iXTn61ZJ

1CREATE TABLE IF NOT EXISTS `cotisations` (
2  `Id` int(11) NOT NULL,
3  `Id_ancien` int(11) NOT NULL,
4  `mode_paie` set('CHQ','VIR','ESP','PREL','CB') NOT NULL,
5  `budget` year(4) NOT NULL,
6  `date_paie` date NOT NULL,
7  `montant` float DEFAULT NULL,
8  `nbr_relance` int(11) NOT NULL,
9  `date_relance` date NOT NULL,
10  `annuaire` varchar(255) DEFAULT NULL,
11  `Id_auteur` int(11) NOT NULL,
12  `date_creation` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
13  PRIMARY KEY (`Id`),
14  UNIQUE KEY `Id` (`Id`)
15) ENGINE=MyISAM DEFAULT CHARSET=latin1;