iVbMsrvd

1SQL query:
2
3CREATE TABLE IF NOT EXISTS  `adminnotification_inbox` (
4
5 `notification_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT  'Notification id',
6 `severity` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT  '0' COMMENT  'Problem type',
7 `date_added` TIMESTAMP NOT NULL COMMENT  'Create date',
8 `title` VARCHAR( 255 ) NOT NULL COMMENT  'Title',
9 `description` TEXT COMMENT  'Description',
10 `url` VARCHAR( 255 ) DEFAULT NULL COMMENT  'Url',
11 `is_read` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT  '0' COMMENT  'Flag if notification read',
12 `is_remove` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT  '0' COMMENT  'Flag if notification might be removed',
13PRIMARY KEY (  `notification_id` ) ,
14KEY  `IDX_ADMINNOTIFICATION_INBOX_SEVERITY` (  `severity` ) ,
15KEY  `IDX_ADMINNOTIFICATION_INBOX_IS_READ` (  `is_read` ) ,
16KEY  `IDX_ADMINNOTIFICATION_INBOX_IS_REMOVE` (  `is_remove` )
17) TYPE = INNODB COMMENT =  'Adminnotification Inbox' AUTO_INCREMENT =86;
18
19MySQL said: 
20
21#1064 - 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  COMMENT='Adminnotification Inbox' AUTO_INCREMENT=86' at line 14