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
| CREATE TABLE `regfideles` (
`id` int(5) NOT NULL auto_increment,
`fidele` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`sexe` varchar(1) character set latin1 collate latin1_general_ci NOT NULL,
`lieubapt` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`jourbapt` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`moisbapt` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`anneebapt` varchar(4) character set latin1 collate latin1_general_ci NOT NULL,
`pretrebapt` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`parrain` varchar(30) character set latin1 collate latin1_general_ci NOT NULL default 'Aucun',
`marraine` varchar(30) character set latin1 collate latin1_general_ci NOT NULL default 'Aucune',
`lieumari` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`jourmari` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`moismari` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`anneemari` varchar(4) character set latin1 collate latin1_general_ci NOT NULL,
`pretremari` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`temoin` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`conjoint` varchar(30) character set latin1 collate latin1_danish_ci NOT NULL,
`exco` varchar(3) character set latin1 collate latin1_general_ci NOT NULL default 'non',
`jourexco` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`moisexco` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`anneeexco` varchar(4) character set latin1 collate latin1_general_ci NOT NULL,
`pretreexco` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`funerailles` varchar(3) character set latin1 collate latin1_general_ci NOT NULL default 'non',
`lieufuner` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
`jourfuner` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`moisfuner` varchar(2) character set latin1 collate latin1_general_ci NOT NULL,
`anneefuner` varchar(4) character set latin1 collate latin1_general_ci NOT NULL,
`pretrefuner` varchar(30) character set latin1 collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) |
Partager