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/mysql?unsub=1
>
>
>
