| Server IP : 172.67.187.206 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /dataDB/BackupDB/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 4.6.6 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Jun 19, 2025 at 03:02 AM -- Server version: 5.7.17-log -- PHP Version: 5.6.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `sc_prachamongkol` -- CREATE DATABASE IF NOT EXISTS `sc_prachamongkol` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `sc_prachamongkol`; -- -------------------------------------------------------- -- -- Table structure for table `web_activeuser` -- CREATE TABLE IF NOT EXISTS `web_activeuser` ( `ct_no` int(11) NOT NULL AUTO_INCREMENT, `ct_yyyy` int(4) NOT NULL DEFAULT '0', `ct_mm` int(2) NOT NULL DEFAULT '0', `ct_dd` int(2) NOT NULL DEFAULT '0', `ct_ip` varchar(15) NOT NULL DEFAULT '', `ct_count` int(2) NOT NULL DEFAULT '0', `ct_time` int(20) NOT NULL DEFAULT '0', PRIMARY KEY (`ct_no`) ) ENGINE=MyISAM AUTO_INCREMENT=431 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_activeuser` -- INSERT INTO `web_activeuser` (`ct_no`, `ct_yyyy`, `ct_mm`, `ct_dd`, `ct_ip`, `ct_count`, `ct_time`) VALUES (1, 2018, 10, 11, '127.0.0.1', 1, 1539266147), (2, 2018, 10, 19, '127.0.0.1', 1, 1539903898), (3, 2018, 10, 26, '127.0.0.1', 1, 1540553252), (4, 2018, 10, 27, '127.0.0.1', 1, 1540634219), (5, 2018, 10, 30, '127.0.0.1', 1, 1540906862), (6, 2018, 11, 9, '127.0.0.1', 1, 1541746328), (7, 2018, 11, 13, '127.0.0.1', 1, 1542112424), (8, 2018, 11, 14, '127.0.0.1', 1, 1542177359), (9, 2018, 11, 16, '127.0.0.1', 1, 1542352607), (10, 2018, 11, 17, '127.0.0.1', 1, 1542450938), (11, 2018, 11, 18, '127.0.0.1', 1, 1542537726), (12, 2018, 11, 19, '127.0.0.1', 1, 1542591671), (13, 2018, 11, 21, '127.0.0.1', 1, 1542777935), (14, 2018, 11, 22, '127.0.0.1', 1, 1542890709), (15, 2018, 11, 23, '127.0.0.1', 1, 1542931470), (16, 2018, 12, 5, '127.0.0.1', 1, 1543988577), (17, 2018, 12, 7, '127.0.0.1', 1, 1544175297), (18, 2018, 12, 8, '127.0.0.1', 1, 1544237684), (19, 2018, 12, 12, '127.0.0.1', 1, 1544598257), (20, 2018, 12, 15, '127.0.0.1', 1, 1544869925), (21, 2018, 12, 17, '127.0.0.1', 1, 1545044672), (22, 2018, 12, 18, '127.0.0.1', 1, 1545121277), (23, 2018, 12, 21, '127.0.0.1', 1, 1545366744), (24, 2018, 12, 25, '127.0.0.1', 1, 1545740679), (25, 2018, 12, 26, '127.0.0.1', 1, 1545792289), (26, 2019, 1, 1, '113.53.77.78', 1, 1546326254), (27, 2019, 1, 1, '171.7.238.60', 1, 1546325420), (28, 2019, 1, 1, '171.7.250.242', 1, 1546342495), (29, 2019, 1, 1, '184.22.45.160', 1, 1546343797), (30, 2019, 1, 1, '66.102.6.40', 1, 1546345494), (31, 2019, 1, 2, '113.53.71.146', 1, 1546395744), (32, 2019, 1, 2, '125.24.49.142', 1, 1546399432), (33, 2019, 1, 2, '113.53.73.205', 1, 1546394496), (34, 2019, 1, 2, '182.52.16.122', 1, 1546401930), (35, 2019, 1, 2, '49.230.121.176', 1, 1546394579), (36, 2019, 1, 2, '182.53.198.145', 1, 1546395307), (37, 2019, 1, 2, '49.230.110.80', 1, 1546395497), (38, 2019, 1, 2, '134.236.248.148', 1, 1546400316), (39, 2019, 1, 2, '171.7.247.5', 1, 1546399000), (40, 2019, 1, 2, '125.25.207.43', 1, 1546403014), (41, 2019, 1, 2, '171.7.246.217', 1, 1546396144), (42, 2019, 1, 2, '1.10.222.61', 1, 1546400370), (43, 2019, 1, 2, '113.53.88.69', 1, 1546403297), (44, 2019, 1, 2, '49.49.161.230', 1, 1546400318), (45, 2019, 1, 2, '1.10.222.91', 1, 1546397611), (46, 2019, 1, 2, '113.53.100.39', 1, 1546405050), (47, 2019, 1, 2, '180.183.168.98', 1, 1546403766), (48, 2019, 1, 2, '49.230.115.174', 1, 1546397816), (49, 2019, 1, 2, '182.52.44.243', 1, 1546401748), (50, 2019, 1, 2, '49.230.115.158', 1, 1546397829), (51, 2019, 1, 2, '113.53.102.241', 1, 1546400008), (52, 2019, 1, 2, '171.7.250.155', 1, 1546397873), (53, 2019, 1, 2, '113.53.66.196', 1, 1546403397), (54, 2019, 1, 2, '49.230.66.108', 1, 1546397915), (55, 2019, 1, 2, '125.25.207.232', 1, 1546400360), (56, 2019, 1, 2, '171.7.251.101', 1, 1546401559), (57, 2019, 1, 2, '182.52.16.92', 1, 1546398554), (58, 2019, 1, 2, '118.173.110.249', 1, 1546398232), (59, 2019, 1, 2, '182.52.16.114', 1, 1546404076), (60, 2019, 1, 2, '113.53.134.122', 1, 1546398619), (61, 2019, 1, 2, '182.232.109.116', 1, 1546398607), (62, 2019, 1, 2, '171.7.251.35', 1, 1546398630), (63, 2019, 1, 2, '113.53.182.15', 1, 1546398754), (64, 2019, 1, 2, '113.53.129.149', 1, 1546399015), (65, 2019, 1, 2, '171.7.246.187', 1, 1546399070), (66, 2019, 1, 2, '182.232.6.240', 1, 1546399233), (67, 2019, 1, 2, '1.10.175.112', 1, 1546400806), (68, 2019, 1, 2, '49.229.79.141', 1, 1546399562), (69, 2019, 1, 2, '171.7.246.56', 1, 1546399681), (70, 2019, 1, 2, '223.204.182.164', 1, 1546399523), (71, 2019, 1, 2, '171.7.250.166', 1, 1546399676), (72, 2019, 1, 2, '125.26.185.38', 1, 1546399378), (73, 2019, 1, 2, '182.52.16.65', 1, 1546399482), (74, 2019, 1, 2, '223.204.42.129', 1, 1546399525), (75, 2019, 1, 2, '101.109.113.81', 1, 1546400369), (76, 2019, 1, 2, '118.173.51.182', 1, 1546403674), (77, 2019, 1, 2, '101.109.113.236', 1, 1546399727), (78, 2019, 1, 2, '1.10.222.182', 1, 1546400987), (79, 2019, 1, 2, '182.52.16.199', 1, 1546404549), (80, 2019, 1, 2, '125.25.207.8', 1, 1546400984), (81, 2019, 1, 2, '171.7.246.181', 1, 1546399940), (82, 2019, 1, 2, '118.175.101.213', 1, 1546400108), (83, 2019, 1, 2, '101.51.106.252', 1, 1546401786), (84, 2019, 1, 2, '171.7.250.248', 1, 1546401121), (85, 2019, 1, 2, '101.109.113.225', 1, 1546400213), (86, 2019, 1, 2, '113.53.4.65', 1, 1546401835), (87, 2019, 1, 2, '113.53.72.190', 1, 1546400454), (88, 2019, 1, 2, '171.7.246.220', 1, 1546400508), (89, 2019, 1, 2, '180.183.170.31', 1, 1546400452), (90, 2019, 1, 2, '182.52.16.117', 1, 1546401393), (91, 2019, 1, 2, '182.52.16.187', 1, 1546404601), (92, 2019, 1, 2, '49.49.163.221', 1, 1546401249), (93, 2019, 1, 2, '171.7.250.168', 1, 1546401364), (94, 2019, 1, 2, '223.24.185.232', 1, 1546400831), (95, 2019, 1, 2, '113.53.130.93', 1, 1546400869), (96, 2019, 1, 2, '171.7.250.140', 1, 1546401905), (97, 2019, 1, 2, '101.51.117.202', 1, 1546402695), (98, 2019, 1, 2, '223.24.158.187', 1, 1546401173), (99, 2019, 1, 2, '113.53.77.71', 1, 1546401423), (100, 2019, 1, 2, '171.7.251.254', 1, 1546401463), (101, 2019, 1, 2, '49.229.148.43', 1, 1546401563), (102, 2019, 1, 2, '113.53.4.16', 1, 1546402082), (103, 2019, 1, 2, '171.7.250.206', 1, 1546401599), (104, 2019, 1, 2, '118.175.212.123', 1, 1546401826), (105, 2019, 1, 2, '69.171.251.9', 1, 1546401646), (106, 2019, 1, 2, '173.252.127.20', 1, 1546401646), (107, 2019, 1, 2, '69.171.251.44', 1, 1546401647), (108, 2019, 1, 2, '69.171.251.20', 1, 1546401647), (109, 2019, 1, 2, '69.171.251.3', 1, 1546401647), (110, 2019, 1, 2, '182.232.244.247', 1, 1546401671), (111, 2019, 1, 2, '134.236.71.8', 1, 1546402483), (112, 2019, 1, 2, '49.49.164.122', 1, 1546401710), (113, 2019, 1, 2, '1.0.214.234', 1, 1546401790), (114, 2019, 1, 2, '171.7.246.47', 1, 1546401763), (115, 2019, 1, 2, '125.25.207.91', 1, 1546404653), (116, 2019, 1, 2, '180.183.168.12', 1, 1546404897), (117, 2019, 1, 2, '182.53.198.156', 1, 1546401871), (118, 2019, 1, 2, '125.24.153.145', 1, 1546402656), (119, 2019, 1, 2, '223.204.43.146', 1, 1546402082), (120, 2019, 1, 2, '1.0.253.137', 1, 1546405424), (121, 2019, 1, 2, '180.183.173.115', 1, 1546402535), (122, 2019, 1, 2, '171.7.250.145', 1, 1546402509), (123, 2019, 1, 2, '171.7.247.56', 1, 1546402492), (124, 2019, 1, 2, '223.24.174.214', 1, 1546402984), (125, 2019, 1, 2, '113.53.128.200', 1, 1546402855), (126, 2019, 1, 2, '182.52.16.121', 1, 1546403055), (127, 2019, 1, 2, '49.229.132.117', 1, 1546403090), (128, 2019, 1, 2, '113.53.7.166', 1, 1546403030), (129, 2019, 1, 2, '113.53.99.233', 1, 1546403144), (130, 2019, 1, 2, '1.20.233.130', 1, 1546403286), (131, 2019, 1, 2, '125.24.153.254', 1, 1546403285), (132, 2019, 1, 2, '171.7.246.64', 1, 1546403776), (133, 2019, 1, 2, '182.52.16.103', 1, 1546404127), (134, 2019, 1, 2, '125.24.49.63', 1, 1546404011), (135, 2019, 1, 2, '171.7.246.100', 1, 1546404485), (136, 2019, 1, 2, '182.52.16.198', 1, 1546404756), (137, 2019, 1, 2, '101.109.113.133', 1, 1546405245), (138, 2019, 1, 2, '171.7.250.17', 1, 1546405428), (139, 2019, 1, 3, '127.0.0.1', 1, 1546502034), (140, 2019, 1, 4, '127.0.0.1', 1, 1546603064), (141, 2019, 1, 5, '127.0.0.1', 1, 1546667940), (142, 2019, 1, 9, '127.0.0.1', 1, 1547022274), (143, 2019, 1, 11, '127.0.0.1', 1, 1547165663), (144, 2019, 1, 14, '127.0.0.1', 1, 1547451552), (145, 2019, 1, 15, '127.0.0.1', 1, 1547556083), (146, 2019, 1, 16, '127.0.0.1', 1, 1547640680), (147, 2019, 1, 17, '127.0.0.1', 1, 1547734435), (148, 2019, 1, 18, '127.0.0.1', 1, 1547819109), (149, 2019, 1, 19, '127.0.0.1', 1, 1547906326), (150, 2019, 1, 21, '127.0.0.1', 1, 1548080729), (151, 2019, 1, 22, '127.0.0.1', 1, 1548170706), (152, 2019, 1, 24, '127.0.0.1', 1, 1548291832), (153, 2019, 1, 25, '127.0.0.1', 1, 1548399707), (154, 2019, 1, 28, '127.0.0.1', 1, 1548654471), (155, 2019, 1, 29, '127.0.0.1', 1, 1548749146), (156, 2019, 2, 1, '127.0.0.1', 1, 1548988152), (157, 2019, 2, 17, '127.0.0.1', 1, 1550372651), (158, 2019, 2, 19, '127.0.0.1', 1, 1550550843), (159, 2019, 2, 20, '127.0.0.1', 1, 1550661772), (160, 2019, 2, 22, '127.0.0.1', 1, 1550826256), (161, 2019, 2, 23, '127.0.0.1', 1, 1550894299), (162, 2019, 2, 25, '127.0.0.1', 1, 1551091518), (163, 2019, 3, 3, '127.0.0.1', 1, 1551606204), (164, 2019, 3, 4, '127.0.0.1', 1, 1551707788), (165, 2019, 3, 7, '127.0.0.1', 1, 1551964359), (166, 2019, 3, 8, '127.0.0.1', 1, 1552005363), (167, 2019, 3, 9, '127.0.0.1', 1, 1552136813), (168, 2019, 3, 10, '127.0.0.1', 1, 1552178068), (169, 2019, 3, 13, '127.0.0.1', 1, 1552482120), (170, 2019, 3, 15, '127.0.0.1', 1, 1552656499), (171, 2019, 3, 17, '127.0.0.1', 1, 1552825496), (172, 2019, 3, 18, '127.0.0.1', 1, 1552889845), (173, 2019, 3, 23, '127.0.0.1', 1, 1553343970), (174, 2019, 3, 30, '127.0.0.1', 1, 1553915465), (175, 2019, 3, 31, '127.0.0.1', 1, 1554035750), (176, 2019, 4, 4, '127.0.0.1', 1, 1554332434), (177, 2019, 4, 24, '127.0.0.1', 1, 1556073556), (178, 2019, 4, 25, '127.0.0.1', 1, 1556166473), (179, 2019, 4, 26, '127.0.0.1', 1, 1556287790), (180, 2019, 4, 28, '127.0.0.1', 1, 1556427969), (181, 2019, 4, 30, '127.0.0.1', 1, 1556623999), (182, 2019, 5, 1, '127.0.0.1', 1, 1556696823), (183, 2019, 5, 3, '127.0.0.1', 1, 1556888529), (184, 2019, 5, 4, '127.0.0.1', 1, 1556979598), (185, 2019, 5, 5, '127.0.0.1', 1, 1557063551), (186, 2019, 5, 6, '127.0.0.1', 1, 1557120588), (187, 2019, 5, 7, '127.0.0.1', 1, 1557237464), (188, 2019, 5, 8, '127.0.0.1', 1, 1557329477), (189, 2019, 5, 9, '127.0.0.1', 1, 1557395949), (190, 2019, 5, 10, '127.0.0.1', 1, 1557493989), (191, 2019, 5, 11, '127.0.0.1', 1, 1557579852), (192, 2019, 5, 12, '127.0.0.1', 1, 1557637672), (193, 2019, 5, 14, '127.0.0.1', 1, 1557842545), (194, 2019, 5, 15, '127.0.0.1', 1, 1557929949), (195, 2019, 5, 16, '127.0.0.1', 1, 1557993615), (196, 2019, 5, 17, '127.0.0.1', 1, 1558096235), (197, 2019, 6, 6, '127.0.0.1', 1, 1559807069), (198, 2019, 6, 8, '127.0.0.1', 1, 1559995596), (199, 2019, 6, 9, '127.0.0.1', 1, 1560049454), (200, 2019, 6, 10, '127.0.0.1', 1, 1560120677), (201, 2019, 6, 11, '127.0.0.1', 1, 1560256960), (202, 2019, 6, 12, '127.0.0.1', 1, 1560354221), (203, 2019, 6, 13, '127.0.0.1', 1, 1560435456), (204, 2019, 6, 14, '127.0.0.1', 1, 1560485616), (205, 2019, 6, 15, '127.0.0.1', 1, 1560611133), (206, 2019, 6, 16, '127.0.0.1', 1, 1560687236), (207, 2019, 6, 16, '171.7.249.202', 1, 1560640321), (208, 2019, 6, 16, '14.207.34.206', 1, 1560669675), (209, 2019, 6, 16, '171.103.5.158', 1, 1560661793), (210, 2019, 6, 16, '147.92.137.133', 1, 1560652186), (211, 2019, 6, 16, '147.92.137.134', 1, 1560652187), (212, 2019, 6, 16, '27.55.64.7', 1, 1560652219), (213, 2019, 6, 16, '171.7.233.208', 1, 1560652274), (214, 2019, 6, 16, '182.232.221.106', 1, 1560653833), (215, 2019, 6, 16, '182.232.224.8', 1, 1560656256), (216, 2019, 6, 16, '64.233.172.74', 1, 1560667951), (217, 2019, 6, 16, '1.46.11.154', 1, 1560669177), (218, 2019, 6, 16, '64.233.173.170', 1, 1560671310), (219, 2019, 6, 16, '64.233.173.174', 1, 1560671297), (220, 2019, 6, 17, '127.0.0.1', 1, 1560722838), (221, 2019, 6, 20, '127.0.0.1', 1, 1561005294), (222, 2019, 6, 21, '127.0.0.1', 1, 1561112279), (223, 2019, 6, 22, '127.0.0.1', 1, 1561178860), (224, 2019, 6, 23, '127.0.0.1', 1, 1561291717), (225, 2019, 7, 2, '127.0.0.1', 1, 1562061379), (226, 2019, 9, 22, '127.0.0.1', 1, 1569140159), (227, 2019, 10, 23, '127.0.0.1', 1, 1571812059), (228, 2019, 10, 24, '127.0.0.1', 1, 1571865144), (229, 2019, 10, 27, '127.0.0.1', 1, 1572158706), (230, 2019, 10, 29, '127.0.0.1', 1, 1572315570), (231, 2019, 10, 31, '171.7.238.166', 1, 1572518113), (232, 2019, 11, 1, '171.7.239.190', 1, 1572560890), (233, 2019, 11, 1, '101.51.106.54', 1, 1572596993), (234, 2019, 11, 4, '171.7.248.253', 1, 1572819608), (235, 2019, 11, 12, '101.51.106.54', 1, 1573533527), (236, 2019, 11, 12, '159.192.218.177', 1, 1573575518), (237, 2019, 11, 15, '101.51.106.54', 1, 1573802124), (238, 2019, 11, 15, '119.76.190.42', 1, 1573799991), (239, 2019, 11, 15, '122.155.35.148', 1, 1573801936), (240, 2019, 11, 15, '64.233.173.119', 1, 1573784821), (241, 2019, 11, 15, '182.232.207.196', 1, 1573784865), (242, 2019, 11, 15, '182.232.212.130', 1, 1573788653), (243, 2019, 11, 15, '182.232.207.77', 1, 1573790628), (244, 2019, 11, 15, '64.233.173.115', 1, 1573790925), (245, 2019, 11, 15, '182.232.207.110', 1, 1573792692), (246, 2019, 11, 15, '182.232.207.175', 1, 1573800092), (247, 2019, 11, 15, '64.233.173.117', 1, 1573800451), (248, 2019, 11, 15, '223.24.160.73', 1, 1573800992), (249, 2019, 11, 15, '1.47.8.80', 1, 1573801159), (250, 2019, 11, 15, '182.232.204.125', 1, 1573801164), (251, 2019, 11, 15, '122.155.38.74', 1, 1573805150), (252, 2019, 11, 15, '182.232.209.37', 1, 1573805040), (253, 2019, 11, 15, '182.232.207.235', 1, 1573805417), (254, 2019, 11, 15, '182.232.213.1', 1, 1573807867), (255, 2019, 11, 15, '182.232.207.133', 1, 1573807828), (256, 2019, 11, 15, '113.53.187.231', 1, 1573811992), (257, 2019, 11, 15, '223.24.152.178', 1, 1573814097), (258, 2019, 11, 15, '171.7.237.163', 1, 1573815988), (259, 2019, 11, 15, '182.232.211.223', 1, 1573829587), (260, 2019, 11, 16, '159.192.218.26', 1, 1573857171), (261, 2019, 11, 16, '101.51.106.54', 1, 1573895899), (262, 2019, 11, 16, '119.76.190.42', 1, 1573890587), (263, 2019, 11, 16, '223.24.160.85', 1, 1573868654), (264, 2019, 11, 16, '122.155.46.15', 1, 1573872507), (265, 2019, 11, 16, '122.155.38.1', 1, 1573873556), (266, 2019, 11, 16, '223.24.190.103', 1, 1573880350), (267, 2019, 11, 16, '1.46.0.132', 1, 1573884105), (268, 2019, 11, 16, '182.232.205.227', 1, 1573884363), (269, 2019, 11, 16, '122.155.35.123', 1, 1573886677), (270, 2019, 11, 16, '122.155.46.177', 1, 1573887888), (271, 2019, 11, 16, '184.22.23.238', 1, 1573894228), (272, 2019, 11, 17, '159.192.220.61', 1, 1573942410), (273, 2019, 11, 17, '171.7.248.52', 1, 1573995845), (274, 2019, 11, 17, '1.46.193.248', 1, 1573963534), (275, 2019, 11, 17, '101.51.106.54', 1, 1573977508), (276, 2019, 11, 17, '64.233.173.119', 1, 1573991105), (277, 2019, 11, 17, '64.233.173.115', 1, 1573992427), (278, 2019, 11, 17, '171.6.247.249', 1, 1573992722), (279, 2019, 11, 18, '171.7.248.242', 1, 1574031670), (280, 2019, 11, 18, '182.232.249.236', 1, 1574044421), (281, 2019, 11, 18, '101.51.106.54', 1, 1574069030), (282, 2019, 11, 18, '64.233.173.117', 1, 1574066602), (283, 2019, 11, 18, '74.125.212.21', 1, 1574068967), (284, 2019, 11, 18, '64.233.173.115', 1, 1574069438), (285, 2019, 11, 18, '182.232.204.227', 1, 1574082802), (286, 2019, 11, 18, '182.232.214.210', 1, 1574084881), (287, 2019, 11, 19, '101.51.106.54', 1, 1574156383), (288, 2019, 11, 19, '64.233.173.119', 1, 1574127599), (289, 2019, 11, 19, '119.76.190.42', 1, 1574146150), (290, 2019, 11, 19, '180.180.155.196', 1, 1574160311), (291, 2019, 11, 19, '1.20.152.57', 1, 1574160511), (292, 2019, 11, 19, '64.233.173.115', 1, 1574161721), (293, 2019, 11, 19, '159.192.216.145', 1, 1574162048), (294, 2019, 11, 19, '182.232.248.14', 1, 1574164741), (295, 2019, 11, 20, '1.46.110.52', 1, 1574222603), (296, 2019, 11, 20, '101.51.106.54', 1, 1574233512), (297, 2019, 11, 20, '1.2.167.68', 1, 1574243645), (298, 2019, 11, 20, '182.232.209.130', 1, 1574252312), (299, 2019, 11, 20, '182.232.203.202', 1, 1574252301), (300, 2019, 11, 20, '182.232.248.248', 1, 1574257624), (301, 2019, 11, 21, '159.192.222.187', 1, 1574287176), (302, 2019, 11, 21, '182.232.211.153', 1, 1574294864), (303, 2019, 11, 21, '101.51.106.54', 1, 1574318595), (304, 2019, 11, 21, '119.76.190.42', 1, 1574303157), (305, 2019, 11, 21, '182.232.206.63', 1, 1574306846), (306, 2019, 11, 21, '182.232.203.82', 1, 1574320905), (307, 2019, 11, 21, '182.232.202.90', 1, 1574328332), (308, 2019, 11, 21, '182.232.203.178', 1, 1574333999), (309, 2019, 11, 21, '182.232.202.110', 1, 1574336868), (310, 2019, 11, 21, '64.233.173.181', 1, 1574350939), (311, 2019, 11, 21, '64.233.173.183', 1, 1574350998), (312, 2019, 11, 21, '64.233.173.179', 1, 1574351048), (313, 2019, 11, 22, '101.51.106.54', 1, 1574404501), (314, 2019, 11, 22, '182.232.201.111', 1, 1574393903), (315, 2019, 11, 22, '64.233.173.181', 1, 1574397173), (316, 2019, 11, 22, '182.232.210.82', 1, 1574413503), (317, 2019, 11, 22, '1.47.133.60', 1, 1574428966), (318, 2019, 11, 23, '171.6.251.120', 1, 1574461967), (319, 2019, 11, 23, '101.51.106.54', 1, 1574483255), (320, 2019, 11, 23, '1.46.137.171', 1, 1574505499), (321, 2019, 11, 24, '223.24.62.94', 1, 1574540284), (322, 2019, 11, 24, '101.51.106.54', 1, 1574564047), (323, 2019, 11, 24, '182.232.202.28', 1, 1574564344), (324, 2019, 11, 24, '182.232.209.206', 1, 1574574406), (325, 2019, 11, 24, '27.55.90.209', 1, 1574577886), (326, 2019, 11, 24, '182.232.211.81', 1, 1574599197), (327, 2019, 11, 25, '101.51.106.54', 1, 1574668793), (328, 2019, 11, 25, '182.232.214.20', 1, 1574666257), (329, 2019, 11, 25, '182.232.203.84', 1, 1574688738), (330, 2019, 11, 25, '64.233.173.181', 1, 1574690848), (331, 2019, 11, 25, '64.233.173.183', 1, 1574690826), (332, 2019, 11, 25, '66.249.82.179', 1, 1574691423), (333, 2019, 11, 25, '66.249.82.181', 1, 1574691271), (334, 2019, 11, 25, '66.249.82.183', 1, 1574691428), (335, 2019, 11, 26, '101.51.106.54', 1, 1574758040), (336, 2019, 11, 26, '66.249.82.179', 1, 1574746764), (337, 2019, 11, 26, '66.249.82.183', 1, 1574746740), (338, 2019, 11, 26, '66.249.82.181', 1, 1574746864), (339, 2019, 11, 26, '64.233.173.181', 1, 1574770806), (340, 2019, 11, 26, '182.232.128.74', 1, 1574772438), (341, 2019, 11, 26, '182.232.135.168', 1, 1574772484), (342, 2019, 11, 26, '180.180.169.31', 1, 1574772622), (343, 2019, 11, 26, '182.232.130.138', 1, 1574774537), (344, 2019, 11, 26, '64.233.173.183', 1, 1574781393), (345, 2019, 11, 26, '182.232.210.222', 1, 1574782160), (346, 2019, 11, 27, '101.51.106.54', 1, 1574841686), (347, 2019, 11, 27, '118.173.141.80', 1, 1574851206), (348, 2019, 11, 27, '66.249.82.179', 1, 1574858390), (349, 2019, 11, 27, '182.232.200.148', 1, 1574863635), (350, 2019, 11, 28, '101.51.106.54', 1, 1574923383), (351, 2019, 11, 28, '64.233.173.179', 1, 1574917338), (352, 2019, 11, 28, '14.207.59.107', 1, 1574923349), (353, 2019, 11, 28, '182.232.248.39', 1, 1574926870), (354, 2019, 11, 28, '182.232.200.118', 1, 1574927786), (355, 2019, 11, 28, '64.233.173.181', 1, 1574928260), (356, 2019, 11, 28, '64.233.173.183', 1, 1574937432), (357, 2019, 11, 28, '182.232.201.185', 1, 1574937911), (358, 2019, 11, 28, '49.230.135.15', 1, 1574941693), (359, 2019, 11, 28, '223.24.164.215', 1, 1574951638), (360, 2019, 11, 29, '101.51.106.54', 1, 1574987879), (361, 2019, 11, 29, '64.233.173.181', 1, 1574990097), (362, 2019, 11, 29, '64.233.173.179', 1, 1574991285), (363, 2019, 11, 29, '64.233.173.183', 1, 1574991269), (364, 2019, 11, 29, '182.232.214.143', 1, 1575010024), (365, 2019, 11, 29, '119.76.190.42', 1, 1575017306), (366, 2019, 11, 29, '66.249.82.179', 1, 1575037625), (367, 2019, 11, 29, '182.232.211.21', 1, 1575037755), (368, 2019, 11, 30, '64.233.173.183', 1, 1575065295), (369, 2019, 11, 30, '64.233.173.181', 1, 1575065329), (370, 2019, 11, 30, '101.51.106.54', 1, 1575076676), (371, 2019, 11, 30, '119.76.190.42', 1, 1575095551), (372, 2019, 11, 30, '113.53.115.213', 1, 1575108830), (373, 2019, 11, 30, '159.192.221.236', 1, 1575114335), (374, 2019, 11, 30, '171.7.238.17', 1, 1575120387), (375, 2019, 12, 1, '171.7.236.46', 1, 1575208362), (376, 2019, 12, 2, '122.155.46.148', 1, 1575261761), (377, 2019, 12, 2, '113.53.113.121', 1, 1575276190), (378, 2019, 12, 2, '171.7.236.54', 1, 1575274652), (379, 2019, 12, 2, '1.47.38.241', 1, 1575253311), (380, 2019, 12, 2, '122.155.47.164', 1, 1575274502), (381, 2019, 12, 3, '1.20.233.164', 1, 1575360180), (382, 2019, 12, 3, '171.7.236.54', 1, 1575360492), (383, 2019, 12, 3, '1.47.38.241', 1, 1575338271), (384, 2019, 12, 3, '125.26.161.139', 1, 1575356688), (385, 2019, 12, 3, '171.7.249.49', 1, 1575376372), (386, 2019, 12, 4, '64.233.173.159', 1, 1575461632), (387, 2019, 12, 4, '66.249.82.122', 1, 1575425735), (388, 2019, 12, 4, '66.249.82.124', 1, 1575425724), (389, 2019, 12, 4, '66.249.82.126', 1, 1575425765), (390, 2019, 12, 4, '171.7.248.103', 1, 1575442825), (391, 2019, 12, 4, '182.232.206.51', 1, 1575450560), (392, 2019, 12, 4, '110.78.32.61', 1, 1575453607), (393, 2019, 12, 4, '182.232.206.208', 1, 1575464225), (394, 2019, 12, 5, '182.232.204.138', 1, 1575505396), (395, 2019, 12, 5, '64.233.173.158', 1, 1575514090), (396, 2019, 12, 5, '1.20.231.179', 1, 1575517583), (397, 2019, 12, 6, '171.7.248.181', 1, 1575617035), (398, 2019, 12, 6, '1.47.138.136', 1, 1575603402), (399, 2019, 12, 6, '64.233.173.158', 1, 1575650584), (400, 2019, 12, 6, '64.233.173.157', 1, 1575606011), (401, 2019, 12, 6, '66.249.79.190', 1, 1575608898), (402, 2019, 12, 6, '113.53.103.114', 1, 1575612726), (403, 2019, 12, 6, '171.7.248.173', 1, 1575616143), (404, 2019, 12, 6, '66.249.79.186', 1, 1575625541), (405, 2019, 12, 6, '66.249.79.188', 1, 1575627518), (406, 2019, 12, 7, '66.249.79.186', 1, 1575651666), (407, 2019, 12, 7, '66.249.79.188', 1, 1575651909), (408, 2019, 12, 7, '66.249.79.190', 1, 1575652549), (409, 2019, 12, 7, '49.230.6.233', 1, 1575689132), (410, 2019, 12, 7, '1.0.161.125', 1, 1575698175), (411, 2019, 12, 7, '223.206.76.47', 1, 1575704096), (412, 2019, 12, 7, '64.233.173.186', 1, 1575710782), (413, 2019, 12, 8, '66.249.79.188', 1, 1575745489), (414, 2019, 12, 8, '64.233.173.190', 1, 1575765595), (415, 2019, 12, 8, '101.51.116.175', 1, 1575773815), (416, 2019, 12, 8, '66.249.71.94', 1, 1575778565), (417, 2019, 12, 8, '66.249.71.90', 1, 1575810596), (418, 2019, 12, 9, '66.249.71.94', 1, 1575829440), (419, 2019, 12, 9, '66.249.71.92', 1, 1575835792), (420, 2019, 12, 9, '66.249.79.188', 1, 1575837031), (421, 2019, 12, 9, '66.249.79.186', 1, 1575837833), (422, 2019, 12, 9, '66.249.71.90', 1, 1575841356), (423, 2019, 12, 9, '171.7.236.228', 1, 1575876853), (424, 2019, 12, 9, '113.53.177.143', 1, 1575869865), (425, 2019, 12, 9, '122.155.46.42', 1, 1575870845), (426, 2019, 12, 9, '14.207.56.251', 1, 1575872226), (427, 2019, 12, 9, '49.230.8.187', 1, 1575874240), (428, 2019, 12, 9, '182.232.51.190', 1, 1575882419), (429, 2019, 12, 9, '122.155.38.146', 1, 1575890915), (430, 2019, 12, 9, '127.0.0.1', 1, 1575897409); -- -------------------------------------------------------- -- -- Table structure for table `web_admin` -- CREATE TABLE IF NOT EXISTS `web_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL DEFAULT '', `password` varchar(50) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `email` varchar(100) NOT NULL DEFAULT '', `level` tinyint(4) NOT NULL DEFAULT '0', `status` int(5) NOT NULL DEFAULT '0', `picture` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`), KEY `username` (`username`), KEY `password` (`password`), KEY `level` (`level`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_admin` -- INSERT INTO `web_admin` (`id`, `username`, `password`, `name`, `email`, `level`, `status`, `picture`) VALUES (1, 'taweerath', '99bce1ea7146d327e083eaa35fd963a8', 'นายทวีรัตน์ เทพนะ', '[email protected]', 1, 2, '1271195595_123.jpg'), (2, '[email protected]', '530e4a65b3e81ed64b93e81aa1193f7b', 'สพป.พัทลุง เขต ๑', '[email protected]', 3, 2, '1417597179_images.jpg'), (8, 'takrearwittayakom', 'e144737252b772ad8d4887f7f521a548', 'ตะเครียะ', '[email protected]', 2, 1, '1546324597_no.gif'); -- -------------------------------------------------------- -- -- Table structure for table `web_approval` -- CREATE TABLE IF NOT EXISTS `web_approval` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `category` varchar(10) NOT NULL DEFAULT '', `topic` varchar(255) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL, `posit` varchar(100) NOT NULL, `person` text NOT NULL, `rachakan` text NOT NULL, `na` text NOT NULL, `date` date NOT NULL, `date1` date NOT NULL, `day3` varchar(20) NOT NULL, `pahana` varchar(50) NOT NULL, `ao` varchar(50) NOT NULL, `money` varchar(20) NOT NULL, `praman` varchar(100) NOT NULL, `ao2` varchar(50) NOT NULL, `tabain` varchar(20) NOT NULL, `cat` varchar(10) NOT NULL, `working` varchar(5) NOT NULL, `comment` varchar(30) NOT NULL, `namecom` varchar(50) NOT NULL, `edit` varchar(5) NOT NULL, `status` varchar(5) NOT NULL, `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, `full_texts` varchar(100) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_approval_comment` -- CREATE TABLE IF NOT EXISTS `web_approval_comment` ( `id` int(7) NOT NULL AUTO_INCREMENT, `approval_id` int(7) NOT NULL DEFAULT '0', `detail` varchar(250) NOT NULL, `comment` varchar(30) NOT NULL, `work` varchar(5) NOT NULL, `laysen1` varchar(5) NOT NULL, `post_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `tkk1_id` (`approval_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_awards` -- CREATE TABLE IF NOT EXISTS `web_awards` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category` int(5) NOT NULL DEFAULT '0', `user_id` varchar(10) NOT NULL, `name` varchar(50) NOT NULL, `school` varchar(100) NOT NULL, `awards` varchar(250) NOT NULL, `degee` varchar(50) NOT NULL, `full_text` varchar(30) NOT NULL, `date` varchar(30) NOT NULL, `post_date` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_awards_category` -- CREATE TABLE IF NOT EXISTS `web_awards_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `level` varchar(100) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_awards_category` -- INSERT INTO `web_awards_category` (`id`, `category_name`, `level`, `sort`) VALUES (1, 'ระดับเครือข่าย', '1', 1), (2, 'ระดับเขต', '1', 2), (3, 'ระดับจังหวัด', '1', 3), (4, 'ระดับภาค', '1', 4), (5, 'ระดับประเทศ', '1', 5); -- -------------------------------------------------------- -- -- Table structure for table `web_calendar` -- CREATE TABLE IF NOT EXISTS `web_calendar` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `room` varchar(50) NOT NULL, `date_event` date NOT NULL DEFAULT '0000-00-00', `timein` varchar(10) NOT NULL, `timeout` varchar(100) NOT NULL, `subject` varchar(255) NOT NULL, `detail` text NOT NULL, `person` varchar(100) NOT NULL, `post_date` int(20) NOT NULL DEFAULT '0', `update_date` int(20) NOT NULL DEFAULT '0', `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `date_event` (`date_event`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_calendars` -- CREATE TABLE IF NOT EXISTS `web_calendars` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `date_event` date NOT NULL DEFAULT '0000-00-00', `work` varchar(5) NOT NULL, `timeout` varchar(100) NOT NULL, `subject` varchar(255) NOT NULL, `detail` text NOT NULL, `person` varchar(5) NOT NULL, `post_date` int(20) NOT NULL DEFAULT '0', `update_date` int(20) NOT NULL DEFAULT '0', `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `date_event` (`date_event`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_course` -- CREATE TABLE IF NOT EXISTS `web_course` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(5) NOT NULL DEFAULT '0', `category` int(5) NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL, `school` varchar(100) NOT NULL, `course` varchar(250) NOT NULL, `sara` varchar(5) NOT NULL, `hour` int(5) NOT NULL DEFAULT '0', `department` varchar(250) NOT NULL, `budget` varchar(50) NOT NULL, `full_text` varchar(50) NOT NULL, `date` varchar(30) NOT NULL, `post_date` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_groups` -- CREATE TABLE IF NOT EXISTS `web_groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` tinytext NOT NULL, `description` text NOT NULL, `news_add` tinyint(4) NOT NULL DEFAULT '0', `news_edit` tinyint(4) NOT NULL DEFAULT '0', `news_del` tinyint(4) NOT NULL DEFAULT '0', `newscat_add` tinyint(4) NOT NULL DEFAULT '0', `newscat_edit` tinyint(4) NOT NULL DEFAULT '0', `newscat_del` tinyint(4) NOT NULL DEFAULT '0', `admin_add` tinyint(4) NOT NULL DEFAULT '0', `admin_edit` tinyint(4) NOT NULL DEFAULT '0', `admin_del` tinyint(4) NOT NULL DEFAULT '0', `group_add` tinyint(4) NOT NULL DEFAULT '0', `group_edit` tinyint(4) NOT NULL DEFAULT '0', `group_del` tinyint(4) NOT NULL DEFAULT '0', `calendar_add` tinyint(4) NOT NULL DEFAULT '0', `calendar_edit` tinyint(4) NOT NULL DEFAULT '0', `calendar_del` tinyint(4) NOT NULL DEFAULT '0', `minepass_edit` tinyint(4) NOT NULL DEFAULT '0', `user_add` tinyint(4) NOT NULL DEFAULT '0', `user_edit` tinyint(4) NOT NULL DEFAULT '0', `user_del` tinyint(4) NOT NULL DEFAULT '0', `usersch_add` tinyint(4) NOT NULL DEFAULT '0', `usersch_edit` tinyint(4) NOT NULL DEFAULT '0', `usersch_del` tinyint(4) NOT NULL DEFAULT '0', `tkk1_add` tinyint(4) NOT NULL DEFAULT '0', `tkk1_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk1_del` tinyint(4) NOT NULL DEFAULT '0', `tkk1_read` tinyint(4) NOT NULL DEFAULT '0', `tkk1_readod2` tinyint(4) NOT NULL DEFAULT '0', `tkk1_readod3` tinyint(4) NOT NULL DEFAULT '0', `tkk1_group` tinyint(4) NOT NULL DEFAULT '0', `tkk1_sent` tinyint(4) NOT NULL DEFAULT '0', `tkk1file_add` tinyint(4) NOT NULL DEFAULT '0', `tkk1file_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk1file_del` tinyint(4) NOT NULL DEFAULT '0', `tkk2_add` tinyint(4) NOT NULL DEFAULT '0', `tkk2_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk2_del` tinyint(4) NOT NULL DEFAULT '0', `tkk2_read` tinyint(4) NOT NULL DEFAULT '0', `tkk3_add` tinyint(4) NOT NULL DEFAULT '0', `tkk3_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk3_del` tinyint(4) NOT NULL DEFAULT '0', `tkk3_read` tinyint(4) NOT NULL DEFAULT '0', `tkk3_group` tinyint(4) NOT NULL DEFAULT '0', `tkk3_area` tinyint(4) NOT NULL DEFAULT '0', `tkk4_add` tinyint(4) NOT NULL DEFAULT '0', `tkk4_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk4_del` tinyint(4) NOT NULL DEFAULT '0', `tkk4_read` tinyint(4) NOT NULL DEFAULT '0', `tkk5_add` tinyint(4) NOT NULL DEFAULT '0', `tkk5_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk5_del` tinyint(4) NOT NULL DEFAULT '0', `tkk6_add` tinyint(4) NOT NULL DEFAULT '0', `tkk6_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk6_del` tinyint(4) NOT NULL DEFAULT '0', `tkk6_read` tinyint(4) NOT NULL DEFAULT '0', `tkk6cat_add` tinyint(4) NOT NULL DEFAULT '0', `tkk6cat_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk6cat_del` tinyint(4) NOT NULL DEFAULT '0', `tkknola_add` tinyint(4) NOT NULL DEFAULT '0', `tkknola_edit` tinyint(4) NOT NULL DEFAULT '0', `tkknola_del` tinyint(4) NOT NULL DEFAULT '0', `tkknola_read` tinyint(4) NOT NULL DEFAULT '0', `numbook_add` tinyint(4) NOT NULL DEFAULT '0', `numbook_edit` tinyint(4) NOT NULL DEFAULT '0', `numbook_del` tinyint(4) NOT NULL DEFAULT '0', `numbook_read` tinyint(4) NOT NULL DEFAULT '0', `number_add` tinyint(4) NOT NULL DEFAULT '0', `number_edit` tinyint(4) NOT NULL DEFAULT '0', `number_del` tinyint(4) NOT NULL DEFAULT '0', `number_read` tinyint(4) NOT NULL DEFAULT '0', `tkk7_add` tinyint(4) NOT NULL DEFAULT '0', `tkk7_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk7_del` tinyint(4) NOT NULL DEFAULT '0', `tkk7_read` tinyint(4) NOT NULL DEFAULT '0', `tkk7_group` tinyint(4) NOT NULL DEFAULT '0', `tkk7_ska2` tinyint(4) NOT NULL DEFAULT '0', `tkk9_add` tinyint(4) NOT NULL DEFAULT '0', `tkk9_edit` tinyint(4) NOT NULL DEFAULT '0', `tkk9_del` tinyint(4) NOT NULL DEFAULT '0', `tkk9_read` tinyint(4) NOT NULL DEFAULT '0', `tkk9_group` tinyint(4) NOT NULL DEFAULT '0', `tkk9_area` tinyint(4) NOT NULL DEFAULT '0', `report_add` tinyint(4) NOT NULL DEFAULT '0', `report_edit` tinyint(4) NOT NULL DEFAULT '0', `report_del` tinyint(4) NOT NULL DEFAULT '0', `report_read` tinyint(4) NOT NULL DEFAULT '0', `reportfile_add` tinyint(4) NOT NULL DEFAULT '0', `reportfile_edit` tinyint(4) NOT NULL DEFAULT '0', `reportcat_add` tinyint(4) NOT NULL, `reportcat_edit` int(4) NOT NULL, `reportcat_del` tinyint(4) NOT NULL, `reportfile_del` tinyint(4) NOT NULL DEFAULT '0', `kamsang_add` tinyint(4) NOT NULL DEFAULT '0', `kamsang_edit` tinyint(4) NOT NULL DEFAULT '0', `kamsang_del` tinyint(4) NOT NULL DEFAULT '0', `kamsang_read` tinyint(4) NOT NULL DEFAULT '0', `kamsang_ska2` tinyint(4) NOT NULL DEFAULT '0', `publish_add` tinyint(4) NOT NULL DEFAULT '0', `publish_edit` tinyint(4) NOT NULL DEFAULT '0', `publish_del` tinyint(4) NOT NULL DEFAULT '0', `page_add` tinyint(4) NOT NULL DEFAULT '0', `page_edit` tinyint(4) NOT NULL DEFAULT '0', `page_del` tinyint(4) NOT NULL DEFAULT '0', `approval_add` tinyint(4) NOT NULL DEFAULT '0', `approval_edit` tinyint(4) NOT NULL DEFAULT '0', `approval_del` tinyint(4) NOT NULL DEFAULT '0', `approval_read` tinyint(4) NOT NULL DEFAULT '0', `radabcat_add` tinyint(4) NOT NULL DEFAULT '0', `radabcat_edit` tinyint(4) NOT NULL DEFAULT '0', `radabcat_del` tinyint(4) NOT NULL DEFAULT '0', `approvalkru_add` tinyint(4) NOT NULL DEFAULT '0', `approvalkru_edit` tinyint(4) NOT NULL DEFAULT '0', `approvalkru_del` tinyint(4) NOT NULL DEFAULT '0', `approvalkru_read` tinyint(4) NOT NULL DEFAULT '0', `workingcat_add` tinyint(4) NOT NULL DEFAULT '0', `workingcat_edit` tinyint(4) NOT NULL DEFAULT '0', `workingcat_del` tinyint(4) NOT NULL DEFAULT '0', `course_add` tinyint(4) NOT NULL DEFAULT '0', `course_edit` tinyint(4) NOT NULL DEFAULT '0', `course_del` tinyint(4) NOT NULL DEFAULT '0', `awards_add` tinyint(4) NOT NULL DEFAULT '0', `awards_edit` tinyint(4) NOT NULL DEFAULT '0', `awards_del` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_groups` -- INSERT INTO `web_groups` (`id`, `name`, `description`, `news_add`, `news_edit`, `news_del`, `newscat_add`, `newscat_edit`, `newscat_del`, `admin_add`, `admin_edit`, `admin_del`, `group_add`, `group_edit`, `group_del`, `calendar_add`, `calendar_edit`, `calendar_del`, `minepass_edit`, `user_add`, `user_edit`, `user_del`, `usersch_add`, `usersch_edit`, `usersch_del`, `tkk1_add`, `tkk1_edit`, `tkk1_del`, `tkk1_read`, `tkk1_readod2`, `tkk1_readod3`, `tkk1_group`, `tkk1_sent`, `tkk1file_add`, `tkk1file_edit`, `tkk1file_del`, `tkk2_add`, `tkk2_edit`, `tkk2_del`, `tkk2_read`, `tkk3_add`, `tkk3_edit`, `tkk3_del`, `tkk3_read`, `tkk3_group`, `tkk3_area`, `tkk4_add`, `tkk4_edit`, `tkk4_del`, `tkk4_read`, `tkk5_add`, `tkk5_edit`, `tkk5_del`, `tkk6_add`, `tkk6_edit`, `tkk6_del`, `tkk6_read`, `tkk6cat_add`, `tkk6cat_edit`, `tkk6cat_del`, `tkknola_add`, `tkknola_edit`, `tkknola_del`, `tkknola_read`, `numbook_add`, `numbook_edit`, `numbook_del`, `numbook_read`, `number_add`, `number_edit`, `number_del`, `number_read`, `tkk7_add`, `tkk7_edit`, `tkk7_del`, `tkk7_read`, `tkk7_group`, `tkk7_ska2`, `tkk9_add`, `tkk9_edit`, `tkk9_del`, `tkk9_read`, `tkk9_group`, `tkk9_area`, `report_add`, `report_edit`, `report_del`, `report_read`, `reportfile_add`, `reportfile_edit`, `reportcat_add`, `reportcat_edit`, `reportcat_del`, `reportfile_del`, `kamsang_add`, `kamsang_edit`, `kamsang_del`, `kamsang_read`, `kamsang_ska2`, `publish_add`, `publish_edit`, `publish_del`, `page_add`, `page_edit`, `page_del`, `approval_add`, `approval_edit`, `approval_del`, `approval_read`, `radabcat_add`, `radabcat_edit`, `radabcat_del`, `approvalkru_add`, `approvalkru_edit`, `approvalkru_del`, `approvalkru_read`, `workingcat_add`, `workingcat_edit`, `workingcat_del`, `course_add`, `course_edit`, `course_del`, `awards_add`, `awards_edit`, `awards_del`) VALUES (1, 'Admin', 'admin', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0), (2, 'ผู้ดูแลระบบ', '2', 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0), (3, 'หน่วยงาน', '3', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0), (4, 'กลุ่มผู้บริหาร', '4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1), (5, 'เจ้าหน้าที่', '5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `web_kamsang` -- CREATE TABLE IF NOT EXISTS `web_kamsang` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) CHARACTER SET ucs2 NOT NULL, `idtabain` varchar(10) NOT NULL, `cate` varchar(5) NOT NULL, `category` varchar(10) NOT NULL DEFAULT '', `topic` varchar(255) NOT NULL DEFAULT '', `date` varchar(30) NOT NULL, `date1` varchar(30) NOT NULL, `kom` varchar(80) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `sangkad` varchar(4) NOT NULL DEFAULT '0', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `full_text` varchar(30) NOT NULL, `full_texts` varchar(30) NOT NULL, `full_textu` varchar(30) NOT NULL, `full_texto` varchar(30) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_meeting` -- CREATE TABLE IF NOT EXISTS `web_meeting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `status` varchar(5) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_meeting` -- INSERT INTO `web_meeting` (`id`, `name`, `status`, `sort`) VALUES (1, 'ห้องพระธรรมเมธาจารย์', '1', 1), (2, 'ห้องโสตทัศนูปกรณ์', '1', 2); -- -------------------------------------------------------- -- -- Table structure for table `web_news` -- CREATE TABLE IF NOT EXISTS `web_news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category` varchar(10) NOT NULL DEFAULT '', `topic` varchar(255) NOT NULL DEFAULT '', `posted` varchar(100) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL DEFAULT '', `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_news_category` -- CREATE TABLE IF NOT EXISTS `web_news_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_news_category` -- INSERT INTO `web_news_category` (`id`, `category_name`, `sort`) VALUES (1, 'ข่าวประชาสัมพันธ์', 1); -- -------------------------------------------------------- -- -- Table structure for table `web_news_comment` -- CREATE TABLE IF NOT EXISTS `web_news_comment` ( `id` int(7) NOT NULL AUTO_INCREMENT, `news_id` int(7) NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', `comment` text NOT NULL, `ip` varchar(50) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `news_id` (`news_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_number` -- CREATE TABLE IF NOT EXISTS `web_number` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `number1` varchar(10) NOT NULL, `number2` varchar(10) NOT NULL, `category` text NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `kom` varchar(30) NOT NULL, `full_text` varchar(100) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_numbook` -- CREATE TABLE IF NOT EXISTS `web_numbook` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `idtabain` varchar(10) NOT NULL, `category` text NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `kom` varchar(30) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `full_text` varchar(30) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_page` -- CREATE TABLE IF NOT EXISTS `web_page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `menuname` varchar(50) NOT NULL, `filename` varchar(50) NOT NULL, `praphet` int(4) NOT NULL DEFAULT '0', `leftmenu` char(1) NOT NULL DEFAULT '1', `sort` int(5) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_page` -- INSERT INTO `web_page` (`id`, `name`, `menuname`, `filename`, `praphet`, `leftmenu`, `sort`) VALUES (1, 'Cute.zip', 'โปรแกรม cute to pdf', '1348030368', 4, '1', 3), (2, 'http://1.179.171.26/myoffice/2561', 'Myoffice 2561', '1546324685', 2, '1', 4), (3, 'http://1.179.171.26/myoffice/2560', 'Myoffice 2560', '1546324691', 2, '1', 5); -- -------------------------------------------------------- -- -- Table structure for table `web_position_category` -- CREATE TABLE IF NOT EXISTS `web_position_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `level` varchar(5) NOT NULL, `school` varchar(5) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=tis620; -- -- Dumping data for table `web_position_category` -- INSERT INTO `web_position_category` (`id`, `category_name`, `level`, `school`, `sort`) VALUES (1, 'ผู้อำนวยการ', '1', '1', 0), (2, 'รองผู้อำนวยการ', '1', '1', 1), (3, 'หัวหน้าฝ่าย', '1', '1', 3), (4, 'ลูกจ้างชั่วคราว', '3', '1', 4), (5, 'ลูกจ้างประจำ', '3', '1', 5), (6, 'ครู', '2', '1', 6), (7, 'ครูผู้ช่วย', '2', '1', 7), (8, 'ครูพี่เลี้ยง', '2', '1', 8), (9, 'ครูอัตราจัาง', '2', '1', 9), (10, 'ครู ช่วยราชการ', '2', '1', 10), (11, 'เจ้าหน้าที่ธุรการ', '3', '1', 11), (12, 'นักการภารโรง', '3', '1', 12), (13, 'ยาม', '3', '1', 13), (14, 'คนสวน', '3', '1', 14), (15, 'แม่บ้าน', '3', '1', 15), (16, 'คนขับรถ', '3', '1', 16), (17, 'วิทยากรภาษาอังกฤษ', '3', '1', 17), (18, 'พนักงานราชการ', '3', '1', 18); -- -------------------------------------------------------- -- -- Table structure for table `web_publish` -- CREATE TABLE IF NOT EXISTS `web_publish` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idpublish` varchar(10) NOT NULL, `year` varchar(10) NOT NULL, `category` varchar(10) NOT NULL DEFAULT '', `tabain` varchar(20) NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `date` date NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `sangkad` varchar(4) NOT NULL DEFAULT '0', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `full_text` varchar(30) NOT NULL, `full_texts` varchar(30) NOT NULL, `full_textu` varchar(30) NOT NULL, `full_texto` varchar(30) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_report` -- CREATE TABLE IF NOT EXISTS `web_report` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(5) NOT NULL, `cat` varchar(30) NOT NULL, `category` text NOT NULL, `topic` varchar(255) NOT NULL, `kom` varchar(50) NOT NULL, `draw` varchar(20) NOT NULL, `date` varchar(100) NOT NULL, `edit` varchar(10) NOT NULL, `posted` varchar(100) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL, `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_report_category` -- CREATE TABLE IF NOT EXISTS `web_report_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `report_id` varchar(5) NOT NULL, `year` varchar(5) NOT NULL, `dmy` varchar(20) NOT NULL, `topic` varchar(100) NOT NULL, `ream` varchar(20) NOT NULL, `post_date` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_reportfile` -- CREATE TABLE IF NOT EXISTS `web_reportfile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `report_id` varchar(10) NOT NULL, `year` varchar(5) NOT NULL, `name` varchar(255) NOT NULL, `posted` varchar(100) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, `rub` int(5) NOT NULL DEFAULT '1', `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_sara_category` -- CREATE TABLE IF NOT EXISTS `web_sara_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `level` varchar(100) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_sara_category` -- INSERT INTO `web_sara_category` (`id`, `category_name`, `level`, `sort`) VALUES (1, 'สนับสนุนการสอน', '1', 1), (2, 'กลุ่มสาระการเรียนรู้ภาษาไทย', '2', 2), (3, 'กลุ่มสาระการเรียนรู้คณิตศาสตร์', '3', 3), (4, 'กลุ่มสาระการเรียนรู้วิทยาศาสตร์', '4', 4), (5, 'กลุ่มสาระการเรียนรู้สังคมศึกษา', '5', 5), (6, 'กลุ่มสาระการเรียนรู้ภาษาต่างประเทศ', '6', 6), (7, 'กลุ่มสาระการเรียนรู้การงานเทคโนโลยี', '7', 7), (8, 'กลุ่มสาระการเรียนรู้สุขศึกษาและพลศึกษา', '8', 8), (9, 'กลุ่มสาระการเรียนรู้ศิลป', '9', 9), (10, 'กิจกกรมพัฒนาผู้เรียน', '10', 10); -- -------------------------------------------------------- -- -- Table structure for table `web_tkk1` -- CREATE TABLE IF NOT EXISTS `web_tkk1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `category` varchar(10) NOT NULL DEFAULT '', `kom` varchar(100) NOT NULL, `num` varchar(150) NOT NULL, `service` varchar(250) NOT NULL, `topic` varchar(255) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `sangkad` varchar(4) NOT NULL DEFAULT '0', `laysen` varchar(10) NOT NULL DEFAULT '0', `comment1` varchar(250) NOT NULL, `comment2` varchar(20) NOT NULL, `comment3` varchar(50) NOT NULL, `comment_b` varchar(20) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `praphet` varchar(5) NOT NULL, `namecom` varchar(50) NOT NULL, `edit` tinyint(5) NOT NULL DEFAULT '0', `rabob` varchar(20) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk1_comment` -- CREATE TABLE IF NOT EXISTS `web_tkk1_comment` ( `id` int(7) NOT NULL AUTO_INCREMENT, `tkk1_id` int(7) NOT NULL DEFAULT '0', `detail` varchar(250) NOT NULL, `comment` text NOT NULL, `comment3` varchar(250) NOT NULL, `work` varchar(10) NOT NULL, `laysen1` varchar(10) NOT NULL, `post_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `tkk1_id` (`tkk1_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk1file` -- CREATE TABLE IF NOT EXISTS `web_tkk1file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tkk1_id` varchar(10) NOT NULL, `name` text NOT NULL, `post_date` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk2` -- CREATE TABLE IF NOT EXISTS `web_tkk2` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `idtabain` varchar(20) NOT NULL, `category` varchar(10) NOT NULL, `praphet` tinyint(4) NOT NULL DEFAULT '0', `tabain` varchar(20) NOT NULL, `date` date NOT NULL, `group_ska` varchar(50) NOT NULL, `school` varchar(100) NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `namecom` varchar(10) NOT NULL, `cat` varchar(5) NOT NULL, `edit` varchar(20) NOT NULL, `sentback` varchar(100) NOT NULL, `posted` varchar(50) NOT NULL, `sangkad` varchar(4) NOT NULL, `status` varchar(5) NOT NULL, `laysen` varchar(10) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, `full_texts` varchar(100) NOT NULL, `full_textu` varchar(100) NOT NULL, `full_texto` varchar(100) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk2_comment` -- CREATE TABLE IF NOT EXISTS `web_tkk2_comment` ( `id` int(7) NOT NULL AUTO_INCREMENT, `tkk2_id` int(7) NOT NULL DEFAULT '0', `edit` varchar(10) NOT NULL, `detail` varchar(250) NOT NULL, `comment` varchar(5) NOT NULL, `work` int(5) NOT NULL, `laysen1` varchar(5) NOT NULL, `ip` varchar(50) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `tkk2_id` (`tkk2_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk3` -- CREATE TABLE IF NOT EXISTS `web_tkk3` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `tkk2_id` varchar(5) NOT NULL, `tkk6_id` varchar(5) NOT NULL, `cat` varchar(5) NOT NULL, `category` text NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `edit` varchar(10) NOT NULL, `view` varchar(5) NOT NULL, `view1` varchar(4) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `sangkad` varchar(4) NOT NULL DEFAULT '0', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `namecom` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, `full_texts` varchar(100) NOT NULL, `full_textu` varchar(100) NOT NULL, `full_texto` varchar(100) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk3_comment` -- CREATE TABLE IF NOT EXISTS `web_tkk3_comment` ( `id` int(7) NOT NULL AUTO_INCREMENT, `tkk3_id` int(7) NOT NULL DEFAULT '0', `catno` varchar(10) NOT NULL, `ip` varchar(50) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `tkk3_id` (`tkk3_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk4` -- CREATE TABLE IF NOT EXISTS `web_tkk4` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `idtabain` int(10) NOT NULL, `category` text NOT NULL, `praphet` tinyint(4) NOT NULL DEFAULT '0', `tabain` varchar(20) NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `tab` varchar(5) NOT NULL, `kom` varchar(50) NOT NULL, `group_ska` varchar(80) NOT NULL, `ska2` varchar(5) NOT NULL, `date` varchar(10) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `sangkad` varchar(4) NOT NULL DEFAULT '0', `cat` varchar(5) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `full_text` varchar(100) NOT NULL, `full_texts` varchar(100) NOT NULL, `full_textu` varchar(100) NOT NULL, `full_texto` varchar(100) NOT NULL, `full_texty` varchar(50) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk5` -- CREATE TABLE IF NOT EXISTS `web_tkk5` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category` varchar(10) NOT NULL DEFAULT '', `topic` text NOT NULL, `headline` varchar(255) NOT NULL DEFAULT '', `posted` varchar(100) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL DEFAULT '', `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk5_category` -- CREATE TABLE IF NOT EXISTS `web_tkk5_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_tkk5_category` -- INSERT INTO `web_tkk5_category` (`id`, `category_name`, `sort`) VALUES (1, 'ข่าวด่วน', 1); -- -------------------------------------------------------- -- -- Table structure for table `web_tkk6` -- CREATE TABLE IF NOT EXISTS `web_tkk6` ( `id` int(11) NOT NULL AUTO_INCREMENT, `yearla` varchar(10) NOT NULL, `category` varchar(10) NOT NULL DEFAULT '', `address` varchar(100) NOT NULL, `date` varchar(30) NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL, `position` varchar(100) NOT NULL, `kom` varchar(80) NOT NULL, `la` varchar(20) NOT NULL, `numpoi` varchar(10) NOT NULL, `date1` varchar(30) NOT NULL, `date2` varchar(30) NOT NULL, `reason` varchar(100) NOT NULL, `tel` varchar(20) NOT NULL, `satanti` varchar(255) NOT NULL, `laysen2` varchar(10) NOT NULL, `cat` varchar(10) NOT NULL, `comment1` varchar(20) NOT NULL, `status` varchar(5) NOT NULL, `fix` tinyint(5) NOT NULL DEFAULT '1', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `namecom` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk6_category` -- CREATE TABLE IF NOT EXISTS `web_tkk6_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `yearla` varchar(10) NOT NULL, `cat` int(11) NOT NULL, `category_name` varchar(255) NOT NULL, `working` varchar(30) NOT NULL, `cumulative` varchar(5) NOT NULL DEFAULT '0', `claim` varchar(5) NOT NULL DEFAULT '0', `update_date` varchar(50) NOT NULL, `post_date` varchar(50) NOT NULL, `sort` varchar(10) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk6_comment` -- CREATE TABLE IF NOT EXISTS `web_tkk6_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tkk6_id` varchar(4) NOT NULL, `work` varchar(5) NOT NULL, `detail` varchar(250) NOT NULL, `laysen1` varchar(30) NOT NULL, `comment1` varchar(10) NOT NULL, `post_date` varchar(30) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk9` -- CREATE TABLE IF NOT EXISTS `web_tkk9` ( `id` int(11) NOT NULL AUTO_INCREMENT, `year` varchar(4) NOT NULL, `cat` varchar(5) NOT NULL, `category` text NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `edit` varchar(10) NOT NULL, `posted` varchar(100) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `namecom` varchar(50) NOT NULL, `full_text` varchar(100) NOT NULL, `full_texts` varchar(100) NOT NULL, `full_textu` varchar(100) NOT NULL, `full_texto` varchar(100) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkk9_comment` -- CREATE TABLE IF NOT EXISTS `web_tkk9_comment` ( `id` int(7) NOT NULL AUTO_INCREMENT, `tkk9_id` int(7) NOT NULL DEFAULT '0', `catno` int(10) NOT NULL, `ip` varchar(50) NOT NULL DEFAULT '', `post_date` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `tkk3_id` (`tkk9_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkknola` -- CREATE TABLE IF NOT EXISTS `web_tkknola` ( `id` int(11) NOT NULL AUTO_INCREMENT, `yearla` varchar(10) NOT NULL, `category` varchar(10) NOT NULL DEFAULT '', `address` varchar(100) NOT NULL, `date` varchar(30) NOT NULL, `topic` varchar(255) NOT NULL DEFAULT '', `name` varchar(50) NOT NULL, `position` varchar(100) NOT NULL, `kom` varchar(80) NOT NULL, `la` varchar(20) NOT NULL, `numpoi` varchar(10) NOT NULL, `date1` varchar(30) NOT NULL, `date2` varchar(30) NOT NULL, `reason` varchar(100) NOT NULL, `date3` varchar(30) NOT NULL, `date4` varchar(30) NOT NULL, `tel` varchar(20) NOT NULL, `laysen2` varchar(10) NOT NULL, `cat` varchar(10) NOT NULL, `edit` varchar(5) NOT NULL, `comment1` varchar(20) NOT NULL, `post_date` varchar(50) NOT NULL, `update_date` varchar(50) NOT NULL DEFAULT '', `enable_comment` tinyint(1) NOT NULL DEFAULT '0', `namecom` varchar(50) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`), KEY `category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_tkknola_comment` -- CREATE TABLE IF NOT EXISTS `web_tkknola_comment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tkknola_id` varchar(4) NOT NULL, `work` varchar(5) NOT NULL, `detail` varchar(250) NOT NULL, `laysen1` varchar(30) NOT NULL, `comment1` varchar(10) NOT NULL, `post_date` varchar(30) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_user` -- CREATE TABLE IF NOT EXISTS `web_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL DEFAULT '', `password` varchar(50) NOT NULL DEFAULT '', `category_name` varchar(255) NOT NULL, `posit` varchar(100) NOT NULL, `work` varchar(100) NOT NULL, `school` varchar(100) NOT NULL, `cotton` varchar(5) NOT NULL, `working` tinyint(4) NOT NULL DEFAULT '0', `workgroup` varchar(5) NOT NULL, `sangkad` varchar(5) NOT NULL, `odgroup` varchar(5) NOT NULL DEFAULT '1', `odsara` varchar(5) NOT NULL, `la` varchar(5) NOT NULL DEFAULT '1', `rad` varchar(5) NOT NULL DEFAULT '1', `odpr` varchar(5) NOT NULL DEFAULT '1', `turakan` varchar(5) NOT NULL DEFAULT '1', `pic` varchar(15) NOT NULL, `level` tinyint(11) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '1', `tel` varchar(20) NOT NULL, `update_date` varchar(50) NOT NULL, `post_date` varchar(50) NOT NULL, `last_date` varchar(50) NOT NULL, `pageview` int(11) NOT NULL DEFAULT '0', `ip` varchar(50) NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`), KEY `username` (`username`), KEY `password` (`password`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_useronline` -- CREATE TABLE IF NOT EXISTS `web_useronline` ( `post_date` varchar(50) NOT NULL, `useronline` varchar(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `web_work_category` -- CREATE TABLE IF NOT EXISTS `web_work_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `level` varchar(100) NOT NULL, `status` varchar(5) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_work_category` -- INSERT INTO `web_work_category` (`id`, `category_name`, `level`, `status`, `sort`) VALUES (1, 'ไม่มี', '1', '4', 1), (2, 'ผู้อำนวยการ', '2', '1', 2), (3, 'รองผู้อำนวยการ', '3', '1', 3), (4, 'หัวหน้ากลุ่ม', '4', '2', 4), (7, 'ธุรการกลุ่ม', '7', '2', 6), (8, 'สารบรรณกลาง', '8', '2', 5), (9, 'เลขานุการ ผอ.', '9', '4', 7), (10, 'เจ้าหน้าที่วันลา', '10', '2', 8), (11, 'จนท.แผนงานและงบประมาณ', '11', '2', 9), (6, 'ครู .เจ้าหน้าที่', '6', '2', 0), (5, 'หัวหน้ากลุ่มสาระ', '5', '2', 5); -- -------------------------------------------------------- -- -- Table structure for table `web_workgroup_category` -- CREATE TABLE IF NOT EXISTS `web_workgroup_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `working_id` int(4) NOT NULL DEFAULT '0', `category_name` varchar(255) NOT NULL DEFAULT '', `status` varchar(5) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_workgroup_category` -- INSERT INTO `web_workgroup_category` (`id`, `working_id`, `category_name`, `status`, `sort`) VALUES (1, 1, 'สนับสนุนการสอน', '2', 1), (2, 5, 'กลุ่มสาระการเรียนรู้สังคมศึกษา', '1', 2), (3, 5, 'กลุ่มสาระการเรียนรู้ภาษาไทย', '1', 3), (4, 5, 'กลุ่มสาระการเรียนรู้วิทยาศาสตร์', '1', 4), (5, 5, 'กลุ่มสาระการเรียนรู้คณิตศาสตร์', '1', 5), (6, 5, 'กลุ่มสาระการเรียนรู้ภาษาต่างประเทศ', '1', 6), (7, 5, 'กลุ่มสาระการเรียนรู้การงานและเทคโนโลยี', '1', 7), (8, 5, 'กลุ่มสาระการเรียนรู้สุขศึกษาและพลศึกษา', '1', 8), (9, 5, 'กลุ่มสาระการเรียนรู้ศิลป', '1', 9), (10, 5, 'กิจกรรมพัฒนาผู้เรียน', '1', 10); -- -------------------------------------------------------- -- -- Table structure for table `web_working_category` -- CREATE TABLE IF NOT EXISTS `web_working_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL DEFAULT '', `level` varchar(100) NOT NULL, `status` varchar(5) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_working_category` -- INSERT INTO `web_working_category` (`id`, `category_name`, `level`, `status`, `sort`) VALUES (1, 'กลุ่มบริหารและสนับสนุน', '1', '2', 1), (2, 'กลุ่มบริหารงานทั่วไป', '2', '1', 2), (3, 'กลุ่มบริหารงานบุคคล', '3', '1', 3), (4, 'กลุ่มบริหารงบประมาน', '4', '1', 4), (5, 'กลุ่มบริหารงานวิชาการ', '5', '1', 5); -- -------------------------------------------------------- -- -- Table structure for table `web_year_category` -- CREATE TABLE IF NOT EXISTS `web_year_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` int(6) NOT NULL, `level` varchar(100) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_year_category` -- INSERT INTO `web_year_category` (`id`, `name`, `level`, `sort`) VALUES (1, 2563, '1', 1); -- -------------------------------------------------------- -- -- Table structure for table `web_yearla_category` -- CREATE TABLE IF NOT EXISTS `web_yearla_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` int(6) NOT NULL, `level` varchar(100) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_yearla_category` -- INSERT INTO `web_yearla_category` (`id`, `name`, `level`, `sort`) VALUES (1, 2563, '1', 1); -- -------------------------------------------------------- -- -- Table structure for table `web_years_category` -- CREATE TABLE IF NOT EXISTS `web_years_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` int(6) NOT NULL, `level` varchar(100) NOT NULL, `sort` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- -- Dumping data for table `web_years_category` -- INSERT INTO `web_years_category` (`id`, `name`, `level`, `sort`) VALUES (1, 2562, '1', 0); /*!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 */;