--
-- Host: localhost    Database: expertij
-- ------------------------------------------------------


--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `addressable_id` int unsigned DEFAULT NULL,
  `addressable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `street` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `addresses`
--

INSERT INTO `addresses` VALUES (1,2,'App\\Models\\User','6, Chemin Des Bateliers',NULL,'74000','Annecy',NULL,'0698548712',NULL,'2023-12-11 14:22:18','2023-12-11 14:22:18'),(2,5,'App\\Models\\User','74, rue Beauvau',NULL,'13004','Marseille',NULL,'0698521478',NULL,'2024-03-03 10:29:12','2024-03-03 10:29:12');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `alt_img` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extra_fields` json DEFAULT NULL,
  `meta_data` json NOT NULL,
  `settings` json NOT NULL,
  `collection_type` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `_lft` int unsigned NOT NULL DEFAULT '0',
  `_rgt` int unsigned NOT NULL DEFAULT '0',
  `parent_id` int unsigned DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `categories__lft__rgt_parent_id_index` (`_lft`,`_rgt`,`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--


--
-- Table structure for table `categorizables`
--

CREATE TABLE `categorizables` (
  `category_id` int unsigned DEFAULT NULL,
  `categorizable_id` int unsigned DEFAULT NULL,
  `categorizable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categorizables`
--


--
-- Table structure for table `category_group`
--

CREATE TABLE `category_group` (
  `category_id` bigint unsigned NOT NULL,
  `group_id` bigint unsigned NOT NULL,
  KEY `category_group_category_id_foreign` (`category_id`),
  KEY `category_group_group_id_foreign` (`group_id`),
  CONSTRAINT `category_group_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `category_group_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_group`
--


--
-- Table structure for table `citizenships`
--

CREATE TABLE `citizenships` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `alpha_3` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `published` tinyint(1) NOT NULL,
  `fr` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `citizenships`
--

INSERT INTO `citizenships` VALUES (1,'AFG',1,'Afghane (Afghanistan)'),(2,'ALB',1,'Albanaise (Albanie)'),(3,'DZA',1,'Algérienne (Algérie)'),(4,'DEU',1,'Allemande (Allemagne)'),(5,'USA',1,'Americaine (États-Unis)'),(6,'AND',1,'Andorrane (Andorre)'),(7,'AGO',1,'Angolaise (Angola)'),(8,'ATG',1,'Antiguaise-et-Barbudienne (Antigua-et-Barbuda)'),(9,'ARG',1,'Argentine (Argentine)'),(10,'ARM',1,'Armenienne (Arménie)'),(11,'AUS',1,'Australienne (Australie)'),(12,'AUT',1,'Autrichienne (Autriche)'),(13,'AZE',1,'Azerbaïdjanaise (Azerbaïdjan)'),(14,'BHS',1,'Bahamienne (Bahamas)'),(15,'BHR',1,'Bahreinienne (Bahreïn)'),(16,'BGD',1,'Bangladaise (Bangladesh)'),(17,'BRB',1,'Barbadienne (Barbade)'),(18,'BEL',1,'Belge (Belgique)'),(19,'BLZ',1,'Belizienne (Belize)'),(20,'BEN',1,'Béninoise (Bénin)'),(21,'BTN',1,'Bhoutanaise (Bhoutan)'),(22,'BLR',1,'Biélorusse (Biélorussie)'),(23,'MMR',1,'Birmane (Birmanie)'),(24,'GNB',1,'Bissau-Guinéenne (Guinée-Bissau)'),(25,'BOL',1,'Bolivienne (Bolivie)'),(26,'BIH',1,'Bosnienne (Bosnie-Herzégovine)'),(27,'BWA',1,'Botswanaise (Botswana)'),(28,'BRA',1,'Brésilienne (Brésil)'),(29,'GBR',1,'Britannique (Royaume-Uni)'),(30,'BRN',1,'Brunéienne (Brunéi)'),(31,'BGR',1,'Bulgare (Bulgarie)'),(32,'BFA',1,'Burkinabée (Burkina)'),(33,'BDI',1,'Burundaise (Burundi)'),(34,'KHM',1,'Cambodgienne (Cambodge)'),(35,'CMR',1,'Camerounaise (Cameroun)'),(36,'CAN',1,'Canadienne (Canada)'),(37,'CPV',1,'Cap-verdienne (Cap-Vert)'),(38,'CAF',1,'Centrafricaine (Centrafrique)'),(39,'CHL',1,'Chilienne (Chili)'),(40,'CHN',1,'Chinoise (Chine)'),(41,'CYP',1,'Chypriote (Chypre)'),(42,'COL',1,'Colombienne (Colombie)'),(43,'COM',1,'Comorienne (Comores)'),(44,'COG',1,'Congolaise (Congo-Brazzaville)'),(45,'COD',1,'Congolaise (Congo-Kinshasa)'),(46,'COK',1,'Cookienne (Îles Cook)'),(47,'CRI',1,'Costaricaine (Costa Rica)'),(48,'HRV',1,'Croate (Croatie)'),(49,'CUB',1,'Cubaine (Cuba)'),(50,'DNK',1,'Danoise (Danemark)'),(51,'DJI',1,'Djiboutienne (Djibouti)'),(52,'DOM',1,'Dominicaine (République dominicaine)'),(53,'DMA',1,'Dominiquaise (Dominique)'),(54,'EGY',1,'Égyptienne (Égypte)'),(55,'ARE',1,'Émirienne (Émirats arabes unis)'),(56,'GNQ',1,'Équato-guineenne (Guinée équatoriale)'),(57,'ECU',1,'Équatorienne (Équateur)'),(58,'ERI',1,'Érythréenne (Érythrée)'),(59,'ESP',1,'Espagnole (Espagne)'),(60,'TLS',1,'Est-timoraise (Timor-Leste)'),(61,'EST',1,'Estonienne (Estonie)'),(62,'ETH',1,'Éthiopienne (Éthiopie)'),(63,'FJI',1,'Fidjienne (Fidji)'),(64,'FIN',1,'Finlandaise (Finlande)'),(65,'FRA',1,'Française (France)'),(66,'GAB',1,'Gabonaise (Gabon)'),(67,'GMB',1,'Gambienne (Gambie)'),(68,'GEO',1,'Georgienne (Géorgie)'),(69,'GHA',1,'Ghanéenne (Ghana)'),(70,'GRD',1,'Grenadienne (Grenade)'),(71,'GTM',1,'Guatémaltèque (Guatemala)'),(72,'GIN',1,'Guinéenne (Guinée)'),(73,'GUY',1,'Guyanienne (Guyana)'),(74,'HTI',1,'Haïtienne (Haïti)'),(75,'GRC',1,'Hellénique (Grèce)'),(76,'HND',1,'Hondurienne (Honduras)'),(77,'HUN',1,'Hongroise (Hongrie)'),(78,'IND',1,'Indienne (Inde)'),(79,'IDN',1,'Indonésienne (Indonésie)'),(80,'IRQ',1,'Irakienne (Iraq)'),(81,'IRN',1,'Iranienne (Iran)'),(82,'IRL',1,'Irlandaise (Irlande)'),(83,'ISL',1,'Islandaise (Islande)'),(84,'ISR',1,'Israélienne (Israël)'),(85,'ITA',1,'Italienne (Italie)'),(86,'CIV',1,'Ivoirienne (Côte d\'Ivoire)'),(87,'JAM',1,'Jamaïcaine (Jamaïque)'),(88,'JPN',1,'Japonaise (Japon)'),(89,'JOR',1,'Jordanienne (Jordanie)'),(90,'KAZ',1,'Kazakhstanaise (Kazakhstan)'),(91,'KEN',1,'Kenyane (Kenya)'),(92,'KGZ',1,'Kirghize (Kirghizistan)'),(93,'KIR',1,'Kiribatienne (Kiribati)'),(94,'KNA',1,'Kittitienne et Névicienne (Saint-Christophe-et-Niévès)'),(95,'KWT',1,'Koweïtienne (Koweït)'),(96,'LAO',1,'Laotienne (Laos)'),(97,'LSO',1,'Lesothane (Lesotho)'),(98,'LVA',1,'Lettone (Lettonie)'),(99,'LBN',1,'Libanaise (Liban)'),(100,'LBR',1,'Libérienne (Libéria)'),(101,'LBY',1,'Libyenne (Libye)'),(102,'LIE',1,'Liechtensteinoise (Liechtenstein)'),(103,'LTU',1,'Lituanienne (Lituanie)'),(104,'LUX',1,'Luxembourgeoise (Luxembourg)'),(105,'MKD',1,'Macédonienne (Macédoine)'),(106,'MYS',1,'Malaisienne (Malaisie)'),(107,'MWI',1,'Malawienne (Malawi)'),(108,'MDV',1,'Maldivienne (Maldives)'),(109,'MDG',1,'Malgache (Madagascar)'),(110,'MLI',1,'Maliennes (Mali)'),(111,'MLT',1,'Maltaise (Malte)'),(112,'MAR',1,'Marocaine (Maroc)'),(113,'MHL',1,'Marshallaise (Îles Marshall)'),(114,'MUS',1,'Mauricienne (Maurice)'),(115,'MRT',1,'Mauritanienne (Mauritanie)'),(116,'MEX',1,'Mexicaine (Mexique)'),(117,'FSM',1,'Micronésienne (Micronésie)'),(118,'MDA',1,'Moldave (Moldovie)'),(119,'MCO',1,'Monegasque (Monaco)'),(120,'MNG',1,'Mongole (Mongolie)'),(121,'MNE',1,'Monténégrine (Monténégro)'),(122,'MOZ',1,'Mozambicaine (Mozambique)'),(123,'NAM',1,'Namibienne (Namibie)'),(124,'NRU',1,'Nauruane (Nauru)'),(125,'NLD',1,'Néerlandaise (Pays-Bas)'),(126,'NZL',1,'Néo-Zélandaise (Nouvelle-Zélande)'),(127,'NPL',1,'Népalaise (Népal)'),(128,'NIC',1,'Nicaraguayenne (Nicaragua)'),(129,'NGA',1,'Nigériane (Nigéria)'),(130,'NER',1,'Nigérienne (Niger)'),(131,'NIU',1,'Niuéenne (Niue)'),(132,'PRK',1,'Nord-coréenne (Corée du Nord)'),(133,'NOR',1,'Norvégienne (Norvège)'),(134,'OMN',1,'Omanaise (Oman)'),(135,'UGA',1,'Ougandaise (Ouganda)'),(136,'UZB',1,'Ouzbéke (Ouzbékistan)'),(137,'PAK',1,'Pakistanaise (Pakistan)'),(138,'PLW',1,'Palaosienne (Palaos)'),(139,'PSE',1,'Palestinienne (Palestine)'),(140,'PAN',1,'Panaméenne (Panama)'),(141,'PNG',1,'Papouane-Néo-Guinéenne (Papouasie-Nouvelle-Guinée)'),(142,'PRY',1,'Paraguayenne (Paraguay)'),(143,'PER',1,'Péruvienne (Pérou)'),(144,'PHL',1,'Philippine (Philippines)'),(145,'POL',1,'Polonaise (Pologne)'),(146,'PRT',1,'Portugaise (Portugal)'),(147,'QAT',1,'Qatarienne (Qatar)'),(148,'ROU',1,'Roumaine (Roumanie)'),(149,'RUS',1,'Russe (Russie)'),(150,'RWA',1,'Rwandaise (Rwanda)'),(151,'LCA',1,'Saint-Lucienne (Sainte-Lucie)'),(152,'SMR',1,'Saint-Marinaise (Saint-Marin)'),(153,'VCT',1,'Saint-Vincentaise et Grenadine (Saint-Vincent-et-les Grenadines)'),(154,'SLB',1,'Salomonaise (Îles Salomon)'),(155,'SLV',1,'Salvadorienne (Salvador)'),(156,'WSM',1,'Samoane (Samoa)'),(157,'STP',1,'Santoméenne (Sao Tomé-et-Principe)'),(158,'SAU',1,'Saoudienne (Arabie saoudite)'),(159,'SEN',1,'Sénégalaise (Sénégal)'),(160,'SRB',1,'Serbe (Serbie)'),(161,'SYC',1,'Seychelloise (Seychelles)'),(162,'SLE',1,'Sierra-Léonaise (Sierra Leone)'),(163,'SGP',1,'Singapourienne (Singapour)'),(164,'SVK',1,'Slovaque (Slovaquie)'),(165,'SVN',1,'Slovène (Slovénie)'),(166,'SOM',1,'Somalienne (Somalie)'),(167,'SDN',1,'Soudanaise (Soudan)'),(168,'LKA',1,'Sri-Lankaise (Sri Lanka)'),(169,'ZAF',1,'Sud-Africaine (Afrique du Sud)'),(170,'KOR',1,'Sud-Coréenne (Corée du Sud)'),(171,'SSD',1,'Sud-Soudanaise (Soudan du Sud)'),(172,'SWE',1,'Suédoise (Suède)'),(173,'CHE',1,'Suisse (Suisse)'),(174,'SUR',1,'Surinamaise (Suriname)'),(175,'SWZ',1,'Swazie (Swaziland)'),(176,'SYR',1,'Syrienne (Syrie)'),(177,'TJK',1,'Tadjike (Tadjikistan)'),(178,'TZA',1,'Tanzanienne (Tanzanie)'),(179,'TCD',1,'Tchadienne (Tchad)'),(180,'CZE',1,'Tchèque (Tchéquie)'),(181,'THA',1,'Thaïlandaise (Thaïlande)'),(182,'TGO',1,'Togolaise (Togo)'),(183,'TON',1,'Tonguienne (Tonga)'),(184,'TTO',1,'Trinidadienne (Trinité-et-Tobago)'),(185,'TUN',1,'Tunisienne (Tunisie)'),(186,'TKM',1,'Turkmène (Turkménistan)'),(187,'TUR',1,'Turque (Turquie)'),(188,'TUV',1,'Tuvaluane (Tuvalu)'),(189,'UKR',1,'Ukrainienne (Ukraine)'),(190,'URY',1,'Uruguayenne (Uruguay)'),(191,'VUT',1,'Vanuatuane (Vanuatu)'),(192,'VAT',1,'Vaticane (Vatican)'),(193,'VEN',1,'Vénézuélienne (Venezuela)'),(194,'VNM',1,'Vietnamienne (Viêt Nam)'),(195,'YEM',1,'Yéménite (Yémen)'),(196,'ZMB',1,'Zambienne (Zambie)'),(197,'ZWE',1,'Zimbabwéenne (Zimbabwe)');

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `text` text COLLATE utf8mb4_unicode_ci,
  `owned_by` bigint unsigned NOT NULL,
  `commentable_id` int unsigned DEFAULT NULL,
  `commentable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 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;

--
-- Dumping data for table `comments`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `object` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci DEFAULT 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;

--
-- Dumping data for table `contacts`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `alpha_2` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alpha_3` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `numerical` smallint unsigned NOT NULL,
  `continent_code` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `published` tinyint(1) NOT NULL,
  `fr` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=243 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'AF','AFG',4,'AS',1,'Afghanistan'),(2,'AX','ALA',248,'EU',1,'Åland, Îles'),(3,'AL','ALB',8,'EU',1,'Albanie'),(4,'DZ','DZA',12,'AF',1,'Algérie'),(5,'AS','ASM',16,'OC',1,'Samoa américaines'),(6,'AD','AND',20,'EU',1,'Andorre'),(7,'AO','AGO',24,'AF',1,'Angola'),(8,'AI','AIA',660,'NA',1,'Anguilla'),(9,'AQ','ATA',10,'AN',1,'Antarctique'),(10,'AG','ATG',28,'NA',1,'Antigua et Barbuda'),(11,'AR','ARG',32,'SA',1,'Argentine'),(12,'AM','ARM',51,'AS',1,'Arménie'),(13,'AW','ABW',533,'NA',1,'Aruba'),(14,'AU','AUS',36,'OC',1,'Australie'),(15,'AT','AUT',40,'EU',1,'Autriche'),(16,'AZ','AZE',31,'AS',1,'Azerbaïdjan'),(17,'BS','BHS',44,'NA',1,'Bahamas'),(18,'BH','BHR',48,'AS',1,'Bahrein'),(19,'BD','BGD',50,'AS',1,'Bangladesh'),(20,'BB','BRB',52,'NA',1,'Barbade'),(21,'BY','BLR',112,'EU',1,'Bélarus'),(22,'BE','BEL',56,'EU',1,'Belgique'),(23,'BZ','BLZ',84,'NA',1,'Bélize'),(24,'BJ','BEN',204,'AF',1,'Bénin'),(25,'BM','BMU',60,'NA',1,'Bermudes'),(26,'BT','BTN',64,'AS',1,'Bhoutan'),(27,'BO','BOL',68,'SA',1,'Bolivie (État plurinational de)'),(28,'BA','BIH',70,'EU',1,'Bosnie-Herzégovine'),(29,'BW','BWA',72,'AF',1,'Botswana'),(30,'BR','BRA',76,'SA',1,'Brésil'),(31,'VG','VGB',92,'NA',1,'Îles vierges britanniques'),(32,'IO','IOT',86,'AS',1,'Indien (Territoire britannique de l\'océan)'),(33,'BN','BRN',96,'AS',1,'Brunéi Darussalam'),(34,'BG','BGR',100,'EU',1,'Bulgarie'),(35,'BF','BFA',854,'AF',1,'Burkina Faso'),(36,'BI','BDI',108,'AF',1,'Burundi'),(37,'KH','KHM',116,'AS',1,'Cambodge'),(38,'CM','CMR',120,'AF',1,'Cameroun'),(39,'CA','CAN',124,'NA',1,'Canada'),(40,'CV','CPV',132,'AF',1,'Cabo Verde'),(41,'KY','CYM',136,'NA',1,'Caïmans, Iles'),(42,'CF','CAF',140,'AF',1,'République centrafricaine'),(43,'TD','TCD',148,'AF',1,'Tchad'),(44,'CL','CHL',152,'SA',1,'Chili'),(45,'CN','CHN',156,'AS',1,'Chine'),(46,'HK','HKG',344,'AS',1,'Hong Kong'),(47,'MO','MAC',446,'AS',1,'Macao'),(48,'CX','CXR',162,'AS',1,'Christmas, île'),(49,'CC','CCK',166,'AS',1,'Cocos/Keeling (Îles)'),(50,'CO','COL',170,'SA',1,'Colombie'),(51,'KM','COM',174,'AF',1,'Comores'),(52,'CG','COG',178,'AF',1,'Congo'),(53,'CD','COD',180,'AF',1,'Congo, République démocratique du'),(54,'CK','COK',184,'OC',1,'Cook, Iles'),(55,'CR','CRI',188,'NA',1,'Costa Rica'),(56,'CI','CIV',384,'AF',1,'Côte d\'Ivoire'),(57,'HR','HRV',191,'EU',1,'Croatie'),(58,'CU','CUB',192,'NA',1,'Cuba'),(59,'CY','CYP',196,'EU',1,'Chypre'),(60,'CZ','CZE',203,'EU',1,'Tchèque, République'),(61,'DK','DNK',208,'EU',1,'Danemark'),(62,'DJ','DJI',262,'AF',1,'Djibouti'),(63,'DM','DMA',212,'NA',1,'Dominique'),(64,'DO','DOM',214,'NA',1,'Dominicaine, République'),(65,'EC','ECU',218,'SA',1,'Equateur'),(66,'EG','EGY',818,'AF',1,'Egypte'),(67,'SV','SLV',222,'NA',1,'El Salvador'),(68,'GQ','GNQ',226,'AF',1,'Guinée équatoriale'),(69,'ER','ERI',232,'AF',1,'Erythrée'),(70,'EE','EST',233,'EU',1,'Estonie'),(71,'ET','ETH',231,'AF',1,'Ethiopie'),(72,'FK','FLK',238,'SA',1,'Falkland/Malouines (Îles)'),(73,'FO','FRO',234,'EU',1,'Féroé, îles'),(74,'FJ','FJI',242,'OC',1,'Fidji'),(75,'FI','FIN',246,'EU',1,'Finlande'),(76,'FR','FRA',250,'EU',1,'France'),(77,'GF','GUF',254,'SA',1,'Guyane française'),(78,'PF','PYF',258,'OC',1,'Polynésie française'),(79,'TF','ATF',260,'AN',1,'Terres australes françaises'),(80,'GA','GAB',266,'AF',1,'Gabon'),(81,'GM','GMB',270,'AF',1,'Gambie'),(82,'GE','GEO',268,'AS',1,'Géorgie'),(83,'DE','DEU',276,'EU',1,'Allemagne'),(84,'GH','GHA',288,'AF',1,'Ghana'),(85,'GI','GIB',292,'EU',1,'Gibraltar'),(86,'GR','GRC',300,'EU',1,'Grèce'),(87,'GL','GRL',304,'NA',1,'Groenland'),(88,'GD','GRD',308,'NA',1,'Grenade'),(89,'GP','GLP',312,'NA',1,'Guadeloupe'),(90,'GU','GUM',316,'OC',1,'Guam'),(91,'GT','GTM',320,'NA',1,'Guatemala'),(92,'GG','GGY',831,'EU',1,'Guernesey'),(93,'GN','GIN',324,'AF',1,'Guinée'),(94,'GW','GNB',624,'AF',1,'Guinée-Bissau'),(95,'GY','GUY',328,'SA',1,'Guyana'),(96,'HT','HTI',332,'NA',1,'Haïti'),(97,'HN','HND',340,'NA',1,'Honduras'),(98,'HU','HUN',348,'EU',1,'Hongrie'),(99,'IS','ISL',352,'EU',1,'Islande'),(100,'IN','IND',356,'AS',1,'Inde'),(101,'ID','IDN',360,'AS',1,'Indonésie'),(102,'IR','IRN',364,'AS',1,'Iran, République islamique'),(103,'IQ','IRQ',368,'AS',1,'Iraq'),(104,'IE','IRL',372,'EU',1,'Irlande'),(105,'IM','IMN',833,'EU',1,'Île de Man'),(106,'IL','ISR',376,'AS',1,'Israël'),(107,'IT','ITA',380,'EU',1,'Italie'),(108,'JM','JAM',388,'NA',1,'Jamaïque'),(109,'JP','JPN',392,'AS',1,'Japon'),(110,'JE','JEY',832,'EU',1,'Jersey'),(111,'JO','JOR',400,'AS',1,'Jordanie'),(112,'KZ','KAZ',398,'AS',1,'Kazakhstan'),(113,'KE','KEN',404,'AF',1,'Kenya'),(114,'KI','KIR',296,'OC',1,'Kiribati'),(115,'KP','PRK',408,'AS',1,'Corée, République populaire démocratique de'),(116,'KR','KOR',410,'AS',1,'Corée, République de'),(117,'KW','KWT',414,'AS',1,'Koweït'),(118,'KG','KGZ',417,'AS',1,'Kirghizistan'),(119,'LA','LAO',418,'AS',1,'Lao, République démocratique populaire'),(120,'LV','LVA',428,'EU',1,'Lettonie'),(121,'LB','LBN',422,'AS',1,'Liban'),(122,'LS','LSO',426,'AF',1,'Lesotho'),(123,'LR','LBR',430,'AF',1,'Libéria'),(124,'LY','LBY',434,'AF',1,'Libye'),(125,'LI','LIE',438,'EU',1,'Liechtenstein'),(126,'LT','LTU',440,'EU',1,'Lituanie'),(127,'LU','LUX',442,'EU',1,'Luxembourg'),(128,'MK','MKD',807,'EU',1,'Macédoine, ex-République yougoslave de'),(129,'MG','MDG',450,'AF',1,'Madagascar'),(130,'MW','MWI',454,'AF',1,'Malawi'),(131,'MY','MYS',458,'AS',1,'Malaisie'),(132,'MV','MDV',462,'AS',1,'Maldives'),(133,'ML','MLI',466,'AF',1,'Mali'),(134,'MT','MLT',470,'EU',1,'Malte'),(135,'MH','MHL',584,'OC',1,'Marshall, Iles'),(136,'MQ','MTQ',474,'NA',1,'Martinique'),(137,'MR','MRT',478,'AF',1,'Mauritanie'),(138,'MU','MUS',480,'AF',1,'Maurice'),(139,'YT','MYT',175,'AF',1,'Mayotte'),(140,'MX','MEX',484,'NA',1,'Mexique'),(141,'FM','FSM',583,'OC',1,'Micronésie, Etats Fédérés de'),(142,'MD','MDA',498,'EU',1,'Moldova, République de'),(143,'MC','MCO',492,'EU',1,'Monaco'),(144,'MN','MNG',496,'AS',1,'Mongolie'),(145,'ME','MNE',499,'EU',1,'Monténégro'),(146,'MS','MSR',500,'NA',1,'Montserrat'),(147,'MA','MAR',504,'AF',1,'Maroc'),(148,'MZ','MOZ',508,'AF',1,'Mozambique'),(149,'MM','MMR',104,'AS',1,'Myanmar'),(150,'NA','NAM',516,'AF',1,'Namibie'),(151,'NR','NRU',520,'OC',1,'Nauru'),(152,'NP','NPL',524,'AS',1,'Népal'),(153,'NL','NLD',528,'EU',1,'Pays-Bas'),(154,'AN','ANT',530,'NA',1,'Antilles néerlandaises'),(155,'NC','NCL',540,'OC',1,'Nouvelle-Calédonie'),(156,'NZ','NZL',554,'OC',1,'Nouvelle-Zélande'),(157,'NI','NIC',558,'NA',1,'Nicaragua'),(158,'NE','NER',562,'AF',1,'Niger'),(159,'NG','NGA',566,'AF',1,'Nigéria'),(160,'NU','NIU',570,'OC',1,'Niue'),(161,'NF','NFK',574,'OC',1,'Norfolk, Ile'),(162,'MP','MNP',580,'OC',1,'Mariannes du nord, Iles'),(163,'NO','NOR',578,'EU',1,'Norvège'),(164,'OM','OMN',512,'AS',1,'Oman'),(165,'PK','PAK',586,'AS',1,'Pakistan'),(166,'PW','PLW',585,'OC',1,'Palaos'),(167,'PS','PSE',275,'AS',1,'Palestine, Etat de'),(168,'PA','PAN',591,'NA',1,'Panama'),(169,'PG','PNG',598,'OC',1,'Papouasie-Nouvelle-Guinée'),(170,'PY','PRY',600,'SA',1,'Paraguay'),(171,'PE','PER',604,'SA',1,'Pérou'),(172,'PH','PHL',608,'AS',1,'Philippines'),(173,'PN','PCN',612,'OC',1,'Pitcairn'),(174,'PL','POL',616,'EU',1,'Pologne'),(175,'PT','PRT',620,'EU',1,'Portugal'),(176,'PR','PRI',630,'NA',1,'Porto Rico'),(177,'QA','QAT',634,'AS',1,'Qatar'),(178,'RE','REU',638,'AF',1,'Réunion'),(179,'RO','ROU',642,'EU',1,'Roumanie'),(180,'RU','RUS',643,'EU',1,'Russie, Fédération de'),(181,'RW','RWA',646,'AF',1,'Rwanda'),(182,'BL','BLM',652,'NA',1,'Saint-Barthélemy'),(183,'SH','SHN',654,'AF',1,'Sainte-Hélène, Ascension et Tristan da Cunha'),(184,'KN','KNA',659,'NA',1,'Saint-Kitts-et-Nevis'),(185,'LC','LCA',662,'NA',1,'Sainte-Lucie'),(186,'MF','MAF',663,'NA',1,'Saint-Martin (partie française)'),(187,'PM','SPM',666,'NA',1,'Saint-Pierre-et-Miquelon'),(188,'VC','VCT',670,'NA',1,'Saint-Vincent-et-les-Grenadines'),(189,'WS','WSM',882,'OC',1,'Samoa'),(190,'SM','SMR',674,'EU',1,'Saint-Marin'),(191,'ST','STP',678,'AF',1,'Sao Tomé-et-Principe'),(192,'SA','SAU',682,'AS',1,'Arabie Saoudite'),(193,'SN','SEN',686,'AF',1,'Sénégal'),(194,'RS','SRB',688,'EU',1,'Serbie'),(195,'SC','SYC',690,'AF',1,'Seychelles'),(196,'SL','SLE',694,'AF',1,'Sierra Leone'),(197,'SG','SGP',702,'AS',1,'Singapour'),(198,'SK','SVK',703,'EU',1,'Slovaquie'),(199,'SI','SVN',705,'EU',1,'Slovénie'),(200,'SB','SLB',90,'OC',1,'Salomon, Iles'),(201,'SO','SOM',706,'AF',1,'Somalie'),(202,'ZA','ZAF',710,'AF',1,'Afrique du Sud'),(203,'ES','ESP',724,'EU',1,'Espagne'),(204,'LK','LKA',144,'AS',1,'Sri Lanka'),(205,'SD','SDN',736,'AF',1,'Soudan'),(206,'SR','SUR',740,'SA',1,'Suriname'),(207,'SJ','SJM',744,'EU',1,'Svalbard et île Jan Mayen'),(208,'SZ','SWZ',748,'AF',1,'Swaziland'),(209,'SE','SWE',752,'EU',1,'Suède'),(210,'CH','CHE',756,'EU',1,'Suisse'),(211,'SY','SYR',760,'AS',1,'République arabe syrienne'),(212,'TW','TWN',158,'AS',1,'Taïwan, Province de Chine'),(213,'TJ','TJK',762,'AS',1,'Tadjikistan'),(214,'TZ','TZA',834,'AF',1,'Tanzanie, République unie de'),(215,'TH','THA',764,'AS',1,'Thaïlande'),(216,'TL','TLS',626,'AS',1,'Timor-Leste'),(217,'TG','TGO',768,'AF',1,'Togo'),(218,'TK','TKL',772,'OC',1,'Tokelau'),(219,'TO','TON',776,'OC',1,'Tonga'),(220,'TT','TTO',780,'NA',1,'Trinité-et-Tobago'),(221,'TN','TUN',788,'AF',1,'Tunisie'),(222,'TR','TUR',792,'AS',1,'Turquie'),(223,'TM','TKM',795,'AS',1,'Turkménistan'),(224,'TC','TCA',796,'NA',1,'Turks-et-Caïcos (Îles)'),(225,'TV','TUV',798,'OC',1,'Tuvalu'),(226,'UG','UGA',800,'AF',1,'Ouganda'),(227,'UA','UKR',804,'EU',1,'Ukraine'),(228,'AE','ARE',784,'AS',1,'Emirats arabes unis'),(229,'GB','GBR',826,'EU',1,'Royaume-Uni de Grande-Bretagne et d\'Irlande du Nord'),(230,'US','USA',840,'NA',1,'Etats-Unis d\'Amérique'),(231,'UM','UMI',581,'OC',1,'Îles mineures éloignées des Etats-Unis'),(232,'UY','URY',858,'SA',1,'Uruguay'),(233,'UZ','UZB',860,'AS',1,'Ouzbékistan'),(234,'VU','VUT',548,'OC',1,'Vanuatu'),(235,'VE','VEN',862,'SA',1,'Venezuela (République bolivarienne du)'),(236,'VN','VNM',704,'AS',1,'Viet Nam'),(237,'VI','VIR',850,'NA',1,'Îles vierges des Etats-Unis'),(238,'WF','WLF',876,'OC',1,'Wallis et Futuna'),(239,'EH','ESH',732,'AF',1,'Sahara occidental'),(240,'YE','YEM',887,'AS',1,'Yémen'),(241,'ZM','ZMB',894,'AF',1,'Zambie'),(242,'ZW','ZWE',716,'AF',1,'Zimbabwe');

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `disk_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` int unsigned DEFAULT NULL,
  `content_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `field` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `documentable_id` int unsigned DEFAULT NULL,
  `documentable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_public` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` VALUES (1,'3c8b1900890165481234f8c20d7d67fb.pdf','iptables.pdf',117724,'application/pdf','professional_attestation',1,'App\\Models\\Membership',1,'2023-12-11 14:22:18','2023-12-11 14:22:18'),(2,'65ecfcc180000385f38aa9290d680e25.pdf','mon_attestation.pdf',13984,'application/pdf','licence_attestation',1,'App\\Models\\Membership\\Attestation',1,'2023-12-11 14:22:18','2023-12-11 14:22:18'),(3,'03aff4845b3e349cd6ef4153c26545e9.pdf','mon_attestation_2.pdf',13984,'application/pdf','licence_attestation',2,'App\\Models\\Membership\\Attestation',1,'2023-12-11 14:22:18','2023-12-11 14:22:18'),(4,'fad0621e355af5489483d8def05dc8b4.jpg','Actresses-with-Short-Blonde-Hair.jpg',46298,'image/jpeg','photo',2,'App\\Models\\User',1,'2023-12-11 14:22:18','2023-12-11 14:22:18'),(5,'5a7c0f2fe7c83418a469ded5f292e653.pdf','insurance-invoice.pdf',24194,'application/pdf','invoice',3,'App\\Models\\Cms\\Payment',1,'2024-02-06 11:59:30','2024-02-06 11:59:30'),(6,'aa1a5a6920d862bcd836f226c7604830.pdf','subscription-invoice.pdf',24194,'application/pdf','invoice',3,'App\\Models\\Cms\\Payment',1,'2024-02-06 14:19:02','2024-02-06 14:19:02'),(7,'13d1c012d71ae1d3f585aef1e6421723.pdf','facture-assurance-2024-1-E-09-02-2024.pdf',24210,'application/pdf','invoice',3,'App\\Models\\Cms\\Payment',1,'2024-02-09 06:06:56','2024-02-09 06:06:56'),(8,'9559efb1f493f5ec3977ac8035efd2dd.pdf','facture-adhesion-2024-1-E-09-02-2024.pdf',23765,'application/pdf','invoice',1,'App\\Models\\Cms\\Payment',1,'2024-02-09 06:17:35','2024-02-09 06:17:35'),(9,'1fa6cb74d983298fa228cbecf1e28771.pdf','facture-assurance-2024-1-E-09-02-2024.pdf',24209,'application/pdf','invoice',3,'App\\Models\\Cms\\Payment',1,'2024-02-09 09:43:53','2024-02-09 09:43:53'),(10,'6b6c746a4fc22dab12f0bd2a3240e9e9.pdf','iptables.pdf',117724,'application/pdf','file_manager',1,'App\\Models\\User',1,'2024-02-15 13:43:13','2024-02-15 13:43:13'),(11,'f9dbe8b86dab575b20a72ecc62d1e7ae.pdf','mon_attestation.pdf',13984,'application/pdf','file_manager',1,'App\\Models\\User',1,'2024-02-15 13:45:09','2024-02-15 13:45:09'),(17,'29b5d2352bb7194d8c8a5b7ee14f2818.pdf','web-services-rest.pdf',131311,'application/pdf','sharing',1,'App\\Models\\Membership\\Sharing',1,'2024-02-22 12:01:02','2024-02-22 12:01:02'),(18,'bd8d493996c1e15bffab3044b0b3eb53.pdf','ESI-nEar05_classic.pdf',183511,'application/pdf','sharing',1,'App\\Models\\Membership\\Sharing',1,'2024-02-22 12:03:36','2024-02-22 12:03:36'),(19,'e05c7950f3b104d865e3cd2a24fe867e.pdf','Formulairederabonnement-2019.pdf',53952,'application/pdf','sharing',1,'App\\Models\\Membership\\Sharing',1,'2024-02-22 12:04:48','2024-02-22 12:04:48'),(20,'2329b734b928137f270eeae62752da64.pdf','LinuxFirewalling.pdf',71573,'application/pdf','sharing',2,'App\\Models\\Membership\\Sharing',1,'2024-02-22 13:33:02','2024-02-22 13:33:02'),(21,'5097c056fb2f1fae98d87f9a43c8e896.pdf','Tarot-Blueprint.pdf',58802,'application/pdf','sharing',2,'App\\Models\\Membership\\Sharing',1,'2024-02-22 13:33:02','2024-02-22 13:33:02'),(24,'bd8921f0b2dc40bb70c519833fe3a33a.pdf','web-services-rest.pdf',131311,'application/pdf','resume',1,'App\\Models\\Membership',1,'2024-02-26 15:37:34','2024-02-26 15:37:34'),(25,'c1d58ec536b967aae8ce4351a4162546.pdf','facture-adhesion-2024-2-MA-07-03-2024.pdf',23759,'application/pdf','invoice',4,'App\\Models\\Cms\\Payment',1,'2024-03-07 09:27:58','2024-03-07 09:27:58'),(26,'a22dbee15f8e92604d036cda8951a1de.pdf','facture-adhesion-2024-1-E-09-03-2024.pdf',23765,'application/pdf','invoice',5,'App\\Models\\Cms\\Payment',1,'2024-03-09 09:04:39','2024-03-09 09:04:39'),(27,'5365209048e944ea4a9918b1192f6abc.pdf','facture-assurance-2024-1-E-09-03-2024.pdf',24210,'application/pdf','invoice',5,'App\\Models\\Cms\\Payment',1,'2024-03-09 09:04:39','2024-03-09 09:04:39');

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body_html` text COLLATE utf8mb4_unicode_ci,
  `body_text` text COLLATE utf8mb4_unicode_ci,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plain_text` tinyint(1) DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `emails_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` VALUES (1,'user-registration','Bienvenue {{ $data->name }}','<p>Bonjour {{ $data->name }}</p>\r\n<p>Bienvenue chez Expertij !<br />Un compte utilisateur a été créé pour vous.</p>\r\n<p>login: {{ $data->email }}<br />Veuillez utiliser le mot de passe que vous avez choisi durant l\'enregistrement.</p>\r\n<p>Cordialement,<br />Expertij</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-11 09:11:42','2024-02-29 14:49:43'),(2,'new-message','New message','<p>Hello administrator.<br /><br />A user has sent a message.<br />Name: {{ $data->name }}<br />Email: {{ $data->email }}<br />Object: {{ $data->object }}<br />Message: {{ $data->message }}<br /><br />Best regard, <br />The Starter CMS team.</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-11 09:11:42','2023-12-11 14:45:37'),(3,'comment-alert','Comment alert','<p>Hello {{ $data->post_author }}<br /><br />The user {{ $data->comment_author }} has left a comment regarding your post {{ $data->title }}.<br />You can check it out here: {{ $data->post_url }}<br /><br />Best regard, <br />The Starter CMS team.</p>',NULL,NULL,0,NULL,NULL,NULL,'2023-12-11 09:11:42','2023-12-11 09:11:42'),(4,'candidate-application','Confirmation de réception d\'une demande d’adhésion','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Nous avons bien reçu votre demande d’adhésion. <br />Le secrétariat général vous informera prochainement de la décision du conseil d’administration et des membres fondateurs.</p>\r\n<p>Cordialement, EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-11 13:52:51','2023-12-11 14:46:42'),(5,'membership-request','Nouvelle demande d’adhésion','<p>Bonjour,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} vient de déposer une demande d’adhésion. </p>\r\n<p>Merci d’en prendre connaissance.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-11 17:01:37','2023-12-11 17:01:37'),(6,'decision-makers-alert','Nouvelle demande d’adhésion','<p>Bonjour,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} vient de déposer une demande d’adhésion. <br />Merci de donner votre avis.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-13 09:35:27','2023-12-21 10:11:05'),(7,'vote-alert','Vote d’un décisionnaire','<p>Bonjour,<br />{{ $data->first_name }} {{ $data->last_name }} a donné son avis sur la demande d’adhésion de {{ $data->applicant_first_name }} {{ $data->applicant_last_name }}.<br />Vous pouvez consulter cet avis.</p>\r\n<p>Cordialement, EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-21 10:15:25','2023-12-21 10:15:25'),(8,'pending-subscription','Candidature acceptée','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Votre demande d’adhésion a été acceptée. <br />Pour devenir membre de l’association, merci de vous rendre dans votre espace personnel et de régler votre cotisation d’un montant de  {{ $data->subscription_fee }} euros.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-25 14:17:40','2023-12-26 07:06:07'),(9,'refused','Candidature refusée','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Nous sommes au regret de vous informer que le conseil d’administration et les membres fondateurs n’ont pas pu accepter votre demande d’adhésion.<br />N’hésitez pas à nous contacter à ce sujet.</p>\r\n<p>Cordialement.<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-25 14:18:44','2023-12-26 07:06:15'),(10,'revoked','Radiation membre','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Nous vous avons radié de la liste des membres. Vous ne faites plus partie d’EXPERTIJ.<br />Vous pouvez contacter le secrétariat général ou la présidence pour de plus amples informations</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 08:44:33','2023-12-26 08:44:33'),(11,'cancelled','Candidature annulée','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Votre demande d’adhésion a été acceptée mais vous n’avez pas réglé votre cotisation. Nous annulons donc votre demande. <br />Pour plus d’information, merci de contacter le secrétariat général.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 08:45:25','2023-12-26 08:45:25'),(12,'new-member','Vous êtes bien membre d’EXPERTIJ','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Vous êtes maintenant membre d’Expertij. <br />Bienvenue dans notre association !</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 08:47:04','2023-12-26 08:47:04'),(13,'cancellation-alert','Annulation adhésion','<p>Bonjour,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} a annulé son adhésion.</p>\r\n<p> Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 08:49:25','2023-12-26 08:49:25'),(14,'cancellation','Annulation adhésion','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Nous avons bien noté que vous ne souhaitiez plus faire partie d’Expertij.<br />Merci de contacter le secrétariat général ou la présidence au sujet de l’accès à votre espace personnel.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-26 08:50:11','2023-12-26 08:50:11'),(15,'subscription-renewal','Adhésion renouvelée','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Merci d’avoir renouvelé votre adhésion à EXPERTIJ et de continuer à nous faire confiance.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2023-12-31 10:07:18','2023-12-31 10:07:18'),(16,'free-period-validation','Validation période de gratuité','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>La période pendant laquelle vous étiez membre d’Expertij gratuitement est écoulée. <br />Votre cotisation versée le {{ $data->payment_date }} couvre l’année à venir.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-31 10:09:07','2024-02-05 14:48:29'),(17,'free-period-validation-alert','Validation période de gratuité','<p>Bonjour,</p>\r\n<p>La période de gratuité de l’adhésion de {{ $data->first_name }} {{ $data->last_name }} vient de se terminer.<br />La cotisation versée le {{ $data->payment_date }} couvre l’année à venir.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-31 10:10:09','2024-02-05 14:48:54'),(18,'offline-payment-subscription-alert','Envoi d’un règlement de cotisation par {{ $data->payment_mode }}','<p>Cher administrateur,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} a choisi de régler sa cotisation d’un montant de {{ $data->subscription_fee }} euros par {{ $data->payment_mode }}.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-31 10:12:02','2024-02-06 05:51:27'),(19,'offline-payment-insurance-alert','Envoi d’un règlement d\'assurance par {{ $data->payment_mode }}','<p>Cher administrateur,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} a choisi de régler son assurance {{ $data->insurance_formula }} d’un montant de {{ $data->insurance_fee }} euros par {{ $data->payment_mode }}.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-31 10:13:04','2024-02-06 05:50:29'),(20,'offline-payment-subscription','Envoi d’un règlement de cotisation par {{ $data->payment_mode }}','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Vous avez choisi de régler votre cotisation par {{ $data->payment_mode }} pour un montant de {{ $data->subscription_fee }} euros. <br />Veuillez trouver ci-dessous les instructions correspondants au mode de paiement choisi.</p>\r\n<p>Cordialement, <br />EXPERTIJ</p>\r\n<p>- Paiement par chèque.</p>\r\n<p>Merci d’envoyer le chèque libellé à l’ordre d’Expertij au trésorier :</p>\r\n<p>Natallia CALVEL<br />13  route du Stade<br />09000 Saint Jean de Verges.</p>\r\n<p> </p>\r\n<p>- Paiement par virement bancaire.</p>\r\n<p>---- Relevé d\'identité bancaire ----<br />CREDIT LYONNAIS<br />CHATEAUNEUF SUR LOIRE<br />62 GRANDE RUE<br />45110 CHATEAUNEUF SUR LOIRE&lt;br /&gt;</p>\r\n<p>---- Titulaire du compte ----<br />EXPERTS ET TRADUCTEURS<br />INTERPRETES JUDICIAIRES EXPERTIJ</p>\r\n<p>---- Domiciliation ----<br />CHATEAUNEUF SUR LOIRE (07660)</p>\r\n<p>---- Références bancaires nationales - RIB ----<br />Banque: 30002<br />Indicatif: 07660<br />No de compte: 0000070480U<br />Clé: 77</p>\r\n<p>---- Références bancaires internationales ----<br />IBAN: FR03 3000 2076 6000 0007 0480 U77<br />BIC: CRLYFRPP<br /><br /></p>',NULL,NULL,0,NULL,NULL,1,'2023-12-31 10:17:46','2023-12-31 10:20:22'),(21,'offline-payment-insurance','Envoi d’un règlement d\'assurance par {{ $data->payment_mode }}','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Vous avez choisi de régler votre assurance {{ $data->insurance_formula }} d\'un montant de {{ $data->insurance_fee }} euros par {{ $data->payment_mode }} . <br />La couverture de cette assurance est de {{ $data->insurance_coverage }}.<br />Veuillez trouver ci-dessous les instructions correspondants au mode de paiement choisi. </p>\r\n<p>Cordialement,<br />EXPERTIJ</p>\r\n<p>- Paiement par chèque.</p>\r\n<p>Merci d’envoyer le chèque libellé à l’ordre d’Expertij au trésorier :</p>\r\n<p>Natallia CALVEL<br />13  route du Stade<br />09000 Saint Jean de Verges.</p>\r\n<p> </p>\r\n<p>- Paiement par virement bancaire.</p>\r\n<p>---- Relevé d\'identité bancaire ----<br />CREDIT LYONNAIS<br />CHATEAUNEUF SUR LOIRE<br />62 GRANDE RUE<br />45110 CHATEAUNEUF SUR LOIRE&lt;br /&gt;</p>\r\n<p>---- Titulaire du compte ----<br />EXPERTS ET TRADUCTEURS<br />INTERPRETES JUDICIAIRES EXPERTIJ</p>\r\n<p>---- Domiciliation ----<br />CHATEAUNEUF SUR LOIRE (07660)</p>\r\n<p>---- Références bancaires nationales - RIB ----<br />Banque: 30002<br />Indicatif: 07660<br />No de compte: 0000070480U<br />Clé: 77</p>\r\n<p>---- Références bancaires internationales ----<br />IBAN: FR03 3000 2076 6000 0007 0480 U77<br />BIC: CRLYFRPP</p>',NULL,NULL,0,NULL,NULL,1,'2023-12-31 10:20:03','2024-02-29 12:58:33'),(22,'new-member-free-period','Vous êtes bien membre d’EXPERTIJ','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Vous êtes maintenant membre d’Expertij.<br />Bienvenue dans notre association !</p>\r\n<p>Information:<br />Votre demande d\'adhésion ayant été pris en compte tardivement, vous bénéficiez d\'une période de gratuité qui va de la date d\'admission en tant que membre d\'Expertij jusqu\'au renouvellement de cotisation.<br />Votre paiement couvrira donc votre cotisation pour l\'année à venir.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2024-01-01 08:17:49','2024-01-05 14:59:50'),(23,'payment-completed','Règlement reçu','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Votre règlement d’un montant de {{ $data->amount }} euros en paiement de votre {{ $data->item }} par {{ $data->payment_mode }} est confirmé.<br />Veuillez trouver le justificatif en pièce jointe.<br />Votre attestation d’assurance est accessible dans votre espace personnel.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2024-01-05 10:06:03','2024-01-06 06:11:47'),(24,'payment-completed-alert','Règlement reçu','<p>Bonjour,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} a réglé un montant de {{ $data->amount }} euros pour : {{ $data->item }} par : {{ $data->payment_mode }}. <br />Le justificatif lui a été envoyé.</p>\r\n<p>Cordialement,&lt;br&gt;<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2024-01-05 10:07:12','2024-01-06 06:12:16'),(25,'payment-cancelled','Annulation de paiement','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }},</p>\r\n<p>Votre règlement d’un montant de {{ $data->amount }} euros pour {{ $data->item }} par {{ $data->payment_mode }} a été annulé.<br />En cas de règlement par chèque, celui-ci vous sera retourné.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-05 10:08:24','2024-01-05 10:08:24'),(26,'payment-cancelled-alert','Annulation de paiement','<p>Bonjour,</p>\r\n<p>Le règlement de {{ $data->first_name }} {{ $data->last_name }} d’un montant de {{ $data->amount }} euros pour {{ $data->item }} par {{ $data->payment_mode }} a été annulé.<br />Il faut penser, le cas échéant, à retourner le chèque.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-01-05 10:09:32','2024-01-05 10:09:32'),(27,'pending-renewal','Renouvellement d’adhésion','<p>Cher membre,</p>\r\n<p>Votre adhésion arrive à échéance le {{ $data->renewal_date }}.<br />Veuillez aller dans votre espace personnel pour procéder à son renouvellement en payant votre cotisation d’un montant de  {{ $data->subscription_fee }} euros.<br />Note: Pour les membres associés le montant est de {{ $data->associated_subscription_fee }} euros.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,0,NULL,NULL,1,'2024-01-15 07:35:46','2024-02-05 15:38:24'),(28,'offline-payment-subscription-insurance','Envoi d’un règlement de cotisation et d\'assurance par {{ $data->payment_mode }}','<p>Bonjour {{ $data->first_name }} {{ $data->last_name }}, <br />Vous avez choisi de régler votre cotisation d\'un montant de {{ $data->subscription_fee }} euros ainsi que votre assurance {{ $data->insurance_formula }} d\'un montant de {{ $data->insurance_fee }} euros par {{ $data->payment_mode }}. <br />Le montant total de votre réglement est de {{ $data->total_amount }} euros. <br />Veuillez trouver ci-dessous les instructions correspondants au mode de paiement choisi.<br /><br />Cordialement, EXPERTIJ - Paiement par chèque.<br /><br /></p>\r\n<p>- Paiement par chèque.</p>\r\n<p>Merci d’envoyer le chèque libellé à l’ordre d’Expertij au trésorier :</p>\r\n<p>Natallia CALVEL<br />13  route du Stade<br />09000 Saint Jean de Verges.</p>\r\n<p> </p>\r\n<p>- Paiement par virement bancaire.</p>\r\n<p>---- Relevé d\'identité bancaire ----<br />CREDIT LYONNAIS<br />CHATEAUNEUF SUR LOIRE<br />62 GRANDE RUE<br />45110 CHATEAUNEUF SUR LOIRE&lt;br /&gt;</p>\r\n<p>---- Titulaire du compte ----<br />EXPERTS ET TRADUCTEURS<br />INTERPRETES JUDICIAIRES EXPERTIJ</p>\r\n<p>---- Domiciliation ----<br />CHATEAUNEUF SUR LOIRE (07660)</p>\r\n<p>---- Références bancaires nationales - RIB ----<br />Banque: 30002<br />Indicatif: 07660<br />No de compte: 0000070480U<br />Clé: 77</p>\r\n<p>---- Références bancaires internationales ----<br />IBAN: FR03 3000 2076 6000 0007 0480 U77<br />BIC: CRLYFRPP<br /><br /></p>',NULL,NULL,0,NULL,NULL,1,'2024-02-01 13:20:04','2024-02-01 13:24:48'),(29,'offline-payment-subscription-insurance-alert','Envoi d’un règlement de cotisation et d\'assurance par {{ $data->payment_mode }}','<p>Cher administrateur,</p>\r\n<p>{{ $data->first_name }} {{ $data->last_name }} a choisi de régler sa cotisation d’un montant de {{ $data->subscription_fee }} euros ainsi que son assurance {{ $data->insurance_formula }} d\'un montant de {{ $data->insurance_fee }} euros par {{ $data->payment_mode }}. <br />Le montant total de son réglement est de {{ $data->total_amount }} euros.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-02-01 13:27:09','2024-02-01 13:27:09'),(30,'alert-document','Nouveau document','<p>Cher membre,</p>\r\n<p>Un document intitulé {{ $data->name }} vient d’être publié dans votre espace membre.<br />Merci d’en prendre connaissance.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-02-24 05:35:09','2024-02-24 05:35:09'),(31,'pending-renewal-reminder','Rappel renouvellement d’adhésion','<p>Cher membre,</p>\r\n<p>Votre adhésion arrive à échéance le {{ $data->renewal_date }} mais n’a pas été renouvelée à ce jour.<br />Veuillez aller dans votre espace personnel pour procéder à son renouvellement en payant votre cotisation d’un montant de  {{ $data->subscription_fee }} euros.<br />Note: Pour les membres associés le montant est de {{ $data->associated_subscription_fee }} euros.</p>\r\n<p>Cordialement,<br />EXPERTIJ</p>',NULL,NULL,NULL,NULL,NULL,NULL,'2024-02-28 14:43:03','2024-02-28 14:43:03');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `group_menu`
--

CREATE TABLE `group_menu` (
  `group_id` bigint unsigned NOT NULL,
  `menu_id` bigint unsigned NOT NULL,
  KEY `group_menu_group_id_foreign` (`group_id`),
  KEY `group_menu_menu_id_foreign` (`menu_id`),
  CONSTRAINT `group_menu_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `group_menu_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_menu`
--


--
-- Table structure for table `group_post`
--

CREATE TABLE `group_post` (
  `group_id` bigint unsigned NOT NULL,
  `post_id` bigint unsigned NOT NULL,
  KEY `group_post_group_id_foreign` (`group_id`),
  KEY `group_post_post_id_foreign` (`post_id`),
  CONSTRAINT `group_post_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `group_post_post_id_foreign` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_post`
--


--
-- Table structure for table `group_user`
--

CREATE TABLE `group_user` (
  `group_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  KEY `group_user_group_id_foreign` (`group_id`),
  KEY `group_user_user_id_foreign` (`user_id`),
  CONSTRAINT `group_user_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  CONSTRAINT `group_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_user`
--

INSERT INTO `group_user` VALUES (1,3),(2,3),(1,4),(2,4);

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` tinytext COLLATE utf8mb4_unicode_ci,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` VALUES (1,'office',NULL,'public_ro','read_only',NULL,NULL,1,1,'2023-12-11 15:19:14','2023-12-11 15:28:16'),(2,'decision-maker',NULL,'public_ro','read_only',NULL,NULL,1,NULL,'2023-12-11 15:28:42','2023-12-11 15:28:42'),(3,'secretary',NULL,'public_ro','read_only',NULL,NULL,1,NULL,'2023-12-21 10:22:36','2023-12-21 10:22:36');

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `layout_items`
--

CREATE TABLE `layout_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `layout_itemable_id` bigint unsigned DEFAULT NULL,
  `layout_itemable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_nb` smallint unsigned NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `data` json DEFAULT NULL,
  `order` tinyint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `layout_items`
--


--
-- Table structure for table `membership_attestations`
--

CREATE TABLE `membership_attestations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `licence_id` bigint unsigned DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_attestations`
--

INSERT INTO `membership_attestations` VALUES (1,1,'2025-03-17','2023-12-11 14:22:18','2023-12-11 14:22:18'),(2,1,'2025-02-13','2023-12-11 14:22:18','2023-12-11 14:22:18');

--
-- Table structure for table `membership_insurances`
--

CREATE TABLE `membership_insurances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_insurances`
--


--
-- Table structure for table `membership_jurisdictions`
--

CREATE TABLE `membership_jurisdictions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_jurisdictions`
--

INSERT INTO `membership_jurisdictions` VALUES (1,'appeal_court','Agen'),(2,'appeal_court','Aix en Provence'),(3,'appeal_court','Amiens'),(4,'appeal_court','Angers'),(5,'appeal_court','Basse Terre'),(6,'appeal_court','Bastia'),(7,'appeal_court','Besançon'),(8,'appeal_court','Bordeaux'),(9,'appeal_court','Bourges'),(10,'appeal_court','Caen'),(11,'appeal_court','Cayenne'),(12,'appeal_court','Chambéry'),(13,'appeal_court','Colmar'),(14,'appeal_court','Dijon'),(15,'appeal_court','Douai'),(16,'appeal_court','Fort de France'),(17,'appeal_court','Grenoble'),(18,'appeal_court','Limoges'),(19,'appeal_court','Lyon'),(20,'appeal_court','Metz'),(21,'appeal_court','Montpellier'),(22,'appeal_court','Nancy'),(23,'appeal_court','Nîmes'),(24,'appeal_court','Nouméa'),(25,'appeal_court','Orléans'),(26,'appeal_court','Papeete'),(27,'appeal_court','Paris'),(28,'appeal_court','Pau'),(29,'appeal_court','Poitiers'),(30,'appeal_court','Reims'),(31,'appeal_court','Rennes'),(32,'appeal_court','Riom'),(33,'appeal_court','Rouen'),(34,'appeal_court','Saint Denis'),(35,'appeal_court','Saint Pierre'),(36,'appeal_court','Toulouse'),(37,'appeal_court','Versailles'),(38,'court','Section Détachée du Tribunal de Première Instance à Koné'),(39,'court','Section Détachée du Tribunal de Première Instance à Lifou'),(40,'court','Section Détachée du Tribunal de Première Instance à Nuku-Hiva'),(41,'court','Section Détachée du Tribunal de Première Instance à Raïatéa'),(42,'court','Tribunal judiciaire d\'Agen'),(43,'court','Tribunal judiciaire d\'Aix-en-Provence'),(44,'court','Tribunal judiciaire d\'Ajaccio'),(45,'court','Tribunal judiciaire d\'Albertville'),(46,'court','Tribunal judiciaire d\'Albi'),(47,'court','Tribunal judiciaire d\'Alençon'),(48,'court','Tribunal judiciaire d\'Alès'),(49,'court','Tribunal judiciaire d\'Amiens'),(50,'court','Tribunal judiciaire d\'Angers'),(51,'court','Tribunal judiciaire d\'Angoulême'),(52,'court','Tribunal judiciaire d\'Annecy'),(53,'court','Tribunal judiciaire d\'Argentan'),(54,'court','Tribunal judiciaire d\'Arras'),(55,'court','Tribunal judiciaire d\'Auch'),(56,'court','Tribunal judiciaire d\'Aurillac'),(57,'court','Tribunal judiciaire d\'Auxerre'),(58,'court','Tribunal judiciaire d\'Avesnes-sur-Helpe'),(59,'court','Tribunal judiciaire d\'Avignon'),(60,'court','Tribunal judiciaire de Bar-le-Duc'),(61,'court','Tribunal judiciaire de Basse-Terre'),(62,'court','Tribunal judiciaire de Bastia'),(63,'court','Tribunal judiciaire de Bayonne'),(64,'court','Tribunal judiciaire de Beauvais'),(65,'court','Tribunal judiciaire de Belfort'),(66,'court','Tribunal judiciaire de Bergerac'),(67,'court','Tribunal judiciaire de Besançon'),(68,'court','Tribunal judiciaire de Béthune'),(69,'court','Tribunal judiciaire de Béziers'),(70,'court','Tribunal judiciaire de Blois'),(71,'court','Tribunal judiciaire de Bobigny'),(72,'court','Tribunal judiciaire de Bonneville'),(73,'court','Tribunal judiciaire de Bordeaux'),(74,'court','Tribunal judiciaire de Boulogne-sur-Mer'),(75,'court','Tribunal judiciaire de Bourg-en-Bresse'),(76,'court','Tribunal judiciaire de Bourges'),(77,'court','Tribunal judiciaire de Bourgoin-Jallieu'),(78,'court','Tribunal judiciaire de Brest'),(79,'court','Tribunal judiciaire de Brive-la-Gaillarde'),(80,'court','Tribunal judiciaire de Caen'),(81,'court','Tribunal judiciaire de Cahors'),(82,'court','Tribunal judiciaire de Cambrai'),(83,'court','Tribunal judiciaire de Carcassonne'),(84,'court','Tribunal judiciaire de Carpentras'),(85,'court','Tribunal judiciaire de Castres'),(86,'court','Tribunal judiciaire de Cayenne'),(87,'court','Tribunal judiciaire de Châlons-en-Champagne'),(88,'court','Tribunal judiciaire de Chalon-sur-Saône'),(89,'court','Tribunal judiciaire de Chambéry'),(90,'court','Tribunal judiciaire de Charleville-Mézières'),(91,'court','Tribunal judiciaire de Chartres'),(92,'court','Tribunal judiciaire de Châteauroux'),(93,'court','Tribunal judiciaire de Chaumont'),(94,'court','Tribunal judiciaire de Cherbourg-en-Cotentin'),(95,'court','Tribunal judiciaire de Clermont-Ferrand'),(96,'court','Tribunal judiciaire de Colmar'),(97,'court','Tribunal judiciaire de Compiègne'),(98,'court','Tribunal judiciaire de Coutances'),(99,'court','Tribunal judiciaire de Créteil'),(100,'court','Tribunal judiciaire de Cusset'),(101,'court','Tribunal judiciaire de Dax'),(102,'court','Tribunal judiciaire de Dieppe'),(103,'court','Tribunal judiciaire de Digne-les-Bains'),(104,'court','Tribunal judiciaire de Dijon'),(105,'court','Tribunal judiciaire de Douai'),(106,'court','Tribunal judiciaire de Draguignan'),(107,'court','Tribunal judiciaire de Dunkerque'),(108,'court','Tribunal judiciaire d\'Epinal'),(109,'court','Tribunal judiciaire d\'Evreux'),(110,'court','Tribunal judiciaire d\'Évry-Courcouronnes'),(111,'court','Tribunal judiciaire de Foix'),(112,'court','Tribunal judiciaire de Fontainebleau'),(113,'court','Tribunal judiciaire de Fort-de-France'),(114,'court','Tribunal judiciaire de Gap'),(115,'court','Tribunal judiciaire de Grasse'),(116,'court','Tribunal judiciaire de Grenoble'),(117,'court','Tribunal judiciaire de Guéret'),(118,'court','Tribunal judiciaire du Havre'),(119,'court','Tribunal judiciaire de Laon'),(120,'court','Tribunal judiciaire de La Rochelle'),(121,'court','Tribunal judiciaire de La Roche-sur-Yon'),(122,'court','Tribunal judiciaire de Laval'),(123,'court','Tribunal judiciaire de Libourne'),(124,'court','Tribunal judiciaire de Lille'),(125,'court','Tribunal judiciaire de Limoges'),(126,'court','Tribunal judiciaire de Lisieux'),(127,'court','Tribunal judiciaire de Lons-le-Saunier'),(128,'court','Tribunal judiciaire de Lorient'),(129,'court','Tribunal judiciaire de Lyon'),(130,'court','Tribunal judiciaire de Mâcon'),(131,'court','Tribunal judiciaire de Mamoudzou'),(132,'court','Tribunal judiciaire du Mans'),(133,'court','Tribunal judiciaire de Marseille'),(134,'court','Tribunal judiciaire de Meaux'),(135,'court','Tribunal judiciaire de Melun'),(136,'court','Tribunal judiciaire de Mende'),(137,'court','Tribunal judiciaire de Metz'),(138,'court','Tribunal judiciaire de Montargis'),(139,'court','Tribunal judiciaire de Montauban'),(140,'court','Tribunal judiciaire de Montbéliard'),(141,'court','Tribunal judiciaire de Mont-de-Marsan'),(142,'court','Tribunal judiciaire de Montluçon'),(143,'court','Tribunal judiciaire de Montpellier'),(144,'court','Tribunal judiciaire de Moulins'),(145,'court','Tribunal judiciaire de Mulhouse'),(146,'court','Tribunal judiciaire de Nancy'),(147,'court','Tribunal judiciaire de Nanterre'),(148,'court','Tribunal judiciaire de Nantes'),(149,'court','Tribunal judiciaire de Narbonne'),(150,'court','Tribunal judiciaire de Nevers'),(151,'court','Tribunal judiciaire de Nice'),(152,'court','Tribunal judiciaire de Nîmes'),(153,'court','Tribunal judiciaire de Niort'),(154,'court','Tribunal judiciaire d\'Orléans'),(155,'court','Tribunal judiciaire de Paris'),(156,'court','Tribunal judiciaire de Pau'),(157,'court','Tribunal judiciaire de Périgueux'),(158,'court','Tribunal judiciaire de Perpignan'),(159,'court','Tribunal judiciaire de Pointe-à-Pitre'),(160,'court','Tribunal judiciaire de Poitiers'),(161,'court','Tribunal judiciaire de Pontoise'),(162,'court','Tribunal judiciaire de Privas'),(163,'court','Tribunal judiciaire du Puy-en-Velay'),(164,'court','Tribunal judiciaire de Quimper'),(165,'court','Tribunal judiciaire de Reims'),(166,'court','Tribunal judiciaire de Rennes'),(167,'court','Tribunal judiciaire de Roanne'),(168,'court','Tribunal judiciaire de Rodez'),(169,'court','Tribunal judiciaire de Rouen'),(170,'court','Tribunal judiciaire des Sables-d\'Olonne'),(171,'court','Tribunal judiciaire de Saint-Brieuc'),(172,'court','Tribunal judiciaire de Saint-Denis-de-La-Réunion'),(173,'court','Tribunal judiciaire de Saintes'),(174,'court','Tribunal judiciaire de Saint-Etienne'),(175,'court','Tribunal judiciaire de Saint-Malo'),(176,'court','Tribunal judiciaire de Saint-Nazaire'),(177,'court','Tribunal judiciaire de Saint-Omer'),(178,'court','Tribunal judiciaire de Saint-Pierre'),(179,'court','Tribunal judiciaire de Saint-Quentin'),(180,'court','Tribunal judiciaire de Sarreguemines'),(181,'court','Tribunal judiciaire de Saumur'),(182,'court','Tribunal judiciaire de Saverne'),(183,'court','Tribunal judiciaire de Senlis'),(184,'court','Tribunal judiciaire de Sens'),(185,'court','Tribunal judiciaire de Soissons'),(186,'court','Tribunal judiciaire de St Gaudens'),(187,'court','Tribunal judiciaire de Strasbourg'),(188,'court','Tribunal judiciaire de Tarascon'),(189,'court','Tribunal judiciaire de Tarbes'),(190,'court','Tribunal judiciaire de Thionville'),(191,'court','Tribunal judiciaire de Thonon-les-Bains'),(192,'court','Tribunal judiciaire de Toulon'),(193,'court','Tribunal judiciaire de Toulouse'),(194,'court','Tribunal judiciaire de Tours'),(195,'court','Tribunal judiciaire de Troyes'),(196,'court','Tribunal judiciaire de Tulle'),(197,'court','Tribunal judiciaire de Val de Briey'),(198,'court','Tribunal judiciaire de Valence'),(199,'court','Tribunal judiciaire de Valenciennes'),(200,'court','Tribunal judiciaire de Vannes'),(201,'court','Tribunal judiciaire de Verdun'),(202,'court','Tribunal judiciaire de Versailles'),(203,'court','Tribunal judiciaire de Vesoul'),(204,'court','Tribunal judiciaire de Vienne'),(205,'court','Tribunal judiciaire de Villefranche-sur-Saône'),(206,'court','Tribunal de Première Instance de Mata-Utu'),(207,'court','Tribunal de Première Instance de Nouméa'),(208,'court','Tribunal de Première Instance de Papeete'),(209,'court','Tribunal de Première Instance de Saint-Pierre-et-Miquelon');

--
-- Table structure for table `membership_languages`
--

CREATE TABLE `membership_languages` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `alpha_2` char(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alpha_3` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `published` tinyint(1) NOT NULL,
  `fr` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_languages`
--

INSERT INTO `membership_languages` VALUES (1,'ab','abk',0,'Abkhaze'),(2,'aa','aar',0,'Afar'),(3,'af','afr',1,'Afrikaans'),(4,'ak','aka',0,'Akan'),(5,'sq','sqi',1,'Albanais'),(6,'am','amh',1,'Amharique'),(7,'ar','ara',1,'Arabe'),(8,'an','arg',0,'Aragonais'),(9,'hy','hye',1,'Arménien'),(10,'as','asm',0,'Assamais'),(11,'av','ava',0,'Avar'),(12,'ae','ave',0,'Avestique'),(13,'ay','aym',0,'Aymara'),(14,'az','aze',1,'Azéri'),(15,'bm','bam',0,'Bambara'),(16,'ba','bak',0,'Bachkir'),(17,'eu','eus',0,'Basque'),(18,'be','bel',1,'Biélorusse'),(19,'bn','ben',1,'Bengali'),(20,'bh','bih',0,'Bihari'),(21,'bi','bis',0,'Bichelamar'),(22,'bs','bos',0,'Bosnien'),(23,'br','bre',0,'Breton'),(24,'bg','bul',1,'Bulgare'),(25,'my','mya',1,'Birman'),(26,'ca','cat',1,'Catalan'),(27,'ch','cha',0,'Chamorro'),(28,'ce','che',1,'Tchétchène'),(29,'ny','nya',0,'Chichewa'),(30,'zh','zho',0,'Chinois'),(31,'cv','chv',0,'Tchouvache'),(32,'kw','cor',0,'Cornique'),(33,'co','cos',0,'Corse'),(34,'cr','cre',0,'Cri'),(35,'hr','hrv',1,'Croate'),(36,'cs','ces',1,'Tchèque'),(37,'da','dan',1,'Danois'),(38,'dv','div',0,'Maldivien'),(39,'nl','nld',1,'Néerlandais'),(40,'dz','dzo',0,'Dzongkha'),(41,'en','eng',1,'Anglais'),(42,'eo','epo',0,'Espéranto'),(43,'et','est',1,'Estonien'),(44,'ee','ewe',0,'Ewe'),(45,'fo','fao',0,'Féroïen'),(46,'fj','fij',0,'Fidjien'),(47,'fi','fin',1,'Finnois'),(48,'fr','fra',1,'Français'),(49,'ff','ful',1,'Peul'),(50,'gl','glg',0,'Galicien'),(51,'lg','lug',0,'Ganda'),(52,'ka','kat',1,'Géorgien'),(53,'de','deu',1,'Allemand'),(54,'el','ell',1,'Grec moderne'),(55,'kl','kal',0,'Groenlandais'),(56,'gn','grn',0,'Guarani'),(57,'gu','guj',1,'Gujarati'),(58,'ht','hat',1,'Créole haïtien'),(59,'ha','hau',1,'Haoussa'),(60,'he','heb',1,'Hébreu'),(61,'hz','her',0,'Héréro'),(62,'hi','hin',1,'Hindi'),(63,'ho','hmo',0,'Hiri motu'),(64,'hu','hun',1,'Hongrois'),(65,'is','isl',1,'Islandais'),(66,'io','ido',0,'Ido'),(67,'ig','ibo',1,'Igbo'),(68,'id','ind',1,'Indonésien'),(69,'ia','ina',0,'Interlingua'),(70,'ie','ile',0,'Occidental'),(71,'iu','iku',0,'Inuktitut'),(72,'ik','ipk',0,'Inupiak'),(73,'ga','gle',0,'Irlandais'),(74,'it','ita',1,'Italien'),(75,'ja','jpn',1,'Japonais'),(76,'jv','jav',1,'Javanais'),(77,'kn','kan',1,'Kannada'),(78,'kr','kau',0,'Kanouri'),(79,'ks','kas',0,'Cachemiri'),(80,'kk','kaz',1,'Kazakh'),(81,'km','khm',1,'Khmer'),(82,'ki','kik',0,'Kikuyu'),(83,'rw','kin',0,'Kinyarwanda'),(84,'ky','kir',1,'Kirghiz'),(85,'rn','run',0,'Kirundi'),(86,'kv','kom',0,'Komi'),(87,'kg','kon',0,'Kikongo'),(88,'ko','kor',1,'Coréen'),(89,'ku','kur',1,'Kurde'),(90,'kj','kua',0,'Kuanyama'),(91,'lo','lao',1,'Lao'),(92,'la','lat',1,'Latin'),(93,'lv','lav',1,'Letton'),(94,'li','lim',0,'Limbourgeois'),(95,'ln','lin',0,'Lingala'),(96,'lt','lit',1,'Lituanien'),(97,'lu','lub',0,'Luba'),(98,'lb','ltz',0,'Luxembourgeois'),(99,'mk','mkd',1,'Macédonien'),(100,'mg','mlg',1,'Malgache'),(101,'ms','msa',1,'Malais'),(102,'ml','mal',1,'Malayalam'),(103,'mt','mlt',0,'Maltais'),(104,'gv','glv',0,'Mannois'),(105,'mi','mri',0,'Maori de Nouvelle-Zélande'),(106,'mr','mar',1,'Marathi'),(107,'mh','mah',0,'Marshallais'),(108,'mo','mol',1,'Moldave'),(109,'mn','mon',1,'Mongol'),(110,'na','nau',0,'Nauruan'),(111,'nv','nav',0,'Navajo'),(112,'ng','ndo',0,'Ndonga'),(113,'ne','nep',1,'Népalais'),(114,'nd','nde',0,'Sindebele'),(115,'se','sme',0,'Same du Nord'),(116,'no','nor',1,'Norvégien'),(117,'nb','nob',0,'Norvégien Bokmål'),(118,'nn','nno',0,'Norvégien Nynorsk'),(119,'oc','oci',0,'Occitan'),(120,'oj','oji',0,'Ojibwé'),(121,'cu','chu',0,'Vieux-slave'),(122,'or','ori',1,'Oriya'),(123,'om','orm',1,'Oromo'),(124,'os','oss',0,'Ossète'),(125,'pi','pli',0,'Pali'),(126,'pa','pan',1,'Pendjabi'),(127,'ps','pus',1,'Pachto'),(128,'fa','fas',1,'Persan'),(129,'pl','pol',1,'Polonais'),(130,'pt','por',1,'Portugais'),(131,'qu','que',0,'Quechua'),(132,'rc','rcf',1,'Créole Réunionnais'),(133,'ro','ron',1,'Roumain'),(134,'rm','roh',0,'Romanche'),(135,'ru','rus',1,'Russe'),(136,'sm','smo',0,'Samoan'),(137,'sg','sag',0,'Sango'),(138,'sa','san',0,'Sanskrit'),(139,'sc','srd',0,'Sarde'),(140,'gd','gla',0,'Écossais'),(141,'sr','srp',1,'Serbe'),(142,'sh','hbs',1,'Serbo-croate'),(143,'sn','sna',0,'Shona'),(144,'ii','iii',0,'Yi'),(145,'sd','snd',1,'Sindhi'),(146,'si','sin',1,'Cingalais'),(147,'sk','slk',1,'Slovaque'),(148,'sl','slv',0,'Slovène'),(149,'so','som',1,'Somali'),(150,'st','sot',0,'Sotho du Sud'),(151,'nr','nbl',0,'Nrebele'),(152,'es','spa',1,'Espagnol'),(153,'su','sun',1,'Soundanais'),(154,'sw','swa',1,'Swahili'),(155,'ss','ssw',0,'Swati'),(156,'sv','swe',1,'Suédois'),(157,'tl','tgl',1,'Tagalog'),(158,'ty','tah',0,'Tahitien'),(159,'tg','tgk',0,'Tadjik'),(160,'ta','tam',1,'Tamoul'),(161,'tt','tat',1,'Tatar'),(162,'te','tel',1,'Télougou'),(163,'th','tha',1,'Thaï'),(164,'bo','bod',1,'Tibétain'),(165,'ti','tir',0,'Tigrigna'),(166,'to','ton',0,'Tongien'),(167,'ts','tso',0,'Tsonga'),(168,'tn','tsn',0,'Tswana'),(169,'tr','tur',1,'Turc'),(170,'tk','tuk',1,'Turkmène'),(171,'tw','twi',0,'Twi'),(172,'ug','uig',0,'Ouïghour'),(173,'uk','ukr',1,'Ukrainien'),(174,'ur','urd',1,'Ourdou'),(175,'uz','uzb',1,'Ouzbek'),(176,'ve','ven',0,'Venda'),(177,'vi','vie',1,'Vietnamien'),(178,'vo','vol',0,'Volapük'),(179,'wa','wln',0,'Wallon'),(180,'cy','cym',0,'Gallois'),(181,'fy','fry',0,'Frison occidental'),(182,'wo','wol',1,'Wolof'),(183,'xh','xho',0,'Xhosa'),(184,'yi','yid',0,'Yiddish'),(185,'yo','yor',1,'Yoruba'),(186,'za','zha',0,'Zhuang'),(187,'zu','zul',1,'Zoulou'),(188,'zh','cmn',1,'Mandarin'),(189,'zh','yue',1,'Cantonais'),(190,'zh','nan',1,'Minnan'),(191,'zh','wuu',1,'Wu'),(192,'ar','arz',1,'Arabe égyptien'),(193,'','bho',1,'Bhodjpouri'),(194,'','phi',1,'Philippin'),(195,'xx','ber',1,'Berbère'),(196,'xx','dyu',1,'Dioula'),(197,'xx','ira',1,'Iranien'),(198,'xx','kab',1,'Kabyle'),(199,'xx','mai',1,'Maithili'),(200,'xx','snk',1,'Soninke'),(201,'xx','fon',1,'Fon');

--
-- Table structure for table `membership_licences`
--

CREATE TABLE `membership_licences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `membership_id` bigint unsigned DEFAULT NULL,
  `jurisdiction_id` bigint unsigned DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `since` smallint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_licences`
--

INSERT INTO `membership_licences` VALUES (1,1,9,'expert',2016,'2023-12-11 14:22:18','2023-12-30 05:28:48');

--
-- Table structure for table `membership_sharings`
--

CREATE TABLE `membership_sharings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` tinytext COLLATE utf8mb4_unicode_ci,
  `licence_types` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `courts` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appeal_courts` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_emails` tinyint(1) NOT NULL DEFAULT '0',
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_sharings`
--

INSERT INTO `membership_sharings` VALUES (1,'Document to share',NULL,'expert,ceseda',NULL,'9,13',1,'published','public_ro',NULL,NULL,3,NULL,'2024-02-17 15:35:37','2024-02-24 09:42:35'),(2,'Decision makers',NULL,'expert',NULL,NULL,0,'published','public_ro',NULL,NULL,4,NULL,'2024-02-22 13:33:02','2024-02-22 13:33:02');

--
-- Table structure for table `membership_skills`
--

CREATE TABLE `membership_skills` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attestation_id` bigint unsigned DEFAULT NULL,
  `language_id` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interpreter` tinyint(1) DEFAULT NULL,
  `interpreter_cassation` tinyint(1) DEFAULT NULL,
  `translator` tinyint(1) DEFAULT NULL,
  `translator_cassation` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_skills`
--

INSERT INTO `membership_skills` VALUES (1,1,'dan',1,0,1,0),(2,1,'deu',1,0,1,1),(3,2,'eng',1,1,1,0);

--
-- Table structure for table `membership_votes`
--

CREATE TABLE `membership_votes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `membership_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `choice` char(3) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `membership_votes`
--

INSERT INTO `membership_votes` VALUES (1,1,1,'yes','An incident involving a homophobic comment has been brought to my attention.','2023-12-21 13:58:17','2023-12-21 13:58:17'),(2,1,3,'yes','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','2023-12-21 14:31:56','2023-12-21 14:31:56'),(3,2,3,'yes','Lorem ipsum dolor sit ameet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.','2024-03-03 13:26:39','2024-03-03 13:26:39');

--
-- Table structure for table `memberships`
--

CREATE TABLE `memberships` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public_ro',
  `member_list` tinyint(1) NOT NULL DEFAULT '1',
  `sending_emails` tinyint(1) NOT NULL DEFAULT '0',
  `member_since` timestamp NULL DEFAULT NULL,
  `member_number` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `associated_member` tinyint(1) NOT NULL DEFAULT '0',
  `free_period` tinyint(1) NOT NULL DEFAULT '0',
  `insurance_code` char(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `professional_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `professional_status_info` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `since` smallint unsigned DEFAULT NULL,
  `siret_number` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `naf_code` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linguistic_training` text COLLATE utf8mb4_unicode_ci,
  `extra_linguistic_training` text COLLATE utf8mb4_unicode_ci,
  `professional_experience` text COLLATE utf8mb4_unicode_ci,
  `observations` text COLLATE utf8mb4_unicode_ci,
  `why_expertij` text COLLATE utf8mb4_unicode_ci,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `memberships`
--

INSERT INTO `memberships` VALUES (1,2,'member','public_ro',1,1,'2024-01-06 07:23:35','2024-1-E',0,0,'f4','liberal_profession',NULL,2017,'36252187900034','4932Z','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.','Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',NULL,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.',NULL,NULL,2,1,'2023-12-11 14:22:18','2024-03-11 15:24:59'),(2,5,'pending_renewal','public_ro',0,0,'2024-03-07 09:27:57','2024-2-MA',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,1,'2024-03-03 10:29:12','2024-03-12 09:18:34');

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL,
  `menu_code` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anchor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `_lft` int unsigned NOT NULL DEFAULT '0',
  `_rgt` int unsigned NOT NULL DEFAULT '0',
  `parent_id` int unsigned DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_items__lft__rgt_parent_id_index` (`_lft`,`_rgt`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` VALUES (1,'Root','root','root',NULL,NULL,NULL,'published',1,10,NULL,NULL,NULL,NULL,'2023-12-11 09:11:42','2023-12-11 09:11:42'),(2,'Home','main-menu','/',NULL,NULL,NULL,'published',2,3,1,NULL,NULL,NULL,'2023-12-11 09:11:42','2023-12-11 09:11:42'),(3,'Registration','main-menu','/memberships/create',NULL,NULL,NULL,'published',4,5,1,NULL,NULL,1,'2023-12-11 10:22:10','2023-12-11 10:24:09'),(4,'Liste des membres','main-menu','/memberships/members',NULL,NULL,NULL,'published',6,7,1,NULL,NULL,NULL,'2024-03-05 05:37:44','2024-03-05 05:37:44'),(5,'Liste des membres associés','main-menu','/memberships/associated',NULL,NULL,NULL,'published',8,9,1,NULL,NULL,NULL,'2024-03-07 05:52:31','2024-03-07 05:52:31');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,'Main menu','main-menu','published','public_rw',NULL,NULL,1,NULL,'2023-12-11 09:11:42','2023-12-11 09:11:42');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2020_05_05_060229_create_permission_tables',1),(6,'2021_05_30_051729_create_groups_table',1),(7,'2021_05_31_051829_create_group_user_table',1),(8,'2021_06_16_045540_create_settings_table',1),(9,'2021_06_24_151612_create_documents_table',1),(10,'2021_07_05_091208_create_emails_table',1),(11,'2021_08_01_115731_update_roles_table',1),(12,'2021_08_25_075701_create_posts_table',1),(13,'2021_09_04_063252_create_group_post_table',1),(14,'2021_09_25_083336_create_menus_table',1),(15,'2021_09_25_083350_create_menu_items_table',1),(16,'2021_09_26_073254_create_group_menu_table',1),(17,'2021_10_29_050634_create_post_settings_table',1),(18,'2021_11_12_084927_update_users_table',1),(19,'2021_11_27_062746_api_token_users_table',1),(20,'2022_04_04_140355_add_login_fields_to_users_table',1),(21,'2022_06_24_152055_create_contacts_table',1),(22,'2022_10_07_091428_create_layout_items_table',1),(23,'2023_08_25_073024_create_comments_table',1),(24,'2023_08_26_150803_create_categories_table',1),(25,'2023_08_26_150950_create_categorizables_table',1),(26,'2023_08_26_152956_create_category_group_table',1),(27,'2023_08_27_043244_create_orders_table',1),(28,'2023_09_10_074946_update_membership_users_table',1),(29,'2023_09_12_060553_create_memberships_table',1),(30,'2023_09_12_060717_create_licences_table',1),(31,'2023_09_12_060819_create_skills_table',1),(32,'2023_09_12_060839_create_insurances_table',1),(33,'2023_09_12_060858_create_votes_table',1),(34,'2023_09_12_060920_create_languages_table',1),(35,'2023_09_12_060946_create_jurisdictions_table',1),(36,'2023_09_12_061030_create_citizenships_table',1),(37,'2023_09_12_061050_create_addresses_table',1),(38,'2023_09_12_061105_create_payments_table',1),(39,'2023_09_12_073601_create_membership_settings_table',1),(40,'2023_09_13_083747_create_countries_table',1),(41,'2023_09_18_083838_create_attestations_table',1),(42,'2024_02_01_153729_create_jobs_table',2),(43,'2024_02_12_085822_create_membership_sharings_table',2);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(5,'App\\Models\\User',2),(4,'App\\Models\\User',3),(4,'App\\Models\\User',4),(5,'App\\Models\\User',5);

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `orderable_id` int unsigned DEFAULT NULL,
  `orderable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_order` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payable_id` int unsigned DEFAULT NULL,
  `payable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mode` char(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `item` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(5,2) NOT NULL,
  `currency` char(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `data` text COLLATE utf8mb4_unicode_ci,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` VALUES (1,1,'App\\Models\\Membership','completed','bank_transfer','subscription',70.00,'EUR',NULL,NULL,'OFFL65967d6c9238a','2024-01-04 09:42:04','2024-03-09 06:21:58'),(3,1,'App\\Models\\Membership','completed','cheque','insurance_f5',70.00,'EUR',NULL,NULL,'OFFL65c1ca1858159','2024-02-06 05:56:40','2024-03-09 06:21:58'),(4,2,'App\\Models\\Membership','completed','bank_transfer','subscription',30.00,'EUR',NULL,NULL,'OFFL65e9886cc0897','2024-03-07 09:27:08','2024-03-09 06:21:58'),(5,1,'App\\Models\\Membership','completed','cheque','subscription_insurance_f4',70.00,'EUR',NULL,NULL,'OFFL65ec1052be62c','2024-03-09 07:31:30','2024-03-09 09:04:39');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'create-users','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(2,'update-users','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(3,'delete-users','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(4,'create-user-groups','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(5,'update-user-groups','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(6,'delete-user-groups','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(7,'create-user-roles','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(8,'update-user-roles','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(9,'delete-user-roles','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(10,'create-menus','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(11,'update-menus','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(12,'delete-menus','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(13,'create-posts','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(14,'update-posts','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(15,'delete-posts','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(16,'create-post-categories','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(17,'update-post-categories','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(18,'delete-post-categories','web','2024-02-12 07:16:19','2024-02-12 07:16:19'),(19,'update-post-settings','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(20,'create-memberships','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(21,'update-memberships','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(22,'delete-memberships','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(23,'create-membership-sharings','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(24,'update-membership-settings','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(25,'global-settings','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(26,'update-emails','web','2024-02-12 07:16:20','2024-02-12 07:16:20'),(27,'access-dashboard','web','2024-02-12 07:16:20','2024-02-12 07:16:20');

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `raw_content` text COLLATE utf8mb4_unicode_ci,
  `excerpt` text COLLATE utf8mb4_unicode_ci,
  `status` char(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `main_cat_id` bigint unsigned DEFAULT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_img` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extra_fields` json DEFAULT NULL,
  `meta_data` json DEFAULT NULL,
  `settings` json NOT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT 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;

--
-- Dumping data for table `posts`
--


--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(8,2),(9,2),(10,2),(11,2),(12,2),(13,2),(14,2),(15,2),(16,2),(17,2),(18,2),(20,2),(21,2),(22,2),(23,2),(27,2),(1,3),(2,3),(3,3),(4,3),(5,3),(6,3),(13,3),(14,3),(15,3),(20,3),(21,3),(22,3),(23,3),(27,3),(13,4),(14,4),(15,4),(20,4),(21,4),(22,4),(23,4),(27,4),(13,5),(14,5),(15,5),(20,5),(21,5),(23,5);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_level` char(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_level` tinyint DEFAULT NULL,
  `role_type` char(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `checked_out` bigint unsigned DEFAULT NULL,
  `checked_out_time` timestamp NULL DEFAULT NULL,
  `owned_by` bigint unsigned NOT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'super-admin','web','public_ro',5,'super-admin',NULL,NULL,1,NULL,'2023-12-11 09:11:43','2023-12-11 09:11:43'),(2,'admin','web','public_ro',4,'admin',NULL,NULL,1,NULL,'2023-12-11 09:11:43','2023-12-11 09:11:43'),(3,'manager','web','public_ro',3,'manager',NULL,NULL,1,NULL,'2023-12-11 09:11:43','2023-12-11 09:11:43'),(4,'assistant','web','public_ro',2,'assistant',NULL,NULL,1,NULL,'2023-12-11 09:11:43','2023-12-11 09:11:43'),(5,'registered','web','public_ro',1,'registered',NULL,NULL,1,NULL,'2023-12-11 09:11:43','2023-12-11 09:11:43');


