16 lines
526 B
SQL
Executable File
16 lines
526 B
SQL
Executable File
CREATE TABLE IF NOT EXISTS `sfr_data` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`NumSeq` varchar(10) NOT NULL,
|
|
`siren` varchar(9) NOT NULL,
|
|
`NbLignes` int(11) NOT NULL,
|
|
`NbContrats` int(11) NOT NULL,
|
|
`DateContrat` varchar(8) NOT NULL,
|
|
`IR` float NOT NULL,
|
|
`IdVOR` varchar(10) NOT NULL,
|
|
`comment` text NOT NULL,
|
|
`PO` float NOT NULL,
|
|
`debug` text NOT NULL,
|
|
`error` int(11) NOT NULL,
|
|
`dateInsert` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; |