
--
-- Table structure for table `index_stats`
--

CREATE TABLE `index_stats` (
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `index_name` varchar(64) NOT NULL,
  `prefix_arity` int(11) unsigned NOT NULL,
  `avg_frequency` decimal(12,4) DEFAULT NULL,
  PRIMARY KEY (`db_name`,`table_name`,`index_name`,`prefix_arity`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=0 COMMENT='Statistics on Indexes';

--
-- Dumping data for table `index_stats`
--


--
-- Table structure for table `innodb_index_stats`
--

CREATE TABLE `innodb_index_stats` (
  `database_name` varchar(64) NOT NULL,
  `table_name` varchar(199) NOT NULL,
  `index_name` varchar(64) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `stat_name` varchar(64) NOT NULL,
  `stat_value` bigint(20) unsigned NOT NULL,
  `sample_size` bigint(20) unsigned DEFAULT NULL,
  `stat_description` varchar(1024) NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

--
-- Table structure for table `innodb_table_stats`
--

CREATE TABLE `innodb_table_stats` (
  `database_name` varchar(64) NOT NULL,
  `table_name` varchar(199) NOT NULL,
  `last_update` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `n_rows` bigint(20) unsigned NOT NULL,
  `clustered_index_size` bigint(20) unsigned NOT NULL,
  `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--


--
-- Table structure for table `proc`
--

CREATE TABLE `proc` (
  `db` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `name` char(64) NOT NULL DEFAULT '',
  `type` enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') NOT NULL,
  `specific_name` char(64) NOT NULL DEFAULT '',
  `language` enum('SQL') NOT NULL DEFAULT 'SQL',
  `sql_data_access` enum('CONTAINS_SQL','NO_SQL','READS_SQL_DATA','MODIFIES_SQL_DATA') NOT NULL DEFAULT 'CONTAINS_SQL',
  `is_deterministic` enum('YES','NO') NOT NULL DEFAULT 'NO',
  `security_type` enum('INVOKER','DEFINER') NOT NULL DEFAULT 'DEFINER',
  `param_list` blob NOT NULL,
  `returns` longblob NOT NULL,
  `body` longblob NOT NULL,
  `definer` char(141) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sql_mode` set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','EMPTY_STRING_IS_NULL','SIMULTANEOUS_ASSIGNMENT','TIME_ROUND_FRACTIONAL') NOT NULL DEFAULT '',
  `comment` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `character_set_client` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `collation_connection` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `db_collation` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `body_utf8` longblob DEFAULT NULL,
  `aggregate` enum('NONE','GROUP') NOT NULL DEFAULT 'NONE',
  PRIMARY KEY (`db`,`name`,`type`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Stored Procedures';

--
-- Dumping data for table `proc`
--

INSERT INTO `proc` VALUES ('mysql','AddGeometryColumn','PROCEDURE','AddGeometryColumn','SQL','CONTAINS_SQL','NO','INVOKER','catalog varchar(64), t_schema varchar(64),\n   t_name varchar(64), geometry_column varchar(64), t_srid int','','begin\n  set @qwe= concat(\'ALTER TABLE \', t_schema, \'.\', t_name, \' ADD \', geometry_column,\' GEOMETRY REF_SYSTEM_ID=\', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end','mariadb.sys@localhost','2023-10-23 15:39:43','2023-07-27 16:23:21','','','utf8','utf8_general_ci','latin1_swedish_ci','begin\n  set @qwe= concat(\'ALTER TABLE \', t_schema, \'.\', t_name, \' ADD \', geometry_column,\' GEOMETRY REF_SYSTEM_ID=\', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end','NONE'),('mysql','DropGeometryColumn','PROCEDURE','DropGeometryColumn','SQL','CONTAINS_SQL','NO','INVOKER','catalog varchar(64), t_schema varchar(64),\n   t_name varchar(64), geometry_column varchar(64)','','begin\n  set @qwe= concat(\'ALTER TABLE \', t_schema, \'.\', t_name, \' DROP \', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end','mariadb.sys@localhost','2023-10-23 15:39:43','2023-07-27 16:23:21','','','utf8','utf8_general_ci','latin1_swedish_ci','begin\n  set @qwe= concat(\'ALTER TABLE \', t_schema, \'.\', t_name, \' DROP \', geometry_column); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end','NONE');

--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(60) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY') NOT NULL,
  `Grantor` char(141) NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(60) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Proxied_host` char(60) NOT NULL DEFAULT '',
  `Proxied_user` char(80) NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT 0,
  `Grantor` char(141) NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'','2023-07-27 16:23:21'),('lemeon.vps.local','root','','',1,'','2023-07-27 16:23:21');

--
-- Table structure for table `roles_mapping`
--

CREATE TABLE `roles_mapping` (
  `Host` char(60) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Role` char(80) NOT NULL DEFAULT '',
  `Admin_option` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  UNIQUE KEY `Host` (`Host`,`User`,`Role`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Granted roles';

--
-- Dumping data for table `roles_mapping`
--


--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` varchar(2048) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(80) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int(4) NOT NULL DEFAULT 0,
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` varchar(512) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `table_stats`
--

CREATE TABLE `table_stats` (
  `db_name` varchar(64) NOT NULL,
  `table_name` varchar(64) NOT NULL,
  `cardinality` bigint(21) unsigned DEFAULT NULL,
  PRIMARY KEY (`db_name`,`table_name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=0 COMMENT='Statistics on Tables';

--
-- Dumping data for table `table_stats`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(60) NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `User` char(80) NOT NULL DEFAULT '',
  `Table_name` char(64) NOT NULL DEFAULT '',
  `Grantor` char(141) NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger','Delete versioning rows') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_bin PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--

INSERT INTO `tables_priv` VALUES ('localhost','mysql','mariadb.sys','global_priv','root@localhost','0000-00-00 00:00:00','Select,Delete','');

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint(20) NOT NULL,
  `Correction` int(11) NOT NULL,
  PRIMARY KEY (`Transition_time`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_time` bigint(20) NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int(10) unsigned NOT NULL,
  `Transition_type_id` int(10) unsigned NOT NULL,
  `Offset` int(11) NOT NULL DEFAULT 0,
  `Is_DST` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) ENGINE=Aria DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1 TRANSACTIONAL=1 COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Temporary table structure for view `user`
--

/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE VIEW `user` AS SELECT
 1 AS `Host`,
  1 AS `User`,
  1 AS `Password`,
  1 AS `Select_priv`,
  1 AS `Insert_priv`,
  1 AS `Update_priv`,
  1 AS `Delete_priv`,
  1 AS `Create_priv`,
  1 AS `Drop_priv`,
  1 AS `Reload_priv`,
  1 AS `Shutdown_priv`,
  1 AS `Process_priv`,
  1 AS `File_priv`,
  1 AS `Grant_priv`,
  1 AS `References_priv`,
  1 AS `Index_priv`,
  1 AS `Alter_priv`,
  1 AS `Show_db_priv`,
  1 AS `Super_priv`,
  1 AS `Create_tmp_table_priv`,
  1 AS `Lock_tables_priv`,
  1 AS `Execute_priv`,
  1 AS `Repl_slave_priv`,
  1 AS `Repl_client_priv`,
  1 AS `Create_view_priv`,
  1 AS `Show_view_priv`,
  1 AS `Create_routine_priv`,
  1 AS `Alter_routine_priv`,
  1 AS `Create_user_priv`,
  1 AS `Event_priv`,
  1 AS `Trigger_priv`,
  1 AS `Create_tablespace_priv`,
  1 AS `Delete_history_priv`,
  1 AS `ssl_type`,
  1 AS `ssl_cipher`,
  1 AS `x509_issuer`,
  1 AS `x509_subject`,
  1 AS `max_questions`,
  1 AS `max_updates`,
  1 AS `max_connections`,
  1 AS `max_user_connections`,
  1 AS `plugin`,
  1 AS `authentication_string`,
  1 AS `password_expired`,
  1 AS `is_role`,
  1 AS `default_role`,
  1 AS `max_statement_time` */;

--
-- Table structure for table `transaction_registry`
--

CREATE TABLE IF NOT EXISTS `transaction_registry` (
  `transaction_id` bigint(20) unsigned NOT NULL,
  `commit_id` bigint(20) unsigned NOT NULL,
  `begin_timestamp` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `commit_timestamp` timestamp(6) NOT NULL DEFAULT '0000-00-00 00:00:00.000000',
  `isolation_level` enum('READ-UNCOMMITTED','READ-COMMITTED','REPEATABLE-READ','SERIALIZABLE') NOT NULL,
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `commit_id` (`commit_id`),
  KEY `begin_timestamp` (`begin_timestamp`),
  KEY `commit_timestamp` (`commit_timestamp`,`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;

--
-- Current Database: `nom_de_la_base`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `nom_de_la_base` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;

USE `nom_de_la_base`;

--
-- Current Database: `premiertour`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `premiertour` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;

USE `premiertour`;

--
-- Table structure for table `account_emailaddress`
--

CREATE TABLE `account_emailaddress` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(254) NOT NULL,
  `verified` tinyint(1) NOT NULL,
  `primary` tinyint(1) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `account_emailaddress_user_id_email_987c8728_uniq` (`user_id`,`email`),
  CONSTRAINT `account_emailaddress_user_id_2c513194_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `account_emailaddress`
--


--
-- Table structure for table `account_emailconfirmation`
--

CREATE TABLE `account_emailconfirmation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime(6) NOT NULL,
  `sent` datetime(6) DEFAULT NULL,
  `key` varchar(64) NOT NULL,
  `email_address_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `key` (`key`),
  KEY `account_emailconfirm_email_address_id_5b7f8c58_fk_account_e` (`email_address_id`),
  CONSTRAINT `account_emailconfirm_email_address_id_5b7f8c58_fk_account_e` FOREIGN KEY (`email_address_id`) REFERENCES `account_emailaddress` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `account_emailconfirmation`
--


--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `auth_group`
--

INSERT INTO `auth_group` VALUES (2,'admin'),(3,'millitant'),(1,'super_admin');

--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `auth_group_permissions`
--

INSERT INTO `auth_group_permissions` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,1,12),(13,1,13),(14,1,14),(15,1,15),(16,1,16),(17,1,17),(18,1,18),(19,1,19),(20,1,20),(21,1,21),(22,1,22),(23,1,23),(24,1,24),(25,1,25),(26,1,26),(27,1,27),(28,1,28),(29,1,29),(30,1,30),(31,1,31),(32,1,32),(33,1,33),(34,1,34),(35,1,35),(36,1,36),(37,1,37),(38,1,38),(39,1,39),(40,1,40),(41,1,41),(42,1,42),(43,1,43),(44,1,44),(45,1,45),(46,1,46),(47,1,47),(48,1,48),(49,1,49),(50,1,50),(51,1,51),(52,1,52),(53,1,53),(54,1,54),(55,1,55),(56,1,56),(57,2,49),(58,2,50),(59,2,51),(60,2,52),(61,2,53),(62,2,54),(63,2,55),(64,2,56);

--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can view log entry',1,'view_logentry'),(5,'Can add permission',2,'add_permission'),(6,'Can change permission',2,'change_permission'),(7,'Can delete permission',2,'delete_permission'),(8,'Can view permission',2,'view_permission'),(9,'Can add group',3,'add_group'),(10,'Can change group',3,'change_group'),(11,'Can delete group',3,'delete_group'),(12,'Can view group',3,'view_group'),(13,'Can add user',4,'add_user'),(14,'Can change user',4,'change_user'),(15,'Can delete user',4,'delete_user'),(16,'Can view user',4,'view_user'),(17,'Can add event',5,'add_event'),(18,'Can change event',5,'change_event'),(19,'Can delete event',5,'delete_event'),(20,'Can view event',5,'view_event'),(21,'Can add content type',6,'add_contenttype'),(22,'Can change content type',6,'change_contenttype'),(23,'Can delete content type',6,'delete_contenttype'),(24,'Can view content type',6,'view_contenttype'),(25,'Can add session',7,'add_session'),(26,'Can change session',7,'change_session'),(27,'Can delete session',7,'delete_session'),(28,'Can view session',7,'view_session'),(29,'Can add application',8,'add_application'),(30,'Can change application',8,'change_application'),(31,'Can delete application',8,'delete_application'),(32,'Can view application',8,'view_application'),(33,'Can add access token',9,'add_accesstoken'),(34,'Can change access token',9,'change_accesstoken'),(35,'Can delete access token',9,'delete_accesstoken'),(36,'Can view access token',9,'view_accesstoken'),(37,'Can add grant',10,'add_grant'),(38,'Can change grant',10,'change_grant'),(39,'Can delete grant',10,'delete_grant'),(40,'Can view grant',10,'view_grant'),(41,'Can add refresh token',11,'add_refreshtoken'),(42,'Can change refresh token',11,'change_refreshtoken'),(43,'Can delete refresh token',11,'delete_refreshtoken'),(44,'Can view refresh token',11,'view_refreshtoken'),(45,'Can add id token',12,'add_idtoken'),(46,'Can change id token',12,'change_idtoken'),(47,'Can delete id token',12,'delete_idtoken'),(48,'Can view id token',12,'view_idtoken'),(49,'Can add email address',13,'add_emailaddress'),(50,'Can change email address',13,'change_emailaddress'),(51,'Can delete email address',13,'delete_emailaddress'),(52,'Can view email address',13,'view_emailaddress'),(53,'Can add email confirmation',14,'add_emailconfirmation'),(54,'Can change email confirmation',14,'change_emailconfirmation'),(55,'Can delete email confirmation',14,'delete_emailconfirmation'),(56,'Can view email confirmation',14,'view_emailconfirmation'),(57,'Can add social account',15,'add_socialaccount'),(58,'Can change social account',15,'change_socialaccount'),(59,'Can delete social account',15,'delete_socialaccount'),(60,'Can view social account',15,'view_socialaccount'),(61,'Can add social application',16,'add_socialapp'),(62,'Can change social application',16,'change_socialapp'),(63,'Can delete social application',16,'delete_socialapp'),(64,'Can view social application',16,'view_socialapp'),(65,'Can add social application token',17,'add_socialtoken'),(66,'Can change social application token',17,'change_socialtoken'),(67,'Can delete social application token',17,'delete_socialtoken'),(68,'Can view social application token',17,'view_socialtoken'),(69,'Can add Token',18,'add_token'),(70,'Can change Token',18,'change_token'),(71,'Can delete Token',18,'delete_token'),(72,'Can view Token',18,'view_token'),(73,'Can add token',19,'add_tokenproxy'),(74,'Can change token',19,'change_tokenproxy'),(75,'Can delete token',19,'delete_tokenproxy'),(76,'Can view token',19,'view_tokenproxy'),(77,'Can add message',20,'add_message'),(78,'Can change message',20,'change_message'),(79,'Can delete message',20,'delete_message'),(80,'Can view message',20,'view_message');

--
-- Table structure for table `auth_user`
--

CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `auth_user`
--

INSERT INTO `auth_user` VALUES (1,'pbkdf2_sha256$600000$TE7yTudo3guZ802xoEF9iQ$gbTLfhbv3SIoDogWMD60OPdSBpjIhjOwTHLseZuMt4o=','2023-10-14 13:39:05.561435',1,'gh','Gilles','Hélleué','helleugilles@gmail.com',1,1,'2023-09-18 14:10:34.000000'),(2,'pbkdf2_sha256$600000$xcxEN0a8L7MjZnwGEIVWCQ$gaWeGByRaVoL0UDtSOyVV0UBNjYa4Lq/ZYmOqi50e/I=','2023-10-12 19:30:52.535888',0,'thierry','thierry','Bootstrap','thierry@bootstrap.eu',0,1,'2023-09-18 14:11:35.000000'),(4,'pbkdf2_sha256$600000$h9ImgL39IFxbVqgkZP62JI$PS9vZ4O9zpPJQxT2U5NHjw0+3TB8bqmHf13LdyPfPxk=',NULL,0,'moui','','','moui@gmail.com',0,1,'2023-09-19 13:17:10.887808'),(5,'pbkdf2_sha256$600000$S7KOaMKcnaYSjjHRD57tlO$532LFioLO6nRMvgynZmCPxMDa7A2ptQOTqIHFJF3Z3Q=','2023-09-19 15:20:16.000000',0,'moui2','','','moui2@gmail.com',0,1,'2023-09-19 13:18:04.000000'),(6,'pbkdf2_sha256$600000$U0UMhHgtH5ydqrdrdYOahe$WMlClBYinVkJZtn7PrTqDp91oSapK5r2S+PU0wq7LtI=','2023-09-19 15:00:28.369595',0,'moui3','moui3','','moui3@gmail.com',0,1,'2023-09-19 13:20:33.629977'),(9,'pbkdf2_sha256$600000$Vr3sczBSDY6pxM6wb4r6s3$7I27LEzxcRR7ox1yFjuFP9i94Ms0rSvcaWYc64ALBvY=',NULL,0,'g.clemenceau@gmail.com','Georges ','Clémenceau','g.clemenceau@gmail.com',0,1,'2023-10-09 18:21:31.298825');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `auth_user_groups`
--

INSERT INTO `auth_user_groups` VALUES (1,1,1),(3,2,3),(2,5,3),(6,9,3);

--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `auth_user_user_permissions`
--

INSERT INTO `auth_user_user_permissions` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,1,12),(13,1,13),(14,1,14),(15,1,15),(16,1,16),(17,1,17),(18,1,18),(19,1,19),(20,1,20),(21,1,21),(22,1,22),(23,1,23),(24,1,24),(25,1,25),(26,1,26),(27,1,27),(28,1,28),(29,1,29),(30,1,30),(31,1,31),(32,1,32),(33,1,33),(34,1,34),(35,1,35),(36,1,36),(37,1,37),(38,1,38),(39,1,39),(40,1,40),(41,1,41),(42,1,42),(43,1,43),(44,1,44),(45,1,45),(46,1,46),(47,1,47),(48,1,48),(49,1,49),(50,1,50),(51,1,51),(52,1,52),(53,1,53),(54,1,54),(55,1,55),(56,1,56),(57,1,57),(58,1,58),(59,1,59),(60,1,60),(61,1,61),(62,1,62),(63,1,63),(64,1,64),(65,1,65),(66,1,66),(67,1,67),(68,1,68),(69,1,69),(70,1,70),(71,1,71),(72,1,72),(73,1,73),(74,1,74),(75,1,75),(76,1,76);

--
-- Table structure for table `authtoken_token`
--

CREATE TABLE `authtoken_token` (
  `key` varchar(40) NOT NULL,
  `created` datetime(6) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`key`),
  UNIQUE KEY `user_id` (`user_id`),
  CONSTRAINT `authtoken_token_user_id_35299eff_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `authtoken_token`
--

INSERT INTO `authtoken_token` VALUES ('7196019dc2b63dd11fba3e83ffe2f914ef21e9e3','2023-09-20 10:12:00.866167',1);

--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext DEFAULT NULL,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL CHECK (`action_flag` >= 0),
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` VALUES (1,'2023-09-18 14:11:36.125855','2','thierry',1,'[{\"added\": {}}]',4,1),(2,'2023-09-18 14:12:41.948933','2','thierry',2,'[]',4,1),(3,'2023-09-18 14:49:06.078907','1','premiertour',1,'[{\"added\": {}}]',8,1),(4,'2023-09-18 14:57:32.106861','1','JTI: c9105a2d-7e0e-4a6c-9d05-8171e2ee488a User: 1',1,'[{\"added\": {}}]',12,1),(5,'2023-09-19 07:30:43.447204','2','secondtour',1,'[{\"added\": {}}]',8,1),(6,'2023-09-19 08:50:16.615997','1','super_admin',1,'[{\"added\": {}}]',3,1),(7,'2023-09-19 08:51:11.592624','2','admin',1,'[{\"added\": {}}]',3,1),(8,'2023-09-19 08:51:26.147761','3','millitant',1,'[{\"added\": {}}]',3,1),(9,'2023-09-19 08:52:37.660639','3','millitant',2,'[]',3,1),(10,'2023-09-19 14:16:36.646731','1','gh',2,'[{\"changed\": {\"fields\": [\"First name\", \"Last name\", \"Groups\"]}}]',4,1),(11,'2023-09-19 15:21:46.918440','5','moui2',2,'[{\"changed\": {\"fields\": [\"Groups\"]}}]',4,1),(12,'2023-09-20 14:28:52.378638','1','gh',2,'[{\"changed\": {\"fields\": [\"User permissions\"]}}]',4,1),(13,'2023-09-21 09:33:25.005789','1','gh',2,'[{\"changed\": {\"fields\": [\"Last name\"]}}]',4,1);

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (13,'account','emailaddress'),(14,'account','emailconfirmation'),(1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(18,'authtoken','token'),(19,'authtoken','tokenproxy'),(6,'contenttypes','contenttype'),(9,'oauth2_provider','accesstoken'),(8,'oauth2_provider','application'),(10,'oauth2_provider','grant'),(12,'oauth2_provider','idtoken'),(11,'oauth2_provider','refreshtoken'),(5,'premiertourapp','event'),(20,'premiertourapp','message'),(7,'sessions','session'),(15,'socialaccount','socialaccount'),(16,'socialaccount','socialapp'),(17,'socialaccount','socialtoken');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2023-09-18 14:08:42.410843'),(2,'auth','0001_initial','2023-09-18 14:08:44.960560'),(3,'admin','0001_initial','2023-09-18 14:08:46.656853'),(4,'admin','0002_logentry_remove_auto_add','2023-09-18 14:08:46.997860'),(5,'admin','0003_logentry_add_action_flag_choices','2023-09-18 14:08:47.127149'),(6,'contenttypes','0002_remove_content_type_name','2023-09-18 14:08:47.648765'),(7,'auth','0002_alter_permission_name_max_length','2023-09-18 14:08:47.842185'),(8,'auth','0003_alter_user_email_max_length','2023-09-18 14:08:48.117102'),(9,'auth','0004_alter_user_username_opts','2023-09-18 14:08:48.249781'),(10,'auth','0005_alter_user_last_login_null','2023-09-18 14:08:48.511365'),(11,'auth','0006_require_contenttypes_0002','2023-09-18 14:08:48.633045'),(12,'auth','0007_alter_validators_add_error_messages','2023-09-18 14:08:48.765722'),(13,'auth','0008_alter_user_username_max_length','2023-09-18 14:08:49.036514'),(14,'auth','0009_alter_user_last_name_max_length','2023-09-18 14:08:49.229448'),(15,'auth','0010_alter_group_name_max_length','2023-09-18 14:08:49.421377'),(16,'auth','0011_update_proxy_permissions','2023-09-18 14:08:49.817256'),(17,'auth','0012_alter_user_first_name_max_length','2023-09-18 14:08:50.083302'),(18,'oauth2_provider','0001_initial','2023-09-18 14:08:53.287394'),(19,'oauth2_provider','0002_auto_20190406_1805','2023-09-18 14:08:54.661179'),(20,'oauth2_provider','0003_auto_20201211_1314','2023-09-18 14:08:54.949077'),(21,'oauth2_provider','0004_auto_20200902_2022','2023-09-18 14:08:56.684738'),(22,'oauth2_provider','0005_auto_20211222_2352','2023-09-18 14:09:00.369874'),(23,'oauth2_provider','0006_alter_application_client_secret','2023-09-18 14:09:00.827571'),(24,'oauth2_provider','0007_application_post_logout_redirect_uris','2023-09-18 14:09:01.212133'),(25,'premiertourapp','0001_initial','2023-09-18 14:09:03.586702'),(26,'premiertourapp','0002_delete_userfavorite','2023-09-18 14:09:04.432974'),(27,'premiertourapp','0003_delete_customuser','2023-09-18 14:09:04.822119'),(28,'sessions','0001_initial','2023-09-18 14:09:05.290052'),(29,'account','0001_initial','2023-09-19 08:48:05.077099'),(30,'account','0002_email_max_length','2023-09-19 08:48:05.293426'),(31,'account','0003_alter_emailaddress_create_unique_verified_email','2023-09-19 08:48:05.543164'),(32,'account','0004_alter_emailaddress_drop_unique_email','2023-09-19 08:48:06.161820'),(33,'account','0005_emailaddress_idx_upper_email','2023-09-19 08:48:06.292395'),(34,'premiertourapp','0004_alter_event_id','2023-09-19 08:48:06.491009'),(35,'socialaccount','0001_initial','2023-09-19 10:30:19.255837'),(36,'socialaccount','0002_token_max_lengths','2023-09-19 10:30:19.671962'),(37,'socialaccount','0003_extra_data_default_dict','2023-09-19 10:30:19.808608'),(38,'socialaccount','0004_app_provider_id_settings','2023-09-19 10:30:20.336823'),(39,'socialaccount','0005_socialtoken_nullable_app','2023-09-19 10:30:21.277923'),(40,'authtoken','0001_initial','2023-09-20 09:58:22.513159'),(41,'authtoken','0002_auto_20160226_1747','2023-09-20 09:58:22.674198'),(42,'authtoken','0003_tokenproxy','2023-09-20 09:58:22.793581'),(43,'premiertourapp','0002_message','2023-10-09 18:47:56.229838'),(44,'premiertourapp','0003_message_is_pinned','2023-10-09 18:54:41.975114'),(45,'premiertourapp','0004_alter_message_options_remove_message_pinned','2023-10-09 19:58:07.069408'),(46,'premiertourapp','0005_message_pinned','2023-10-12 16:06:55.081234');

--
-- Table structure for table `django_session`
--

CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `django_session`
--

INSERT INTO `django_session` VALUES ('1gfs6d0zysap9bhkildyf5cih5kb8s7l','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qiwJZ:x5chwT8ihllNj9QN6Ez_HCgpRTve7QS4HaNFK6ej9sk','2023-10-04 12:28:21.049576'),('3rdl9jra3mcnp0el4s54fuzlevwqo10c','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qiwU3:5RLULxB-CsaDvztz_RIpAWTLzrmVqE-Utpecx-r-ef0','2023-10-04 12:39:11.116836'),('6k810g6veixejf2yy4o4kny8c0ui7kuo','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qrZfa:61L3sRZzdGe1eMHlbvc5vo9c9oN-8nSzBb1P9qOj6yg','2023-10-28 08:06:46.290758'),('6o16zjwycg2vwkg3owi7doplrtnlwhkw','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qnJ2z:6dH-352AF6hkRrPykBzesf-7dZH1HnAaBdkA7xSJGPY','2023-10-16 13:33:17.130774'),('amcyf54t6zstxnkogmabjzaxdyex04wu','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qiyGG:ifFKSzInM74oEAhBIM-S3UhKyN3wgbxSII1sCa0Njes','2023-10-04 14:33:04.635740'),('ewrh0iu3w8f71jsd6r4owxowa1o653hg','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qrerB:73k0tWeEwpNgyMxsDA0pdkw7EGGLgDkFvq3X2hMf6I0','2023-10-28 13:39:05.855375'),('ey4rem4z86ofmtx8t3zeq7bmn7ktwqm9','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qnwrA:fzN7LoiXEYnAR7PpWlPi3lZoAygI6wu-p5u9M1rUMzk','2023-10-18 08:03:44.283739'),('fbiq9kqgc506vdmljlv1q5hnuoxxinot','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qkfaa:OeeItnx8ojbfw1FothpVm6F3QTHd49HketJFYuorFDo','2023-10-09 07:01:04.471644'),('gfzfz9itl7wbzvwxetqcrvm992aano1y','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qr1PS:GZodiyNUw0h1Jvgj8B9zy4eJloe_aHh_Ux2bJpxC4uY','2023-10-26 19:31:50.324136'),('hv3p254uo8vmqhh4kxrfbyh4g4ct3edd','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qqvJa:r9LUgQ9eBYtlcNelNhbEz1UkBhLgdMqrIFRV2vfPgHU','2023-10-26 13:01:22.541569'),('jgcih3j425fho0p6vmc9qptiru0npgca','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qrZSd:aHxs07y_x4iy37XqDk7LUlk5NInDWU3ITY8M9R86a3Y','2023-10-28 07:53:23.697422'),('oea45um05ehgtet5bfgjacgntxke69yo','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qkhLS:DEvWe9gdCugTbjRv5UlQCIKnR591_wkkAtedZmXBreg','2023-10-09 08:53:34.554832'),('qitrgtla39b95jp72x3d2jahp3xlue35','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qix1k:RQ_wFkzG4Lc04nh3rysfdsA3G4phjusmq3n_XuWimk0','2023-10-04 13:14:00.938854'),('rzqwppwmnh2rflz3tzkakw7f06uylxyi','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qix1k:RQ_wFkzG4Lc04nh3rysfdsA3G4phjusmq3n_XuWimk0','2023-10-04 13:14:00.939269'),('t7jan8uhqcyyzaavrryjtfr3h4kud8e8','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qjESe:FGVcg7QM_UWyIO4iJ3lFvtmFRvzSdmZUqFoOLvutDjk','2023-10-05 07:50:56.879776'),('vcssmigm03d0ko30wereviyt15wh69yw','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qqwPo:GYR4pshgPxf74W8PsK7rHe5gqcS9f5CfwEGB8NzrpYY','2023-10-26 14:11:52.637401'),('vwu57hf1gl9x08agtkbv8pi5fkfhu6kl','e30:1qiac8:Zx3lkQ3bZ3Z9TfgT_x_bP5lsPaBHunOlUvgRyfy_1_E','2023-10-03 13:18:04.528528'),('w8qrvillbwdt08sr1olt0z3yg3315m96','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qix1k:RQ_wFkzG4Lc04nh3rysfdsA3G4phjusmq3n_XuWimk0','2023-10-04 13:14:00.942543'),('y5p69haelpafv4j0ly4ugf717192yy3s','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qkfGS:9IEEwi89-7fgXw_-r0SSN_kyq9HZsBcxamVcgR6OwAU','2023-10-09 06:40:16.891681'),('yqf8z5oer4v9ry44u248kfddt95v8nhx','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qixRF:dHk3cG0DD3iCsCP4QDg7dKW8S9rZqtT4nV9i54YFxCE','2023-10-04 13:40:21.792196'),('yu566v6db6cp840cz8xhi20pqphkdmpy','.eJxVjMsOwiAQRf-FtSE8hIJL9_0GwnRmpGogKe3K-O_apAvd3nPOfYmUt7WkrdOSZhQXocXpd4M8PajuAO-53pqcWl2XGeSuyIN2OTak5_Vw_w5K7uVbK_agSJ0HHaIlNuiMjcTsshkYldFGgQ7BBwb06AO5SNY5sj5aBezE-wPXKTeE:1qr1jR:4FA7rMKttsPG_21y977-xWMqCqtSp00Ryprw4MhGJKs','2023-10-26 19:52:29.293378'),('za2ezm1a0n5j4elcizznibagv9s52jih','e30:1qiaZL:EEkkxoRpOl8AoDKR8n9rFHUFRLCLXN_K8e4OHp_3Y4Q','2023-10-03 13:15:11.216033');

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('boitage','porte-à-porte','meeting','réunion','marché') DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `oauth2_provider_accesstoken`
--

CREATE TABLE `oauth2_provider_accesstoken` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `expires` datetime(6) NOT NULL,
  `scope` longtext NOT NULL,
  `application_id` bigint(20) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `source_refresh_token_id` bigint(20) DEFAULT NULL,
  `id_token_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `token` (`token`),
  UNIQUE KEY `source_refresh_token_id` (`source_refresh_token_id`),
  UNIQUE KEY `id_token_id` (`id_token_id`),
  KEY `oauth2_provider_acce_application_id_b22886e1_fk_oauth2_pr` (`application_id`),
  KEY `oauth2_provider_accesstoken_user_id_6e4c9a65_fk_auth_user_id` (`user_id`),
  CONSTRAINT `oauth2_provider_acce_application_id_b22886e1_fk_oauth2_pr` FOREIGN KEY (`application_id`) REFERENCES `oauth2_provider_application` (`id`),
  CONSTRAINT `oauth2_provider_acce_id_token_id_85db651b_fk_oauth2_pr` FOREIGN KEY (`id_token_id`) REFERENCES `oauth2_provider_idtoken` (`id`),
  CONSTRAINT `oauth2_provider_acce_source_refresh_token_e66fbc72_fk_oauth2_pr` FOREIGN KEY (`source_refresh_token_id`) REFERENCES `oauth2_provider_refreshtoken` (`id`),
  CONSTRAINT `oauth2_provider_accesstoken_user_id_6e4c9a65_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `oauth2_provider_accesstoken`
--


--
-- Table structure for table `oauth2_provider_application`
--

CREATE TABLE `oauth2_provider_application` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `client_id` varchar(100) NOT NULL,
  `redirect_uris` longtext NOT NULL,
  `client_type` varchar(32) NOT NULL,
  `authorization_grant_type` varchar(32) NOT NULL,
  `client_secret` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `skip_authorization` tinyint(1) NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `algorithm` varchar(5) NOT NULL,
  `post_logout_redirect_uris` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `client_id` (`client_id`),
  KEY `oauth2_provider_application_client_secret_53133678` (`client_secret`),
  KEY `oauth2_provider_application_user_id_79829054_fk_auth_user_id` (`user_id`),
  CONSTRAINT `oauth2_provider_application_user_id_79829054_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `oauth2_provider_application`
--

INSERT INTO `oauth2_provider_application` VALUES (1,'vPvAuSnIHWcsHFjZduPzmLBE5RCxGfn4I1GukBIL','http://127.0.0.1:8000/events/','confidential','authorization-code','pbkdf2_sha256$216000$CoOmIuAZyYHR$31R5KaG48Gq2GlRNseDH8wi8ZsDQUaGR9jy+m2SCxJk=','premiertour',NULL,0,'2023-09-18 14:49:05.958014','2023-09-18 14:49:05.958089','',''),(2,'rxgSrr4vmy2YLzV23MsOJskWYy6tdq5NglTqrNnz','http://127.0.0.1:8000/events/','confidential','authorization-code','pbkdf2_sha256$216000$mL1CCNocW96c$H3UeF5g79ZU8RkSnyrbwGmpyUMq698CmxH3Qv+nm67Q=','secondtour',NULL,0,'2023-09-19 07:30:43.317304','2023-09-19 07:30:43.317353','','');

--
-- Table structure for table `oauth2_provider_grant`
--

CREATE TABLE `oauth2_provider_grant` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `expires` datetime(6) NOT NULL,
  `redirect_uri` longtext NOT NULL,
  `scope` longtext NOT NULL,
  `application_id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `code_challenge` varchar(128) NOT NULL,
  `code_challenge_method` varchar(10) NOT NULL,
  `nonce` varchar(255) NOT NULL,
  `claims` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `oauth2_provider_gran_application_id_81923564_fk_oauth2_pr` (`application_id`),
  KEY `oauth2_provider_grant_user_id_e8f62af8_fk_auth_user_id` (`user_id`),
  CONSTRAINT `oauth2_provider_gran_application_id_81923564_fk_oauth2_pr` FOREIGN KEY (`application_id`) REFERENCES `oauth2_provider_application` (`id`),
  CONSTRAINT `oauth2_provider_grant_user_id_e8f62af8_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `oauth2_provider_grant`
--


--
-- Table structure for table `oauth2_provider_idtoken`
--

CREATE TABLE `oauth2_provider_idtoken` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `jti` char(32) NOT NULL,
  `expires` datetime(6) NOT NULL,
  `scope` longtext NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `application_id` bigint(20) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `jti` (`jti`),
  KEY `oauth2_provider_idto_application_id_08c5ff4f_fk_oauth2_pr` (`application_id`),
  KEY `oauth2_provider_idtoken_user_id_dd512b59_fk_auth_user_id` (`user_id`),
  CONSTRAINT `oauth2_provider_idto_application_id_08c5ff4f_fk_oauth2_pr` FOREIGN KEY (`application_id`) REFERENCES `oauth2_provider_application` (`id`),
  CONSTRAINT `oauth2_provider_idtoken_user_id_dd512b59_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `oauth2_provider_idtoken`
--

INSERT INTO `oauth2_provider_idtoken` VALUES (1,'c9105a2d7e0e4a6c9d058171e2ee488a','2023-09-19 14:57:26.000000','','2023-09-18 14:57:31.980729','2023-09-18 14:57:31.980780',1,1);

--
-- Table structure for table `oauth2_provider_refreshtoken`
--

CREATE TABLE `oauth2_provider_refreshtoken` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `token` varchar(255) NOT NULL,
  `access_token_id` bigint(20) DEFAULT NULL,
  `application_id` bigint(20) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created` datetime(6) NOT NULL,
  `updated` datetime(6) NOT NULL,
  `revoked` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `access_token_id` (`access_token_id`),
  UNIQUE KEY `oauth2_provider_refreshtoken_token_revoked_af8a5134_uniq` (`token`,`revoked`),
  KEY `oauth2_provider_refr_application_id_2d1c311b_fk_oauth2_pr` (`application_id`),
  KEY `oauth2_provider_refreshtoken_user_id_da837fce_fk_auth_user_id` (`user_id`),
  CONSTRAINT `oauth2_provider_refr_access_token_id_775e84e8_fk_oauth2_pr` FOREIGN KEY (`access_token_id`) REFERENCES `oauth2_provider_accesstoken` (`id`),
  CONSTRAINT `oauth2_provider_refr_application_id_2d1c311b_fk_oauth2_pr` FOREIGN KEY (`application_id`) REFERENCES `oauth2_provider_application` (`id`),
  CONSTRAINT `oauth2_provider_refreshtoken_user_id_da837fce_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `oauth2_provider_refreshtoken`
--


--
-- Table structure for table `premiertourapp_event`
--

CREATE TABLE `premiertourapp_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `start_date` datetime(6) NOT NULL,
  `end_date` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `premiertourapp_event`
--

INSERT INTO `premiertourapp_event` VALUES (1,'boitage','nouvel événement','lorem lorem','2023-09-22 00:00:00.000000','2023-09-22 00:00:00.000000'),(2,'boitage','boitage rue alphonse','test','2023-09-20 00:00:00.000000','2023-09-20 00:00:00.000000'),(3,'meeting','Olivier Faure en meeting à Bordeaux','lorem','2023-09-24 00:00:00.000000','2023-09-24 00:00:00.000000'),(4,'boitage','Ex Boitage','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse pulvinar ipsum sed lorem pulvinar dignissim. Donec dignissim in nisi quis vestibulum. Aenean ac diam sagittis, auctor ante quis, accumsan urna. Vestibulum mollis nisl sed tortor dictum, in venenatis dui sodales. Quisque lobortis facilisis ornare. Ut pulvinar odio consectetur ante rhoncus euismod. Duis vel velit rhoncus, feugiat libero fringilla, pharetra augue. Proin ullamcorper quis sapien non aliquet.','2023-09-26 00:00:00.000000','2023-09-26 00:00:00.000000'),(5,'porte-à-porte','ex porte à porte','Sed accumsan mi eu purus ornare ultrices. Praesent vestibulum risus sed lorem faucibus, sed viverra sem aliquet. Vivamus nec nulla ut augue accumsan rutrum. Maecenas congue mi a magna dictum, tincidunt condimentum odio malesuada. Maecenas sollicitudin ut libero sed rutrum.','2023-09-27 00:00:00.000000','2023-09-27 00:00:00.000000'),(6,'meeting','Meeting d\'Olivier Faure','Sed accumsan mi eu purus ornare ultrices. Praesent vestibulum risus sed lorem faucibus, sed viverra sem aliquet. Vivamus nec nulla ut augue accumsan rutrum. Maecenas congue mi a magna dictum, tincidunt condimentum odio malesuada. Maecenas sollicitudin ut libero sed rutrum.','2023-10-15 00:00:00.000000','2023-10-15 00:00:00.000000'),(7,'réunion','réunion de rentrée','Sed accumsan mi eu purus ornare ultrices. Praesent vestibulum risus sed lorem faucibus, sed viverra sem aliquet. Vivamus nec nulla ut augue accumsan rutrum. Maecenas congue mi a magna dictum, tincidunt condimentum odio malesuada. Maecenas sollicitudin ut libero sed rutrum.','2023-10-18 00:00:00.000000','2023-10-18 00:00:00.000000'),(8,'boitage','boitage à Compans','Sed accumsan mi eu purus ornare ultrices. Praesent vestibulum risus sed lorem faucibus, sed viverra sem aliquet. Vivamus nec nulla ut augue accumsan rutrum. Maecenas congue mi a magna dictum, tincidunt condimentum odio malesuada. Maecenas sollicitudin ut libero sed rutrum.','2023-10-26 00:00:00.000000','2023-10-26 00:00:00.000000'),(9,'porte-à-porte','test','tests lorem','2023-11-09 00:00:00.000000','2023-11-09 00:00:00.000000');

--
-- Table structure for table `premiertourapp_message`
--

CREATE TABLE `premiertourapp_message` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `content` longtext NOT NULL,
  `timestamp` datetime(6) NOT NULL,
  `author_id` int(11) NOT NULL,
  `is_pinned` tinyint(1) NOT NULL,
  `pinned` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `premiertourapp_message_author_id_ad9fbe51_fk_auth_user_id` (`author_id`),
  CONSTRAINT `premiertourapp_message_author_id_ad9fbe51_fk_auth_user_id` FOREIGN KEY (`author_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `premiertourapp_message`
--

INSERT INTO `premiertourapp_message` VALUES (1,'Youpu la vie est belle et j\'aime diam\'s ce soir','2023-10-09 18:48:47.029242',1,1,0),(2,'J\'espère que vous allez bien ;) ! Bises','2023-10-09 19:02:01.647845',1,0,0),(3,'j\'aime aussi scylla','2023-10-09 19:26:23.246208',1,0,0),(6,'Tout va bien\r\n','2023-10-12 16:51:25.844481',1,0,0),(7,'test d\'un autre message','2023-10-12 17:39:35.443375',1,0,0),(8,'qsdf ','2023-10-12 17:47:09.912762',1,0,0),(9,'erhqdfg qsd','2023-10-12 17:47:15.567097',1,0,0),(10,'qsdfg qdfhsd fg sdgf','2023-10-12 17:47:22.063758',1,0,0),(11,'j\'adore artur ','2023-10-12 18:22:14.759965',1,0,0),(13,'il faudrait voir s\'il n\'y a pas de soucis de temporalité car en fait il est 20h29','2023-10-12 18:30:04.316156',1,0,0),(14,'c\'est bon les timezones sont bonnes maintenant il faudrait qu\'il y ait un design différentes entre l\'utilisateur présent et les autres\r\n','2023-10-12 18:35:44.988998',1,0,0),(15,'Coucou c\'est Thierry j\'ai 54 ans','2023-10-12 18:42:23.588792',2,0,0),(16,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut dignissim lacus quis erat iaculis commodo. Maecenas aliquam mattis neque, id malesuada ante euismod id. Aliquam erat volutpat. Nullam et viverra massa. Donec nec tortor augue. Quisque at accumsan urna. Etiam non arcu at mi lobortis mattis in at quam. Vestibulum quis placerat leo.\r\n\r\nIn hac habitasse platea dictumst. Aenean ullamcorper ex in nulla pretium mollis ut auctor arcu. Mauris hendrerit sed purus id maximus. Nulla efficitur turpis eget urna varius luctus. Aliquam eu turpis ac dolor lobortis vulputate. Morbi in lacus ante. Ut dignissim, felis at maximus feugiat, ex tortor consectetur eros, id volutpat nulla enim eget lorem.\r\n','2023-10-12 19:03:10.302527',2,0,0),(17,'ceci est un message ','2023-10-12 19:29:07.972333',1,0,1),(18,'test d\'un message \r\n','2023-10-14 08:02:11.587302',1,0,0),(19,'je fais un test aujourd\'hui','2023-10-14 12:08:18.858089',1,0,0);

--
-- Table structure for table `socialaccount_socialaccount`
--

CREATE TABLE `socialaccount_socialaccount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `provider` varchar(200) NOT NULL,
  `uid` varchar(191) NOT NULL,
  `last_login` datetime(6) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `extra_data` longtext NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `socialaccount_socialaccount_provider_uid_fc810c6e_uniq` (`provider`,`uid`),
  KEY `socialaccount_socialaccount_user_id_8146e70c_fk_auth_user_id` (`user_id`),
  CONSTRAINT `socialaccount_socialaccount_user_id_8146e70c_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `socialaccount_socialaccount`
--


--
-- Table structure for table `socialaccount_socialapp`
--

CREATE TABLE `socialaccount_socialapp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `provider` varchar(30) NOT NULL,
  `name` varchar(40) NOT NULL,
  `client_id` varchar(191) NOT NULL,
  `secret` varchar(191) NOT NULL,
  `key` varchar(191) NOT NULL,
  `provider_id` varchar(200) NOT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`settings`)),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `socialaccount_socialapp`
--


--
-- Table structure for table `socialaccount_socialtoken`
--

CREATE TABLE `socialaccount_socialtoken` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` longtext NOT NULL,
  `token_secret` longtext NOT NULL,
  `expires_at` datetime(6) DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `app_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `socialaccount_socialtoken_app_id_account_id_fca4e0ac_uniq` (`app_id`,`account_id`),
  KEY `socialaccount_social_account_id_951f210e_fk_socialacc` (`account_id`),
  CONSTRAINT `socialaccount_social_account_id_951f210e_fk_socialacc` FOREIGN KEY (`account_id`) REFERENCES `socialaccount_socialaccount` (`id`),
  CONSTRAINT `socialaccount_social_app_id_636a42d7_fk_socialacc` FOREIGN KEY (`app_id`) REFERENCES `socialaccount_socialapp` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `socialaccount_socialtoken`
--


--
-- Table structure for table `user_favorites`
--

CREATE TABLE `user_favorites` (
  `user_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`event_id`),
  KEY `event_id` (`event_id`),
  CONSTRAINT `user_favorites_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user_favorites`
--


--
-- Current Database: `safekids`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `safekids` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */;

USE `safekids`;

--
-- Current Database: `1erTour`
--

USE `1erTour`;

--
-- Current Database: `gilleshelleu`
--

USE `gilleshelleu`;

--
-- Current Database: `mailserver`
--

USE `mailserver`;

--
-- Current Database: `mysql`
--

USE `mysql`;

--
-- Final view structure for view `user`
--

/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`mariadb.sys`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user` AS select `global_priv`.`Host` AS `Host`,`global_priv`.`User` AS `User`,if(json_value(`global_priv`.`Priv`,'$.plugin') in ('mysql_native_password','mysql_old_password'),ifnull(json_value(`global_priv`.`Priv`,'$.authentication_string'),''),'') AS `Password`,if(json_value(`global_priv`.`Priv`,'$.access') & 1,'Y','N') AS `Select_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 2,'Y','N') AS `Insert_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 4,'Y','N') AS `Update_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 8,'Y','N') AS `Delete_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 16,'Y','N') AS `Create_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 32,'Y','N') AS `Drop_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 64,'Y','N') AS `Reload_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 128,'Y','N') AS `Shutdown_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 256,'Y','N') AS `Process_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 512,'Y','N') AS `File_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 1024,'Y','N') AS `Grant_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 2048,'Y','N') AS `References_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 4096,'Y','N') AS `Index_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 8192,'Y','N') AS `Alter_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 16384,'Y','N') AS `Show_db_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 32768,'Y','N') AS `Super_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 65536,'Y','N') AS `Create_tmp_table_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 131072,'Y','N') AS `Lock_tables_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 262144,'Y','N') AS `Execute_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 524288,'Y','N') AS `Repl_slave_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 1048576,'Y','N') AS `Repl_client_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 2097152,'Y','N') AS `Create_view_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 4194304,'Y','N') AS `Show_view_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 8388608,'Y','N') AS `Create_routine_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 16777216,'Y','N') AS `Alter_routine_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 33554432,'Y','N') AS `Create_user_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 67108864,'Y','N') AS `Event_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 134217728,'Y','N') AS `Trigger_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 268435456,'Y','N') AS `Create_tablespace_priv`,if(json_value(`global_priv`.`Priv`,'$.access') & 536870912,'Y','N') AS `Delete_history_priv`,elt(ifnull(json_value(`global_priv`.`Priv`,'$.ssl_type'),0) + 1,'','ANY','X509','SPECIFIED') AS `ssl_type`,ifnull(json_value(`global_priv`.`Priv`,'$.ssl_cipher'),'') AS `ssl_cipher`,ifnull(json_value(`global_priv`.`Priv`,'$.x509_issuer'),'') AS `x509_issuer`,ifnull(json_value(`global_priv`.`Priv`,'$.x509_subject'),'') AS `x509_subject`,cast(ifnull(json_value(`global_priv`.`Priv`,'$.max_questions'),0) as unsigned) AS `max_questions`,cast(ifnull(json_value(`global_priv`.`Priv`,'$.max_updates'),0) as unsigned) AS `max_updates`,cast(ifnull(json_value(`global_priv`.`Priv`,'$.max_connections'),0) as unsigned) AS `max_connections`,cast(ifnull(json_value(`global_priv`.`Priv`,'$.max_user_connections'),0) as signed) AS `max_user_connections`,ifnull(json_value(`global_priv`.`Priv`,'$.plugin'),'') AS `plugin`,ifnull(json_value(`global_priv`.`Priv`,'$.authentication_string'),'') AS `authentication_string`,if(ifnull(json_value(`global_priv`.`Priv`,'$.password_last_changed'),1) = 0,'Y','N') AS `password_expired`,elt(ifnull(json_value(`global_priv`.`Priv`,'$.is_role'),0) + 1,'N','Y') AS `is_role`,ifnull(json_value(`global_priv`.`Priv`,'$.default_role'),'') AS `default_role`,cast(ifnull(json_value(`global_priv`.`Priv`,'$.max_statement_time'),0.0) as decimal(12,6)) AS `max_statement_time` from `global_priv` */;

--
-- Current Database: `nom_de_la_base`
--

USE `nom_de_la_base`;

--
-- Current Database: `premiertour`
--

USE `premiertour`;

--
-- Current Database: `safekids`
--

USE `safekids`;


