· 8 years ago · Jul 05, 2018, 06:52 PM
1--------------------------------------------------------------------------------------------------------------
2
3____ __. .__ .__ _________ .__ __
4| |/ _|____ | |___ _|__| ____ / _____/ ____ ____ __ _________|__|/ |_ ___.__.
5| <_/ __ | | / / |/ _____ _/ __ _/ ___| | _ __ __< | |
6| | ___/| |_ /| | | / ___/ ___| | /| | / || | ___ |
7|____|__ ___ >____/_/ |__|___| /_______ /___ >___ >____/ |__| |__||__| / ____|
8 / / / / / / /
9--- contact:https://www.facebook.com/pages/KelvinSecurity/1470285456587684
10
11
12----- больш ---------------------------------------------------------------------------------------------------------------
13Што Kelvinsecurity? -- -KelvinSecurity- //1995//1996//2019
14
15
16Kelvinsecurity з'ÑўлÑецца хакер твар шукае збору інфармацыі вÑлікіх людзей па ÑžÑім Ñвеце, падлучаных да Ñеткі, Ñ– ÑžÑ€Ð°Ð·Ð»Ñ–Ð²Ñ‹Ñ Ð´Ð° гÑÑ‚Ñ‹Ñ… платформах.
17
18 Follow In twitter > @nationgoverment
19 EMAIL_CONTACT: > KelvinseZurity@3g2upl4pq6kufc4m.onion
20----------------------------------------------------------------------------------------------------------------
21
22-- MySQL dump 10.13 Distrib 5.5.42, for osx10.6 (i386)
23--
24-- Host: localhost Database: v2-dns
25-- ------------------------------------------------------
26-- Server version 5.5.42
27
28/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
29/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
30/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
31/*!40101 SET NAMES utf8 */;
32/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
33/*!40103 SET TIME_ZONE='+00:00' */;
34/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
35/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
36/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
37/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
38
39--
40-- Current Database: `v2-dns`
41--
42
43CREATE DATABASE /*!32312 IF NOT EXISTS*/ `v2-dns` /*!40100 DEFAULT CHARACTER SET latin1 */;
44
45USE `v2-dns`;
46
47--
48-- Table structure for table `app_sessions`
49--
50
51DROP TABLE IF EXISTS `app_sessions`;
52/*!40101 SET @saved_cs_client = @@character_set_client */;
53/*!40101 SET character_set_client = utf8 */;
54CREATE TABLE `app_sessions` (
55 `user_id` int(11) NOT NULL,
56 `log_hash` varchar(128) NOT NULL,
57 `log_exp_date` datetime NOT NULL,
58 PRIMARY KEY (`user_id`),
59 UNIQUE KEY `user_id` (`user_id`)
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `app_sessions`
65--
66
67LOCK TABLES `app_sessions` WRITE;
68/*!40000 ALTER TABLE `app_sessions` DISABLE KEYS */;
69INSERT INTO `app_sessions` VALUES (1,'8f18d195c8040df146caf356903b6e2efae3d43368fa2d52d2114b6b78764df13accd206f069f46ef1573808a4a43899051ad3e7908ecba2f5575f2fc3a48655','2016-06-21 00:34:35'),(4,'4317907ea63ad407b58d0b4e9619c241df3be95f3b988faeb977d31befb9aa4b4fb3273974511110d010c2e4f8648ad568dc1249570351b60a5466025c99146c','2016-07-02 13:53:37');
70/*!40000 ALTER TABLE `app_sessions` ENABLE KEYS */;
71UNLOCK TABLES;
72
73--
74-- Table structure for table `app_users`
75--
76
77DROP TABLE IF EXISTS `app_users`;
78/*!40101 SET @saved_cs_client = @@character_set_client */;
79/*!40101 SET character_set_client = utf8 */;
80CREATE TABLE `app_users` (
81 `user_id` int(11) NOT NULL AUTO_INCREMENT,
82 `user_name` varchar(255) NOT NULL,
83 `user_pass` varchar(255) NOT NULL,
84 `firstName` varchar(255) NOT NULL,
85 `lastName` varchar(255) NOT NULL,
86 `phone` varchar(12) NOT NULL,
87 `company` varchar(255) NOT NULL,
88 `user_level` int(11) NOT NULL DEFAULT '0',
89 `active` int(11) NOT NULL DEFAULT '1',
90 `images` text NOT NULL,
91 PRIMARY KEY (`user_id`),
92 UNIQUE KEY `user_name` (`user_name`)
93) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=latin1;
94/*!40101 SET character_set_client = @saved_cs_client */;
95
96--
97-- Dumping data for table `app_users`
98--
99
100LOCK TABLES `app_users` WRITE;
101/*!40000 ALTER TABLE `app_users` DISABLE KEYS */;
102INSERT INTO `app_users` VALUES (1,'admin@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','ad','min','+31 523 6134','',1,1,'profileImage_1_1456223699073.21.png'),(4,'martijn.smit@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Martijn ','Smit','','WeMa Mobile',2,1,'profileImage_4_1456576886793.77.png'),(5,'wesley.dubbink@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Wesley','Dubbink','','WeMa Mobile',2,1,'profileImage_5_1456823482500.3.png'),(7,'norbert@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Norbert','Sullman','','DNS',2,1,'profileImage_7_1457032243518.74.png'),(10,'bas.kuipers@wemamobile.nl','dbb56881807fe3ac79dfc13cf89f876b5f04faf9b2eeee5aa6c1422fb3f08fd5a65d9943f94bf4c818229417de731dde978c41c0a0812ff54d5b5b4c360cd086','Bas','Kuipers','0615975346','WeMa Mobile',2,0,'profileImage_10_1457095265282.36.png'),(11,'janbeton@apple.com','87e29e039ce5a60dc765a9d01ea98477ef9cb231421bf6aeddda12767d735e45a021eb8d5b5c3bc3bb8f665b39ad01022df650971937f5727ce573bdef510767','jan','beton','','Apple Inc.',1,1,'profileImage_11_1457957579529.38.png'),(13,'nsushsbs@me.com','1126d7b992baeb9be63f996bcf2281d4103e8b56b4630161ce293db264ec359efc95e1cec72a04233ea50958379d6db5c90c927ce9f82666e4ba555075541860','kfyi','hukngi','','mbduenen',3,0,'profileImage_13_1457514582281.63.png'),(15,'tijmen.kodden@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Tijmen','Kodden','','WeMa Mobile',3,1,'profileImage_15_1464092117723.21.png'),(16,'mark.ter.luun@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Mark','Ter Luun','','WeMa Mobile',2,1,''),(19,'test123@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Joost','Weten','','WeMa Mobile',2,1,'profileImage_19_1457515765223.99.png'),(27,'henk@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Jos','Verra','','WeMa Mobile',3,1,''),(33,'testhenk@wemamobile.nl','cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e','Henk','Smit','','WeMa Mobile',2,1,''),(37,'m.altena@denieuwestart.nl','cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e','Mannes ','Altena','0629179008','DNS',2,1,''),(38,'t.graafsma@denieuwestart.nl','cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e','Taeke','Graafsma','0625013142','DNS',2,1,''),(47,'geen','cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e','Nando','Fietje','0653319223','DNS',2,1,''),(53,'e.vandersluis@denieuwestart.nl','cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e','Erik','van der Sluis','0627621732','Dns',2,1,'profileImage_53_1457447254322.03.png'),(54,'eric.schmidt@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Eric','Schmidt','','Google',3,1,'profileImage_54_1464098756896.96.png'),(57,'elon.musk@tesla.com','cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e','Elon','Musk','','Tesla',2,1,'profileImage_57_1464016634708.61.png'),(58,'nsulmann','e645312b4d2434170c682eb866107f4c75a173eb493147d38a090a3995c66f55831e105783d9ac4c1b0b2ea5dc3c386ae0d8b69e277d8aff08a5b26ff279cd35','norby007','','','',2,1,''),(59,'tunderbird1@live.nl','96c20d5ea5717bc0a63c636da53f30694460a4ecb1c1786e92b0848ccdb41e580dc124d050defb9523cd2364740133c77134bc12106fec3feb31b28102bbb626','Jos','Verra','0623156950','WeMa Mobile',2,1,''),(60,'r.devries@denieuwestart.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Reinier','de Vries','0650627039','De Nieuwe Start',2,1,''),(61,'r.spier@denieuwestart.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Richard','Spier','','De Nieuwe Start',3,1,'profileImage_61_1464626946620.02.png'),(62,'p.test@denieuwestart.n','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Pieter','Test','','De Nieuwe Start',1,1,'profileImage_62_1464005587251.19.png'),(63,'nsulmann@home.nl','e645312b4d2434170c682eb866107f4c75a173eb493147d38a090a3995c66f55831e105783d9ac4c1b0b2ea5dc3c386ae0d8b69e277d8aff08a5b26ff279cd35','Norby2','Sulmann','','De nieuwestart',1,1,'profileImage_63_1464011021601.01.png'),(65,'j.verra@wemamobile.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Jos','Verra','','WeMa',3,1,''),(74,'rspier@home.nl','daef4953b9783365cad6615223720506cc46c5167cd16ab500fa597aa08ff964eb24fb19687f34d7665f778fcb6c5358fc0a5b81e1662cf90f73a2671c53f991','Richard','Spier Admin','','De Nieuwe Start',1,1,'profileImage_74_1464626977464.36.png');
103/*!40000 ALTER TABLE `app_users` ENABLE KEYS */;
104UNLOCK TABLES;
105
106--
107-- Table structure for table `calendar`
108--
109
110DROP TABLE IF EXISTS `calendar`;
111/*!40101 SET @saved_cs_client = @@character_set_client */;
112/*!40101 SET character_set_client = utf8 */;
113CREATE TABLE `calendar` (
114 `clientID` int(11) NOT NULL,
115 `date_time` datetime NOT NULL,
116 `message` text NOT NULL,
117 UNIQUE KEY `clientID` (`clientID`,`date_time`)
118) ENGINE=InnoDB DEFAULT CHARSET=latin1;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `calendar`
123--
124
125LOCK TABLES `calendar` WRITE;
126/*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
127/*!40000 ALTER TABLE `calendar` ENABLE KEYS */;
128UNLOCK TABLES;
129
130--
131-- Table structure for table `checklist`
132--
133
134DROP TABLE IF EXISTS `checklist`;
135/*!40101 SET @saved_cs_client = @@character_set_client */;
136/*!40101 SET character_set_client = utf8 */;
137CREATE TABLE `checklist` (
138 `itemID` int(11) NOT NULL AUTO_INCREMENT,
139 `name` varchar(255) NOT NULL,
140 `active` tinyint(1) NOT NULL DEFAULT '1',
141 `danger_level_low` int(11) NOT NULL DEFAULT '0',
142 `danger_level_high` int(11) NOT NULL DEFAULT '0',
143 `rank` int(11) NOT NULL DEFAULT '0',
144 `pushToggle` tinyint(1) NOT NULL DEFAULT '1',
145 `pushTime` time NOT NULL DEFAULT '12:00:00',
146 `category` int(11) NOT NULL DEFAULT '1',
147 PRIMARY KEY (`itemID`)
148) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
149/*!40101 SET character_set_client = @saved_cs_client */;
150
151--
152-- Dumping data for table `checklist`
153--
154
155LOCK TABLES `checklist` WRITE;
156/*!40000 ALTER TABLE `checklist` DISABLE KEYS */;
157INSERT INTO `checklist` VALUES (1,'Is de client op tijd vandaag?',1,25,75,5,0,'12:00:00',1),(2,'Houdt de deelnemer zich aan de rookpauzes?',1,40,60,3,0,'11:00:00',1),(3,'Was de client op tijd bij de middag lunch',1,25,75,13,0,'12:00:00',1),(4,'Is de client rustig in omgaan?',1,25,75,14,0,'12:00:00',1),(5,'Is de client vandaag blij?',0,25,75,22,0,'12:00:00',1),(6,'Volgt deelnemer aanwijzingen van de begeleider op?',1,25,100,0,0,'07:00:00',1),(7,'Is de client spraakzaam geweest?',1,30,85,7,0,'12:00:00',1),(8,'Heeft de client zijn werk juist afgerond?',1,25,75,9,0,'12:00:00',1),(9,'Maakt de client progressie in de manier van werken?',1,10,90,11,0,'12:00:00',1),(10,'Is de client aardig tegen de andere cliënten?',1,45,55,6,0,'12:00:00',1),(11,'Praat de client met andere cliënten?',1,50,50,8,0,'14:00:00',1),(12,'Test vraag!!!',0,66,77,11,0,'12:00:00',1),(13,'Poetst de client zijn tanden?',1,10,90,12,0,'12:00:00',1),(14,'Houdt de deelnemer zich aan de pauzetijden?',1,25,60,1,0,'09:00:00',1),(15,'computer les gehad',1,0,0,10,0,'12:00:00',1),(23,'Heeft de deelnemer zijn werkzaamheden vandaag afgemaakt?',1,0,0,4,0,'12:00:00',1),(24,'Is de deelnemer om 09.00 uur begonnen met zijn werkzaamheden?',1,0,0,2,0,'12:00:00',1),(27,'Testje',0,1,2,1,0,'12:00:00',1),(28,'Nog een testje',0,1,4,0,0,'12:00:00',1);
158/*!40000 ALTER TABLE `checklist` ENABLE KEYS */;
159UNLOCK TABLES;
160
161--
162-- Table structure for table `checklist_answer`
163--
164
165DROP TABLE IF EXISTS `checklist_answer`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `checklist_answer` (
169 `clientID` int(11) NOT NULL,
170 `itemID` int(11) NOT NULL,
171 `flag` tinyint(1) NOT NULL,
172 `date` date NOT NULL,
173 UNIQUE KEY `clientID` (`clientID`,`itemID`,`date`)
174) ENGINE=InnoDB DEFAULT CHARSET=latin1;
175/*!40101 SET character_set_client = @saved_cs_client */;
176
177--
178-- Dumping data for table `checklist_answer`
179--
180
181LOCK TABLES `checklist_answer` WRITE;
182/*!40000 ALTER TABLE `checklist_answer` DISABLE KEYS */;
183INSERT INTO `checklist_answer` VALUES (1,1,1,'2016-02-23'),(1,1,1,'2016-02-24'),(1,1,1,'2016-02-25'),(1,1,0,'2016-02-26'),(1,1,0,'2016-02-27'),(1,1,0,'2016-02-29'),(1,1,0,'2016-03-03'),(1,1,1,'2016-03-07'),(1,2,1,'2016-02-23'),(1,2,1,'2016-02-24'),(1,2,0,'2016-02-25'),(1,2,1,'2016-02-26'),(1,2,0,'2016-02-27'),(1,2,0,'2016-02-29'),(1,2,0,'2016-03-03'),(1,2,0,'2016-03-07'),(1,3,0,'2016-02-23'),(1,3,1,'2016-02-24'),(1,3,0,'2016-02-25'),(1,3,0,'2016-02-26'),(1,3,1,'2016-02-27'),(1,3,0,'2016-02-29'),(1,3,0,'2016-03-03'),(1,3,0,'2016-03-07'),(1,4,1,'2016-02-23'),(1,4,0,'2016-02-24'),(1,4,0,'2016-02-25'),(1,4,1,'2016-02-26'),(1,4,1,'2016-02-27'),(1,4,0,'2016-03-03'),(1,5,1,'2016-02-23'),(1,5,0,'2016-02-24'),(1,5,1,'2016-02-25'),(1,6,1,'2016-02-23'),(1,6,1,'2016-02-24'),(1,6,1,'2016-02-25'),(1,6,0,'2016-02-26'),(1,6,0,'2016-02-27'),(1,6,1,'2016-02-29'),(1,6,1,'2016-03-03'),(1,7,1,'2016-02-23'),(1,7,0,'2016-02-24'),(1,7,0,'2016-02-25'),(1,7,1,'2016-02-26'),(1,7,1,'2016-02-27'),(1,7,0,'2016-02-29'),(1,7,1,'2016-03-03'),(1,7,1,'2016-03-07'),(1,8,1,'2016-02-23'),(1,8,1,'2016-02-24'),(1,8,1,'2016-02-25'),(1,8,0,'2016-02-26'),(1,8,1,'2016-02-27'),(1,8,0,'2016-02-29'),(1,8,1,'2016-03-03'),(1,8,1,'2016-03-07'),(1,9,0,'2016-02-23'),(1,9,0,'2016-02-24'),(1,9,1,'2016-02-25'),(1,9,0,'2016-02-26'),(1,9,1,'2016-02-27'),(1,9,1,'2016-02-29'),(1,9,0,'2016-03-03'),(1,9,1,'2016-03-07'),(1,10,1,'2016-02-23'),(1,10,1,'2016-02-24'),(1,10,0,'2016-02-25'),(1,10,1,'2016-02-26'),(1,10,1,'2016-02-27'),(1,10,1,'2016-02-29'),(1,10,0,'2016-03-03'),(1,10,1,'2016-03-07'),(1,11,0,'2016-02-23'),(1,11,0,'2016-02-24'),(1,11,0,'2016-02-25'),(1,11,1,'2016-02-26'),(1,11,1,'2016-02-27'),(1,11,0,'2016-02-29'),(1,11,1,'2016-03-03'),(1,11,0,'2016-03-07'),(1,12,1,'2016-02-25'),(1,13,1,'2016-02-29'),(1,13,1,'2016-03-03'),(1,13,0,'2016-03-07'),(2,1,1,'2016-02-23'),(2,1,0,'2016-02-24'),(2,1,1,'2016-02-25'),(2,1,1,'2016-02-26'),(2,1,1,'2016-02-27'),(2,1,1,'2016-02-29'),(2,1,1,'2016-03-03'),(2,1,0,'2016-03-08'),(2,1,1,'2016-03-11'),(2,2,1,'2016-02-23'),(2,2,0,'2016-02-24'),(2,2,0,'2016-02-25'),(2,2,1,'2016-02-26'),(2,2,1,'2016-02-27'),(2,2,1,'2016-02-29'),(2,2,1,'2016-03-03'),(2,2,0,'2016-03-07'),(2,2,0,'2016-03-08'),(2,2,1,'2016-03-11'),(2,3,0,'2016-02-23'),(2,3,0,'2016-02-24'),(2,3,0,'2016-02-25'),(2,3,0,'2016-02-26'),(2,3,0,'2016-02-27'),(2,3,0,'2016-02-29'),(2,3,0,'2016-03-03'),(2,3,0,'2016-03-11'),(2,4,0,'2016-02-23'),(2,4,1,'2016-02-24'),(2,4,0,'2016-02-25'),(2,4,1,'2016-02-26'),(2,4,0,'2016-02-27'),(2,4,0,'2016-02-29'),(2,4,0,'2016-03-03'),(2,4,0,'2016-03-11'),(2,5,0,'2016-02-23'),(2,5,1,'2016-02-24'),(2,5,1,'2016-02-25'),(2,6,0,'2016-02-23'),(2,6,1,'2016-02-24'),(2,6,1,'2016-02-25'),(2,6,0,'2016-02-26'),(2,6,1,'2016-02-27'),(2,6,1,'2016-02-29'),(2,6,1,'2016-03-03'),(2,6,1,'2016-03-07'),(2,6,1,'2016-03-11'),(2,7,0,'2016-02-23'),(2,7,1,'2016-02-24'),(2,7,0,'2016-02-25'),(2,7,1,'2016-02-26'),(2,7,0,'2016-02-27'),(2,7,1,'2016-02-29'),(2,7,1,'2016-03-03'),(2,7,1,'2016-03-07'),(2,7,0,'2016-03-11'),(2,8,1,'2016-02-23'),(2,8,1,'2016-02-24'),(2,8,0,'2016-02-25'),(2,8,1,'2016-02-26'),(2,8,0,'2016-02-27'),(2,8,1,'2016-02-29'),(2,8,1,'2016-03-03'),(2,8,1,'2016-03-07'),(2,8,0,'2016-03-11'),(2,9,0,'2016-02-23'),(2,9,1,'2016-02-24'),(2,9,0,'2016-02-25'),(2,9,1,'2016-02-26'),(2,9,1,'2016-02-29'),(2,9,1,'2016-03-03'),(2,9,1,'2016-03-11'),(2,10,0,'2016-02-23'),(2,10,1,'2016-02-24'),(2,10,0,'2016-02-25'),(2,10,1,'2016-02-26'),(2,10,0,'2016-02-27'),(2,10,1,'2016-02-29'),(2,10,1,'2016-03-07'),(2,10,0,'2016-03-11'),(2,11,0,'2016-02-23'),(2,11,1,'2016-02-24'),(2,11,1,'2016-02-25'),(2,11,0,'2016-02-26'),(2,11,0,'2016-02-27'),(2,11,0,'2016-02-29'),(2,11,0,'2016-03-07'),(2,11,1,'2016-03-08'),(2,11,0,'2016-03-11'),(2,12,1,'2016-02-25'),(2,13,1,'2016-02-29'),(2,13,1,'2016-03-03'),(2,13,0,'2016-03-07'),(2,13,0,'2016-03-08'),(2,13,0,'2016-03-11'),(2,14,0,'2016-03-08'),(2,14,1,'2016-03-11'),(2,15,0,'2016-03-11'),(3,1,0,'2016-02-23'),(3,1,1,'2016-02-24'),(3,1,1,'2016-02-25'),(3,1,0,'2016-02-26'),(3,1,1,'2016-02-27'),(3,1,1,'2016-02-29'),(3,1,1,'2016-03-01'),(3,1,0,'2016-03-03'),(3,1,1,'2016-03-07'),(3,2,0,'2016-02-23'),(3,2,1,'2016-02-24'),(3,2,0,'2016-02-25'),(3,2,1,'2016-02-26'),(3,2,0,'2016-02-27'),(3,2,1,'2016-02-29'),(3,2,1,'2016-03-01'),(3,2,1,'2016-03-03'),(3,2,0,'2016-03-07'),(3,3,1,'2016-02-23'),(3,3,1,'2016-02-24'),(3,3,1,'2016-02-25'),(3,3,0,'2016-02-26'),(3,3,0,'2016-02-27'),(3,3,0,'2016-02-29'),(3,3,0,'2016-03-01'),(3,3,1,'2016-03-03'),(3,4,0,'2016-02-23'),(3,4,1,'2016-02-24'),(3,4,1,'2016-02-25'),(3,4,0,'2016-02-26'),(3,4,0,'2016-02-27'),(3,4,0,'2016-02-29'),(3,4,1,'2016-03-01'),(3,4,0,'2016-03-03'),(3,5,0,'2016-02-23'),(3,5,1,'2016-02-24'),(3,5,0,'2016-02-25'),(3,6,1,'2016-02-23'),(3,6,1,'2016-02-24'),(3,6,1,'2016-02-25'),(3,6,1,'2016-02-26'),(3,6,1,'2016-02-27'),(3,6,1,'2016-02-29'),(3,6,0,'2016-03-01'),(3,6,1,'2016-03-03'),(3,6,1,'2016-03-07'),(3,7,1,'2016-02-23'),(3,7,0,'2016-02-24'),(3,7,1,'2016-02-25'),(3,7,0,'2016-02-26'),(3,7,1,'2016-02-27'),(3,7,0,'2016-02-29'),(3,7,1,'2016-03-01'),(3,7,1,'2016-03-03'),(3,8,1,'2016-02-23'),(3,8,1,'2016-02-24'),(3,8,0,'2016-02-25'),(3,8,0,'2016-02-26'),(3,8,0,'2016-02-27'),(3,8,0,'2016-02-29'),(3,8,1,'2016-03-01'),(3,8,0,'2016-03-03'),(3,9,1,'2016-02-23'),(3,9,1,'2016-02-24'),(3,9,0,'2016-02-25'),(3,9,0,'2016-02-26'),(3,9,0,'2016-02-27'),(3,9,0,'2016-02-29'),(3,9,1,'2016-03-01'),(3,9,0,'2016-03-03'),(3,10,1,'2016-02-24'),(3,10,0,'2016-02-25'),(3,10,0,'2016-02-26'),(3,10,1,'2016-02-27'),(3,10,1,'2016-02-29'),(3,10,0,'2016-03-01'),(3,10,1,'2016-03-03'),(3,10,0,'2016-03-07'),(3,11,0,'2016-02-23'),(3,11,0,'2016-02-24'),(3,11,1,'2016-02-25'),(3,11,0,'2016-02-26'),(3,11,1,'2016-02-27'),(3,11,1,'2016-02-29'),(3,11,1,'2016-03-01'),(3,11,1,'2016-03-03'),(3,12,1,'2016-02-25'),(3,13,1,'2016-02-29'),(3,13,0,'2016-03-01'),(3,13,0,'2016-03-03'),(3,13,0,'2016-03-07'),(4,1,1,'2016-02-23'),(4,1,0,'2016-02-24'),(4,1,0,'2016-02-25'),(4,1,1,'2016-02-26'),(4,1,1,'2016-02-27'),(4,1,1,'2016-02-29'),(4,1,1,'2016-03-03'),(4,2,1,'2016-02-23'),(4,2,0,'2016-02-24'),(4,2,1,'2016-02-25'),(4,2,1,'2016-02-26'),(4,2,1,'2016-02-27'),(4,2,1,'2016-02-29'),(4,2,0,'2016-03-03'),(4,3,1,'2016-02-23'),(4,3,0,'2016-02-24'),(4,3,1,'2016-02-25'),(4,3,0,'2016-02-26'),(4,3,0,'2016-02-27'),(4,3,0,'2016-03-03'),(4,4,1,'2016-02-23'),(4,4,0,'2016-02-24'),(4,4,1,'2016-02-25'),(4,4,1,'2016-02-26'),(4,4,0,'2016-02-27'),(4,4,0,'2016-03-03'),(4,5,0,'2016-02-23'),(4,5,0,'2016-02-24'),(4,5,0,'2016-02-25'),(4,6,1,'2016-02-23'),(4,6,0,'2016-02-24'),(4,6,0,'2016-02-25'),(4,6,0,'2016-02-26'),(4,6,1,'2016-02-27'),(4,6,0,'2016-02-29'),(4,6,0,'2016-03-03'),(4,6,1,'2016-03-07'),(4,7,0,'2016-02-23'),(4,7,0,'2016-02-24'),(4,7,0,'2016-02-25'),(4,7,1,'2016-02-26'),(4,7,1,'2016-02-27'),(4,7,1,'2016-02-29'),(4,7,1,'2016-03-03'),(4,8,1,'2016-02-23'),(4,8,0,'2016-02-24'),(4,8,0,'2016-02-25'),(4,8,1,'2016-02-26'),(4,8,1,'2016-02-27'),(4,8,1,'2016-02-29'),(4,8,1,'2016-03-03'),(4,9,0,'2016-02-23'),(4,9,1,'2016-02-24'),(4,9,1,'2016-02-25'),(4,9,1,'2016-02-26'),(4,9,0,'2016-02-29'),(4,9,0,'2016-03-03'),(4,10,1,'2016-02-23'),(4,10,1,'2016-02-24'),(4,10,1,'2016-02-25'),(4,10,1,'2016-02-26'),(4,10,1,'2016-02-27'),(4,10,0,'2016-02-29'),(4,10,0,'2016-03-03'),(4,10,1,'2016-03-07'),(4,11,0,'2016-02-23'),(4,11,0,'2016-02-24'),(4,11,0,'2016-02-25'),(4,11,0,'2016-02-26'),(4,11,1,'2016-02-27'),(4,11,0,'2016-03-03'),(4,12,1,'2016-02-25'),(4,13,1,'2016-02-29'),(4,13,1,'2016-03-03'),(5,1,1,'2016-02-26'),(5,1,0,'2016-02-27'),(5,1,1,'2016-02-29'),(5,1,1,'2016-03-01'),(5,1,0,'2016-03-03'),(5,1,1,'2016-03-10'),(5,1,1,'2016-03-11'),(5,1,0,'2016-03-14'),(5,1,1,'2016-03-15'),(5,1,0,'2016-03-16'),(5,1,1,'2016-03-17'),(5,1,1,'2016-03-22'),(5,1,1,'2016-03-24'),(5,1,1,'2016-04-05'),(5,1,1,'2016-04-07'),(5,1,0,'2016-04-11'),(5,1,0,'2016-04-15'),(5,1,0,'2016-04-25'),(5,1,0,'2016-05-02'),(5,1,1,'2016-05-24'),(5,2,1,'2016-02-26'),(5,2,1,'2016-02-27'),(5,2,0,'2016-02-29'),(5,2,1,'2016-03-01'),(5,2,1,'2016-03-07'),(5,2,0,'2016-03-10'),(5,2,1,'2016-03-11'),(5,2,1,'2016-03-14'),(5,2,1,'2016-03-15'),(5,2,1,'2016-03-16'),(5,2,1,'2016-03-17'),(5,2,0,'2016-03-22'),(5,2,1,'2016-03-24'),(5,2,1,'2016-04-05'),(5,2,1,'2016-04-07'),(5,2,1,'2016-04-11'),(5,2,1,'2016-04-15'),(5,2,1,'2016-04-25'),(5,2,0,'2016-05-02'),(5,2,0,'2016-05-24'),(5,3,1,'2016-02-26'),(5,3,1,'2016-02-27'),(5,3,1,'2016-02-29'),(5,3,0,'2016-03-03'),(5,3,1,'2016-03-10'),(5,3,1,'2016-03-11'),(5,3,0,'2016-03-14'),(5,3,0,'2016-03-15'),(5,3,1,'2016-03-16'),(5,3,1,'2016-03-17'),(5,3,1,'2016-03-22'),(5,3,1,'2016-03-24'),(5,3,1,'2016-04-05'),(5,3,1,'2016-04-11'),(5,3,1,'2016-04-15'),(5,3,1,'2016-05-02'),(5,3,0,'2016-05-24'),(5,4,1,'2016-02-26'),(5,4,1,'2016-02-27'),(5,4,1,'2016-02-29'),(5,4,1,'2016-03-01'),(5,4,1,'2016-03-03'),(5,4,0,'2016-03-10'),(5,4,1,'2016-03-14'),(5,4,0,'2016-03-15'),(5,4,1,'2016-03-16'),(5,4,1,'2016-03-17'),(5,4,1,'2016-03-22'),(5,4,1,'2016-03-24'),(5,4,0,'2016-04-05'),(5,4,1,'2016-04-11'),(5,4,1,'2016-04-15'),(5,4,1,'2016-05-02'),(5,4,1,'2016-05-24'),(5,6,1,'2016-02-26'),(5,6,1,'2016-02-27'),(5,6,1,'2016-02-29'),(5,6,1,'2016-03-01'),(5,6,1,'2016-03-03'),(5,6,1,'2016-03-10'),(5,6,0,'2016-03-11'),(5,6,0,'2016-03-14'),(5,6,1,'2016-03-15'),(5,6,0,'2016-03-16'),(5,6,0,'2016-03-17'),(5,6,0,'2016-03-22'),(5,6,0,'2016-03-24'),(5,6,0,'2016-04-05'),(5,6,0,'2016-04-07'),(5,6,1,'2016-04-11'),(5,6,1,'2016-04-15'),(5,6,1,'2016-04-21'),(5,6,1,'2016-04-25'),(5,6,0,'2016-05-02'),(5,6,1,'2016-05-24'),(5,7,1,'2016-02-26'),(5,7,0,'2016-02-27'),(5,7,1,'2016-02-29'),(5,7,0,'2016-03-01'),(5,7,0,'2016-03-03'),(5,7,0,'2016-03-10'),(5,7,0,'2016-03-11'),(5,7,1,'2016-03-14'),(5,7,1,'2016-03-16'),(5,7,0,'2016-03-17'),(5,7,0,'2016-03-22'),(5,7,1,'2016-03-24'),(5,7,1,'2016-04-05'),(5,7,1,'2016-04-11'),(5,7,0,'2016-04-15'),(5,7,0,'2016-05-02'),(5,7,1,'2016-05-24'),(5,8,1,'2016-02-26'),(5,8,1,'2016-02-27'),(5,8,0,'2016-02-29'),(5,8,1,'2016-03-01'),(5,8,0,'2016-03-03'),(5,8,1,'2016-03-10'),(5,8,1,'2016-03-11'),(5,8,0,'2016-03-14'),(5,8,1,'2016-03-15'),(5,8,0,'2016-03-16'),(5,8,0,'2016-03-17'),(5,8,0,'2016-03-22'),(5,8,1,'2016-03-24'),(5,8,0,'2016-04-05'),(5,8,0,'2016-04-11'),(5,8,0,'2016-04-15'),(5,8,0,'2016-05-02'),(5,8,1,'2016-05-24'),(5,9,0,'2016-02-26'),(5,9,0,'2016-02-27'),(5,9,0,'2016-02-29'),(5,9,1,'2016-03-01'),(5,9,1,'2016-03-03'),(5,9,0,'2016-03-10'),(5,9,1,'2016-03-11'),(5,9,0,'2016-03-14'),(5,9,1,'2016-03-15'),(5,9,0,'2016-03-16'),(5,9,0,'2016-03-17'),(5,9,1,'2016-03-22'),(5,9,0,'2016-03-24'),(5,9,1,'2016-04-05'),(5,9,1,'2016-04-11'),(5,9,0,'2016-04-15'),(5,9,1,'2016-05-02'),(5,9,0,'2016-05-24'),(5,10,0,'2016-02-26'),(5,10,0,'2016-02-27'),(5,10,0,'2016-02-29'),(5,10,0,'2016-03-01'),(5,10,0,'2016-03-03'),(5,10,0,'2016-03-10'),(5,10,0,'2016-03-14'),(5,10,0,'2016-03-15'),(5,10,1,'2016-03-16'),(5,10,1,'2016-03-17'),(5,10,0,'2016-03-22'),(5,10,0,'2016-03-24'),(5,10,1,'2016-04-05'),(5,10,0,'2016-04-11'),(5,10,0,'2016-04-15'),(5,10,0,'2016-05-02'),(5,10,1,'2016-05-24'),(5,11,0,'2016-02-26'),(5,11,1,'2016-02-27'),(5,11,1,'2016-02-29'),(5,11,0,'2016-03-01'),(5,11,1,'2016-03-03'),(5,11,1,'2016-03-07'),(5,11,0,'2016-03-10'),(5,11,0,'2016-03-11'),(5,11,1,'2016-03-14'),(5,11,1,'2016-03-15'),(5,11,1,'2016-03-16'),(5,11,0,'2016-03-17'),(5,11,0,'2016-04-05'),(5,11,0,'2016-04-07'),(5,11,1,'2016-04-11'),(5,11,1,'2016-04-15'),(5,11,1,'2016-04-25'),(5,11,0,'2016-05-02'),(5,11,1,'2016-05-24'),(5,13,1,'2016-02-29'),(5,13,1,'2016-03-01'),(5,13,1,'2016-03-03'),(5,13,1,'2016-03-07'),(5,13,0,'2016-03-10'),(5,13,1,'2016-03-11'),(5,13,1,'2016-03-14'),(5,13,0,'2016-03-16'),(5,13,1,'2016-03-17'),(5,13,1,'2016-03-22'),(5,13,0,'2016-03-24'),(5,13,0,'2016-04-05'),(5,13,1,'2016-04-07'),(5,13,0,'2016-04-11'),(5,13,1,'2016-04-15'),(5,13,0,'2016-04-25'),(5,13,1,'2016-05-02'),(5,13,0,'2016-05-24'),(5,14,1,'2016-03-10'),(5,14,1,'2016-03-11'),(5,14,1,'2016-03-14'),(5,14,1,'2016-03-15'),(5,14,1,'2016-03-16'),(5,14,1,'2016-03-17'),(5,14,1,'2016-03-22'),(5,14,1,'2016-03-24'),(5,14,1,'2016-04-05'),(5,14,1,'2016-04-07'),(5,14,1,'2016-04-11'),(5,14,1,'2016-04-15'),(5,14,1,'2016-04-21'),(5,14,1,'2016-04-25'),(5,14,1,'2016-05-02'),(5,14,1,'2016-05-24'),(5,15,1,'2016-03-10'),(5,15,0,'2016-03-11'),(5,15,0,'2016-03-14'),(5,15,0,'2016-03-15'),(5,15,1,'2016-03-16'),(5,15,0,'2016-03-17'),(5,15,1,'2016-03-22'),(5,15,1,'2016-03-24'),(5,15,0,'2016-04-05'),(5,15,0,'2016-04-07'),(5,15,0,'2016-04-11'),(5,15,0,'2016-04-15'),(5,15,1,'2016-04-25'),(5,15,1,'2016-05-02'),(5,15,0,'2016-05-24'),(5,23,1,'2016-05-02'),(5,23,1,'2016-05-24'),(5,24,1,'2016-05-02'),(5,24,0,'2016-05-24'),(6,1,0,'2016-02-29'),(6,1,1,'2016-03-01'),(6,1,1,'2016-03-03'),(6,1,1,'2016-03-07'),(6,1,1,'2016-03-08'),(6,1,1,'2016-03-09'),(6,1,0,'2016-03-11'),(6,1,1,'2016-03-13'),(6,1,1,'2016-03-14'),(6,1,1,'2016-03-15'),(6,1,1,'2016-03-18'),(6,1,0,'2016-03-19'),(6,1,0,'2016-05-18'),(6,1,0,'2016-05-24'),(6,2,0,'2016-02-29'),(6,2,1,'2016-03-01'),(6,2,1,'2016-03-03'),(6,2,1,'2016-03-07'),(6,2,0,'2016-03-08'),(6,2,0,'2016-03-09'),(6,2,0,'2016-03-11'),(6,2,1,'2016-03-13'),(6,2,1,'2016-03-14'),(6,2,0,'2016-03-15'),(6,2,1,'2016-03-17'),(6,2,1,'2016-03-18'),(6,2,1,'2016-05-18'),(6,2,1,'2016-05-24'),(6,3,1,'2016-02-29'),(6,3,0,'2016-03-01'),(6,3,0,'2016-03-03'),(6,3,1,'2016-03-07'),(6,3,1,'2016-03-08'),(6,3,1,'2016-03-09'),(6,3,0,'2016-03-11'),(6,3,1,'2016-03-13'),(6,3,0,'2016-03-14'),(6,3,1,'2016-03-15'),(6,3,1,'2016-03-17'),(6,3,1,'2016-03-18'),(6,3,1,'2016-03-19'),(6,3,1,'2016-05-18'),(6,3,0,'2016-05-24'),(6,4,1,'2016-02-29'),(6,4,0,'2016-03-01'),(6,4,0,'2016-03-03'),(6,4,1,'2016-03-07'),(6,4,1,'2016-03-08'),(6,4,1,'2016-03-09'),(6,4,0,'2016-03-11'),(6,4,1,'2016-03-13'),(6,4,1,'2016-03-14'),(6,4,1,'2016-03-15'),(6,4,1,'2016-03-18'),(6,4,1,'2016-03-19'),(6,4,1,'2016-05-18'),(6,4,0,'2016-05-24'),(6,6,1,'2016-02-29'),(6,6,0,'2016-03-01'),(6,6,1,'2016-03-03'),(6,6,1,'2016-03-07'),(6,6,1,'2016-03-08'),(6,6,0,'2016-03-09'),(6,6,0,'2016-03-11'),(6,6,1,'2016-03-13'),(6,6,0,'2016-03-14'),(6,6,0,'2016-03-15'),(6,6,1,'2016-03-17'),(6,6,0,'2016-03-18'),(6,6,0,'2016-03-19'),(6,6,1,'2016-05-18'),(6,6,0,'2016-05-24'),(6,7,1,'2016-02-29'),(6,7,1,'2016-03-01'),(6,7,1,'2016-03-03'),(6,7,0,'2016-03-07'),(6,7,1,'2016-03-08'),(6,7,0,'2016-03-13'),(6,7,0,'2016-03-14'),(6,7,0,'2016-03-15'),(6,7,0,'2016-03-17'),(6,7,1,'2016-03-18'),(6,7,0,'2016-03-19'),(6,7,0,'2016-05-18'),(6,7,1,'2016-05-24'),(6,8,1,'2016-02-29'),(6,8,1,'2016-03-01'),(6,8,0,'2016-03-03'),(6,8,0,'2016-03-07'),(6,8,1,'2016-03-08'),(6,8,0,'2016-03-09'),(6,8,0,'2016-03-11'),(6,8,1,'2016-03-13'),(6,8,1,'2016-03-14'),(6,8,0,'2016-03-15'),(6,8,0,'2016-03-17'),(6,8,0,'2016-03-18'),(6,8,1,'2016-03-19'),(6,8,0,'2016-05-18'),(6,8,1,'2016-05-24'),(6,9,1,'2016-02-29'),(6,9,0,'2016-03-01'),(6,9,1,'2016-03-03'),(6,9,1,'2016-03-07'),(6,9,1,'2016-03-08'),(6,9,0,'2016-03-09'),(6,9,0,'2016-03-11'),(6,9,1,'2016-03-13'),(6,9,0,'2016-03-14'),(6,9,1,'2016-03-15'),(6,9,0,'2016-03-18'),(6,9,1,'2016-03-19'),(6,9,1,'2016-05-18'),(6,9,0,'2016-05-24'),(6,10,0,'2016-02-29'),(6,10,1,'2016-03-01'),(6,10,1,'2016-03-03'),(6,10,0,'2016-03-07'),(6,10,0,'2016-03-08'),(6,10,1,'2016-03-09'),(6,10,0,'2016-03-11'),(6,10,1,'2016-03-13'),(6,10,0,'2016-03-14'),(6,10,1,'2016-03-15'),(6,10,1,'2016-03-17'),(6,10,0,'2016-03-19'),(6,10,0,'2016-05-18'),(6,10,0,'2016-05-24'),(6,11,1,'2016-02-29'),(6,11,0,'2016-03-01'),(6,11,0,'2016-03-03'),(6,11,0,'2016-03-07'),(6,11,0,'2016-03-08'),(6,11,1,'2016-03-09'),(6,11,0,'2016-03-11'),(6,11,1,'2016-03-13'),(6,11,0,'2016-03-14'),(6,11,0,'2016-03-15'),(6,11,1,'2016-03-17'),(6,11,1,'2016-03-18'),(6,11,1,'2016-03-19'),(6,11,0,'2016-05-18'),(6,11,1,'2016-05-24'),(6,13,1,'2016-02-29'),(6,13,1,'2016-03-01'),(6,13,0,'2016-03-03'),(6,13,1,'2016-03-07'),(6,13,1,'2016-03-08'),(6,13,0,'2016-03-09'),(6,13,1,'2016-03-11'),(6,13,1,'2016-03-13'),(6,13,1,'2016-03-14'),(6,13,1,'2016-03-15'),(6,13,1,'2016-03-17'),(6,13,0,'2016-03-18'),(6,13,1,'2016-03-19'),(6,13,1,'2016-05-18'),(6,13,0,'2016-05-24'),(6,14,1,'2016-03-08'),(6,14,1,'2016-03-09'),(6,14,0,'2016-03-11'),(6,14,0,'2016-03-13'),(6,14,1,'2016-03-14'),(6,14,0,'2016-03-15'),(6,14,1,'2016-03-17'),(6,14,1,'2016-03-18'),(6,14,1,'2016-03-19'),(6,14,1,'2016-05-18'),(6,14,1,'2016-05-24'),(6,15,1,'2016-03-08'),(6,15,1,'2016-03-09'),(6,15,0,'2016-03-11'),(6,15,0,'2016-03-13'),(6,15,1,'2016-03-14'),(6,15,0,'2016-03-15'),(6,15,0,'2016-03-18'),(6,15,1,'2016-03-19'),(6,15,1,'2016-05-18'),(6,15,1,'2016-05-24'),(6,23,1,'2016-05-18'),(6,23,1,'2016-05-24'),(6,24,1,'2016-05-18'),(6,24,0,'2016-05-24'),(7,1,1,'2016-03-01'),(7,1,1,'2016-03-02'),(7,1,1,'2016-03-03'),(7,2,1,'2016-03-01'),(7,2,1,'2016-03-02'),(7,2,0,'2016-03-03'),(7,3,0,'2016-03-01'),(7,3,1,'2016-03-02'),(7,3,0,'2016-03-03'),(7,4,1,'2016-03-01'),(7,4,1,'2016-03-02'),(7,4,0,'2016-03-03'),(7,6,1,'2016-03-01'),(7,6,0,'2016-03-02'),(7,6,1,'2016-03-03'),(7,7,1,'2016-03-02'),(7,7,1,'2016-03-03'),(7,8,0,'2016-03-01'),(7,8,0,'2016-03-02'),(7,8,1,'2016-03-03'),(7,9,1,'2016-03-01'),(7,9,0,'2016-03-02'),(7,9,1,'2016-03-03'),(7,10,0,'2016-03-01'),(7,10,1,'2016-03-02'),(7,10,1,'2016-03-03'),(7,11,1,'2016-03-01'),(7,11,1,'2016-03-02'),(7,11,0,'2016-03-03'),(7,13,1,'2016-03-01'),(7,13,1,'2016-03-02'),(7,13,0,'2016-03-03'),(9,2,0,'2016-03-07'),(9,11,0,'2016-03-07'),(9,13,0,'2016-03-07'),(9,15,0,'2016-03-08'),(11,1,0,'2016-03-11'),(11,1,0,'2016-03-14'),(11,1,1,'2016-03-15'),(11,1,1,'2016-03-16'),(11,1,1,'2016-05-02'),(11,2,0,'2016-03-11'),(11,2,0,'2016-03-14'),(11,2,1,'2016-03-15'),(11,2,1,'2016-03-16'),(11,2,0,'2016-05-02'),(11,3,1,'2016-03-11'),(11,3,0,'2016-03-14'),(11,3,1,'2016-03-15'),(11,3,1,'2016-03-16'),(11,3,0,'2016-05-02'),(11,4,1,'2016-03-11'),(11,4,0,'2016-03-14'),(11,4,1,'2016-03-15'),(11,4,1,'2016-03-16'),(11,4,0,'2016-05-02'),(11,6,0,'2016-03-11'),(11,6,0,'2016-03-14'),(11,6,1,'2016-03-15'),(11,6,1,'2016-03-16'),(11,6,0,'2016-05-02'),(11,7,1,'2016-03-11'),(11,7,1,'2016-03-14'),(11,7,0,'2016-03-15'),(11,7,0,'2016-03-16'),(11,7,0,'2016-05-02'),(11,8,0,'2016-03-11'),(11,8,1,'2016-03-14'),(11,8,1,'2016-03-15'),(11,8,0,'2016-03-16'),(11,8,1,'2016-05-02'),(11,9,0,'2016-03-11'),(11,9,1,'2016-03-14'),(11,9,1,'2016-03-15'),(11,9,1,'2016-03-16'),(11,9,1,'2016-05-02'),(11,10,0,'2016-03-11'),(11,10,0,'2016-03-14'),(11,10,0,'2016-03-15'),(11,10,1,'2016-03-16'),(11,10,0,'2016-05-02'),(11,11,1,'2016-03-11'),(11,11,1,'2016-03-14'),(11,11,1,'2016-03-15'),(11,11,0,'2016-03-16'),(11,11,0,'2016-05-02'),(11,13,1,'2016-03-11'),(11,13,1,'2016-03-14'),(11,13,0,'2016-03-15'),(11,13,0,'2016-03-16'),(11,13,0,'2016-05-02'),(11,14,1,'2016-03-11'),(11,14,0,'2016-03-14'),(11,14,1,'2016-03-15'),(11,14,1,'2016-03-16'),(11,14,1,'2016-05-02'),(11,15,1,'2016-03-11'),(11,15,0,'2016-03-14'),(11,15,0,'2016-03-15'),(11,15,0,'2016-03-16'),(11,15,1,'2016-05-02'),(11,23,1,'2016-05-02'),(11,24,1,'2016-05-02');
184/*!40000 ALTER TABLE `checklist_answer` ENABLE KEYS */;
185UNLOCK TABLES;
186
187--
188-- Table structure for table `client`
189--
190
191DROP TABLE IF EXISTS `client`;
192/*!40101 SET @saved_cs_client = @@character_set_client */;
193/*!40101 SET character_set_client = utf8 */;
194CREATE TABLE `client` (
195 `clientID` int(11) NOT NULL AUTO_INCREMENT,
196 `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
197 `active` int(11) NOT NULL,
198 PRIMARY KEY (`clientID`)
199) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Dumping data for table `client`
204--
205
206LOCK TABLES `client` WRITE;
207/*!40000 ALTER TABLE `client` DISABLE KEYS */;
208INSERT INTO `client` VALUES (3,'2016-02-23 22:16:52',0),(4,'2016-02-23 22:19:49',0),(5,'2016-02-26 09:11:53',1),(6,'2016-02-27 12:32:53',1),(10,'2016-03-10 21:09:57',1),(11,'2016-03-10 21:12:46',1),(12,'2016-04-07 08:07:27',0),(13,'2016-05-03 12:46:11',1),(14,'2016-05-04 06:43:37',1),(15,'2016-05-04 07:36:47',1),(16,'2016-05-23 12:16:00',1),(17,'2016-05-23 15:27:59',1),(18,'2016-06-02 09:38:14',1),(19,'2016-06-02 09:38:37',1);
209/*!40000 ALTER TABLE `client` ENABLE KEYS */;
210UNLOCK TABLES;
211
212--
213-- Table structure for table `client_caretaker`
214--
215
216DROP TABLE IF EXISTS `client_caretaker`;
217/*!40101 SET @saved_cs_client = @@character_set_client */;
218/*!40101 SET character_set_client = utf8 */;
219CREATE TABLE `client_caretaker` (
220 `caretakerID` int(11) NOT NULL AUTO_INCREMENT,
221 `clientID` int(11) NOT NULL,
222 `fullName` varchar(255) NOT NULL,
223 `address` varchar(255) NOT NULL,
224 `zipcode` varchar(255) NOT NULL,
225 `city` varchar(255) NOT NULL,
226 `mobile` varchar(255) NOT NULL,
227 `active` int(11) NOT NULL DEFAULT '1',
228 PRIMARY KEY (`caretakerID`)
229) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
230/*!40101 SET character_set_client = @saved_cs_client */;
231
232--
233-- Dumping data for table `client_caretaker`
234--
235
236LOCK TABLES `client_caretaker` WRITE;
237/*!40000 ALTER TABLE `client_caretaker` DISABLE KEYS */;
238INSERT INTO `client_caretaker` VALUES (1,1,'Henk Sikpens','Salads errata 16','7772BZ','Hardenberg','05123126132',1),(2,2,'Voordan Verra','Zwingel 4','7772CZ','Hardenberg','06123456',1),(3,3,'Henke Kodden','Dalfsenweg 4','7772BZ','Dalfsen','0623773',1),(4,5,'Chantal Jansen','Sallandsestraat 16b','7772LB','Hardenberg','0650627039',1),(5,4,'pieter','geen','7773CT','Groningen','0523-324837',1),(6,9,'Henk De Vries','Eggenweg 4','8832HH','Hardenberg','061234546543',1),(7,6,'tjerry de slingeraar','','','','',1),(8,12,'Ingrid','Lage gaardnetrat 21','6373av','Hardenberg','0650627039',1),(9,13,'M de Haan (moeder)','Mondriaanstraat 21','9403 BN','Assen','0592 785308',1),(10,14,' Miranda Venhuizen (moeder)','Eskant 6','9531 AN','Borger','06 46979168',1),(11,14,'Edgar Beck (vader)','Hoofdstraat 72','7879 AC','Exloo','06 10676934',1),(14,17,'Heck Smit','Zwingel 4','7772 BZ','Hardenberg','06124367123',1);
239/*!40000 ALTER TABLE `client_caretaker` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `client_document`
244--
245
246DROP TABLE IF EXISTS `client_document`;
247/*!40101 SET @saved_cs_client = @@character_set_client */;
248/*!40101 SET character_set_client = utf8 */;
249CREATE TABLE `client_document` (
250 `clientID` int(11) NOT NULL,
251 `files` varchar(255) NOT NULL,
252 PRIMARY KEY (`clientID`)
253) ENGINE=InnoDB DEFAULT CHARSET=latin1;
254/*!40101 SET character_set_client = @saved_cs_client */;
255
256--
257-- Dumping data for table `client_document`
258--
259
260LOCK TABLES `client_document` WRITE;
261/*!40000 ALTER TABLE `client_document` DISABLE KEYS */;
262INSERT INTO `client_document` VALUES (1,'11_voorlopig_lijst_strings_meldingen.docx'),(2,'Planning Kleding:Fashiola_1456269177907.52_2.pdf,12_voorlopig_lijst_strings_meldingen.docx'),(3,'voorlopig_lijst_strings_meldingen_1456269467089.04_3.docx'),(4,'forest-image2_1456825651870.89_4.jpg,format-begeleidingsplan_1456825659768.32_4.docx,to do list Tap-it_1456825673886.64_4.xlsx,apps-bouwen-met-swift-1-programmeren-met-swift kopie_1456825694338.25_4.pdf'),(5,'t1.jpg_1456481641414.31_5.png,test.docx'),(9,'voorlopig_lijst_strings_meldingen_1457340370963.04_9.docx'),(12,'t1.jpg_1460023776485.08_12.png,voorlopig_lijst_strings_meldingen_1464098842489.73_12.docx');
263/*!40000 ALTER TABLE `client_document` ENABLE KEYS */;
264UNLOCK TABLES;
265
266--
267-- Table structure for table `client_info`
268--
269
270DROP TABLE IF EXISTS `client_info`;
271/*!40101 SET @saved_cs_client = @@character_set_client */;
272/*!40101 SET character_set_client = utf8 */;
273CREATE TABLE `client_info` (
274 `clientID` int(11) NOT NULL,
275 `firstName` varchar(255) NOT NULL,
276 `lastName` varchar(255) NOT NULL,
277 `dateOfBirth` date NOT NULL,
278 `placeOfBirth` varchar(255) NOT NULL,
279 `nationality` varchar(255) NOT NULL,
280 `bsn` varchar(255) NOT NULL,
281 `settlementType` varchar(255) NOT NULL,
282 `gender` tinyint(1) NOT NULL,
283 `mobile` varchar(255) NOT NULL,
284 `dateOfPlacement` date NOT NULL,
285 `endDateCizIndication` date NOT NULL,
286 `images` varchar(255) NOT NULL,
287 `checklist_category` varchar(4) NOT NULL DEFAULT '1',
288 PRIMARY KEY (`clientID`),
289 UNIQUE KEY `clientID` (`clientID`)
290) ENGINE=InnoDB DEFAULT CHARSET=latin1;
291/*!40101 SET character_set_client = @saved_cs_client */;
292
293--
294-- Dumping data for table `client_info`
295--
296
297LOCK TABLES `client_info` WRITE;
298/*!40000 ALTER TABLE `client_info` DISABLE KEYS */;
299INSERT INTO `client_info` VALUES (1,'Jordi','Sipkens','1993-02-17','Alphen aan de Rijn','Nederland','1337','Zak en kleedgeld regeling',0,'061234567','2014-02-17','2016-02-17','profileImage_1_1457088073018.04.png','1'),(2,'Jos','Verra','1993-02-23','Almelo','Nederland','55555555555','WW',0,'06123456789','2015-02-23','2019-02-23','profileImage_2_1456501356338.38.png','1'),(3,'Tijmen','Kodden','1997-02-23','Dalfsen','Nederland','rfrffrrfrfrfrfrf','Zak en kleedgeld regeling',0,'2846454','2014-02-23','2018-02-23','profileImage_3_1456743349472.53.png','1'),(4,'Niels','Van den Bout','2007-02-23','Hardenberg','Nederland','555555555','WW',0,'97275087','2012-02-23','2024-02-23','profileImage_4_1456501287792.35.png','1'),(5,'Bas','Kuipers','1965-05-21','Hardenberg','Nederland','12345678969','Zak en kleedgeld regeling',0,'0623465491','2015-12-23','2016-06-14','profileImage_5_1456501262119.83.png','1'),(6,'Norbert','Sulmann','1964-05-23','Erica','','','',0,'','0000-00-00','0000-00-00','profileImage_6_1457355698422.42.png','1'),(7,'niels','vandenboug','1982-02-10','Groningen','Frankrijk','','WWB',0,'1345458184','2010-11-29','0000-00-00','profileImage_7_1457515466358.71.png','1'),(8,'bvuh','vfijvf','2016-01-05','hvghn','België','','WWB',0,'808662541','2020-05-05','2035-03-05','profileImage_8_1457184303346.08.png','1'),(9,'Bill ','Gates','2016-03-06','Hardenberg','Duitsland','55555555555','WWB',0,'09871521','2016-03-04','2016-03-05','profileImage_9_1457340383214.62.png','1'),(11,'Erik','van der Sluis','1971-12-03','Stadskanaal','Nederland','','Zak en kleedgeld regeling',0,'','0000-00-00','0000-00-00','profileImage_11_1457648297581.56.png','1'),(12,'Wesley','Dubbink','1991-02-25','Hardenberg','Nederland','55555555555','Zak en kleedgeld regeling',0,'0650627039','2016-02-06','2016-04-08','profileImage_12_1464098821883.72.png','1'),(13,'Jeroen ','Agema','1978-11-04','Wehe de Hoorn','Nederlandse','108405679','Wajong uitkering',0,'06 17152106','2016-07-02','2016-09-02','','1'),(14,'Pepijn','Beck','1998-05-06','Exloo','Nederlandse','230073918','Geen',0,'0610676934','2015-07-29','1970-01-01','','1'),(15,'Alex','Dijks','1991-02-04','??','Nederlandse','204839713','Wajong uitkering',0,'0629370761','2013-10-22','2016-09-04','','1'),(16,'Pietje','Puk','1973-05-23','Den Ham','','','Zak en kleedgeld regeling',0,'','0000-00-00','0000-00-00','profileImage_16_1464006759241.58.png','1'),(17,'Martijn','Smit','1986-05-21','Hardenberg','Nederland','','WWB',0,'90124387149','2016-05-22','2016-04-20','profileImage_17_1464098337750.1.png','1'),(18,'Steve','Jobs','1965-04-02','','Nederland','','WW',0,'0645249','2014-05-02','2016-06-04','','1,2'),(19,'','','0000-00-00','','','','',0,'','0000-00-00','0000-00-00','','1');
300/*!40000 ALTER TABLE `client_info` ENABLE KEYS */;
301UNLOCK TABLES;
302
303--
304-- Table structure for table `client_medicine`
305--
306
307DROP TABLE IF EXISTS `client_medicine`;
308/*!40101 SET @saved_cs_client = @@character_set_client */;
309/*!40101 SET character_set_client = utf8 */;
310CREATE TABLE `client_medicine` (
311 `clientID` int(11) NOT NULL,
312 `medicineID` int(11) NOT NULL,
313 `note` text NOT NULL,
314 `intake` time NOT NULL,
315 PRIMARY KEY (`clientID`,`medicineID`,`intake`)
316) ENGINE=InnoDB DEFAULT CHARSET=latin1;
317/*!40101 SET character_set_client = @saved_cs_client */;
318
319--
320-- Dumping data for table `client_medicine`
321--
322
323LOCK TABLES `client_medicine` WRITE;
324/*!40000 ALTER TABLE `client_medicine` DISABLE KEYS */;
325INSERT INTO `client_medicine` VALUES (3,2,'Veel water','11:30:00');
326/*!40000 ALTER TABLE `client_medicine` ENABLE KEYS */;
327UNLOCK TABLES;
328
329--
330-- Table structure for table `client_note`
331--
332
333DROP TABLE IF EXISTS `client_note`;
334/*!40101 SET @saved_cs_client = @@character_set_client */;
335/*!40101 SET character_set_client = utf8 */;
336CREATE TABLE `client_note` (
337 `noteID` int(11) NOT NULL AUTO_INCREMENT,
338 `clientID` int(11) NOT NULL,
339 `placementDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
340 `description` text NOT NULL,
341 `noteTakerUserType` int(11) NOT NULL,
342 `specialNotice` tinyint(1) NOT NULL,
343 PRIMARY KEY (`noteID`)
344) ENGINE=InnoDB AUTO_INCREMENT=193 DEFAULT CHARSET=latin1;
345/*!40101 SET character_set_client = @saved_cs_client */;
346
347--
348-- Dumping data for table `client_note`
349--
350
351LOCK TABLES `client_note` WRITE;
352/*!40000 ALTER TABLE `client_note` DISABLE KEYS */;
353INSERT INTO `client_note` VALUES (1,1,'2016-02-23 10:57:26','Jord is bang voor honden',0,0),(2,1,'2016-02-23 10:57:44','Jordi mag geen suikerhoudende producten',0,1),(3,2,'2016-02-23 23:12:16','Geen koekjes geven',0,0),(5,2,'2016-02-23 23:34:00','Eet beren op',0,0),(6,1,'2016-02-23 23:42:03','Look out for dogs',0,0),(7,6,'2016-02-27 13:37:44','Even een klein testje',0,0),(8,6,'2016-02-27 13:40:46','Als ik een notitie maak crasht de app als ik op de knop bewwaar druk',0,0),(11,3,'2016-02-29 11:21:17','Test',0,0),(12,3,'2016-02-29 11:21:30','Test ',0,0),(13,6,'2016-02-29 11:35:13','Test',0,0),(14,3,'2016-02-29 11:39:42','Test',0,1),(15,3,'2016-02-29 11:39:45','Test',0,1),(16,4,'2016-03-01 09:50:15','keushbsue',0,1),(17,9,'2016-03-07 08:45:48','Geen suikerhoudende producten geven ',0,0),(18,5,'2016-03-07 09:44:58','Test',0,0),(19,6,'2016-03-09 15:32:34','Even een testje',0,1),(20,6,'2016-03-10 07:06:27','een web gui test',2,0),(21,5,'2016-04-15 13:36:36','Test',0,1),(22,5,'2016-04-15 13:39:16','Test 15:39',0,1),(23,5,'2016-04-15 13:43:44','Test1543',0,1),(24,5,'2016-04-15 13:44:37','Test1544',0,0),(25,8,'2016-04-15 13:50:54','Test',0,1),(26,8,'2016-04-15 13:53:40','Test',0,0),(27,8,'2016-04-15 13:53:50','Test1533',0,1),(28,11,'2016-04-15 13:54:17','Test',0,0),(29,12,'2016-04-15 13:58:16','Test',0,1),(30,12,'2016-04-15 13:58:21','Test',0,0),(31,12,'2016-04-15 13:58:30','Test1',0,1),(32,12,'2016-04-15 13:58:42','Test3',0,1),(33,4,'2016-04-15 13:58:53','Test',0,0),(34,8,'2016-04-15 14:02:45','Test',0,0),(35,8,'2016-04-15 14:02:52','Test',0,1),(36,2,'2016-04-15 14:05:08','Bang voor honden',0,1),(37,2,'2016-04-15 14:05:16','Geen chips geven',0,0),(38,2,'2016-04-15 14:05:32','Levensgevaarlijk',0,0),(39,2,'2016-04-15 14:05:42','Op tijd komen',0,1),(40,2,'2016-04-15 14:05:57','Mag niet buiten komen',0,0),(41,7,'2016-04-15 14:06:13','Bang voor honden',0,0),(42,5,'2016-04-18 13:22:58','Test 15:22',0,1),(43,9,'2016-04-18 13:29:20','Test 15:29',0,0),(44,9,'2016-04-18 13:29:33','Test 15:29',0,0),(45,9,'2016-04-18 13:29:43','Test 15:29',0,1),(46,9,'2016-04-18 13:29:51','15:29',0,0),(47,9,'2016-04-18 13:30:02','Test 15:30',0,1),(48,9,'2016-04-18 13:30:22','Test 1530a',0,0),(49,9,'2016-04-18 13:30:34','Test 1530b',0,1),(50,9,'2016-04-18 13:30:54','Test 15:30b',0,1),(51,9,'2016-04-18 13:31:00','Test',0,0),(52,9,'2016-04-18 13:31:05','Test',0,1),(53,8,'2016-04-18 13:31:18','Test',0,1),(54,8,'2016-04-18 13:37:25','Teset',0,0),(55,8,'2016-04-18 13:40:44','Test 123',0,1),(56,8,'2016-04-18 13:41:01','Test',0,0),(57,8,'2016-04-18 13:41:05','Test',0,0),(58,8,'2016-04-18 13:41:08','Test',0,0),(59,8,'2016-04-18 13:41:13','Test',0,1),(60,8,'2016-04-18 13:41:17','Test',0,1),(61,8,'2016-04-18 13:41:21','Test',0,0),(62,8,'2016-04-18 13:41:27','Test',0,1),(63,8,'2016-04-18 13:41:32','Test',0,0),(64,9,'2016-04-18 13:42:27','Test',0,0),(65,9,'2016-04-18 13:42:31','Test',0,1),(66,9,'2016-04-18 13:42:34','Test',0,0),(67,5,'2016-04-18 13:42:43','Test',0,1),(68,9,'2016-04-18 14:08:04','Test123',0,1),(69,9,'2016-04-18 14:08:07','Test',0,0),(70,9,'2016-04-18 14:08:12','Test123',0,1),(71,9,'2016-04-18 14:08:22','Test',0,0),(72,9,'2016-04-18 14:08:25','Test',0,0),(73,9,'2016-04-18 14:08:29','Test',0,1),(74,8,'2016-04-18 14:08:42','Test',0,0),(75,5,'2016-04-18 14:13:43','Test',0,0),(76,5,'2016-04-18 14:13:46','Test',0,0),(77,5,'2016-04-18 14:13:52','Test',0,1),(78,5,'2016-04-18 14:13:56','Test',0,1),(79,9,'2016-04-18 14:14:07','Test123',0,0),(80,9,'2016-04-18 14:15:13','Test234',0,0),(81,9,'2016-04-18 14:15:16','Test',0,1),(82,9,'2016-04-18 14:15:21','Test123',0,0),(83,5,'2016-04-18 14:15:30','Test123',0,1),(84,9,'2016-04-18 14:21:05','Test',0,0),(85,9,'2016-04-18 14:21:10','Test',0,1),(86,5,'2016-04-18 14:21:16','Test',0,0),(87,9,'2016-04-18 14:22:01','Test',0,0),(88,9,'2016-04-18 14:22:06','Test',0,1),(89,9,'2016-04-18 14:22:15','Test',0,0),(90,9,'2016-04-18 14:22:20','Test',0,1),(91,9,'2016-04-18 14:22:25','Test',0,0),(92,9,'2016-04-18 14:22:30','Test',0,1),(93,5,'2016-04-18 14:22:42','Test',0,0),(94,5,'2016-04-18 14:24:11','Test123',0,0),(95,5,'2016-04-18 14:24:16','Test123',0,1),(96,9,'2016-04-18 14:24:26','Test123',0,0),(97,11,'2016-04-21 15:49:08','Test',0,0),(98,5,'2016-04-21 15:50:21','Test',0,0),(99,5,'2016-04-21 15:51:58','Test1234567',0,1),(100,2,'2016-04-21 15:53:04','Test',0,0),(101,2,'2016-04-21 15:53:09','Test',0,0),(102,2,'2016-04-21 15:53:14','Test',0,0),(103,9,'2016-04-21 15:53:23','Test',0,0),(104,5,'2016-04-21 15:54:56','Test',0,0),(105,11,'2016-04-21 15:57:29','Tst',0,1),(106,5,'2016-04-25 07:37:59','Test123',0,1),(107,5,'2016-04-25 07:38:05','Test',0,0),(108,5,'2016-04-25 07:38:16','Test 09:38',0,0),(109,5,'2016-04-25 07:38:25','Test 09:38',0,0),(110,5,'2016-04-25 07:38:41','Test 25-1',0,0),(111,5,'2016-04-25 07:38:48','Test 25-2',0,0),(112,9,'2016-04-25 07:39:19','25-1',0,0),(113,5,'2016-04-25 07:47:24','Test123',0,0),(114,5,'2016-04-25 07:47:27','Test',0,0),(115,9,'2016-04-25 07:47:35','Test',0,0),(116,5,'2016-04-25 07:49:16','Test',0,0),(117,5,'2016-04-25 07:49:25','Test 1234',0,0),(118,9,'2016-04-25 07:49:40','Test',0,0),(119,5,'2016-04-25 08:41:55','Test 10:41',0,0),(120,9,'2016-04-25 08:42:20','Test',0,0),(121,5,'2016-04-25 08:44:07','Test',0,0),(122,9,'2016-04-25 08:44:17','Test',0,0),(123,5,'2016-04-25 08:48:05','Test 1048',0,0),(124,9,'2016-04-25 08:48:22','Test 1048',0,0),(125,5,'2016-04-25 08:50:14','Test',0,0),(126,9,'2016-04-25 08:50:21','Test',0,0),(127,5,'2016-04-25 08:54:37','Test',0,0),(128,5,'2016-04-25 08:54:41','Test',0,0),(129,9,'2016-04-25 08:54:49','Test',0,0),(130,5,'2016-04-25 08:57:28','Test',0,0),(131,5,'2016-04-25 08:57:32','Test',0,0),(132,9,'2016-04-25 08:57:51','Test 10:57',0,0),(133,5,'2016-04-25 09:03:03','Test123',0,0),(134,9,'2016-04-25 09:03:16','Test123',0,0),(135,5,'2016-04-25 09:07:18','Test',0,0),(136,9,'2016-04-25 09:07:53','Test 11:07',0,0),(137,5,'2016-04-25 09:09:42','Test 11:09',0,0),(138,9,'2016-04-25 09:10:02','Test 11:09',0,0),(139,5,'2016-04-25 09:16:04','Test123',0,0),(140,9,'2016-04-25 09:16:31','Test',0,0),(141,5,'2016-04-25 09:16:41','Teset',0,0),(142,5,'2016-04-25 09:24:01','Test',0,0),(143,9,'2016-04-25 09:24:11','Test',0,0),(144,5,'2016-04-25 09:26:13','Test',0,0),(145,9,'2016-04-25 09:26:17','Test',0,0),(146,5,'2016-04-25 09:26:44','Test',0,0),(147,9,'2016-04-25 09:26:49','Test',0,0),(148,5,'2016-04-25 09:30:14','Test',0,0),(149,9,'2016-04-25 09:30:20','Test',0,0),(150,5,'2016-04-25 09:30:55','Test',0,0),(151,9,'2016-04-25 09:31:01','Test',0,0),(152,5,'2016-04-25 09:31:53','Test',0,0),(153,9,'2016-04-25 09:31:59','Test',0,0),(154,5,'2016-04-25 09:32:33','Test',0,0),(155,9,'2016-04-25 09:32:41','Test',0,0),(156,5,'2016-04-25 09:34:25','Test 11:34',0,0),(157,9,'2016-04-25 09:34:36','Test 11:34',0,0),(158,5,'2016-04-25 09:35:25','Test 11:35',0,0),(159,9,'2016-04-25 09:35:37','Test 11:35',0,0),(160,5,'2016-04-25 09:37:29','Test 11:37',0,0),(161,9,'2016-04-25 09:37:43','Test 11:37',0,0),(162,5,'2016-04-25 09:38:10','Test 11:38',0,0),(163,9,'2016-04-25 09:38:20','11:38',0,0),(164,9,'2016-04-25 09:38:33','11:38',0,0),(165,5,'2016-04-25 09:40:13','Test 123',0,0),(166,9,'2016-04-25 09:40:26','Test 123',0,0),(167,5,'2016-04-25 09:42:48','11:42',0,0),(168,5,'2016-04-25 09:42:49','11:42',0,0),(169,9,'2016-04-25 09:43:09','Test1234',0,0),(170,8,'2016-04-25 09:58:06','Test 11:38',0,0),(171,8,'2016-04-25 09:58:18','11:58',0,1),(172,5,'2016-04-25 09:58:40','Test',0,1),(173,5,'2016-04-25 10:02:54','Test',0,0),(174,1,'2016-04-25 10:03:11','Test',0,1),(175,1,'2016-04-25 10:03:22','Lust geen vis',0,0),(176,9,'2016-04-25 12:08:22','Test',0,0),(177,9,'2016-04-25 12:08:36','Test123',0,0),(178,13,'2016-05-03 12:54:38','Jeroen heeft zijn medicatie in eigen beheer. Kluiscode: 51119.',2,0),(179,13,'2016-05-03 13:06:17','Bewindvoerder: Houkes bewindvoering Emmen. Contactpersoon: Dennis Alting',2,0),(180,13,'2016-05-03 13:10:00','Huisartsencentrum “Valkenhoed†Tel. 0591551811',2,0),(181,13,'2016-05-03 13:12:50','Tandarts Stoker & Veenstra Tel. 0591-630154',2,0),(182,13,'2016-05-03 13:14:53','Behandelende instantie AFPN Tel. 0591-856385',2,0),(183,13,'2016-05-03 14:42:40','Test',0,1),(184,15,'2016-05-04 09:14:26','Huisarts: P. Muilwijk. Tel. 0591-622321',2,0),(185,6,'2016-05-18 09:21:44','Test',0,1),(186,16,'2016-05-23 12:39:39','Test test test',0,1),(187,15,'2016-05-23 13:18:53','Ik wil dit bewaren',0,0),(188,15,'2016-05-23 13:19:17','Deze wil ik ook bewaren',0,1),(189,17,'2016-05-23 15:28:54','Test notitie',0,0),(190,17,'2016-05-23 15:29:16','Test bijzondere afspraak',0,1),(191,17,'2016-05-23 15:29:20','Test',0,0),(192,6,'2016-06-13 22:35:35','Dit is een audio test',0,0);
354/*!40000 ALTER TABLE `client_note` ENABLE KEYS */;
355UNLOCK TABLES;
356
357--
358-- Table structure for table `client_policy_info`
359--
360
361DROP TABLE IF EXISTS `client_policy_info`;
362/*!40101 SET @saved_cs_client = @@character_set_client */;
363/*!40101 SET character_set_client = utf8 */;
364CREATE TABLE `client_policy_info` (
365 `clientID` int(11) NOT NULL,
366 `healthInsuranceName` varchar(255) NOT NULL,
367 `healthInsuranceNo` varchar(255) NOT NULL,
368 `waInsuranceName` varchar(255) NOT NULL,
369 `waInsuranceNo` varchar(255) NOT NULL,
370 `funeralInsuranceName` varchar(255) NOT NULL,
371 `funeralInsuranceNo` varchar(255) NOT NULL,
372 UNIQUE KEY `clientID` (`clientID`)
373) ENGINE=InnoDB DEFAULT CHARSET=latin1;
374/*!40101 SET character_set_client = @saved_cs_client */;
375
376--
377-- Dumping data for table `client_policy_info`
378--
379
380LOCK TABLES `client_policy_info` WRITE;
381/*!40000 ALTER TABLE `client_policy_info` DISABLE KEYS */;
382INSERT INTO `client_policy_info` VALUES (1,'A','B','C','D','E','F'),(2,'','','','','',''),(3,'','','','','',''),(4,'bryjx dhx','neuehsv','bdushebz','bdushs','jdudbs','jdudbs'),(5,'','','','','',''),(6,'','','','','',''),(7,'','','','','',''),(8,'','','','','',''),(9,'','','','','',''),(10,'','','','','',''),(11,'','','','','',''),(12,'','','','','',''),(13,'Menzis','10 02 41 23','Fortis','00 32 69 29 42','The Last Post','2009 D902'),(14,'Zilveren Kruis Achmea','???????????','Middels ouders','??????????','Middels ouders','???????????'),(15,'Zilveren Kruis Achmea','401559327','??','??','??','??'),(16,'','','','','',''),(17,'','','','','',''),(18,'','','','','',''),(19,'','','','','','');
383/*!40000 ALTER TABLE `client_policy_info` ENABLE KEYS */;
384UNLOCK TABLES;
385
386--
387-- Table structure for table `company`
388--
389
390DROP TABLE IF EXISTS `company`;
391/*!40101 SET @saved_cs_client = @@character_set_client */;
392/*!40101 SET character_set_client = utf8 */;
393CREATE TABLE `company` (
394 `companyID` int(11) NOT NULL AUTO_INCREMENT,
395 `name` varchar(255) NOT NULL,
396 `contact` varchar(255) NOT NULL,
397 `address` varchar(255) NOT NULL,
398 `zipcode` varchar(255) NOT NULL,
399 `place` varchar(255) NOT NULL,
400 `phone` varchar(255) NOT NULL,
401 `extra` text NOT NULL,
402 PRIMARY KEY (`companyID`)
403) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
404/*!40101 SET character_set_client = @saved_cs_client */;
405
406--
407-- Dumping data for table `company`
408--
409
410LOCK TABLES `company` WRITE;
411/*!40000 ALTER TABLE `company` DISABLE KEYS */;
412INSERT INTO `company` VALUES (3,'WeMa Company','Mr Smit','Zwingel 4','7772 CK','Hardenberg','0612345678','Extra?'),(4,'WeMa Company','Mr Smit','Zwingel 4','7772 CK','Hardenberg','0612345678','Extra?'),(5,'WeMa Company','Mr Smit','Zwingel 4','7772 CK','Hardenberg','0612345678','Extra?'),(6,'WeMa Concepts','Mr Smit','Zwingel 4','7772 CK','Hardenberg','0612345678','Extra?');
413/*!40000 ALTER TABLE `company` ENABLE KEYS */;
414UNLOCK TABLES;
415
416--
417-- Table structure for table `hours`
418--
419
420DROP TABLE IF EXISTS `hours`;
421/*!40101 SET @saved_cs_client = @@character_set_client */;
422/*!40101 SET character_set_client = utf8 */;
423CREATE TABLE `hours` (
424 `user_id` int(11) NOT NULL,
425 `date` date NOT NULL,
426 `hours` varchar(255) NOT NULL,
427 `hourType` int(11) NOT NULL,
428 PRIMARY KEY (`user_id`,`date`)
429) ENGINE=InnoDB DEFAULT CHARSET=latin1;
430/*!40101 SET character_set_client = @saved_cs_client */;
431
432--
433-- Dumping data for table `hours`
434--
435
436LOCK TABLES `hours` WRITE;
437/*!40000 ALTER TABLE `hours` DISABLE KEYS */;
438INSERT INTO `hours` VALUES (2,'2016-02-21','03:01',100),(4,'2016-02-29','04:01',120),(4,'2016-03-03','00:01',80),(4,'2016-04-21','02:01',90),(5,'2016-03-23','01:01',140),(5,'2016-04-07','01:01',100),(7,'2016-03-09','02:01',20),(7,'2016-05-24','08:01',150);
439/*!40000 ALTER TABLE `hours` ENABLE KEYS */;
440UNLOCK TABLES;
441
442--
443-- Table structure for table `medicine`
444--
445
446DROP TABLE IF EXISTS `medicine`;
447/*!40101 SET @saved_cs_client = @@character_set_client */;
448/*!40101 SET character_set_client = utf8 */;
449CREATE TABLE `medicine` (
450 `medicineID` int(11) NOT NULL AUTO_INCREMENT,
451 `name` varchar(255) NOT NULL,
452 PRIMARY KEY (`medicineID`)
453) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
454/*!40101 SET character_set_client = @saved_cs_client */;
455
456--
457-- Dumping data for table `medicine`
458--
459
460LOCK TABLES `medicine` WRITE;
461/*!40000 ALTER TABLE `medicine` DISABLE KEYS */;
462INSERT INTO `medicine` VALUES (2,'Test');
463/*!40000 ALTER TABLE `medicine` ENABLE KEYS */;
464UNLOCK TABLES;
465
466--
467-- Table structure for table `modules`
468--
469
470DROP TABLE IF EXISTS `modules`;
471/*!40101 SET @saved_cs_client = @@character_set_client */;
472/*!40101 SET character_set_client = utf8 */;
473CREATE TABLE `modules` (
474 `id` int(11) NOT NULL AUTO_INCREMENT,
475 `rank` int(11) DEFAULT NULL,
476 `table` varchar(100) NOT NULL,
477 `module` varchar(100) NOT NULL,
478 `module_name` varchar(100) NOT NULL,
479 `instance_name` varchar(120) DEFAULT NULL,
480 `icon` varchar(100) NOT NULL DEFAULT 'fa-file-o',
481 `hidden` tinyint(1) NOT NULL DEFAULT '0',
482 PRIMARY KEY (`id`)
483) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
484/*!40101 SET character_set_client = @saved_cs_client */;
485
486--
487-- Dumping data for table `modules`
488--
489
490LOCK TABLES `modules` WRITE;
491/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
492INSERT INTO `modules` VALUES (1,0,'client','client','Patienten','Patient','fa-user',1),(12,NULL,'','file','Bestandsbeheer',NULL,'fa-file-text',0),(13,NULL,'app_users','security','security',NULL,'fa-fusers',1),(14,NULL,'checklist','checklist','Checklist','Checklist items','fa-file-o',0),(15,1,'employee','employee','Werknemers','Werknemer','fa-user',1),(16,1,'hours','hours','Uren','Uren','fa-clock',1),(17,1,'calendar','calendar','Kalender','Kalender','fa-calendar',1),(18,1,'company','company','Bedrijven','Bedrijven','fa-building-o',1),(19,1,'medicine','medicine','Medicijnen','Medicijnen','fa-medkit',1);
493/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
494UNLOCK TABLES;
495/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
496
497/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
498/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
499/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
500/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
501/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
502/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
503/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;