-- phpMyAdmin SQL Dump -- version 4.8.0.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Mar 23, 2019 at 09:45 AM -- Server version: 5.5.60-MariaDB -- PHP Version: 7.0.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `panvel` -- -- -------------------------------------------------------- -- -- Table structure for table `activations` -- CREATE TABLE `activations` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `ip_address` varchar(45) 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 `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 `password_resets` -- CREATE TABLE `password_resets` ( `id` int(10) UNSIGNED NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- 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); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone` int(10) DEFAULT NULL, `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `activated` tinyint(1) NOT NULL DEFAULT '0', `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `signup_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signup_confirmation_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `signup_sm_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `admin_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 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 `users` -- INSERT INTO `users` (`id`, `name`, `first_name`, `last_name`, `email`, `phone`, `password`, `remember_token`, `activated`, `token`, `signup_ip_address`, `signup_confirmation_ip_address`, `signup_sm_ip_address`, `admin_ip_address`, `updated_ip_address`, `deleted_ip_address`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'admin', 'Priscilla', 'Braun', 'admin@admin.com', 0, '$2y$10$BpSrtbn30nb0YMd4fpMwqOUtX3CEsntl52oeQXOYL3x8XlSK.MCXq', 'NzwDXnlsV00Wu9elJ380XByBQT9FtOvylHntEM1w5UWO6ZNPe5eB9qt7fU1v', 1, 'nJM6LmbrJhQVfX8EA7eDGqUgWiFwvF9HPiYibgzvrnXMHz8nGTvi2LWC9IRirTNT', NULL, '170.33.226.31', NULL, '53.164.27.190', '0.0.0.0', NULL, '2019-03-07 23:00:19', '2019-03-07 23:36:29', NULL), (2, 'ischinner', 'Courtney', 'Adams', 'user@user.com', 0, '$2y$10$1L5qqJjve4nsk94zomkhRuudtzMgia6WeW0kAzybtFnW4a8MiFk3y', '535VnQzKCQVO18AvHkYAeyo9Uva7NN6BBrzEdUYvRQei48vszjZpPkYXOeSE', 1, 'l1a1oFiIy2o29ULADrAlWozMNo3HM507oley6BGE4m2zDbKCRFJ4CNiRCd5TM3zH', '6.126.187.236', '37.108.62.87', NULL, NULL, NULL, NULL, '2019-03-07 23:00:19', '2019-03-07 23:00:19', NULL), (25, 'apiuser', 'api', 'user', 'api@user.com', 1234567890, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, 'd92e180e51501ff48427d164dfb7d337', NULL, NULL, NULL, NULL, NULL, NULL, '2019-03-12 11:41:07', '2019-03-12 11:41:07', NULL), (26, 'apiuser', 'api', 'user', 'api@user.com', 1234567890, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, '512250787aec5618c2eb30bca4ed0408', NULL, NULL, NULL, NULL, NULL, NULL, '2019-03-12 11:41:11', '2019-03-12 11:41:11', NULL), (27, 'apiuser', 'api', 'user', 'api@user.com', 1234567890, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, '5b9f360f430dbc7f07f760fe70289d13', NULL, NULL, NULL, NULL, NULL, NULL, '2019-03-12 13:41:36', '2019-03-12 13:41:36', NULL), (28, 'apiuser', 'api', 'user', 'api@user.com', NULL, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, '3d1ce3e62a5f3554101c5cd7326b2ee2', NULL, NULL, NULL, NULL, NULL, NULL, '2019-03-12 16:11:44', '2019-03-12 16:11:44', NULL), (29, 'apiuser', 'api', 'user', 'api@user.com', NULL, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, '0de9335aa68d165cb24efdc0375f2ea4', NULL, NULL, NULL, NULL, NULL, NULL, '2019-03-12 16:12:23', '2019-03-12 16:12:23', NULL), (30, 'apiuser', 'api', 'user', 'api@user.com', NULL, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, 'da27565b8662e0f6d90977a361283fd7', NULL, NULL, NULL, NULL, NULL, '192.168.0.213', '2019-03-12 16:12:30', '2019-03-22 09:44:43', '2019-03-22 09:44:43'), (31, 'apiuser', 'api', 'user', 'api@user.com', NULL, '827ccb0eea8a706c4c34a16891f84e7b', NULL, 1, '753b718dc51c3f0b9e9db68fe9fec6b3', NULL, NULL, NULL, NULL, NULL, '192.168.0.213', '2019-03-12 16:12:31', '2019-03-22 09:44:38', '2019-03-22 09:44:38'), (32, 'Saurabh', 'Saurabh', 'Jain', 'saurabh_jain@marketingmindz.in', NULL, '$2y$10$.xh8n9Tf0kjf1pCCU.9WXOStLGyh7VCZqCQDoaCmTQMNgnT4Ulmr2', 'bPXKXpr0Ius6e3VTVyCWpFtYFE89wDUTyZZnNk84fvuhPLTn93u6qH1o5KZV', 1, 'Yk5jJyTFUB99tNceGbfQ026vEs06atQHUPwJPExLZiBcwnnR48BFMF1pEplNcMlp', NULL, NULL, NULL, '192.168.0.213', NULL, NULL, '2019-03-23 16:23:59', '2019-03-23 16:23:59', NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `activations` -- ALTER TABLE `activations` ADD PRIMARY KEY (`id`), ADD KEY `activations_user_id_index` (`user_id`); -- -- 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 `password_resets` -- ALTER TABLE `password_resets` ADD PRIMARY KEY (`id`), ADD KEY `password_resets_email_index` (`email`), ADD KEY `password_resets_token_index` (`token`); -- -- 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`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `activations` -- ALTER TABLE `activations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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 `password_resets` -- ALTER TABLE `password_resets` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- 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; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- Constraints for dumped tables -- -- -- Constraints for table `activations` -- ALTER TABLE `activations` ADD CONSTRAINT `activations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;