-
Notifications
You must be signed in to change notification settings - Fork 1
/
cais.sql
419 lines (352 loc) · 74.9 KB
/
cais.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
-- phpMyAdmin SQL Dump
-- version 4.5.2
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 14, 2016 at 11:25 PM
-- Server version: 5.7.9
-- PHP Version: 7.0.0
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 utf8mb4 */;
--
-- Database: `cais`
--
-- --------------------------------------------------------
--
-- Table structure for table `inventory`
--
DROP TABLE IF EXISTS `inventory`;
CREATE TABLE IF NOT EXISTS `inventory` (
`item_id` varchar(250) NOT NULL,
`username` varchar(250) NOT NULL,
`item_name` varchar(500) NOT NULL,
`item_description` longtext,
`item_quantity` int(11) DEFAULT '0',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`item_id`),
UNIQUE KEY `item_name_UNIQUE` (`item_name`),
UNIQUE KEY `inventory_item_id_UNIQUE` (`item_id`),
KEY `inventory_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `inventory`
--
INSERT INTO `inventory` (`item_id`, `username`, `item_name`, `item_description`, `item_quantity`, `created_at`, `updated_at`) VALUES
('inv_cBIySV_3', 'admin', 'testxsadqwxxxxx', 'sadx', 0, '2016-10-27 22:12:03', '2016-10-27 22:43:21'),
('inv_g1Leba_2', 'admin', 'testxsadqw', 'sad', 0, '2016-10-27 22:11:52', '2016-10-27 22:44:30'),
('inv_t1go17_4', 'admin', '23xc', 'd23sasdas', 30, '2016-10-27 22:19:58', '2016-11-01 04:47:44'),
('inv_XgJceh_5', 'admin', 'tfsdvsxfwqerd', 'ssds', 49, '2016-10-28 02:46:07', '2016-11-01 04:52:07'),
('inv_xJJLx5_1', 'admin', 'test item', 'test description', 426, '2016-10-27 22:11:02', '2016-10-28 00:24:47');
-- --------------------------------------------------------
--
-- Table structure for table `inventory_images`
--
DROP TABLE IF EXISTS `inventory_images`;
CREATE TABLE IF NOT EXISTS `inventory_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` varchar(45) DEFAULT NULL,
`image_name` varchar(500) DEFAULT NULL,
`image_type` varchar(50) NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `image_name` (`image_name`),
KEY `inventory_images_item_id` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `messages`
--
DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(250) NOT NULL,
`to_who` varchar(250) NOT NULL,
`messages` longtext NOT NULL,
`status` varchar(45) NOT NULL DEFAULT 'unread',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `messages`
--
INSERT INTO `messages` (`id`, `username`, `to_who`, `messages`, `status`, `created_at`, `updated_at`) VALUES
(153, 'test-user2', 'admin', 'zedwaexxxxxxxx', 'read', '2016-10-28 02:31:01', '2016-10-31 20:29:41'),
(154, 'test-user2', 'hh', 'zedwaexxxxxxxx', 'unread', '2016-10-28 02:31:01', '2016-10-28 02:31:01'),
(155, 'test-user2', 'kj', 'zedwaexxxxxxxx', 'unread', '2016-10-28 02:31:01', '2016-10-28 02:31:01'),
(156, 'test-user2', 'test-inventory', 'zedwaexxxxxxxx', 'read', '2016-10-28 02:31:01', '2016-10-28 02:31:12'),
(157, 'test-user', 'admin', 'xzdas', 'read', '2016-10-28 02:31:24', '2016-10-31 20:29:43'),
(158, 'test-user', 'hh', 'xzdas', 'unread', '2016-10-28 02:31:24', '2016-10-28 02:31:24'),
(159, 'test-user', 'kj', 'xzdas', 'unread', '2016-10-28 02:31:24', '2016-10-28 02:31:24'),
(160, 'test-user', 'test-inventory', 'xzdas', 'read', '2016-10-28 02:31:24', '2016-10-28 02:34:58'),
(162, 'test-user', 'hh', 'asdzxczxfcasd', 'unread', '2016-10-28 02:31:30', '2016-10-28 02:31:30'),
(163, 'test-user', 'kj', 'asdzxczxfcasd', 'unread', '2016-10-28 02:31:30', '2016-10-28 02:31:30'),
(164, 'test-user', 'test-inventory', 'asdzxczxfcasd', 'read', '2016-10-28 02:31:30', '2016-10-28 02:35:00');
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
DROP TABLE IF EXISTS `notifications`;
CREATE TABLE IF NOT EXISTS `notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(250) NOT NULL,
`to_who` varchar(250) NOT NULL,
`contents` longtext NOT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `notifications`
--
INSERT INTO `notifications` (`id`, `username`, `to_who`, `contents`, `created_at`, `updated_at`) VALUES
(92, 'test-user', 'test-inventory', '<b>Test User</b> has request an item named <b>23xc</b>. You may approve or disapprove the request from the request table in the reporting page.', '2016-10-28 02:39:34', '2016-10-28 02:39:34'),
(95, 'test-user', 'test-inventory', '<b>Test User</b> has request an item named <b>23xc</b>. You may approve or disapprove the request from the request table in the reporting page.', '2016-10-28 02:40:25', '2016-10-28 02:40:25'),
(98, 'test-user', 'test-inventory', '<b>Test User</b> has request an item named <b>23xc</b>. You may approve or disapprove the request from the request table in the reporting page.', '2016-10-28 02:41:03', '2016-10-28 02:41:03'),
(101, 'test-user', 'test-inventory', '<b>Test User</b> has request an item named <b>23xc</b>. You may approve or disapprove the request from the request table in the reporting page.', '2016-10-28 02:42:24', '2016-10-28 02:42:24'),
(104, 'admin', 'test-user2', '<b>Juliver Galleto</b> has added new item named tfsdvsxfwqerd.', '2016-10-28 02:46:07', '2016-10-28 02:46:07'),
(106, 'test-user', 'test-inventory', '<b>Test User</b> has request an item named <b>23xc</b>. You may approve or disapprove the request from the request table in the reporting page.', '2016-11-01 04:47:44', '2016-11-01 04:47:44'),
(108, 'test-user', 'test-inventory', '<b>Test User</b> has request an item named <b>tfsdvsxfwqerd</b>. You may approve or disapprove the request from the request table in the reporting page.', '2016-11-01 04:52:07', '2016-11-01 04:52:07');
-- --------------------------------------------------------
--
-- Table structure for table `permissions`
--
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
`perm_id` int(11) NOT NULL,
`perm_name` varchar(250) DEFAULT NULL,
`perm_description` varchar(500) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`perm_id`),
UNIQUE KEY `role_name_UNIQUE` (`perm_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `permissions`
--
INSERT INTO `permissions` (`perm_id`, `perm_name`, `perm_description`, `created_at`, `updated_at`) VALUES
(0, 'The King', 'Grant full access to the system.', '2016-10-26 02:00:22', NULL),
(1, 'Inventory General', 'Grant full access to the inventory section.', '2016-10-26 02:00:22', NULL),
(2, 'Profile General', 'Grant full access to the profile section.', '2016-10-26 02:01:16', NULL),
(3, 'Reporting General', 'Grant full access to the reporting section.', '2016-10-26 02:01:16', NULL),
(5, 'User', 'User', '2016-10-28 05:39:59', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `permissions_id`
--
DROP TABLE IF EXISTS `permissions_id`;
CREATE TABLE IF NOT EXISTS `permissions_id` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`perm_id` int(11) NOT NULL,
`username` varchar(250) NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `permissions_id_username` (`username`),
KEY `permissions_id_permissions` (`perm_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `permissions_id`
--
INSERT INTO `permissions_id` (`id`, `perm_id`, `username`, `created_at`, `updated_at`) VALUES
(1, 0, 'admin', '2016-10-26 02:01:38', NULL),
(2, 1, 'test-inventory', '2016-10-26 02:01:38', NULL),
(3, 1, 'admin', '2016-10-26 02:02:06', NULL),
(4, 2, 'admin', '2016-10-26 02:02:06', NULL),
(5, 3, 'admin', '2016-10-26 02:02:11', NULL),
(6, 5, 'test-user', '2016-10-28 05:40:08', NULL),
(7, 5, 'test-user2', '2016-10-27 22:40:46', '2016-10-27 22:40:46');
-- --------------------------------------------------------
--
-- Table structure for table `profiles`
--
DROP TABLE IF EXISTS `profiles`;
CREATE TABLE IF NOT EXISTS `profiles` (
`username` varchar(250) NOT NULL,
`fullname` varchar(250) DEFAULT NULL,
`img` blob,
`age` int(11) DEFAULT NULL,
`address` varchar(500) DEFAULT NULL,
`marital_status` varchar(250) DEFAULT NULL,
`email` varchar(250) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`username`),
UNIQUE KEY `username_UNIQUE` (`username`),
UNIQUE KEY `fullname_UNIQUE` (`fullname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `profiles`
--
INSERT INTO `profiles` (`username`, `fullname`, `img`, `age`, `address`, `marital_status`, `email`, `created_at`, `updated_at`) VALUES
('admin', 'Juliver Galleto', 0xffd8ffe000104a46494600010200000100010000ffed009c50686f746f73686f7020332e30003842494d04040000000000801c026700145a505a4d437630534348416d644a4866315679681c0228006246424d4430313030306163323033303030306365306230303030316331343030303032333138303030303734316230303030313832343030303030633265303030303439333130303030363733343030303031313337303030306564343730303030ffe2021c4943435f50524f46494c450001010000020c6c636d73021000006d6e74725247422058595a2007dc00010019000300290039616373704150504c0000000000000000000000000000000000000000000000000000f6d6000100000000d32d6c636d7300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000a64657363000000fc0000005e637072740000015c0000000b777470740000016800000014626b70740000017c000000147258595a00000190000000146758595a000001a4000000146258595a000001b80000001472545243000001cc0000004067545243000001cc0000004062545243000001cc0000004064657363000000000000000363320000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000074657874000000004642000058595a20000000000000f6d6000100000000d32d58595a20000000000000031600000333000002a458595a200000000000006fa2000038f50000039058595a2000000000000062990000b785000018da58595a2000000000000024a000000f840000b6cf63757276000000000000001a000000cb01c903630592086b0bf6103f15511b3421f1299032183b92460551775ded6b707a0589b19a7cac69bf7dd3c3e930ffffffdb004300090607080706090808080a0a090b0e170f0e0d0d0e1c14151117221e2323211e2020252a352d2527322820202e3f2f3237393c3c3c242d4246413a46353b3c39ffdb0043010a0a0a0e0c0e1b0f0f1b392620263939393939393939393939393939393939393939393939393939393939393939393939393939393939393939393939393939ffc200110801f401f403002200011101021101ffc4001b00010002030101000000000000000000000004050103060702ffc4001a010100030101010000000000000000000000020304050106ffc4001a010100030101010000000000000000000000020304050106ffda000c03000001110211000001ee0000000000000000000000000000000000000000000000000000000000000000062a4b771552f3d2a3799acabbe8bc96e9d5d0628f328deede73e1ef6137cf74427ea99f28955dde9ae1efa33ba7cfd000000000000000000000000000000057716f3b7e5686d6fcb57b2e9a7145939c5f9425000000003457dbe6abf9fbadd1f3ebeb6c7cae5e6dde94a8b785a00000000000000000000000039e2e788a7b6bb355dc6e6ee5e05b9c000000000000001f1b31e4a8e7cdd19777692fca3aec5d2ea479300000000000000000001f1afcf1e4fa8973f6f371935f383df0000000000000000000054dbabb6177fc0c1e7f63d4516555a00000000000000000c68faf35f7cc58664efe46069c4000000000000000000000000d5bb119517a471f4fcfecfaaa2caa3500000000000000f9fae1cad93a2c77f27035600000000000000000000000000006add88ca9bd3381737b7e862ad000000000000d453f11f37da708743900000000000000000000000000000019a7b8c576d8751e4fe9bcbeecb1e4c000000001c2f5be6b2859cc3abc009400000000000000000000000000000000d1aa6d164e87aa2a6db0f54000000011ce23151d06de6606ce68000000000000000000000000000000003e3663c9577a4795fa272bbf6221600000038fec3cbfdf25cec67abf3f813ac0000000000000000000000000000000000d1f7b287174fd598ce3e900000042f37eaa92fcb3874b880000000000000000000000000000000000019a6b88f55fd45c711dbf2fbc000001e772aa6e76f3303673463cf7e9538aafb7540b75464b6540b754e0b7540b7540b7540b655dacebc09d600031e7bf4a9c557dbaa05baa05baa05baa05baa05baa05baa05b2aace50fa16540567a5f947ab723e8b223300063310f32e8686fba3c6c0d18d8cbcf78f93b7a3c5d5e59d4accfcbe9eb63c67cc7dfdd955aea9731651a999bfa157cb3a95b9f97c7530fc9f2ddaf13daf9e86ce6800319f88cb8b9d1ba3e7f6a99d4b461e59d48e3374ec51ba12e3e270a8c6fbd87b44ea5a31f2cea5e38feaa92fbc9fd0d7ce0287d33cebb7e6772e053a4001556b4a71373536dd3e1e05d980a4b095ce65dfd2e21ccd18c250d55b70aeea3956398cf02ece31e33cefd58e6df55d152dc23b06ac2000d3ba2c2cacd136565df35cf5fe8c9f42dce813d0b28f65c216e9df859404a398ff34746bdbd0ebd928605b9c0adea799e839dd9e9c67d8000a3bca538eb3aab6e9f0b02ece031979ed1ebe87567d9a25d3c57bd1679dcfb1e87141f2745f1419f3d995d6d3fcf624bcb464a4b3ae9f46a9234e2000439906bbb45ad6d94651a93a5c25536712ba165fb9e7be742e7def9d0679c79edcd56db3f3da7bcfb594605b400040e839fe839dd8e9c67da000acb38c79bdcd0df74b8817e5000000632f3df9fa00f7c000a89b067e6db2469c40019afb0815ddaecab2cfcf42da0007bf39cbc07be000000015bd571fdd737b56c28d60000793f41516fbf921ab000000000000001496b49d066db91a71000224cd50b2b6de86f61705d940000000000000a0f4ff32f55e577c2bb80000f3edd69cf6ac36037f20000000000001f1f7ced5a1d1c693e302ece0000739d145abcbbefc6ac00000000000006624671fd2b8cecf91f420f400008de63eade673aed58cf57e7c3df00000000033a76d4d7741b7a69d977dc35ecd9cc09440000cd6cbaba35e8bde76ceabecc6ce6800000000019a4baa3cdb7d02d0e7f60000001caf55a8f3cb0e7fa1e971702fc80000000000224cc46741f3d0fcd1aa0d85657bde8dcf3df3a2f9e79e7b615f636051da49cce9c0bb38000000000004599cf7a5f37b73051a80000000e1e2f73e61765e8074f880000000000000001e7a1e81e000000000000019d1be829d167e875f61ccee03d00000001c7763f079d58525cf438ff00434e2000019aeb18d8c3e3d8fde61cbf3d1089af9faf62cabbc9d80956ce8f9859204ebce205842cc1894328161e498462534edf7cce335de4ac04ab0063cf636ea5f4fe6f6f78a748000000000157e79eafc94a1171536dd3e1059501af103467db1efb98b2a745ac783f13abeadf9d9b19da536d80f6ff006547d4eab6a1915d5ddd3aa56e791f10fe69d17ea95d9e35ff003361569b6f8acc5b9f4def353eabedaafe627b1b69749ba51b4a2935b0b3a7db4b6fa31fd8bb328e65863e95d5f18ba6000000000000079fe8f44f3ab68b0cc299d2e204a00525e15dd8d3b93aeaed3388cd516f935fde7128292f10b302ca61fc5862bb82ca692ef2aeec6329d54d739c42d57593d8c59587be292f119e0594e627d40cdb777a3fc6de7f5c1e80000000000000f8fb1e6f9f44e0eda242a2dfa1c6c0b2a00000000000000000000001134e72efd3e8ff005b3075721e800000000000000000727ca7abd5ca1ccfd52caddcab01a7100000000000000000008519cca4c77787a947dae59b700000000000000000000001f1c97603c9ed7bae42ecd9c504fd7ceb06337e50f7c00000000000418593e3545d66dd4bd07592f27435ec233000000000000000000000000000d7cd7523cce27ab479d7e7f36de92fcb25511adcfd0628374ebba543d8dbaa3e0bac50fcc27d0ebab9b5ddaa075b7d4e9f3be87adcd3a746f1e800000000000000000000000000000000000478b6429f17229f6d988d240000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003ffc4002f100001040102050304020300030000000003000102040513141112203040101550062132333134222324357080ffda0008010000010502ff00d333b0182964e9453e669b27ced55efd553676aa6cd53751ca5292859013e4cf91a8145cf454b297cca43b864d41d35082d9096d02b6805b402d9053d0827a0e9836c2a391c8050b3e8193a864cfc7e2ec5a0d76b39d539ddb8a141942b8a1de9845353a31506b951ebe726cab5d059f87b570155ace62c1de15264718063f1081191128bb2af94b555ea642bdaf833146185ccc908875264718e036f1e508cd8b49d954cb9abbd7b02b30f3f219415552dc5f20410179850c0ada67a73c7e5867f35dd99b2397792af4d7f1e7d8a6d258fca4eb3c271247c92922285fc812f4eb5688be08e0899aa5b3638b5ce3b03f1ca5804772d17226006218fc194512c4263638f5ac0ec8bc524e2385cb44c89c2288a3f0a41c491014b8db15cf0b02f0ddf82c9dd95d3570b061f0e6131614ec931d66138923e1672faa80d28fc4d90b1a187bcf5c9e0e56e6d01483ccff0017781ccd85bdb8177c9388e049cf21719999be309cd4ecd6346c03bd9fb7c5ea8b487f1a71b14784b2f5ec776d9dab57a91739fe3ef8f83e36ceeaaf73ea0b3ce600f485f1e48b4e3863bd6bbdb391821aacf62cfc8df872ca89f7357b5f511f9434c7a61f913c3505f4e9f84fb57a7bbc9fc9f36d321d9b65d0ad8e87197c9e461fe1892eb50ec7d425e5a94a3ca0f93b11e70fd365ecfd413e7b916e58fca6265a395ec5a7d6cbf4ef86b7c35be1adf0d6f86b7c35be1adf0d6f86b7c35be1adf0d6f86b7c35be1adf0d35d83bf677c35be1adf0d6f86b7c35be1adf0d6f86b7c35be1adf0d6f86b7c35be1adf0d6f86b7c3517e68f419f46ff629ff00b2d743ff00031c8b2d9996cccb6665b332282626882726db116d88b6c45284a32d9996cccb6665b3327a86661fe7d897f0e9aa164db332d9996cccb6665c9279edc8b6c45b622900916106655b332d9996cccb666450cc483fa7a324dfe55a7a95faad4b92ae35befd20ff0055ce8b03d51c09203c4c392d4829d98b2aa29149d16a7c806fb3f609f83438c294f981d170328cc7659d6a4148c36452c8cf545a23e8befcc68b72c7a322dfebc4cb9b1dd5947e18fc6fe1d37c7c1eb198b0e820e0452a105edea14c51eab047b05b90d378fe3d67fd3423cd1149ea9dbeedd04a839a7a0a342286180fa4c56142a41ca6e9bffa304fc71dd5997e18dc77e9e9766931073aa4058897b6eeccd66cb95ead7d26c97f22fd7d76bf4637f0b2063441624078c9a4dda31e0266625c2420d0874defebfd3ffd1eacdffe331dfa3a9d99d8d4dd90ed906876444eb94a3145bb08ae07b4e0af117a64bf807e9ebb9fd6c77e947040ccf0355715e8ba8ce33eb25810d12eca485525378c5a0dd57bfaff004f7f47ab31f7c6e3bf57626384d4e8c5685912d7b305be22dfcd6f4aeb9ad913532490ea0a1d192fc6b7e8ebbbfd6c7fe8f525514d4a9122b8db1ade1a2b7e45be22dc599ad1b4450a0c86280fb37bfaff004fff0043ab24dc68637f1eef06ec647f0adfa3aef7f5f1ff00a3af8377b21fa306dc31dd5663cf5f1bf978b92fc2b7e8ebbbfd6c7fe8f1722ffe18b8f2e3faeab695df172483f60f5dbfbd7c73ff00afc5c93ff9821a61ebbd1d1cbf8b79f98edf66eb23730f1cff00e5e2c9b5b25d8fa887cb660fcd0f0e726846ac5cd63b24e35ad33b49bc4c3475b25d8cf8b9e95197303c2e3c1ac15ec4c02608fb3643ac3a87d27f0ed4b901f4e0b80fb1606c605093c0be090b01b14c4b32ad5d82ddbb3598a836261784e336f07233fb6343a14bb3941edb24cfc5bc0353e75c0f59c779940919f688580d12f2d33d97054d37f0430de64bb59f06a55a24e70f844ac3229d29c53593850ee0e699f8f43bb3225d1c56bd83285193a1d718fc3b33d30fd3b5fedda2418901b3d4bbe23b3491290e49c3600b7a565be2a7b86926ae7321d31c53370f16ec9ca6aa16af5fb7f50565589aa2f8f34f4c782afad63b87144c21f353b7f1f726e52d2aed56b7773f539e14cda83f8db25d21e06a73cfbcecd26b80963ee464d38f61acf13fa125c90ac7d66f4b1634545f8c7d076b9cde862690c05d687a1ace913d1d57b3ad2f4b06d188a7a90f47b3c0fd2ff65084f2170438887dfc8548dcaf588f5cbd4e4833ea8d4651df6a8d6a8d1c8370e3e718b6a8d6a8d64251938ca3e4d51ad51a04a2d73546b546ae12120519c221d51ad51ab928c8faa35aa34e51f0a128c49aa35aa357e7090ea920c0d51ad51a94a3bed51ae3c7a2e9b99f134b680f0735435a34ac733749a9ea4fdbd307fe8f6f5ede894b9215abebaf6f5b05641a2a3478c7dbd6c10c3ce7f6f5ede8f534875eaeb43dbd7b7a387489b05ede9e82ae0d697b7af6f562ae8c454f507edebdbd387fe8f6f438f243d2dd8d28e12871f13318fd1955b0c58f54473defa19b88a842506f4bc394dc7f687a04536b7e96e2f305283c03e96c5391fd1ff8a239c27e97a1298eb45e20f490e7bdf5b0660c71746574acdc3c476e2d93a12a64ad618d1f8539a218d1a64c8187088e1e2ca2d38e4b1f3a73ad658adf0760f10b52a65c8144388a1e3bb716c962a4255adb4be0acda61ac7e349725084471f2b25898990ec12bca1269b79aeed163da94df1d87f3ae520dc8d8a9671f205b813cc35980908567233a38e0d46f3dd99daee16135cf629cc56465f20a718939cd6254b08a108c23f04610cd0b7834f3b55243b839a6767f0c96c505af62ccaae127240ae2af1f869c2248d9c2008898dbd5946e160f0ba27519c65dc79462a56c5152bd3921d1bd6d57c186084218a3f16508ccc6c2d59a2e08ac9e964429cf6c49afc9364196fa0b7c35bf82dfb27bee9ac592a8d4c8990f047920e12b4106b841f29208a69e85492f6ca4ebdae92f6ba4a342a45440187ff0cfffc4003011000103020307040202020300000000000200010304111214311013202130405122323341526134420523506071ffda0008010211013f01ff008c77b27a88c7ed3d644b3d1acf469aae27fb4320968fdc4956008eb4df4e488c8b5e30a89074751d7fe4c82513d1fb39aa463ffd52d41c9af519ddb450d6bb723426c4d76ebe8aa2b3fa82d7af14a51bdd94138cadfbeabbdb9baa9a973e43a76424e2f7654f50d2b59f5ea55d4627c23da0938bdd9413b4a3fbe9564f81b0b76d14af195d9093135dba066c0377521b9bddfb7a29acf81fa15d2ff46ee19ecf7511e3167e277b35d4858c9dfb9a09351e2ab3c31f754e786467e2af2d076e565f0b2b2f859597c2cacbe16565f0b2b2f859597c2cacbe1491107bb872b2f859597c2cacbe16565f0b2b2f859597c2cacbe16565f0a484c3ddb632c42cfc35af793636aaa2a4a37e4b3e6a3ae2726c488cdb4d134b23fd29ea9e37b32cf9a8eb2432665fe43eb8035551294637159f359f35bd2216205be93c296778c2efaacf9acf9aaa3c510df6d2bde26e1aaf95f6c6ed38607d5918383d9f604e61a3a2aa95fef6335d00b538e32d54ef8a2127e08bdec8a56695c0b475340f1bfeb604841ed759b97ca22727bbec860bfa8f453cbbc2db45f1f0d57cafb59ec86a589b0c8d75b988fda4b247f4b2522ca88fbc96fa38be36466e6f7247fc71e083e46555f2ba8aa5c393f3658609347b2c993e8eb2522ca5bdc4af045a73752ce526bc143f1f0d635a57e2bbac4fc07fc76e083e46553f2bedbac4fc746dfeae1af1f533f4e6f4c22dc113d8d9d55b5a47e9c0386366e1ae1b85fa5042f23fe954c98cb969c24dbf8eedab74a31c44cc9b970ca18c1d93b5ba10883bfadd4c24e368b44e2e3af0c11cb7b8aa808b577e7d1a20b9df8eae3c077f3d10908344d558b948d75ba8a4f63d964a44d498799badec31fb1ae8ea4cfa5491e00e3aa8b781d4bbabf4e9e2de1f46ae1c0576d384e320d5335dec8c1c1ece801cdecc9dac82322bbb7d6cdd961c7f5b0a3216677fbd871903d9d0039bd9910e17b3a08c8f4dacd754d0eec7f7d130631b3a96278cacfb46382dcc94e113db13a08e0c4d6253842e7ea250042c7e97451c17e64a108984b0baddd3fe4b045b9b5f92ddd3fe4a5089c4713a68e9efee55011397add4210b1fa49491c0e4f7250044d7c2ea61899bd0fb28e9ff00b974e685a51460e0f67db2caf25909617ba964de1625149bb2c49deef751cb819dbcecdebeef06c925c62c3e133d94d26f0aea33c058919627ba8a5dddf652d3637c45a756680656e6a588a37b3f634f48e5ea24cd6e4dd630636b3a9a908398e9d608c8dec2a0a460e65af652d2848a4a430d39a76b7446323d194543f6680041acdda94407ab22a107d115017d3a7a39596565f0b292f84d4523a1a0fc9d0524629999b4ff00b67fffc4002c110002010204050500030003000000000001020003110412213110132030321422404151334252506061ffda0008010111013f01ff008cb4149cfd4f4ef3d2b4f4cd0d07fc85186ff2130ecd170ca378140dbada92b7d46c2ff98d4d977f874e897894957b845e54c303e3194a9d7bfbca587fb6f80f4c3ef2a5229dd02f28d1cba9f8445f432b51c9a8ee50a39753f108be8655a790f6b0f4ae6e7e33a07168ca54dbb08b98da2ae516f8f89a7719bb1864fedf208bca8b95add405cda28ca2df2714bfdbab0eb77f9555732756147df1e724e727ece724e724e724e724e727ece724570db74f39273927393f673927393f673927393f67393f62d456db8b8b35ba70c3d9c0ca74438d67a658d8616d22a21de1a74c7dca74036a67a658d87402f30bf7d076949031b19e9967a65829a83669c94fd8b4833693d32cf4cb282d9cdb8d71ef3d343c0716bd36cc368ac1869c1a9ab6f05141c09b466e69ca3694b4723a1fc4c09ec0c3794ea07e0c81b79c848001b70a956ded5949328e389f3e9a1e038917868d8dd0ce63aee27a85fb9ea167389f11396efe715428b08bfca7a2a789947c23d20dacbd44de7a81f627a859cfbec25aa3ff00e44a617a313e7d387f0ebb742ff29e8a9e0651f01d161d788f3e9c29f6dbb74f5a8c7a1c7b4ca07d9dbaa6ee7a70adeeb76aabe51292651af483ca6b1dbb4c6c2f0f4d36cad7ecd42c07b653201bbef0107a6a325ac65267dbebb3896b2dbae83e65ec950778685b55333ba7909ea1673efe2264a8fb98b4557b55df3375d07caddcb772abe55ece1ea66163d2ac1b68748ac185c4660a2e608580df86617cbc03026c382b061a42428b980df58cc177e8ad533b76518a9bc470e2fc4b54be82526717b08cd52db4a6d532e8255672ba881eadb69519ee2e267abf9333f336d667abf929b3dcd842f56db4a4ce07b44a8d532ea22b54b682556736b894cb9df8622aff0051dba550a18ac185c7144c908b888b945a3ae6168348c99883c327bb37054ca4986534c82d1d730b402c2d1d33f0ad5b2e825fb94ea94311c38d3e0d6af6d04dfbcac54e929e203687bccc17532ae20b683e125765895d5bb4ce1778f89ff3198b6ff156a32ed1714df706297ee7a849ce49cf4871290e2bf23621cc249ffb67ffc4003c1000010202040c040602020203010000000100020311122131321320223033404151718191a1041050612342526272b182c114d134b2708092a2ffda0008010000063f02ff00c3397161b78b9571dbcab579c7f8abb14f25723741fed5d8a392bcf1fc5551c73042c88d0ddc1dea7951813b9b5af83049f772c8c9fc1abe23de7f272ade156e2b6abbdd5ceeaef75b554e2aa7af86f70fc5cb28923ee6af8d039b4aaa2d13b9d5298f4b9c5881bedb54bc3c3e6e596f751e8165bba2a9839e7ab60592e929c27b80fb6c52f110e7eed5f0e209fd3b7d1fe2bebfa45aa8401831ed5954a2badeaaa6ea994d5386e5462fc46fdd6f5590f93fe936fa1d388f0d6fbaa1e18511f56d54e3135f55268d624e135384792c1f8805edee15384e0e1e8145b971776ee2a9c4755d82a857bf5cca0b0905c7884191a50e2763aeccd88c2f0bcdff00e9528bd155afd28751dcb05e26659bf6b5073082d361d68bde64d1b560a14c42ddbd4cd6ef42dcedea89ae19b5a84486663582f8864d0a8b6a862c0aab77fa248a9b6b69b46c7211219abf5ab17bcc9a2d545b54306a1fda90f46a2e5315b4da378422433307549958185a21ff00e94b6edf48a2549da337820f699b4d8753ff001611fccff4a66f9f4afbb62ff1a29c826a9fca752c9d23aeac2bf97a6611b68b560621f88cee3502f71935b6a2f367e8290f4d6c587be61362b6c767c78561f77af736fa716f447c3beebcf439e7c53f2a7467d75cf9fa808ad4d7fcc2a771ceb7c336c6d678a0df502d3b5605f75f573ce3e2bac689a7457ef9fa90881322ed22be39b64016bcccf04379afd49cd513c39db94336efa41a3c87aa3628b273e59a8917e96a73fd51afdca11da0513996c3fadc87bd7ea8e0a341fe4332c863e56a0377aa86ec74db9989f9cba635d72bae575caeb95d72bae575caeb95d72bae575caeb95d72bae575caeb94a473575cac72bae575caeb95d72bae575caeb95d72bae575caeb95d72bae575caeb903bf15913710eccb9fc4e349aaef7577babbdd5deea6e0a6054ac562b15136abbdd5deeaef7577ba9cbba6f1cc9f2040b7dd5deeaef7577babbdd50daac562b14c84688b15deeaef7577babbdd0a5b533862b0a84ffa9a0e3c676e6129e71a8f2c52d545c15e57875593595847d98aef7a903997704e76e4378c5c2b165d455e1d55e1c95060a94b69b715ad1b101bb15a7dd413ed2c78ff008a7e308ade6bee16e2e505538855c4ecabcac60c658a181b021987f05141da88758a6316ca27d95513b2ade4ac918b48ac2bb663734cf6271e372fda3c71a45536dd5b9dbb37326a5838767ed4cdf50d378661e9dc57dc160e259fa530663375dbb95767e9516e315fcce3c6e5fb0b9e3c8854a174546209fed5e971c7ca32591945576765bceff262670cc3d1e3e55dbbd4c58b2c5159241c7addd14a1892a51549a2431dc8fe671e372fda3c73394d9ac874b8ac83d0aac1e6156d0ae055342f9bf4a6f74957947df119c5338661cb9e25944fb2c874d7cdfb55b4745702ba1540f20b2a7ccacb774592d9664afe671e3fe09f9eb330de299c330e5cf31667b9a87ee4fef1e2b77b084f1ab31338661cb9eacd1eea00fb67987c3dd31ab302670cc3d387beacd1eca1b3e9681987fbba7d7566b429661c3d93dbab319f701998513ea6cba20778d50b8ec5843b2bcd4f62046ab4fe99bb334fe874d4b76a983658a8f5cd7dc2c5838967eb54715162ef321997c33f30927433a94dc55060ab72deece526de583882a53699ea4d6735099b65339a2f163b2d4f519b5e67eea6054b2db2e0b25c0e6b29cbe1b7aaa4473532f33f6d49adf967db36228b619eca5b5ba9dd91f65386e9a93c4f8aaf24a98c499320b2729499d94e23954dd4c9daa27883b72466dcc758e1229d09fbe5aac889ac9c92a6decae8575aa400e8a6f32e2abca2a404b556c26d7b39a6421f28ce37c4b7f172076edf502e47c43ec659c73ae86eb1c249d09fbe47d41b0595d72e699086cb78e7878965e65ee0a46f37d3a7b7623e29f60a9bc73e41ac1555c35b7820e1666705476db3f32edc8e4ca5e63267340eff003c1d1efe74a5354a52f3a3467cf108a3297bf98329a0eb27e782a3b6d9e34d0636cfd04d86ca9ad121a8167cdf29f7460c4aabe98f22f68e6b48deaa94c4a76ad237aad237aa7e5b6cde9f3701c5691bd5691bd5328b81e09b96db37ad237aad237aa24912ad691bd5691bd5101e0f3522e02bda5691bd5691bd502082b48deab48dea8e5b7aa7522054b48deab48dea849c0d7b13417b4735a46f55a46f554a6253b5691bd71704ce6b2b4afbdfeb52ff002210f88dbc378541d6ecc62ea72e4b49d960a96d94d693b2d27645d84b3d93b2a52f65a4ecb49d90ca9cd0384b7d9693b2d2f6583a4b49d9693b2a74e7c952a72e4b49d9693b2a34a6b49d9693b2d2764452949693b2d2f640d39f241d4e53f65a4ecb49d960a96d94d693b20ddde7445f2878a8a3f01fdea9fe4c1191f30dca46f63d3a2653f3701b93a9023cdb45a4a6f0f3a45a655f99004d49c2467e6086923cca7526915798a2275a683e74e8994f13df62c346d103ff00d6ab2362c3419e0bfeabeef46aeddca9bea862d3fd20c60934583562d70982b0d06782ff00aa91a9de89bddb9537cc42da7fa0831824d1ac48d8b0de1864ed6ee545f6eff42936b72c3479885ddc835824d160d6cc58126c4dadd8560e30356fd8a6d331af4c992a1041ff006845f1427b99fef5e93c650b1c2d53b59f50b148e4bb5cdeedcb2464efd814c6544fa8fa04889854fc31a0efa762a115a78156c8eed6328f25420b4f0083fc51fe0106b1a1ad1b07a1d188c0e6fbaa5e19ff00c5ca8c5611f92af24a98af53b691f65420b4ff00154bc4be5f6b6d546130347a3d17b4386e2a7089847a8536658fb15188dfe95752c97039cca202b67c1498d55b4b46f7d4a719c621dd605461b0347b0f4c944635fc42c9a50cfb15f0a335dc6a571c47da66be24370fc9b255b02b9dd5d2aeb95d2ae1eaaa605f0d87f8b66ae3c71a97c48ac6f0ad659744ec17c286d6f01ea9950d878855f8787c9abfe3b5680752b40d5ff1e1f45930a18e0dff00d19fffc4002c1000010204020a03010101000000000000010011213141615171203040508191a1b1c1f010d1f1e17080ffda0008010000013f21ff001981e4905db50f6052ecb12065901fbf8284cf383f6a71994943f4221438a6003bcdd40a5cf452d765ba05092018790ba91e1bbd153ec83a066f24078f8a17fc4ac79bed1b5e244940e28d91ce2a9b3985db315d755755287a2a1fb4ce03eeb040004041a8dd763aaa7045f7fc029952a13d042cc364a80e2d77840c8f89ac2b31087e44de28e59e5f885c663439373bec029885c1183b600c4fd276e788b97252f89c4c7e61b0b8b0f8d51b8e690303cd33320a4081206250ff00adc65212aa1d27c9708f2144c9231172e4994c5ea7686910ba8ce820a04e0e7d8ac52462331b80096b0e61e9444ff1a1fa01079d514f6c6064913458e9bd0845688bfab6da744002249a22a59024099f554635c98ff4800000000506dcd44f001c9141ad7802f42108aa382476a05b15c92628fa155e501198e1b8a39b08c74993a06e10099798381da06345724a19013b2ee5322229e2dc8d1f23509cc7041f69e4453152c0ecc3fa2b9151e5fd4c9b746a71dcc660e3820de523ee5d6d881c0ec8002460264a8e976176299089cdba093827051c678a0c4211a15c151b1949396bd714363f06ea6448264f341b7a103b1063298617458918cd538eec821de0540341f9db036f8392757148e8a02130019b761ba087edf60293a92c0d46bc9828c741e792670456ddc282755d1cb66c1fd632e5ae891b2031340a242884d4b781618c5a850cf9a5d9ad21abc1712974ee8750ae7bc24b00c88c8c57da8fae3ac9b862512a31733bc8f07dc622487870ca9eadc4f41bfbd948555bcb1f19c669d4c399af8e5ab69bbb2753caa6f37c3803c69f940821c441d4e3b108ce9d538940dcf7a38054c53b27b221d9b52d518c6c87f5b7aacc9670a010c881743e35272271d627f15b501bd48f2ce1dfc0d4bab0f03c6892c09d8622222222222222207c23ea49604ec31511111111111110f14041c180e8d1d1a8624004992327e67aa7fba20e42c8b02e444ab6e456dc8adb915b7220c6c0c2685c475d59735eb2bd453204b6e456dc8adb915b722382184645d1353d12990aa900e2056dc8adb915b722b6e442109e4adf9af515ea28a5a01741c9eaa2adb915b722b6e456dc8a13b5115d0fb68e61047bcd6327341a7ec34165600691bc752745470cc2373d9e582090019c1104d61ede12a62178d744443c419c53b5284c6b9185d61d372c9d18ca625cb50a1e0661022d3137320821c658a8a71b45374415a301a2f6092cd74891e34ddb78e68235c69172420992701e7442b0cdea883cf03a04f4123a04ae8000300c0684b2519a02c2e872333d51b9f103504d9fec872d3077534ac0fda200238323a1351605c87c202e98194a5071ae8994ca0c4a3c924ef7d217ca098181eba6e3b074208ba5391b830213d1380a1ed985e35674000992a205d0ba0a7e5d1044cfc28b2fdb504d96823a422c251c534c2d3c505c626adc66f4238601ad010b0180d2eac238fd25a87a667ec34ce8020cc1475c7cd1e088bb663229301610698470e72a08079010737748216e2e97c7527c237cbea3a01dc20898fc60035013516a7188839a81bcc44421cf961d39024e112273ead53f121e2d528744061a7d92f5580d31009c3b08a1ea62584874496a3c2e11f02881cdf02bd52a4c0c82a668b043ec0b994d842e7d10000612f99ab913ea0135d6eebbdf1f3351d170845c7d055f7820843334f44a2790f81f851ad31530ed81038576a4f9e10119bc1a6df188f2470f0235a403300ab4e49b60ecec9777a8b4e48002400d6936714fac6f50f1a7fa2d0459800ecd217281b5105ecb7753b3f8d9b3b395ecea47cea2e8393f9b31759030b7b6a0195bcaca9b31dc1bbde4bf0411a8c0c03de3df66ada00040c05036a2f9926f18c7de7b355f0786af9d4b03f60bfaadf87643b700463249daa06313b8b828c5b821c1d90c039923bba3c5e7530bcc5c061f49b6a36d8c81092c0550cba5f0ba100899962754260622124ce83d5b262b10c38a71c4ae14fbea648c7c8a01e4d2e3d3b13498c054a0028615734e431667582200ef4fa042866136d86c508562f79a798373431d51862380e33eae800088311b0593e2f0ce81e2014cb3852d9c40ef906aa24216aa0c9cbfd136c050a0104060320d8aa1cfc93d5b77aecd3f0980f03853639d5c4089e41428c3eeaa8511b9f6800e020d4680d65884a8538ed04492020602a562c22548a27131d8e3945019a600fa49f1ab054e602c552d9df076518c83021460cf30228e923137406625231057e51411989a8891c740b1775c40060180d962560583125227609c4d4f3d64bdeb03e3928e904336f009ba085d162e3c46a7ef6d6c47df14b3b7d23bc01c92902a49a80908f1ab5cca20332b8b828c540e5bb867ab04301c48b5a8ebc458018835531cc631c08ecc43521ba822bf1009d8ec806d157e5ef585025980b7cb8c36243d9f2fd2947579cccff2314f56054f82604e0802601fe55b62d3509ec3bfc5506ca1a4100245808929c5c63e614042006c041b018e0a0a52d6106ad32e20b82fcda789ae682fcdafcda08021340299162665f9b5f9b50585ddce801119014afcdafcda1853a2260bf36bf3688628400274b9d002fcdafcda1911844175f9b5f9b5697851402e22cbf36bf368227f11d17c0048862bf36bf369a24b9a0bf26800020820c88d03c58c64a9c105e0130b0d88fb0040f670988d0cd88d2a9b522f2b37de69db84059bef359bef35318c76fda6454c907bf959fef34ec796652e6c05bf6b37de6b3bde6824851316c166fbcd66fbcd04f2544baf664cdf79acdf79a086722ecb3fde6b37de69904be1eea852dcf259bef3599ef355a52c82cbe266fbcd66fbcd356080bd7f6a213b19fe630f82e9c66c7ae1b210ad88b82bc459389619df4c2228997687c985092600145f4219c7cc2d07760808443101f26621f1110f930e2849390389fcb4d80881f3d322900350f90294b00421c82057354f82802065da1a0ff99c898312e0bd5864800c030121b2088004a041aa128e1e6c325420198f3b9884c452424312b3ec41c22b029b302004c41914547275279aca16834c72dc98a492433839e805b15801b4088004a041aa324e2310cef164ca5029c5b89d9ae88420428bc7a16422a2302436b643923e928c45bd889919f36e0e060137535c16702391345d13f574400018061b6c32ec029df4c51678260e292db1f03da794c93b4c4a0a6950a22ed86e03a18902088147081899b2c1433dbd414d005cb68015704d477668b92aa9d5fee7e94048000c06e32a395014c61ed02b296820722a14799f6803800d46c44801c960a122c3eca646680e79a6c6d9bcfc4562771a67335dce4841981c22670847611d23ba4fd1454c89821ca622770ba381d675c42ca5c676230cc13c51604c6a3070fe26cc3d7e8ac31dadd8c4767273239c875517c8a4fca97591e85480c54aa1915526131fe183452699928d665d4f866250b1c6a6dc49b8fc26627b027b1f68235de273de9d0352bb4307644c73c024795ef9e50017eb1fb526e3bfbae9da0ff867ffda000c03000001110211000010f3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3c0f42e43189bcf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf079f217df3ef3ef7adfdd3cf3cf3cf3cf3cf3cf3cf3cf3c490f7cf3cf3cf3cf3cf34f47f3cf3cf3cf3cf3cf3cf3c6dcf3cf3cf3cf3cf3cf3cf3cf23fb4f3cf3cf3cf3cf3cf30abcf3cf3cf3cf3cf3cf3cf3cf3c9fad3cf3cf3cf3cf3ca02f3cf3cf3cf3cf3cf3cf3cf3cf3cf27ebcf3cf3cf3cf3ccbdf3cf3cf3cf3cf3cf3cf3cf3cf3cf3c5ebf3cf3cf3cf1cf7cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf23f3cf3cf3ce1af3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf24c3cf3cf3c50af3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3c6bcf3cf3ca7cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3c694f3cf3cc7cf873cb3c73cf3f9f3cf3e1cf3cf3cf3cfdfcf4ef3cf3c03cb40ccfbc28f3125f3cf39373cdc39ac7393cfb9f3cf38a3cf0677cc5a738a3bf3cfaf5d0f7ef4ff5c03cf27f3cf2c4fcf3ecac9530d743ff003cf3ad94670e28142f3cf27f3cf2877cf3cf3df7df7cf16f3cf9477cf7cf7dfbcf3cf0df3cf3cd7cf3cf3cf3cf3cf7ff003cf2713cf3cf3cf3cf3cf58f3cf3ce3cf3cf3cf3cf3cd63f3cf3d175f3cf3cf3cf3cd6bf3cf3c63cf3cf3cf3cf0dbbef3cf3d61df7cf3cf3cf3c77cf3cf3cf38f3cf3cf3cf3cd6e1343852bdf3cf3cf3cf3db3cf3cf3cf2ff7cf3cf3cf3cfbcf7ef3cf3cf3cf3cf3cf13a7cf3cf3cf3c6bcf3cf68626e3e93d8bd4bee5a314f7cf01f3cf3cf3cf3c51ef3db096a393f34f4cf91d99e8a50bcd7cf3cf3cf3cf3cf3997cf42f56e14c3ddfcc6c5a3ba2f47ffcf3cf3cf3cf3cf2c643f3cf3cf3cf3cf3cf3cf7cf3dd5ff003cf3cf3cf3cf3cf3cf106fdf3cf3cf3cf3cf3cf3cf4bb3cf3cf3cf3cf3cf3cf3cf3cf3e4b4f3ef3cf3cf3cec581cf3cf3cf3cf3cf3cf3cf3cf3cf3c72cd416040575ebebcf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf1c71cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cf3cffc4002a11010002010107040202030000000000000100112131102030415161714081a1f091b150d160c1e1ffda0008010211013f10fe3005acd60fee0b46fda76dfc417afe27484d1a7dfd3a816cc7197b4c5e08a5a5de14d26a27ee269ef10bbbbd1e0f5e88a658e8711db54ce6a1d65d9b38ea0b6237f962aade3db998463a38a014a08ae97ede8802524d300f9e265ac1f3e9002524b8726bc2c8797e0f4c4e46f49e030e5443acfa7e903a702e4f23ea1c86a41379ef122d08e8f37d4ea3e4deb9ae78f55e48fdef66f73605f064924928e957b817c192492414455ec1a6e77143771bd0363a10604a4b9d920002b9c7ac8f246e88315af39d9208432c1afcee0b24d4356b3b243a2400027382b47c260cdb427649d922a35b9dbe31baef6815eb41eb170d3b06ac501a7f08aae622a273c3d08daf33b82cfb93962878c4b36ab4763d7445cafd096e6dd9d3c7e6670d0c1b5dfbddd3b44564c613af39aeabb314d43ef0e651ef0ca13c471ae7ab1625b33f36e0bf2915c42afb0c736ef4748e6133c3f986b910ccff004a2f4b1d0d373f6eefe05bc1738a738abb7e5ee7cf27cdda23467722aebbd507adeed1d61c3f37cee7661279d53c3f116ed674bc2cc703560f4ec1b834caae9c9d6256382827360051bbde1258ae051e820dabc5cc6a853ba427fd46140e7acf073dd0dfbd1a65c142dd4ad447ccebd7467789a2613a91d598a5a3a116f834abab9dfd0353244ae1f7a29d5e1b11c8cb02b07031165f0ee11003565c721ab129d243e76c454c0438c9d8262d55b0d3c68816d4a934c0a76b113508821ba2f6a2a2067d5af059693196d9214be7f6a356cc63c42a35dfde514ac3d2105d7a46bb2fef68116899ed3bff00bed0b16e7af79dff00df6844a018ef3407f7da59d46185179110186f3f6a356dc67c414daecd02f1fdf0eb8e13463f3cec18e24aa2a549e51111571c8172fa1ca3456c0957177b152344b1716e951cc1a4557cdb8e905d951cc4e50f980051c4a8e09a3286fa0254613a758000c71a9cd92f327c8895c5a11729b3fc0f4590aa7a933d83b44d5c17a998ba9ec4a4347a5d2266bd481d06724bf7d9048d7a89ff001664aafcc02851fe59ffc4002711010002010304020202030000000000000100113121415110203061407191a1508160d1f0ffda0008010111013f10fe304b44c22836d3da44f8838c61f8e1735074273681d0aee419968de5f98ce8f87ab60e6634d79f200a66a194a00af382a884737102b1e70a847b939f2a2a209dcf84676222d8f19086f3f10cec47f4b8f17051f198a8816de0411bc20183e3e80cefe0ac57f5f2005315bb8c02188dbe4e11f5dd45ebe5581dda6f5fbba4f7cf74f74f7749ee9777bedf74f7f49eee93ddd66469df44b25a7b76d01e7a611e29b19ef615b6b855246196c12d81b4f7b19a5d26d763a53f0b67bd9ef62174768896c55af4659ef67bd83b11a75abb615d40b2b5997857d35611cb0815d036c2cb007763a4f519c4a09c3b9d02d37016ea19428e9cc1665f3bf535fd3c203e807f5395fb2711271dfe26ed7ee198a382500a27eb763afaa1a114a68f24c616407213feea2b299bad10fd33cf662faed567ba89595d7f4bb3f53b2513d5003b9daedb1707c7fa076581c92e1e3b87beda172f10d5bb823729d5edb9c8c41f09bada2b6fb68206cbf05b05b356bf6c436c7b5c97fdc2b42fdbc3f6eefa9bc9e13685cb1687f539c1c93d6c7032ce24704d483595e1d20c1df96c307c74e20063c77cefb4cf83940edb6b6348816c0182580d22b2c8e82ce3a6fdae7a3e4d4cc5a96a5647180800186535b3a755a2e7d018f08b1088ea7468c0b55ac5bb9202e2512a25454a74a6f49e9c693b189e9c0bd8ef360caad84722a21c9a3304b58a69ae9a3f97c76b310c269d4c20e5b9707304c6d0d9414a86c387a273eb55d0c4730595028301def2a86d0c02e1be8677a296df25d8c4b22f821bd62aadf35f94da060df94cb289b027c2d2724d19698238f0856aa19a0fee2d6afe2e4150185c460905de7be23bc06159c7fccdc6bea216bfe59fffc4002c10010001020404060301010101000000000111002131415161718191f01030a1b1c1d1204050e1f17080ffda0008010000013f10ff00c65996992fead484aefae5756d37bc507769eda7c3d4cfa93e8ea0f9c4c749a5612ee20a4040ccdd267fa4a02ac0560a159e68dc1cd28d3a443ef27a94ba976703d41d6b82acc3d4c74a77a8dee8af4cb07dd157389f5286cab63f67822461cafb2b00becbef5ec5cf81429db88fd969d985d6f4c950e1bc020f202f5a62437a527125a39f56ee4d070691244fe5ca8c928cf005de94c54f7e0deef2a7176967b181e8d44aee630757eaa0960cc4fd68008000c8f36526ae2927521a9557a3275b27ad291265bb71767994a8cacdaf8bb2f06972f8bd9f9aef124acbf8d2ca09e93e43760de938db8757f024d69e9692c9775ff684223beeb972ae34c65fa0b6b43194d192fa240e65498252b81db04f4a119fed136c4f39a15486acdb2e49e5fc30593768e466bb17a5279c5bd13d4f0a6488c54eaae1ce5a13abf1711c7f61ee9b8c3839530b4a91308ecf7c6968ecad9717dd7de8864c86174c41fe032e7b631d5187ab86351a25442034eedda169439a5c34e557ceadfaf8d4784092864870688743f34c24e32561a604e1b65c5b3c9cbf740faa8c00c55c8a4b2e4ad98d0756918d304c8836f3aaf8eba5184680200fde423091acf4938781a3e9c2a799a2978d9ec6265a54bd14321fb5275e2d83e5db3ac0c586d066e46d819ce5086c5e16e1fbfe04c571ab50016cbf0752af0045b0d7c9f7c1dadb77d33419269faf815354a17a1aae4675779496c35f5f6c0de3e42bc5f66c6dfc4692a2e38ba945e6825581ec271c4dcc4dad8bf18193ff007f5950130a0a2c2ca6600c38b1d260dc94a5772ebeb6ac6ffc3c7c27e037062b5296bc24f1f1864e4ea378cdbc1e28324fd40e065440066d0555049939f6d36bbb0482e21c5d381fc808626e05dea5329380ee646f9eb71d808858b260fe9a38725e2e9eda6b50b10de72e9c75ac3f8f8f8298015f85d9a94812ac570d931d1be6fe93d023719b9ec4f54de9ace29965ce538dfd787f2f6a9bb52d0e6713db8544483095cec6e4c1e4ebfa02e956e414c4adc4c26c37f9568cd1c06007f2cb5011848d3c5cb3bbb431c1a75f1aa6f849b8c9e7cca82ed8b8fcee3a28c831ad1c8e5f759ff36058574c860d29a8872363d1cde723e44b3c4f6e6294bb32b381274c7a7f3f2a9de6a184860f7a1428b086588f321e7b79a82601b2567254b03892ccd63f5cbf9ed9a27e58b6727937a61315ad85bf9b3c8ab797860959b058375b73a69afdf2594395de5fd0c68a67d4a0a426238c1e95665689958f5126c9e5352da420e48f1835bc61ea181d23fa47032f915cfaa48e8635cb01e292e6f2e1844c79620e2cf9d004400300acbfa334cb45c0cec1e88a36c0244ccf24a7a3746303a8a6bbe2139b72fa7aff004f2acea2709b9edeb57d2df536a78c9cfc95858b0d4e5f5564890b573b1e81fd4b4728f885cf6a66dae245df4f271b8163472fa1500f0178047e36ab55aad56ab55aad56ab55aad56ab55aad53587936ab55aad56ab55aad56ab55aad56ab55aad587e2924372bae10c423d7c933d0ca6469c8fc26cc026905303857705770577057705770577057707dd770577057705770577057705770577054a068058cf9d2c9e44d9804d20a6070aef8fbaee0aee0aee0aee0aee0aee0fbaee0aee0aee0aee0fbaee0aee0aee0aee0ab47b1f746d20d1c4127f1f8994127d9f219a804ae85092dc275ff004564fe0c362a0a37e64142d219f12ac66f6675dcdf35dcdf3573baeb418dd040df1ca90b30581b57fc6d6d3a6b6bd346cc38b08e3857737cd7737cd7737cd5acdeece858c0a720e756f6172b2fcdabb88f6ac53768aa11321275aee6f9aee6f9aee6f9aee6f9a7a4c10a42e63ed5ff00335b5e9adaf4d0291cac28c10412044f1aee6f9aee6f9aee6f9aee6f9ab61bb60662270e25773d1f8c702dd119a488dcfc45fce34c44e4da9bfda0bf54e3f8b59a7d2f542b955b5ab6be012262ae1261f273a6f9373b2b52892ae985d6d4148ce0a6aae4b103ee8592de063300d8f88a8830ab55b5ab6b5694806ad9ed2f2a706494475be5e4e24d9adb0d0712708193de2a476512db13d1f4ab6b56d6adad5b5a66108b8b5b834312589247ea8793a6a1de00be1401560095520c2a48603a72ab6b56d6adad5b5ac190106ab8748acd405e447e3ba81d4ff2b38a5fcd0c0126e780f9a86e2fe90fdd647e27d39219260fc72a160106e7c1f03c46e97c03825e912569fe0ac80d97fbd300af09d0f99a2460400401e314a05501756a616dce09c5e1f0561682518b2579aad6544af4f22597c2b7150fa26fa9da2a68e6b2593214288520d92b0f1402208e234d2e17957727e22aee21bffba424ad0bdd341c3a21775cda5f1c1a8297067641532ca6431773a63d2934fc665b5d7a27cd629d965dedbafe60c0b369b9fcd319451e87dd647e2620f2332afb4366e268d0f911dd63bacff0b784352f8944992510150c27c93a11a7bd462030edd0df56a2b1bc3a7faa724985efc1f998d49a530f542b01e22fc0ff006b0c42fe4d1dbda9aa70112e6da9b74df051023f9e3f83293965bbf46f5349b141c01516c706ab9aef5107e246ce10752919d90036b79211c65f894099e012252254199c07167de34b08b8999f673eb4003bdf7d3c9a110444704f0b54f870a813b5028775a9b1f2f77a1500b65e835f56a1e4e595f806454d127cced74a643a5d03f3c8a70fd88541ae0e81f74542e2cb6b38ea6d4d173250b665cf95403b745e589eb505ae7031c74f09fc2c654371a12f4c39d366850425f0303d6a2d5526cf1b4f7ac2f800fcfd57b8f21088920dcc529aeac4a39565f94d61513964a5ce0e254eaed093a973d6ac02e76de4c4f4ac1c73b662ac2b16c07debfe27da954bb2967de9011460c6eb054f98c657eaf5a7572c8b7c3acd0000040058abc518d01cf01e87d522dd9f9e4544b63d0fc50877c53d3e9e1314804491a519264c1d30a7113c097eaf5a25080633075bd5f05bc3e895ff000fed56096dcf9a1f17d949ee35912f64e9fe51517aac3abf55084a2184af36f48e756fcc007303ad2952cd37207c3f9a4ca4b32704fc54ba97d47ebcdc943526bfe3a801000191f9fad7b791d995eafdc563f658fcd2486e57fc7566e1a11e6c19a0f45f8ac8dcc71fcc2df4da38a7cd47fe3493e7cf9fcd46a1bd0fba89ba5eb7fccc4a90ee7a0f9a53b41e9f6f226a7cd8f56745be6acc60f55f2044247ab9a65fabc5a5be91f35ae64fc61e4704af40fc54f2b323887d565fab78313a98a4c245b3480f8f2013174b5009d553fab8e886eeb3ec943870872fcca51094c71462a5fca3c98fd62872af1904f4507c87930328dc4f43d2b54fa81fa7bd426263be873a05a50d94e477a56fe49074a11c51ee518038198fea3192012ba511191d9c25b3d7d3e4c28cb879df5572a9619572627bfa7e982214a98028ec04005deaf7bd4622d876454da3c9b6124473733834f649c2b35276f6a1104647f4b2a8c18e66b3d95ac699d6c661c51d3c965887ae6481e4c344cb3c5e4ac9d3f453ad60306af00a7635b626e5d8509201b66c6def572b1f26231a75032f3636bbefd93b571ec3a9b50fcc586e71313f472a8dec49fa14970506972f8784c72f262f4a68de195bd1d452020c4331fd049119d66e81132e78fbd61b90029bb952614b88746e7ad45938a2b9c4c4f285e674ae45eaf9ba3eb7dd2915b0120db5e53596919bc05c53a7e95a718a726ff503d7cbbe0c8817633a1975a961373d9cb956ff00a31432926fbe9e951f91b898be3d68c8532090d9cfd6a096b2bce8f98a0b816491f1e14ec73110152a21e0757e0a663f1811c5cbad325dd9c638b81eb44899df7ae1cbf4cede0e7be897956338a774217ac393e5ee43c4087de96241d92049e9b67835b7e8acd5eb853d4dc44942a8d91ec37f5a4e2f7601e27f9442db144f384aecef9ac303853c92bed41d9334c9cb2f4a89116761d0f99a3e0b804072f018fd317d3439808f63ad46e23071398979f98e381c407767449f2e9ccf990ff3f2a4e45b073381d68ee5cea37219e2f9a11e53509c137184e15acbc603a3b323c1fe7c5e28f2003324472c3ad5d38c2635d75c360a5f356ca8319b6e63d1da8c8481a8e47e1ff7cbc2f5851e18d61e11e1b5247e1b7884fe5878452cd6fe412930ddf5e5f5520b50e63d998375d3cf70243240d9134a8b14d53676edd4c3a39d4d1250f92e66138126f11b6b4de14e359dcf7a2637a1540c45f333b1a7836a32b1cf4e11b3ad6fd08989269a2cd04e5e2166ca36d7c49773042132c630d0c051524b08ce0d7c586a013012a610e95abc2c64c1629cce30ca6e1a1ad3e028c36564597474a87220b90ba63cab3a2d0a3334bc491788df5fc87d1d4600504cb65858dbbbfca145c449191aef9afe86230b8c2f8707fca975265adba3f4d17ac3f1247710c9c969827b4e346604890b2f79c289fb4eb51f69eb4ade202958c89a0e7182196384d36e3b4dead5fb4de92421608618c51180910460debb93e6adcf69c690636085d317c2bb13e6bb13e69a1760a2dcc869448f4031064b5d89f35d89f3446892218b9956fb4eb5d89f34b01d5764d31916241b9ad5b7b4e7427c3f6513e9341411b52aba48c9764b599da71aee4f9a6112440596bce15da9f344d9251226cfe02125062b9035fba02c011a639076cf79dbf49245b717231350ea5b20ac2c9b8e065c4f6fc81a728c2d5831a21aa27b51c073789db5a8445442a06713a684c6f43c528825333b9a5450cea4b4473485bb6a23775a39e588944934855270a29038863e6ca76d6a1510a82139827199631968d5283c46119c9ad42a215184be491c54c25d2833550a809ca0b141096217cdc3535a043550ca88b4d1308b2eae9528f0ac27174c676abaaa185409de9e238bc4efad00465564d358898dbc4a3505a32fcb4a9f06f27c5d7db5d3f51fd44bc5feb1e8ecda2507669d4f93c31fc71c0e2ac66f359d34ff001e02558a15470a271ac5ac1a7d89e2118529c048e23078b29cc30ba62fe2b08b004adca4d305021883c41dc252932d18f8050095514cdf00b02c9e22134d24421a462c90425de2c383cab08bcf8c54a3054d57576a4322c64f2eccfa1b01302008034fd41c0a812071134a1e2ee45d7cdaac9783bc4184e3ecdbdbf2629bf8daa2a2ad45153f818451e38dea68f010ac686b16b0f02d4278a8402d375fadeb0d9d6ffa7db1d2404501807eb389f1f20e2255dc8a4a5dcb5641e4ee0942be4dff004ae1587f073bd5ce80b4faba15323053167a9e871b3075e3d83e5df3fd81c08812071134a67d93ab9daaecc4dcc08c392d8e2d1f4addfe092bc1b9f17576ac6290236746ee9a90fcd0c05447ed32919710ea7fc1ce2ed5a4a951d6c4eca0ae182776fdd89a3a07294050a718ae59c863f3c2a2cb14321bacdffad281000800803f74a43516fb3399b3e98d232a5b927907371e4b46c36b42b9d9f87d7f6ca2d6060b87165ef51f8c51e6f376bb40e5b0224d8e4f5d5fe003834720e223894ab34aab3eec786e70a62bb830935c24e12507256caf0c9ae35c3f4ede1e9482172dc5cb2e74098b2285ba6074ab928c163c0fdbaa8b804201b07f0f10264c875331dca199f622fa7c29ce8b1a1824703c7929518a6caf3a3e628560492479fe926005d5602a620bba7c3deafa59da0df271b539a0609e89ca7895ac6a1e6a5d717f8e677e034e4d342f7cc78993931b53810bcf4f170bd1a4581e90f1ff00950671b075268be4e0bd2a37ab55b5f0b55aa1abd5eada526f47cf05bdd53814cac756288bd20c5bc0ff00b4a3fa798c63e948895757976bb8c9c28d1ae502eac62eff00cb6acca60061c170e55a7b2c7384fd129e80170f4843da8db75b40bc8afa571137d4143f5a8fba47a607e0a23b17646bb82a05dbbc1f347f5c07c34f9e767d294897c0fb4ae3da84f314f6a01728c03c4b3d69c1ae32ce5753039e100b8e279be16fe967cfde2561ce7b1054601d9ba1e0e8184dbb9d1a6292f36fe6a10b2e1f1c7ff0cfffd9, 23, 'Prk. 9 Tambacan Iligan City, Philippines', 'single', 'juliver.galleto@megamitch.com', '2016-06-20 07:17:49', '2016-06-19 23:20:28'),
('gg', 'gg', NULL, 18, 'gg', 'single', 'gg@yahoo.com', '2016-06-30 20:55:40', '2016-06-30 20:55:40'),
('hh', 'hh', NULL, 18, 'hh', 'single', 'hh@yahee.com', '2016-06-30 20:46:47', '2016-06-30 20:46:47'),
('kj', 'kj', NULL, 18, 'kj', 'single', 'kj@yahee.com', '2016-06-30 20:56:52', '2016-06-30 20:56:52'),
('kk', 'kk', NULL, 18, 'kk', 'single', 'kk@yahee.com', '2016-06-30 20:55:01', '2016-06-30 20:55:01'),
('ss', 'ss', NULL, 18, 'ss', 'single', 'ss@yahee.com', '2016-06-30 20:45:28', '2016-06-30 20:45:28'),
('test-inventory', 'Test Inventory', NULL, 18, 'test-inventory', 'single', 'test-inventory@yahoo.com', '2016-10-10 01:59:52', '2016-10-10 01:59:52'),
('test-user', 'Test User', NULL, 18, 'test-user', 'single', 'test-user@yahee.com', '2016-10-10 01:33:47', '2016-10-10 01:33:47');
INSERT INTO `profiles` (`username`, `fullname`, `img`, `age`, `address`, `marital_status`, `email`, `created_at`, `updated_at`) VALUES
('test-user2', 'test-user2', 0x89504e470d0a1a0a0000000d49484452000000960000009608060000003c0171e20000000473424954080808087c0864880000200049444154789ced7d7998654595e7ef44dcfb3281621717c4051050691b158ba52ab31caab20a6d7169456a741c994f94ee46accc2a10b7eea199465b052a330b6cd46f465b67dc706bc1052a330ba8ca2a0ac4cf76da1dc6719d56517181aaca776fc4993fdebb37e3c63d71df7b592fab3293f7fbbecc7b5fac27227e71ce89b81bd0430f3df4d0430f3df4d0430f3df4d0430f3df4d0430f3df4d0430f3df4d0c302071d6c01161aaedbbae2cf68865352a9b53a3ef688236acf37b61969d93cba2f99b68612ad2c3151f4d675bbbe7d50055ea0784c12eb1fbf3c7074ff61fa4865cd2003cf26d0b3c0fc5426b271ac8e07c3320030faa29a7a1c73231f5b86b5fcef205822800d9431f6d70c3001df04f04bb266a752fddf7ee88fbffdc3357ff9addf1fc4661e543c668835ba6de52b23e8d53aa693d2d49e41a48ed7118188600d831b5482b58cd96e61300368120b0410016eb7916afc529a1a7104a4750b66fc5c47f483a46e7e0cd88991a15d9f39404d5d1058b2c41a9d38fb3f28aabd58693ad3581eacc5bac6009819d636b44f4e18a0dc1319bffc6316e7e6632f19018a08a41b09880063cc5e907a0096ef31d64e6e1c9afe5cf75bbd70b0a48875c3e4aae7458a2f00f3ab88e844a5d51144049358344ddb2c080d03464e20bb7128f68e14e793cd4fefa421cab41ac1a6bc8f611f82c56d9671ebc3d16f775e73de771fe942172c182c09626dde7ace0b7554bb4a0183baa60fb7a985b54d33e6a26af0674fc2e429e5f1504aef2474c2090029828e08266130d96f5b63bf3032b4f3ea0e9bbe60b16889f5be2f1d7b78ffb2676d205297f41d129d98d42dacb1600b598b48a62d83d40b55a6cf4fd32ef9a4b46868b2b8a650df9726d6e22b0cfec46237958b8e58d76d3debc49a8a2f27a55fa7b57abc6dacd40010c02c6b1b61300b90e2336789d939b6104e22a0e08f4924640614014a2b58630c33be01a61b86d76ebfa545ad0b128b8a58e35303ef02d16551a48fb7262314c244ea44d3b4d26e9d98c7906f56f5db919300a858c1a69c02f6ded426d76e1ada7dbbd4270b158b8258639383eb015c13f7e9d36ccab0860303e92cd1dc70dff12ec4351df82ac73d439503dfc279afcc0fcc6a45b7290074a4a03590d4cd24a77b370eafbb7f516cc82e68628d6d1b381b4c5747917a31331a846a3590feef3cdcdd171006310b779d6df8655484bb0869aed00ab22aac598e8e148cb129337ff6d147eb1bdff5b27b7f25d4bc60a00fb600218c4e0c8e28a20f44917eae499d151e39c756a60e5ebc44cafc18d0761428abd5ef923c544e1f2266334c6982d2041d2910015a93aaf5e9e79052eb5f72f1d3e2afedf9c96e7c575c9f1e742c488d353e3570471447ebac699a3d20ac21aa4c492b2d912564bf8ed07e4205aa647365f267842b3f184a11e23e05664652373f06e3411de907e12801a5105b66b36f4f7ae315e7effc5667821e182c28628d4ead7cb382be368ad55169d2bcf2dbc96624bc3004d2851c7578f185a3b7ea94ca865006d0f4e35024b0271351735f2b350f5ac6c746d6ecb8168b180b8658e353833783e80d8aa896aff67cb44b8c50be5661525cabad8a2ab4f2fb9a47a50816bc17866fb67f52ffb0f12fef5ef417afa3832d00008c4eaefce75a7f747132631a5b08216759d22692b6f1cf7d5485bbfe110b71ee79e52aaff92fb4b7d6848e08d6f22f91a4970cafdbf5d580648b0e079558efbef5ec271cbeac7657ad3f7ae6cc5e534e5065f2da5da549e6aa1d0d2491aad54a117e3a6e9841b0d80e5d53b0a9f9c9de197bfedb5ebceb076d48b56870d05685374cac7cd921fdf1e79452a724f5cc9f6af6be4f1e1712815af96092860b99c60249a89c27241b09f287cc74d3fcb1e59f2596d7bef5fc9d3f145abaa871507cacb18973cf271d7f3ad28e931e32172113541506272e433b9aab6abfca97d14f2fd8dee06e0211189c92c5591b86b67f5348b2e8a10e7485374e9c7bbed2f1a7b4a206a97c3f09ce6f498b64f14071e442da4d88e3bc4e92fd2d49e34926d83de70a5271f148c460cbef59aaa4020eb0c6da3c31f872ade9135aa9c34c6a651fc5972cb0929a4dc461ad55e57f55e569b592f3aaefa4cea8a690d4d3bb4686a6cf135abd6470c09cf79b26579c6b15fd2f52749831b6ac1142280c1021bf318f81c235be50de56e56668654a43654aa40aa42505a429ff4959fc7d85644b0207c4145e7dcbb39719e89b75a497d9944ba6a180e0564073e9dececaccfded2ffffdf82a6de587b3f3e7c6f95a2cb05d11c50a80fdca8675d3770bb52c29ccbb29dcb2e3b9c77172c48e3856a725755be16c3b7b3e40fb8eb740b4ec16aa429e76170355e9fd78f7d6e62a138aa63c8ab0e1bcbbbbdae7effec2994f3aecf043af8962baa0efd0e8498d3b3f08c93e0330a68d315f1c1e9adedccd3adbc1bc6b2c3b73f847b4a2d3f22d85d00ace65523b4eb9443c6fb55f8ca7cef6a3b2045544f76fb791646c6a301529b0b19f165a33678c6d1dd870e431cbee8f6bea4dccf4a43d7f4ab1ef51837d8fa63086018501a5f50d5bb6adfad1d8c4e0e5ddacbb15e6955863530357f41d125d60f2bd4f8125ceca8c1481d078e020b75cbea911d12c3764deb8794215e4f2c325132799c190e974ca23108cb17fb4a9d9d2aa25ed626cebc03b95a6cd008e4f53e1623d0093366e86544a9da82275e3d8c4e047ba557f2bcc9b291c9b3cf702a5e25b0110bb83e56815528ddb42a29890d42d8ce1949829532e0c507f7fa4d836eec532cef37f6def2f49e6ae137328d511d25285b266136a4d48adb96764f5f48a961dd706466f5ff112dd17ff0b01517ed3635ebf23a027675fbfc6be7de977962587ae7ae38beef85d376409615e56859bbf7cce9341fa66524436751a4e8d1d67a509696af76a85ef27f5f4419be26ba9c5cf7eaf7fb7fbc8fa113500984923ee3f2c3972662fce01e179609cae889e4b1a4f545ae902c9806287badb10708280b09691e2fcdf55db0bf0c2dd6d102268a54703b5768ca83f1a252032868b11e40b549469669f4114a9d31fc59efbde3671d299ef5bfba33f744ba6928cf351a83e24faa88ea2134cb6ab8e06a100c032ffc226766b6af189e1d5dba75a14f530801f03f83400dcf0958153551f9e4d86d713d190d6f438e6e6d3cb858bbd82efd3eab718de5c09f8e95ce71d4ebd4089788d76dbefdcffd1edb7b5686b5b189b1c78675cd3a7ccec35c149922f5efc8740b8611ea3589ffca4e4c977bd7feb09175db56efb03dd90cb47d74de1d8c4cacba35a74a34967cd40142bcccc9807ac4daedf3874cf87bb55d7f8e4c055207a43ad3f3acda48c34b1c55d855626cb3d0fa5f5d3909331a8ad9ad104d46a0a3333e9ffdc3834fdfa8e1a27e0e6ad2b1e5f8ff4bd8ad4d30b0f928464f0e471e39b8f9bdd35b2767e366abb4aacd1c98193a2487d93481d915dbf4d52fb759bdad18deba63fd5cdba5c8c4f9c73117474655f7fbc3c99b145471690577ea28f559ee179da922f16f665723010f729d4ebe68c91353bfef77e3613e393ab2e8dfbd5879219db7a72844cb61316d514d2c47c7878f58ebfda5fd97c74755548c0658a54cd1afb505a4f27ebf5e4af87576f3f6b3e490500c36b77df32bc7afaacfa5e73ad61fb0b1d93a3585aac18f3df1ea99c6079fba319181a4046e64b3ed00d520100119f2bde41e1ca1ada42115488492c14d1c5d7df71eeaa6ec8e7a2abc41a199abe72dfa3c9799cceac1c1e9a5e3b32b4f343dd2cbf1536acd9fe773c531f48ea76923435fc1b72b457d55681f40e071f7e7eff263eb79ee6205b63ff79aeed717175c38d5c6d525bdcf6a832f36ebcafd532f189fa221ddddc0d195dccdb76c3c1c6d8c4cad79356d7c7b13eaeb1e3eff4aa64fa7c5357b5fd50b52d8146b98a00c3fca7bd7b7ffcb4775cf0d387f7b73dd74fad5cdbafa32f18cbcb90bd46409a00e2ead7675431b8ef108d993df5770cafddf9defd9533c301bf6de6406164edce8f9bba3d2f49cce7b426288da2a900664f7c73e26b26373c644ac9f90337de9bc5f6da6e900a0062522f60c6b2729d54d69625393d52110a79ea33162ad69bc626cf5dde0d5981254c2c00d8f4a29ddf195ebde3d5499abc9b99ffa875b3477d53e176b44fa42a044818450ad6daddc343d3efdfdf3664d0119da4234770d71cba616e5b7c3983db130ca5d5714ac597744bde254dac0c1b8776fd6dbaaf3e608cbd2fae65be5733d21fa0c26cf606d2279f30504a11d2c41865cda66eb6c1265865b23b430ae4e722a14a7ea093d697ddf96b6e0faddf3c75ce93bb21ef63825800b0e92f76ffdbf09a1d67d7f799b730f303714dcd124c7280393b4171300079e5d55c0502b66e155d74f9d0ae7bbada00e263d92550619140458de49efbdb10f0ce9b69d83054a48e221bbdbb1be23e6688956164ed8e9bf6fce6d1e5a931375bcbbfc9de435a98c1d280540d12001511acb58f32f3c8c6d5dbbfd06db975a48e65f77e3471d120cb960748bea3d31e9b3294a2d77543de25bb2a6c079b6f3fe7192a8aaf20c225b53e1d17ee1268b54a6c82d07824be3e637e436cdfb66168baeb77108c4eae7a4314d1ff28cbe66ca76490364e0b79aac3e29ac6be7a72e5a635d337ec8fcc8f6962b9b861ebca77d46afa156cb13cee53645206db86633bbb793a3b0aa41a6f804913b3878dfdfc70172ed984303a313852ebd3a3a973edb592287e9aec1c288fb8574ee3da267f2ff9e68fcedcb4e9e77be72a738f581ec6a7065700f679807a2d40c792a227287237288898ed1e30ffce80a788e923ddda590fcbb4ea33514417a589a39ddad97b4316d68c0c929066b72488a014c0c6bc7ac37ebcae72413c62bf9030bc66c72e00bb007c0068be389774e356c514606595067efd96f3eff9fe8192c9321fcaec30c6f7a5fc7d2cdf49975e4652d064ecfce6862666f50a000b8f58eff9e2f2630f5dd6f74a22aa5b0b52da44c36b76fdf7f9aa6fbeb069ddeebb0fb208512d56275b7fb75d5aa186f6b52454ec81a529c382cfdb1fa1bb6a0a472756be52c77a3d59ac61c6313a22726c08989999f14366be33b5f66357acddb9bb9bf52f455cf9f1271cf6b4a79cf62d804e2edc2d0ab45c58883e1750368782ffa508c6006f1859bdfde37391bb2b1a6b6cdbcad3007d8d025e196915a796c1c44853f61b474ad3695aa9d328a5d76c991afce4b71fdc33fce1bffa46d20d3996224e38ee192730e3e4a2b96aae06db550bad76e405075f69d236e597039813b1f67b1f6bf35757be4041efa8456a3d33c549dd36565216c519d114da366fc803e8c8b85fffcd9f3de3d0dd376e3debc4fd9563a922d1badef0adbd4d50dfc19276d4435aacb47befc437f3d8c6027470ae72ef17b1c62657bc4af7a9bb94a2e39284679d447f8604ae4fd5f75ae8583f9fa3feef8d4e0d3e7f7f6459aa88233ba4b5427e1706014dbfa2e878fbef38f577e07db2f926d023a2b58c2856c78ddebee22573917bcec41afbdae09f2b156dd15a1dd6b886c5b38d731be237ceb3ef6962418afab4a2dbb74cae9af30c59aa20ad28f22f3e03c2b64260a394204f74c90416ea6868488ad4bab9c83d6762a93efa27add5f169e149112e1cd0942f0ff31be29847add571163c76d3e49a63e72ad39244ca0385a771a42d03ff3cb4720450ba03353b2fad2a19cc8cb84f9f3217b1e744acb1c9817746b15a99a6b6b0c7562294345bfcf8e6799a58d4faf4f30dd597cceb12bb01021e5ffa3e903f977d9f89509ec4f958f8eac949e76934cb8049f80557dff2ec633a957b4ec422c29bb2a7705c41c4dfbe59ccc2805995db4452b7d0913e6b6c726557aeb02f0928342e3e67f049e313c945c8d772134844cda29a7ed631471ffdeccec5ee10a393039be2bee8e9f94b6845b2a0dca042e3c96968d17c5ac320a52fbb7e72a0e3c62c4544913ada3a9708836e467664e1b7e45f01c5054160eb820860a55ed6a9dc1d132b8ef5c5d6dd9f9208145aeee68d0e389a8d4d54c4b13e2a026eec54b6a586d1ad2b569b841f5708f4b50e0385775248be939bd62da32a2e9bef8df17a42a7b27744ac2d770efe276bf839a6f4be002fa1b4b31bda57111cc7a46ea0b45a3d3e39705527f22d39301f01a23e57abb3dba7c0ecf6439e072572ccf6bfb717c6429ebcccc66f9332a2483fb753d13bd358162fd7917baddf11c26f8c641adda30f6f76355e004b1b3a926f89a17648ed4415517fdedd947591b7fd50d8ce215933650414b71da838f19d3c0cc01a7bf40d93cb4fed44f68e88c5e0e5859bcd7c844c6321bdd029feec42c3d78a22f5e4f1a955efea44c6a50463f8a9796f159cecc0f6831f578502213d8d5748c3504a1d42a93eaabd821b689b58a313e73c0ba027b1ebf07148fd405eb9b8821350da2df6ca6bbeebe34a08ddf75800839fcfee973afc2d9c0c6e98efeb961c7c9acd23a5c9c7aaa11e9901d2f43815d55ed089ec6d134b217e89d2aaafb8c1cb02c30541dd38374f81a4cd38c7d6b365f4f5eba3c6a70617dded365d81a553acb48755b2022812cddf42c8e2dd8553c8912f6945022c8361d34e446f9b5806f654e5daef4c285f0e37d25fc148b38ebd38cff94cea1644f48a1b27563da75d5997026edc7ad689201c95bf024c5ab5855675d2d6821f97e5612f7d098d6f4592a28e1e0b6b9b5871a44ec9cd6026145076fc5ca7c00f0ff96585f29c2335b4565453c75885c794239f507caed2ce8a30731b7c5397415a99e7fdefe4f5cb008a7179b9b32b48a50991562777227ffba650295d5aae6612f98df2572a25a1516e94544613699d41840b377ff5ccc78cd6d24c2b085005d3242e86502242199e731e1a07b86145d632b3f015ad30da378596cf10df3b951d830253317d3683fcd923f904cd9ee4c6cae428dd77d8f5edcabbd8c15a3dab6cee3ccd434da6652bbb90d6caf248be2f501ec7421dee8ff6d136b1d8e2f0d24bc9fc554821837752b59201ca0d6d2e75b38ba6d65a288d759b6f5d7e7abb322f662885e714164aeec22737850e13f25b968449ebc2d77afe8a531aa346b11db1ab6d6211b115191f54a5de7981385c9e4121ff8b67b31008d1b243e7fce4c862c1966dabd6d5faf471a5075481b27b91c1bdf1cfcd2339fa594192afe6e76d6e39b0c5b24edad0d9ce7b767bacd438ffbc551ac9ff725b2f10d6a40ca5f1ccb1c9c1257df783b5f6a206a98455b8af6124075e8a9388988587c8daac9f2d8319f3b7f35eb881df57a9a14615668db08274d34bcfbf15ea07d8025ad31bc7b69e7d7647b22f125cfcd1a7f52badcf3629cff677bb8b1e6972fb16c32fc7276b415b3512abc6db11bfde493b3abca4d3fc17f8ce9f7f776cd907e37203ddb4d22cf31c506b01a5d5e349f52dc9bb1f963ff5e983043ebdf0c175894092cfea6f49f893db3f2f69292a8e59961e040677f4445747c4a2bc42c189c76cbb44f5ec86fbea5752f7ee7981708da77c7444cbc7a7565dd789fc8b0196cc7aa555516787b44d1696f7219709e796e1125234a992b600c28586d1a129740a971cbe3c9d102e39a0be398517efe775cab51620f0c6cd132b5ede511b1630aefbf89f1f06a621ebdee32e4d461fbe19f3f3418893568b3ef1e0a6932a0ea37d6231cda6ad5a4d84ea27144da8d448761293736cd695fb9b4c60cb505ae948471f1cbbf5ec8e6f445b88d0271c711169f594d9bb7349264076144940e5747e7ec9e528d445def810d0e1c3cded134be11785cfd5480e9fef2c9666095777943f3bb24f9734cb99ddaa6994630ca0b47aa25a56dbf9feafaee8e892c342444ceaede48e89fb2d44e9e893cb376779df53318da8b1dc851317eab0a985496c476fd4699b585ad1ffcd7596e4604b0869257707b9d05924779e5fa753b9492d74a44feeef575dfb94cac1c0e6db57be56c7fa54e37f1eaee4487bf01d788184ec3f99239a410aa6697cee8f3bfaa053fb97748c8dcb24f27c2e9f70d9d1f799e0745e41b355d871bf33f2f209696211c5d1ead1a9959f69a72d0b0d9b6f39e790a84f5f5dfa3800506a777e6bb2dff7a225a059abe66bb9d2c2a95988300426b5c632cd0fb1ace5fba974db2b57cf2617becfe4c7492b96100ae91a6a3b99b1e8efaf5d343e39d095af6c1d48a863e2f7c6b13ad5a6ce84738f0e7277c47f240c102c436095177259dc8f2934ff8800a5e9776cd3ffd3519bda4ec9788421f8482578ce63213ce03364d1d26ad2fded3ba905ff8e50df67a0227dc1d8e4c07ddd7aadf47c636c72703d812e4dea1ea95cd3549868012b9193c3eb7fc99cfada0bde6f672c8808d6f02348f18b4edad53eb1c8decf8cb4207441b00ab3980586563455eadf9f6179f912f31af7cac7b5687944f1e4755b573cbe9da61d4c10e1bd4a533f4bed09f8958d8c081c2bfc29c90773fb56f29d092045bfdf74c1eef9219679a47e9fb59c50702f2b53a32cf84e7e5a07fe6a324b1b9a61f0d20b5a2ead5b68ad9fd9a7f50f6f985cf1aa369a775030363530a523dd7cf8978a6d7521ade844dfb50949b3fbe5f969fd74cdb2b526a4a9e9f81dab6d13eb8a57dcff3362fc96fc1544e8b7e35ce7e1c0eceacf55ed5ec7b0dfc1d24c93ceb3ba297b8b8d3a32a2e8739b270716dc3df3374e0d4ec6b5a8f1352f20f7150b6fecf17d4f370c803871fdd5b5aff99cf28bcf28327cb2321ad709b5561d7f0ca1b39d7785fb1b5f5fe0eac6b97b22e4370c285c59774d243bd943b3ace0a87a8b892c7333bf350c22a016eb4bc62757dd3b76c70bd776d4de79c28d53835b55a4d6a4f526a90a6d105416e5ff667ffb24cbb518a1f489bc80434f7e9f7a47a58064c6d4c1e964fbad6be6ed2c394fe515174c95e00ff8b34df2a17c55eeabf86ce6f9eade9d8d7ed99ea9606edc6ea36375968af98be393033775d6e6ee626c72e04e15e9b569b602f46567e1dc85bf07e8bb11ae0fe64f50c99f92fa36cf4760e077bffdcdef3bfe8299af172a31ba6dd5ea48e18b6c7144e1d53a3e428e781657e57f95b49f9056f2bb5aa66f7c7535ee574866d29f58e00323ab771cb08bd89b27565e14118deb9a7e625ae75ca682c6f651d56e389ac9ef0b3fbd74cc669d5fbe935fc78434e5cf8facd97e61a7eded88580070d3f6177e8f2d9e297e1a040834222c7c218f2f51c89185972658a7c7bae6a161ce010bfe11a7f6c32343d3ef4787b7deb68bf77d69e5f1fdcbd4d5045c4c4af5e56f3eaeea2faf2f4ae31f224316e6978b8af47e5e275f54534866cc5523439d4fc08edf3693d4cdbd5acf9a28961ae09bba2a94de94e2a8fa423a14c37395ed542cf8139cf983d9aaabb12f036b190a7452dc17bd77cbb6c11fdeb86dd5d88726ce3cb26507b40f3db66df09a430ed7f746b1ba14a4fa6cf69c4bc92f741ce92c3cd72ac56e2934b78a542004ef7f174d2c0aa422104c620cd9fabfb4dd62071d6bac2d770e5c18c5d167937db6da24f9359434899730a4f6ab3a432a3b94b730738b668434218a0826b5ccc0bf1a367792b5778e0cddf365a1d64adc70c78a57d56ad18560bc44c7ea709336482ccb21c82a8557b52954865f5f95b692cc6044b06c7fb8e1bc1da7b5d36e1f1dbfe7ddda64479aa88749d1d1ec5e02c84e2453566a14cf6a1b69dfabc22cc02b2678ee6bd0c20070a12eb68c64864104224dcf8b55f43c686c1c9f1a7c8408bf20a2ef18c33f20b60f33cdde84470466e69ad26a39984f60d0695ad3e1e0c67b271adfa2f6da21416aafdbe6cc1fcb278373eefb4d28b6add41f121145ab43b0e9dc3f79d2b1c60280f16d839f8db4ba30755f17d9aec609d6e86490be0e5fd5f1c159eb7574484ebf0d9939a0c657be946a9a242a36839b0919687c29cc32b8f09042a07e5f76a10b4a69abda9fcb4fc549e3b74b2ad345939ccdef89ece1347df5f0ba5d737a27ecdcbe4c61f04144746170761404f5ce254dc4cd08728e3e59c82b27037b4729321b5f9279173a3237de5b60d32aa27b15e7e93c52f9da589a689d6835b18f042d26696f04ca40a33d4a132cf38373251530c797db0eafdd3195a6e6a74a53b1a3fccecb200e3ea1f024af540ebcb218725904b90c61cc1b79a93c88d2004b26a3aa6e374c225c9657ca5361be2a1f52f16516351295d385cc3335fc2b05deaf8755e6fc9e776bf98bcaef4c5f13b971d92cce07891b3d966daefa1d1ed244a2c913eaad9427a081d8cf1bb0db12c15cd982a61928add4fc8924909a0a655131de972924ab0f5f0964c512214df8e7f599e4ae40ceb630776219fea831fc90a290e41054bee37fb8904ca948cc1671d220f9249566aa44ea8279f6caf0eb963458a981595a97d4343bd902daa374ee4ec4529cd7befc9cab27410606a298608c9ddef4a2dd0f0a12b58d3913eb8af3777e8b99ef53fee7382495efa2cae710069efd875cdd72a4f242f5f8f0e239480e2a1c2adb10922b0b243435569350ec8daca4c9500ce34c6b496df22759ab387f3235c54af7a6d708a57784fdfa489361f3be34b5f5c2c54c9f207e27492648f215f2e45c1e388934d251eac8ece89b00b7d282ac5c0e83772e698f609b328670b9bfdc3fb70d4ed98d0bf48ee0a5fef51a1432dbbe48d4b845a6be2fdd71e54bf7ffebb1fb45ac4d43bb76c0f21d3a560501f37317854ea4f0608ba604c54e6eebf946c7c44832f984164d489686ca24f03553c82390349aa4d5ab340c50264c36e14a0472260237232419fd094c80b59c32683cd0928eb0dfdf2b243d7319c020573d171a4cc2007aadf206bcfcfa1eaf5ce76d354c7e3a9af56532d742d2a2be469590af1ed9191c8f4194a5a3723979f901d63984e242a05046de182a6690885ad85709f4b547661d293061d7c8d08ecfcbc27686fd26d686f3eefb391bfe928ebd8ecd1be9044a7e89a03928b420104c0e9588e1fa33c877340af0e5700b7465cfb4829bc77d71893be86eda929c5cacd39701283e242169f35c3687e4219782bc347ebb3c378108b0c6d6adb1a3e812f69b5800905afa8031fc0829c1c401e5d9e5fb15a5992e74ae3f2870cefdce72f308daaf70c1b759064bbbfd6e3e3fdcaf2baf93ca61de408a26556a4ba8fdf0e27c0813b0ea5c470ad6f2dd1b87a6e774c15942578835b2e6ee09b6e693718d8a1d0184fda55083dd78a9834266324fe3980ac99781ab1d66e34b77533250307b014d331b96a9c846a1d9165da17e4963e56df14c5c1589427deae66d953e8b528031d6c0d09bc3a93a4757880500f15ebc7d66c63ca87585192b4451d8c791348def1b487e916b4adc01f43b3d60120a7565264caa531c5886bbc7946d5115d287c819229cefb7653e962b6b4106a11d01ad9d1d75a4604c3a3abc6efb0342abe68cae11ebb20ba61f26d04d25732191a678528ecb4dc26c27e6fb3770d204f3613693547f3e004d4968bc0000088149444154e40467eacc17ca33ef6e3e6960fdc9e3a60b91d325b1af71254d2492d00bf36511fc36ad0926313fd9b876d75bd165748d580030bc66fbb8b1f6761d29799666903a4ad26899d39b5b186f24a57c05f3c9b361926975fcaad20da43909b83cc0a2baf4ca065070f4dda35044be57ea7f543c97d52bd36d979fc6d5b07e1fbb499867acb5ffb5ba31734357890500b4975f6f52f388722f55480d058ab3cdd506d9809688e0a74579b0fc595ce56f48b33b542e8474be89f4cf43265638e60ad99f00a5b204f35830df5e9b242dc940d4a7608dfdf4c8da9d1fc73ca0ebc4daf017d30f59cb57313393db3849358b2add9b56bef993c85a48effdf64d85e84ba1d8f9e2e053395f88b82102d12c374afd2011ca8dcfd3095adb3db69a78dcb87b214dec7793bdfa4aa1c6aea0e451740be393839f8a6afa3fa6892d0f608860ee2092db3392ea42b9d3a532fdb0566925931c7a9a4594bd8d2320cbe2239437cb5f257f200f35af515ade7bd6c8d0d73b7a616d27e8bac6ca303cb4e335c6d8ef4671e66f49ea046113974d6ff6ce431bae01955fd20285db56a858a73448a137b6b8f5fbcdca2e323bb2941e3a114da5a3fe7c8dee1e0b7284ecbc538613dcb8878eb7cc27a90449ba8ff16d83bf554a1d53b80bd3ad3def4041130165b284c2dc38c9148434965f5e503ea9aea6666da57942f5bb6d6f753bb6df57fe274ef23634130a32d5fa14ea757bcbf0eaedeb5b48bbdf98378d350bbe1296ffa0b247c6803269b21ffeec2fcc38772653b98cd06b7f248de2d79185fb335cd2605266a9cc50bda28211269d844c1bfae90b7e9a2393535e5c53989949a7e384e7cdaff2459d778c6f1bfcbb38d6ff2dc9de55d00a0197aa528bb979c559ee86cd45d378795a69c4902fd58e46ecc40facd2c04de888600cff893173cac89a7b7f156a6a377100341630bc7ac73fd46792f7d4fa54a30f0a7e85f75b82af45806a42549a1da0f4d0819bcf3fe6e5709914be8cbe5f14f2c148481fea033f4d959f566a27a02282b5fc6b6bf6ae3a50a4020e10b100606468e7bbf6ed49c748114a17aba541ca50655642f01de69626cd2b57f0b5f20bd7be297327476990499e147e7d21cd29955925b7974f2982b5f6d1d4a4976e5cf7f57f6d514a5771404ca18bf1a9c17f528afe86add35f92f31c9a95aea35f15e696e1d6e143aa53ca5335f0add04acb4a0472dbe497c142bc57161181c81a0bba62f8bced5db979af131c308d956178cd8ecb4ccaa371bf57b5ef3cfb5aa0e0b073399ff4b25778e590932064ca8032095b914a32a1c1babd32dcbafd74d28313ae3ceeed454e1aa5083a2618436f3e18a4020e82c6cab0f98e817fecebd76f37cd278873949c606715e4c6fbe77efe5298a3d12447b85559adfcb6527982dc4091c0d222a350a65378e6e7f960372d379fb2e19fb3a1d70cafbd7bba9ce1c0e0a0110b00b66c1b1c67c6a54aa9fefc331f19243356691e511e74a92cbfbc10d142a84adfca57f2656fc70c5791cf2b37aa2998d4fc3f9bd8ff3272fece898a56cc3b0e2ab100607c6af08d4474b3521419c38199db44d5a0b7da4208699c0ceef75c5cad23dd21d1aad75a115c22533b04f5f33ae9a258c118f37daef3eb86cf9ffe460b09e71d079d5819b66c5bf5531da9a7a489b3d755d20ec240bb697d147cdb6662e92d78a1d557c8f449c411d294de15e1932cf43b2fcb69af5b86535763950dd8d4dc363c34fd322c101c70e73d840dabb73f2d4df836a58855f6ecbeebc403c54ece07828a61ee9f3b50c410f7a27cb2901007c8c475e13aeacdfc24e5f30948425c9ecf9b045e1a151198ed8c35666c21910a5840c402c0c36bee7e9949cdfb18bc4747cd5e2fad949cf36ce4da319b92f35c7a8db85bae005fcbf8e95bf966be5c527d6e5992166dfed611c1a6f6576cf83f0faf99de5851f341c18231852e6eb8e3ac3354d4f7b1be3e7d465ab7f2738655a409adc4424778e9dcdf1244075ef0d142c8e5ca6c6640ce825c0db3a83441694232937e796468faa515b51c542c486265d8b26de09d00bd4b47fad0fcbe2ea07265145ce9c1c98b403e178cb28bd3eeeab1d5caaf15f98534a4085a03c6f0030cf3f7c3ab777e3250fb82c0822616006cbe7df02c1de33aa5680044ca1a96b58c34e895dacdd116fe0ad02dc387485e42e9ae822a12b6e3fc3bd011c1a4fc08acfdea232ad9f0ae0378cd6fae58f0c4ca3036b1f272a5d55fc77dd1e969dd22dff70a0d48c5ec07506e792bedd28e966937bd94d7af5f015a2b9002d2c4dc6b4cf2a64d6b77ff1b1609160db1328c4daebc442b7db58e1bdf4e36ee171ec8d31c2eda71e68379a879ee694b37bf443254c455903d8a154c6a61adbd93adbd76e3ba5ddbb0c8b0e8880500efbdedcca7f61fd2bf164a5dae89ce504a519a3adfa5a972825d04b58ab01c6bc7e16fe9f335892ff43a51ee43cd58cbdf6036efd9b876d7572a3b6201635112cbc5e8e4c026ade902227aa1524a651f0798d3eab01d9faa4ad349c48397de75c89db7321bcb29804f2589b9ed8a75d39fedb01b161c163db15c6cb97bd50739c55aa5e924ad09c630f24fb300ed3bd541873ac09aaa6fe27875101adb053a2224750302be05c297df72def6bfeda0a90b1e4b8a5819c6b7adbc08ac5eab143d03c0a93a56b14d19d602b39f40692696cc239cb856be582b2d85cccc11180c66dec386bf0fe669038c6f1c9afed19c1bba80b1248995e1d24b113f73fde0ab6a913edda6e6a54ad1d3195846441a8ac0869b6f8569b2632e8ebf97c6356f0d93cc7552f47b93f2834ad3e7927de67b9b5e347dfb3c3579c16049134bc2d8e4e07aadd5e90c7e16114e638393544d1da6d07c4f9461e40b811620345670a4a8f9455720addb8788f04b267c932d7fdf1835b169edddf7cf6ba316201e73c40a616c72703dc34644ea8c5a4dad60900d2df8d8a2714701b34aeae65645f8770bfd9b8d6beefeda416b400f3df4d0430f3df4d0430f3df4d0430f3df4d0430f3df4d0430f0b03ff1f048f0143295458e50000000049454e44ae426082, 18, 'test-user2', 'single', 'test-user2@yahee.com', '2016-10-27 22:40:46', '2016-10-27 22:40:46');
-- --------------------------------------------------------
--
-- Table structure for table `request_items`
--
DROP TABLE IF EXISTS `request_items`;
CREATE TABLE IF NOT EXISTS `request_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_id` varchar(250) NOT NULL,
`item_quantity` int(11) DEFAULT NULL,
`username` varchar(45) DEFAULT NULL,
`status` varchar(45) DEFAULT 'PENDING',
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `request_items_item_id` (`item_id`),
KEY `request_items_username` (`item_id`),
KEY `request_items_username_idx` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `request_items`
--
INSERT INTO `request_items` (`id`, `item_id`, `item_quantity`, `username`, `status`, `created_at`, `updated_at`) VALUES
(155, 'inv_t1go17_4', 1, 'test-user', 'APPROVE', '2016-10-28 02:34:04', '2016-10-28 02:34:13'),
(156, 'inv_t1go17_4', 1, 'test-user', 'PENDING', '2016-10-28 02:39:34', '2016-10-28 02:39:34'),
(157, 'inv_t1go17_4', 1, 'test-user', 'PENDING', '2016-10-28 02:40:25', '2016-10-28 02:40:25'),
(158, 'inv_t1go17_4', 1, 'test-user', 'PENDING', '2016-10-28 02:41:03', '2016-10-28 02:41:03'),
(159, 'inv_t1go17_4', 1, 'test-user', 'PENDING', '2016-10-28 02:42:24', '2016-10-28 02:42:24'),
(160, 'inv_t1go17_4', 10, 'test-user', 'PENDING', '2016-11-01 04:47:44', '2016-11-01 04:47:44'),
(161, 'inv_XgJceh_5', 1, 'test-user', 'PENDING', '2016-11-01 04:52:07', '2016-11-01 04:52:07');
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
`role_id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(250) DEFAULT NULL,
`role_description` varchar(500) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`role_id`),
UNIQUE KEY `role_name_UNIQUE` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`role_id`, `role_name`, `role_description`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'Has all the privilege, controls the system. ', '2016-06-20 07:19:40', NULL),
(2, 'Inventory', 'Can only control the inventory section, has only privilege for the inventory section', '2016-06-20 07:19:49', NULL),
(3, 'User', 'Can only see inventory items, can request items, can edit his/her profile.', '2016-10-10 09:31:17', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `roles_id`
--
DROP TABLE IF EXISTS `roles_id`;
CREATE TABLE IF NOT EXISTS `roles_id` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_id` int(11) NOT NULL,
`username` varchar(250) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `roles_id_username` (`username`),
KEY `roles_id_role_id` (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `roles_id`
--
INSERT INTO `roles_id` (`id`, `role_id`, `username`, `created_at`, `updated_at`) VALUES
(1, 1, 'admin', '2016-06-20 07:20:05', NULL),
(7, 2, 'hh', '2016-06-30 20:46:47', '2016-06-30 20:46:47'),
(10, 2, 'kj', '2016-06-30 20:56:53', '2016-06-30 20:56:53'),
(11, 3, 'test-user', '2016-10-10 01:33:48', '2016-10-10 01:33:48'),
(12, 2, 'test-inventory', '2016-10-10 01:59:52', '2016-10-10 01:59:52'),
(13, 3, 'test-user2', '2016-10-27 22:40:46', '2016-10-27 22:40:46');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(250) NOT NULL,
`password` varchar(250) DEFAULT NULL,
`real_password` varchar(250) DEFAULT NULL,
`remember_token` varchar(100) DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username_UNIQUE` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `real_password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'admin', '$2y$10$Q21kVs0llalIYmhtNiJgauyMaHxNVYR5UPDTA7YnM6kznp5kC4Mj.', 'admin', 'U1Mey7NC80v2kxxP4NHyHEbEknmrPo879BOM6lg8t1WrL7uEKL8qKOBOUgqo', '2016-06-20 07:19:07', '2016-10-28 00:54:09'),
(6, 'ss', '$2y$10$veytAaVebsh9JFrGS4OS0.eCOVWfGJmLjDSudHFCycmBrz1zg..7S', 'ss', NULL, '2016-06-30 20:45:28', '2016-06-30 20:45:28'),
(7, 'hh', '$2y$10$UIJTraDpeT/CDIGH0WCEjeyZVYnuZztQ56iXlZHLQPr8grXZrSS5K', 'hh', NULL, '2016-06-30 20:46:47', '2016-06-30 20:46:47'),
(8, 'kk', '$2y$10$oUvaLOvo6vuPqm3VPjHw4.SkR8KQm6ZtAmmxRNfkyElzOpFHaw9ca', 'kk', NULL, '2016-06-30 20:55:02', '2016-06-30 20:55:02'),
(9, 'gg', '$2y$10$W3CZQQ9bnT0fwvsMG.hf5uCae622BIrxJRSIn7zpwxVGQx0uU1zte', 'gg', NULL, '2016-06-30 20:55:40', '2016-06-30 20:55:40'),
(10, 'kj', '$2y$10$/7sXjhmf8Ix9fgoAOR6uguhGzictceawHdRJ8A0w8u2tpizMXP196', 'kj', NULL, '2016-06-30 20:56:53', '2016-06-30 20:56:53'),
(11, 'test-user', '$2y$10$FOD4Flg5SHQ75nGmsdRdausRfKLsDKEr3ibqFhLjPAiTCDm2c2AeC', 'test-user', 'nlryscIai55n1ZqkuCCgoYl9iFeS7VTXqOfaKp9kWGnkKRS7NvClBUYQKkUm', '2016-10-10 01:33:48', '2016-11-01 04:47:56'),
(12, 'test-inventory', '$2y$10$rtbS7ND0Y76iEyCGrSpcxuJR6X/8Tivkq4utD0Tu.ZukP4IbZTopq', 'test-inventory', NULL, '2016-10-10 01:59:52', '2016-10-10 01:59:52'),
(13, 'test-user2', '$2y$10$hgSTErjS8GY1WLezFvJvY.tCodbqw.VcMaYnAPluG/ImabWduEuAS', 'test-user2', 'tDhPMderfES3wartdoJloChlY0tt8mTv1dgGfhz1HD9trDqQ5Fg3sKeziNfe', '2016-10-27 22:40:46', '2016-10-28 00:54:03');
--
-- Constraints for dumped tables
--
--
-- Constraints for table `inventory`
--
ALTER TABLE `inventory`
ADD CONSTRAINT `inventory_ibfk_1` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `inventory_images`
--
ALTER TABLE `inventory_images`
ADD CONSTRAINT `inventory_images_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `inventory` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
ADD CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`);
--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
ADD CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `permissions_id`
--
ALTER TABLE `permissions_id`
ADD CONSTRAINT `permissions_id_ibfk_1` FOREIGN KEY (`perm_id`) REFERENCES `permissions` (`perm_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `permissions_id_username_fk` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `request_items`
--
ALTER TABLE `request_items`
ADD CONSTRAINT `request_items_item_id` FOREIGN KEY (`item_id`) REFERENCES `inventory` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE,
ADD CONSTRAINT `request_items_username` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `roles_id`
--
ALTER TABLE `roles_id`
ADD CONSTRAINT `roles_id_role_id` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
ADD CONSTRAINT `roles_id_username` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;
--
-- Constraints for table `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `users_username` FOREIGN KEY (`username`) REFERENCES `profiles` (`username`) ON DELETE CASCADE ON UPDATE CASCADE;
/*!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 */;