Da

✏️ Editing: designco_wallet.sql

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

/*!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: `designco_wallet`
--

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

USE `designco_wallet`;

--
-- Table structure for table `member_authentication`
--

DROP TABLE IF EXISTS `member_authentication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `member_authentication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expired_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `member_authentication`
--

LOCK TABLES `member_authentication` WRITE;
/*!40000 ALTER TABLE `member_authentication` DISABLE KEYS */;
INSERT INTO `member_authentication` VALUES (4,1,'X5zTpI+BXHNvaLhpyM+9nPV9kwjocx9bQ','2020-09-09 23:42:46','2020-09-09 20:42:45','2020-09-09 20:42:46'),(6,3,'42b17zjbPECZMaLmMywGp9+IdfGEVul3eQ','2020-09-09 23:57:54','2020-09-09 20:57:54','2020-09-09 20:57:54'),(9,4,'eutyuj1KgVuDjMjnrxUyED3375TQ3TpW4w','2020-09-10 02:00:46','2020-09-09 22:30:30','2020-09-09 23:00:46'),(10,5,'WCRzjpJb3tS0G5fO2HR3dh9+SPwPMCknKw','2020-09-10 02:30:56','2020-09-09 23:30:55','2020-09-09 23:30:56'),(11,2,'gVLcFA6ZAMBtFl5J1uBWjU9jFV0lvhFg','2020-09-10 08:27:50','2020-09-10 05:21:42','2020-09-10 05:27:50');
/*!40000 ALTER TABLE `member_authentication` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms`
--

DROP TABLE IF EXISTS `sms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `remark` text DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms`
--

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

--
-- Table structure for table `tb_agent`
--

DROP TABLE IF EXISTS `tb_agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_agent` (
  `agent_id` int(11) NOT NULL AUTO_INCREMENT,
  `agent_group` varchar(75) DEFAULT NULL,
  `member_id` int(11) DEFAULT NULL,
  `username` varchar(75) DEFAULT NULL,
  `password` varchar(75) DEFAULT NULL,
  `credit_balance` int(11) DEFAULT 0,
  `status` enum('0','1','2') NOT NULL DEFAULT '2',
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`agent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_agent`
--

LOCK TABLES `tb_agent` WRITE;
/*!40000 ALTER TABLE `tb_agent` DISABLE KEYS */;
INSERT INTO `tb_agent` VALUES (1,'ufabet',1,'ufriz000001','Pwd123456',0,'1','Administrator','2020-09-09 20:29:13','114.119.188.73','2020-09-09 20:30:11'),(2,'ufabet',2,'ufriz000002','Pwd123456',0,'1','Administrator','2020-09-09 20:29:13','114.119.188.73','2020-09-09 20:52:13'),(3,'ufabet',3,'ufriz000003','Pwd123456',0,'1','Administrator','2020-09-09 20:29:13','114.119.188.73','2020-09-09 20:57:41'),(4,'ufabet',4,'ufriz000004','Pwd123456',0,'1','Administrator','2020-09-09 20:29:13','114.119.188.73','2020-09-09 22:05:34'),(5,'ufabet',5,'ufriz000005','Pwd123456',0,'1','Administrator','2020-09-09 20:29:13','114.119.188.73','2020-09-09 23:30:30'),(6,'ufabet',NULL,'ufriz000006','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(7,'ufabet',NULL,'ufriz000007','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(8,'ufabet',NULL,'ufriz000008','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(9,'ufabet',NULL,'ufriz000009','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(10,'ufabet',NULL,'ufriz000010','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(11,'ufabet',NULL,'ufriz000011','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(12,'ufabet',NULL,'ufriz000012','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(13,'ufabet',NULL,'ufriz000013','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(14,'ufabet',NULL,'ufriz000014','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(15,'ufabet',NULL,'ufriz000015','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(16,'ufabet',NULL,'ufriz000016','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(17,'ufabet',NULL,'ufriz000017','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(18,'ufabet',NULL,'ufriz000018','Pwd123456',0,'2','Administrator','2020-09-09 20:29:13',NULL,NULL),(19,'ufabet',NULL,'ufriz000019','Pwd123456',0,'2','Administrator','2020-09-09 20:29:14',NULL,NULL),(20,'ufabet',NULL,'ufriz000020','Pwd123456',0,'2','Administrator','2020-09-09 20:29:14',NULL,NULL),(21,'sagame',1,'sagame000001','Pwd123456',0,'1','Administrator','2020-09-09 20:29:21','114.119.188.73','2020-09-09 20:30:11'),(22,'sagame',2,'sagame000002','Pwd123456',0,'1','Administrator','2020-09-09 20:29:21','114.119.188.73','2020-09-09 20:52:13'),(23,'sagame',3,'sagame000003','Pwd123456',0,'1','Administrator','2020-09-09 20:29:21','114.119.188.73','2020-09-09 20:57:41'),(24,'sagame',4,'sagame000004','Pwd123456',0,'1','Administrator','2020-09-09 20:29:21','114.119.188.73','2020-09-09 22:05:34'),(25,'sagame',5,'sagame000005','Pwd123456',0,'1','Administrator','2020-09-09 20:29:21','114.119.188.73','2020-09-09 23:30:30'),(26,'sagame',NULL,'sagame000006','Pwd123456',0,'2','Administrator','2020-09-09 20:29:21',NULL,NULL),(27,'sagame',NULL,'sagame000007','Pwd123456',0,'2','Administrator','2020-09-09 20:29:21',NULL,NULL),(28,'sagame',NULL,'sagame000008','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(29,'sagame',NULL,'sagame000009','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(30,'sagame',NULL,'sagame000010','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(31,'sagame',NULL,'sagame000011','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(32,'sagame',NULL,'sagame000012','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(33,'sagame',NULL,'sagame000013','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(34,'sagame',NULL,'sagame000014','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(35,'sagame',NULL,'sagame000015','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(36,'sagame',NULL,'sagame000016','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(37,'sagame',NULL,'sagame000017','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(38,'sagame',NULL,'sagame000018','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(39,'sagame',NULL,'sagame000019','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(40,'sagame',NULL,'sagame000020','Pwd123456',0,'2','Administrator','2020-09-09 20:29:22',NULL,NULL),(41,'jokergame',1,'joker000001','Pwd123456',0,'1','Administrator','2020-09-09 20:29:29','114.119.188.73','2020-09-09 20:30:11'),(42,'jokergame',2,'joker000002','Pwd123456',0,'1','Administrator','2020-09-09 20:29:29','114.119.188.73','2020-09-09 20:52:13'),(43,'jokergame',3,'joker000003','Pwd123456',0,'1','Administrator','2020-09-09 20:29:29','114.119.188.73','2020-09-09 20:57:41'),(44,'jokergame',4,'joker000004','Pwd123456',0,'1','Administrator','2020-09-09 20:29:29','114.119.188.73','2020-09-09 22:05:34'),(45,'jokergame',5,'joker000005','Pwd123456',0,'1','Administrator','2020-09-09 20:29:29','114.119.188.73','2020-09-09 23:30:30'),(46,'jokergame',NULL,'joker000006','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(47,'jokergame',NULL,'joker000007','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(48,'jokergame',NULL,'joker000008','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(49,'jokergame',NULL,'joker000009','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(50,'jokergame',NULL,'joker000010','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(51,'jokergame',NULL,'joker000011','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(52,'jokergame',NULL,'joker000012','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(53,'jokergame',NULL,'joker000013','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(54,'jokergame',NULL,'joker000014','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(55,'jokergame',NULL,'joker000015','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(56,'jokergame',NULL,'joker000016','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(57,'jokergame',NULL,'joker000017','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(58,'jokergame',NULL,'joker000018','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(59,'jokergame',NULL,'joker000019','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL),(60,'jokergame',NULL,'joker000020','Pwd123456',0,'2','Administrator','2020-09-09 20:29:29',NULL,NULL);
/*!40000 ALTER TABLE `tb_agent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_bank_main`
--

DROP TABLE IF EXISTS `tb_bank_main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_bank_main` (
  `bank_main_id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('Deposit','Withdrawal') NOT NULL,
  `bank_id` int(11) NOT NULL,
  `bank_acc` varchar(255) NOT NULL,
  `bank_number` varchar(25) NOT NULL,
  `money_balance` varchar(10) NOT NULL DEFAULT '0',
  `promptpay` varchar(75) DEFAULT NULL,
  `promptpay_used` enum('1','0') DEFAULT '0',
  `username` varchar(75) NOT NULL,
  `password` varchar(75) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`bank_main_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_bank_main`
--

LOCK TABLES `tb_bank_main` WRITE;
/*!40000 ALTER TABLE `tb_bank_main` DISABLE KEYS */;
INSERT INTO `tb_bank_main` VALUES (1,'Withdrawal',5,'12345678910','12345678910','0','','0','-','-','1','Administrator','2020-05-10 18:36:51','Administrator','2020-09-01 01:58:34'),(3,'Deposit',2,'-','-','0','','0','-','-','1','Administrator','2020-05-10 19:13:23','autoSystem','2020-08-01 17:49:08');
/*!40000 ALTER TABLE `tb_bank_main` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_member`
--

DROP TABLE IF EXISTS `tb_member`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_member` (
  `member_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(75) NOT NULL,
  `password` varchar(205) DEFAULT NULL,
  `name` text NOT NULL,
  `lineid` varchar(105) NOT NULL,
  `account_bank_id` int(11) NOT NULL,
  `account_number` varchar(20) NOT NULL,
  `register_ip` varchar(75) DEFAULT NULL,
  `register_date` datetime NOT NULL,
  `come_from` varchar(75) DEFAULT NULL,
  `user_recommend` varchar(75) DEFAULT NULL,
  `used_auto` enum('1','0') NOT NULL,
  `used_bonus` enum('1','0') NOT NULL,
  `remark` text DEFAULT NULL,
  `credit_balance` int(11) NOT NULL DEFAULT 0,
  `status` enum('1','0') NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  PRIMARY KEY (`member_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_member`
--

LOCK TABLES `tb_member` WRITE;
/*!40000 ALTER TABLE `tb_member` DISABLE KEYS */;
INSERT INTO `tb_member` VALUES (1,'08631278360','5ee2da63c84ec6aa0b877320ebe06218','supasit singboon','',1,'1234567890','114.119.188.73','2020-09-09 20:30:11','','','1','0','',0,'1','114.119.188.73','2020-09-09 20:30:11',NULL,NULL,'2020-09-09 20:42:45'),(2,'0863127836','25d55ad283aa400af464c76d713c07ad','supasit singboon','',6,'08000000000','114.119.188.73','2020-09-09 20:52:13','','','1','0','',0,'1','114.119.188.73','2020-09-09 20:52:13','114.119.188.73','2020-09-09 21:38:31','2020-09-10 05:21:42'),(3,'0989866225','90b7c601df09a83cb22f53cd8e157cb6','ทิพย์สุดา','',4,'0943721957','114.119.188.73','2020-09-09 20:57:41','','','1','0','',0,'1','114.119.188.73','2020-09-09 20:57:41',NULL,NULL,'2020-09-09 20:57:54'),(4,'0623655265','65e08d938aab4040ac409017f4b42390','Borripat utumporn','',2,'3432611093','114.119.188.73','2020-09-09 22:05:34','','','1','0','',0,'1','114.119.188.73','2020-09-09 22:05:34',NULL,NULL,'2020-09-09 22:30:30'),(5,'0616465956','8b50dfdea77d8b566c0e6b6a64bd57e9','ระพี พวงสุพาง','',2,'359-2-79191-8','114.119.188.73','2020-09-09 23:30:30','','','1','0','',0,'1','114.119.188.73','2020-09-09 23:30:30',NULL,NULL,'2020-09-09 23:30:55');
/*!40000 ALTER TABLE `tb_member` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_member_transaction`
--

DROP TABLE IF EXISTS `tb_member_transaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_member_transaction` (
  `member_transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) DEFAULT NULL,
  `transaction_id` int(11) DEFAULT NULL,
  `type` enum('deposit','withdraw','agent') NOT NULL,
  `pay_in` varchar(25) DEFAULT NULL,
  `pay_out` varchar(25) DEFAULT NULL,
  `credit_data` int(11) NOT NULL DEFAULT 0,
  `credit_old` int(11) NOT NULL DEFAULT 0,
  `credit_current` int(11) NOT NULL DEFAULT 0,
  `ip` varchar(105) DEFAULT NULL,
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `check_code` varchar(25) NOT NULL,
  `create_type` enum('Auto','Manual') NOT NULL DEFAULT 'Auto',
  `status` enum('success','error','wait','hide') NOT NULL,
  `remark` text DEFAULT NULL,
  `update_by` varchar(105) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`member_transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_member_transaction`
--

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

--
-- Table structure for table `tb_otp`
--

DROP TABLE IF EXISTS `tb_otp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_otp` (
  `otp_id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_id` int(11) NOT NULL,
  `bank_number` varchar(25) NOT NULL,
  `otp` varchar(11) NOT NULL,
  `ref` varchar(25) NOT NULL,
  `phone_bank` varchar(25) NOT NULL,
  `status` enum('wait','success','error') NOT NULL DEFAULT 'wait',
  `create_date` datetime NOT NULL,
  `create_by` varchar(75) NOT NULL,
  PRIMARY KEY (`otp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_otp`
--

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

--
-- Table structure for table `tb_transaction`
--

DROP TABLE IF EXISTS `tb_transaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_transaction` (
  `transaction_id` int(11) NOT NULL AUTO_INCREMENT,
  `transaction_code` varchar(75) DEFAULT NULL,
  `receive_type` enum('Deposit','Withdrawal','Outstanding_Balance') NOT NULL,
  `receive_date` date NOT NULL,
  `receive_time` time NOT NULL,
  `receive_bank` varchar(10) NOT NULL,
  `receive_bank_number` varchar(15) NOT NULL,
  `receive_price` varchar(11) NOT NULL,
  `receive_balance` varchar(75) DEFAULT NULL,
  `from_bank` int(11) NOT NULL,
  `from_bank_number` varchar(25) NOT NULL,
  `receive_phone_number` varchar(75) DEFAULT NULL,
  `status` enum('wait','success','error','onprocess','step1','step2','step3','error_otp','cancel','queue','error_captcha','queue_order','captcha') NOT NULL DEFAULT 'wait',
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `check_code` varchar(25) NOT NULL,
  `type_system` varchar(25) NOT NULL,
  `remark` varchar(205) DEFAULT NULL,
  PRIMARY KEY (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_transaction`
--

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

--
-- Table structure for table `tm_authorization`
--

DROP TABLE IF EXISTS `tm_authorization`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tm_authorization` (
  `auth_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(105) NOT NULL,
  `master_carrier` int(11) NOT NULL DEFAULT 0,
  `master_channel` int(11) NOT NULL DEFAULT 0,
  `master_note` int(11) NOT NULL DEFAULT 0,
  `master_payment` int(11) NOT NULL DEFAULT 0,
  `master_product` int(11) NOT NULL DEFAULT 0,
  `master_product_type` int(11) NOT NULL DEFAULT 0,
  `master_social` int(11) NOT NULL DEFAULT 0,
  `master_user` int(11) NOT NULL DEFAULT 0,
  `transaction_order` int(11) NOT NULL DEFAULT 0,
  `status` enum('available','disabled') NOT NULL,
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tm_authorization`
--

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

--
-- Table structure for table `tm_bank`
--

DROP TABLE IF EXISTS `tm_bank`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tm_bank` (
  `bank_id` int(11) NOT NULL AUTO_INCREMENT,
  `bank_th` varchar(205) NOT NULL,
  `bank_en` varchar(205) NOT NULL,
  `bank_swiftcode` varchar(75) NOT NULL,
  `bank_set` varchar(75) NOT NULL,
  `bank_icon` varchar(205) NOT NULL,
  `bank_bg` varchar(205) NOT NULL,
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `check_code` varchar(25) NOT NULL,
  PRIMARY KEY (`bank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tm_bank`
--

LOCK TABLES `tm_bank` WRITE;
/*!40000 ALTER TABLE `tm_bank` DISABLE KEYS */;
INSERT INTO `tm_bank` VALUES (1,'ธนาคารกรุงเทพ','Bangkokbank','BKKBTHBK','BBL','bbl_icon.png','bbl_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(2,'ธนาคารกสิกรไทย','KASIKORNBANK','KASITHBK','KBANK','kbank_icon.png','kbank_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(3,'ธนาคารกรุงไทย','Krungthai','KRTHTHBK','KTB','ktb_icon.png','ktb_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(4,'ธนาคารทหารไทย','TMBBank','TMBKTHBK','TMB','tmb_icon.png','tmb_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(5,'ธนาคารไทยพาณิชย์','SCBBank','SICOTHBK','SCB','scb_icon.png','scb_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(6,'ธนาคารกรุงศรีอยุธยา','BAYBank','AYUDTHBK','BAY','kma_icon.png','bay_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(7,'ธนาคารซีไอเอ็มบีไทย','Cimbthai','UBOBTHBK','CIMBT','cimbt_icon.png','cimbt_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(8,'ธนาคารทิสโก้','Tisco','TFPCTHB1','TISCO','tisco_icon.png','tisco_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(9,'ธนาคารธนชาต','Thanachartbank','THBKTHBK','TBNK','tbank_icon.png','tbank_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(10,'ธนาคารยูโอบี','UBO','UOVBTHBK','UOBT','oubt_icon.png','oubt_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(11,'ธนาคารออมสิน','GSB','GSBATHBK','GSB','gsb_icon.png','gsb_bg.png','1','administrator','2020-04-27 00:00:00',NULL,NULL,''),(12,'ธนาคารเพื่อการเกษตรและสหกรณ์การเกษตร','ธนาคารเพื่อการเกษตรและสหกรณ์การเกษตร','BAAC','BAAC','baac_icon.png','baac.bg','1','administrator','2020-05-25 00:20:11',NULL,NULL,''),(13,'ธนาคารแลนด์แอนด์เฮ้าส์','ธนาคารแลนด์แอนด์เฮ้าส์','LHBA','LHBA','lhba_icon.png','lhba_bg.png','1','administrator','2020-05-25 00:20:11',NULL,NULL,''),(14,'ธนาคารไทยเครดิตเพื่อรายย่อย','ธนาคารไทยเครดิตเพื่อรายย่อย','TCD','TCD','tcd_icon.png','tcd_bg.png','1','administrator','2020-05-25 00:20:11',NULL,NULL,''),(15,'ธนาคารซิตี้แบงค์','ธนาคารซิตี้แบงค์','CITI','CITI','citi_icon.png','citi_bg.png','1','administrator','2020-05-25 00:20:11',NULL,NULL,'');
/*!40000 ALTER TABLE `tm_bank` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tm_user`
--

DROP TABLE IF EXISTS `tm_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tm_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `auth_id` int(11) NOT NULL,
  `display` varchar(105) NOT NULL,
  `phone_number` varchar(75) NOT NULL,
  `password` varchar(150) NOT NULL,
  `email` varchar(75) NOT NULL,
  `address` text DEFAULT NULL,
  `check_login` int(11) NOT NULL DEFAULT 0,
  `status` enum('available','disabled','cancel') NOT NULL DEFAULT 'available',
  `last_login` datetime DEFAULT NULL,
  `create_by` varchar(75) NOT NULL,
  `create_date` datetime NOT NULL,
  `update_by` varchar(75) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `check_code` varchar(25) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tm_user`
--

LOCK TABLES `tm_user` WRITE;
/*!40000 ALTER TABLE `tm_user` DISABLE KEYS */;
INSERT INTO `tm_user` VALUES (1,1,'Administrator','0811111111','81dc9bdb52d04dc20036dbd8313ed055','168@gmail.com',NULL,1,'available','2021-01-12 23:13:44','Administrator','2020-04-13 00:00:00',NULL,NULL,'');
/*!40000 ALTER TABLE `tm_user` 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-31 13:20:02

📁 Sid Gifari File Manager