Da

✏️ Editing: tpgarden_monsterbike.sql

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

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

--
-- Current Database: `tpgarden_monsterbike`
--

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

USE `tpgarden_monsterbike`;

--
-- Table structure for table `building`
--

DROP TABLE IF EXISTS `building`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `building` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `title` varchar(191) NOT NULL,
  `description` text NOT NULL,
  `lat` float(10,6) NOT NULL,
  `lng` float(10,6) NOT NULL,
  `image` text DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `building`
--

LOCK TABLES `building` WRITE;
/*!40000 ALTER TABLE `building` DISABLE KEYS */;
INSERT INTO `building` VALUES (8,'Ok3O','โรงพยาบาลสงขลานครินทร์2','โรงพยาบาลสงขลานครินทร์2',7.006853,100.494484,'images/buildings/โรงพยาบาลสงขลานครินทร์2/CCU-Songklanagarind.jpg',0,0,'2017-06-14','2017-06-14');
/*!40000 ALTER TABLE `building` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `car_details`
--

DROP TABLE IF EXISTS `car_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `car_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_id` int(11) NOT NULL,
  `car` varchar(255) DEFAULT NULL,
  `model` varchar(50) DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `plate` varchar(50) DEFAULT NULL,
  `car_lat` text DEFAULT NULL,
  `car_lng` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `car_details`
--

LOCK TABLES `car_details` WRITE;
/*!40000 ALTER TABLE `car_details` DISABLE KEYS */;
INSERT INTO `car_details` VALUES (2,17,'Honda','City','ดำ','กข1234',NULL,NULL,'2017-04-17 13:13:33','2017-04-17 13:13:33'),(4,18,'Toyota','Vios','ดำ','ฟก452',NULL,NULL,'2017-04-17 14:13:36','2017-04-18 16:52:06'),(6,20,'','','','',NULL,NULL,'2017-04-17 14:21:42','2017-04-17 14:21:42'),(7,11,'โตโยต้า','รีโว','ขาว','กก2244',NULL,NULL,NULL,NULL),(8,13,'อิซุซุ                  ','ดีแม็ก','ดำ','กง5689                  ',NULL,NULL,'2017-04-26 14:01:34','2017-04-26 15:26:34');
/*!40000 ALTER TABLE `car_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ci_sessions`
--

DROP TABLE IF EXISTS `ci_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  `data` blob NOT NULL,
  KEY `ci_sessions_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ci_sessions`
--

LOCK TABLES `ci_sessions` WRITE;
/*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */;
INSERT INTO `ci_sessions` VALUES ('75d2bdc3c029ea61421b002096f163b3ebee7143','::1',1488616299,'__ci_last_regenerate|i:1488616056;'),('746b13ef8412c9cf32a106ef8a06bdde644e757e','::1',1488616866,'__ci_last_regenerate|i:1488616574;'),('cc19b30225fba21fcd3357c4a3023a638bc3505d','::1',1488617116,'__ci_last_regenerate|i:1488616911;'),('0c5354d75f98c6f7ca7a758fb2843cb1d65ba0bc','::1',1488617242,'__ci_last_regenerate|i:1488617226;'),('4dbc84da6731ba091b9e547c092c5e60f2085631','::1',1488617329,'__ci_last_regenerate|i:1488617248;'),('aa7983c67c98ef4ac0f148459f1f2902b6936fc8','::1',1488617880,'__ci_last_regenerate|i:1488617606;'),('0126ee859068049b35e9de7ccead21352400df64','::1',1488618098,'__ci_last_regenerate|i:1488617925;'),('aada2d068a493a3bd62b71a1363b826b115b1390','::1',1488618645,'__ci_last_regenerate|i:1488618606;'),('a4113daa89dc88665a914f321b706169713c364c','::1',1488618744,'__ci_last_regenerate|i:1488618730;'),('8c667d5ef9f545b90ae100309ddc01e9b368e0d7','::1',1488619421,'__ci_last_regenerate|i:1488619233;'),('856af1bdd15d73000f6b2bfefc5eeac267df039a','::1',1488619871,'__ci_last_regenerate|i:1488619627;'),('0d06a866f5fd5c0965aadeb0a991a52f36da0fb7','::1',1488620362,'__ci_last_regenerate|i:1488620073;'),('2ff8a64533c66fbc5a384ca8c9f7b6e007ceecda','::1',1488620822,'__ci_last_regenerate|i:1488620538;'),('af2783bf5ea7195602afcebdca61770f623ae876','::1',1488621129,'__ci_last_regenerate|i:1488620866;'),('3160954a59459875624b4cea70b5ce0c8cd00cee','192.168.1.12',1488621248,'__ci_last_regenerate|i:1488620968;'),('82f90227a99c9678422d01076a95f58f10f268ab','::1',1488621408,'__ci_last_regenerate|i:1488621178;'),('21e8be9769fc519059d6928217854e48fa7ad472','192.168.1.12',1488621582,'__ci_last_regenerate|i:1488621323;'),('2ed2f1412a837468e5e1e67076a04d612e23e5b9','::1',1488621609,'__ci_last_regenerate|i:1488621524;'),('8026bce237a35b8786a46aa11d6c9603c0b99138','192.168.1.12',1488621656,'__ci_last_regenerate|i:1488621630;'),('509d9fe9b92f2e9f7f38baba5b13886aed28f379','::1',1488622067,'__ci_last_regenerate|i:1488621914;'),('49c294577c4eaf341c814a8eb6c7e3eb16d2a962','::1',1488622429,'__ci_last_regenerate|i:1488622366;'),('ffcfcd22d669a8c52bf47c27c6d02636b53c3ee3','::1',1488623241,'__ci_last_regenerate|i:1488622976;'),('98a5cae1d1e021a1b3ee0d6923005749d101369f','192.168.1.12',1488623026,'__ci_last_regenerate|i:1488623020;'),('e28a43a890efaad32b8d0c9d8345933302764b3f','::1',1488623525,'__ci_last_regenerate|i:1488623280;'),('48485db9f927a643b790bb05fbb0e0d345e7ba76','192.168.1.12',1488623960,'__ci_last_regenerate|i:1488623820;'),('4765be97610bd7b70c6caa7785778fd7444a5041','::1',1488624553,'__ci_last_regenerate|i:1488624257;'),('c9526a8b1a44fd3e1081c0fc857c8e2bce817cc2','::1',1488625037,'__ci_last_regenerate|i:1488624737;'),('135b82a0a53400be12b22fcfca8f1bf32b450a73','192.168.1.12',1488625055,'__ci_last_regenerate|i:1488625052;'),('6a319b978324110fd0cfbaf59a2e874c61dce610','::1',1488625203,'__ci_last_regenerate|i:1488625186;'),('f13f4e4f35286ee82034f8aafe04aa0d680eca17','::1',1488631768,'__ci_last_regenerate|i:1488631498;'),('49de042308b4fca19ad5e4f33ef90ad079a8f151','::1',1488632082,'__ci_last_regenerate|i:1488631815;'),('200e156c15e3c59bbfd86596d2c8c4c860fb02a1','192.168.1.12',1488632060,'__ci_last_regenerate|i:1488631831;'),('68a0c48c8f014f002f06eb6680dc0d3a9682eb61','::1',1488632409,'__ci_last_regenerate|i:1488632119;'),('6677713516b38ad35eb9c0df0c0ed4c6217b90cb','192.168.1.12',1488632212,'__ci_last_regenerate|i:1488632160;'),('6800193c6364d766f8e91ad0280ba4a7e1e50d0d','::1',1488632690,'__ci_last_regenerate|i:1488632424;'),('5185fd32ec3f6beb560e6fd78b2fb58dee904be1','::1',1488632871,'__ci_last_regenerate|i:1488632808;'),('d4262c839a6db67289c3d19a41ad0dc6d1f9f365','192.168.1.12',1488632875,'__ci_last_regenerate|i:1488632873;'),('c50b9f2e725c1b8fc236b112af3a32652a9a2a76','::1',1488633567,'__ci_last_regenerate|i:1488633273;'),('3a9fe8330eed51306f85a1f915f8fe713e3fa1eb','192.168.1.12',1488633581,'__ci_last_regenerate|i:1488633284;'),('6a41d2750638e6c89042873d339bb4fbaa68b6f3','::1',1488633891,'__ci_last_regenerate|i:1488633592;'),('8697bac0a0db69cb3cf7d40e550411aba51e33a7','192.168.1.12',1488633968,'__ci_last_regenerate|i:1488633771;'),('bec44d51ddbe73d7d2136555292c3b4f4150bb21','::1',1488633912,'__ci_last_regenerate|i:1488633896;'),('9625c1cb4d5d0b8ae67ace06bb4d47cc2c7cabe5','192.168.1.12',1488634109,'__ci_last_regenerate|i:1488634082;'),('48f61056ce8e6a853b65ca05ba9219ef62ef95ec','192.168.1.12',1488634873,'__ci_last_regenerate|i:1488634864;'),('bca24e15bfac757e67062691b6e4991267181433','::1',1488635482,'__ci_last_regenerate|i:1488635447;'),('3c5013b98e171be248dc380fbfbab03d204efec0','::1',1488640352,'__ci_last_regenerate|i:1488640215;'),('63b359e1fcc06abaf6f824a984d9345b56336528','::1',1488686839,'__ci_last_regenerate|i:1488686559;'),('39577fa6d1de92432d9dd9435afe59618540cb8e','::1',1488689180,'__ci_last_regenerate|i:1488688985;'),('323c141909cf839a378b353fe1d5ec3094cdfad6','::1',1488689725,'__ci_last_regenerate|i:1488689451;'),('a466146279b3ddec2e20ed156f93fb245369f967','::1',1488690024,'__ci_last_regenerate|i:1488689756;'),('5397096815a47c856985e9ffd0a37e4db37f4cda','::1',1488690530,'__ci_last_regenerate|i:1488690250;'),('84206e7ce8d08fdc8ee2d1865a5f3e9d5dd7fa95','::1',1488690532,'__ci_last_regenerate|i:1488690382;'),('b0cd543dc072d1e5c4b39126728c076e27a4e6fe','::1',1488690942,'__ci_last_regenerate|i:1488690942;'),('c3a4d79f1e1a52dc9169a0f98312c0c70635bacb','::1',1488693106,'__ci_last_regenerate|i:1488692808;'),('6963f9a475635c6f8d946c11617a731e607e8f3c','::1',1488693311,'__ci_last_regenerate|i:1488693141;'),('a5ecc102bcb31e3dc27af73c197da5a0321ac21c','::1',1488694484,'__ci_last_regenerate|i:1488694409;'),('fd17dd4b36aacd769fce1094d6910c0f2421992c','::1',1488694516,'__ci_last_regenerate|i:1488694486;'),('a19d00f014b9f88ccb45f6d1ddd72abfccb49b44','::1',1488695855,'__ci_last_regenerate|i:1488695587;'),('0865c52cb0ffcde8dcd70daba2efa2032bc30b93','::1',1488696055,'__ci_last_regenerate|i:1488695972;'),('e01720de58652d726519acdff260fcc645903773','::1',1488696561,'__ci_last_regenerate|i:1488696319;priv|s:6:\"member\";'),('f08be1c35bcd5531adc3d322961c48f748105584','::1',1488698327,'__ci_last_regenerate|i:1488698167;priv|s:6:\"member\";'),('e1a5a5496756c96602adbfd3988a73c6959edbcc','::1',1488698930,'__ci_last_regenerate|i:1488698680;priv|s:5:\"admin\";name|s:4:\"jane\";surname|N;'),('4521a423bcf129993bddb1b0bce41000929b74c4','::1',1488699061,'__ci_last_regenerate|i:1488699011;priv|s:5:\"admin\";name|s:4:\"jane\";surname|N;'),('caf2c7b1e3e070d2dc16c8aac59c8981fed6b261','::1',1488699405,'__ci_last_regenerate|i:1488699334;priv|s:5:\"admin\";name|s:4:\"jane\";surname|N;'),('d7d65e1e8ab1235b111cba2aceea1d844b84fd70','192.168.1.12',1488701188,'__ci_last_regenerate|i:1488700892;username|s:21:\"hajibeijane@gmail.com\";name|s:4:\"jane\";surname|N;priv|s:5:\"admin\";logged_in|b:1;'),('3d6c692bebe2da9a6db4f782fdaa9951ec998a0c','::1',1488701148,'__ci_last_regenerate|i:1488700970;priv|s:5:\"admin\";name|s:4:\"jane\";surname|N;'),('c9abff422be1af297c65dea46c6431e8e9c760d5','192.168.1.12',1488701246,'__ci_last_regenerate|i:1488701207;name|s:4:\"jane\";surname|N;priv|s:5:\"admin\";'),('af0ee0e28dbd777797e5a7a655d10d344cd7c824','::1',1488799580,'__ci_last_regenerate|i:1488799566;'),('b950a5f88a540b165f667b57d5bd8820b0febf7e','::1',1488799578,'__ci_last_regenerate|i:1488799578;'),('a98194edd98d04c869c7e6389f37264fa1d23d8f','::1',1488801104,'__ci_last_regenerate|i:1488801042;username|s:21:\"hajibeijane@gmail.com\";name|s:4:\"jane\";surname|N;priv|s:5:\"admin\";logged_in|b:1;'),('d53c7b884a32a85b50fa9dba2c60fca1059c8275','::1',1488801093,'__ci_last_regenerate|i:1488801090;'),('e739e5f423659e0cfc620876959d2deed3e9a592','127.0.0.1',1488801177,'__ci_last_regenerate|i:1488801148;name|s:4:\"jane\";surname|N;priv|s:5:\"admin\";'),('83005a921c08a3eda93396bc16c3fd5c27f26daf','127.0.0.1',1488977746,'__ci_last_regenerate|i:1488977603;'),('45d7b6cfe579eebc958b384e89775e7926c779c5','127.0.0.1',1488978116,'__ci_last_regenerate|i:1488977921;username|s:21:\"hajibeijane@gmail.com\";name|s:4:\"jane\";surname|N;priv|s:5:\"admin\";logged_in|b:1;'),('da36175622d66ae940405ce5c1ba21ea3b018b4b','127.0.0.1',1488980651,'__ci_last_regenerate|i:1488980402;name|s:4:\"jane\";surname|N;priv|s:5:\"admin\";'),('9912d9c1c27f390dc9337b021f4cad762ce7f66f','127.0.0.1',1488980850,'__ci_last_regenerate|i:1488980804;name|N;surname|N;priv|N;'),('17ab29c019ad369ca1d29e95ea67d0ea72fd8fcd','::1',1489256843,'__ci_last_regenerate|i:1489256838;');
/*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `member`
--

DROP TABLE IF EXISTS `member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `password` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `status` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0=ไม่แสดง 1=แสดง 2=ลบ ',
  `name` varchar(100) DEFAULT NULL,
  `surname` varchar(100) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `gender` varchar(100) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `tel` varchar(16) DEFAULT NULL,
  `idnumber` varchar(13) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `tambon` varchar(100) DEFAULT NULL,
  `amphur` varchar(100) DEFAULT NULL,
  `province` varchar(100) DEFAULT NULL,
  `postcode` varchar(10) DEFAULT NULL,
  `member_type_id` int(32) NOT NULL,
  `remember_token` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `idnumber` (`idnumber`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member`
--

LOCK TABLES `member` WRITE;
/*!40000 ALTER TABLE `member` DISABLE KEYS */;
INSERT INTO `member` VALUES (11,'$2y$10$bkcck9JIcX7fNNnMeWaYdeepV4m6tYCOSnDT6decyPibk1DS5Ub7i','hlong2','0','Mr.Logistic','Everything',NULL,'male','images/members/hlong2/man.png','0899999999',NULL,'',NULL,NULL,'','',3,'d6rhG5plSyUbnDwy9ae7hHG0QXZ5PP68fpDOXSoNvD420NRgeWMoVQoNRchJ','2017-03-30 18:59:35','2017-05-18 09:53:44'),(12,'$2y$10$Sy2tOFL9KXYXclnRpY9Bee8yhe87.EOzqZ8.8NlQqRiG.K2JSCTXC','john','0','John','Doe',NULL,'male','images/members/john/boy.png','',NULL,'',NULL,NULL,'','',3,'qzAwpe4IyWgf9ysTzcdu7xAjGyxZCHZ8LJCrxaOw7x4SsyZti74tq5I4oFUN','2017-04-10 17:12:43','2018-11-20 21:10:50'),(13,'$2y$10$zFL0ZfEZoQHN29CHBAT9oeV.v7dHu879Ob.Jvl1eAhXFKBTPjeI3q','driver','0','Jane','Doe',NULL,'male','images/members/driver/driver2-4.png','',NULL,'',NULL,NULL,'','',2,'ehbqfSFuXuZzqXJg8YlUCjoV0aJ8CNheSWShCHIO2XTsQNnnkPWnRojuzktA','2017-04-10 17:40:37','2018-11-20 20:48:20'),(14,'$2y$10$u7zOwHum9NKQqx6AgBvyi.QYxWH.S0q5l4h1sAhfdttp.QED0NN76','admin','0','Admin','',NULL,'male','images/members/admin/man.png','',NULL,'',NULL,NULL,'','',3,'24iMnnQXBj0lZTbuSQiLlfcCQGxSfsnBgLwA8GEkz0aZizeKaxjmGiVN1Mh8','2017-04-10 18:25:27','2017-06-28 13:52:51'),(26,'$2y$10$wlANylI48.ktQWxx53y9M.jp9FHD8DRhHDHf59kxgQuEZvvn8BYzG','somchai','0','สมชาย','เข็มกลัด',NULL,'male','images/members/somchai/boy.png','',NULL,'',NULL,NULL,'','',1,'','2017-04-28 18:22:31','2017-04-28 18:39:28'),(27,'$2y$10$ON9I/fUeAUGK04x93nBphOLGGPhlE/shKcCCsJ8ceJEHf9WXcyzOK','baibua','0','ใบบัว','น่ารัก',NULL,'female','images/members/girl.png','',NULL,'',NULL,NULL,'','',1,'','2017-04-28 18:23:09','2017-04-28 18:27:17'),(28,'$2y$10$c0tEh9AKxJTnyrQGSIlhQOXH80spSdfQlF.M5jlc8AF6RbhK6Zd.K','Qq','0','Qq','Qq',NULL,'female','images/members/girl.png','',NULL,'',NULL,NULL,'','',1,'','2017-05-04 11:01:42','2017-05-04 11:01:42'),(29,'$2y$10$lTlb.27dvwstYgrKo36KJ.odK7sc9D4i0yF6y9RpxGIIjMmgblxkK','tester','0','fff','ffff',NULL,'male','images/members/boy.png','',NULL,'',NULL,NULL,'','',1,'','2017-10-10 14:55:23','2017-10-10 14:55:23');
/*!40000 ALTER TABLE `member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `member_package`
--

DROP TABLE IF EXISTS `member_package`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member_package`
--

LOCK TABLES `member_package` WRITE;
/*!40000 ALTER TABLE `member_package` DISABLE KEYS */;
INSERT INTO `member_package` VALUES (1,10000043,11,NULL,NULL),(2,10000045,11,NULL,NULL),(3,11,10000046,NULL,NULL),(4,11,10000047,NULL,NULL),(5,11,10000048,NULL,NULL),(6,11,10000049,NULL,NULL),(7,11,10000050,NULL,NULL),(8,12,10000051,NULL,NULL),(9,11,10000052,NULL,NULL),(10,11,10000053,NULL,NULL),(11,11,10000054,NULL,NULL),(12,13,10000055,NULL,NULL),(13,11,10000056,NULL,NULL),(14,12,10000057,NULL,NULL),(15,12,10000058,NULL,NULL),(16,12,10000059,NULL,NULL),(17,12,10000060,NULL,NULL),(18,12,10000061,NULL,NULL),(19,11,10000062,NULL,NULL),(20,11,10000063,NULL,NULL),(21,11,10000064,NULL,NULL),(22,11,10000065,NULL,NULL),(23,11,10000066,NULL,NULL),(24,11,10000067,NULL,NULL),(25,11,10000068,NULL,NULL),(26,11,10000069,NULL,NULL),(27,11,10000070,NULL,NULL);
/*!40000 ALTER TABLE `member_package` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `member_type`
--

DROP TABLE IF EXISTS `member_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member_type`
--

LOCK TABLES `member_type` WRITE;
/*!40000 ALTER TABLE `member_type` DISABLE KEYS */;
INSERT INTO `member_type` VALUES (1,'ผู้ใช้งานทั่วไป'),(2,'คนขับรถ'),(3,'admin');
/*!40000 ALTER TABLE `member_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `package`
--

DROP TABLE IF EXISTS `package`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `package` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `service_id` varchar(20) NOT NULL,
  `staff_id` int(10) DEFAULT NULL,
  `sender` varchar(100) DEFAULT NULL COMMENT 'ผู้ส่ง',
  `receiver` varchar(100) DEFAULT NULL COMMENT 'ผู้รับ',
  `sender_address` varchar(500) DEFAULT NULL COMMENT 'ที่อยู่ผู้ส่ง',
  `receiver_address` varchar(500) DEFAULT NULL COMMENT 'ที่อยู่ผู้รับ',
  `sender_phone` varchar(10) DEFAULT NULL,
  `receiver_phone` varchar(10) DEFAULT NULL,
  `lat_start` text DEFAULT NULL,
  `lng_start` text DEFAULT NULL,
  `lat_end` text DEFAULT NULL,
  `lng_end` text DEFAULT NULL,
  `staff_lat` text DEFAULT NULL,
  `staff_lng` text DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `product_weight` decimal(3,2) NOT NULL DEFAULT 0.00,
  `status_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff id` (`staff_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10000071 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `package`
--

LOCK TABLES `package` WRITE;
/*!40000 ALTER TABLE `package` DISABLE KEYS */;
INSERT INTO `package` VALUES (10000067,'21zi1kwD',NULL,'John Doe','Jane Doe','สุราษฎร์ธานี ','นครศรีธรรมราช','0899999999','0899999999','9.1382786','99.32171519999997','8.4303896','99.96322220000002','9.1382786','99.32171519999997',NULL,0.00,1,'2017-05-18 03:02:21','2017-05-18 03:02:21'),(10000051,'f65XvAHC',11,'จอน','เจน','ดอนเมือง','สุวรรณภูมิ','091111111','0911122222','13.9245277','100.60388990000001','13.7171586','100.75758210000004','13.7171586','100.75758210000004',NULL,0.00,4,'2017-04-26 22:31:27','2017-05-18 03:06:10'),(10000065,'1prgUWKP',11,'Mr.Logistic Everything','นายก','กทม','สุราษฎร์ธานี','0899999999','สบายดี','13.7563299','100.50176490000001','9.138259','99.32178410000006','9.138259','99.32178410000006',NULL,0.00,5,'2017-05-17 21:15:08','2017-05-18 03:04:44'),(10000068,'G98YVSya',11,'Michael Scofield','Lincoln Burrows','สมุทรปราการ','หนองคาย','0899999999','0899999999','13.5991224','100.59984480000003','17.8782766','102.74125530000003','13.591682061803462','100.6107223033905',NULL,0.00,2,'2017-05-18 03:04:18','2017-05-18 03:04:28'),(10000069,'fRvohtVu',11,'Fernando Sucre','Theodore \'T-Bag\' Bagwell','เลย','เชียงใหม่','0899999999','0899999999','17.4859701','101.72221639999998','18.7877315','98.99315180000008','17.4859701','101.72221639999998',NULL,0.00,3,'2017-05-18 03:05:36','2017-05-18 03:05:55'),(10000070,'gButdPln',11,'Mr.Logistic Everything','นายก','สุราษ','นคร','0899999999','09033333','9.1382786','99.32171519999997','8.4303896','99.96322220000002','9.135401900560623','99.33346509933472',NULL,0.00,2,'2017-05-18 10:09:27','2017-05-18 10:10:01');
/*!40000 ALTER TABLE `package` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `package_price`
--

DROP TABLE IF EXISTS `package_price`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `package_price` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_price` decimal(6,2) NOT NULL,
  `weight_price` decimal(6,2) NOT NULL,
  `distance_price` decimal(6,2) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `package_price`
--

LOCK TABLES `package_price` WRITE;
/*!40000 ALTER TABLE `package_price` DISABLE KEYS */;
INSERT INTO `package_price` VALUES (1,35.00,16.00,1.00,'2017-03-01 00:00:00','2017-04-28 22:47:59');
/*!40000 ALTER TABLE `package_price` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `package_status`
--

DROP TABLE IF EXISTS `package_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `package_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `color` varchar(50) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `package_status`
--

LOCK TABLES `package_status` WRITE;
/*!40000 ALTER TABLE `package_status` DISABLE KEYS */;
INSERT INTO `package_status` VALUES (1,'รอติดต่อกลับ','warning',NULL,NULL),(2,'กำลังรับสินค้า','info',NULL,NULL),(3,'กำลังส่งสินค้า','primary',NULL,NULL),(4,'ส่งสินค้าแล้ว','success',NULL,NULL),(5,'บริการขัดข้อง','danger',NULL,NULL);
/*!40000 ALTER TABLE `package_status` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2025-10-22 17:09:54

📁 Sid Gifari File Manager