Da

✏️ Editing: nrrudorm_easycontr_db.sql

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

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

USE `nrrudorm_easycontr_db`;

--
-- Table structure for table `branch_contracts`
--

DROP TABLE IF EXISTS `branch_contracts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `branch_contracts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contract_id` int(11) NOT NULL,
  `clinic_code` varchar(15) NOT NULL,
  `clinic_name` varchar(100) NOT NULL,
  `install_date` date NOT NULL,
  `live_date` date NOT NULL,
  `remark` text DEFAULT NULL,
  `status` enum('Y','N') DEFAULT 'Y',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `branch_contracts`
--

LOCK TABLES `branch_contracts` WRITE;
/*!40000 ALTER TABLE `branch_contracts` DISABLE KEYS */;
INSERT INTO `branch_contracts` VALUES (1,1,'DEMO','ดีโม คลินิก','2022-01-19','2022-01-19','','Y',NULL,'2022-01-19 13:54:45',NULL,'2022-01-19 15:01:04'),(2,2,'wandeeKK','วันดีคลินิกขอนแก่น','2022-01-28','2022-01-28','','Y',NULL,'2022-01-27 07:49:25',NULL,'2022-01-27 07:48:39'),(3,2,'wandeeUD','วันดีคลินิกอุดรธานี','2022-01-28','2022-01-28','','Y',NULL,'2022-01-28 03:20:05',NULL,'2022-01-28 03:28:56'),(4,3,'thicha101','Thicha Clinic ร้อยเอ็ด','2022-06-10','2022-06-10',NULL,'Y',1,'2022-06-10 11:19:52',1,'2022-06-10 11:23:18'),(5,4,'magnolia','Magnolia Bangkok Center','2022-06-21','2022-06-22','-','Y',1,'2022-06-21 04:35:26',NULL,'2022-06-21 04:35:26'),(6,5,'YUWARAT','YUWARAT CLINIC','2022-07-13','2022-07-15',NULL,'Y',1,'2022-07-08 02:34:13',1,'2022-07-13 08:45:13'),(7,2,'wandeeHK','วันดีคลินิกหอกาญ','2022-08-06','2022-08-06','wandeehk_db\r\nwandeehk/11*C2sbc9','Y',1,'2022-08-06 01:04:36',NULL,'2022-08-06 01:04:36'),(8,6,'FYclinic','FY clinic','2022-09-01','2022-09-02',NULL,'Y',1,'2022-09-01 09:10:49',NULL,'2022-09-01 09:10:49'),(9,7,'ravisclinic','รวิช คลินิก','2022-09-20','2022-09-21','ravisclinic_db\r\nravisclinic_root / 2_Hzg288r\r\n\r\nravisclinic_master_db\r\nravisclinic_master / Jd7tt88%8','Y',1,'2022-09-19 06:52:17',1,'2022-09-26 03:39:27'),(10,8,'Orgasm','Orgasm beauty center','2022-10-05','2022-10-05',NULL,'Y',1,'2022-10-05 03:00:50',NULL,'2022-10-05 03:00:50'),(11,9,'PWclinic','PW Clinic','2022-10-06','2022-10-07',NULL,'Y',1,'2022-10-06 08:10:34',1,'2022-10-06 08:11:27'),(12,10,'prime','Prime Clinic','2022-11-02','2022-11-03',NULL,'Y',1,'2022-11-02 02:47:56',1,'2022-11-02 03:35:09'),(13,2,'wandeeBKK','วันดีคลินิกกรุงเทพ','2022-11-18','2022-11-18','wandeebkk_db\r\nwandeebkk_root / Ucar065_5','Y',1,'2022-11-18 02:20:40',1,'2022-11-18 03:22:36'),(14,11,'MyLifeClinic','My Life Clinic','2022-12-08','2022-12-10','MyLifeClinic\r\nop5!6MV@C!88','Y',1,'2022-12-08 09:06:38',1,'2022-12-08 10:11:22'),(15,12,'resta_plus','Resta plus clinic','2023-01-04','2023-01-05',NULL,'Y',1,'2023-01-04 08:17:35',NULL,'2023-01-04 08:17:35'),(16,2,'wandeeCBI','วันดีคลินิกพัทยา','2023-01-31','2023-01-31','wandeecbi_db\r\nwandeecbi_root /  J0s_4j35j','Y',1,'2023-01-23 04:24:04',1,'2023-01-23 08:05:51'),(17,13,'dermistclinic','เดอมิสท์คลินิก','2023-02-03','2023-02-03',NULL,'Y',1,'2023-02-03 03:02:33',NULL,'2023-02-03 03:02:33'),(18,14,'LALADA','ลลดาคลินิกเวชกรรม','2023-09-03','2023-09-03',NULL,'Y',1,'2023-09-03 02:22:54',1,'2023-09-03 02:26:14');
/*!40000 ALTER TABLE `branch_contracts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contracts`
--

DROP TABLE IF EXISTS `contracts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contracts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_key` varchar(50) NOT NULL,
  `contract_name` varchar(100) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `tax_id` varchar(50) DEFAULT NULL,
  `sale_date` date DEFAULT NULL,
  `remark` text DEFAULT NULL,
  `exprie` date NOT NULL,
  `package` varchar(20) NOT NULL DEFAULT '',
  `user_quota` int(11) NOT NULL DEFAULT 0,
  `branch_quota` int(11) NOT NULL DEFAULT 0,
  `status` enum('Y','N') DEFAULT 'Y',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contracts`
--

LOCK TABLES `contracts` WRITE;
/*!40000 ALTER TABLE `contracts` DISABLE KEYS */;
INSERT INTO `contracts` VALUES (1,'WVLEA-2N3HY-AW2EX-L24Q5','ดีโม่ คลินิก จำกัด มหาชน','สุรชัย','ลุนสำโรง','0857516129','demo@gmail.com','122/22','0000000000000','2022-01-19','*สำหรับทดลองใช้','2023-12-19','ECONOMY',500,1,'Y',NULL,'2022-01-19 11:39:56',1,'2023-01-17 09:01:19'),(2,'WANDEE-00001-9999-8888','หจก. วันดีคลินิก','คณิต','ภาโสม','0613693556','wandeeclinic@gmail.com','344/17 ซอยรื่นรมย์ ต.ในเมือง อ.เมือง ขอนแก่น 40000','097-935-5556','2022-01-27','-','2023-12-04','PREMIUM',200,6,'Y',NULL,'2022-01-27 07:47:32',1,'2022-11-18 02:19:55'),(3,'NRFNB-032N3-4WE7V-AHVST-HLE5A','Thicha clinic','วัชรินทร์','แก้วม่วง','0933883555','watcharin_kaewmoung@hotmail.com',NULL,'0','2022-06-10','จ่ายราคา 17,000 ขอใช้งาน 1 สาขา\r\nDB_DATABASE=thicha_db\r\nDB_USERNAME=thicha_root\r\nDB_PASSWORD=Q08miv8_8\r\n\r\nDB_DATABASE_SECOND=thicha_master_db\r\nDB_USERNAME_SECOND=thicha\r\nDB_PASSWORD_SECOND=x!d32cU13','2023-06-12','STANDARD',30,1,'Y',1,'2022-06-10 11:18:29',1,'2022-07-08 03:47:02'),(4,'20ZIO-BVZ3G-AO5XF-QEU1R-ODMIB','Magnolia Bangkok Center','ยู','-','0832324542','example@example.com',NULL,NULL,'2022-06-21','1 สาขา\r\nราคา 17,000 + Vat 1,190 = 18,190\r\nเครื่องสแกน 2285\r\nรวมเครื่องสแกน 20,475 บาท\r\nโปรแถม 2 เดือน\r\nmagnolia_db\r\nmagnolia/@5o04gsH0\r\nmagnolia_master_db\r\nmagnolia_master/@5o04gsH0','2023-10-25','STANDARD',30,1,'Y',1,'2022-06-21 04:32:24',1,'2022-08-03 03:53:23'),(5,'4MFOB-IAPOT-B33EF-LJB2B-CMVMB','YUWARAT CLINIC','สุรพงษ์','เลียบใย','0843985525','yuwarat.group@gmail.com','YUWARAT CLINIC\r\nNo. 77, Toenayar Housing, Sansai(B) Quarter, Tachileik, Myanmar\r\nTel : 09699939888 , 09699979888 (Myanmar)\r\nTel : 0843985525 (Thai)',NULL,'2022-07-13','clinic1_db\r\nclinic1 / 9Z!6c0e5r\r\n\r\nclinic1_master_db\r\nclinic1_master / p7O2f*g77','2023-07-15','ECONOMY',15,1,'Y',1,'2022-07-08 02:31:10',1,'2022-07-13 09:12:45'),(6,'J96PV-VLPDA-9H5EQ-NSB7I-XWFXV','FY clinic','กมณฑ์เทพ','วรรณา','0642959995','doctorkie789@gmail.com',NULL,NULL,'2022-09-01','-Economy 1 ปี: 12,900 บาท\r\n*Vat. 7%: 903 บาท\r\n-เครื่องแสกนบัตร 2,485 บาท\r\n\r\nรวมชำระ 16,288 บาท\r\n\r\nfyclinic_db\r\nfyclinic_admin / d@N5s24v5\r\n\r\nfyclinic_master_db\r\nfyclinic_master / c4wAq_040','2023-09-02','ECONOMY',15,1,'Y',1,'2022-09-01 09:10:15',1,'2022-09-01 09:29:39'),(7,'72RW1-UHHHY-AJCOW-MJJFY-DTBLN','รวิชคลินิก','คุณผักกาด','-','082-362-6619','Nuttakanburdok2@gmail.com','คุณผักกาด 0659652698\r\n\r\nบริษัท บีเอชดับบลิว โกลบอล จำกัด\r\nสำนักงานใหญ่ ที่อยู่ 66/126 ถนนพหลโยธิน แขวงอนุสาวรีย์ เขตบางเขน กรุงเทพมหานคร 10220\r\n\r\nเลขประจำตัวผู้เสียภาษี 0105565123231','0105565123231','2022-09-19','- Standard 1 ปี: 19,900 บาท\r\n*Vat. 7%: 1,393 บาท\r\n\r\nรวมชำระ 21,293 บาท\r\n\r\nต่ออายุลดแพ็จเกจ\r\n- ECONOMY 1 ปี: 12,900 บาท  / 14 เดือน\r\n*Vat. 7%: 903 บาท\r\n\r\nรวมชำระ 13,803 บาท','2024-11-17','STANDARD',30,1,'Y',1,'2022-09-19 06:49:11',1,'2023-10-18 06:31:26'),(8,'IQYL3-SQY7K-P4DBU-YVV1X-UL6ON','Orgasm beauty center','Orgasm','beauty center','0612391592','example@example.com','Orgasm beauty center\r\nสปป.ลาว เมืองสะหวันเขต\r\n0612391592',NULL,'2022-10-05','orgasm_db\r\norgasm_root / u0t6!a3W7\r\n\r\norgasm_master_db\r\norgasm_master / K2kt18i!7','2023-10-10','ECONOMY',15,1,'Y',1,'2022-10-05 03:00:09',1,'2022-10-05 07:00:41'),(9,'BHMLC-5A0IU-SHU2F-C2ZD5-U1JOY','พีดับบลิว4289','วุฒิ','-','0623263923',NULL,'คลินิก : PW Clinic\r\nที่อยู่ : 51/2-3 ม.9 (ข้างโรบินสันกาญจนบุรี) ต.ปากแพรก อ.เมือง จ.กาญจนบุรี 71000','0715564002401','2022-10-06','pwclinic_db\r\npwclinic_root  /  y5g84lX!1\r\n\r\npwclinic_master_db\r\npwclinic_master /  Y7v_5w7z2','2023-12-12','ECONOMY',15,1,'Y',1,'2022-10-06 04:25:03',1,'2022-10-06 09:54:43'),(10,'MIEZN-GLKYT-BJH1C-1ZH0X-2ZTJG','บริษัท ไฟร์ม คลินิก 2022 จำกัด','ไฟร์ม คลินิก','-','0858255646','Prime.clinichuahin@gmail.com','10/119 ซอยหมู่บ้านหัวนา  ตำบลหนองแก อำเภอหัวหิน จังหวัดประจวบคีรีขันธ์ 77110','0775565003982','2022-11-02','prime_db\r\nprime_root / 9Yn0nm$78\r\n\r\nprime_master_db\r\nprime_master / m_Ma9516r','2024-12-11','ECONOMY',15,1,'Y',1,'2022-11-02 02:31:10',1,'2023-10-18 06:30:31'),(11,'SPMRL-5JUVP-SH7CX-0NOVM-JOUZC','My Life clinic','My Life clinic','-','095-579-7871',NULL,'297/1 ถนนราชสีมา แขวงดุสิต เขตดุสิต กทม 10300',NULL,'2022-12-08','mylifeclinic_db\r\nmylifeclinic_root / 7rya9!3B4\r\n\r\nmylifeclinic_master / H7mtb11$3','2023-12-10','STANDARD',30,1,'Y',1,'2022-12-08 08:44:08',1,'2022-12-08 09:38:33'),(12,'PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','Resta plus clinic','อภิญญา','พงศ์พจมาน','0934932965','Drumbellapy01@gmail.com','251/97, หมู่ 5 ตำบล บ้านกรด อำเภอบางปะอิน จังหวัดพระนครศรีอยุธยา 13160',NULL,'2023-01-04',NULL,'2024-01-10','ECONOMY',15,1,'Y',1,'2023-01-04 08:16:16',1,'2023-01-04 08:54:38'),(13,'Y0OH0-ANTIB-ES6T1-VBE7H-PSUWG','บริษัท เดอมิสท์คลินิก จำกัด','เดอมิสท์คลินิก','-','099-0863855','dermistclinic@gmail.com','199/8-9 ถ.บรมไตรโลกนารถ2 (ถนนคนเดิน) ต.ในเมือง อ.เมือง จ.พิษณุโลก 65000','0655563002271','2023-02-03','dermistclinic_db\r\ndermistclinic_root / 11qe9sW@7\r\n\r\ndermistclinic_master_db\r\ndermistclinic_master / M@5q1g5y0','2024-02-06','STANDARD',30,2,'Y',1,'2023-02-03 02:46:14',1,'2023-02-03 06:41:06'),(14,'F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','บิส เวลเนส จำกัด','ทัศนา','ประวิเศษ','081-242-9659',NULL,'0956145255\r\ntassana.pra@gmail.com','0105566160335','2023-09-03',NULL,'2024-09-05','ECONOMY',15,1,'Y',1,'2023-09-03 02:21:31',NULL,'2023-09-03 02:21:31');
/*!40000 ALTER TABLE `contracts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_identities`
--

DROP TABLE IF EXISTS `user_identities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_identities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `loginname` varchar(100) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(200) NOT NULL,
  `tel` varchar(200) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `nickname` varchar(50) DEFAULT NULL,
  `sex` varchar(6) DEFAULT NULL,
  `remark` mediumtext DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `role` varchar(50) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT 'Y',
  `expire` date DEFAULT NULL,
  `product_key` varchar(100) DEFAULT NULL,
  `token_access` varchar(300) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginname` (`loginname`,`product_key`)
) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_identities`
--

LOCK TABLES `user_identities` WRITE;
/*!40000 ALTER TABLE `user_identities` DISABLE KEYS */;
INSERT INTO `user_identities` VALUES (5,'Minkmaster','Minkmaster@hotmail.com',NULL,'96e79218965eb72c92a549dd5a330112','0613693556','Mink','master','-','ชาย',NULL,'XzE2MzYwODI1OTE=1_5.jfif','MANAGER','Y','2024-12-10','WANDEE-00001-9999-8888','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJodHRwczovL2V4YW1wbGUuYXV0aDAuY29tLyIsImF1ZCI6Imh0dHBzOi8vYXBpLmV4YW1wbGUuY29tL2NhbGFuZGFyL3YxLyIsInN1YiI6InVzcl8xMjMiLCJpYXQiOjE0NTg3ODU3OTYsImV4cCI6MTQ1ODg3MjE5Nn0.CA7eaHjIHz5NxeIJoFK9krqaeZrPLwmMmgI_XiQiIkQ',NULL,NULL,'2022-11-29 07:14:59'),(6,'admin1','chaikhonkaen@gmail.com',NULL,'abef9c1832dcc72491cd9b206cfbbf74','0857516129','สุรชัย','Administrator','-','ชาย','x','XzE2MTk1ODExNDY=1_6.jpg','ADMIN','Y','2025-12-08','WANDEE-00001-9999-8888','d93d9672-e3a4-11e7-80c1-9a214cf093ae',NULL,'2021-02-09 13:44:08','2023-09-04 10:34:58'),(7,'demo1',NULL,NULL,'81dc9bdb52d04dc20036dbd8313ed055',NULL,'DEMO 1','-',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2024-11-28','WVLEA-2N3HY-AW2EX-L24Q5','35a6befffad715425ef7fae8c57d106f',NULL,'2022-12-01 04:41:29','2023-10-22 10:56:15'),(8,'demo2',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'DEMO 2','-',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2024-06-26','WVLEA-2N3HY-AW2EX-L24Q5','c0df3732c814e54ac4a5234f558f9abc',NULL,'2022-12-01 07:34:54','2022-12-01 07:39:08'),(9,'Vatchareeporn05@gmail.com','example@example.com',NULL,'39377ab7252a782934e0956525cfed3a',NULL,'วัชรีภรณ์','-',NULL,'หญิง','วัชรีภรณ์ ไวยบุตรี \r\nVatchareeporn05@gmail.com\r\n0955651142',NULL,'EMPLOYEE','Y','2022-12-31','WVLEA-2N3HY-AW2EX-L24Q5','b7fae5733832593e89f0188c8f90275d',NULL,'2022-12-02 12:42:38','2022-12-02 12:42:38'),(10,'Nanntsvip@gmail.com','example@example.com',NULL,'9327778b88deb64951710e8c51ffef9d',NULL,'ธนวรรณ','-',NULL,'หญิง','ธนวรรณ สุขแก้ว\r\n0654234719\r\nNanntsvip@gmail.com',NULL,'EMPLOYEE','Y','2022-12-31','WVLEA-2N3HY-AW2EX-L24Q5','45ebb6b13552a652d13b139827f763e0',NULL,'2022-12-02 13:12:40','2022-12-02 13:12:40'),(11,'wanvisatas@gmail.com','example@example.com',NULL,'f12c2b51df5d7465bf770cdfb84d888a',NULL,'วันวิสา','-',NULL,NULL,'ทัศศรี 0869462002',NULL,'EMPLOYEE','Y','2022-12-31','WVLEA-2N3HY-AW2EX-L24Q5','0f751a31758c66da998c36e88693ba22',NULL,'2022-12-03 11:10:49','2022-12-03 11:10:49'),(12,'royaljackyzz@gmail.com','example@example.com',NULL,'56bb3c101a87f9aef05e3af5bb04458f',NULL,'Ekaxay','-',NULL,'ชาย','Ekaxay Souksomboun , 0959939876 , royaljackyzz@gmail.com',NULL,'EMPLOYEE','Y','2022-12-31','WVLEA-2N3HY-AW2EX-L24Q5','09322ec913c630f74f7a083fada58c71',NULL,'2022-12-05 01:36:24','2022-12-05 01:36:24'),(13,'Phongsarun5@gmail.com','example@example.com',NULL,'0f0f683ec5ed9866c2d63e425f71c652',NULL,'พงศ์ศรัณย์','-',NULL,'ชาย','0932929898',NULL,'EMPLOYEE','Y','2022-12-30','WVLEA-2N3HY-AW2EX-L24Q5','9baa50fcc6854c8395a7271d3ec71a57',NULL,'2022-12-06 06:30:32','2022-12-06 06:30:32'),(14,'admin.wandee','chaikhonkaen@gmail.com',NULL,'96e79218965eb72c92a549dd5a330112','0857516129','สุรชัย','Administrator',NULL,'ชาย',NULL,NULL,'ADMIN','Y','2025-12-08','WANDEE-00001-9999-8888','3f064c82c96f2ba5f55d66a57fdd90a0',NULL,'2022-12-08 03:52:25','2022-12-08 03:52:25'),(15,'MyLifeClinic','example@example.com',NULL,'ecdb7e40ff212c064f1ac8417e8053a8',NULL,'MyLifeClinic','-',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2023-12-10','SPMRL-5JUVP-SH7CX-0NOVM-JOUZC','b4c2e83a1639f3cf196d7bad2f85dabe',NULL,'2022-12-08 16:53:47','2022-12-08 16:55:09'),(16,'asst.wandeeKK9','example@example.com',NULL,'b4ce287b11c84fd40c70368d04e4405d',NULL,'บวรลักษณ์','วิบูลย์ศิลป์',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-11-30','WANDEE-00001-9999-8888','54daa75ba13ce74b5f2e6f1acac0aab2',NULL,'2022-12-09 06:38:37','2022-12-09 11:15:14'),(17,'sales.wandeeKK18','example@example.com',NULL,'cc486f8a9a363e60f3559405c0c9f528',NULL,'รมย์รัมภา','อินอ่อน',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-11-16','WANDEE-00001-9999-8888','ef379389edb7ee9db10d7cbaa28ed275',NULL,'2022-12-09 06:39:59','2022-12-09 06:39:59'),(18,'sales.wandee1','example@example.com',NULL,'96e79218965eb72c92a549dd5a330112',NULL,'กุลธิดา','แก้วเมืองกลาง',NULL,'หญิง',NULL,NULL,'SALES','Y','2025-12-08','WANDEE-00001-9999-8888','fb6bf6fb2e2f1154626d3605d791761a',NULL,'2022-12-09 07:11:22','2022-12-09 07:11:22'),(19,'asst.wandee2','example@example.com',NULL,'96e79218965eb72c92a549dd5a330112',NULL,'สุพัตรา','ต้นกันยา',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2025-12-08','WANDEE-00001-9999-8888','a96cbaaa3a9de4b1d7750093f3d2900f',NULL,'2022-12-09 07:11:34','2022-12-09 07:11:34'),(20,'sales.wandee2','example@example.com',NULL,'42202e272aef9a2171c3aed3fbdc705d',NULL,'สุพิชญ์ชญา','ธรรมมา',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2025-12-08','WANDEE-00001-9999-8888','2f803c5c10091c261081a3f13ebe6998',NULL,'2022-12-09 07:11:45','2022-12-09 07:11:45'),(21,'admin1.wandee','example@example.com',NULL,'96e79218965eb72c92a549dd5a330112','-','มนทนา','บุบผาเทพ',NULL,'หญิง',NULL,NULL,'SALES','Y','2025-12-08','WANDEE-00001-9999-8888','6e3d02f13b3e864a38eb112c78d2d601',NULL,'2022-12-09 07:14:57','2022-12-09 07:14:57'),(22,'cat.wandee','example@example.com',NULL,'1461c111791cd86c22d8a8a28634e4e0',NULL,'อังคณา','นิสัญตา',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2025-12-08','WANDEE-00001-9999-8888','56ec1b56480820a947e536d869258ee9',NULL,'2022-12-09 07:15:00','2022-12-09 07:15:00'),(23,'sales.wandee4','fam.wirasinee@hotmail.com',NULL,'96e79218965eb72c92a549dd5a330112','0850095085','วิลาสินี','ไพรัชการนันท์',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2025-12-08','WANDEE-00001-9999-8888','63c9daac88b7ae506b27cc8bd29e61e7',NULL,'2022-12-09 07:15:04','2022-12-09 07:15:04'),(24,'sales.wandee5',NULL,NULL,'21218cca77804d2ba1922c33e0151105',NULL,'จิราพร','ไชยราช',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-06-28','WANDEE-00001-9999-8888','d08625c5b5d34ca35cf8ad495017c9a9',NULL,'2022-12-09 07:15:08','2022-12-09 07:15:08'),(25,'asst.wandeeKK',NULL,NULL,'52c69e3a57331081823331c4e69d3f2e',NULL,'ปริมสุภา','นามมา',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-06-30','WANDEE-00001-9999-8888','25aaf4b54220c07d3b89f92dc72208d7',NULL,'2022-12-09 07:15:11','2022-12-09 07:15:11'),(26,'admin3.wandee',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'สุนิสา','ไชยจงมี',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-07-28','WANDEE-00001-9999-8888','432d53f1343678471b42eef904baf0b6',NULL,'2022-12-09 07:15:15','2022-12-09 07:15:15'),(27,'asst.wandeeKK6',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'อภิญา','จันทร์รักษ์',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-10-30','WANDEE-00001-9999-8888','720e44a989e1af7d52c737e8e815910e',NULL,'2022-12-09 07:15:21','2022-12-09 07:15:21'),(28,'sales.wandeeKK7',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'วรรณภา','ศรีหลัก',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-02-28','WANDEE-00001-9999-8888','1db72e316f1797347c5454ba8321cc90',NULL,'2022-12-09 07:15:25','2022-12-09 07:15:25'),(29,'fern',NULL,NULL,'8ddcff3a80f4189ca1c9d4d902c3c909',NULL,'จารุมาศ','พลทองสถิตย์',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2023-01-08','WANDEE-00001-9999-8888','bb7ec56d8cb471447b78d94eb36ab7d3',NULL,'2022-12-09 07:15:29','2022-12-09 07:15:29'),(30,'sales.wandeeKK9',NULL,NULL,'52c69e3a57331081823331c4e69d3f2e',NULL,'ปรียาณัฐ','พรมทา',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-10-25','WANDEE-00001-9999-8888','a50db78423390c71707967679d1f31e8',NULL,'2022-12-09 07:15:33','2022-12-09 07:15:33'),(31,'sales.wandeeKK10',NULL,NULL,'ca3cb1cf7364e2cd6801dce08befd644',NULL,'ฉัตรปวีณ์','ญานศิริ',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-06-21','WANDEE-00001-9999-8888','492757fb4875d5c17fd06f6d4a45c3bc',NULL,'2022-12-09 07:15:37','2022-12-09 07:15:37'),(32,'accounting_4',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'อังษฎา','สีพจน์',NULL,'หญิง',NULL,NULL,'ADMIN','Y','2024-12-03','WANDEE-00001-9999-8888','2a522db414ce3c4f93a3c8ccf85d32cf',NULL,'2022-12-09 07:15:40','2022-12-09 07:15:40'),(33,'asst.wandeeUD6',NULL,NULL,'dc0fa7df3d07904a09288bd2d2bb5f40',NULL,'หญิงตระการ','แก้วคำ',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-05-31','WANDEE-00001-9999-8888','834c5112d441c58100cd356f1c94037b',NULL,'2022-12-09 07:15:46','2022-12-09 07:15:46'),(34,'sales.wandeeKK14',NULL,NULL,'e10adc3949ba59abbe56e057f20f883e',NULL,'วิยะดา','นาเมืองรักษ์',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-03-15','WANDEE-00001-9999-8888','e6a00bbc70a41ad23c73613ef02f2662',NULL,'2022-12-09 07:15:49','2022-12-09 07:15:49'),(35,'sales.wandeeKK16','oonammmmmoo@gmail.com',NULL,'21218cca77804d2ba1922c33e0151105',NULL,'สิริลักษณ์','โสระเวช',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-11-28','WANDEE-00001-9999-8888','99305e20b96e77ae6290d6f8bd645818',NULL,'2022-12-09 07:15:53','2022-12-09 07:15:53'),(36,'sales.wandeeUD4',NULL,NULL,'5b1b68a9abf4d2cd155c81a9225fd158',NULL,'สุกัญญา','-',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-11-23','WANDEE-00001-9999-8888','cafa37fde5b9525c34d25c87d41c0a58',NULL,'2022-12-09 07:15:57','2022-12-09 07:15:57'),(37,'admin4.wandee',NULL,NULL,'21218cca77804d2ba1922c33e0151105',NULL,'ชนาธิป','ภูดินแดน',NULL,'ชาย',NULL,NULL,'SALES','Y','2023-03-30','WANDEE-00001-9999-8888','7a6e252523bae46a3d139e8955fa5d13',NULL,'2022-12-09 07:16:00','2022-12-09 07:16:00'),(38,'sales.wandeeHK1',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'รัชนีกร','พันธ์โยศรี',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-06-25','WANDEE-00001-9999-8888','897b4f6691884a3d73d236258eb7b59c',NULL,'2022-12-09 07:16:04','2022-12-09 07:16:04'),(39,'asst.wandeeKK8',NULL,NULL,'be2f0c49c439a23cd8667b923aadcc23',NULL,'รัตติยาภรณ์','พานา',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-06-27','WANDEE-00001-9999-8888','80361736b7a8a5fca64c7d5e599c8232',NULL,'2022-12-09 07:16:07','2022-12-09 07:16:07'),(40,'asst.wandeeUD8',NULL,NULL,'2634071b60415a903d660443a5573f38',NULL,'จันทร์จ้าว','จันทร์จิรา',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-06-01','WANDEE-00001-9999-8888','e356bcadf6b960d78e8e1e3abb4fd3f2',NULL,'2022-12-09 07:16:10','2022-12-09 07:16:10'),(41,'asst.wandeeUD9','example@example.com',NULL,'96e79218965eb72c92a549dd5a330112',NULL,'อภิญญา','-',NULL,'หญิง','น้องเอิร์น อภิญญา ผชพ UD',NULL,'DOCTORASSI','Y','2023-10-31','WANDEE-00001-9999-8888','b78387822abc6b7dd6e7dc18dc585ca8',NULL,'2022-12-09 07:16:14','2022-12-09 07:16:14'),(42,'asst.wandeeBKK1','example@example.com',NULL,'5f793b7851db948d53e78c338bb6a4ff',NULL,'ผุสดี (ก้อย)','นามวิเศษ',NULL,'หญิง',NULL,NULL,'DOCTORASSI','N','2023-11-01','WANDEE-00001-9999-8888','35abc68c589923bc7c0347dc5c42a42d',NULL,'2022-12-09 07:16:17','2023-02-01 06:44:03'),(43,'asst.wandeeBKK2','example@example.com',NULL,'406518c0593fdd5ef5f19f41fb512703',NULL,'สุขฤทัย','สายปะละ(เอี้ยง)',NULL,'หญิง',NULL,NULL,'DOCTORASSI','N','2023-11-15','WANDEE-00001-9999-8888','5ebebf670d60b421c8477a9411938b2a',NULL,'2022-12-09 07:16:19','2023-02-01 06:44:15'),(44,'dr.wandeeBKK1','example@example.com',NULL,'cd98b5aec9c5bdcec9b42752133ddacf',NULL,'อมลวรรณ','เพียงเกษ',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2025-12-17','WANDEE-00001-9999-8888','125f86c6d049cbb547eed8a3c0e15d85',NULL,'2022-12-09 07:16:22','2022-12-09 07:16:22'),(45,'sales.wandee6','example@example.com',NULL,'4b320c5377ecedff9172554d0c610a89',NULL,'นิภาวัล','ชาติราษี',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-11-29','WANDEE-00001-9999-8888','84bc9e4a838745e938a5aa47d4ce7cd2',NULL,'2022-12-09 07:16:25','2022-12-09 07:16:25'),(46,'dr.wandeeKK17',NULL,NULL,'21218cca77804d2ba1922c33e0151105',NULL,'นวพล','ลิมป์ทวีชัย',NULL,'ชาย',NULL,NULL,'DOCTOR','Y','2022-12-28','WANDEE-00001-9999-8888','1bc3176a080e1047d60c9653599954e7',NULL,'2022-12-09 07:17:03','2022-12-09 07:17:03'),(47,'khaun_pr@hotmail.com','example@example.com',NULL,'3fd3e72992b29dffc82f57bae168f288',NULL,'ขวัญฟ้า','-',NULL,'ชาย','ขวัญฟ้า  0891865898',NULL,'EMPLOYEE','Y','2022-12-31','WVLEA-2N3HY-AW2EX-L24Q5','717ec0606399fe4a14824be436631424',NULL,'2022-12-14 07:16:22','2022-12-14 07:18:16'),(48,'asst.wandeeUD10','example@example.com',NULL,'96e79218965eb72c92a549dd5a330112',NULL,'ชฎาพร','-',NULL,'หญิง','รบกวนพี่ชัยเพิ่ม\r\nน้องฟ้า ชฎาพร ตำแหน่งผู้ช่วยแพทย์ในระบบนะคะ',NULL,'DOCTORASSI','N','2023-12-17','WANDEE-00001-9999-8888','57efff02bc865c0fa9cb36886941a0ec',NULL,'2022-12-17 11:41:05','2023-01-25 03:45:31'),(49,'nuamanp@hotmail.com',NULL,NULL,'076c7381c7e32f467ef4e32995298aac',NULL,'นุอมาน','-',NULL,NULL,'- ชื่อ นุอมาน\r\n- 0817016799\r\n- nuamanp@hotmail.com',NULL,'EMPLOYEE','Y','2022-12-31','WVLEA-2N3HY-AW2EX-L24Q5','022bff264ed9733cfa77ad2c49b507b0',NULL,'2022-12-17 12:39:02','2022-12-18 12:28:32'),(50,'kitrawee.ru@bdms.co.th','example@example.com',NULL,'ca100004003f1618645eadc0ed69bad8',NULL,'kitrawee','-',NULL,'หญิง','(right)0909133614\r\n(right)',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','4742a31de7ea25e27b36edf2307ec6b2',NULL,'2022-12-19 05:08:58','2023-01-06 07:27:31'),(51,'golfers.gts@gmail.com','example@example.com',NULL,'6c029acc7bf9190e0337d65b074b2e9d',NULL,'ธีระพงษ์','-',NULL,'ชาย','ธีระพงษ์ 0832324694',NULL,'EMPLOYEE','Y','2023-01-06','WVLEA-2N3HY-AW2EX-L24Q5','c723f229cd763a625781b50e06c6fc93',NULL,'2022-12-19 08:43:14','2022-12-19 08:43:14'),(52,'Benyapa.msc@gmail.com','example@example.com',NULL,'305d7e1e0bd92c30765814accaa0d8d7',NULL,'เบญญาภา','-',NULL,NULL,'เบญญาภา เสนารัตน์\r\n0836662955\r\nBenyapa.msc@gmail.com',NULL,'EMPLOYEE','Y','2023-01-06','WVLEA-2N3HY-AW2EX-L24Q5','08987802e6482257250ce4a8adaefd06',NULL,'2022-12-20 07:43:27','2022-12-20 07:43:27'),(53,'dr.wandeeKK19',NULL,NULL,'288e0fbde4b2d41447ac6375799aecf2',NULL,'พญ.จิราพร','จินดาศิริตระกูล(หมอติ๊ก)',NULL,'หญิง','แพทย์พาททาม KK1',NULL,'DOCTOR','Y','2023-12-23','WANDEE-00001-9999-8888','0a0038c26bcffe915205ec645d01f4cb',NULL,'2022-12-23 10:25:31','2022-12-23 10:25:31'),(54,'resta_plus','example@example.com',NULL,'c9e3dd0faf537d7acf69d51fd6d2a833',NULL,'resta_plus','-',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2024-01-10','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','2d2b29bfb563232db2655ff96b872f0f',NULL,'2023-01-04 15:56:26','2023-09-01 10:29:35'),(55,'cclever.clinic@gmail.com','example@example.com',NULL,'3d286d51f370d82847d9bdb7498db5dd',NULL,'ธนากร','-',NULL,'ชาย','ธนากร 0625855596 cclever.clinic@gmail.com',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','5dc41080fe97e13b3efafde5e8c217ec',NULL,'2023-01-05 01:40:27','2023-01-05 01:40:27'),(56,'jpatlidanon@gmail.com','example@example.com',NULL,'065a5a872abc205310eb6e31d26ed2c5',NULL,'Nui Jutima','-',NULL,'หญิง','0839153639',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','5740bcd9302e704a7abfa973128cf9d4',NULL,'2023-01-06 11:53:24','2023-01-06 11:53:24'),(57,'sakeerin1@gmail.com','example@example.com',NULL,'c03fac17d73c25cb29eb7ae61ee96a2c',NULL,'กฤษดา','-',NULL,NULL,'ศิริ\r\n0881823421\r\nsakeerin1@gmail.com',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','5d8326fc10d1b06e9b7f1a1b9ca1dbcd',NULL,'2023-01-09 08:01:09','2023-01-09 08:01:09'),(58,'Lalita_Ls@hotmail.com','example@example.com',NULL,'9d17e2c80828b2f28bd590948dab81c8',NULL,'May','-',NULL,'หญิง','094-5265626',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','3bc8d57a8a6f576b6b23030f2dd8ed4d',NULL,'2023-01-10 02:28:59','2023-01-10 02:28:59'),(59,'Lingzpanyakarn@gmail.com','example@example.com',NULL,'9f38e675b5cc308a68c523963e62acf7',NULL,'ปัญญากาญจน์','-',NULL,'ชาย','ปัญญากาญจน์\r\n0986074527\r\nLingzpanyakarn@gmail.com',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','3c3f18e0010a33149b9bd7047f8dbf22',NULL,'2023-01-11 03:50:41','2023-01-11 03:50:41'),(60,'Dermistclinic@gmail.com','example@example.com',NULL,'2f53ba0af062438c45b0e7560e19f179',NULL,'กชพร','-',NULL,'หญิง','เบอร์โทร 099-0863855 E-mail',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','b8cc49ed26f8a50bc517182693b6ef29',NULL,'2023-01-11 04:59:30','2023-01-11 04:59:30'),(61,'nik.thanakorn.c@gmail.com','example@example.com',NULL,'232d9b9aa371fb400436d9ba0d811ca8',NULL,'ธนกร','-',NULL,'ชาย','ชื่อ ธนกร ฉัตรบวรยศธร\r\nเบอร์ 083-457-7799\r\nnik.thanakorn.c@gmail.com',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','8fc3ab526ac9c64a4cb401cfb64ca6d0',NULL,'2023-01-17 09:47:50','2023-01-17 09:47:50'),(62,'jirattikarn4444@gmail.com','example@example.com',NULL,'b9b14d73ac573747202cbce2f04e3c8a',NULL,'จิรัฐติกาล','-',NULL,'หญิง','ขอยูเซอร์ทดลองใช้โปรแกรม\r\n- จิรัฐติกาล\r\n- 0961488398\r\n- jirattikarn4444@gmail.com',NULL,'EMPLOYEE','Y','2023-10-30','WVLEA-2N3HY-AW2EX-L24Q5','5e76c8c393ec5d80d10fdf7fec1d846e',NULL,'2023-01-18 09:06:31','2023-10-03 09:39:37'),(63,'Info@wincellresearch.com','example@example.com',NULL,'9e26432d0faed2f4e7e44e2140f398c0',NULL,'โอฬาร','-',NULL,'ชาย','โอฬาร\r\nInfo@wincellresearch.com\r\n0818528897',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','78c8367c4941c4a5247c5c48e3a4c18b',NULL,'2023-01-19 07:27:55','2023-01-19 07:27:55'),(64,'v.Kittipit@gmail.com','example@example.com',NULL,'ddc7889089e88d83e9f34663a7b24eb0',NULL,'กิตติพิชญ์','-',NULL,'หญิง','กิตติพิชญ์ วิทยาภัทร์วงศ์ 095-5365539 v.Kittipit@gmail.com',NULL,'EMPLOYEE','Y','2023-02-15','WVLEA-2N3HY-AW2EX-L24Q5','eabc4f8d470ebc7d7ceeb45bd626f22d',NULL,'2023-01-22 03:08:29','2023-01-22 03:08:29'),(65,'nattapach.rat@gmail.com','example@example.com',NULL,'32dbb3d0584547dd48b42c12cdbd2eed',NULL,'ณัฐภัทร','-',NULL,'ชาย',', 0982424474 , nattapach.rat@gmail.com',NULL,'EMPLOYEE','Y','2023-01-31','WVLEA-2N3HY-AW2EX-L24Q5','1384bae198ce89eb9cf897be4bf388bc',NULL,'2023-01-23 02:58:09','2023-01-23 02:58:09'),(66,'namojakkrit@gmail.com','example@example.com',NULL,'ee2762516584b7173b9e850ec2b09411',NULL,'จักรกฤช','-',NULL,'ชาย','จักรกฤช\r\n0980492640\r\nnamojakkrit@gmail.com',NULL,'EMPLOYEE','Y','2023-03-15','WVLEA-2N3HY-AW2EX-L24Q5','385d101aaae4d9983edaf2876bd3c778',NULL,'2023-01-24 09:45:00','2023-01-24 09:45:00'),(67,'issavora.yut@gmail.com','example@example.com',NULL,'71598f5bd9db171701beb0bd4fcd6868',NULL,'แจง','-',NULL,'หญิง','ชื่อ เเจง 0634165926\r\nissavora.yut@gmail.com',NULL,'EMPLOYEE','Y','2023-02-15','WVLEA-2N3HY-AW2EX-L24Q5','4bcbe5b71ad94d95a96e50ceff78f7c1',NULL,'2023-01-24 10:57:18','2023-01-24 10:57:18'),(68,'customer','example@example.com',NULL,'96e79218965eb72c92a549dd5a330112',NULL,'ลูกค้า','LINE Official',NULL,'ชาย',NULL,NULL,'EMPLOYEE','Y','2025-12-08','WANDEE-00001-9999-8888','8db1768c914680b0085c5bb2408f8ca8',NULL,'2023-01-30 13:32:00','2023-01-30 13:32:00'),(69,'sales.wandeeKKU1','example@example.com',NULL,'daf731b2bb2e013dbee69f3c9ee0e9d1',NULL,'ฐิติกา','วงศ์ขันธ์',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-11-30','WANDEE-00001-9999-8888','bb4752965158f32428f16389da01a36d',NULL,'2023-02-01 04:41:02','2023-02-01 08:22:27'),(70,'pty_wandee1',NULL,NULL,'5cb336d9afa99991170f4fd809b15d97',NULL,'เฌอณีช','ชนะรินทร์',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2023-12-27','WANDEE-00001-9999-8888','dfc0d889cf68a28b251b0dced5f600e1',NULL,'2023-02-02 08:00:25','2023-02-03 15:33:30'),(71,'pty_wandee2','example@example.com',NULL,'825f194f6dbf9f1ddd2784f0e397cda6',NULL,'เมย์','คูโบต้า',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-07-12','WANDEE-00001-9999-8888','8ee984902f3c473a8eea35b29c325410',NULL,'2023-02-02 08:01:55','2023-02-03 15:35:35'),(72,'pty_wandee3',NULL,NULL,'96e79218965eb72c92a549dd5a330112',NULL,'พรรัดดา','สำรวจหันต์',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-08-23','WANDEE-00001-9999-8888','567acae39c3891ed5e253cd6ffb203d1',NULL,'2023-02-02 08:02:58','2023-02-04 19:04:54'),(73,'dermistclinic','dermistclinic@gmail.com',NULL,'1a599002ad2f16e60a6bf2afc9c0cf5a',NULL,'dermist','clinic',NULL,NULL,NULL,NULL,'MANAGER','Y','2024-02-08','Y0OH0-ANTIB-ES6T1-VBE7H-PSUWG','f3ef13ade6d4674a9b5248fb61cfe43b',NULL,'2023-02-03 13:36:23','2023-02-03 14:14:46'),(74,'pty_wandee4','example@example.com',NULL,'0052cd50cf01ca1a66c0d363d3058819',NULL,'พัดชา','ศีลี',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2023-12-27','WANDEE-00001-9999-8888','93a542a01d58a9e1be24c1342a2af436',NULL,'2023-02-04 17:27:16','2023-02-07 08:15:21'),(75,'pty_wandee5','example@example.com',NULL,'7b18e159118189239aa0a74fdce95b15',NULL,'ธนธร','ลีลาขจรจิต',NULL,'ชาย',NULL,NULL,'DOCTOR','Y','2023-12-28','WANDEE-00001-9999-8888','734ad33a9248efee8cfa4aa433feefa6',NULL,'2023-02-04 17:28:03','2023-02-04 17:28:03'),(76,'pty_wandee6','example@example.com',NULL,'c8bee4680b95bdd60c689c5f909fb5cc',NULL,'แคนดี้','-',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2023-10-31','WANDEE-00001-9999-8888','ccb61466dffdbede7b03bf1275d046f7',NULL,'2023-02-05 04:56:13','2023-02-07 08:14:48'),(77,'pty_wandee7','example@example.com',NULL,'e0c7b2791a6c5e2cd07f2dc92318e4d2',NULL,'มิ้น','-',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2024-01-31','WANDEE-00001-9999-8888','165a28b4dc82679eb9cdeaa23cf704de',NULL,'2023-02-07 11:32:57','2023-02-07 11:32:57'),(78,'dermist2',NULL,NULL,'6598f6ecc0b6f60fb465f7e883e345d9',NULL,'พญ.ปัทมา','จารีวิษฎ์',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2025-12-31','Y0OH0-ANTIB-ES6T1-VBE7H-PSUWG','2059c7962ae5ff5a9894e15d245b3e26',NULL,'2023-02-08 15:55:19','2023-02-08 15:55:19'),(79,'onuma798@gmail.com',NULL,NULL,'09e416d8097233cbffa59c47b0c0572d',NULL,'ตาล','-',NULL,'หญิง','087-2604425\r\nonuma798@gmail.com',NULL,'EMPLOYEE','Y','2023-02-28','WVLEA-2N3HY-AW2EX-L24Q5','6864d4810f6469fe288da0317990b975',NULL,'2023-02-09 04:57:18','2023-02-09 04:57:18'),(80,'leeming.kb@gmail.com',NULL,NULL,'0f6f28d93f325d4ef8e51b15d7cc5460',NULL,'ครองขวัญ','-',NULL,'หญิง','- ครองขวัญ\r\n- 0953694956\r\n- leeming.kb@gmail.com',NULL,'EMPLOYEE','Y','2023-05-15','WVLEA-2N3HY-AW2EX-L24Q5','1308f794b553c68bc2d35057a3ad4d4b',NULL,'2023-02-09 04:59:10','2023-04-25 06:52:26'),(81,'Tcm0456@gmail.com',NULL,NULL,'bc30f84bccf13a6f843da71d0caeb8ce',NULL,'นพดลยวัฒน์','-',NULL,'ชาย','นพดลยวัฒน์ ศรีเตชะคูวงศ์\r\n0610289946',NULL,'EMPLOYEE','Y','2023-02-28','WVLEA-2N3HY-AW2EX-L24Q5','bf1d2fa702e0ba242aebae24e5ef7f74',NULL,'2023-02-09 12:40:28','2023-02-09 12:40:28'),(82,'kku_dr1','example@example.com',NULL,'2e2fc791f6653e42ffeb71b165901ffc',NULL,'ศินิภา','ปาเลย์',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2024-12-20','WANDEE-00001-9999-8888','6dd368063a9d1583a07a1a9bc3bca7c6',NULL,'2023-02-13 08:01:56','2023-02-13 08:01:56'),(83,'Petraclinic6677@gmail.com',NULL,NULL,'34984a1dc68cc4c83026f44dd8b8bea1',NULL,'วันวิสาข์','-',NULL,'หญิง','วันวิสาข์ ไม้พันธุ์\r\n0804613912',NULL,'EMPLOYEE','Y','2023-03-31','WVLEA-2N3HY-AW2EX-L24Q5','ca7e3eecfd9ac8b14f4d24f5b69bfb0e',NULL,'2023-02-15 06:23:11','2023-03-16 06:46:51'),(84,'Alisa.wewellholistic@gmail.com','example@example.com',NULL,'fc10f2d2de552750259505d5707f39cb',NULL,'อลิสา','-',NULL,'หญิง','- อลิสา\r\n- 0944199663\r\n- Alisa.wewellholistic@gmail.com',NULL,'EMPLOYEE','Y','2023-02-28','WVLEA-2N3HY-AW2EX-L24Q5','2f16971074b5e45cec84e1009883ba0e',NULL,'2023-02-19 01:44:50','2023-02-19 01:44:50'),(85,'chaiwat.c0412@gmail.com',NULL,NULL,'fbebea2e61f3fdcff2683a3f5be14890',NULL,'ชัยวัฒน์','-',NULL,NULL,'- นายชัยวัฒน์ ฉวีวรรณ\r\n- 099-949-6663\r\n- chaiwat.c0412@gmail.com',NULL,'EMPLOYEE','Y','2023-03-15','WVLEA-2N3HY-AW2EX-L24Q5','625ff80262cf617b6af209adaaa17845',NULL,'2023-02-27 02:27:55','2023-02-27 02:27:55'),(86,'bmu@chulapd.org','example@example.com',NULL,'3cd031dc3cc11fd1abb340e957fb53c8',NULL,'นุ่น','-',NULL,'หญิง','ขอยูเซอร์ทดลองใช้ค่ะ\r\n- ชื่อผู้ติดต่อ นุ่น\r\n- เบอร์โทรศัพท์ 095-6430171',NULL,'EMPLOYEE','Y','2023-03-15','WVLEA-2N3HY-AW2EX-L24Q5','2d53b5b1b1bfd73751c3312070932951',NULL,'2023-02-27 03:30:09','2023-02-27 03:30:09'),(87,'thanra@kkumail.com','example@example.com',NULL,'d8228630ab24ecf16a804558c8b7d6f2',NULL,'มิ้ง','-',NULL,'หญิง','-มิ้ง\r\n-0624895650\r\n-thanra@kkumail.com',NULL,'EMPLOYEE','Y','2023-03-31','WVLEA-2N3HY-AW2EX-L24Q5','609db4a131821bb9f9f7fd95d41d162d',NULL,'2023-03-09 02:15:25','2023-03-09 02:15:25'),(88,'pattanantra@gmail.com','example@example.com',NULL,'34f0c8a6c7020430763edfa37a1fb43f',NULL,'คุณตรา','-',NULL,'หญิง','ติดต่อคุณตรา\r\n095-536-2969\r\nอีเมลล์',NULL,'EMPLOYEE','Y','2023-03-31','WVLEA-2N3HY-AW2EX-L24Q5','61396477d5063f9ada1b325712ea1d04',NULL,'2023-03-09 02:18:31','2023-03-09 02:18:31'),(89,'ibb35.ink@gmail.com',NULL,NULL,'387d6c7f95706f6470b86a84155a1e5a',NULL,'เพ็ญรวี','-',NULL,'หญิง','คลินิกเด็กหมอเพ็ญรวี (หมอแแพรว)\r\nพญ.เพ็ญรวี ขาวสำลี\r\n1099/6 ถนน ขุขันธ์ อำเภอเมืองศรีสะเกษ จ.ศรีสะเกษ 33000\r\n083-4422924\r\n\r\nibb35.ink@gmail.com',NULL,'EMPLOYEE','Y','2023-03-31','WVLEA-2N3HY-AW2EX-L24Q5','9b7367635312bb177fe19a6a9d21764f',NULL,'2023-03-13 06:55:53','2023-03-13 06:55:53'),(90,'bulakorns.k@gmail.com',NULL,NULL,'c78ba9d2893bbdd843b41a47974f5e47',NULL,'เก่ง','-',NULL,'ชาย','0961360763\r\nbulakorns.k@gmail.com',NULL,'EMPLOYEE','Y','2023-03-31','WVLEA-2N3HY-AW2EX-L24Q5','358f8229310a94bfb25b68c340e25c7b',NULL,'2023-03-15 09:10:56','2023-03-15 09:11:16'),(91,'joco_19@hotmail.com',NULL,NULL,'59ea104824751fc4326cd6cefd2a9f4a',NULL,'Ake','-',NULL,'ชาย','Ake, 0819028883, joco_19@hotmail.com',NULL,'EMPLOYEE','Y','2023-04-30','WVLEA-2N3HY-AW2EX-L24Q5','6a0c8fe10d5d0b929dc95982ca62c8ac',NULL,'2023-03-16 06:49:22','2023-03-16 06:49:22'),(92,'boo10888@gmail.com',NULL,NULL,'2c7dbda3c764c7dae865dac25d6884f8',NULL,'คุณเอก','-',NULL,'ชาย','0863419559\r\nboo10888@gmail.com',NULL,'EMPLOYEE','Y','2023-04-19','WVLEA-2N3HY-AW2EX-L24Q5','e6e9e44eb55cafc97a67fee13b55da69',NULL,'2023-03-19 02:14:17','2023-03-19 02:14:17'),(93,'nueng_aimable@hotmail.com',NULL,NULL,'d77f07bc876f7cd7d7d84a6c14eff514',NULL,'พบสุข','-',NULL,'ชาย','พบสุข\r\n0895534136\r\nnueng_aimable@hotmail.com',NULL,'EMPLOYEE','Y','2023-04-30','WVLEA-2N3HY-AW2EX-L24Q5','bc71ec85faea128e05ed5c1cb4a74a64',NULL,'2023-03-20 07:54:57','2023-03-20 07:54:57'),(94,'happysecret05@gmail.com',NULL,NULL,'ff34e345d460ac046d94647596b87ea8',NULL,'กีต้าร์','05',NULL,'หญิง','95 856 8451',NULL,'EMPLOYEE','Y','2023-04-30','WVLEA-2N3HY-AW2EX-L24Q5','abcbf14ca07d8fc9317281cf2f646e7c',NULL,'2023-03-29 04:33:36','2023-03-29 04:33:36'),(95,'Theweena.info@gmail.com',NULL,NULL,'4545a7468607559f4eb141a8b8fd9107',NULL,'บีเอ็ม','-',NULL,'ชาย','บีเอ็ม\r\n0650985642\r\nTheweena.info@gmail.com',NULL,'EMPLOYEE','Y','2023-04-30','WVLEA-2N3HY-AW2EX-L24Q5','bfd3f8e16153ceba490be1481af30399',NULL,'2023-03-31 09:52:46','2023-03-31 09:52:46'),(96,'Punnaruj56@gmail.com',NULL,NULL,'bfaf357149e1da635c859de5bfb28874',NULL,'ปัณณรุจน์','-',NULL,'ชาย','ชื่อ ปัณณรุจน์ ธีระวรรณวัชร์\r\n0624535328\r\nPunnaruj56@gmail.com',NULL,'EMPLOYEE','Y','2023-06-15','WVLEA-2N3HY-AW2EX-L24Q5','2637847e15c23544284da008c297622b',NULL,'2023-04-10 02:24:02','2023-06-01 02:20:48'),(97,'lalitphan.chao@gmail.com',NULL,NULL,'d8bb075f3e5f1e8db3830fa841740885',NULL,'ไข่มุก','-',NULL,'ชาย','ชื่อ ไข่มุก\r\nเบอร์ 0635653922\r\nlalitphan.chao@gmail.com',NULL,'EMPLOYEE','Y','2023-04-30','WVLEA-2N3HY-AW2EX-L24Q5','87905067d4a5dd702fa98aa0d785d95c',NULL,'2023-04-10 02:26:44','2023-04-10 02:26:44'),(98,'yotpicha@gmail.com','example@example.com',NULL,'6ddd1c98fed345d5323e6241e3a015bb',NULL,'ยศพิชา','-',NULL,'ชาย','ยศพิชา 0891997370\r\nyotpicha@gmail.com',NULL,'EMPLOYEE','Y','2023-06-10','WVLEA-2N3HY-AW2EX-L24Q5','e3b6445e72544d6b0779c02310e19844',NULL,'2023-04-24 02:31:21','2023-04-24 02:31:21'),(99,'Pop181@hotmail.com','example@example.com',NULL,'1a609aa136243dd26eb15bdca4a4971a',NULL,'K.Pop','-',NULL,NULL,NULL,NULL,'EMPLOYEE','Y','2023-12-31','WVLEA-2N3HY-AW2EX-L24Q5','a897ec125b17a07fd2a991c208d25a4c',NULL,'2023-04-25 06:43:16','2023-04-25 06:43:16'),(100,'espada00400@gmail.com','chailsr.master@gmail.com',NULL,'046a0ea37f35f4ccb081cdadfea55094',NULL,'จิรศักดิ์','-',NULL,'ชาย','ติดต่อขอ user demo ครับ\r\nจิรศักดิ์  วรรณชัย\r\n0643474999\r\nespada00400@gmail.com',NULL,'EMPLOYEE','Y','2023-05-15','WVLEA-2N3HY-AW2EX-L24Q5','04f34114e80a3163c877a8c30acc52eb',NULL,'2023-04-29 10:23:15','2023-04-29 10:23:15'),(101,'patcha2105@gmail.com',NULL,NULL,'4dbd4706421612650ec3d60819ff4182',NULL,'พัชรินทร์','-',NULL,'ชาย','ขอยูเซอร์ทดลองใช้\r\nพัชรินทร์ นพคุณ\r\n0844396039\r\npatcha2105@gmail.com',NULL,'EMPLOYEE','Y','2023-05-31','WVLEA-2N3HY-AW2EX-L24Q5','f1826839f0bbcb1cf240ddf4d43f7cd3',NULL,'2023-05-10 03:33:06','2023-05-10 03:33:06'),(102,'jkp7429@gmail.com','example@example.com',NULL,'89a2d7695d47a47072d4948f7d0499ea',NULL,'จักรพันธ์','-',NULL,'ชาย','จักรพันธ์ ศรทอง\r\n0991647429\r\njkp7429@gmail.com',NULL,'EMPLOYEE','Y','2023-05-31','WVLEA-2N3HY-AW2EX-L24Q5','2d6eac5a8584b0fe5cab3c10a61b0dcb',NULL,'2023-05-15 02:19:44','2023-05-15 02:19:44'),(103,'saman.sum@swingth.org','example@example.com',NULL,'62dbd84cac758c896fc7d10a28a3a295',NULL,'ทราย','-',NULL,'ชาย','ทราย\r\n084-977-3948\r\nsaman.sum@swingth.org',NULL,'EMPLOYEE','Y','2023-05-31','WVLEA-2N3HY-AW2EX-L24Q5','8c2836e87818772886f0a9351f399acd',NULL,'2023-05-22 02:20:14','2023-05-22 02:20:14'),(104,'Natchanitw@gmail.com','example@example.com',NULL,'c0c45dc237a1ea7d0628f96986037d8f',NULL,'ณัชณิษฐ์','-',NULL,'หญิง','ณัชณิษฐ์ วัฒนะเดชาเศรษฐ์\r\n0636622974\r\nNatchanitw@gmail.com',NULL,'EMPLOYEE','Y','2023-06-30','WVLEA-2N3HY-AW2EX-L24Q5','2241b39fc794eb5c30cd3a9f79c30672',NULL,'2023-06-05 12:04:31','2023-06-05 12:04:31'),(105,'Subhavit.r@gmail.com','example@example.com',NULL,'bf4eee667060333e8515c3f9d27ca483',NULL,'Subhavit','-',NULL,NULL,'Subhavit\r\n0989497989\r\nSubhavit.r@gmail.com',NULL,'EMPLOYEE','Y','2023-06-30','WVLEA-2N3HY-AW2EX-L24Q5','c4a94ec5f9093f147e38c01b27ba03f0',NULL,'2023-06-06 07:00:53','2023-06-06 07:00:53'),(106,'topformacc@gmail.com','example@example.com',NULL,'9bd5351bd95adf62f0c219273f551558',NULL,'ชลิดา','-',NULL,'หญิง','- ชื่อผู้ติดต่อ > ชลิดา  ตะเภาทอง\r\n- เบอร์โทรศัทพ์ > 097-4962828\r\n- อีเมล์ > topformacc@gmail.com',NULL,'MANAGER','Y','2023-06-30','WVLEA-2N3HY-AW2EX-L24Q5','72257fb952376de54113ebee7a771230',NULL,'2023-06-08 10:45:12','2023-06-13 10:35:08'),(107,'crwsc@hotmail.com','example@example.com',NULL,'f2b0c76c11bd0fea4d66b35e4dc48e5d',NULL,'จรัชวิทย์','-',NULL,'หญิง','จรัชวิทย์ จิตตะณิชย์กุล (อุ้ม)\r\n082-626-2326\r\ncrwsc@hotmail.com',NULL,'EMPLOYEE','Y','2023-06-30','WVLEA-2N3HY-AW2EX-L24Q5','100b7efd01e6c7ff4239c62d0cf352fa',NULL,'2023-06-13 09:07:37','2023-06-13 09:07:37'),(108,'aya.gwang789@gmail.com','example@example.com',NULL,'c6508da3ef5cb82aafbf51afa922a31c',NULL,'กวาง','-',NULL,'หญิง','กวาง 0874449266\r\naya.gwang789@gmail.com ค่ะ',NULL,'EMPLOYEE','Y','2023-07-20','WVLEA-2N3HY-AW2EX-L24Q5','33741b80874614789d56e537ec971e8f',NULL,'2023-06-20 08:49:31','2023-06-20 08:49:31'),(109,'Candysoontaree@gmail.com',NULL,NULL,'4823bc6fe5632d47f6265542ebb5aa11',NULL,'สุนทรี','-',NULL,'ชาย','สุนทรี นามแสง\r\n0961596398\r\nCandysoontaree@gmail.com',NULL,'EMPLOYEE','Y','2023-07-31','WVLEA-2N3HY-AW2EX-L24Q5','6f7a4f688bec57c841159cac67cf0514',NULL,'2023-07-03 02:24:04','2023-07-03 02:24:04'),(110,'chaiteachawut@hotmail.com',NULL,NULL,'81cb134aa3ae09353cb85dfe1183fd87',NULL,'คุณหมู','-',NULL,'ชาย','- คุณหมู\r\n- 081-9824955\r\n- chaiteachawut@hotmail.com',NULL,'EMPLOYEE','Y','2023-07-31','WVLEA-2N3HY-AW2EX-L24Q5','167f18f743e66687a89e3fd6890e36ed',NULL,'2023-07-04 03:16:12','2023-07-04 03:16:12'),(111,'manataya.wtnt@gmail.com',NULL,NULL,'c245407242f8dbfe3d7b7409556e3c45',NULL,'นะ','-',NULL,NULL,'ชื่อ นะ\r\n0661246291\r\nmanataya.wtnt@gmail.com',NULL,'EMPLOYEE','Y','2023-07-31','WVLEA-2N3HY-AW2EX-L24Q5','4fbd41956dcbe1e1994380e020b87013',NULL,'2023-07-05 01:56:30','2023-07-05 01:56:30'),(112,'chawin18443@gmail.com',NULL,NULL,'7c1fc4ee82434e28d92b18325b3cdb1f',NULL,'ชวิน','-',NULL,'ชาย','ขอยูเซอร์ทดลองใช้รบกวนขอข้อมูลลูกค้า\r\n- ชื่อผู้ติดต่อ - ชวิน นิพพิทาวาสิน\r\n- เบอร์โทรศัทพ์ 089-7181111\r\n- อีเมล์ chawin18443@gmail.com',NULL,'EMPLOYEE','Y','2023-07-31','WVLEA-2N3HY-AW2EX-L24Q5','81c6b80d8a8b2979bd920f977f23ad8c',NULL,'2023-07-06 07:12:33','2023-07-06 07:12:33'),(113,'tnan2465@gmail.com','example@example.com',NULL,'3b41990d06ac0b49d22c1ddc10d2c97d',NULL,'ธนนันท์','-',NULL,'หญิง','ธนนันท์\r\n0639659944',NULL,'EMPLOYEE','Y','2023-07-31','WVLEA-2N3HY-AW2EX-L24Q5','e1c094b5e0b5ad9121da86f3564d62ae',NULL,'2023-07-17 02:55:41','2023-07-17 02:55:41'),(114,'piyapongsaeli@gmail.com','example@example.com',NULL,'18e308ef38dd28144e45e1e91f43cea2',NULL,'ปิยพงษ์','-',NULL,'ชาย','ขอยูเซอร์ทดลองใช้โปรแกรม\r\n- ปิยพงษ์\r\n- 0937580855\r\n- piyapongsaeli@gmail.com',NULL,'EMPLOYEE','Y','2023-08-31','WVLEA-2N3HY-AW2EX-L24Q5','4bfbae82f1a83c1efde7d678637bb9e7',NULL,'2023-07-24 04:35:51','2023-07-24 04:35:51'),(115,'get4545@gmail.com','example@example.com',NULL,'b8b38095e93f73e3b9c8d948761656b2',NULL,'เก็ต','-',NULL,'ชาย','เก็ต พัฒน์รดิศ\r\n0969542269\r\nget4545@gmail.com',NULL,'EMPLOYEE','Y','2023-08-31','WVLEA-2N3HY-AW2EX-L24Q5','7675730a18dee0d84ab2d436fda0eeda',NULL,'2023-07-25 04:54:35','2023-07-25 04:54:35'),(116,'ิbangkokstore2023@gmail.com','example@example.com',NULL,'ae127caecaaef456ff247617eb67676d',NULL,'ปีใหม่','-',NULL,'หญิง','- ชื่อผู้ติดต่อ\r\nปีใหม่\r\n- เบอร์โทรศัทพ์\r\n0968124575\r\n- อีเมล์\r\nBangkokstore2023@gmail.com',NULL,'EMPLOYEE','Y','2023-08-31','WVLEA-2N3HY-AW2EX-L24Q5','38821bf2bb111eba8cea2bf8480b7c08',NULL,'2023-07-25 07:13:36','2023-07-25 07:13:36'),(117,'matthew.btv8@gmail.com','example@example.com',NULL,'1213338973a952312cadcfcff5f88d1e',NULL,'ทิว','-',NULL,'ชาย','+8562055442663 (นครหลวง เวียงจัณน์)\r\nMatthew.btv8@gmail.com',NULL,'EMPLOYEE','Y','2023-08-31','WVLEA-2N3HY-AW2EX-L24Q5','3888a348876cf56fdae4be35538f05a0',NULL,'2023-07-26 03:18:13','2023-07-26 03:18:13'),(118,'mookqvay@gmail.com',NULL,NULL,'708507e57bb582815a93a34c69a829ea',NULL,'อารดา','-',NULL,'หญิง','- ชื่อผู้ติดต่อ : อารดา บุญประภากร\r\n- เบอร์โทรศัทพ์ : 0900981707\r\n- อีเมล์ : mookqvay@gmail.com',NULL,'EMPLOYEE','Y','2023-08-31','WVLEA-2N3HY-AW2EX-L24Q5','2db27c1d437f3ce10ce71d46704c1b8c',NULL,'2023-08-03 06:54:36','2023-08-03 06:54:36'),(119,'netnapha.pick@gmail.com','example@example.com',NULL,'08891246b0ead9788aaf9c2b9bd17769',NULL,'เนตรนภา','-',NULL,'หญิง','- ชื่อผู้ติดต่อ เนตรนภา บุญยง\r\n- เบอร์โทรศัทพ์ 089-4166419\r\n- อีเมล์ netnapha.pick@gmail.com',NULL,'EMPLOYEE','Y','2023-08-31','WVLEA-2N3HY-AW2EX-L24Q5','1f0820d95bffc02a57f4f66cc756456e',NULL,'2023-08-04 02:25:31','2023-08-04 02:25:31'),(120,'tassana.pra@gmail.com',NULL,NULL,'936852df58447e57652f28f3425e8a22',NULL,'ทัศนา','-',NULL,'ชาย','ทัศนา ประวิเศษ\r\n0956145255\r\ntassana.pra@gmail.com',NULL,'EMPLOYEE','Y','2023-09-07','WVLEA-2N3HY-AW2EX-L24Q5','6e5b66e09b5968f1eacc6f89a7c98b97',NULL,'2023-08-15 02:19:30','2023-08-30 14:14:44'),(121,'celebe.jda@gmail.com','example@example.com',NULL,'63d52ff1520de36881ba3d7214dfa7fb',NULL,'มิวู','-',NULL,'หญิง','มิวู คลินิก (ดา)\r\n0890060125',NULL,'EMPLOYEE','Y','2023-09-06','WVLEA-2N3HY-AW2EX-L24Q5','0776d8cdb111abf2e0e277ae68e188aa',NULL,'2023-08-23 09:04:45','2023-08-23 09:04:45'),(122,'Aombubie',NULL,NULL,'e10adc3949ba59abbe56e057f20f883e',NULL,'มาริสา','กระต่ายทอง',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-12-31','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','16f40fe76bd5caf586c5a1614aa5b84f',NULL,'2023-09-01 10:17:55','2023-09-01 10:17:55'),(123,'Gloy',NULL,NULL,'4297f44b13955235245b2497399d7a93',NULL,'สุภาพร','บุญนพ',NULL,'หญิง',NULL,NULL,'SALES','Y','2023-12-31','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','f64633a8ffcac83816052530bbbded13',NULL,'2023-09-01 10:22:15','2023-09-01 10:22:15'),(124,'Kookkik',NULL,NULL,'ef9426d29e662866c3972d53de78ad09',NULL,'บุญญรัตน์','สีสะท้าน',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2023-12-31','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','9496fea7a56ed3c2a20f92690858a4d1',NULL,'2023-09-01 10:26:32','2023-09-13 17:24:17'),(125,'meplaernwecare@gmail.com','example@example.com',NULL,'ead9823d76d9142029736d89205cb2b5',NULL,'รักชนก','-',NULL,'หญิง','รักชนก\r\n0894726872\r\nmeplaernwecare@gmail.com',NULL,'EMPLOYEE','Y','2023-09-30','WVLEA-2N3HY-AW2EX-L24Q5','3d83680b6ce181636c1548c8f4da5001',NULL,'2023-09-02 14:53:40','2023-09-02 14:53:40'),(126,'aa','a@hotmail.com',NULL,'47bce5c74f589f4867dbd57e9ca9f808','aa','aa','a',NULL,'ชาย',NULL,NULL,'DOCTORASSI','Y','2023-09-03','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','691fb9d03616f5fb8e33a1080ca4d870',NULL,'2023-09-02 16:19:57','2023-09-02 16:19:57'),(127,'laladaclinic','tassana.pra@gmail.com',NULL,'12220ecd33db8ab810ba7c500cdf95ca',NULL,'lalada','clinic',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2024-09-05','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','bd89ed286eb9347623aaa7de3f87a477',NULL,'2023-09-03 09:40:03','2023-09-03 09:40:03'),(128,'Doctor',NULL,NULL,'81dc9bdb52d04dc20036dbd8313ed055',NULL,'ธำรงค์','เอกรัตนวงศ์',NULL,'ชาย',NULL,NULL,'DOCTOR','Y','2023-12-31','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','f21f1a7a79b81912458fd7b75eb85838',NULL,'2023-09-03 12:51:06','2023-09-03 12:51:06'),(129,'BT',NULL,NULL,'81dc9bdb52d04dc20036dbd8313ed055',NULL,'No','-',NULL,'ชาย',NULL,NULL,'DOCTOR','Y','2023-12-31','PB7LT-8FCYU-YSZLR-YUXUB-JGSUX','28ea6ee8e2b783aed2095749dcbea991',NULL,'2023-09-03 13:21:54','2023-09-03 13:21:54'),(130,'chutinan_te@hotmail.com','example@example.com',NULL,'37a681e44875440335a8d8aab06afd4d',NULL,'นุ่น','-',NULL,'หญิง','นุ่น\r\n099-426-3651\r\nchutinan_te@hotmail.com',NULL,'EMPLOYEE','Y','2023-09-30','WVLEA-2N3HY-AW2EX-L24Q5','a217ada8e5066b1eb3ce1e6990957a27',NULL,'2023-09-05 10:42:48','2023-09-05 10:42:48'),(131,'benjaporn_f',NULL,NULL,'7400b38f8649699ee3dad9a520af854e',NULL,'เบญจพร','เฟื่องฟู',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2024-09-01','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','a06e07ae2ea5ab64bc95d907df84dba3',NULL,'2023-09-06 15:08:46','2023-09-06 15:08:46'),(132,'kimkimasmar@gmail.com','example@example.com',NULL,'a1671ac8c1d419add7e2f3f1df2c94b0',NULL,'อับดุลฮากิม','-',NULL,'ชาย','-ชื่อผู้ติดต่อ อับดุลฮากิม\r\n-เบอร์โทรศัพท์ 0624063871\r\n-อีเมล์ kimkimasmar@gmail.com',NULL,'EMPLOYEE','Y','2023-09-30','WVLEA-2N3HY-AW2EX-L24Q5','25ed2b38e90675bab1c257f82abc1a8d',NULL,'2023-09-07 12:17:58','2023-09-07 12:17:58'),(133,'lukkana_s',NULL,NULL,'25d55ad283aa400af464c76d713c07ad',NULL,'ลักขณา','สิงห์เสนา',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2024-08-31','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','68b5330e93ede800c35c2713c61f50b6',NULL,'2023-09-11 19:27:14','2023-09-11 19:27:14'),(134,'darunee_y',NULL,NULL,'25d55ad283aa400af464c76d713c07ad',NULL,'ดารูนี','เยะมูเร็ง',NULL,'หญิง',NULL,NULL,'SALES','Y','2024-08-31','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','c5b3aff331c57cd9e1443eb49b65866e',NULL,'2023-09-11 19:28:37','2023-09-11 19:28:37'),(135,'galewalee_p',NULL,NULL,'25d55ad283aa400af464c76d713c07ad',NULL,'เกวลี','ภูชะหาร',NULL,'หญิง',NULL,NULL,'DOCTORASSI','Y','2024-08-31','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','83cf9b05bcb6da09297c2369a1b49d1f',NULL,'2023-09-11 19:29:58','2023-09-11 19:29:58'),(136,'sittiporn_c',NULL,NULL,'25d55ad283aa400af464c76d713c07ad',NULL,'นพ.สิทธิพร','เจริญขวัญ',NULL,'ชาย',NULL,NULL,'DOCTOR','Y','2024-08-31','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','bd20fa33c9dec2d8d5ad6a9069c57ac0',NULL,'2023-09-11 19:32:36','2023-09-11 19:32:36'),(137,'prompong_s',NULL,NULL,'25d55ad283aa400af464c76d713c07ad','0928069991','นพ.พร้อมพงศ์','ศรีสวัสดิคุโณดม',NULL,'ชาย',NULL,NULL,'DOCTOR','Y','2024-08-31','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','234ca6562161350f4537180ee8176780',NULL,'2023-09-11 19:34:20','2023-09-11 19:37:10'),(138,'tassana_p',NULL,NULL,'5f80eacdc949b9b630b1f40b8e2500ca',NULL,'ทัศนา','ประวิเศษ',NULL,'หญิง',NULL,NULL,'MANAGER','Y','2024-09-01','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','349dbabca5ea945738769faa276376d1',NULL,'2023-09-11 21:17:58','2023-09-11 21:17:58'),(139,'wachiraya_b',NULL,NULL,'22a4d9b04fe95c9893b41e2fde83a427',NULL,'พญ.วชิรญา','บุตรคาม',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2025-04-30','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','3aeb70a1f3cacf6f4b7c1427ae1219fe',NULL,'2023-09-24 17:53:38','2023-09-24 17:53:38'),(140,'nissaraporn_s',NULL,NULL,'22a4d9b04fe95c9893b41e2fde83a427',NULL,'นิสราพร','สมานเกียรติสกุล',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2025-04-30','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','2a5d1e68926697135f74359f6d333d48',NULL,'2023-09-24 17:55:18','2023-09-24 17:55:18'),(141,'apinya_s',NULL,NULL,'22a4d9b04fe95c9893b41e2fde83a427',NULL,'พญ.อภิญญา','แซ่ลิ้ม',NULL,'หญิง',NULL,NULL,'DOCTOR','Y','2024-07-31','F5IXO-LUFIQ-KHMQJ-WJUBH-NIPNS','e6da7c4f5a44345ed1656cfd1779ad87',NULL,'2023-09-29 07:03:18','2023-09-29 14:03:18');
/*!40000 ALTER TABLE `user_identities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'surachai','chailsr.master@gmail.com',NULL,'$2y$10$fSz9EkoXZOFenN3fUph.yuwgwkNccuf54xSvScrlHcOwtuwVQ/oyS',NULL,'2022-02-09 03:23:16','2022-02-09 03:23:16');
/*!40000 ALTER TABLE `users` 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:41:08

📁 Sid Gifari File Manager