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; |
