1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| DROP TABLE IF EXISTS `t_type_etablissement`;
DROP TABLE IF EXISTS `t_etablissement`;
CREATE TABLE `t_type_etablissement` (
`id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
`type` VARCHAR(100) NOT NULL,
`description` TEXT NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--INSERT ...
--INSERT ...
--INSERT ...
CREATE TABLE `t_etablissement` (
`id` TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
`type_id` TINYINT UNSIGNED NOT NULL,
`nom` VARCHAR(100),
`ville` VARCHAR(30) NOT NULL,
PRIMARY KEY (`id`),
FOREIGN KEY (`type_id`) REFERENCES `t_type_etablissement` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--INSERT ...
--INSERT ...
--INSERT ... |
Partager