DROP TABLE IF EXISTS sacoche_referentiel_theme;

CREATE TABLE sacoche_referentiel_theme (
  theme_id    SMALLINT     UNSIGNED                NOT NULL AUTO_INCREMENT,
  domaine_id  SMALLINT     UNSIGNED                NOT NULL DEFAULT 0,
  theme_ordre TINYINT      UNSIGNED                NOT NULL DEFAULT 1 COMMENT "Commence à 1.",
  theme_ref   VARCHAR(3)   COLLATE utf8_unicode_ci NOT NULL DEFAULT "",
  theme_nom   VARCHAR(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT "",
  PRIMARY KEY (theme_id),
  KEY domaine_id (domaine_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
