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
| CREATE TABLE `ville` (
`id_ville` smallint(5) unsigned NOT NULL auto_increment,
`cp` smallint(5) NOT NULL,
`nom` varchar(255) NOT NULL,
PRIMARY KEY (`id_ville`),
UNIQUE KEY (`nom`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `groupe` (
`id_groupe` smallint(5) unsigned NOT NULL auto_increment,
`nom` varchar(100) NOT NULL,
`adresse` varchar(255) NOT NULL,
`id_ville` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id_groupe`),
UNIQUE KEY (`nom`),
FOREIGN KEY (`id_ville`) REFERENCES `ville` (`id_ville`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `personne` (
`id_personne` mediumint(8) unsigned NOT NULL auto_increment,
`nom` varchar(255) NOT NULL,
`prenom` varchar(255) NOT NULL,
`id_groupe` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id_personne`),
KEY (`nom`),
FOREIGN KEY (`id_groupe`) REFERENCES `groupe` (`id_groupe`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Partager