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
| CREATE TABLE `donnees` (
`id` int(11) NOT NULL auto_increment,
`idu` int(11) NOT NULL default '0',
`motcle` text NOT NULL,
`codeentreprise` varchar(150) NOT NULL default '',
`mois` varchar(150) NOT NULL default '',
`prixAchat` varchar(150) NOT NULL default '',
`datepaiement` text NOT NULL,
`codeplanteur` varchar(150) NOT NULL default '',
`nbrelevement` varchar(150) NOT NULL default '',
`modepaiement` varchar(150) NOT NULL default '',
`netpayer` varchar(150) NOT NULL default '',
`bank` varchar(50) NOT NULL default '',
`poidstotaleleve` varchar(150) NOT NULL default '',
`tsModif` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `idu` (`idu`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=108 ;
CREATE TABLE `actuel` (
`id` int(11) NOT NULL auto_increment,
`idu` int(11) NOT NULL default '0',
`motcle` text NOT NULL,
`codeentreprise` varchar(150) NOT NULL default '',
`mois` varchar(150) NOT NULL default '',
`prixAchat` varchar(150) NOT NULL default '',
`datepaiement` text NOT NULL,
`codeplanteur` varchar(150) NOT NULL default '',
`nbrelevement` varchar(150) NOT NULL default '',
`modepaiement` varchar(150) NOT NULL default '',
`netpayer` varchar(150) NOT NULL default '',
` bank` varchar(50) NOT NULL default '',
`poidstotaleleve` varchar(150) NOT NULL default '',
`tsModif` timestamp NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `idu` (`idu`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ; |
Partager