-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `app_users`
--

CREATE TABLE `app_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_id` varchar(50) 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;

--
-- Dumping data for table `app_users`
--

INSERT INTO `app_users` (`id`, `phone`, `device_id`, `created_at`, `updated_at`) VALUES
(1, '1234567890', NULL, '2019-03-12 16:26:58', '2019-03-12 16:26:58'),
(2, '1234567810', NULL, '2019-03-12 16:42:12', '2019-03-12 16:42:12'),
(3, '1212121212', NULL, '2019-03-12 16:43:54', '2019-03-12 16:43:54'),
(4, '4444444444', NULL, '2019-03-12 16:47:34', '2019-03-12 16:47:34'),
(5, '444455444444', NULL, '2019-03-12 17:07:40', '2019-03-12 17:07:40'),
(6, '121231212', NULL, '2019-03-12 17:08:18', '2019-03-12 17:08:18'),
(7, '121211212', NULL, '2019-03-12 17:08:28', '2019-03-12 17:08:28'),
(8, '44442355444444', NULL, '2019-03-13 09:13:47', '2019-03-13 09:13:47'),
(9, '4444235444444', NULL, '2019-03-13 09:13:55', '2019-03-13 09:13:55'),
(10, '+911111111111', NULL, '2019-03-13 09:55:42', '2019-03-13 09:55:42'),
(11, '121281212', NULL, '2019-03-13 10:00:22', '2019-03-13 10:00:22'),
(12, '5454545454', NULL, '2019-03-13 10:00:53', '2019-03-13 10:00:53'),
(13, '5454548454', NULL, '2019-03-13 10:05:36', '2019-03-13 10:05:36'),
(14, '5456568454', NULL, '2019-03-13 10:10:26', '2019-03-13 10:10:26'),
(15, '+911515254556', NULL, '2019-03-13 10:10:38', '2019-03-13 10:10:38'),
(16, '+915656255955', NULL, '2019-03-13 10:14:41', '2019-03-13 10:14:41'),
(17, '+911122122221', NULL, '2019-03-13 10:16:42', '2019-03-13 10:16:42'),
(18, '+912885353535', NULL, '2019-03-13 10:17:54', '2019-03-13 10:17:54'),
(19, '+915828293835', NULL, '2019-03-13 10:18:43', '2019-03-13 10:18:43'),
(20, '+918828828828', NULL, '2019-03-13 10:19:42', '2019-03-13 10:19:42'),
(21, '+918282822228', NULL, '2019-03-13 10:23:33', '2019-03-13 10:23:33'),
(22, '+915355255552', NULL, '2019-03-13 10:24:05', '2019-03-13 10:24:05'),
(23, '+913525253535', NULL, '2019-03-13 10:24:43', '2019-03-13 10:24:43'),
(24, '+915282828282', NULL, '2019-03-13 10:26:19', '2019-03-13 10:26:19'),
(25, '+912255556555', NULL, '2019-03-13 10:27:33', '2019-03-13 10:27:33'),
(26, '+912555555555', NULL, '2019-03-13 10:28:12', '2019-03-13 10:28:12'),
(27, '+918383838383', NULL, '2019-03-13 10:30:32', '2019-03-13 10:30:32'),
(28, '+918838353535', NULL, '2019-03-13 10:35:19', '2019-03-13 10:35:19'),
(29, '+910282835353', NULL, '2019-03-13 10:36:24', '2019-03-13 10:36:24'),
(30, '+913525225382', NULL, '2019-03-13 10:37:11', '2019-03-13 10:37:11'),
(31, '+918528288828', NULL, '2019-03-13 10:38:51', '2019-03-13 10:38:51'),
(32, '+915353535353', NULL, '2019-03-13 10:40:02', '2019-03-13 10:40:02'),
(33, '+915353535355', NULL, '2019-03-13 10:40:37', '2019-03-13 10:40:37'),
(34, '5459878454', NULL, '2019-03-13 10:40:48', '2019-03-13 10:40:48'),
(35, '+918653535555', NULL, '2019-03-13 10:43:17', '2019-03-13 10:43:17'),
(36, '+915353535253', NULL, '2019-03-13 10:52:04', '2019-03-13 10:52:04'),
(37, '+915835353835', NULL, '2019-03-13 10:57:11', '2019-03-13 10:57:11'),
(38, '+916538683538', NULL, '2019-03-13 11:02:11', '2019-03-13 11:02:11'),
(39, '+918619375919', NULL, '2019-03-13 15:09:59', '2019-03-13 15:09:59'),
(40, '+918094556013', NULL, '2019-03-13 15:58:58', '2019-03-13 15:58:58'),
(41, '+917568540140', NULL, '2019-03-13 16:28:24', '2019-03-13 16:28:24');

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` int(10) UNSIGNED NOT NULL,
  `complaint_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(20) NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `complaint_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assign` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `img_url1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_url2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_url3` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_url4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img_url5` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `complaints`
--

INSERT INTO `complaints` (`id`, `complaint_number`, `user_id`, `title`, `description`, `address`, `complaint_status`, `assign`, `img_url`, `created_at`, `updated_at`, `img_url1`, `img_url2`, `img_url3`, `img_url4`, `img_url5`) VALUES
(6, 'pvcn213417035176', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'closed', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_2041586604.jpeg', '2019-03-20 10:40:42', '2019-03-20 10:40:42', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1201269286.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1782915886.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1428798755.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1439535695.jpeg', NULL),
(7, 'pvcn211722035176', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'open', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1516362470.jpeg', '2019-03-20 10:41:36', '2019-03-20 10:41:36', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1299856997.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_280151514.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1332566992.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1674255200.jpeg', NULL),
(8, 'pvcn211702335176', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'open', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_2997384.jpeg', '2019-03-20 10:42:19', '2019-03-23 09:41:06', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_144348718.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_695753948.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_32527884.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1436609810.jpeg', NULL),
(9, 'pvcn2117032335176', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'open', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_493171459.jpeg', '2019-03-20 10:43:47', '2019-03-20 10:43:47', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_2104457597.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_673557971.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_534575155.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1595594168.jpeg', NULL),
(10, 'pvcn2112327035176', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'closed', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1361862229.jpeg', '2019-03-20 10:44:02', '2019-03-20 10:44:02', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_753501882.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1456287628.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1275853947.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1968009651.jpeg', NULL),
(11, 'pvcn211711035176', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'open', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1636938760.jpeg', '2019-03-20 10:45:25', '2019-03-20 10:45:25', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_697638000.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_99031243.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1790993208.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_561459065.jpeg', NULL),
(12, 'pvcn21170354545', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'open', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1178310679.jpeg', '2019-03-20 10:45:47', '2019-03-20 10:45:47', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1969983363.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1287221509.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1078001157.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1387550175.jpeg', NULL),
(13, 'pvcn21170351454', 3, 'ploolution issue', 'pluution is excees not soltion, poor air quaality', '202 vardhman nagar jaipur', 'pending', NULL, 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_924952471.jpeg', '2019-03-20 10:56:04', '2019-03-20 10:56:04', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_36458594.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_701066809.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_1467373259.jpeg', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-20_213745663.jpeg', NULL),
(14, 'pvcn2117035176', 3, 'test', 'test', NULL, 'pending', NULL, NULL, '2019-03-20 15:27:58', '2019-03-20 15:27:58', NULL, NULL, NULL, NULL, NULL),
(15, 'pvcn697275233', 3, 'amt', 'tweqw', '200 patrakar colony', 'pending', NULL, NULL, '2019-03-20 15:52:43', '2019-03-22 17:21:10', NULL, NULL, NULL, NULL, NULL),
(16, 'pvcn11720860', 3, 'amt', 'tweqw wqe est', '200 vardhman', 'closed', NULL, NULL, '2019-03-20 15:53:17', '2019-03-20 15:53:17', NULL, NULL, NULL, NULL, NULL),
(17, 'pvcn1237491371', 3, 'test compiant', 'tweqw wqsadsad asd sa sadsa asdsae est', NULL, 'open', NULL, NULL, '2019-03-23 10:11:03', '2019-03-23 10:11:03', NULL, NULL, NULL, NULL, NULL),
(18, 'pvcn186271570', 3, 'Water issue', 'Water is polluted.', '200 patrakar colony', 'open', 'engineer', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1054080450.png', '2019-03-23 10:50:47', '2019-03-23 16:15:21', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1177806253.png', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1672411406.png', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1944959163.png', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_567182680.png', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1574911964.png'),
(19, 'pvcn530438815', 83, 'test compiant', 'tweqw wqsadsad asd sa sadsa asdsae est', NULL, 'open', NULL, NULL, '2019-03-23 14:22:14', '2019-03-23 14:22:14', NULL, NULL, NULL, NULL, NULL),
(20, 'pvcn579761437', 785, 'test compiant', 'tweqw wqsadsad asd sa sadsa asdsae est', NULL, 'open', NULL, NULL, '2019-03-23 14:22:22', '2019-03-23 14:22:22', NULL, NULL, NULL, NULL, NULL),
(21, 'pvcn770249425', 9509718, 'Water Problem', 'gfhgsd fsfgshf sdhfgsdhfgshfgshfgsh fhgshfgsdhfgsdhgfsdjfg dsjfgdshgfshdfghsdgfjsdhgf fjdsgfhdgfdsgf dfgdsfgdsjfh dsfgjdsfgdsj fjdsgfds jfhgdsh fdsfgshdfj sjdsfjfgd', 'Jaipur, Mansarovar #220', 'open', 'engineer', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_331346439.png', '2019-03-23 16:34:09', '2019-03-23 16:34:09', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1448761160.png', 'http://192.168.0.93/panvel/public/images/complaint_2019-03-23_1566789207.png', NULL, NULL, NULL);

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

--
-- Table structure for table `complaint_comments`
--

CREATE TABLE `complaint_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(50) DEFAULT NULL,
  `complaint_id` int(50) NOT NULL,
  `comment` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_img_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment_img_url1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment_img_url2` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment_img_url3` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment_img_url4` varchar(100) 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;

--
-- Dumping data for table `complaint_comments`
--

INSERT INTO `complaint_comments` (`id`, `user_id`, `complaint_id`, `comment`, `author`, `comment_img_url`, `comment_img_url1`, `comment_img_url2`, `comment_img_url3`, `comment_img_url4`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'euirtwe weroywe rwoeirywe rweiorywe rweoirywe rwoer erp yer', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-20 10:31:20', '2019-03-20 10:31:20'),
(2, 3, 1, 'euirtwe weroywe rwoeirywe rweiorywe rweoirywe rwoer erp yer', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-20 10:31:36', '2019-03-20 10:31:36'),
(3, 3, 1, 'this is not a valid solution', 'user', 'http://192.168.0.93/panvel/public/images/comment_2019-03-20_1271576186.jpeg', NULL, NULL, NULL, NULL, '2019-03-20 12:08:27', '2019-03-20 12:08:27'),
(4, 3, 1, 'euirtwe weroywe rwoeirywe rweiorywe rweoirywe rwoer erp yer', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-20 12:26:49', '2019-03-20 12:26:49'),
(5, 3, 17, 'euirtwe weroywe rwoeirywe lllllllllllllllllllllllll rweoirywe rwoer erp yer', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:14:29', '2019-03-23 10:14:29'),
(6, 3, 3, 'test', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:15:50', '2019-03-23 10:15:50'),
(7, 3, 3, 'test', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:17:22', '2019-03-23 10:17:22'),
(8, 3, 3, 'test', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:18:40', '2019-03-23 10:18:40'),
(9, 3, 17, 'iuqe qweut doi qwp wqeuq pwqeuwq r', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:25:48', '2019-03-23 10:25:48'),
(10, 3, 17, 'thanks for your help with', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:43:11', '2019-03-23 10:43:11'),
(11, 3, 17, 'thanks for letting me know about this weekend', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:44:52', '2019-03-23 10:44:52'),
(12, 3, 17, 'tty', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:46:22', '2019-03-23 10:46:22'),
(13, 3, 17, 'we are going to be there', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:47:28', '2019-03-23 10:47:28'),
(14, 3, 17, 'I will be there', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:48:36', '2019-03-23 10:48:36'),
(15, 3, 17, 'hfghghhh', 'user', 'http://192.168.0.93/panvel/public/images/comment_2019-03-23_753849066.jpeg', NULL, NULL, NULL, NULL, '2019-03-23 10:49:53', '2019-03-23 10:49:53'),
(16, 3, 17, 'I will be there in the morning?', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:51:39', '2019-03-23 10:51:39'),
(17, 3, 17, 'jguhhghh', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:52:50', '2019-03-23 10:52:50'),
(18, 3, 17, 'iuqe qweut doi qwp wqeuq pwqeuwq r', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:53:27', '2019-03-23 10:53:27'),
(19, 3, 17, 'ggfg', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:55:14', '2019-03-23 10:55:14'),
(20, 3, 17, 'ggfg', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:55:48', '2019-03-23 10:55:48'),
(21, 3, 17, 'guruhghjuuygh', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 10:56:48', '2019-03-23 10:56:48'),
(22, 3, 17, 'uthv yhubyhybun', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 11:01:46', '2019-03-23 11:01:46'),
(23, 3, 17, 'we are at', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 11:05:34', '2019-03-23 11:05:34'),
(24, 3, 17, 'we are at the airport', 'user', NULL, NULL, NULL, NULL, NULL, '2019-03-23 11:06:27', '2019-03-23 11:06:27'),
(25, 3, 17, 'asdsad', 'admin', NULL, NULL, NULL, NULL, NULL, '2019-03-23 15:40:16', '2019-03-23 15:40:16'),
(26, 3, 17, 'asdsad', 'admin', NULL, NULL, NULL, NULL, NULL, '2019-03-23 15:40:49', '2019-03-23 15:40:49'),
(28, 3, 17, 'Pls this is', 'admin', NULL, NULL, NULL, NULL, NULL, '2019-03-23 15:56:21', '2019-03-23 15:56:21');

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

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

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

--
-- Dumping data for 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_15_105324_create_roles_table', 1),
(4, '2016_01_15_114412_create_role_user_table', 1),
(5, '2016_01_26_115212_create_permissions_table', 1),
(6, '2016_01_26_115523_create_permission_role_table', 1),
(7, '2016_02_09_132439_create_permission_user_table', 1),
(8, '2017_03_09_082449_create_social_logins_table', 1),
(9, '2017_03_09_082526_create_activations_table', 1),
(10, '2017_03_20_213554_create_themes_table', 1),
(11, '2017_03_21_042918_create_profiles_table', 1),
(12, '2017_05_20_095210_create_tasks_table', 1),
(13, '2019_03_12_113250_create_complaints_table', 2),
(14, '2019_03_12_121855_create_app_users_table', 3),
(15, '2019_03_15_113624_create_complaint_comments_table', 4);

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

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

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model` varchar(191) 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;

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

INSERT INTO `permissions` (`id`, `name`, `slug`, `description`, `model`, `created_at`, `updated_at`) VALUES
(1, 'Can View Users', 'view.users', 'Can view users', 'Permission', '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(2, 'Can Create Users', 'create.users', 'Can create new users', 'Permission', '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(3, 'Can Edit Users', 'edit.users', 'Can edit users', 'Permission', '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(4, 'Can Delete Users', 'delete.users', 'Can delete users', 'Permission', '2019-03-07 23:00:02', '2019-03-07 23:00:02');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_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;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(2, 2, 1, '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(3, 3, 1, '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(4, 4, 1, '2019-03-07 23:00:02', '2019-03-07 23:00:02');

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

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  `user_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;

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `theme_id` int(10) UNSIGNED NOT NULL DEFAULT '1',
  `location` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8mb4_unicode_ci,
  `twitter_username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `github_username` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_status` tinyint(1) NOT NULL DEFAULT '0',
  `user_profile_bg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '/images/default-user-bg.png',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `theme_id`, `location`, `bio`, `twitter_username`, `github_username`, `avatar`, `avatar_status`, `user_profile_bg`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL, NULL, NULL, NULL, 0, '/images/default-user-bg.png', '2019-03-07 23:00:19', '2019-03-07 23:00:19'),
(2, 2, 1, NULL, NULL, NULL, NULL, NULL, 0, '/images/default-user-bg.png', '2019-03-07 23:00:19', '2019-03-07 23:00:19'),
(3, 32, 1, NULL, NULL, NULL, NULL, NULL, 0, '/images/default-user-bg.png', '2019-03-23 16:23:59', '2019-03-23 16:23:59');

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

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

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `level`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin', 'Admin Role', 5, '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(2, 'User', 'user', 'User Role', 1, '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(3, 'Unverified', 'unverified', 'Unverified Role', 0, '2019-03-07 23:00:02', '2019-03-07 23:00:02'),
(4, 'Engineer', 'engineer', 'Engineer Role', 1, NULL, NULL),
(5, 'Technician', 'technician', 'Technician Role', 1, NULL, NULL);

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `user_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;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES
(2, 2, 2, '2019-03-07 23:00:19', '2019-03-07 23:00:19'),
(4, 1, 1, '2019-03-07 23:37:07', '2019-03-07 23:37:07'),
(5, 4, 32, '2019-03-23 16:23:59', '2019-03-23 16:23:59');

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

--
-- Table structure for table `social_logins`
--

CREATE TABLE `social_logins` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `provider` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_id` 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;

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `completed` 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;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `user_id`, `name`, `description`, `completed`, `created_at`, `updated_at`) VALUES
(1, 1, 'test', 'test', 0, '2019-03-07 23:38:21', '2019-03-22 09:07:50'),
(2, 1, 'test', 'test tetet', 0, '2019-03-22 09:44:26', '2019-03-22 15:14:02'),
(3, 1, 'rtes', 'seee', 0, '2019-03-22 16:04:30', '2019-03-22 16:04:30'),
(4, 1, 'tatrtart', 'tttasggdgsgsh', 0, '2019-03-22 16:29:48', '2019-03-22 16:29:48');

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

--
-- Table structure for table `themes`
--

CREATE TABLE `themes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `taggable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taggable_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `themes`
--

INSERT INTO `themes` (`id`, `name`, `link`, `notes`, `status`, `taggable_type`, `taggable_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Default', 'material.min.css', NULL, 1, 'theme', 1, '2019-03-07 23:00:02', '2019-03-07 23:00:11', NULL),
(2, 'Amber / Blue', 'material.amber-blue.min.css', NULL, 1, 'theme', 2, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(3, 'Amber / Cyan', 'material.amber-cyan.min.css', NULL, 1, 'theme', 3, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(4, 'Amber / Deep Orange', 'material.amber-deep_orange.min.css', NULL, 1, 'theme', 4, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(5, 'Amber / Deep Purple', 'material.amber-deep_purple.min.css', NULL, 1, 'theme', 5, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(6, 'Amber / Green', 'material.amber-green.min.css', NULL, 1, 'theme', 6, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(7, 'Amber / Indigo', 'material.amber-indigo.min.css', NULL, 1, 'theme', 7, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(8, 'Amber / Light Blue', 'material.amber-light_blue.min.css', NULL, 1, 'theme', 8, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(9, 'Amber / Light Green', 'material.amber-light_green.min.css', NULL, 1, 'theme', 9, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(10, 'Amber / Lime', 'material.amber-lime.min.css', NULL, 1, 'theme', 10, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(11, 'Amber / Orange', 'material.amber-orange.min.css', NULL, 1, 'theme', 11, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(12, 'Amber / Pink', 'material.amber-pink.min.css', NULL, 1, 'theme', 12, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(13, 'Amber / Purple', 'material.amber-purple.min.css', NULL, 1, 'theme', 13, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(14, 'Amber / Red', 'material.amber-red.min.css', NULL, 1, 'theme', 14, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(15, 'Amber / Teal', 'material.amber-teal.min.css', NULL, 1, 'theme', 15, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(16, 'Amber / Yellow', 'material.amber-yellow.min.css', NULL, 1, 'theme', 16, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(17, 'Blue Grey / Amber', 'material.blue_grey-amber.min.css', NULL, 1, 'theme', 17, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(18, 'Blue Grey / Blue', 'material.blue_grey-blue.min.css', NULL, 1, 'theme', 18, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(19, 'Blue Grey / Cyan', 'material.blue_grey-cyan.min.css', NULL, 1, 'theme', 19, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(20, 'Blue Grey / Deep Orange', 'material.blue_grey-deep_orange.min.css', NULL, 1, 'theme', 20, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(21, 'Blue Grey / Deep Purple', 'material.blue_grey-deep_purple.min.css', NULL, 1, 'theme', 21, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(22, 'Blue Grey / Green', 'material.blue_grey-green.min.css', NULL, 1, 'theme', 22, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(23, 'Blue Grey / Indigo', 'material.blue_grey-indigo.min.css', NULL, 1, 'theme', 23, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(24, 'Blue Grey / Light Blue', 'material.blue_grey-light_blue.min.css', NULL, 1, 'theme', 24, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(25, 'Blue Grey / Light Green', 'material.blue_grey-light_green.min.css', NULL, 1, 'theme', 25, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(26, 'Blue Grey / Lime', 'material.blue_grey-lime.min.css', NULL, 1, 'theme', 26, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(27, 'Blue Grey / Orange', 'material.blue_grey-orange.min.css', NULL, 1, 'theme', 27, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(28, 'Blue Grey / Pink', 'material.blue_grey-pink.min.css', NULL, 1, 'theme', 28, '2019-03-07 23:00:03', '2019-03-07 23:00:11', NULL),
(29, 'Blue Grey / Purple', 'material.blue_grey-purple.min.css', NULL, 1, 'theme', 29, '2019-03-07 23:00:03', '2019-03-07 23:00:12', NULL),
(30, 'Blue Grey / Red', 'material.blue_grey-red.min.css', NULL, 1, 'theme', 30, '2019-03-07 23:00:03', '2019-03-07 23:00:12', NULL),
(31, 'Blue Grey / Teal', 'material.blue_grey-teal.min.css', NULL, 1, 'theme', 31, '2019-03-07 23:00:03', '2019-03-07 23:00:12', NULL),
(32, 'Blue Grey / Yellow', 'material.blue_grey-yellow.min.css', NULL, 1, 'theme', 32, '2019-03-07 23:00:03', '2019-03-07 23:00:12', NULL),
(33, 'Blue / Amber', 'material.blue-amber.min.css', NULL, 1, 'theme', 33, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(34, 'Blue / Cyan', 'material.blue-cyan.min.css', NULL, 1, 'theme', 34, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(35, 'Blue / Deep Orange', 'material.blue-deep_orange.min.css', NULL, 1, 'theme', 35, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(36, 'Blue / Deep Purple', 'material.blue-deep_purple.min.css', NULL, 1, 'theme', 36, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(37, 'Blue / Green', 'material.blue-green.min.css', NULL, 1, 'theme', 37, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(38, 'Blue / Indigo', 'material.blue-indigo.min.css', NULL, 1, 'theme', 38, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(39, 'Blue / Light Blue', 'material.blue-light_blue.min.css', NULL, 1, 'theme', 39, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(40, 'Blue / Light Green', 'material.blue-light_green.min.css', NULL, 1, 'theme', 40, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(41, 'Blue / Lime', 'material.blue-lime.min.css', NULL, 1, 'theme', 41, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(42, 'Blue / Orange', 'material.blue-orange.min.css', NULL, 1, 'theme', 42, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(43, 'Blue / Pink', 'material.blue-pink.min.css', NULL, 1, 'theme', 43, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(44, 'Blue / Purple', 'material.blue-purple.min.css', NULL, 1, 'theme', 44, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(45, 'Blue / Red', 'material.blue-red.min.css', NULL, 1, 'theme', 45, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(46, 'Blue / Teal', 'material.blue-teal.min.css', NULL, 1, 'theme', 46, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(47, 'Blue / Yellow', 'material.blue-yellow.min.css', NULL, 1, 'theme', 47, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(48, 'Brown / Amber', 'material.brown-amber.min.css', NULL, 1, 'theme', 48, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(49, 'Brown / Blue', 'material.brown-blue.min.css', NULL, 1, 'theme', 49, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(50, 'Brown / Cyan', 'material.brown-cyan.min.css', NULL, 1, 'theme', 50, '2019-03-07 23:00:04', '2019-03-07 23:00:12', NULL),
(51, 'Brown / Deep Orange', 'material.brown-deep_orange.min.css', NULL, 1, 'theme', 51, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(52, 'Brown / Deep Purple', 'material.brown-deep_purple.min.css', NULL, 1, 'theme', 52, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(53, 'Brown / Green', 'material.brown-green.min.css', NULL, 1, 'theme', 53, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(54, 'Brown / Indigo', 'material.brown-indigo.min.css', NULL, 1, 'theme', 54, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(55, 'Brown / Light Blue', 'material.brown-light_blue.min.css', NULL, 1, 'theme', 55, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(56, 'Brown / Light Green', 'material.brown-light_green.min.css', NULL, 1, 'theme', 56, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(57, 'Brown / Lime', 'material.brown-lime.min.css', NULL, 1, 'theme', 57, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(58, 'Brown / Orange', 'material.brown-orange.min.css', NULL, 1, 'theme', 58, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(59, 'Brown / Pink', 'material.brown-pink.min.css', NULL, 1, 'theme', 59, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(60, 'Brown / Purple', 'material.brown-purple.min.css', NULL, 1, 'theme', 60, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(61, 'Brown / Red', 'material.brown-red.min.css', NULL, 1, 'theme', 61, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(62, 'Brown / Teal', 'material.brown-teal.min.css', NULL, 1, 'theme', 62, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(63, 'Brown / Yellow', 'material.brown-yellow.min.css', NULL, 1, 'theme', 63, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(64, 'Cyan / Amber', 'material.cyan-amber.min.css', NULL, 1, 'theme', 64, '2019-03-07 23:00:04', '2019-03-07 23:00:13', NULL),
(65, 'Cyan / Blue', 'material.cyan-blue.min.css', NULL, 1, 'theme', 65, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(66, 'Cyan / Deep Orange', 'material.cyan-deep_orange.min.css', NULL, 1, 'theme', 66, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(67, 'Cyan / Deep Purple', 'material.cyan-deep_purple.min.css', NULL, 1, 'theme', 67, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(68, 'Cyan / Green', 'material.cyan-green.min.css', NULL, 1, 'theme', 68, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(69, 'Cyan / Indigo', 'material.cyan-indigo.min.css', NULL, 1, 'theme', 69, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(70, 'Cyan / Light Blue', 'material.cyan-light_blue.min.css', NULL, 1, 'theme', 70, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(71, 'Cyan / Light Green', 'material.cyan-light_green.min.css', NULL, 1, 'theme', 71, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(72, 'Cyan / Lime', 'material.cyan-lime.min.css', NULL, 1, 'theme', 72, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(73, 'Cyan / Orange', 'material.cyan-orange.min.css', NULL, 1, 'theme', 73, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(74, 'Cyan / Pink', 'material.cyan-pink.min.css', NULL, 1, 'theme', 74, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(75, 'Cyan / Purple', 'material.cyan-purple.min.css', NULL, 1, 'theme', 75, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(76, 'Cyan / Red', 'material.cyan-red.min.css', NULL, 1, 'theme', 76, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(77, 'Cyan / Teal', 'material.cyan-teal.min.css', NULL, 1, 'theme', 77, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(78, 'Cyan / Yellow', 'material.cyan-yellow.min.css', NULL, 1, 'theme', 78, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(79, 'Deep Orange / Amber', 'material.deep_orange-amber.min.css', NULL, 1, 'theme', 79, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(80, 'Deep Orange / Blue', 'material.deep_orange-blue.min.css', NULL, 1, 'theme', 80, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(81, 'Deep Orange / Cyan', 'material.deep_orange-cyan.min.css', NULL, 1, 'theme', 81, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(82, 'Deep Orange / Deep Purple', 'material.deep_orange-deep_purple.min.css', NULL, 1, 'theme', 82, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(83, 'Deep Orange / Green', 'material.deep_orange-green.min.css', NULL, 1, 'theme', 83, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(84, 'Deep Orange / Indigo', 'material.deep_orange-indigo.min.css', NULL, 1, 'theme', 84, '2019-03-07 23:00:05', '2019-03-07 23:00:13', NULL),
(85, 'Deep Orange / Light Blue', 'material.deep_orange-light_blue.min.css', NULL, 1, 'theme', 85, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(86, 'Deep Orange / Light Green', 'material.deep_orange-light_green.min.css', NULL, 1, 'theme', 86, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(87, 'Deep Orange / Lime', 'material.deep_orange-lime.min.css', NULL, 1, 'theme', 87, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(88, 'Deep Orange / Orange', 'material.deep_orange-orange.min.css', NULL, 1, 'theme', 88, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(89, 'Deep Orange / Pink', 'material.deep_orange-pink.min.css', NULL, 1, 'theme', 89, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(90, 'Deep Orange / Purple', 'material.deep_orange-purple.min.css', NULL, 1, 'theme', 90, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(91, 'Deep Orange / Red', 'material.deep_orange-red.min.css', NULL, 1, 'theme', 91, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(92, 'Deep Orange / Teal', 'material.deep_orange-teal.min.css', NULL, 1, 'theme', 92, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(93, 'Deep Orange / Yellow', 'material.deep_orange-yellow.min.css', NULL, 1, 'theme', 93, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(94, 'Deep Purple / Amber', 'material.deep_purple-amber.min.css', NULL, 1, 'theme', 94, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(95, 'Deep Purple / Blue', 'material.deep_purple-blue.min.css', NULL, 1, 'theme', 95, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(96, 'Deep Purple / Cyan', 'material.deep_purple-cyan.min.css', NULL, 1, 'theme', 96, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(97, 'Deep Purple / Deep Orange', 'material.deep_purple-deep_orange.min.css', NULL, 1, 'theme', 97, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(98, 'Deep Purple / Green', 'material.deep_purple-green.min.css', NULL, 1, 'theme', 98, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(99, 'Yellow / Teal', 'material.yellow-teal.min.css', NULL, 1, 'theme', 99, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(100, 'Yellow / Red', 'material.yellow-red.min.css', NULL, 1, 'theme', 100, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(101, 'Yellow / Orange', 'material.yellow-orange.min.css', NULL, 1, 'theme', 101, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(102, 'Yellow / Pink', 'material.yellow-pink.min.css', NULL, 1, 'theme', 102, '2019-03-07 23:00:05', '2019-03-07 23:00:14', NULL),
(103, 'Yellow / Purple', 'material.yellow-purple.min.css', NULL, 1, 'theme', 103, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(104, 'Yellow / Lime', 'material.yellow-lime.min.css', NULL, 1, 'theme', 104, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(105, 'Yellow / Light Green', 'material.yellow-light_green.min.css', NULL, 1, 'theme', 105, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(106, 'Yellow / Indigo', 'material.yellow-indigo.min.css', NULL, 1, 'theme', 106, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(107, 'Yellow / Light Blue', 'material.yellow-light_blue.min.css', NULL, 1, 'theme', 107, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(108, 'Yellow / Green', 'material.yellow-green.min.css', NULL, 1, 'theme', 108, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(109, 'Yellow / Deep Purple', 'material.yellow-deep_purple.min.css', NULL, 1, 'theme', 109, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(110, 'Yellow / Deep Orange', 'material.yellow-deep_orange.min.css', NULL, 1, 'theme', 110, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(111, 'Yellow / Cyan', 'material.yellow-cyan.min.css', NULL, 1, 'theme', 111, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(112, 'Yellow / Blue', 'material.yellow-blue.min.css', NULL, 1, 'theme', 112, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(113, 'Yellow / Amber', 'material.yellow-amber.min.css', NULL, 1, 'theme', 113, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(114, 'Teal / Yellow', 'material.teal-yellow.min.css', NULL, 1, 'theme', 114, '2019-03-07 23:00:06', '2019-03-07 23:00:14', NULL),
(115, 'Teal / Red', 'material.teal-red.min.css', NULL, 1, 'theme', 115, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(116, 'Teal / Purple', 'material.teal-purple.min.css', NULL, 1, 'theme', 116, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(117, 'Teal / Pink', 'material.teal-pink.min.css', NULL, 1, 'theme', 117, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(118, 'Teal / Orange', 'material.teal-orange.min.css', NULL, 1, 'theme', 118, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(119, 'Teal / Lime', 'material.teal-lime.min.css', NULL, 1, 'theme', 119, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(120, 'Teal / Light Green', 'material.teal-light_green.min.css', NULL, 1, 'theme', 120, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(121, 'Teal / Light Blue', 'material.teal-light_blue.min.css', NULL, 1, 'theme', 121, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(122, 'Teal / Indigo', 'material.teal-indigo.min.css', NULL, 1, 'theme', 122, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(123, 'Teal / Green', 'material.teal-green.min.css', NULL, 1, 'theme', 123, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(124, 'Teal / Deep Purple', 'material.teal-deep_purple.min.css', NULL, 1, 'theme', 124, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(125, 'Teal / Deep Orange', 'material.teal-deep_orange.min.css', NULL, 1, 'theme', 125, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(126, 'Teal / Cyan', 'material.teal-cyan.min.css', NULL, 1, 'theme', 126, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(127, 'Teal / Blue', 'material.teal-blue.min.css', NULL, 1, 'theme', 127, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(128, 'Teal / Amber', 'material.teal-amber.min.css', NULL, 1, 'theme', 128, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(129, 'Red / Yellow', 'material.red-yellow.min.css', NULL, 1, 'theme', 129, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(130, 'Red / Teal', 'material.red-teal.min.css', NULL, 1, 'theme', 130, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(131, 'Red / Purple', 'material.red-purple.min.css', NULL, 1, 'theme', 131, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(132, 'Red / Pink', 'material.red-pink.min.css', NULL, 1, 'theme', 132, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(133, 'Red / Orange', 'material.red-orange.min.css', NULL, 1, 'theme', 133, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(134, 'Red / Lime', 'material.red-lime.min.css', NULL, 1, 'theme', 134, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(135, 'Red / Light Green', 'material.red-light_green.min.css', NULL, 1, 'theme', 135, '2019-03-07 23:00:06', '2019-03-07 23:00:15', NULL),
(136, 'Red / Light Blue', 'material.red-light_blue.min.css', NULL, 1, 'theme', 136, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(137, 'Red / Indigo', 'material.red-indigo.min.css', NULL, 1, 'theme', 137, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(138, 'Red / Green', 'material.red-green.min.css', NULL, 1, 'theme', 138, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(139, 'Red / Deep Purple', 'material.red-deep_purple.min.css', NULL, 1, 'theme', 139, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(140, 'Red / Deep Orange', 'material.red-deep_orange.min.css', NULL, 1, 'theme', 140, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(141, 'Red / Cyan', 'material.red-cyan.min.css', NULL, 1, 'theme', 141, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(142, 'Red / Blue', 'material.red-blue.min.css', NULL, 1, 'theme', 142, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(143, 'Red / Amber', 'material.red-amber.min.css', NULL, 1, 'theme', 143, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(144, 'Purple / Yellow', 'material.purple-yellow.min.css', NULL, 1, 'theme', 144, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(145, 'Purple / Teal', 'material.purple-teal.min.css', NULL, 1, 'theme', 145, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(146, 'Purple / Pink', 'material.purple-pink.min.css', NULL, 1, 'theme', 146, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(147, 'Purple / Orange', 'material.purple-orange.min.css', NULL, 1, 'theme', 147, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(148, 'Purple / Lime', 'material.purple-lime.min.css', NULL, 1, 'theme', 148, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(149, 'Purple / Light Green', 'material.purple-light_green.min.css', NULL, 1, 'theme', 149, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(150, 'Purple / Light Blue', 'material.purple-light_blue.min.css', NULL, 1, 'theme', 150, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(151, 'Purple / Indigo', 'material.purple-indigo.min.css', NULL, 1, 'theme', 151, '2019-03-07 23:00:07', '2019-03-07 23:00:15', NULL),
(152, 'Purple / Green', 'material.purple-green.min.css', NULL, 1, 'theme', 152, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(153, 'Purple / Deep Purple', 'material.purple-deep_purple.min.css', NULL, 1, 'theme', 153, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(154, 'Purple / Deep Orange', 'material.purple-deep_orange.min.css', NULL, 1, 'theme', 154, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(155, 'Purple / Cyan', 'material.purple-cyan.min.css', NULL, 1, 'theme', 155, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(156, 'Purple / Blue', 'material.purple-blue.min.css', NULL, 1, 'theme', 156, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(157, 'Purple / Amber', 'material.purple-amber.min.css', NULL, 1, 'theme', 157, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(158, 'Pink / Yellow', 'material.pink-yellow.min.css', NULL, 1, 'theme', 158, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(159, 'Pink / Teal', 'material.pink-teal.min.css', NULL, 1, 'theme', 159, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(160, 'Pink / Red', 'material.pink-red.min.css', NULL, 1, 'theme', 160, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(161, 'Pink / Purple', 'material.pink-purple.min.css', NULL, 1, 'theme', 161, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(162, 'Pink / Orange', 'material.pink-orange.min.css', NULL, 1, 'theme', 162, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(163, 'Pink / Lime', 'material.pink-lime.min.css', NULL, 1, 'theme', 163, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(164, 'Pink / Light Green', 'material.pink-light_green.min.css', NULL, 1, 'theme', 164, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(165, 'Pink / Light Blue', 'material.pink-light_blue.min.css', NULL, 1, 'theme', 165, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(166, 'Pink / Indigo', 'material.pink-indigo.min.css', NULL, 1, 'theme', 166, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(167, 'Pink / Green', 'material.pink-green.min.css', NULL, 1, 'theme', 167, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(168, 'Pink / Deep Purple', 'material.pink-deep_purple.min.css', NULL, 1, 'theme', 168, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(169, 'Pink / Deep Orange', 'material.pink-deep_orange.min.css', NULL, 1, 'theme', 169, '2019-03-07 23:00:07', '2019-03-07 23:00:16', NULL),
(170, 'Pink / Cyan', 'material.pink-cyan.min.css', NULL, 1, 'theme', 170, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(171, 'Pink / Blue', 'material.pink-blue.min.css', NULL, 1, 'theme', 171, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(172, 'Pink / Amber', 'material.pink-amber.min.css', NULL, 1, 'theme', 172, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(173, 'Orange / Yellow', 'material.orange-yellow.min.css', NULL, 1, 'theme', 173, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(174, 'Orange / Teal', 'material.orange-teal.min.css', NULL, 1, 'theme', 174, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(175, 'Orange / Red', 'material.orange-red.min.css', NULL, 1, 'theme', 175, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(176, 'Orange / Purple', 'material.orange-purple.min.css', NULL, 1, 'theme', 176, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(177, 'Orange / Pink', 'material.orange-pink.min.css', NULL, 1, 'theme', 177, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(178, 'Orange / Lime', 'material.orange-lime.min.css', NULL, 1, 'theme', 178, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(179, 'Orange / Light Green', 'material.orange-light_green.min.css', NULL, 1, 'theme', 179, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(180, 'Orange / Light Blue', 'material.orange-light_blue.min.css', NULL, 1, 'theme', 180, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(181, 'Orange / Indigo', 'material.orange-indigo.min.css', NULL, 1, 'theme', 181, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(182, 'Orange / Green', 'material.orange-green.min.css', NULL, 1, 'theme', 182, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(183, 'Orange / Deep Purple', 'material.orange-deep_purple.min.css', NULL, 1, 'theme', 183, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(184, 'Orange / Deep Orange', 'material.orange-deep_orange.min.css', NULL, 1, 'theme', 184, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(185, 'Orange / Cyan', 'material.orange-cyan.min.css', NULL, 1, 'theme', 185, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(186, 'Orange / Amber', 'material.orange-amber.min.css', NULL, 1, 'theme', 186, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(187, 'Orange / Blue', 'material.orange-blue.min.css', NULL, 1, 'theme', 187, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(188, 'Lime / Yellow', 'material.lime-yellow.min.css', NULL, 1, 'theme', 188, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(189, 'Lime / Teal', 'material.lime-teal.min.css', NULL, 1, 'theme', 189, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(190, 'Lime / Red', 'material.lime-red.min.css', NULL, 1, 'theme', 190, '2019-03-07 23:00:08', '2019-03-07 23:00:16', NULL),
(191, 'Lime / Purple', 'material.lime-purple.min.css', NULL, 1, 'theme', 191, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(192, 'Lime / Pink', 'material.lime-pink.min.css', NULL, 1, 'theme', 192, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(193, 'Lime / Orange', 'material.lime-orange.min.css', NULL, 1, 'theme', 193, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(194, 'Lime / Light Green', 'material.lime-light_green.min.css', NULL, 1, 'theme', 194, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(195, 'Lime / Light Blue', 'material.lime-light_blue.min.css', NULL, 1, 'theme', 195, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(196, 'Lime / Indigo', 'material.lime-indigo.min.css', NULL, 1, 'theme', 196, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(197, 'Lime / Green', 'material.lime-green.min.css', NULL, 1, 'theme', 197, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(198, 'Lime / Deep Orange', 'material.lime-deep_orange.min.css', NULL, 1, 'theme', 198, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(199, 'Lime / Deep Purple', 'material.lime-deep_purple.min.css', NULL, 1, 'theme', 199, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(200, 'Lime / Cyan', 'material.lime-cyan.min.css', NULL, 1, 'theme', 200, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(201, 'Lime / Blue', 'material.lime-blue.min.css', NULL, 1, 'theme', 201, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(202, 'Lime / Amber', 'material.lime-amber.min.css', NULL, 1, 'theme', 202, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(203, 'Light Green / Yellow', 'material.light_green-yellow.min.css', NULL, 1, 'theme', 203, '2019-03-07 23:00:08', '2019-03-07 23:00:17', NULL),
(204, 'Light Green / Teal', 'material.light_green-teal.min.css', NULL, 1, 'theme', 204, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(205, 'Light Green / Red', 'material.light_green-red.min.css', NULL, 1, 'theme', 205, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(206, 'Light Green / Purple', 'material.light_green-purple.min.css', NULL, 1, 'theme', 206, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(207, 'Light Green / Pink', 'material.light_green-pink.min.css', NULL, 1, 'theme', 207, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(208, 'Light Green / Orange', 'material.light_green-orange.min.css', NULL, 1, 'theme', 208, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(209, 'Light Green / Lime', 'material.light_green-lime.min.css', NULL, 1, 'theme', 209, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(210, 'Light Green / Light Blue', 'material.light_green-light_blue.min.css', NULL, 1, 'theme', 210, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(211, 'Light Green / Indigo', 'material.light_green-indigo.min.css', NULL, 1, 'theme', 211, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(212, 'Light Green / Green', 'material.light_green-green.min.css', NULL, 1, 'theme', 212, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(213, 'Light Green / Deep Purple', 'material.light_green-deep_purple.min.css', NULL, 1, 'theme', 213, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(214, 'Light Green / Deep Orange', 'material.light_green-deep_orange.min.css', NULL, 1, 'theme', 214, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(215, 'Light Green / Cyan', 'material.light_green-cyan.min.css', NULL, 1, 'theme', 215, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(216, 'Light Green / Blue', 'material.light_green-blue.min.css', NULL, 1, 'theme', 216, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(217, 'Light Green / Amber', 'material.light_green-amber.min.css', NULL, 1, 'theme', 217, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(218, 'Light Blue / Yellow', 'material.light_blue-yellow.min.css', NULL, 1, 'theme', 218, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(219, 'Light Blue / Teal', 'material.light_blue-teal.min.css', NULL, 1, 'theme', 219, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(220, 'Light Blue / Red', 'material.light_blue-red.min.css', NULL, 1, 'theme', 220, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(221, 'Light Blue / Purple', 'material.light_blue-purple.min.css', NULL, 1, 'theme', 221, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(222, 'Light Blue / Pink', 'material.light_blue-pink.min.css', NULL, 1, 'theme', 222, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(223, 'Light Blue / Orange', 'material.light_blue-orange.min.css', NULL, 1, 'theme', 223, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(224, 'Light Blue / Lime', 'material.light_blue-lime.min.css', NULL, 1, 'theme', 224, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(225, 'Light Blue / Light Green', 'material.light_blue-light_green.min.css', NULL, 1, 'theme', 225, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(226, 'Light Blue / Indigo', 'material.light_blue-indigo.min.css', NULL, 1, 'theme', 226, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(227, 'Light Blue / Green', 'material.light_blue-green.min.css', NULL, 1, 'theme', 227, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(228, 'Light Blue / Deep Purple', 'material.light_blue-deep_purple.min.css', NULL, 1, 'theme', 228, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(229, 'Light Blue / Deep Orange', 'material.light_blue-deep_orange.min.css', NULL, 1, 'theme', 229, '2019-03-07 23:00:09', '2019-03-07 23:00:17', NULL),
(230, 'Light Blue / Cyan', 'material.light_blue-cyan.min.css', NULL, 1, 'theme', 230, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(231, 'Light Blue / Blue', 'material.light_blue-blue.min.css', NULL, 1, 'theme', 231, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(232, 'Light Blue / Amber', 'material.light_blue-amber.min.css', NULL, 1, 'theme', 232, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(233, 'Indigo / Yellow', 'material.indigo-yellow.min.css', NULL, 1, 'theme', 233, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(234, 'Indigo / Teal', 'material.indigo-teal.min.css', NULL, 1, 'theme', 234, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(235, 'Indigo / Red', 'material.indigo-red.min.css', NULL, 1, 'theme', 235, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(236, 'Indigo / Purple', 'material.indigo-purple.min.css', NULL, 1, 'theme', 236, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(237, 'Indigo / Pink', 'material.indigo-pink.min.css', NULL, 1, 'theme', 237, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(238, 'Indigo / Orange', 'material.indigo-orange.min.css', NULL, 1, 'theme', 238, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(239, 'Indigo / Lime', 'material.indigo-lime.min.css', NULL, 1, 'theme', 239, '2019-03-07 23:00:09', '2019-03-07 23:00:18', NULL),
(240, 'Indigo / Light Green', 'material.indigo-light_green.min.css', NULL, 1, 'theme', 240, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(241, 'Indigo / Light Blue', 'material.indigo-light_blue.min.css', NULL, 1, 'theme', 241, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(242, 'Indigo / Green', 'material.indigo-green.min.css', NULL, 1, 'theme', 242, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(243, 'Indigo / Deep Purple', 'material.indigo-deep_purple.min.css', NULL, 1, 'theme', 243, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(244, 'Indigo / Deep Orange', 'material.indigo-deep_orange.min.css', NULL, 1, 'theme', 244, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(245, 'Indigo / Cyan', 'material.indigo-cyan.min.css', NULL, 1, 'theme', 245, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(246, 'Indigo / Blue', 'material.indigo-blue.min.css', NULL, 1, 'theme', 246, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(247, 'Indigo / Amber', 'material.indigo-amber.min.css', NULL, 1, 'theme', 247, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(248, 'Grey / Yellow', 'material.grey-yellow.min.css', NULL, 1, 'theme', 248, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(249, 'Grey / Teal', 'material.grey-teal.min.css', NULL, 1, 'theme', 249, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(250, 'Grey / Red', 'material.grey-red.min.css', NULL, 1, 'theme', 250, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(251, 'Grey / Purple', 'material.grey-purple.min.css', NULL, 1, 'theme', 251, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(252, 'Grey / Pink', 'material.grey-pink.min.css', NULL, 1, 'theme', 252, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(253, 'Grey / Orange', 'material.grey-orange.min.css', NULL, 1, 'theme', 253, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(254, 'Grey / Lime', 'material.grey-lime.min.css', NULL, 1, 'theme', 254, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(255, 'Grey / Light Green', 'material.grey-light_green.min.css', NULL, 1, 'theme', 255, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(256, 'Grey / Light Blue', 'material.grey-light_blue.min.css', NULL, 1, 'theme', 256, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(257, 'Grey / Indigo', 'material.grey-indigo.min.css', NULL, 1, 'theme', 257, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(258, 'Grey / Green', 'material.grey-green.min.css', NULL, 1, 'theme', 258, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(259, 'Grey / Deep Purple', 'material.grey-deep_purple.min.css', NULL, 1, 'theme', 259, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(260, 'Grey / Deep Orange', 'material.grey-deep_orange.min.css', NULL, 1, 'theme', 260, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(261, 'Grey / Cyan', 'material.grey-cyan.min.css', NULL, 1, 'theme', 261, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(262, 'Grey / Blue', 'material.grey-blue.min.css', NULL, 1, 'theme', 262, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(263, 'Grey / Amber', 'material.grey-amber.min.css', NULL, 1, 'theme', 263, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(264, 'Green / Yellow', 'material.green-yellow.min.css', NULL, 1, 'theme', 264, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(265, 'Green / Teal', 'material.green-teal.min.css', NULL, 1, 'theme', 265, '2019-03-07 23:00:10', '2019-03-07 23:00:18', NULL),
(266, 'Green / Red', 'material.green-red.min.css', NULL, 1, 'theme', 266, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(267, 'Green / Purple', 'material.green-purple.min.css', NULL, 1, 'theme', 267, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(268, 'Green / Pink', 'material.green-pink.min.css', NULL, 1, 'theme', 268, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(269, 'Green / Orange', 'material.green-orange.min.css', NULL, 1, 'theme', 269, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(270, 'Green / Lime', 'material.green-lime.min.css', NULL, 1, 'theme', 270, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(271, 'Green / Light Green', 'material.green-light_green.min.css', NULL, 1, 'theme', 271, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(272, 'Green / Light Blue', 'material.green-light_blue.min.css', NULL, 1, 'theme', 272, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(273, 'Green / Indigo', 'material.green-indigo.min.css', NULL, 1, 'theme', 273, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(274, 'Green / Deep Purple', 'material.green-deep_purple.min.css', NULL, 1, 'theme', 274, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(275, 'Green / Deep Orange', 'material.green-deep_orange.min.css', NULL, 1, 'theme', 275, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(276, 'Green / Cyan', 'material.green-cyan.min.css', NULL, 1, 'theme', 276, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(277, 'Green / Blue', 'material.green-blue.min.css', NULL, 1, 'theme', 277, '2019-03-07 23:00:10', '2019-03-07 23:00:19', NULL),
(278, 'Green / Amber', 'material.green-amber.min.css', NULL, 1, 'theme', 278, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(279, 'Deep Purple / Yellow', 'material.deep_purple-yellow.min.css', NULL, 1, 'theme', 279, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(280, 'Deep Purple / Teal', 'material.deep_purple-teal.min.css', NULL, 1, 'theme', 280, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(281, 'Deep Purple / Red', 'material.deep_purple-red.min.css', NULL, 1, 'theme', 281, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(282, 'Deep Purple / Purple', 'material.deep_purple-purple.min.css', NULL, 1, 'theme', 282, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(283, 'Deep Purple / Pink', 'material.deep_purple-pink.min.css', NULL, 1, 'theme', 283, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(284, 'Deep Purple / Orange', 'material.deep_purple-orange.min.css', NULL, 1, 'theme', 284, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(285, 'Deep Purple / Lime', 'material.deep_purple-lime.min.css', NULL, 1, 'theme', 285, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(286, 'Deep Purple / Light Green', 'material.deep_purple-light_green.min.css', NULL, 1, 'theme', 286, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(287, 'Deep Purple / Light Blue', 'material.deep_purple-light_blue.min.css', NULL, 1, 'theme', 287, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL),
(288, 'Deep Purple / Indigo', 'material.deep_purple-indigo.min.css', NULL, 1, 'theme', 288, '2019-03-07 23:00:11', '2019-03-07 23:00:19', NULL);

--
-- Indexes for table `app_users`
--
ALTER TABLE `app_users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `complaint_comments`
--
ALTER TABLE `complaint_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_slug_unique` (`slug`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indexes for table `permission_user`
--
ALTER TABLE `permission_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_user_permission_id_index` (`permission_id`),
  ADD KEY `permission_user_user_id_index` (`user_id`);

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `profiles_theme_id_foreign` (`theme_id`),
  ADD KEY `profiles_user_id_index` (`user_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_user_role_id_index` (`role_id`),
  ADD KEY `role_user_user_id_index` (`user_id`);

--
-- Indexes for table `social_logins`
--
ALTER TABLE `social_logins`
  ADD PRIMARY KEY (`id`),
  ADD KEY `social_logins_user_id_index` (`user_id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tasks_user_id_foreign` (`user_id`);

--
-- Indexes for table `themes`
--
ALTER TABLE `themes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `themes_name_unique` (`name`),
  ADD UNIQUE KEY `themes_link_unique` (`link`),
  ADD KEY `themes_taggable_type_taggable_id_index` (`taggable_type`,`taggable_id`),
  ADD KEY `themes_id_index` (`id`);

--
-- AUTO_INCREMENT for table `app_users`
--
ALTER TABLE `app_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `complaint_comments`
--
ALTER TABLE `complaint_comments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `permission_role`
--
ALTER TABLE `permission_role`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `permission_user`
--
ALTER TABLE `permission_user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `profiles`
--
ALTER TABLE `profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `role_user`
--
ALTER TABLE `role_user`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `social_logins`
--
ALTER TABLE `social_logins`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `themes`
--
ALTER TABLE `themes`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=289;

--
-- Constraints for 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;

--
-- Constraints for table `permission_user`
--
ALTER TABLE `permission_user`
  ADD CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `profiles`
--
ALTER TABLE `profiles`
  ADD CONSTRAINT `profiles_theme_id_foreign` FOREIGN KEY (`theme_id`) REFERENCES `themes` (`id`),
  ADD CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `social_logins`
--
ALTER TABLE `social_logins`
  ADD CONSTRAINT `social_logins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

