One Hat Cyber Team
Your IP :
216.73.216.62
Server IP :
122.155.17.190
Server :
Linux cat17190.thaihostserver.com 5.10.0-21-amd64 #1 SMP Debian 5.10.162-1 (2023-01-21) x86_64
Server Software :
Apache/2
PHP Version :
5.6.40
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
neunkho
/
public_html
/
hpp
/
View File Name :
systems_hpp_sriracha (3).sql
-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Apr 12, 2022 at 11:50 AM -- Server version: 10.1.38-MariaDB -- PHP Version: 5.6.40 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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: `systems_hpp_sriracha` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_businessman` -- CREATE TABLE `tbl_businessman` ( `businessman_id` int(50) NOT NULL, `businessman_pic` varchar(100) DEFAULT NULL, `businessman_idcard` varchar(30) NOT NULL, `titlename_name` varchar(100) NOT NULL, `businessman_fname` varchar(100) NOT NULL, `businessman_lname` varchar(100) NOT NULL, `businessman_sex` varchar(2) NOT NULL, `businessman_birthdate` date NOT NULL, `businessman_nationality` varchar(50) NOT NULL, `businessman_address_no` varchar(10) NOT NULL, `businessman_address_moo` varchar(100) DEFAULT NULL, `businessman_address_soi` varchar(100) DEFAULT NULL, `businessman_address_road` varchar(100) DEFAULT NULL, `businessman_address_tambon` varchar(100) NOT NULL, `businessman_address_amphoe` varchar(100) NOT NULL, `businessman_address_province` varchar(100) NOT NULL, `businessman_address_postcode` varchar(10) NOT NULL, `businessman_phone` varchar(100) NOT NULL, `businessman_type_person` int(1) NOT NULL, `businessman_helper_fname` varchar(100) DEFAULT NULL, `businessman_helper_lname` varchar(100) DEFAULT NULL, `businessman_helper_pic` varchar(100) DEFAULT NULL, `date_modify` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_businessman` -- INSERT INTO `tbl_businessman` (`businessman_id`, `businessman_pic`, `businessman_idcard`, `titlename_name`, `businessman_fname`, `businessman_lname`, `businessman_sex`, `businessman_birthdate`, `businessman_nationality`, `businessman_address_no`, `businessman_address_moo`, `businessman_address_soi`, `businessman_address_road`, `businessman_address_tambon`, `businessman_address_amphoe`, `businessman_address_province`, `businessman_address_postcode`, `businessman_phone`, `businessman_type_person`, `businessman_helper_fname`, `businessman_helper_lname`, `businessman_helper_pic`, `date_modify`) VALUES (637, '', '0000000000000', 'นาย', '156', '16', 'F', '0000-00-00', '6126', '16', '161', '61', '6', 'ศรีราชา', 'ศรีราชา', 'ชลบุรี', '20110', '16', 1, '', '', '', '2022-04-05 20:09:38'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_config_institution` -- CREATE TABLE `tbl_config_institution` ( `institution_id` int(2) NOT NULL, `institution_logo` varchar(100) NOT NULL, `institution_name` varchar(200) NOT NULL, `institution_add_no` varchar(10) DEFAULT NULL, `institution_add_moo` varchar(10) DEFAULT NULL, `institution_add_road` varchar(100) DEFAULT NULL, `institution_add_tumbon` varchar(100) DEFAULT NULL, `institution_add_ampur` varchar(100) DEFAULT NULL, `institution_add_province` varchar(100) DEFAULT NULL, `institution_add_postcode` varchar(10) DEFAULT NULL, `institution_add_tel` varchar(100) DEFAULT NULL, `institution_add_fax` varchar(100) DEFAULT NULL, `personnel_fname_01` varchar(100) NOT NULL, `personnel_lname_01` varchar(100) NOT NULL, `personnel_position_01` varchar(100) DEFAULT NULL, `personnel_fname_02` varchar(100) NOT NULL, `personnel_lname_02` varchar(100) NOT NULL, `personnel_position_02` varchar(100) DEFAULT NULL, `personnel_fname_03` varchar(100) NOT NULL, `personnel_lname_03` varchar(100) NOT NULL, `personnel_position_03` varchar(100) DEFAULT NULL, `personnel_fname_04` varchar(100) NOT NULL, `personnel_lname_04` varchar(100) NOT NULL, `personnel_position_04` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_config_institution` -- INSERT INTO `tbl_config_institution` (`institution_id`, `institution_logo`, `institution_name`, `institution_add_no`, `institution_add_moo`, `institution_add_road`, `institution_add_tumbon`, `institution_add_ampur`, `institution_add_province`, `institution_add_postcode`, `institution_add_tel`, `institution_add_fax`, `personnel_fname_01`, `personnel_lname_01`, `personnel_position_01`, `personnel_fname_02`, `personnel_lname_02`, `personnel_position_02`, `personnel_fname_03`, `personnel_lname_03`, `personnel_position_03`, `personnel_fname_04`, `personnel_lname_04`, `personnel_position_04`) VALUES (1, '202204052005048343200.jpg', 'เทศบาลเมืองศรีราชา', '161', '', 'เจิมจอมพล', 'ศรีราชา', 'ศรีราชา', 'ชลบุรี', '20110', '0-3832-7888', '0-3832-7888', 'นายฉัตรชัย', 'ทิมกระจ่าง', '', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '); -- -------------------------------------------------------- -- -- Table structure for table `tbl_config_program` -- CREATE TABLE `tbl_config_program` ( `config_program_id` int(5) NOT NULL, `name_program` varchar(100) NOT NULL, `message_welcome` text NOT NULL, `bg_program` varchar(100) NOT NULL, `version_program` varchar(100) NOT NULL, `text_receipt_except` text NOT NULL, `config_year_cal` varchar(100) NOT NULL, `code_cus` int(5) NOT NULL, `data_map` varchar(300) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_config_program` -- INSERT INTO `tbl_config_program` (`config_program_id`, `name_program`, `message_welcome`, `bg_program`, `version_program`, `text_receipt_except`, `config_year_cal`, `code_cus`, `data_map`) VALUES (1, 'ระบบบริหารจัดการออกใบอนุญาต<br>หนังสือรับรองการแจ้งตามพระราชบัญญัติการสาธารณสุข พ.ศ.2535', '<font color=\"#ffffff\"><b>ยินดีต้อนรับเข้าสู่ โปรแกรมออกใบอนุญาตตาม พ.ร.บ.การสาธารณสุข พ.ศ.2535</b></font>', '202204100924212997437.jpg', '2.0', 'ยกเว้นค่าธรรมนียมตามกฏกระทรวง', '1900:2030', 76, '13.1626114,100.9219584'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_data_application` -- CREATE TABLE `tbl_data_application` ( `data_application_id` int(100) NOT NULL, `data_application_old_id` int(100) DEFAULT NULL, `data_license_old_id` int(100) DEFAULT NULL, `data_application_no` varchar(10) DEFAULT NULL, `data_application_year` varchar(10) DEFAULT NULL, `type_document_id` int(10) NOT NULL, `application_type` int(1) NOT NULL COMMENT '1=คำขอรับ,2=คำขอต่อ', `businessman_id` int(50) NOT NULL, `application_creation_date` date NOT NULL, `data_business_title` varchar(100) DEFAULT NULL, `data_business_type` varchar(100) DEFAULT NULL, `data_business_address_no` varchar(100) DEFAULT NULL, `data_business_address_moo` varchar(100) DEFAULT NULL, `data_business_address_soi` varchar(100) DEFAULT NULL, `data_business_address_road` varchar(100) DEFAULT NULL, `data_business_address_tumbon` varchar(100) DEFAULT NULL, `data_business_address_amper` varchar(100) DEFAULT NULL, `data_business_address_province` varchar(100) DEFAULT NULL, `data_business_address_postcode` varchar(100) DEFAULT NULL, `data_business_address_tel` varchar(100) DEFAULT NULL, `data_business_address_fax` varchar(100) DEFAULT NULL, `data_business_area` varchar(100) DEFAULT NULL, `data_business_other1` text, `data_business_other2` text, `data_business_other3` text, `data_business_other4` text, `data_business_other5` text, `data_business_other6` text, `data_business_other7` text, `data_business_map` varchar(100) NOT NULL, `data_business_fee` int(10) NOT NULL, `doc_attachments_1` varchar(100) DEFAULT NULL, `doc_attachments_1_text` varchar(100) DEFAULT NULL, `doc_attachments_2` varchar(100) DEFAULT NULL, `doc_attachments_2_text` varchar(100) DEFAULT NULL, `doc_attachments_3` varchar(100) DEFAULT NULL, `doc_attachments_3_text` varchar(100) DEFAULT NULL, `doc_attachments_4` varchar(100) DEFAULT NULL, `doc_attachments_4_text` varchar(100) DEFAULT NULL, `doc_attachments_5` varchar(100) DEFAULT NULL, `doc_attachments_5_text` varchar(100) DEFAULT NULL, `doc_attachments_6` varchar(100) DEFAULT NULL, `doc_attachments_6_text` varchar(100) DEFAULT NULL, `member_id` int(10) NOT NULL, `date_modify` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_data_application` -- INSERT INTO `tbl_data_application` (`data_application_id`, `data_application_old_id`, `data_license_old_id`, `data_application_no`, `data_application_year`, `type_document_id`, `application_type`, `businessman_id`, `application_creation_date`, `data_business_title`, `data_business_type`, `data_business_address_no`, `data_business_address_moo`, `data_business_address_soi`, `data_business_address_road`, `data_business_address_tumbon`, `data_business_address_amper`, `data_business_address_province`, `data_business_address_postcode`, `data_business_address_tel`, `data_business_address_fax`, `data_business_area`, `data_business_other1`, `data_business_other2`, `data_business_other3`, `data_business_other4`, `data_business_other5`, `data_business_other6`, `data_business_other7`, `data_business_map`, `data_business_fee`, `doc_attachments_1`, `doc_attachments_1_text`, `doc_attachments_2`, `doc_attachments_2_text`, `doc_attachments_3`, `doc_attachments_3_text`, `doc_attachments_4`, `doc_attachments_4_text`, `doc_attachments_5`, `doc_attachments_5_text`, `doc_attachments_6`, `doc_attachments_6_text`, `member_id`, `date_modify`) VALUES (1, 0, 0, '1/65', '222', 1, 1, 637, '2022-04-05', '62', '32626', '262', '2', '62', '62', '62', '626', 'กรุงเทพมหานคร', '230632', '63', '', '626', '26', '26', '', '', '', '', '', '', 20, '', '', '', '', '', '|', '', '', '', '', NULL, NULL, 1, '2022-04-05 20:18:01'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_data_corporation` -- CREATE TABLE `tbl_data_corporation` ( `corporation_id` int(50) NOT NULL, `businessman_id` int(50) NOT NULL, `corporation_name` varchar(200) NOT NULL, `corporation_type` varchar(100) NOT NULL, `corporation_registered_date` date NOT NULL, `corporation_age` varchar(10) NOT NULL, `corporation_address_no` varchar(10) NOT NULL, `corporation_address_moo` varchar(5) DEFAULT NULL, `corporation_address_soi` varchar(100) DEFAULT NULL, `corporation_address_road` varchar(100) DEFAULT NULL, `corporation_address_tambon` varchar(100) NOT NULL, `corporation_address_amphoe` varchar(100) NOT NULL, `corporation_address_province` varchar(100) NOT NULL, `corporation_address_phone` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tbl_data_license` -- CREATE TABLE `tbl_data_license` ( `data_license_id` int(100) NOT NULL, `data_application_id` int(100) NOT NULL, `data_license_nobook` varchar(100) NOT NULL, `data_license_numbook` varchar(100) DEFAULT NULL, `data_license_yearbook` varchar(10) NOT NULL, `data_license_receipt_type` int(1) DEFAULT NULL COMMENT '0=ปกติ,1=ยกเว้นค่าธรรมเนียม', `data_license_receipt_text` text, `data_license_receipt_no` varchar(5) DEFAULT NULL, `data_license_receipt_num` varchar(30) DEFAULT NULL, `data_license_receipt_date` date DEFAULT NULL, `data_license_other1` text, `data_license_other2` text, `data_license_date_start` date DEFAULT NULL, `data_license_date_effectual` date DEFAULT NULL, `data_license_date_end` date DEFAULT NULL, `member_id` int(10) NOT NULL, `date_modify` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tbl_data_receipt` -- CREATE TABLE `tbl_data_receipt` ( `data_receipt_id` int(100) NOT NULL, `data_application_id` int(100) DEFAULT NULL, `data_yearly` varchar(10) DEFAULT NULL, `data_license_receipt_num` varchar(30) DEFAULT NULL, `data_license_receipt_date` date DEFAULT NULL, `amount` int(10) DEFAULT NULL, `data_memo` text, `data_memo_pay` text ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tbl_log_login` -- CREATE TABLE `tbl_log_login` ( `log_login_id` int(10) NOT NULL, `member_id` int(10) NOT NULL, `date_login` datetime NOT NULL, `ip_address_client` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_log_login` -- INSERT INTO `tbl_log_login` (`log_login_id`, `member_id`, `date_login`, `ip_address_client`) VALUES (1, 1, '2022-04-06 01:01:26', '::1'), (2, 1, '2022-04-08 05:05:29', '::1'), (3, 3, '2022-04-08 05:49:23', '::1'), (4, 1, '2022-04-08 05:49:29', '::1'), (5, 1, '2022-04-08 05:49:46', '::1'), (6, 1, '2022-04-08 05:50:00', '::1'), (7, 1, '2022-04-08 05:53:25', '::1'), (8, 1, '2022-04-08 05:53:52', '::1'), (9, 1, '2022-04-08 05:53:55', '::1'), (10, 1, '2022-04-08 05:54:03', '::1'), (11, 1, '2022-04-08 05:54:23', '::1'), (12, 1, '2022-04-08 05:55:21', '::1'), (13, 1, '2022-04-08 05:57:00', '::1'), (14, 1, '2022-04-08 05:57:25', '::1'), (15, 1, '2022-04-08 05:57:37', '::1'), (16, 1, '2022-04-08 05:58:48', '::1'), (17, 1, '2022-04-08 05:58:52', '::1'), (18, 1, '2022-04-08 05:59:34', '::1'), (19, 1, '2022-04-08 05:59:44', '::1'), (20, 1, '2022-04-08 06:01:38', '192.168.1.35'), (21, 1, '2022-04-08 06:02:25', '192.168.1.101'), (22, 1, '2022-04-08 06:02:57', '192.168.1.101'), (23, 1, '2022-04-08 06:04:22', '192.168.1.101'), (24, 1, '2022-04-08 06:04:46', '192.168.1.35'), (25, 1, '2022-04-08 08:17:53', '192.168.1.250'), (26, 1, '2022-04-09 17:24:27', '192.168.1.35'), (27, 1, '2022-04-10 09:31:47', '::1'), (28, 1, '2022-04-10 09:36:39', '::1'), (29, 1, '2022-04-10 12:18:49', '::1'), (30, 1, '2022-04-10 12:32:18', '192.168.1.35'), (31, 1, '2022-04-10 14:38:55', '192.168.1.35'), (32, 1, '2022-04-10 14:41:18', '192.168.1.35'), (33, 1, '2022-04-11 05:54:05', '::1'), (34, 1, '2022-04-11 06:41:54', '192.168.1.35'), (35, 1, '2022-04-11 10:11:36', '192.168.1.35'), (36, 1, '2022-04-11 10:13:42', '::1'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_member` -- CREATE TABLE `tbl_member` ( `member_id` int(10) NOT NULL, `member_firstname` varchar(50) NOT NULL, `member_lastname` varchar(50) NOT NULL, `member_position` varchar(100) NOT NULL, `member_username` varchar(50) NOT NULL, `member_password` varchar(100) NOT NULL, `member_img` varchar(100) DEFAULT NULL, `member_phone` varchar(30) DEFAULT NULL, `member_email` varchar(50) DEFAULT NULL, `member_level` int(5) NOT NULL, `date_last_login` datetime NOT NULL, `date_insert` datetime NOT NULL, `login_status` int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_member` -- INSERT INTO `tbl_member` (`member_id`, `member_firstname`, `member_lastname`, `member_position`, `member_username`, `member_password`, `member_img`, `member_phone`, `member_email`, `member_level`, `date_last_login`, `date_insert`, `login_status`) VALUES (1, 'อมร', 'สุระกำแหง', 'SuperAdmin', 'sadmin', '81dc9bdb52d04dc20036dbd8313ed055', '', ' ', ' ', 1, '2022-04-11 10:13:42', '0000-00-00 00:00:00', 1), (2, 'Administrator', ' ', 'Administrator', 'admin', 'c2ae6222036ca9794d207b60b681069c', NULL, ' ', ' ', 2, '0000-00-00 00:00:00', '2022-04-11 01:37:18', 1); -- -------------------------------------------------------- -- -- Table structure for table `tbl_provinces` -- CREATE TABLE `tbl_provinces` ( `id` int(5) NOT NULL, `code` varchar(2) COLLATE utf8_unicode_ci NOT NULL, `name_th` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `name_en` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `geography_id` int(5) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `tbl_provinces` -- INSERT INTO `tbl_provinces` (`id`, `code`, `name_th`, `name_en`, `geography_id`) VALUES (1, '10', 'กรุงเทพมหานคร', 'Bangkok', 2), (2, '11', 'สมุทรปราการ', 'Samut Prakan', 2), (3, '12', 'นนทบุรี', 'Nonthaburi', 2), (4, '13', 'ปทุมธานี', 'Pathum Thani', 2), (5, '14', 'พระนครศรีอยุธยา', 'Phra Nakhon Si Ayutthaya', 2), (6, '15', 'อ่างทอง', 'Ang Thong', 2), (7, '16', 'ลพบุรี', 'Loburi', 2), (8, '17', 'สิงห์บุรี', 'Sing Buri', 2), (9, '18', 'ชัยนาท', 'Chai Nat', 2), (10, '19', 'สระบุรี', 'Saraburi', 2), (11, '20', 'ชลบุรี', 'Chon Buri', 5), (12, '21', 'ระยอง', 'Rayong', 5), (13, '22', 'จันทบุรี', 'Chanthaburi', 5), (14, '23', 'ตราด', 'Trat', 5), (15, '24', 'ฉะเชิงเทรา', 'Chachoengsao', 5), (16, '25', 'ปราจีนบุรี', 'Prachin Buri', 5), (17, '26', 'นครนายก', 'Nakhon Nayok', 2), (18, '27', 'สระแก้ว', 'Sa Kaeo', 5), (19, '30', 'นครราชสีมา', 'Nakhon Ratchasima', 3), (20, '31', 'บุรีรัมย์', 'Buri Ram', 3), (21, '32', 'สุรินทร์', 'Surin', 3), (22, '33', 'ศรีสะเกษ', 'Si Sa Ket', 3), (23, '34', 'อุบลราชธานี', 'Ubon Ratchathani', 3), (24, '35', 'ยโสธร', 'Yasothon', 3), (25, '36', 'ชัยภูมิ', 'Chaiyaphum', 3), (26, '37', 'อำนาจเจริญ', 'Amnat Charoen', 3), (27, '39', 'หนองบัวลำภู', 'Nong Bua Lam Phu', 3), (28, '40', 'ขอนแก่น', 'Khon Kaen', 3), (29, '41', 'อุดรธานี', 'Udon Thani', 3), (30, '42', 'เลย', 'Loei', 3), (31, '43', 'หนองคาย', 'Nong Khai', 3), (32, '44', 'มหาสารคาม', 'Maha Sarakham', 3), (33, '45', 'ร้อยเอ็ด', 'Roi Et', 3), (34, '46', 'กาฬสินธุ์', 'Kalasin', 3), (35, '47', 'สกลนคร', 'Sakon Nakhon', 3), (36, '48', 'นครพนม', 'Nakhon Phanom', 3), (37, '49', 'มุกดาหาร', 'Mukdahan', 3), (38, '50', 'เชียงใหม่', 'Chiang Mai', 1), (39, '51', 'ลำพูน', 'Lamphun', 1), (40, '52', 'ลำปาง', 'Lampang', 1), (41, '53', 'อุตรดิตถ์', 'Uttaradit', 1), (42, '54', 'แพร่', 'Phrae', 1), (43, '55', 'น่าน', 'Nan', 1), (44, '56', 'พะเยา', 'Phayao', 1), (45, '57', 'เชียงราย', 'Chiang Rai', 1), (46, '58', 'แม่ฮ่องสอน', 'Mae Hong Son', 1), (47, '60', 'นครสวรรค์', 'Nakhon Sawan', 2), (48, '61', 'อุทัยธานี', 'Uthai Thani', 2), (49, '62', 'กำแพงเพชร', 'Kamphaeng Phet', 2), (50, '63', 'ตาก', 'Tak', 4), (51, '64', 'สุโขทัย', 'Sukhothai', 2), (52, '65', 'พิษณุโลก', 'Phitsanulok', 2), (53, '66', 'พิจิตร', 'Phichit', 2), (54, '67', 'เพชรบูรณ์', 'Phetchabun', 2), (55, '70', 'ราชบุรี', 'Ratchaburi', 4), (56, '71', 'กาญจนบุรี', 'Kanchanaburi', 4), (57, '72', 'สุพรรณบุรี', 'Suphan Buri', 2), (58, '73', 'นครปฐม', 'Nakhon Pathom', 2), (59, '74', 'สมุทรสาคร', 'Samut Sakhon', 2), (60, '75', 'สมุทรสงคราม', 'Samut Songkhram', 2), (61, '76', 'เพชรบุรี', 'Phetchaburi', 4), (62, '77', 'ประจวบคีรีขันธ์', 'Prachuap Khiri Khan', 4), (63, '80', 'นครศรีธรรมราช', 'Nakhon Si Thammarat', 6), (64, '81', 'กระบี่', 'Krabi', 6), (65, '82', 'พังงา', 'Phangnga', 6), (66, '83', 'ภูเก็ต', 'Phuket', 6), (67, '84', 'สุราษฎร์ธานี', 'Surat Thani', 6), (68, '85', 'ระนอง', 'Ranong', 6), (69, '86', 'ชุมพร', 'Chumphon', 6), (70, '90', 'สงขลา', 'Songkhla', 6), (71, '91', 'สตูล', 'Satun', 6), (72, '92', 'ตรัง', 'Trang', 6), (73, '93', 'พัทลุง', 'Phatthalung', 6), (74, '94', 'ปัตตานี', 'Pattani', 6), (75, '95', 'ยะลา', 'Yala', 6), (76, '96', 'นราธิวาส', 'Narathiwat', 6), (77, '97', 'บึงกาฬ', 'buogkan', 3); -- -------------------------------------------------------- -- -- Table structure for table `tbl_road` -- CREATE TABLE `tbl_road` ( `road_id` int(10) NOT NULL, `road_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tbl_soi` -- CREATE TABLE `tbl_soi` ( `soi_id` int(10) NOT NULL, `soi_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tbl_status` -- CREATE TABLE `tbl_status` ( `status_id` int(10) NOT NULL, `status_name` varchar(100) NOT NULL, `status_color` varchar(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_status` -- INSERT INTO `tbl_status` (`status_id`, `status_name`, `status_color`) VALUES (1, 'ปกติ', '#0031FF'), (2, 'ยกเลิก', '#F50000'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_title_name` -- CREATE TABLE `tbl_title_name` ( `titlename_id` int(10) NOT NULL, `titlename_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_title_name` -- INSERT INTO `tbl_title_name` (`titlename_id`, `titlename_name`) VALUES (1, 'นาย'), (2, 'นางสาว'), (3, 'นาง'), (4, ' '); -- -------------------------------------------------------- -- -- Table structure for table `tbl_type_application` -- CREATE TABLE `tbl_type_application` ( `type_application_id` int(5) NOT NULL, `type_application_name` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_type_application` -- INSERT INTO `tbl_type_application` (`type_application_id`, `type_application_name`) VALUES (1, 'ผู้ประกอบการรายใหม่'), (2, 'ต่ออายุใบอนุญาต'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_type_document` -- CREATE TABLE `tbl_type_document` ( `type_document_id` int(10) NOT NULL, `type_document_title` varchar(100) NOT NULL, `type_document_name` varchar(100) NOT NULL, `type_document_style` int(1) NOT NULL COMMENT '1=ใบอนุญาต,2=หนังสือรับรอง,3=เอกสารอื่นๆ', `type_document_code` varchar(100) NOT NULL, `type_document_application` int(1) NOT NULL, `type_appication_print` int(1) NOT NULL, `type_license_print` int(1) NOT NULL, `type_document_status` int(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_type_document` -- INSERT INTO `tbl_type_document` (`type_document_id`, `type_document_title`, `type_document_name`, `type_document_style`, `type_document_code`, `type_document_application`, `type_appication_print`, `type_license_print`, `type_document_status`) VALUES (1, 'กิจการที่เป็นอันตรายต่อสุขภาพ', 'ใบอนุญาตประกอบกิจการที่เป็นอันตรายต่อสุขภาพ', 1, 'LicenseDangerToHealth', 1, 1, 1, 1), (2, 'จำหน่ายสินค้าในที่หรือทางสาธารณะ', 'ใบอนุญาตจำหน่ายสินค้าในที่หรือทางสาธารณะ', 1, 'LicensePublicWay', 1, 1, 4, 1), (3, 'ตลาดเอกชน', 'ใบอนุญาตให้ใช้สถานที่เป็นตลาดเอกชน', 1, 'LicenseMarket', 1, 1, 5, 1), (4, 'รับทำการเก็บขนสิ่งปฏิกูลหรือมูลฝอย', 'ใบอนุญาตรับทำการเก็บขนสิ่งปฏิกูลหรือมูลฝอย', 1, 'LicenseSewage', 1, 1, 16, 1), (5, 'จัดตั้งสถานที่จำหน่ายอาหาร', 'ใบอนุญาตจัดตั้งสถานที่จำหน่ายอาหาร', 1, 'LicenseFoodPlace', 1, 1, 2, 1), (6, 'จัดตั้งสถานที่สะสมอาหาร', 'ใบอนุญาตจัดตั้งสถานที่สะสมอาหาร', 1, 'LicenseFoodCollection', 1, 1, 3, 1), (7, 'จัดตั้งสถานที่จำหน่ายอาหาร', 'หนังสือรับรองการแจ้งจัดตั้งสถานที่จำหน่ายอาหาร', 2, 'CertificateFoodPlace', 1, 2, 7, 1), (8, 'จัดตั้งสถานที่สะสมอาหาร', 'หนังสือรับรองการแจ้งจัดตั้งสถานที่สะสมอาหาร', 2, 'CertificateFoodCollection', 1, 2, 8, 1), (9, 'คำร้องดูดสิ่งปฏิกูล ทั้งในและนอกเขต', 'คำร้องดูดสิ่งปฏิกูล', 4, 'PetitionSucking', 0, 2, 0, 0), (10, 'คำร้องขอรับบริการรถสุขาเคลื่อนที่', 'คำร้องขอรับบริการรถสุขาเคลื่อนที่', 4, 'PetitionMobileToilet', 0, 6, 0, 0), (11, 'คำร้องขอรับบริการรถดูดลอกท่อระบายน้ำ', 'คำร้องลอกท่อระบายน้ำ', 4, 'PetitionDrainPipe', 0, 5, 0, 0), (12, 'คำร้องเหตุรำคาญ', 'คำร้องเหตุรำคาญ', 4, 'PetitionAnnoyance', 0, 0, 0, 0), (13, 'หนังสือฯกรณียังไม่มีใบอนุญาตหรือหนังสือรับรองฯ', 'หนังสือแจ้งเตือนกรณียังไม่มีใบอนุญาตหรือหนังสือรับรองการแจ้ง', 4, 'PetitionBookAlretNoLicense', 0, 11, 0, 0), (14, 'หนังสือฯกรณีใบอนุญาตยังไม่หมดอายุ', 'หนังสือแจ้งเตือนกรณีใบอนุญาตยังไม่หมดอายุ', 4, 'PetitionBookAlretLicenseBefore', 0, 14, 0, 0), (15, 'หนังสือฯกรณีใบอนุญาตหมดอายุ', 'หนังสือแจ้งเตือนกรณีใบอนุญาตหมดอายุ', 4, 'PetitionBookAlretLicenseOut', 0, 15, 0, 0), (16, 'หนังสือคำสั่งให้หยุดดำเนินการ', 'หนังสือคำสั่งให้หยุดดำเนินการ', 4, 'PetitionBookAlretStop', 0, 11, 0, 0), (17, 'คำร้องต่างๆ', 'คำร้องต่างๆ', 4, 'PetitionRequests', 0, 16, 0, 0), (66, 'จัดตั้งสุสานหรือฌาปนสถาน', 'ใบอนุญาตจัดตั้งสุสานและฌาปณสถาน', 4, 'LicenseTomb', 3, 3, 6, 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_type_member` -- CREATE TABLE `tbl_type_member` ( `id_type_member` int(5) NOT NULL, `name_type_member` varchar(100) NOT NULL, `color_type_member` varchar(30) NOT NULL, `permission` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tbl_type_member` -- INSERT INTO `tbl_type_member` (`id_type_member`, `name_type_member`, `color_type_member`, `permission`) VALUES (1, 'ผู้ดูแลระบบระดับสูง', '#0000cc', ''), (2, 'ผู้ดูแลระบบ', '#339900', ''), (3, 'เจ้าหน้าที่', '#ff9900', ''); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_businessman` -- ALTER TABLE `tbl_businessman` ADD PRIMARY KEY (`businessman_id`); -- -- Indexes for table `tbl_config_institution` -- ALTER TABLE `tbl_config_institution` ADD PRIMARY KEY (`institution_id`); -- -- Indexes for table `tbl_config_program` -- ALTER TABLE `tbl_config_program` ADD PRIMARY KEY (`config_program_id`); -- -- Indexes for table `tbl_data_application` -- ALTER TABLE `tbl_data_application` ADD PRIMARY KEY (`data_application_id`); -- -- Indexes for table `tbl_data_corporation` -- ALTER TABLE `tbl_data_corporation` ADD PRIMARY KEY (`corporation_id`); -- -- Indexes for table `tbl_data_license` -- ALTER TABLE `tbl_data_license` ADD PRIMARY KEY (`data_license_id`); -- -- Indexes for table `tbl_data_receipt` -- ALTER TABLE `tbl_data_receipt` ADD PRIMARY KEY (`data_receipt_id`); -- -- Indexes for table `tbl_log_login` -- ALTER TABLE `tbl_log_login` ADD PRIMARY KEY (`log_login_id`); -- -- Indexes for table `tbl_member` -- ALTER TABLE `tbl_member` ADD PRIMARY KEY (`member_id`); -- -- Indexes for table `tbl_provinces` -- ALTER TABLE `tbl_provinces` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_road` -- ALTER TABLE `tbl_road` ADD PRIMARY KEY (`road_id`); -- -- Indexes for table `tbl_soi` -- ALTER TABLE `tbl_soi` ADD PRIMARY KEY (`soi_id`); -- -- Indexes for table `tbl_status` -- ALTER TABLE `tbl_status` ADD PRIMARY KEY (`status_id`); -- -- Indexes for table `tbl_title_name` -- ALTER TABLE `tbl_title_name` ADD PRIMARY KEY (`titlename_id`); -- -- Indexes for table `tbl_type_application` -- ALTER TABLE `tbl_type_application` ADD PRIMARY KEY (`type_application_id`); -- -- Indexes for table `tbl_type_document` -- ALTER TABLE `tbl_type_document` ADD PRIMARY KEY (`type_document_id`); -- -- Indexes for table `tbl_type_member` -- ALTER TABLE `tbl_type_member` ADD PRIMARY KEY (`id_type_member`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_businessman` -- ALTER TABLE `tbl_businessman` MODIFY `businessman_id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=641; -- -- AUTO_INCREMENT for table `tbl_config_institution` -- ALTER TABLE `tbl_config_institution` MODIFY `institution_id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_config_program` -- ALTER TABLE `tbl_config_program` MODIFY `config_program_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_data_application` -- ALTER TABLE `tbl_data_application` MODIFY `data_application_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_data_corporation` -- ALTER TABLE `tbl_data_corporation` MODIFY `corporation_id` int(50) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_data_license` -- ALTER TABLE `tbl_data_license` MODIFY `data_license_id` int(100) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_data_receipt` -- ALTER TABLE `tbl_data_receipt` MODIFY `data_receipt_id` int(100) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_log_login` -- ALTER TABLE `tbl_log_login` MODIFY `log_login_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `tbl_member` -- ALTER TABLE `tbl_member` MODIFY `member_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `tbl_road` -- ALTER TABLE `tbl_road` MODIFY `road_id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_soi` -- ALTER TABLE `tbl_soi` MODIFY `soi_id` int(10) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_status` -- ALTER TABLE `tbl_status` MODIFY `status_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_title_name` -- ALTER TABLE `tbl_title_name` MODIFY `titlename_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `tbl_type_application` -- ALTER TABLE `tbl_type_application` MODIFY `type_application_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_type_document` -- ALTER TABLE `tbl_type_document` MODIFY `type_document_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67; -- -- AUTO_INCREMENT for table `tbl_type_member` -- ALTER TABLE `tbl_type_member` MODIFY `id_type_member` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!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 */;