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
|
CREATE TABLE `appartenir` (
`id_util` varchar(20) NOT NULL default '',
`id_groupe` int(3) unsigned NOT NULL auto_increment,
KEY (`id_util`),
KEY (`id_groupe`),
FOREIGN KEY (`id_util`) REFERENCES `util`(`id_util`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`id_groupe`) REFERENCES `groupe`(`id_groupe`) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB, ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `groupe` (
`id_groupe` int(3) unsigned NOT NULL auto_increment,
`designation_groupe` varchar(20) NOT NULL default '',
`description_groupe` varchar(50) default NULL,
PRIMARY KEY (`id_groupe`)
) TYPE=InnoDB, ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `util` (
`id_util` varchar(20) NOT NULL default '',
`titre_util` char(1) NOT NULL default 'M',
`nom_util` varchar(20) NOT NULL default '',
`prenom_util` varchar(20) NOT NULL default '',
`mdp_util` varchar(20) NOT NULL default '',
PRIMARY KEY (`id_util`)
) TYPE=InnoDB, ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager