-- phpMyAdmin SQL Dump -- version 4.0.4.1 -- http://www.phpmyadmin.net -- -- 主機: 127.0.0.1 -- 產生日期: 2014 年 02 月 21 日 16:20 -- 伺服器版本: 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`; -- -------------------------------------------------------- -- -- 表的結構 `activity` -- CREATE TABLE IF NOT EXISTS `activity` ( `activity_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, `title` varchar(500) CHARACTER SET utf8 NOT NULL, `content` varchar(500) CHARACTER SET utf8 NOT NULL, `price` decimal(18,1) NOT NULL, `remarks` varchar(500) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`activity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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=6 ; -- -- 轉存資料表中的資料 `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, 'Low\n\nAverage'), (2, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 20, 'Average'), (3, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, 'High\n\nAverage'), (4, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, 'Superior'), (5, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, 'Very Superior'); -- -------------------------------------------------------- -- -- 表的結構 `adult` -- CREATE TABLE IF NOT EXISTS `adult` ( `adult_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, `adult_code` varchar(500) NOT NULL, `last_name` varchar(500) NOT NULL, `first_name` varchar(500) NOT NULL, `gender` tinyint(1) NOT NULL, `ch_name` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `position` varchar(500) DEFAULT NULL, `tel` varchar(20) DEFAULT NULL, `mobile` varchar(20) DEFAULT NULL, `address` varchar(500) DEFAULT NULL, `address2` varchar(500) DEFAULT NULL, `address3` varchar(500) DEFAULT NULL, `fax` varchar(20) DEFAULT NULL, `email` varchar(500) DEFAULT NULL, PRIMARY KEY (`adult_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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=5 ; -- -- 轉存資料表中的資料 `assessor` -- INSERT INTO `assessor` (`assessor_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `assessor`) VALUES (1, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'CAC'), (2, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'EDB'), (3, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'School'), (4, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Doctor'); -- -------------------------------------------------------- -- -- 表的結構 `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_id` int(10) 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=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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=11 ; -- -- 轉存資料表中的資料 `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, 'Features of Dyslexia'), (3, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, 'At risk dyslexia'), (4, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, 'Math Learning Disorder'), (5, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, 'Attention Deficit Hyperactivity Disorder'), (6, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 60, 'Attention Deficit Disorder'), (7, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 70, 'Specific Learning Impairment'), (8, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 80, 'Developmental Coordination Disorder'), (9, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 90, 'Autism Spectrum Disorder Multiple selection allowed'), (10, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 100, 'Anxiety/ Mood Problem'); -- -------------------------------------------------------- -- -- 表的結構 `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=19 ; -- -- 轉存資料表中的資料 `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, 'Central and Western '), (2, 0, '0000-00-00 00:00:00', 2, '2013-07-04 13:54:32', 1, 0, 2, 'Wan Chai'), (3, 2, '2013-06-28 16:48:27', 2, '2013-07-04 13:54:32', 1, 0, 3, 'Eastern '), (4, 2, '2013-06-28 16:48:34', 2, '2013-06-28 16:48:46', 1, 0, 5, 'Southern'), (5, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Yau Tsim Mong'), (6, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Sham Shui Po'), (7, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Kowloon City'), (8, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Wong Tai Sin'), (9, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Kwun Tong'), (10, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Kwai Tsing'), (11, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, ' Tsuen Wan'), (12, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Tuen Mun'), (13, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Yuen Long '), (14, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'North'), (15, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, ' Tai Po'), (16, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Sha Tin'), (17, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Sai Kung'), (18, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 0, 'Islands '); -- -------------------------------------------------------- -- -- 表的結構 `donor` -- CREATE TABLE IF NOT EXISTS `donor` ( `donor_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, `donor_code` varchar(500) NOT NULL, `registration_date` date NOT NULL, `org_name` varchar(500) DEFAULT NULL, `org_ch_name` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `address` varchar(500) DEFAULT NULL, `address2` varchar(500) DEFAULT NULL, `address3` varchar(500) DEFAULT NULL, `org_fax` varchar(20) DEFAULT NULL, `org_tel` varchar(20) DEFAULT NULL, `contact_position` varchar(500) DEFAULT NULL, `contact_gender` tinyint(1) DEFAULT NULL, `contact_last_name` varchar(500) DEFAULT NULL, `contact_first_name` varchar(500) DEFAULT NULL, `contact_ch_name` varchar(500) CHARACTER SET utf8 DEFAULT NULL, `contact_mobile` varchar(20) DEFAULT NULL, `contact_email` varchar(500) DEFAULT NULL, `is_individual` tinyint(1) NOT NULL, `is_past` tinyint(1) NOT NULL, PRIMARY KEY (`donor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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, `is_free` tinyint(1) NOT NULL, `school_id` int(10) 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=1 ; -- -------------------------------------------------------- -- -- 表的結構 `event_activity` -- CREATE TABLE IF NOT EXISTS `event_activity` ( `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, `activity_id` int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- 表的結構 `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_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=27 ; -- -- 轉存資料表中的資料 `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, 'K2'), (2, 0, '2013-11-23 00:00:00', 0, '2013-11-23 00:00:00', 1, 0, 'K3'), (3, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 'P1'), (4, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 'P2'), (5, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 'P3'), (6, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 'P4'), (7, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'P5'), (8, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'P6'), (9, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'S1'), (10, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'S2'), (11, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'S3'), (12, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'S4'), (13, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'S5'), (14, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'S6'), (15, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y1'), (16, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y2'), (17, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y3'), (18, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y4'), (19, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y5'), (20, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y6'), (21, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y7'), (22, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y8'), (23, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y9'), (24, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y10'), (25, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y11'), (26, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 'Y12'); -- -------------------------------------------------------- -- -- 表的結構 `invoice` -- CREATE TABLE IF NOT EXISTS `invoice` ( `invoice_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `invoice_code` varchar(500) CHARACTER SET utf8 NOT NULL, `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, `stu_linking_id` int(10) NOT NULL, `event_code` int(10) NOT NULL, `invoice_date` date NOT NULL, `total_original_fee` decimal(18,2) NOT NULL, `total_discount_fee` decimal(18,2) NOT NULL, `total_amount` decimal(18,2) NOT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`invoice_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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, `lesson_id` int(10) NOT NULL, `event_programme_fee_type` int(10) NOT NULL, `discount_type` int(1) NOT NULL COMMENT '1=subsidy,2=package discount,3=funding', `original_fee` decimal(18,2) NOT NULL, `discounted_fee` decimal(18,2) NOT NULL, `amount` decimal(18,2) NOT NULL, `hour` decimal(18,2) NOT NULL, `subsidy_percent` int(10) DEFAULT NULL, `remarks` longtext CHARACTER SET utf8, PRIMARY KEY (`invoice_line_id`), KEY `fk_mis_invoice_line_invoice_id_idx` (`invoice_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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, `start_date` date NOT NULL, `end_date` date NOT NULL, `leave_type` int(1) NOT NULL COMMENT '1=full_day,2=morning,3=after lunch', `reason_id` int(10) NOT NULL, `approve_by` int(10) DEFAULT NULL, `is_approved` tinyint(1) NOT NULL, `remarks` varchar(500) NOT NULL, PRIMARY KEY (`leave_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `leave_lesson` -- CREATE TABLE IF NOT EXISTS `leave_lesson` ( `leave_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, `make_up_lesson_id` int(10) NOT NULL, PRIMARY KEY (`leave_id`,`lesson_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- 表的結構 `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, `teaching_hr` decimal(18,2) NOT NULL, PRIMARY KEY (`lesson_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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, `rate_type` int(10) NOT NULL, `payroll_gened` tinyint(1) DEFAULT NULL, `invoice_gened` tinyint(1) DEFAULT NULL, `is_charge` tinyint(1) NOT NULL, `package_discount` decimal(18,2) NOT NULL, `is_substitute` tinyint(1) DEFAULT NULL, `state` int(10) NOT NULL, `reason_id` int(10) DEFAULT NULL, PRIMARY KEY (`attend_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `payroll` -- CREATE TABLE IF NOT EXISTS `payroll` ( `payroll_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `payroll_code` 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, `staff_id` int(10) unsigned NOT NULL, `payroll_date` date NOT NULL, `total_amount` decimal(18,2) NOT NULL, `is_paid` tinyint(1) NOT NULL, `remarks` longtext CHARACTER SET utf8, `start_date` date NOT NULL, `end_date` date NOT NULL, 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, `rate_type` int(10) NOT NULL, `rate` decimal(18,2) NOT NULL, `hour` decimal(18,2) DEFAULT NULL, `amount` decimal(18,2) 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=15 ; -- -- 轉存資料表中的資料 `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, 'Executive Director'), (2, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 2, 'Admin Manager'), (3, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 3, 'Admin Officer'), (4, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 4, 'Accounting Clerk'), (5, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 5, 'Executive Assistant/ \n\nJanitor'), (6, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 6, 'Technician'), (7, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 7, 'Social Worker'), (8, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 8, 'Programme Director'), (9, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 9, 'Senior Teacher'), (10, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 10, 'Teacher'), (11, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 11, 'Teacher Assistant'), (12, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 12, 'Clinical Psychologist'), (13, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 13, 'Speech Therapist'), (14, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 1, 0, 14, 'Occupational Therapist'); -- -------------------------------------------------------- -- -- 表的結構 `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=14 ; -- -- 轉存資料表中的資料 `program` -- INSERT INTO `program` (`program_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `program_code`, `program_name`, `prog_short_form`) VALUES (1, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 1, 'Subject Based Assessment', 'Subject Based Assessment', 'AZ'), (2, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 2, 'ASSP', 'ASSP', 'AS'), (3, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 3, 'ISSP', 'ISSP', 'IS'), (4, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 4, 'Pre-School', 'Pre-School', 'PS'), (5, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 5, 'Atelier', 'Atelier', 'SA'), (6, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 6, 'Short Courses - Sammer Program', 'Short Courses - Sammer Program', 'SP'), (7, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 7, 'Short Course - DSE', 'Short Course - DSE', 'DZ'), (8, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 8, 'Short Course-Word Study', 'Short Course-Word Study', 'WS'), (9, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 9, 'Professional Services', 'Professional Services', 'ZZ'), (10, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 10, 'Counselling Services', 'Counselling Services', 'CS'), (11, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 11, 'Teacher Workshop', 'Teacher Workshop', 'TW'), (12, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 12, 'Parent Workshop', 'Parent Workshop', 'PW'), (13, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 13, 'Parent Interview', 'Parent Interview', 'PI'); -- -------------------------------------------------------- -- -- 表的結構 `prog_subject` -- CREATE TABLE IF NOT EXISTS `prog_subject` ( `prog_subj_id` int(10) NOT NULL AUTO_INCREMENT, `program_id` int(10) NOT NULL, `subject_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, `primary_individual_price` decimal(18,2) NOT NULL, `primary_group_price` decimal(18,2) NOT NULL, `primary_package_price` decimal(18,2) NOT NULL, ` secondary_individual_price` decimal(18,2) NOT NULL, `secondary_group_price` decimal(18,2) NOT NULL, `secondary_package_price` decimal(18,2) NOT NULL, PRIMARY KEY (`prog_subj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `reason` -- CREATE TABLE IF NOT EXISTS `reason` ( `reason_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, `reason_name` varchar(500) NOT NULL, PRIMARY KEY (`reason_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- 轉存資料表中的資料 `reason` -- INSERT INTO `reason` (`reason_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `reason_name`) VALUES (1, 1, '2014-02-01 00:00:00', 1, '2014-02-01 00:00:00', 1, 0, 'Sick Leave'), (2, 1, '2014-02-01 00:00:00', 1, '2014-02-01 00:00:00', 1, 0, 'Annual Leave'), (3, 1, '2014-02-01 00:00:00', 1, '2014-02-01 00:00:00', 1, 0, 'Personal Leave'), (4, 1, '2014-02-01 00:00:00', 1, '2014-02-01 00:00:00', 1, 0, 'School Event Leave'), (5, 1, '2014-02-01 00:00:00', 1, '2014-02-01 00:00:00', 1, 0, 'No Pay Leave'); -- -------------------------------------------------------- -- -- 表的結構 `receive` -- CREATE TABLE IF NOT EXISTS `receive` ( `receive_id` int(10) NOT NULL AUTO_INCREMENT, `receive_code` varchar(500) 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, `receive_date` date NOT NULL, `invoice_id` int(10) DEFAULT NULL, `receive_from` varchar(500) CHARACTER SET utf8 NOT NULL, `payment_of` varchar(500) CHARACTER SET utf8 NOT NULL, `total_amount` decimal(18,2) NOT NULL, `is_cash` tinyint(1) NOT NULL, `is_normal` tinyint(1) NOT NULL, `campus_id` int(10) NOT NULL, PRIMARY KEY (`receive_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `refer` -- CREATE TABLE IF NOT EXISTS `refer` ( `refer_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(10) NOT NULL, `refer_name` varchar(500) NOT NULL, PRIMARY KEY (`refer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- 轉存資料表中的資料 `refer` -- INSERT INTO `refer` (`refer_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `refer_name`) VALUES (1, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0, 'CAC'), (2, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0, 'Other NGOs '), (3, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0, 'Personal referral '), (4, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0, 'Private Practitioners '), (5, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0, 'Publicity materials '), (6, 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0, 0, 'Schools'); -- -------------------------------------------------------- -- -- 表的結構 `school` -- CREATE TABLE IF NOT EXISTS `school` ( `school_id` int(10) NOT NULL AUTO_INCREMENT, `sch_code` varchar(500) 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, `root_id` int(10) NOT NULL, `sch_name` varchar(500) NOT NULL, `sch_ch_name` varchar(500) CHARACTER SET utf8 NOT NULL, `address` varchar(500) NOT NULL, `address2` varchar(500) NOT NULL, `address3` varchar(500) NOT NULL, `sch_fax` varchar(30) NOT NULL, `sch_tel` varchar(30) NOT NULL, `contact_last_name` varchar(500) NOT NULL, `contact_first_name` varchar(500) NOT NULL, `contact_ch_name` varchar(500) NOT NULL, `contact_gender` tinyint(1) NOT NULL, `contact_mobile` varchar(30) NOT NULL, PRIMARY KEY (`school_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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=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,2) DEFAULT NULL, `rate2` decimal(18,2) DEFAULT NULL, `rate3` decimal(18,2) DEFAULT NULL, `rate4` decimal(18,2) DEFAULT NULL, `rate5` decimal(18,2) DEFAULT NULL, `rate6` decimal(18,2) DEFAULT NULL, `other_rate` decimal(18,2) 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=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=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, `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=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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_assessment` -- CREATE TABLE IF NOT EXISTS `student_assessment` ( `stu_ass_id` int(10) NOT NULL AUTO_INCREMENT, `stu_linking_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, `program_id` int(10) NOT NULL, `subject_id` int(10) NOT NULL, `assessment_doc` varchar(500) NOT NULL, PRIMARY KEY (`stu_ass_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- 表的結構 `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_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=11 ; -- -- 轉存資料表中的資料 `subject` -- INSERT INTO `subject` (`subject_id`, `createby`, `createdate`, `lastupby`, `lastupdate`, `actived`, `deleted`, `sort`, `sub_code`, `sub_name`, `sub_short_form`) VALUES (1, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 1, 'Chinese', 'Chinese', 'C'), (2, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 2, 'English', 'English', 'E'), (3, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 3, 'Maths', 'Maths', 'M'), (4, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 4, 'Visual Arts', 'Visual Arts', 'V'), (5, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 5, 'Performing Arts', 'Performing Arts', 'P'), (6, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 6, 'Digital Media', 'Digital Media', 'D'), (7, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 7, 'CP', 'CP', 'C'), (8, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 8, 'OT', 'OT', 'O'), (9, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 9, 'ST', 'ST', 'S'), (10, 1, '2014-01-01 00:00:00', 1, '2014-01-01 00:00:00', 1, 0, 10, 'Counselling', 'Counselling', 'C'); -- -------------------------------------------------------- -- -- 表的結構 `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=18 ; -- -- 轉存資料表中的資料 `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, '10%', '2', 10, NULL), (2, 2, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 20, '15%', '2', 15, NULL), (3, 3, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 30, '20%', '2', 20, NULL), (4, 4, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 40, '25%', '2', 25, NULL), (5, 5, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 50, '30%', '2', 30, NULL), (6, 6, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 60, '35%', '2', 35, NULL), (7, 7, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 70, '40%', '2', 40, NULL), (8, 8, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 80, '45%', '2', 45, NULL), (9, 9, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 90, '50% ', '2', 50, NULL), (10, 10, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 100, '55%', '2', 55, NULL), (11, 11, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 110, '60%', '2', 60, NULL), (12, 12, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 120, '65%', '2', 65, NULL), (13, 13, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 130, '70%', '2', 70, NULL), (14, 14, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 140, '75%', '2', 75, NULL), (15, 15, 1, '2013-06-20 11:15:59', 1, '2013-06-20 11:15:59', 1, 0, 150, '80%', '2', 80, NULL), (16, 16, 0, '2014-01-29 00:00:00', 0, '2014-01-29 00:00:00', 1, 0, 150, '85%', '2', 85, NULL), (17, 17, 0, '2014-01-29 00:00:00', 0, '2014-01-29 00:00:00', 1, 0, 160, '90%', '2', 90, 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_linking_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, `state_id` int(10) 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 */;