Форум пользователей MySQL

DROP TABLE IF EXISTS `code_check_price`;

CREATE TABLE `code_check_price` (
  `id` int(11) NOT NULL auto_increment,
  `CashFrom` double NOT NULL default '0',
  `CashTo` double NOT NULL default '1000000',
  `QuantityOfChecksFrom` double NOT NULL default '1',
  `QuantityOfChecksTo` double NOT NULL default '1000',
  `LiveTimeSeconds` int(11) NOT NULL default '0',
  `TimeBegin` time NOT NULL default '00:00:00',
  `TimeEnd` time NOT NULL default '23:59:59',
  `DayOfWeek` tinyint(4) default NULL,
  `DateCategoriesID` int(11) default NULL,
  `ClientCategoryID` int(11) NOT NULL default '2',
  `PriceName` varchar(128) NOT NULL default '',
  `Inet1InMbCost` double NOT NULL default '0',
  `Inet1OutMbCost` double NOT NULL default '0',
  `Cat1MbCost` double NOT NULL default '0',
  `Cat2MbCost` double NOT NULL default '0',
  `Cat3MbCost` double NOT NULL default '0',
  `Cat4MbCost` double NOT NULL default '0',
  `Cat5MbCost` double NOT NULL default '0',
  `Cat6MbCost` double NOT NULL default '0',
  `Section` int(11) NOT NULL default '1',
  `SectionComments` varchar(15) NOT NULL default 'Отдел1',
  `Article` varchar(9) NOT NULL default '1',
  `ArticleName` varchar(24) NOT NULL default 'Код доступа',
  `LastChangesTime` timestamp(14) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `CashFrom` (`CashFrom`),
  KEY `CashTo` (`CashTo`),
  KEY `TimeBegin` (`TimeBegin`),
  KEY `TimeEnd` (`TimeEnd`),
  KEY `DayOfWeek` (`DayOfWeek`),
  KEY `DateCategoriesID` (`DateCategoriesID`),
  KEY `ClientCategoryID` (`ClientCategoryID`)
) TYPE=InnoDB COMMENT='Получение срока жизни кода от параметров';

/*Data for the table `code_check_price` */

insert  into `code_check_price`(`id`,`CashFrom`,`CashTo`,`QuantityOfChecksFrom`,`QuantityOfChecksTo`,`LiveTimeSeconds`,`TimeBegin`,`TimeEnd`,`DayOfWeek`,`DateCategoriesID`,`ClientCategoryID`,`PriceName`,`Inet1InMbCost`,`Inet1OutMbCost`,`Cat1MbCost`,`Cat2MbCost`,`Cat3MbCost`,`Cat4MbCost`,`Cat5MbCost`,`Cat6MbCost`,`Section`,`SectionComments`,`Article`,`ArticleName`,`LastChangesTime`) values (1,0,100000,1,1000,172800,'00:00:00','23:59:59',NULL,NULL,2,'',0,0,0,0,0,0,0,0,1,'Отдел1','1','Код доступа',20120620182420);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;


Error occured at:2012-08-23 13:40:15
Line no.:56
Error Code: 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 '(14) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `CashFrom` (`CashFrom`),
  KEY `Cash' at line 26