-- Server version	5.6.16-log

/*!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 */;

DROP DATABASE IF EXISTS matt_test;
CREATE DATABASE matt_test;
USE matt_test;

--
-- Table structure for table `sm_m2m_group_dependency`
--

DROP TABLE IF EXISTS `sm_m2m_group_dependency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sm_m2m_group_dependency` (
  `dispatch_group` varchar(32) DEFAULT NULL,
  `assignment_group` varchar(32) DEFAULT NULL,
  `sys_id` char(32) NOT NULL DEFAULT '',
  `sys_updated_by` varchar(40) DEFAULT NULL,
  `sys_updated_on` datetime DEFAULT NULL,
  `sys_created_by` varchar(40) DEFAULT NULL,
  `sys_created_on` datetime DEFAULT NULL,
  `sys_mod_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`sys_id`),
  KEY `dispatch_group` (`dispatch_group`),
  KEY `assignment_group` (`assignment_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sm_m2m_group_dependency`
--

LOCK TABLES `sm_m2m_group_dependency` WRITE;
/*!40000 ALTER TABLE `sm_m2m_group_dependency` DISABLE KEYS */;
INSERT INTO `sm_m2m_group_dependency` VALUES ('6dd9f63237232000158bbfc8bcbe5dc1','7172ea0037332000158bbfc8bcbe5db6','083880e037003000158bbfc8bcbe5dc8','admin','2017-04-16 02:26:12','admin','2017-04-16 02:26:12',0),('4c0482b237232000158bbfc8bcbe5d09','7172ea0037332000158bbfc8bcbe5db6','111888a037003000158bbfc8bcbe5d98','admin','2017-04-16 02:25:44','admin','2017-04-16 02:25:44',0),('81a880e037003000158bbfc8bcbe5df8','7172ea0037332000158bbfc8bcbe5db6','161944e037003000158bbfc8bcbe5d34','admin','2017-04-16 02:30:15','admin','2017-04-16 02:30:15',0),('61d9f63237232000158bbfc8bcbe5dbd','7172ea0037332000158bbfc8bcbe5db6','16f74ca037003000158bbfc8bcbe5d59','admin','2017-04-16 02:25:21','admin','2017-04-16 02:25:21',0),('25d9f63237232000158bbfc8bcbe5db3','96346e0037332000158bbfc8bcbe5daa','256880e037003000158bbfc8bcbe5d95','admin','2017-04-16 02:27:12','admin','2017-04-16 02:27:12',0),('b4f342b237232000158bbfc8bcbe5def','f304ae0037332000158bbfc8bcbe5d4f','2998c0e037003000158bbfc8bcbe5dfc','admin','2017-04-16 02:27:57','admin','2017-04-16 02:27:57',0),('011969e237232000158bbfc8bcbe5d3e','7864ae0037332000158bbfc8bcbe5db8','2de740e037003000158bbfc8bcbe5dd9','admin','2017-04-16 02:24:57','admin','2017-04-16 02:24:57',0),('29d9f63237232000158bbfc8bcbe5dc5','f304ae0037332000158bbfc8bcbe5d4f','3498c0e037003000158bbfc8bcbe5df0','admin','2017-04-16 02:27:53','admin','2017-04-16 02:27:53',0),('add9f63237232000158bbfc8bcbe5dbb','7172ea0037332000158bbfc8bcbe5db6','3d2880e037003000158bbfc8bcbe5da2','admin','2017-04-16 02:26:03','admin','2017-04-16 02:26:03',0),('61d9f63237232000158bbfc8bcbe5dc9','7172ea0037332000158bbfc8bcbe5db6','3e28cca037003000158bbfc8bcbe5d6f','admin','2017-04-16 02:26:07','admin','2017-04-16 02:26:07',0),('21d9f63237232000158bbfc8bcbe5db1','7864ae0037332000158bbfc8bcbe5db8','43d78ca037003000158bbfc8bcbe5d79','admin','2017-04-16 02:24:52','admin','2017-04-16 02:24:52',0),('e9d9f63237232000158bbfc8bcbe5dba','7172ea0037332000158bbfc8bcbe5db6','4b3880e037003000158bbfc8bcbe5d7f','admin','2017-04-16 02:26:25','admin','2017-04-16 02:26:25',0),('17801ac21b13200050fdfbcd2c0713e8','f253da061b13200050fdfbcd2c0713ab','4ee57bfe1b23200050fdfbcd2c071307','admin','2017-03-29 22:59:54','admin','2017-03-29 22:59:54',0),('e5d9f63237232000158bbfc8bcbe5dbf','f304ae0037332000158bbfc8bcbe5d4f','5398c0e037003000158bbfc8bcbe5dbb','admin','2017-04-16 02:28:04','admin','2017-04-16 02:28:04',0),('69d9f63237232000158bbfc8bcbe5dcb','7172ea0037332000158bbfc8bcbe5db6','5c188ca037003000158bbfc8bcbe5dbc','admin','2017-04-16 02:25:40','admin','2017-04-16 02:25:40',0),('577ed708d773020058c92cf65e61037a','699708d4d773020058c92cf65e61037c','623a8cd4d773020058c92cf65e6103ea','admin','2017-05-12 22:47:59','admin','2017-05-12 22:47:59',0),('96fb652637232000158bbfc8bcbe5db4','df50316637232000158bbfc8bcbe5d23','6835bd6637232000158bbfc8bcbe5d21','admin','2017-03-28 18:58:59','admin','2017-03-28 18:58:55',1),('e1d9f63237232000158bbfc8bcbe5db8','96346e0037332000158bbfc8bcbe5daa','697880e037003000158bbfc8bcbe5dcd','admin','2017-04-16 02:27:24','admin','2017-04-16 02:27:24',0),('25d9f63237232000158bbfc8bcbe5dbe','f304ae0037332000158bbfc8bcbe5d4f','6a9804e037003000158bbfc8bcbe5d09','admin','2017-04-16 02:28:00','admin','2017-04-16 02:28:00',0),('96fb652637232000158bbfc8bcbe5db4','e08fad2637232000158bbfc8bcbe5d39','6d25f96637232000158bbfc8bcbe5d79','admin','2017-03-28 18:58:45','admin','2017-03-28 18:58:45',0),('e9d9f63237232000158bbfc8bcbe5dc6','7172ea0037332000158bbfc8bcbe5db6','702880e037003000158bbfc8bcbe5d94','admin','2017-04-16 02:25:59','admin','2017-04-16 02:25:59',0),('a5d9f63237232000158bbfc8bcbe5dca','f304ae0037332000158bbfc8bcbe5d4f','7188c0e037003000158bbfc8bcbe5d75','admin','2017-04-16 02:27:45','admin','2017-04-16 02:27:45',0),('65d9f63237232000158bbfc8bcbe5dc4','f304ae0037332000158bbfc8bcbe5d4f','778880e037003000158bbfc8bcbe5d9e','admin','2017-04-16 02:27:49','admin','2017-04-16 02:27:49',0),('a1d9f63237232000158bbfc8bcbe5dc3','7172ea0037332000158bbfc8bcbe5db6','7d0840e037003000158bbfc8bcbe5dde','admin','2017-04-16 02:25:30','admin','2017-04-16 02:25:30',0),('21d9f63237232000158bbfc8bcbe5db7','96346e0037332000158bbfc8bcbe5daa','7f6880e037003000158bbfc8bcbe5da7','admin','2017-04-16 02:27:16','admin','2017-04-16 02:27:16',0),('96fb652637232000158bbfc8bcbe5db4','ec70316637232000158bbfc8bcbe5d60','8025f96637232000158bbfc8bcbe5dd0','admin','2017-03-28 18:58:40','admin','2017-03-28 18:58:40',0),('3dd9f63237232000158bbfc8bcbe5dcc','7172ea0037332000158bbfc8bcbe5db6','823880e037003000158bbfc8bcbe5ded','admin','2017-04-16 02:26:21','admin','2017-04-16 02:26:21',0),('96fb652637232000158bbfc8bcbe5db4','7b10fd2637232000158bbfc8bcbe5d30','9a353d6637232000158bbfc8bcbe5dee','admin','2017-03-28 18:59:06','admin','2017-03-28 18:59:06',0),('75d9f63237232000158bbfc8bcbe5dd0','ebb4620037332000158bbfc8bcbe5d89','a558c0e037003000158bbfc8bcbe5d36','admin','2017-04-16 02:26:51','admin','2017-04-16 02:26:51',0),('6dd9f63237232000158bbfc8bcbe5db5','96346e0037332000158bbfc8bcbe5daa','bc78cca037003000158bbfc8bcbe5d74','admin','2017-04-16 02:27:21','admin','2017-04-16 02:27:21',0),('add9f63237232000158bbfc8bcbe5dc7','7172ea0037332000158bbfc8bcbe5db6','c53804a037003000158bbfc8bcbe5db8','admin','2017-04-16 02:26:16','admin','2017-04-16 02:26:16',0),('fdd9f63237232000158bbfc8bcbe5dcd','7864ae0037332000158bbfc8bcbe5db8','cfe740e037003000158bbfc8bcbe5de8','admin','2017-04-16 02:25:03','admin','2017-04-16 02:25:03',0),('96fb652637232000158bbfc8bcbe5db4','3120fd2637232000158bbfc8bcbe5d42','e2257d6637232000158bbfc8bcbe5ded','admin','2017-03-28 18:58:51','admin','2017-03-28 18:58:51',0),('3c3725e237232000158bbfc8bcbe5da1','96346e0037332000158bbfc8bcbe5daa','ee78c0e037003000158bbfc8bcbe5db5','admin','2017-04-16 02:27:28','admin','2017-04-16 02:27:28',0),('a9d9f63237232000158bbfc8bcbe5dc0','7172ea0037332000158bbfc8bcbe5db6','f00888a037003000158bbfc8bcbe5dd3','admin','2017-04-16 02:25:26','admin','2017-04-16 02:25:26',0),('29d9f63237232000158bbfc8bcbe5db9','7172ea0037332000158bbfc8bcbe5db6','fa0880e037003000158bbfc8bcbe5d70','admin','2017-04-16 02:25:34','admin','2017-04-16 02:25:34',0),('b1d9f63237232000158bbfc8bcbe5dcf','ebb4620037332000158bbfc8bcbe5d89','fa48c0e037003000158bbfc8bcbe5d28','admin','2017-04-16 02:26:45','admin','2017-04-16 02:26:45',0);
/*!40000 ALTER TABLE `sm_m2m_group_dependency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_group`
--

DROP TABLE IF EXISTS `sys_user_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_group` (
  `name` varchar(80) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `manager` varchar(32) DEFAULT NULL,
  `include_members` tinyint(1) DEFAULT NULL,
  `exclude_manager` tinyint(1) DEFAULT NULL,
  `default_assignee` varchar(32) DEFAULT NULL,
  `description` mediumtext,
  `source` varchar(255) DEFAULT NULL,
  `type` mediumtext,
  `active` tinyint(1) DEFAULT NULL,
  `parent` varchar(32) DEFAULT NULL,
  `cost_center` varchar(32) DEFAULT NULL,
  `sys_id` char(32) NOT NULL,
  `sys_updated_by` varchar(40) DEFAULT NULL,
  `sys_updated_on` datetime DEFAULT NULL,
  `sys_created_by` varchar(40) DEFAULT NULL,
  `sys_created_on` datetime DEFAULT NULL,
  `sys_mod_count` int(11) DEFAULT NULL,
  `vendors` mediumtext,
  PRIMARY KEY (`sys_id`),
  UNIQUE KEY `name` (`name`),
  KEY `manager` (`manager`),
  KEY `default_assignee` (`default_assignee`),
  KEY `parent` (`parent`),
  KEY `cost_center` (`cost_center`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_group`
--

LOCK TABLES `sys_user_group` WRITE;
/*!40000 ALTER TABLE `sys_user_group` DISABLE KEYS */;
INSERT INTO `sys_user_group` VALUES ('Colorado Dispatchers to the Acme Company for the Acme Company',NULL,'5137153cc611227c000bbd1bd8cd2006',0,0,NULL,'Field Service Colorado Dispatchers to the Acme Company for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'011969e237232000158bbfc8bcbe5d3e','admin','2012-08-02 18:39:46','admin','2012-08-02 18:05:59',5,NULL),('WM Dispatchers for the Acme Company',NULL,'824fd523bf4320007a6d257b3f073963',0,0,NULL,'Field Service Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'17801ac21b13200050fdfbcd2c0713e8','admin','2012-08-02 21:33:58','admin','2012-08-02 21:25:47',4,NULL),('RMA Approvers for the Acme Company',NULL,NULL,0,0,NULL,'Responsible for Return Material Authorization approvals\n			and RMA number allocations in Inventory Management for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'1c590685c0a8018b2a473a7159ff5d9a','admin','2017-05-17 20:58:16','admin','2017-05-13 21:01:31',2,NULL),('Wyoming Dispatchers for the Acme Company',NULL,'5137153cc611227c000bbd1bd8cd2006',0,0,NULL,'Field Service Wyoming Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'21d9f63237232000158bbfc8bcbe5db1','admin','2012-08-03 19:16:24','admin','2012-08-03 18:37:18',2,NULL),('Missouri Dispatchers for the Acme Company',NULL,'b682abf03710200044e0bfc8bcbe5d21',0,0,NULL,'Field Service Missouri Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'21d9f63237232000158bbfc8bcbe5db7','admin','2012-08-03 19:09:46','admin','2012-08-03 18:37:18',4,NULL),('Catalog Request Approvers > $1000 for the Acme Company',NULL,NULL,0,0,NULL,'This is the group of users that need to approve a Service\n			Catalog request that is greater than $1000\n		 for the Acme Company',NULL,'74af88c6c611227d0066386e74dc853d',1,NULL,NULL,'220f8e71c61122840197e57c33464f70','admin','2012-10-14 01:11:42','admin','2012-09-27 20:02:58',6,NULL),('Catalog Request Approvers for Sales for the Acme Company',NULL,NULL,0,0,NULL,'This is a group of users that need to approve Service\n			Catalog requests from the Sales department\n		 for the Acme Company',NULL,'74af88c6c611227d0066386e74dc853d',1,NULL,NULL,'22122b37c611228400f9ff91c857581d','admin','2012-10-14 01:11:50','admin','2012-09-27 20:05:49',5,NULL),('Louisiana Dispatchers for the Acme Company',NULL,'ee826bf03710200044e0bfc8bcbe5de6',0,0,NULL,'Field Service Louisiana Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'25d9f63237232000158bbfc8bcbe5db3','admin','2012-08-03 19:04:16','admin','2012-08-03 18:37:18',2,NULL),('Tennessee Dispatchers for the Acme Company',NULL,'f682abf03710200044e0bfc8bcbe5d26',0,0,NULL,'Field Service Tennessee Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'25d9f63237232000158bbfc8bcbe5dbe','admin','2012-08-03 19:01:17','admin','2012-08-03 18:37:18',3,NULL),('Network for the Acme Company',NULL,'f298d2d2c611227b0106c6be7f154bc8',0,0,NULL,NULL,NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'287ebd7da9fe198100f92cc8d1d2154e','admin','2017-05-17 20:58:16','admin','2014-07-20 02:02:08',1,NULL),('Database for the Acme Company',NULL,'9ee1b13dc6112271007f9d0efdb69cd0',0,0,NULL,NULL,NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'287ee6fea9fe198100ada7950d0b1b73','admin','2017-05-17 20:58:16','admin','2014-07-20 02:02:18',1,NULL),('Virginia Dispatchers for the Acme Company',NULL,'fa82abf03710200044e0bfc8bcbe5d1f',0,0,NULL,'Field Service Virginia Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'29d9f63237232000158bbfc8bcbe5db9','admin','2012-08-03 19:13:00','admin','2012-08-03 18:37:18',2,NULL),('South Carolina Dispatchers for the Acme Company',NULL,'f282abf03710200044e0bfc8bcbe5d24',0,0,NULL,'Field Service South Carolina Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'29d9f63237232000158bbfc8bcbe5dc5','admin','2012-08-03 18:52:02','admin','2012-08-03 18:37:18',2,NULL),('Field Services Vendors for the Acme Company',NULL,'ae826bf03710200044e0bfc8bcbe5de1',0,0,NULL,'Field Services Vendors for the Acme Company',NULL,'12345fb137032000158bbfc8bcbe5d66',1,NULL,NULL,'2b957191eb203100eae001e64206fe96','admin','2014-11-21 23:36:44','admin','2014-11-21 23:36:44',0,'820351a1c0a8018b67c73d51c074097c,0c440474c6112275000025152d88c19f,0e579a3b37e3100044e0bfc8bcbe5d53'),('San Diego North Central for the Acme Company',NULL,'c6826bf03710200044e0bfc8bcbe5d87',0,0,NULL,'Field Service San Diego North Central for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'3120fd2637232000158bbfc8bcbe5d42','admin','2012-08-02 18:48:40','admin','2012-08-02 18:36:53',4,NULL),('East Qualifiers for the Acme Company',NULL,'5f728212c0a8010e004a13c7588047dd',0,0,NULL,'Field Service East Qualifiers for the Acme Company',NULL,'98906fb137032000158bbfc8bcbe5d65',1,NULL,NULL,'320ee92637232000158bbfc8bcbe5d40','admin','2012-08-03 16:42:01','admin','2012-08-02 18:27:40',4,NULL),('Texas Dispatchers for the Acme Company',NULL,'ee826bf03710200044e0bfc8bcbe5de6',0,0,NULL,'Field Service Texas Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'3c3725e237232000158bbfc8bcbe5da1','admin','2012-08-02 18:39:48','admin','2012-08-02 17:58:08',8,NULL),('New Hampshire Dispatchers for the Acme Company',NULL,'46d96f57a9fe198101947a9620895886',0,0,NULL,'Field Service New Hampshire Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'3dd9f63237232000158bbfc8bcbe5dcc','admin','2012-08-03 19:11:03','admin','2012-08-03 18:37:18',2,NULL),('New York Dispatchers for the Acme Company',NULL,'46b673a6a9fe19810007ab03cbd5849d',0,0,NULL,'Field Service New York Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'4c0482b237232000158bbfc8bcbe5d09','admin','2012-08-03 14:46:34','admin','2012-08-03 14:42:05',3,NULL),('Central Qualifiers for the Acme Company',NULL,'ea826bf03710200044e0bfc8bcbe5de4',0,0,NULL,'Field Service Central Qualifiers for the Acme Company',NULL,'98906fb137032000158bbfc8bcbe5d65',1,NULL,NULL,'539546b237232000158bbfc8bcbe5d7f','admin','2012-08-03 14:49:48','admin','2012-08-03 14:49:08',1,NULL),('NorCal Dispatch Group for the Acme Company',NULL,'931644d4d773020058c92cf65e61034c',0,0,NULL,'Dispatchers supporting the nortern California. for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'577ed708d773020058c92cf65e61037a','admin','2017-05-16 01:16:08','admin','2017-01-17 19:37:05',5,NULL),('IT Finance CAB for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'5f63e48fc0a8010e00eeaad81cd4dd37','admin','2017-05-17 20:58:16','admin','2013-03-07 21:00:17',1,NULL),('IT Securities for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'5f6441efc0a8010e0177fcb589156352','admin','2017-05-17 20:58:16','admin','2013-03-07 21:00:41',1,NULL),('ITSM Engineering for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'5f721d93c0a8010e015533746de18bf9','admin','2017-05-17 20:58:16','admin','2013-03-07 21:15:49',1,NULL),('NY DB for the Acme Company',NULL,NULL,0,0,NULL,'Manages databases hosted in New York for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,'287ee6fea9fe198100ada7950d0b1b73',NULL,'5f74727dc0a8010e01efe33a251993f9','admin','2017-05-17 20:58:16','admin','2013-03-07 21:18:22',1,NULL),('Maryland Dispatchers for the Acme Company',NULL,'46b673a6a9fe19810007ab03cbd5849d',0,0,NULL,'Field Service Maryland Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'61d9f63237232000158bbfc8bcbe5dbd','admin','2012-08-03 19:05:20','admin','2012-08-03 18:37:18',2,NULL),('Indiana Dispatchers for the Acme Company',NULL,'e6826bf03710200044e0bfc8bcbe5de2',0,0,NULL,'Field Service Indiana Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'61d9f63237232000158bbfc8bcbe5dc9','admin','2012-08-03 19:02:37','admin','2012-08-03 18:37:18',2,NULL),('Alabama Dispatchers for the Acme Company',NULL,'8d56406a0a0a0a6b004070b354aada28',0,0,NULL,'Field Service Alabama Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'65d9f63237232000158bbfc8bcbe5dc4','admin','2012-08-03 18:42:34','admin','2012-08-03 18:37:18',2,NULL),('Illinois Dispatchers for the Acme Company',NULL,'46d59205a9fe198101d603f5de37bfa3',0,0,NULL,'Field Service Illinois Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'671e327237232000158bbfc8bcbe5d00','admin','2012-08-03 18:56:23','admin','2012-08-03 18:56:00',1,NULL),('NorCal Technicians for the Acme Company',NULL,'4847c4d4d773020058c92cf65e61038e',0,0,NULL,'Technicians need to support Nortern California  for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'699708d4d773020058c92cf65e61037c','admin','2017-05-16 01:15:19','admin','2017-01-17 22:36:39',3,NULL),('Massachusetts Dispatchers for the Acme Company',NULL,'46b673a6a9fe19810007ab03cbd5849d',0,0,NULL,'Field Service Massachusetts Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'69d9f63237232000158bbfc8bcbe5dcb','admin','2012-08-03 19:06:34','admin','2012-08-03 18:37:18',2,NULL),('Kansas Dispatchers for the Acme Company',NULL,'b682abf03710200044e0bfc8bcbe5d21',0,0,NULL,'Field Service Kansas Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'6dd9f63237232000158bbfc8bcbe5db5','admin','2012-08-03 19:01:58','admin','2012-08-03 18:37:18',2,NULL),('Washington D.C Dispatchers for the Acme Company',NULL,'fa82abf03710200044e0bfc8bcbe5d1f',0,0,NULL,'Field Service Washington D.C Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'6dd9f63237232000158bbfc8bcbe5dc1','admin','2012-08-03 19:12:36','admin','2012-08-03 18:37:18',2,NULL),('North East for the Acme Company',NULL,'46d96f57a9fe198101947a9620895886',0,0,NULL,'Field Service North East for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'7172ea0037332000158bbfc8bcbe5db6','admin','2012-08-07 18:34:06','admin','2012-08-07 17:38:30',2,NULL),('Field Services for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'74af88c6c611227d0066386e74dc853d',1,NULL,NULL,'74ad1ff3c611227d01d25feac2af603f','admin','2012-10-14 01:11:34','admin','2012-10-13 21:03:56',3,NULL),('Washington Dispatchers for the Acme Company',NULL,'86826bf03710200044e0bfc8bcbe5d79',0,0,NULL,'Field Service Washington Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'75d9f63237232000158bbfc8bcbe5dd0','admin','2012-08-03 19:14:22','admin','2012-08-03 18:37:18',2,NULL),('West Qualifiers for the Acme Company',NULL,'82826bf03710200044e0bfc8bcbe5d89',0,0,NULL,'Field Service West Qualifiers for the Acme Company',NULL,'98906fb137032000158bbfc8bcbe5d65',1,NULL,NULL,'781da52637232000158bbfc8bcbe5db8','admin','2012-08-03 16:42:09','admin','2012-08-02 18:24:01',2,NULL),('North for the Acme Company',NULL,'5137153cc611227c000bbd1bd8cd2006',0,0,NULL,'Field Service North for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'7864ae0037332000158bbfc8bcbe5db8','admin','2012-08-07 18:36:03','admin','2012-08-07 17:39:53',1,NULL),('San Diego South for the Acme Company',NULL,'c6826bf03710200044e0bfc8bcbe5d6c',0,0,NULL,'Field Service San Diego South for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'7b10fd2637232000158bbfc8bcbe5d30','admin','2012-08-02 18:46:10','admin','2012-08-02 18:36:45',3,NULL),('Michigan Dispatchers for the Acme Company',NULL,'46b673a6a9fe19810007ab03cbd5849d',0,0,NULL,'Field Service Michigan Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'81a880e037003000158bbfc8bcbe5df8','admin','2012-08-21 02:31:55','admin','2012-08-21 02:29:09',3,NULL),('Procurement for the Acme Company',NULL,NULL,0,0,NULL,'Responsible for ordering catalog items, or moving them\n			from inventory that are \"In Stock\" for the Acme Company',NULL,'74af88c6c611227d0066386e74dc853d',1,NULL,NULL,'8a4cb6d4c61122780043b1642efcd52b','admin','2012-10-18 01:50:16','admin','2012-10-18 01:50:16',0,NULL),('Software for the Acme Company',NULL,NULL,0,0,NULL,'IT department responsible for all software requests\n			including installation and repair for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'8a4dde73c6112278017a6a4baf547aa7','admin','2017-05-17 20:58:16','admin','2012-10-18 01:51:32',2,NULL),('Hardware for the Acme Company',NULL,NULL,0,0,NULL,'IT department responsible for all hardware requests\n		including installation and repair for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'8a5055c9c61122780043563ef53438e3','admin','2017-05-17 20:58:16','admin','2012-10-18 01:54:14',1,NULL),('South for the Acme Company',NULL,'ee826bf03710200044e0bfc8bcbe5de6',0,0,NULL,'Field Service South for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'96346e0037332000158bbfc8bcbe5daa','admin','2012-08-07 18:34:25','admin','2012-08-07 17:40:01',1,NULL),('California Dispatchers for the Acme Company',NULL,'ca826bf03710200044e0bfc8bcbe5d89',0,0,NULL,'Field Service California Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'96fb652637232000158bbfc8bcbe5db4','admin','2012-08-02 18:39:42','admin','2012-08-02 18:18:37',4,NULL),('Rhode Island Dispatchers for the Acme Company',NULL,'46d96f57a9fe198101947a9620895886',0,0,NULL,'Field Service Rhode Island Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'a1d9f63237232000158bbfc8bcbe5dc3','admin','2012-08-03 19:11:58','admin','2012-08-03 18:37:18',2,NULL),('North Carolina Dispatchers for the Acme Company',NULL,'fa82abf03710200044e0bfc8bcbe5d1f',0,0,NULL,'Field Service North Carolina Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'a5d9f63237232000158bbfc8bcbe5dca','admin','2012-08-03 18:58:46','admin','2012-08-03 18:37:18',2,NULL),('Change Management for the Acme Company',NULL,NULL,0,0,NULL,'Change Management Group for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'a715cd759f2002002920bde8132e7018','admin','2017-05-17 20:58:16','admin','2015-06-10 05:32:35',2,NULL),('New Jersey Dispatchers for the Acme Company',NULL,'46b673a6a9fe19810007ab03cbd5849d',0,0,NULL,'Field Service New Jersey Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'a9d9f63237232000158bbfc8bcbe5dc0','admin','2012-08-03 19:05:43','admin','2012-08-03 18:37:18',2,NULL),('Project Mgmt for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'74af88c6c611227d0066386e74dc853d',1,NULL,NULL,'aacb62e2c0a80015007f67f752c2b12c','admin','2015-09-16 01:42:19','admin','2015-09-16 01:38:47',1,NULL),('Capacity Mgmt for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'74af88c6c611227d0066386e74dc853d',1,NULL,NULL,'aaccc971c0a8001500fe1ff4302de101','admin','2015-09-16 01:40:19','admin','2015-09-16 01:40:19',0,NULL),('Delaware Dispatchers for the Acme Company',NULL,'46b673a6a9fe19810007ab03cbd5849d',0,0,NULL,'Field Service Delaware Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'add9f63237232000158bbfc8bcbe5dbb','admin','2012-08-03 18:53:20','admin','2012-08-03 18:37:18',2,NULL),('Kentucky Dispatchers for the Acme Company',NULL,'f682abf03710200044e0bfc8bcbe5d26',0,0,NULL,'Field Service Kentucky Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'add9f63237232000158bbfc8bcbe5dc7','admin','2012-08-03 19:03:23','admin','2012-08-03 18:37:18',2,NULL),('Oregon Dispatchers for the Acme Company',NULL,'0a826bf03710200044e0bfc8bcbe5d83',0,0,NULL,'Field Service Oregon Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'b1d9f63237232000158bbfc8bcbe5dcf','admin','2012-08-03 19:14:50','admin','2012-08-03 18:37:18',2,NULL),('Florida Dispatchers for the Acme Company',NULL,'c2826bf03710200044e0bfc8bcbe5d6a',0,0,NULL,'Field Service Florida Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'b4f342b237232000158bbfc8bcbe5def','admin','2012-08-03 14:45:16','admin','2012-08-03 14:41:52',2,NULL),('CAB Approval for the Acme Company',NULL,NULL,0,0,NULL,'CAB approvers for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'b85d44954a3623120004689b2d5dd60a','admin','2011-09-30 16:30:34','admin','2011-09-30 16:30:34',0,NULL),('eCAB Approval for the Acme Company',NULL,NULL,0,0,NULL,'eCAB Approvers for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'b97e89b94a36231201676b73322a0311','admin','2011-09-30 08:46:44','admin','2011-09-30 08:46:44',0,NULL),('Team Development Code Reviewers for the Acme Company',NULL,NULL,0,0,NULL,'Review, approve and/or reject the code pushed to parent instance. for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'cfcbad03d711110050f5edcb9e61038f','admin','2017-05-17 20:58:16','admin','2013-12-01 23:47:36',1,NULL),('Service Desk for the Acme Company',NULL,NULL,0,0,NULL,NULL,NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'d625dccec0a8016700a222a0f7900d06','admin','2017-05-17 20:58:16','admin','2017-05-13 00:14:56',1,NULL),('Database Atlanta for the Acme Company',NULL,NULL,0,0,NULL,'Manages databases hosted in Atlanta for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,'287ee6fea9fe198100ada7950d0b1b73',NULL,'db53580b0a0a0a6501aa37c294a2ba6b','admin','2017-05-17 20:58:16','admin','2015-08-06 18:46:16',2,NULL),('Database San Diego for the Acme Company',NULL,NULL,0,0,NULL,'Manages databases hosted in San Diego for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,'287ee6fea9fe198100ada7950d0b1b73',NULL,'db53a9290a0a0a650091abebccf833c6','admin','2017-05-17 20:58:16','admin','2015-08-06 18:46:37',1,NULL),('LDAP Admins for the Acme Company',NULL,NULL,0,0,NULL,'LDAP admins group for the Acme Company',NULL,'1cb8ab9bff500200158bffffffffff62',1,NULL,NULL,'dc0db135c332010016194ffe5bba8f23','admin','2017-05-17 20:58:16','admin','2013-07-26 21:12:56',2,NULL),('San Diego South Central for the Acme Company',NULL,'5a826bf03710200044e0bfc8bcbe5da8',0,0,NULL,'Field Service San Diego South Central for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'df50316637232000158bbfc8bcbe5d23','admin','2012-08-02 18:47:27','admin','2012-08-02 18:37:49',3,NULL),('San Diego North for the Acme Company',NULL,'02826bf03710200044e0bfc8bcbe5d7f',0,0,NULL,'Field Service San Diego North for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'e08fad2637232000158bbfc8bcbe5d39','admin','2012-08-02 18:45:16','admin','2012-08-02 18:36:33',3,NULL),('Oklahoma Dispatchers for the Acme Company',NULL,'b682abf03710200044e0bfc8bcbe5d21',0,0,NULL,'Field Service Oklahoma Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'e1d9f63237232000158bbfc8bcbe5db8','admin','2012-08-03 19:11:32','admin','2012-08-03 18:37:18',2,NULL),('Minnesota Dispatchers for the Acme Company',NULL,'b682abf03710200044e0bfc8bcbe5d21',0,0,NULL,'Field Service Minnesota Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'e5d9f63237232000158bbfc8bcbe5db4','admin','2012-08-03 19:10:41','admin','2012-08-03 18:37:18',2,NULL),('Georgia Dispatchers for the Acme Company',NULL,'be826bf03710200044e0bfc8bcbe5df3',0,0,NULL,'Field Service Georgia Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'e5d9f63237232000158bbfc8bcbe5dbf','admin','2012-08-03 18:49:26','admin','2012-08-03 18:37:18',2,NULL),('Pennsylvania Dispatchers for the Acme Company',NULL,'46d96f57a9fe198101947a9620895886',0,0,NULL,'Field Service Pennsylvania Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'e9d9f63237232000158bbfc8bcbe5dba','admin','2012-08-03 19:16:50','admin','2012-08-03 18:37:18',2,NULL),('Ohio Dispatchers for the Acme Company',NULL,'e6826bf03710200044e0bfc8bcbe5de2',0,0,NULL,'Field Service Ohio Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'e9d9f63237232000158bbfc8bcbe5dc6','admin','2012-08-03 18:50:22','admin','2012-08-03 18:37:18',2,NULL),('North West for the Acme Company',NULL,'c6826bf03710200044e0bfc8bcbe5d87',0,0,NULL,'Field Service North West for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'ebb4620037332000158bbfc8bcbe5d89','admin','2012-08-07 18:35:18','admin','2012-08-07 17:40:20',2,NULL),('San Diego Border for the Acme Company',NULL,'46c6f9efa9fe198101ddf5eed9adf6e7',0,0,NULL,'Field Service San Diego Border for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'ec70316637232000158bbfc8bcbe5d60','admin','2012-08-02 18:45:26','admin','2012-08-02 18:38:10',3,NULL),('WM Agents for the Acme Company',NULL,'3b1f5523bf4320007a6d257b3f0739fd',0,0,NULL,'Field Service Agents for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'f253da061b13200050fdfbcd2c0713ab','admin','2012-08-02 21:38:02','admin','2012-08-02 21:38:02',0,NULL),('South East for the Acme Company',NULL,'c2826bf03710200044e0bfc8bcbe5d6a',0,0,NULL,'Field Service South East for the Acme Company',NULL,'87245e061b13200050fdfbcd2c0713cc',1,NULL,NULL,'f304ae0037332000158bbfc8bcbe5d4f','admin','2012-08-07 18:35:00','admin','2012-08-07 17:40:08',1,NULL),('WM Qualifiers for the Acme Company',NULL,'ee9f1923bf4320007a6d257b3f07391b',0,0,NULL,'Field Service Qualifiers for the Acme Company',NULL,'98906fb137032000158bbfc8bcbe5d65',1,NULL,NULL,'f972d6061b13200050fdfbcd2c0713e5','admin','2012-08-02 21:34:48','admin','2012-08-02 21:34:09',1,NULL),('Utah Dispatchers for the Acme Company',NULL,'5137153cc611227c000bbd1bd8cd2006',0,0,NULL,'Field Service Utah Dispatchers for the Acme Company',NULL,'59e22fb137032000158bbfc8bcbe5d52',1,NULL,NULL,'fdd9f63237232000158bbfc8bcbe5dcd','admin','2012-08-03 19:15:59','admin','2012-08-03 18:37:18',3,NULL);
/*!40000 ALTER TABLE `sys_user_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_grmember`
--

DROP TABLE IF EXISTS `sys_user_grmember`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_grmember` (
  `group` varchar(32) DEFAULT NULL,
  `user` varchar(32) DEFAULT NULL,
  `sys_id` char(32) NOT NULL,
  `sys_updated_by` varchar(40) DEFAULT NULL,
  `sys_updated_on` datetime DEFAULT NULL,
  `sys_created_by` varchar(40) DEFAULT NULL,
  `sys_created_on` datetime DEFAULT NULL,
  `sys_mod_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`sys_id`),
  KEY `group` (`group`),
  KEY `user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_grmember`
--

LOCK TABLES `sys_user_grmember` WRITE;
/*!40000 ALTER TABLE `sys_user_grmember` DISABLE KEYS */;
INSERT INTO `sys_user_grmember` VALUES ('69d9f63237232000158bbfc8bcbe5dcb','46d96f57a9fe198101947a9620895886','0190c77237232000158bbfc8bcbe5d29','admin','2012-08-03 19:06:46','admin','2012-08-03 19:06:46',0),('7172ea0037332000158bbfc8bcbe5db6','ee826bf03710200044e0bfc8bcbe5def','08827591ff1131007a6dffffffffff17','admin','2014-12-29 06:09:14','admin','2014-12-29 06:09:14',0),('7864ae0037332000158bbfc8bcbe5db8','46b87022a9fe198101a78787e40d7547','0960e74437732000158bbfc8bcbe5d91','admin','2012-08-07 18:38:09','admin','2012-08-07 18:38:09',0),('a9d9f63237232000158bbfc8bcbe5dc0','46b673a6a9fe19810007ab03cbd5849d','0a60c77237232000158bbfc8bcbe5d11','admin','2012-08-03 19:06:00','admin','2012-08-03 19:06:00',0),('4c0482b237232000158bbfc8bcbe5d09','46d96f57a9fe198101947a9620895886','0a64c2b237232000158bbfc8bcbe5d02','admin','2012-08-03 14:43:51','admin','2012-08-03 14:43:51',0),('4c0482b237232000158bbfc8bcbe5d09','46b673a6a9fe19810007ab03cbd5849d','0a64c2b237232000158bbfc8bcbe5d14','admin','2012-08-03 14:43:51','admin','2012-08-03 14:43:51',0),('a5d9f63237232000158bbfc8bcbe5dca','fa82abf03710200044e0bfc8bcbe5d1f','0acef27237232000158bbfc8bcbe5d99','admin','2012-08-03 18:58:54','admin','2012-08-03 18:58:54',0),('ebb4620037332000158bbfc8bcbe5d89','4a826bf03710200044e0bfc8bcbe5d76','0c122f4437732000158bbfc8bcbe5d80','admin','2012-08-07 18:45:27','admin','2012-08-07 18:45:27',0),('7b10fd2637232000158bbfc8bcbe5d30','c6826bf03710200044e0bfc8bcbe5d6c','0c42b56637232000158bbfc8bcbe5d46','admin','2012-08-02 18:46:03','admin','2012-08-02 18:46:03',0),('f253da061b13200050fdfbcd2c0713ab','3b1f5523bf4320007a6d257b3f0739fd','0d045e061b13200050fdfbcd2c071379','admin','2012-08-02 21:40:55','admin','2012-08-02 21:40:55',0),('69d9f63237232000158bbfc8bcbe5dcb','46b673a6a9fe19810007ab03cbd5849d','0d90c77237232000158bbfc8bcbe5d9c','admin','2012-08-03 19:06:46','admin','2012-08-03 19:06:46',0),('3120fd2637232000158bbfc8bcbe5d42','06826bf03710200044e0bfc8bcbe5d8a','0dd2396637232000158bbfc8bcbe5d0e','admin','2012-08-02 18:48:34','admin','2012-08-02 18:48:34',0),('17801ac21b13200050fdfbcd2c0713e8','8e826bf03710200044e0bfc8bcbe5d86','14c19a061b13200050fdfbcd2c07134b','admin','2012-08-02 21:31:02','admin','2012-08-02 21:31:02',0),('e1d9f63237232000158bbfc8bcbe5db8','b682abf03710200044e0bfc8bcbe5d21','15b1cb7237232000158bbfc8bcbe5d05','admin','2012-08-03 19:11:41','admin','2012-08-03 19:11:41',0),('f304ae0037332000158bbfc8bcbe5d4f','46b9852ca9fe198101531c8c1e926c86','16d1eb4437732000158bbfc8bcbe5dba','admin','2012-08-07 18:44:31','admin','2012-08-07 18:44:31',0),('f304ae0037332000158bbfc8bcbe5d4f','4e826bf03710200044e0bfc8bcbe5d78','1ad1eb4437732000158bbfc8bcbe5db5','admin','2012-08-07 18:44:31','admin','2012-08-07 18:44:31',0),('1c590685c0a8018b2a473a7159ff5d9a','5137153cc611227c000bbd1bd8cd2007','1e7836bac0a8018b439ffb87b1fcc39d','admin','2017-05-13 06:53:36','admin','2017-05-13 06:53:36',0),('1c590685c0a8018b2a473a7159ff5d9a','5137153cc611227c000bbd1bd8cd2005','1e7836f0c0a8018b439ffb87529a3c00','admin','2017-05-13 06:53:36','admin','2017-05-13 06:53:36',0),('f972d6061b13200050fdfbcd2c0713e5','f682abf03710200044e0bfc8bcbe5d26','1fe21e061b13200050fdfbcd2c07130f','admin','2012-08-02 21:36:10','admin','2012-08-02 21:36:10',0),('ec70316637232000158bbfc8bcbe5d60','ae826bf03710200044e0bfc8bcbe5de1','20a1356637232000158bbfc8bcbe5d19','admin','2012-08-02 18:43:21','admin','2012-08-02 18:43:21',0),('96346e0037332000158bbfc8bcbe5daa','66826bf03710200044e0bfc8bcbe5de1','2281ab4437732000158bbfc8bcbe5ddc','admin','2012-08-07 18:43:10','admin','2012-08-07 18:43:10',0),('011969e237232000158bbfc8bcbe5d3e','5137153cc611227c000bbd1bd8cd2006','241aade237232000158bbfc8bcbe5d60','admin','2012-08-02 18:10:19','admin','2012-08-02 18:10:19',0),('6dd9f63237232000158bbfc8bcbe5db5','b682abf03710200044e0bfc8bcbe5d21','248f367237232000158bbfc8bcbe5df3','admin','2012-08-03 19:02:04','admin','2012-08-03 19:02:04',0),('287ebd7da9fe198100f92cc8d1d2154e','5137153cc611227c000bbd1bd8cd2005','287f330aa9fe19810078ae8293e477cb','admin','2014-07-19 02:02:38','admin','2014-07-19 02:02:38',0),('287ebd7da9fe198100f92cc8d1d2154e','681b365ec0a80164000fb0b05854a0cd','287f3358a9fe19810109062e982279cf','admin','2014-07-19 02:02:38','admin','2014-07-19 02:02:38',0),('287ee6fea9fe198100ada7950d0b1b73','681b365ec0a80164000fb0b05854a0cd','287f7ad1a9fe198101f9c5c8f8d30b53','admin','2014-07-19 02:02:56','admin','2014-07-19 02:02:56',0),('17801ac21b13200050fdfbcd2c0713e8','293255f0df031100a9e78b6c3df26302','2c8255f0df031100a9e78b6c3df26338','admin','2014-02-19 22:00:03','admin','2014-02-19 22:00:03',0),('ec70316637232000158bbfc8bcbe5d60','46c6f9efa9fe198101ddf5eed9adf6e7','2ca1356637232000158bbfc8bcbe5d11','admin','2012-08-02 18:43:21','admin','2012-08-02 18:43:21',0),('ec70316637232000158bbfc8bcbe5d60','46bbf3daa9fe1981001fd0ccdd391f83','2ca1356637232000158bbfc8bcbe5d2f','admin','2012-08-02 18:43:21','admin','2012-08-02 18:43:21',0),('a1d9f63237232000158bbfc8bcbe5dc3','46b673a6a9fe19810007ab03cbd5849d','30d10b7237232000158bbfc8bcbe5d95','admin','2012-08-03 19:12:12','admin','2012-08-03 19:12:12',0),('577ed708d773020058c92cf65e61037a','931644d4d773020058c92cf65e61034c','339888d4d773020058c92cf65e6103aa','admin','2017-05-13 22:40:50','admin','2017-05-13 22:40:50',0),('3c3725e237232000158bbfc8bcbe5da1','3282abf03710200044e0bfc8bcbe5d1e','343b612637232000158bbfc8bcbe5d00','admin','2012-08-02 18:15:14','admin','2012-08-02 18:15:14',0),('320ee92637232000158bbfc8bcbe5d40','5f728212c0a8010e004a13c7588047dd','344ee92637232000158bbfc8bcbe5d7c','admin','2012-08-02 18:28:38','admin','2012-08-02 18:28:38',0),('539546b237232000158bbfc8bcbe5d7f','26826bf03710200044e0bfc8bcbe5de5','34e546b237232000158bbfc8bcbe5dfe','admin','2012-08-03 14:50:20','admin','2012-08-03 14:50:20',0),('df50316637232000158bbfc8bcbe5d23','92826bf03710200044e0bfc8bcbe5da9','3682f56637232000158bbfc8bcbe5d44','admin','2012-08-02 18:47:19','admin','2012-08-02 18:47:19',0),('e9d9f63237232000158bbfc8bcbe5dba','46d96f57a9fe198101947a9620895886','37e24f7237232000158bbfc8bcbe5dfb','admin','2012-08-03 19:17:02','admin','2012-08-03 19:17:02',0),('b4f342b237232000158bbfc8bcbe5def','86826bf03710200044e0bfc8bcbe5d70','38e4c2b237232000158bbfc8bcbe5dea','admin','2012-08-03 14:45:57','admin','2012-08-03 14:45:57',0),('781da52637232000158bbfc8bcbe5db8','c6826bf03710200044e0bfc8bcbe5d87','398d292637232000158bbfc8bcbe5d64','admin','2012-08-02 18:25:25','admin','2012-08-02 18:25:25',0),('2b957191eb203100eae001e64206fe96','5a826bf03710200044e0bfc8bcbe5dba','3a06b1d1eb203100eae001e64206fe8b','admin','2014-11-21 23:37:37','admin','2014-11-21 23:37:37',0),('b1d9f63237232000158bbfc8bcbe5dcf','0a826bf03710200044e0bfc8bcbe5d83','3a720f7237232000158bbfc8bcbe5dec','admin','2012-08-03 19:15:04','admin','2012-08-03 19:15:04',0),('df50316637232000158bbfc8bcbe5d23','d6826bf03710200044e0bfc8bcbe5da7','3a82f56637232000158bbfc8bcbe5d4b','admin','2012-08-02 18:47:19','admin','2012-08-02 18:47:19',0),('671e327237232000158bbfc8bcbe5d00','46d59205a9fe198101d603f5de37bfa3','3b3eb27237232000158bbfc8bcbe5dc4','admin','2012-08-03 18:56:34','admin','2012-08-03 18:56:34',0),('699708d4d773020058c92cf65e61037c','54c684d4d773020058c92cf65e6103af','3d09c8d4d773020058c92cf65e6103b0','admin','2017-05-13 22:42:37','admin','2017-05-13 22:42:37',0),('e08fad2637232000158bbfc8bcbe5d39','02826bf03710200044e0bfc8bcbe5d7f','3e02756637232000158bbfc8bcbe5d9b','admin','2012-08-02 18:45:08','admin','2012-08-02 18:45:08',0),('25d9f63237232000158bbfc8bcbe5dbe','f682abf03710200044e0bfc8bcbe5d26','3e5f367237232000158bbfc8bcbe5d1c','admin','2012-08-03 19:01:24','admin','2012-08-03 19:01:24',0),('fdd9f63237232000158bbfc8bcbe5dcd','5137153cc611227c000bbd1bd8cd2006','43b24f7237232000158bbfc8bcbe5da4','admin','2012-08-03 19:16:11','admin','2012-08-03 19:16:11',0),('7b10fd2637232000158bbfc8bcbe5d30','8a826bf03710200044e0bfc8bcbe5d72','4442b56637232000158bbfc8bcbe5d43','admin','2012-08-02 18:46:03','admin','2012-08-02 18:46:03',0),('699708d4d773020058c92cf65e61037c','ff969201d7b3020058c92cf65e61036d','44c85601d7b3020058c92cf65e6103e1','admin','2017-05-16 17:05:59','admin','2017-05-16 17:05:59',0),('f253da061b13200050fdfbcd2c0713ab','46c9e158a9fe198101d44d0d22cb640d','45045e061b13200050fdfbcd2c071331','admin','2012-08-02 21:40:55','admin','2012-08-02 21:40:55',0),('3120fd2637232000158bbfc8bcbe5d42','c6826bf03710200044e0bfc8bcbe5d87','45d2396637232000158bbfc8bcbe5d3b','admin','2012-08-02 18:48:34','admin','2012-08-02 18:48:34',0),('3120fd2637232000158bbfc8bcbe5d42','82826bf03710200044e0bfc8bcbe5d89','49d2396637232000158bbfc8bcbe5d12','admin','2012-08-02 18:48:34','admin','2012-08-02 18:48:34',0),('cfcbad03d711110050f5edcb9e61038f','6816f79cc0a8016401c5a33be04be441','4c744323d711110050f5edcb9e6103e4','admin','2013-12-03 19:31:14','admin','2013-12-03 19:31:14',0),('21d9f63237232000158bbfc8bcbe5db1','5137153cc611227c000bbd1bd8cd2006','4cd20f7237232000158bbfc8bcbe5d77','admin','2012-08-03 19:16:31','admin','2012-08-03 19:16:31',0),('a715cd759f2002002920bde8132e7018','f8588956937002002dcef157b67ffb98','4d788956937002002dcef157b67ffbc8','admin','2015-06-24 05:19:12','admin','2015-06-24 05:19:12',0),('96fb652637232000158bbfc8bcbe5db4','86826bf03710200044e0bfc8bcbe5d79','4e3ca52637232000158bbfc8bcbe5d3e','admin','2012-08-02 18:19:42','admin','2012-08-02 18:19:42',0),('7172ea0037332000158bbfc8bcbe5db6','ba82abf03710200044e0bfc8bcbe5d1a','50827591ff1131007a6dffffffffff97','admin','2014-12-29 06:09:15','admin','2014-12-29 06:09:15',0),('17801ac21b13200050fdfbcd2c0713e8','aa826bf03710200044e0bfc8bcbe5dd6','50c1d6061b13200050fdfbcd2c0713d5','admin','2012-08-02 21:31:02','admin','2012-08-02 21:31:02',0),('17801ac21b13200050fdfbcd2c0713e8','b682abf03710200044e0bfc8bcbe5d0f','50c1d6061b13200050fdfbcd2c0713da','admin','2012-08-02 21:31:02','admin','2012-08-02 21:31:02',0),('add9f63237232000158bbfc8bcbe5dc7','f682abf03710200044e0bfc8bcbe5d26','51df767237232000158bbfc8bcbe5ded','admin','2012-08-03 19:03:30','admin','2012-08-03 19:03:30',0),('f972d6061b13200050fdfbcd2c0713e5','31826bf03710200044e0bfc8bcbe5d2d','53e21e061b13200050fdfbcd2c071313','admin','2012-08-02 21:36:10','admin','2012-08-02 21:36:10',0),('f304ae0037332000158bbfc8bcbe5d4f','0e826bf03710200044e0bfc8bcbe5d6a','56d1eb4437732000158bbfc8bcbe5dbe','admin','2012-08-07 18:44:31','admin','2012-08-07 18:44:31',0),('81a880e037003000158bbfc8bcbe5df8','46d96f57a9fe198101947a9620895886','570944e037003000158bbfc8bcbe5d42','admin','2012-08-21 02:29:58','admin','2012-08-21 02:29:58',0),('17801ac21b13200050fdfbcd2c0713e8','824fd523bf4320007a6d257b3f073963','58c19a061b13200050fdfbcd2c07134e','admin','2012-08-02 21:31:02','admin','2012-08-02 21:31:02',0),('699708d4d773020058c92cf65e61037c','901784d4d773020058c92cf65e6103da','5bc708d4d773020058c92cf65e6103d5','admin','2017-05-13 22:37:15','admin','2017-05-13 22:37:15',0),('699708d4d773020058c92cf65e61037c','42f6d201d7b3020058c92cf65e610360','5e771601d7b3020058c92cf65e610332','admin','2017-05-16 17:00:25','admin','2017-05-16 17:00:25',0),('ec70316637232000158bbfc8bcbe5d60','46bac3d6a9fe1981005f299d979b8869','64a1356637232000158bbfc8bcbe5d2c','admin','2012-08-02 18:43:21','admin','2012-08-02 18:43:21',0),('e9d9f63237232000158bbfc8bcbe5dc6','e6826bf03710200044e0bfc8bcbe5de2','66dc7e3237232000158bbfc8bcbe5d66','admin','2012-08-03 18:50:28','admin','2012-08-03 18:50:28',0),('e5d9f63237232000158bbfc8bcbe5db4','b682abf03710200044e0bfc8bcbe5d21','68818b7237232000158bbfc8bcbe5d36','admin','2012-08-03 19:10:49','admin','2012-08-03 19:10:49',0),('7172ea0037332000158bbfc8bcbe5db6','42826bf03710200044e0bfc8bcbe5d8d','68827591ff1131007a6dffffffffffa6','admin','2014-12-29 06:09:16','admin','2014-12-29 06:09:16',0),('ec70316637232000158bbfc8bcbe5d60','22826bf03710200044e0bfc8bcbe5de3','68a1356637232000158bbfc8bcbe5d15','admin','2012-08-02 18:43:21','admin','2012-08-02 18:43:21',0),('75d9f63237232000158bbfc8bcbe5dd0','86826bf03710200044e0bfc8bcbe5d79','6b52cb7237232000158bbfc8bcbe5ded','admin','2012-08-03 19:14:34','admin','2012-08-03 19:14:34',0),('df50316637232000158bbfc8bcbe5d23','5a826bf03710200044e0bfc8bcbe5da8','7282f56637232000158bbfc8bcbe5d48','admin','2012-08-02 18:47:19','admin','2012-08-02 18:47:19',0),('e9d9f63237232000158bbfc8bcbe5dba','46b673a6a9fe19810007ab03cbd5849d','73e24f7237232000158bbfc8bcbe5dff','admin','2012-08-03 19:17:02','admin','2012-08-03 19:17:02',0),('29d9f63237232000158bbfc8bcbe5db9','fa82abf03710200044e0bfc8bcbe5d1f','7602cb7237232000158bbfc8bcbe5d00','admin','2012-08-03 19:13:10','admin','2012-08-03 19:13:10',0),('3c3725e237232000158bbfc8bcbe5da1','ee826bf03710200044e0bfc8bcbe5de6','7c3b212637232000158bbfc8bcbe5dcc','admin','2012-08-02 18:15:14','admin','2012-08-02 18:15:14',0),('96fb652637232000158bbfc8bcbe5db4','0a826bf03710200044e0bfc8bcbe5d83','7efde92637232000158bbfc8bcbe5d21','admin','2012-08-02 18:27:23','admin','2012-08-02 18:27:23',0),('7b10fd2637232000158bbfc8bcbe5d30','ca826bf03710200044e0bfc8bcbe5d77','8042356637232000158bbfc8bcbe5d3e','admin','2012-08-02 18:46:03','admin','2012-08-02 18:46:03',0),('f253da061b13200050fdfbcd2c0713ab','8e826bf03710200044e0bfc8bcbe5d86','81045e061b13200050fdfbcd2c071373','admin','2012-08-02 21:40:55','admin','2012-08-02 21:40:55',0),('61d9f63237232000158bbfc8bcbe5dbd','46b673a6a9fe19810007ab03cbd5849d','8240877237232000158bbfc8bcbe5dbf','admin','2012-08-03 19:05:28','admin','2012-08-03 19:05:28',0),('29d9f63237232000158bbfc8bcbe5dc5','f282abf03710200044e0bfc8bcbe5d24','884d327237232000158bbfc8bcbe5d9f','admin','2012-08-03 18:52:13','admin','2012-08-03 18:52:13',0),('3dd9f63237232000158bbfc8bcbe5dcc','46d96f57a9fe198101947a9620895886','8b918b7237232000158bbfc8bcbe5dc8','admin','2012-08-03 19:11:16','admin','2012-08-03 19:11:16',0),('7b10fd2637232000158bbfc8bcbe5d30','8e826bf03710200044e0bfc8bcbe5d74','8c42b56637232000158bbfc8bcbe5d3f','admin','2012-08-02 18:46:03','admin','2012-08-02 18:46:03',0),('7864ae0037332000158bbfc8bcbe5db8','46c5bf6ca9fe1981010713e3ac7d3384','8d60e74437732000158bbfc8bcbe5d98','admin','2012-08-07 18:38:09','admin','2012-08-07 18:38:09',0),('320ee92637232000158bbfc8bcbe5d40','be826bf03710200044e0bfc8bcbe5df3','91116b4437732000158bbfc8bcbe5d8f','admin','2012-08-07 18:41:10','admin','2012-08-07 18:41:10',0),('25d9f63237232000158bbfc8bcbe5db3','ee826bf03710200044e0bfc8bcbe5de6','9300077237232000158bbfc8bcbe5dbd','admin','2012-08-03 19:04:26','admin','2012-08-03 19:04:26',0),('f972d6061b13200050fdfbcd2c0713e5','aa826bf03710200044e0bfc8bcbe5dd6','93e21e061b13200050fdfbcd2c07130c','admin','2012-08-02 21:36:10','admin','2012-08-02 21:36:10',0),('7172ea0037332000158bbfc8bcbe5db6','46c1293aa9fe1981000dc753e75ebeee','94216b4437732000158bbfc8bcbe5dbd','admin','2012-08-07 18:41:22','admin','2012-08-07 18:41:22',0),('7172ea0037332000158bbfc8bcbe5db6','a2826bf03710200044e0bfc8bcbe5de4','98216b4437732000158bbfc8bcbe5dc3','admin','2012-08-07 18:41:22','admin','2012-08-07 18:41:22',0),('61d9f63237232000158bbfc8bcbe5dbd','46d96f57a9fe198101947a9620895886','9970877237232000158bbfc8bcbe5dae','admin','2012-08-03 19:06:14','admin','2012-08-03 19:06:14',0),('add9f63237232000158bbfc8bcbe5dbb','46d96f57a9fe198101947a9620895886','9b7d727237232000158bbfc8bcbe5d27','admin','2012-08-03 18:53:15','admin','2012-08-03 18:53:15',0),('6dd9f63237232000158bbfc8bcbe5dc1','fa82abf03710200044e0bfc8bcbe5d1f','9df18b7237232000158bbfc8bcbe5dc1','admin','2012-08-03 19:12:47','admin','2012-08-03 19:12:47',0),('21d9f63237232000158bbfc8bcbe5db7','b682abf03710200044e0bfc8bcbe5d21','a3314b7237232000158bbfc8bcbe5dc1','admin','2012-08-03 19:09:40','admin','2012-08-03 19:09:40',0),('699708d4d773020058c92cf65e61037c','4847c4d4d773020058c92cf65e61038e','a43848d4d773020058c92cf65e610352','admin','2017-05-13 22:39:42','admin','2017-05-13 22:38:58',1),('e5d9f63237232000158bbfc8bcbe5dbf','7a826bf03710200044e0bfc8bcbe5df5','a7acfe3237232000158bbfc8bcbe5d78','admin','2012-08-03 18:49:43','admin','2012-08-03 18:49:43',0),('8a5055c9c61122780043563ef53438e3','46d44a23a9fe19810012d100cca80666','a9af790fc611227601d6fc1be3a1240c','admin','2014-10-01 21:09:10','admin','2014-10-01 21:09:10',0),('8a5055c9c61122780043563ef53438e3','681b365ec0a80164000fb0b05854a0cd','a9af79abc6112276015e64636c3446fb','admin','2014-10-01 21:09:10','admin','2014-10-01 21:09:10',0),('8a5055c9c61122780043563ef53438e3','f298d2d2c611227b0106c6be7f154bc8','a9aff4c7c611227600d2be9863bb358a','admin','2014-10-01 21:09:41','admin','2014-10-01 21:09:41',0),('8a5055c9c61122780043563ef53438e3','46c4aeb7a9fe1981002bbd372644a37b','a9aff4e6c611227601df107427b313b8','admin','2014-10-01 21:09:41','admin','2014-10-01 21:09:41',0),('8a5055c9c61122780043563ef53438e3','5137153cc611227c000bbd1bd8cd2007','a9aff524c611227601b164f251a0ee5b','admin','2014-10-01 21:09:41','admin','2014-10-01 21:09:41',0),('8a5055c9c61122780043563ef53438e3','9ee1b13dc6112271007f9d0efdb69cd0','a9aff553c6112276015a8006174bee21','admin','2014-10-01 21:09:41','admin','2014-10-01 21:09:41',0),('8a5055c9c61122780043563ef53438e3','5137153cc611227c000bbd1bd8cd2005','a9aff582c6112276008b3bd8e1c890e8','admin','2014-10-01 21:09:41','admin','2014-10-01 21:09:41',0),('287ee6fea9fe198100ada7950d0b1b73','46d44a23a9fe19810012d100cca80666','a9b0fd4dc611227601908ba719053cf6','admin','2014-10-01 21:10:49','admin','2014-10-01 21:10:49',0),('287ee6fea9fe198100ada7950d0b1b73','5137153cc611227c000bbd1bd8cd2005','a9b0fdbbc6112276012f1ce289b64ba1','admin','2014-10-01 21:10:49','admin','2014-10-01 21:10:49',0),('287ebd7da9fe198100f92cc8d1d2154e','f298d2d2c611227b0106c6be7f154bc8','a9b2960ec6112276019a534a8ba2f11d','admin','2014-10-01 21:12:34','admin','2014-10-01 21:12:34',0),('287ebd7da9fe198100f92cc8d1d2154e','46c4aeb7a9fe1981002bbd372644a37b','a9b2963dc611227600d25883465ee6b8','admin','2014-10-01 21:12:34','admin','2014-10-01 21:12:34',0),('287ebd7da9fe198100f92cc8d1d2154e','5137153cc611227c000bbd1bd8cd2007','a9b2964dc611227601b1407a5ecfdb4a','admin','2014-10-01 21:12:34','admin','2014-10-01 21:12:34',0),('8a4dde73c6112278017a6a4baf547aa7','46d44a23a9fe19810012d100cca80666','a9b2f4c8c611227600f247cafc400282','admin','2014-10-01 21:12:58','admin','2014-10-01 21:12:58',0),('8a4dde73c6112278017a6a4baf547aa7','5137153cc611227c000bbd1bd8cd2007','a9b2f4f7c61122760047411cbd092e4d','admin','2014-10-01 21:12:58','admin','2014-10-01 21:12:58',0),('8a4dde73c6112278017a6a4baf547aa7','9ee1b13dc6112271007f9d0efdb69cd0','a9b2f526c61122760003ae07349d294f','admin','2014-10-01 21:12:58','admin','2014-10-01 21:12:58',0),('8a4dde73c6112278017a6a4baf547aa7','5137153cc611227c000bbd1bd8cd2005','a9b2f545c6112276019658dbe20ccc7f','admin','2014-10-01 21:12:58','admin','2014-10-01 21:12:58',0),('8a4dde73c6112278017a6a4baf547aa7','681b365ec0a80164000fb0b05854a0cd','a9b2f574c611227601a3b8a199fceb7c','admin','2014-10-01 21:12:58','admin','2014-10-01 21:12:58',0),('aacb62e2c0a80015007f67f752c2b12c','5137153cc611227c000bbd1bd8cd2005','aacbab0fc0a80015005cb70cd78770ce','admin','2015-09-15 01:39:06','admin','2015-09-15 01:39:06',0),('aaccc971c0a8001500fe1ff4302de101','5137153cc611227c000bbd1bd8cd2007','aaccee67c0a80015002bd014ff82ec8a','admin','2015-09-15 01:40:28','admin','2015-09-15 01:40:28',0),('aaccc971c0a8001500fe1ff4302de101','9ee1b13dc6112271007f9d0efdb69cd0','aacceed3c0a80015009069bba51c4e21','admin','2015-09-15 01:40:29','admin','2015-09-15 01:40:29',0),('65d9f63237232000158bbfc8bcbe5dc4','8d56406a0a0a0a6b004070b354aada28','ac1bfa3237232000158bbfc8bcbe5dc3','admin','2012-08-03 18:42:42','admin','2012-08-03 18:42:42',0),('ec70316637232000158bbfc8bcbe5d60','0d5b61dfc0a8026601c8e80d8bb57f6e','aca1356637232000158bbfc8bcbe5d28','admin','2012-08-02 18:43:21','admin','2012-08-02 18:43:21',0),('b85d44954a3623120004689b2d5dd60a','ee826bf03710200044e0bfc8bcbe5de6','b37bc032cbb00200d71cb9c0c24c9c45','admin','2017-05-13 14:09:50','admin','2017-05-13 14:09:50',0),('b85d44954a3623120004689b2d5dd60a','62d78687c0a8010e00b3d84178adc913','b37bc032cbb00200d71cb9c0c24c9c46','admin','2017-05-13 14:09:51','admin','2017-05-13 14:09:51',0),('781da52637232000158bbfc8bcbe5db8','ca826bf03710200044e0bfc8bcbe5d80','b58d292637232000158bbfc8bcbe5d6c','admin','2012-08-02 18:25:25','admin','2012-08-02 18:25:25',0),('2b957191eb203100eae001e64206fe96','46b9852ca9fe198101531c8c1e926c86','b606b1d1eb203100eae001e64206fe8d','admin','2014-11-21 23:37:37','admin','2014-11-21 23:37:37',0),('b85d44954a3623120004689b2d5dd60a','97000fcc0a0a0a6e0104ca999f619e5b','b77bc032cbb00200d71cb9c0c24c9c45','admin','2017-05-13 14:09:51','admin','2017-05-13 14:09:51',0),('220f8e71c61122840197e57c33464f70','8d56406a0a0a0a6b004070b354aada28','b9b74f080a0a0b343ba75b95bdb27056','admin','2017-05-12 04:47:24','admin','2017-05-12 04:47:24',0),('2b957191eb203100eae001e64206fe96','ee826bf03710200044e0bfc8bcbe5ddd','ba06b1d1eb203100eae001e64206fe89','admin','2014-11-21 23:37:37','admin','2014-11-21 23:37:37',0),('b85d44954a3623120004689b2d5dd60a','46ca0887a9fe19810191e08e51927ebf','bb7bc032cbb00200d71cb9c0c24c9c45','admin','2017-05-13 14:09:51','admin','2017-05-13 14:09:51',0),('539546b237232000158bbfc8bcbe5d7f','ea826bf03710200044e0bfc8bcbe5de4','bce586b237232000158bbfc8bcbe5d01','admin','2012-08-03 14:50:20','admin','2012-08-03 14:50:20',0),('e08fad2637232000158bbfc8bcbe5d39','82826bf03710200044e0bfc8bcbe5d80','be02756637232000158bbfc8bcbe5d8b','admin','2012-08-02 18:45:08','admin','2012-08-02 18:45:08',0),('b85d44954a3623120004689b2d5dd60a','46d96f57a9fe198101947a9620895886','bf7bc032cbb00200d71cb9c0c24c9c45','admin','2017-05-13 14:09:51','admin','2017-05-13 14:09:51',0),('ebb4620037332000158bbfc8bcbe5d89','06826bf03710200044e0bfc8bcbe5d8a','c0122f4437732000158bbfc8bcbe5d79','admin','2012-08-07 18:45:27','admin','2012-08-07 18:45:27',0),('ebb4620037332000158bbfc8bcbe5d89','7682abf03710200044e0bfc8bcbe5d25','c0122f4437732000158bbfc8bcbe5d7d','admin','2012-08-07 18:45:27','admin','2012-08-07 18:45:27',0),('7864ae0037332000158bbfc8bcbe5db8','46d80e5fa9fe198101490eab4fe5cbb0','c160e74437732000158bbfc8bcbe5d95','admin','2012-08-07 18:38:09','admin','2012-08-07 18:38:09',0),('96fb652637232000158bbfc8bcbe5db4','7a82abf03710200044e0bfc8bcbe5d27','c23ca52637232000158bbfc8bcbe5d3b','admin','2012-08-02 18:19:42','admin','2012-08-02 18:19:42',0),('f253da061b13200050fdfbcd2c0713ab','f682abf03710200044e0bfc8bcbe5d26','c5045e061b13200050fdfbcd2c071376','admin','2012-08-02 21:40:55','admin','2012-08-02 21:40:55',0),('7864ae0037332000158bbfc8bcbe5db8','3282abf03710200044e0bfc8bcbe5d27','c560e74437732000158bbfc8bcbe5d8b','admin','2012-08-07 18:38:09','admin','2012-08-07 18:38:09',0),('699708d4d773020058c92cf65e61037c','17f8d601d7b3020058c92cf65e610318','c629d601d7b3020058c92cf65e610303','admin','2017-05-16 17:08:11','admin','2017-05-16 17:07:46',1),('3dd9f63237232000158bbfc8bcbe5dcc','46b673a6a9fe19810007ab03cbd5849d','c7918b7237232000158bbfc8bcbe5dcc','admin','2012-08-03 19:11:16','admin','2012-08-03 19:11:16',0),('a9d9f63237232000158bbfc8bcbe5dc0','46d96f57a9fe198101947a9620895886','ca60c77237232000158bbfc8bcbe5d0d','admin','2012-08-03 19:06:00','admin','2012-08-03 19:06:00',0),('22122b37c611228400f9ff91c857581d','46d44a23a9fe19810012d100cca80666','d23bbe79ac1464186694751286d85f70','admin','2017-05-16 23:02:57','admin','2017-05-16 23:02:57',0),('22122b37c611228400f9ff91c857581d','9ee1b13dc6112271007f9d0efdb69cd0','d23bbf5dac14641866947512bde59dc5','admin','2017-05-16 23:02:57','admin','2017-05-16 23:02:57',0),('d625dccec0a8016700a222a0f7900d06','46d44a23a9fe19810012d100cca80666','d6266a10c0a8016700a11212dabddd67','admin','2017-05-12 00:15:21','admin','2017-05-12 00:15:21',0),('d625dccec0a8016700a222a0f7900d06','5137153cc611227c000bbd1bd8cd2007','d6266b1fc0a8016700a112121c900054','admin','2017-05-12 00:15:21','admin','2017-05-12 00:15:21',0),('d625dccec0a8016700a222a0f7900d06','681b365ec0a80164000fb0b05854a0cd','d6266bb0c0a8016700a1121231cdd959','admin','2017-05-12 00:15:21','admin','2017-05-12 00:15:21',0),('81a880e037003000158bbfc8bcbe5df8','46b673a6a9fe19810007ab03cbd5849d','d70944e037003000158bbfc8bcbe5d48','admin','2012-08-21 02:29:58','admin','2012-08-21 02:29:58',0),('add9f63237232000158bbfc8bcbe5dbb','46b673a6a9fe19810007ab03cbd5849d','d77d727237232000158bbfc8bcbe5d2b','admin','2012-08-03 18:53:15','admin','2012-08-03 18:53:15',0),('61d9f63237232000158bbfc8bcbe5dc9','e6826bf03710200044e0bfc8bcbe5de2','daaf367237232000158bbfc8bcbe5de2','admin','2012-08-03 19:02:45','admin','2012-08-03 19:02:45',0),('db53580b0a0a0a6501aa37c294a2ba6b','f298d2d2c611227b0106c6be7f154bc8','db541dbd0a0a0a65019da0f70a13f76c','admin','2015-08-05 18:47:07','admin','2015-08-05 18:47:07',0),('5f74727dc0a8010e01efe33a251993f9','5137153cc611227c000bbd1bd8cd2007','db5465160a0a0a6500facbec6fe20118','admin','2015-08-05 18:47:25','admin','2015-08-05 18:47:25',0),('db53a9290a0a0a650091abebccf833c6','9ee1b13dc6112271007f9d0efdb69cd0','db54a0f60a0a0a65002c54dcb72b4f41','admin','2015-08-05 18:47:41','admin','2015-08-05 18:47:41',0),('e5d9f63237232000158bbfc8bcbe5dbf','be826bf03710200044e0bfc8bcbe5df3','e3acfe3237232000158bbfc8bcbe5d7c','admin','2012-08-03 18:49:43','admin','2012-08-03 18:49:43',0),('96346e0037332000158bbfc8bcbe5daa','be82abf03710200044e0bfc8bcbe5d25','e681ab4437732000158bbfc8bcbe5dd7','admin','2012-08-07 18:43:10','admin','2012-08-07 18:43:10',0),('f972d6061b13200050fdfbcd2c0713e5','293255f0df031100a9e78b6c3df26302','e88255f0df031100a9e78b6c3df26339','admin','2014-02-19 22:00:03','admin','2014-02-19 22:00:03',0),('011969e237232000158bbfc8bcbe5d3e','3e82abf03710200044e0bfc8bcbe5d24','ec1aade237232000158bbfc8bcbe5d55','admin','2012-08-02 18:10:19','admin','2012-08-02 18:10:19',0),('96346e0037332000158bbfc8bcbe5daa','32826bf03710200044e0bfc8bcbe5df5','ee81ab4437732000158bbfc8bcbe5ddf','admin','2012-08-07 18:43:10','admin','2012-08-07 18:43:10',0),('f972d6061b13200050fdfbcd2c0713e5','ee9f1923bf4320007a6d257b3f07391b','efb2da061b13200050fdfbcd2c071358','admin','2012-08-02 21:35:21','admin','2012-08-02 21:35:21',0),('a1d9f63237232000158bbfc8bcbe5dc3','46d96f57a9fe198101947a9620895886','f0d10b7237232000158bbfc8bcbe5d91','admin','2012-08-03 19:12:12','admin','2012-08-03 19:12:12',0),('e08fad2637232000158bbfc8bcbe5d39','c2826bf03710200044e0bfc8bcbe5d7c','f202756637232000158bbfc8bcbe5d9f','admin','2012-08-02 18:45:08','admin','2012-08-02 18:45:08',0),('2b957191eb203100eae001e64206fe96','b1826bf03710200044e0bfc8bcbe5d25','f206b1d1eb203100eae001e64206fe8f','admin','2014-11-21 23:37:37','admin','2014-11-21 23:37:37',0),('b4f342b237232000158bbfc8bcbe5def','c2826bf03710200044e0bfc8bcbe5d6a','f4e4c2b237232000158bbfc8bcbe5df1','admin','2012-08-03 14:45:57','admin','2012-08-03 14:45:57',0),('e08fad2637232000158bbfc8bcbe5d39','8e826bf03710200044e0bfc8bcbe5d86','f602756637232000158bbfc8bcbe5d88','admin','2012-08-02 18:45:08','admin','2012-08-02 18:45:08',0),('96fb652637232000158bbfc8bcbe5db4','46d14f04a9fe19810142e40c6b071512','f6fde92637232000158bbfc8bcbe5d25','admin','2012-08-02 18:27:23','admin','2012-08-02 18:27:23',0),('699708d4d773020058c92cf65e61037c','8d59d601d7b3020058c92cf65e6103c2','f718a241d7b3020058c92cf65e610332','admin','2017-05-16 18:13:09','admin','2017-05-16 18:13:09',0),('781da52637232000158bbfc8bcbe5db8','c2826bf03710200044e0bfc8bcbe5d85','f98d292637232000158bbfc8bcbe5d68','admin','2012-08-02 18:25:25','admin','2012-08-02 18:25:25',0),('df50316637232000158bbfc8bcbe5d23','9e826bf03710200044e0bfc8bcbe5da6','fe82f56637232000158bbfc8bcbe5d4e','admin','2012-08-02 18:47:19','admin','2012-08-02 18:47:19',0),('f972d6061b13200050fdfbcd2c0713e5','780395f0df031100a9e78b6c3df2631f','ff4395f0df031100a9e78b6c3df2637e','admin','2014-02-19 22:03:33','admin','2014-02-19 22:03:33',0);
/*!40000 ALTER TABLE `sys_user_grmember` 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 2017-05-17 16:42:36

SELECT sm_m2m_group_dependency0.assignment_group FROM (sm_m2m_group_dependency sm_m2m_group_dependency0 INNER JOIN sys_user_group sys_user_group1 ON sm_m2m_group_dependency0.assignment_group = sys_user_group1.sys_id ) WHERE sm_m2m_group_dependency0.dispatch_group IN (SELECT sys_user_grmember0.group FROM (sys_user_grmember sys_user_grmember0 LEFT JOIN sys_user_group sys_user_group1 ON sys_user_grmember0.group = sys_user_group1.sys_id ) WHERE (sys_user_group1.type LIKE '59e22fb137032000158bbfc8bcbe5d52' AND sys_user_grmember0.user = '86826bf03710200044e0bfc8bcbe5d79')) ORDER BY sys_user_group1.name;
