· 6 years ago · Aug 16, 2019, 10:28 PM
1-- MySQL dump 10.16 Distrib 10.1.38-MariaDB, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: ims
4-- ------------------------------------------------------
5-- Server version 10.1.38-MariaDB-0ubuntu0.18.10.2
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `groups`
20--
21SET FOREIGN_KEY_CHECKS=0;
22
23DROP TABLE IF EXISTS `groups`;
24/*!40101 SET @saved_cs_client = @@character_set_client */;
25/*!40101 SET character_set_client = utf8 */;
26CREATE TABLE `groups` (
27 `id` bigint(20) NOT NULL AUTO_INCREMENT,
28 `updated_by` bigint(20) DEFAULT NULL,
29 `deleted_by` bigint(20) DEFAULT NULL,
30 `created_by` bigint(20) DEFAULT NULL,
31 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
32 `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
33 `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
34 `locked` tinyint(1) DEFAULT NULL,
35 `enabled` tinyint(1) NOT NULL,
36 `created_at` datetime NOT NULL,
37 `updated_at` datetime DEFAULT NULL,
38 `deleted_at` datetime DEFAULT NULL,
39 PRIMARY KEY (`id`),
40 KEY `IDX_F06D397016FE72E1` (`updated_by`),
41 KEY `IDX_F06D39701F6FA0AF` (`deleted_by`),
42 KEY `IDX_F06D3970DE12AB56` (`created_by`),
43 CONSTRAINT `FK_F06D397016FE72E1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
44 CONSTRAINT `FK_F06D39701F6FA0AF` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`id`),
45 CONSTRAINT `FK_F06D3970DE12AB56` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
46) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
47/*!40101 SET character_set_client = @saved_cs_client */;
48
49--
50-- Dumping data for table `groups`
51--
52
53LOCK TABLES `groups` WRITE;
54/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
55INSERT INTO `groups` VALUES (1,NULL,NULL,NULL,'Super Admin','a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}','Super Admin',0,1,'2019-05-23 12:19:23',NULL,NULL),(2,NULL,NULL,NULL,'Back-office Officer','a:2:{i:0;s:8:\"ROLE_QC1\";i:1;s:15:\"ROLE_QC_PENDING\";}','Back-office Officer',0,1,'2019-05-16 19:10:39',NULL,NULL),(3,NULL,NULL,NULL,'Back-office Supervisor','a:4:{i:0;s:8:\"ROLE_QC2\";i:1;s:17:\"ROLE_QC2_REFERRED\";i:2;s:14:\"ROLE_EKYC_EDIT\";i:3;s:17:\"ROLE_GENERATE_PDF\";}','Back-office Supervisor',0,1,'2019-05-16 23:10:28',NULL,NULL),(4,NULL,NULL,NULL,'Compliance QA','a:4:{i:0;s:8:\"ROLE_QC3\";i:1;s:17:\"ROLE_QC3_REFERRED\";i:2;s:14:\"ROLE_EKYC_EDIT\";i:3;s:17:\"ROLE_GENERATE_PDF\";}','Compliance QA',0,1,'2019-05-22 07:06:37',NULL,NULL),(5,NULL,NULL,NULL,'Case Management Officer','a:1:{i:0;s:8:\"ROLE_QC4\";}','Case Management Officer',0,1,'2019-05-17 11:02:44',NULL,NULL),(6,NULL,NULL,NULL,'Case Management Supervisor','a:1:{i:0;s:8:\"ROLE_QC5\";}','Case Management Supervisor',0,1,'2019-05-23 03:26:11',NULL,NULL),(7,NULL,NULL,NULL,'Case Management Analyst','a:1:{i:0;s:8:\"ROLE_QC6\";}','Case Management Analyst',0,1,'2019-05-19 20:49:27',NULL,NULL),(8,NULL,NULL,NULL,'Technology Back office','a:4:{i:0;s:8:\"ROLE_QC7\";i:1;s:16:\"ROLE_QC7_PENDING\";i:2;s:29:\"ROLE_ALLOW_ACTION_FROM_SEARCH\";i:3;s:17:\"ROLE_GENERATE_PDF\";}','Technology Back office',0,1,'2019-05-19 23:17:30',NULL,NULL),(9,NULL,NULL,NULL,'General Users (CS)','a:1:{i:0;s:8:\"ROLE_QC8\";}','General Users (CS)',0,1,'2019-05-22 06:03:19',NULL,NULL),(10,NULL,NULL,NULL,'Admin Users','a:1:{i:0;s:8:\"ROLE_QC9\";}','Admin Users',0,1,'2019-05-18 09:35:28',NULL,NULL);
56/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
57UNLOCK TABLES;
58SET FOREIGN_KEY_CHECKS=1;
59/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
60
61/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
62/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
63/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
64/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
65/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
66/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
67/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
68
69-- Dump completed on 2019-07-31 12:40:52