List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:June 27 2006 12:51pm
Subject:Re: CREATE TABLE Failure
View as plain text  
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
>
>
>

Thread
CREATE TABLE FailureAsif Lodhi27 Jun
  • Re: CREATE TABLE FailureDan Buettner27 Jun
  • Re: CREATE TABLE FailureMartijn Tonies27 Jun