-- MySQL dump 10.13 Distrib 5.7.22, for Linux (x86_64) -- -- Host: localhost Database: insura_test -- ------------------------------------------------------ -- Server version 5.7.22-0ubuntu0.16.04.1 /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `attachments` -- DROP TABLE IF EXISTS `attachments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `attachments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `attachee_id` int(10) unsigned NOT NULL, `attachee_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `filename` varchar(16) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `uploader_id` int(10) unsigned NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `attachments_uploader_id_foreign` (`uploader_id`), CONSTRAINT `attachments_uploader_id_foreign` FOREIGN KEY (`uploader_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attachments` -- LOCK TABLES `attachments` WRITE; /*!40000 ALTER TABLE `attachments` DISABLE KEYS */; /*!40000 ALTER TABLE `attachments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chats` -- DROP TABLE IF EXISTS `chats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chats` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `message` text COLLATE utf8_unicode_ci NOT NULL, `recipient_id` int(10) unsigned NOT NULL, `sender_id` int(10) unsigned NOT NULL, `status` enum('received','seen','sent') COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `chats_recipient_id_foreign` (`recipient_id`), KEY `chats_sender_id_foreign` (`sender_id`), CONSTRAINT `chats_recipient_id_foreign` FOREIGN KEY (`recipient_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `chats_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chats` -- LOCK TABLES `chats` WRITE; /*!40000 ALTER TABLE `chats` DISABLE KEYS */; /*!40000 ALTER TABLE `chats` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `client_notes` -- DROP TABLE IF EXISTS `client_notes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `client_notes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `message` text COLLATE utf8_unicode_ci NOT NULL, `subject_id` int(10) unsigned NOT NULL, `writer_id` int(10) unsigned NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `client_notes_subject_id_foreign` (`subject_id`), KEY `client_notes_writer_id_foreign` (`writer_id`), CONSTRAINT `client_notes_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `client_notes_writer_id_foreign` FOREIGN KEY (`writer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `client_notes` -- LOCK TABLES `client_notes` WRITE; /*!40000 ALTER TABLE `client_notes` DISABLE KEYS */; /*!40000 ALTER TABLE `client_notes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `companies` -- DROP TABLE IF EXISTS `companies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `companies` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `address` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL, `aft_api_key` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `aft_username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `currency_code` enum('AED','AFN','ALL','AMD','ANG','AOA','ARS','AUD','AWG','AFL','AZN','BAM','BDT','BBD','BGN','BHD','BIF','BSD','BMD','BND','BOB','BOV','BRL','BTN','BWP','BYN','BZD','CAD','CDF','CHE','CHF','CHW','CLF','CLP','CNY','COP','COU','CRC','CUC','CUP','CVE','CZK','DJF','DKK','DOP','DZD','EEK','EGP','ERN','ETB','EUR','FJD','FKP','GBP','GEL','GGP','GHS','GIP','GMD','GNF','GTQ','GYD','HKD','HNL','HRK','HTG','HUF','IDR','ILS','IMP','INR','IQD','IRR','ISK','JEP','JMD','JOD','JPY','KES','KGS','KHR','KMF','KPW','KRW','KWD','KYD','KZT','LAK','LBP','LKR','LRD','LSL','LTL','LVL','LYD','MAD','MDL','MGA','MKD','MMK','MNT','MOP','MRO','MUR','MVR','MWK','MXN','MXV','MYR','MZN','NAD','NGN','NIO','NOK','NPR','PRB','NZD','OMR','PAB','PEN','PGK','PHP','PKR','PLN','PYG','QAR','RON','RSD','RUB','RWF','SAR','SBD','SCR','SDG','SEK','SGD','SHP','SLL','SOS','SRD','SSP','STD','SVC','SYP','SZL','THB','TJS','TMT','TND','TOP','TRY','TTD','TVD','TWD','TZS','UAH','UGX','USD','USN','UYI','UYU','UZS','VEF','VND','VUV','WST','XAF','XAG','XAU','XBA','XBB','XBC','XBD','XCD','XDR','XOF','XPF','XPT','XSU','XTS','XUA','XXX','YER','ZAR','ZMK','ZMW','ZWD','ZWL') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'AED', `custom_fields_metadata` text COLLATE utf8_unicode_ci, `email` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `email_signature` text COLLATE utf8_unicode_ci, `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `product_categories` text COLLATE utf8_unicode_ci, `product_sub_categories` text COLLATE utf8_unicode_ci, `reminder_status` tinyint(1) NOT NULL DEFAULT '0', `text_provider` enum('aft','twilio') COLLATE utf8_unicode_ci DEFAULT NULL, `text_signature` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `twilio_auth_token` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `twilio_number` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `twilio_sid` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `companies` -- LOCK TABLES `companies` WRITE; /*!40000 ALTER TABLE `companies` DISABLE KEYS */; INSERT INTO `companies` VALUES (1,NULL,NULL,NULL,'AED',NULL,NULL,NULL,'Insura Inc.',NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,'2018-05-28 02:42:54','2018-05-28 02:42:54'); /*!40000 ALTER TABLE `companies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `custom_fields` -- DROP TABLE IF EXISTS `custom_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `custom_fields` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `label` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `model_id` int(10) unsigned NOT NULL, `model_type` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `type` enum('checkbox','date','email','hidden','number','select','tel','text','textarea') COLLATE utf8_unicode_ci NOT NULL, `uuid` char(23) COLLATE utf8_unicode_ci NOT NULL, `value` text COLLATE utf8_unicode_ci, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `custom_fields` -- LOCK TABLES `custom_fields` WRITE; /*!40000 ALTER TABLE `custom_fields` DISABLE KEYS */; /*!40000 ALTER TABLE `custom_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emails` -- DROP TABLE IF EXISTS `emails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emails` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `message` text COLLATE utf8_unicode_ci NOT NULL, `recipient_id` int(10) unsigned NOT NULL, `sender_id` int(10) unsigned NOT NULL, `status` tinyint(1) NOT NULL, `subject` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `emails_recipient_id_foreign` (`recipient_id`), KEY `emails_sender_id_foreign` (`sender_id`), CONSTRAINT `emails_recipient_id_foreign` FOREIGN KEY (`recipient_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `emails_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emails` -- LOCK TABLES `emails` WRITE; /*!40000 ALTER TABLE `emails` DISABLE KEYS */; /*!40000 ALTER TABLE `emails` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `connection` text COLLATE utf8_unicode_ci NOT NULL, `queue` text COLLATE utf8_unicode_ci NOT NULL, `payload` longtext COLLATE utf8_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `payload` longtext COLLATE utf8_unicode_ci NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_reserved_reserved_at_index` (`queue`,`reserved`,`reserved_at`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES ('2018_02_22_074656_companies',1),('2018_02_22_080034_users',1),('2018_02_22_080554_client_notes',1),('2018_02_22_080721_password_resets',1),('2018_02_22_081351_products',1),('2018_02_22_082805_policies',1),('2018_02_22_084717_payments',1),('2018_02_22_085338_attachments',1),('2018_02_22_090224_emails',1),('2018_02_22_091432_texts',1),('2018_02_22_091827_chats',1),('2018_02_22_092509_reminders',1),('2018_02_22_093310_jobs',1),('2018_02_22_093346_failed_jobs',1),('2018_02_22_093729_custom_fields',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', KEY `password_resets_email_index` (`email`), KEY `password_resets_token_index` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `amount` decimal(10,2) NOT NULL, `date` date NOT NULL, `method` enum('card','cash','paypal') COLLATE utf8_unicode_ci NOT NULL, `policy_id` int(10) unsigned NOT NULL, `user_id` int(10) unsigned NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `payments_policy_id_foreign` (`policy_id`), KEY `payments_user_id_foreign` (`user_id`), CONSTRAINT `payments_policy_id_foreign` FOREIGN KEY (`policy_id`) REFERENCES `policies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `policies` -- DROP TABLE IF EXISTS `policies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `policies` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `beneficiaries` text COLLATE utf8_unicode_ci, `expiry` date NOT NULL, `payer` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `premium` decimal(10,2) NOT NULL, `product_id` int(10) unsigned NOT NULL, `ref_no` char(8) COLLATE utf8_unicode_ci NOT NULL, `renewal` date NOT NULL, `special_remarks` text COLLATE utf8_unicode_ci, `type` enum('annually','monthly','weekly') COLLATE utf8_unicode_ci NOT NULL, `user_id` int(10) unsigned NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `policies_ref_no_unique` (`ref_no`), KEY `policies_product_id_foreign` (`product_id`), KEY `policies_user_id_foreign` (`user_id`), CONSTRAINT `policies_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `policies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `policies` -- LOCK TABLES `policies` WRITE; /*!40000 ALTER TABLE `policies` DISABLE KEYS */; /*!40000 ALTER TABLE `policies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `products` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `category` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `company_id` int(10) unsigned NOT NULL, `insurer` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `sub_category` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `products_company_id_foreign` (`company_id`), CONSTRAINT `products_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reminders` -- DROP TABLE IF EXISTS `reminders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reminders` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `company_id` int(10) unsigned NOT NULL, `days` int(11) NOT NULL, `message` text COLLATE utf8_unicode_ci NOT NULL, `subject` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `timeline` enum('after','before') COLLATE utf8_unicode_ci NOT NULL, `type` enum('email','text') COLLATE utf8_unicode_ci NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `reminders_company_id_foreign` (`company_id`), CONSTRAINT `reminders_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reminders` -- LOCK TABLES `reminders` WRITE; /*!40000 ALTER TABLE `reminders` DISABLE KEYS */; /*!40000 ALTER TABLE `reminders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `texts` -- DROP TABLE IF EXISTS `texts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `texts` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `message` text COLLATE utf8_unicode_ci NOT NULL, `recipient_id` int(10) unsigned NOT NULL, `sender_id` int(10) unsigned NOT NULL, `status` tinyint(1) NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `texts_recipient_id_foreign` (`recipient_id`), KEY `texts_sender_id_foreign` (`sender_id`), CONSTRAINT `texts_recipient_id_foreign` FOREIGN KEY (`recipient_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `texts_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `texts` -- LOCK TABLES `texts` WRITE; /*!40000 ALTER TABLE `texts` DISABLE KEYS */; /*!40000 ALTER TABLE `texts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `address` varchar(256) COLLATE utf8_unicode_ci DEFAULT NULL, `birthday` date DEFAULT NULL, `commission_rate` decimal(10,2) NOT NULL DEFAULT '0.00', `company_id` int(10) unsigned NOT NULL, `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `first_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `inviter_id` int(10) unsigned DEFAULT NULL, `last_name` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` char(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en_US', `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `phone` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `profile_image_filename` char(19) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default-profile.jpg', `role` enum('admin','broker','client','staff','super') COLLATE utf8_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), KEY `users_company_id_foreign` (`company_id`), KEY `users_inviter_id_foreign` (`inviter_id`), CONSTRAINT `users_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `users_inviter_id_foreign` FOREIGN KEY (`inviter_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,NULL,NULL,0.00,1,'demo@simcycreative.com','Demo',NULL,'Admin','en_US','$2y$10$xTxd/luv.JsH1weMs0vb8.yBq46rKpVjqDd22TRQSpiIHFmL07hxi',NULL,'default-profile.jpg','super',NULL,'2018-05-28 02:42:54','2018-05-28 02:42:54'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2018-05-28 8:52:12