Da

✏️ Editing: linklek_dfg.sql

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

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

USE `linklek_dfg`;

--
-- Table structure for table `account_role`
--

DROP TABLE IF EXISTS `account_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `account_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `account_role`
--

LOCK TABLES `account_role` WRITE;
/*!40000 ALTER TABLE `account_role` DISABLE KEYS */;
INSERT INTO `account_role` VALUES (1,'Owner','Owner',NULL,0,NULL,NULL,NULL,NULL,NULL),(2,'editor','Editor',NULL,1,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `account_role` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `building`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `building` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `client_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(255) NOT NULL,
  `ordering` int(11) NOT NULL,
  `public_contact_tel` varchar(255) DEFAULT NULL,
  `private_contact_tel` varchar(255) DEFAULT NULL,
  `contact_address` longtext DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `cover_image` longtext DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E16F61D419EB6921` (`client_id`),
  CONSTRAINT `FK_E16F61D419EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `building` WRITE;
/*!40000 ALTER TABLE `building` DISABLE KEYS */;
INSERT INTO `building` VALUES ('�H(��|<���)����','�Hx�|���oO�1S�','JTC',1,'02-630-1000','-','919/1 Silom Road, Silom, Bangrak, Bangkok 10500',13.744,100.39,'jtc-building-64b49ef8b1926341337595-64be52de7568f480586450.jpg',94805,'published',NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 01:52:56','2023-07-24 10:30:54');
/*!40000 ALTER TABLE `building` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `building_facilities`
--

DROP TABLE IF EXISTS `building_facilities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `building_facilities` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `building_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `facility_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `floor_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `ordering` int(11) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_83A0EA504D2A7E12` (`building_id`),
  KEY `IDX_83A0EA50A7014910` (`facility_id`),
  KEY `IDX_83A0EA50854679E2` (`floor_id`),
  CONSTRAINT `FK_83A0EA504D2A7E12` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`),
  CONSTRAINT `FK_83A0EA50854679E2` FOREIGN KEY (`floor_id`) REFERENCES `floor_plan` (`id`),
  CONSTRAINT `FK_83A0EA50A7014910` FOREIGN KEY (`facility_id`) REFERENCES `facility` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `building_facilities`
--

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

--
-- Table structure for table `building_image`
--

DROP TABLE IF EXISTS `building_image`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `building_image` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `building_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `image` longtext NOT NULL,
  `image_size` int(11) DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A99DB5C54D2A7E12` (`building_id`),
  CONSTRAINT `FK_A99DB5C54D2A7E12` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `building_image`
--

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

--
-- Table structure for table `building_translation`
--

DROP TABLE IF EXISTS `building_translation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `building_translation` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `translatable_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `name` varchar(255) NOT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `locale` varchar(5) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `building_translation_unique_translation` (`translatable_id`,`locale`),
  KEY `IDX_29957AAF2C2AC5D3` (`translatable_id`),
  CONSTRAINT `FK_29957AAF2C2AC5D3` FOREIGN KEY (`translatable_id`) REFERENCES `building` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `building_translation`
--

LOCK TABLES `building_translation` WRITE;
/*!40000 ALTER TABLE `building_translation` DISABLE KEYS */;
INSERT INTO `building_translation` VALUES ('�H(��|<���)�7��','�H(��|<���)����','Jewelry Trade Center Thailand','The Jewelry Trade Center (JTC) is Thailand’s leading trade premises for diamonds, gems and assorted jewelry. It comprises over 180,000 square meters of retail, office and residential space, constructed upon 4.5 acres of land in Bangkok’s thriving Central','th'),('�H(��r����iX��','�H(��|<���)����','Jewelry Trade Center Thailand','The Jewelry Trade Center (JTC) is Thailand’s leading trade premises for diamonds, gems and assorted jewelry. It comprises over 180,000 square meters of retail, office and residential space, constructed upon 4.5 acres of land in Bangkok’s thriving Central','en');
/*!40000 ALTER TABLE `building_translation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `client_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `ordering` int(11) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `cover_image` longtext DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  `highlight_color` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_64C19C119EB6921` (`client_id`),
  CONSTRAINT `FK_64C19C119EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES ('�M�8�pك�9�9�3',NULL,'cat1','Cat1',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),('�M�?{x6�ޗY���','�Hx�|���oO�1S�','bank','Bank',1,NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-19 16:20:15','2023-07-31 09:41:12',NULL,NULL,'#0421ae'),('�n��*tٜ���̈u\Z','�Hx�|���oO�1S�','jewelry','Jewelry zone',2,'Jewerly zone','chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-19 16:24:38','2023-07-31 09:41:27',NULL,NULL,'#ff0000'),('�n�|Q�����Z�','�Hx�|���oO�1S�','fashion','Fashion',3,'Bangkok fashion outlet Zone','chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-19 16:26:03','2023-07-31 09:41:45',NULL,NULL,'#e4d101'),('�q���w��k�лB��','�Hx�|���oO�1S�','food','Food and beverage',4,NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-20 05:02:52','2023-07-31 09:42:00',NULL,NULL,'#00c70d'),('�q�DrJ��=¼Y8�','�Hx�|���oO�1S�','other','Other',5,NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-20 05:11:07','2023-07-31 09:42:16',NULL,NULL,'#525151');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client`
--

DROP TABLE IF EXISTS `client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `status` varchar(50) NOT NULL,
  `expired_at` datetime DEFAULT NULL,
  `cover_image` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client`
--

LOCK TABLES `client` WRITE;
/*!40000 ALTER TABLE `client` DISABLE KEYS */;
INSERT INTO `client` VALUES ('�Hx�|���oO�1S�','jtc','JTC',NULL,'active',NULL,NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 08:54:06','2023-07-17 08:54:06',NULL);
/*!40000 ALTER TABLE `client` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client_accounts`
--

DROP TABLE IF EXISTS `client_accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `member_id` int(11) DEFAULT NULL,
  `account_role_id` int(11) NOT NULL,
  `ordering` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `invite_member` varchar(255) NOT NULL,
  `invite_member_email` varchar(255) NOT NULL,
  `invite_member_status` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E42EAE6919EB6921` (`client_id`),
  KEY `IDX_E42EAE697597D3FE` (`member_id`),
  KEY `IDX_E42EAE691F2836E4` (`account_role_id`),
  CONSTRAINT `FK_E42EAE6919EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
  CONSTRAINT `FK_E42EAE691F2836E4` FOREIGN KEY (`account_role_id`) REFERENCES `account_role` (`id`),
  CONSTRAINT `FK_E42EAE697597D3FE` FOREIGN KEY (`member_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client_accounts`
--

LOCK TABLES `client_accounts` WRITE;
/*!40000 ALTER TABLE `client_accounts` DISABLE KEYS */;
INSERT INTO `client_accounts` VALUES (1,'�Hx�|���oO�1S�',1,1,1,NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 10:17:38','2023-07-17 10:17:38','chanond buranabunpot','chanond.b@app-alive.com','active'),(2,'�Hx�|���oO�1S�',2,2,0,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-17 10:56:56','2023-07-20 05:52:19','chanond','as.ur.service@gmail.com','active'),(3,'�Hx�|���oO�1S�',3,2,0,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-20 05:44:23','2023-07-20 05:52:19','thapakorn','thapakorn.n@app-alive.com','active'),(4,'�Hx�|���oO�1S�',5,1,0,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-20 10:28:24','2023-07-20 10:28:24','Kanda','kandawiley82@gmail.com','active');
/*!40000 ALTER TABLE `client_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(50) NOT NULL,
  `fav_icon` longtext DEFAULT NULL,
  `social_image` longtext DEFAULT NULL,
  `google_ga_code` varchar(255) DEFAULT NULL,
  `custom_code_header` longtext DEFAULT NULL,
  `custom_code_body` longtext DEFAULT NULL,
  `custom_code_header_end` longtext DEFAULT NULL,
  `custom_code_body_end` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

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

--
-- Table structure for table `config_translation`
--

DROP TABLE IF EXISTS `config_translation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config_translation` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `translatable_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `name` varchar(255) NOT NULL,
  `short_description` varchar(255) DEFAULT NULL,
  `locale` varchar(5) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `config_translation_unique_translation` (`translatable_id`,`locale`),
  KEY `IDX_663CC9082C2AC5D3` (`translatable_id`),
  CONSTRAINT `FK_663CC9082C2AC5D3` FOREIGN KEY (`translatable_id`) REFERENCES `config` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config_translation`
--

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

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customer` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `customer_code` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` varchar(50) NOT NULL,
  `contact_person_name` varchar(255) DEFAULT NULL,
  `contact_person_tel` varchar(255) DEFAULT NULL,
  `contact_person_email` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

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

--
-- Table structure for table `facility`
--

DROP TABLE IF EXISTS `facility`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facility` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `client_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `cover_image` longtext DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_105994B219EB6921` (`client_id`),
  CONSTRAINT `FK_105994B219EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facility`
--

LOCK TABLES `facility` WRITE;
/*!40000 ALTER TABLE `facility` DISABLE KEYS */;
INSERT INTO `facility` VALUES ('�M�?]tA�o�k�n��','�Hx�|���oO�1S�','S-1','Swimming pool','ชั้น 18',1,NULL,'chanond.b@app-alive.com',NULL,'2023-07-23 04:06:00','2023-07-23 04:06:00',NULL,NULL),('�b�V3rt��M�h��\'','�Hx�|���oO�1S�','lift','Lift',NULL,2,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-17 06:53:42','2023-07-17 06:53:42',NULL,NULL),('�b��\'x���RMl(M�','�Hx�|���oO�1S�','wc','Toilet',NULL,2,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-17 06:53:57','2023-07-17 06:53:57',NULL,NULL);
/*!40000 ALTER TABLE `facility` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `floor_plan`
--

DROP TABLE IF EXISTS `floor_plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `floor_plan` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `building_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `name` varchar(255) NOT NULL,
  `cover_image` longtext DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `total_rooms` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F1A6905B4D2A7E12` (`building_id`),
  CONSTRAINT `FK_F1A6905B4D2A7E12` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `floor_plan`
--

LOCK TABLES `floor_plan` WRITE;
/*!40000 ALTER TABLE `floor_plan` DISABLE KEYS */;
INSERT INTO `floor_plan` VALUES ('�H�urƈ�s��v�','�H(��|<���)����','B1','floorplan-b1-2-64b9e40337a73169256555.jpg',249665,1,'B1',0,NULL,'chanond.b@app-alive.com',NULL,'2023-07-16 02:52:37','2023-07-24 10:38:11','open'),('�N�ڱs;����]�','�H(��|<���)����','G','floorplan-g-3-6505cf90adc6e865562416.jpg',244116,2,'G',0,NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 01:55:27','2023-09-16 15:53:52','open'),('�N�vxu@����9[��','�H(��|<���)����','F2','floorplan-2f-1-64b9e412bcd58094269423.jpg',240804,3,'F2',0,NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 01:55:18','2023-07-24 10:38:21','open'),('�N���}��2`h�M','�H(��|<���)����','F3','floorplan-3f-1-64b9e41ca5a9a690985151.jpg',258536,4,'F3',0,NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 01:55:45','2023-07-24 10:38:26','open'),('�N�d?	����yIF','�H(��|<���)����','F4','floorplan-4f-1-64b9e4267b8bc072426170.jpg',238437,5,'F4',0,NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 01:55:37','2023-07-24 10:38:30','open'),('��zI�ss����ޒ','�H(��|<���)����','F18',NULL,NULL,18,'F18',0,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-24 10:38:05','2023-07-24 10:38:05','under construction');
/*!40000 ALTER TABLE `floor_plan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `floor_plan_facility`
--

DROP TABLE IF EXISTS `floor_plan_facility`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `floor_plan_facility` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `floor_plan_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `facility_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `position_x` double DEFAULT NULL,
  `position_y` double DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1BAB9660485C8857` (`floor_plan_id`),
  KEY `IDX_1BAB9660A7014910` (`facility_id`),
  CONSTRAINT `FK_1BAB9660485C8857` FOREIGN KEY (`floor_plan_id`) REFERENCES `floor_plan` (`id`),
  CONSTRAINT `FK_1BAB9660A7014910` FOREIGN KEY (`facility_id`) REFERENCES `facility` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `floor_plan_facility`
--

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

--
-- Table structure for table `messenger_messages`
--

DROP TABLE IF EXISTS `messenger_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `messenger_messages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `body` longtext NOT NULL,
  `headers` longtext NOT NULL,
  `queue_name` varchar(190) NOT NULL,
  `created_at` datetime NOT NULL,
  `available_at` datetime NOT NULL,
  `delivered_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_75EA56E0FB7336F0` (`queue_name`),
  KEY `IDX_75EA56E0E3BD61CE` (`available_at`),
  KEY `IDX_75EA56E016BA31DB` (`delivered_at`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `messenger_messages`
--

LOCK TABLES `messenger_messages` WRITE;
/*!40000 ALTER TABLE `messenger_messages` DISABLE KEYS */;
INSERT INTO `messenger_messages` VALUES (1,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:41:\\\"registration/confirmation_email.html.twig\\\";i:1;N;i:2;a:3:{s:9:\\\"signedUrl\\\";s:175:\\\"https://localhost:8000/verify/email?expires=1689134737&id=1&signature=kKWpIvuiWn9ON3gJZ3zhuf4UfNXWL1kzZW%2B0AJlF0zc%3D&token=RHWL7HebJaM03%2F1b4f8dTDsmhxpjhvojRbO%2FIBedu6E%3D\\\";s:19:\\\"expiresAtMessageKey\\\";s:26:\\\"%count% hour|%count% hours\\\";s:20:\\\"expiresAtMessageData\\\";a:1:{s:7:\\\"%count%\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:7:\\\"LinkLek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:23:\\\"chanond.b@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:25:\\\"Please Confirm your Email\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-12 03:05:37','2023-07-12 03:05:37',NULL),(2,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:32:\\\"dfp/email/invite-email.html.twig\\\";i:1;N;i:2;a:1:{s:13:\\\"clientAccount\\\";O:32:\\\"App\\\\Entity\\\\System\\\\ClientAccounts\\\":13:{s:36:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0id\\\";i:2;s:40:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0client\\\";O:24:\\\"App\\\\Entity\\\\System\\\\Client\\\":18:{s:30:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0code\\\";s:3:\\\"jtc\\\";s:30:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0name\\\";s:3:\\\"JTC\\\";s:42:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0shortDescription\\\";N;s:32:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0status\\\";s:6:\\\"active\\\";s:35:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0expiredAt\\\";N;s:40:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0clientAccounts\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:36:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0coverImage\\\";N;s:35:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0buildings\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:36:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0facilities\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:36:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0categories\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:35:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0imageFile\\\";N;s:39:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0unitContracts\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:28:\\\"\\0App\\\\Entity\\\\System\\\\Client\\0id\\\";O:28:\\\"Symfony\\\\Component\\\\Uid\\\\UuidV7\\\":1:{s:6:\\\"\\0*\\0uid\\\";s:36:\\\"01894812-78da-7c87-96c6-6f4fa93153e2\\\";}s:12:\\\"\\0*\\0createdAt\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2023-07-17 08:54:06.000000\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:12:\\\"\\0*\\0updatedAt\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2023-07-17 08:54:06.000000\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:12:\\\"\\0*\\0createdBy\\\";N;s:12:\\\"\\0*\\0updatedBy\\\";s:23:\\\"chanond.b@app-alive.com\\\";s:12:\\\"\\0*\\0deletedBy\\\";N;}s:40:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0member\\\";N;s:45:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0accountRole\\\";O:29:\\\"App\\\\Entity\\\\System\\\\AccountRole\\\":11:{s:33:\\\"\\0App\\\\Entity\\\\System\\\\AccountRole\\0id\\\";i:2;s:35:\\\"\\0App\\\\Entity\\\\System\\\\AccountRole\\0code\\\";s:6:\\\"editor\\\";s:35:\\\"\\0App\\\\Entity\\\\System\\\\AccountRole\\0name\\\";s:6:\\\"Editor\\\";s:47:\\\"\\0App\\\\Entity\\\\System\\\\AccountRole\\0shortDescription\\\";N;s:39:\\\"\\0App\\\\Entity\\\\System\\\\AccountRole\\0ordering\\\";i:1;s:45:\\\"\\0App\\\\Entity\\\\System\\\\AccountRole\\0clientAccounts\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:12:\\\"\\0*\\0createdAt\\\";N;s:12:\\\"\\0*\\0updatedAt\\\";N;s:12:\\\"\\0*\\0createdBy\\\";N;s:12:\\\"\\0*\\0updatedBy\\\";N;s:12:\\\"\\0*\\0deletedBy\\\";N;}s:42:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0ordering\\\";i:0;s:46:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0inviteMember\\\";s:7:\\\"chanond\\\";s:51:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0inviteMemberEmail\\\";s:23:\\\"as.ur.service@gmail.com\\\";s:52:\\\"\\0App\\\\Entity\\\\System\\\\ClientAccounts\\0inviteMemberStatus\\\";s:7:\\\"pending\\\";s:12:\\\"\\0*\\0createdAt\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2023-07-17 10:56:56.378083\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:12:\\\"\\0*\\0updatedAt\\\";r:74;s:12:\\\"\\0*\\0createdBy\\\";O:22:\\\"App\\\\Entity\\\\System\\\\User\\\":18:{s:26:\\\"\\0App\\\\Entity\\\\System\\\\User\\0id\\\";i:1;s:32:\\\"\\0App\\\\Entity\\\\System\\\\User\\0username\\\";s:23:\\\"chanond.b@app-alive.com\\\";s:29:\\\"\\0App\\\\Entity\\\\System\\\\User\\0roles\\\";a:0:{}s:32:\\\"\\0App\\\\Entity\\\\System\\\\User\\0password\\\";s:60:\\\"$2y$13$ASLcVxWg3wAa4kSXNCMQ6utpIj7EzL8rcQydZbsqd/He0OBUNOEuK\\\";s:37:\\\"\\0App\\\\Entity\\\\System\\\\User\\0plainPassword\\\";N;s:34:\\\"\\0App\\\\Entity\\\\System\\\\User\\0isVerified\\\";b:1;s:34:\\\"\\0App\\\\Entity\\\\System\\\\User\\0coverImage\\\";N;s:38:\\\"\\0App\\\\Entity\\\\System\\\\User\\0coverImageSize\\\";N;s:33:\\\"\\0App\\\\Entity\\\\System\\\\User\\0imageFile\\\";N;s:38:\\\"\\0App\\\\Entity\\\\System\\\\User\\0clientAccounts\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}s:35:\\\"\\0App\\\\Entity\\\\System\\\\User\\0systemRoles\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:2:{i:0;O:22:\\\"App\\\\Entity\\\\System\\\\Role\\\":6:{s:26:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0id\\\";i:1;s:28:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0code\\\";s:10:\\\"ROLE_ADMIN\\\";s:28:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0name\\\";s:5:\\\"Admin\\\";s:40:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0shortDescription\\\";N;s:32:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0ordering\\\";i:1;s:29:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0users\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}}i:1;O:22:\\\"App\\\\Entity\\\\System\\\\Role\\\":6:{s:26:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0id\\\";i:2;s:28:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0code\\\";s:16:\\\"ROLE_SUPER_ADMIN\\\";s:28:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0name\\\";s:11:\\\"Super admin\\\";s:40:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0shortDescription\\\";N;s:32:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0ordering\\\";i:0;s:29:\\\"\\0App\\\\Entity\\\\System\\\\Role\\0users\\\";O:33:\\\"Doctrine\\\\ORM\\\\PersistentCollection\\\":2:{s:13:\\\"\\0*\\0collection\\\";O:43:\\\"Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\\":1:{s:53:\\\"\\0Doctrine\\\\Common\\\\Collections\\\\ArrayCollection\\0elements\\\";a:0:{}}s:14:\\\"\\0*\\0initialized\\\";b:0;}}}}s:14:\\\"\\0*\\0initialized\\\";b:1;}s:33:\\\"\\0App\\\\Entity\\\\System\\\\User\\0firstName\\\";s:7:\\\"chanond\\\";s:32:\\\"\\0App\\\\Entity\\\\System\\\\User\\0lastName\\\";s:12:\\\"buranabunpot\\\";s:12:\\\"\\0*\\0createdAt\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2023-07-12 03:05:37.000000\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:12:\\\"\\0*\\0updatedAt\\\";O:8:\\\"DateTime\\\":3:{s:4:\\\"date\\\";s:26:\\\"2023-07-12 03:08:00.000000\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:12:\\\"\\0*\\0createdBy\\\";N;s:12:\\\"\\0*\\0updatedBy\\\";N;s:12:\\\"\\0*\\0deletedBy\\\";N;}s:12:\\\"\\0*\\0updatedBy\\\";r:79;s:12:\\\"\\0*\\0deletedBy\\\";N;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:11:\\\"DFP linklek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:23:\\\"as.ur.service@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:37:\\\"Join DFP Linklek for manage your Data\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-17 10:56:56','2023-07-17 10:56:56',NULL),(3,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:41:\\\"registration/confirmation_email.html.twig\\\";i:1;N;i:2;a:3:{s:9:\\\"signedUrl\\\";s:178:\\\"https://dfp.linklek.com/verify/email?expires=1689605742&id=2&signature=kOOjLW8%2Fd%2BrYwQPPnPNv%2BahxEk6uXlkELdg5obKN2R8%3D&token=4caicp6pqhGbkI9V0ONuV%2BOzRdGFVO5oXHFxkInvzOU%3D\\\";s:19:\\\"expiresAtMessageKey\\\";s:26:\\\"%count% hour|%count% hours\\\";s:20:\\\"expiresAtMessageData\\\";a:1:{s:7:\\\"%count%\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:7:\\\"LinkLek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:23:\\\"as.ur.service@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:25:\\\"Please Confirm your Email\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-17 13:55:42','2023-07-17 13:55:42',NULL),(4,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:41:\\\"registration/confirmation_email.html.twig\\\";i:1;N;i:2;a:3:{s:9:\\\"signedUrl\\\";s:174:\\\"https://dfp.linklek.com/verify/email?expires=1689617925&id=3&signature=ZKqPHtdxbate6Dk8z3x%2FTur6nXkNZcUyE0M4r1BxA2Q%3D&token=WYLJLHAlKGIO9KyGQwzwcFln%2BMNxz9yLZuW5684hJnA%3D\\\";s:19:\\\"expiresAtMessageKey\\\";s:26:\\\"%count% hour|%count% hours\\\";s:20:\\\"expiresAtMessageData\\\";a:1:{s:7:\\\"%count%\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:7:\\\"LinkLek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:25:\\\"thapakorn.n@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:25:\\\"Please Confirm your Email\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-17 17:18:45','2023-07-17 17:18:45',NULL),(5,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:30:\\\"reset_password/email.html.twig\\\";i:1;N;i:2;a:1:{s:10:\\\"resetToken\\\";O:58:\\\"SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\\":4:{s:65:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0token\\\";s:40:\\\"6KcSut5964U1hRyLqzE4Pzkx7HgfcO556Q4iR1Sn\\\";s:69:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0expiresAt\\\";O:17:\\\"DateTimeImmutable\\\":3:{s:4:\\\"date\\\";s:26:\\\"2023-07-20 05:16:50.360942\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:3:\\\"UTC\\\";}s:71:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0generatedAt\\\";i:1689826610;s:73:\\\"\\0SymfonyCasts\\\\Bundle\\\\ResetPassword\\\\Model\\\\ResetPasswordToken\\0transInterval\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:11:\\\"DFP linklek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:23:\\\"as.ur.service@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:27:\\\"Your password reset request\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-20 04:16:50','2023-07-20 04:16:50',NULL),(6,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:41:\\\"registration/confirmation_email.html.twig\\\";i:1;N;i:2;a:3:{s:9:\\\"signedUrl\\\";s:171:\\\"https://localhost:8000/verify/email?expires=1689836756&id=4&signature=oWPWVRywovm7U3clDfYoviXjPfRqMMzy8kYtUyNmJj0%3D&token=Rgt1PQbN0xQSlS9En9gvBpUEEcXKhmIviJsXnck%2FFwA%3D\\\";s:19:\\\"expiresAtMessageKey\\\";s:26:\\\"%count% hour|%count% hours\\\";s:20:\\\"expiresAtMessageData\\\";a:1:{s:7:\\\"%count%\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:7:\\\"LinkLek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:24:\\\"rb.on.the.moon@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:25:\\\"Please Confirm your Email\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-20 06:05:56','2023-07-20 06:05:56',NULL),(7,'O:36:\\\"Symfony\\\\Component\\\\Messenger\\\\Envelope\\\":2:{s:44:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0stamps\\\";a:1:{s:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\";a:1:{i:0;O:46:\\\"Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\\":1:{s:55:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Stamp\\\\BusNameStamp\\0busName\\\";s:21:\\\"messenger.bus.default\\\";}}}s:45:\\\"\\0Symfony\\\\Component\\\\Messenger\\\\Envelope\\0message\\\";O:51:\\\"Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\\":2:{s:60:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0message\\\";O:39:\\\"Symfony\\\\Bridge\\\\Twig\\\\Mime\\\\TemplatedEmail\\\":4:{i:0;s:41:\\\"registration/confirmation_email.html.twig\\\";i:1;N;i:2;a:3:{s:9:\\\"signedUrl\\\";s:178:\\\"https://dfp.linklek.com/verify/email?expires=1689925901&id=6&signature=0MYd2NRR6%2FAuz5PigmqsnzKqhzzq3qLQY9dC%2FrYqNq8%3D&token=IK453OmV8JaGfcc%2Bo7LgSXLkEOHiGyOYIPyyb%2FGxHP0%3D\\\";s:19:\\\"expiresAtMessageKey\\\";s:26:\\\"%count% hour|%count% hours\\\";s:20:\\\"expiresAtMessageData\\\";a:1:{s:7:\\\"%count%\\\";i:1;}}i:3;a:6:{i:0;N;i:1;N;i:2;N;i:3;N;i:4;a:0:{}i:5;a:2:{i:0;O:37:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\\":2:{s:46:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0headers\\\";a:3:{s:4:\\\"from\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:4:\\\"From\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:22:\\\"contract@app-alive.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:7:\\\"LinkLek\\\";}}}}s:2:\\\"to\\\";a:1:{i:0;O:47:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:2:\\\"To\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:58:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\MailboxListHeader\\0addresses\\\";a:1:{i:0;O:30:\\\"Symfony\\\\Component\\\\Mime\\\\Address\\\":2:{s:39:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0address\\\";s:16:\\\"tatont@gmail.com\\\";s:36:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Address\\0name\\\";s:0:\\\"\\\";}}}}s:7:\\\"subject\\\";a:1:{i:0;O:48:\\\"Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\\":5:{s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0name\\\";s:7:\\\"Subject\\\";s:56:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lineLength\\\";i:76;s:50:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0lang\\\";N;s:53:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\AbstractHeader\\0charset\\\";s:5:\\\"utf-8\\\";s:55:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\UnstructuredHeader\\0value\\\";s:25:\\\"Please Confirm your Email\\\";}}}s:49:\\\"\\0Symfony\\\\Component\\\\Mime\\\\Header\\\\Headers\\0lineLength\\\";i:76;}i:1;N;}}}s:61:\\\"\\0Symfony\\\\Component\\\\Mailer\\\\Messenger\\\\SendEmailMessage\\0envelope\\\";N;}}','[]','default','2023-07-21 06:51:42','2023-07-21 06:51:42',NULL);
/*!40000 ALTER TABLE `messenger_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reset_password_request`
--

DROP TABLE IF EXISTS `reset_password_request`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reset_password_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `selector` varchar(20) NOT NULL,
  `hashed_token` varchar(100) NOT NULL,
  `requested_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `expires_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  PRIMARY KEY (`id`),
  KEY `IDX_7CE748AA76ED395` (`user_id`),
  CONSTRAINT `FK_7CE748AA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reset_password_request`
--

LOCK TABLES `reset_password_request` WRITE;
/*!40000 ALTER TABLE `reset_password_request` DISABLE KEYS */;
INSERT INTO `reset_password_request` VALUES (1,2,'6KcSut5964U1hRyLqzE4','6uZUibwOm93Z0+7g4b3SMVnJE7yIOsAwTUWnfriHNY8=','2023-07-20 04:16:50','2023-07-20 05:16:50');
/*!40000 ALTER TABLE `reset_password_request` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role`
--

DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role`
--

LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES (1,'ROLE_ADMIN','Admin',NULL,1),(2,'ROLE_SUPER_ADMIN','Super admin',NULL,0),(3,'ROLE_CLIENT','Client',NULL,2);
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unit`
--

DROP TABLE IF EXISTS `unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `floor_plan_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(255) NOT NULL,
  `internal_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `status` varchar(50) NOT NULL,
  `cover_image` longtext DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  `ordering` int(11) NOT NULL,
  `total_area` double DEFAULT NULL,
  `room_image` longtext DEFAULT NULL,
  `room_image_size` int(11) DEFAULT NULL,
  `room_position_x` double DEFAULT NULL,
  `room_position_y` double DEFAULT NULL,
  `room_filter_color_code` varchar(50) DEFAULT NULL,
  `remark` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `detail` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_DCBB0C53485C8857` (`floor_plan_id`),
  CONSTRAINT `FK_DCBB0C53485C8857` FOREIGN KEY (`floor_plan_id`) REFERENCES `floor_plan` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit`
--

LOCK TABLES `unit` WRITE;
/*!40000 ALTER TABLE `unit` DISABLE KEYS */;
INSERT INTO `unit` VALUES ('�N��uؤ�컹�l','�H�urƈ�s��v�','B01',NULL,'Success Gems','active',NULL,NULL,1,32,'b1-x1518-2616-y344-0555-64d34f8f8d7e7510328942.png',279,1518.2616,344.0555,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-16 14:53:07','2023-08-09 08:34:23',NULL),('�N��z����̈�','�H�urƈ�s��v�','B01A',NULL,'Color Masters','active','b1a-x1558-1698-y343-7176-64b63f8c8e770019990520.png',385,2,58,'b1a-x1558-1698-y343-7176-64d34f703bde0743179201.png',430,1558.1698,343.7176,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:30:20','2023-08-09 08:33:52',NULL),('�N� p+�7�J�!b','�H�urƈ�s��v�','B01B',NULL,'Deluxe Gems International','active',NULL,NULL,3,92.06,'b1b-x1609-383-y344-1226-64d34f83ac0d5452256450.png',741,1609.383,344.1226,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:31:11','2023-08-09 08:34:11',NULL),('�N�kxV��\'$Z�!U','�H�urƈ�s��v�','B02',NULL,'A.U.E. Gems','active',NULL,NULL,4,51.5,'b2-x1480-5867-y345-3569-64d34fa36de97912177206.png',420,1480.5867,345.3569,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:31:46','2023-08-09 08:34:43',NULL),('�N��z�@�.�39<','�H�urƈ�s��v�','B03',NULL,'Charasri White Gold','active',NULL,NULL,5,61.89,'b3-x1423-5665-y346-4446-64d34fbaad282001201568.png',573,1423.5665,346.4446,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:35:14','2023-08-09 08:35:06',NULL),('�N��~_�k�גN�','�H�urƈ�s��v�','B04A',NULL,'Beautiful Color Stone','active',NULL,NULL,6,33.86,'b4a-x1337-7437-y349-805-64d34fbe4cec0687743000.png',340,1337.7437,349.805,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:35:57','2023-08-09 08:35:10',NULL),('�N�	Q{�w�7��y','�H�urƈ�s��v�','B04B',NULL,'RMC Gems Thai','active',NULL,NULL,7,35.23,'b4b-x1371-3189-y349-2424-64d34fd1acb09843510580.png',402,1371.3189,349.2424,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:36:15','2023-08-09 08:35:29',NULL),('�N�	�|��6	}|��','�H�urƈ�s��v�','B05',NULL,'Beauty Pearl and Silver','active',NULL,NULL,8,63.26,'b5-x1283-2897-y1283-2897-64d34ff0e17d5929118723.png',611,1283.2897,1283.2897,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:36:24','2023-08-09 08:36:00',NULL),('�N�	�}���lg1Z','�H�urƈ�s��v�','B06A',NULL,'Happy Gems & Jewelry','active',NULL,NULL,9,41.69,'b6a-x1227-0978-y354-0373-64d3501ecf73a578983223.png',574,1227.0978,354.0373,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 07:36:35','2023-08-09 08:36:46',NULL),('�N�\n-t��*{o��Y�','�H�urƈ�s��v�','B06B',NULL,'Iskkon','active',NULL,NULL,10,40.77,'b6b-x1189-8044-y354-1282-64d35027ad1b6304641425.png',462,1189.8044,354.1282,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:56:45','2023-08-09 08:36:55',NULL),('�N�\n}p����5\Zi?�','�H�urƈ�s��v�','B07A',NULL,'KKS Jewelry','active',NULL,NULL,11,42,'b7a-x1154-1467-y355-797-64d35032a5af0133354038.png',407,1154.1467,355.797,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 09:23:24','2023-08-09 08:37:06',NULL),('�N�\n�|/�\r-{��','�H�urƈ�s��v�','B07B',NULL,'MAZHAR THAI GEMS','active',NULL,NULL,12,39.18,'b7b-x1116-7162-y355-8608-64d350375816e866960193.png',407,1116.7162,355.8608,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 09:23:50','2023-08-09 08:37:11',NULL),('�N�y���Qs\0�','�H�urƈ�s��v�','B07C',NULL,'Anbu Gems','active',NULL,NULL,13,6.39,'b7c-x1085-2829-y378-3666-64d3504bb181b687186518.png',477,1085.2829,378.3666,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 09:24:47','2023-08-09 08:37:31',NULL),('�N�^qQ�<w`y�Ŷ','�H�urƈ�s��v�','B08',NULL,'Z.M.I Gems & Jewelry','active',NULL,NULL,14,65.69,'b8-x1042-49-y345-874-64d350544e66c788076288.png',648,1042.49,345.874,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 09:25:08','2023-08-09 08:37:40',NULL),('�N��x���9�\"X?h','�H�urƈ�s��v�','B09A-09B',NULL,'Eklada Jewelry','active',NULL,NULL,15,32,'b9a-b-x959-0633-y344-1209-64d35066b87a2090791356.png',377,959.0633,344.1209,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:08:05','2023-08-09 08:37:58',NULL),('�N��v`�T����ȷ','�H�urƈ�s��v�','B09C-09E',NULL,'Brother Gems','active',NULL,NULL,16,32,'b9c-e-x898-7545-y345-8969-64d350b838ba7786455869.png',316,898.7545,345.8969,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:08:51','2023-08-09 08:39:20',NULL),('�N�\'sf��Ҁu�y�','�H�urƈ�s��v�','B09F-B10',NULL,'Sadruddin Jewellers International','active',NULL,NULL,17,31,'b9-10-x834-392-y345-8969-64b6656eb6afd134590438.png',298,834.392,345.8969,'#000000','',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:11:58','2023-07-24 11:03:57',NULL),('�N�Pz���s��+�','�H�urƈ�s��v�','B11',NULL,'Precious Colour Gems','active',NULL,NULL,18,15,'b11-x786-5399-y345-8969-64d351c56fa24324028531.png',193,786.5399,345.8969,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:12:10','2023-08-09 08:43:49',NULL),('�N��|إAk(O��','�H�urƈ�s��v�','B12',NULL,'Cattleya','active',NULL,NULL,19,15,'b12-x760-2066-y345-9044-64d351d07e7ea370661860.png',185,760.2066,345.9044,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:12:21','2023-08-09 08:44:00',NULL),('�N��vʢt6��F3','�H�urƈ�s��v�','B13-B14',NULL,'Y.Co Gems','active',NULL,NULL,20,21.52,'b13-14-x726-6406-y345-8969-64d351e1e0e7f812120951.png',193,726.6406,345.8969,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:12:35','2023-08-09 08:44:17',NULL),('�N�@vQ�2��_F\r','�H�urƈ�s��v�','B15',NULL,'Panash Gems International','active',NULL,NULL,21,21.48,'b15-x688-2281-y345-9322-64d351f9a86b9443116055.png',205,688.2281,345.9322,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:13:13','2023-08-09 08:44:41',NULL),('�N��q!�K�v,y��','�H�urƈ�s��v�','B16',NULL,'D.D Thailand Jewelry & Gold','active',NULL,NULL,22,23,'b16-x648-081-y345-9528-64d35202d0f5c641983144.png',360,648.081,345.9528,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:13:22','2023-08-09 08:44:50',NULL),('�N��p��KU\"��p','�H�urƈ�s��v�','B16B/1',NULL,'Genuine Gems & Jewelry','active',NULL,NULL,23,112,'b16b1-x590-4393-y289-062-64d4af3e5f6e8465739441.png',519,590.4393,289.062,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:13:33','2023-08-10 09:34:54',NULL),('�N�x�Hv���>','�H�urƈ�s��v�','B16B/2',NULL,'B16B/2','active',NULL,NULL,24,104,'b16b2-x527-3659-y289-3817-64d4af43bb715996252143.png',448,527.3659,289.3817,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:13:42','2023-08-10 09:34:59',NULL),('�N�hq����Yt�','�H�urƈ�s��v�','B22',NULL,'B22','active',NULL,NULL,25,113,'b22-x473-3865-y827-142-64d35284d838a993254123.png',1089,473.3865,827.142,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:14:07','2023-08-09 08:47:00',NULL),('�N��{��E�+�$�','�H�urƈ�s��v�','B23',NULL,'AIGS LAB','active','b23x593-0869y827-9459-64afcb42ea9fa953105852.svg',2863,26,168.75,'b23-x593-0869-y827-9459-64d3529bd223f839707451.png',483,593.0869,827.9459,'#10da39',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-15 03:31:18','2023-08-09 08:47:23',NULL),('�N�s��]��kԚ.','�H�urƈ�s��v�','B24A',NULL,'AIGS LAB','active',NULL,NULL,27,36.26,'b24a-x687-0215-y828-6654-64d352b58ffac558148151.png',318,687.0215,828.6654,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:14:29','2023-08-09 08:47:49',NULL),('�N�Uy��\ZA���','�H�urƈ�s��v�','B24B',NULL,'AIGS LAB','active',NULL,NULL,28,55.15,'b24b-x725-1251-y828-5778-64d352bac51a8381835865.png',302,725.1251,828.5778,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:14:41','2023-08-09 08:47:54',NULL),('�N��|ۃ@_�h�`�','�H�urƈ�s��v�','B25A',NULL,'AIGS LAB','active',NULL,NULL,29,91.85,'b25a-x783-4603-y828-9271-64d352dc6ef38947535973.png',440,783.4603,828.9271,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:14:50','2023-08-09 08:48:28',NULL),('�N��}t�1�~�','�H�urƈ�s��v�','B25BC',NULL,'AIGS LAB','active',NULL,NULL,30,101.6,'b25b-c-x867-6994-y827-9954-64d352e175bbb371404337.png',410,867.6994,827.9954,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:15:26','2023-08-09 08:48:33',NULL),('�N�4x��P)\"mmʓ','�H�urƈ�s��v�','B25D',NULL,'AIGS LAB','active',NULL,NULL,31,36.62,'b25d-x938-0127-y855-3363-64d352f1c4ff3697482137.png',207,938.0127,855.3363,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:15:35','2023-08-09 08:48:49',NULL),('�N��{B��-MI�','�H�urƈ�s��v�','B33',NULL,'Atiya Gems','active',NULL,NULL,32,51,'b33-x843-1287-y592-2947-64d352fabd6a8400813287.png',482,843.1287,592.2947,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:15:44','2023-08-09 08:48:58',NULL),('�N��r����3ғ�','�H�urƈ�s��v�','B34',NULL,'Rainbow Mineral & Crystal','active',NULL,NULL,33,41,'b34-x886-3172-y592-4893-64d3530fe0da3372722470.png',361,886.3172,592.4893,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:15:53','2023-08-09 08:49:19',NULL),('�N�͍E�5�:\n>','�H�urƈ�s��v�','B35',NULL,'AB Impex','active',NULL,NULL,34,72,'b35-x946-0972-y574-8504-64d35316d52e7327678515.png',356,946.0972,574.8504,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:16:10','2023-08-09 08:49:26',NULL),('�N�U��}�\Z','�H�urƈ�s��v�','B36',NULL,'MNT 2017','active',NULL,NULL,35,72.93,'b36-x1020-5472-y592-3969-64d35355982ae462522237.png',583,1020.5472,592.3969,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:16:23','2023-08-09 08:50:29',NULL),('�N��y·� @�\n2','�H�urƈ�s��v�','B37',NULL,'Cometrue Jewellry','active',NULL,NULL,36,38.46,'b37-x1083-2231-y545-0503-64d3535dabf7b757225537.png',573,1083.2231,545.0503,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:16:33','2023-08-09 08:50:37',NULL),('�N��pE�z����x','�H�urƈ�s��v�','B38 AB',NULL,'B38 AB','active',NULL,NULL,37,32,'b38ab-x1125-4593-y538-9456-64d35391d660b064763571.png',488,1125.4593,538.9456,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:16:45','2023-08-09 08:51:29',NULL),('�N�\'t����*�0�','�H�urƈ�s��v�','B38A',NULL,'Zarghon Gems','active',NULL,NULL,38,31,'b38a-x1158-7089-y538-0802-64d35381b35b2141161728.png',508,1158.7089,538.0802,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:16:54','2023-08-09 08:51:13',NULL),('�N�wu7����\'�','�H�urƈ�s��v�','B38B',NULL,'MMK & FAH','active',NULL,NULL,39,25.4,'b38b-x1195-8255-y534-6288-64d353bed8c12559137107.png',436,1195.8255,534.6288,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:17:04','2023-08-09 08:52:14',NULL),('�N��qa���w��n','�H�urƈ�s��v�','B39',NULL,'Sparkle Global Gems','active',NULL,NULL,40,45.86,'b39-x1277-6324-y532-0752-64d353c1cf53c342921492.png',403,1277.6324,532.0752,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:19:01','2023-08-09 08:52:17',NULL),('�N��y������8�','�H�urƈ�s��v�','B40',NULL,'Ders International','active',NULL,NULL,41,36.78,'b40-x1359-083-y528-0993-64d353c888b19411892100.png',444,1359.083,528.0993,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:19:07','2023-08-09 08:52:24',NULL),('�N�Evԡ���g','�H�urƈ�s��v�','B42',NULL,'Sun Moon Star','active',NULL,NULL,42,61.26,'b42-x1536-9067-y518-6372-64d35419455c4006543498.png',546,1536.9067,518.6372,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:19:13','2023-08-09 08:53:45',NULL),('�N��tؓi�Mi�','�H�urƈ�s��v�','B43',NULL,'UPSC Thailand','active',NULL,NULL,43,89.07,'b43-x1618-1348-y508-9907-64d3541e9f4df181207437.png',773,1618.1348,508.9907,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:19:22','2023-08-09 08:53:50',NULL),('�N��x����)lҧ&','�H�urƈ�s��v�','B17 & B17/1',NULL,'B17 & B17/1','active',NULL,NULL,44,100.4,'b17-b17-1-x493-5812-y423-5237-64d4af914764c351937613.png',476,493.5812,423.5237,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:13:55','2023-08-10 09:36:17',NULL),('�N�5q~�G��>�B�','�H�urƈ�s��v�','B16A',NULL,'Bangkok','active',NULL,NULL,45,505.51,'bbl-x367-9306-y283-1148-64c782941aeec550848578.png',764,367.9306,283.1148,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:30:18','2023-07-31 09:44:52',NULL),('�N�|{֋�l��*y','�N�ڱs;����]�','Bangkok',NULL,'Bangkok','active',NULL,NULL,46,212.53,'bbl-x261-5165-y289-3943-64b66b33080d9677737992.png',642,261.5165,289.3943,'#000000','',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:36:35','2023-07-20 05:15:23',NULL),('�N��~ �ԕ��aa','�N�ڱs;����]�','Mama Cafe',NULL,'Mama Cafe','active',NULL,NULL,47,25,'cafe-dc-x663-9262-y557-8929-64d354af58156751664043.png',781,663.9262,557.8929,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:31:25','2023-09-16 16:05:56',NULL),('�N�~ݶ�F��6��','�N�ڱs;����]�','No. 130AB/1',NULL,'No. 130AB/1','active',NULL,NULL,48,67.35,'130ab-1-x-812-0052-y527-8242-64d4b000e7ee4352881067.png',570,812.36,527.824,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:34:59','2023-09-16 16:14:39',NULL),('�N�LuE�x�nZ��','�N�ڱs;����]�','No.101',NULL,'VP Gemstone','active',NULL,NULL,49,49.83,'101-x1564-0867-y332-8177-64d3551230daa982676130.png',404,1564.0867,332.8177,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:26:24','2023-08-09 08:57:54',NULL),('�N��z.�ʂkX,�','�N�ڱs;����]�','No.102-103',NULL,'No.102-103','active',NULL,NULL,50,73.04,'102-103-x1436-7307-y347-6374-64d35524af745434764669.png',685,1436.7307,347.6374,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:26:36','2023-08-09 08:58:12',NULL),('�N��xU�qj*�cxf','�N�ڱs;����]�','No.104',NULL,'JLR','active',NULL,NULL,51,28.12,'104-x1222-4473-y355-2246-64d3552ae757f135147815.png',388,1222.4473,355.2246,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:26:49','2023-08-09 08:58:18',NULL),('�N�Ft����^�H','�N�ڱs;����]�','No.105',NULL,'Thai Gem Center','active',NULL,NULL,52,45.98,'105-x1158-5804-y356-416-64d3552eb0f59911317277.png',535,1158.5804,356.416,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:25:26','2023-08-09 08:58:22',NULL),('�N��t��M�B��l0','�N�ڱs;����]�','No.106',NULL,'HSIN YI','active',NULL,NULL,53,33.7,'106-x1093-7846-y360-1585-64d3555f53b38940233288.png',424,1093.7846,360.1585,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:25:39','2023-08-09 08:59:11',NULL),('�N��uQ����o��','�N�ڱs;����]�','No.107',NULL,'Ann Gems','active',NULL,NULL,54,27.61,'107-x1035-7269-y360-5556-64d35562aef6a636921778.png',578,1035.7269,360.5556,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:25:47','2023-08-09 08:59:14',NULL),('�N�\Z)s�7w��;`','�N�ڱs;����]�','No.108A',NULL,'Gemma International','active',NULL,NULL,55,51.08,'108a-x879-9357-y365-6205-64d355666da40860690888.png',729,879.9357,365.6205,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:25:56','2023-08-09 08:59:18',NULL),('�N�\Z�p��f��\Z���','�N�ڱs;����]�','No.108B',NULL,'No.108B','active',NULL,NULL,56,31.95,'108b-x817-7574-y375-5907-64d3556b4fdba160494958.png',280,817.7574,375.5907,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:26:05','2023-08-09 08:59:23',NULL),('�N�\Z�|,��j�4�y!','�N�ڱs;����]�','No.109',NULL,'Maron Gems','active',NULL,NULL,57,50.8,'109-x769-5201-y365-4661-64d3556f17c7b428856945.png',381,769.5201,365.4661,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:26:13','2023-08-09 08:59:27',NULL),('�N�(}՚��<RxR','�N�ڱs;����]�','No.110',NULL,'Gem Dream','active',NULL,NULL,58,63.25,'110-x703-3976-y381-999-64d355748111b116752462.png',623,703.3976,381.999,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:26:22','2023-08-09 08:59:32',NULL),('�N�qqD��aVͻ�4','�N�ڱs;����]�','No.111',NULL,'Jean Import','active',NULL,NULL,59,73.56,'111-x642-3094-y381-7177-64d35726119d7418245319.png',385,642.3094,381.7177,'#000000','Lingerie & Children',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:26:32','2023-08-09 09:06:46',NULL),('�N��w��s�M�T�','�N�ڱs;����]�','No.112-115',NULL,'Mark & Spenser (M&S)','active',NULL,NULL,60,274,'112-115-x514-7662-y369-7568-64d3572978ac2778653901.png',994,514.7662,369.7568,'#000000','M&S Outlet',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:26:40','2023-08-09 09:06:49',NULL),('�N�}��-�+�l��','�N�ڱs;����]�','No.116A',NULL,'KASIKORN BANK','active',NULL,NULL,61,114.76,'116a-x485-3495-y259-3349-64d3572dc1525627133155.png',386,485.3495,259.3349,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 12:26:53','2023-08-09 09:06:53',NULL),('�N�_�$�`o�(k','�N�ڱs;����]�','No.117-118',NULL,'FootWork Void','active',NULL,NULL,62,221.34,'117-118-x261-0216-y471-0121-64d35731a7577247859034.png',681,261.0216,471.0121,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 17:59:46','2023-08-09 09:06:57',NULL),('�N��u���S[v','�N�ڱs;����]�','No.119',NULL,'Crocs','active',NULL,NULL,63,47,'119-x411-3727-y637-5122-64d3573588169008156886.png',1236,411.3727,637.5122,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 17:59:58','2023-08-09 09:07:01',NULL),('�N��wV��<^jq�','�N�ڱs;����]�','No.120-124',NULL,'Woman\'s department','active',NULL,NULL,64,824,'120-124-x617-5862-y774-51-64d35739c1ef9024755579.png',2016,617.5862,774.51,'#000000','Import Brands. (Young miss /Accessories/ Watches /Shoes & Handbags Men’s Wear/ Luggage)',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:00:11','2023-08-09 09:07:05',NULL),('�N�BvV�H� ?,','�N�ڱs;����]�','No.126-127',NULL,'Import Brand department','active',NULL,NULL,65,113,'126-127-x765-1845-y618-5649-64d3573dd1111920303204.png',1007,765.1845,618.5649,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:00:34','2023-08-09 09:07:09',NULL),('�N�����	Oݿy�','�N�ڱs;����]�','No.130',NULL,'Pornchai International','active',NULL,NULL,66,106.5,'130-x879-7882-y527-7036-64d357426220c123238153.png',835,879.7882,527.7036,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:00:52','2023-08-09 09:07:14',NULL),('�N��x���n|P5','�N�ڱs;����]�','No.131',NULL,'PPR Collection','active',NULL,NULL,67,23.75,'131-x1040-7979-y509-9313-64d3574a64b5a522877460.png',508,1040.7979,509.9313,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:01:06','2023-08-09 09:07:22',NULL),('�N�Br7���f¹Y','�N�ڱs;����]�','No.132',NULL,'Blue Star','active',NULL,NULL,68,20.59,'132-x1123-4046-y497-7625-64d3574f8acfe561029570.png',257,1123.4046,497.7625,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:01:17','2023-08-09 09:07:27',NULL),('�N��}�Dq�cU�@','�N�ڱs;����]�','No.133',NULL,'Formico','active',NULL,NULL,69,47.16,'133-x1230-5092-y522-7337-64d357b0dbf9a978418430.png',360,1230.5092,522.7337,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:01:27','2023-08-09 09:09:04',NULL),('�N��we�E��ȓ','�N�ڱs;����]�','No.134',NULL,'Pamir Gems','active',NULL,NULL,70,36.31,'134-x1315-4613-y517-0372-64d357b4c9135430833054.png',392,1315.4613,517.0372,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:01:35','2023-08-09 09:09:08',NULL),('�N�,~������Ǩ','�N�ڱs;����]�','No.135',NULL,'Top Gems','active',NULL,NULL,71,87.28,'135-x1569-5847-y516-9994-64d357b90eb36453574408.png',521,1569.5847,516.9994,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:01:44','2023-08-09 09:09:13',NULL),('�N�rڷN�G�o','�N�ڱs;����]�','No.137',NULL,'Naza Anna','active',NULL,NULL,72,37.92,'137-x1489-0286-y514-8412-64d357bd3d850494098576.png',441,1489.0286,514.8412,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:02:15','2023-08-09 09:09:17',NULL),('�N��u�����\"X�','�N�ڱs;����]�','No128-129',NULL,'Gems Store','active',NULL,NULL,73,79,'128-129-x745-9084-y509-5043-64d4b14fe173c193622867.png',725,745.9084,509.5043,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-20 05:15:23','2023-08-10 09:43:43',NULL),('�N� v���c˷��','�N�vxu@����9[��','No. 212-215',NULL,'The Outlet 24','active',NULL,NULL,74,810,'212-215-x384-0504-y348-5635-64d3587899a84181560562.png',1814,384.0504,348.5635,'#000000','The Outlet24',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:35:24','2023-08-09 09:12:24',NULL),('�N� Euх+L\'��h�','�N�vxu@����9[��','No. 216-217',NULL,'Office Mate','active',NULL,NULL,75,380,'216-217-x270-2598-y549-5549-64d3587f0930b403309930.png',1192,270.2598,549.5549,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:38:20','2023-08-09 09:12:31',NULL),('�N� �9��CšsB','�N�vxu@����9[��','No.201',NULL,'Gems.Stock.Org','active',NULL,NULL,76,59.74,'201-x1489-1919-y370-5424-64d3588ea289a818584070.png',530,1489.1919,370.5424,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:02:38','2023-08-09 09:12:46',NULL),('�N� �w�MF�|wl','�N�vxu@����9[��','No.202',NULL,'No.202','active',NULL,NULL,77,49.71,'202-x1406-7052-y375-5556-64d358920c955565836050.png',618,1406.7052,375.5556,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:02:54','2023-08-09 09:12:50',NULL),('�N�!@t�|D3��D','�N�vxu@����9[��','No.203',NULL,'Spinel Gallery','active',NULL,NULL,78,61.21,'203-x1332-2502-y378-0436-64d3589678ca4721846730.png',485,1332.2502,378.0436,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:01','2023-08-09 09:12:54',NULL),('�N�!�y��QX�n��\0','�N�vxu@����9[��','No.204',NULL,'Trocadero Collection','active',NULL,NULL,79,49.56,'204-x1259-8885-y382-465-64d35919254fe367413329.png',657,1259.8885,382.465,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:08','2023-08-09 09:15:05',NULL),('�N�!�v��!>J|js','�N�vxu@����9[��','No.205',NULL,'Rida Creation','active',NULL,NULL,80,68.27,'205-x1180-3265-y384-9668-64d3591c4ded9635199013.png',655,1180.3265,384.9668,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:14','2023-08-09 09:15:08',NULL),('�N�\")v���EH�.C�','�N�vxu@����9[��','No.206',NULL,'Jinheng (BANGKOK)','active',NULL,NULL,81,50.87,'206-x1108-1109-y386-9879-64d3592063d21661534738.png',510,1108.1109,386.9879,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:20','2023-08-09 09:15:12',NULL),('�N�\"�vh���ۈM�$','�N�vxu@����9[��','No.207',NULL,'White Star','active',NULL,NULL,82,45.96,'207-x1045-9631-y387-9407-64d359242e9c4766922472.png',634,1045.9631,387.9407,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:27','2023-08-09 09:15:16',NULL),('�N�\"�t�[|<ճ�','�N�vxu@����9[��','No.208',NULL,'No.208','active',NULL,NULL,83,87.32,'208-x884-2719-y412-3395-64d35927d84ee579286614.png',799,884.2719,412.3395,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:33','2023-08-09 09:15:19',NULL),('�N�#rñ�h�n�','�N�vxu@����9[��','No.209',NULL,'Collection Gems','active',NULL,NULL,84,36.33,'209-x799-0545-y412-1305-64d3592ae17d4558700845.png',361,799.0545,412.1305,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:03:40','2023-08-09 09:15:22',NULL),('�N�#[uٻ�?�D\0��','�N�vxu@����9[��','No.209A',NULL,'Raja Gems','active',NULL,NULL,85,36.33,'209a-x740-683-y410-8103-64d3592e93ccd501575503.png',376,740.683,410.8103,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:04:13','2023-08-09 09:15:26',NULL),('�N�#�uӖ\"(^�!�^','�N�vxu@����9[��','No.210',NULL,'Diamond Dreams Bangkok','active',NULL,NULL,86,67,'210-x682-3082-y425-8651-64d359333739e643270001.png',751,682.3082,425.8651,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:04:23','2023-08-09 09:15:31',NULL),('�N�#�~��.��}�','�N�vxu@����9[��','No.211',NULL,'No.211','active',NULL,NULL,87,72,'211-x619-9772-y426-3821-64d359373a5bc949464039.png',360,619.9772,426.3821,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:04:34','2023-08-09 09:15:35',NULL),('�N�$7yw�6z�l豞','�N�vxu@����9[��','No.212',NULL,'No.212','active',NULL,NULL,88,73,'212-x556-4249-y426-4478-64d3593c2d7b4685877655.png',509,556.4249,426.4478,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:04:44','2023-08-09 09:15:40',NULL),('�N�$}sU�񿊕q��','�N�vxu@����9[��','No.218',NULL,'Kid\'s department','active',NULL,NULL,89,31.81,'218-x410-0618-y676-7894-64d359930d0c3693724419.png',1087,410.0618,676.7894,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:04:55','2023-08-09 09:17:07',NULL),('�N�$�������','�N�vxu@����9[��','No.218-223',NULL,'Kid\'s department','active',NULL,NULL,90,836,'218-223-x622-7492-y771-5268-64d359969b447290764620.png',3609,622.7492,771.5268,'#000000','(Lingerie /Children/Houseware',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:05:03','2023-08-09 09:17:10',NULL),('�N�%\Zst�*�Ƨl��','�N�vxu@����9[��','No.230-231',NULL,'No.230-231','active',NULL,NULL,91,120,'230-231-x794-3797-y659-6195-64d3599a2cd6c698287603.png',1004,794.3797,659.6195,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:05:57','2023-08-09 09:17:14',NULL),('�N�%Yu@��qa�~B','�N�vxu@����9[��','No.232',NULL,'No.232','active',NULL,NULL,92,83.9,'232-x794-0209-y577-1233-64d3599de0d35078111098.png',481,794.0209,577.1233,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:06:08','2023-08-09 09:17:17',NULL),('�N�%�s�����90V','�N�vxu@����9[��','No.233A',NULL,'Manihar International','active',NULL,NULL,93,42.03,'233a-x832-2698-y526-5323-64d359a54c1fc966980116.png',366,832.2698,526.5323,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:06:18','2023-08-09 09:17:25',NULL),('�N�%�z���Y��) |','�N�vxu@����9[��','No.233B',NULL,'No.233B','active',NULL,NULL,94,39.25,'233b-x758-2989-y526-0857-64d359ab55fbb823336462.png',576,758.2989,526.0857,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:06:29','2023-08-09 09:17:31',NULL),('�N�&9w�Wy��\0�!','�N�vxu@����9[��','No.234',NULL,'Starlanka','active',NULL,NULL,95,85.39,'234-x902-6426-y570-3257-64d359afb8492271558112.png',1011,902.6426,570.3257,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:06:54','2023-08-09 09:17:35',NULL),('�N�&�rr��:T�� U','�N�vxu@����9[��','No.235',NULL,'Gem Park International','active',NULL,NULL,96,59.56,'235-x1058-7374-y571-0693-64d359b4151d6124475364.png',665,1058.7374,571.0693,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:07:03','2023-08-09 09:17:40',NULL),('�N�&�p����?','�N�vxu@����9[��','No.236A',NULL,'Dazzle Gems','active',NULL,NULL,97,36,'236a-x1120-0562-y567-8229-64d359b82a2c2589932340.png',529,1120.0562,567.8229,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:07:13','2023-08-09 09:17:44',NULL),('�N�\'3|+���}K�','�N�vxu@����9[��','No.236B',NULL,'Zafs International','active',NULL,NULL,98,31.2,'236b-x1165-2729-y566-9509-64d359be2bd5f519934305.png',482,1165.2729,566.9509,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:07:23','2023-08-09 09:17:50',NULL),('�N�\'�}ݔ�����','�N�vxu@����9[��','No.237',NULL,'No.237','active',NULL,NULL,99,47.16,'237-x1253-0414-y563-7539-64d35a06552cf632935688.png',278,1253.0414,563.7539,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:07:36','2023-08-09 09:19:02',NULL),('�N�\'�y�$6B��\\�','�N�vxu@����9[��','No.238',NULL,'No.238','active',NULL,NULL,100,29.03,'238-x1333-5523-y558-459-64d35a0abebdf075140199.png',383,1333.5523,558.459,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:07:45','2023-08-09 09:19:06',NULL),('�N�(-{�Ղ�-$Z','�N�vxu@����9[��','No.241A',NULL,'Pearl Depot','active',NULL,NULL,101,102,'241a-x1610-7153-y361-779-64d35a0e9832a520476001.png',742,1610.7153,361.779,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:08:49','2023-08-09 09:19:10',NULL),('�N�(x{� ��b','�N�vxu@����9[��','No.241BAB',NULL,'Aqua Gems','active',NULL,NULL,102,51.1,'241bab-x1654-5512-y557-4359-64d35a2ba8d6e649674887.png',412,1654.5512,557.4359,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:09:00','2023-08-09 09:19:39',NULL),('�N�(�zf���ͬ?��','�N�vxu@����9[��','No.241BC',NULL,'Vibhav International','active',NULL,NULL,103,40,'241bc-x1577-535-y560-8808-64d35a2f3fcda233793640.png',403,1577.535,560.8808,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-20 05:15:23','2023-08-09 09:19:43',NULL),('�N�)t�?¾���','�N�vxu@����9[��','No.24O',NULL,'Ta Thoo Aung','active',NULL,NULL,104,40,'240-x1515-2947-y555-4396-64d35a3493a72559062348.png',490,1515.2947,555.4396,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:09:31','2023-08-09 09:19:48',NULL),('�N�)e~֓��}em�','�N���}��2`h�M','JTC Office Management',NULL,'JTC Office Management','active',NULL,NULL,105,170,'jtc-x228-7582-y297-931-64d35cbee1446652804784.png',716,228.7582,297.931,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 10:35:46','2023-08-09 09:30:38',NULL),('�N�)���7Nϓf˔','�N���}��2`h�M','No. 310',NULL,'TJB Gems','active',NULL,NULL,106,36.11,'310-x796-2374-y418-8344-64d35ab07cd2b641415061.png',269,796.2374,418.8344,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:23:44','2023-08-09 09:21:52',NULL),('�N�*\nrн7��Q�Ѭ','�N���}��2`h�M','No. 311-313',NULL,'No. 311-313','active',NULL,NULL,107,540,'311-313-x536-1692-y356-7621-64d35ac302cea557971699.png',1866,536.1692,356.7621,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:24:01','2023-08-09 09:22:11',NULL),('�N�*Y~)�e�S��#�','�N���}��2`h�M','No. 313BA',NULL,'No. 313BA','active',NULL,NULL,108,232.26,'313ba-x365-114-y327-3906-64d35ace4710f671347109.png',1065,365.114,327.3906,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:24:15','2023-08-09 09:22:22',NULL),('�N�*�tY�w�]5k�','�N���}��2`h�M','No. 318-323',NULL,'No. 318-323','active',NULL,NULL,109,857,NULL,NULL,NULL,NULL,NULL,'',NULL,'chanond.b@app-alive.com',NULL,'2023-07-20 05:15:23','2023-07-20 05:15:23',NULL),('�N�*�v�r6\'\n�O','�N���}��2`h�M','No. 328-332',NULL,'No. 328-332','active',NULL,NULL,110,285.5,NULL,NULL,NULL,NULL,NULL,'',NULL,'chanond.b@app-alive.com',NULL,'2023-07-20 05:15:23','2023-07-20 05:15:23',NULL),('�N�+0t���b���','�N���}��2`h�M','No. 3S01',NULL,'No. 3S01','active',NULL,NULL,111,64.7,'3s01-x741-8265-y432-4876-64d35b2d5c174919543581.png',664,741.8265,432.4876,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 11:25:52','2023-08-09 09:23:57',NULL),('�N�+pql��31��4|','�N���}��2`h�M','No.301',NULL,'Pak Ariana co.,ltd.','active',NULL,NULL,112,63.44,'301-x1501-9122-y374-271-64d35b66bb072031525322.png',678,1501.9122,374.271,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:11:32','2023-08-09 09:24:54',NULL),('�N�+�|~�!�\Zܼ�','�N���}��2`h�M','No.302',NULL,'GIL','active',NULL,NULL,113,52.45,'302-x1417-705-y381-1276-64d35b6c1b9d2122317307.png',559,1417.705,381.1276,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:11','2023-08-09 09:25:00',NULL),('�N�,\rq��>��wm	K','�N���}��2`h�M','No.303',NULL,'No.303','active',NULL,NULL,114,61.05,'303-x1345-0863-y385-7018-64d35b7223e4a461372654.png',572,1345.0863,385.7018,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:20','2023-08-09 09:25:06',NULL),('�N�,o|��f�o�$h,','�N���}��2`h�M','No.304',NULL,'Rigthteous Gems co.,ltd.','active',NULL,NULL,115,52.45,'304-x1268-5949-y385-7018-64d35b790c871528341095.png',665,1268.5949,385.7018,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:27','2023-08-09 09:25:13',NULL),('�N�,�{X�ݏ�[�vs','�N���}��2`h�M','No.305A',NULL,'Patcharee Gems','active',NULL,NULL,116,36.83,'305a-x1168-3781-y388-6411-64d35b7fd5986740733152.png',779,1168.3781,388.6411,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:35','2023-08-09 09:25:19',NULL),('�N�-r�W�5M','�N���}��2`h�M','No.305B',NULL,'A.B.C. Stone','active',NULL,NULL,117,35.83,'305b-x1208-4602-y387-9679-64d35b84c77d7287238891.png',436,1208.4602,387.9679,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:43','2023-08-09 09:25:24',NULL),('�N�-`u�_�e_��','�N���}��2`h�M','No.306',NULL,'Fancy Colours Diamonds','active',NULL,NULL,118,53.17,'306-x1118-3222-y391-8396-64d35b916f53a387316770.png',403,1118.3222,391.8396,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:50','2023-08-09 09:25:37',NULL),('�N�-�yY���;_�','�N���}��2`h�M','No.307',NULL,'Crest Gem co.,ltd.','active',NULL,NULL,119,48.73,'307-x1054-3113-y391-3222-64d35be67905c064651578.png',658,1054.3113,391.3222,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:12:56','2023-08-09 09:27:02',NULL),('�N�.\0p���!�0�f[','�N���}��2`h�M','No.308',NULL,'Almighty Box','active',NULL,NULL,120,92.62,'308-x879-9584-y419-2679-64d35beb37915998533337.png',855,879.9584,419.2679,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:13:03','2023-08-09 09:27:07',NULL),('�N�.A{��A�ʸ~\r','�N���}��2`h�M','No.334',NULL,'Fine Art','active',NULL,NULL,121,87.85,'334-x915-5799-y579-9243-64d35bfabc13c554329410.png',735,915.5799,579.9243,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:13:10','2023-08-09 09:27:22',NULL),('�N�.�yj��g@_I�|','�N���}��2`h�M','No.335',NULL,'Ayub Brother','active',NULL,NULL,122,36.44,'335-x1052-9059-y584-8566-64d35c0123e9f014590520.png',536,1052.9059,584.8566,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:13:34','2023-08-09 09:27:29',NULL),('�N�.�}��KM���','�N���}��2`h�M','No.336A',NULL,'Lapis Gems','active',NULL,NULL,123,38.4,'336a-x1107-898-y576-5581-64d35c05e7ee1263431138.png',531,1107.898,576.5581,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:13:41','2023-08-09 09:27:33',NULL),('�N�/\"t�R��QX','�N���}��2`h�M','No.336B',NULL,'E.C.C.','active',NULL,NULL,124,53,'336b-x1164-5617-y575-3952-64d35c0a58ddf058964371.png',521,1164.5617,575.3952,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:13:49','2023-08-09 09:27:38',NULL),('�N�/xyW��$ �\n�\'','�N���}��2`h�M','No.337',NULL,'BM Gems Jewelry','active',NULL,NULL,125,47.16,'337-x1262-6622-y572-8935-64d35c111c6b8364216959.png',391,1262.6622,572.8935,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:13:58','2023-08-09 09:27:45',NULL),('�N�/�|Ც�G�-�','�N���}��2`h�M','No.338',NULL,'Golden Emperor','active',NULL,NULL,126,36.31,'338-x1349-5419-y567-3114-64d35c22bd9b5211886021.png',334,1349.5419,567.3114,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:14:05','2023-08-09 09:28:02',NULL),('�N�0p��/9�q{6','�N���}��2`h�M','No.340',NULL,'GRA Gemological lab','active',NULL,NULL,127,33.36,'340-x1528-2898-y564-7774-64d35c2c7fe02159266006.png',427,1528.2898,564.7774,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:14:13','2023-08-09 09:28:12',NULL),('�N�0Dvq��W���*�','�N���}��2`h�M','No.341AA',NULL,'GCI','active',NULL,NULL,128,39,'341aa-x1574-7415-y365-1033-64d35c3b44ed6877327229.png',419,1574.7415,365.1033,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:14:22','2023-08-09 09:28:27',NULL),('�N�0�s�>e-�*','�N���}��2`h�M','No.341AB',NULL,'Gem Shoppe','active',NULL,NULL,129,29.25,'341ab-x1632-7503-y364-3248-64d35c7ae4341500385381.png',431,1632.7503,364.3248,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:31:34','2023-08-09 09:29:30',NULL),('�N�0�}F��o�#x�K','�N���}��2`h�M','No.341AC',NULL,'Prachya Jewelry & Rayhana Jewels','active',NULL,NULL,130,37,'341ac-x1683-0779-y363-7395-64d35c7e9e2cf135686392.png',369,1683.0779,363.7395,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:31:53','2023-08-09 09:29:34',NULL),('�N�1-xR�7�#�x','�N���}��2`h�M','No.341BA',NULL,'Tsarina Jewels','active',NULL,NULL,131,39,'341ba-x1582-5793-y569-5457-64d35c82e9b37702113748.png',493,1582.5793,569.5457,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:32:14','2023-08-09 09:29:38',NULL),('�N�1ev��\"%�>���','�N���}��2`h�M','No.341BB',NULL,'Natural Art Jewelry','active',NULL,NULL,132,29.25,'341bb-x1634-062-y567-1563-64d35c8750c13700046593.png',350,1634.062,567.1563,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:33:43','2023-08-09 09:29:43',NULL),('�N�1���ȵt��','�N���}��2`h�M','No.341BC',NULL,'Calenthy','active',NULL,NULL,133,37,'341bc-x1683-7862-y561-0732-64d35c8be56b3593951425.png',450,1683.7862,561.0732,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:33:50','2023-08-09 09:29:47',NULL),('�N�2\0}/�sb���^�','�N���}��2`h�M','No.3S02',NULL,'Madagas Gem','active',NULL,NULL,134,33.6,'3s02-x852-4918-y536-8771-64d35cdece38a469007291.png',286,852.4918,536.8771,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:00','2023-08-09 09:31:10',NULL),('�N�2H}ݸ(IGV�WR','�N���}��2`h�M','No.3S03',NULL,'K.C.T. IMPEX co.,ltd.','active',NULL,NULL,135,45.6,'3s03-x775-8921-y537-0937-64d35ce207446229645607.png',491,775.8921,537.0937,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:08','2023-08-09 09:31:14',NULL),('�N�2�qћ�ܙ^�','�N���}��2`h�M','No.3S04',NULL,'Gem Stones Ltd.','active',NULL,NULL,136,32.43,'3s04-x852-2759-y586-5381-64d35ce5b636b239520250.png',248,852.2759,586.5381,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:17','2023-08-09 09:31:17',NULL),('�N�2�x���/��K��','�N���}��2`h�M','No.3S05',NULL,'Vijay Laxmi Gems Ruby & Sapphire','active',NULL,NULL,137,26.7,'3s05-x852-7575-y628-8021-64d35ce9c6cbc152854441.png',215,852.7575,628.8021,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:28','2023-08-09 09:31:21',NULL),('�N�3Ap�>o�&o�|','�N���}��2`h�M','No.3S06',NULL,'Shree Jee Gems Stone co.,ltd.','active',NULL,NULL,138,59.64,'3s06-x784-0628-y691-2505-64d35ced66dc8795094898.png',518,784.0628,691.2505,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:37','2023-08-09 09:31:25',NULL),('�N�3�t\"��[���','�N���}��2`h�M','No.3S07',NULL,'No.3S07','active',NULL,NULL,139,39.79,'3s07-x762-6531-y777-6707-64d35d55950d1321806201.png',606,762.6531,777.6707,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:46','2023-08-09 09:33:09',NULL),('�N�3�tӼ�;s2kÿ','�N���}��2`h�M','No.3S08',NULL,'Jonan Gems','active',NULL,NULL,140,17.17,'3s08-x831-1557-y806-5365-64d35d59249f9695126856.png',251,831.1557,806.5365,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:34:54','2023-08-09 09:33:13',NULL),('�N�4u��_҄l�l\'','�N���}��2`h�M','No.3S09',NULL,'TAJ Gems & Jewelry','active',NULL,NULL,141,35.73,'3s09-x846-1845-y880-3203-64d35d5dc17a8104294126.png',267,846.1845,880.3203,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:35:02','2023-08-09 09:33:17',NULL),('�N�4cv���z�W ','�N���}��2`h�M','No.3S10',NULL,'Super Gems','active',NULL,NULL,142,49.39,'3s10-x778-2625-y880-9682-64d35d618db9b682976529.png',558,778.2625,880.9682,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:36:42','2023-08-09 09:33:21',NULL),('�N�4�yo�>>rt�2','�N���}��2`h�M','No.3S11',NULL,'Gem Shoppe','active',NULL,NULL,143,43.49,'3s11-x645-2189-y897-458-64d35d66a4e19997533114.png',319,645.2189,897.458,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:36:49','2023-08-09 09:33:26',NULL),('�N�5{�����d','�N���}��2`h�M','No.3S12',NULL,'TGS Colour Gems','active',NULL,NULL,144,42.1,'3s12-x558-1844-y896-3999-64d35d6b3be21537270432.png',278,558.1844,896.3999,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:36:56','2023-08-09 09:33:31',NULL),('�N�5Rv����[�,~','�N���}��2`h�M','No.3S12A',NULL,'No.3S12A','active',NULL,NULL,145,32.47,'3s12a-x488-2328-y897-0325-64d35d6f3e125071634274.png',271,488.2328,897.0325,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-19 07:31:13','2023-08-09 09:33:35',NULL),('�N�5�tK��\Z�_�\0�','�N���}��2`h�M','No.3S14',NULL,'No.3S14','active',NULL,NULL,146,60.98,'3s14-x391-9621-y858-3419-64d35d776a611288635189.png',1080,391.9621,858.3419,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:46:41','2023-08-09 09:33:43',NULL),('�N�5�v���ĺ�4','�N���}��2`h�M','No.3S15',NULL,'No.3S15','active',NULL,NULL,147,29.19,'3s15-x439-0306-y744-0298-64d35d7d5429f086930448.png',817,439.0306,744.0298,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:46:52','2023-08-09 09:33:49',NULL),('�N�6>~�ET7�ׁ�','�N���}��2`h�M','No.3S16',NULL,'Rana Internatioanl co.,ltd.','active',NULL,NULL,148,33.97,'3s16-x393-0503-y672-4134-64d35d85563ea642784373.png',1135,393.0503,672.4134,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:47:03','2023-08-09 09:33:57',NULL),('�N�6�|���ĥ�^','�N���}��2`h�M','No.3S17',NULL,'Interstellar gemstone','active',NULL,NULL,149,114.56,'3s17-x237-5067-y638-7741-64d35db771b94757030492.png',859,237.5067,638.7741,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:47:17','2023-08-09 09:34:47',NULL),('�N�6�vԎ��,�o;','�N���}��2`h�M','No.3S18',NULL,'No.3S18','active',NULL,NULL,150,53.27,'3s18-x221-6368-y550-4998-64d35dbad2a5b878570906.png',295,221.6368,550.4998,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:47:29','2023-08-09 09:34:50',NULL),('�N�7${ו�I5F�S�','�N���}��2`h�M','No.3S19',NULL,'No.3S19','active',NULL,NULL,151,39.41,'3s19-x223-3884-y504-9072-64d35dbee1720776441521.png',299,223.3884,504.9072,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:47:42','2023-08-09 09:34:54',NULL),('�N�7own�\0v�&�G�','�N���}��2`h�M','No.3S20',NULL,'No.3S20','active',NULL,NULL,152,42.4,'3s20-x221-9226-y462-3896-64d35dc47aa17204418689.png',267,221.9226,462.3896,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:52:09','2023-08-09 09:35:00',NULL),('�N�7�qb��N\\��:','�N�d?	����yIF','No.401A',NULL,'Storage.Studio','active',NULL,NULL,153,43.96,'401a-x1533-725-y527-2954-64d35e5ac6e5d504011628.png',443,1533.725,527.2954,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:50:50','2023-08-09 09:37:30',NULL),('�N�8p�u���w��','�N�d?	����yIF','No.401B',NULL,'American International Gemlab','active',NULL,NULL,154,32.26,'401b-x1573-9903-y512-5783-64d35e5df30a1550326161.png',271,1573.9903,512.5783,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:50:59','2023-08-09 09:37:33',NULL),('�N�8xr�=[X� v','�N�d?	����yIF','No.401C',NULL,'No.401C','active',NULL,NULL,155,32.43,'401c-x1617-7513-y510-0453-64d35e61846ec057237704.png',401,1617.7513,510.0453,'#000000','BD MEETING',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:06','2023-08-09 09:37:37',NULL),('�N�8�z	��d�wD3','�N�d?	����yIF','No.402A-E',NULL,'Power Buy','active',NULL,NULL,156,198.77,'402a-e-x1506-9462-y369-7662-64d35e70f25e1402866462.png',1122,1506.9462,369.7662,'#000000','POWER BUY',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:15','2023-08-09 09:37:52',NULL),('�N�9rp��c�Hϫ�','�N�d?	����yIF','No.403A',NULL,'AZAD Gems','active',NULL,NULL,157,37.71,'403a-x1313-7375-y365-1707-64d35e75cc8ed425398359.png',537,1313.7375,365.1707,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:23','2023-08-09 09:37:57',NULL),('�N�:�x���u���','�N�d?	����yIF','No.403B',NULL,'Pin Thai','active',NULL,NULL,158,31.05,'403b-x1364-5608-y366-3056-64d35e7b0c58f894612124.png',389,1364.5608,366.3056,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:29','2023-08-09 09:38:03',NULL),('�N�;\ZuE��phUA&','�N�d?	����yIF','No.404A',NULL,'Sukaina Gems','active',NULL,NULL,159,44.67,'404a-x1169-7812-y369-9139-64d35eb3a9132829263875.png',498,1169.7812,369.9139,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:36','2023-08-09 09:38:59',NULL),('�N�;�t����*3�7E','�N�d?	����yIF','No.404B',NULL,'Milleniumcolourgems','active',NULL,NULL,160,33.65,'404b-x1215-3205-y368-2879-64d35eb6f035f052451731.png',443,1215.3205,368.2879,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:44','2023-08-09 09:39:02',NULL),('�N�<bw�m�Y�|','�N�d?	����yIF','No.404C',NULL,'Kanpoj','active',NULL,NULL,161,43.42,'404c-x1259-5596-y367-2878-64d35ebc2a9b8811383266.png',453,1259.5596,367.2878,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:51:51','2023-08-09 09:39:08',NULL),('�N�<�}8��B�)��l','�N�d?	����yIF','No.405',NULL,'MAFA (Thailand) co.,ltd.','active',NULL,NULL,162,59.12,'405-x1082-8087-y386-9347-64d35ebfa40c2073526092.png',725,1082.8087,386.9347,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:52:43','2023-08-09 09:39:11',NULL),('�N�=#ys�dqK���l','�N�d?	����yIF','No.406',NULL,'Royal Gem Source co.,ltd.','active',NULL,NULL,163,25,'406-x907-3017-y385-5441-64d35ec335027080852492.png',705,907.3017,385.5441,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:53:04','2023-08-09 09:39:15',NULL),('�N�=���������','�N�d?	����yIF','No.407',NULL,'I.B.Gems','active',NULL,NULL,164,23,'407-x840-3437-y384-9404-64d35ec7c7103455261861.png',258,840.3437,384.9404,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:53:11','2023-08-09 09:39:19',NULL),('�N�>\Zwy���qR>:','�N�d?	����yIF','No.408',NULL,'Lucky Gems Stone','active',NULL,NULL,165,23,'408-x797-5947-y384-9404-64d35ecbc8985178979495.png',245,797.5947,384.9404,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:53:19','2023-08-09 09:39:23',NULL),('�N�>rv��L�ԮR�','�N�d?	����yIF','No.409',NULL,'DE BLOOMING','active',NULL,NULL,166,23,'409-x754-0233-y385-217-64d35ecfc7d01798068758.png',239,754.0233,385.217,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:53:26','2023-08-09 09:39:27',NULL),('�N�>�ph�� :��','�N�d?	����yIF','No.410',NULL,'AB Impex','active',NULL,NULL,167,23,'410-x711-6962-y385-217-64d35ed3a9f95813765075.png',224,711.6962,385.217,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:53:32','2023-08-09 09:39:31',NULL),('�N�?{Շ�6���','�N�d?	����yIF','No.411',NULL,'PIROMYA Jewelry','active',NULL,NULL,168,22,'411-x670-4817-y385-5195-64d35ed76d15e441601278.png',253,670.4817,385.5195,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:53:38','2023-08-09 09:39:35',NULL),('�N�?Iy뼧c��J��','�N�d?	����yIF','No.412',NULL,'MARA (Thailand) co.,ltd.','active',NULL,NULL,169,22,'412-x629-6483-y385-5195-64d35f191f0f6300079704.png',233,629.6483,385.5195,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:54:05','2023-08-09 09:40:41',NULL),('�N�?�uꟸv��Ĺ~','�N�d?	����yIF','No.413-414',NULL,'CRC','active',NULL,NULL,170,252.98,'413-414-x279-6456-y260-9218-64d35f1cac800754802712.png',822,279.6456,260.9218,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:54:13','2023-08-09 09:40:44',NULL),('�N�?�s���mTjz','�N�d?	����yIF','No.415-416',NULL,'No.415-416','active',NULL,NULL,171,62,'415-416-x237-3857-y626-9366-64d35f2145f80836000542.png',556,237.3857,626.9366,'#000000','CBD Stock',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:54:21','2023-08-09 09:40:49',NULL),('�N�@%r���V��	�','�N�d?	����yIF','No.418',NULL,'Seminar room','active',NULL,NULL,172,103.1,'418-x857-4364-y840-8755-64d35f24b80c3242180193.png',620,857.4364,840.8755,'#000000','Seminar Room',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:54:40','2023-08-09 09:40:52',NULL),('�N�@u|����Vt\Zf�','�N�d?	����yIF','No.431-432',NULL,'FACET GEMS','active',NULL,NULL,173,68.6,'431-432-x1100-8843-y545-8372-64d35f2956ece940917424.png',658,1100.8843,545.8372,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:54:48','2023-08-09 09:40:57',NULL),('�N�@�v��\Zx�p�X','�N�d?	����yIF','No.433-434',NULL,'No.433-434','active',NULL,NULL,174,124.61,'433-434-x1237-2018-y462-8618-64d35f2ccc181810262381.png',670,1237.2018,462.8618,'#000000','PRIVILAGE LOUNGE',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:54:56','2023-08-09 09:41:00',NULL),('�N�Aw���P�mI_','�N�d?	����yIF','No.435',NULL,'VR Treasure','active',NULL,NULL,175,100,'435-x1410-4847-y458-2212-64d35f30a8afe588362581.png',572,1410.4847,458.2212,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:55:06','2023-08-09 09:41:04',NULL),('�N�A~v���ʬ���','�N�d?	����yIF','No.436',NULL,'No.436','active',NULL,NULL,176,462.24,'436-x464-1718-y308-2406-64d35f3595184085657195.png',1396,464.1718,308.2406,'#000000','CBD Office',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:55:14','2023-08-09 09:41:09',NULL),('�N�A�p�!�t�V:','�N�d?	����yIF','No.437',NULL,'No.437','active',NULL,NULL,177,329.55,'437-x265-1206-y513-002-64d35f3a03f89454357815.png',972,265.1206,513.002,'#000000','CBD Office',NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:55:21','2023-08-09 09:41:14',NULL),('�N�B����sbT�','�N�d?	����yIF','No.438',NULL,'No.438','active',NULL,NULL,178,754.62,'438-x558-1417-y806-8419-64d35f3f73332736863195.png',1942,558.1417,806.8419,'#000000',NULL,NULL,'chanond.b@app-alive.com',NULL,'2023-07-18 18:55:30','2023-08-09 09:41:19',NULL),('��]�R}5��Ԛ��n','�H�urƈ�s��v�','FC1','FC1','Food court','active',NULL,NULL,0,0,'fc1-x322-2667-y647-0373-64d34eedcae8c680381615.png',3525,322.2667,647.0373,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-31 09:53:25','2023-08-09 08:31:41',NULL),('��^�jp��/�H�9�','�H�urƈ�s��v�','FC2','FC2','Food court','active',NULL,NULL,1,0,'fc2-x521-5412-y543-6711-64d34f5735494157403693.png',361,521.5412,543.6711,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-31 09:54:09','2023-08-09 08:33:27',NULL),('�޴�y���|���','�N�vxu@����9[��','241C','241C','241C','active','241c-x1577-535-y560-8808-64d4a8fdc7865614744793.png',449,0,0,'241c-x1577-535-y560-8808-64d4aef1a18f5891945913.png',449,1577.535,560.8808,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-08-10 09:08:13','2023-08-10 09:33:37',NULL),('�޴�}y�8��','�N���}��2`h�M','SS','SS','SS','active','ss-x409-941-y596-0261-64d4a923ac770234059310.png',287,0,0,'ss-x409-941-y596-0261-64d4af037d1f6839345859.png',287,409.941,596.0261,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-08-10 09:08:51','2023-08-10 09:33:55',NULL),('�޵��yR�����\r','�N�d?	����yIF','BD','BD','BD','active','bd-x238-2087-y322-4338-64d4a977f20cb553223737.png',273,0,0,'bd-x238-2087-y322-4338-64d4aed76e21a900461878.png',273,238.2087,322.4338,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-08-10 09:10:15','2023-08-10 09:33:11','BD'),('�޶�mq[�a��`�]','�H�urƈ�s��v�','B9-B10','B9-B10','B9-B10','active',NULL,NULL,0,0,'b9-10-x834-392-y345-8969-64d4aedd9a392643066236.png',322,834.392,345.8969,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-08-10 09:11:00','2023-08-10 09:33:17','B9-B10'),('�޸=�|���\Z�m�P]','�H�urƈ�s��v�','B21','B21','B21','active','b21-x478-0958-y634-8739-64d4aa0bbce1a080085711.png',758,0,0,'b21-x478-0958-y634-8739-64d4aee2de297085073622.png',758,478.0958,634.8739,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-08-10 09:12:43','2023-08-10 09:33:22','B21'),('�޸ߣe��q�^��','�H�urƈ�s��v�','Evenethall','Evenethall','Evenethall','active','evenethall-x630-9486-y573-8005-64d4aa3525886797767211.png',1725,0,0,'evenethall-x630-9486-y573-8005-64d4aea9c518c499424328.png',1725,630.9486,573.8005,'#000000',NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-08-10 09:13:25','2023-08-10 09:32:25','Evenethall');
/*!40000 ALTER TABLE `unit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unit_category`
--

DROP TABLE IF EXISTS `unit_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_category` (
  `unit_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `category_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  PRIMARY KEY (`unit_id`,`category_id`),
  KEY `IDX_7372F353F8BD700D` (`unit_id`),
  KEY `IDX_7372F35312469DE2` (`category_id`),
  CONSTRAINT `FK_7372F35312469DE2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_7372F353F8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit_category`
--

LOCK TABLES `unit_category` WRITE;
/*!40000 ALTER TABLE `unit_category` DISABLE KEYS */;
INSERT INTO `unit_category` VALUES ('�N��uؤ�컹�l','�n��*tٜ���̈u\Z'),('�N��z����̈�','�n��*tٜ���̈u\Z'),('�N� p+�7�J�!b','�n��*tٜ���̈u\Z'),('�N�kxV��\'$Z�!U','�n��*tٜ���̈u\Z'),('�N��z�@�.�39<','�n��*tٜ���̈u\Z'),('�N��~_�k�גN�','�n��*tٜ���̈u\Z'),('�N�	Q{�w�7��y','�n��*tٜ���̈u\Z'),('�N�	�|��6	}|��','�n��*tٜ���̈u\Z'),('�N�	�}���lg1Z','�n��*tٜ���̈u\Z'),('�N�\n-t��*{o��Y�','�n��*tٜ���̈u\Z'),('�N�\n}p����5\Zi?�','�n��*tٜ���̈u\Z'),('�N�\n�|/�\r-{��','�n��*tٜ���̈u\Z'),('�N�y���Qs\0�','�n��*tٜ���̈u\Z'),('�N�^qQ�<w`y�Ŷ','�n��*tٜ���̈u\Z'),('�N��x���9�\"X?h','�n��*tٜ���̈u\Z'),('�N��v`�T����ȷ','�n��*tٜ���̈u\Z'),('�N�\'sf��Ҁu�y�','�n��*tٜ���̈u\Z'),('�N�Pz���s��+�','�n��*tٜ���̈u\Z'),('�N��|إAk(O��','�n��*tٜ���̈u\Z'),('�N��vʢt6��F3','�n��*tٜ���̈u\Z'),('�N�@vQ�2��_F\r','�n��*tٜ���̈u\Z'),('�N��q!�K�v,y��','�n��*tٜ���̈u\Z'),('�N��p��KU\"��p','�n��*tٜ���̈u\Z'),('�N�x�Hv���>','�n��*tٜ���̈u\Z'),('�N�hq����Yt�','�n��*tٜ���̈u\Z'),('�N��{��E�+�$�','�n��*tٜ���̈u\Z'),('�N�s��]��kԚ.','�n��*tٜ���̈u\Z'),('�N�Uy��\ZA���','�n��*tٜ���̈u\Z'),('�N��|ۃ@_�h�`�','�n��*tٜ���̈u\Z'),('�N��}t�1�~�','�n��*tٜ���̈u\Z'),('�N�4x��P)\"mmʓ','�n��*tٜ���̈u\Z'),('�N��{B��-MI�','�n��*tٜ���̈u\Z'),('�N��r����3ғ�','�n��*tٜ���̈u\Z'),('�N�͍E�5�:\n>','�n��*tٜ���̈u\Z'),('�N�U��}�\Z','�n��*tٜ���̈u\Z'),('�N��y·� @�\n2','�n��*tٜ���̈u\Z'),('�N��pE�z����x','�n��*tٜ���̈u\Z'),('�N�\'t����*�0�','�n��*tٜ���̈u\Z'),('�N�wu7����\'�','�n��*tٜ���̈u\Z'),('�N��qa���w��n','�n��*tٜ���̈u\Z'),('�N��y������8�','�n��*tٜ���̈u\Z'),('�N�Evԡ���g','�n��*tٜ���̈u\Z'),('�N��tؓi�Mi�','�n��*tٜ���̈u\Z'),('�N��x����)lҧ&','�n��*tٜ���̈u\Z'),('�N�5q~�G��>�B�','�M�?{x6�ޗY���'),('�N�|{֋�l��*y','�M�?{x6�ޗY���'),('�N��~ �ԕ��aa','�q���w��k�лB��'),('�N�~ݶ�F��6��','�n��*tٜ���̈u\Z'),('�N�LuE�x�nZ��','�n��*tٜ���̈u\Z'),('�N��z.�ʂkX,�','�n��*tٜ���̈u\Z'),('�N��xU�qj*�cxf','�n��*tٜ���̈u\Z'),('�N�Ft����^�H','�n��*tٜ���̈u\Z'),('�N��t��M�B��l0','�n��*tٜ���̈u\Z'),('�N��uQ����o��','�n��*tٜ���̈u\Z'),('�N�\Z)s�7w��;`','�n��*tٜ���̈u\Z'),('�N�\Z�p��f��\Z���','�n��*tٜ���̈u\Z'),('�N�\Z�|,��j�4�y!','�n��*tٜ���̈u\Z'),('�N�(}՚��<RxR','�n��*tٜ���̈u\Z'),('�N�qqD��aVͻ�4','�n�|Q�����Z�'),('�N��w��s�M�T�','�n�|Q�����Z�'),('�N�}��-�+�l��','�M�?{x6�ޗY���'),('�N�_�$�`o�(k','�n�|Q�����Z�'),('�N��u���S[v','�n�|Q�����Z�'),('�N��wV��<^jq�','�n�|Q�����Z�'),('�N�BvV�H� ?,','�n�|Q�����Z�'),('�N�����	Oݿy�','�n��*tٜ���̈u\Z'),('�N��x���n|P5','�n��*tٜ���̈u\Z'),('�N�Br7���f¹Y','�n��*tٜ���̈u\Z'),('�N��}�Dq�cU�@','�n��*tٜ���̈u\Z'),('�N��we�E��ȓ','�n��*tٜ���̈u\Z'),('�N�,~������Ǩ','�n��*tٜ���̈u\Z'),('�N�rڷN�G�o','�n��*tٜ���̈u\Z'),('�N��u�����\"X�','�n��*tٜ���̈u\Z'),('�N� v���c˷��','�n�|Q�����Z�'),('�N� Euх+L\'��h�','�q�DrJ��=¼Y8�'),('�N� �9��CšsB','�n��*tٜ���̈u\Z'),('�N� �w�MF�|wl','�n��*tٜ���̈u\Z'),('�N�!@t�|D3��D','�n��*tٜ���̈u\Z'),('�N�!�y��QX�n��\0','�n��*tٜ���̈u\Z'),('�N�!�v��!>J|js','�n��*tٜ���̈u\Z'),('�N�\")v���EH�.C�','�n��*tٜ���̈u\Z'),('�N�\"�vh���ۈM�$','�n��*tٜ���̈u\Z'),('�N�\"�t�[|<ճ�','�n��*tٜ���̈u\Z'),('�N�#rñ�h�n�','�n��*tٜ���̈u\Z'),('�N�#[uٻ�?�D\0��','�n��*tٜ���̈u\Z'),('�N�#�uӖ\"(^�!�^','�n��*tٜ���̈u\Z'),('�N�#�~��.��}�','�n��*tٜ���̈u\Z'),('�N�$7yw�6z�l豞','�n��*tٜ���̈u\Z'),('�N�$}sU�񿊕q��','�n�|Q�����Z�'),('�N�$�������','�n�|Q�����Z�'),('�N�%\Zst�*�Ƨl��','�q�DrJ��=¼Y8�'),('�N�%Yu@��qa�~B','�n��*tٜ���̈u\Z'),('�N�%�s�����90V','�n��*tٜ���̈u\Z'),('�N�%�z���Y��) |','�n��*tٜ���̈u\Z'),('�N�&9w�Wy��\0�!','�n��*tٜ���̈u\Z'),('�N�&�rr��:T�� U','�n��*tٜ���̈u\Z'),('�N�&�p����?','�n��*tٜ���̈u\Z'),('�N�\'3|+���}K�','�n��*tٜ���̈u\Z'),('�N�\'�}ݔ�����','�n��*tٜ���̈u\Z'),('�N�\'�y�$6B��\\�','�n��*tٜ���̈u\Z'),('�N�(-{�Ղ�-$Z','�n��*tٜ���̈u\Z'),('�N�(x{� ��b','�n��*tٜ���̈u\Z'),('�N�(�zf���ͬ?��','�n��*tٜ���̈u\Z'),('�N�)t�?¾���','�n��*tٜ���̈u\Z'),('�N�)e~֓��}em�','�q�DrJ��=¼Y8�'),('�N�)���7Nϓf˔','�n��*tٜ���̈u\Z'),('�N�*\nrн7��Q�Ѭ','�n��*tٜ���̈u\Z'),('�N�*Y~)�e�S��#�','�n�|Q�����Z�'),('�N�*�tY�w�]5k�','�q�DrJ��=¼Y8�'),('�N�*�v�r6\'\n�O','�q�DrJ��=¼Y8�'),('�N�+0t���b���','�n��*tٜ���̈u\Z'),('�N�+pql��31��4|','�n��*tٜ���̈u\Z'),('�N�+�|~�!�\Zܼ�','�n��*tٜ���̈u\Z'),('�N�,\rq��>��wm	K','�n��*tٜ���̈u\Z'),('�N�,o|��f�o�$h,','�n��*tٜ���̈u\Z'),('�N�,�{X�ݏ�[�vs','�n��*tٜ���̈u\Z'),('�N�-r�W�5M','�n��*tٜ���̈u\Z'),('�N�-`u�_�e_��','�n��*tٜ���̈u\Z'),('�N�-�yY���;_�','�n��*tٜ���̈u\Z'),('�N�.\0p���!�0�f[','�n��*tٜ���̈u\Z'),('�N�.A{��A�ʸ~\r','�n��*tٜ���̈u\Z'),('�N�.�yj��g@_I�|','�n��*tٜ���̈u\Z'),('�N�.�}��KM���','�n��*tٜ���̈u\Z'),('�N�/\"t�R��QX','�n��*tٜ���̈u\Z'),('�N�/xyW��$ �\n�\'','�n��*tٜ���̈u\Z'),('�N�/�|Ც�G�-�','�n��*tٜ���̈u\Z'),('�N�0p��/9�q{6','�n��*tٜ���̈u\Z'),('�N�0Dvq��W���*�','�n��*tٜ���̈u\Z'),('�N�0�s�>e-�*','�n��*tٜ���̈u\Z'),('�N�0�}F��o�#x�K','�n��*tٜ���̈u\Z'),('�N�1-xR�7�#�x','�n��*tٜ���̈u\Z'),('�N�1ev��\"%�>���','�n��*tٜ���̈u\Z'),('�N�1���ȵt��','�n��*tٜ���̈u\Z'),('�N�2\0}/�sb���^�','�q�DrJ��=¼Y8�'),('�N�2H}ݸ(IGV�WR','�q�DrJ��=¼Y8�'),('�N�2�qћ�ܙ^�','�q�DrJ��=¼Y8�'),('�N�2�x���/��K��','�q�DrJ��=¼Y8�'),('�N�3Ap�>o�&o�|','�q�DrJ��=¼Y8�'),('�N�3�t\"��[���','�q�DrJ��=¼Y8�'),('�N�3�tӼ�;s2kÿ','�q�DrJ��=¼Y8�'),('�N�4u��_҄l�l\'','�n��*tٜ���̈u\Z'),('�N�4cv���z�W ','�n��*tٜ���̈u\Z'),('�N�4�yo�>>rt�2','�n��*tٜ���̈u\Z'),('�N�5{�����d','�n��*tٜ���̈u\Z'),('�N�5Rv����[�,~','�q�DrJ��=¼Y8�'),('�N�5�tK��\Z�_�\0�','�q�DrJ��=¼Y8�'),('�N�5�v���ĺ�4','�q�DrJ��=¼Y8�'),('�N�6>~�ET7�ׁ�','�n��*tٜ���̈u\Z'),('�N�6�|���ĥ�^','�n��*tٜ���̈u\Z'),('�N�6�vԎ��,�o;','�q�DrJ��=¼Y8�'),('�N�7${ו�I5F�S�','�q�DrJ��=¼Y8�'),('�N�7own�\0v�&�G�','�q�DrJ��=¼Y8�'),('�N�7�qb��N\\��:','�q�DrJ��=¼Y8�'),('�N�8p�u���w��','�n��*tٜ���̈u\Z'),('�N�8xr�=[X� v','�q�DrJ��=¼Y8�'),('�N�8�z	��d�wD3','�q�DrJ��=¼Y8�'),('�N�9rp��c�Hϫ�','�q�DrJ��=¼Y8�'),('�N�:�x���u���','�q�DrJ��=¼Y8�'),('�N�;\ZuE��phUA&','�q�DrJ��=¼Y8�'),('�N�;�t����*3�7E','�q�DrJ��=¼Y8�'),('�N�<bw�m�Y�|','�q�DrJ��=¼Y8�'),('�N�<�}8��B�)��l','�q�DrJ��=¼Y8�'),('�N�=#ys�dqK���l','�n��*tٜ���̈u\Z'),('�N�=���������','�n��*tٜ���̈u\Z'),('�N�>\Zwy���qR>:','�q�DrJ��=¼Y8�'),('�N�>rv��L�ԮR�','�q�DrJ��=¼Y8�'),('�N�>�ph�� :��','�n��*tٜ���̈u\Z'),('�N�?{Շ�6���','�n��*tٜ���̈u\Z'),('�N�?Iy뼧c��J��','�q�DrJ��=¼Y8�'),('�N�?�uꟸv��Ĺ~','�q�DrJ��=¼Y8�'),('�N�?�s���mTjz','�q�DrJ��=¼Y8�'),('�N�@%r���V��	�','�q�DrJ��=¼Y8�'),('�N�@u|����Vt\Zf�','�n��*tٜ���̈u\Z'),('�N�@�v��\Zx�p�X','�q�DrJ��=¼Y8�'),('�N�Aw���P�mI_','�q�DrJ��=¼Y8�'),('�N�A~v���ʬ���','�q�DrJ��=¼Y8�'),('�N�A�p�!�t�V:','�q�DrJ��=¼Y8�'),('�N�B����sbT�','�q�DrJ��=¼Y8�'),('��]�R}5��Ԛ��n','�q���w��k�лB��'),('��^�jp��/�H�9�','�q���w��k�лB��'),('�޴�y���|���','�q�DrJ��=¼Y8�'),('�޴�}y�8��','�q�DrJ��=¼Y8�'),('�޵��yR�����\r','�q�DrJ��=¼Y8�'),('�޶�mq[�a��`�]','�q�DrJ��=¼Y8�'),('�޸=�|���\Z�m�P]','�q�DrJ��=¼Y8�'),('�޸ߣe��q�^��','�q�DrJ��=¼Y8�');
/*!40000 ALTER TABLE `unit_category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unit_contract`
--

DROP TABLE IF EXISTS `unit_contract`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_contract` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `client_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `contract_category_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `customer_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `building_id` binary(16) DEFAULT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(255) NOT NULL,
  `start_at` datetime NOT NULL,
  `end_at` datetime NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9CB1C2CB19EB6921` (`client_id`),
  KEY `IDX_9CB1C2CB50ED442F` (`contract_category_id`),
  KEY `IDX_9CB1C2CB9395C3F3` (`customer_id`),
  KEY `IDX_9CB1C2CB4D2A7E12` (`building_id`),
  CONSTRAINT `FK_9CB1C2CB19EB6921` FOREIGN KEY (`client_id`) REFERENCES `client` (`id`),
  CONSTRAINT `FK_9CB1C2CB4D2A7E12` FOREIGN KEY (`building_id`) REFERENCES `building` (`id`),
  CONSTRAINT `FK_9CB1C2CB50ED442F` FOREIGN KEY (`contract_category_id`) REFERENCES `unit_contract_category` (`id`),
  CONSTRAINT `FK_9CB1C2CB9395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit_contract`
--

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

--
-- Table structure for table `unit_contract_category`
--

DROP TABLE IF EXISTS `unit_contract_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_contract_category` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ordering` int(11) NOT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit_contract_category`
--

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

--
-- Table structure for table `unit_contract_unit`
--

DROP TABLE IF EXISTS `unit_contract_unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_contract_unit` (
  `unit_contract_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `unit_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  PRIMARY KEY (`unit_contract_id`,`unit_id`),
  KEY `IDX_DA77D23EBE118ADB` (`unit_contract_id`),
  KEY `IDX_DA77D23EF8BD700D` (`unit_id`),
  CONSTRAINT `FK_DA77D23EBE118ADB` FOREIGN KEY (`unit_contract_id`) REFERENCES `unit_contract` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DA77D23EF8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit_contract_unit`
--

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

--
-- Table structure for table `unit_image`
--

DROP TABLE IF EXISTS `unit_image`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_image` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `unit_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `image` longtext DEFAULT NULL,
  `image_size` int(11) DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL,
  `short_description` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4E0F7A54F8BD700D` (`unit_id`),
  CONSTRAINT `FK_4E0F7A54F8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit_image`
--

LOCK TABLES `unit_image` WRITE;
/*!40000 ALTER TABLE `unit_image` DISABLE KEYS */;
INSERT INTO `unit_image` VALUES ('�qa�	r���V��','�N�5q~�G��>�B�',NULL,NULL,NULL,NULL,'chanond.b@app-alive.com','chanond.b@app-alive.com',NULL,'2023-07-20 03:39:30','2023-07-20 03:39:30');
/*!40000 ALTER TABLE `unit_image` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `unit_log`
--

DROP TABLE IF EXISTS `unit_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unit_log` (
  `id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `unit_id` binary(16) NOT NULL COMMENT '(DC2Type:uuid)',
  `location_contract` varchar(255) DEFAULT NULL,
  `customer_code` varchar(255) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `remark` longtext DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9AA2C19BF8BD700D` (`unit_id`),
  CONSTRAINT `FK_9AA2C19BF8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit_log`
--

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(180) NOT NULL,
  `roles` longtext NOT NULL COMMENT '(DC2Type:json)',
  `password` varchar(255) NOT NULL,
  `is_verified` tinyint(1) NOT NULL,
  `cover_image` longtext DEFAULT NULL,
  `cover_image_size` int(11) DEFAULT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D649F85E0677` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'chanond.b@app-alive.com','[]','$2y$13$ASLcVxWg3wAa4kSXNCMQ6utpIj7EzL8rcQydZbsqd/He0OBUNOEuK',1,NULL,NULL,'chanond','buranabunpot',NULL,NULL,NULL,'2023-07-12 03:05:37','2023-07-12 03:08:00'),(2,'as.ur.service@gmail.com','[]','$2y$13$li70ThOokt/NAdvGErnbIeP9066e77FJoACVwPpEZNh8jKmkYnPi6',1,NULL,NULL,'chanond','buran',NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 13:55:42','2023-07-20 10:19:04'),(3,'thapakorn.n@app-alive.com','[]','$2y$13$TaMN..jA.JILM.p9QBIZS.6HqnVOXdsSyHSeL3zbnZ2D.mfJVLrmq',1,NULL,NULL,'Thapakorn','Noinongyao',NULL,'chanond.b@app-alive.com',NULL,'2023-07-17 17:18:45','2023-07-19 15:38:43'),(4,'rb.on.the.moon@gmail.com','[]','$2y$13$lVCOeAjxjyhefEB5Wf.h1eP88ANFiNZCL9o1U.Rc3jTtiUfHYF73W',0,NULL,NULL,'chanond','rb',NULL,NULL,NULL,'2023-07-20 06:05:56','2023-07-20 06:05:56'),(5,'kandawiley82@gmail.com','[]','$2y$13$Rq965YRiEdUh476Lr3gnve.E1YhqWalmDUNgnqNQoBwYJZX8EBZ7m',1,'1687716657804-64bc968b0f26b631172683.jpg',58030,'Kanda','Konnitsiri','chanond.b@app-alive.com','kandawiley82@gmail.com',NULL,'2023-07-20 10:27:21','2023-07-23 02:55:07'),(6,'tatont@gmail.com','[]','$2y$13$2IePKrtUS0fgpo505fbIfeGjyVucFVyl4mJ/fdQd4zmTtkTD61.E6',0,NULL,NULL,'tatont','tont',NULL,NULL,NULL,'2023-07-21 06:51:41','2023-07-21 06:51:41');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_role`
--

DROP TABLE IF EXISTS `user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_role` (
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `IDX_2DE8C6A3A76ED395` (`user_id`),
  KEY `IDX_2DE8C6A3D60322AC` (`role_id`),
  CONSTRAINT `FK_2DE8C6A3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2DE8C6A3D60322AC` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_role`
--

LOCK TABLES `user_role` WRITE;
/*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
INSERT INTO `user_role` VALUES (1,1),(1,2),(5,3);
/*!40000 ALTER TABLE `user_role` 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:38:53

📁 Sid Gifari File Manager