Da

✏️ Editing: httpstha_vij.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.26-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: httpstha_vij
-- ------------------------------------------------------
-- 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: `httpstha_vij`
--

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

USE `httpstha_vij`;

--
-- Table structure for table `get_zodiac`
--

DROP TABLE IF EXISTS `get_zodiac`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `get_zodiac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `lineid` varchar(150) DEFAULT NULL,
  `set_zodiac_id` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `get_zodiac`
--

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

--
-- Table structure for table `log_login`
--

DROP TABLE IF EXISTS `log_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT NULL,
  `lineid` varchar(150) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_login`
--

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

--
-- Table structure for table `redeem`
--

DROP TABLE IF EXISTS `redeem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `redeem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `campaign_date` date DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  `lineid` varchar(150) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `dob` varchar(150) DEFAULT NULL,
  `tel` varchar(150) DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `upload_image` varchar(255) DEFAULT NULL,
  `status_upload` tinyint(1) DEFAULT NULL,
  `status_approve` varchar(150) DEFAULT NULL,
  `detail_approve` text DEFAULT NULL,
  `slip_no` varchar(255) DEFAULT NULL,
  `slip_date` datetime DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `redeem`
--

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

--
-- Table structure for table `register`
--

DROP TABLE IF EXISTS `register`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `register` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lineid` varchar(255) DEFAULT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `zodiac` varchar(150) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `tel` varchar(15) DEFAULT NULL,
  `special_wallpaper` varchar(255) DEFAULT NULL,
  `special_pop_wallpaper` varchar(255) DEFAULT NULL,
  `normal_wallpaper` varchar(255) DEFAULT NULL,
  `normal_popup_wallpaper` varchar(255) DEFAULT NULL,
  `create_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `register`
--

LOCK TABLES `register` WRITE;
/*!40000 ALTER TABLE `register` DISABLE KEYS */;
INSERT INTO `register` VALUES (1,'Uebe47a365dda50e69d24ac712ed42ea0','้ัHHH','2024-09-19','ขาล_824','female','0845666769',NULL,NULL,'uploads/1/vertical_text_image_2_wall.png','uploads/1/vertical_text_image_2.png','2024-09-20 11:48:33');
/*!40000 ALTER TABLE `register` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `set_zodiac`
--

DROP TABLE IF EXISTS `set_zodiac`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `set_zodiac` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `campaign_date` date DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image_zodiac` varchar(255) DEFAULT NULL,
  `image_brand` varchar(255) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `set_zodiac`
--

LOCK TABLES `set_zodiac` WRITE;
/*!40000 ALTER TABLE `set_zodiac` DISABLE KEYS */;
INSERT INTO `set_zodiac` VALUES (1,'2024-09-20','โชคแห่งการเริ่มต้น','asset_vita/1/Icon_Date_1.png','asset_vita/1/Product_Date_1.png','เสริมโชคด้วย นมทางเลือกใหม่'),(2,'2024-09-21','โชคสุขภาพ','asset_vita/2/Icon_Date_2.png','asset_vita/2/Product_Date_2.png','เสริมสุขภาพ ประโยชน์คุ้มครอง'),(3,'2024-09-22','โชคมหาสเน่ห์','asset_vita/3/Icon_Date_3.png','asset_vita/3/Product_Date_3.png','เสริมผิวใส ใครเห็นก็หลง'),(4,'2024-09-23','โชคสติปัญญา','asset_vita/4/Icon_Date_4.png','asset_vita/4/Product_Date_4.png','เสริมอัลมอนด์ กระตุ้นสมอง'),(5,'2024-09-24','โชคความมั่นคง','asset_vita/5/Icon_Date_5.png','asset_vita/5/Product_Date_5.png','เสริมเจ ดีต่อใจ ทุกสิ่งราบรื่น'),(6,'2024-09-25','โชคการงาน','asset_vita/6/Icon_Date_6.png','asset_vita/6/Product_Date_6.png','เสริมมหาประโยชน์ การงานก้าวหน้า'),(7,'2024-09-26','โชคอำนาจบารมี','asset_vita/7/Icon_Date_7.png','asset_vita/7/Product_Date_7.png','เสริมหัวใจมั่นคง เพิ่มบารมี'),(8,'2024-09-27','โชคลาภเงินทอง','asset_vita/8/Icon_Date_8.png','asset_vita/8/Product_Date_8.png','เสริมสุขภาพ ร่างกายแข็งแรง เงินทองไหลมาเทมา'),(9,'2024-09-28','โชคความสำเร็จปัง!!','asset_vita/9/Icon_Date_9.png','asset_vita/9/Product_Date_9.png','เสริมองค์รวม สำเร็จทุกประการ');
/*!40000 ALTER TABLE `set_zodiac` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_access_matrix`
--

DROP TABLE IF EXISTS `tbl_access_matrix`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_access_matrix` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `access` text DEFAULT NULL,
  `roleId` int(11) NOT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT 0,
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_access_matrix`
--

LOCK TABLES `tbl_access_matrix` WRITE;
/*!40000 ALTER TABLE `tbl_access_matrix` DISABLE KEYS */;
INSERT INTO `tbl_access_matrix` VALUES (1,'[{\"module\":\"Task\",\"total_access\":0,\"list\":1,\"create_records\":0,\"edit_records\":0,\"delete_records\":0},{\"module\":\"Booking\",\"total_access\":0,\"list\":1,\"create_records\":0,\"edit_records\":0,\"delete_records\":0}]',12,0,1,'2022-06-17 21:01:02',1,'2022-06-18 20:50:58');
/*!40000 ALTER TABLE `tbl_access_matrix` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_booking`
--

DROP TABLE IF EXISTS `tbl_booking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_booking` (
  `bookingId` int(4) NOT NULL AUTO_INCREMENT,
  `roomName` varchar(256) NOT NULL,
  `description` varchar(1024) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT 0,
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  PRIMARY KEY (`bookingId`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_booking`
--

LOCK TABLES `tbl_booking` WRITE;
/*!40000 ALTER TABLE `tbl_booking` DISABLE KEYS */;
INSERT INTO `tbl_booking` VALUES (8,'Banner1',NULL,'http://localhost/sh/backend1/uploads/banner_1.png',0,1,'2024-06-08 10:09:06',NULL,NULL),(9,'Banner2',NULL,'http://localhost/sh/backend1/uploads/banner_2.png',0,1,'2024-06-08 10:09:14',NULL,NULL),(10,'Banner3',NULL,'http://localhost/sh/backend1/uploads/banner_3.png',0,1,'2024-06-08 10:09:22',NULL,NULL),(11,'TEST',NULL,'http://localhost/sh/backend1/uploads/S__31014935.jpg',0,1,'2024-06-18 09:25:40',NULL,NULL);
/*!40000 ALTER TABLE `tbl_booking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_bookingtime`
--

DROP TABLE IF EXISTS `tbl_bookingtime`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_bookingtime` (
  `id` int(11) NOT NULL,
  `lunch_name` varchar(250) DEFAULT NULL,
  `lunch_date` varchar(150) DEFAULT NULL,
  `lunch_time_start` varchar(100) DEFAULT NULL,
  `lunch_time_end` varchar(100) DEFAULT NULL,
  `dinner_name` varchar(250) DEFAULT NULL,
  `dinner_date` varchar(100) DEFAULT NULL,
  `dinner_time_start` varchar(100) DEFAULT NULL,
  `dinner_time_end` varchar(100) DEFAULT NULL,
  `detail` text DEFAULT NULL,
  `seotitle` varchar(255) DEFAULT NULL,
  `seodescription` text DEFAULT NULL,
  `created_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_bookingtime`
--

LOCK TABLES `tbl_bookingtime` WRITE;
/*!40000 ALTER TABLE `tbl_bookingtime` DISABLE KEYS */;
INSERT INTO `tbl_bookingtime` VALUES (1,'LUNCH','TUESDAY - SUNDAY,','12:00 NOON  -   2:00 PM','','DINNER','TUESDAY - SUNDAY,','6:00 PM  -   7:30 PM 7:45 PM  -   9:30 PM',NULL,'Experience authentic Edomae sushi at our tranquil restaurant on the majestic Chao Phraya River at the Chao Phraya Estate, celebrating the freshest seasonal seafood, hand-picked by Chef Takashi Saito every morning at Tokyo\'s Toyosu Market.','Sushi Saito Thailand','Sushi Saito Thailand Sushi Saito ThailandSushi Saito Thailand','2024-06-08 10:17:30');
/*!40000 ALTER TABLE `tbl_bookingtime` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_last_login`
--

DROP TABLE IF EXISTS `tbl_last_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_last_login` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userId` bigint(20) NOT NULL,
  `sessionData` varchar(2048) NOT NULL,
  `machineIp` varchar(1024) NOT NULL,
  `userAgent` varchar(128) NOT NULL,
  `agentString` varchar(1024) NOT NULL,
  `platform` varchar(128) NOT NULL,
  `createdDtm` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_last_login`
--

LOCK TABLES `tbl_last_login` WRITE;
/*!40000 ALTER TABLE `tbl_last_login` DISABLE KEYS */;
INSERT INTO `tbl_last_login` VALUES (1,1,'{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}','::1','Chrome 128.0.0.0','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','Windows 10','2024-09-15 10:02:45'),(2,1,'{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}','49.228.105.79','Chrome 128.0.0.0','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','Windows 10','2024-09-15 10:52:15'),(3,1,'{\"role\":\"1\",\"roleText\":\"System Administrator\",\"name\":\"System Administrator\",\"isAdmin\":\"1\"}','49.228.106.184','Chrome 128.0.0.0','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36','Windows 10','2024-09-15 20:15:48');
/*!40000 ALTER TABLE `tbl_last_login` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_reset_password`
--

DROP TABLE IF EXISTS `tbl_reset_password`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_reset_password` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `email` varchar(128) NOT NULL,
  `activation_id` varchar(32) NOT NULL,
  `agent` varchar(512) NOT NULL,
  `client_ip` varchar(32) NOT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT 0,
  `createdBy` bigint(20) NOT NULL DEFAULT 1,
  `createdDtm` datetime NOT NULL,
  `updatedBy` bigint(20) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_reset_password`
--

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

--
-- Table structure for table `tbl_roles`
--

DROP TABLE IF EXISTS `tbl_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_roles` (
  `roleId` tinyint(4) NOT NULL AUTO_INCREMENT COMMENT 'role id',
  `role` varchar(50) NOT NULL COMMENT 'role text',
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `isDeleted` tinyint(4) NOT NULL DEFAULT 0,
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  PRIMARY KEY (`roleId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_roles`
--

LOCK TABLES `tbl_roles` WRITE;
/*!40000 ALTER TABLE `tbl_roles` DISABLE KEYS */;
INSERT INTO `tbl_roles` VALUES (1,'System Administrator',1,0,0,'2021-01-21 00:00:00',1,'2022-06-17 20:21:46'),(2,'Manager',1,0,0,'2021-01-13 00:00:00',NULL,NULL),(3,'Employee',1,0,0,'2021-01-13 00:00:00',1,'2021-01-22 18:11:16'),(4,'Office Boy',1,0,1,'2021-01-22 17:40:24',1,'2021-01-22 18:33:49'),(5,'Receptionist',2,0,1,'2021-01-22 18:12:41',1,'2021-02-05 17:32:13'),(6,'Project Manager',1,0,1,'2021-02-05 18:25:00',NULL,NULL),(7,'Project Manager L2',1,0,1,'2021-02-05 18:27:30',1,'2021-03-26 14:54:08'),(8,'Project Manager L3',1,0,1,'2021-02-05 18:29:11',1,'2021-03-26 14:54:02'),(9,'Project Manager L4',1,0,1,'2021-02-05 18:29:43',1,'2021-03-26 14:53:51'),(10,'Project Manager L5',1,0,1,'2021-02-05 18:56:47',1,'2021-03-20 19:21:06'),(11,'Project Manager L6',1,0,1,'2021-02-05 18:57:23',1,'2022-06-17 20:56:55'),(12,'Data Entry Operator',1,0,1,'2022-06-17 20:57:22',1,'2022-06-18 20:50:52');
/*!40000 ALTER TABLE `tbl_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_task`
--

DROP TABLE IF EXISTS `tbl_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_task` (
  `taskId` int(4) NOT NULL AUTO_INCREMENT,
  `taskTitle` varchar(256) NOT NULL,
  `description` varchar(1024) DEFAULT NULL,
  `isDeleted` tinyint(4) NOT NULL DEFAULT 0,
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  PRIMARY KEY (`taskId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_task`
--

LOCK TABLES `tbl_task` WRITE;
/*!40000 ALTER TABLE `tbl_task` DISABLE KEYS */;
INSERT INTO `tbl_task` VALUES (1,'Small Task 1','Small task related to addition, substraction',0,1,'2022-06-18 20:47:47',1,'2022-06-18 20:49:40'),(2,'Small Task 2','Closure task',0,1,'2022-06-18 20:49:48',1,'2022-06-18 20:50:05');
/*!40000 ALTER TABLE `tbl_task` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_users`
--

DROP TABLE IF EXISTS `tbl_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_users` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(128) NOT NULL COMMENT 'login email',
  `password` varchar(128) NOT NULL COMMENT 'hashed login password',
  `name` varchar(128) DEFAULT NULL COMMENT 'full name of user',
  `mobile` varchar(20) DEFAULT NULL,
  `roleId` tinyint(4) NOT NULL,
  `isAdmin` tinyint(4) NOT NULL DEFAULT 2,
  `isDeleted` tinyint(4) NOT NULL DEFAULT 0,
  `createdBy` int(11) NOT NULL,
  `createdDtm` datetime NOT NULL,
  `updatedBy` int(11) DEFAULT NULL,
  `updatedDtm` datetime DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_users`
--

LOCK TABLES `tbl_users` WRITE;
/*!40000 ALTER TABLE `tbl_users` DISABLE KEYS */;
INSERT INTO `tbl_users` VALUES (1,'admin@vitaj.com','$2y$10$6Y28WIo2Oz.p8xsEMYcCmuvvijXZU8.sRT3737ix.vN1CwGs3NJk6','System Administrator','9890098900',1,1,0,0,'2015-07-01 18:56:49',1,'2021-06-01 16:17:08');
/*!40000 ALTER TABLE `tbl_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_line`
--

DROP TABLE IF EXISTS `user_line`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_line` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lineid` varchar(150) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `nickname` varchar(150) DEFAULT NULL,
  `term` tinyint(1) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_line`
--

LOCK TABLES `user_line` WRITE;
/*!40000 ALTER TABLE `user_line` DISABLE KEYS */;
INSERT INTO `user_line` VALUES (1,'Uebe47a365dda50e69d24ac712ed42ea0','Hnun ✨ * OOO','https://profile.line-scdn.net/0hYJ2l5QxVBmUPFRQGnpt5MjNQCAh4OwAtdyNAVioRDVMnLBRgNidKVH5HWlYmJ0MwO3JKAihBWl11','',1,'2024-09-20 11:25:30'),(2,'Ub21b0bbb781bcdafe80a50b39d5b3746','parn','https://profile.line-scdn.net/0h-CHM8ashcmx1NFvyP8sNO0lxfAECGnQkDVA1CFhkK1oKV2FpTwE6X1RneAhQVjc-G1o9XQM9KFwM','',NULL,'2024-09-20 16:15:49');
/*!40000 ALTER TABLE `user_line` 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-26 21:36:48

📁 Sid Gifari File Manager