1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| CREATE TABLE IF NOT EXISTS `societes` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`libel` varchar(64) COLLATE utf8_bin DEFAULT NULL ,
`id_adresse` int(11) DEFAULT NULL ,
`siret` varchar(45) COLLATE utf8_bin DEFAULT NULL ,
`activite` varchar(100) COLLATE utf8_bin DEFAULT NULL ,
`rcs` varchar(100) COLLATE utf8_bin DEFAULT NULL ,
`immatriculation` date DEFAULT NULL ,
`id_nationalite` varchar(3) COLLATE utf8_bin DEFAULT NULL
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=81 ;
CREATE TABLE IF NOT EXISTS `adresses` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`bat` varchar(45) COLLATE utf8_bin DEFAULT NULL ,
`rue` varchar(255) COLLATE utf8_bin DEFAULT NULL ,
`complement` varchar(50) COLLATE utf8_bin DEFAULT NULL ,
`codePostal` varchar(10) COLLATE utf8_bin DEFAULT NULL ,
`Ville` varchar(45) COLLATE utf8_bin DEFAULT NULL ,
`date_modif` datetime DEFAULT NULL
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=16820 ; |
Partager