1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| CREATE TABLE `T1` (
`E_NOM` varchar(50) NOT NULL,
`E_VALEUR` varchar(50) NOT NULL,
PRIMARY KEY (`E_NOM`,`E_VALEUR`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `T2` (
`E_ID` int(11) NOT NULL default '0',
`E_NOM` varchar(50) default NULL,
PRIMARY KEY (`EQ_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `T3` (
`S_ID` int(11) NOT NULL default '0',
`E_ID` int(11) NOT NULL,
PRIMARY KEY (`SU_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
CREATE TABLE `T4` (
`S_ID` int(11) NOT NULL default '0',
`D_VALEUR` varchar(100) NOT NULL
PRIMARY KEY (`SU_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
Partager