1423 lines
84 KiB
SQL
1423 lines
84 KiB
SQL
-- MySQL dump 10.13 Distrib 9.2.0, for macos15 (arm64)
|
|
--
|
|
-- Host: 127.0.0.1 Database: twr
|
|
-- ------------------------------------------------------
|
|
-- Server version 9.2.0
|
|
|
|
/*!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 */;
|
|
/*!50503 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 */;
|
|
|
|
--
|
|
-- Table structure for table `appointment_sections`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `appointment_sections`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `appointment_sections` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`heading` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`address` text COLLATE utf8mb4_unicode_ci,
|
|
`cta_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta2_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta2_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`media_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`media_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`overlay_opacity` int NOT NULL DEFAULT '30',
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`section_heading` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`article1_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`article1_slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`article1_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`article2_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`article2_slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`article2_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`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 `appointment_sections`
|
|
--
|
|
|
|
LOCK TABLES `appointment_sections` WRITE;
|
|
/*!40000 ALTER TABLE `appointment_sections` DISABLE KEYS */;
|
|
INSERT INTO `appointment_sections` VALUES (1,'Visit Us','The Watch Reserve','Unit 23, Building 8, Molito Lifestyle Center, Alabang, Muntinlupa','Book an Appointment','/contact',NULL,NULL,'cms/appointment/appointment-1773473495.webp',NULL,30,1,'The Journal','The Evolution of Dive Watch','evolution-of-dive-watch','cms/journal/journal-1-1774684208.webp','Investment Grade: Why Steel Rolex Reigns','investment-grade-steel-rolex','cms/journal/journal-2-1774684255.webp','2026-03-22 23:06:25','2026-03-27 23:50:55');
|
|
/*!40000 ALTER TABLE `appointment_sections` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `attendances`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `attendances`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `attendances` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint unsigned NOT NULL,
|
|
`date` date NOT NULL,
|
|
`check_in` time DEFAULT NULL,
|
|
`check_out` time DEFAULT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'present',
|
|
`late_minutes` int NOT NULL DEFAULT '0',
|
|
`undertime_minutes` int NOT NULL DEFAULT '0',
|
|
`notes` text COLLATE utf8mb4_unicode_ci,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `attendances_user_id_date_unique` (`user_id`,`date`),
|
|
KEY `attendances_date_index` (`date`),
|
|
CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `attendances`
|
|
--
|
|
|
|
LOCK TABLES `attendances` WRITE;
|
|
/*!40000 ALTER TABLE `attendances` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `attendances` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `brands`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `brands`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `brands` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`logo_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `brands_name_unique` (`name`),
|
|
UNIQUE KEY `brands_slug_unique` (`slug`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `brands`
|
|
--
|
|
|
|
LOCK TABLES `brands` WRITE;
|
|
/*!40000 ALTER TABLE `brands` DISABLE KEYS */;
|
|
INSERT INTO `brands` VALUES (1,'Rolex','rolex','Switzerland',NULL,1,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(2,'Omega','omega','Switzerland',NULL,1,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(3,'Tudor','tudor','Switzerland',NULL,1,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(4,'Audemars Piguet','audemars-piguet','Switzerland',NULL,1,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(5,'Patek Philippe','patek-philippe','Switzerland',NULL,1,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(6,'Cartier','cartier','France',NULL,1,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(7,'Jaeger-LeCoultre','jaeger-lecoultre','Switzerland',NULL,1,'2026-03-30 18:47:00','2026-03-30 18:47:00'),(8,'Vacheron Constantin','vacheron-constantin','Switzerland',NULL,1,'2026-03-30 18:47:23','2026-03-30 18:47:23');
|
|
/*!40000 ALTER TABLE `brands` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `cache`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `cache`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `cache` (
|
|
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`expiration` int NOT NULL,
|
|
PRIMARY KEY (`key`),
|
|
KEY `cache_expiration_index` (`expiration`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `cache`
|
|
--
|
|
|
|
LOCK TABLES `cache` WRITE;
|
|
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
|
|
INSERT INTO `cache` VALUES ('the-watch-reserve-cache-spatie.permission.cache','a:3:{s:5:\"alias\";a:4:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:10:\"guard_name\";s:1:\"r\";s:5:\"roles\";}s:11:\"permissions\";a:10:{i:0;a:4:{s:1:\"a\";i:1;s:1:\"b\";s:14:\"view_dashboard\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:4:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;}}i:1;a:4:{s:1:\"a\";i:2;s:1:\"b\";s:14:\"manage_watches\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:2;a:4:{s:1:\"a\";i:3;s:1:\"b\";s:12:\"manage_sales\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:3;a:4:{s:1:\"a\";i:4;s:1:\"b\";s:16:\"manage_inquiries\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:4;a:4:{s:1:\"a\";i:5;s:1:\"b\";s:18:\"manage_consignment\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:5;a:4:{s:1:\"a\";i:6;s:1:\"b\";s:15:\"manage_bookings\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:6;a:4:{s:1:\"a\";i:7;s:1:\"b\";s:17:\"manage_newsletter\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:7;a:4:{s:1:\"a\";i:8;s:1:\"b\";s:10:\"manage_cms\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:8;a:4:{s:1:\"a\";i:9;s:1:\"b\";s:9:\"manage_hr\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:4;}}i:9;a:4:{s:1:\"a\";i:10;s:1:\"b\";s:12:\"manage_users\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}}s:5:\"roles\";a:4:{i:0;a:3:{s:1:\"a\";i:1;s:1:\"b\";s:5:\"Admin\";s:1:\"c\";s:3:\"web\";}i:1;a:3:{s:1:\"a\";i:2;s:1:\"b\";s:13:\"Sales Manager\";s:1:\"c\";s:3:\"web\";}i:2;a:3:{s:1:\"a\";i:3;s:1:\"b\";s:11:\"Sales Staff\";s:1:\"c\";s:3:\"web\";}i:3;a:3:{s:1:\"a\";i:4;s:1:\"b\";s:10:\"HR Manager\";s:1:\"c\";s:3:\"web\";}}}',1776483907);
|
|
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `cache_locks`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `cache_locks`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `cache_locks` (
|
|
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`expiration` int NOT NULL,
|
|
PRIMARY KEY (`key`),
|
|
KEY `cache_locks_expiration_index` (`expiration`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `cache_locks`
|
|
--
|
|
|
|
LOCK TABLES `cache_locks` WRITE;
|
|
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `consignment_requests`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `consignment_requests`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `consignment_requests` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`item_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'consignment',
|
|
`vlog_documentation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'without_vlog',
|
|
`brand` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`model` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`dial_size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`material` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`is_working` tinyint(1) NOT NULL DEFAULT '0',
|
|
`is_serviced` tinyint(1) NOT NULL DEFAULT '0',
|
|
`has_papers` tinyint(1) NOT NULL DEFAULT '0',
|
|
`has_box` tinyint(1) NOT NULL DEFAULT '0',
|
|
`comment` text COLLATE utf8mb4_unicode_ci,
|
|
`photos` json DEFAULT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
|
|
`reviewed_by` bigint unsigned DEFAULT NULL,
|
|
`reviewed_at` timestamp NULL DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `consignment_requests_reviewed_by_foreign` (`reviewed_by`),
|
|
KEY `consignment_requests_status_index` (`status`),
|
|
CONSTRAINT `consignment_requests_reviewed_by_foreign` FOREIGN KEY (`reviewed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `consignment_requests`
|
|
--
|
|
|
|
LOCK TABLES `consignment_requests` WRITE;
|
|
/*!40000 ALTER TABLE `consignment_requests` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `consignment_requests` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `consignments`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `consignments`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `consignments` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`consignor_id` bigint unsigned NOT NULL,
|
|
`watch_id` bigint unsigned NOT NULL,
|
|
`intake_date` date NOT NULL,
|
|
`agreed_price` decimal(12,2) NOT NULL,
|
|
`commission_rate` decimal(15,2) NOT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
|
|
`settlement_date` date DEFAULT NULL,
|
|
`settlement_amount` decimal(12,2) DEFAULT NULL,
|
|
`notes` text COLLATE utf8mb4_unicode_ci,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `consignments_consignor_id_foreign` (`consignor_id`),
|
|
KEY `consignments_watch_id_foreign` (`watch_id`),
|
|
KEY `consignments_status_index` (`status`),
|
|
KEY `consignments_intake_date_index` (`intake_date`),
|
|
CONSTRAINT `consignments_consignor_id_foreign` FOREIGN KEY (`consignor_id`) REFERENCES `consignors` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `consignments_watch_id_foreign` FOREIGN KEY (`watch_id`) REFERENCES `watches` (`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 `consignments`
|
|
--
|
|
|
|
LOCK TABLES `consignments` WRITE;
|
|
/*!40000 ALTER TABLE `consignments` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `consignments` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `consignors`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `consignors`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `consignors` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`address` text COLLATE utf8mb4_unicode_ci,
|
|
`default_commission_rate` decimal(15,2) NOT NULL,
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`notes` text COLLATE utf8mb4_unicode_ci,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL 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 `consignors`
|
|
--
|
|
|
|
LOCK TABLES `consignors` WRITE;
|
|
/*!40000 ALTER TABLE `consignors` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `consignors` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `customers`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `customers`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `customers` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`address` text COLLATE utf8mb4_unicode_ci,
|
|
`notes` text COLLATE utf8mb4_unicode_ci,
|
|
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL 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 `customers`
|
|
--
|
|
|
|
LOCK TABLES `customers` WRITE;
|
|
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `failed_jobs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `failed_jobs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `failed_jobs` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `failed_jobs`
|
|
--
|
|
|
|
LOCK TABLES `failed_jobs` WRITE;
|
|
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `hero_sections`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `hero_sections`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `hero_sections` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`subtitle` text COLLATE utf8mb4_unicode_ci,
|
|
`title_size` int NOT NULL DEFAULT '100',
|
|
`subtitle_size` int NOT NULL DEFAULT '100',
|
|
`cta_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta2_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta2_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`media_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'image',
|
|
`media_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`media_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`overlay_opacity` int NOT NULL DEFAULT '60',
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '0',
|
|
`sort_order` int NOT NULL DEFAULT '0',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`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 `hero_sections`
|
|
--
|
|
|
|
LOCK TABLES `hero_sections` WRITE;
|
|
/*!40000 ALTER TABLE `hero_sections` DISABLE KEYS */;
|
|
INSERT INTO `hero_sections` VALUES (1,'Timeless Luxury','The Watch Reserve',90,130,'View Collection','/collection','Sell Your Watch','/consign','video','cms/heroes/hero-1773369171.mp4',NULL,70,1,0,'2026-03-22 22:56:51','2026-03-22 22:56:51');
|
|
/*!40000 ALTER TABLE `hero_sections` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `history_pages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `history_pages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `history_pages` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`hero_year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'EST. 1922',
|
|
`hero_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'A Legacy in Seconds',
|
|
`hero_text` text COLLATE utf8mb4_unicode_ci,
|
|
`hero_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`mission_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'Our Mission: The Preservation of Craft',
|
|
`mission_text` text COLLATE utf8mb4_unicode_ci,
|
|
`mission_quote` text COLLATE utf8mb4_unicode_ci,
|
|
`mission_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`founders_subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'THE VISIONARIES',
|
|
`founders_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'The Founders'' Story',
|
|
`founders_text` text COLLATE utf8mb4_unicode_ci,
|
|
`founders_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`perfection_col1_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'PROVENANCE',
|
|
`perfection_col1_text` text COLLATE utf8mb4_unicode_ci,
|
|
`perfection_col1_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`perfection_col2_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'RESTORATION',
|
|
`perfection_col2_text` text COLLATE utf8mb4_unicode_ci,
|
|
`perfection_col2_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`perfection_col3_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'CURATION',
|
|
`perfection_col3_text` text COLLATE utf8mb4_unicode_ci,
|
|
`perfection_col3_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL 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 `history_pages`
|
|
--
|
|
|
|
LOCK TABLES `history_pages` WRITE;
|
|
/*!40000 ALTER TABLE `history_pages` DISABLE KEYS */;
|
|
INSERT INTO `history_pages` VALUES (1,'EST. 1922','A Legacy in Seconds',NULL,'cms/history/fL1qSunHPbfAfZiPTVP6UDb6rSTFnum9qssixJ7I.webp','Our Mission: The Preservation of Craft',NULL,NULL,'cms/history/w1lvjPJ6LdfQSbcCLllcRoKM6swWjxbVu2hDEKXE.png','THE VISIONARIES','The Founders\' Story',NULL,'cms/history/eGrDaYocRU4ktk4VQelv78spRFy57OclMm05NboG.png','PROVENANCE',NULL,'cms/history/13y1fxbJEKJ4z6dDMNJiT5TayNwEFRyJMOf00TI4.png','RESTORATION',NULL,'cms/history/FDYAcH8GQ3GbDf5NVJwKY3EWe81uzPsLKlXRcamE.png','CURATION',NULL,'cms/history/t2B7A3Ph3VevVcmAz3JiDNUCxEyM9fNgxjcujXyB.png','2026-03-22 22:12:59','2026-03-22 23:18:18'),(2,'EST. 1922','A Legacy in Seconds',NULL,'cms/history/fL1qSunHPbfAfZiPTVP6UDb6rSTFnum9qssixJ7I.webp','Our Mission: The Preservation of Craft',NULL,NULL,'cms/history/w1lvjPJ6LdfQSbcCLllcRoKM6swWjxbVu2hDEKXE.png','THE VISIONARIES','The Founders Story',NULL,'cms/history/eGrDaYocRU4ktk4VQelv78spRFy57OclMm05NboG.png','PROVENANCE',NULL,'cms/history/13y1fxbJEKJ4z6dDMNJiT5TayNwEFRyJMOf00TI4.png','RESTORATION',NULL,'cms/history/FDYAcH8GQ3GbDf5NVJwKY3EWe81uzPsLKlXRcamE.png','CURATION',NULL,'cms/history/ypqCKiZDDZ1hyXJaI3v1kPfPa5fQtUz3yyUCHpin.png','2026-03-22 22:56:55','2026-03-22 22:56:55');
|
|
/*!40000 ALTER TABLE `history_pages` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `inquiries`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `inquiries`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `inquiries` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`watch_id` bigint unsigned NOT NULL,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`preferred_contact` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`message` text COLLATE utf8mb4_unicode_ci,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
|
|
`replied_at` timestamp NULL DEFAULT NULL,
|
|
`replied_by` bigint unsigned DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `inquiries_watch_id_foreign` (`watch_id`),
|
|
KEY `inquiries_replied_by_foreign` (`replied_by`),
|
|
KEY `inquiries_status_index` (`status`),
|
|
CONSTRAINT `inquiries_replied_by_foreign` FOREIGN KEY (`replied_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
|
|
CONSTRAINT `inquiries_watch_id_foreign` FOREIGN KEY (`watch_id`) REFERENCES `watches` (`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 `inquiries`
|
|
--
|
|
|
|
LOCK TABLES `inquiries` WRITE;
|
|
/*!40000 ALTER TABLE `inquiries` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `inquiries` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `instagram_posts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `instagram_posts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `instagram_posts` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`instagram_section_id` bigint unsigned NOT NULL,
|
|
`image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`post_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`caption` text COLLATE utf8mb4_unicode_ci,
|
|
`sort_order` int NOT NULL DEFAULT '0',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `instagram_posts_instagram_section_id_foreign` (`instagram_section_id`),
|
|
CONSTRAINT `instagram_posts_instagram_section_id_foreign` FOREIGN KEY (`instagram_section_id`) REFERENCES `instagram_sections` (`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 `instagram_posts`
|
|
--
|
|
|
|
LOCK TABLES `instagram_posts` WRITE;
|
|
/*!40000 ALTER TABLE `instagram_posts` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `instagram_posts` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `instagram_sections`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `instagram_sections`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `instagram_sections` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`heading` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`instagram_handle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`profile_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`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 `instagram_sections`
|
|
--
|
|
|
|
LOCK TABLES `instagram_sections` WRITE;
|
|
/*!40000 ALTER TABLE `instagram_sections` DISABLE KEYS */;
|
|
INSERT INTO `instagram_sections` VALUES (1,'Follow Us On Instagram','@thewatchreserve.ph',NULL,1,'2026-03-22 22:57:07','2026-03-27 23:53:28');
|
|
/*!40000 ALTER TABLE `instagram_sections` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `job_batches`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `job_batches`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `job_batches` (
|
|
`id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`total_jobs` int NOT NULL,
|
|
`pending_jobs` int NOT NULL,
|
|
`failed_jobs` int NOT NULL,
|
|
`failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`options` mediumtext COLLATE utf8mb4_unicode_ci,
|
|
`cancelled_at` int DEFAULT NULL,
|
|
`created_at` int NOT NULL,
|
|
`finished_at` int 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 `job_batches`
|
|
--
|
|
|
|
LOCK TABLES `job_batches` WRITE;
|
|
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `jobs`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `jobs`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `jobs` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`attempts` tinyint unsigned NOT NULL,
|
|
`reserved_at` int unsigned DEFAULT NULL,
|
|
`available_at` int unsigned NOT NULL,
|
|
`created_at` int unsigned NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `jobs_queue_reserved_at_available_at_index` (`queue`,`reserved_at`,`available_at`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `jobs`
|
|
--
|
|
|
|
LOCK TABLES `jobs` WRITE;
|
|
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `leave_balances`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `leave_balances`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `leave_balances` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint unsigned NOT NULL,
|
|
`leave_type_id` bigint unsigned NOT NULL,
|
|
`balance` decimal(5,2) NOT NULL DEFAULT '0.00',
|
|
`accrued` decimal(5,2) NOT NULL DEFAULT '0.00',
|
|
`used` decimal(5,2) NOT NULL DEFAULT '0.00',
|
|
`year` int NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `leave_balances_user_id_leave_type_id_year_unique` (`user_id`,`leave_type_id`,`year`),
|
|
KEY `leave_balances_leave_type_id_foreign` (`leave_type_id`),
|
|
CONSTRAINT `leave_balances_leave_type_id_foreign` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `leave_balances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `leave_balances`
|
|
--
|
|
|
|
LOCK TABLES `leave_balances` WRITE;
|
|
/*!40000 ALTER TABLE `leave_balances` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `leave_balances` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `leave_settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `leave_settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `leave_settings` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`leave_type_id` bigint unsigned NOT NULL,
|
|
`accrual_rate` decimal(5,2) NOT NULL DEFAULT '0.00',
|
|
`accrual_period` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'monthly',
|
|
`max_balance` decimal(5,2) NOT NULL DEFAULT '0.00',
|
|
`carry_over` tinyint(1) NOT NULL DEFAULT '0',
|
|
`max_carry_over` decimal(5,2) NOT NULL DEFAULT '0.00',
|
|
`probation_months` int NOT NULL DEFAULT '0',
|
|
`reset_cycle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'annual',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `leave_settings_leave_type_id_foreign` (`leave_type_id`),
|
|
CONSTRAINT `leave_settings_leave_type_id_foreign` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`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 `leave_settings`
|
|
--
|
|
|
|
LOCK TABLES `leave_settings` WRITE;
|
|
/*!40000 ALTER TABLE `leave_settings` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `leave_settings` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `leave_types`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `leave_types`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `leave_types` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`description` text COLLATE utf8mb4_unicode_ci,
|
|
`is_paid` tinyint(1) NOT NULL DEFAULT '1',
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `leave_types_code_unique` (`code`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `leave_types`
|
|
--
|
|
|
|
LOCK TABLES `leave_types` WRITE;
|
|
/*!40000 ALTER TABLE `leave_types` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `leave_types` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `leaves`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `leaves`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `leaves` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint unsigned NOT NULL,
|
|
`leave_type_id` bigint unsigned NOT NULL,
|
|
`start_date` date NOT NULL,
|
|
`end_date` date NOT NULL,
|
|
`days` decimal(5,2) NOT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
|
|
`reason` text COLLATE utf8mb4_unicode_ci,
|
|
`approved_by` bigint unsigned DEFAULT NULL,
|
|
`approved_at` timestamp NULL DEFAULT NULL,
|
|
`rejection_reason` text COLLATE utf8mb4_unicode_ci,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `leaves_user_id_foreign` (`user_id`),
|
|
KEY `leaves_leave_type_id_foreign` (`leave_type_id`),
|
|
KEY `leaves_approved_by_foreign` (`approved_by`),
|
|
KEY `leaves_status_index` (`status`),
|
|
CONSTRAINT `leaves_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
|
|
CONSTRAINT `leaves_leave_type_id_foreign` FOREIGN KEY (`leave_type_id`) REFERENCES `leave_types` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `leaves_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `leaves`
|
|
--
|
|
|
|
LOCK TABLES `leaves` WRITE;
|
|
/*!40000 ALTER TABLE `leaves` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `leaves` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `marquee_images`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `marquee_images`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `marquee_images` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`marquee_section_id` bigint unsigned NOT NULL,
|
|
`image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`watch_id` bigint unsigned DEFAULT NULL,
|
|
`alt_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`sort_order` int NOT NULL DEFAULT '0',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `marquee_images_marquee_section_id_foreign` (`marquee_section_id`),
|
|
KEY `marquee_images_watch_id_foreign` (`watch_id`),
|
|
CONSTRAINT `marquee_images_marquee_section_id_foreign` FOREIGN KEY (`marquee_section_id`) REFERENCES `marquee_sections` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `marquee_images_watch_id_foreign` FOREIGN KEY (`watch_id`) REFERENCES `watches` (`id`) ON DELETE SET NULL
|
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `marquee_images`
|
|
--
|
|
|
|
LOCK TABLES `marquee_images` WRITE;
|
|
/*!40000 ALTER TABLE `marquee_images` DISABLE KEYS */;
|
|
INSERT INTO `marquee_images` VALUES (1,1,'cms/marquee/marquee-1773373633-69b388c16bf4d.webp',NULL,NULL,1,'2026-03-22 22:57:03','2026-03-22 22:57:03'),(2,1,'cms/marquee/marquee-1773373633-69b388c16d11d.webp',NULL,NULL,2,'2026-03-22 22:57:03','2026-03-22 22:57:03'),(3,1,'cms/marquee/marquee-1773373633-69b388c16dbc0.webp',NULL,NULL,3,'2026-03-22 22:57:03','2026-03-22 22:57:03'),(4,1,'cms/marquee/marquee-1773373633-69b388c1715cb.webp',NULL,NULL,4,'2026-03-22 22:57:03','2026-03-22 22:57:03'),(5,1,'cms/marquee/marquee-1773373633-69b388c1739bb.webp',NULL,NULL,5,'2026-03-22 22:57:03','2026-03-22 22:57:03');
|
|
/*!40000 ALTER TABLE `marquee_images` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `marquee_sections`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `marquee_sections`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `marquee_sections` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`subtitle` text COLLATE utf8mb4_unicode_ci,
|
|
`heading` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`step1_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`step1_desc` text COLLATE utf8mb4_unicode_ci,
|
|
`step2_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`step2_desc` text COLLATE utf8mb4_unicode_ci,
|
|
`step3_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`step3_desc` text COLLATE utf8mb4_unicode_ci,
|
|
`image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`is_active` tinyint(1) NOT NULL DEFAULT '1',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`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 `marquee_sections`
|
|
--
|
|
|
|
LOCK TABLES `marquee_sections` WRITE;
|
|
/*!40000 ALTER TABLE `marquee_sections` DISABLE KEYS */;
|
|
INSERT INTO `marquee_sections` VALUES (1,'Watches inspired from the past, made for today.','Explore Now','How to Consign With Us','Request an Estimate','Submit your watch details online. Our specialists will provide a preliminary valuation based on current market trends.','Secure Transit & Inspection','Ship your watch via our fully insured concierge courier for professional authentication and high-definition photography.','Global Exposure & Sale','Your timepiece is showcased to our global collector network. Once sold, you receive payment promptly via secure transfer.','cms/consign/consign-1774229904.png','Get Your Estimate','/consign',1,'2026-03-22 22:56:59','2026-03-23 23:10:58');
|
|
/*!40000 ALTER TABLE `marquee_sections` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `migrations`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `migrations`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `migrations` (
|
|
`id` int unsigned NOT NULL AUTO_INCREMENT,
|
|
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`batch` int NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `migrations`
|
|
--
|
|
|
|
LOCK TABLES `migrations` WRITE;
|
|
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
|
|
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_03_13_005333_create_permission_tables',1),(5,'2026_03_13_010000_create_consignors_table',1),(6,'2026_03_13_010100_create_customers_table',1),(7,'2026_03_13_010150_create_brands_table',1),(8,'2026_03_13_010200_create_watches_table',1),(9,'2026_03_13_010250_add_brand_id_and_images_to_watches',1),(10,'2026_03_13_010300_create_consignments_table',1),(11,'2026_03_13_010400_create_reservations_table',1),(12,'2026_03_13_010500_create_transactions_table',1),(13,'2026_03_13_010600_create_attendances_table',1),(14,'2026_03_13_010700_create_leave_tables',1),(15,'2026_03_13_010800_create_settings_table',1),(16,'2026_03_13_010900_create_inquiries_table',1),(17,'2026_03_13_011000_create_consignment_requests_table',1),(18,'2026_03_13_011100_create_hero_sections_table',1),(19,'2026_03_13_011200_create_marquee_tables',1),(20,'2026_03_13_024301_add_font_sizes_to_hero_sections',1),(21,'2026_03_14_011300_create_appointment_sections_table',1),(22,'2026_03_14_011400_create_instagram_tables',1),(23,'2026_03_23_013017_add_consign_fields_to_marquee_sections_table',1),(24,'2026_03_23_014215_add_journal_fields_to_appointment_sections_table',1),(25,'2026_03_23_023509_add_preferred_contact_to_inquiries_table',1),(26,'2026_03_23_030711_create_history_pages_table',1),(27,'2026_03_24_060000_add_password_to_customers_table',1),(28,'2026_03_24_061810_create_personal_access_tokens_table',1),(29,'2026_03_24_074303_create_newsletter_subscribers_table',1),(30,'2026_03_25_121402_create_services_pages_table',1),(31,'2026_03_25_132734_create_valuation_bookings_table',1),(32,'2026_03_25_140740_create_shifts_table',1),(33,'2026_03_25_142458_add_payment_details_to_transactions_table',1),(34,'2026_03_25_144004_add_document_path_to_transactions_table',1),(35,'2026_03_28_093805_create_service_requests_table',1),(36,'2026_03_31_121356_change_commission_rates_to_flat_amount_in_tables',1),(37,'2026_04_07_141118_make_message_nullable_on_inquiries_table',1);
|
|
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `model_has_permissions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `model_has_permissions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `model_has_permissions` (
|
|
`permission_id` bigint unsigned NOT NULL,
|
|
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`model_id` bigint unsigned NOT NULL,
|
|
PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
|
|
KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
|
|
CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`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 `model_has_permissions`
|
|
--
|
|
|
|
LOCK TABLES `model_has_permissions` WRITE;
|
|
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
|
|
INSERT INTO `model_has_permissions` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',1),(3,'App\\Models\\User',1),(4,'App\\Models\\User',1),(5,'App\\Models\\User',1),(6,'App\\Models\\User',1),(7,'App\\Models\\User',1),(8,'App\\Models\\User',1),(9,'App\\Models\\User',1),(10,'App\\Models\\User',1),(1,'App\\Models\\User',9),(2,'App\\Models\\User',9),(3,'App\\Models\\User',9),(4,'App\\Models\\User',9),(5,'App\\Models\\User',9),(6,'App\\Models\\User',9),(7,'App\\Models\\User',9),(8,'App\\Models\\User',9),(9,'App\\Models\\User',9),(10,'App\\Models\\User',9);
|
|
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `model_has_roles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `model_has_roles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `model_has_roles` (
|
|
`role_id` bigint unsigned NOT NULL,
|
|
`model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`model_id` bigint unsigned NOT NULL,
|
|
PRIMARY KEY (`role_id`,`model_id`,`model_type`),
|
|
KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
|
|
CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `model_has_roles`
|
|
--
|
|
|
|
LOCK TABLES `model_has_roles` WRITE;
|
|
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
|
|
INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(3,'App\\Models\\User',3),(3,'App\\Models\\User',4),(4,'App\\Models\\User',5),(3,'App\\Models\\User',6),(1,'App\\Models\\User',7),(3,'App\\Models\\User',8),(1,'App\\Models\\User',9),(4,'App\\Models\\User',10),(3,'App\\Models\\User',11),(1,'App\\Models\\User',12),(3,'App\\Models\\User',13),(3,'App\\Models\\User',14);
|
|
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `newsletter_subscribers`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `newsletter_subscribers`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `newsletter_subscribers` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'footer',
|
|
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `newsletter_subscribers_email_unique` (`email`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `newsletter_subscribers`
|
|
--
|
|
|
|
LOCK TABLES `newsletter_subscribers` WRITE;
|
|
/*!40000 ALTER TABLE `newsletter_subscribers` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `newsletter_subscribers` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `password_reset_tokens`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `password_reset_tokens`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `password_reset_tokens` (
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`email`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `password_reset_tokens`
|
|
--
|
|
|
|
LOCK TABLES `password_reset_tokens` WRITE;
|
|
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `permissions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `permissions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `permissions` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `permissions`
|
|
--
|
|
|
|
LOCK TABLES `permissions` WRITE;
|
|
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
|
|
INSERT INTO `permissions` VALUES (1,'view_dashboard','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(2,'manage_watches','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(3,'manage_sales','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(4,'manage_inquiries','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(5,'manage_consignment','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(6,'manage_bookings','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(7,'manage_newsletter','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(8,'manage_cms','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(9,'manage_hr','web','2026-03-25 06:15:34','2026-03-25 06:15:34'),(10,'manage_users','web','2026-03-25 06:15:34','2026-03-25 06:15:34');
|
|
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `personal_access_tokens`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `personal_access_tokens`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `personal_access_tokens` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`tokenable_id` bigint unsigned NOT NULL,
|
|
`name` text COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`abilities` text COLLATE utf8mb4_unicode_ci,
|
|
`last_used_at` timestamp NULL DEFAULT NULL,
|
|
`expires_at` timestamp NULL DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
|
|
KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
|
|
KEY `personal_access_tokens_expires_at_index` (`expires_at`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `personal_access_tokens`
|
|
--
|
|
|
|
LOCK TABLES `personal_access_tokens` WRITE;
|
|
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `reservations`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `reservations`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `reservations` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`watch_id` bigint unsigned NOT NULL,
|
|
`customer_id` bigint unsigned NOT NULL,
|
|
`staff_id` bigint unsigned DEFAULT NULL,
|
|
`deposit_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
|
|
`deadline` date NOT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
|
|
`notes` text COLLATE utf8mb4_unicode_ci,
|
|
`extensions` int NOT NULL DEFAULT '0',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `reservations_watch_id_foreign` (`watch_id`),
|
|
KEY `reservations_customer_id_foreign` (`customer_id`),
|
|
KEY `reservations_staff_id_foreign` (`staff_id`),
|
|
KEY `reservations_status_index` (`status`),
|
|
KEY `reservations_deadline_index` (`deadline`),
|
|
CONSTRAINT `reservations_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `reservations_staff_id_foreign` FOREIGN KEY (`staff_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
|
|
CONSTRAINT `reservations_watch_id_foreign` FOREIGN KEY (`watch_id`) REFERENCES `watches` (`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 `reservations`
|
|
--
|
|
|
|
LOCK TABLES `reservations` WRITE;
|
|
/*!40000 ALTER TABLE `reservations` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `reservations` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `role_has_permissions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `role_has_permissions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `role_has_permissions` (
|
|
`permission_id` bigint unsigned NOT NULL,
|
|
`role_id` bigint unsigned NOT NULL,
|
|
PRIMARY KEY (`permission_id`,`role_id`),
|
|
KEY `role_has_permissions_role_id_foreign` (`role_id`),
|
|
CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`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 `role_has_permissions`
|
|
--
|
|
|
|
LOCK TABLES `role_has_permissions` WRITE;
|
|
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
|
|
INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(1,2),(2,2),(3,2),(4,2),(5,2),(6,2),(7,2),(1,3),(2,3),(3,3),(4,3),(1,4),(9,4);
|
|
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `roles`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `roles`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `roles` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `roles`
|
|
--
|
|
|
|
LOCK TABLES `roles` WRITE;
|
|
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
|
|
INSERT INTO `roles` VALUES (1,'Admin','web','2026-03-22 21:43:14','2026-03-22 21:43:14'),(2,'Sales Manager','web','2026-03-22 21:43:14','2026-03-22 21:43:14'),(3,'Sales Staff','web','2026-03-22 21:43:14','2026-03-22 21:43:14'),(4,'HR Manager','web','2026-03-22 21:43:14','2026-03-22 21:43:14'),(5,'Consignor','web','2026-03-22 21:43:14','2026-03-22 21:43:14');
|
|
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `service_requests`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `service_requests`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `service_requests` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`service_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`sub_service_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending Approval',
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL 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 `service_requests`
|
|
--
|
|
|
|
LOCK TABLES `service_requests` WRITE;
|
|
/*!40000 ALTER TABLE `service_requests` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `service_requests` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `services_pages`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `services_pages`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `services_pages` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`hero_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`servicing_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`preservation_col1_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`preservation_col2_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`preservation_col3_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`cta_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`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 `services_pages`
|
|
--
|
|
|
|
LOCK TABLES `services_pages` WRITE;
|
|
/*!40000 ALTER TABLE `services_pages` DISABLE KEYS */;
|
|
INSERT INTO `services_pages` VALUES (1,'cms/services/3SPnqR0pUPp5RaUpWg406mTuM8fQK4BicGq8aQJP.png','cms/services/bLanqJxpsc69fKcbvWFU4B6yRXnyDWc9IRr71n5j.png',NULL,NULL,NULL,'cms/services/NvmK58CYcqPFTPVn95XfAjO57C28hcgksWpAumSj.png','2026-03-25 04:26:10','2026-03-25 04:57:13');
|
|
/*!40000 ALTER TABLE `services_pages` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `sessions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `sessions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `sessions` (
|
|
`id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`user_id` bigint unsigned DEFAULT NULL,
|
|
`ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`user_agent` text COLLATE utf8mb4_unicode_ci,
|
|
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`last_activity` int NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `sessions_user_id_index` (`user_id`),
|
|
KEY `sessions_last_activity_index` (`last_activity`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `sessions`
|
|
--
|
|
|
|
LOCK TABLES `sessions` WRITE;
|
|
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
|
|
INSERT INTO `sessions` VALUES ('oGRjpTGzHRS1KqICAdwgj1mp5jQBLqbwwKsSrui8',1,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiRWlsNU5CenBMVURiS1J4Mnd5MFJWT3dYaU5sNXpJUVJYSGdWaFdlUyI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjMyOiJodHRwczovL3R3ci50ZXN0L3VzZXItbWFuYWdlbWVudCI7czo1OiJyb3V0ZSI7czoyMToidXNlci1tYW5hZ2VtZW50LmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1776397557);
|
|
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `settings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `settings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `settings` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`value` text COLLATE utf8mb4_unicode_ci,
|
|
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string',
|
|
`group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
|
|
`description` text COLLATE utf8mb4_unicode_ci,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `settings_key_unique` (`key`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `settings`
|
|
--
|
|
|
|
LOCK TABLES `settings` WRITE;
|
|
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
|
|
INSERT INTO `settings` VALUES (1,'business_name','The Watch Reserve','string','general',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(2,'currency','PHP','string','general',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(3,'tax_enabled','false','boolean','tax',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(4,'tax_rate','12','float','tax',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(5,'tax_label','VAT','string','tax',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(6,'aging_caution_days','15','integer','aging',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(7,'aging_warning_days','30','integer','aging',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(8,'aging_danger_days','45','integer','aging',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(9,'aging_critical_days','46','integer','aging',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(10,'default_reservation_days','7','integer','reservation',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(11,'work_start_time','09:00','string','hr',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(12,'work_end_time','18:00','string','hr',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(13,'site_logo','cms/branding/logo-1774249551.png','string','branding',NULL,'2026-03-22 23:05:51','2026-03-22 23:05:51'),(14,'terms_conditions','All watch sales and trades at The Watch Reserve are final and cannot be changed, canceled, or\nrefunded once completed. Watches offered for trade must be authentic and accurately described;\nwe reserve the right to inspect and decline any transaction if authenticity or condition is in\nquestion. Ownership and risk pass to the buyer upon payment or handover.\n\nThe Watch Reserve sells all watches in good faith, representing that they have been lawfully\nacquired and are not reported lost or stolen to the best of our knowledge. By completing a sale or\ntrade, you agree to release, waive, and discharge The Watch Reserve, its owners, and staff from any\nliability, claims, or disputes arising from or related to the transaction, including loss, damage,\ndefects, or other issues, to the fullest extent permitted by law.','string','general',NULL,'2026-03-31 04:37:16','2026-03-31 05:56:43'),(15,'order_process','','string','general',NULL,'2026-03-31 04:37:16','2026-03-31 06:03:08'),(16,'service_warranty','Comprehensive Service Warranty for Timepieces\n\nWe are committed to delivering exceptional quality and reliability in every timepiece we offer. All watches, whether equipped with mechanical or quartz movements, are covered by our comprehensive service warranty to ensure optimal performance and customer confidence.\n\nWarranty Coverage\nThis warranty covers manufacturing defects in materials and workmanship under normal use. For mechanical watches, this includes the movement, gear train, and balance system. For quartz watches, coverage includes the electronic movement and internal components. During the warranty period, we will, at our discretion, repair or replace any defective parts without additional cost for labor.','string','general',NULL,'2026-03-31 04:37:16','2026-03-31 06:03:08'),(17,'payment_methods','We accept a variety of payment methods for your convenience, including cash, bank transfer, and cheque. Credit card payments are also available; however, please note that a 2.8% terminal processing fee will be applied to all credit card transactions.','string','general',NULL,'2026-03-31 04:37:16','2026-03-31 06:03:08');
|
|
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `shifts`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `shifts`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `shifts` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` bigint unsigned NOT NULL,
|
|
`date` date NOT NULL,
|
|
`start_time` time NOT NULL,
|
|
`end_time` time NOT NULL,
|
|
`type` enum('morning','mid','closing','custom','day_off') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'morning',
|
|
`notes` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_by` bigint unsigned DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `shifts_user_id_date_unique` (`user_id`,`date`),
|
|
KEY `shifts_created_by_foreign` (`created_by`),
|
|
CONSTRAINT `shifts_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
|
|
CONSTRAINT `shifts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`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 `shifts`
|
|
--
|
|
|
|
LOCK TABLES `shifts` WRITE;
|
|
/*!40000 ALTER TABLE `shifts` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `shifts` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `transactions`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `transactions`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `transactions` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`invoice_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`watch_id` bigint unsigned NOT NULL,
|
|
`customer_id` bigint unsigned DEFAULT NULL,
|
|
`staff_id` bigint unsigned NOT NULL,
|
|
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'sale',
|
|
`payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`payment_details` json DEFAULT NULL,
|
|
`document_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`amount` decimal(12,2) NOT NULL,
|
|
`tax_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
|
|
`discount_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
|
|
`total_amount` decimal(12,2) NOT NULL,
|
|
`profit` decimal(12,2) NOT NULL DEFAULT '0.00',
|
|
`notes` text COLLATE utf8mb4_unicode_ci,
|
|
`sold_at` timestamp NOT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `transactions_invoice_number_unique` (`invoice_number`),
|
|
KEY `transactions_watch_id_foreign` (`watch_id`),
|
|
KEY `transactions_customer_id_foreign` (`customer_id`),
|
|
KEY `transactions_type_index` (`type`),
|
|
KEY `transactions_sold_at_index` (`sold_at`),
|
|
KEY `transactions_staff_id_index` (`staff_id`),
|
|
CONSTRAINT `transactions_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
|
|
CONSTRAINT `transactions_staff_id_foreign` FOREIGN KEY (`staff_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
|
|
CONSTRAINT `transactions_watch_id_foreign` FOREIGN KEY (`watch_id`) REFERENCES `watches` (`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 `transactions`
|
|
--
|
|
|
|
LOCK TABLES `transactions` WRITE;
|
|
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `users`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `users`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `users` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email_verified_at` timestamp NULL DEFAULT NULL,
|
|
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `users_email_unique` (`email`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `users`
|
|
--
|
|
|
|
LOCK TABLES `users` WRITE;
|
|
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
|
|
INSERT INTO `users` VALUES (1,'TWR Admin','admin@twr.com',NULL,'$2y$12$EDNIgzLHj4Fq3oO//jxWiOaBsEHafLt6QW2MfC/ymv195iH1qWz8i',NULL,'2026-03-22 21:43:14','2026-03-22 21:43:14'),(2,'Sales Manager','sales@twr.com',NULL,'$2y$12$Y5q7HQLKZhoKZv0CnSyjDueqsU1BTtupSOU.6fE7I60mOAhOedNtW',NULL,'2026-03-22 21:43:14','2026-03-22 21:43:14'),(3,'Staff One','staff1@twr.com',NULL,'$2y$12$SxuotWNuFh7E81NbzW8vfuCFZDi7zzfzTcaMPwGI/H/FVdWcS/MuO',NULL,'2026-03-22 21:43:14','2026-03-22 21:43:14'),(4,'Staff Two','staff2@twr.com',NULL,'$2y$12$uSTjYx0xfHG04zVa9e.5/uNO8S8kBReejFRnOT7qqmjidow2jaRRa',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(5,'HR Manager','hr@twr.com',NULL,'$2y$12$61wA58P9kJC8F5CBDDJ2deDZa4ouRcRDQop/9NUwxRPiKjWXnPbc6',NULL,'2026-03-22 21:43:15','2026-03-22 21:43:15'),(6,'Andrea Punzalan','andreapunzalan@thewatchreserve.ph',NULL,'$2y$12$DKCBstIX7ghznrW.9w4Mw.PyCmVM5jAahsycqlUOGua8OE4mG.JVy','qfL8AlNFXZfX2nkzQaPXXlMMB0T6wnMryY8R7Qmdd58u5O1seIyphG9VMAob','2026-03-28 02:35:35','2026-04-13 13:21:31'),(7,'Beata Lopez','beatalopez@thewatchreserve.ph',NULL,'$2y$12$0d2/lnc8wV5ZbIeAkEnpKOar/BcxGX7WZrVBLmZmjvnDuLPWTzEue',NULL,'2026-03-28 02:35:36','2026-03-28 02:35:36'),(8,'Erica Agne','ericaagne@thewatchreserve.ph',NULL,'$2y$12$mYZLOoZvLBYBj5CoPU2Wo.ggKkXty7qUgj7Y.O8FaOh0YzW2bekXW','nN5jMVpkyOAQtZgBylgS5beUvh2tjTobJ446apIIDW3OeCVRoIl3cg46QOkr','2026-03-28 02:35:36','2026-04-13 13:22:04'),(9,'Miguel Bustamante','miguelbustamante@thewatchreserve.ph',NULL,'$2y$12$PeTa64ZHbgAYDUPQSy85Y.NqJFKNqjG.hIY4nXC3jtuUEPiyItAky',NULL,'2026-03-28 02:35:36','2026-03-28 02:35:36'),(10,'Nico Castillo','nicocastillo@thewatchreserve.ph',NULL,'$2y$12$ufkdUxOE3eMHfhHV4jKqZO9.3T3mu/YhBIdZwBtxjFhaO/umDK4Sm',NULL,'2026-03-28 02:35:36','2026-03-28 02:35:36'),(11,'Zhet Flores','zhetflores@thewatchreserve.ph',NULL,'$2y$12$lAst8ljbCZZwwxJk71hKgOZ0vuWBLIYY46NE9LEYjm5BSimkKryky',NULL,'2026-03-28 02:35:36','2026-03-28 02:35:36'),(12,'Lorenzo Galicia','lorenzogalicia@thewatchreserve.ph',NULL,'$2y$12$e.XEdIBTFsWDmG0z/PxrJeYClPoxErFE..jA9sIecPutniXAuILb2',NULL,'2026-03-28 02:35:37','2026-03-28 02:35:37'),(13,'Cassie Mallarie','cassie@thewatchreserve.ph',NULL,'$2y$12$u.9/drqAONjJysItkh0B.OR.RhebYHNm8cJzYb6svPcQpfK6Hi3I.',NULL,'2026-04-05 23:33:00','2026-04-13 13:21:58'),(14,'Ann Segundo','annsegundo@thewatchreserve.ph',NULL,'$2y$12$hY2fVX5BcBqvGZqOb3yJ4OT782aMGDFsitIxutkd9Ko7S7z3eDIwu','AxCayCC1VNdFthoSiDB9CVjCGu2cMnhJc919lCVwPR9IG5PDbHsX2Cu1ngVP','2026-04-05 23:33:14','2026-04-13 13:21:36');
|
|
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `valuation_bookings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `valuation_bookings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `valuation_bookings` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`booking_date` date NOT NULL,
|
|
`booking_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
|
|
`admin_notes` text COLLATE utf8mb4_unicode_ci,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL 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 `valuation_bookings`
|
|
--
|
|
|
|
LOCK TABLES `valuation_bookings` WRITE;
|
|
/*!40000 ALTER TABLE `valuation_bookings` DISABLE KEYS */;
|
|
/*!40000 ALTER TABLE `valuation_bookings` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
|
|
--
|
|
-- Table structure for table `watches`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `watches`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `watches` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`brand_id` bigint unsigned DEFAULT NULL,
|
|
`brand` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`reference_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`serial_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
|
|
`condition` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pre-owned',
|
|
`description` text COLLATE utf8mb4_unicode_ci,
|
|
`image_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
|
|
`gallery` json DEFAULT NULL,
|
|
`cost_price` decimal(12,2) NOT NULL,
|
|
`selling_price` decimal(12,2) NOT NULL,
|
|
`status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'intake',
|
|
`photos` json DEFAULT NULL,
|
|
`consignor_id` bigint unsigned DEFAULT NULL,
|
|
`listed_at` timestamp NULL DEFAULT NULL,
|
|
`sold_at` timestamp NULL DEFAULT NULL,
|
|
`created_at` timestamp NULL DEFAULT NULL,
|
|
`updated_at` timestamp NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `watches_serial_number_unique` (`serial_number`),
|
|
KEY `watches_consignor_id_foreign` (`consignor_id`),
|
|
KEY `watches_status_index` (`status`),
|
|
KEY `watches_brand_index` (`brand`),
|
|
KEY `watches_brand_id_foreign` (`brand_id`),
|
|
CONSTRAINT `watches_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE SET NULL,
|
|
CONSTRAINT `watches_consignor_id_foreign` FOREIGN KEY (`consignor_id`) REFERENCES `consignors` (`id`) ON DELETE SET NULL
|
|
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `watches`
|
|
--
|
|
|
|
LOCK TABLES `watches` WRITE;
|
|
/*!40000 ALTER TABLE `watches` DISABLE KEYS */;
|
|
INSERT INTO `watches` VALUES (43,2,'Omega','test','3243','1234','pre-owned','test','watches/LnzhMZfnN1aIofm7p3estdvoPbqSvBcly1HcMTvg.jpg','[\"watches/gallery/adtgNn8EyGFuVm0M61UI4axWgNY2mH6Ly8B7Stx1.jpg\"]',1.00,2.00,'intake',NULL,NULL,NULL,NULL,'2026-03-30 19:00:28','2026-03-30 19:00:28'),(44,1,'Rolex','GMT-Master II \"Pepsi\"','16710','C0U1S0Y2X5','pre-owned','Year: 1993\nCase Size: 40mm\nInclusions: Outer Box, Inner Box, Red Tag & Papers\nCondition: 9.6/10\nComes with 2 years service warranty\n\nEvery image showcased is an original work created and owned by The Watch Reserve','watches/hsHLlfAS2SBl4gFNiNWQ9B8JHjduAeUOzPzUozli.jpg','[\"watches/gallery/DSyphouYDrZhlXdbJALvffIopzGqp0z28JXOLdiT.jpg\", \"watches/gallery/SvdsnRCi8spGpokM2IgAyyGPEDpo5gwlhB9Pa6j2.jpg\"]',600000.00,788000.00,'listed',NULL,NULL,'2026-03-30 19:44:59',NULL,'2026-03-30 19:44:35','2026-03-31 04:20:55'),(45,1,'Rolex','GMT-Master II \"Rootbeer\"','126711CHNR','K1W0M4Q7X5','pre-owned','<p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Year: 2021</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Case Size: 40mm</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Inclusions: Outer Box, Inner Box, Manual, NFC Card, Leather Card Holder, & Green Tag</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Condition: 9.8/10</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Comes with 2 years service warranty</span></p><p><br></p>','watches/7fPW9zDyXkKxopfwK211OtdIZjDoit06vp8igjKS.jpg','[\"watches/gallery/mSMaCBgIoDy8ExbpiDdPXMKZrixp6lGA1ZkbFBnX.jpg\", \"watches/gallery/0gvV1w8Qrn88c4po0METqhyk9tiQVrKLEbtlIe1f.jpg\", \"watches/gallery/cX67wLEd5rsArlNLf0In0tLRpBexRkIp1nkFb3tX.jpg\"]',1050000.00,1218000.00,'listed',NULL,NULL,'2026-04-11 08:50:29',NULL,'2026-04-11 08:41:30','2026-04-11 09:03:09'),(46,1,'Rolex','Datejust 31 - Blue Sunburst','278274','U0S1Y0G9X5','pre-owned','<p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Year: 2022</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Case Size: 31mm</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Inclusions: Outer Box, Inner Box, Manual, NFC Card, Leather Card Holder, & Green Tag</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Condition: 9.8/10</span></p><p><span style=\"background-color: rgb(245, 241, 234); color: oklab(0.22645 0 0 / 0.6);\">Comes with 2 years service warranty</span></p><p><br></p>','watches/tNAkFqVFDQPTheo78bWK5EUi778mFY309UH50OJ7.jpg','[]',670000.00,695000.00,'listed',NULL,NULL,'2026-04-11 08:56:14',NULL,'2026-04-11 08:48:52','2026-04-11 09:02:55'),(47,1,'Rolex','Datejust 36 - Panna Dial','16234','D0E0O7K4X0','pre-owned','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 1990</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 36mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Manual, & Service Paper</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: 9.6/10</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p>','watches/j4yu6lUN6ZGDdQ0sAWqfp8d5dvYd97WoEgNca6wj.jpg','[\"watches/gallery/Wn5Z7OsDbDGoJTHC7jD5Sg5GvVXrFypVxxtQN07w.jpg\", \"watches/gallery/qGZ44qIKd4aH0i7S81vAx5cp6TVqSPMuO44TaI27.jpg\", \"watches/gallery/bwrHajwHZ14yfddQ7mKPjuLSSK8oCQFpMqBNQsjE.jpg\", \"watches/gallery/HxMKjyloye3xFDz7kYGzEo1UyUJiOf3zfdEfniBO.jpg\"]',315000.00,388000.00,'listed',NULL,NULL,'2026-04-11 09:02:42',NULL,'2026-04-11 09:02:38','2026-04-11 09:02:42'),(48,1,'Rolex','Seadweller - SD4K (NOS)','116600','W0M1Q1E7X5','new','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 2015</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 40mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Manual, Card, Leather Card Holder,</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: New Old Stock</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p>','watches/IQzexVEJwLnlCyZDl4hmA8le7cO4iCaLOQmSge0A.jpg','[\"watches/gallery/nQBO6xzSpOdO7yy0zFFqNXgLeL7HjsDCgyTE1MMO.jpg\", \"watches/gallery/LuOudcaRCc8SY8AGFLCbadFfh5sGCvzfCy1PIqtG.jpg\", \"watches/gallery/4lGJkqsuPuaHEFTrpgPu4LCc37NwxYdh0vKX4qyB.jpg\", \"watches/gallery/8RJxzdETpLNbvYNAHChgcjAW08ykhReNVix1Pocm.jpg\"]',750000.00,818000.00,'listed',NULL,NULL,'2026-04-11 09:18:28',NULL,'2026-04-11 09:17:53','2026-04-11 11:06:15'),(49,3,'Tudor','1926','91350','V0C0U4S9X8','new','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 2023</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 28mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Manual, Card, & White Tag</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: New Old Stock</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p>','watches/cHtHNPBwMCppBDwelI5AZhH2ElSlYDxNJ3MrSBO8.jpg','[\"watches/gallery/wTXs2NiGEKxgyBd2bjCOktdWcazx2bDjBOwVSpTh.jpg\", \"watches/gallery/QJIIi0mJWPacxyAXAyS1XvRDOhCtiMYbkMkvMwpY.jpg\", \"watches/gallery/KdfgmOVNgs48hPAHzy61y9eb7ygzgNO65WnbyIY7.jpg\", \"watches/gallery/ZNyNNe74WLl0lIWs4GEMYFvljoe9RVAGKUyx6nBq.jpg\"]',73000.00,95000.00,'listed',NULL,NULL,'2026-04-11 11:09:34',NULL,'2026-04-11 11:09:31','2026-04-11 11:09:34'),(50,6,'Cartier','Santos De Cartier Medium (Green)','WSSA0061','W0M0Q7E8X5','new','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 2025</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 35mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Card, & Cartier Kit</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: Brand new</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p>','watches/7Hb7JGkWsKtDuPsWNpUqTlNKN2eCo89RqIywaD1Y.jpg','[\"watches/gallery/IGXEaQhg9KbHc5S7hJMo1ABUVgMqVUctU6jTyzSP.jpg\", \"watches/gallery/P56PBa6WjroGjC76mLCJbP5Bn9VyLCRoyITBna7e.jpg\", \"watches/gallery/LIBAT2qW9cudEOmZ12Tyfpa9pKmyyXKIsTjN1SND.jpg\", \"watches/gallery/WLgIgunL45JUwm4azKQTjtTKz9fj12T3Bj5DEwig.jpg\"]',360000.00,458000.00,'listed',NULL,NULL,'2026-04-11 11:17:13',NULL,'2026-04-11 11:17:05','2026-04-11 11:29:23'),(51,6,'Cartier','Santos De Cartier Medium (Blue)','WSSA0063','Q0M0S7C8X0','new','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 2025</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 35mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Card, & Cartier Kit</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: Brand new</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p><p><br></p>','watches/Qunfzd4BFBUwoNmKI01ZtoUbGNlFMAmu97q1TLSl.jpg','[]',354825.00,458000.00,'listed',NULL,NULL,'2026-04-11 11:26:37',NULL,'2026-04-11 11:25:48','2026-04-11 11:31:10'),(52,6,'Cartier','Santos de Cartier Large (ADLC)','WSSA0039','n/a','pre-owned','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 2022</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 40mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Card, & Cartier Kit</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: 9.8/10</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p>','watches/FN7DYS1qRu0mc9JCBgq21QgMMri6pZ868fNNEr0H.jpg','[\"watches/gallery/il77uxMBsc8Kd9PdGxjQflXL7fPoAIUnJ8jXbUeb.jpg\", \"watches/gallery/R4DW2K7I0NgMaGYnX7HakGc59BeOPeMrabKT29nP.jpg\", \"watches/gallery/JkuoRWWrYRN5BXCBbLyzZS9Zf33L8KEBTUDCSm6c.jpg\", \"watches/gallery/FpiQ8athnLj8vFL60Z99VPeTklxiGUxTTyKZjqjx.jpg\"]',360000.00,428000.00,'sold',NULL,NULL,NULL,'2026-04-12 09:18:17','2026-04-11 11:40:05','2026-04-12 09:18:17'),(53,6,'Cartier','Santos 100 Medium','2878','W0M0Q6E5X5','pre-owned','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: No Date</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 33mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Watch Only</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: 9.5/10</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 1 year service warranty</span></p><p><br></p>','watches/H2QIFqHJaFhoNuTAaR2hgCa3H9th8P9vm3OljvZC.jpg',NULL,230000.00,268000.00,'listed',NULL,NULL,'2026-04-12 03:46:22',NULL,'2026-04-12 03:46:06','2026-04-12 09:23:17'),(54,1,'Rolex','Datejust 36 - Champagne','16233','V0F0D7E8X4','pre-owned','<p><span style=\"background-color: rgb(245, 241, 234);\">Year: 1994</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Case Size: 36mm</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Inclusions: Outer Box, Inner Box, Manual, Rolex Guarantee Paper,</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Condition: 9.6/10</span></p><p><span style=\"background-color: rgb(245, 241, 234);\">Comes with 2 years service warranty</span></p>','watches/TUHkBpnrfr78XbXpj1FzK5d1ojKbHJ8KUUZwEp8g.jpg','[\"watches/gallery/PvCw44hKAbgG9MAaKZ57R28UBNg6hvCdvsUksej3.jpg\", \"watches/gallery/utsc6hcPD09DvsRuDlZiGNo6BmslvPMlTQnNwrud.jpg\", \"watches/gallery/W7Do2KBLPPP9kDbnqeY5gLMe5rZhV5uyviImeCs3.jpg\", \"watches/gallery/5tCuk0AfWLAMK2JDzmWmHH0rklGJ9m6OzE3rqsFL.jpg\"]',359350.00,428000.00,'listed',NULL,NULL,'2026-04-12 09:18:24',NULL,'2026-04-12 05:13:54','2026-04-12 09:18:24'),(55,5,'Patek Philippe','Gondolo','5489-R-001','J0N1H0S8X4','pre-owned','<p>Year: <span style=\"color: rgb(0, 0, 0);\">2007</span></p><p><br></p><p>Case Size: 34mm</p><p><br></p><p>Inclusions: Complete</p><p><br></p><p>Comes with 1 year service warranty</p>','watches/1CZ3nCF04m1DpBQNZx4uOzTK9HXrzw6HLO0PG4R6.jpg','[\"watches/gallery/7MgoRfJTJffo9Jqev5AFTsVH9IfdMZV0LMMCvKpV.jpg\", \"watches/gallery/cdnkinVJ3FvQHICKr5nYGEMpLwyoYeulgq7EnbDj.jpg\", \"watches/gallery/6deL9u0WC1CN7leklkeNzjlXnHaWrKF8mYO5KlIC.jpg\", \"watches/gallery/90I7s7vmwDpLtHxLCLSO1VAHDVTABdRjTrdu6Nez.jpg\"]',659170.00,998000.00,'listed',NULL,NULL,'2026-04-12 09:17:48',NULL,'2026-04-12 09:17:29','2026-04-12 09:22:51'),(56,1,'Rolex','Oyster Perpetual w/ Date - Aligator Strap','6627','Q0H0Y6L4X9','pre-owned','<p>Year: 1967</p><p><br></p><p>Case Size: 31mm</p><p><br></p><p>Inclusions: Box only</p><p><br></p><p>Comes with 1 year service warranty</p>','watches/0YenrqvNNpbkR6PIDyXxI4NNUf71DbKsOLu8iZ01.jpg','[\"watches/gallery/XdJ1Y67APpoA21FTVtJhHG4f5m4FNRvWwQGdMRme.jpg\", \"watches/gallery/tN8B67RsEdso2uoU8QE1C6KsWJDuCvY09dnqPAUQ.jpg\", \"watches/gallery/iFvotRLYN2pBYLe03vF48CBEaXvIWfJXbbLMXdWW.jpg\"]',224365.00,388000.00,'listed',NULL,NULL,'2026-04-12 09:23:47',NULL,'2026-04-12 09:21:32','2026-04-12 09:23:47'),(57,5,'Patek Philippe','Twenty~4 (Green)','4910/1200A-011','Q0E1O3K2X5','pre-owned','<p>Year: <span style=\"color: rgb(0, 0, 0);\">2024</span></p><p><br></p><p>Case Size: 25mm x 30mm</p><p><br></p><p>Inclusions: Complete</p><p><br></p><p>Comes with 1 year service warranty</p>','watches/FRvtZWPwntg4rfi5JTZfWmbJ1lNRgvs3CDfPjU6P.jpg','[\"watches/gallery/Og3sfoDP6aLH8iUWoE8nhijG6MSfDQMWSzaUC1lY.jpg\", \"watches/gallery/GjQ6uvPsT6l8NTjRMAbWZZ4Xqeuny1BiEuLY9jZg.jpg\", \"watches/gallery/HuXyaQzGKeZh6jReZh9fc5pdsKdpsojHNmmme4Bk.jpg\", \"watches/gallery/b0Z71xtm1GAGWbiaRUXzWRpuLUrN0nSasYM6VH0u.jpg\"]',900000.00,968000.00,'listed',NULL,NULL,'2026-04-13 06:21:33',NULL,'2026-04-13 06:21:26','2026-04-13 06:21:33'),(58,1,'Rolex','Datejust 31 (MOP White Roman)','178271','M0X1Z2Q1X8','pre-owned','<p>Year: 2019</p><p><br></p><p>Case Size: 31mm</p><p><br></p><p>Inclusions: Complete</p><p><br></p><p>Comes with 2 year service warranty</p>','watches/mmf4Y6sriiRoeyIU0jJnV34JHexazfK2BqiSSjfV.jpg','[\"watches/gallery/nXNwE403Zh4cSjukEm81WJ3p6p10CvuvEpl91Ief.jpg\", \"watches/gallery/GHv9Ixtjt82kj74JfTpuA2sMbpATDJafvLT27hk1.jpg\", \"watches/gallery/Im9FjjOj8PtzKJDLYnTItNALXnnxtpCJPECCWYVd.jpg\"]',792730.00,998000.00,'listed',NULL,NULL,'2026-04-13 06:24:50',NULL,'2026-04-13 06:24:35','2026-04-13 07:40:18'),(59,1,'Rolex','Datejust 36 White Roman','126234','Q0E1O0K6X5','new','<p>Year: 2026</p><p><br></p><p>Case Size: 36mm</p><p><br></p><p>Inclusions: Complete</p><p><br></p><p>Comes with 2 year service warranty</p>','watches/5Ipj6DD72aVj9nfZBTkgMJdYAgSTcHpaYkmkAaTJ.jpg',NULL,640000.00,758000.00,'listed',NULL,NULL,'2026-04-13 07:38:55',NULL,'2026-04-13 07:38:49','2026-04-13 07:38:55'),(60,1,'Rolex','Datejust 41 Azurro Blue ','126334','B0K1W1M8X0','new','<p>Year: 2026</p><p><br></p><p>Case Size: 41mm</p><p><br></p><p>Inclusions: Complete</p><p><br></p><p>Comes with 2 year service warranty</p>','watches/5OfB2CeGpMX2Zht6SCPov7Ox9wUnm5AMF1PeEYNC.jpg','[\"watches/gallery/unX6q7skHkeMjErKh13RhD672XuwrusAZW5aNsUz.jpg\", \"watches/gallery/8Oh3yJFYr89NV26f6hdfBmkLBCW6FtbOawOx8oHR.jpg\", \"watches/gallery/p1GAbm1rpYQulS9yqk6eBTT24sx7qGC4L8Oa9HCm.jpg\"]',755000.00,908000.00,'sold',NULL,NULL,'2026-04-13 07:42:34','2026-04-16 10:00:24','2026-04-13 07:42:25','2026-04-16 10:00:24');
|
|
/*!40000 ALTER TABLE `watches` 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 2026-04-17 11:46:24
|