|
|
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
Navigation:
[Reply to this message]
|