# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: localhost (MySQL 5.7.21)
# Database: matrix_media
# Generation Time: 2018-04-23 10:28:51 +0000
# ************************************************************




# Dump of table academic_syllabus
# ------------------------------------------------------------


CREATE TABLE `academic_syllabus` (
  `academic_syllabus_id` int(11) NOT NULL AUTO_INCREMENT,
  `academic_syllabus_code` longtext COLLATE utf8_unicode_ci,
  `title` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `class_id` int(11) DEFAULT NULL,
  `uploader_type` longtext COLLATE utf8_unicode_ci,
  `uploader_id` int(11) DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci,
  `timestamp` longtext COLLATE utf8_unicode_ci,
  `file_name` longtext COLLATE utf8_unicode_ci,
  `subject_id` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`academic_syllabus_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `academic_syllabus` (`academic_syllabus_id`, `academic_syllabus_code`, `title`, `description`, `class_id`, `uploader_type`, `uploader_id`, `year`, `timestamp`, `file_name`, `subject_id`, `school_id`)
VALUES
	(1,'b992523','Lalal','asdasd',1,'admin',1,'2017-2018','1521961850','Exam Routine  Ekattor.pdf',1,1);



# Dump of table announcement
# ------------------------------------------------------------


CREATE TABLE `announcement` (
  `announcement_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`announcement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `announcement` (`announcement_id`, `title`, `description`, `time`, `school_id`)
VALUES
	(1,'Test Announcement','Hello world','2018-04-20 03:05:20',1);



# Dump of table appraisal_assign
# ------------------------------------------------------------


CREATE TABLE `appraisal_assign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `type` longtext COLLATE utf8_unicode_ci,
  `department_id` int(11) DEFAULT NULL,
  `department_member_id` int(11) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table appraisal_submission
# ------------------------------------------------------------


CREATE TABLE `appraisal_submission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appraisal_assign_id` int(11) DEFAULT NULL,
  `appraisal_by` int(11) DEFAULT NULL,
  `appraisal_by_role_id` int(11) DEFAULT NULL,
  `date` longtext COLLATE utf8_unicode_ci,
  `score` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table attendance
# ------------------------------------------------------------


CREATE TABLE `attendance` (
  `attendance_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `class_routine_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`attendance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `attendance` (`attendance_id`, `timestamp`, `year`, `class_id`, `section_id`, `student_id`, `class_routine_id`, `status`, `school_id`)
VALUES
	(1,'1524247200','2017-2018',1,1,1,NULL,1,1);



# Dump of table bank_account
# ------------------------------------------------------------


CREATE TABLE `bank_account` (
  `bank_account_id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_name` longtext COLLATE utf8_unicode_ci,
  `branch` longtext COLLATE utf8_unicode_ci,
  `account_number` longtext COLLATE utf8_unicode_ci,
  `opening_balance` longtext COLLATE utf8_unicode_ci,
  `current_balance` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`bank_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table bed
# ------------------------------------------------------------


CREATE TABLE `bed` (
  `bed_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `room_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 = available, 0 = not available',
  `school_id` int(11) NOT NULL,
  PRIMARY KEY (`bed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table book
# ------------------------------------------------------------


CREATE TABLE `book` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `author` longtext COLLATE utf8_unicode_ci,
  `publisher_name` longtext COLLATE utf8_unicode_ci,
  `location` longtext COLLATE utf8_unicode_ci,
  `late_fees` double DEFAULT NULL,
  `class_id` longtext COLLATE utf8_unicode_ci,
  `price` longtext COLLATE utf8_unicode_ci,
  `total_copies` int(11) DEFAULT NULL,
  `issued_copies` int(11) DEFAULT NULL,
  `status` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `book` (`book_id`, `name`, `description`, `author`, `publisher_name`, `location`, `late_fees`, `class_id`, `price`, `total_copies`, `issued_copies`, `status`, `school_id`)
VALUES
	(1,'A tale of two seas','Lalla','Arnest Hemingway',NULL,NULL,NULL,'1','21',NULL,1,NULL,1);



# Dump of table book_request
# ------------------------------------------------------------


CREATE TABLE `book_request` (
  `book_request_id` int(11) NOT NULL AUTO_INCREMENT,
  `book_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` longtext COLLATE utf8_unicode_ci,
  `issue_start_date` longtext COLLATE utf8_unicode_ci,
  `issue_end_date` longtext COLLATE utf8_unicode_ci,
  `status` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`book_request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `book_request` (`book_request_id`, `book_id`, `user_id`, `user_type`, `issue_start_date`, `issue_end_date`, `status`, `school_id`, `student_id`)
VALUES
	(1,1,1,'student','1522022400','1522368000',1,1,NULL);



# Dump of table ci_sessions
# ------------------------------------------------------------


CREATE TABLE `ci_sessions` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `data` blob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`)
VALUES
	('00d7f4dc7c8fa79bbf998ead47206e54592a1f73','::1',1524239124,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343233383833323B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0342fdf69726794f2b49838753987b470b9bd39f','::1',1524245017,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234343934343B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('03a75cefb91996cd9fe49f4d0d9bcad8e513342f','::1',1518524251,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383532343137373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('05738252928ebff54f1765c1c40eb552440896b5','::1',1524062304,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036323330323B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('08eee13da96c923c54951b6d79ec10c16970427d','::1',1524072318,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037323033323B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0c43fe164d1a48ad20373f8f16f2411a72987bbd','::1',1524071226,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037303933333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0c68bd1b7e140648542e0fc7de7bf1e07c290e05','::1',1521961733,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936313437373B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0cccce47841984e067c608cd149bd18dc8fdf9be','::1',1524058030,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035373736373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0d682f8c643a8a44f203749713d77967fc75d81a','::1',1524070526,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037303239303B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0e149c93e13d27a885e14c3cfc6ad4e50b19fba8','::1',1524053898,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035333834383B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('0e7df09090f41f27db4355aa18eb8de32334f140','::1',1518509537,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530393235313B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('113a1cea8ec907da3509d8e7a32a8072ee045be6','::1',1517383620,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373338333631393B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('12bc612dc3a9978fd951173dd34b5d8cce465c5e','::1',1517467329,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373436373332393B'),
	('1304604953136ac1243eddded91dc052f3c567c5','::1',1523445910,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333434353837313B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('14bd23a13a95a163f21eb7dedfae95857ba59599','::1',1524239136,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343233393133363B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('166c95f4b3aeee1a8ca5c2633e812c7836733b73','::1',1521961471,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936313337303B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A32333A2244617461204164646564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('1ac7c7aae393e92092734fd81f81dc03cf253568','::1',1521963289,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936333237363B6C696272617269616E5F6C6F67696E7C733A313A2231223B6C696272617269616E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A363A2253616C617361223B726F6C655F69647C733A313A2233223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A393A226C696272617269616E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A32393A2252657175657374204163636570746564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('1fe968239c5e5beef8e9f66aeaf6fa212e9b37b2','::1',1522136470,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133363434303B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('22f66ae9c536351a7db7e07915ef5ab4a8a1c860','::1',1524088027,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038373735333B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('2324da3a0878cb1da9c7f0589f30eee6fed7a530','::1',1517385984,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373338353937363B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('23479f055615099db3a183cf928327dbb0ed8989','::1',1521971813,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313937313830393B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('234a86aef60786ce722acfe4ddd8ee2c6e69eab6','::1',1524174015,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137333836303B6C696272617269616E5F6C6F67696E7C733A313A2231223B6C696272617269616E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A363A2253616C617361223B726F6C655F69647C733A313A2233223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A393A226C696272617269616E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('2622ea32fd719cb999e85cca679fa0f9aef6da50','::1',1518507792,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530373733323B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B666C6173685F6D6573736167657C733A32363A224576656E742055706461746564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('2668ce9d80604e8fa2cab64be0230cc91968c87f','::1',1521964216,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936343036303B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('2908fd5628b8bbe6c470772edbb8df53dded88c4','::1',1524177025,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137363938383B6163636F756E74616E745F6C6F67696E7C733A313A2231223B6163636F756E74616E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224D72204163636F756E74616E74223B726F6C655F69647C733A313A2235223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A31303A226163636F756E74616E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('29666e7f917a543c4c5c35d303ddb42bc597048b','::1',1522134989,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133343936393B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('299f2b1dd04d36aeab7e0f79e8f4ffef304124fb','::1',1524088897,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038383730363B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('2a41gebotvnnq1p9au2ee55h2q','::1',1523444641,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333434343634313B'),
	('2b4c279ad9c511a9f43eb6161c88b84cd55d75ed','::1',1524062140,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036313837373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('2c2ed8c9fe137fe07eaf565dcc65fe7edad9e4f4','::1',1524070246,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036393937323B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('2ce5b5e82c3e423e27c47f14fbb4874c7c0d3eb4','::1',1524126306,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343132363239303B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A363A22706172656E74223B'),
	('2f40ea0f16db6761ad136732f9bf7713314d0328','::1',1524171152,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137303832393B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('2f6a3beab126e0c146d0c9e0291c9da32ee79b86','::1',1518417889,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383431373837383B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('2f6a3e55e97e2fabaf358d8b5dd9f7e363c0831d','::1',1524255081,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235343830363B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('302983d8a81f591554901ca97e1c3d3b14397c4b','::1',1521715288,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313731353233343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('31b504507f3ac8a4a3be7b005cd0ddb3becd1022','::1',1524173565,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137333237323B7472616E73706F72746174696F6E5F73746166665F6C6F67696E7C733A313A2231223B7472616E73706F72746174696F6E5F73746166665F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31343A224C65766920446F6E616C64736F6E223B726F6C655F69647C733A313A2232223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A32303A227472616E73706F72746174696F6E5F7374616666223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('35171643323af40ca9bb3d2599a828a4f2657846','::1',1524058368,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035383233383B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('3517e9b56517ca026c9ae8c7e2b8a0ed5dc8dc62','::1',1524244898,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234343633393B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('359cb6b5bd4aca58b26d58b8253501804124314b','::1',1518509204,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530383933303B7363686F6F6C5F69647C733A313A2231223B'),
	('3c3184fac6000c2cab23eb5845fe9ad4ba7638ca','::1',1524052626,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035323333313B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('3c7acd012f4086b5d5080e6679ea1f76ef9410c5','::1',1524253517,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235333432343B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('3f5de3d2b4760dcd44741ab54fd6ed249b8f9480','::1',1524255485,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235353230343B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('3fcf123b77fa11a431b957b74c5f840261963066','::1',1524253401,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235333131383B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('4012e135d949cee0353056f0d61a6d5fdff37e2f','::1',1524088349,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038383036393B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('40b3af34102a1a41ed909e5095ae157c5a970f38','::1',1521963666,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936333432303B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('41971715cc884c92dc5a9d2f67c7f219da564c77','::1',1524243722,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234333533373B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('4236d5f2c466efece646689f07816b725933901e','::1',1521962842,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936323630323B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('47d52824b541ccf4b59d9f86c22a44c7a8516519','::1',1524174434,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137343237393B6C696272617269616E5F6C6F67696E7C733A313A2231223B6C696272617269616E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A363A2253616C617361223B726F6C655F69647C733A313A2233223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A393A226C696272617269616E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('48f92d9be1d64be231be3d0f5a197444393711cd','::1',1524176017,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137353735323B686F7374656C5F61646D696E5F6C6F67696E7C733A313A2231223B686F7374656C5F61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31353A224D7220486F7374656C2041646D696E223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2236223B6C6F67696E5F747970657C733A31323A22686F7374656C5F61646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('492b9e78184908f0c57c51285c0e5bb4f8147819','::1',1518957891,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383935373633393B7472616E73706F72746174696F6E5F73746166665F6C6F67696E7C733A313A2231223B7472616E73706F72746174696F6E5F73746166665F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31343A224C65766920446F6E616C64736F6E223B726F6C655F69647C733A313A2232223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A32303A227472616E73706F72746174696F6E5F7374616666223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('495cefb2772374470c784a974fd091c32da82263','::1',1521965523,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936353530373B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('4d0aa7365c97636231aaa5c779b45180297038f3','::1',1523960387,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333936303338373B'),
	('4dde2400f752760df76539988165eb0ee6d68c40','::1',1524059014,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035383831363B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('4ebb7b5a6bbcdcd4e65333c0eea5892f9032c1ea','::1',1524086229,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038363139393B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B6C6173745F706167657C733A36393A22687474703A2F2F6C6F63616C686F73742F637573746F6D2F6D61747269785F6D656469612F696E6465782E7068702F73747564656E742F73747564795F6D6174657269616C223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B'),
	('4ed3bbe4696e60d551a369537754254b0b6381e8','::1',1518511956,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383531313935363B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C4E3B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('4f948345f6cfb24ae91cfaa4e15facb5b371f57e','::1',1523561597,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333536313539363B'),
	('554009caaec18bf14a9e8c4fdd62bf7476404858','::1',1518507395,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530373339323B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('55a2023f86fac02a364c755840ef7ff421fbfeb8','::1',1524055673,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035353430343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('55c5daa92b3ac65f069ea3f00f38c0ad1c5ae5e0','::1',1524056389,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035363338373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('56e3106e7579d880468573cf30218494e2de72a3','::1',1524239988,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343233393935333B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('589fa6b25a86b0ab77263909f07e4bc174dc152f','::1',1524248915,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234383830393B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('594a7bc6895d4c2fd9d58516f013cf24f057a7e6','::1',1524254443,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235343434333B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('5a98ae4a5c7f37cbb6080ce149fb48c1b5377e03','::1',1524149798,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343134393536333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('5c96875a5178e83867bbd2d05068a21906cfc753','::1',1524065540,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036353430363B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('5dc592abe5da85fc9e0f7138ab744f79302a1f6e','::1',1518508416,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530383338323B'),
	('5f962a5607a1375f448049312943d4af4565ee16','::1',1524061300,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036313037323B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('603b319b26b82bdd15a9c4077819e05264d21434','::1',1521962071,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936313831313B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('609c707eecbf8c437e70ac68d30309904df9757e','::1',1524087722,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038373433333B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('63780be7860e477f5aab2368d789c9282ee7499d','::1',1517830533,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373833303434323B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B666C6173685F6D6573736167657C733A32333A2244617461204164646564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('63d73aed070c794993f4ccfd0bfc64757a34d416','::1',1524053302,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035333134373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('6840df76f901ccc13e5584e532b69b5bf7cd4cff','::1',1524089436,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038393433353B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('695f2253bed3b44b77d3276484b862ef485e3d05','::1',1524153602,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343135333333393B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('69a2852ea89a51746146b1e59c6d0ee1cd2f1a80','::1',1524059142,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035393134323B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('6af2cad700232a8bc1a573c6b629d3baa5601e6d','::1',1522139554,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133393333363B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('6b0d21ba380ff28b57135d10a88dbf8092fe9728','::1',1524239718,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343233393434353B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('6ded400de4e60bdb9db77a0795013676d2d2bbcd','::1',1521963044,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936323936313B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('6f6caf9d6b3f2ebe6d0f8fe5146bd68c5c19bbbc','::1',1524244093,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234333838353B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('6ff20a410356ea790a83c4ce562474b868deeef5','::1',1524240709,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234303436333B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('6ti9bcmp4d1u6p231kg7u70hue','::1',1523444590,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333434343539303B'),
	('71a2e9a50f3d9924e5c935b4c689d02ebe77356f','::1',1524242726,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234323434393B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('7346f0c1ef4cd286c2070d1b1ef089e6adde00fb','::1',1524171449,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137313135323B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('73dedc246b76f77cbd2ea6c589993fd7f8c48a64','::1',1523444962,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333434343637313B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('7450d90a88fb9f248441de8b0077c3e3b8c25db0','::1',1524073237,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037323936373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('7a6380d5d22021972e8a1b9c19c5200b0358d516','::1',1522140414,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323134303137313B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('7aefbc4d0c6bf53f3a093dba2474483b4338b5d8','::1',1524253797,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235333739313B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('7c51fdd082b671166e840e44a326d5c58e5cf8c8','::1',1518673788,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383637333738373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('7d0ed46b850a049144778cf2f57534605495bc40','::1',1518957635,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383935373333353B7472616E73706F72746174696F6E5F73746166665F6C6F67696E7C733A313A2231223B7472616E73706F72746174696F6E5F73746166665F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31343A224C65766920446F6E616C64736F6E223B726F6C655F69647C733A313A2232223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A32303A227472616E73706F72746174696F6E5F7374616666223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('7ea4a04c2ebe72128413f2a22148b2f817375642','::1',1519292497,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239323236333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A31333A224D6573736167652053656E7421223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('7f51caf0f19e2cbec2dd0891e99a6c3d939732d2','::1',1524163474,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343136333333353B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('7fa76376df3861e313537a6803c9b7dbd98fb2bf','::1',1518517257,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383531373231343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C4E3B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('80d67f38d8137f702a63221a2f62f991990d9793','::1',1521961981,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936313639303B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A33373A225374756479204D6174657269616C20496E666F205361766564205375636365737366756C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('80e093e540c22baa15961101e88a347dbf4c7bf7','::1',1524065952,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036353739303B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('824132932059c937926cbe72105fb0aafbe39440','::1',1521963217,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936323932343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A32333A2244617461204164646564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('82a08bd224564c80547b3398834a38cc0d289c63','::1',1524171784,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137313530323B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('8852ceea1a9113a3fdad55e543b40ab615429d38','::1',1521965154,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936353036363B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('888282d21ae2255598ed611d3b4eab0311ca570b','::1',1521971506,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313937313335393B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('88cf35c3c882e9957281d7e3b130a70a0ddda548','::1',1517390344,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373339303334343B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('8a17db71ee904944c71c8d74aca4c257a18ed3ed','::1',1518590741,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383539303633303B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('8b0aef4920d62c790e807ebc5bdc86a10e7806ea','::1',1524087402,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038373131303B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('8c4855533437f9f905f32472c1fa90d1a3788992','::1',1524242026,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234313834323B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('8d84fc1a6144c5c5ace117ee2e1ad4c285eb326f','::1',1517384618,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373338343432393B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('8e34603251dd680ec9ca32bd0aa240aabab5d9a6','::1',1522136104,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133363039373B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('91349336009767be95ee7b443702a8cf9bbfe7a7','::1',1517915182,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373931353133303B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('91d890665bf35520d6cc9e92d75e99e7bf89b078','::1',1518522828,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383532323831363B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('928db3b56d083e3f44c6d1674d73eef376f281cb','::1',1524241174,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234303936363B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('92f33f43032316ef22644ba1f9ae1c0c3ea92b09','::1',1521965564,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936353535343B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('984b98bf7d8a9ffec0f07eaa3d22416402dcdb79','::1',1524053049,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035323832333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('98b7c497ecb39698e49af0bc9e22e6aa722f33c9','::1',1518510539,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383531303438373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C4E3B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('9988faeea70c564bf47c4fc0eb324a7c13da645e','::1',1518522616,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383532323339313B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('99e93c8993868c33801c63e64249d03ce4705eeb','::1',1517389875,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373338393837353B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('9ad6f3e1e522c0ec3d4e41a009ab6423723acaab','::1',1517396515,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373339363531343B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('9cb1851f77942bc5c7ef0219b68b50796f13d634','::1',1522135727,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133353437383B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('a1ba48094fbe7d905072f2eb6a83eba1dd880988','::1',1524248498,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234383233323B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('a2d2ed4v4c3eltemqgefqbe6p9','::1',1524406500,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343430363530303B'),
	('a50fb4c7a63c6e4922a73c749a4739b080b879ec','::1',1521965111,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936353038333B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A32333A2244617461204164646564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('a533bf76977b52938d734b5a4177e504eef35433','::1',1519300787,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393330303738353B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('a6dbdb46e25cf8afac72e2182a40846f8ee066c8','::1',1524063789,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036333439303B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('aad0d6215d652dd365049bc8da5942dbf51c2c26','::1',1518676525,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383637363237383B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('ab06a240eb4c02b4a9a080ab8638e78a2f39d549','::1',1524061680,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036313432373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('ab3a87e095cec6bd745c09b7577939da4b5c124d','::1',1518511940,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383531313632343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C4E3B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('aba6b59b80d1ccc57560b9c23613610ec14510d5','::1',1524172037,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137313834303B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('aeb26c5165dd5d9062a5c522a9869065260135c0','::1',1524252900,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235323730383B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('aeee6b4af1920a755f7edcca302b04403d7bccc4','::1',1524162546,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343136323431343B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('af866d0880ce2e32383a54be8af2d25147545129','::1',1524088603,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038383337333B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b04c556abe6e6537c5a568103352726293286152','::1',1519542075,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393534323037343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('b12cf58ec2df10e2af35aa5bbf67d88f98ed9ede','::1',1524071589,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037313339353B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b15c5fc601f9c27e12f57cffe3a65f4deefe81b3','::1',1524176432,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137363134393B686F7374656C5F61646D696E5F6C6F67696E7C733A313A2231223B686F7374656C5F61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31353A224D7220486F7374656C2041646D696E223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2236223B6C6F67696E5F747970657C733A31323A22686F7374656C5F61646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b315e3f0166a1ce548543d9f693dc7fd6569665f','::1',1524255893,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235353738343B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b46c7806817d59794a54f7adced9eeccdc3a8ea1','::1',1519625870,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393632353836383B72756E6E696E675F796561727C4E3B73797374656D5F6E616D657C4E3B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('b486f81ea61ae3bd7dbfa05307a9cddc32e0945b','::1',1524063953,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036333739353B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b4f297ca6f1f7299c314a31b97dc295a1b3741a5','::1',1521971013,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313937303934353B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b672696f4ec413306541663ca9a07a24ce1b363c','::1',1524072943,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037323634373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('b767a815188911edb97d8f37123ee751ffac27b1','::1',1522136065,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133353737393B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('b7fbd73d5e3ab99057702e65d4c0f6646bbbce42','::1',1519296364,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239363331333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('bb1e45a09b2375bda6aa9da80c129e0a68b2d9b4','::1',1524257046,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235373034363B'),
	('bf5216babc8206f4fcbb0e44c323652f83000601','::1',1524238687,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343233383436383B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c160e018a56e7fb2d2e0d809da1cf223b4afee44','::1',1524066200,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036363039333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c168d084d487193e503d462e96ebb4602b1d2cc0','::1',1518510202,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530393931343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c1ac9c93469327bb1f2d9fe6c571fce8b1c52d6b','::1',1518509829,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530393535353B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c24a66cfdcce27f61a3c60077d1b58801d15eb72','::1',1524245509,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234353236333B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c4aedd89d791e22e8644e0979f98ad781cf1e4af','::1',1524243502,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234333231373B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c4f9f7995210721a1a7b25b4e744319ffc75472f','::1',1521964726,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936343730383B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c5ffa9698719d5ce9641a05a61c05f307b93585d','::1',1524161305,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343136313238393B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c7c685386fd449d820ef4f3524c3d4b4dcd5bd2d','::1',1518514933,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383531343637343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C4E3B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c818b97b8f8e0b5d7b8bc5b6ff57913e0cdbad5a','::1',1524052752,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035323639333B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c8c07a835e1fe263b1d40e26e3a0aca7e8d2d31f','::1',1524252708,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235323339373B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('c8eb4b0dd04b5650e95e0770d396f032a358b614','::1',1521971716,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313937313731363B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('ca2cea1a663edab169290565dfc2982be72cf7df','::1',1524072638,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037323333393B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('cad90dfd746ab92b0b045a94d1d25ccb1417cda9','::1',1524065318,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036353037363B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('ccd13d4303961b7ac0c8f24dedfa039fe8d3ed8b','::1',1518691679,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383639313637383B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('cd86b1c391b1f73383528d24fec39df365f62fdd','::1',1519292874,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239323537373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('cdaa0bdd0a13c42a18933bf06a346b7e7b050a98','::1',1517988170,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373938383137303B'),
	('cf105baa29713bfa4714ced436c591e880231667','::1',1524154010,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343135333735363B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('d09e9cef69f8206bea95993a5c926469276c79b8','::1',1524244584,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234343239313B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('d3ff90cb49a89f392fc8b38f1b5c5531075083e8','::1',1524250054,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235303031333B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('d43f066114c6ca9a40459a9541fba94ea5b61388','::1',1521964666,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936343336383B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('d5035dbfbacd1875ba648f28e9d1b62f70001f81','::1',1524245754,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234353733343B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('d5ca5b15a5ce2eea043360c8f5575ce525b1a0b8','::1',1518674837,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383637343831343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('d686ca57f8b43b62667cbe81766b3edce2623c6f','::1',1521962433,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936323131353B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('df9cea4d9595022224e82dd33caab844c03e4b84','::1',1521964022,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936333735363B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('df9e4401a081de7a918340f2b53f5044571056ab','::1',1519293075,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239333037353B72756E6E696E675F796561727C4E3B73797374656D5F6E616D657C4E3B'),
	('dff3569fd8b2a2cf49fd098c6b7da451e383cba0','::1',1524063308,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036333133303B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('e38ca73d04fa6b3102ec9237a2a5fee52a23a00a','::1',1524073522,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037333333313B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('e4003e2c788ca4f307eb1cb562cddb514cc5b0b2','::1',1524055342,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035353035373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('e4755b8bdac4c8bb97c4d8fd4e86c0d41024a85d','::1',1524086128,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038353834303B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B6C6173745F706167657C733A36393A22687474703A2F2F6C6F63616C686F73742F637573746F6D2F6D61747269785F6D656469612F696E6465782E7068702F73747564656E742F73747564795F6D6174657269616C223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B'),
	('e58cd7edb66b279af3ab5abfcf40a3d896c47599','::1',1519292701,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239323638303B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('e5b90f30ebf35647965f45234cfa85fb13362d06','::1',1524086849,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038363535313B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B6C6173745F706167657C733A36393A22687474703A2F2F6C6F63616C686F73742F637573746F6D2F6D61747269785F6D656469612F696E6465782E7068702F73747564656E742F73747564795F6D6174657269616C223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B'),
	('e63a5a40f3833fbe150f33033a5129cdbf285172','::1',1518340859,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383334303835363B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('e676de879b7ac6a18047b7d2cb17d5c7d6fdc938','::1',1521971100,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313937303938373B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('e6b784e2ef85c80c9236b0030d4a0af198931862','::1',1524175469,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137353339323B686F7374656C5F61646D696E5F6C6F67696E7C733A313A2231223B686F7374656C5F61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31353A224D7220486F7374656C2041646D696E223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2236223B6C6F67696E5F747970657C733A31323A22686F7374656C5F61646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('e722cce9191c3e77553f9825b9c7e0bd3fe3d3d3','::1',1524150547,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343135303534373B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('eb44c10b47a574c885b574c4ddba6a7e11e4628e','::1',1518676657,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383637363635373B'),
	('ec17e45d8a91f84077a32b23925cfc967b6ded5b','::1',1521961304,X'5F5F63695F6C6173745F726567656E65726174657C693A313532313936313034353B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('ee07b36eac89c28b7b942ed2cdf18594c72a5302','::1',1524242418,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234323134383B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f11ec19e92f6cda908716d5717d80b19e8dfbcaf','::1',1524055992,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035353737343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f168f4bedc1081b45e2de707fcbec34bfcc0f92c','::1',1518506816,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383530363733323B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('f344be60cef39be312dd2141dcd15b9e2511a06c','::1',1524070898,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343037303632333B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f3600495089b36ddeab9bb1e4a93419252996251','::1',1524089397,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343038393130303B706172656E745F6C6F67696E7C733A313A2231223B706172656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A343A224C616C61223B726F6C655F69647C4E3B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A363A22706172656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f545b84b72bd367f1ccddac0d5724a062bc6fc27','::1',1522139887,X'5F5F63695F6C6173745F726567656E65726174657C693A313532323133393731333B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B'),
	('f6835e300a3f5c7d36ce314c1e3375a166c16fce','::1',1524176985,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343137363638353B6163636F756E74616E745F6C6F67696E7C733A313A2231223B6163636F756E74616E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224D72204163636F756E74616E74223B726F6C655F69647C733A313A2235223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A31303A226163636F756E74616E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f6f9ea850f62195470609827a0b8075e9df9ac31','::1',1524056786,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343035363738343B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B73747564656E745F6C6F67696E7C733A313A2231223B73747564656E745F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A383A224A616E6520446F65223B726F6C655F69647C4E3B6C6F67696E5F747970657C733A373A2273747564656E74223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f76839b7ef11a487d3b7e0c0f30bb1caa8b0d319','::1',1519295096,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239343834393B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('f7748ed72c0533302d8612fe18877b7a1740a7c8','::1',1518591401,X'5F5F63695F6C6173745F726567656E65726174657C693A313531383539313430303B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('f7ea92177c34db0b0a8012fc54f3a60b21f0cb82','::1',1524066194,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343036363135373B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B666C6173685F6D6573736167657C733A32333A2244617461204164646564205375636365737366756C6C79223B5F5F63695F766172737C613A313A7B733A31333A22666C6173685F6D657373616765223B733A333A226F6C64223B7D'),
	('f7eb61063692670d3ffe5b5b0053ff85e2db0352','::1',1524254310,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343235343131333B746561636865725F6C6F67696E7C733A313A2231223B746561636865725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31333A224272616E64656E204275726368223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A373A2274656163686572223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('fb412cc84e16e5ccc1a358bbbc413c2b7eb20630','::1',1519293075,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393239333037353B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('fd20016ec392aebef740c06d886a9d663cf2a313','::1',1519021024,X'5F5F63695F6C6173745F726567656E65726174657C693A313531393032313032323B72756E6E696E675F796561727C4E3B73797374656D5F6E616D657C4E3B7363686F6F6C5F69647C733A313A2231223B7363686F6F6C5F636F64657C733A373A2261616566623239223B'),
	('fe9716208fa04073db7c5acc46989557a1ad36c3','::1',1524242886,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234323836363B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('feb43dda35d7b14ee5682948025f5f10585dff97','::1',1517384333,X'5F5F63695F6C6173745F726567656E65726174657C693A313531373338343038383B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A31313A2244656D6F2073797374656D223B'),
	('ff84080d2c590f9c3aabb18791146ffb843f8ffb','::1',1524241590,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343234313335343B68725F6C6F67696E7C733A313A2231223B68725F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A353A224D72204872223B7363686F6F6C5F69647C733A313A2231223B726F6C655F69647C733A313A2234223B6C6F67696E5F747970657C733A323A226872223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('ffae66aa77ccdc29091a90ba14dc0a99b9a72788','::1',1524154247,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343135343139343B61646D696E5F6C6F67696E7C733A313A2231223B61646D696E5F69647C733A313A2231223B6C6F67696E5F757365725F69647C733A313A2231223B6E616D657C733A31303A2244656D6F2041646D696E223B726F6C655F69647C733A313A2231223B7363686F6F6C5F69647C733A313A2231223B6C6F67696E5F747970657C733A353A2261646D696E223B72756E6E696E675F796561727C733A393A22323031372D32303138223B73797374656D5F6E616D657C733A373A22456B6174746F72223B'),
	('j3ojh6ffl014mfidpu94psj9nr','::1',1524406500,X'5F5F63695F6C6173745F726567656E65726174657C693A313532343430363530303B'),
	('uttqju7l9ai0q4m81d8v4vb86u','::1',1523444629,X'5F5F63695F6C6173745F726567656E65726174657C693A313532333434343632393B');



# Dump of table class
# ------------------------------------------------------------


CREATE TABLE `class` (
  `class_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `name_numeric` longtext COLLATE utf8_unicode_ci,
  `class_fee` longtext COLLATE utf8_unicode_ci,
  `teacher_id` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `class` (`class_id`, `name`, `name_numeric`, `class_fee`, `teacher_id`, `school_id`)
VALUES
	(1,'Class One','1','600',1,1);



# Dump of table class_routine
# ------------------------------------------------------------


CREATE TABLE `class_routine` (
  `class_routine_id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `time_start` int(11) DEFAULT NULL,
  `time_end` int(11) DEFAULT NULL,
  `time_start_min` int(11) DEFAULT NULL,
  `time_end_min` int(11) DEFAULT NULL,
  `day` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`class_routine_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `class_routine` (`class_routine_id`, `class_id`, `section_id`, `subject_id`, `time_start`, `time_end`, `time_start_min`, `time_end_min`, `day`, `year`, `school_id`)
VALUES
	(1,1,1,1,10,11,0,0,'monday','2017-2018',1),
	(2,1,1,2,13,15,10,15,'monday','2017-2018',1);



# Dump of table department
# ------------------------------------------------------------


CREATE TABLE `department` (
  `department_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`department_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `department` (`department_id`, `name`, `description`, `school_id`)
VALUES
	(1,'Sgsd','sgdsd',1);



# Dump of table department_member
# ------------------------------------------------------------


CREATE TABLE `department_member` (
  `department_member_id` int(11) NOT NULL AUTO_INCREMENT,
  `department_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  `is_head` int(1) DEFAULT '0',
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`department_member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `department_member` (`department_member_id`, `department_id`, `user_id`, `role_id`, `is_head`, `school_id`)
VALUES
	(1,1,1,1,0,1),
	(2,1,2,1,0,1),
	(3,1,1,2,0,1),
	(4,1,1,3,0,1),
	(5,1,1,4,0,1),
	(6,1,1,6,0,1),
	(7,1,1,5,0,1);



# Dump of table document
# ------------------------------------------------------------


CREATE TABLE `document` (
  `document_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `file_name` longtext COLLATE utf8_unicode_ci,
  `file_type` longtext COLLATE utf8_unicode_ci,
  `class_id` longtext COLLATE utf8_unicode_ci,
  `teacher_id` int(11) DEFAULT NULL,
  `timestamp` longtext COLLATE utf8_unicode_ci,
  `subject_id` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `document` (`document_id`, `title`, `description`, `file_name`, `file_type`, `class_id`, `teacher_id`, `timestamp`, `subject_id`, `school_id`)
VALUES
	(1,'Test Study','<p>dasfasfasf</p>','Dialer-System-Doc.docx','doc','1',NULL,'1522022400',1,1);



# Dump of table dormitory
# ------------------------------------------------------------


CREATE TABLE `dormitory` (
  `dormitory_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `number_of_room` int(11) DEFAULT '0',
  `description` longtext COLLATE utf8_unicode_ci,
  `location` longtext COLLATE utf8_unicode_ci,
  `manager_name` longtext COLLATE utf8_unicode_ci,
  `manager_mobile` longtext COLLATE utf8_unicode_ci,
  `manager_email` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`dormitory_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `dormitory` (`dormitory_id`, `name`, `number_of_room`, `description`, `location`, `manager_name`, `manager_mobile`, `manager_email`, `school_id`)
VALUES
	(1,'Test Dormitory',0,'Test description','test location','test manager','45678','man@mandorm.com',1);



# Dump of table driver
# ------------------------------------------------------------


CREATE TABLE `driver` (
  `driver_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `driver_licence_number` longtext COLLATE utf8_unicode_ci,
  `mobile_number` longtext COLLATE utf8_unicode_ci,
  `emergency_contact` longtext COLLATE utf8_unicode_ci,
  `relationship` longtext COLLATE utf8_unicode_ci,
  `remarks` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`driver_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table dummy
# ------------------------------------------------------------


CREATE TABLE `dummy` (
  `dummy_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  PRIMARY KEY (`dummy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table enroll
# ------------------------------------------------------------


CREATE TABLE `enroll` (
  `enroll_id` int(11) NOT NULL AUTO_INCREMENT,
  `enroll_code` longtext COLLATE utf8_unicode_ci,
  `student_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `roll` int(11) DEFAULT NULL,
  `date_added` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`enroll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `enroll` (`enroll_id`, `enroll_code`, `student_id`, `class_id`, `section_id`, `roll`, `date_added`, `year`, `school_id`)
VALUES
	(1,'1a06ebc',1,1,1,NULL,'1521961003','2017-2018',1);



# Dump of table exam
# ------------------------------------------------------------


CREATE TABLE `exam` (
  `exam_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `time_start` int(11) DEFAULT NULL,
  `time_end` int(11) DEFAULT NULL,
  `time_start_min` int(11) DEFAULT NULL,
  `time_end_min` int(11) DEFAULT NULL,
  `date` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `comment` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`exam_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `exam` (`exam_id`, `name`, `class_id`, `section_id`, `time_start`, `time_end`, `time_start_min`, `time_end_min`, `date`, `year`, `comment`, `school_id`)
VALUES
	(1,'Mid',1,1,8,9,20,15,'27-03-2018','2017-2018','Lalal',1);



# Dump of table expense_category
# ------------------------------------------------------------


CREATE TABLE `expense_category` (
  `expense_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`expense_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table form_response
# ------------------------------------------------------------


CREATE TABLE `form_response` (
  `form_response_id` int(11) NOT NULL AUTO_INCREMENT,
  `form_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `status` longtext COLLATE utf8_unicode_ci,
  `comments` longtext COLLATE utf8_unicode_ci,
  `files` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`form_response_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `form_response` (`form_response_id`, `form_id`, `parent_id`, `status`, `comments`, `files`, `school_id`)
VALUES
	(1,1,1,'accept','Hello','uploads/form_files/11/',1);



# Dump of table forms
# ------------------------------------------------------------


CREATE TABLE `forms` (
  `form_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `start` longtext COLLATE utf8_unicode_ci,
  `end` longtext COLLATE utf8_unicode_ci,
  `fee` longtext COLLATE utf8_unicode_ci,
  `instruction` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  `parent_id` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`form_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `forms` (`form_id`, `name`, `start`, `end`, `fee`, `instruction`, `school_id`, `parent_id`)
VALUES
	(1,'May Day','20/03/2018 18:40','29/03/2018 22:50','344','Please fill',1,'all');



# Dump of table frontend_events
# ------------------------------------------------------------


CREATE TABLE `frontend_events` (
  `frontend_events_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8,
  `timestamp` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`frontend_events_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `frontend_events` (`frontend_events_id`, `title`, `timestamp`, `status`, `school_id`)
VALUES
	(1,'Accusantium eum nesciunt eum dolore sint',1514847600,1,1);



# Dump of table frontend_gallery
# ------------------------------------------------------------


CREATE TABLE `frontend_gallery` (
  `frontend_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8,
  `description` longtext CHARACTER SET utf8,
  `date_added` int(11) DEFAULT NULL,
  `image` text CHARACTER SET utf8,
  `show_on_website` int(11) NOT NULL DEFAULT '0',
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`frontend_gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table frontend_gallery_image
# ------------------------------------------------------------


CREATE TABLE `frontend_gallery_image` (
  `frontend_gallery_image_id` int(11) NOT NULL AUTO_INCREMENT,
  `frontend_gallery_id` int(11) DEFAULT NULL,
  `title` text CHARACTER SET utf8,
  `image` text CHARACTER SET utf8,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`frontend_gallery_image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table frontend_general_settings
# ------------------------------------------------------------


CREATE TABLE `frontend_general_settings` (
  `frontend_general_settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `description` longtext CHARACTER SET utf8,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`frontend_general_settings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `frontend_general_settings` (`frontend_general_settings_id`, `type`, `description`, `school_id`)
VALUES
	(1,'about_us','',1),
	(2,'terms_conditions','',1),
	(3,'privacy_policy','',1),
	(4,'social_links','[{\"facebook\":\"Temporibus itaque aute cupiditate in fugit consequatur quasi laboris exercitation in rerum quia\",\"twitter\":\"Officia eiusmod magni odio vero ut illo\",\"linkedin\":\"Consequuntur qui dolores illum voluptate nulla voluptatem\",\"google\":\"Beatae adipisci cillum odit eu\",\"youtube\":\"Voluptatem architecto porro itaque numquam quasi perspiciatis nesciunt sit nemo eiusmod minima laudantium sint elit occaecat proident itaque\",\"instagram\":\"Maiores architecto dolorem sunt porro tempore delectus est et odio eveniet est exercitationem totam sequi voluptatem corporis\"}]',1),
	(5,'school_title','Ekattor School',1),
	(6,'school_logo','',1),
	(7,'school_location','51.7548164,-1.2565555',1),
	(8,'address','Atque officia illum duis labore delectus labore cillum nostrud molestias',1),
	(9,'phone','+758-25-4409047',1),
	(10,'email','raqusifoke@example.com',1),
	(11,'fax','+986-59-3808300',1),
	(12,'header_logo','',1),
	(13,'footer_logo','',1),
	(14,'copyright_text','demo copyright',1),
	(15,'about_us_image','about_us_IMG_215439.png',1),
	(16,'slider_images','[{\"title\":\"We rock the big stage\",\"description\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected \",\"image\":\"1.jpg\"},{\"title\":\"Making this the first true generator on the Internet\",\"description\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected \",\"image\":\"20688fd80c1f634c7c7c2d1e710d2991-5a701e605bf42.jpg\"},{\"title\":\"There are many variations of passages of Lorem Ipsum\",\"description\":\"There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected \",\"image\":\"3.jpg\"}]',1),
	(17,'theme','default',1),
	(18,'homepage_note_title','Ratione eius aut dignissimos veniam quibusdam',1),
	(19,'homepage_note_description','Sit culpa voluptatem Molestias facere natus magna occaecat',1),
	(20,'recaptcha_site_key','',1);



# Dump of table frontend_news
# ------------------------------------------------------------


CREATE TABLE `frontend_news` (
  `frontend_news_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `date_added` int(11) DEFAULT NULL,
  `image` text COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`frontend_news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table general_account
# ------------------------------------------------------------


CREATE TABLE `general_account` (
  `general_account_id` int(11) NOT NULL AUTO_INCREMENT,
  `account_number` longtext COLLATE utf8_unicode_ci,
  `account_name` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `type` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`general_account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table grade
# ------------------------------------------------------------


CREATE TABLE `grade` (
  `grade_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `grade_point` longtext COLLATE utf8_unicode_ci,
  `mark_from` int(11) DEFAULT NULL,
  `mark_upto` int(11) DEFAULT NULL,
  `comment` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`grade_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


# Dump of table inventory
# ------------------------------------------------------------


CREATE TABLE `inventory` (
  `inventory_id` int(11) NOT NULL AUTO_INCREMENT,
  `inventory_category_id` int(11) DEFAULT NULL,
  `name` longtext COLLATE utf8_unicode_ci,
  `quantity` int(10) DEFAULT NULL,
  `end_quantity` int(11) DEFAULT NULL,
  `comment` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`inventory_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table inventory_category
# ------------------------------------------------------------


CREATE TABLE `inventory_category` (
  `inventory_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`inventory_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table invoice
# ------------------------------------------------------------


CREATE TABLE `invoice` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `title` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `amount` int(11) DEFAULT NULL,
  `amount_paid` longtext COLLATE utf8_unicode_ci,
  `due` longtext COLLATE utf8_unicode_ci,
  `creation_timestamp` int(11) DEFAULT NULL,
  `payment_timestamp` longtext COLLATE utf8_unicode_ci,
  `payment_method` longtext COLLATE utf8_unicode_ci,
  `payment_details` longtext COLLATE utf8_unicode_ci,
  `status` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table language
# ------------------------------------------------------------


CREATE TABLE `language` (
  `phrase_id` int(11) NOT NULL AUTO_INCREMENT,
  `phrase` longtext COLLATE utf8_unicode_ci,
  `english` longtext COLLATE utf8_unicode_ci,
  `bengali` longtext COLLATE utf8_unicode_ci,
  `spanish` longtext COLLATE utf8_unicode_ci,
  `arabic` longtext COLLATE utf8_unicode_ci,
  `dutch` longtext COLLATE utf8_unicode_ci,
  `russian` longtext COLLATE utf8_unicode_ci,
  `chinese` longtext COLLATE utf8_unicode_ci,
  `turkish` longtext COLLATE utf8_unicode_ci,
  `portuguese` longtext COLLATE utf8_unicode_ci,
  `hungarian` longtext COLLATE utf8_unicode_ci,
  `french` longtext COLLATE utf8_unicode_ci,
  `greek` longtext COLLATE utf8_unicode_ci,
  `german` longtext COLLATE utf8_unicode_ci,
  `italian` longtext COLLATE utf8_unicode_ci,
  `thai` longtext COLLATE utf8_unicode_ci,
  `urdu` longtext COLLATE utf8_unicode_ci,
  `hindi` longtext COLLATE utf8_unicode_ci,
  `latin` longtext COLLATE utf8_unicode_ci,
  `indonesian` longtext COLLATE utf8_unicode_ci,
  `japanese` longtext COLLATE utf8_unicode_ci,
  `korean` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`phrase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;






# Dump of table leave_request
# ------------------------------------------------------------


CREATE TABLE `leave_request` (
  `leave_id` int(11) NOT NULL AUTO_INCREMENT,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `reason` longtext COLLATE utf8_unicode_ci,
  `remarks` longtext COLLATE utf8_unicode_ci,
  `status` int(1) DEFAULT '0' COMMENT '0=pending, 1=admin apperoved, 2 =hr processed',
  `user_id` int(11) DEFAULT NULL,
  `user_type` longtext COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`leave_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `leave_request` (`leave_id`, `start_date`, `end_date`, `reason`, `remarks`, `status`, `user_id`, `user_type`, `created_at`, `updated_at`, `school_id`)
VALUES
	(2,'2018-01-31','2018-02-02','Irure sunt recusandae Fugit sunt neque quia cupiditate praesentium eu consequatur id','Ad Nam cumque dolores consequatur cupiditate culpa quasi ut unde dolor',1,1,'admin','2018-01-31 13:42:43',NULL,1);



# Dump of table mark
# ------------------------------------------------------------


CREATE TABLE `mark` (
  `mark_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `exam_id` int(11) DEFAULT NULL,
  `mark_obtained` int(11) DEFAULT NULL,
  `mark_total` int(11) DEFAULT NULL,
  `comment` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`mark_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table message
# ------------------------------------------------------------


CREATE TABLE `message` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_thread_code` longtext COLLATE utf8_unicode_ci,
  `message` longtext COLLATE utf8_unicode_ci,
  `sender` longtext COLLATE utf8_unicode_ci,
  `timestamp` longtext COLLATE utf8_unicode_ci,
  `read_status` int(11) DEFAULT NULL,
  `attached_file_name` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `message` (`message_id`, `message_thread_code`, `message`, `sender`, `timestamp`, `read_status`, `attached_file_name`, `school_id`)
VALUES
	(1,'67acdda87cd878c','<p>sdgdsg</p>','admin-1','1519292280',1,NULL,1),
	(2,'67acdda87cd878c','gsdg','admin-1','1519292284',1,NULL,1),
	(3,'67acdda87cd878c','gdsag','admin-1','1519292287',1,NULL,1),
	(4,'67acdda87cd878c','sgsg','admin-1','1519292289',1,NULL,1),
	(5,'67acdda87cd878c','gsadg','admin-1','1519292293',1,NULL,1),
	(6,'67acdda87cd878c','aa','admin-1','1519292497',1,NULL,1),
	(7,'67acdda87cd878c','bb','admin-1','1519292843',1,NULL,1),
	(8,'ad9d749d35a3e49','<p>sadad</p>','admin-1','1522135989',NULL,'BPA.pdf',1),
	(9,'ad9d749d35a3e49','adasd','admin-1','1522135999',NULL,'BPA.pdf',1),
	(10,'9b3e1f96d455906','<p>hello</p>','admin-1','1522139550',NULL,'Business Travel Quotation Request 2.pdf',1);



# Dump of table message_thread
# ------------------------------------------------------------


CREATE TABLE `message_thread` (
  `message_thread_id` int(11) NOT NULL AUTO_INCREMENT,
  `message_thread_code` longtext COLLATE utf8_unicode_ci,
  `sender` longtext COLLATE utf8_unicode_ci,
  `reciever` longtext COLLATE utf8_unicode_ci,
  `last_message_timestamp` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`message_thread_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `message_thread` (`message_thread_id`, `message_thread_code`, `sender`, `reciever`, `last_message_timestamp`, `school_id`)
VALUES
	(1,'67acdda87cd878c','admin-1','teacher-1',NULL,1),
	(2,'ad9d749d35a3e49','admin-1','parent-1',NULL,1),
	(3,'9b3e1f96d455906','admin-1','student-1',NULL,1);



# Dump of table noticeboard
# ------------------------------------------------------------


CREATE TABLE `noticeboard` (
  `notice_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_title` longtext COLLATE utf8_unicode_ci,
  `notice` longtext COLLATE utf8_unicode_ci,
  `create_timestamp` longtext COLLATE utf8_unicode_ci,
  `status` int(11) DEFAULT '1',
  `show_on_website` int(11) DEFAULT '0',
  `image` text COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table notification
# ------------------------------------------------------------


CREATE TABLE `notification` (
  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
  `description` longtext COLLATE utf8_unicode_ci,
  `link` longtext COLLATE utf8_unicode_ci,
  `status` int(1) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `notification` (`notification_id`, `description`, `link`, `status`, `user_id`, `user_type`, `school_id`, `time`)
VALUES
	(1,'New Leave Request','leave_manage',1,0,'admin',1,'2018-01-31 13:42:21'),
	(2,'New Leave Request','leave_manage',1,0,'admin',1,'2018-01-31 13:42:43'),
	(3,'Leave Approved','leave_manage',1,0,'hr',1,'2018-01-31 13:42:59'),
	(4,'New Student Form Created','forms',1,1,'parent',1,'2018-03-25 15:43:01');



# Dump of table payment
# ------------------------------------------------------------


CREATE TABLE `payment` (
  `payment_id` int(11) NOT NULL AUTO_INCREMENT,
  `expense_category_id` int(11) DEFAULT NULL,
  `title` longtext COLLATE utf8_unicode_ci,
  `payment_type` longtext COLLATE utf8_unicode_ci,
  `invoice_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `method` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `amount` longtext COLLATE utf8_unicode_ci,
  `timestamp` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table payroll
# ------------------------------------------------------------


CREATE TABLE `payroll` (
  `payroll_id` int(11) NOT NULL AUTO_INCREMENT,
  `payroll_code` longtext CHARACTER SET latin1,
  `user_id` int(11) DEFAULT NULL,
  `user_type` longtext CHARACTER SET latin1,
  `joining_salary` int(11) DEFAULT NULL,
  `allowances` longtext CHARACTER SET latin1,
  `deductions` longtext CHARACTER SET latin1,
  `date` longtext CHARACTER SET latin1,
  `status` int(11) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`payroll_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `payroll` (`payroll_id`, `payroll_code`, `user_id`, `user_type`, `joining_salary`, `allowances`, `deductions`, `date`, `status`, `school_id`)
VALUES
	(1,'5f84dae',1,'teacher',2000,'[{\"type\":\"aa\",\"amount\":\"23\"},{\"type\":\"bb\",\"amount\":\"23\"}]','[{\"type\":\"ad\",\"amount\":\"3\"},{\"type\":\"bd\",\"amount\":\"4\"}]','3,2018',1,1);



# Dump of table permissions
# ------------------------------------------------------------


CREATE TABLE `permissions` (
  `permission_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `permissions` (`permission_id`, `name`)
VALUES
	(1,'admin'),
	(2,'teacher'),
	(4,'accountant'),
	(5,'librarian'),
	(6,'hr'),
	(7,'driver'),
	(8,'hostel_admin'),
	(9,'general_staff'),
	(10,'transportation_staff');



# Dump of table question_paper
# ------------------------------------------------------------


CREATE TABLE `question_paper` (
  `question_paper_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `question_paper` longtext COLLATE utf8_unicode_ci,
  `class_id` int(11) DEFAULT NULL,
  `exam_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`question_paper_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table roles
# ------------------------------------------------------------


CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
  `permission_id` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `roles` (`role_id`, `name`, `permission_id`, `school_id`)
VALUES
	(1,'Teacher Role',2,1),
	(2,'Transport Staff',10,1),
	(3,'Librarian',5,1),
	(4,'HR',6,1),
	(5,'Accountant',4,1),
	(6,'Hostel Admin',8,1);



# Dump of table room
# ------------------------------------------------------------


CREATE TABLE `room` (
  `room_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `dormitory_id` int(11) DEFAULT NULL,
  `special_needs` longtext COLLATE utf8_unicode_ci,
  `floor` longtext COLLATE utf8_unicode_ci,
  `room_capacity` longtext COLLATE utf8_unicode_ci,
  `room_fee` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `remarks` longtext COLLATE utf8_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1=available, 0=not available',
  `school_id` int(11) NOT NULL,
  PRIMARY KEY (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table room_allocation
# ------------------------------------------------------------


CREATE TABLE `room_allocation` (
  `room_allocation_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) DEFAULT NULL,
  `bed_id` int(11) DEFAULT NULL,
  `allocation_type` longtext COLLATE utf8_unicode_ci,
  `user_type` longtext COLLATE utf8_unicode_ci,
  `payment_status` tinyint(4) DEFAULT '0' COMMENT '1=paid,0=unpaid',
  `user_id` int(11) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  `created_at` longtext COLLATE utf8_unicode_ci,
  `updated_at` longtext COLLATE utf8_unicode_ci,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `remarks` longtext COLLATE utf8_unicode_ci,
  `year` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`room_allocation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table route_vehicle
# ------------------------------------------------------------


CREATE TABLE `route_vehicle` (
  `route_id` int(11) NOT NULL AUTO_INCREMENT,
  `vehicle_id` int(11) NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  `assign_date` date DEFAULT NULL,
  `id` int(11) NOT NULL DEFAULT '0',
  `school_id` int(11) NOT NULL,
  PRIMARY KEY (`route_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table school
# ------------------------------------------------------------


CREATE TABLE `school` (
  `school_id` int(100) NOT NULL AUTO_INCREMENT,
  `school_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `school_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `varification_status` int(10) NOT NULL DEFAULT '0' COMMENT '1(verified) 0(pending)',
  `school_settings` longtext COLLATE utf8_unicode_ci NOT NULL,
  `sms_settings` longtext CHARACTER SET latin1,
  `time_settings` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`school_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `school` (`school_id`, `school_code`, `school_name`, `varification_status`, `school_settings`, `sms_settings`, `time_settings`)
VALUES
	(1,'aaefb29','Demo School',1,'{\"system_name\":\"Ekattor\",\"system_title\":\"Ektoor Title\",\"year\":\"2017-2018\",\"address\":\"\",\"phone\":\"\",\"paypal_email\":\"\",\"currency\":\"\",\"system_email\":\"\",\"language\":\"\",\"text_align\":\"\",\"skin_colour\":\"default\"}','{\"active_sms_service\":\"disabled\",\"clickatell_user\":\"\",\"clickatell_password\":\"\",\"clickatell_api_id\":\"\",\"twilio_account_sid\":\"\",\"twilio_auth_token\":\"\",\"twilio_sender_phone_number\":\"\",\"msg91_authentication_key\":\"\",\"msg91_sender_ID\":\"\",\"msg91_route\":\"\",\"msg91_country_code\":\"\"}','{\"first_working_day\":\"sunday\",\"last_working_day\":\"sunday\",\"start\":\"2:00 PM\",\"end\":\"2:00 PM\"}');



# Dump of table section
# ------------------------------------------------------------


CREATE TABLE `section` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `nick_name` longtext COLLATE utf8_unicode_ci,
  `capacity` longtext COLLATE utf8_unicode_ci,
  `location` longtext COLLATE utf8_unicode_ci,
  `remarks` longtext COLLATE utf8_unicode_ci,
  `class_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `section` (`section_id`, `name`, `nick_name`, `capacity`, `location`, `remarks`, `class_id`, `teacher_id`, `school_id`)
VALUES
	(1,'A',NULL,NULL,NULL,NULL,1,1,1);



# Dump of table settings
# ------------------------------------------------------------


CREATE TABLE `settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` longtext CHARACTER SET latin1,
  `description` longtext CHARACTER SET latin1,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `settings` (`settings_id`, `type`, `description`, `school_id`)
VALUES
	(1,'system_name','Ekattor',NULL),
	(2,'system_title','demo title',NULL),
	(3,'address','Address',NULL),
	(4,'phone','+8012654159',NULL),
	(5,'paypal_email','',NULL),
	(6,'currency','usd',NULL),
	(7,'system_email','school@ekattor.com',NULL),
	(11,'language','english',NULL),
	(12,'text_align','left-to-right',NULL),
	(13,'clickatell_user','',NULL),
	(14,'clickatell_password','',NULL),
	(15,'clickatell_api_id','',NULL),
	(16,'skin_colour','default',NULL),
	(17,'twilio_account_sid','',NULL),
	(18,'twilio_auth_token','',NULL),
	(19,'twilio_sender_phone_number','',NULL),
	(20,'active_sms_service','msg91',NULL),
	(22,'payumoney_merchant_key','',NULL),
	(23,'payumoney_salt_id','',NULL),
	(24,'msg91_authentication_key',NULL,NULL),
	(25,'msg91_sender_ID',NULL,NULL),
	(26,'msg91_route',NULL,NULL),
	(27,'msg91_country_code',NULL,NULL),
	(28,'purchase_code','121314',NULL),
	(29,'running_year','2016-2017',NULL);



# Dump of table staff_appraisal
# ------------------------------------------------------------


CREATE TABLE `staff_appraisal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` longtext COLLATE utf8_unicode_ci NOT NULL,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table staff_attendance
# ------------------------------------------------------------


CREATE TABLE `staff_attendance` (
  `attendance_id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` longtext CHARACTER SET latin1,
  `year` longtext CHARACTER SET latin1,
  `staff_id` int(11) DEFAULT NULL,
  `staff_type` longtext CHARACTER SET latin1,
  `status` int(11) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`attendance_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `staff_attendance` (`attendance_id`, `timestamp`, `year`, `staff_id`, `staff_type`, `status`, `school_id`)
VALUES
	(1,'1524160800','2017-2018',1,'teacher',1,1),
	(2,'1524160800','2017-2018',2,'teacher',1,1),
	(3,'1524160800','2017-2018',1,'accountant',1,1),
	(4,'1524160800','2017-2018',1,'librarian',2,1),
	(5,'1524160800','2017-2018',1,'hostel_admin',1,1),
	(6,'1524160800','2017-2018',1,'transportation_staff',1,1),
	(7,'1524160800','2017-2018',1,'hostel_admin',1,1),
	(8,'1524160800','2017-2018',1,'hr',1,1),
	(9,'1524247200','2017-2018',1,'teacher',0,1),
	(10,'1524247200','2017-2018',2,'teacher',2,1),
	(11,'1524247200','2017-2018',1,'accountant',2,1),
	(12,'1524247200','2017-2018',1,'librarian',2,1),
	(13,'1524247200','2017-2018',1,'hostel_admin',2,1),
	(14,'1524247200','2017-2018',1,'transportation_staff',2,1),
	(15,'1524247200','2017-2018',1,'hostel_admin',2,1),
	(16,'1524247200','2017-2018',1,'hr',2,1);



# Dump of table subject
# ------------------------------------------------------------


CREATE TABLE `subject` (
  `subject_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext COLLATE utf8_unicode_ci,
  `class_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `year` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `subject` (`subject_id`, `name`, `class_id`, `teacher_id`, `year`, `school_id`)
VALUES
	(1,'Maths',1,1,'2017-2018',1),
	(2,'English',1,2,'2017-2018',1);



# Dump of table teacher_appraisal
# ------------------------------------------------------------


CREATE TABLE `teacher_appraisal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table transport
# ------------------------------------------------------------


CREATE TABLE `transport` (
  `transport_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_name` longtext COLLATE utf8_unicode_ci,
  `number_of_vehicle` longtext COLLATE utf8_unicode_ci,
  `description` longtext COLLATE utf8_unicode_ci,
  `route_fare` longtext COLLATE utf8_unicode_ci,
  `school_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`transport_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


INSERT INTO `transport` (`transport_id`, `route_name`, `number_of_vehicle`, `description`, `route_fare`, `school_id`)
VALUES
	(1,'Dhaka To Kolkata','3','fa','42',1);



# Dump of table vehicle
# ------------------------------------------------------------


CREATE TABLE `vehicle` (
  `vehicle_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext COLLATE utf8_unicode_ci,
  `vehicle_plate_number` longtext COLLATE utf8_unicode_ci,
  `registration_expiry_date` date DEFAULT NULL,
  `model` longtext COLLATE utf8_unicode_ci,
  `model_year` longtext COLLATE utf8_unicode_ci,
  `seating_capacity` longtext COLLATE utf8_unicode_ci,
  `owner_name` longtext COLLATE utf8_unicode_ci,
  `owner_contact_number` longtext COLLATE utf8_unicode_ci,
  `remarks` longtext COLLATE utf8_unicode_ci,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`vehicle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table vehicle_driver
# ------------------------------------------------------------


CREATE TABLE `vehicle_driver` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vehicle_id` int(11) DEFAULT NULL,
  `driver_id` int(11) DEFAULT NULL,
  `assign_date` date DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



# Dump of table vehicle_student
# ------------------------------------------------------------


CREATE TABLE `vehicle_student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `vehicle_id` int(11) DEFAULT NULL,
  `assign_date` date DEFAULT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  `route_id` int(11) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;




