In addition to Ben's answer... > Hi All, > > I have been repeatedly trying to create the following table - without > __ANY__ success. Looks like there is REALLY something wrong with the > MySQL engine or something! Here is the script:
Posting the error itself would help. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com > CREATE TABLE Order ( > DID int not null, > DeskNo int not null, > OrderDate datetime not null, /* KOT Date */ > OrderNo int not null, /* KOT No */ > CRMID int not null, /* Customer Relationship Management ID B2PID */ > CustomerID int not null, /* PersonID of Customer, Member, etc. */ > TableNo int not null, > WaiterID int not null, /* PersonID of Waiter */ > OrderClerkID int not null, /* PersonID of Order-Clerk */ > Status int not null, /* Order Status - Open;1;In-Process;2; > Cooked/Ready;3;Delivered;4; > Cancelled;-1, -2, -3, .. */ > CONSTRAINT Order_UQ UNIQUE INDEX (DID, DeskNo, OrderDate, OrderNo), > INDEX CRMID_NDX (CRMID), > FOREIGN KEY CRM_FK_NDX (CRMID) REFERENCES RelationB2P (ID), > INDEX CustomerID_NDX (CustomerID), > FOREIGN KEY Customer_FK_NDX (PersonID) REFERENCES Person (PersonID), > INDEX DID_NDX (DID), > FOREIGN KEY Department_FK_NDX (DID) REFERENCES EntityBranchDept > (DepartmentID), > IDNEX WaiterID_NDX (WaiterID), > FOREIGN KEY WaiterID_FK_NDX (WaiterID) REFERENCES Person (PersonID), > INDEX OrderClerkID (OrderClerkID), > FOREIGN KEY OrderClerk_FK_NDX (OrderClerkID) REFERENCES Person (PersonID) > ) ENGINE=InnoDB; > > > > > > You guys can delete all the index/references and other clauses! Even > then this table doesn't get created! > > I'd appreciate your help. > > -- > Asif > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
