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
|
CREATE TABLE `heurglis_lfpg` (
`HG_DATE` date NOT NULL,
`HG_HOURS_UTC` char(11) COLLATE utf8_unicode_ci NOT NULL,
`ARR_09L` smallint(5) NOT NULL,
`ARR_27R` smallint(5) NOT NULL,
`ARR_09R` smallint(5) NOT NULL,
`ARR_27L` smallint(5) NOT NULL,
`ARR_08L` smallint(5) NOT NULL,
`ARR_26R` smallint(5) NOT NULL,
`ARR_08R` smallint(5) NOT NULL,
`ARR_26L` smallint(5) NOT NULL,
`TOT_ARR` smallint(5) NOT NULL,
`DEP_09L` smallint(5) NOT NULL,
`DEP_27R` smallint(5) NOT NULL,
`DEP_09R` smallint(5) NOT NULL,
`DEP_27L` smallint(5) NOT NULL,
`DEP_08L` smallint(5) NOT NULL,
`DEP_26R` smallint(5) NOT NULL,
`DEP_08R` smallint(5) NOT NULL,
`DEP_26L` smallint(5) NOT NULL,
`TOT_DEP` smallint(5) NOT NULL,
`TOT_GEN` smallint(5) NOT NULL,
`TOT_ARR_DN` smallint(5) NOT NULL,
`TOT_DEP_DN` smallint(5) NOT NULL,
`TOT_DN` smallint(5) NOT NULL,
`TOT_ARR_DS` smallint(5) NOT NULL,
`TOT_DEP_DS` smallint(5) NOT NULL,
`TOT_DS` smallint(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Fichier(s) source(s) : AAAA_MM_JJ_plateforme_lfpg_gliss_1h.csv';
ALTER TABLE `heurglis_lfpg`
ADD KEY `HG_DATE` (`HG_DATE`),
ADD KEY `HG_HOURS_UTC` (`HG_HOURS_UTC`); |
Partager