Posted by Frankly on 06/20/06 07:02

its just about 3am here. I was having a hard time sleeping so i figured i
would give this another shot.

CREATE DATABASE `myweb325573_grace`;

DROP TABLE IF EXISTS `myweb325573_grace`.`RelationManagementsBuildings`;

CREATE TABLE `RelationManagementsBuildings` (

`ManID` int(10) unsigned NOT NULL default '0',

`BuildingID` int(10) unsigned NOT NULL default '0',

PRIMARY KEY (`ManID`,`BuildingID`),

CONSTRAINT `FK_RelationManagementsBuildings_1` FOREIGN KEY (`ManID`)
REFERENCES `Managements` (`ManID`) ON DELETE CASCADE ON UPDATE CASCADE

) TYPE=InnoDB ROW_FORMAT=DYNAMIC;



i think this is wrong because it was created in the ManagementsBuildings
table and used

the primary keys in the other tables as foreign.





o well it the admin crashed because i picked the wrong table ok ok i tried
to create a relation for the relation table to the relation table lol duh..
i realized it as soon as i pressed the button. well my foot fell asleep big
time and its bothering me. time to try sleep once again. 3:01am see you
in 5 hours hope i get at least 4 hours. it dont look good.



Frank

[Back to original message]