1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
CREATE TABLE tbl1 (
id int(11) NOT NULL auto_increment,
libelle varchar(100) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE tbl2 (
id int(11) NOT NULL,
nom varchar(255) NOT NULL default '0',
texte longtext,
adresse longtext,
prix decimal(12,2) default NULL,
`type` varchar(255) default NULL,
PRIMARY KEY (id),
KEY prix (prix),
KEY `type` (`type`),
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE tbl3 (
id int(11) NOT NULL auto_increment,
id_tbl2 int(11) NOT NULL,
reference varchar(20) NOT NULL,
originebien int(11) NOT NULL default '1',
PRIMARY KEY (id),
UNIQUE KEY id_tbl2 (id_tbl2),
KEY originebien (originebien),
CONSTRAINT tbl3_ibfk_4 FOREIGN KEY (id_tbl2) REFERENCES tbl2 (id) ON DELETE CASCADE,
CONSTRAINT tbl3_ibfk_5 FOREIGN KEY (originebien) REFERENCES tbl1 (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Can't create table './agencesi/tbl3.frm' (errno: 150) |
Partager