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 33 34 35 36 37 38 39 40 41 42 43 44
|
CREATE TABLE IF NOT EXISTS clie (
cli_id int(11) NOT NULL AUTO_INCREMENT,
cli_nom varchar(100) DEFAULT NULL,
cli_pre varchar(100) DEFAULT NULL,
cli_soc varchar(100) DEFAULT NULL,
cli_dat date NOT NULL,
cli_adr varchar(255) DEFAULT NULL,
cli_mai varchar(255) DEFAULT NULL,
map_id int(11) NOT NULL,
PRIMARY KEY (cli_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS poss (
cli_id int(11) NOT NULL,
ord_id int(11) NOT NULL,
PRIMARY KEY (cli_id, ord_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;
CREATE TABLE IF NOT EXISTS ordi (
ord_id int(11) NOT NULL AUTO_INCREMENT,
ord_os varchar(50) DEFAULT NULL,
ord_pro varchar(100) DEFAULT NULL,
ord_car varchar(100) DEFAULT NULL,
ord_mem varchar(100) DEFAULT NULL,
ord_bio varchar(100) DEFAULT NULL,
ord_mar varchar(100) DEFAULT NULL,
ord_por int(1) DEFAULT NULL,
PRIMARY KEY (ord_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
#marche
ALTER TABLE poss
ADD CONSTRAINT FK_poss_vers_ordi FOREIGN KEY (ord_id) REFERENCES ordi (ord_id);
#marche pas
ALTER TABLE poss
ADD CONSTRAINT FK_poss_vers_clie FOREIGN KEY (cli_id) REFERENCES clie (cli_id);
#1005 - Can't create table 'test3.#sql-1678_38' (errno: 121) |
Partager