DROP TABLE IF EXISTS `staff_preferred_facility_test`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff_preferred_facility_test` ( `created_by_id` int(11) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `facility_id` int(11) NOT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `modified_by_id` int(11) DEFAULT NULL, `staff_preferences_id` int(11) DEFAULT NULL, `default_facility` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `created_by_id` (`created_by_id`), KEY `facility_id` (`facility_id`), KEY `modified_by_id` (`modified_by_id`), KEY `staff_preferences_id` (`staff_preferences_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3411 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `staff_preferred_facility_test` -- LOCK TABLES `staff_preferred_facility_test` WRITE; /*!40000 ALTER TABLE `staff_preferred_facility_test` DISABLE KEYS */; INSERT INTO `staff_preferred_facility_test` VALUES (7517,'2015-10-15 15:13:19','2016-11-02 15:02:51',49,27,7517,36,0),(7517,'2016-02-23 14:30:29','2016-02-23 14:30:29',49,53,NULL,55,1),(7517,'2016-04-28 18:47:34','2016-04-28 18:47:34',49,76,NULL,63,1),(7517,'2016-04-29 14:26:28','2016-04-29 14:26:28',49,79,NULL,65,1),(7517,'2016-06-15 18:20:50','2018-08-01 15:31:02',49,91,7517,79,0),(7517,'2016-06-15 19:54:51','2016-06-15 19:54:54',49,92,7517,80,0),(7517,'2018-07-12 18:07:32','2018-07-12 18:07:32',49,2427,NULL,46,0),(7517,'2019-01-09 21:56:12','2019-01-09 21:56:12',49,2953,NULL,429,0),(7517,'2019-01-09 21:56:12','2019-01-09 21:56:12',107,2954,NULL,429,0),(7517,'2019-01-09 21:56:12','2019-01-09 21:56:12',149,2955,NULL,429,0),(7517,'2019-01-09 21:57:22','2019-01-09 21:57:22',107,2956,NULL,429,0),(7517,'2019-01-09 21:57:22','2019-01-09 21:57:22',149,2957,NULL,429,0),(7517,'2019-01-09 21:57:22','2019-01-09 21:57:22',49,2958,NULL,429,0),(7517,'2019-01-15 20:19:17','2019-01-15 20:19:17',107,2967,NULL,240,0),(7517,'2019-01-15 20:19:17','2019-01-15 20:19:17',49,2968,NULL,240,0),(7517,'2019-01-15 20:25:14','2019-01-15 20:25:14',49,2969,NULL,240,0),(7517,'2019-01-15 20:25:14','2019-01-15 20:25:14',107,2970,NULL,240,0),(7517,'2019-01-15 21:21:51','2019-01-15 21:21:51',49,2988,NULL,34,0),(7517,'2019-02-07 20:52:28','2019-02-07 20:52:28',49,3074,NULL,78,0),(7517,'2019-02-19 16:18:33','2019-02-19 16:18:33',49,3137,NULL,73,0); /*!40000 ALTER TABLE `staff_preferred_facility_test` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `staff_preferences_test` -- DROP TABLE IF EXISTS `staff_preferences_test`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff_preferences_test` ( `created_by_id` int(11) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `modified_by_id` int(11) DEFAULT NULL, `staff_id` int(11) NOT NULL, `detail_1` tinyint(1) DEFAULT '0', `detail_2` tinyint(1) DEFAULT NULL, `detail_3` varchar(20) DEFAULT NULL, `detail_4` int(11) DEFAULT NULL, `detail_5` tinyint(1) NOT NULL DEFAULT '1', `detail_6` int(11) DEFAULT NULL, `detail_7` tinyint(1) DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `uniq_idx_staff_preferences_staff_id` (`staff_id`) USING BTREE, KEY `created_by_id` (`created_by_id`), KEY `modified_by_id` (`modified_by_id`) ) ENGINE=InnoDB AUTO_INCREMENT=1486 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `staff_preferences_test` -- LOCK TABLES `staff_preferences_test` WRITE; /*!40000 ALTER TABLE `staff_preferences_test` DISABLE KEYS */; INSERT INTO `staff_preferences_test` VALUES (7518,'2015-08-13 13:09:45','2018-09-14 17:52:37',34,7518,7518,0,1,'MONTH',1,1,10,0),(7517,'2015-10-15 15:13:19','2019-03-13 17:33:59',36,15941,15941,0,0,'YEAR',1,1,0,1),(7517,'2015-12-28 14:52:15','2016-09-02 14:35:30',46,19322,19322,0,0,NULL,NULL,1,NULL,1),(7517,'2016-02-23 14:30:29','2016-06-22 15:22:07',55,19943,19943,0,0,NULL,NULL,1,NULL,1),(7517,'2016-04-28 18:47:34','2016-11-09 19:02:45',63,21262,21262,0,0,NULL,NULL,1,NULL,1),(7517,'2016-04-29 14:26:28','2018-10-05 20:16:53',65,21291,21291,0,0,'YEAR',1,1,0,1),(7517,'2016-05-27 17:53:31','2016-05-27 17:53:31',73,NULL,21695,NULL,NULL,NULL,NULL,1,NULL,1),(7517,'2016-06-14 22:08:50','2019-03-08 16:40:43',78,21865,21865,0,0,'YEAR',1,1,0,1),(7517,'2016-06-15 18:20:50','2018-11-12 21:56:43',79,21919,21919,0,1,'YEAR',1,1,0,1),(7517,'2016-06-15 19:54:51','2016-06-25 20:33:07',80,21887,21887,0,0,NULL,NULL,1,NULL,1),(7517,'2017-05-04 14:34:18','2019-02-28 21:52:05',240,27470,27470,0,0,'YEAR',1,1,0,1),(7517,'2018-02-08 21:11:31','2019-01-09 21:58:14',429,38159,38159,0,0,'YEAR',1,1,0,1); /*!40000 ALTER TABLE `staff_preferences_test` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_user_test` -- DROP TABLE IF EXISTS `account_user_test`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_user_test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_id` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `account_id` (`account_id`) ) ENGINE=InnoDB AUTO_INCREMENT=38160 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_user_test` -- LOCK TABLES `account_user_test` WRITE; /*!40000 ALTER TABLE `account_user_test` DISABLE KEYS */; INSERT INTO `account_user_test` VALUES (7518,28),(15941,28),(19322,28),(19943,28),(21262,28),(21291,28),(21695,28),(21865,28),(21887,28),(21919,28),(27470,28),(38159,28); /*!40000 ALTER TABLE `account_user_test` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_test` -- DROP TABLE IF EXISTS `account_test`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account_name` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `name` (`account_name`) ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_test` -- LOCK TABLES `account_test` WRITE; /*!40000 ALTER TABLE `account_test` DISABLE KEYS */; INSERT INTO `account_test` VALUES (28,'Test_Account'); /*!40000 ALTER TABLE `account_test` ENABLE KEYS */; UNLOCK TABLES;