MySQL Forums
Forum List  »  Newbie

Table Creation Syntax
Posted by: Christopher Weaver
Date: July 05, 2006 12:12PM

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;

Options: ReplyQuote


Subject
Written By
Posted
Table Creation Syntax
July 05, 2006 12:12PM
July 05, 2006 12:29PM
July 05, 2006 01:23PM
July 05, 2006 02:21PM
July 05, 2006 03:01PM


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.