-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- 主機: localhost
-- 建立日期: Nov 09, 2009, 08:02 AM
-- 伺服器版本: 5.0.45
-- PHP 版本: 5.2.3
-- 
-- 資料庫: `ts`
-- 

-- --------------------------------------------------------

-- 
-- 資料表格式： `abundant_master_paper`
-- 

CREATE TABLE `abundant_master_paper` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci default NULL,
  `Paper_No` char(10) collate utf8_unicode_ci default NULL,
  `Student_name` varchar(8) collate utf8_unicode_ci default NULL,
  `Topic_Chinese` varchar(30) collate utf8_unicode_ci default NULL,
  `Topic_English` varchar(30) collate utf8_unicode_ci default NULL,
  `School_name` char(10) collate utf8_unicode_ci default NULL,
  `series` char(10) collate utf8_unicode_ci default NULL,
  `GuiTime` date default NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

-- 
-- 列出以下資料庫的數據： `abundant_master_paper`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `abundant_master_paper_examination`
-- 

CREATE TABLE `abundant_master_paper_examination` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Examination_No` char(10) NOT NULL,
  `Student_name` varchar(30) NOT NULL,
  `Topic` varchar(60) NOT NULL,
  `English_Topic` varchar(60) NOT NULL,
  `School_name` varchar(10) NOT NULL default '',
  `Is_leaves` varchar(10) NOT NULL default '',
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- 
-- 列出以下資料庫的數據： `abundant_master_paper_examination`
-- 

INSERT INTO `abundant_master_paper_examination` VALUES (1, '124190251', '1', '學生姓名', '題目中', '題目英', '校名', '系別所', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `abundant_master_paper_examination` VALUES (4, '124190251', '', '2', '3', '4', '5', '6', '', '', '', '', '', '', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `class`
-- 

CREATE TABLE `class` (
  `id` int(4) NOT NULL auto_increment,
  `class` varchar(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- 列出以下資料庫的數據： `class`
-- 

INSERT INTO `class` VALUES (1, '阿鼠');
INSERT INTO `class` VALUES (2, '阿鼠');
INSERT INTO `class` VALUES (3, '嘻嘻');

-- --------------------------------------------------------

-- 
-- 資料表格式： `demonstration_lecture`
-- 

CREATE TABLE `demonstration_lecture` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) character set utf8 default NULL,
  `exhNo` char(10) collate utf8_unicode_ci default '',
  `Author` varchar(8) collate utf8_unicode_ci default NULL,
  `Subject` char(20) collate utf8_unicode_ci default NULL,
  `Organizing_unit` char(20) collate utf8_unicode_ci default NULL,
  `Place` char(20) collate utf8_unicode_ci default NULL,
  `Time` date default NULL,
  `number` char(10) collate utf8_unicode_ci default NULL,
  `class1` varchar(3) collate utf8_unicode_ci default NULL,
  `class2` varchar(2) collate utf8_unicode_ci default NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

-- 
-- 列出以下資料庫的數據： `demonstration_lecture`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `deplist`
-- 

CREATE TABLE `deplist` (
  `Id` int(4) NOT NULL auto_increment,
  `Dep` varchar(10) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci CHECKSUM=1 AUTO_INCREMENT=14 ;

-- 
-- 列出以下資料庫的數據： `deplist`
-- 

INSERT INTO `deplist` VALUES (1, '資訊管理學系');
INSERT INTO `deplist` VALUES (2, '資訊工程學系');
INSERT INTO `deplist` VALUES (3, '應用外語學系');
INSERT INTO `deplist` VALUES (4, '航運管理學系');
INSERT INTO `deplist` VALUES (5, '行銷物流學系');
INSERT INTO `deplist` VALUES (6, '海洋運動學系');
INSERT INTO `deplist` VALUES (7, '電信工程學系');
INSERT INTO `deplist` VALUES (8, '人文管理學院');
INSERT INTO `deplist` VALUES (9, '休閒學系');
INSERT INTO `deplist` VALUES (10, '研究所');
INSERT INTO `deplist` VALUES (11, '研究所');
INSERT INTO `deplist` VALUES (12, '研究所');
INSERT INTO `deplist` VALUES (13, '研究所');

-- --------------------------------------------------------

-- 
-- 資料表格式： `education_plan`
-- 

CREATE TABLE `education_plan` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Chinese_plan` varchar(20) NOT NULL,
  `English_plan` varchar(20) NOT NULL,
  `Positions` varchar(10) NOT NULL,
  `Execution_period_start_Y` varchar(4) NOT NULL,
  `Execution_period_start_M` varchar(2) NOT NULL,
  `Execution_period_end_Y` varchar(4) NOT NULL,
  `Execution_period_end_M` varchar(2) NOT NULL,
  `Program_code` varchar(20) NOT NULL,
  `Approved_amount` varchar(10) NOT NULL,
  `Business_office_inschool` varchar(7) default NULL,
  `Business_office_outschool` varchar(10) default NULL,
  `Domestic_inter_unit_cooperation` varchar(10) NOT NULL,
  `International_cooperation` varchar(10) NOT NULL,
  `School_coordination_fund` varchar(4) NOT NULL,
  `Management_fees` varchar(10) default NULL,
  `Other_Auxiliary_unit` varchar(20) default NULL,
  `Subsidy` varchar(20) default NULL,
  `Situation` varchar(3) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- 列出以下資料庫的數據： `education_plan`
-- 

INSERT INTO `education_plan` VALUES (1, '124190250', '', '2', '2', '11', '11', '', '1111', '1', '1', '1', '', '1', '1', '1', '1', '1', '1', '1', '執行中', '2009-09-24', '2009-09-23');
INSERT INTO `education_plan` VALUES (2, '124190250', '', '555', '555', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `education_plan` VALUES (3, '124190250', '', '5', '5', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `education_plan` VALUES (4, '124190250', '', '新增測試', '新增測試', '新增測試', '2009', '10', '2009', '10', '新增測試', '新增測試', '', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '執行中', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `education_training`
-- 

CREATE TABLE `education_training` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `EducationNo` char(10) collate utf8_unicode_ci NOT NULL,
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `Topic` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `unitName` char(20) collate utf8_unicode_ci NOT NULL default '',
  `Curriculum_Name` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 ;

-- 
-- 列出以下資料庫的數據： `education_training`
-- 

INSERT INTO `education_training` VALUES (33, '124190250', '', '洪祥哲', '', '', '', '', '', '', '2009-11-09', '0000-00-00');
INSERT INTO `education_training` VALUES (26, '', '', '洪祥哲', '', '', '', '', '', '', '2009-10-01', '0000-00-00');

-- --------------------------------------------------------

-- 
-- 資料表格式： `electronic_weekly`
-- 

CREATE TABLE `electronic_weekly` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci default NULL,
  `WeeklyNo` char(10) collate utf8_unicode_ci default NULL,
  `Author` varchar(8) collate utf8_unicode_ci default NULL,
  `Topic` varchar(30) collate utf8_unicode_ci default NULL,
  `Publication_name` char(20) collate utf8_unicode_ci default NULL,
  `Volume` varchar(10) collate utf8_unicode_ci default NULL,
  `Release_unit` char(10) collate utf8_unicode_ci default NULL,
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=17 ;

-- 
-- 列出以下資料庫的數據： `electronic_weekly`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `encyclopedia`
-- 

CREATE TABLE `encyclopedia` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci default NULL,
  `Encyclopedia_No` char(10) collate utf8_unicode_ci default NULL,
  `Book_title` char(20) collate utf8_unicode_ci default NULL,
  `Entry` varchar(20) collate utf8_unicode_ci default NULL,
  `Author` varchar(8) collate utf8_unicode_ci default NULL,
  `Edit` char(10) collate utf8_unicode_ci default NULL,
  `Publishing_house` char(10) collate utf8_unicode_ci default NULL,
  `Publication_place` char(10) collate utf8_unicode_ci default NULL,
  `Version` char(10) collate utf8_unicode_ci default NULL,
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10 ;

-- 
-- 列出以下資料庫的數據： `encyclopedia`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `extracurricular_lecture`
-- 

CREATE TABLE `extracurricular_lecture` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `lecture_no` char(10) NOT NULL default '',
  `lecture_topic` varchar(30) default NULL,
  `invites_the_unit` varchar(60) default NULL,
  `placa` char(20) default NULL,
  `domestic_and_foreign` varchar(3) default NULL,
  `year` varchar(4) default NULL,
  `month` varchar(2) default NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=18 ;

-- 
-- 列出以下資料庫的數據： `extracurricular_lecture`
-- 

INSERT INTO `extracurricular_lecture` VALUES (1, '124190251', '1', '1', '1', '1', '1', NULL, NULL, '0000-00-00', '0000-00-00');
INSERT INTO `extracurricular_lecture` VALUES (3, '124190251', '3', '題目', '單位', '地點', '國內', '1000', '10', '0000-00-00', '0000-00-00');
INSERT INTO `extracurricular_lecture` VALUES (4, '124190251', '', '123', '456', '789', '國際', '1', '2', '0000-00-00', '0000-00-00');

-- --------------------------------------------------------

-- 
-- 資料表格式： `fitness_report`
-- 

CREATE TABLE `fitness_report` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `FitnessNo` char(10) collate utf8_unicode_ci NOT NULL,
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `Topic` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `Publication_Place` char(20) collate utf8_unicode_ci NOT NULL,
  `Cooperation_unit` char(20) collate utf8_unicode_ci NOT NULL default '',
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=26 ;

-- 
-- 列出以下資料庫的數據： `fitness_report`
-- 

INSERT INTO `fitness_report` VALUES (17, '', '', '洪祥哲', '111', '11', '11', '11', '11', '11', '2009-09-17', '2009-09-17');

-- --------------------------------------------------------

-- 
-- 資料表格式： `handles_the_foreign_language_related_activity`
-- 

CREATE TABLE `handles_the_foreign_language_related_activity` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Related_activity_No` char(10) NOT NULL,
  `School_year` varchar(5) NOT NULL,
  `Active_name` varchar(30) NOT NULL,
  `Active_goal` varchar(300) NOT NULL default '',
  `Active_director` varchar(60) NOT NULL,
  `Funds_origin` varchar(30) NOT NULL,
  `Amount` char(10) NOT NULL,
  `Participates_in_the_specially_appointed_teacher_numbe` char(5) NOT NULL default '',
  `Participation_number_of_students` char(5) NOT NULL default '',
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

-- 
-- 列出以下資料庫的數據： `handles_the_foreign_language_related_activity`
-- 

INSERT INTO `handles_the_foreign_language_related_activity` VALUES (1, '124190251', '1', '97', '活動名稱', '活動目的', '活動主持人', '經費來源', '1234567890', '1', '2', '0000-00-00', '0000-00-00');
INSERT INTO `handles_the_foreign_language_related_activity` VALUES (2, '124190251', '', '99', '活動1', '目的無', '沒有人', '撿到', '10', '0', '1', '0000-00-00', '0000-00-00');
INSERT INTO `handles_the_foreign_language_related_activity` VALUES (5, '124190251', '', '7', '7', '7', '7', '7', '7', '7', '7', '2009-09-23', '2009-09-23');
INSERT INTO `handles_the_foreign_language_related_activity` VALUES (6, '124190251', '', '8', '8', '8', '8', '8', '8', '8', '8', '2009-09-23', '2009-09-23');
INSERT INTO `handles_the_foreign_language_related_activity` VALUES (13, '124190250', '', '98', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '2009-10-01', '2009-10-01');
INSERT INTO `handles_the_foreign_language_related_activity` VALUES (12, '124190250', '', '97', '名稱', ' ', '主持人', '經費來源', '金額', '12', '22', '2009-09-23', '2009-09-23');
INSERT INTO `handles_the_foreign_language_related_activity` VALUES (11, '124190250', '', '1', '1', '1', '1', '1', '1', '1', '1', '2009-09-23', '2009-09-23');

-- --------------------------------------------------------

-- 
-- 資料表格式： `handles_the_spread_education_service`
-- 

CREATE TABLE `handles_the_spread_education_service` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Education_No` char(10) NOT NULL,
  `School_year` varchar(10) NOT NULL,
  `Semester` varchar(10) NOT NULL,
  `Non_study_divides_into_classes_starts_work_the_number` char(5) default NULL,
  `Non_school_grades_colleague_number` char(5) default NULL,
  `Non_study_divides_into_classes_the_aggregate_amount` char(10) default NULL,
  `Studies_divides_into_classes_starts_work_the_number` char(5) default NULL,
  `Studies_divides_into_classes_teaches_a_course_the_school_grades` char(5) default NULL,
  `Studies_grades_colleague_number` char(5) default NULL,
  `Studies_divides_into_classes_the_aggregate_amount` char(10) default NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- 
-- 列出以下資料庫的數據： `handles_the_spread_education_service`
-- 

INSERT INTO `handles_the_spread_education_service` VALUES (1, '124190251', '', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0000-00-00', '0000-00-00');
INSERT INTO `handles_the_spread_education_service` VALUES (4, '124190251', '', '9+', '8+', '7+', '6+', '5+', '4+', '3+', '2+', '1+', '2009-09-29', '2009-09-29');
INSERT INTO `handles_the_spread_education_service` VALUES (6, '124190250', '', '98', '上', '1', '1', '1', '1', '1', '1', '1', '2009-10-01', '2009-10-01');
INSERT INTO `handles_the_spread_education_service` VALUES (7, '124190250', '', '99', '上', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '2009-10-01', '2009-10-01');
INSERT INTO `handles_the_spread_education_service` VALUES (9, '124190250', '', '97', '1', '1', '30', '20000', '1', '3', '30', '100000', '2009-10-12', '2009-10-12');
INSERT INTO `handles_the_spread_education_service` VALUES (10, '124190250', '', '99', '88', '001', '002', '003', '004', '005', '006', '007', '2009-10-21', '2009-10-21');

-- --------------------------------------------------------

-- 
-- 資料表格式： `holds_the_post_of_the_event_appraisal`
-- 

CREATE TABLE `holds_the_post_of_the_event_appraisal` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Competition_No` char(10) NOT NULL default '',
  `Competition_name` varchar(30) NOT NULL,
  `Organizing_unit` varchar(60) NOT NULL,
  `Category` varchar(2) NOT NULL,
  `Scale` varchar(2) NOT NULL,
  `Hold_the_post_of_the_title` varchar(30) NOT NULL,
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=14 ;

-- 
-- 列出以下資料庫的數據： `holds_the_post_of_the_event_appraisal`
-- 

INSERT INTO `holds_the_post_of_the_event_appraisal` VALUES (1, '124190251', '', '1', '2', '校內', '國內', '3', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `holds_the_post_of_the_event_appraisal` VALUES (2, '124190251', '2', '名稱', '單位', '校外', '國內', '', '', '', '0000-00-00', '2009-09-23');
INSERT INTO `holds_the_post_of_the_event_appraisal` VALUES (3, '124190251', '', '45671', '81', '校外', '國內', '991', '', '', '0000-00-00', '2009-09-23');
INSERT INTO `holds_the_post_of_the_event_appraisal` VALUES (5, '124190251', '', '', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `holds_the_post_of_the_event_appraisal` VALUES (6, '124190251', '', '1', '2', '校內', '國際', '3', '', '', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `important_meeting_duty`
-- 

CREATE TABLE `important_meeting_duty` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Conference_No` char(10) NOT NULL,
  `Seminar_name` varchar(60) NOT NULL,
  `Organizing_unit` varchar(60) NOT NULL,
  `Conducting_place` varchar(60) NOT NULL,
  `Domestic_and_foreign` varchar(2) NOT NULL,
  `Holds_the_post_of_the_duty` varchar(20) NOT NULL,
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- 列出以下資料庫的數據： `important_meeting_duty`
-- 

INSERT INTO `important_meeting_duty` VALUES (1, '124190251', '1', '研討會名稱', '主辦單位', '舉辦地點', '國際', '主持人', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `important_meeting_duty` VALUES (2, '124190251', '2', '1111', '2', '3', '國內', '主持人', '', '', '', '', '', '', '0000-00-00', '2009-09-23');
INSERT INTO `important_meeting_duty` VALUES (7, '124190251', '', '1', '2', '3', '國際', '主持人', '', '', '', '', '', '', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `important_periodical_duty`
-- 

CREATE TABLE `important_periodical_duty` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Duty_No` char(10) default '0',
  `Paper_type` varchar(2) NOT NULL default '',
  `Name` varchar(60) NOT NULL,
  `Domestic_and_foreign` varchar(2) NOT NULL default '',
  `SCI` varchar(1) default NULL,
  `SSCI` varchar(1) default NULL,
  `EI` varchar(1) default NULL,
  `HI` varchar(1) default NULL,
  `AHCI` varchar(1) default NULL,
  `CIJE` varchar(1) default NULL,
  `TSSCI` varchar(1) default NULL,
  `Hoids_the_post_of_the_duty` varchar(20) NOT NULL default '',
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- 
-- 列出以下資料庫的數據： `important_periodical_duty`
-- 

INSERT INTO `important_periodical_duty` VALUES (1, '124190251', '1', '學報', '000', '全國', '', '', '', '', '', '', '', '審查委員(reviewer)', '', '', '', '', '', '', '0000-00-00', '2009-09-23');
INSERT INTO `important_periodical_duty` VALUES (2, '124190251', '2', '學報', '', '全國', '1', '1', '1', '1', '1', '1', '1', '審查委員(reviewer)', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `important_periodical_duty` VALUES (5, '124190251', '', '學報', '1', '國際', '', '1', '', '1', '', '', '', '編輯委員(editor board)', '', '', '', '', '', '', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `industry_university_cooperation_program`
-- 

CREATE TABLE `industry_university_cooperation_program` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Chinese_plan` varchar(20) NOT NULL,
  `English_plan` varchar(20) NOT NULL,
  `Positions` varchar(10) NOT NULL,
  `Execution_period_start_Y` varchar(4) NOT NULL,
  `Execution_period_start_M` varchar(2) NOT NULL,
  `Execution_period_end_Y` varchar(4) NOT NULL,
  `Execution_period_end_M` varchar(2) NOT NULL,
  `Program_code` varchar(20) NOT NULL,
  `Subsidy_client` varchar(10) default NULL,
  `Approved_amount` varchar(10) NOT NULL,
  `Business_office_inschool` varchar(7) default NULL,
  `Business_office_outschool` varchar(10) default NULL,
  `Domestic_inter_unit_cooperation` varchar(10) NOT NULL,
  `International_cooperation` varchar(10) NOT NULL,
  `School_coordination_fund` varchar(4) NOT NULL,
  `Management_fees` varchar(10) default NULL,
  `Other_Auxiliary_unit` varchar(20) default NULL,
  `Subsidy` varchar(20) default NULL,
  `Situation` varchar(3) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- 列出以下資料庫的數據： `industry_university_cooperation_program`
-- 

INSERT INTO `industry_university_cooperation_program` VALUES (1, '124190250', '', '1', '1', '1', '11', '1', '1', '1', '1', '1', '1', '', '1', '11', '1', '1', '1', '1', '1', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `industry_university_cooperation_program` VALUES (2, '124190250', '', '111', '11', '11', '1', '1', '1', '1', '11', '1', '1', '', '1', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `industry_university_cooperation_program` VALUES (3, '124190250', '', '新增測試', '新增測試', '新增測試', '2009', '10', '2009', '10', '新增測試', '新增測試', '新增測試', '', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '執行中', '2009-10-01', '2009-10-01');
INSERT INTO `industry_university_cooperation_program` VALUES (4, '124190250', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-10-20', '2009-10-20');

-- --------------------------------------------------------

-- 
-- 資料表格式： `long_range_teaching_curriculum`
-- 

CREATE TABLE `long_range_teaching_curriculum` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `Long_range_teaching_No` char(10) NOT NULL,
  `School_year` varchar(10) NOT NULL,
  `Semester` varchar(10) NOT NULL,
  `Teaches_a_course_the_school` varchar(4) NOT NULL default '',
  `Repair_the_class_school` varchar(60) default NULL,
  `Teaches_a_course_the_school_or_the_unit` varchar(60) default NULL,
  `Domestic` varchar(2) NOT NULL default '',
  `Curriculum_name` varchar(30) NOT NULL,
  `School_grades` varchar(5) NOT NULL default '',
  `School_grades_number` char(5) NOT NULL,
  `Attending_class_population` char(5) NOT NULL,
  `Synchronized` varchar(6) NOT NULL default '',
  `PeriodY` varchar(4) NOT NULL,
  `PeriodM` varchar(2) NOT NULL,
  `PeriodD` varchar(2) NOT NULL,
  `PeriodY2` varchar(4) NOT NULL,
  `PeriodM2` varchar(2) NOT NULL,
  `PeriodD2` varchar(2) NOT NULL,
  `Curriculum_explanatio` varchar(300) NOT NULL default '',
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- 列出以下資料庫的數據： `long_range_teaching_curriculum`
-- 

INSERT INTO `long_range_teaching_curriculum` VALUES (1, '124190251', '', '1', '2', '開課學校', '3', '4', '國內', '5', '學分', '6', '7', '同步', '8', '9', '10', '11', '12', '13', '14', '0000-00-00', '0000-00-00');
INSERT INTO `long_range_teaching_curriculum` VALUES (2, '124190251', '', '', '', '修課學校', '', '開課學校', '', '課程名稱', '', '', '', '同步及非同步', '', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `long_range_teaching_curriculum` VALUES (4, '124190251', '', '1', '2', '修課學校', '3', '4', '修課', '56', '非學分課程', '6', '7', '同步及非同步', '8', '9', '10', '11', '12', '13', '', '2009-09-24', '2009-09-23');
INSERT INTO `long_range_teaching_curriculum` VALUES (6, '124190250', '', '98', '上', '', '新增測試', '新增測試', '', '新增測試', '', '新增測試', '新增測試', '', '2009', '10', '10', '2009', '10', '10', '新增測試', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `magazine_article`
-- 

CREATE TABLE `magazine_article` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `mwNo` char(10) collate utf8_unicode_ci NOT NULL,
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `Piece` char(5) collate utf8_unicode_ci NOT NULL,
  `Newspaper` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Vol` char(10) collate utf8_unicode_ci default NULL,
  `No` char(10) collate utf8_unicode_ci default NULL,
  `PP` char(10) collate utf8_unicode_ci default NULL,
  `Version` char(10) collate utf8_unicode_ci NOT NULL default '',
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=21 ;

-- 
-- 列出以下資料庫的數據： `magazine_article`
-- 

INSERT INTO `magazine_article` VALUES (9, '', '', '洪祥哲', '', '', '', '', '', '', '', '', '', '0000-00-00', '0000-00-00');

-- --------------------------------------------------------

-- 
-- 資料表格式： `male_privately_operated_institution_position`
-- 

CREATE TABLE `male_privately_operated_institution_position` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Position_serial_number` char(10) NOT NULL,
  `Unit_name` varchar(60) NOT NULL,
  `Male_privately_operated` varchar(2) NOT NULL,
  `Respective_committee_name` varchar(60) NOT NULL,
  `Holds_the_post_of_the_title` varchar(60) NOT NULL,
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- 
-- 列出以下資料庫的數據： `male_privately_operated_institution_position`
-- 

INSERT INTO `male_privately_operated_institution_position` VALUES (1, '124190251', '1', '單位名稱', '公營', '所屬委員會名稱', '擔任職稱', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `male_privately_operated_institution_position` VALUES (3, '124190253', '1', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `male_privately_operated_institution_position` VALUES (5, '124190251', '', '111', '民營', '122', '1', '', '', '', '', '', '', '0000-00-00', '2009-09-23');
INSERT INTO `male_privately_operated_institution_position` VALUES (4, '124190251', '', '中油', '公營', '中油委員會', '董ㄟ', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `male_privately_operated_institution_position` VALUES (6, '124190251', '', '1', '公營', '2', '3', '', '', '', '', '', '', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `national_science_account_paint`
-- 

CREATE TABLE `national_science_account_paint` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Chinese_plan` varchar(20) NOT NULL,
  `English_plan` varchar(20) NOT NULL,
  `Positions` varchar(10) NOT NULL,
  `Execution_period_start_Y` varchar(4) NOT NULL,
  `Execution_period_start_M` varchar(2) NOT NULL,
  `Execution_period_end_Y` varchar(4) NOT NULL,
  `Execution_period_end_M` varchar(2) NOT NULL,
  `Program_code` varchar(20) NOT NULL,
  `Approved_amount` varchar(10) NOT NULL,
  `Business_office_inschool` varchar(7) default NULL,
  `Business_office_outschool` varchar(10) default NULL,
  `Domestic_inter_unit_cooperation` varchar(10) NOT NULL,
  `international_cooperation` varchar(10) NOT NULL,
  `School_coordination_fund` varchar(4) NOT NULL,
  `Management_fees` varchar(10) default NULL,
  `Other_Auxiliary_unit` varchar(20) default NULL,
  `Subsidy` varchar(20) default NULL,
  `Situation` varchar(3) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

-- 
-- 列出以下資料庫的數據： `national_science_account_paint`
-- 

INSERT INTO `national_science_account_paint` VALUES (1, '124190250', '', '222222222', '222222222', '333', '2009', '09', '2009', '11', '333', '333', '', '111', '111', '111', '111', '111', '111', '111', '執行中', '2009-09-23', '2009-09-23');
INSERT INTO `national_science_account_paint` VALUES (10, '124190250', '', '新增測試', '新增測試', '新增測試', '2009', '10', '2009', '11', '新增測試', '新增測試', '', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '執行中', '2009-10-01', '2009-10-01');
INSERT INTO `national_science_account_paint` VALUES (11, '124190250', '', '資訊應用', 'information ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-10-28', '2009-10-28');
INSERT INTO `national_science_account_paint` VALUES (12, '124190250', '', '中', '英', '', '年1', '月2', '年1', '月2', '計畫編號', '核定金額', 'radiobu', '', '', '', '學校配合', '管理', '其他補助', '補助', '執行中', '2009-10-28', '2009-10-28');

-- --------------------------------------------------------

-- 
-- 資料表格式： `newspapers_article`
-- 

CREATE TABLE `newspapers_article` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `Newspapers_article` char(10) collate utf8_unicode_ci NOT NULL default '',
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `Piece` char(5) collate utf8_unicode_ci NOT NULL,
  `Newspaper` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `Vol` char(10) collate utf8_unicode_ci default NULL,
  `No` char(10) collate utf8_unicode_ci default NULL,
  `PP` char(10) collate utf8_unicode_ci default NULL,
  `version` char(10) collate utf8_unicode_ci NOT NULL default '',
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

-- 
-- 列出以下資料庫的數據： `newspapers_article`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `other`
-- 

CREATE TABLE `other` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Other_No` char(10) NOT NULL,
  `Teacher_name` varchar(60) NOT NULL,
  `Service_item` varchar(60) NOT NULL,
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- 
-- 列出以下資料庫的數據： `other`
-- 

INSERT INTO `other` VALUES (1, '124190251', '1', '教師姓名', '服務事項', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `other` VALUES (2, '124190251', '2', '1', '2', '', '', '', '', '', '', '0000-00-00', '0000-00-00');

-- --------------------------------------------------------

-- 
-- 資料表格式： `patent`
-- 

CREATE TABLE `patent` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci default NULL,
  `PatentNo` char(10) collate utf8_unicode_ci NOT NULL,
  `year` varchar(3) collate utf8_unicode_ci NOT NULL,
  `Department` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Teacher_name` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Patent_new_variety` varchar(20) collate utf8_unicode_ci NOT NULL,
  `regional` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Patent_class` varchar(8) collate utf8_unicode_ci NOT NULL,
  `Technical_report_score` text collate utf8_unicode_ci NOT NULL,
  `progrese` varchar(3) collate utf8_unicode_ci NOT NULL,
  `Author_cis_position` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Applicant_power` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Applicant_day_effective_day` varchar(2) collate utf8_unicode_ci NOT NULL,
  `End_day` date NOT NULL default '0000-00-00',
  `Licensing_authority` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Inventor_cis_position` varchar(5) collate utf8_unicode_ci NOT NULL,
  `country` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Certificate_cod` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Authorized` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Authorized_money` varchar(7) collate utf8_unicode_ci NOT NULL,
  `Projectplane` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;

-- 
-- 列出以下資料庫的數據： `patent`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `personal`
-- 

CREATE TABLE `personal` (
  `serial` int(11) unsigned NOT NULL auto_increment,
  `teacherid` varchar(11) collate utf8_unicode_ci NOT NULL default '0',
  `access` varchar(12) collate utf8_unicode_ci default NULL,
  `pasw` varchar(12) collate utf8_unicode_ci default NULL,
  `classroom` varchar(50) collate utf8_unicode_ci default NULL,
  `Tname` varchar(50) collate utf8_unicode_ci default NULL,
  `passport` varchar(255) character set utf8 default NULL,
  `uid` varchar(255) collate utf8_unicode_ci default NULL,
  `homeid` varchar(255) collate utf8_unicode_ci default NULL,
  `idcard` varchar(255) collate utf8_unicode_ci default NULL,
  `speciality` varchar(255) collate utf8_unicode_ci default NULL,
  `Tcase` varchar(255) collate utf8_unicode_ci default NULL,
  `grade` varchar(255) collate utf8_unicode_ci default NULL,
  `Temail` varchar(255) collate utf8_unicode_ci default '',
  `phone` varchar(255) collate utf8_unicode_ci default NULL,
  `speciality1` varchar(255) collate utf8_unicode_ci default NULL,
  `experience` varchar(255) collate utf8_unicode_ci default NULL,
  `direction` varchar(255) collate utf8_unicode_ci default NULL,
  `peoplehtml` varchar(255) collate utf8_unicode_ci default NULL,
  `comeday` date default NULL,
  `EcomeT` datetime NOT NULL default '0000-00-00 00:00:00',
  `EalterT` datetime NOT NULL default '0000-00-00 00:00:00',
  `EenterT` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`serial`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10001 ;

-- 
-- 列出以下資料庫的數據： `personal`
-- 

INSERT INTO `personal` VALUES (9999, '124190250', 'root', '123', '1', '洪祥哲', '台灣', 'D122214628', '居留證', '學生', '專任', '專案', '職級', 'td00230634@gmail.com', '3343817', '領域別', '創研經驗', '創研方向', 'http://www.npu.edu.tw', '2028-10-05', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `personal` VALUES (3, '124190251', '123', '123', '1', '大空空', '台灣', 'S123456789', '居留證', '學生', '專任', '專案', '職級', 'koo@yahoo.com.tw', '3345678', '領域別', '創研經驗', '創研方向', 'valentine93214', '2009-01-01', '2009-09-09 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `personal` VALUES (9998, '999999999', 'mis', 'npu', '1', '測試用帳號', '', '', '', '', '', '', '', '', '', '', '', '', '', '2008-01-01', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `personal` VALUES (7, '1095410009', 'X120433988', 'qwer1234', '', '袁偉杰', '', 'X120433988', '', '', '', '', '', '', '', '', '', '', '', '2012-01-24', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `personal` VALUES (10000, '33', 'h124190250', '0250', NULL, '洪祥哲', NULL, 'h124190250', NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

-- 
-- 資料表格式： `post`
-- 

CREATE TABLE `post` (
  `id` int(4) NOT NULL auto_increment,
  `Message` longtext collate utf8_unicode_ci NOT NULL,
  `Public` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ;

-- 
-- 列出以下資料庫的數據： `post`
-- 

INSERT INTO `post` VALUES (1, '新增管理員系統', 1);
INSERT INTO `post` VALUES (2, '老師們可以選擇自己的學系了喔！', 1);
INSERT INTO `post` VALUES (3, '更新公告系統：管理員擁有公告系統可以新增修改公告', 1);
INSERT INTO `post` VALUES (4, '背景顏色統一了', 1);
INSERT INTO `post` VALUES (5, '腳踏車忙畢代的事情忙翻天了', 1);
INSERT INTO `post` VALUES (6, '可以選擇公告的公開模式：公開或不公開', 1);
INSERT INTO `post` VALUES (7, '不知道可以更新甚麼了', 1);
INSERT INTO `post` VALUES (8, '這筆不公開測試哈哈', 0);
INSERT INTO `post` VALUES (9, '腳踏車is豬', 0);
INSERT INTO `post` VALUES (10, '張雁松臭三八', 0);
INSERT INTO `post` VALUES (11, '阿鼠好睏', 0);
INSERT INTO `post` VALUES (12, '逼機', 0);
INSERT INTO `post` VALUES (13, 'QQ', 1);

-- --------------------------------------------------------

-- 
-- 資料表格式： `produces_study_the_cooperation_teaching_curriculum`
-- 

CREATE TABLE `produces_study_the_cooperation_teaching_curriculum` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Produces_study_the_cooperation_No` char(10) NOT NULL,
  `School_year` varchar(10) NOT NULL,
  `Semester` varchar(10) NOT NULL,
  `Teaches_a_course_institute` varchar(30) NOT NULL,
  `When_time_class_number` char(10) NOT NULL,
  `Curriculum_name` varchar(30) NOT NULL,
  `Teaches_a_course_total_hour` char(5) NOT NULL,
  `Subsidy_or_not` varchar(2) NOT NULL default '',
  `Auxiliary_unit` varchar(60) NOT NULL,
  `Subsidy_type` varchar(60) default NULL,
  `Field_teacher_name` varchar(60) NOT NULL,
  `Field_teacher_Duty_station` varchar(60) NOT NULL,
  `Field_teacher_title` varchar(30) NOT NULL,
  `The_field_teacher_teaches_hour` char(5) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- 列出以下資料庫的數據： `produces_study_the_cooperation_teaching_curriculum`
-- 

INSERT INTO `produces_study_the_cooperation_teaching_curriculum` VALUES (1, '124190251', '', '1', '2', '3', '4', '5', '6', '1', '7', '8', '9', '10', '11', '12', '0000-00-00', '0000-00-00');
INSERT INTO `produces_study_the_cooperation_teaching_curriculum` VALUES (3, '124190251', '', '1', '2', '開課系所', '當期課號', '課程名稱', '開課總時數', '', '補助單位', '補助類型', '業界教師姓名', '業界教師任職單位', '業界教師職稱', '時數', '0000-00-00', '0000-00-00');
INSERT INTO `produces_study_the_cooperation_teaching_curriculum` VALUES (5, '124190250', '', '98', '上', '新增測試', '新增測試', '新增測試', '新增測試', '', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `qq`
-- 

CREATE TABLE `qq` (
  `id` int(99) NOT NULL auto_increment,
  `Name` varchar(5) NOT NULL,
  `Memo` varchar(30) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=173 ;

-- 
-- 列出以下資料庫的數據： `qq`
-- 

INSERT INTO `qq` VALUES (172, '阿鼠', '嗚嗚');
INSERT INTO `qq` VALUES (171, '阿鼠', '呵呵');
INSERT INTO `qq` VALUES (170, '阿鼠', '嗚嗚');
INSERT INTO `qq` VALUES (169, '阿鼠', '呵呵');
INSERT INTO `qq` VALUES (168, '阿鼠', '嗚嗚');
INSERT INTO `qq` VALUES (166, '阿鼠', '嗚嗚');
INSERT INTO `qq` VALUES (167, '阿鼠', '呵呵');
INSERT INTO `qq` VALUES (165, '阿鼠', '呵呵');

-- --------------------------------------------------------

-- 
-- 資料表格式： `school_plan_in`
-- 

CREATE TABLE `school_plan_in` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Chinese_plan` varchar(20) NOT NULL,
  `English_plan` varchar(20) NOT NULL,
  `Positions` varchar(10) NOT NULL,
  `Execution_period_start_Y` varchar(4) NOT NULL,
  `Execution_period_start_M` varchar(2) NOT NULL,
  `Execution_period_end_Y` varchar(4) NOT NULL,
  `Execution_period_end_M` varchar(2) NOT NULL,
  `Program_code` varchar(20) NOT NULL,
  `Approved_amount` varchar(20) NOT NULL,
  `Domestic_inter_unit_cooperation` varchar(10) NOT NULL,
  `International_cooperation` varchar(10) NOT NULL,
  `Situation` varchar(3) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

-- 
-- 列出以下資料庫的數據： `school_plan_in`
-- 

INSERT INTO `school_plan_in` VALUES (1, '124190250', '', '1111', '111', '1111', '1', '1', '1', '1', '1111', '1111', '1111', '1111', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `school_plan_in` VALUES (9, '124190250', '', '1212', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `school_plan_in` VALUES (3, '124190251', '', '000', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `school_plan_in` VALUES (10, '124190250', '', '12121', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');
INSERT INTO `school_plan_in` VALUES (11, '124190250', '', '測試新增', '測試新增', '測試新增', '2009', '10', '2009', '10', '測試新增', '測試新增', '測試新增', '測試新增', '執行中', '2009-10-01', '2009-10-01');
INSERT INTO `school_plan_in` VALUES (12, '124190250', '', '', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `school_plan_out`
-- 

CREATE TABLE `school_plan_out` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Chinese_plan` varchar(20) NOT NULL,
  `English_plan` varchar(20) NOT NULL,
  `Positions` varchar(10) NOT NULL,
  `Execution_period_start_Y` varchar(4) NOT NULL,
  `Execution_period_start_M` varchar(2) NOT NULL,
  `Execution_period_end_Y` varchar(4) NOT NULL,
  `Execution_period_end_M` varchar(2) NOT NULL,
  `Program_code` varchar(20) NOT NULL,
  `Approved_amount` varchar(10) NOT NULL,
  `Business_office_inschool` varchar(7) default NULL,
  `Business_office_outschool` varchar(10) default NULL,
  `Domestic_inter_unit_cooperation` varchar(10) NOT NULL,
  `International_cooperation` varchar(10) NOT NULL,
  `School_coordination_fund` varchar(4) NOT NULL,
  `Management_fees` varchar(10) default NULL,
  `Other_Auxiliary_unit` varchar(20) default NULL,
  `Subsidy` varchar(20) default NULL,
  `Situation` varchar(3) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- 列出以下資料庫的數據： `school_plan_out`
-- 

INSERT INTO `school_plan_out` VALUES (1, '124190250', '', '22', '222', '2', '2', '2', '2', '2', '2', '2', '', '2', '22', '2', '2', '22', '2', '2', '執行中', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `seminar_paper`
-- 

CREATE TABLE `seminar_paper` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `SeminarNo` char(10) collate utf8_unicode_ci NOT NULL,
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `year` varchar(5) collate utf8_unicode_ci NOT NULL,
  `Serminar_name` varchar(20) collate utf8_unicode_ci NOT NULL,
  `paperName` char(10) collate utf8_unicode_ci NOT NULL,
  `Institute` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `Department` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `country` varchar(20) collate utf8_unicode_ci NOT NULL,
  `city` varchar(20) collate utf8_unicode_ci NOT NULL,
  `No` char(10) character set utf8 default '',
  `PP` char(10) collate utf8_unicode_ci default NULL,
  `Periodical_category` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Communication_author` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Author_cis_positun` varchar(10) collate utf8_unicode_ci NOT NULL,
  `PlanNo` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci default NULL,
  `Announce_TimeM` varchar(4) character set utf8 default NULL,
  `Announce_TimeD` varchar(4) character set utf8 default NULL,
  `Project_plane` varchar(20) collate utf8_unicode_ci NOT NULL,
  `ID_state` varchar(10) collate utf8_unicode_ci NOT NULL,
  `ID_number` varchar(12) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;

-- 
-- 列出以下資料庫的數據： `seminar_paper`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `short_term_research_further_education`
-- 

CREATE TABLE `short_term_research_further_education` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Research_No` char(10) NOT NULL,
  `School_year` varchar(3) NOT NULL default '',
  `Semester` varchar(1) NOT NULL default '',
  `Institute` varchar(20) NOT NULL,
  `Teacher` varchar(60) NOT NULL default '',
  `Development_facility` varchar(60) NOT NULL default '',
  `Placa` varchar(20) NOT NULL,
  `Plan_name` varchar(60) NOT NULL default '',
  `Auxiliary_unit` varchar(60) NOT NULL default '',
  `Further_education_project` varchar(20) NOT NULL,
  `Further_education_organization` varchar(20) NOT NULL,
  `Further_education_institute` varchar(20) NOT NULL,
  `Upgrading_course` varchar(20) NOT NULL,
  `Further_education_hour` varchar(20) NOT NULL,
  `Majors_domain` varchar(60) NOT NULL default '',
  `Further_education_time` varchar(2) NOT NULL default '',
  `School_handles_the_way` varchar(4) NOT NULL default '',
  `Further_education_area` varchar(2) NOT NULL default '',
  `countrys_name` varchar(60) NOT NULL default '',
  `Ch1` varchar(1) default '',
  `Ch2` varchar(1) default NULL,
  `Ch3` varchar(1) default NULL,
  `Ch4` varchar(1) default NULL,
  `Ch5` varchar(1) default NULL,
  `Ch6` varchar(1) default NULL,
  `Ch7` varchar(1) default NULL,
  `Subsidy_situation` varchar(5) NOT NULL default '',
  `Subsidy_amount` varchar(60) NOT NULL default '',
  `Further_education_condition` varchar(3) NOT NULL default '',
  `Certificate_words` varchar(15) NOT NULL default '',
  `Further_education_proof` varchar(1) NOT NULL default '',
  `year1` varchar(4) NOT NULL,
  `month1` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `In_the_school_signs_a_treaty` varchar(20) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

-- 
-- 列出以下資料庫的數據： `short_term_research_further_education`
-- 

INSERT INTO `short_term_research_further_education` VALUES (1, '124190251', '1', '98', '1', '系所', '教師', '研究機構', '地點', '計畫名稱', '補助單位', '博士班', '進修學校/進修機構', '進修系所', '進修課程', '進修時數', '主修領域', '全部', '留職停薪', '國外', '縣市名/國名', '1', '1', '1', '1', '1', '1', '1', '經費補助', '補助金額/補助項目', '進修中', '證書字號', '有', '', '', '', '', '有', '0000-00-00', '0000-00-00');
INSERT INTO `short_term_research_further_education` VALUES (2, '124190251', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `short_term_research_further_education` VALUES (5, '124190251', '', '1', '2', '3', '4', '5', '6', '7', '8', '', '9', '10', '11', '12', '13', '', '', '', '14', '', '', '', '', '', '', '', '', '15', '', '16', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `short_term_research_further_education` VALUES (7, '124190251', '', '', '', '', '', '99999', '', '', '', '非學分班', '', '', '', '', '', '部分', '無', '大陸', '', '1', '1', '1', '1', '1', '1', '1', '無', '', '休學中', '', '無', '', '', '', '', '無', '2009-09-29', '2009-09-28');

-- --------------------------------------------------------

-- 
-- 資料表格式： `special_book_author`
-- 

CREATE TABLE `special_book_author` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `bookNo` char(10) collate utf8_unicode_ci NOT NULL default '',
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `year` varchar(3) collate utf8_unicode_ci NOT NULL,
  `Institute` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Department` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Book_name` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Book_category` varchar(3) collate utf8_unicode_ci NOT NULL,
  `User_language` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Author_population` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Communication_author` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Author_cis_positun` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Project_plane` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Publishing_year` date NOT NULL default '0000-00-00',
  `Publishing_house` varchar(12) collate utf8_unicode_ci NOT NULL,
  `Publishing_place` varchar(12) collate utf8_unicode_ci NOT NULL,
  `ID_state` varchar(10) collate utf8_unicode_ci NOT NULL,
  `ID_number` varchar(12) collate utf8_unicode_ci NOT NULL,
  `ISBN` char(10) collate utf8_unicode_ci NOT NULL default '',
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

-- 
-- 列出以下資料庫的數據： `special_book_author`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `special_book_paper`
-- 

CREATE TABLE `special_book_paper` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `Sepcial_bookNo` char(10) collate utf8_unicode_ci NOT NULL,
  `Book_Title` char(10) collate utf8_unicode_ci NOT NULL,
  `language` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Chapter` char(10) collate utf8_unicode_ci default NULL,
  `Author` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `Institute` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `Department` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `Book_categories` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Author_order` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Corresponding_author` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Edit` char(20) collate utf8_unicode_ci NOT NULL,
  `Publishing_House` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Publication_Place` char(10) collate utf8_unicode_ci NOT NULL,
  `ISBN` varchar(10) collate utf8_unicode_ci NOT NULL,
  `ID_State` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Case_Plan` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeD` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

-- 
-- 列出以下資料庫的數據： `special_book_paper`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `student_plan_national_science_council`
-- 

CREATE TABLE `student_plan_national_science_council` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Chinese_plan` varchar(20) NOT NULL,
  `English_plan` varchar(20) NOT NULL,
  `Student_name` varchar(10) NOT NULL,
  `Student_branch` varchar(12) NOT NULL,
  `Execution_period_start_Y` varchar(4) NOT NULL,
  `Execution_period_start_M` varchar(2) NOT NULL,
  `Execution_period_end_Y` varchar(4) NOT NULL,
  `Execution_period_end_M` varchar(2) NOT NULL,
  `Program_code` varchar(10) NOT NULL,
  `Approved_amount` varchar(10) NOT NULL,
  `Situation` varchar(3) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- 
-- 列出以下資料庫的數據： `student_plan_national_science_council`
-- 

INSERT INTO `student_plan_national_science_council` VALUES (1, '124190250', '', '456', '456', '456', '456', '2009', '10', '2009', '11', '456', '456', '執行中', '2009-09-24', '2009-09-23');
INSERT INTO `student_plan_national_science_council` VALUES (8, '124190250', '', '新增測試', '新增測試', '新增測試', '新增測試', '2009', '10', '2009', '10', '新增測試', '新增測試', '執行中', '2009-10-01', '2009-10-01');
INSERT INTO `student_plan_national_science_council` VALUES (7, '124190250', '', '', '', '', '', '', '', '', '', '', '', '執行中', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_all_plan`
-- 

CREATE TABLE `teacher_all_plan` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `planNO` char(10) NOT NULL,
  `Year` varchar(5) NOT NULL,
  `department` varchar(20) NOT NULL,
  `teach` varchar(20) NOT NULL,
  `Case_id` varchar(20) NOT NULL,
  `Case_name` varchar(20) NOT NULL,
  `Type` varchar(20) NOT NULL,
  `Start_plan_time` varchar(10) NOT NULL,
  `End_plan_time` varchar(10) NOT NULL,
  `Type_work` varchar(7) NOT NULL,
  `Plan_total_money` varchar(20) NOT NULL,
  `Government_money` varchar(20) default NULL,
  `Business_money` varchar(20) default NULL,
  `Other_money` varchar(20) default NULL,
  `School_money` varchar(20) default NULL,
  `Main_come_in` varchar(7) NOT NULL,
  `Unit_name` varchar(20) NOT NULL,
  `Secondary_come_in` varchar(20) NOT NULL,
  `Preferential_unit` varchar(20) NOT NULL,
  `Trust_unit` varchar(20) NOT NULL,
  `Cooperation_unit` varchar(20) NOT NULL,
  `Case_full_time` varchar(20) NOT NULL,
  `Case_part_time` varchar(20) NOT NULL,
  `Whole_plan_people` varchar(20) NOT NULL,
  `Business_plan_people` varchar(20) NOT NULL,
  `Other_plan_people` varchar(20) NOT NULL,
  `Other_school_case_in` varchar(2) NOT NULL,
  `Other_school_case_out` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

-- 
-- 列出以下資料庫的數據： `teacher_all_plan`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_counsels_record_filling_in`
-- 

CREATE TABLE `teacher_counsels_record_filling_in` (
  `id` int(11) NOT NULL,
  `teachid` char(10) NOT NULL,
  `Teacher_counsels_No` char(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- 列出以下資料庫的數據： `teacher_counsels_record_filling_in`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_education_table`
-- 

CREATE TABLE `teacher_education_table` (
  `id` int(11) NOT NULL auto_increment,
  `teachID` char(10) NOT NULL,
  `Term` varchar(10) NOT NULL,
  `Department` varchar(20) NOT NULL,
  `Teach` varchar(20) NOT NULL,
  `Education_project` varchar(4) NOT NULL,
  `Education_school` varchar(20) NOT NULL,
  `Education_department` varchar(3) default NULL,
  `Education_course` varchar(4) default NULL,
  `Education_hours` varchar(5) default NULL,
  `Majoring_field` varchar(5) default NULL,
  `Education_time` varchar(2) default NULL,
  `School_approach` varchar(4) NOT NULL,
  `Education_region` varchar(2) NOT NULL,
  `County_city` varchar(20) NOT NULL,
  `Ministry_education` varchar(3) NOT NULL,
  `School_set_aside` varchar(4) NOT NULL,
  `National_science_council` varchar(3) NOT NULL,
  `Foundation` varchar(3) NOT NULL,
  `Academin_institution` varchar(4) NOT NULL,
  `Other` varchar(2) NOT NULL,
  `Own_expense` varchar(2) NOT NULL,
  `Grant_case` varchar(4) NOT NULL,
  `Grant_amount` varchar(4) default NULL,
  `Education_state` varchar(3) NOT NULL,
  `Licensing_number` varchar(20) default NULL,
  `Education_date` varchar(10) NOT NULL,
  `Completion_date` varchar(10) NOT NULL,
  `School_contract` varchar(1) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- 列出以下資料庫的數據： `teacher_education_table`
-- 

INSERT INTO `teacher_education_table` VALUES (1, '124190250', '97學年度下學期', '請選擇', '請選擇 ', '請選擇', '2', '2', '2', '2', '2', '請選', '請選擇', '請選', '1', '', '', '', '', '', '', '', '請選擇', '1', '請選擇', '1', '2009-09-29', '2009-09-30', '', '2009-09-29', '2009-10-01');
INSERT INTO `teacher_education_table` VALUES (10, '124190250', '98學年度上學期', '請選擇', '請選擇', '請選擇', '新增測試', '新增測', '新增測試', '新增測試', '新增測試', '請選', '請選擇', '請選', '新增測試', '', '', '', '', '', '', '', '請選擇', '新增測試', '請選擇', '新增測試', '新增測試', '新增測試', '', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_individual_prize_record`
-- 

CREATE TABLE `teacher_individual_prize_record` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) character set utf8 NOT NULL default '',
  `Prize_No` char(10) collate utf8_unicode_ci NOT NULL default '',
  `year1` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Teacher` varchar(30) collate utf8_unicode_ci NOT NULL,
  `Prize_name` varchar(30) collate utf8_unicode_ci default NULL,
  `Prize_unit` varchar(60) collate utf8_unicode_ci default NULL,
  `Award_item_nature` varchar(20) collate utf8_unicode_ci default NULL,
  `Nature` varchar(20) collate utf8_unicode_ci default NULL,
  `Institute` varchar(30) collate utf8_unicode_ci default '',
  `Nationality` varchar(60) collate utf8_unicode_ci default '',
  `Promulgation_activity_designator` varchar(60) collate utf8_unicode_ci default '',
  `Author_order` varchar(10) collate utf8_unicode_ci default '',
  `year` varchar(4) collate utf8_unicode_ci default '',
  `month` varchar(2) collate utf8_unicode_ci default '',
  `Respective_plan_document` varchar(30) collate utf8_unicode_ci default '',
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=68 ;

-- 
-- 列出以下資料庫的數據： `teacher_individual_prize_record`
-- 

INSERT INTO `teacher_individual_prize_record` VALUES (5, '124190251', '', '99', '大空空', '特獎2', '澎科大', '非學術性獎項(含教學性)', '校內', '資管系', '台灣', '頒獎機構名稱', '第一作者', '2007', '7', 'A計劃', '0000-00-00', '0000-00-00');
INSERT INTO `teacher_individual_prize_record` VALUES (6, '124190251', '2', '', '', '獲獎名稱', '獎助單位', '其它', '國際性', '系所', '國別', '頒獎機構名稱', '第二作者', '2007', '5', '所屬計畫案', '0000-00-00', '0000-00-00');
INSERT INTO `teacher_individual_prize_record` VALUES (50, '124190251', '', '1+', '2+', '3++', '4+', '非學術性獎項(含教學性)', '國際性', '5+', '6+', '7+', '第一作者', '8+', '9+', '10+', '2009-09-29', '2009-09-29');
INSERT INTO `teacher_individual_prize_record` VALUES (57, '124190251', '', '9', '8', '7', '6', '非學術性獎項(含教學性)', '國際性', '5', '4', '3', '第一作者', '2', '1', '0', '2009-10-28', '2009-10-28');

-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_periodical_paper`
-- 

CREATE TABLE `teacher_periodical_paper` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) collate utf8_unicode_ci NOT NULL,
  `paperNo` char(10) collate utf8_unicode_ci NOT NULL default '',
  `Author` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `paper_Name` varchar(20) collate utf8_unicode_ci NOT NULL,
  `lnstitute` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `Department` varchar(30) collate utf8_unicode_ci NOT NULL default '',
  `year` varchar(3) collate utf8_unicode_ci NOT NULL,
  `Periodical_name` mediumtext collate utf8_unicode_ci NOT NULL,
  `Vol` char(10) collate utf8_unicode_ci default NULL,
  `No` char(10) collate utf8_unicode_ci default NULL,
  `Announce_year` varchar(3) collate utf8_unicode_ci NOT NULL,
  `month` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Project_plane` varchar(20) collate utf8_unicode_ci NOT NULL,
  `Communication_author` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Periodical_category` varchar(4) character set utf8 NOT NULL default '',
  `Announce_state` varchar(4) collate utf8_unicode_ci NOT NULL,
  `SCI` varchar(3) collate utf8_unicode_ci NOT NULL,
  `SSCI` varchar(4) collate utf8_unicode_ci NOT NULL,
  `EI` varchar(2) collate utf8_unicode_ci NOT NULL,
  `HI` varchar(2) collate utf8_unicode_ci NOT NULL,
  `AHCI` varchar(4) collate utf8_unicode_ci NOT NULL,
  `CIJE` varchar(4) collate utf8_unicode_ci NOT NULL,
  `TSSCI` varchar(5) collate utf8_unicode_ci NOT NULL,
  `Author_cis_positun` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Imact_factor` varchar(10) collate utf8_unicode_ci NOT NULL,
  `Subject_categories` varchar(10) collate utf8_unicode_ci default NULL,
  `RankN` varchar(10) collate utf8_unicode_ci default NULL,
  `RankM` varchar(10) collate utf8_unicode_ci default NULL,
  `PlanNo` char(10) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeY` varchar(4) collate utf8_unicode_ci NOT NULL,
  `Announce_TimeM` varchar(2) collate utf8_unicode_ci NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC AUTO_INCREMENT=111 ;

-- 
-- 列出以下資料庫的數據： `teacher_periodical_paper`
-- 


-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_practical_experience`
-- 

CREATE TABLE `teacher_practical_experience` (
  `id` int(11) NOT NULL auto_increment,
  `teachID` char(10) NOT NULL,
  `Term` varchar(12) NOT NULL,
  `department` varchar(20) NOT NULL,
  `teach` varchar(20) NOT NULL,
  `Working_body` varchar(20) NOT NULL,
  `Start_date` varchar(10) NOT NULL,
  `End_date` varchar(10) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- 
-- 列出以下資料庫的數據： `teacher_practical_experience`
-- 

INSERT INTO `teacher_practical_experience` VALUES (1, '124190250', '97學年度下學期', '請選擇', '請選擇 ', '2', '2009-09-29', '2009-09-30', '2009-09-29', '2009-09-29');
INSERT INTO `teacher_practical_experience` VALUES (2, '124190250', '97學年度下學期', '請選擇', '請選擇 ', '4', '2009-09-28', '2009-09-29', '2009-09-29', '2009-09-29');
INSERT INTO `teacher_practical_experience` VALUES (6, '124190250', '98學年度上學期', '請選擇', '請選擇 ', '新增測試', '2009-09-05', '2009-10-01', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_professional_services`
-- 

CREATE TABLE `teacher_professional_services` (
  `id` int(11) NOT NULL auto_increment,
  `teachID` char(10) NOT NULL,
  `Term` varchar(4) NOT NULL,
  `Department` varchar(20) NOT NULL,
  `teach` varchar(20) default NULL,
  `case_number` varchar(20) default NULL,
  `case_number1` varchar(20) default NULL,
  `Service_unit` varchar(20) default NULL,
  `Signed_document` varchar(1) default NULL,
  `Content_teacher_professional_skill` varchar(1) default NULL,
  `Service_nature` varchar(13) NOT NULL,
  `Service_start_date` varchar(10) default NULL,
  `Signed_hours` varchar(10) default NULL,
  `Signed_back_payment` varchar(10) default NULL,
  `Systemstart_time` date default NULL,
  `Systemend_time` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

-- 
-- 列出以下資料庫的數據： `teacher_professional_services`
-- 

INSERT INTO `teacher_professional_services` VALUES (2, '124190250', '', '', '', '1', '2', '3', '4', '', '', '5', '6', '7', '2009-09-26', '2009-09-26');
INSERT INTO `teacher_professional_services` VALUES (3, '124190250', '22', '', '', '1122', '2222 ', '3322 ', '4', ' ', ' ', '5522 ', '6622 ', '7722', '0000-00-00', '2009-09-26');
INSERT INTO `teacher_professional_services` VALUES (5, '124190250', '33', '', '', '33', '33', '33', '3', '', '', '33', '33', '33', '2009-09-26', '2009-09-26');
INSERT INTO `teacher_professional_services` VALUES (6, '124190250', '', '', '', '洪', '', '', '', '', '', '', '', '', '2009-09-26', '2009-09-26');
INSERT INTO `teacher_professional_services` VALUES (7, '124190250', '', '', '', '', '', '', '', '', '', '', '', '', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_related_license`
-- 

CREATE TABLE `teacher_related_license` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL,
  `Term` varchar(4) NOT NULL,
  `Department` varchar(20) NOT NULL,
  `Teach` varchar(20) NOT NULL,
  `Licensing_type` varchar(6) NOT NULL,
  `Licensing_name` varchar(20) NOT NULL,
  `Licensing_authority` varchar(20) NOT NULL,
  `Licensing_number` varchar(20) NOT NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

-- 
-- 列出以下資料庫的數據： `teacher_related_license`
-- 

INSERT INTO `teacher_related_license` VALUES (14, '124190250', '', '請選擇', '請選擇', '請選擇', '', '', '', '2009-10-20', '2009-10-20');
INSERT INTO `teacher_related_license` VALUES (12, '124190250', '98學年', '請選擇', '請選擇', '請選擇', '1111', '111', '111', '2009-10-01', '2009-10-01');
INSERT INTO `teacher_related_license` VALUES (13, '124190250', '98學年', '請選擇', '請選擇', '請選擇', '新增測試', '新增測試', '新增測試', '2009-10-01', '2009-10-01');
INSERT INTO `teacher_related_license` VALUES (6, '124190250', '111', '請選擇', '請選擇', '請選擇', '111', '111', '111', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `teacher_upgraded`
-- 

CREATE TABLE `teacher_upgraded` (
  `id` int(11) NOT NULL auto_increment,
  `teachid` char(10) default NULL,
  `Term` varchar(4) NOT NULL,
  `Department` varchar(20) NOT NULL,
  `teach` varchar(20) NOT NULL,
  `Rating_upgraded1` varchar(4) NOT NULL,
  `Rating_upgraded2` varchar(6) NOT NULL,
  `State` varchar(3) NOT NULL,
  `School_issue_number` varchar(4) default NULL,
  `Seniority_date` varchar(10) default NULL,
  `Issue_date` varchar(10) default NULL,
  `Systemstart_time` date default NULL,
  `Systemend_time` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- 列出以下資料庫的數據： `teacher_upgraded`
-- 

INSERT INTO `teacher_upgraded` VALUES (1, '124190250', '1', '', '', '', '', '', '2', '3', '4', '2009-09-28', '2009-09-28');
INSERT INTO `teacher_upgraded` VALUES (2, '124190250', '98學年', '', '', '', '', '', '新增測試', '2009-08-22', '2009-10-01', '2009-10-01', '2009-10-01');
INSERT INTO `teacher_upgraded` VALUES (3, '124190250', '新增測試', '', '', '', '', '', '新增測試', '新增測試', '新增測試', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `the_plan_examines_committee_member`
-- 

CREATE TABLE `the_plan_examines_committee_member` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Plan_No` char(10) NOT NULL,
  `Plan_name` varchar(60) NOT NULL,
  `Plan_origin_organization` varchar(60) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- 
-- 列出以下資料庫的數據： `the_plan_examines_committee_member`
-- 

INSERT INTO `the_plan_examines_committee_member` VALUES (1, '124190251', '1', '計畫名稱', '計畫來源機構', '0000-00-00', '0000-00-00');
INSERT INTO `the_plan_examines_committee_member` VALUES (5, '124190251', '', '1', '1', '2009-09-24', '2009-09-24');

-- --------------------------------------------------------

-- 
-- 資料表格式： `the_school_handles_the_home_and_the_international_cooperation`
-- 

CREATE TABLE `the_school_handles_the_home_and_the_international_cooperation` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `School_No` char(10) NOT NULL,
  `School_year` varchar(5) NOT NULL,
  `Domestic_or_overseas` varchar(30) NOT NULL,
  `Cooperation_school_number` char(5) NOT NULL default '',
  `Cooperative_effort_number_of_articles` char(5) default NULL,
  `The_cross_school_research_project_number_of_articles` char(5) default NULL,
  `Student_exchange` char(5) default NULL,
  `Teacher_exchange` char(5) default NULL,
  `The_nationality_student_population` char(5) default NULL,
  `Other1` char(5) default NULL,
  `Research_project` char(5) default NULL,
  `Teaching_cooperation` char(5) default NULL,
  `Seminar` char(5) default NULL,
  `Twin_degree` char(5) default NULL,
  `Other2` char(5) default NULL,
  `Handles_the_interscholastic_cooperation_funds` char(5) default NULL,
  `The_cooperating_agency_provides_amount_of_total_funds` char(5) default NULL,
  `Amount_of_total_school_coordination_subsidy` char(5) default NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

-- 
-- 列出以下資料庫的數據： `the_school_handles_the_home_and_the_international_cooperation`
-- 

INSERT INTO `the_school_handles_the_home_and_the_international_cooperation` VALUES (2, '124190251', '', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '0000-00-00', '0000-00-00');
INSERT INTO `the_school_handles_the_home_and_the_international_cooperation` VALUES (3, '124190251', '', '99+', '國內或國外+', '1+', '2+', '3+', '4+', '5+', '6+', '7+', '8+', '9+', '10+', '11+', '12+', '13+', '14+', '15+', '2009-09-28', '2009-09-28');
INSERT INTO `the_school_handles_the_home_and_the_international_cooperation` VALUES (5, '124190250', '', '98', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '新增測試', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `the_student_participates_in_the_competition`
-- 

CREATE TABLE `the_student_participates_in_the_competition` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Competition_No` char(10) NOT NULL,
  `School_year` varchar(10) NOT NULL,
  `Semester` varchar(10) NOT NULL,
  `Active_category` varchar(30) NOT NULL default '',
  `Activity_Organizing_unit` varchar(30) default NULL,
  `Active_name` varchar(30) default NULL,
  `Competition_project` varchar(30) default NULL,
  `Prize_position` varchar(30) NOT NULL,
  `Active_outset_dateY` varchar(4) NOT NULL,
  `Active_outset_dateM` varchar(2) NOT NULL,
  `Active_outset_dateD` varchar(2) NOT NULL,
  `Active_conclusion_dateY` varchar(4) NOT NULL,
  `Active_conclusion_dateM` varchar(2) NOT NULL,
  `Active_conclusion_dateD` varchar(2) NOT NULL,
  `Student_respective_branch_department` varchar(30) NOT NULL default '',
  `Yes` varchar(1) default NULL,
  `Systemstart_time` date NOT NULL,
  `Systemend_time` date NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

-- 
-- 列出以下資料庫的數據： `the_student_participates_in_the_competition`
-- 

INSERT INTO `the_student_participates_in_the_competition` VALUES (1, '124190251', '', '1', '2', '中央、直轄市、縣(市)主管行政機關主辦', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '1', '0000-00-00', '0000-00-00');
INSERT INTO `the_student_participates_in_the_competition` VALUES (2, '124190251', '', '學年', '學期', '全國', '活動主辦單位 ', '活動名稱 ', '競賽項目 ', '獲獎名次', '1', '1', '1', '2', '2', '2', '學生所屬科系 ', '1', '0000-00-00', '0000-00-00');
INSERT INTO `the_student_participates_in_the_competition` VALUES (4, '124190251', '', '99+', '98+', '中央、直轄市、縣(市)主管行政機關主辦', '9+', '8+', '7+', '6+', '5+', '4+', '3+', '2+', '1+', '0+', '00+', '', '2009-09-29', '2009-09-28');
INSERT INTO `the_student_participates_in_the_competition` VALUES (6, '124190250', '', '98', '上', '', '新增測試', '新增測試', '新增測試', '新增測試', '2009', '10', '10', '2009', '10', '10', '新增測試', '', '2009-10-01', '2009-10-01');

-- --------------------------------------------------------

-- 
-- 資料表格式： `the_test_proposition_or_examines_test_papers`
-- 

CREATE TABLE `the_test_proposition_or_examines_test_papers` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Test_No` char(10) NOT NULL,
  `Institution_name` varchar(60) NOT NULL,
  `Holds_the_post_of_the_duty` varchar(4) NOT NULL,
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- 
-- 列出以下資料庫的數據： `the_test_proposition_or_examines_test_papers`
-- 

INSERT INTO `the_test_proposition_or_examines_test_papers` VALUES (2, '124190251', '2', '機關名稱', '命題委員', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `the_test_proposition_or_examines_test_papers` VALUES (1, '124190251', '1', '機關名稱', '閱卷委員', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `the_test_proposition_or_examines_test_papers` VALUES (6, '124190251', '', '3', '命題委員', '', '', '', '', '', '', '0000-00-00', '0000-00-00');

-- --------------------------------------------------------

-- 
-- 資料表格式： `this_school_periodical_duty`
-- 

CREATE TABLE `this_school_periodical_duty` (
  `Id` int(11) NOT NULL auto_increment,
  `teachid` char(10) NOT NULL default '',
  `Periodical_No` char(10) NOT NULL,
  `Periodical_name` varchar(60) NOT NULL,
  `Release_unit` varchar(10) NOT NULL,
  `The_work_language_leaves` varchar(2) NOT NULL,
  `Holds_the_post_of_the_duty` varchar(20) NOT NULL,
  `year` varchar(4) NOT NULL,
  `month` varchar(2) NOT NULL,
  `day` varchar(2) NOT NULL,
  `year2` varchar(4) NOT NULL,
  `month2` varchar(2) NOT NULL,
  `day2` varchar(2) NOT NULL,
  `Systemstart_time` date NOT NULL default '0000-00-00',
  `Systemend_time` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- 
-- 列出以下資料庫的數據： `this_school_periodical_duty`
-- 

INSERT INTO `this_school_periodical_duty` VALUES (1, '124190251', '1', '名', '澎科大發行', '中文', '編輯委員(editor board)', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `this_school_periodical_duty` VALUES (2, '124190251', '2', '2', '澎科大發行', '中文', '編輯委員(editor board)', '', '', '', '', '', '', '0000-00-00', '2009-09-23');
INSERT INTO `this_school_periodical_duty` VALUES (6, '124190251', '', '111', '澎科大發行', '外文', '編輯委員(editor board)', '', '', '', '', '', '', '0000-00-00', '0000-00-00');
INSERT INTO `this_school_periodical_duty` VALUES (7, '124190251', '', '99990', '澎科大發行', '中文', '編輯委員(editor board)', '', '', '', '', '', '', '0000-00-00', '2009-09-23');