14 lines
437 B
SQL
Executable File
14 lines
437 B
SQL
Executable File
--
|
|
-- Structure de la table `rapports_giants`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `rapports_giants` (
|
|
`id` int(8) NOT NULL AUTO_INCREMENT,
|
|
`companyId` varchar(255) NOT NULL,
|
|
`date` date NOT NULL,
|
|
`pays` enum('FR','ES','BE','NL','UK','DE') NOT NULL,
|
|
`type` enum('FU','CO','CR','FL') DEFAULT NULL,
|
|
`lang` varchar(2) CHARACTER SET utf8 NOT NULL,
|
|
`report` longtext NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=utf8; |