CREATE TABLE population (
       CODGEO CHAR(5),
       P09_POP MEDIUMINT,
       P99_POP MEDIUMINT,
       D90_POP MEDIUMINT,
       D82_POP MEDIUMINT,
       D75_POP MEDIUMINT,
       D68_POP MEDIUMINT,
       SUPERF REAL,
       NAIS9909 MEDIUMINT,
       NAIS9099 MEDIUMINT,
       NAIS8290 MEDIUMINT,
       NAIS7582 MEDIUMINT,
       NAIS6875 MEDIUMINT,
       DECE9909 MEDIUMINT,
       DECE9099 MEDIUMINT,
       DECE8290 MEDIUMINT,
       DECE7582 MEDIUMINT,
       DECE6875 MEDIUMINT,
       NAIS10 SMALLINT,
       NAIS09 SMALLINT,
       NAIS08 SMALLINT,
       NAIS07 SMALLINT,
       NAIS06 SMALLINT,
       NAIS05 SMALLINT,
       NAIS04 SMALLINT,
       NAIS03 SMALLINT,
       NAIS02 SMALLINT,
       NAIS01 SMALLINT,
       NAIS00 SMALLINT,
       NAIS99 SMALLINT,
       DECE10 SMALLINT,
       DECE09 SMALLINT,
       DECE08 SMALLINT,
       DECE07 SMALLINT,
       DECE06 SMALLINT,
       DECE05 SMALLINT,
       DECE04 SMALLINT,
       DECE03 SMALLINT,
       DECE02 SMALLINT,
       DECE01 SMALLINT,
       DECE00 SMALLINT,
       DECE99 SMALLINT,
       P09_POP0014 MEDIUMINT,
       P09_POP1529 MEDIUMINT,
       P09_POP3044 MEDIUMINT,
       P09_POP4559 MEDIUMINT,
       P09_POP6074 MEDIUMINT,
       P09_POP75P MEDIUMINT,
       P99_POP0014 MEDIUMINT,
       P99_POP1529 MEDIUMINT,
       P99_POP3044 MEDIUMINT,
       P99_POP4559 MEDIUMINT,
       P99_POP6074 MEDIUMINT,
       P99_POP75P MEDIUMINT,
       P09_POPH MEDIUMINT,
       P09_H0014 MEDIUMINT,
       P09_H1529 MEDIUMINT,
       P09_H3044 MEDIUMINT,
       P09_H4559 MEDIUMINT,
       P09_H6074 MEDIUMINT,
       P09_H7589 SMALLINT,
       P09_H90P SMALLINT,
       P09_H0019 MEDIUMINT,
       P09_H2064 MEDIUMINT,
       P09_H65P MEDIUMINT,
       P09_POPF MEDIUMINT,
       P09_F0014 MEDIUMINT,
       P09_F1529 MEDIUMINT,
       P09_F3044 MEDIUMINT,
       P09_F4559 MEDIUMINT,
       P09_F6074 MEDIUMINT,
       P09_F7589 MEDIUMINT,
       P09_F90P SMALLINT,
       P09_F0019 MEDIUMINT,
       P09_F2064 MEDIUMINT,
       P09_F65P MEDIUMINT,
       C09_POP15P MEDIUMINT,
       C09_POP15P_CS1 SMALLINT,
       C09_POP15P_CS2 SMALLINT,
       C09_POP15P_CS3 MEDIUMINT,
       C09_POP15P_CS4 MEDIUMINT,
       C09_POP15P_CS5 MEDIUMINT,
       C09_POP15P_CS6 MEDIUMINT,
       C09_POP15P_CS7 MEDIUMINT,
       C09_POP15P_CS8 MEDIUMINT,
       C99_POP15P MEDIUMINT,
       C99_POP15P_CS1 SMALLINT,
       C99_POP15P_CS2 MEDIUMINT,
       C99_POP15P_CS3 MEDIUMINT,
       C99_POP15P_CS4 MEDIUMINT,
       C99_POP15P_CS5 MEDIUMINT,
       C99_POP15P_CS6 MEDIUMINT,
       C99_POP15P_CS7 MEDIUMINT,
       C99_POP15P_CS8 MEDIUMINT,
       C09_H15P MEDIUMINT,
       C09_H15P_CS1 SMALLINT,
       C09_H15P_CS2 SMALLINT,
       C09_H15P_CS3 MEDIUMINT,
       C09_H15P_CS4 MEDIUMINT,
       C09_H15P_CS5 MEDIUMINT,
       C09_H15P_CS6 MEDIUMINT,
       C09_H15P_CS7 MEDIUMINT,
       C09_H15P_CS8 MEDIUMINT,
       C09_F15P MEDIUMINT,
       C09_F15P_CS1 SMALLINT,
       C09_F15P_CS2 SMALLINT,
       C09_F15P_CS3 MEDIUMINT,
       C09_F15P_CS4 MEDIUMINT,
       C09_F15P_CS5 MEDIUMINT,
       C09_F15P_CS6 SMALLINT,
       C09_F15P_CS7 MEDIUMINT,
       C09_F15P_CS8 MEDIUMINT,
       C09_POP1524 MEDIUMINT,
       C09_POP1524_CS1 TINYINT,
       C09_POP1524_CS2 SMALLINT,
       C09_POP1524_CS3 SMALLINT,
       C09_POP1524_CS4 SMALLINT,
       C09_POP1524_CS5 SMALLINT,
       C09_POP1524_CS6 SMALLINT,
       C09_POP1524_CS7 TINYINT,
       C09_POP1524_CS8 MEDIUMINT,
       C09_POP2554 MEDIUMINT,
       C09_POP2554_CS1 SMALLINT,
       C09_POP2554_CS2 SMALLINT,
       C09_POP2554_CS3 MEDIUMINT,
       C09_POP2554_CS4 MEDIUMINT,
       C09_POP2554_CS5 MEDIUMINT,
       C09_POP2554_CS6 MEDIUMINT,
       C09_POP2554_CS7 SMALLINT,
       C09_POP2554_CS8 MEDIUMINT,
       C09_POP55P MEDIUMINT,
       C09_POP55P_CS1 SMALLINT,
       C09_POP55P_CS2 SMALLINT,
       C09_POP55P_CS3 MEDIUMINT,
       C09_POP55P_CS4 SMALLINT,
       C09_POP55P_CS5 SMALLINT,
       C09_POP55P_CS6 SMALLINT,
       C09_POP55P_CS7 MEDIUMINT,
       C09_POP55P_CS8 SMALLINT,
       CONSTRAINT cle_popu PRIMARY KEY (CODGEO)
)ENGINE InnoDB;
       
-- CONSTRAINT ref_popcom FOREIGN KEY (CODGEO) REFERENCES communes(ComId)
-- pb avec la clé externe 2012-07-12T11:06:09+0200