-- phpMyAdmin SQL Dump -- version 4.0.4.1 -- http://www.phpmyadmin.net -- -- 主機: 127.0.0.1 -- 產生日期: 2014 年 01 月 31 日 06:47 -- 伺服器版本: 5.5.32 -- PHP 版本: 5.4.16 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 資料庫: `pathways` -- CREATE DATABASE IF NOT EXISTS `pathways` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `pathways`; -- -------------------------------------------------------- -- -- 表的結構 `additional_aspect` -- CREATE TABLE IF NOT EXISTS `additional_aspect` ( `aspect_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `aspect_name` varchar(500) NOT NULL, PRIMARY KEY (`aspect_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ; -- -- 轉存資料表中的資料 `additional_aspect` -- INSERT INTO `additional_aspect` (`aspect_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `aspect_name`) VALUES (1, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 10, 'Average IQ'), (2, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 20, 'Low average IQ'), (3, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, 'High average IQ'), (4, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, 'Superior IQ'), (5, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, 'Very superior IQ'), (6, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 60, 'Limited intelligence'), (7, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 70, 'Mild grade MR'), (8, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 80, 'Moderate grade MR'); -- -------------------------------------------------------- -- -- 表的結構 `assessor` -- CREATE TABLE IF NOT EXISTS `assessor` ( `assessor_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `assessor` varchar(500) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`assessor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `attendance` -- CREATE TABLE IF NOT EXISTS `attendance` ( `attend_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `staff_id` int(10) unsigned DEFAULT NULL, `stu_linking_id` int(10) DEFAULT NULL COMMENT 'LINKING ID', `date` date NOT NULL, `attendance` tinyint(1) NOT NULL, `in_time` time DEFAULT NULL, `out_time` time DEFAULT NULL, `reason` varchar(500) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`attend_id`), KEY `fk_mis_attendance_staff_id_idx` (`staff_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- 轉存資料表中的資料 `attendance` -- INSERT INTO `attendance` (`attend_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `staff_id`, `stu_linking_id`, `date`, `attendance`, `in_time`, `out_time`, `reason`) VALUES (1, 1, '2013-12-12 09:49:38', 1, '2013-12-12 09:49:38', 1, 0, 1, NULL, '2013-12-12', 1, '06:00:00', '07:00:00', ''); -- -------------------------------------------------------- -- -- 表的結構 `campus` -- CREATE TABLE IF NOT EXISTS `campus` ( `campus_id` int(10) NOT NULL AUTO_INCREMENT, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `campus_name` varchar(500) CHARACTER SET utf8 NOT NULL, `address` longtext CHARACTER SET utf8 NOT NULL, `cam_short_form` varchar(2) NOT NULL, PRIMARY KEY (`campus_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `campus` -- INSERT INTO `campus` (`campus_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `campus_name`, `address`, `cam_short_form`) VALUES (1, 0, '0000-00-00 00:00:00', 4, '2013-06-24 16:06:21', 1, 0, 1, '沙田教育中心', '沙田', 'ST'), (2, 0, '0000-00-00 00:00:00', 2, '2013-07-02 10:24:34', 1, 0, 2, '九龍', '九龍', 'KL'); -- -------------------------------------------------------- -- -- 表的結構 `diagnose` -- CREATE TABLE IF NOT EXISTS `diagnose` ( `diagnose_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `diagnose_name` varchar(500) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`diagnose_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ; -- -- 轉存資料表中的資料 `diagnose` -- INSERT INTO `diagnose` (`diagnose_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `diagnose_name`) VALUES (1, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 10, 'Dyslexia'), (2, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 20, 'Math LD'), (3, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, 'Borderline Dyslexia'), (4, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, 'Borderline Math LD'), (5, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, 'Suspected Dyslexia'), (6, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 60, 'Suspected Math LD'), (7, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 70, 'Attention deficit and hyperactivity disorder'), (8, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 80, 'Attention deficit disorder without hyperactivity'), (9, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 90, 'Attention deficit and hyperactivity problem'), (10, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 100, 'Attention deficit problem without hyperactivity'), (11, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 110, 'Borderline Developmental Delay (preschool)'), (12, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 120, 'Specific language impairment'), (13, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 130, 'Childhood autism'), (14, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 140, 'Autistic features'), (15, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 150, 'Asperger Syndrome'), (16, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 160, 'Developmental Coordination Disorder'), (17, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 170, 'Problems related to upbrining or other psychosocia'), (18, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 180, 'Behaviour and emotional disorders'), (19, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 190, 'Visual Impairment'), (20, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 200, 'Hearing Impairment'), (21, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 210, 'Mental Retardation'), (22, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 220, 'At risk dyslexia'); -- -------------------------------------------------------- -- -- 表的結構 `district` -- CREATE TABLE IF NOT EXISTS `district` ( `district_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `district` varchar(500) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`district_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ; -- -- 轉存資料表中的資料 `district` -- INSERT INTO `district` (`district_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `district`) VALUES (1, 0, '0000-00-00 00:00:00', 2, '2013-07-04 13:54:32', 1, 0, 1, '葵青區'), (2, 0, '0000-00-00 00:00:00', 2, '2013-07-04 13:54:32', 1, 0, 2, '油尖旺'), (3, 2, '2013-06-28 16:48:27', 2, '2013-07-04 13:54:32', 1, 0, 3, '離島'), (4, 2, '2013-06-28 16:48:34', 2, '2013-06-28 16:48:46', 1, 1, 5, 'TEST2'); -- -------------------------------------------------------- -- -- 表的結構 `event` -- CREATE TABLE IF NOT EXISTS `event` ( `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `event_code` varchar(500) CHARACTER SET utf8 NOT NULL, `program_id` int(10) unsigned NOT NULL, `subject_id` int(10) unsigned NOT NULL, `class_size` int(10) NOT NULL, `programme_fee_type` int(10) NOT NULL, `primary_individual_price` decimal(18,1) DEFAULT NULL, `primary_group_price` decimal(18,1) DEFAULT NULL, `primary_package_price` decimal(18,1) DEFAULT NULL, `secondary_individual_price` decimal(18,1) DEFAULT NULL, `secondary_group_price` decimal(18,1) DEFAULT NULL, `secondary_package_price` decimal(18,1) DEFAULT NULL, `package_discount` decimal(18,1) DEFAULT NULL, `sec_package_discount` decimal(18,1) DEFAULT NULL, `is_free` tinyint(1) NOT NULL, PRIMARY KEY (`event_id`), KEY `fk_mis_event_subject_id_idx` (`subject_id`), KEY `fk_mis_event_program_id_idx` (`program_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ; -- -- 轉存資料表中的資料 `event` -- INSERT INTO `event` (`event_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `event_code`, `program_id`, `subject_id`, `class_size`, `programme_fee_type`, `primary_individual_price`, `primary_group_price`, `primary_package_price`, `secondary_individual_price`, `secondary_group_price`, `secondary_package_price`, `package_discount`, `sec_package_discount`, `is_free`) VALUES (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 'iscg1314-01', 1, 1, 2, 0, '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 0), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 'iseg1314-01', 1, 2, 2, 0, '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 0), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 'ismg1314-01', 1, 3, 2, 2, '0.0', '0.0', NULL, '0.0', '0.0', '300.0', NULL, NULL, 0), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 'ascg1314-01', 2, 1, 1, 1, '1.0', '2.0', '0.0', '3.0', '4.0', '0.0', '0.0', '0.0', 0), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 'iseg1314-02', 1, 2, 1, 2, '0.0', '0.0', NULL, '0.0', '0.0', '3.0', NULL, NULL, 0), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 'iscg1314-02', 1, 1, 6, 0, '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', 0), (7, 1, '2014-01-29 05:36:09', 1, '2014-01-29 05:36:09', 1, 0, 'iscg1314-02', 1, 1, 7, 1, '1.0', '2.0', '0.0', '3.0', '4.0', '0.0', '0.0', '0.0', 0); -- -------------------------------------------------------- -- -- 表的結構 `event_lesson` -- CREATE TABLE IF NOT EXISTS `event_lesson` ( `event_id` int(10) NOT NULL, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `lesson_id` int(10) NOT NULL, PRIMARY KEY (`event_id`,`lesson_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- 轉存資料表中的資料 `event_lesson` -- INSERT INTO `event_lesson` (`event_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `lesson_id`) VALUES (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 1), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 2), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 3), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 4), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 5), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 6), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 7), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 8), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 9), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 10), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 11), (1, 1, '2014-01-29 05:22:59', 1, '2014-01-29 05:22:59', 1, 0, 12), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 13), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 14), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 15), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 16), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 17), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 18), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 19), (2, 1, '2014-01-29 05:24:29', 1, '2014-01-29 05:24:29', 1, 0, 20), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 21), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 22), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 23), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 24), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 25), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 26), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 27), (3, 1, '2014-01-29 05:25:32', 1, '2014-01-29 05:39:58', 1, 1, 28), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 29), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 30), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 31), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 32), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 33), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 34), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 35), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 36), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 37), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 38), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 39), (4, 1, '2014-01-29 05:31:18', 1, '2014-01-29 05:31:18', 1, 0, 40), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 41), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 42), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 43), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 44), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 45), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 46), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 47), (5, 1, '2014-01-29 05:32:59', 1, '2014-01-29 05:32:59', 1, 0, 48), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 49), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 50), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 51), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 52), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 53), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 54), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 55), (6, 1, '2014-01-29 05:33:55', 1, '2014-01-29 05:35:31', 1, 1, 56), (7, 1, '2014-01-29 05:36:09', 1, '2014-01-29 05:36:09', 1, 0, 57), (7, 1, '2014-01-29 05:36:09', 1, '2014-01-29 05:36:09', 1, 0, 58), (7, 1, '2014-01-29 05:36:09', 1, '2014-01-29 05:36:09', 1, 0, 59), (7, 1, '2014-01-29 05:36:09', 1, '2014-01-29 05:36:09', 1, 0, 60), (7, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:42', 1, 0, 61), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 21), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 22), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 23), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 24), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 25), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 26), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 27), (8, 0, '2014-01-29 05:39:58', 0, '2014-01-29 05:39:58', 1, 0, 28), (9, 1, '2014-01-29 05:43:26', 1, '2014-01-29 05:43:26', 1, 0, 62), (9, 1, '2014-01-29 05:43:26', 1, '2014-01-29 05:43:26', 1, 0, 63), (9, 1, '2014-01-29 05:43:26', 1, '2014-01-29 05:43:26', 1, 0, 64), (10, 1, '2014-01-29 05:44:08', 1, '2014-01-29 05:44:08', 1, 0, 65), (10, 1, '2014-01-29 05:44:08', 1, '2014-01-29 05:44:08', 1, 0, 66), (10, 1, '2014-01-29 05:44:08', 1, '2014-01-29 05:44:08', 1, 0, 67), (11, 1, '2014-01-29 05:46:20', 1, '2014-01-29 05:46:20', 1, 0, 68), (11, 1, '2014-01-29 05:46:20', 1, '2014-01-29 05:46:20', 1, 0, 69), (11, 1, '2014-01-29 05:46:20', 1, '2014-01-29 05:46:20', 1, 0, 70); -- -------------------------------------------------------- -- -- 表的結構 `event_stu_list` -- CREATE TABLE IF NOT EXISTS `event_stu_list` ( `eve_stu_id` int(10) NOT NULL AUTO_INCREMENT, `event_id` int(10) NOT NULL, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `stu_linking_id` int(10) NOT NULL, PRIMARY KEY (`eve_stu_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `event_teach_list` -- CREATE TABLE IF NOT EXISTS `event_teach_list` ( `event_teach_id` int(10) NOT NULL AUTO_INCREMENT, `event_id` int(10) NOT NULL, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `staff_id` int(10) NOT NULL, PRIMARY KEY (`event_teach_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `grade` -- CREATE TABLE IF NOT EXISTS `grade` ( `grade_id` int(10) NOT NULL AUTO_INCREMENT, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `grade` varchar(50) NOT NULL, PRIMARY KEY (`grade_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `grade` -- INSERT INTO `grade` (`grade_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `grade`) VALUES (1, 0, '2013-11-15 00:00:00', 0, '2013-11-15 00:00:00', 1, 0, 'P1'), (2, 0, '2013-11-23 00:00:00', 0, '2013-11-23 00:00:00', 1, 0, 'P2'); -- -------------------------------------------------------- -- -- 表的結構 `invoice` -- CREATE TABLE IF NOT EXISTS `invoice` ( `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `stu_linking_id` int(10) NOT NULL, `code` varchar(500) CHARACTER SET utf8 NOT NULL, `remarks` longtext CHARACTER SET utf8, `subsidy_type` int(11) DEFAULT NULL, PRIMARY KEY (`invoice_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- 轉存資料表中的資料 `invoice` -- INSERT INTO `invoice` (`invoice_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `stu_linking_id`, `code`, `remarks`, `subsidy_type`) VALUES (1, 0, '2014-01-26 02:26:21', 0, '2014-01-26 02:26:21', 1, 0, 8888, 'PIS0002', '', 2); -- -------------------------------------------------------- -- -- 表的結構 `invoice_line` -- CREATE TABLE IF NOT EXISTS `invoice_line` ( `invoice_line_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `invoice_id` int(10) unsigned NOT NULL, `student_linking_id` int(10) unsigned NOT NULL, `event_programme_fee_type` int(10) NOT NULL, `amount` decimal(18,1) NOT NULL, `original_fee` decimal(18,1) NOT NULL, `discounted_fee` decimal(18,1) NOT NULL, `hour` decimal(18,1) NOT NULL, `subsidy_percent` int(10) NOT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`invoice_line_id`), KEY `fk_mis_invoice_line_invoice_id_idx` (`invoice_id`), KEY `fk_mis_invoice_line_lesson_student_id_idx` (`student_linking_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- 轉存資料表中的資料 `invoice_line` -- INSERT INTO `invoice_line` (`invoice_line_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `invoice_id`, `student_linking_id`, `event_programme_fee_type`, `amount`, `original_fee`, `discounted_fee`, `hour`, `subsidy_percent`, `remarks`) VALUES (1, 0, '2014-01-26 02:26:21', 0, '2014-01-26 02:26:21', 1, 0, 1, 8888, 1, '4.0', '10.0', '6.0', '0.0', 40, ''); -- -------------------------------------------------------- -- -- 表的結構 `leave_app` -- CREATE TABLE IF NOT EXISTS `leave_app` ( `leave_id` int(10) NOT NULL AUTO_INCREMENT, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `staff_id` int(10) DEFAULT NULL, `stu_linking_id` int(10) DEFAULT NULL, `leave_date` date NOT NULL, `is_full_day` tinyint(1) NOT NULL, `event_id` int(10) DEFAULT NULL, `is_sick` tinyint(1) NOT NULL, `reason` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `approve_by` int(10) DEFAULT NULL, `is_approve` tinyint(1) NOT NULL, `remarks` varchar(500) NOT NULL, PRIMARY KEY (`leave_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `lesson` -- CREATE TABLE IF NOT EXISTS `lesson` ( `lesson_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `room_id` varchar(10) CHARACTER SET utf8 NOT NULL, `date` date NOT NULL, `start_time` time NOT NULL, `end_time` time NOT NULL, `upload_file` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `remarks` longtext CHARACTER SET utf8, `state` varchar(500) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`lesson_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=71 ; -- -- 轉存資料表中的資料 `lesson` -- INSERT INTO `lesson` (`lesson_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `room_id`, `date`, `start_time`, `end_time`, `upload_file`, `remarks`, `state`) VALUES (1, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-03', '09:00:00', '10:00:00', NULL, '0', ''), (2, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-05', '09:00:00', '10:00:00', NULL, '0', ''), (3, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-07', '09:00:00', '10:00:00', NULL, '0', ''), (4, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-10', '09:00:00', '10:00:00', NULL, '0', ''), (5, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-12', '09:00:00', '10:00:00', NULL, '0', ''), (6, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-14', '09:00:00', '10:00:00', NULL, '0', ''), (7, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-17', '09:00:00', '10:00:00', NULL, '0', ''), (8, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-19', '09:00:00', '10:00:00', NULL, '0', ''), (9, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-21', '09:00:00', '10:00:00', NULL, '0', ''), (10, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-24', '09:00:00', '10:00:00', NULL, '0', ''), (11, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-26', '09:00:00', '10:00:00', NULL, '0', ''), (12, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 0, 'KLN001', '2014-02-28', '09:00:00', '10:00:00', NULL, '0', ''), (13, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-04', '12:00:00', '13:00:00', NULL, '0', ''), (14, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-06', '12:00:00', '13:00:00', NULL, '0', ''), (15, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-11', '12:00:00', '13:00:00', NULL, '0', ''), (16, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-13', '12:00:00', '13:00:00', NULL, '0', ''), (17, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-18', '12:00:00', '13:00:00', NULL, '0', ''), (18, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-20', '12:00:00', '13:00:00', NULL, '0', ''), (19, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-25', '12:00:00', '13:00:00', NULL, '0', ''), (20, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 0, 'ST001', '2014-02-27', '12:00:00', '13:00:00', NULL, '0', ''), (21, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'ST002', '2014-02-01', '18:00:00', '19:00:00', NULL, '0', ''), (22, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'KLN002', '2014-02-02', '18:30:00', '19:30:00', NULL, '0', ''), (23, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'ST002', '2014-02-08', '18:00:00', '19:00:00', NULL, '0', ''), (24, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'KLN002', '2014-02-09', '18:30:00', '19:30:00', NULL, '0', ''), (25, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'ST002', '2014-02-15', '18:00:00', '19:00:00', NULL, '0', ''), (26, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'KLN002', '2014-02-16', '18:30:00', '19:30:00', NULL, '0', ''), (27, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'ST002', '2014-02-22', '18:00:00', '19:00:00', NULL, '0', ''), (28, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 'KLN002', '2014-02-23', '18:30:00', '19:30:00', NULL, '0', ''), (29, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-03', '11:15:00', '12:35:00', NULL, '0', ''), (30, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-05', '11:15:00', '12:35:00', NULL, '0', ''), (31, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-07', '11:15:00', '12:35:00', NULL, '0', ''), (32, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-10', '11:15:00', '12:35:00', NULL, '0', ''), (33, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-12', '11:15:00', '12:35:00', NULL, '0', ''), (34, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-14', '11:15:00', '12:35:00', NULL, '0', ''), (35, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-17', '11:15:00', '12:35:00', NULL, '0', ''), (36, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-19', '11:15:00', '12:35:00', NULL, '0', ''), (37, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-21', '11:15:00', '12:35:00', NULL, '0', ''), (38, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-24', '11:15:00', '12:35:00', NULL, '0', ''), (39, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-26', '11:15:00', '12:35:00', NULL, '0', ''), (40, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 0, 'KLN002', '2014-02-28', '11:15:00', '12:35:00', NULL, '0', ''), (41, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-04', '09:00:00', '09:40:00', NULL, '1', ''), (42, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-06', '09:00:00', '09:40:00', NULL, '1', ''), (43, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-11', '09:00:00', '09:40:00', NULL, '1', ''), (44, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-13', '09:00:00', '09:40:00', NULL, '1', ''), (45, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-18', '09:00:00', '09:40:00', NULL, '1', ''), (46, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-20', '09:00:00', '09:40:00', NULL, '1', ''), (47, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-25', '09:00:00', '09:40:00', NULL, '1', ''), (48, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 'ST002', '2014-02-27', '09:00:00', '09:40:00', NULL, '1', ''), (49, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-04', '06:00:00', '07:50:00', NULL, '0', ''), (50, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-06', '06:00:00', '07:50:00', NULL, '0', ''), (51, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-11', '06:00:00', '07:50:00', NULL, '0', ''), (52, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-13', '06:00:00', '07:50:00', NULL, '0', ''), (53, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-18', '06:00:00', '07:50:00', NULL, '0', ''), (54, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-20', '06:00:00', '07:50:00', NULL, '0', ''), (55, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-25', '06:00:00', '07:50:00', NULL, '0', ''), (56, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 'ST002', '2014-02-27', '06:00:00', '07:50:00', NULL, '0', ''), (57, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 0, 'KLN002', '2014-02-02', '21:45:00', '22:00:00', NULL, '1', ''), (58, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 0, 'KLN002', '2014-02-09', '21:45:00', '22:00:00', NULL, '1', ''), (59, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 0, 'KLN002', '2014-02-16', '21:45:00', '22:00:00', NULL, '1', ''), (60, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 0, 'KLN002', '2014-02-23', '21:45:00', '22:00:00', NULL, '1', ''), (61, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 0, 'KLN002', '2014-03-01', '08:00:00', '09:20:00', NULL, '0', ''), (62, 0, '2014-01-29 05:43:26', 0, '2014-01-29 05:43:26', 1, 0, 'KLN001', '2014-02-03', '06:00:00', '06:15:00', NULL, '0', ''), (63, 0, '2014-01-29 05:43:26', 0, '2014-01-29 05:43:26', 1, 0, 'KLN001', '2014-02-10', '06:00:00', '06:15:00', NULL, '0', ''), (64, 0, '2014-01-29 05:43:26', 0, '2014-01-29 05:43:26', 1, 0, 'KLN001', '2014-02-17', '06:00:00', '06:15:00', NULL, '0', ''), (65, 0, '2014-01-29 05:44:08', 0, '2014-01-29 05:44:08', 1, 0, 'KLN001', '2014-02-03', '06:00:00', '06:15:00', NULL, '0', ''), (66, 0, '2014-01-29 05:44:08', 0, '2014-01-29 05:44:08', 1, 0, 'KLN001', '2014-02-10', '06:00:00', '06:15:00', NULL, '0', ''), (67, 0, '2014-01-29 05:44:08', 0, '2014-01-29 05:44:08', 1, 0, 'KLN001', '2014-02-17', '06:00:00', '06:15:00', NULL, '0', ''), (68, 0, '2014-01-29 05:46:20', 0, '2014-01-29 05:46:20', 1, 0, 'KLN001', '2014-02-03', '06:00:00', '06:15:00', NULL, '0', ''), (69, 0, '2014-01-29 05:46:20', 0, '2014-01-29 05:46:20', 1, 0, 'KLN001', '2014-02-10', '06:00:00', '06:15:00', NULL, '0', ''), (70, 0, '2014-01-29 05:46:20', 0, '2014-01-29 05:46:20', 1, 0, 'KLN001', '2014-02-17', '06:00:00', '06:15:00', NULL, '0', ''); -- -------------------------------------------------------- -- -- 表的結構 `lesson_attendance` -- CREATE TABLE IF NOT EXISTS `lesson_attendance` ( `attend_id` int(10) NOT NULL AUTO_INCREMENT, `lesson_id` int(10) NOT NULL, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `stu_linking_id` int(10) DEFAULT NULL, `staff_id` int(10) DEFAULT NULL, `attendance` tinyint(1) NOT NULL, `date` date NOT NULL, `in_time` time DEFAULT NULL, `out_time` time DEFAULT NULL, `reason` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `rate` decimal(18,1) NOT NULL, `payroll_gened` tinyint(1) DEFAULT NULL, `invoice_gened` tinyint(1) DEFAULT NULL, PRIMARY KEY (`attend_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=622 ; -- -- 轉存資料表中的資料 `lesson_attendance` -- INSERT INTO `lesson_attendance` (`attend_id`, `lesson_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `stu_linking_id`, `staff_id`, `attendance`, `date`, `in_time`, `out_time`, `reason`, `rate`, `payroll_gened`, `invoice_gened`) VALUES (1, 1, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (2, 2, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (3, 3, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (4, 4, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (5, 5, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (6, 6, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (7, 7, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (8, 8, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (9, 9, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (10, 10, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (11, 11, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (12, 12, 0, '2014-01-29 05:22:59', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (13, 1, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (14, 1, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (15, 1, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (16, 2, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (17, 2, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (18, 2, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (19, 3, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (20, 3, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (21, 3, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (22, 4, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (23, 4, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (24, 4, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (25, 5, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (26, 5, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (27, 5, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (28, 6, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (29, 6, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (30, 6, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (31, 7, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (32, 7, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (33, 7, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (34, 8, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (35, 8, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (36, 8, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (37, 9, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (38, 9, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (39, 9, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (40, 10, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (41, 10, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (42, 10, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (43, 11, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (44, 11, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (45, 11, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (46, 12, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (47, 12, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (48, 12, 0, '2014-01-29 05:23:06', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (49, 1, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (50, 1, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (51, 2, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (52, 2, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (53, 3, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (54, 3, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (55, 4, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (56, 4, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (57, 5, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (58, 5, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (59, 6, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (60, 6, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (61, 7, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (62, 7, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (63, 8, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (64, 8, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (65, 9, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (66, 9, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (67, 10, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (68, 10, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (69, 11, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (70, 11, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (71, 12, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (72, 12, 0, '2014-01-29 05:23:16', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (73, 1, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (74, 1, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (75, 1, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (76, 1, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (77, 1, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (78, 2, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (79, 2, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (80, 2, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (81, 2, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (82, 2, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (83, 3, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (84, 3, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (85, 3, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (86, 3, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (87, 3, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (88, 4, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (89, 4, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (90, 4, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (91, 4, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (92, 4, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (93, 5, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (94, 5, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (95, 5, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (96, 5, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (97, 5, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (98, 6, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (99, 6, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (100, 6, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (101, 6, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (102, 6, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (103, 7, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (104, 7, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (105, 7, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (106, 7, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (107, 7, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (108, 8, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (109, 8, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (110, 8, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (111, 8, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (112, 8, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (113, 9, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (114, 9, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (115, 9, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (116, 9, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (117, 9, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (118, 10, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (119, 10, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (120, 10, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (121, 10, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (122, 10, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (123, 11, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (124, 11, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (125, 11, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (126, 11, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (127, 11, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (128, 12, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (129, 12, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (130, 12, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (131, 12, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (132, 12, 0, '2014-01-29 05:23:18', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (133, 1, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (134, 1, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (135, 2, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (136, 2, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (137, 3, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (138, 3, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (139, 4, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (140, 4, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (141, 5, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (142, 5, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (143, 6, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (144, 6, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (145, 7, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (146, 7, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (147, 8, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (148, 8, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (149, 9, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (150, 9, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (151, 10, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (152, 10, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (153, 11, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (154, 11, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (155, 12, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (156, 12, 0, '2014-01-29 05:23:30', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (157, 1, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (158, 1, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (159, 1, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (160, 1, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (161, 1, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (162, 2, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (163, 2, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (164, 2, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (165, 2, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (166, 2, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (167, 3, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (168, 3, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (169, 3, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (170, 3, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (171, 3, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (172, 4, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (173, 4, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (174, 4, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (175, 4, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (176, 4, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (177, 5, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (178, 5, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (179, 5, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (180, 5, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (181, 5, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (182, 6, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (183, 6, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (184, 6, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (185, 6, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (186, 6, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (187, 7, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (188, 7, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (189, 7, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (190, 7, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (191, 7, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (192, 8, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (193, 8, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (194, 8, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (195, 8, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (196, 8, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (197, 9, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (198, 9, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (199, 9, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (200, 9, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (201, 9, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (202, 10, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (203, 10, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (204, 10, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (205, 10, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (206, 10, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (207, 11, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (208, 11, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (209, 11, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (210, 11, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (211, 11, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (212, 12, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (213, 12, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (214, 12, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (215, 12, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (216, 12, 0, '2014-01-29 05:23:31', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (217, 13, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (218, 13, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (219, 14, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (220, 14, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (221, 15, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (222, 15, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (223, 16, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (224, 16, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (225, 17, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (226, 17, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (227, 18, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (228, 18, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (229, 19, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (230, 19, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (231, 20, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (232, 20, 0, '2014-01-29 05:24:29', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (233, 13, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (234, 13, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (235, 13, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (236, 13, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (237, 13, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (238, 14, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (239, 14, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (240, 14, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (241, 14, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (242, 14, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (243, 15, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (244, 15, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (245, 15, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (246, 15, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (247, 15, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (248, 16, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (249, 16, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (250, 16, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (251, 16, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (252, 16, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (253, 17, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (254, 17, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (255, 17, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (256, 17, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (257, 17, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (258, 18, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (259, 18, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (260, 18, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (261, 18, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (262, 18, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (263, 19, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (264, 19, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (265, 19, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (266, 19, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (267, 19, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (268, 20, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (269, 20, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (270, 20, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (271, 20, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (272, 20, 0, '2014-01-29 05:24:31', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (273, 21, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (274, 21, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (275, 21, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (276, 21, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (277, 22, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (278, 22, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (279, 22, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (280, 22, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (281, 23, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-08', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (282, 23, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-08', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (283, 23, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-08', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (284, 23, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-08', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (285, 24, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (286, 24, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (287, 24, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (288, 24, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (289, 25, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-15', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (290, 25, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-15', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (291, 25, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-15', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (292, 25, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-15', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (293, 26, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (294, 26, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (295, 26, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (296, 26, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (297, 27, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-22', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (298, 27, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-22', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (299, 27, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-22', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (300, 27, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-22', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (301, 28, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 1, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (302, 28, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, NULL, 2, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (303, 28, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 123, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (304, 28, 0, '2014-01-29 05:25:32', 0, '2014-01-29 05:25:32', 1, 0, 12345, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (305, 1, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (306, 1, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (307, 2, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (308, 2, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (309, 3, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (310, 3, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (311, 4, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (312, 4, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (313, 5, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (314, 5, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (315, 6, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (316, 6, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (317, 7, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (318, 7, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (319, 8, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (320, 8, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (321, 9, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (322, 9, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (323, 10, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (324, 10, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (325, 11, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (326, 11, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (327, 12, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (328, 12, 0, '2014-01-29 05:27:33', 0, '2014-01-29 05:27:35', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (329, 1, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (330, 1, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (331, 2, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (332, 2, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (333, 3, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (334, 3, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (335, 4, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (336, 4, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (337, 5, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (338, 5, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (339, 6, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (340, 6, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (341, 7, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (342, 7, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (343, 8, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (344, 8, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (345, 9, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (346, 9, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (347, 10, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL); INSERT INTO `lesson_attendance` (`attend_id`, `lesson_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `stu_linking_id`, `staff_id`, `attendance`, `date`, `in_time`, `out_time`, `reason`, `rate`, `payroll_gened`, `invoice_gened`) VALUES (348, 10, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (349, 11, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (350, 11, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (351, 12, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, 123, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (352, 12, 0, '2014-01-29 05:27:35', 0, '2014-01-29 05:27:35', 1, 0, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (353, 13, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (354, 13, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (355, 14, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (356, 14, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (357, 15, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (358, 15, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (359, 16, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (360, 16, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (361, 17, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (362, 17, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (363, 18, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (364, 18, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (365, 19, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (366, 19, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (367, 20, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (368, 20, 0, '2014-01-29 05:27:45', 0, '2014-01-29 05:27:47', 1, 1, NULL, 2, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (369, 13, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (370, 13, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (371, 14, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (372, 14, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (373, 15, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (374, 15, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (375, 16, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (376, 16, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (377, 17, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (378, 17, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (379, 18, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (380, 18, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (381, 19, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (382, 19, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (383, 20, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (384, 20, 0, '2014-01-29 05:27:47', 0, '2014-01-29 05:27:47', 1, 0, NULL, 2, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (385, 29, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (386, 30, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (387, 31, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (388, 32, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (389, 33, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (390, 34, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (391, 35, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (392, 36, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (393, 37, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (394, 38, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (395, 39, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (396, 40, 0, '2014-01-29 05:31:18', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (397, 29, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (398, 29, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (399, 29, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (400, 30, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (401, 30, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (402, 30, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (403, 31, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (404, 31, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (405, 31, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (406, 32, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (407, 32, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (408, 32, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (409, 33, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (410, 33, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (411, 33, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (412, 34, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (413, 34, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (414, 34, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (415, 35, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (416, 35, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (417, 35, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (418, 36, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (419, 36, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (420, 36, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (421, 37, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (422, 37, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (423, 37, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (424, 38, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (425, 38, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (426, 38, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (427, 39, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (428, 39, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (429, 39, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (430, 40, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (431, 40, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (432, 40, 0, '2014-01-29 05:31:29', 0, '2014-01-29 05:31:55', 1, 1, NULL, 2, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (433, 29, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (434, 29, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (435, 29, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-03', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (436, 30, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (437, 30, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (438, 30, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-05', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (439, 31, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (440, 31, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (441, 31, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-07', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (442, 32, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (443, 32, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (444, 32, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-10', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (445, 33, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (446, 33, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (447, 33, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-12', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (448, 34, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (449, 34, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (450, 34, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-14', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (451, 35, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (452, 35, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (453, 35, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-17', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (454, 36, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (455, 36, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (456, 36, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-19', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (457, 37, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (458, 37, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (459, 37, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-21', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (460, 38, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (461, 38, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (462, 38, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-24', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (463, 39, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (464, 39, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (465, 39, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-26', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (466, 40, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, 12345, NULL, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (467, 40, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 1, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (468, 40, 0, '2014-01-29 05:31:55', 0, '2014-01-29 05:31:55', 1, 0, NULL, 2, 1, '2014-02-28', '00:00:00', '00:00:00', NULL, '1.0', NULL, NULL), (469, 41, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (470, 41, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (471, 42, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (472, 42, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (473, 43, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (474, 43, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (475, 44, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (476, 44, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (477, 45, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (478, 45, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (479, 46, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (480, 46, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (481, 47, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (482, 47, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (483, 48, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (484, 48, 0, '2014-01-29 05:32:59', 0, '2014-01-29 05:32:59', 1, 0, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (485, 49, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (486, 49, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (487, 50, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (488, 50, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (489, 51, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (490, 51, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (491, 52, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (492, 52, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (493, 53, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (494, 53, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (495, 54, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (496, 54, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (497, 55, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (498, 55, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (499, 56, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (500, 56, 0, '2014-01-29 05:33:55', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (501, 49, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (502, 49, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (503, 49, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (504, 49, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (505, 50, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (506, 50, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (507, 50, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (508, 50, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (509, 51, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (510, 51, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (511, 51, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (512, 51, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (513, 52, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (514, 52, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (515, 52, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (516, 52, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (517, 53, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (518, 53, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (519, 53, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (520, 53, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (521, 54, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (522, 54, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (523, 54, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (524, 54, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (525, 55, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (526, 55, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (527, 55, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (528, 55, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (529, 56, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (530, 56, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (531, 56, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (532, 56, 0, '2014-01-29 05:34:02', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (533, 49, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (534, 49, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (535, 49, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (536, 49, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-04', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (537, 50, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (538, 50, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (539, 50, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (540, 50, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-06', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (541, 51, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (542, 51, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (543, 51, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (544, 51, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-11', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (545, 52, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (546, 52, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (547, 52, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (548, 52, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-13', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (549, 53, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (550, 53, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (551, 53, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (552, 53, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-18', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (553, 54, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (554, 54, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (555, 54, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (556, 54, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-20', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (557, 55, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (558, 55, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (559, 55, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (560, 55, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-25', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (561, 56, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 12345, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (562, 56, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, 123, NULL, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (563, 56, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 1, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (564, 56, 0, '2014-01-29 05:34:04', 0, '2014-01-29 05:35:31', 1, 1, NULL, 2, 1, '2014-02-27', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (565, 57, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (566, 58, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (567, 59, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (568, 60, 0, '2014-01-29 05:36:09', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (569, 57, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (570, 57, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (571, 57, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (572, 58, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (573, 58, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (574, 58, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (575, 59, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (576, 59, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (577, 59, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (578, 60, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (579, 60, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (580, 60, 0, '2014-01-29 05:36:19', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (581, 57, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (582, 57, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (583, 57, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (584, 58, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (585, 58, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (586, 58, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (587, 59, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (588, 59, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (589, 59, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (590, 60, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (591, 60, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (592, 60, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (593, 61, 0, '2014-01-29 05:36:42', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-03-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (594, 57, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (595, 57, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (596, 57, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (597, 58, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (598, 58, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (599, 58, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (600, 59, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (601, 59, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (602, 59, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (603, 60, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (604, 60, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (605, 60, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 1, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (606, 61, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, 12345, NULL, 1, '2014-03-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (607, 61, 0, '2014-01-29 05:36:47', 0, '2014-01-29 05:36:51', 1, 1, NULL, 2, 1, '2014-03-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (608, 57, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, 12345, NULL, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (609, 57, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 2, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (610, 57, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 1, 1, '2014-02-02', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (611, 58, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, 12345, NULL, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (612, 58, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 2, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (613, 58, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 1, 1, '2014-02-09', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (614, 59, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, 12345, NULL, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (615, 59, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 2, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (616, 59, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 1, 1, '2014-02-16', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (617, 60, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, 12345, NULL, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (618, 60, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 2, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (619, 60, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 1, 1, '2014-02-23', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (620, 61, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, 12345, NULL, 1, '2014-03-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL), (621, 61, 0, '2014-01-29 05:36:51', 0, '2014-01-29 05:36:51', 1, 0, NULL, 2, 1, '2014-03-01', '00:00:00', '00:00:00', NULL, '0.0', NULL, NULL); -- -------------------------------------------------------- -- -- 表的結構 `payroll` -- CREATE TABLE IF NOT EXISTS `payroll` ( `payroll_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `staff_id` int(10) unsigned NOT NULL, `code` varchar(500) CHARACTER SET utf8 NOT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`payroll_id`), KEY `fk_mis_payroll_staff_id_idx` (`staff_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `payroll_line` -- CREATE TABLE IF NOT EXISTS `payroll_line` ( `payroll_line_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `payroll_id` int(10) unsigned NOT NULL, `is_FT` tinyint(1) NOT NULL, `amount` decimal(18,1) NOT NULL, `original_fee` decimal(18,1) NOT NULL, `hour` decimal(18,1) NOT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`payroll_line_id`), KEY `fk_mis_payroll_line_payroll_id_idx` (`payroll_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `position` -- CREATE TABLE IF NOT EXISTS `position` ( `position_id` int(10) NOT NULL AUTO_INCREMENT, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `position_name` varchar(500) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`position_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- 轉存資料表中的資料 `position` -- INSERT INTO `position` (`position_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `position_name`) VALUES (1, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 1, 'Teacher (In House)'), (2, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 2, 'Teacher (Outside School)'), (3, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 3, 'Teaching Assistant (In House)'), (4, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 4, 'Teaching Assistant (Outside School)'), (5, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 5, 'Traveling'); -- -------------------------------------------------------- -- -- 表的結構 `program` -- CREATE TABLE IF NOT EXISTS `program` ( `program_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `program_code` varchar(500) CHARACTER SET utf8 NOT NULL, `program_name` varchar(500) CHARACTER SET utf8 NOT NULL, `prog_short_form` char(2) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`program_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `program` -- INSERT INTO `program` (`program_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `program_code`, `program_name`, `prog_short_form`) VALUES (1, 1, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00', 1, 0, 1, 'ISSP', 'Full Name of ISSP', 'is'), (2, 1, '2013-12-11 00:00:00', 1, '2013-12-05 00:00:00', 1, 0, 1, 'ASSP', 'OP', 'as'); -- -------------------------------------------------------- -- -- 表的結構 `staff` -- CREATE TABLE IF NOT EXISTS `staff` ( `staff_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_code` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `root_id` int(10) DEFAULT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `status` varchar(50) CHARACTER SET utf8 NOT NULL, `join_date` date NOT NULL, `registration_date` date NOT NULL, `last_name` varchar(500) CHARACTER SET utf8 NOT NULL, `first_name` varchar(500) CHARACTER SET utf8 NOT NULL, `ch_name` varchar(500) CHARACTER SET utf8 NOT NULL, `gender` tinyint(1) NOT NULL COMMENT '1=male,0=female', `date_of_brith` date NOT NULL, `home_tel` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `mobile` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(500) CHARACTER SET utf8 NOT NULL, `address` longtext CHARACTER SET utf8 NOT NULL, `address2` varchar(500) CHARACTER SET utf8 NOT NULL, `address3` varchar(500) CHARACTER SET utf8 NOT NULL, `refer_by` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`staff_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `staff` -- INSERT INTO `staff` (`staff_id`, `staff_code`, `root_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `status`, `join_date`, `registration_date`, `last_name`, `first_name`, `ch_name`, `gender`, `date_of_brith`, `home_tel`, `mobile`, `email`, `address`, `address2`, `address3`, `refer_by`, `remarks`) VALUES (1, 'SKL0001', 1, 0, '2014-01-29 01:33:40', 0, '2014-01-29 01:33:40', 1, 0, '1', '2014-01-01', '2014-01-29', 'Lau', 'ziyi', '劉子怡', 2, '2012-01-29', '24957364', '93746184', '123@123.com', 'address 1', 'address 2', 'address 3', 'user', ''), (2, 'SKL0002', 2, 0, '2014-01-29 01:38:07', 0, '2014-01-29 01:38:07', 1, 0, '1', '2014-01-29', '2014-01-29', 'zhang', 'jia le', '張家樂', 1, '2014-01-29', '93874651', '27158048', '2262309796@qq.com', 'address 1', 'address 2', 'address 3', 'user', ''); -- -------------------------------------------------------- -- -- 表的結構 `staff_attachment` -- CREATE TABLE IF NOT EXISTS `staff_attachment` ( `staff_attact_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `pdf` varchar(500) CHARACTER SET utf8 NOT NULL, `remarks` varchar(500) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`staff_attact_id`), KEY `fk_mis_staff_attachment_staff_id_idx` (`staff_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `staff_campus` -- CREATE TABLE IF NOT EXISTS `staff_campus` ( `campus_staff_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `campus_id` int(10) unsigned NOT NULL, PRIMARY KEY (`campus_staff_id`), KEY `fk_mis_staff_campus_staff_id_idx` (`staff_id`), KEY `fk_mis_staff_campus_campus_id_idx` (`campus_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `staff_campus` -- INSERT INTO `staff_campus` (`campus_staff_id`, `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `campus_id`) VALUES (1, 1, 0, '2014-01-29 01:33:40', 0, '2014-01-29 01:33:40', 1, 0, 2), (2, 2, 0, '2014-01-29 01:38:07', 0, '2014-01-29 01:38:07', 1, 0, 2); -- -------------------------------------------------------- -- -- 表的結構 `staff_education` -- CREATE TABLE IF NOT EXISTS `staff_education` ( `staff_edu_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `education` longtext CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`staff_edu_id`), KEY `fk_mis_staff_education_staff_id_idx` (`staff_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `staff_experience` -- CREATE TABLE IF NOT EXISTS `staff_experience` ( `staff_exp_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`staff_exp_id`), KEY `fk_mis_staff_experience_staff_id_idx` (`staff_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `staff_position` -- CREATE TABLE IF NOT EXISTS `staff_position` ( `staff_id` int(10) NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `position_id` int(10) NOT NULL, PRIMARY KEY (`staff_id`,`position_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- 表的結構 `staff_program` -- CREATE TABLE IF NOT EXISTS `staff_program` ( `staff_prog_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `program_id` int(10) unsigned NOT NULL, PRIMARY KEY (`staff_prog_id`), KEY `fk_mis_staff_program_program_id_idx` (`program_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `staff_program` -- INSERT INTO `staff_program` (`staff_prog_id`, `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `program_id`) VALUES (1, 1, 0, '2014-01-29 01:33:40', 0, '2014-01-29 01:33:40', 1, 0, 1), (2, 2, 0, '2014-01-29 01:38:07', 0, '2014-01-29 01:38:07', 1, 0, 1); -- -------------------------------------------------------- -- -- 表的結構 `staff_salary_history` -- CREATE TABLE IF NOT EXISTS `staff_salary_history` ( `staff_his_id` int(10) NOT NULL AUTO_INCREMENT, `staff_id` int(10) NOT NULL, `version` int(10) NOT NULL, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `salary` decimal(18,1) DEFAULT NULL, `rate1` decimal(18,1) DEFAULT NULL, `rate2` decimal(18,1) DEFAULT NULL, `rate3` decimal(18,1) DEFAULT NULL, `rate4` decimal(18,1) DEFAULT NULL, `rate5` decimal(18,1) DEFAULT NULL, `rate6` decimal(18,1) DEFAULT NULL, `other_rate` decimal(18,1) DEFAULT NULL, `other_rate_desc` varchar(500) DEFAULT NULL, `is_monthly` tinyint(1) NOT NULL, `is_volunteer` tinyint(1) NOT NULL, `is_hourly` tinyint(1) NOT NULL, `position_id` int(10) NOT NULL, PRIMARY KEY (`staff_his_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `staff_salary_history` -- INSERT INTO `staff_salary_history` (`staff_his_id`, `staff_id`, `version`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `salary`, `rate1`, `rate2`, `rate3`, `rate4`, `rate5`, `rate6`, `other_rate`, `other_rate_desc`, `is_monthly`, `is_volunteer`, `is_hourly`, `position_id`) VALUES (1, 1, 1, 0, '2014-01-29 01:33:40', 0, '2014-01-29 01:33:40', 1, 0, '10000.0', '530.0', '230.0', '758.0', '590.0', '900.0', '0.0', NULL, '', 0, 0, 1, 1), (2, 2, 1, 0, '2014-01-29 01:38:07', 0, '2014-01-29 01:38:07', 1, 0, '3000.0', '2100.0', '1200.0', '3100.0', '1300.0', '4100.0', '0.0', NULL, '', 1, 0, 0, 1); -- -------------------------------------------------------- -- -- 表的結構 `staff_subject` -- CREATE TABLE IF NOT EXISTS `staff_subject` ( `staff_sub_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `subject_id` int(10) unsigned NOT NULL, PRIMARY KEY (`staff_sub_id`), KEY `fk_mis_staff_subject_subject_id_idx` (`subject_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `staff_subject` -- INSERT INTO `staff_subject` (`staff_sub_id`, `staff_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `subject_id`) VALUES (1, 1, 0, '2014-01-29 01:33:40', 0, '2014-01-29 01:33:40', 1, 0, 3), (2, 2, 0, '2014-01-29 01:38:07', 0, '2014-01-29 01:38:07', 1, 0, 1); -- -------------------------------------------------------- -- -- 表的結構 `staff_training` -- CREATE TABLE IF NOT EXISTS `staff_training` ( `staff_train_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `staff_id` int(10) NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `remarks` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`staff_train_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `student` -- CREATE TABLE IF NOT EXISTS `student` ( `linking_id` int(10) NOT NULL AUTO_INCREMENT, `New_stu_ID` varchar(500) NOT NULL, `Old_stu_ID` int(10) NOT NULL, `Sem_yr` char(9) NOT NULL, `root_id` int(10) DEFAULT NULL, `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `registration_no` varchar(500) NOT NULL, `old_registration_no` int(10) NOT NULL, `reg_campus_id` int(10) NOT NULL, `input_date` date NOT NULL, `registration_date` date NOT NULL, `is_pathway_student` tinyint(1) NOT NULL, `is_in_school_student` tinyint(1) NOT NULL, `reg_sem_year` char(9) NOT NULL, `last_name` varchar(100) NOT NULL, `first_name` varchar(100) NOT NULL, `ch_name` varchar(100) CHARACTER SET utf8 NOT NULL, `gender` tinyint(1) NOT NULL, `date_of_birth` date NOT NULL, `home_tel` varchar(30) NOT NULL, `fax` varchar(30) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `photo` varchar(500) NOT NULL, `address` varchar(500) NOT NULL, `address2` varchar(500) CHARACTER SET utf8 NOT NULL, `address3` varchar(500) CHARACTER SET utf8 NOT NULL, `district_id` int(10) NOT NULL, `school_name` varchar(200) NOT NULL, `sch_district_id` int(10) DEFAULT NULL, `father_name` varchar(100) DEFAULT NULL, `father_occupation` varchar(200) DEFAULT NULL, `father_mobile` varchar(30) DEFAULT NULL, `father_off_tel` varchar(30) DEFAULT NULL, `mother_name` varchar(100) DEFAULT NULL, `mother_occupation` varchar(200) DEFAULT NULL, `mother_mobile` varchar(30) DEFAULT NULL, `mother_off_tel` varchar(30) DEFAULT NULL, `guardian_name` varchar(100) DEFAULT NULL, `guardian_occupation` varchar(200) DEFAULT NULL, `guardian_relationship` varchar(100) DEFAULT NULL, `guardian_mobile` varchar(30) DEFAULT NULL, `guardian_home_tel` varchar(30) DEFAULT NULL, `guardian_off_tel` varchar(30) DEFAULT NULL, `eme_contact_name` varchar(100) DEFAULT NULL, `eme_contact_number` varchar(30) DEFAULT NULL, `eme_contact_relationship` varchar(100) DEFAULT NULL, `ch_assessment_ID` int(10) DEFAULT NULL, `ch_assessment_date` date DEFAULT NULL, `en_assessment_ID` int(10) DEFAULT NULL, `en_assessment_date` date DEFAULT NULL, `math_assessment_ID` int(10) DEFAULT NULL, `math_assessment_date` date DEFAULT NULL, `medication` varchar(500) DEFAULT NULL, `traveling_allowance` tinyint(1) NOT NULL, PRIMARY KEY (`linking_id`), UNIQUE KEY `Add_ID` (`linking_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- 轉存資料表中的資料 `student` -- INSERT INTO `student` (`linking_id`, `New_stu_ID`, `Old_stu_ID`, `Sem_yr`, `root_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `registration_no`, `old_registration_no`, `reg_campus_id`, `input_date`, `registration_date`, `is_pathway_student`, `is_in_school_student`, `reg_sem_year`, `last_name`, `first_name`, `ch_name`, `gender`, `date_of_birth`, `home_tel`, `fax`, `email`, `photo`, `address`, `address2`, `address3`, `district_id`, `school_name`, `sch_district_id`, `father_name`, `father_occupation`, `father_mobile`, `father_off_tel`, `mother_name`, `mother_occupation`, `mother_mobile`, `mother_off_tel`, `guardian_name`, `guardian_occupation`, `guardian_relationship`, `guardian_mobile`, `guardian_home_tel`, `guardian_off_tel`, `eme_contact_name`, `eme_contact_number`, `eme_contact_relationship`, `ch_assessment_ID`, `ch_assessment_date`, `en_assessment_ID`, `en_assessment_date`, `math_assessment_ID`, `math_assessment_date`, `medication`, `traveling_allowance`) VALUES (1, 'KL12345', 12345, '2013-2014', 12345, 0, '2014-01-29 01:22:50', 0, '2014-01-29 01:22:50', 1, 0, 'KL123', 123, 2, '2013-12-12', '2013-12-12', 1, 0, '2013-2014', 'Bai', 'hua', '白樺', 0, '2010-03-05', '24123123', '24131312', '123@123.com', 'student_photo/Ability_Creature_Poison_06.png', 'address 1', 'address 2', 'address 3', 1, '123', 2, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 1), (2, 'ST123', 123, '2013-2014', 123, 0, '2014-01-29 01:29:42', 0, '2014-01-29 01:29:42', 1, 0, 'ST123', 123, 1, '2013-12-13', '2013-11-21', 0, 1, '2013-2014', 'Xia', 'yan', '夏言', 1, '2010-01-29', '24123123', '123', '123@123.com', 'student_photo/Ability_Ambush.png', 'address 1', 'address 2', 'address 3', 1, 'post', 1, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', 0); -- -------------------------------------------------------- -- -- 表的結構 `student_additional_aspect` -- CREATE TABLE IF NOT EXISTS `student_additional_aspect` ( `stu_add_ID` int(10) NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `aspect_id` int(10) unsigned NOT NULL, PRIMARY KEY (`stu_add_ID`,`aspect_id`), KEY `fk_mis_student_additional_aspect_additional_aspect_id_idx` (`aspect_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- 表的結構 `student_diagnose` -- CREATE TABLE IF NOT EXISTS `student_diagnose` ( `stu_dia_ID` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `diagnose_id` int(10) unsigned NOT NULL, PRIMARY KEY (`stu_dia_ID`,`diagnose_id`), KEY `fk_mis_student_diagnose_diagnose_id_idx` (`diagnose_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- 表的結構 `student_document` -- CREATE TABLE IF NOT EXISTS `student_document` ( `stu_doc_id` int(10) NOT NULL AUTO_INCREMENT, `stu_linking_id` int(10) NOT NULL COMMENT '=root_id', `createby` int(10) NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `refer_by` varchar(500) NOT NULL, `assessed_by` varchar(500) NOT NULL, `assessed_doc` varchar(500) NOT NULL, `assessed_date` date NOT NULL, PRIMARY KEY (`stu_doc_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `student_grade` -- CREATE TABLE IF NOT EXISTS `student_grade` ( `student_grade_id` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `grade_id` int(10) NOT NULL, PRIMARY KEY (`student_grade_id`), UNIQUE KEY `student_grade_id` (`student_grade_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- 轉存資料表中的資料 `student_grade` -- INSERT INTO `student_grade` (`student_grade_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `grade_id`) VALUES (1, 0, '2014-01-29 01:22:50', 0, '2014-01-29 01:22:50', 1, 1, 1), (2, 0, '2014-01-29 01:29:42', 0, '2014-01-29 01:29:42', 1, 0, 1), (3, 0, '2014-01-29 02:36:35', 0, '2014-01-29 02:36:35', 1, 0, 1), (4, 0, '2014-01-29 02:48:42', 0, '2014-01-29 02:48:42', 1, 0, 0); -- -------------------------------------------------------- -- -- 表的結構 `student_subsidy` -- CREATE TABLE IF NOT EXISTS `student_subsidy` ( `stu_subsidy_id` int(10) unsigned NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `subsidy_id` int(10) unsigned NOT NULL, PRIMARY KEY (`stu_subsidy_id`,`subsidy_id`), KEY `fk_mis_student_subsidy_subsidy_id_idx` (`subsidy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- 表的結構 `subject` -- CREATE TABLE IF NOT EXISTS `subject` ( `subject_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `sub_code` varchar(500) CHARACTER SET utf8 NOT NULL, `sub_name` varchar(500) CHARACTER SET utf8 NOT NULL, `sub_short_form` char(1) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`subject_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -- 轉存資料表中的資料 `subject` -- INSERT INTO `subject` (`subject_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `sub_code`, `sub_name`, `sub_short_form`) VALUES (1, 1, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00', 1, 0, 1, 'CHI', 'Chinese', 'c'), (2, 1, '2013-12-12 00:00:00', 1, '2013-12-20 00:00:00', 1, 0, 1, 'ENG', 'dnhj', 'e'), (3, 1, '2013-12-12 00:00:00', 1, '2013-12-12 00:00:00', 1, 0, 1, 'MATH', 'MATH', 'm'); -- -------------------------------------------------------- -- -- 表的結構 `subsidy` -- CREATE TABLE IF NOT EXISTS `subsidy` ( `Subsidy_ID` int(10) unsigned NOT NULL AUTO_INCREMENT, `root_id` int(10) NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `sort` int(11) NOT NULL, `title` varchar(500) COLLATE utf8_unicode_ci NOT NULL, `subsidy_type` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `percent` int(11) NOT NULL, `valid_date_till` date DEFAULT NULL, PRIMARY KEY (`Subsidy_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=28 ; -- -- 轉存資料表中的資料 `subsidy` -- INSERT INTO `subsidy` (`Subsidy_ID`, `root_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `title`, `subsidy_type`, `percent`, `valid_date_till`) VALUES (1, 1, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 10, 'Minimum rate', '2', 20, NULL), (2, 2, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 20, 'Unstable income', '2', 20, NULL), (3, 3, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, 'Single parent', '2', 5, NULL), (4, 4, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, 'With sibling who is SLD', '2', 5, NULL), (5, 5, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, 'SLD & ADD or AD/HD', '2', 5, NULL), (6, 6, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 60, 'Severe SLD, ADD or AD/HD', '2', 5, NULL), (7, 7, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 70, 'P5 or above without any help before', '2', 5, NULL), (8, 8, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 80, 'F1 or above without any help before', '2', 10, NULL), (9, 9, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 90, 'F3 or above without any help before ', '2', 15, NULL), (10, 10, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 100, 'Behavioural/emotional problems', '2', 5, NULL), (11, 11, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 110, 'Family members with chronic illness', '2', 5, NULL), (12, 12, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 120, 'Other problems', '2', 5, NULL), (13, 13, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 130, 'Others problems', '2', 10, NULL), (14, 14, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 140, 'Others problems', '2', 15, NULL), (15, 15, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 150, 'Others problems', '2', 20, NULL), (16, 16, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 10, 'Minimum rate', '3', 60, NULL), (17, 17, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 20, 'Single parent', '3', 5, NULL), (18, 18, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, 'With sibling who is SLD', '3', 5, NULL), (19, 19, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, 'SLD & ADD or AD/HD', '3', 5, NULL), (20, 20, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, 'Severe SLD, ADD or AD/HD', '3', 5, NULL), (21, 21, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 60, 'P5 or above without any help before', '3', 5, NULL), (22, 22, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 70, 'P1 or above without any help before', '3', 10, NULL), (23, 23, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 80, 'P3 or above without any help before', '3', 15, NULL), (24, 24, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 90, 'Behavioural/emotional problems', '3', 5, NULL), (25, 25, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 100, 'Family members with chronic illness', '3', 5, NULL), (26, 26, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 110, 'Other problems', '3', 5, NULL), (27, 27, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 120, 'Other problems', '3', 10, NULL); -- -------------------------------------------------------- -- -- 表的結構 `user` -- CREATE TABLE IF NOT EXISTS `user` ( `loginname` varchar(100) CHARACTER SET utf8 NOT NULL, `loginpw` varchar(100) CHARACTER SET utf8 NOT NULL, `username` varchar(500) CHARACTER SET utf8 NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `user_lv` int(10) unsigned NOT NULL, PRIMARY KEY (`loginname`), UNIQUE KEY `loginname` (`loginname`), KEY `ix_system_login_loginname` (`loginname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- 轉存資料表中的資料 `user` -- INSERT INTO `user` (`loginname`, `loginpw`, `username`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `user_lv`) VALUES ('user', 'e10adc3949ba59abbe56e057f20f883e', 'user', 1, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00', 1, 0, 1); -- -------------------------------------------------------- -- -- 表的結構 `venue` -- CREATE TABLE IF NOT EXISTS `venue` ( `room_ID` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `campus_id` int(10) unsigned NOT NULL, PRIMARY KEY (`room_ID`), KEY `fk_mis_venue_campus_id_idx` (`campus_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- 轉存資料表中的資料 `venue` -- INSERT INTO `venue` (`room_ID`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `campus_id`) VALUES ('a', 1, '2013-06-14 17:01:11', 1, '2013-06-14 17:01:23', 1, 1, 1), ('b', 1, '2013-06-14 17:01:15', 1, '2013-06-14 17:01:23', 1, 1, 0), ('KLN001', 0, '0000-00-00 00:00:00', 2, '2013-07-29 11:08:02', 1, 0, 2), ('KLN002', 1, '2013-06-14 17:01:45', 2, '2013-07-29 11:08:10', 1, 0, 2), ('RM002', 0, '0000-00-00 00:00:00', 1, '2013-06-14 17:01:04', 1, 1, 2), ('ST001', 2, '2013-07-29 11:08:20', 2, '2013-07-29 11:08:20', 1, 0, 1), ('ST002', 2, '2013-07-29 11:08:26', 2, '2013-07-29 11:08:26', 1, 0, 1); -- -------------------------------------------------------- -- -- 表的結構 `waiting_list` -- CREATE TABLE IF NOT EXISTS `waiting_list` ( `waiting_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `createby` int(10) unsigned NOT NULL, `createdate` datetime NOT NULL, `lastupby` int(10) unsigned NOT NULL, `lastupdate` datetime NOT NULL, `actived` tinyint(1) NOT NULL, `deleted` tinyint(1) NOT NULL, `stu_root_id` int(10) unsigned NOT NULL, `program_id` int(10) NOT NULL, `subject_id` int(10) NOT NULL, `priority` int(10) DEFAULT NULL, `is_head` tinyint(1) NOT NULL, PRIMARY KEY (`waiting_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;