-- MySQL dump 10.11
--
-- Host: localhost    Database: managedb
-- ------------------------------------------------------
-- Server version	5.0.77

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Amphur`
--

DROP TABLE IF EXISTS `Amphur`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Amphur` (
  `amphurId` int(4) NOT NULL default '0',
  `amphurName` varchar(30) NOT NULL default '',
  `amphurNameEng` varchar(30) NOT NULL default '',
  `provinceId` int(2) NOT NULL default '0',
  PRIMARY KEY  (`amphurId`),
  KEY `provinceId` (`provinceId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Amphur`
--

LOCK TABLES `Amphur` WRITE;
/*!40000 ALTER TABLE `Amphur` DISABLE KEYS */;
/*!40000 ALTER TABLE `Amphur` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `College`
--

DROP TABLE IF EXISTS `College`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `College` (
  `collegeCode` char(3) NOT NULL default '',
  `collegeStatus` varchar(255) NOT NULL,
  `collegeName` text NOT NULL,
  `collegeNameEng` text NOT NULL,
  `collegeAbbr` varchar(50) NOT NULL default '',
  `collegeAbbrEng` varchar(50) NOT NULL default '',
  `collegeAddress` text NOT NULL,
  `collegePhone` text NOT NULL,
  PRIMARY KEY  (`collegeCode`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `College`
--

LOCK TABLES `College` WRITE;
/*!40000 ALTER TABLE `College` DISABLE KEYS */;
/*!40000 ALTER TABLE `College` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Condition_db`
--

DROP TABLE IF EXISTS `Condition_db`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Condition_db` (
  `conditionId` int(11) NOT NULL default '0',
  `conditionCode` char(3) NOT NULL default '',
  `condition` varchar(100) NOT NULL default '',
  `conditionEng` varchar(100) NOT NULL default '',
  `conditionAbbr` char(3) NOT NULL default '',
  `conditionAbbrEng` char(3) NOT NULL default '',
  `conditionType` char(1) NOT NULL default '',
  `minGrade` char(2) NOT NULL default '',
  PRIMARY KEY  (`conditionId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Condition_db`
--

LOCK TABLES `Condition_db` WRITE;
/*!40000 ALTER TABLE `Condition_db` DISABLE KEYS */;
/*!40000 ALTER TABLE `Condition_db` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Course`
--

DROP TABLE IF EXISTS `Course`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Course` (
  `courseId` int(11) NOT NULL default '0',
  `courseCode` varchar(10) NOT NULL default '',
  `courseCodeEng` varchar(10) NOT NULL default '',
  `courseName` varchar(100) NOT NULL default '',
  `courseNameEng` varchar(100) NOT NULL default '',
  `courseAbbr` varchar(32) NOT NULL default '',
  `courseAbbrEng` varchar(32) NOT NULL default '',
  `creditTotal` int(11) NOT NULL default '0',
  `credit1` int(11) NOT NULL default '0',
  `credit2` int(11) NOT NULL default '0',
  `period1` int(11) NOT NULL default '0',
  `period2` int(11) NOT NULL default '0',
  `period3` int(11) NOT NULL default '0',
  `courseStatus` char(1) NOT NULL default '',
  `description` text NOT NULL,
  `descriptionEng` text NOT NULL,
  `createDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `createUserId` varchar(20) NOT NULL default '',
  `updateDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `updateUserId` varchar(20) NOT NULL default '',
  `courseUnit` varchar(12) NOT NULL default '',
  `showLabTS` char(1) NOT NULL default '',
  `conditionId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`courseId`),
  KEY `conditionId` (`conditionId`),
  CONSTRAINT `Course_ibfk_3` FOREIGN KEY (`conditionId`) REFERENCES `Condition_db` (`conditionId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Course`
--

LOCK TABLES `Course` WRITE;
/*!40000 ALTER TABLE `Course` DISABLE KEYS */;
/*!40000 ALTER TABLE `Course` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `District`
--

DROP TABLE IF EXISTS `District`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `District` (
  `districtId` int(2) NOT NULL default '0',
  `districtName` varchar(30) NOT NULL default '',
  `districtNameEng` varchar(30) NOT NULL default '',
  `amphurId` int(2) NOT NULL default '0',
  `provinceId` int(2) NOT NULL default '0',
  PRIMARY KEY  (`districtId`),
  KEY `amphurId` (`amphurId`),
  KEY `provinceId` (`provinceId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `District`
--

LOCK TABLES `District` WRITE;
/*!40000 ALTER TABLE `District` DISABLE KEYS */;
/*!40000 ALTER TABLE `District` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Docombook_tb`
--

DROP TABLE IF EXISTS `Docombook_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Docombook_tb` (
  `codeId` int(11) NOT NULL auto_increment,
  `code` int(11) NOT NULL default '0',
  `workGpId` int(11) NOT NULL default '0',
  `Year` int(4) NOT NULL default '0',
  `Teacher_code` int(5) NOT NULL default '0',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Status` text NOT NULL,
  PRIMARY KEY  (`codeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Docombook_tb`
--

LOCK TABLES `Docombook_tb` WRITE;
/*!40000 ALTER TABLE `Docombook_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `Docombook_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Docontion_tb`
--

DROP TABLE IF EXISTS `Docontion_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Docontion_tb` (
  `conditionId` int(3) NOT NULL auto_increment,
  `Docom_name` varchar(255) NOT NULL default '',
  `Img1` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`conditionId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Docontion_tb`
--

LOCK TABLES `Docontion_tb` WRITE;
/*!40000 ALTER TABLE `Docontion_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `Docontion_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Document_tb`
--

DROP TABLE IF EXISTS `Document_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Document_tb` (
  `codeId` int(11) NOT NULL auto_increment,
  `Docom_name` varchar(255) NOT NULL default '',
  `conditionId` int(11) NOT NULL default '0',
  `Img1` varchar(155) NOT NULL default '',
  PRIMARY KEY  (`codeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Document_tb`
--

LOCK TABLES `Document_tb` WRITE;
/*!40000 ALTER TABLE `Document_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `Document_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `FormAoffice`
--

DROP TABLE IF EXISTS `FormAoffice`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `FormAoffice` (
  `codeId` int(11) NOT NULL auto_increment,
  `code` int(11) NOT NULL default '0',
  `ProjectId` int(11) NOT NULL default '0',
  `Training_type` int(11) NOT NULL default '0',
  `Teacher_code` int(5) NOT NULL default '0',
  `Training_name` varchar(150) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `Day` varchar(4) NOT NULL default '',
  `Detail` varchar(50) NOT NULL default '',
  `Year_std` varchar(4) NOT NULL default '',
  `TeacherId` int(5) NOT NULL default '0',
  `Flag1` char(2) NOT NULL default '',
  `Flag2` char(2) NOT NULL default '',
  `No_in` varchar(50) NOT NULL default '',
  `Training_code` int(11) NOT NULL default '0',
  `Budget_use` float NOT NULL default '0',
  PRIMARY KEY  (`codeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `FormAoffice`
--

LOCK TABLES `FormAoffice` WRITE;
/*!40000 ALTER TABLE `FormAoffice` DISABLE KEYS */;
/*!40000 ALTER TABLE `FormAoffice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Prefix`
--

DROP TABLE IF EXISTS `Prefix`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Prefix` (
  `prefixId` int(2) NOT NULL default '0',
  `prefixName` varchar(100) NOT NULL default '',
  `prefixNameEng` varchar(100) NOT NULL default '',
  `defaultSex` char(1) default NULL,
  PRIMARY KEY  (`prefixId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Prefix`
--

LOCK TABLES `Prefix` WRITE;
/*!40000 ALTER TABLE `Prefix` DISABLE KEYS */;
/*!40000 ALTER TABLE `Prefix` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Program`
--

DROP TABLE IF EXISTS `Program`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Program` (
  `programId` int(12) NOT NULL default '0',
  `programCode` varchar(8) NOT NULL default '',
  `programYear` int(4) NOT NULL default '0',
  `degreeId` int(2) NOT NULL default '0',
  `levelId` int(2) NOT NULL default '0',
  `programName` varchar(100) NOT NULL default '',
  `programNameEng` varchar(100) NOT NULL default '',
  `programAbbr` varchar(35) NOT NULL default '',
  `programAbbrEng` varchar(35) NOT NULL default '',
  `creditTotal` float NOT NULL default '0',
  `description` text,
  `descriptionEng` text,
  `studyYearMax` int(2) NOT NULL default '0',
  `gradePointMin` float NOT NULL default '0',
  `createDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `createUserId` varchar(20) NOT NULL default '',
  `updateDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `updateUserId` varchar(20) NOT NULL default '',
  `semesterPerYear` int(1) NOT NULL default '0',
  `programStatus` char(1) NOT NULL default 'Y',
  `studyYear` int(1) NOT NULL default '0',
  `programConfId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`programId`),
  KEY `degreeId` (`degreeId`),
  KEY `levelId` (`levelId`),
  KEY `programConfId` (`programConfId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Program`
--

LOCK TABLES `Program` WRITE;
/*!40000 ALTER TABLE `Program` DISABLE KEYS */;
/*!40000 ALTER TABLE `Program` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Province`
--

DROP TABLE IF EXISTS `Province`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Province` (
  `provinceId` int(2) NOT NULL default '0',
  `provinceName` varchar(30) NOT NULL default '',
  `provinceNameEng` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`provinceId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Province`
--

LOCK TABLES `Province` WRITE;
/*!40000 ALTER TABLE `Province` DISABLE KEYS */;
/*!40000 ALTER TABLE `Province` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `Status`
--

DROP TABLE IF EXISTS `Status`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `Status` (
  `StatusId` int(2) NOT NULL default '0',
  `StatusTh` varchar(50) NOT NULL default '',
  `StatusEng` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`StatusId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `Status`
--

LOCK TABLES `Status` WRITE;
/*!40000 ALTER TABLE `Status` DISABLE KEYS */;
/*!40000 ALTER TABLE `Status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `WorkGroup`
--

DROP TABLE IF EXISTS `WorkGroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `WorkGroup` (
  `workGpId` int(11) NOT NULL default '0',
  `deptId` int(11) NOT NULL default '0',
  `workGpName` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`workGpId`),
  KEY `deptId` (`deptId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `WorkGroup`
--

LOCK TABLES `WorkGroup` WRITE;
/*!40000 ALTER TABLE `WorkGroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `WorkGroup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `accessories_tb`
--

DROP TABLE IF EXISTS `accessories_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `accessories_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Acc_code` varchar(100) NOT NULL default '',
  `Acc_name` varchar(255) NOT NULL default '',
  `Acc_type_code` int(5) NOT NULL default '0',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Store` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Fix_History` text NOT NULL,
  `Contact` text NOT NULL,
  `Date_buy` date NOT NULL default '0000-00-00',
  `Price` float(9,2) NOT NULL default '0.00',
  `Fix_budget` float(9,2) NOT NULL default '0.00',
  `Status` varchar(255) NOT NULL default '',
  `Statistic` text NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY  (`code`),
  KEY `Faculty_code` (`Faculty_code`),
  KEY `Acc_type_code` (`Acc_type_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `accessories_tb`
--

LOCK TABLES `accessories_tb` WRITE;
/*!40000 ALTER TABLE `accessories_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `accessories_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `accessories_type_tb`
--

DROP TABLE IF EXISTS `accessories_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `accessories_type_tb` (
  `Acc_type_code` int(5) NOT NULL auto_increment,
  `Acc_type` varchar(255) NOT NULL default '',
  `Acc_Etype` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Acc_type_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `accessories_type_tb`
--

LOCK TABLES `accessories_type_tb` WRITE;
/*!40000 ALTER TABLE `accessories_type_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `accessories_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `account`
--

DROP TABLE IF EXISTS `account`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `account` (
  `Teach_id` int(4) NOT NULL auto_increment,
  `Teacher_code` int(5) NOT NULL default '0',
  `HN_code` varchar(10) NOT NULL default '0',
  `No_code` int(7) NOT NULL default '0',
  `Person_code` int(5) unsigned zerofill NOT NULL default '00000',
  `Tooth_code` varchar(8) NOT NULL default '',
  `Code` int(3) NOT NULL default '0',
  `Date` date NOT NULL default '0000-00-00',
  `Time_in` time NOT NULL default '00:00:00',
  `Time_out` time NOT NULL default '00:00:00',
  `Price` float(8,2) NOT NULL default '0.00',
  `Teach_code` int(3) unsigned zerofill NOT NULL default '000',
  `Dentis_code` int(2) unsigned NOT NULL default '0',
  `Mount` varchar(5) NOT NULL default '',
  `Cost_total` float(8,2) NOT NULL default '0.00',
  `Roug` tinyint(1) unsigned NOT NULL default '0',
  `Hostpital` int(1) unsigned zerofill NOT NULL default '0',
  `Percen` int(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Teach_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `account`
--

LOCK TABLES `account` WRITE;
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `accountMed_db`
--

DROP TABLE IF EXISTS `accountMed_db`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `accountMed_db` (
  `Teach_id` int(4) NOT NULL auto_increment,
  `Teacher_code` int(5) NOT NULL default '0',
  `massegeId` int(2) NOT NULL default '0',
  `HN_code` varchar(10) NOT NULL default '0',
  `No` int(3) unsigned zerofill NOT NULL default '000',
  `No_code` int(3) unsigned zerofill NOT NULL default '000',
  `personId` int(11) NOT NULL default '0',
  `Tooth_code` varchar(8) NOT NULL default '',
  `Code` int(3) NOT NULL default '0',
  `Date` date NOT NULL default '0000-00-00',
  `Time_in` time NOT NULL default '00:00:00',
  `Time_out` time NOT NULL default '00:00:00',
  `Price` float(8,2) NOT NULL default '0.00',
  `Teach_code` int(3) NOT NULL default '0',
  `Dentis_code` int(2) unsigned NOT NULL default '0',
  `Mount` varchar(5) NOT NULL default '',
  `Cost_total` float(8,2) NOT NULL default '0.00',
  `Roug` tinyint(1) unsigned NOT NULL default '0',
  `prefixId` int(2) NOT NULL default '0',
  `Percen` int(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Teach_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `accountMed_db`
--

LOCK TABLES `accountMed_db` WRITE;
/*!40000 ALTER TABLE `accountMed_db` DISABLE KEYS */;
/*!40000 ALTER TABLE `accountMed_db` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `accounts` (
  `id` varchar(20) NOT NULL default '',
  `Paydate` varchar(15) NOT NULL default '',
  `code` varchar(10) NOT NULL default '',
  `code_1` varchar(10) NOT NULL default '',
  `name` varchar(100) NOT NULL default '',
  `Mainjob` varchar(100) NOT NULL default '',
  `TypeM` varchar(50) NOT NULL default '',
  `GPyear` varchar(80) NOT NULL default '',
  `year` varchar(50) NOT NULL default '',
  `prince_1` varchar(50) NOT NULL default '',
  `prince` varchar(20) NOT NULL default '',
  `Budget` varchar(200) NOT NULL default '',
  `BUDSUM` varchar(20) NOT NULL default '',
  `Percent` varchar(10) NOT NULL default '',
  `Discrition` varchar(200) NOT NULL default '',
  `Sdate` varchar(20) NOT NULL default '',
  `Fdate` varchar(20) NOT NULL default '',
  `question` varchar(200) NOT NULL default '',
  `Discrition_1` varchar(200) NOT NULL default '',
  `Discrition_2` varchar(200) NOT NULL default '',
  `Discrition_3` varchar(200) NOT NULL default '',
  `Subject` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `accounts`
--

LOCK TABLES `accounts` WRITE;
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `advice_problem_tb`
--

DROP TABLE IF EXISTS `advice_problem_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `advice_problem_tb` (
  `Prob_code` int(10) NOT NULL auto_increment,
  `Problem` tinyint(1) NOT NULL default '0',
  `officerId1` int(3) NOT NULL,
  `studentCode` varchar(10) NOT NULL,
  `prefixId` int(5) NOT NULL,
  `studentName` varchar(155) NOT NULL,
  `studentSurname` varchar(155) NOT NULL,
  `Prob1` varchar(100) NOT NULL default '',
  `Prob2` varchar(100) NOT NULL default '',
  `Prob3` varchar(100) NOT NULL default '',
  `Prob4` varchar(100) NOT NULL default '',
  `Prob_detail1` text NOT NULL,
  `Prob_detail2` text NOT NULL,
  `Prob_detail3` text NOT NULL,
  `Prob_detail4` text NOT NULL,
  `Recom` text NOT NULL,
  `Date_meet` date NOT NULL default '0000-00-00',
  `Unit_meet` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Prob_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `advice_problem_tb`
--

LOCK TABLES `advice_problem_tb` WRITE;
/*!40000 ALTER TABLE `advice_problem_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `advice_problem_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bookPerson_tb`
--

DROP TABLE IF EXISTS `bookPerson_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `bookPerson_tb` (
  `pcodeId` int(11) NOT NULL auto_increment,
  `code` int(11) NOT NULL default '0',
  `Date_buy` date NOT NULL default '0000-00-00',
  `No` varchar(10) NOT NULL default '0',
  `No_in` varchar(150) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Statistic` varchar(200) NOT NULL default '',
  `Year` int(4) NOT NULL default '0',
  `Description` text NOT NULL,
  PRIMARY KEY  (`pcodeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `bookPerson_tb`
--

LOCK TABLES `bookPerson_tb` WRITE;
/*!40000 ALTER TABLE `bookPerson_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `bookPerson_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bookmant_tb`
--

DROP TABLE IF EXISTS `bookmant_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `bookmant_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Book_code` int(1) NOT NULL default '0',
  `conditionId` int(3) NOT NULL default '0',
  `Year` int(4) NOT NULL default '0',
  `No` varchar(10) NOT NULL default '0',
  `No_in` varchar(50) NOT NULL default '',
  `No_out` varchar(50) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Faculty_code` tinyint(2) unsigned zerofill NOT NULL default '00',
  `Store_1` varchar(200) NOT NULL default '',
  `Store_2` varchar(200) NOT NULL default '',
  `Img1` varchar(50) NOT NULL default '',
  `Date_buy` date NOT NULL default '0000-00-00',
  `Date_year` date NOT NULL default '0000-00-00',
  `Status` text NOT NULL,
  `Statistic` varchar(200) NOT NULL default '',
  `Description` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `bookmant_tb`
--

LOCK TABLES `bookmant_tb` WRITE;
/*!40000 ALTER TABLE `bookmant_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `bookmant_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `building_tb`
--

DROP TABLE IF EXISTS `building_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `building_tb` (
  `BuildD_No` int(5) NOT NULL auto_increment,
  `BuildD_ID` varchar(10) NOT NULL default '',
  `Build_name` varchar(100) NOT NULL default '',
  `Build_type` varchar(100) NOT NULL default '',
  `Img1` varchar(155) NOT NULL default '',
  `Short_name` varchar(50) NOT NULL default '',
  `Class_unit` int(11) NOT NULL default '0',
  `Room_unit` int(11) NOT NULL default '0',
  `BuildD_Yr` date NOT NULL default '0000-00-00',
  `BuildD_Pr` varchar(20) NOT NULL default '',
  `MoneyS_C` int(5) NOT NULL default '0',
  `Description` text NOT NULL,
  PRIMARY KEY  (`BuildD_No`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `building_tb`
--

LOCK TABLES `building_tb` WRITE;
/*!40000 ALTER TABLE `building_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `building_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `building_type_tb`
--

DROP TABLE IF EXISTS `building_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `building_type_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Type_name` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `building_type_tb`
--

LOCK TABLES `building_type_tb` WRITE;
/*!40000 ALTER TABLE `building_type_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `building_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comment_tb`
--

DROP TABLE IF EXISTS `comment_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `comment_tb` (
  `Info_code` int(5) NOT NULL auto_increment,
  `Info_name` varchar(100) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `Info_detail` text NOT NULL,
  `Organiz` varchar(100) NOT NULL default '',
  `Supervisor` varchar(100) NOT NULL default '',
  `Flag` char(2) NOT NULL default '',
  PRIMARY KEY  (`Info_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `comment_tb`
--

LOCK TABLES `comment_tb` WRITE;
/*!40000 ALTER TABLE `comment_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `comment_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `committee_tb`
--

DROP TABLE IF EXISTS `committee_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `committee_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Title` varchar(255) NOT NULL default '',
  `Year_com` varchar(10) NOT NULL default '',
  `Edu` varchar(100) NOT NULL default '',
  `Edu_job` varchar(100) NOT NULL default '',
  `Tsis` varchar(100) NOT NULL default '',
  `Check_tool` varchar(150) NOT NULL default '00:00:00',
  `Scp10` varchar(100) NOT NULL default '',
  `Club_bcnlp` varchar(100) NOT NULL default '',
  `North_network` varchar(100) NOT NULL default '0',
  `Else_commit` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `committee_tb`
--

LOCK TABLES `committee_tb` WRITE;
/*!40000 ALTER TABLE `committee_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `committee_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `course_tb`
--

DROP TABLE IF EXISTS `course_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `course_tb` (
  `Course_code` tinyint(5) unsigned zerofill NOT NULL auto_increment,
  `Course_id` varchar(5) NOT NULL default '',
  `Course_name` varchar(255) NOT NULL default '',
  `Course_nameE` varchar(255) NOT NULL default '',
  `Degree_Thai` varchar(255) NOT NULL default '',
  `Short_Thai` varchar(255) NOT NULL default '',
  `Degree_Eng` varchar(255) NOT NULL default '',
  `Short_Eng` varchar(255) NOT NULL default '',
  `Course_type` varchar(50) NOT NULL default '',
  `TotalUnit` varchar(30) NOT NULL default '',
  `Term` varchar(30) NOT NULL default '',
  `Spec` text NOT NULL,
  `Affect_class` text NOT NULL,
  `Course_desc` text NOT NULL,
  PRIMARY KEY  (`Course_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `course_tb`
--

LOCK TABLES `course_tb` WRITE;
/*!40000 ALTER TABLE `course_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `course_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cul_activity_tb`
--

DROP TABLE IF EXISTS `cul_activity_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `cul_activity_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Activity_name` varchar(255) NOT NULL default '',
  `Activity_type` varchar(255) NOT NULL default '',
  `Perform` varchar(50) NOT NULL default '',
  `Activity` varchar(255) NOT NULL default '',
  `Period` varchar(255) NOT NULL default '0000-00-00',
  `Fund` float(8,2) NOT NULL default '0.00',
  `Source` text NOT NULL,
  `Target` varchar(255) NOT NULL default '',
  `Amount` varchar(255) NOT NULL default '',
  `Supervisor` text NOT NULL,
  `Duty` varchar(100) NOT NULL default '',
  `Objective` text NOT NULL,
  `Index_mature` text NOT NULL,
  `Spec` text NOT NULL,
  `Affect_class` text NOT NULL,
  `Asses` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `cul_activity_tb`
--

LOCK TABLES `cul_activity_tb` WRITE;
/*!40000 ALTER TABLE `cul_activity_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `cul_activity_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `degree_tb`
--

DROP TABLE IF EXISTS `degree_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `degree_tb` (
  `Degree_code` int(5) NOT NULL auto_increment,
  `Degree_name` varchar(60) NOT NULL default '',
  `Rate` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`Degree_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `degree_tb`
--

LOCK TABLES `degree_tb` WRITE;
/*!40000 ALTER TABLE `degree_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `degree_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `degree_type_tb`
--

DROP TABLE IF EXISTS `degree_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `degree_type_tb` (
  `Type_Degree` int(3) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`Type_Degree`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `degree_type_tb`
--

LOCK TABLES `degree_type_tb` WRITE;
/*!40000 ALTER TABLE `degree_type_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `degree_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dentis_tb`
--

DROP TABLE IF EXISTS `dentis_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `dentis_tb` (
  `Dentis_code` int(2) NOT NULL auto_increment,
  `Person_code` int(5) NOT NULL default '0',
  `Class` varchar(100) NOT NULL default '',
  `Orderlist` varchar(5) NOT NULL default '0',
  `Dental_code` int(6) NOT NULL default '0',
  `First_name` varchar(30) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Lastname` varchar(100) NOT NULL default '',
  `Sex` varchar(10) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Religion` varchar(30) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Name_eng` varchar(155) NOT NULL default '',
  `Lastname_eng` varchar(155) NOT NULL default '',
  `ProvinceId` int(2) unsigned NOT NULL default '0',
  `Phone_1` varchar(10) NOT NULL default '',
  `Phone_2` varchar(10) NOT NULL default '',
  `Email` varchar(155) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Datetype` date NOT NULL default '0000-00-00',
  `Panal_code` int(5) NOT NULL default '0',
  `Year_1` varchar(5) NOT NULL default '00000',
  `Flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`Dentis_code`,`Dental_code`),
  UNIQUE KEY `code` (`Dentis_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `dentis_tb`
--

LOCK TABLES `dentis_tb` WRITE;
/*!40000 ALTER TABLE `dentis_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `dentis_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `descriptionplan_tb`
--

DROP TABLE IF EXISTS `descriptionplan_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `descriptionplan_tb` (
  `Code` int(6) NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `descriptionplan_tb`
--

LOCK TABLES `descriptionplan_tb` WRITE;
/*!40000 ALTER TABLE `descriptionplan_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `descriptionplan_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `diagnosis_tb`
--

DROP TABLE IF EXISTS `diagnosis_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `diagnosis_tb` (
  `Code` int(6) NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `diagnosis_tb`
--

LOCK TABLES `diagnosis_tb` WRITE;
/*!40000 ALTER TABLE `diagnosis_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `diagnosis_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `edu_product_tb`
--

DROP TABLE IF EXISTS `edu_product_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `edu_product_tb` (
  `Prod_code` int(10) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Product_name` varchar(255) NOT NULL default '',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `Term` varchar(4) NOT NULL default '',
  `Product_type` varchar(100) NOT NULL default '00000',
  `name1` int(5) NOT NULL default '0',
  `name2` int(5) NOT NULL default '0',
  `name3` int(5) NOT NULL default '0',
  `name4` int(5) NOT NULL default '0',
  `name5` int(5) NOT NULL default '0',
  `name6` int(5) NOT NULL default '0',
  `name7` int(5) NOT NULL default '0',
  `Fund_resource` varchar(100) NOT NULL default '',
  `Fund` varchar(100) NOT NULL default '',
  `Propagate` varchar(100) NOT NULL default '',
  `Benefit` text NOT NULL,
  `Use_ref` text NOT NULL,
  PRIMARY KEY  (`Prod_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `edu_product_tb`
--

LOCK TABLES `edu_product_tb` WRITE;
/*!40000 ALTER TABLE `edu_product_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `edu_product_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `edu_project_tb`
--

DROP TABLE IF EXISTS `edu_project_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `edu_project_tb` (
  `Project_code` int(11) NOT NULL auto_increment,
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Project_name` text NOT NULL,
  `Addwork` text NOT NULL,
  `Project_desc` text NOT NULL,
  `Period` varchar(255) NOT NULL default '',
  `Start_Date` varchar(255) NOT NULL default '',
  `Super` text NOT NULL,
  `Supervisor` text NOT NULL,
  `Term` varchar(4) NOT NULL default '',
  `Budget_Year` varchar(4) NOT NULL default '',
  `Budget` float(9,2) NOT NULL default '0.00',
  `Budget_use` float(9,2) NOT NULL default '0.00',
  `Percent_ans` int(11) NOT NULL default '0',
  `Result_oper` char(1) NOT NULL default '',
  `Dif_result` float(9,2) NOT NULL default '0.00',
  `Flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`Project_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `edu_project_tb`
--

LOCK TABLES `edu_project_tb` WRITE;
/*!40000 ALTER TABLE `edu_project_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `edu_project_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `edu_service_tb`
--

DROP TABLE IF EXISTS `edu_service_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `edu_service_tb` (
  `Project_code` int(11) NOT NULL auto_increment,
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Project_name` varchar(255) NOT NULL default '',
  `Period` varchar(150) NOT NULL default '00:00:00',
  `Date_start` date NOT NULL default '0000-00-00',
  `Term` varchar(4) NOT NULL default '',
  `Res` char(2) NOT NULL default '',
  `Detail` varchar(100) NOT NULL default '',
  `Year_budget` varchar(4) NOT NULL default '',
  `Budget` float(10,2) NOT NULL default '0.00',
  `Budget_use` float(10,2) NOT NULL default '0.00',
  `Target_group` int(10) NOT NULL default '0',
  `Objective` text NOT NULL,
  `Fund_support` varchar(200) NOT NULL default '',
  `Fee` float(10,2) NOT NULL default '0.00',
  `Response` varchar(100) NOT NULL default '',
  `Total_time_project` int(11) NOT NULL default '0',
  `Total_time_insi` int(11) NOT NULL default '0',
  `Total_time_inso` int(11) NOT NULL default '0',
  `Dif_result` float(8,2) NOT NULL default '0.00',
  `Result_oper` char(1) NOT NULL default '0',
  `Img1` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Project_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `edu_service_tb`
--

LOCK TABLES `edu_service_tb` WRITE;
/*!40000 ALTER TABLE `edu_service_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `edu_service_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faculty_tb`
--

DROP TABLE IF EXISTS `faculty_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `faculty_tb` (
  `Faculty_code` int(2) unsigned zerofill NOT NULL auto_increment,
  `Faculty_name` varchar(255) NOT NULL default '',
  `Faculty_nameE` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Faculty_code`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `faculty_tb`
--

LOCK TABLES `faculty_tb` WRITE;
/*!40000 ALTER TABLE `faculty_tb` DISABLE KEYS */;
INSERT INTO `faculty_tb` VALUES (01,'ฝ่ายบริหาร','Management Department'),(02,'ฝ่ายวิชาการ',''),(03,'ฝ่ายกิจการนักศึกษา','Student Activity  Department'),(04,'ฝ่ายวางแผนและพัฒนา','Planning and Development Department'),(06,'ภาควิชาเทคนิคเภสัช',' Pharmacy Department'),(07,'ภาควิชาทันตสาธารณสุข','Dental Department'),(08,'ภาควิชาสาธารณสุขชุมชน','Community Health Department'),(09,'ภาควิชาสาธารณสุขศาสตร์','Bechelor of Public Health Department'),(10,'ศูนย์พัฒนาบุคลากร','Human Development Department'),(12,'หน่วยประกันคุณภาพการศึกษา',''),(13,'หน่วยควบคุมภายใน',''),(15,'ภาควิชาแพทย์แผนไทยประยุกต์','Thai Traditional Medicine Deparment'),(16,'หน่วยวิจัย','-'),(17,'ภาควิชาเวชกิจฉุกเฉิน','-'),(18,'ศูนย์ศึกษาฯ','-');
/*!40000 ALTER TABLE `faculty_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `finance2_tb`
--

DROP TABLE IF EXISTS `finance2_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `finance2_tb` (
  `code` int(10) NOT NULL auto_increment,
  `Year_budget` varchar(4) NOT NULL default '0',
  `Month` int(4) NOT NULL default '0',
  `Date_note` date NOT NULL default '0000-00-00',
  `Cost1` float(8,2) NOT NULL default '0.00',
  `Cost2` float(8,2) NOT NULL default '0.00',
  `Cost3` float(8,2) NOT NULL default '0.00',
  `Cost4` float(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (`code`,`Year_budget`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `finance2_tb`
--

LOCK TABLES `finance2_tb` WRITE;
/*!40000 ALTER TABLE `finance2_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `finance2_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `finance3_tb`
--

DROP TABLE IF EXISTS `finance3_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `finance3_tb` (
  `code` int(10) NOT NULL auto_increment,
  `Year_budget` varchar(4) NOT NULL default '0',
  `Month` int(4) NOT NULL default '0',
  `Date_note` date NOT NULL default '0000-00-00',
  `Cost1` float(8,2) NOT NULL default '0.00',
  `Cost2` float(8,2) NOT NULL default '0.00',
  `Cost3` float(8,2) NOT NULL default '0.00',
  `Cost4` float(8,2) NOT NULL default '0.00',
  `Cost5` float(8,2) NOT NULL default '0.00',
  `Cost6` float(8,2) NOT NULL default '0.00',
  `Cost7` float(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (`code`,`Year_budget`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `finance3_tb`
--

LOCK TABLES `finance3_tb` WRITE;
/*!40000 ALTER TABLE `finance3_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `finance3_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `finance4_tb`
--

DROP TABLE IF EXISTS `finance4_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `finance4_tb` (
  `code` int(10) NOT NULL auto_increment,
  `Year_budget` varchar(4) NOT NULL default '0',
  `Month` int(4) NOT NULL default '0',
  `Date_note` date NOT NULL default '0000-00-00',
  `Cost1` float(8,2) NOT NULL default '0.00',
  `Cost2` float(8,2) NOT NULL default '0.00',
  `Cost3` float(8,2) NOT NULL default '0.00',
  `Cost4` float(8,2) NOT NULL default '0.00',
  `Cost5` float(8,2) NOT NULL default '0.00',
  `Cost6` float(8,2) NOT NULL default '0.00',
  `Cost7` float(8,2) NOT NULL default '0.00',
  `Cost8` float(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (`code`,`Year_budget`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `finance4_tb`
--

LOCK TABLES `finance4_tb` WRITE;
/*!40000 ALTER TABLE `finance4_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `finance4_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `foreign_relation_tb`
--

DROP TABLE IF EXISTS `foreign_relation_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `foreign_relation_tb` (
  `code` int(10) NOT NULL auto_increment,
  `Project_name` varchar(200) NOT NULL default '',
  `Term` varchar(4) NOT NULL default '',
  `Budget_Year` varchar(4) NOT NULL default '',
  `Objective` text NOT NULL,
  `Target` varchar(200) NOT NULL default '',
  `Period` varchar(200) NOT NULL default '',
  `Start_Date` varchar(255) NOT NULL default '',
  `Budget` float(8,2) NOT NULL default '0.00',
  `Budget_use` float(8,2) NOT NULL default '0.00',
  `Dif_result` float(8,2) NOT NULL default '0.00',
  `Fund_resource` varchar(200) NOT NULL default '',
  `Director` varchar(100) NOT NULL default '',
  `Join_co` varchar(100) NOT NULL default '',
  `Join_type` varchar(100) NOT NULL default '',
  `Result_oper` char(1) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `foreign_relation_tb`
--

LOCK TABLES `foreign_relation_tb` WRITE;
/*!40000 ALTER TABLE `foreign_relation_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `foreign_relation_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `formation_tb`
--

DROP TABLE IF EXISTS `formation_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `formation_tb` (
  `Code` int(5) NOT NULL auto_increment,
  `InforName` varchar(255) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `InforDetail` text NOT NULL,
  `Teacher_code` int(5) NOT NULL default '0',
  `Flage` char(2) NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `formation_tb`
--

LOCK TABLES `formation_tb` WRITE;
/*!40000 ALTER TABLE `formation_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `formation_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grade_tb`
--

DROP TABLE IF EXISTS `grade_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `grade_tb` (
  `code` int(5) unsigned zerofill NOT NULL auto_increment,
  `Student_id` varchar(10) NOT NULL default '00000',
  `Class` char(2) NOT NULL default '',
  `Term` tinyint(5) NOT NULL default '0',
  `Tb` int(11) NOT NULL default '0',
  `Tp` int(11) NOT NULL default '0',
  `Total` int(11) NOT NULL default '0',
  `Gpa` float(8,2) NOT NULL default '0.00',
  `Total_Unit` float(8,2) NOT NULL default '0.00',
  `Total_Gpa` float(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `grade_tb`
--

LOCK TABLES `grade_tb` WRITE;
/*!40000 ALTER TABLE `grade_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `grade_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history_absent`
--

DROP TABLE IF EXISTS `history_absent`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history_absent` (
  `code` int(2) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Absent_code` int(2) unsigned zerofill NOT NULL default '00',
  `Absent_times` int(2) unsigned zerofill NOT NULL default '00',
  `Year` int(4) NOT NULL default '0',
  PRIMARY KEY  (`code`,`Teacher_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history_absent`
--

LOCK TABLES `history_absent` WRITE;
/*!40000 ALTER TABLE `history_absent` DISABLE KEYS */;
/*!40000 ALTER TABLE `history_absent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history_absent01_tb`
--

DROP TABLE IF EXISTS `history_absent01_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history_absent01_tb` (
  `Absent_code` int(2) NOT NULL auto_increment,
  `Absent_type` varchar(100) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Absent_01` int(2) unsigned NOT NULL default '0',
  `Absent_02` int(2) unsigned NOT NULL default '0',
  `Absent_03` int(2) unsigned NOT NULL default '0',
  `Absent_04` int(2) unsigned NOT NULL default '0',
  `Absent_05` int(2) unsigned NOT NULL default '0',
  `Absent_06` int(2) unsigned NOT NULL default '0',
  `Absent_times` int(10) NOT NULL default '0',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `Unit_count` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`Absent_code`,`Teacher_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history_absent01_tb`
--

LOCK TABLES `history_absent01_tb` WRITE;
/*!40000 ALTER TABLE `history_absent01_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `history_absent01_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history_absent_tb`
--

DROP TABLE IF EXISTS `history_absent_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history_absent_tb` (
  `code` int(6) NOT NULL auto_increment,
  `Absent_code` int(2) unsigned zerofill NOT NULL default '00',
  `Year` int(4) NOT NULL default '0',
  `Absent_type` varchar(100) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Absent_times` varchar(5) NOT NULL default '0',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `Unit_count` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`code`,`Teacher_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history_absent_tb`
--

LOCK TABLES `history_absent_tb` WRITE;
/*!40000 ALTER TABLE `history_absent_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `history_absent_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history_decoration_tb`
--

DROP TABLE IF EXISTS `history_decoration_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history_decoration_tb` (
  `Code` int(10) NOT NULL auto_increment,
  `Decoration_name` varchar(100) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Year_receive` int(4) NOT NULL default '0',
  `Volumn` varchar(100) NOT NULL default '',
  `Col` varchar(100) NOT NULL default '',
  `Page` varchar(10) NOT NULL default '',
  `Orderlist` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history_decoration_tb`
--

LOCK TABLES `history_decoration_tb` WRITE;
/*!40000 ALTER TABLE `history_decoration_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `history_decoration_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `history_position_tb`
--

DROP TABLE IF EXISTS `history_position_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `history_position_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Position_id` varchar(20) NOT NULL default '',
  `Date_post` date NOT NULL default '0000-00-00',
  `Gover_pos` varchar(100) NOT NULL default '',
  `Manage_pos` varchar(100) NOT NULL default '',
  `Level` varchar(10) NOT NULL default '',
  `Salary` int(10) NOT NULL default '0',
  `Skill` text NOT NULL,
  `Order_id` varchar(30) NOT NULL default '',
  `Ref_doc` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `history_position_tb`
--

LOCK TABLES `history_position_tb` WRITE;
/*!40000 ALTER TABLE `history_position_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `history_position_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hospital`
--

DROP TABLE IF EXISTS `hospital`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `hospital` (
  `Hostpital` int(5) NOT NULL auto_increment,
  `Hostpital_name` varchar(50) NOT NULL default '',
  `picture` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`Hostpital`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `hospital`
--

LOCK TABLES `hospital` WRITE;
/*!40000 ALTER TABLE `hospital` DISABLE KEYS */;
/*!40000 ALTER TABLE `hospital` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `information_tb`
--

DROP TABLE IF EXISTS `information_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `information_tb` (
  `Info_code` int(11) NOT NULL auto_increment,
  `Info_name` varchar(100) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `Info_detail` text NOT NULL,
  `Organiz` varchar(100) NOT NULL default '',
  `Supervisor` varchar(100) NOT NULL default '',
  `Flag` char(2) NOT NULL default '',
  PRIMARY KEY  (`Info_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `information_tb`
--

LOCK TABLES `information_tb` WRITE;
/*!40000 ALTER TABLE `information_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `information_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `instructor_tb`
--

DROP TABLE IF EXISTS `instructor_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `instructor_tb` (
  `code` int(11) NOT NULL auto_increment,
  `First_name` varchar(20) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Lastname` varchar(100) NOT NULL default '',
  `Sex` varchar(100) NOT NULL default '',
  `Status` char(1) NOT NULL default '',
  `Degree` varchar(200) character set tis620 collate tis620_bin NOT NULL default '',
  `Exper` varchar(100) NOT NULL default '',
  `Skill` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Addr_work` text NOT NULL,
  `Addr_home` text NOT NULL,
  `Tel` varchar(15) NOT NULL default '',
  `Email` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `instructor_tb`
--

LOCK TABLES `instructor_tb` WRITE;
/*!40000 ALTER TABLE `instructor_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `instructor_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `labtype_tb`
--

DROP TABLE IF EXISTS `labtype_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `labtype_tb` (
  `Code` int(6) NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Lab` text NOT NULL,
  `Description` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `labtype_tb`
--

LOCK TABLES `labtype_tb` WRITE;
/*!40000 ALTER TABLE `labtype_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `labtype_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `magazine_tb`
--

DROP TABLE IF EXISTS `magazine_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `magazine_tb` (
  `code_mag` int(10) NOT NULL auto_increment,
  `Magazine_name` varchar(100) NOT NULL default '',
  `Magazine_type` varchar(100) NOT NULL default '',
  `Ex_article` text NOT NULL,
  `Author` varchar(255) NOT NULL default '',
  `Vol` varchar(100) NOT NULL default '',
  `Year` varchar(4) NOT NULL default '',
  `Month` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`code_mag`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `magazine_tb`
--

LOCK TABLES `magazine_tb` WRITE;
/*!40000 ALTER TABLE `magazine_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `magazine_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manage_tb`
--

DROP TABLE IF EXISTS `manage_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `manage_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Acc_code` varchar(100) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Student_id` varchar(10) NOT NULL default '',
  `Acc_name` varchar(255) NOT NULL default '',
  `Store` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Fix_History` text NOT NULL,
  `Contact` text NOT NULL,
  `Date_buy` date NOT NULL default '0000-00-00',
  `Date_year` date NOT NULL default '0000-00-00',
  `Price` float(8,2) NOT NULL default '0.00',
  `Fix_budget` float(8,2) NOT NULL default '0.00',
  `Status` varchar(255) NOT NULL default '',
  `Status_1` varchar(150) NOT NULL default '',
  `Statistic` text NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `manage_tb`
--

LOCK TABLES `manage_tb` WRITE;
/*!40000 ALTER TABLE `manage_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `manage_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manament_tb`
--

DROP TABLE IF EXISTS `manament_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `manament_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Acc_code` varchar(100) NOT NULL default '',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Teacher_code` int(3) NOT NULL default '0',
  `Student_id` varchar(10) NOT NULL default '',
  `Acc_name` varchar(255) NOT NULL default '',
  `Store` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Fix_History` text NOT NULL,
  `Contact` text NOT NULL,
  `Date_buy` date NOT NULL default '0000-00-00',
  `Date_year` date NOT NULL default '0000-00-00',
  `Price` float(8,2) NOT NULL default '0.00',
  `Fix_budget` float(8,2) NOT NULL default '0.00',
  `Status` varchar(255) NOT NULL default '',
  `Status_1` varchar(150) NOT NULL default '',
  `Statistic` text NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `manament_tb`
--

LOCK TABLES `manament_tb` WRITE;
/*!40000 ALTER TABLE `manament_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `manament_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `massege_db`
--

DROP TABLE IF EXISTS `massege_db`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `massege_db` (
  `massegeId` int(3) NOT NULL auto_increment,
  `Person_code` int(5) NOT NULL default '0',
  `Class` varchar(100) NOT NULL default '',
  `Orderlist` varchar(5) NOT NULL default '0',
  `Dental_code` int(6) NOT NULL default '0',
  `First_name` varchar(30) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Lastname` varchar(100) NOT NULL default '',
  `Sex` varchar(10) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Religion` varchar(30) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Name_eng` varchar(155) NOT NULL default '',
  `Lastname_eng` varchar(155) NOT NULL default '',
  `provinceId` int(2) NOT NULL default '0',
  `Phone_1` varchar(10) NOT NULL default '',
  `Phone_2` varchar(10) NOT NULL default '',
  `Email` varchar(155) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Datetype` date NOT NULL default '0000-00-00',
  `StatusId` int(1) NOT NULL default '0',
  `Year_1` varchar(5) NOT NULL default '00000',
  `Flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`massegeId`,`Dental_code`),
  UNIQUE KEY `code` (`massegeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `massege_db`
--

LOCK TABLES `massege_db` WRITE;
/*!40000 ALTER TABLE `massege_db` DISABLE KEYS */;
/*!40000 ALTER TABLE `massege_db` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `method_tb`
--

DROP TABLE IF EXISTS `method_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `method_tb` (
  `Method_code` int(5) NOT NULL auto_increment,
  `Method_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`Method_code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `method_tb`
--

LOCK TABLES `method_tb` WRITE;
/*!40000 ALTER TABLE `method_tb` DISABLE KEYS */;
INSERT INTO `method_tb` VALUES (1,'ภาคทฤษฎี'),(2,'ภาคปฏิบัติ'),(3,'ภาคทดลองปฏิบัติ');
/*!40000 ALTER TABLE `method_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `money_source_tb`
--

DROP TABLE IF EXISTS `money_source_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `money_source_tb` (
  `MoneyS_C` int(5) NOT NULL auto_increment,
  `MoneyS_M` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`MoneyS_C`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `money_source_tb`
--

LOCK TABLES `money_source_tb` WRITE;
/*!40000 ALTER TABLE `money_source_tb` DISABLE KEYS */;
INSERT INTO `money_source_tb` VALUES (1,'งบประมาณ'),(2,'บำรุงการศึกษา'),(3,'บำรุงสถานบริการ'),(4,'งบประมาณเครือข่าย สวส'),(5,'เงินงบประมาณ สบช'),(6,'งบประมาณเครือข่ายภาคกลาง'),(7,'งบค่าลงทะเบียน');
/*!40000 ALTER TABLE `money_source_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `money_tb`
--

DROP TABLE IF EXISTS `money_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `money_tb` (
  `MoneyId` int(5) NOT NULL auto_increment,
  `MoneyName` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`MoneyId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `money_tb`
--

LOCK TABLES `money_tb` WRITE;
/*!40000 ALTER TABLE `money_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `money_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `month_tb`
--

DROP TABLE IF EXISTS `month_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `month_tb` (
  `monthCode` int(2) NOT NULL auto_increment,
  `month` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`monthCode`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `month_tb`
--

LOCK TABLES `month_tb` WRITE;
/*!40000 ALTER TABLE `month_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `month_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permission_tb`
--

DROP TABLE IF EXISTS `permission_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `permission_tb` (
  `Number` int(5) NOT NULL auto_increment,
  `permision` int(11) NOT NULL default '0',
  `url` varchar(100) NOT NULL default '',
  `description` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Number`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `permission_tb`
--

LOCK TABLES `permission_tb` WRITE;
/*!40000 ALTER TABLE `permission_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `permission_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `persnal_project_tb`
--

DROP TABLE IF EXISTS `persnal_project_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `persnal_project_tb` (
  `Persnal_code` int(5) NOT NULL auto_increment,
  `Project_code` int(3) NOT NULL default '0',
  `Code_no` varchar(8) NOT NULL default '0',
  `Project_name` varchar(150) NOT NULL default '',
  `First_name` varchar(20) NOT NULL default '',
  `Name` varchar(50) NOT NULL default '',
  `Last_name` varchar(50) NOT NULL default '',
  `citizenId` varchar(13) NOT NULL default '',
  `Program` int(2) NOT NULL default '0',
  `Program_1` char(2) NOT NULL default '0',
  `Program_2` char(2) NOT NULL default '',
  `Program_3` char(2) NOT NULL default '',
  `Program_4` char(2) NOT NULL default '',
  `Program_5` char(2) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Code` int(3) NOT NULL default '0',
  `Age` int(2) NOT NULL default '0',
  `Sex` varchar(10) NOT NULL default '',
  `Address` varchar(255) NOT NULL default '',
  `Amper` varchar(50) NOT NULL default '0.00',
  `ProvinceId` int(2) NOT NULL default '0',
  `Img1` varchar(100) NOT NULL default '',
  `Date_buy` date NOT NULL default '0000-00-00',
  `Date_year` date NOT NULL default '0000-00-00',
  `Zipcode` int(5) NOT NULL default '0',
  `Email` varchar(50) NOT NULL default '',
  `Phone` varchar(10) NOT NULL default '',
  `Education` text NOT NULL,
  `Education_1` text NOT NULL,
  `Education_2` text NOT NULL,
  `Addwork` text NOT NULL,
  `Amount` float NOT NULL default '0',
  `Flag` int(1) unsigned zerofill NOT NULL default '0',
  `Work` text NOT NULL,
  `Room` varchar(100) NOT NULL default '',
  `Foot` varchar(50) NOT NULL default '',
  `programId` int(2) NOT NULL default '0',
  `collegeCode` int(2) NOT NULL default '0',
  `Detail` varchar(100) NOT NULL default '',
  `Bank` varchar(50) NOT NULL default '',
  `Class` varchar(10) NOT NULL default '',
  `Addname` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`Persnal_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `persnal_project_tb`
--

LOCK TABLES `persnal_project_tb` WRITE;
/*!40000 ALTER TABLE `persnal_project_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `persnal_project_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `person_type_tb`
--

DROP TABLE IF EXISTS `person_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `person_type_tb` (
  `Ptype_code` int(5) NOT NULL auto_increment,
  `Ptype_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Ptype_code`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `person_type_tb`
--

LOCK TABLES `person_type_tb` WRITE;
/*!40000 ALTER TABLE `person_type_tb` DISABLE KEYS */;
INSERT INTO `person_type_tb` VALUES (1,'ข้าราชการ'),(2,'พนักงานของรัฐ'),(3,'ลูกจ้างประจำ'),(4,'ลูกจ้างเหมาจ่าย (เงินบำรุง)');
/*!40000 ALTER TABLE `person_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personalMed`
--

DROP TABLE IF EXISTS `personalMed`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `personalMed` (
  `personId` int(11) NOT NULL auto_increment,
  `Teacher_code` int(5) NOT NULL default '0',
  `HN_code` varchar(10) NOT NULL default '',
  `Teach_code` int(3) NOT NULL default '0',
  `prefixId` int(3) NOT NULL default '0',
  `Name` varchar(60) NOT NULL default '',
  `Lastname` varchar(60) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Datetype` date NOT NULL default '0000-00-00',
  `Sex` varchar(10) NOT NULL default '',
  `Age` varchar(10) NOT NULL default '',
  `Nationality` varchar(50) NOT NULL default '',
  `Hostpital` int(1) NOT NULL default '0',
  `Nation` varchar(50) NOT NULL default '',
  `Religion` varchar(50) NOT NULL default '',
  `Citizen_id` varchar(13) NOT NULL default '',
  `amphurId` int(4) NOT NULL default '0',
  `districtId` int(2) NOT NULL default '0',
  `provinceId` int(2) NOT NULL default '0',
  `Zipcode` varchar(10) NOT NULL default '',
  `Phone` varchar(20) NOT NULL default '',
  `Mobile` varchar(15) NOT NULL default '',
  `Work` varchar(155) NOT NULL default '',
  `Status2` varchar(50) NOT NULL default '',
  `Status3` varchar(50) NOT NULL default '',
  `Education` varchar(150) NOT NULL default '',
  `Email_name` varchar(50) NOT NULL default '',
  `State_bank` varchar(1) NOT NULL,
  `Email_1` varchar(50) NOT NULL default '',
  `Address` varchar(155) NOT NULL default '',
  `Img1` varchar(255) NOT NULL default '',
  `Degree_code` varchar(50) NOT NULL default '0',
  `Group_1` varchar(200) NOT NULL default '',
  `Group_2` varchar(200) NOT NULL default '',
  `Group_3` varchar(200) NOT NULL default '',
  `Group_4` varchar(50) NOT NULL default '',
  `massegeId` int(3) NOT NULL default '0',
  `Dental_code` tinyint(6) NOT NULL default '0',
  `Club_nid` varchar(15) NOT NULL default '',
  `MedCode` int(5) NOT NULL default '0',
  PRIMARY KEY  (`personId`),
  KEY `Teacher_code` (`personId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `personalMed`
--

LOCK TABLES `personalMed` WRITE;
/*!40000 ALTER TABLE `personalMed` DISABLE KEYS */;
/*!40000 ALTER TABLE `personalMed` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_den_tb`
--

DROP TABLE IF EXISTS `personal_den_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `personal_den_tb` (
  `Person_code` int(5) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `HN_code` varchar(10) NOT NULL default '',
  `Teach_code` int(3) unsigned zerofill NOT NULL default '000',
  `First_name` varchar(30) NOT NULL default '',
  `Name` varchar(60) NOT NULL default '',
  `Lastname` varchar(60) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Datetype` date NOT NULL default '0000-00-00',
  `Sex` varchar(10) NOT NULL default '',
  `Age` varchar(10) NOT NULL default '',
  `Nationality` varchar(50) NOT NULL default '',
  `Hostpital` int(1) NOT NULL default '0',
  `Nation` varchar(50) NOT NULL default '',
  `Religion` varchar(50) NOT NULL default '',
  `Citizen_id` varchar(13) NOT NULL default '',
  `Father_name` varchar(100) NOT NULL default '',
  `Mother_name` varchar(100) NOT NULL default '',
  `ProvinceId` int(2) NOT NULL default '0',
  `Zipcode` varchar(10) NOT NULL default '',
  `Phone` varchar(20) NOT NULL default '',
  `Mobile` varchar(15) NOT NULL default '',
  `Work` varchar(155) NOT NULL default '',
  `Status2` varchar(50) NOT NULL default '',
  `Status3` varchar(50) NOT NULL default '',
  `Education` varchar(150) NOT NULL default '',
  `Email_name` varchar(50) NOT NULL default '',
  `Email_1` varchar(50) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Phone_1` varchar(20) NOT NULL default '',
  `Mobile_1` varchar(15) NOT NULL default '0',
  `Degree_code` varchar(50) NOT NULL default '0',
  `Group_1` varchar(200) NOT NULL default '',
  `Group_2` varchar(200) NOT NULL default '',
  `Group_3` varchar(200) NOT NULL default '',
  `Group_4` varchar(50) NOT NULL default '',
  `Person_type` int(1) NOT NULL default '0',
  `Dental_code` int(6) NOT NULL default '0',
  `Club_nid` varchar(15) NOT NULL default '',
  `Dentis_code` int(2) NOT NULL default '0',
  `Username` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  `Flag_del` int(1) NOT NULL default '0',
  `Permision` char(2) NOT NULL default '',
  PRIMARY KEY  (`Person_code`),
  KEY `Teacher_code` (`Person_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `personal_den_tb`
--

LOCK TABLES `personal_den_tb` WRITE;
/*!40000 ALTER TABLE `personal_den_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_den_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_tb`
--

DROP TABLE IF EXISTS `personal_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `personal_tb` (
  `Teacher_code` int(3) NOT NULL auto_increment,
  `officerId1` int(3) NOT NULL default '0',
  `Teacher_id` varchar(6) NOT NULL,
  `First_name` varchar(30) NOT NULL default '',
  `Teacher_name` varchar(60) NOT NULL default '',
  `Teacher_lastname` varchar(60) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Sex` varchar(10) NOT NULL default '',
  `Nationality` varchar(50) NOT NULL default '',
  `Nation` varchar(100) NOT NULL default '',
  `Religion` varchar(50) NOT NULL default '',
  `Citizen_id` varchar(13) NOT NULL default '0',
  `Father_name` varchar(100) NOT NULL default '',
  `Mother_name` varchar(100) NOT NULL default '',
  `StatusId` int(1) NOT NULL default '0',
  `Status` varchar(50) NOT NULL default '',
  `Status2` varchar(50) NOT NULL default '',
  `Status3` varchar(50) NOT NULL default '',
  `Soulmate` varchar(100) NOT NULL default '',
  `Total_child` varchar(10) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '../personal_pic/lodo.gif',
  `Skill` text NOT NULL,
  `Type_Degree` tinyint(3) NOT NULL default '0',
  `Degree_code` tinyint(5) NOT NULL default '0',
  `Degree_else` varchar(50) NOT NULL default '',
  `Degree_His1` varchar(200) NOT NULL default '',
  `Degree_His2` varchar(200) NOT NULL default '',
  `Degree_His3` varchar(200) NOT NULL default '',
  `Type_degree1` varchar(50) NOT NULL default '',
  `Type_degree2` varchar(50) NOT NULL default '',
  `Type_degree3` varchar(50) NOT NULL default '',
  `Year_1` varchar(4) NOT NULL default '',
  `Year_2` varchar(4) NOT NULL default '',
  `Year_3` varchar(4) NOT NULL default '',
  `Person_type` int(1) NOT NULL default '0',
  `Teacher_type` char(2) NOT NULL default '',
  `Gover_id` varchar(20) NOT NULL default '',
  `Forum_nid` varchar(15) NOT NULL default '',
  `Club_nid` varchar(15) NOT NULL default '',
  `Year_gov` int(11) NOT NULL default '0',
  `Year_coll` int(11) NOT NULL default '0',
  `Year_fac` int(11) NOT NULL default '0',
  `Gover_pos` varchar(30) NOT NULL default '',
  `Salary_1` float(8,2) NOT NULL default '0.00',
  `Salary_2` float(8,2) NOT NULL default '0.00',
  `Salary_3` float(8,2) NOT NULL default '0.00',
  `Absent_01` int(2) unsigned zerofill NOT NULL default '00',
  `Absent_02` int(2) unsigned zerofill NOT NULL default '00',
  `Absent_03` int(2) unsigned zerofill NOT NULL default '00',
  `TeacherId` int(2) NOT NULL default '0',
  `Absent_05` int(2) unsigned zerofill NOT NULL default '00',
  `Absent_06` int(2) unsigned zerofill NOT NULL default '00',
  `Manage_pos` varchar(50) NOT NULL default '',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Dentis_code` int(2) unsigned zerofill NOT NULL default '00',
  `Depart` varchar(60) NOT NULL default '',
  `Username` varchar(100) NOT NULL default '',
  `Password` varchar(100) NOT NULL default '',
  `Flag_del` int(1) NOT NULL default '0',
  `Permision` char(2) NOT NULL default '',
  PRIMARY KEY  (`Teacher_code`),
  KEY `Teacher_code` (`Teacher_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `personal_tb`
--

LOCK TABLES `personal_tb` WRITE;
/*!40000 ALTER TABLE `personal_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `planteach_tb`
--

DROP TABLE IF EXISTS `planteach_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `planteach_tb` (
  `Teach_id` int(11) NOT NULL auto_increment,
  `HN_code` varchar(10) NOT NULL default '0',
  `No_code` int(7) NOT NULL default '0',
  `Person_code` int(11) NOT NULL default '0',
  `Tooth_code` int(2) NOT NULL default '0',
  `Img1` varchar(100) NOT NULL default '',
  `Img2` varchar(100) NOT NULL default '',
  `Code` int(3) NOT NULL default '0',
  `Date` date NOT NULL default '0000-00-00',
  `Time_in` time NOT NULL default '00:00:00',
  `Time_out` time NOT NULL default '00:00:00',
  `Price` float(8,2) NOT NULL default '0.00',
  `Teach_code` int(5) NOT NULL default '0',
  `Teacher_code` int(3) NOT NULL default '0',
  `Religion` varchar(50) NOT NULL default '',
  `Discrition` varchar(50) NOT NULL default '',
  `Flag` int(1) unsigned NOT NULL default '0',
  `Percen` int(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Teach_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `planteach_tb`
--

LOCK TABLES `planteach_tb` WRITE;
/*!40000 ALTER TABLE `planteach_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `planteach_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `program`
--

DROP TABLE IF EXISTS `program`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `program` (
  `programId` int(12) NOT NULL default '0',
  `programCode` varchar(8) NOT NULL default '',
  `programYear` int(4) NOT NULL default '0',
  `degreeId` int(2) NOT NULL default '0',
  `levelId` int(2) NOT NULL default '0',
  `programName` varchar(100) NOT NULL default '',
  `programNameEng` varchar(100) NOT NULL default '',
  `programAbbr` varchar(35) NOT NULL default '',
  `programAbbrEng` varchar(35) NOT NULL default '',
  `creditTotal` float NOT NULL default '0',
  `description` text,
  `descriptionEng` text,
  `studyYearMax` int(2) NOT NULL default '0',
  `gradePointMin` float NOT NULL default '0',
  `createDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `createUserId` varchar(20) NOT NULL default '',
  `updateDateTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `updateUserId` varchar(20) NOT NULL default '',
  `semesterPerYear` int(1) NOT NULL default '0',
  `programStatus` char(1) NOT NULL default 'Y',
  `studyYear` int(1) NOT NULL default '0',
  `programConfId` int(11) NOT NULL default '0',
  PRIMARY KEY  (`programId`),
  KEY `degreeId` (`degreeId`),
  KEY `levelId` (`levelId`),
  KEY `programConfId` (`programConfId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `program`
--

LOCK TABLES `program` WRITE;
/*!40000 ALTER TABLE `program` DISABLE KEYS */;
/*!40000 ALTER TABLE `program` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projectName`
--

DROP TABLE IF EXISTS `projectName`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `projectName` (
  `codeId` int(11) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `projectCode` varchar(10) NOT NULL default '',
  `projectName` varchar(255) NOT NULL default '',
  `objective` varchar(255) NOT NULL default '',
  `objectiveName` varchar(255) NOT NULL default '',
  `operat` text NOT NULL,
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `budgetGrop` varchar(20) NOT NULL default '',
  `BudgetYear` varchar(15) NOT NULL default '',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `purpose` varchar(255) NOT NULL default '',
  `result` varchar(255) NOT NULL default '',
  `January` float(9,2) NOT NULL default '0.00',
  `February` float(8,2) NOT NULL default '0.00',
  `March` float(9,2) NOT NULL default '0.00',
  `April` float(9,2) NOT NULL default '0.00',
  `May` float(9,2) NOT NULL default '0.00',
  `June` float(9,2) NOT NULL default '0.00',
  `July` float(9,2) NOT NULL default '0.00',
  `Augus` float(9,2) NOT NULL default '0.00',
  `September` float(9,2) NOT NULL default '0.00',
  `October` float(9,2) NOT NULL default '0.00',
  `November` float(9,2) NOT NULL default '0.00',
  `December` float(9,2) NOT NULL default '0.00',
  `Budget_use` float(9,2) NOT NULL default '0.00',
  PRIMARY KEY  (`codeId`),
  KEY `codeId` (`codeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `projectName`
--

LOCK TABLES `projectName` WRITE;
/*!40000 ALTER TABLE `projectName` DISABLE KEYS */;
/*!40000 ALTER TABLE `projectName` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `projectStdPlan_tb`
--

DROP TABLE IF EXISTS `projectStdPlan_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `projectStdPlan_tb` (
  `Project_code` int(11) NOT NULL auto_increment,
  `codeId` int(11) NOT NULL default '0',
  `Teacher_code` int(3) NOT NULL default '0',
  `Orderlist` int(5) NOT NULL default '0',
  `Faculty_name` text NOT NULL,
  `Orderlist_2` text NOT NULL,
  `Project_name` text NOT NULL,
  `Project_plan` text NOT NULL,
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Period_1` text NOT NULL,
  `Period` text NOT NULL,
  `Budget_Year` varchar(4) NOT NULL default '',
  `Project_rep` text NOT NULL,
  PRIMARY KEY  (`Project_code`),
  KEY `Project_code` (`Project_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `projectStdPlan_tb`
--

LOCK TABLES `projectStdPlan_tb` WRITE;
/*!40000 ALTER TABLE `projectStdPlan_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `projectStdPlan_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project_tb`
--

DROP TABLE IF EXISTS `project_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `project_tb` (
  `codeId` int(11) NOT NULL auto_increment,
  `Ind` varchar(10) NOT NULL default '0',
  `ProjectId` int(11) NOT NULL default '0',
  `Project_code` int(11) NOT NULL default '0',
  `MoneyId` int(5) NOT NULL default '0',
  `MoneyS_C` int(5) NOT NULL default '0',
  `programId` int(12) NOT NULL default '0',
  `Orderlist` float(5,2) NOT NULL default '0.00',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Teacher_code` int(3) NOT NULL default '0',
  `Orderlist_2` varchar(5) NOT NULL default '0',
  `Training_name` varchar(255) NOT NULL default '',
  `Project_plan` varchar(200) NOT NULL default '',
  `Date` date NOT NULL default '0000-00-00',
  `Budget_use` float(9,2) NOT NULL default '0.00',
  `Budget_Year` varchar(4) NOT NULL default '',
  `Year` varchar(4) NOT NULL default '',
  `Training_code` int(11) NOT NULL default '0',
  PRIMARY KEY  (`codeId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `project_tb`
--

LOCK TABLES `project_tb` WRITE;
/*!40000 ALTER TABLE `project_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project_type_tb`
--

DROP TABLE IF EXISTS `project_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `project_type_tb` (
  `ProjectId` int(11) NOT NULL auto_increment,
  `Project_code` int(11) NOT NULL default '0',
  `Orderlist` float(5,2) NOT NULL default '0.00',
  `Faculty_name` varchar(255) NOT NULL default '',
  `Orderlist_2` varchar(255) NOT NULL default '',
  `Project_name` varchar(255) NOT NULL default '',
  `Project_plan` varchar(255) NOT NULL default '',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `Teacher_code` int(5) NOT NULL default '0',
  `Period_1` varchar(155) NOT NULL default '0.00',
  `Period` varchar(255) NOT NULL default '',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `Project_rep` varchar(155) NOT NULL default '',
  `Budget_Year` varchar(4) NOT NULL default '',
  `Budget` float(9,2) NOT NULL default '0.00',
  `Budget_use` float(9,2) NOT NULL default '0.00',
  `MoneyS_C` int(5) NOT NULL default '0',
  `MoneyId` int(5) NOT NULL default '0',
  `Dif_result` float(9,2) NOT NULL default '0.00',
  `January` float(9,2) NOT NULL default '0.00',
  `February` float(8,2) NOT NULL default '0.00',
  `March` float(9,2) NOT NULL default '0.00',
  `April` float(9,2) NOT NULL default '0.00',
  `May` float(9,2) NOT NULL default '0.00',
  `June` float(9,2) NOT NULL default '0.00',
  `July` float(9,2) NOT NULL default '0.00',
  `Augus` float(9,2) NOT NULL default '0.00',
  `September` float(9,2) NOT NULL default '0.00',
  `October` float(9,2) NOT NULL default '0.00',
  `November` float(9,2) NOT NULL default '0.00',
  `December` float(9,2) NOT NULL default '0.00',
  `Flag` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`ProjectId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `project_type_tb`
--

LOCK TABLES `project_type_tb` WRITE;
/*!40000 ALTER TABLE `project_type_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `project_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `province`
--

DROP TABLE IF EXISTS `province`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `province` (
  `ProvinceId` int(2) NOT NULL default '0',
  `ProvinceName` varchar(30) NOT NULL default '',
  `ProvinceNameEng` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`ProvinceId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `province`
--

LOCK TABLES `province` WRITE;
/*!40000 ALTER TABLE `province` DISABLE KEYS */;
INSERT INTO `province` VALUES (1,'กรุงเทพมหานคร',''),(2,'สมุทรปราการ',''),(3,'นนทบุรี',''),(4,'ปทุมธานี',''),(5,'พระนครศรีอยุธยา',''),(6,'อ่างทอง',''),(7,'ลพบุรี',''),(8,'สิงห์บุรี',''),(9,'ชัยนาท',''),(10,'สระบุรี',''),(11,'ชลบุรี',''),(12,'ระยอง',''),(13,'จันทบุรี',''),(14,'ตราด',''),(15,'ฉะเชิงเทรา',''),(16,'ปราจีนบุรี',''),(17,'นครนายก',''),(18,'สระแก้ว',''),(19,'นครราชสีมา',''),(20,'บุรีรัมย์',''),(21,'สุรินทร์',''),(22,'ศรีสะเกษ',''),(23,'อุบลราชธานี',''),(24,'ยโสธร',''),(25,'ชัยภูมิ',''),(26,'อำนาจเจริญ',''),(27,'หนองบัวลำภู',''),(28,'ขอนแก่น',''),(29,'อุดรธานี',''),(30,'เลย',''),(31,'หนองคาย',''),(32,'มหาสารคาม',''),(33,'ร้อยเอ็ด',''),(34,'กาฬสินธุ์',''),(35,'สกลนคร',''),(36,'นครพนม',''),(37,'มุกดาหาร',''),(38,'เชียงใหม่',''),(39,'ลำพูน',''),(40,'ลำปาง',''),(41,'อุตรดิตถ์',''),(42,'แพร่',''),(43,'น่าน',''),(44,'พะเยา',''),(45,'เชียงราย',''),(46,'แม่ฮ่องสอน',''),(47,'นครสวรรค์',''),(48,'อุทัยธานี',''),(49,'กำแพงเพชร',''),(50,'ตาก',''),(51,'สุโขทัย',''),(52,'พิษณุโลก',''),(53,'พิจิตร',''),(54,'เพชรบูรณ์',''),(55,'ราชบุรี',''),(56,'กาญจนบุรี',''),(57,'สุพรรณบุรี',''),(58,'นครปฐม',''),(59,'สมุทรสาคร',''),(60,'สมุทรสงคราม',''),(61,'เพชรบุรี',''),(62,'ประจวบคีรีขันธ์',''),(63,'นครศรีธรรมราช',''),(64,'กระบี่',''),(65,'พังงา',''),(66,'ภูเก็ต',''),(67,'สุราษฎร์ธานี',''),(68,'ระนอง',''),(69,'ชุมพร',''),(70,'สงขลา',''),(71,'สตูล',''),(72,'ตรัง',''),(73,'พัทลุง',''),(74,'ปัตตานี','Pattani'),(75,'ยะลา',''),(76,'นราธิวาส','');
/*!40000 ALTER TABLE `province` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `punishment_tb`
--

DROP TABLE IF EXISTS `punishment_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `punishment_tb` (
  `Punish_code` int(5) NOT NULL auto_increment,
  `Student_id` varchar(10) NOT NULL default '',
  `Perform` varchar(100) NOT NULL default '',
  `Result` varchar(255) NOT NULL default '',
  `Healthy_card` varchar(255) NOT NULL default '',
  `Sick_in_learn` text NOT NULL,
  `Insurrance` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Punish_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `punishment_tb`
--

LOCK TABLES `punishment_tb` WRITE;
/*!40000 ALTER TABLE `punishment_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `punishment_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qa_pi_cri_tb`
--

DROP TABLE IF EXISTS `qa_pi_cri_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `qa_pi_cri_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Stand_code` varchar(5) NOT NULL default '0.0',
  `Ind_code` varchar(5) NOT NULL default '',
  `Indicate` text NOT NULL,
  `Source` varchar(255) NOT NULL default '',
  `IncFor` text NOT NULL,
  `Awa` text NOT NULL,
  `Att` text NOT NULL,
  `Ach1` text NOT NULL,
  `Ach2` text NOT NULL,
  `Ach3` text NOT NULL,
  `Ach4` text NOT NULL,
  `E_awa` text NOT NULL,
  `E_att` text NOT NULL,
  `E_ach1` text NOT NULL,
  `E_ach2` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `qa_pi_cri_tb`
--

LOCK TABLES `qa_pi_cri_tb` WRITE;
/*!40000 ALTER TABLE `qa_pi_cri_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `qa_pi_cri_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qa_project_tb`
--

DROP TABLE IF EXISTS `qa_project_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `qa_project_tb` (
  `Project_code` int(10) NOT NULL auto_increment,
  `Orderlist` varchar(10) NOT NULL default '',
  `Project_name` varchar(150) NOT NULL default '',
  `Objective` text NOT NULL,
  `Fee` float(8,2) NOT NULL default '0.00',
  `Period` varchar(255) NOT NULL default '',
  `Start_Date` varchar(255) NOT NULL default '',
  `Term` varchar(4) NOT NULL default '',
  `Budget_Year` varchar(4) NOT NULL default '',
  `Budget` float(8,2) NOT NULL default '0.00',
  `Budget_use` float(8,2) NOT NULL default '0.00',
  `Participant` text NOT NULL,
  `Percent_ans` int(11) NOT NULL default '0',
  `Result_oper` char(1) NOT NULL default '',
  `Dif_result` float(8,2) NOT NULL default '0.00',
  `Flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`Project_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `qa_project_tb`
--

LOCK TABLES `qa_project_tb` WRITE;
/*!40000 ALTER TABLE `qa_project_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `qa_project_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qa_result_tb`
--

DROP TABLE IF EXISTS `qa_result_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `qa_result_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Stand_code` varchar(5) NOT NULL default '',
  `Term` varchar(4) NOT NULL default '',
  `Times` char(2) NOT NULL default '',
  `Assessor` text NOT NULL,
  `S11` int(11) NOT NULL default '0',
  `S12` int(11) NOT NULL default '0',
  `S13` int(11) NOT NULL default '0',
  `S14` int(11) NOT NULL default '0',
  `S15` int(11) NOT NULL default '0',
  `S16` int(11) NOT NULL default '0',
  `S17` int(11) NOT NULL default '0',
  `S18` int(11) NOT NULL default '0',
  `S19` int(11) NOT NULL default '0',
  `S21` int(11) NOT NULL default '0',
  `S22` int(11) NOT NULL default '0',
  `S23` int(11) NOT NULL default '0',
  `S24` int(11) NOT NULL default '0',
  `S25` int(11) NOT NULL default '0',
  `S26` int(11) NOT NULL default '0',
  `S27` int(11) NOT NULL default '0',
  `S28` int(11) NOT NULL default '0',
  `S29` int(11) NOT NULL default '0',
  `S210` int(11) NOT NULL default '0',
  `S31` int(11) NOT NULL default '0',
  `S32` int(11) NOT NULL default '0',
  `S33` int(11) NOT NULL default '0',
  `S34` int(11) NOT NULL default '0',
  `S35` int(11) NOT NULL default '0',
  `S36` int(11) NOT NULL default '0',
  `S41` int(11) NOT NULL default '0',
  `S42` int(11) NOT NULL default '0',
  `S43` int(11) NOT NULL default '0',
  `S44` int(11) NOT NULL default '0',
  `S45` int(11) NOT NULL default '0',
  `S46` int(11) NOT NULL default '0',
  `S51` int(11) NOT NULL default '0',
  `S52` int(11) NOT NULL default '0',
  `S53` int(11) NOT NULL default '0',
  `S54` int(11) NOT NULL default '0',
  `S55` int(11) NOT NULL default '0',
  `S61` int(11) NOT NULL default '0',
  `S62` int(11) NOT NULL default '0',
  `S71` int(11) NOT NULL default '0',
  `S72` int(11) NOT NULL default '0',
  `S73` int(11) NOT NULL default '0',
  `S74` int(11) NOT NULL default '0',
  `S75` int(11) NOT NULL default '0',
  `S76` int(11) NOT NULL default '0',
  `S77` int(11) NOT NULL default '0',
  `S78` int(11) NOT NULL default '0',
  `S79` int(11) NOT NULL default '0',
  `S710` int(11) NOT NULL default '0',
  `S711` int(11) NOT NULL default '0',
  `S712` int(11) NOT NULL default '0',
  `S81` int(11) NOT NULL default '0',
  `S82` int(11) NOT NULL default '0',
  `S91` int(11) NOT NULL default '0',
  `S92` int(11) NOT NULL default '0',
  `S93` int(11) NOT NULL default '0',
  `S94` int(11) NOT NULL default '0',
  `S95` int(11) NOT NULL default '0',
  `S96` int(11) NOT NULL default '0',
  `S97` int(11) NOT NULL default '0',
  `S98` int(11) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `qa_result_tb`
--

LOCK TABLES `qa_result_tb` WRITE;
/*!40000 ALTER TABLE `qa_result_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `qa_result_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `qa_standard_tb`
--

DROP TABLE IF EXISTS `qa_standard_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `qa_standard_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Stand_code` varchar(5) NOT NULL default '0.0',
  `Topic` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `qa_standard_tb`
--

LOCK TABLES `qa_standard_tb` WRITE;
/*!40000 ALTER TABLE `qa_standard_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `qa_standard_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `relation_tb`
--

DROP TABLE IF EXISTS `relation_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `relation_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Project_name` varchar(255) NOT NULL default '',
  `Organize` varchar(255) NOT NULL default '',
  `Objective` text NOT NULL,
  `Contact` varchar(255) NOT NULL default '',
  `Address` text NOT NULL,
  `Email` varchar(255) NOT NULL default '',
  `Website` varchar(255) NOT NULL default '',
  `Country` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `relation_tb`
--

LOCK TABLES `relation_tb` WRITE;
/*!40000 ALTER TABLE `relation_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `relation_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `res_project_tb`
--

DROP TABLE IF EXISTS `res_project_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `res_project_tb` (
  `Resp_code` int(11) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Project_name` varchar(255) NOT NULL default '',
  `Year_res` varchar(4) NOT NULL default '0000',
  `Duty` varchar(100) NOT NULL default '',
  `Duty_else` varchar(100) NOT NULL default '',
  `Apply` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Resp_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `res_project_tb`
--

LOCK TABLES `res_project_tb` WRITE;
/*!40000 ALTER TABLE `res_project_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `res_project_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `research_academic`
--

DROP TABLE IF EXISTS `research_academic`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `research_academic` (
  `ReAcId` int(3) NOT NULL auto_increment,
  `ReAcname` varchar(150) NOT NULL,
  PRIMARY KEY  (`ReAcId`),
  KEY `ResearchTyId` (`ReAcId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `research_academic`
--

LOCK TABLES `research_academic` WRITE;
/*!40000 ALTER TABLE `research_academic` DISABLE KEYS */;
INSERT INTO `research_academic` VALUES (1,'สูติศาสตร์/ผดุงครรภ์/มารดาทารก');
/*!40000 ALTER TABLE `research_academic` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `research_char_tb`
--

DROP TABLE IF EXISTS `research_char_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `research_char_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Rchar_name` varchar(255) NOT NULL default '',
  `Rchar_desc` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `research_char_tb`
--

LOCK TABLES `research_char_tb` WRITE;
/*!40000 ALTER TABLE `research_char_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `research_char_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `research_source_tb`
--

DROP TABLE IF EXISTS `research_source_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `research_source_tb` (
  `ResearchDI` int(5) NOT NULL auto_increment,
  `ResearchDetail` varchar(50) NOT NULL,
  `Flag` char(1) NOT NULL,
  PRIMARY KEY  (`ResearchDI`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `research_source_tb`
--

LOCK TABLES `research_source_tb` WRITE;
/*!40000 ALTER TABLE `research_source_tb` DISABLE KEYS */;
INSERT INTO `research_source_tb` VALUES (1,'แก้ไขโครงร่าง','1'),(2,'ศึกษาวรรณกรรม','1'),(3,'สร้าง/พัฒนาเครื่องมือ','1'),(4,'เก็บรวบรวมข้อมูล','1'),(5,'วิเคราะห์ข้อมูล','1'),(6,'อภิปรายผลและจัดทำรายงาน','1'),(7,'งานวิจัยที่แล้วเสร็จ','1'),(8,'เสนอโครงร่าง','2'),(9,'ระหว่างการดำเนินงาน','2'),(10,'แล้วเสร็จ','2'),(11,'เผยแพร่','2'),(12,'จัดจำหน่าย','2');
/*!40000 ALTER TABLE `research_source_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `research_tb`
--

DROP TABLE IF EXISTS `research_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `research_tb` (
  `Research_code` int(11) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL,
  `Branch` varchar(255) NOT NULL default '0',
  `Research_name` varchar(255) NOT NULL,
  `Research_type` int(2) NOT NULL,
  `Research_char` varchar(100) NOT NULL default '',
  `Research_char_else` varchar(100) NOT NULL default '',
  `Research_st` varchar(100) NOT NULL,
  `R_position` varchar(50) NOT NULL default '',
  `name1` int(5) NOT NULL default '0',
  `name2` int(5) NOT NULL default '0',
  `name3` int(5) NOT NULL default '0',
  `name4` int(5) NOT NULL default '0',
  `name5` int(5) NOT NULL default '0',
  `name6` int(5) NOT NULL default '0',
  `name7` int(5) NOT NULL default '0',
  `name8` int(5) NOT NULL default '0',
  `abbStract` text NOT NULL,
  `r_type` tinyint(1) NOT NULL,
  `academic_year` mediumint(4) NOT NULL,
  `fiscal_year` mediumint(4) NOT NULL,
  `academic_year_finish` mediumint(4) NOT NULL,
  `fiscal_year_finish` mediumint(4) NOT NULL,
  `Year_start` date NOT NULL default '0000-00-00',
  `Year_finish` date NOT NULL default '0000-00-00',
  `Year_sprop` date NOT NULL,
  `Fund` varchar(10) NOT NULL default '0',
  `FundIn` float NOT NULL,
  `FundOut` float NOT NULL,
  `FundUse` float NOT NULL,
  `Fund_resource` text NOT NULL,
  `Resource_des` varchar(100) NOT NULL default '',
  `Propagate` varchar(100) NOT NULL default '',
  `Propagate_des` varchar(255) NOT NULL default '',
  `Prop_type` varchar(100) NOT NULL default '',
  `Prop_type1` varchar(100) NOT NULL default '',
  `Prop_type2` varchar(100) NOT NULL default '',
  `Prop_type3` varchar(100) NOT NULL default '',
  `Apply1` varchar(100) NOT NULL default '',
  `Apply2` varchar(100) NOT NULL default '',
  `Apply3` varchar(100) NOT NULL default '',
  `Apply4` varchar(100) NOT NULL default '',
  `Apply_des` varchar(255) NOT NULL default '',
  `Year_prop` varchar(4) NOT NULL default '',
  PRIMARY KEY  (`Research_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `research_tb`
--

LOCK TABLES `research_tb` WRITE;
/*!40000 ALTER TABLE `research_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `research_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `room_tb`
--

DROP TABLE IF EXISTS `room_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `room_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Room_code` varchar(50) NOT NULL default '',
  `BuildD_No` int(5) NOT NULL default '0',
  `Room_type` varchar(50) NOT NULL default '',
  `Img1` varchar(155) NOT NULL default '',
  `Room_name` varchar(50) NOT NULL default '',
  `Size` varchar(50) NOT NULL default '',
  `Area` varchar(30) NOT NULL default '',
  `Eletric_meter` int(5) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `room_tb`
--

LOCK TABLES `room_tb` WRITE;
/*!40000 ALTER TABLE `room_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `room_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salary_repot_tb`
--

DROP TABLE IF EXISTS `salary_repot_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `salary_repot_tb` (
  `Code` int(11) NOT NULL auto_increment,
  `Teacher_id` varchar(6) NOT NULL default '',
  `Teacher_code` int(3) NOT NULL default '0',
  `Faculty_code` int(2) unsigned zerofill NOT NULL default '00',
  `StatusId` int(2) NOT NULL default '0',
  `Person_type` int(1) NOT NULL default '0',
  `Start_mont` int(2) NOT NULL default '0',
  `Start_year` varchar(20) NOT NULL default '',
  `Salary_1` float(8,2) NOT NULL default '0.00',
  `Salary_2` float(8,2) NOT NULL default '0.00',
  `Salary_3` float(8,2) NOT NULL default '0.00',
  `Costt_1` float(8,2) NOT NULL default '0.00',
  `Costt_2` float(8,2) NOT NULL default '0.00',
  `Costt_3` float(8,2) NOT NULL default '0.00',
  `Costt_4` float(8,2) NOT NULL default '0.00',
  `Costt_5` float(8,2) NOT NULL default '0.00',
  `Costt_6` float(8,2) NOT NULL default '0.00',
  `Costt_7` float(8,2) NOT NULL default '0.00',
  `Costt_8` float(8,2) NOT NULL default '0.00',
  `Costt_9` float(8,2) NOT NULL default '0.00',
  `Costt_10` float(8,2) NOT NULL default '0.00',
  `Costt_11` float(8,2) NOT NULL default '0.00',
  `Costt_12` float(8,2) NOT NULL default '0.00',
  `Costt_13` float(8,2) NOT NULL default '0.00',
  `Costt_14` float(8,2) NOT NULL default '0.00',
  `Costt_15` float(8,2) NOT NULL default '0.00',
  `Costt_16` float(8,2) NOT NULL default '0.00',
  `Costt_17` float(8,2) NOT NULL default '0.00',
  `Costt_18` float(8,2) NOT NULL default '0.00',
  `Costt_19` float(8,2) NOT NULL default '0.00',
  `Costt_salary` float(8,2) NOT NULL default '0.00',
  `Costt_to` float(8,2) NOT NULL default '0.00',
  `Costt_total` float(8,2) NOT NULL default '0.00',
  `Flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `salary_repot_tb`
--

LOCK TABLES `salary_repot_tb` WRITE;
/*!40000 ALTER TABLE `salary_repot_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `salary_repot_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salary_tb`
--

DROP TABLE IF EXISTS `salary_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `salary_tb` (
  `Code` int(11) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Start_mont` varchar(15) NOT NULL default '',
  `Start_year` varchar(5) NOT NULL default '',
  `Salary` float(8,2) NOT NULL default '0.00',
  `Cost_1` float(8,2) NOT NULL default '0.00',
  `Cost_2` float(8,2) NOT NULL default '0.00',
  `Cost_3` float(8,2) NOT NULL default '0.00',
  `Cost_4` float(8,2) NOT NULL default '0.00',
  `Cost_5` float(8,2) NOT NULL default '0.00',
  `Cost_6` int(5) NOT NULL default '0',
  `Flag` int(1) NOT NULL default '0',
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `salary_tb`
--

LOCK TABLES `salary_tb` WRITE;
/*!40000 ALTER TABLE `salary_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `salary_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scholarship_tb`
--

DROP TABLE IF EXISTS `scholarship_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `scholarship_tb` (
  `Scholarship_code` int(5) NOT NULL auto_increment,
  `Scholarship_name` varchar(255) NOT NULL default '',
  `Scholarship_type` varchar(255) NOT NULL default '',
  `Source` varchar(255) NOT NULL default '',
  `Fund` float(8,2) NOT NULL default '0.00',
  `Period` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Scholarship_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `scholarship_tb`
--

LOCK TABLES `scholarship_tb` WRITE;
/*!40000 ALTER TABLE `scholarship_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `scholarship_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `state_tb`
--

DROP TABLE IF EXISTS `state_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `state_tb` (
  `stateId` int(10) NOT NULL auto_increment,
  `State` int(3) NOT NULL default '0',
  `Year_State` varchar(4) NOT NULL default '0',
  `Date_note` date NOT NULL default '0000-00-00',
  `No` varchar(100) NOT NULL default '',
  `Disciption` varchar(100) NOT NULL default '',
  `Cost1` float(10,2) NOT NULL default '0.00',
  `Cost2` float(10,2) NOT NULL default '0.00',
  `Cost3` float(10,2) NOT NULL default '0.00',
  `Cost4` float(10,2) NOT NULL default '0.00',
  `Cost5` float(10,2) NOT NULL default '0.00',
  `CostSum` float(15,2) NOT NULL default '0.00',
  PRIMARY KEY  (`stateId`,`Year_State`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `state_tb`
--

LOCK TABLES `state_tb` WRITE;
/*!40000 ALTER TABLE `state_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `state_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_absent_tb`
--

DROP TABLE IF EXISTS `std_absent_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_absent_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Student_id` varchar(10) NOT NULL default '',
  `Date_note` date NOT NULL default '0000-00-00',
  `Case_ab` text NOT NULL,
  `Unit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_absent_tb`
--

LOCK TABLES `std_absent_tb` WRITE;
/*!40000 ALTER TABLE `std_absent_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_absent_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_activity_tb`
--

DROP TABLE IF EXISTS `std_activity_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_activity_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Activity_name` varchar(255) NOT NULL default '',
  `Activity_type` varchar(255) NOT NULL default '',
  `Perform` varchar(50) NOT NULL default '',
  `Activity` varchar(255) NOT NULL default '',
  `Period` varchar(255) NOT NULL default '0000-00-00',
  `Budget` float(8,2) NOT NULL default '0.00',
  `Budget_use` float(8,2) NOT NULL default '0.00',
  `Dif_result` float(8,2) NOT NULL default '0.00',
  `Source` text NOT NULL,
  `Target` varchar(255) NOT NULL default '',
  `Amount` varchar(255) NOT NULL default '',
  `Supervisor` text NOT NULL,
  `Duty` varchar(100) NOT NULL default '',
  `Objective` text NOT NULL,
  `Index_mature` text NOT NULL,
  `Affect_class` text NOT NULL,
  `Ec41_1` varchar(255) NOT NULL default '',
  `Ec41_2` varchar(255) NOT NULL default '',
  `Ec41_3` varchar(255) NOT NULL default '',
  `Ec41_4` varchar(255) NOT NULL default '',
  `Ec41_5` varchar(255) NOT NULL default '',
  `Ec41_6` varchar(255) NOT NULL default '',
  `Ec41_7` varchar(255) NOT NULL default '',
  `Ec41_8` varchar(255) NOT NULL default '',
  `Ec41_9` varchar(255) NOT NULL default '',
  `Ec41_10` varchar(255) NOT NULL default '',
  `Ec41_11` varchar(255) NOT NULL default '',
  `Ec42_1` varchar(255) NOT NULL default '',
  `Ec42_2` varchar(255) NOT NULL default '',
  `Ec42_3` varchar(255) NOT NULL default '',
  `Ec42_4` varchar(255) NOT NULL default '',
  `Ec42_5` varchar(255) NOT NULL default '',
  `Ec42_6` varchar(255) NOT NULL default '',
  `Ec42_7` varchar(255) NOT NULL default '',
  `Ec42_8` varchar(255) NOT NULL default '',
  `Ec42_9` varchar(255) NOT NULL default '',
  `Ec42_10` varchar(255) NOT NULL default '',
  `Ec42_11` varchar(255) NOT NULL default '',
  `Ec42_12` varchar(255) NOT NULL default '',
  `Ec42_13` varchar(255) NOT NULL default '',
  `Ec42_14` varchar(255) NOT NULL default '',
  `Ec42_15` varchar(255) NOT NULL default '',
  `Ec43_1` varchar(255) NOT NULL default '',
  `Ec43_2` varchar(255) NOT NULL default '',
  `Ec43_3` varchar(255) NOT NULL default '',
  `Ec43_4` varchar(255) NOT NULL default '',
  `Ec43_5` varchar(255) NOT NULL default '',
  `Ec43_6` varchar(255) NOT NULL default '',
  `Ec43_7` varchar(255) NOT NULL default '',
  `Ec43_8` varchar(255) NOT NULL default '',
  `Ec43_9` varchar(255) NOT NULL default '',
  `Ec43_10` varchar(255) NOT NULL default '',
  `Ec44_1` varchar(255) NOT NULL default '',
  `Ec44_2` varchar(255) NOT NULL default '',
  `Ec44_3` varchar(255) NOT NULL default '',
  `Ec44_4` varchar(255) NOT NULL default '',
  `Ec44_5` varchar(255) NOT NULL default '',
  `Ec44_6` varchar(255) NOT NULL default '',
  `Ec44_7` varchar(255) NOT NULL default '',
  `Ec44_8` varchar(255) NOT NULL default '',
  `Ec44_9` varchar(255) NOT NULL default '',
  `Ec44_10` varchar(255) NOT NULL default '',
  `Ec44_11` varchar(255) NOT NULL default '',
  `Ec44_12` varchar(255) NOT NULL default '',
  `Ec44_13` varchar(255) NOT NULL default '',
  `Ec44_14` varchar(255) NOT NULL default '',
  `Ec44_15` varchar(255) NOT NULL default '',
  `Result_oper` char(1) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_activity_tb`
--

LOCK TABLES `std_activity_tb` WRITE;
/*!40000 ALTER TABLE `std_activity_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_activity_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_ass14_tb`
--

DROP TABLE IF EXISTS `std_ass14_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_ass14_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Term` varchar(4) NOT NULL default '',
  `Course_code` varchar(5) NOT NULL default '',
  `Level` varchar(5) NOT NULL default '',
  `Total_pass1` int(11) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_ass14_tb`
--

LOCK TABLES `std_ass14_tb` WRITE;
/*!40000 ALTER TABLE `std_ass14_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_ass14_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_ec_tb`
--

DROP TABLE IF EXISTS `std_ec_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_ec_tb` (
  `Es_code` int(11) NOT NULL auto_increment,
  `code` varchar(100) NOT NULL default '',
  `Ec41_1` char(2) NOT NULL default '',
  `Ec41_2` char(2) NOT NULL default '',
  `Ec41_3` char(2) NOT NULL default '',
  `Ec41_4` char(2) NOT NULL default '',
  `Ec41_5` char(2) NOT NULL default '',
  `Ec41_6` char(2) NOT NULL default '',
  `Ec41_7` char(2) NOT NULL default '',
  `Ec41_8` char(2) NOT NULL default '',
  PRIMARY KEY  (`Es_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_ec_tb`
--

LOCK TABLES `std_ec_tb` WRITE;
/*!40000 ALTER TABLE `std_ec_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_ec_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_employer_tb`
--

DROP TABLE IF EXISTS `std_employer_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_employer_tb` (
  `Code` int(11) NOT NULL auto_increment,
  `Term` varchar(4) NOT NULL default '',
  `Course_code` int(5) NOT NULL default '0',
  `Series` int(11) NOT NULL default '0',
  `x1` float(8,2) NOT NULL default '0.00',
  `x2` float(8,2) NOT NULL default '0.00',
  `x3` float(8,2) NOT NULL default '0.00',
  `x4` float(8,2) NOT NULL default '0.00',
  `x5` float(8,2) NOT NULL default '0.00',
  `x6` float(8,2) NOT NULL default '0.00',
  `x7` float(8,2) NOT NULL default '0.00',
  `x8` float(8,2) NOT NULL default '0.00',
  `x9` float(8,2) NOT NULL default '0.00',
  `x10` float(8,2) NOT NULL default '0.00',
  `x11` float(8,2) NOT NULL default '0.00',
  `x12` float(8,2) NOT NULL default '0.00',
  `x13` float(8,2) NOT NULL default '0.00',
  `sd1` float(8,2) NOT NULL default '0.00',
  `sd2` float(8,2) NOT NULL default '0.00',
  `sd3` float(8,2) NOT NULL default '0.00',
  `sd4` float(8,2) NOT NULL default '0.00',
  `sd5` float(8,2) NOT NULL default '0.00',
  `sd6` float(8,2) NOT NULL default '0.00',
  `sd7` float(8,2) NOT NULL default '0.00',
  `sd8` float(8,2) NOT NULL default '0.00',
  `sd9` float(8,2) NOT NULL default '0.00',
  `sd10` float(8,2) NOT NULL default '0.00',
  `sd11` float(8,2) NOT NULL default '0.00',
  `sd12` float(8,2) NOT NULL default '0.00',
  `sd13` float(8,2) NOT NULL default '0.00',
  `rate1` int(1) NOT NULL default '0',
  `rate2` int(1) NOT NULL default '0',
  `rate3` int(1) NOT NULL default '0',
  `rate4` int(1) NOT NULL default '0',
  `rate5` int(1) NOT NULL default '0',
  `rate6` int(1) NOT NULL default '0',
  `rate7` int(1) NOT NULL default '0',
  `rate8` int(1) NOT NULL default '0',
  `rate9` int(1) NOT NULL default '0',
  `rate10` int(1) NOT NULL default '0',
  `rate11` int(1) NOT NULL default '0',
  `rate12` int(1) NOT NULL default '0',
  `rate13` int(1) NOT NULL default '0',
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_employer_tb`
--

LOCK TABLES `std_employer_tb` WRITE;
/*!40000 ALTER TABLE `std_employer_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_employer_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_health_tb`
--

DROP TABLE IF EXISTS `std_health_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_health_tb` (
  `code` int(10) NOT NULL auto_increment,
  `Student_id` varchar(10) NOT NULL default '',
  `Weight` float NOT NULL default '0',
  `Height` int(11) NOT NULL default '0',
  `Date_note` date NOT NULL default '0000-00-00',
  `B_group` varchar(50) NOT NULL default '',
  `Presure` varchar(100) NOT NULL default '',
  `Symptom` text NOT NULL,
  `Disease` text NOT NULL,
  `Treat` text NOT NULL,
  `Place_Treat` varchar(255) NOT NULL default '',
  `Medicine` varchar(255) NOT NULL default '',
  `Bad_Medic` varchar(255) NOT NULL default '',
  `Bad_Food` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`code`,`Student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_health_tb`
--

LOCK TABLES `std_health_tb` WRITE;
/*!40000 ALTER TABLE `std_health_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_health_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_punish_tb`
--

DROP TABLE IF EXISTS `std_punish_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_punish_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Student_id` varchar(10) NOT NULL default '',
  `Date_note` date NOT NULL default '0000-00-00',
  `Punish_type` varchar(255) NOT NULL default '',
  `Perform` text NOT NULL,
  `Consider` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_punish_tb`
--

LOCK TABLES `std_punish_tb` WRITE;
/*!40000 ALTER TABLE `std_punish_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_punish_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_scholarship_tb`
--

DROP TABLE IF EXISTS `std_scholarship_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_scholarship_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Scholarship_code` int(5) NOT NULL default '0',
  `Date_rec` date NOT NULL default '0000-00-00',
  `Student_id` varchar(10) NOT NULL default '',
  `Consider` text NOT NULL,
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_scholarship_tb`
--

LOCK TABLES `std_scholarship_tb` WRITE;
/*!40000 ALTER TABLE `std_scholarship_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_scholarship_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `std_success_tb`
--

DROP TABLE IF EXISTS `std_success_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `std_success_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Student_id` varchar(10) NOT NULL default '',
  `Year_grad` varchar(4) NOT NULL default '',
  `Pass_test` char(2) NOT NULL default '',
  `Times` tinyint(5) NOT NULL default '0',
  `Past_test` char(2) NOT NULL default '',
  `Place` char(1) NOT NULL default '',
  `Work_addr` varchar(255) NOT NULL default '',
  `Work_place` varchar(100) NOT NULL default '',
  `Contact_addr` text NOT NULL,
  `Work_status` char(1) NOT NULL default '',
  `Position` varchar(255) NOT NULL default '',
  `Level` varchar(5) NOT NULL default '',
  `Depart_name` varchar(100) NOT NULL default '',
  `Depart` varchar(100) NOT NULL default '',
  `Date_w1` varchar(100) NOT NULL default '',
  `Date_w11` varchar(100) NOT NULL default '',
  `Date_w2` varchar(100) NOT NULL default '',
  `Date_w22` varchar(100) NOT NULL default '',
  `Date_w3` varchar(100) NOT NULL default '',
  `Date_w33` varchar(100) NOT NULL default '',
  `Work_change` varchar(100) NOT NULL default '',
  `Income_m` float(8,2) NOT NULL default '0.00',
  `Income_y` float(8,2) NOT NULL default '0.00',
  `Status` char(1) NOT NULL default '',
  `Learn_flag` char(1) NOT NULL default '',
  `Degree1` varchar(255) NOT NULL default '',
  `Degree2` varchar(255) NOT NULL default '',
  `Award_in` varchar(255) NOT NULL default '',
  `Award_out` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`code`,`Student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `std_success_tb`
--

LOCK TABLES `std_success_tb` WRITE;
/*!40000 ALTER TABLE `std_success_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `std_success_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `student_tb`
--

DROP TABLE IF EXISTS `student_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `student_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Course_code` int(5) unsigned zerofill NOT NULL default '00000',
  `ProvinceId` char(2) NOT NULL default '',
  `Class` varchar(100) NOT NULL default '',
  `Orderlist` int(5) NOT NULL default '0',
  `Student_id` varchar(10) NOT NULL default '0',
  `First_name` varchar(30) NOT NULL default '',
  `Name` varchar(100) NOT NULL default '',
  `Lastname` varchar(100) NOT NULL default '',
  `Sex` varchar(10) NOT NULL default '',
  `DateBirth` date NOT NULL default '0000-00-00',
  `Religion` varchar(30) NOT NULL default '',
  `Address` text NOT NULL,
  `Img1` varchar(255) NOT NULL default '',
  `Father_name` varchar(255) NOT NULL default '',
  `Mother_name` varchar(255) NOT NULL default '',
  `Address2` text NOT NULL,
  `Telno` varchar(10) NOT NULL default '',
  `Pre_inst` varchar(50) NOT NULL default '',
  `Pre_gpa` varchar(5) NOT NULL default '',
  `Select_Method` varchar(60) NOT NULL default '',
  `Term` varchar(4) NOT NULL default '',
  `Date_in` date NOT NULL default '0000-00-00',
  `Institute` varchar(100) NOT NULL default '',
  `Teacher_code` int(5) NOT NULL default '0',
  `Affect_class` text NOT NULL,
  `Scholarship_code` int(5) NOT NULL default '0',
  `Address_cur` varchar(50) NOT NULL default '',
  `Coll_in` varchar(100) NOT NULL default '',
  `Coll_out` varchar(100) NOT NULL default '',
  `Circle_duty` varchar(100) NOT NULL default '',
  `Circle` varchar(255) NOT NULL default '',
  `Succ_Status` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`code`,`Student_id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `student_tb`
--

LOCK TABLES `student_tb` WRITE;
/*!40000 ALTER TABLE `student_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subject_category_tb`
--

DROP TABLE IF EXISTS `subject_category_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `subject_category_tb` (
  `SubCate_code` int(5) NOT NULL auto_increment,
  `Cate_name` varchar(100) NOT NULL default '',
  `Cate_nameE` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`SubCate_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `subject_category_tb`
--

LOCK TABLES `subject_category_tb` WRITE;
/*!40000 ALTER TABLE `subject_category_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `subject_category_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subject_group_tb`
--

DROP TABLE IF EXISTS `subject_group_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `subject_group_tb` (
  `Subject_group` int(5) NOT NULL auto_increment,
  `SubCate_code` int(5) NOT NULL default '0',
  `Eng_name` varchar(255) NOT NULL default '',
  `Short_name` varchar(255) NOT NULL default '',
  `Thai_name` varchar(255) NOT NULL default '',
  `Description` text NOT NULL,
  PRIMARY KEY  (`Subject_group`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `subject_group_tb`
--

LOCK TABLES `subject_group_tb` WRITE;
/*!40000 ALTER TABLE `subject_group_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `subject_group_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subject_tb`
--

DROP TABLE IF EXISTS `subject_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `subject_tb` (
  `Subject_no` int(5) NOT NULL auto_increment,
  `Course_code` int(5) NOT NULL default '0',
  `SubCate_code` int(5) NOT NULL default '0',
  `Subject_group` varchar(100) NOT NULL default '00000',
  `Subject_code` varchar(50) NOT NULL default '',
  `Subject_name` varchar(255) NOT NULL default '',
  `Unit` varchar(20) NOT NULL default '0',
  `Term` char(1) NOT NULL default '',
  `Class_level` varchar(20) NOT NULL default '',
  `Total_hour` int(5) NOT NULL default '0',
  `Objective` text NOT NULL,
  `Detail` text NOT NULL,
  `Class_Affect` text NOT NULL,
  `Affect_sub` text NOT NULL,
  PRIMARY KEY  (`Subject_no`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `subject_tb`
--

LOCK TABLES `subject_tb` WRITE;
/*!40000 ALTER TABLE `subject_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `subject_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teacher_type_tb`
--

DROP TABLE IF EXISTS `teacher_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `teacher_type_tb` (
  `Ttype_code` int(5) NOT NULL auto_increment,
  `Ttype_name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Ttype_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `teacher_type_tb`
--

LOCK TABLES `teacher_type_tb` WRITE;
/*!40000 ALTER TABLE `teacher_type_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `teacher_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teachplan_tb`
--

DROP TABLE IF EXISTS `teachplan_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `teachplan_tb` (
  `Teach_id` int(11) NOT NULL auto_increment,
  `HN_code` varchar(10) NOT NULL default '0',
  `No_code` int(7) NOT NULL default '0',
  `Person_code` int(5) NOT NULL default '0',
  `Tooth_code` int(2) NOT NULL default '0',
  `Teach1` varchar(50) NOT NULL default '',
  `Teach2` varchar(50) NOT NULL default '',
  `Teach3` varchar(50) NOT NULL default '',
  `Teach4` varchar(50) NOT NULL default '',
  `Teach5` varchar(50) NOT NULL default '',
  `Teach6` varchar(50) NOT NULL default '',
  `Teach7` varchar(50) NOT NULL default '',
  `Teach8` varchar(50) NOT NULL default '',
  `Teach9` varchar(50) NOT NULL default '',
  `Teach10` varchar(50) NOT NULL default '',
  `Teach11` varchar(50) NOT NULL default '',
  `Teach12` varchar(50) NOT NULL default '',
  `Teach13` varchar(50) NOT NULL default '',
  `Teach_13` varchar(255) NOT NULL default '',
  `Tooth_code1` int(2) NOT NULL default '0',
  `Tooth_code3` int(2) NOT NULL default '0',
  `Tooth_code4` int(2) NOT NULL default '0',
  `Tooth_code5` int(2) NOT NULL default '0',
  `Tooth_code6` int(2) NOT NULL default '0',
  `Tooth_code7` int(2) NOT NULL default '0',
  `Tooth_code8` int(2) NOT NULL default '0',
  `Tooth_code11` int(2) NOT NULL default '0',
  `Tooth_code12` int(2) NOT NULL default '0',
  `Religion` varchar(50) NOT NULL default '',
  `Code` int(3) NOT NULL default '0',
  `Date_1` date NOT NULL default '0000-00-00',
  `Date` date NOT NULL default '0000-00-00',
  `Time_in` time NOT NULL default '00:00:00',
  `Time_out` time NOT NULL default '00:00:00',
  `Time` time NOT NULL default '00:00:00',
  `Teach_code` int(3) NOT NULL default '0',
  `Teacher_code` int(3) NOT NULL default '0',
  `Flag` int(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Teach_id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `teachplan_tb`
--

LOCK TABLES `teachplan_tb` WRITE;
/*!40000 ALTER TABLE `teachplan_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `teachplan_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tech_plan_tb`
--

DROP TABLE IF EXISTS `tech_plan_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tech_plan_tb` (
  `Plan_code` int(5) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `conditionId1` int(3) NOT NULL default '0',
  `conditionId2` int(3) NOT NULL default '0',
  `courseId` int(3) NOT NULL default '0',
  `programId` int(2) NOT NULL default '0',
  `Course_code` int(5) NOT NULL default '0',
  `Status` int(5) NOT NULL default '0',
  `Subject_group` int(5) NOT NULL default '0',
  `Subject_no` varchar(50) character set tis620 collate tis620_bin NOT NULL default '0',
  `Start_date` date NOT NULL default '0000-00-00',
  `Objective` text NOT NULL,
  `Mainidea` text NOT NULL,
  `Title_name` text NOT NULL,
  `Total_hour` int(5) default NULL,
  `Total_std` int(5) default NULL,
  `Assess_code` int(5) NOT NULL default '0',
  `Method_code` int(5) NOT NULL default '0',
  `Place` varchar(255) NOT NULL default '',
  `Media` text NOT NULL,
  `Appendix` text NOT NULL,
  `Res_unit` varchar(5) NOT NULL default '',
  `Apply` varchar(5) NOT NULL default '',
  `Asses1` float(8,2) NOT NULL default '0.00',
  `Asses2` float(8,2) NOT NULL default '0.00',
  `Asses3` float(8,2) NOT NULL default '0.00',
  `Asses4` float(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (`Plan_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tech_plan_tb`
--

LOCK TABLES `tech_plan_tb` WRITE;
/*!40000 ALTER TABLE `tech_plan_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `tech_plan_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tech_spec_tb`
--

DROP TABLE IF EXISTS `tech_spec_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tech_spec_tb` (
  `Sptcode` int(11) NOT NULL auto_increment,
  `Plan_code` int(5) NOT NULL default '0',
  `Teacher_code` int(3) NOT NULL default '0',
  `courseId` int(3) NOT NULL default '0',
  `Sp1` varchar(255) NOT NULL default '',
  `Sp2` varchar(255) NOT NULL default '',
  `Sp3` varchar(255) NOT NULL default '',
  `Sp4` varchar(255) NOT NULL default '',
  `Sp5` varchar(255) NOT NULL default '',
  `Sp6` varchar(255) NOT NULL default '',
  `Sp7` varchar(255) NOT NULL default '',
  `Sp8` varchar(255) NOT NULL default '',
  `Sp9` varchar(255) NOT NULL default '',
  `Sp10` varchar(255) NOT NULL default '',
  `Sp11` varchar(255) NOT NULL default '',
  `Else_desc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`Sptcode`,`Plan_code`,`Teacher_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tech_spec_tb`
--

LOCK TABLES `tech_spec_tb` WRITE;
/*!40000 ALTER TABLE `tech_spec_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `tech_spec_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `techplan_method_tb`
--

DROP TABLE IF EXISTS `techplan_method_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `techplan_method_tb` (
  `code` int(11) NOT NULL auto_increment,
  `Plan_code` int(5) NOT NULL default '0',
  `Teacher_code` int(3) NOT NULL default '0',
  `courseId` int(3) NOT NULL default '0',
  `M1` varchar(255) NOT NULL default '',
  `M2` varchar(255) NOT NULL default '',
  `M3` varchar(255) NOT NULL default '',
  `M4` varchar(255) NOT NULL default '',
  `M5` varchar(255) NOT NULL default '',
  `M6` varchar(255) NOT NULL default '',
  `M7` varchar(255) NOT NULL default '',
  `M8` varchar(255) NOT NULL default '',
  `M9` varchar(255) NOT NULL default '',
  `M10` varchar(255) NOT NULL default '',
  `M11` varchar(255) NOT NULL default '',
  `M12` varchar(255) NOT NULL default '',
  `M13` varchar(255) NOT NULL default '',
  `M14` varchar(255) NOT NULL default '',
  `M15` varchar(255) NOT NULL default '',
  `M16` varchar(255) NOT NULL default '',
  `M17` varchar(255) NOT NULL default '',
  `M18` varchar(255) NOT NULL default '',
  `M19` varchar(255) NOT NULL default '',
  `M20` varchar(255) NOT NULL default '',
  `M21` varchar(255) NOT NULL default '',
  `M_else` varchar(255) NOT NULL default '',
  `Else_desc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `techplan_method_tb`
--

LOCK TABLES `techplan_method_tb` WRITE;
/*!40000 ALTER TABLE `techplan_method_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `techplan_method_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tooth_tb`
--

DROP TABLE IF EXISTS `tooth_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tooth_tb` (
  `Tooth_code` int(2) NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` varchar(10) NOT NULL default '',
  `Description_2` text NOT NULL,
  PRIMARY KEY  (`Tooth_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tooth_tb`
--

LOCK TABLES `tooth_tb` WRITE;
/*!40000 ALTER TABLE `tooth_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `tooth_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `training_tb`
--

DROP TABLE IF EXISTS `training_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `training_tb` (
  `Training_code` int(11) NOT NULL auto_increment,
  `Teacher_code` int(5) NOT NULL default '0',
  `Training_name` varchar(255) NOT NULL default '',
  `Period_code` int(5) NOT NULL default '0',
  `Training_type` int(1) NOT NULL default '0',
  `Level` varchar(50) NOT NULL default '',
  `Major` varchar(50) NOT NULL default '',
  `Year_std` varchar(10) NOT NULL default '',
  `Place` varchar(255) NOT NULL default '',
  `Place_des` varchar(200) NOT NULL default '',
  `Date_start` date NOT NULL default '0000-00-00',
  `Date_finish` date NOT NULL default '0000-00-00',
  `CNEU` varchar(100) NOT NULL default '',
  `Total_hour` int(11) NOT NULL default '0',
  `Fund` varchar(100) NOT NULL default '',
  `Fund_resource` varchar(100) NOT NULL default '',
  `Organiz` varchar(100) NOT NULL default '',
  `Date_send` date NOT NULL default '0000-00-00',
  `Period_prop` char(1) NOT NULL default '',
  `Apply` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Training_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `training_tb`
--

LOCK TABLES `training_tb` WRITE;
/*!40000 ALTER TABLE `training_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `training_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `training_type_tb`
--

DROP TABLE IF EXISTS `training_type_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `training_type_tb` (
  `Training_type` int(5) NOT NULL auto_increment,
  `Detail` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`Training_type`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `training_type_tb`
--

LOCK TABLES `training_type_tb` WRITE;
/*!40000 ALTER TABLE `training_type_tb` DISABLE KEYS */;
INSERT INTO `training_type_tb` VALUES (1,'การอบรม'),(2,'การศึกษาดูงาน'),(3,'ประชุม'),(4,'สัมมนา'),(5,'การศึกษาต่อของอาจารย์'),(6,'นิเทศงาน'),(7,'การเป็นวิทยากร');
/*!40000 ALTER TABLE `training_type_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treatMed_tb`
--

DROP TABLE IF EXISTS `treatMed_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `treatMed_tb` (
  `Teach_code` int(3) NOT NULL auto_increment,
  `Code_1` varchar(10) NOT NULL default '',
  `Name` varchar(30) NOT NULL default '',
  `Price` float(8,2) NOT NULL default '0.00',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Teach_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `treatMed_tb`
--

LOCK TABLES `treatMed_tb` WRITE;
/*!40000 ALTER TABLE `treatMed_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `treatMed_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treatcat_tb`
--

DROP TABLE IF EXISTS `treatcat_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `treatcat_tb` (
  `Code` int(3) NOT NULL auto_increment,
  `Code_id` varchar(10) NOT NULL default '',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `treatcat_tb`
--

LOCK TABLES `treatcat_tb` WRITE;
/*!40000 ALTER TABLE `treatcat_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `treatcat_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treatment_tb`
--

DROP TABLE IF EXISTS `treatment_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `treatment_tb` (
  `Teach_code` int(3) NOT NULL auto_increment,
  `Code_1` varchar(10) NOT NULL default '',
  `Name` varchar(30) NOT NULL default '',
  `Price` float(8,2) NOT NULL default '0.00',
  `Description_1` text NOT NULL,
  `Description_2` text NOT NULL,
  `Description_3` text NOT NULL,
  PRIMARY KEY  (`Teach_code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `treatment_tb`
--

LOCK TABLES `treatment_tb` WRITE;
/*!40000 ALTER TABLE `treatment_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `treatment_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_tb`
--

DROP TABLE IF EXISTS `user_tb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `user_tb` (
  `code` int(5) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Username` varchar(30) NOT NULL default '',
  `Password` varchar(50) NOT NULL default '',
  `PasswordR` varchar(100) NOT NULL default '',
  `Priority` mediumint(2) NOT NULL default '0',
  `Flag` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `user_tb`
--

LOCK TABLES `user_tb` WRITE;
/*!40000 ALTER TABLE `user_tb` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_tb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webboard_ans`
--

DROP TABLE IF EXISTS `webboard_ans`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webboard_ans` (
  `No` int(5) NOT NULL auto_increment,
  `QuestionNo` int(5) NOT NULL default '0',
  `Name` varchar(50) NOT NULL default '',
  `Namer` varchar(50) NOT NULL default '',
  `Member` tinyint(1) NOT NULL default '0',
  `IP` varchar(15) NOT NULL default '',
  `Email` varchar(50) NOT NULL default '',
  `Msg` text NOT NULL,
  `Date` datetime default NULL,
  `nphoto` text,
  PRIMARY KEY  (`No`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webboard_ans`
--

LOCK TABLES `webboard_ans` WRITE;
/*!40000 ALTER TABLE `webboard_ans` DISABLE KEYS */;
/*!40000 ALTER TABLE `webboard_ans` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webboard_data`
--

DROP TABLE IF EXISTS `webboard_data`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webboard_data` (
  `No` int(5) NOT NULL auto_increment,
  `Teacher_code` int(3) NOT NULL default '0',
  `Category` varchar(50) NOT NULL default '',
  `Question` varchar(100) NOT NULL default '',
  `Note` text NOT NULL,
  `Name` varchar(50) NOT NULL default '',
  `Namer` varchar(50) NOT NULL default '',
  `Member` tinyint(1) NOT NULL default '0',
  `Memberr` varchar(50) NOT NULL default '',
  `IP` varchar(15) NOT NULL default '',
  `Email` varchar(50) NOT NULL default '',
  `Reply` int(5) NOT NULL default '0',
  `ReplyDate` varchar(20) NOT NULL default '',
  `Date` datetime default NULL,
  `nphoto` varchar(50) default NULL,
  `pageview` char(3) default '0',
  PRIMARY KEY  (`No`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webboard_data`
--

LOCK TABLES `webboard_data` WRITE;
/*!40000 ALTER TABLE `webboard_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `webboard_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webboard_member`
--

DROP TABLE IF EXISTS `webboard_member`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webboard_member` (
  `id` int(6) NOT NULL auto_increment,
  `User` varchar(10) NOT NULL default '',
  `Password` varchar(10) NOT NULL default '',
  `Email` varchar(30) default NULL,
  `ICQ` varchar(15) default NULL,
  `WebName` varchar(80) default NULL,
  `URL` varchar(80) default NULL,
  `Date` datetime default NULL,
  `BDdate` varchar(20) NOT NULL default '',
  `Profile` text,
  `memphoto` varchar(50) default NULL,
  `IP` varchar(16) default NULL,
  `icon` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webboard_member`
--

LOCK TABLES `webboard_member` WRITE;
/*!40000 ALTER TABLE `webboard_member` DISABLE KEYS */;
/*!40000 ALTER TABLE `webboard_member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webboard_online`
--

DROP TABLE IF EXISTS `webboard_online`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webboard_online` (
  `SID` varchar(100) NOT NULL default '',
  `time` varchar(15) NOT NULL default '',
  `day` char(3) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webboard_online`
--

LOCK TABLES `webboard_online` WRITE;
/*!40000 ALTER TABLE `webboard_online` DISABLE KEYS */;
/*!40000 ALTER TABLE `webboard_online` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'managedb'
--
DELIMITER ;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-09-06  3:31:44