Table Creation Syntax
The following was produced by the latest version of EngInSite from a database in existence on the server (4.51) where I want to replicate my database. I'm getting a syntax error message. Can anyone here see a problem with this?
Thanks exceedingly much.
CREATE TABLE `calendar` (
`CalendarID` int(6) unsigned NOT NULL auto_increment,
`DisplayDate` date NOT NULL default '0000-00-00',
`DropDate` date NOT NULL default '0000-00-00',
`EventTitle` text NOT NULL,
`EventDate` date NOT NULL default '0000-00-00',
`EventDescription` text NOT NULL,
`Headliner` tinyint(1) unsigned zerofill NOT NULL default '0',
PRIMARY KEY (`CalendarID`),
KEY `ndxDisplayDate` (`DisplayDate`),
KEY `ndxDropDate` (`DropDate`),
FULLTEXT KEY `ndxEventTitle` (`EventTitle`)
) TYPE=MyISAM;
Subject
Written By
Posted
Table Creation Syntax
July 05, 2006 12:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.