/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `arcadia_link`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arcadia_link` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `media_id` bigint(20) NOT NULL DEFAULT 0,
  `arcadia_id` bigint(20) DEFAULT 0,
  `filename` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `noArt` bigint(20) unsigned DEFAULT NULL,
  `libCcial` varchar(300) COLLATE utf8mb4_bin DEFAULT '',
  `codMarq` bigint(20) unsigned DEFAULT NULL,
  `libMarq` varchar(300) COLLATE utf8mb4_bin DEFAULT '',
  `codFamVte` bigint(20) unsigned DEFAULT NULL,
  `libFamVte` varchar(300) COLLATE utf8mb4_bin DEFAULT '',
  `codGencodAdm` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
  `codGencodSymb` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
  `codGencodPds` varchar(50) COLLATE utf8mb4_bin DEFAULT '',
  `utilisableGroupe` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `noArt` (`noArt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `copyrights`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `copyrights` (
  `copyright_id` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT '',
  PRIMARY KEY (`copyright_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `dossiers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dossiers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `description` text COLLATE utf8mb4_bin DEFAULT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `sujet_id` bigint(20) unsigned DEFAULT NULL,
  `system` int(11) unsigned NOT NULL DEFAULT 0,
  `is_private` int(11) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`),
  KEY `FK_dossiers_sujets` (`sujet_id`),
  CONSTRAINT `FK_dossiers_sujets` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `dossiers_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dossiers_users` (
  `dossier_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`dossier_id`,`user_id`),
  KEY `FK_dossiers_users_users` (`user_id`),
  KEY `FK_dossiers_users_dossiers` (`dossier_id`),
  CONSTRAINT `FK_dossiers_users_dossiers` FOREIGN KEY (`dossier_id`) REFERENCES `dossiers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_dossiers_users_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `etiquettes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `etiquettes` (
  `etiquette_id` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT '',
  `color` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '#000000',
  PRIMARY KEY (`etiquette_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `format_restrictions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `format_restrictions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sujet_id` bigint(20) unsigned DEFAULT NULL,
  `typevues_id` bigint(20) unsigned DEFAULT NULL,
  `typemedias_id` bigint(20) unsigned DEFAULT NULL,
  `in_mimes` int(11) DEFAULT NULL,
  `in_width` int(11) DEFAULT NULL,
  `in_height` int(11) DEFAULT NULL,
  `out_mimes` int(11) DEFAULT NULL,
  `out_width` int(11) DEFAULT NULL,
  `out_height` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `format_restrictions_sujet_id_foreign` (`sujet_id`),
  KEY `format_restrictions_typevues_id_foreign` (`typevues_id`),
  KEY `format_restrictions_typemedias_id_foreign` (`typemedias_id`),
  CONSTRAINT `format_restrictions_sujet_id_foreign` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`),
  CONSTRAINT `format_restrictions_typemedias_id_foreign` FOREIGN KEY (`typemedias_id`) REFERENCES `typemedias` (`codeTypemedia`),
  CONSTRAINT `format_restrictions_typevues_id_foreign` FOREIGN KEY (`typevues_id`) REFERENCES `typevues` (`codeTypevue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `formats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `formats` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(191) COLLATE utf8mb4_bin NOT NULL,
  `extension` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `largeur` int(11) unsigned NOT NULL DEFAULT 0 COMMENT 'Largeur max de l''image générée',
  `hauteur` int(11) unsigned NOT NULL DEFAULT 0 COMMENT 'Hauteur max de l''image générée. 0 = pas de contrainte de hauteur',
  `system` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `libelle` (`libelle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `historiques`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historiques` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `media_id` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(250) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `description` varchar(250) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `created_date` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `FK_historiques_users` (`user_id`),
  KEY `FK_historiques_medias` (`media_id`),
  CONSTRAINT `FK_historiques_medias` FOREIGN KEY (`media_id`) REFERENCES `medias` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_historiques_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `langues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `langues` (
  `langue_id` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT '',
  PRIMARY KEY (`langue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `marques`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marques` (
  `codMarq` bigint(20) unsigned NOT NULL,
  `libMarq` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`codMarq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `marques_dossiers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marques_dossiers` (
  `marque_id` bigint(20) unsigned NOT NULL,
  `dossier_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`marque_id`,`dossier_id`),
  KEY `FK_marques_dossiers_dossiers` (`dossier_id`),
  CONSTRAINT `FK_marques_dossiers_dossiers` FOREIGN KEY (`dossier_id`) REFERENCES `dossiers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_marques_dossiers_marques` FOREIGN KEY (`marque_id`) REFERENCES `marques` (`codMarq`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `marques_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marques_users` (
  `marque_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`marque_id`,`user_id`),
  KEY `FK_marques_users_users` (`user_id`),
  CONSTRAINT `FK_marques_users_marques` FOREIGN KEY (`marque_id`) REFERENCES `marques` (`codMarq`) ON DELETE CASCADE,
  CONSTRAINT `FK_marques_users_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `medias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `arcadia_id` bigint(20) unsigned DEFAULT NULL,
  `libelle` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `folder` varchar(750) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `uid` varchar(750) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `extension` varchar(750) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `taille` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  `largeur` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `largeur_mm` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `hauteur` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `hauteur_mm` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `resolution` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `duree` varchar(100) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `version` bigint(20) unsigned NOT NULL DEFAULT 1,
  `typemedia_id` bigint(20) unsigned DEFAULT NULL,
  `typevue_id` bigint(20) unsigned DEFAULT NULL,
  `commentaire` text COLLATE utf8mb4_bin DEFAULT NULL,
  `dossier_id` bigint(20) unsigned DEFAULT NULL,
  `sujet_id` bigint(20) unsigned DEFAULT NULL,
  `langue_id` bigint(20) unsigned DEFAULT 0,
  `copyright_id` bigint(20) unsigned DEFAULT 0,
  `etiquette_id` bigint(20) unsigned DEFAULT 0,
  `variante_id` bigint(20) unsigned DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `statut` int(10) unsigned DEFAULT 0,
  `isLocked` int(10) unsigned DEFAULT 0,
  `isDefault` int(10) unsigned DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dossier_id` (`dossier_id`),
  KEY `sujet_id` (`sujet_id`),
  KEY `arcadia_id` (`arcadia_id`),
  KEY `typemedia_id` (`typemedia_id`),
  KEY `typevue_id` (`typevue_id`),
  KEY `langue_id` (`langue_id`),
  KEY `copyright_id` (`copyright_id`),
  KEY `etiquette_id` (`etiquette_id`),
  KEY `FK_medias_variantes` (`variante_id`),
  KEY `FK_medias_users` (`created_by`),
  CONSTRAINT `FK_medias_copyrights` FOREIGN KEY (`copyright_id`) REFERENCES `copyrights` (`copyright_id`),
  CONSTRAINT `FK_medias_dossiers` FOREIGN KEY (`dossier_id`) REFERENCES `dossiers` (`id`),
  CONSTRAINT `FK_medias_etiquettes` FOREIGN KEY (`etiquette_id`) REFERENCES `etiquettes` (`etiquette_id`),
  CONSTRAINT `FK_medias_langues` FOREIGN KEY (`langue_id`) REFERENCES `langues` (`langue_id`),
  CONSTRAINT `FK_medias_sujets` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`),
  CONSTRAINT `FK_medias_typemedias` FOREIGN KEY (`typemedia_id`) REFERENCES `typemedias` (`codeTypemedia`),
  CONSTRAINT `FK_medias_typevues` FOREIGN KEY (`typevue_id`) REFERENCES `typevues` (`codeTypevue`),
  CONSTRAINT `FK_medias_users` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_medias_variantes` FOREIGN KEY (`variante_id`) REFERENCES `variantes` (`codeVariante`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `medias_articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medias_articles` (
  `media_id` bigint(20) unsigned NOT NULL,
  `article_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`media_id`,`article_id`),
  KEY `FK_medias_articles_articles` (`article_id`),
  CONSTRAINT `FK_medias_articles_articles` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_medias_articles_medias` FOREIGN KEY (`media_id`) REFERENCES `medias` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `medias_marques`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medias_marques` (
  `media_id` bigint(20) unsigned NOT NULL,
  `marque_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`media_id`,`marque_id`),
  KEY `FK_medias_marques_marques` (`marque_id`),
  CONSTRAINT `FK_medias_marques_marques` FOREIGN KEY (`marque_id`) REFERENCES `marques` (`codMarq`) ON DELETE CASCADE,
  CONSTRAINT `FK_medias_marques_medias` FOREIGN KEY (`media_id`) REFERENCES `medias` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `medias_societes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medias_societes` (
  `media_id` bigint(20) unsigned NOT NULL,
  `societe_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`media_id`,`societe_id`),
  KEY `FK_medias_sites_sites` (`societe_id`),
  CONSTRAINT `FK_medias_sites_medias` FOREIGN KEY (`media_id`) REFERENCES `medias` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_medias_sites_sites` FOREIGN KEY (`societe_id`) REFERENCES `societes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `medias_tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medias_tags` (
  `media_id` bigint(20) unsigned NOT NULL,
  `tag_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`media_id`,`tag_id`),
  KEY `FK_medias_tags_tags` (`tag_id`),
  CONSTRAINT `FK_medias_tags_medias` FOREIGN KEY (`media_id`) REFERENCES `medias` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_medias_tags_tags` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `paniers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paniers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `libelle` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `uid` varchar(191) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `description` text COLLATE utf8mb4_bin DEFAULT NULL,
  `statut` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`uid`),
  KEY `FK_paniers_users` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `paniers_medias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paniers_medias` (
  `panier_id` bigint(20) unsigned NOT NULL,
  `media_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`panier_id`,`media_id`),
  KEY `FK_paniers_medias_medias` (`media_id`),
  CONSTRAINT `FK_paniers_medias_medias` FOREIGN KEY (`media_id`) REFERENCES `medias` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_paniers_medias_panier` FOREIGN KEY (`panier_id`) REFERENCES `paniers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `paniers_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paniers_users` (
  `panier_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`panier_id`,`user_id`),
  KEY `FK_paniers_users_users` (`user_id`),
  CONSTRAINT `FK_paniers_users_panier` FOREIGN KEY (`panier_id`) REFERENCES `paniers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_paniers_users_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `recherches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recherches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `sujet_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `dossier_id` bigint(20) NOT NULL DEFAULT 0,
  `filters` longtext COLLATE utf8mb4_bin NOT NULL,
  `libelle` varchar(200) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_recherche_users` (`user_id`),
  KEY `FK_recherche_sujets` (`sujet_id`),
  KEY `FK_recherche_dossiers` (`dossier_id`),
  CONSTRAINT `FK_recherche_sujets` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`) ON DELETE CASCADE,
  CONSTRAINT `FK_recherche_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `societes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `societes` (
  `id` bigint(20) unsigned NOT NULL,
  `libelle` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sujets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sujets` (
  `codeSujet` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL,
  `sujet_arcadia` int(10) unsigned DEFAULT 0 COMMENT 'sujet en lien avec Arcadia',
  `sujet_dam` int(10) unsigned DEFAULT 0 COMMENT 'sujet pouvant être géré dans le DAM',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`codeSujet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sujets_formats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sujets_formats` (
  `sujet_id` bigint(20) unsigned NOT NULL,
  `format_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`format_id`,`sujet_id`),
  KEY `format_id` (`format_id`),
  KEY `media_id` (`sujet_id`),
  CONSTRAINT `FK_medias_formats_formats` FOREIGN KEY (`format_id`) REFERENCES `formats` (`id`),
  CONSTRAINT `FK_medias_formats_medias` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sujets_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sujets_users` (
  `sujet_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`sujet_id`,`user_id`),
  KEY `FK_sujets_users_users` (`user_id`),
  CONSTRAINT `FK_sujets_users_sujets` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`) ON DELETE CASCADE,
  CONSTRAINT `FK_sujets_users_users` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tags` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `typemedias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `typemedias` (
  `codeTypemedia` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`codeTypemedia`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `typevues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `typevues` (
  `codeTypevue` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT '',
  `sujet_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`codeTypevue`),
  KEY `sujet_id` (`sujet_id`),
  CONSTRAINT `FK_typevues_sujets` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `objectguid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `matricule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `matricule` (`matricule`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `variantes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `variantes` (
  `codeVariante` bigint(20) unsigned NOT NULL,
  `libelle` varchar(150) COLLATE utf8mb4_bin DEFAULT NULL,
  `sujet_id` bigint(20) unsigned NOT NULL,
  `typevue_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`codeVariante`),
  KEY `FK_variantes_sujets` (`sujet_id`),
  KEY `FK_variantes_typevues` (`typevue_id`),
  CONSTRAINT `FK_variantes_sujets` FOREIGN KEY (`sujet_id`) REFERENCES `sujets` (`codeSujet`),
  CONSTRAINT `FK_variantes_typevues` FOREIGN KEY (`typevue_id`) REFERENCES `typevues` (`codeTypevue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1);
INSERT INTO `migrations` VALUES (2,'2014_10_12_100000_create_password_resets_table',1);
INSERT INTO `migrations` VALUES (3,'2019_05_15_080601_create_marques_table',2);
INSERT INTO `migrations` VALUES (4,'2021_06_09_101909_create_format_restrictions_table',3);
INSERT INTO `migrations` VALUES (5,'2021_06_09_115021_create_settings_table',4);