CREATE TABLE Failure

[Asif Lodhi]

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:

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