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
|
CREATE TABLE `Tuser` (
`iduser` int(11) NOT NULL auto_increment,
`Nom` varchar(150) NOT NULL,
`MotPass` varchar(150) NOT NULL,
PRIMARY KEY (`iduser`)
);
CREATE TABLE `Tsites` (
`idsite` int(11) NOT NULL auto_increment,
`Nomsite` varchar(150) NOT NULL,
`Adresssite` text NOT NULL,
PRIMARY KEY (`idsite`)
);
CREATE TABLE `TInfos` (
`idinfo` int(11) NOT NULL auto_increment,
`Mat` varchar(150) NOT NULL,
`Nomet` varchar(150) NOT NULL,
`Prenomset` varchar(150) NOT NULL,
`Filiereet` varchar(150) NOT NULL,
`Anneet` varchar(150) NOT NULL,
`siteet` varchar(150) NOT NULL,
`idsite` int(11) NOT NULL,
PRIMARY KEY (`idinfo`)
); |
Partager