-- https://www.phpmyadmin.net/
--
-- Hôte : localhost
-- Généré le :  lun. 07 jan. 2019 à 05:18
-- Version du serveur :  10.3.10-MariaDB-log
-- Version de PHP :  7.2.11

START TRANSACTION;



--
-- Base de données :  `charli`
--

-- --------------------------------------------------------

--
-- Structure de la table `charlis`
--

CREATE TABLE `charlis` (
  `id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `longitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '2.299083201214671',
  `latitude` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '48.852461424472935',
  `charge_id` int(11) DEFAULT NULL,
  `sim` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `couleur` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sw_arduino` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sw_opi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offline_alert` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_lmk_review` timestamp NULL DEFAULT NULL,
  `last_charli_review` timestamp NULL DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_id` int(11) DEFAULT NULL,
  `device_type` int(11) NOT NULL DEFAULT 0,
  `device_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `charlis`
--

INSERT INTO `charlis` (`id`, `name`, `group_id`, `longitude`, `latitude`, `charge_id`, `sim`, `couleur`, `sw_arduino`, `sw_opi`, `offline_alert`, `created_at`, `last_lmk_review`, `last_charli_review`, `user_id`, `type`, `video_id`, `device_type`, `device_id`) VALUES
('1', 'Premier Charli de test', 4, '2.299083201214671', '48.852461424472935', NULL, 'dfsfsfsf', 'Blanc', 'fdsfsfs', 'fdsfsfs', 0, '2019-01-05 19:01:40', NULL, NULL, 3, '[\"1\"]', NULL, 0, '27472646'),
('2', NULL, NULL, '2.299083201214671', '48.852461424472935', NULL, 'City', 'Blanc', '6.05', '2.4', 0, '2019-01-05 19:01:50', NULL, NULL, 3, '[\"2\"]', NULL, 2, '55944fr_274');

-- --------------------------------------------------------

--
-- Structure de la table `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int(10) UNSIGNED NOT NULL,
  `data_type_id` int(10) UNSIGNED NOT NULL,
  `field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `browse` tinyint(1) NOT NULL DEFAULT 1,
  `read` tinyint(1) NOT NULL DEFAULT 1,
  `edit` tinyint(1) NOT NULL DEFAULT 1,
  `add` tinyint(1) NOT NULL DEFAULT 1,
  `delete` tinyint(1) NOT NULL DEFAULT 1,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `data_rows`
--

INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES
(1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, '{}', 1),
(2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, '{}', 2),
(3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, '{}', 3),
(4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, '{}', 4),
(5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, '{}', 5),
(6, 1, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, '{}', 6),
(7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 7),
(9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":\"0\",\"taggable\":\"0\"}', 10),
(10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 11),
(12, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, '{}', 12),
(13, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(14, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(15, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(16, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(17, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(18, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(19, 3, 'created_at', 'timestamp', 'Created At', 1, 0, 0, 0, 0, 0, NULL, 3),
(20, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(21, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, NULL, 5),
(22, 1, 'role_id', 'text', 'Role', 0, 1, 1, 1, 1, 0, '{}', 9),
(94, 14, 'id', 'text', 'ID', 1, 0, 0, 0, 0, 0, '{}', 22),
(96, 14, 'name', 'text', 'Nom', 0, 1, 1, 1, 0, 1, '{}', 6),
(98, 14, 'longitude', 'text', 'Longitude', 1, 1, 1, 0, 0, 0, '{}', 13),
(99, 14, 'latitude', 'text', 'Latitude', 1, 1, 1, 0, 0, 0, '{}', 14),
(101, 14, 'sim', 'text', 'Sim', 1, 1, 1, 1, 1, 0, '{}', 5),
(105, 14, 'sw_arduino', 'text', 'Software Arduino', 1, 1, 1, 1, 1, 0, '{}', 16),
(106, 14, 'sw_opi', 'text', 'Software Opi', 1, 1, 1, 1, 1, 0, '{}', 17),
(112, 14, 'group_id', 'select_dropdown', 'Groupe', 0, 1, 1, 1, 0, 0, '{}', 9),
(113, 14, 'charge_id', 'text', 'Charge', 0, 1, 1, 0, 0, 0, '{}', 15),
(116, 14, 'offline_alert', 'hidden', 'Alerte hors ligne', 1, 1, 1, 0, 0, 0, '{}', 19),
(117, 14, 'last_lmk_review', 'timestamp', 'Dernière review par LmK', 0, 1, 1, 0, 0, 0, '{}', 20),
(118, 14, 'last_charli_review', 'timestamp', 'Dernière review par SMS', 0, 1, 1, 0, 0, 0, '{}', 21),
(119, 14, 'couleur', 'select_dropdown', 'Couleur', 1, 1, 1, 1, 1, 0, '{\"default\":\"Blanc\",\"options\":{\"Blanc\":\"Blanc\",\"Bleu\":\"Bleu\",\"Noir\":\"Noir\",\"Rouge\":\"Rouge\",\"Vert\":\"Vert\"}}', 4),
(121, 14, 'user_id', 'text', 'User Id', 1, 1, 1, 1, 1, 1, '{}', 7),
(122, 1, 'email_verified_at', 'timestamp', 'Email Verified At', 0, 0, 0, 0, 0, 1, '{}', 6),
(123, 1, 'user_hasmany_charli_relationship', 'relationship', 'charlis', 0, 1, 1, 1, 0, 0, '{\"model\":\"App\\\\Charli\",\"table\":\"charlis\",\"type\":\"hasMany\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 13),
(124, 14, 'charli_belongsto_user_relationship', 'relationship', 'Utilisateur', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 8),
(127, 16, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(128, 16, 'name', 'text', 'Nom', 1, 1, 1, 1, 1, 1, '{}', 2),
(129, 16, 'file_name', 'hidden', 'Fichier', 1, 1, 1, 1, 1, 1, '{}', 3),
(130, 16, 'duration', 'hidden', 'Durée', 1, 1, 1, 1, 1, 1, '{}', 4),
(131, 16, 'created_at', 'timestamp', 'Date de création', 1, 1, 1, 0, 0, 1, '{}', 5),
(132, 16, 'video_belongstomany_charli_relationship', 'relationship', 'charlis', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Charli\",\"table\":\"charlis\",\"type\":\"hasMany\",\"column\":\"video_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"on\"}', 6),
(133, 14, 'created_at', 'timestamp', 'Date de création', 0, 1, 1, 0, 0, 0, '{}', 18),
(134, 17, 'id', 'text', 'Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(135, 17, 'name', 'text', 'Nom', 1, 1, 1, 1, 1, 1, '{}', 2),
(136, 17, 'user_id', 'text', 'User Id', 1, 1, 1, 1, 1, 0, '{\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}', 3),
(137, 17, 'group_hasmany_charli_relationship', 'relationship', 'Supports', 0, 1, 1, 1, 0, 0, '{\"model\":\"App\\\\Charli\",\"table\":\"charlis\",\"type\":\"hasMany\",\"column\":\"group_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 4),
(138, 14, 'charli_belongsto_group_relationship', 'relationship', 'Groupe', 0, 1, 1, 1, 0, 0, '{\"model\":\"App\\\\Group\",\"table\":\"groups\",\"type\":\"belongsTo\",\"column\":\"group_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 10),
(139, 14, 'type', 'select_multiple', 'Groupe', 1, 1, 1, 1, 1, 0, '{\"options\":{\"1\":\"LetmeKnow\",\"2\":\"Parc Occasion\",\"3\":\"Clients\",\"4\":\"Parc r\\u00e9gie\"}}', 2),
(140, 17, 'group_belongsto_user_relationship', 'relationship', 'Utilisateur', 0, 1, 1, 1, 1, 0, '{\"model\":\"App\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 5),
(142, 1, 'user_hasmany_group_relationship', 'relationship', 'groups', 0, 0, 1, 1, 1, 0, '{\"model\":\"App\\\\Group\",\"table\":\"groups\",\"type\":\"hasMany\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 14),
(148, 14, 'video_id', 'select_dropdown', 'Vidéo', 0, 1, 1, 1, 0, 0, '{\"relationship\":{\"key\":\"id\",\"label\":\"name\"}}', 11),
(149, 14, 'charli_belongsto_video_relationship', 'relationship', 'Vidéo', 0, 1, 1, 1, 0, 0, '{\"model\":\"App\\\\Video\",\"table\":\"videos\",\"type\":\"belongsTo\",\"column\":\"video_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 12),
(150, 16, 'user_id', 'text', 'Utilisateur', 0, 1, 1, 0, 0, 0, '{}', 6),
(152, 1, 'user_hasmany_video_relationship', 'relationship', 'videos', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\Video\",\"table\":\"videos\",\"type\":\"hasMany\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 15),
(154, 16, 'video_belongsto_user_relationship', 'relationship', 'Utilisateur', 0, 1, 1, 0, 0, 0, '{\"model\":\"App\\\\User\",\"table\":\"users\",\"type\":\"belongsTo\",\"column\":\"user_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":\"charlis\",\"pivot\":\"0\",\"taggable\":\"0\"}', 8),
(155, 14, 'device_type', 'select_dropdown', 'Type de support', 1, 1, 1, 1, 1, 0, '{\"options\":{\"0\":\"CharLi Play\",\"1\":\"Bubble\",\"2\":\"CharLi 360\"}}', 1),
(156, 16, 'size', 'hidden', 'Size', 1, 0, 0, 1, 1, 0, '{}', 7),
(157, 1, 'upload_allowed', 'text', 'Upload Allowed', 1, 1, 1, 1, 1, 0, '{}', 11),
(158, 14, 'device_id', 'text', 'ID', 1, 0, 1, 1, 1, 0, '{}', 3);

-- --------------------------------------------------------

--
-- Structure de la table `data_types`
--

CREATE TABLE `data_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT 0,
  `server_side` tinyint(4) NOT NULL DEFAULT 0,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `data_types`
--

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'Utilisateur', 'Utilisateurs', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null}', '2018-12-04 11:55:24', '2019-01-02 16:11:43'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, '', '', 1, 0, NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(14, 'charlis', 'supports', 'Support', 'Supports', 'voyager-tv', 'App\\Charli', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null}', '2018-12-09 18:11:53', '2019-01-05 20:30:50'),
(15, 'video', 'video', 'Video', 'Videos', NULL, 'App\\Video', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null}', '2018-12-09 19:37:36', '2018-12-09 19:37:36'),
(16, 'videos', 'videos', 'Video', 'Videos', 'voyager-video', 'App\\Video', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null}', '2018-12-09 20:25:21', '2019-01-01 15:27:12'),
(17, 'groups', 'groups', 'Groupe', 'Groupes', 'voyager-archive', 'App\\Group', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null}', '2018-12-09 20:54:48', '2019-01-05 17:01:56');

-- --------------------------------------------------------

--
-- Structure de la table `groups`
--

CREATE TABLE `groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `groups`
--

INSERT INTO `groups` (`id`, `name`, `user_id`) VALUES
(4, 'Groupe de test 1', 2);

-- --------------------------------------------------------

--
-- Structure de la table `menus`
--

CREATE TABLE `menus` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `menus`
--

INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2018-12-04 11:55:24', '2018-12-04 11:55:24');

-- --------------------------------------------------------

--
-- Structure de la table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `menu_id` int(10) UNSIGNED DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `menu_items`
--

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(4, 1, 'Roles', '', '_self', 'voyager-lock', NULL, NULL, 11, '2018-12-04 11:55:24', '2018-12-31 11:21:41', 'voyager.roles.index', NULL),
(8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, NULL, 5, '2018-12-04 11:55:24', '2018-12-31 11:21:32', 'voyager.compass.index', NULL),
(9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, NULL, 7, '2018-12-04 11:55:24', '2018-12-31 11:21:39', 'voyager.bread.index', NULL),
(16, 1, 'Médiathèque', '', '_self', 'voyager-images', NULL, NULL, 12, '2018-12-08 18:39:04', '2018-12-31 11:21:41', 'voyager.media.index', NULL),
(17, 1, 'Utilisateurs', '', '_self', 'voyager-person', NULL, NULL, 4, '2018-12-08 18:39:04', '2018-12-10 14:46:13', 'voyager.users.index', NULL),
(19, 1, 'Créateur de Menus', '', '_self', 'voyager-list', NULL, NULL, 6, '2018-12-08 18:39:04', '2018-12-31 11:21:37', 'voyager.menus.index', NULL),
(20, 1, 'Base de donnée', '', '_self', 'voyager-data', NULL, NULL, 8, '2018-12-08 18:39:04', '2018-12-31 11:21:41', 'voyager.database.index', NULL),
(21, 1, 'Paramètres', '', '_self', 'voyager-settings', NULL, NULL, 10, '2018-12-08 18:39:04', '2018-12-31 11:21:41', 'voyager.settings.index', NULL),
(22, 1, 'Supports', '', '_self', 'voyager-tv', NULL, NULL, 1, '2018-12-09 18:11:53', '2018-12-10 14:45:31', 'voyager.supports.index', NULL),
(24, 1, 'Vidéos', '', '_self', 'voyager-video', '#000000', NULL, 2, '2018-12-09 20:25:21', '2018-12-10 14:46:00', 'voyager.videos.index', 'null'),
(25, 1, 'Groupes', '', '_self', 'voyager-archive', NULL, NULL, 3, '2018-12-09 20:54:48', '2018-12-10 14:46:07', 'voyager.groups.index', NULL),
(26, 1, 'Contact', '', '_self', '', NULL, NULL, 13, '2018-12-09 20:54:48', '2018-12-10 14:46:07', 'tickets.index', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2016_01_01_000000_create_pages_table', 2),
(24, '2016_01_01_000000_create_posts_table', 2),
(25, '2016_02_15_204651_create_categories_table', 2),
(26, '2017_04_11_000000_alter_post_nullable_fields_table', 2),
(27, '2015_07_22_115516_create_ticketit_tables', 3),
(28, '2015_07_22_123254_alter_users_table', 3),
(29, '2015_09_29_123456_add_completed_at_column_to_ticketit_table', 3),
(30, '2015_10_08_123457_create_settings_table', 3),
(31, '2016_01_15_002617_add_htmlcontent_to_ticketit_and_comments', 3),
(32, '2016_01_15_040207_enlarge_settings_columns', 3),
(33, '2016_01_15_120557_add_indexes', 3),
(34, '2019_01_06_000000_add_supports_to_tickets', 4);

-- --------------------------------------------------------

--
-- Structure de la table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permissions`
--

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(2, 'browse_bread', NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(3, 'browse_database', NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(4, 'browse_media', NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(5, 'browse_compass', NULL, '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(6, 'browse_menus', 'menus', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(7, 'read_menus', 'menus', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(8, 'edit_menus', 'menus', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(9, 'add_menus', 'menus', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(10, 'delete_menus', 'menus', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(11, 'browse_roles', 'roles', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(12, 'read_roles', 'roles', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(13, 'edit_roles', 'roles', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(14, 'add_roles', 'roles', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(15, 'delete_roles', 'roles', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(16, 'browse_users', 'users', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(17, 'read_users', 'users', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(18, 'edit_users', 'users', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(19, 'add_users', 'users', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(20, 'delete_users', 'users', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(21, 'browse_settings', 'settings', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(22, 'read_settings', 'settings', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(23, 'edit_settings', 'settings', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(24, 'add_settings', 'settings', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(25, 'delete_settings', 'settings', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(41, 'browse_hooks', NULL, '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(52, 'browse_charli', 'charli', '2018-12-08 18:34:50', '2018-12-08 18:34:50'),
(53, 'read_charli', 'charli', '2018-12-08 18:34:50', '2018-12-08 18:34:50'),
(54, 'edit_charli', 'charli', '2018-12-08 18:34:50', '2018-12-08 18:34:50'),
(55, 'add_charli', 'charli', '2018-12-08 18:34:50', '2018-12-08 18:34:50'),
(56, 'delete_charli', 'charli', '2018-12-08 18:34:50', '2018-12-08 18:34:50'),
(57, 'browse_charlis', 'charlis', '2018-12-09 18:11:53', '2018-12-09 18:11:53'),
(58, 'read_charlis', 'charlis', '2018-12-09 18:11:53', '2018-12-09 18:11:53'),
(59, 'edit_charlis', 'charlis', '2018-12-09 18:11:53', '2018-12-09 18:11:53'),
(60, 'add_charlis', 'charlis', '2018-12-09 18:11:53', '2018-12-09 18:11:53'),
(61, 'delete_charlis', 'charlis', '2018-12-09 18:11:53', '2018-12-09 18:11:53'),
(62, 'browse_video', 'video', '2018-12-09 19:37:36', '2018-12-09 19:37:36'),
(63, 'read_video', 'video', '2018-12-09 19:37:36', '2018-12-09 19:37:36'),
(64, 'edit_video', 'video', '2018-12-09 19:37:36', '2018-12-09 19:37:36'),
(65, 'add_video', 'video', '2018-12-09 19:37:36', '2018-12-09 19:37:36'),
(66, 'delete_video', 'video', '2018-12-09 19:37:36', '2018-12-09 19:37:36'),
(67, 'browse_videos', 'videos', '2018-12-09 20:25:21', '2018-12-09 20:25:21'),
(68, 'read_videos', 'videos', '2018-12-09 20:25:21', '2018-12-09 20:25:21'),
(69, 'edit_videos', 'videos', '2018-12-09 20:25:21', '2018-12-09 20:25:21'),
(70, 'add_videos', 'videos', '2018-12-09 20:25:21', '2018-12-09 20:25:21'),
(71, 'delete_videos', 'videos', '2018-12-09 20:25:21', '2018-12-09 20:25:21'),
(72, 'browse_groups', 'groups', '2018-12-09 20:54:48', '2018-12-09 20:54:48'),
(73, 'read_groups', 'groups', '2018-12-09 20:54:48', '2018-12-09 20:54:48'),
(74, 'edit_groups', 'groups', '2018-12-09 20:54:48', '2018-12-09 20:54:48'),
(75, 'add_groups', 'groups', '2018-12-09 20:54:48', '2018-12-09 20:54:48'),
(76, 'delete_groups', 'groups', '2018-12-09 20:54:48', '2018-12-09 20:54:48');

-- --------------------------------------------------------

--
-- Structure de la table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 3),
(1, 4),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(16, 4),
(17, 1),
(17, 4),
(18, 1),
(18, 4),
(19, 1),
(19, 4),
(20, 1),
(20, 4),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(41, 1),
(52, 1),
(52, 2),
(52, 3),
(52, 4),
(53, 1),
(53, 2),
(53, 3),
(53, 4),
(54, 1),
(54, 3),
(54, 4),
(55, 1),
(55, 4),
(56, 1),
(56, 3),
(56, 4),
(57, 1),
(57, 2),
(57, 3),
(57, 4),
(58, 1),
(58, 2),
(58, 3),
(58, 4),
(59, 1),
(59, 3),
(59, 4),
(60, 1),
(60, 4),
(61, 1),
(61, 3),
(61, 4),
(62, 1),
(62, 2),
(62, 3),
(62, 4),
(63, 1),
(63, 2),
(63, 3),
(63, 4),
(64, 1),
(64, 3),
(64, 4),
(65, 1),
(65, 3),
(65, 4),
(66, 1),
(66, 3),
(66, 4),
(67, 1),
(67, 2),
(67, 3),
(67, 4),
(68, 1),
(68, 2),
(68, 3),
(68, 4),
(69, 1),
(69, 3),
(69, 4),
(70, 1),
(70, 3),
(70, 4),
(71, 1),
(71, 3),
(71, 4),
(72, 1),
(72, 3),
(72, 4),
(73, 1),
(73, 3),
(73, 4),
(74, 1),
(74, 3),
(74, 4),
(75, 1),
(75, 3),
(75, 4),
(76, 1),
(76, 3),
(76, 4);

-- --------------------------------------------------------

--
-- Structure de la table `posts`
--

CREATE TABLE `posts` (
  `id` int(10) UNSIGNED NOT NULL,
  `author_id` int(11) NOT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `excerpt` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('PUBLISHED','DRAFT','PENDING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `posts`
--

INSERT INTO `posts` (`id`, `author_id`, `category_id`, `title`, `seo_title`, `excerpt`, `body`, `image`, `slug`, `meta_description`, `meta_keywords`, `status`, `featured`, `created_at`, `updated_at`) VALUES
(1, 0, NULL, 'Lorem Ipsum Post', NULL, 'This is the excerpt for the Lorem Ipsum Post', '<p>This is the body of the lorem ipsum post</p>', 'posts/post1.jpg', 'lorem-ipsum-post', 'This is the meta description', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(2, 0, NULL, 'My Sample Post', NULL, 'This is the excerpt for the sample Post', '<p>This is the body for the sample post, which includes the body.</p>\n                <h2>We can use all kinds of format!</h2>\n                <p>And include a bunch of other stuff.</p>', 'posts/post2.jpg', 'my-sample-post', 'Meta Description for sample post', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(3, 0, NULL, 'Latest Post', NULL, 'This is the excerpt for the latest post', '<p>This is the body for the latest post</p>', 'posts/post3.jpg', 'latest-post', 'This is the meta description', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(4, 0, NULL, 'Yarr Post', NULL, 'Reef sails nipperkin bring a spring upon her cable coffer jury mast spike marooned Pieces of Eight poop deck pillage. Clipper driver coxswain galleon hempen halter come about pressgang gangplank boatswain swing the lead. Nipperkin yard skysail swab lanyard Blimey bilge water ho quarter Buccaneer.', '<p>Swab deadlights Buccaneer fire ship square-rigged dance the hempen jig weigh anchor cackle fruit grog furl. Crack Jennys tea cup chase guns pressgang hearties spirits hogshead Gold Road six pounders fathom measured fer yer chains. Main sheet provost come about trysail barkadeer crimp scuttle mizzenmast brig plunder.</p>\n<p>Mizzen league keelhaul galleon tender cog chase Barbary Coast doubloon crack Jennys tea cup. Blow the man down lugsail fire ship pinnace cackle fruit line warp Admiral of the Black strike colors doubloon. Tackle Jack Ketch come about crimp rum draft scuppers run a shot across the bow haul wind maroon.</p>\n<p>Interloper heave down list driver pressgang holystone scuppers tackle scallywag bilged on her anchor. Jack Tar interloper draught grapple mizzenmast hulk knave cable transom hogshead. Gaff pillage to go on account grog aft chase guns piracy yardarm knave clap of thunder.</p>', 'posts/post4.jpg', 'yarr-post', 'this be a meta descript', 'keyword1, keyword2, keyword3', 'PUBLISHED', 0, '2018-12-04 11:55:25', '2018-12-04 11:55:25');

-- --------------------------------------------------------

--
-- Structure de la table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(2, 'user', 'Normal User', '2018-12-04 11:55:24', '2018-12-04 11:55:24'),
(3, 'manager', 'Manager', '2018-12-04 11:56:28', '2018-12-12 19:14:01'),
(4, 'admin_sms', 'Admin Charli', '2018-12-31 11:23:47', '2018-12-31 11:23:47');

-- --------------------------------------------------------

--
-- Structure de la table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL DEFAULT 1,
  `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `settings`
--

INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES
(1, 'site.title', 'Site Title', 'Simon', '', 'text', 1, 'Site'),
(2, 'site.description', 'Site Description', 'Gestionnaire de supports Doohit', '', 'text', 2, 'Site'),
(3, 'site.logo', 'Site Logo', 'settings\\December2018\\AYW38iduJ3QOoUvuU3Vh.png', '', 'image', 3, 'Site'),
(4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', NULL, '', 'text', 4, 'Site'),
(5, 'admin.bg_image', 'Admin Background Image', 'settings\\December2018\\gH5rfzAnJhOEnFwOsAvO.jpg', '', 'image', 5, 'Admin'),
(6, 'admin.title', 'Admin Title', 'Simon', '', 'text', 1, 'Admin'),
(7, 'admin.description', 'Admin Description', 'Bienvenue sur le gestionnaire Doohit', '', 'text', 2, 'Admin'),
(8, 'admin.loader', 'Admin Loader', 'settings\\December2018\\kXwDwQTLT2J8AGEyKfkx.png', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', 'settings\\December2018\\vks7EispxO3YPYdcxW5k.png', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', NULL, '', 'text', 1, 'Admin');

-- --------------------------------------------------------

--
-- Structure de la table `ticketit`
--

CREATE TABLE `ticketit` (
  `id` int(10) UNSIGNED NOT NULL,
  `subject` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `html` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_id` int(10) UNSIGNED NOT NULL,
  `priority_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `agent_id` int(10) UNSIGNED NOT NULL,
  `category_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `charli_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `ticketit`
--

INSERT INTO `ticketit` (`id`, `subject`, `content`, `html`, `status_id`, `priority_id`, `user_id`, `agent_id`, `category_id`, `created_at`, `updated_at`, `completed_at`, `charli_id`) VALUES
(15, 'Où sont les piles ?', 'Les piles ne sont pas au bon endroit !', 'Les piles ne sont pas au bon endroit !', 3, 1, 3, 1, 1, '2019-01-07 03:23:43', '2019-01-07 03:23:43', NULL, 1);

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_audits`
--

CREATE TABLE `ticketit_audits` (
  `id` int(10) UNSIGNED NOT NULL,
  `operation` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_categories`
--

CREATE TABLE `ticketit_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `ticketit_categories`
--

INSERT INTO `ticketit_categories` (`id`, `name`, `color`) VALUES
(1, 'Dysfonctionnement', '#800000');

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_categories_users`
--

CREATE TABLE `ticketit_categories_users` (
  `category_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_comments`
--

CREATE TABLE `ticketit_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `html` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `ticket_id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `ticketit_comments`
--

INSERT INTO `ticketit_comments` (`id`, `content`, `html`, `user_id`, `ticket_id`, `created_at`, `updated_at`) VALUES
(1, 'C\'est pas encore fini !', '<p>C\'est pas encore fini !</p>', 1, 15, '2019-01-07 04:28:32', '2019-01-07 04:28:32');

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_priorities`
--

CREATE TABLE `ticketit_priorities` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `ticketit_priorities`
--

INSERT INTO `ticketit_priorities` (`id`, `name`, `color`) VALUES
(1, 'Faible', '#008040'),
(2, 'Moyenne', '#d9a800'),
(3, 'Haute', '#ff6c00'),
(4, 'Critique', '#ff1717');

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_settings`
--

CREATE TABLE `ticketit_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `lang` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `default` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `ticketit_settings`
--

INSERT INTO `ticketit_settings` (`id`, `lang`, `slug`, `value`, `default`, `created_at`, `updated_at`) VALUES
(1, NULL, 'main_route', 'tickets', 'tickets', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(2, NULL, 'main_route_path', 'tickets', 'tickets', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(3, NULL, 'admin_route', 'tickets-admin', 'tickets-admin', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(4, NULL, 'admin_route_path', 'tickets-admin', 'tickets-admin', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(5, NULL, 'master_template', 'vendor.voyager.master', 'vendor.voyager.master', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(6, NULL, 'bootstrap_version', '4', '4', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(7, NULL, 'email.template', 'ticketit::emails.templates.ticketit', 'ticketit::emails.templates.ticketit', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(8, NULL, 'email.header', 'Mise à jour demande d\'assistance', 'Ticket Update', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(9, NULL, 'email.signoff', 'Merci de votre patience !', 'Thank you for your patience!', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(10, NULL, 'email.signature', 'Smart Mobile Solutions', 'Your friends', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(11, NULL, 'email.dashboard', 'My Dashboard', 'My Dashboard', '2019-01-07 00:14:46', '2019-01-07 00:14:46'),
(12, NULL, 'email.google_plus_link', '#', '#', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(13, NULL, 'email.facebook_link', '#', '#', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(14, NULL, 'email.twitter_link', '#', '#', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(15, NULL, 'email.footer', 'Simon - Smart Mobile Solutions', 'Powered by Ticketit', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(16, NULL, 'email.footer_link', '', 'https://github.com/thekordy/ticketit', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(17, NULL, 'email.color_body_bg', '#FFFFFF', '#FFFFFF', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(18, NULL, 'email.color_header_bg', '#44B7B7', '#44B7B7', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(19, NULL, 'email.color_content_bg', '#F46B45', '#F46B45', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(20, NULL, 'email.color_footer_bg', '#414141', '#414141', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(21, NULL, 'email.color_button_bg', '#AC4D2F', '#AC4D2F', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(22, NULL, 'default_status_id', '3', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(23, NULL, 'default_close_status_id', '6', '0', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(24, NULL, 'default_reopen_status_id', '5', '0', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(25, NULL, 'paginate_items', '10', '10', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(26, NULL, 'length_menu', 'a:2:{i:0;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}i:1;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}}', 'a:2:{i:0;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}i:1;a:3:{i:0;i:10;i:1;i:50;i:2;i:100;}}', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(27, NULL, 'status_notification', '1', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(28, NULL, 'comment_notification', '1', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(29, NULL, 'queue_emails', '0', '0', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(30, NULL, 'assigned_notification', '1', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(31, NULL, 'agent_restrict', '0', '0', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(32, NULL, 'close_ticket_perm', 'a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}', 'a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(33, NULL, 'reopen_ticket_perm', 'a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}', 'a:3:{s:5:\"owner\";b:1;s:5:\"agent\";b:1;s:5:\"admin\";b:1;}', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(34, NULL, 'delete_modal_type', 'builtin', 'builtin', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(35, NULL, 'editor_enabled', '1', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(36, NULL, 'include_font_awesome', '1', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(37, NULL, 'summernote_locale', 'en', 'en', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(38, NULL, 'editor_html_highlighter', '1', '1', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(39, NULL, 'codemirror_theme', 'monokai', 'monokai', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(40, NULL, 'summernote_options_json_file', 'vendor/kordy/ticketit/src/JSON/summernote_init.json', 'vendor/kordy/ticketit/src/JSON/summernote_init.json', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(41, NULL, 'purifier_config', 'a:3:{s:15:\"HTML.SafeIframe\";s:4:\"true\";s:20:\"URI.SafeIframeRegexp\";s:72:\"%^(http://|https://|//)(www.youtube.com/embed/|player.vimeo.com/video/)%\";s:18:\"URI.AllowedSchemes\";a:5:{s:4:\"data\";b:1;s:4:\"http\";b:1;s:5:\"https\";b:1;s:6:\"mailto\";b:1;s:3:\"ftp\";b:1;}}', 'a:3:{s:15:\"HTML.SafeIframe\";s:4:\"true\";s:20:\"URI.SafeIframeRegexp\";s:72:\"%^(http://|https://|//)(www.youtube.com/embed/|player.vimeo.com/video/)%\";s:18:\"URI.AllowedSchemes\";a:5:{s:4:\"data\";b:1;s:4:\"http\";b:1;s:5:\"https\";b:1;s:6:\"mailto\";b:1;s:3:\"ftp\";b:1;}}', '2019-01-07 00:14:47', '2019-01-07 00:14:47'),
(42, NULL, 'routes', 'C:\\laragon\\www\\charli\\vendor/kordy/ticketit/src/routes.php', 'C:\\laragon\\www\\charli\\vendor/kordy/ticketit/src/routes.php', '2019-01-07 00:14:47', '2019-01-07 00:14:47');

-- --------------------------------------------------------

--
-- Structure de la table `ticketit_statuses`
--

CREATE TABLE `ticketit_statuses` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `ticketit_statuses`
--

INSERT INTO `ticketit_statuses` (`id`, `name`, `color`) VALUES
(3, 'Envoyé', '#787878'),
(4, 'Ouvert', '#408080'),
(5, 'En cours de traitement', '#0080c0'),
(6, 'Traité', '#00ff00');

-- --------------------------------------------------------

--
-- Structure de la table `translations`
--

CREATE TABLE `translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int(10) UNSIGNED NOT NULL,
  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `translations`
--

INSERT INTO `translations` (`id`, `table_name`, `column_name`, `foreign_key`, `locale`, `value`, `created_at`, `updated_at`) VALUES
(1, 'data_types', 'display_name_singular', 5, 'pt', 'Post', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(2, 'data_types', 'display_name_singular', 6, 'pt', 'Página', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(3, 'data_types', 'display_name_singular', 1, 'pt', 'Utilizador', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(4, 'data_types', 'display_name_singular', 4, 'pt', 'Categoria', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(5, 'data_types', 'display_name_singular', 2, 'pt', 'Menu', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(6, 'data_types', 'display_name_singular', 3, 'pt', 'Função', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(7, 'data_types', 'display_name_plural', 5, 'pt', 'Posts', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(8, 'data_types', 'display_name_plural', 6, 'pt', 'Páginas', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(9, 'data_types', 'display_name_plural', 1, 'pt', 'Utilizadores', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(10, 'data_types', 'display_name_plural', 4, 'pt', 'Categorias', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(11, 'data_types', 'display_name_plural', 2, 'pt', 'Menus', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(12, 'data_types', 'display_name_plural', 3, 'pt', 'Funções', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(13, 'categories', 'slug', 1, 'pt', 'categoria-1', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(14, 'categories', 'name', 1, 'pt', 'Categoria 1', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(15, 'categories', 'slug', 2, 'pt', 'categoria-2', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(16, 'categories', 'name', 2, 'pt', 'Categoria 2', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(17, 'pages', 'title', 1, 'pt', 'Olá Mundo', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(18, 'pages', 'slug', 1, 'pt', 'ola-mundo', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(19, 'pages', 'body', 1, 'pt', '<p>Olá Mundo. Scallywag grog swab Cat o\'nine tails scuttle rigging hardtack cable nipper Yellow Jack. Handsomely spirits knave lad killick landlubber or just lubber deadlights chantey pinnace crack Jennys tea cup. Provost long clothes black spot Yellow Jack bilged on her anchor league lateen sail case shot lee tackle.</p>\r\n<p>Ballast spirits fluke topmast me quarterdeck schooner landlubber or just lubber gabion belaying pin. Pinnace stern galleon starboard warp carouser to go on account dance the hempen jig jolly boat measured fer yer chains. Man-of-war fire in the hole nipperkin handsomely doubloon barkadeer Brethren of the Coast gibbet driver squiffy.</p>', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(20, 'menu_items', 'title', 1, 'pt', 'Painel de Controle', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(21, 'menu_items', 'title', 2, 'pt', 'Media', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(22, 'menu_items', 'title', 12, 'pt', 'Publicações', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(23, 'menu_items', 'title', 3, 'pt', 'Utilizadores', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(24, 'menu_items', 'title', 11, 'pt', 'Categorias', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(25, 'menu_items', 'title', 13, 'pt', 'Páginas', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(26, 'menu_items', 'title', 4, 'pt', 'Funções', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(27, 'menu_items', 'title', 5, 'pt', 'Ferramentas', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(28, 'menu_items', 'title', 6, 'pt', 'Menus', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(29, 'menu_items', 'title', 7, 'pt', 'Base de dados', '2018-12-04 11:55:25', '2018-12-04 11:55:25'),
(30, 'menu_items', 'title', 10, 'pt', 'Configurações', '2018-12-04 11:55:25', '2018-12-04 11:55:25');

-- --------------------------------------------------------

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `upload_allowed` int(11) NOT NULL DEFAULT 4,
  `ticketit_admin` tinyint(1) NOT NULL DEFAULT 0,
  `ticketit_agent` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`, `upload_allowed`, `ticketit_admin`, `ticketit_agent`) VALUES
(1, 1, 'Admin', 'admin@admin.com', NULL, '$2y$10$E4ffes4wU1pUabbJ/Og5hevH15N3y8li.ozja/8theKCeNPlX6rb6', '77kQwyCkwM7X1xe9DQkpljpWuKFOfFj8nYa6Bb2NLVGciiwy1JiuW6NfHkbY', NULL, '2018-12-04 11:55:25', '2019-01-07 00:23:25', 1, 1, 0),
(2, 3, 'Testeur', 'testeur@test.fr', NULL, '$2y$10$2J.UmdRHNhb7RfQ51b1QKue29ZHMlZNdGt4x9pMsv2bJ3e/F8HKpu', 'hVgtMtaQZfYbWKDNh0a8BL2vj7jgZsl3kSpIrhlglXsoPo4DBzBIKUljf30Y', NULL, '2018-12-09 21:45:17', '2018-12-12 19:13:08', 1, 0, 0),
(3, 3, 'Testeur Deux', 'test2@test.fr', NULL, '$2y$10$ANxLD/4K0dAJvwN1g5bHGuKdDQ4.ebhnqbQIdY4b3mSFfdLynlWEy', '9IMBY7sg0cPaD1KW64oEhZ2bDRa5M6w3QI3rKp0ymukNROKqrqe2QTbBEI9I', NULL, '2018-12-12 20:19:43', '2018-12-12 20:19:43', 1, 0, 0),
(4, 4, 'Admin SMS', 'admin@sms.fr', NULL, '$2y$10$h9O7fkEJtIWBtSHOYOsxQOPMPFk6h4TrcPKAj9nDZqzONwid.Oji.', NULL, NULL, '2018-12-31 11:24:46', '2019-01-07 00:23:25', 4, 1, 0);

-- --------------------------------------------------------

--
-- Structure de la table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `user_roles`
--

INSERT INTO `user_roles` (`user_id`, `role_id`) VALUES
(1, 4);

-- --------------------------------------------------------

--
-- Structure de la table `videos`
--

CREATE TABLE `videos` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `user_id` int(11) DEFAULT NULL,
  `size` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `videos`
--

INSERT INTO `videos` (`id`, `name`, `file_name`, `duration`, `created_at`, `user_id`, `size`) VALUES
(10, 'Une belle vidéo', 'SampleVideo_1280x720_1mb_2019-01-05-23.mp4', 5312, '2019-01-05 15:57:27', 3, 1),
(11, 'Une vidéo encore plus fantastique', 'Video Sample of 720P HD Resolution 1280x720_2019-01-05-09.mp4', 122741, '2019-01-05 16:33:20', 3, 24);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `charlis`
--
ALTER TABLE `charlis`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `charlis_device_id_unique` (`device_id`);

--
-- Index pour la table `data_rows`
--
ALTER TABLE `data_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);

--
-- Index pour la table `data_types`
--
ALTER TABLE `data_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `data_types_name_unique` (`name`),
  ADD UNIQUE KEY `data_types_slug_unique` (`slug`);

--
-- Index pour la table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_name_unique` (`name`);

--
-- Index pour la table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_menu_id_foreign` (`menu_id`);

--
-- Index pour la table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Index pour la table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_key_index` (`key`);

--
-- Index pour la table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Index pour la table `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `posts_slug_unique` (`slug`);

--
-- Index pour la table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Index pour la table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

--
-- Index pour la table `ticketit`
--
ALTER TABLE `ticketit`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticketit_subject_index` (`subject`),
  ADD KEY `ticketit_status_id_index` (`status_id`),
  ADD KEY `ticketit_priority_id_index` (`priority_id`),
  ADD KEY `ticketit_user_id_index` (`user_id`),
  ADD KEY `ticketit_agent_id_index` (`agent_id`),
  ADD KEY `ticketit_category_id_index` (`category_id`),
  ADD KEY `ticketit_completed_at_index` (`completed_at`);

--
-- Index pour la table `ticketit_audits`
--
ALTER TABLE `ticketit_audits`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `ticketit_categories`
--
ALTER TABLE `ticketit_categories`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `ticketit_comments`
--
ALTER TABLE `ticketit_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ticketit_comments_user_id_index` (`user_id`),
  ADD KEY `ticketit_comments_ticket_id_index` (`ticket_id`);

--
-- Index pour la table `ticketit_priorities`
--
ALTER TABLE `ticketit_priorities`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `ticketit_settings`
--
ALTER TABLE `ticketit_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ticketit_settings_slug_unique` (`slug`),
  ADD UNIQUE KEY `ticketit_settings_lang_unique` (`lang`),
  ADD KEY `ticketit_settings_lang_index` (`lang`),
  ADD KEY `ticketit_settings_slug_index` (`slug`);

--
-- Index pour la table `ticketit_statuses`
--
ALTER TABLE `ticketit_statuses`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `translations`
--
ALTER TABLE `translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_role_id_foreign` (`role_id`);

--
-- Index pour la table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_user_id_index` (`user_id`),
  ADD KEY `user_roles_role_id_index` (`role_id`);

--
-- Index pour la table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `data_rows`
--
ALTER TABLE `data_rows`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=159;

--
-- AUTO_INCREMENT pour la table `data_types`
--
ALTER TABLE `data_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT pour la table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT pour la table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT pour la table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT pour la table `ticketit`
--
ALTER TABLE `ticketit`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT pour la table `ticketit_audits`
--
ALTER TABLE `ticketit_audits`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `ticketit_categories`
--
ALTER TABLE `ticketit_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `ticketit_comments`
--
ALTER TABLE `ticketit_comments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `ticketit_priorities`
--
ALTER TABLE `ticketit_priorities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `ticketit_settings`
--
ALTER TABLE `ticketit_settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT pour la table `ticketit_statuses`
--
ALTER TABLE `ticketit_statuses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `translations`
--
ALTER TABLE `translations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `videos`
--
ALTER TABLE `videos`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `data_rows`
--
ALTER TABLE `data_rows`
  ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Contraintes pour la table `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

