-- MySQL dump 10.13  Distrib 5.1.47, for redhat-linux-gnu (i386)
--
-- Host: localhost    Database: XLSX_DB
-- ------------------------------------------------------
-- Server version	5.1.47

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Sheet1`
--

DROP TABLE IF EXISTS `Sheet1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Sheet1` (
  `number` int(4) DEFAULT NULL,
  `dd` varchar(10) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Sheet1`
--

LOCK TABLES `Sheet1` WRITE;
/*!40000 ALTER TABLE `Sheet1` DISABLE KEYS */;
INSERT INTO `Sheet1` VALUES (1225,NULL),(1230,NULL),(1233,NULL),(1239,NULL),(1241,NULL),(1256,NULL),(1269,NULL),(1272,NULL),(1279,NULL),(1280,NULL),(1283,NULL),(1285,NULL),(1287,NULL),(1289,NULL),(1293,NULL),(1297,NULL),(1298,NULL),(1299,NULL),(1300,NULL),(1301,NULL),(1302,NULL),(1304,NULL),(1305,NULL),(1306,NULL),(1307,NULL),(1308,NULL),(1310,NULL),(1314,NULL),(1317,NULL),(1318,NULL),(1319,NULL),(1323,NULL),(1325,NULL),(1329,NULL),(1336,NULL),(1340,NULL),(1347,NULL),(1353,NULL),(1356,NULL),(1361,NULL),(1362,NULL),(1363,NULL),(1364,NULL),(1366,NULL),(1368,NULL),(1376,NULL),(1378,NULL),(1385,NULL),(1392,NULL),(1397,NULL),(1398,NULL),(1399,NULL),(1400,NULL),(1402,NULL),(1409,NULL),(1410,NULL),(1419,NULL),(1428,NULL),(1436,NULL),(1437,NULL),(1438,NULL),(1447,NULL),(1448,NULL),(1450,NULL),(1451,NULL),(1454,NULL),(1465,NULL),(1470,NULL),(1472,NULL),(1479,NULL),(1485,NULL),(1488,NULL),(1490,NULL),(1496,NULL),(1502,NULL),(1509,NULL),(1510,NULL),(1512,NULL),(1516,NULL),(1517,NULL),(1520,NULL),(1525,NULL),(1526,NULL),(1528,NULL),(1531,NULL),(1534,NULL),(1541,NULL),(1544,NULL),(1546,NULL),(1547,NULL),(1549,NULL),(1562,NULL),(1563,NULL),(1567,NULL),(1568,NULL),(1569,NULL),(1571,NULL),(1585,NULL),(1588,NULL),(1589,NULL),(1592,NULL),(1598,NULL),(1600,NULL),(1604,NULL),(1611,NULL),(1612,NULL),(1615,NULL),(1618,NULL),(1623,NULL),(1625,NULL),(1629,NULL),(1630,NULL),(1634,NULL),(1637,NULL),(1638,NULL),(1644,NULL),(1645,NULL),(1649,NULL),(1652,NULL),(1653,NULL),(1655,NULL),(1657,NULL),(1658,NULL),(1659,NULL),(1665,NULL),(1667,NULL),(1669,NULL),(1671,NULL),(1672,NULL),(1673,NULL),(1674,NULL),(1675,NULL),(1678,NULL),(1679,NULL),(1681,NULL),(1683,NULL),(1689,NULL),(1690,NULL),(1691,NULL),(1692,NULL);
/*!40000 ALTER TABLE `Sheet1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_info`
--

DROP TABLE IF EXISTS `tbl_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_info`
--

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

--
-- Table structure for table `temples`
--

DROP TABLE IF EXISTS `temples`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temples` (
  `t_id` int(11) NOT NULL AUTO_INCREMENT,
  `t_name` varchar(50) COLLATE utf8_bin NOT NULL COMMENT 'ชื่อวัด',
  `t_sect` varchar(220) COLLATE utf8_bin NOT NULL,
  `t_num` varchar(50) COLLATE utf8_bin NOT NULL COMMENT 'เลขที่',
  `t_moo` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'หมู่ที่',
  `t_soi` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'ซอย',
  `t_road` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'ถนน',
  `district` varchar(220) COLLATE utf8_bin DEFAULT NULL COMMENT 'ตำบล',
  `amphur` varchar(220) COLLATE utf8_bin NOT NULL,
  `province` varchar(220) COLLATE utf8_bin NOT NULL,
  `geography` varchar(220) COLLATE utf8_bin NOT NULL,
  `budd_geo` varchar(10) COLLATE utf8_bin NOT NULL,
  `zipcode` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'รหัสไปรษณีย์',
  `t_phone1` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'เบอร์โทรวัด1',
  `t_phone2` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'เบอร์โทรวัด2',
  `fax` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'แฟกส์',
  `website` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'website',
  `email` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT 'email',
  `googleMap` varchar(250) COLLATE utf8_bin DEFAULT NULL COMMENT 'googlemap',
  PRIMARY KEY (`t_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='เก็บรายชื่อวัด';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `temples`
--

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

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

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-07-22  0:00:15