[Building Sakai] MySql configuration is throwing Erros

[Pushyami Gundala]

Hi, I am trying to configure Mysql in my Local development, When try to
start the tomcat i am running into some errors . I am able to connect to
the database and some table are created not all. I see that the problems
with creating the table for the "Grade Book" and "Assigments" modules. I
have the full error list in the attachments. I tried to Drop the database
and create it again, still saw the same issue.

  2013-10-22 15:54:56,300  WARN localhost-startStop-1
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
Unsuccessful schema statement: create table ASN_AP_ITEM_ACCESS_T (ID bigint
not null auto_increment, ITEM_ACCESS varchar(255), ASN_AP_ITEM_ID bigint
not null, primary key (ID), unique (ITEM_ACCESS, ASN_AP_ITEM_ID))
type=InnoDB  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'type=InnoDB' at line
1        2013-10-22 15:54:56,302  WARN localhost-startStop-1
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
Unsuccessful schema statement: create table ASN_AP_ITEM_T (ID bigint not
null, ASSIGNMENT_ID varchar(255), TITLE varchar(255), TEXT longtext,
RELEASE_DATE datetime, RETRACT_DATE datetime, HIDE bit, primary key (ID))
type=InnoDB  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You
have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'type=InnoDB' at line
1        2013-10-22 15:54:56,303  WARN localhost-startStop-1
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
Unsuccessful schema statement: create table ASN_MA_ITEM_T (ID bigint not
null, ASSIGNMENT_ID varchar(255), TEXT longtext, SHOW_TO integer, primary
key (ID)) type=InnoDB
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'type=InnoDB' at
line 1        2013-10-22 15:54:56,304  WARN localhost-startStop-1
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
Unsuccessful schema statement: create table ASN_NOTE_ITEM_T (ID bigint not
null auto_increment, ASSIGNMENT_ID varchar(255), NOTE longtext, CREATOR_ID
varchar(255), SHARE_WITH integer, primary key (ID)) type=InnoDB












 Sakai version : Trunk
MySql Version :5.6
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131022/65c3999a/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.xls
Type: application/vnd.ms-excel
Size: 324270 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20131022/65c3999a/attachment.xls