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 28 29 30 31 32 33 34 35 36 37 38
| CREATE TABLE IF NOT EXISTS `dat_addresses` (
`id_user` int(10) UNSIGNED NOT NULL,
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`prenom` varchar(50) NOT NULL,
`nom` varchar(50) NOT NULL,
`adresse` varchar(80) NOT NULL,
`pays` varchar(2) NOT NULL,
`cp` varchar(10) NOT NULL,
`ville` varchar(50) NOT NULL,
`courriel` varchar(60) DEFAULT NULL,
`tel_domicile` varchar(20) DEFAULT NULL,
`tel_travail` varchar(25) DEFAULT NULL,
`tel_portable` varchar(20) DEFAULT NULL,
`naissance` date DEFAULT NULL,
`notes` varchar(500) DEFAULT NULL,
`selection` tinyint(1) NOT NULL DEFAULT '0',
`update_date` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
`create_date` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `courriel` (`courriel`),
UNIQUE KEY `tel_domicile` (`tel_domicile`),
UNIQUE KEY `tel_portable` (`tel_portable`),
KEY `id_user` (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `dat_families` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_address` int(10) UNSIGNED NOT NULL,
`prenom` varchar(50) NOT NULL,
`nom` varchar(50) NOT NULL,
`courriel` varchar(60) DEFAULT NULL,
`tel_travail` varchar(20) DEFAULT NULL,
`tel_portable` varchar(20) DEFAULT NULL,
`naissance` date DEFAULT NULL,
`relation` int(10) UNSIGNED NOT NULL COMMENT '1-conjoint, 2-enfant, 3-enfant_du_cjt',
PRIMARY KEY (`id`),
KEY `id_address` (`id_address`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8; |
Partager