Da

✏️ Editing: jumrussc_edoc.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: jumrussc_edoc
-- ------------------------------------------------------
-- Server version	10.5.26-MariaDB

/*!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 utf8mb4 */;
/*!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 */;

--
-- Current Database: `jumrussc_edoc`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `jumrussc_edoc` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci */;

USE `jumrussc_edoc`;

--
-- Table structure for table `web_admin`
--

DROP TABLE IF EXISTS `web_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `data1` varchar(200) DEFAULT NULL,
  `data2` varchar(200) DEFAULT NULL,
  `data3` varchar(200) DEFAULT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `memberid` int(11) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `tshow` varchar(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `username` (`username`),
  KEY `password` (`password`),
  KEY `level` (`level`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_admin`
--

LOCK TABLES `web_admin` WRITE;
/*!40000 ALTER TABLE `web_admin` DISABLE KEYS */;
INSERT INTO `web_admin` VALUES (1,'','admin','@12345','บุญญวัฒน์ สงวนวงษ์','last.system.boonyawat@gmail.com','0634569146','เจ้าหน้าที่ ICT',1,1,1,'1'),(2,NULL,'admin','953567','ธนวัฒน์ หมวกเหล็ก','','','',1,NULL,2,'1');
/*!40000 ALTER TABLE `web_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_attach`
--

DROP TABLE IF EXISTS `web_attach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_attach` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `text01` varchar(100) DEFAULT NULL,
  `text02` varchar(100) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `attype` varchar(50) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `ftype` varchar(100) DEFAULT NULL,
  `fdate1` varchar(50) DEFAULT NULL,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `mdelete` varchar(1) DEFAULT NULL,
  `mdelete_inbox` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_attach`
--

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

--
-- Table structure for table `web_attach_doc`
--

DROP TABLE IF EXISTS `web_attach_doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_attach_doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `text01` varchar(100) DEFAULT NULL,
  `text02` varchar(100) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `attype` varchar(50) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `ftype` varchar(100) DEFAULT NULL,
  `fdate1` varchar(50) DEFAULT NULL,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `mdelete` varchar(1) DEFAULT NULL,
  `mdelete_inbox` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_attach_doc`
--

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

--
-- Table structure for table `web_attachfile`
--

DROP TABLE IF EXISTS `web_attachfile`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_attachfile` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `toption` varchar(50) DEFAULT NULL,
  `category` varchar(10) DEFAULT NULL,
  `topic_id` varchar(10) DEFAULT NULL,
  `file` varchar(200) DEFAULT NULL,
  `name` varchar(150) DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `filesize` varchar(50) DEFAULT NULL,
  `mode` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_attachfile`
--

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

--
-- Table structure for table `web_calendar`
--

DROP TABLE IF EXISTS `web_calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_calendar` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(30) DEFAULT NULL,
  `category` varchar(10) DEFAULT NULL,
  `date_event` int(15) unsigned DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `icon` varchar(200) DEFAULT NULL,
  `post_date` int(20) DEFAULT NULL,
  `update_date` int(20) DEFAULT NULL,
  `pageview` int(11) DEFAULT NULL,
  `tshow` char(1) DEFAULT NULL,
  `sort` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_calendar`
--

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

--
-- Table structure for table `web_data1`
--

DROP TABLE IF EXISTS `web_data1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data1`
--

LOCK TABLES `web_data1` WRITE;
/*!40000 ALTER TABLE `web_data1` DISABLE KEYS */;
INSERT INTO `web_data1` VALUES (1,'นาย','',1),(2,'นางสาว','',2),(3,'นาง','',1);
/*!40000 ALTER TABLE `web_data1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data10`
--

DROP TABLE IF EXISTS `web_data10`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data10` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text01` varchar(50) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `name2` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `centerid` varchar(50) DEFAULT NULL,
  `internalid` varchar(50) DEFAULT NULL,
  `gt_01` varchar(2) DEFAULT NULL,
  `gt_02` varchar(2) DEFAULT NULL,
  `num01` varchar(10) DEFAULT NULL,
  `gt_03` varchar(2) DEFAULT NULL,
  `num03` varchar(10) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data10`
--

LOCK TABLES `web_data10` WRITE;
/*!40000 ALTER TABLE `web_data10` DISABLE KEYS */;
INSERT INTO `web_data10` VALUES (1,'1','จว','จว',NULL,'1','','','','','','',NULL),(2,'8','','',NULL,'1','','','','','','',NULL),(3,'7','','',NULL,'1','','','','','','',NULL);
/*!40000 ALTER TABLE `web_data10` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data2`
--

DROP TABLE IF EXISTS `web_data2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cateid` varchar(10) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `cateid2` varchar(50) DEFAULT NULL,
  `tshow` varchar(1) DEFAULT NULL,
  `tshow2` varchar(1) DEFAULT NULL,
  `cateid3` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data2`
--

LOCK TABLES `web_data2` WRITE;
/*!40000 ALTER TABLE `web_data2` DISABLE KEYS */;
INSERT INTO `web_data2` VALUES (1,'','โรงเรียนจำรัสวิทยา','',1,'',NULL,NULL,NULL),(2,'1','กลุ่มงานการศึกษา','',1,'1',NULL,NULL,NULL),(3,'1','กลุ่มงานบริหารทั่วไป','',2,'1',NULL,NULL,NULL),(4,'1','กลุ่มงานนโยบายและแผน','',3,'1',NULL,NULL,NULL),(5,'1','ฝ่ายปฐมวัย','',1,'2',NULL,NULL,NULL),(6,'1','ฝ่ายประถมศึกษาและมัธยมศึกษา','',2,'2',NULL,NULL,NULL),(7,'1','ฝ่ายบริหารทั่วไป','',1,'3','1',NULL,'3'),(8,'1','ฝ่ายธุรการ','',2,'3','1',NULL,'3'),(9,'1','ฝ่ายพัสดุ','',3,'3',NULL,NULL,NULL),(10,'1','ฝ่ายนโยบายและแผน','',1,'4',NULL,NULL,NULL),(11,'1','ฝ่ายบัญชี','',2,'4',NULL,NULL,NULL),(12,'1','ฝ่ายกฎหมาย','',3,'4',NULL,NULL,NULL);
/*!40000 ALTER TABLE `web_data2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data20`
--

DROP TABLE IF EXISTS `web_data20`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data20` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data20`
--

LOCK TABLES `web_data20` WRITE;
/*!40000 ALTER TABLE `web_data20` DISABLE KEYS */;
INSERT INTO `web_data20` VALUES (3,'หน่วยงานระดับอำเภอ','',3);
/*!40000 ALTER TABLE `web_data20` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data3`
--

DROP TABLE IF EXISTS `web_data3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data3`
--

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

--
-- Table structure for table `web_data4`
--

DROP TABLE IF EXISTS `web_data4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data4` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data4`
--

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

--
-- Table structure for table `web_data5`
--

DROP TABLE IF EXISTS `web_data5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data5` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data5`
--

LOCK TABLES `web_data5` WRITE;
/*!40000 ALTER TABLE `web_data5` DISABLE KEYS */;
INSERT INTO `web_data5` VALUES (1,'เพื่อทราบ','',1),(2,'เพื่อโปรดทราบ','',2),(3,' เพื่อโปรดพิจารณา','',3),(4,'เพื่อโปรดดำเนินการ','',4),(5,'เพื่อโปรดทราบและดำเนินการต่อไป','',5),(6,'เพื่อโปรดพิจารณาอนุมัติ','',6),(7,'เพื่อโปรดพิจารณาลงนาม','',7),(8,'เพื่อโปรดพิจารณาอนุญาติ','',8),(9,'เพื่อโปรดพิจารณาสั่งการ','',9),(10,'เพื่อให้นำเสนอหรือแจ้งต่อไป','',10),(11,'เพื่อถือปฏิบัติโดยทั่วกัน','',11),(12,'เพื่อปรึกษาหารือ','',12),(13,' เพื่อซักซ้อมความเข้าใจ','',13),(14,' เพื่อชี้แจงข้อเท็จจริง','',1);
/*!40000 ALTER TABLE `web_data5` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data6`
--

DROP TABLE IF EXISTS `web_data6`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data6` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data6`
--

LOCK TABLES `web_data6` WRITE;
/*!40000 ALTER TABLE `web_data6` DISABLE KEYS */;
INSERT INTO `web_data6` VALUES (1,'ปกติ','',1),(2,'ด่วน','',2),(3,'ด่วนมาก','',3),(4,'ด่วนที่สุด','',4);
/*!40000 ALTER TABLE `web_data6` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data7`
--

DROP TABLE IF EXISTS `web_data7`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data7` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data7`
--

LOCK TABLES `web_data7` WRITE;
/*!40000 ALTER TABLE `web_data7` DISABLE KEYS */;
INSERT INTO `web_data7` VALUES (1,'ปกติ','',1),(2,'ลับมาก','',3),(3,'ลับที่สุด','',4),(4,'ลับ','',2);
/*!40000 ALTER TABLE `web_data7` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_data8`
--

DROP TABLE IF EXISTS `web_data8`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data8` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data8`
--

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

--
-- Table structure for table `web_data9`
--

DROP TABLE IF EXISTS `web_data9`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_data9` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_data9`
--

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

--
-- Table structure for table `web_doc1`
--

DROP TABLE IF EXISTS `web_doc1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_doc1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `org_id` varchar(20) DEFAULT NULL,
  `data100` varchar(255) DEFAULT NULL,
  `data00` varchar(255) DEFAULT NULL,
  `data01` varchar(255) DEFAULT NULL,
  `data02` varchar(255) DEFAULT NULL,
  `data03` varchar(255) DEFAULT NULL,
  `data04` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT 0,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '0',
  `status_send` varchar(1) DEFAULT '0',
  `status_type` varchar(1) DEFAULT '0',
  `readview` tinyint(4) DEFAULT 0,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text06_1` varchar(10) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` text DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_doc1`
--

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

--
-- Table structure for table `web_edit`
--

DROP TABLE IF EXISTS `web_edit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_edit` (
  `ssi` varchar(50) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `ttime` int(11) DEFAULT NULL,
  `ttable` varchar(10) DEFAULT NULL,
  `mode` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_edit`
--

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

--
-- Table structure for table `web_external`
--

DROP TABLE IF EXISTS `web_external`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_external` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `org_id` varchar(20) DEFAULT NULL,
  `data100` varchar(255) DEFAULT NULL,
  `data00` varchar(255) DEFAULT NULL,
  `data01` varchar(255) DEFAULT NULL,
  `data02` varchar(255) DEFAULT NULL,
  `data03` varchar(255) DEFAULT NULL,
  `data04` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT 0,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '0',
  `status_send` varchar(1) DEFAULT '0',
  `status_type` varchar(1) DEFAULT '0',
  `readview` tinyint(4) DEFAULT 0,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_external`
--

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

--
-- Table structure for table `web_external_doc`
--

DROP TABLE IF EXISTS `web_external_doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_external_doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `internalid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `stype` varchar(50) DEFAULT NULL,
  `readview` tinyint(4) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text03_time` varchar(20) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `text03_date01` varchar(50) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_external_doc`
--

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

--
-- Table structure for table `web_group`
--

DROP TABLE IF EXISTS `web_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(10) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `detail_list` text DEFAULT NULL,
  `detail_no` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_group`
--

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

--
-- Table structure for table `web_home`
--

DROP TABLE IF EXISTS `web_home`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_home` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_home`
--

LOCK TABLES `web_home` WRITE;
/*!40000 ALTER TABLE `web_home` DISABLE KEYS */;
INSERT INTO `web_home` VALUES (1,'ระบบสารบรรณ','โรงเรียนจำรัสวิทยา','เลขที่ 59 หมู่ 1 ต.คำพราน อ.วังม่วง จ.สระบุรี 18220',1);
/*!40000 ALTER TABLE `web_home` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_inbox`
--

DROP TABLE IF EXISTS `web_inbox`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_inbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `org_id` varchar(20) DEFAULT NULL,
  `data100` varchar(255) DEFAULT NULL,
  `data00` varchar(255) DEFAULT NULL,
  `data01` varchar(255) DEFAULT NULL,
  `data02` varchar(255) DEFAULT NULL,
  `data03` varchar(255) DEFAULT NULL,
  `data04` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT 0,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '0',
  `status_send` varchar(1) DEFAULT '0',
  `status_type` varchar(1) DEFAULT '0',
  `readview` tinyint(4) DEFAULT 0,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(20) DEFAULT NULL,
  `text05_name` varchar(255) NOT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_inbox`
--

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

--
-- Table structure for table `web_inbox_doc`
--

DROP TABLE IF EXISTS `web_inbox_doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_inbox_doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `internalid` varchar(50) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `status_send` varchar(1) DEFAULT NULL,
  `status_type` varchar(1) DEFAULT NULL,
  `readview` tinyint(4) DEFAULT NULL,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text03_time` varchar(20) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `text03_date01` varchar(20) DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_inbox_doc`
--

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

--
-- Table structure for table `web_internal`
--

DROP TABLE IF EXISTS `web_internal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_internal` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `org_id` varchar(20) DEFAULT NULL,
  `data100` varchar(255) DEFAULT NULL,
  `data00` varchar(255) DEFAULT NULL,
  `data01` varchar(255) DEFAULT NULL,
  `data02` varchar(255) DEFAULT NULL,
  `data03` varchar(255) DEFAULT NULL,
  `data04` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT 0,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '0',
  `status_send` varchar(1) DEFAULT '0',
  `status_type` varchar(1) DEFAULT '0',
  `readview` tinyint(4) DEFAULT 0,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_internal`
--

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

--
-- Table structure for table `web_internal1`
--

DROP TABLE IF EXISTS `web_internal1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_internal1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `org_id` varchar(20) DEFAULT NULL,
  `data100` varchar(255) DEFAULT NULL,
  `data00` varchar(255) DEFAULT NULL,
  `data01` varchar(255) DEFAULT NULL,
  `data02` varchar(255) DEFAULT NULL,
  `data03` varchar(255) DEFAULT NULL,
  `data04` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT 0,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '0',
  `status_send` varchar(1) DEFAULT '0',
  `status_type` varchar(1) DEFAULT '0',
  `readview` tinyint(4) DEFAULT 0,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_internal1`
--

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

--
-- Table structure for table `web_internal2`
--

DROP TABLE IF EXISTS `web_internal2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_internal2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `userid_rec` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `org_id` varchar(20) DEFAULT NULL,
  `data100` varchar(255) DEFAULT NULL,
  `data00` varchar(255) DEFAULT NULL,
  `data01` varchar(255) DEFAULT NULL,
  `data02` varchar(255) DEFAULT NULL,
  `data03` varchar(255) DEFAULT NULL,
  `data04` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT 0,
  `ref_sendid` varchar(50) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref2_userid` varchar(20) DEFAULT NULL,
  `ref2_type` varchar(20) DEFAULT NULL,
  `ref_no` varchar(10) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `status` varchar(1) DEFAULT '0',
  `status_send` varchar(1) DEFAULT '0',
  `status_type` varchar(1) DEFAULT '0',
  `readview` tinyint(4) DEFAULT 0,
  `attachid` varchar(255) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01_ref` varchar(100) DEFAULT NULL,
  `text02_ref` varchar(100) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `fdate` varchar(255) DEFAULT NULL,
  `ftime` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `date_receive` int(11) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  `tsend` varchar(20) DEFAULT NULL,
  `tday2` varchar(5) DEFAULT NULL,
  `tmonth2` varchar(5) DEFAULT NULL,
  `tyear2` varchar(5) DEFAULT NULL,
  `tcheck` int(10) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_internal2`
--

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

--
-- Table structure for table `web_intertalk`
--

DROP TABLE IF EXISTS `web_intertalk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_intertalk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `internalid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `stype` varchar(50) DEFAULT NULL,
  `readview` tinyint(4) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text01` varchar(255) DEFAULT NULL,
  `text01_1` varchar(20) DEFAULT NULL,
  `text02` int(11) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05_id` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `text03_date` int(11) unsigned DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_intertalk`
--

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

--
-- Table structure for table `web_listname`
--

DROP TABLE IF EXISTS `web_listname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_listname` (
  `userid` varchar(50) DEFAULT NULL,
  `text` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_listname`
--

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

--
-- Table structure for table `web_listname2`
--

DROP TABLE IF EXISTS `web_listname2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_listname2` (
  `userid` varchar(50) DEFAULT NULL,
  `tb` varchar(50) DEFAULT NULL,
  `user_id` varchar(20) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `tel` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_listname2`
--

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

--
-- Table structure for table `web_log`
--

DROP TABLE IF EXISTS `web_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `internalid` varchar(20) DEFAULT NULL,
  `text01` varchar(50) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `no` varchar(10) DEFAULT NULL,
  `ttable` varchar(20) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `ttime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_log`
--

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

--
-- Table structure for table `web_log_doc`
--

DROP TABLE IF EXISTS `web_log_doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_log_doc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `internalid` varchar(20) DEFAULT NULL,
  `text01` varchar(50) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `no` varchar(10) DEFAULT NULL,
  `ttable` varchar(20) DEFAULT NULL,
  `detail` varchar(100) DEFAULT NULL,
  `ttime` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_log_doc`
--

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

--
-- Table structure for table `web_month`
--

DROP TABLE IF EXISTS `web_month`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_month` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `topic` varchar(20) DEFAULT NULL,
  `detail` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_month`
--

LOCK TABLES `web_month` WRITE;
/*!40000 ALTER TABLE `web_month` DISABLE KEYS */;
INSERT INTO `web_month` VALUES (1,'มกราคม',''),(2,'กุมภาพันธ์',''),(3,'มีนาคม',''),(4,'เมษายน',''),(5,'พฤษภาคม',''),(6,'มิถุนายน',''),(7,'กรกฎาคม',''),(8,'สิงหาคม',''),(9,'กันยายน',''),(10,'ตุลาคม',''),(11,'พฤศจิกายน',''),(12,'ธันวาคม','');
/*!40000 ALTER TABLE `web_month` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_number_in`
--

DROP TABLE IF EXISTS `web_number_in`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_number_in` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_number_in`
--

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

--
-- Table structure for table `web_number_in2`
--

DROP TABLE IF EXISTS `web_number_in2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_number_in2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_number_in2`
--

LOCK TABLES `web_number_in2` WRITE;
/*!40000 ALTER TABLE `web_number_in2` DISABLE KEYS */;
INSERT INTO `web_number_in2` VALUES (1,'2566','1',NULL,0);
/*!40000 ALTER TABLE `web_number_in2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_number_in3`
--

DROP TABLE IF EXISTS `web_number_in3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_number_in3` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_number_in3`
--

LOCK TABLES `web_number_in3` WRITE;
/*!40000 ALTER TABLE `web_number_in3` DISABLE KEYS */;
INSERT INTO `web_number_in3` VALUES (1,'2566','1',NULL,0);
/*!40000 ALTER TABLE `web_number_in3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_number_out`
--

DROP TABLE IF EXISTS `web_number_out`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_number_out` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_number_out`
--

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

--
-- Table structure for table `web_numberdoc1`
--

DROP TABLE IF EXISTS `web_numberdoc1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_numberdoc1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_numberdoc1`
--

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

--
-- Table structure for table `web_numberout`
--

DROP TABLE IF EXISTS `web_numberout`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_numberout` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_numberout`
--

LOCK TABLES `web_numberout` WRITE;
/*!40000 ALTER TABLE `web_numberout` DISABLE KEYS */;
INSERT INTO `web_numberout` VALUES (1,'2566','1',NULL,0);
/*!40000 ALTER TABLE `web_numberout` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_numberrec`
--

DROP TABLE IF EXISTS `web_numberrec`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_numberrec` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_numberrec`
--

LOCK TABLES `web_numberrec` WRITE;
/*!40000 ALTER TABLE `web_numberrec` DISABLE KEYS */;
INSERT INTO `web_numberrec` VALUES (1,'2566','1',NULL,4),(2,'2566','1','โรงเรียนจำรัสวิทยา',5);
/*!40000 ALTER TABLE `web_numberrec` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_numbertalk`
--

DROP TABLE IF EXISTS `web_numbertalk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_numbertalk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `year` varchar(4) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_numbertalk`
--

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

--
-- Table structure for table `web_regist`
--

DROP TABLE IF EXISTS `web_regist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_regist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `date_time` varchar(50) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `doc_id` varchar(50) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `regid` int(10) unsigned DEFAULT NULL,
  `readview` varchar(1) DEFAULT NULL,
  `attype` varchar(50) DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `u_id` varchar(50) DEFAULT NULL,
  `u_name` varchar(255) DEFAULT NULL,
  `to_id` varchar(10) DEFAULT NULL,
  `to_name` varchar(200) DEFAULT NULL,
  `sendid` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_regist`
--

LOCK TABLES `web_regist` WRITE;
/*!40000 ALTER TABLE `web_regist` DISABLE KEYS */;
INSERT INTO `web_regist` VALUES (1,'17/1/2566','17:11:20','1673950280','user_33',NULL,'ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','จว','1673949457',1,NULL,NULL,NULL,'inbox','','ลงทะเบียนรับเอกสาร จว/1','user_33','ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','','',NULL),(2,'17/1/2566','17:12:37','1673950357','user_33',NULL,'ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','จว','1673950346',3,NULL,NULL,NULL,'inbox','','ลงทะเบียนรับเอกสาร จว/3','user_33','ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','','',NULL),(3,'17/1/2566','17:13:36','1673950416','user_33',NULL,'ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','จว','1673950408',4,NULL,NULL,NULL,'inbox','','ลงทะเบียนรับเอกสาร จว/4','user_33','ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','','',NULL),(4,'17/1/2566','17:15:06','1673950506','user_33',NULL,'ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','จว','1673950490',5,NULL,NULL,NULL,'inbox','','ลงทะเบียนรับเอกสาร จว/5','user_33','ดาวรุ่ง ตรีวิสูตร[ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา]-สารบรรณกลาง-สารบรรณฝ่าย','','',NULL);
/*!40000 ALTER TABLE `web_regist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_regist_doc`
--

DROP TABLE IF EXISTS `web_regist_doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_regist_doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `date_time` varchar(50) DEFAULT NULL,
  `userid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `doc_id` varchar(50) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `regid` int(10) unsigned DEFAULT NULL,
  `readview` varchar(1) DEFAULT NULL,
  `attype` varchar(50) DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `u_id` varchar(50) DEFAULT NULL,
  `u_name` varchar(255) DEFAULT NULL,
  `to_id` varchar(10) DEFAULT NULL,
  `to_name` varchar(200) DEFAULT NULL,
  `sendid` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_regist_doc`
--

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

--
-- Table structure for table `web_reject`
--

DROP TABLE IF EXISTS `web_reject`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_reject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `internalid` varchar(20) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `sendid` varchar(50) DEFAULT NULL,
  `uid` varchar(50) DEFAULT NULL,
  `uid_name` varchar(255) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `fdate1` varchar(50) DEFAULT NULL,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_reject`
--

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

--
-- Table structure for table `web_send`
--

DROP TABLE IF EXISTS `web_send`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_send` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `centerid` varchar(10) DEFAULT NULL,
  `internalid` varchar(10) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `text01` varchar(100) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text02` varchar(100) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `readview` tinyint(4) DEFAULT NULL,
  `attachid` varchar(255) DEFAULT NULL,
  `stype` varchar(50) DEFAULT NULL,
  `tto_id` varchar(255) DEFAULT NULL,
  `tto` varchar(255) DEFAULT NULL,
  `bcc_id` varchar(255) DEFAULT NULL,
  `bcc` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `ftype` varchar(100) DEFAULT NULL,
  `fdate1` varchar(50) DEFAULT NULL,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_send`
--

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

--
-- Table structure for table `web_send_doc`
--

DROP TABLE IF EXISTS `web_send_doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_send_doc` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) DEFAULT NULL,
  `internalid` varchar(50) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `ref_userid` varchar(50) DEFAULT NULL,
  `ref_type` varchar(50) DEFAULT NULL,
  `text01` varchar(100) DEFAULT NULL,
  `id_ref` varchar(50) DEFAULT NULL,
  `text02` varchar(100) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `readview` tinyint(4) DEFAULT NULL,
  `attachid` varchar(255) DEFAULT NULL,
  `stype` varchar(50) DEFAULT NULL,
  `tto_id` varchar(255) DEFAULT NULL,
  `tto` varchar(255) DEFAULT NULL,
  `bcc_id` varchar(255) DEFAULT NULL,
  `bcc` varchar(255) DEFAULT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `ftype` varchar(100) DEFAULT NULL,
  `fdate1` varchar(50) DEFAULT NULL,
  `fdate` varchar(50) DEFAULT NULL,
  `ftime` varchar(50) DEFAULT NULL,
  `text03` varchar(255) DEFAULT NULL,
  `text03_time` varchar(20) DEFAULT NULL,
  `text04` varchar(255) DEFAULT NULL,
  `text05` varchar(255) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(255) DEFAULT NULL,
  `text08` varchar(255) DEFAULT NULL,
  `text09` varchar(255) DEFAULT NULL,
  `text20` varchar(255) DEFAULT NULL,
  `text21` varchar(255) DEFAULT NULL,
  `text22` varchar(255) DEFAULT NULL,
  `text23` varchar(255) DEFAULT NULL,
  `text24` varchar(255) DEFAULT NULL,
  `text25` varchar(255) DEFAULT NULL,
  `user_edit` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_send_doc`
--

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

--
-- Table structure for table `web_stat`
--

DROP TABLE IF EXISTS `web_stat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(5) DEFAULT NULL,
  `internalid` varchar(5) DEFAULT NULL,
  `text01` varchar(50) DEFAULT NULL,
  `date_send` varchar(50) DEFAULT NULL,
  `tday` varchar(5) DEFAULT NULL,
  `tmonth` varchar(5) DEFAULT NULL,
  `tyear` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_stat`
--

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

--
-- Table structure for table `web_text`
--

DROP TABLE IF EXISTS `web_text`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_text` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data1` varchar(255) DEFAULT NULL,
  `data2` varchar(255) DEFAULT NULL,
  `data3` varchar(255) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_text`
--

LOCK TABLES `web_text` WRITE;
/*!40000 ALTER TABLE `web_text` DISABLE KEYS */;
INSERT INTO `web_text` VALUES (1,'โรงเรียนจำรัสวิทยา','โรงเรียนจำรัสวิทยา','ผู้อำนวยการโรงเรียนจำรัสวิทยา',1);
/*!40000 ALTER TABLE `web_text` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_user`
--

DROP TABLE IF EXISTS `web_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cateid` varchar(10) DEFAULT NULL,
  `cateid2` varchar(10) DEFAULT NULL,
  `org` varchar(10) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `detail2` varchar(255) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `gt1` varchar(1) DEFAULT NULL,
  `gt2` varchar(1) DEFAULT NULL,
  `gt3` varchar(1) DEFAULT NULL,
  `gt4` varchar(1) DEFAULT NULL,
  `gt41` varchar(1) DEFAULT NULL,
  `gt5` varchar(1) DEFAULT NULL,
  `gt6` varchar(1) DEFAULT NULL,
  `gt7` varchar(1) DEFAULT NULL,
  `gt8` varchar(1) DEFAULT NULL,
  `gt9` varchar(1) DEFAULT NULL,
  `gt10` varchar(1) DEFAULT NULL,
  `gt11` varchar(1) DEFAULT NULL,
  `gt12` varchar(1) DEFAULT NULL,
  `gt13` varchar(1) DEFAULT NULL,
  `gt14` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_user`
--

LOCK TABLES `web_user` WRITE;
/*!40000 ALTER TABLE `web_user` DISABLE KEYS */;
INSERT INTO `web_user` VALUES (5,'2','5','1','u1001','12345','','','นางวันนา พยนต์','','2','','','','','','','','','','','','',''),(7,'2','6','1','u1002','12345','','','นางสาวดาวรุ่ง ตรีวิสูตร','','2','','','','','','','','','','','','',''),(10,'3','7','1','u2001','12345','','','นางสาวนันทภรณ์ หมวกเหล็ก','','2','','','','','','','','','','','','',''),(12,'3','8','1','u2002','12345','','','นางสาวนภณัฏฐ์ จูปราง','1','','','','','','','','','','1','','','',''),(17,'4','10','1','u3001','1234','','','นางสาวชลธิดา กลิ่นสุคนธ์','','2','','','','','','','','','','','','',''),(30,'','1','','tanawat','953567','ผู้อำนวยการโรงเรียน','','นายธนวัฒน์ หมวกเหล็ก','','','','','','5','','','8','','1','1','1','',''),(33,'','1','','daorung','2620','ผู้บริหารฝ่ายประถมศึกษาและมัธยมศึกษา','','ดาวรุ่ง ตรีวิสูตร','','','','4','','','','','','','','','','',''),(34,'','1','','cholthida','0621','ผู้บริหารฝ่ายนโยบายและแผน','','ชลธิดา กลิ่นสุคนธ์','','','','4','','','','','','','','','1','',''),(35,'','1','','wanna','wanna','ผู้บริหารฝ่ายปฐมวัย','','วันนา พยนต์','','','','4','','','','','','','','','1','',''),(36,'','','','napanut','1908','เจ้าหน้าที่ธุรการ','','นภนัฏฐ์ จูปราง','1','','3','','','','','','','','','','','',''),(37,'','1','','nantaporn','953567','','','นันทภรณ์ หมวกเหล็ก','1','','','','','','','','','','','','','','');
/*!40000 ALTER TABLE `web_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `web_user2`
--

DROP TABLE IF EXISTS `web_user2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_user2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cateid` varchar(10) DEFAULT NULL,
  `cateid2` varchar(10) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `gt1` varchar(1) DEFAULT NULL,
  `gt2` varchar(1) DEFAULT NULL,
  `gt3` varchar(1) DEFAULT NULL,
  `gt4` varchar(1) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `province` varchar(10) DEFAULT NULL,
  `subprovince` varchar(10) DEFAULT NULL,
  `userid` varchar(10) DEFAULT NULL,
  `text01` varchar(100) DEFAULT NULL,
  `text02` varchar(100) DEFAULT NULL,
  `text03` varchar(50) DEFAULT NULL,
  `text04` varchar(10) DEFAULT NULL,
  `text05` varchar(250) DEFAULT NULL,
  `text06` varchar(250) DEFAULT NULL,
  `text07` varchar(50) DEFAULT NULL,
  `text08` varchar(100) DEFAULT NULL,
  `text09` varchar(20) DEFAULT NULL,
  `text10` varchar(100) DEFAULT NULL,
  `text11` varchar(100) DEFAULT NULL,
  `text12` varchar(50) DEFAULT NULL,
  `text13` varchar(50) DEFAULT NULL,
  `text14` varchar(20) DEFAULT NULL,
  `text15` varchar(100) DEFAULT NULL,
  `text16` varchar(20) DEFAULT NULL,
  `text17` varchar(10) DEFAULT NULL,
  `tdate` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_user2`
--

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

--
-- Table structure for table `web_useronline`
--

DROP TABLE IF EXISTS `web_useronline`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_useronline` (
  `userid` varchar(30) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `userid_name` varchar(200) DEFAULT NULL,
  `ttime` int(10) unsigned DEFAULT NULL,
  `ssi` varchar(40) DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_useronline`
--

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

--
-- Table structure for table `web_useronline2`
--

DROP TABLE IF EXISTS `web_useronline2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_useronline2` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(30) DEFAULT NULL,
  `userid_name` varchar(200) DEFAULT NULL,
  `ttime` int(10) unsigned DEFAULT NULL,
  `ip` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_useronline2`
--

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

--
-- Table structure for table `web_userperson`
--

DROP TABLE IF EXISTS `web_userperson`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `web_userperson` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `level1` varchar(10) DEFAULT NULL,
  `level2` varchar(10) DEFAULT NULL,
  `cateid` varchar(10) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `userid` varchar(20) DEFAULT NULL,
  `data01` varchar(100) DEFAULT NULL,
  `data02` varchar(100) DEFAULT NULL,
  `text01_1` varchar(20) DEFAULT NULL,
  `text01` varchar(100) DEFAULT NULL,
  `text02` varchar(100) DEFAULT NULL,
  `text02_2` varchar(50) DEFAULT NULL,
  `text03` varchar(50) DEFAULT NULL,
  `text04` varchar(20) DEFAULT NULL,
  `text05` varchar(250) DEFAULT NULL,
  `text06` varchar(255) DEFAULT NULL,
  `text07` varchar(50) DEFAULT NULL,
  `text08` varchar(100) DEFAULT NULL,
  `text09` varchar(20) DEFAULT NULL,
  `text09_1` varchar(50) DEFAULT NULL,
  `text10` varchar(50) DEFAULT NULL,
  `text11` varchar(50) DEFAULT NULL,
  `text12` varchar(50) DEFAULT NULL,
  `addr_1` varchar(10) DEFAULT NULL,
  `addr_2` varchar(10) DEFAULT NULL,
  `addr_3` varchar(50) DEFAULT NULL,
  `addr_4` varchar(50) DEFAULT NULL,
  `addr_5` varchar(50) DEFAULT NULL,
  `addr_6` varchar(50) DEFAULT NULL,
  `addr_7` varchar(50) DEFAULT NULL,
  `addr_8` varchar(50) DEFAULT NULL,
  `addr_9` varchar(10) DEFAULT NULL,
  `addr2_1` varchar(10) DEFAULT NULL,
  `addr2_2` varchar(10) DEFAULT NULL,
  `addr2_3` varchar(50) DEFAULT NULL,
  `addr2_4` varchar(50) DEFAULT NULL,
  `addr2_5` varchar(50) DEFAULT NULL,
  `addr2_6` varchar(50) DEFAULT NULL,
  `addr2_7` varchar(50) DEFAULT NULL,
  `addr2_8` varchar(50) DEFAULT NULL,
  `addr2_9` varchar(10) DEFAULT NULL,
  `tdate` int(11) DEFAULT NULL,
  `tday` varchar(2) DEFAULT NULL,
  `tmonth` varchar(2) DEFAULT NULL,
  `tyear` varchar(4) DEFAULT NULL,
  `ttime` varchar(10) DEFAULT NULL,
  `tstatus` varchar(1) DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_userperson`
--

LOCK TABLES `web_userperson` WRITE;
/*!40000 ALTER TABLE `web_userperson` DISABLE KEYS */;
/*!40000 ALTER TABLE `web_userperson` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2025-10-22 16:51:48

📁 Sid Gifari File Manager