PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null);
INSERT INTO migrations VALUES(1,'0001_01_01_000000_create_users_table',1);
INSERT INTO migrations VALUES(2,'0001_01_01_000001_create_cache_table',1);
INSERT INTO migrations VALUES(3,'0001_01_01_000002_create_jobs_table',1);
INSERT INTO migrations VALUES(4,'2026_03_13_005333_create_permission_tables',1);
INSERT INTO migrations VALUES(5,'2026_03_13_010000_create_consignors_table',1);
INSERT INTO migrations VALUES(6,'2026_03_13_010100_create_customers_table',1);
INSERT INTO migrations VALUES(7,'2026_03_13_010150_create_brands_table',1);
INSERT INTO migrations VALUES(8,'2026_03_13_010200_create_watches_table',1);
INSERT INTO migrations VALUES(9,'2026_03_13_010250_add_brand_id_and_images_to_watches',1);
INSERT INTO migrations VALUES(10,'2026_03_13_010300_create_consignments_table',1);
INSERT INTO migrations VALUES(11,'2026_03_13_010400_create_reservations_table',1);
INSERT INTO migrations VALUES(12,'2026_03_13_010500_create_transactions_table',1);
INSERT INTO migrations VALUES(13,'2026_03_13_010600_create_attendances_table',1);
INSERT INTO migrations VALUES(14,'2026_03_13_010700_create_leave_tables',1);
INSERT INTO migrations VALUES(15,'2026_03_13_010800_create_settings_table',1);
INSERT INTO migrations VALUES(16,'2026_03_13_010900_create_inquiries_table',1);
INSERT INTO migrations VALUES(17,'2026_03_13_011000_create_consignment_requests_table',1);
INSERT INTO migrations VALUES(18,'2026_03_13_011100_create_hero_sections_table',1);
INSERT INTO migrations VALUES(19,'2026_03_13_011200_create_marquee_tables',1);
INSERT INTO migrations VALUES(20,'2026_03_13_024301_add_font_sizes_to_hero_sections',1);
INSERT INTO migrations VALUES(21,'2026_03_14_011300_create_appointment_sections_table',1);
INSERT INTO migrations VALUES(22,'2026_03_14_011400_create_instagram_tables',1);
INSERT INTO migrations VALUES(23,'2026_03_23_013017_add_consign_fields_to_marquee_sections_table',1);
INSERT INTO migrations VALUES(24,'2026_03_23_014215_add_journal_fields_to_appointment_sections_table',1);
INSERT INTO migrations VALUES(25,'2026_03_23_023509_add_preferred_contact_to_inquiries_table',1);
INSERT INTO migrations VALUES(26,'2026_03_23_030711_create_history_pages_table',1);
INSERT INTO migrations VALUES(27,'2026_03_24_060000_add_password_to_customers_table',2);
INSERT INTO migrations VALUES(28,'2026_03_24_061810_create_personal_access_tokens_table',2);
INSERT INTO migrations VALUES(29,'2026_03_24_074303_create_newsletter_subscribers_table',3);
INSERT INTO migrations VALUES(30,'2026_03_25_121402_create_services_pages_table',3);
INSERT INTO migrations VALUES(31,'2026_03_25_132734_create_valuation_bookings_table',4);
INSERT INTO migrations VALUES(32,'2026_03_25_140740_create_shifts_table',4);
INSERT INTO migrations VALUES(33,'2026_03_25_142458_add_payment_details_to_transactions_table',5);
INSERT INTO migrations VALUES(34,'2026_03_25_144004_add_document_path_to_transactions_table',6);
INSERT INTO migrations VALUES(35,'2026_03_28_093805_create_service_requests_table',7);
INSERT INTO migrations VALUES(36,'2026_03_31_121356_change_commission_rates_to_flat_amount_in_tables',8);
INSERT INTO migrations VALUES(37,'2026_04_07_141118_make_message_nullable_on_inquiries_table',9);
CREATE TABLE IF NOT EXISTS "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar not null, "remember_token" varchar, "created_at" datetime, "updated_at" datetime);
INSERT INTO users VALUES(1,'TWR Admin','admin@twr.com',NULL,'$2y$12$EDNIgzLHj4Fq3oO//jxWiOaBsEHafLt6QW2MfC/ymv195iH1qWz8i',NULL,'2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO users VALUES(2,'Sales Manager','sales@twr.com',NULL,'$2y$12$Y5q7HQLKZhoKZv0CnSyjDueqsU1BTtupSOU.6fE7I60mOAhOedNtW',NULL,'2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO users VALUES(3,'Staff One','staff1@twr.com',NULL,'$2y$12$SxuotWNuFh7E81NbzW8vfuCFZDi7zzfzTcaMPwGI/H/FVdWcS/MuO',NULL,'2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO users VALUES(4,'Staff Two','staff2@twr.com',NULL,'$2y$12$uSTjYx0xfHG04zVa9e.5/uNO8S8kBReejFRnOT7qqmjidow2jaRRa',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO users VALUES(5,'HR Manager','hr@twr.com',NULL,'$2y$12$61wA58P9kJC8F5CBDDJ2deDZa4ouRcRDQop/9NUwxRPiKjWXnPbc6',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO users VALUES(6,'Andrea Punzalan','andreapunzalan@thewatchreserve.ph',NULL,'$2y$12$DKCBstIX7ghznrW.9w4Mw.PyCmVM5jAahsycqlUOGua8OE4mG.JVy','qfL8AlNFXZfX2nkzQaPXXlMMB0T6wnMryY8R7Qmdd58u5O1seIyphG9VMAob','2026-03-28 10:35:35','2026-04-13 21:21:31');
INSERT INTO users VALUES(7,'Beata Lopez','beatalopez@thewatchreserve.ph',NULL,'$2y$12$0d2/lnc8wV5ZbIeAkEnpKOar/BcxGX7WZrVBLmZmjvnDuLPWTzEue',NULL,'2026-03-28 10:35:36','2026-03-28 10:35:36');
INSERT INTO users VALUES(8,'Erica Agne','ericaagne@thewatchreserve.ph',NULL,'$2y$12$mYZLOoZvLBYBj5CoPU2Wo.ggKkXty7qUgj7Y.O8FaOh0YzW2bekXW','nN5jMVpkyOAQtZgBylgS5beUvh2tjTobJ446apIIDW3OeCVRoIl3cg46QOkr','2026-03-28 10:35:36','2026-04-13 21:22:04');
INSERT INTO users VALUES(9,'Miguel Bustamante','miguelbustamante@thewatchreserve.ph',NULL,'$2y$12$PeTa64ZHbgAYDUPQSy85Y.NqJFKNqjG.hIY4nXC3jtuUEPiyItAky',NULL,'2026-03-28 10:35:36','2026-03-28 10:35:36');
INSERT INTO users VALUES(10,'Nico Castillo','nicocastillo@thewatchreserve.ph',NULL,'$2y$12$ufkdUxOE3eMHfhHV4jKqZO9.3T3mu/YhBIdZwBtxjFhaO/umDK4Sm',NULL,'2026-03-28 10:35:36','2026-03-28 10:35:36');
INSERT INTO users VALUES(11,'Zhet Flores','zhetflores@thewatchreserve.ph',NULL,'$2y$12$lAst8ljbCZZwwxJk71hKgOZ0vuWBLIYY46NE9LEYjm5BSimkKryky',NULL,'2026-03-28 10:35:36','2026-03-28 10:35:36');
INSERT INTO users VALUES(12,'Lorenzo Galicia','lorenzogalicia@thewatchreserve.ph',NULL,'$2y$12$e.XEdIBTFsWDmG0z/PxrJeYClPoxErFE..jA9sIecPutniXAuILb2',NULL,'2026-03-28 10:35:37','2026-03-28 10:35:37');
INSERT INTO users VALUES(13,'Cassie Mallarie','cassie@thewatchreserve.ph',NULL,'$2y$12$u.9/drqAONjJysItkh0B.OR.RhebYHNm8cJzYb6svPcQpfK6Hi3I.',NULL,'2026-04-06 07:33:00','2026-04-13 21:21:58');
INSERT INTO users VALUES(14,'Ann Segundo','annsegundo@thewatchreserve.ph',NULL,'$2y$12$hY2fVX5BcBqvGZqOb3yJ4OT782aMGDFsitIxutkd9Ko7S7z3eDIwu','AxCayCC1VNdFthoSiDB9CVjCGu2cMnhJc919lCVwPR9IG5PDbHsX2Cu1ngVP','2026-04-06 07:33:14','2026-04-13 21:21:36');
CREATE TABLE IF NOT EXISTS "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"));
CREATE TABLE IF NOT EXISTS "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"));
INSERT INTO sessions VALUES('mACpmoKllo1sJI6pZni10MjrO9C0C2Gd3wcuGL7Y',9,'136.158.26.212','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','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVzNDaUhDTnpBS1lDQ3Z2VWIyZm1pR1ZnYUk2ajI5MWJPS1BvYXBYZSI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjQzOiJodHRwczovL2FkbWluLnRoZXdhdGNocmVzZXJ2ZS5waC9pbnZvaWNlLzE3IjtzOjU6InJvdXRlIjtzOjEzOiJpbnZvaWNlLnByaW50Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6OTt9',1776333625);
CREATE TABLE IF NOT EXISTS "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"));
INSERT INTO cache VALUES('the-watch-reserve-cache-356a192b7913b04c54574d18c28d46e6395428ab:timer','i:1774926071;',1774926071);
INSERT INTO cache VALUES('the-watch-reserve-cache-356a192b7913b04c54574d18c28d46e6395428ab','i:2;',1774926071);
INSERT INTO cache VALUES('the-watch-reserve-cache-0ade7c2cf97f75d009975f4d720d1fa6c19f4897:timer','i:1774928629;',1774928629);
INSERT INTO cache VALUES('the-watch-reserve-cache-0ade7c2cf97f75d009975f4d720d1fa6c19f4897','i:2;',1774928629);
INSERT INTO cache VALUES('the-watch-reserve-cache-fe5dbbcea5ce7e2988b8c69bcfdfde8904aabc1f:timer','i:1775967111;',1775967111);
INSERT INTO cache VALUES('the-watch-reserve-cache-fe5dbbcea5ce7e2988b8c69bcfdfde8904aabc1f','i:2;',1775967111);
INSERT INTO cache VALUES('the-watch-reserve-cache-c1dfd96eea8cc2b62785275bca38ac261256e278:timer','i:1776066195;',1776066195);
INSERT INTO cache VALUES('the-watch-reserve-cache-c1dfd96eea8cc2b62785275bca38ac261256e278','i:2;',1776066195);
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";}}}',1776419996);
CREATE TABLE IF NOT EXISTS "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"));
CREATE TABLE IF NOT EXISTS "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null);
CREATE TABLE IF NOT EXISTS "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"));
CREATE TABLE IF NOT EXISTS "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" text not null, "queue" text not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP);
CREATE TABLE IF NOT EXISTS "permissions" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime);
INSERT INTO permissions VALUES(1,'view_dashboard','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(2,'manage_watches','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(3,'manage_sales','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(4,'manage_inquiries','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(5,'manage_consignment','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(6,'manage_bookings','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(7,'manage_newsletter','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(8,'manage_cms','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(9,'manage_hr','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
INSERT INTO permissions VALUES(10,'manage_users','web','2026-03-25 14:15:34','2026-03-25 14:15:34');
CREATE TABLE IF NOT EXISTS "roles" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime);
INSERT INTO roles VALUES(1,'Admin','web','2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO roles VALUES(2,'Sales Manager','web','2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO roles VALUES(3,'Sales Staff','web','2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO roles VALUES(4,'HR Manager','web','2026-03-23 05:43:14','2026-03-23 05:43:14');
INSERT INTO roles VALUES(5,'Consignor','web','2026-03-23 05:43:14','2026-03-23 05:43:14');
CREATE TABLE IF NOT EXISTS "model_has_permissions" ("permission_id" integer not null, "model_type" varchar not null, "model_id" integer not null, foreign key("permission_id") references "permissions"("id") on delete cascade, primary key ("permission_id", "model_id", "model_type"));
INSERT INTO model_has_permissions VALUES(1,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(2,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(3,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(4,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(5,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(6,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(7,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(8,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(9,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(10,'App\Models\User',1);
INSERT INTO model_has_permissions VALUES(6,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(5,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(4,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(3,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(2,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(1,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(10,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(7,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(9,'App\Models\User',9);
INSERT INTO model_has_permissions VALUES(8,'App\Models\User',9);
CREATE TABLE IF NOT EXISTS "model_has_roles" ("role_id" integer not null, "model_type" varchar not null, "model_id" integer not null, foreign key("role_id") references "roles"("id") on delete cascade, primary key ("role_id", "model_id", "model_type"));
INSERT INTO model_has_roles VALUES(2,'App\Models\User',2);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',3);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',4);
INSERT INTO model_has_roles VALUES(4,'App\Models\User',5);
INSERT INTO model_has_roles VALUES(1,'App\Models\User',1);
INSERT INTO model_has_roles VALUES(1,'App\Models\User',7);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',11);
INSERT INTO model_has_roles VALUES(1,'App\Models\User',12);
INSERT INTO model_has_roles VALUES(4,'App\Models\User',10);
INSERT INTO model_has_roles VALUES(1,'App\Models\User',9);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',6);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',14);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',13);
INSERT INTO model_has_roles VALUES(3,'App\Models\User',8);
CREATE TABLE IF NOT EXISTS "role_has_permissions" ("permission_id" integer not null, "role_id" integer not null, foreign key("permission_id") references "permissions"("id") on delete cascade, foreign key("role_id") references "roles"("id") on delete cascade, primary key ("permission_id", "role_id"));
INSERT INTO role_has_permissions VALUES(1,1);
INSERT INTO role_has_permissions VALUES(2,1);
INSERT INTO role_has_permissions VALUES(3,1);
INSERT INTO role_has_permissions VALUES(4,1);
INSERT INTO role_has_permissions VALUES(5,1);
INSERT INTO role_has_permissions VALUES(6,1);
INSERT INTO role_has_permissions VALUES(7,1);
INSERT INTO role_has_permissions VALUES(8,1);
INSERT INTO role_has_permissions VALUES(9,1);
INSERT INTO role_has_permissions VALUES(10,1);
INSERT INTO role_has_permissions VALUES(1,4);
INSERT INTO role_has_permissions VALUES(9,4);
INSERT INTO role_has_permissions VALUES(1,2);
INSERT INTO role_has_permissions VALUES(2,2);
INSERT INTO role_has_permissions VALUES(3,2);
INSERT INTO role_has_permissions VALUES(4,2);
INSERT INTO role_has_permissions VALUES(5,2);
INSERT INTO role_has_permissions VALUES(6,2);
INSERT INTO role_has_permissions VALUES(7,2);
INSERT INTO role_has_permissions VALUES(1,3);
INSERT INTO role_has_permissions VALUES(2,3);
INSERT INTO role_has_permissions VALUES(3,3);
INSERT INTO role_has_permissions VALUES(4,3);
CREATE TABLE IF NOT EXISTS "customers" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar, "phone" varchar, "address" text, "notes" text, "created_at" datetime, "updated_at" datetime, "password" varchar, "remember_token" varchar);
INSERT INTO customers VALUES(1,'Juan Dela Cruz','juan@email.com','+63 917 111 2222','','','2026-03-23 05:43:15','2026-03-23 16:34:15',NULL,NULL);
INSERT INTO customers VALUES(2,'Maria Santos','maria@email.com','+63 918 333 4444',NULL,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15',NULL,NULL);
INSERT INTO customers VALUES(3,'Carlos Reyes','carlos@email.com','+63 919 555 6666',NULL,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15',NULL,NULL);
INSERT INTO customers VALUES(4,'Ana Garcia','ana@email.com','+63 920 777 8888',NULL,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15',NULL,NULL);
INSERT INTO customers VALUES(5,'Roberto Tan','roberto@email.com','+63 921 999 0000',NULL,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15',NULL,NULL);
INSERT INTO customers VALUES(6,'alfredo cachero','badjingersz@gmail.com','+639289005006',NULL,NULL,'2026-03-24 06:49:01','2026-03-24 06:49:01','$2y$12$nRRidg91haPzoajILQhIeePZASHV8C8/5rA/fopmCGc9R0jVwNYga',NULL);
INSERT INTO customers VALUES(7,'Customer','karylltest@gmail.com','09473270087','','','2026-03-24 09:57:57','2026-03-24 09:58:53','$2y$12$CiMBTriZhkFawxgYzaUsO.CkY8nHhJOCF5G.YNGAINR7QFwcbRswq',NULL);
INSERT INTO customers VALUES(8,'Customer','karyll.anchai@gmail.com','09473270087',NULL,NULL,'2026-03-24 09:59:29','2026-03-24 09:59:29','$2y$12$pGsePHRIFRWlTSh679lSpuFKFHwA9PCUsufYfXH1i5PssTaSh26.O',NULL);
INSERT INTO customers VALUES(9,'Beata Lopez','beatadlopez@gmail.com','09174948419',NULL,NULL,'2026-03-24 14:42:36','2026-03-24 14:42:36','$2y$12$CFw7RJ9P6y1v5tOilK4GFeadrJou0Ecbuh1uE83JMc30L8nXwB/Wm',NULL);
INSERT INTO customers VALUES(10,'charles edward','dvapp.charles@gmail.com','+639085819330',NULL,NULL,'2026-03-28 04:18:20','2026-03-28 04:18:20','$2y$12$hpIgtokz./Dgbahf.3VOhOHU.3E4ocawCQR9KAr8gkwZUzvM6DkNC',NULL);
INSERT INTO customers VALUES(11,'Test','test@gmail.com','09456875541','Test','test','2026-03-28 07:29:54','2026-03-28 07:29:54',NULL,NULL);
CREATE TABLE IF NOT EXISTS "brands" ("id" integer primary key autoincrement not null, "name" varchar not null, "slug" varchar not null, "country" varchar, "logo_path" varchar, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime);
INSERT INTO brands VALUES(1,'Rolex','rolex','Switzerland',NULL,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO brands VALUES(2,'Omega','omega','Switzerland',NULL,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO brands VALUES(3,'Tudor','tudor','Switzerland',NULL,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO brands VALUES(4,'Audemars Piguet','audemars-piguet','Switzerland',NULL,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO brands VALUES(5,'Patek Philippe','patek-philippe','Switzerland',NULL,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO brands VALUES(6,'Cartier','cartier','France',NULL,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO brands VALUES(7,'Jaeger-LeCoultre','jaeger-lecoultre','Switzerland',NULL,1,'2026-03-31 02:47:00','2026-03-31 02:47:00');
INSERT INTO brands VALUES(8,'Vacheron Constantin','vacheron-constantin','Switzerland',NULL,1,'2026-03-31 02:47:23','2026-03-31 02:47:23');
CREATE TABLE IF NOT EXISTS "watches" ("id" integer primary key autoincrement not null, "brand" varchar not null, "model" varchar not null, "reference_number" varchar, "serial_number" varchar not null, "condition" varchar not null default ('pre-owned'), "description" text, "cost_price" numeric not null, "selling_price" numeric not null, "status" varchar not null default ('intake'), "photos" text, "consignor_id" integer, "listed_at" datetime, "sold_at" datetime, "created_at" datetime, "updated_at" datetime, "brand_id" integer, "image_path" varchar, "gallery" text, foreign key("consignor_id") references consignors("id") on delete set null on update no action, foreign key("brand_id") references "brands"("id") on delete set null);
INSERT INTO watches VALUES(43,'Omega','test','3243','1234','pre-owned','test',1,2,'intake',NULL,NULL,NULL,NULL,'2026-03-31 03:00:28','2026-03-31 03:00:28',2,'watches/LnzhMZfnN1aIofm7p3estdvoPbqSvBcly1HcMTvg.jpg','["watches\/gallery\/adtgNn8EyGFuVm0M61UI4axWgNY2mH6Ly8B7Stx1.jpg"]');
INSERT INTO watches VALUES(44,'Rolex','GMT-Master II "Pepsi"','16710','C0U1S0Y2X5','pre-owned',unistr('Year: 1993\u000aCase Size: 40mm\u000aInclusions: Outer Box, Inner Box, Red Tag & Papers\u000aCondition: 9.6/10\u000aComes with 2 years service warranty\u000a\u000aEvery image showcased is an original work created and owned by The Watch Reserve'),600000,788000,'listed',NULL,NULL,'2026-03-31 03:44:59',NULL,'2026-03-31 03:44:35','2026-03-31 12:20:55',1,'watches/hsHLlfAS2SBl4gFNiNWQ9B8JHjduAeUOzPzUozli.jpg','["watches\/gallery\/DSyphouYDrZhlXdbJALvffIopzGqp0z28JXOLdiT.jpg","watches\/gallery\/SvdsnRCi8spGpokM2IgAyyGPEDpo5gwlhB9Pa6j2.jpg"]');
INSERT INTO watches VALUES(45,'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, &amp; 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>',1050000,1218000,'listed',NULL,NULL,'2026-04-11 16:50:29',NULL,'2026-04-11 16:41:30','2026-04-11 17:03:09',1,'watches/7fPW9zDyXkKxopfwK211OtdIZjDoit06vp8igjKS.jpg','["watches\/gallery\/mSMaCBgIoDy8ExbpiDdPXMKZrixp6lGA1ZkbFBnX.jpg","watches\/gallery\/0gvV1w8Qrn88c4po0METqhyk9tiQVrKLEbtlIe1f.jpg","watches\/gallery\/cX67wLEd5rsArlNLf0In0tLRpBexRkIp1nkFb3tX.jpg"]');
INSERT INTO watches VALUES(46,'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, &amp; 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>',670000,695000,'listed',NULL,NULL,'2026-04-11 16:56:14',NULL,'2026-04-11 16:48:52','2026-04-11 17:02:55',1,'watches/tNAkFqVFDQPTheo78bWK5EUi778mFY309UH50OJ7.jpg','[]');
INSERT INTO watches VALUES(47,'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, &amp; 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>',315000,388000,'listed',NULL,NULL,'2026-04-11 17:02:42',NULL,'2026-04-11 17:02:38','2026-04-11 17:02:42',1,'watches/j4yu6lUN6ZGDdQ0sAWqfp8d5dvYd97WoEgNca6wj.jpg','["watches\/gallery\/Wn5Z7OsDbDGoJTHC7jD5Sg5GvVXrFypVxxtQN07w.jpg","watches\/gallery\/qGZ44qIKd4aH0i7S81vAx5cp6TVqSPMuO44TaI27.jpg","watches\/gallery\/bwrHajwHZ14yfddQ7mKPjuLSSK8oCQFpMqBNQsjE.jpg","watches\/gallery\/HxMKjyloye3xFDz7kYGzEo1UyUJiOf3zfdEfniBO.jpg"]');
INSERT INTO watches VALUES(48,'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>',750000,818000,'listed',NULL,NULL,'2026-04-11 17:18:28',NULL,'2026-04-11 17:17:53','2026-04-11 19:06:15',1,'watches/IQzexVEJwLnlCyZDl4hmA8le7cO4iCaLOQmSge0A.jpg','["watches\/gallery\/nQBO6xzSpOdO7yy0zFFqNXgLeL7HjsDCgyTE1MMO.jpg","watches\/gallery\/LuOudcaRCc8SY8AGFLCbadFfh5sGCvzfCy1PIqtG.jpg","watches\/gallery\/4lGJkqsuPuaHEFTrpgPu4LCc37NwxYdh0vKX4qyB.jpg","watches\/gallery\/8RJxzdETpLNbvYNAHChgcjAW08ykhReNVix1Pocm.jpg"]');
INSERT INTO watches VALUES(49,'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, &amp; 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>',73000,95000,'listed',NULL,NULL,'2026-04-11 19:09:34',NULL,'2026-04-11 19:09:31','2026-04-11 19:09:34',3,'watches/cHtHNPBwMCppBDwelI5AZhH2ElSlYDxNJ3MrSBO8.jpg','["watches\/gallery\/wTXs2NiGEKxgyBd2bjCOktdWcazx2bDjBOwVSpTh.jpg","watches\/gallery\/QJIIi0mJWPacxyAXAyS1XvRDOhCtiMYbkMkvMwpY.jpg","watches\/gallery\/KdfgmOVNgs48hPAHzy61y9eb7ygzgNO65WnbyIY7.jpg","watches\/gallery\/ZNyNNe74WLl0lIWs4GEMYFvljoe9RVAGKUyx6nBq.jpg"]');
INSERT INTO watches VALUES(50,'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, &amp; 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>',360000,458000,'listed',NULL,NULL,'2026-04-11 19:17:13',NULL,'2026-04-11 19:17:05','2026-04-11 19:29:23',6,'watches/7Hb7JGkWsKtDuPsWNpUqTlNKN2eCo89RqIywaD1Y.jpg','["watches\/gallery\/IGXEaQhg9KbHc5S7hJMo1ABUVgMqVUctU6jTyzSP.jpg","watches\/gallery\/P56PBa6WjroGjC76mLCJbP5Bn9VyLCRoyITBna7e.jpg","watches\/gallery\/LIBAT2qW9cudEOmZ12Tyfpa9pKmyyXKIsTjN1SND.jpg","watches\/gallery\/WLgIgunL45JUwm4azKQTjtTKz9fj12T3Bj5DEwig.jpg"]');
INSERT INTO watches VALUES(51,'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, &amp; 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>',354825,458000,'listed',NULL,NULL,'2026-04-11 19:26:37',NULL,'2026-04-11 19:25:48','2026-04-11 19:31:10',6,'watches/Qunfzd4BFBUwoNmKI01ZtoUbGNlFMAmu97q1TLSl.jpg','[]');
INSERT INTO watches VALUES(52,'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, &amp; 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>',360000,428000,'sold',NULL,NULL,NULL,'2026-04-12 17:18:17','2026-04-11 19:40:05','2026-04-12 17:18:17',6,'watches/FN7DYS1qRu0mc9JCBgq21QgMMri6pZ868fNNEr0H.jpg','["watches\/gallery\/il77uxMBsc8Kd9PdGxjQflXL7fPoAIUnJ8jXbUeb.jpg","watches\/gallery\/R4DW2K7I0NgMaGYnX7HakGc59BeOPeMrabKT29nP.jpg","watches\/gallery\/JkuoRWWrYRN5BXCBbLyzZS9Zf33L8KEBTUDCSm6c.jpg","watches\/gallery\/FpiQ8athnLj8vFL60Z99VPeTklxiGUxTTyKZjqjx.jpg"]');
INSERT INTO watches VALUES(53,'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>',230000,268000,'listed',NULL,NULL,'2026-04-12 11:46:22',NULL,'2026-04-12 11:46:06','2026-04-12 17:23:17',6,'watches/H2QIFqHJaFhoNuTAaR2hgCa3H9th8P9vm3OljvZC.jpg',NULL);
INSERT INTO watches VALUES(54,'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>',359350,428000,'listed',NULL,NULL,'2026-04-12 17:18:24',NULL,'2026-04-12 13:13:54','2026-04-12 17:18:24',1,'watches/TUHkBpnrfr78XbXpj1FzK5d1ojKbHJ8KUUZwEp8g.jpg','["watches\/gallery\/PvCw44hKAbgG9MAaKZ57R28UBNg6hvCdvsUksej3.jpg","watches\/gallery\/utsc6hcPD09DvsRuDlZiGNo6BmslvPMlTQnNwrud.jpg","watches\/gallery\/W7Do2KBLPPP9kDbnqeY5gLMe5rZhV5uyviImeCs3.jpg","watches\/gallery\/5tCuk0AfWLAMK2JDzmWmHH0rklGJ9m6OzE3rqsFL.jpg"]');
INSERT INTO watches VALUES(55,'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>',659170,998000,'listed',NULL,NULL,'2026-04-12 17:17:48',NULL,'2026-04-12 17:17:29','2026-04-12 17:22:51',5,'watches/1CZ3nCF04m1DpBQNZx4uOzTK9HXrzw6HLO0PG4R6.jpg','["watches\/gallery\/7MgoRfJTJffo9Jqev5AFTsVH9IfdMZV0LMMCvKpV.jpg","watches\/gallery\/cdnkinVJ3FvQHICKr5nYGEMpLwyoYeulgq7EnbDj.jpg","watches\/gallery\/6deL9u0WC1CN7leklkeNzjlXnHaWrKF8mYO5KlIC.jpg","watches\/gallery\/90I7s7vmwDpLtHxLCLSO1VAHDVTABdRjTrdu6Nez.jpg"]');
INSERT INTO watches VALUES(56,'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>',224365,388000,'listed',NULL,NULL,'2026-04-12 17:23:47',NULL,'2026-04-12 17:21:32','2026-04-12 17:23:47',1,'watches/0YenrqvNNpbkR6PIDyXxI4NNUf71DbKsOLu8iZ01.jpg','["watches\/gallery\/XdJ1Y67APpoA21FTVtJhHG4f5m4FNRvWwQGdMRme.jpg","watches\/gallery\/tN8B67RsEdso2uoU8QE1C6KsWJDuCvY09dnqPAUQ.jpg","watches\/gallery\/iFvotRLYN2pBYLe03vF48CBEaXvIWfJXbbLMXdWW.jpg"]');
INSERT INTO watches VALUES(57,'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>',900000,968000,'listed',NULL,NULL,'2026-04-13 14:21:33',NULL,'2026-04-13 14:21:26','2026-04-13 14:21:33',5,'watches/FRvtZWPwntg4rfi5JTZfWmbJ1lNRgvs3CDfPjU6P.jpg','["watches\/gallery\/Og3sfoDP6aLH8iUWoE8nhijG6MSfDQMWSzaUC1lY.jpg","watches\/gallery\/GjQ6uvPsT6l8NTjRMAbWZZ4Xqeuny1BiEuLY9jZg.jpg","watches\/gallery\/HuXyaQzGKeZh6jReZh9fc5pdsKdpsojHNmmme4Bk.jpg","watches\/gallery\/b0Z71xtm1GAGWbiaRUXzWRpuLUrN0nSasYM6VH0u.jpg"]');
INSERT INTO watches VALUES(58,'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>',792730,998000,'listed',NULL,NULL,'2026-04-13 14:24:50',NULL,'2026-04-13 14:24:35','2026-04-13 15:40:18',1,'watches/mmf4Y6sriiRoeyIU0jJnV34JHexazfK2BqiSSjfV.jpg','["watches\/gallery\/nXNwE403Zh4cSjukEm81WJ3p6p10CvuvEpl91Ief.jpg","watches\/gallery\/GHv9Ixtjt82kj74JfTpuA2sMbpATDJafvLT27hk1.jpg","watches\/gallery\/Im9FjjOj8PtzKJDLYnTItNALXnnxtpCJPECCWYVd.jpg"]');
INSERT INTO watches VALUES(59,'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>',640000,758000,'listed',NULL,NULL,'2026-04-13 15:38:55',NULL,'2026-04-13 15:38:49','2026-04-13 15:38:55',1,'watches/5Ipj6DD72aVj9nfZBTkgMJdYAgSTcHpaYkmkAaTJ.jpg',NULL);
INSERT INTO watches VALUES(60,'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>',755000,908000,'sold',NULL,NULL,'2026-04-13 15:42:34','2026-04-16 18:00:24','2026-04-13 15:42:25','2026-04-16 18:00:24',1,'watches/5OfB2CeGpMX2Zht6SCPov7Ox9wUnm5AMF1PeEYNC.jpg','["watches\/gallery\/unX6q7skHkeMjErKh13RhD672XuwrusAZW5aNsUz.jpg","watches\/gallery\/8Oh3yJFYr89NV26f6hdfBmkLBCW6FtbOawOx8oHR.jpg","watches\/gallery\/p1GAbm1rpYQulS9yqk6eBTT24sx7qGC4L8Oa9HCm.jpg"]');
CREATE TABLE IF NOT EXISTS "reservations" ("id" integer primary key autoincrement not null, "watch_id" integer not null, "customer_id" integer not null, "staff_id" integer, "deposit_amount" numeric not null default '0', "deadline" date not null, "status" varchar not null default 'active', "notes" text, "extensions" integer not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("watch_id") references "watches"("id") on delete cascade, foreign key("customer_id") references "customers"("id") on delete cascade, foreign key("staff_id") references "users"("id") on delete set null);
CREATE TABLE IF NOT EXISTS "transactions" ("id" integer primary key autoincrement not null, "invoice_number" varchar not null, "watch_id" integer not null, "customer_id" integer, "staff_id" integer not null, "type" varchar not null default 'sale', "payment_method" varchar not null, "amount" numeric not null, "tax_amount" numeric not null default '0', "discount_amount" numeric not null default '0', "total_amount" numeric not null, "profit" numeric not null default '0', "notes" text, "sold_at" datetime not null, "created_at" datetime, "updated_at" datetime, "payment_details" text, "document_path" varchar, foreign key("watch_id") references "watches"("id") on delete cascade, foreign key("customer_id") references "customers"("id") on delete set null, foreign key("staff_id") references "users"("id") on delete cascade);
INSERT INTO transactions VALUES(17,'TWR-20260416-0001',60,NULL,9,'sale','cash',908000,0,8000,900000,145000,'','2026-04-16 18:00:24','2026-04-16 18:00:24','2026-04-16 18:00:24',NULL,NULL);
CREATE TABLE IF NOT EXISTS "attendances" ("id" integer primary key autoincrement not null, "user_id" integer not null, "date" date not null, "check_in" time, "check_out" time, "status" varchar not null default 'present', "late_minutes" integer not null default '0', "undertime_minutes" integer not null default '0', "notes" text, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade);
INSERT INTO attendances VALUES(1,8,'2026-03-28 00:00:00','10:39:49','10:42:23','present',0,0,NULL,'2026-03-28 10:39:49','2026-03-28 10:42:23');
INSERT INTO attendances VALUES(2,9,'2026-03-31 00:00:00','04:09:26','04:09:29','present',0,0,NULL,'2026-03-31 04:09:26','2026-03-31 04:09:29');
INSERT INTO attendances VALUES(3,13,'2026-04-08 00:00:00','13:41:01','19:13:11','present',0,0,NULL,'2026-04-08 13:41:01','2026-04-08 19:13:11');
INSERT INTO attendances VALUES(4,14,'2026-04-11 00:00:00','11:26:07',NULL,'present',0,0,NULL,'2026-04-11 11:26:07','2026-04-11 11:26:07');
INSERT INTO attendances VALUES(5,6,'2026-04-13 00:00:00','15:37:12',NULL,'present',0,0,NULL,'2026-04-13 15:37:12','2026-04-13 15:37:12');
CREATE TABLE IF NOT EXISTS "leave_types" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "description" text, "is_paid" tinyint(1) not null default '1', "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime);
INSERT INTO leave_types VALUES(1,'Sick Leave','SL',NULL,1,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO leave_types VALUES(2,'Vacation Leave','VL',NULL,1,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO leave_types VALUES(3,'Personal Leave','PL',NULL,0,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO leave_types VALUES(4,'Emergency Leave','EL',NULL,1,1,'2026-03-23 05:43:15','2026-03-23 05:43:15');
CREATE TABLE IF NOT EXISTS "leave_settings" ("id" integer primary key autoincrement not null, "leave_type_id" integer not null, "accrual_rate" numeric not null default '0', "accrual_period" varchar not null default 'monthly', "max_balance" numeric not null default '0', "carry_over" tinyint(1) not null default '0', "max_carry_over" numeric not null default '0', "probation_months" integer not null default '0', "reset_cycle" varchar not null default 'annual', "created_at" datetime, "updated_at" datetime, foreign key("leave_type_id") references "leave_types"("id") on delete cascade);
INSERT INTO leave_settings VALUES(1,1,1.25,'monthly',15,0,0,3,'annual','2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO leave_settings VALUES(2,2,1.25,'monthly',15,0,0,3,'annual','2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO leave_settings VALUES(3,3,0,'monthly',5,0,0,3,'annual','2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO leave_settings VALUES(4,4,0,'monthly',3,0,0,3,'annual','2026-03-23 05:43:15','2026-03-23 05:43:15');
CREATE TABLE IF NOT EXISTS "leave_balances" ("id" integer primary key autoincrement not null, "user_id" integer not null, "leave_type_id" integer not null, "balance" numeric not null default '0', "accrued" numeric not null default '0', "used" numeric not null default '0', "year" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("leave_type_id") references "leave_types"("id") on delete cascade);
CREATE TABLE IF NOT EXISTS "leaves" ("id" integer primary key autoincrement not null, "user_id" integer not null, "leave_type_id" integer not null, "start_date" date not null, "end_date" date not null, "days" numeric not null, "status" varchar not null default 'pending', "reason" text, "approved_by" integer, "approved_at" datetime, "rejection_reason" text, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("leave_type_id") references "leave_types"("id") on delete cascade, foreign key("approved_by") references "users"("id") on delete set null);
CREATE TABLE IF NOT EXISTS "settings" ("id" integer primary key autoincrement not null, "key" varchar not null, "value" text, "type" varchar not null default 'string', "group" varchar not null default 'general', "description" text, "created_at" datetime, "updated_at" datetime);
INSERT INTO settings VALUES(1,'business_name','The Watch Reserve','string','general',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(2,'currency','PHP','string','general',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(3,'tax_enabled','false','boolean','tax',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(4,'tax_rate','12','float','tax',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(5,'tax_label','VAT','string','tax',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(6,'aging_caution_days','15','integer','aging',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(7,'aging_warning_days','30','integer','aging',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(8,'aging_danger_days','45','integer','aging',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(9,'aging_critical_days','46','integer','aging',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(10,'default_reservation_days','7','integer','reservation',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(11,'work_start_time','09:00','string','hr',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(12,'work_end_time','18:00','string','hr',NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO settings VALUES(13,'site_logo','cms/branding/logo-1774249551.png','string','branding',NULL,'2026-03-23 07:05:51','2026-03-23 07:05:51');
INSERT INTO settings VALUES(14,'terms_conditions',unistr('All watch sales and trades at The Watch Reserve are final and cannot be changed, canceled, or\u000arefunded once completed. Watches offered for trade must be authentic and accurately described;\u000awe reserve the right to inspect and decline any transaction if authenticity or condition is in\u000aquestion. Ownership and risk pass to the buyer upon payment or handover.\u000a\u000aThe Watch Reserve sells all watches in good faith, representing that they have been lawfully\u000aacquired and are not reported lost or stolen to the best of our knowledge. By completing a sale or\u000atrade, you agree to release, waive, and discharge The Watch Reserve, its owners, and staff from any\u000aliability, claims, or disputes arising from or related to the transaction, including loss, damage,\u000adefects, or other issues, to the fullest extent permitted by law.'),'string','general',NULL,'2026-03-31 12:37:16','2026-03-31 13:56:43');
INSERT INTO settings VALUES(15,'order_process','','string','general',NULL,'2026-03-31 12:37:16','2026-03-31 14:03:08');
INSERT INTO settings VALUES(16,'service_warranty',unistr('Comprehensive Service Warranty for Timepieces\u000a\u000aWe 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.\u000a\u000aWarranty Coverage\u000aThis 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 12:37:16','2026-03-31 14:03:08');
INSERT INTO settings VALUES(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 12:37:16','2026-03-31 14:03:08');
CREATE TABLE IF NOT EXISTS "consignment_requests" ("id" integer primary key autoincrement not null, "name" varchar not null, "mobile" varchar not null, "email" varchar not null, "item_type" varchar not null default 'consignment', "vlog_documentation" varchar not null default 'without_vlog', "brand" varchar, "model" varchar, "year" varchar, "dial_size" varchar, "material" varchar, "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, "photos" text, "status" varchar not null default 'pending', "reviewed_by" integer, "reviewed_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("reviewed_by") references "users"("id") on delete set null);
INSERT INTO consignment_requests VALUES(1,'Test','+6398765432198','test@gmail.com','consignment','without_vlog','Test','Test','2000','40mm','Test',0,0,0,0,NULL,NULL,'accepted',1,'2026-03-23 15:30:53','2026-03-23 15:08:48','2026-03-23 15:30:53');
INSERT INTO consignment_requests VALUES(2,'Test again','+6398745621547','testagain@gmail.com','for_sale','without_vlog','Test','Test','2001','39mm','Test',1,1,1,1,'Test',NULL,'pending',NULL,NULL,'2026-03-23 15:59:33','2026-03-23 15:59:33');
INSERT INTO consignment_requests VALUES(3,'Hello','09876543212','hello@gmail.com','consignment','without_vlog','Test','Test','1999','35mm','Test',1,0,1,0,'Test',NULL,'pending',NULL,NULL,'2026-03-23 17:05:13','2026-03-23 17:05:13');
INSERT INTO consignment_requests VALUES(4,'Hi','09876543213','hi@gmail.com','for_sale','without_vlog','Test','Test','1998','39mm',NULL,0,1,0,1,'Test',NULL,'pending',NULL,NULL,'2026-03-23 17:06:51','2026-03-23 17:06:51');
INSERT INTO consignment_requests VALUES(5,'Beata Lopez','09174948419','beatadlopez@gmail.com','consignment','without_vlog','Rolex','114060','2012','Philippines','Steel',1,0,1,1,'Scratch on glass',NULL,'pending',NULL,NULL,'2026-03-24 14:50:47','2026-03-24 14:50:47');
INSERT INTO consignment_requests VALUES(6,'Karyll','+6398745632154','karylltest@gmail.com','consignment','without_vlog','Test','Test','1999','40mm','Platinum',1,1,1,1,'For testing only.',NULL,'pending',NULL,NULL,'2026-03-28 06:43:05','2026-03-28 06:43:05');
INSERT INTO consignment_requests VALUES(7,'Jerome Torres','+639189360418','jerometorres1982@gmail.com','consignment','without_vlog','Rolex','Datejust Palm Leaf Green Dial','2022','36mm',NULL,1,0,0,1,NULL,NULL,'pending',NULL,NULL,'2026-04-03 23:46:23','2026-04-03 23:46:23');
INSERT INTO consignment_requests VALUES(8,'Miguel Bustamante','09177026903','Syrculus@gmail.com','consignment','without_vlog','Rolex','GMT-Master ll','2015','40','All Steel',1,1,1,1,NULL,NULL,'accepted',9,'2026-04-07 13:03:47','2026-04-07 13:03:13','2026-04-07 13:03:47');
INSERT INTO consignment_requests VALUES(9,'charles','+639085819330','badjingersz@gmail.com','consignment','without_vlog','test','test','test','40mm','test',0,1,0,0,NULL,NULL,'pending',NULL,NULL,'2026-04-07 14:00:03','2026-04-07 14:00:03');
INSERT INTO consignment_requests VALUES(10,'Miguel','09177026903','Syrculus@gmail.com','consignment','without_vlog','Rolex','Submariner','2017','41','Steel',1,0,0,0,'Test',NULL,'pending',NULL,NULL,'2026-04-07 15:47:41','2026-04-07 15:47:41');
CREATE TABLE IF NOT EXISTS "hero_sections" ("id" integer primary key autoincrement not null, "title" varchar not null, "subtitle" text, "cta_text" varchar, "cta_link" varchar, "cta2_text" varchar, "cta2_link" varchar, "media_type" varchar not null default 'image', "media_path" varchar, "media_url" varchar, "overlay_opacity" integer not null default '60', "is_active" tinyint(1) not null default '0', "sort_order" integer not null default '0', "created_at" datetime, "updated_at" datetime, "title_size" integer not null default '100', "subtitle_size" integer not null default '100');
INSERT INTO hero_sections VALUES(1,'Timeless Luxury','The Watch Reserve','View Collection','/collection','Sell Your Watch','/consign','video','cms/heroes/hero-1773369171.mp4',NULL,70,1,0,'2026-03-23 06:56:51','2026-03-23 06:56:51',90,130);
CREATE TABLE IF NOT EXISTS "marquee_sections" ("id" integer primary key autoincrement not null, "title" varchar, "subtitle" text, "cta_text" varchar, "cta_link" varchar, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "heading" varchar, "step1_title" varchar, "step1_desc" text, "step2_title" varchar, "step2_desc" text, "step3_title" varchar, "step3_desc" text, "image_path" varchar);
INSERT INTO marquee_sections VALUES(1,'Watches inspired from the past, made for today.','Explore Now','Get Your Estimate','/consign',1,'2026-03-23 06:56:59','2026-03-24 07:10:58','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');
CREATE TABLE IF NOT EXISTS "marquee_images" ("id" integer primary key autoincrement not null, "marquee_section_id" integer not null, "image_path" varchar not null, "watch_id" integer, "alt_text" varchar, "sort_order" integer not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("marquee_section_id") references "marquee_sections"("id") on delete cascade, foreign key("watch_id") references "watches"("id") on delete set null);
INSERT INTO marquee_images VALUES(1,1,'cms/marquee/marquee-1773373633-69b388c16bf4d.webp',NULL,NULL,1,'2026-03-23 06:57:03','2026-03-23 06:57:03');
INSERT INTO marquee_images VALUES(2,1,'cms/marquee/marquee-1773373633-69b388c16d11d.webp',NULL,NULL,2,'2026-03-23 06:57:03','2026-03-23 06:57:03');
INSERT INTO marquee_images VALUES(3,1,'cms/marquee/marquee-1773373633-69b388c16dbc0.webp',NULL,NULL,3,'2026-03-23 06:57:03','2026-03-23 06:57:03');
INSERT INTO marquee_images VALUES(4,1,'cms/marquee/marquee-1773373633-69b388c1715cb.webp',NULL,NULL,4,'2026-03-23 06:57:03','2026-03-23 06:57:03');
INSERT INTO marquee_images VALUES(5,1,'cms/marquee/marquee-1773373633-69b388c1739bb.webp',NULL,NULL,5,'2026-03-23 06:57:03','2026-03-23 06:57:03');
CREATE TABLE IF NOT EXISTS "appointment_sections" ("id" integer primary key autoincrement not null, "label" varchar, "heading" varchar, "address" text, "cta_text" varchar, "cta_link" varchar, "cta2_text" varchar, "cta2_link" varchar, "media_path" varchar, "media_url" varchar, "overlay_opacity" integer not null default '30', "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "section_heading" varchar, "article1_title" varchar, "article1_slug" varchar, "article1_image" varchar, "article2_title" varchar, "article2_slug" varchar, "article2_image" varchar);
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,'2026-03-23 07:06:25','2026-03-28 07:50:55','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');
CREATE TABLE IF NOT EXISTS "instagram_sections" ("id" integer primary key autoincrement not null, "heading" varchar, "instagram_handle" varchar, "profile_url" varchar, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime);
INSERT INTO instagram_sections VALUES(1,'Follow Us On Instagram','@thewatchreserve.ph',NULL,1,'2026-03-23 06:57:07','2026-03-28 07:53:28');
CREATE TABLE IF NOT EXISTS "instagram_posts" ("id" integer primary key autoincrement not null, "instagram_section_id" integer not null, "image_path" varchar not null, "post_url" varchar, "caption" text, "sort_order" integer not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("instagram_section_id") references "instagram_sections"("id") on delete cascade);
CREATE TABLE IF NOT EXISTS "history_pages" ("id" integer primary key autoincrement not null, "hero_year" varchar default 'EST. 1922', "hero_title" varchar default 'A Legacy in Seconds', "hero_text" text, "hero_image" varchar, "mission_title" varchar default 'Our Mission: The Preservation of Craft', "mission_text" text, "mission_quote" text, "mission_image" varchar, "founders_subtitle" varchar default 'THE VISIONARIES', "founders_title" varchar default 'The Founders'' Story', "founders_text" text, "founders_image" varchar, "perfection_col1_title" varchar default 'PROVENANCE', "perfection_col1_text" text, "perfection_col1_image" varchar, "perfection_col2_title" varchar default 'RESTORATION', "perfection_col2_text" text, "perfection_col2_image" varchar, "perfection_col3_title" varchar default 'CURATION', "perfection_col3_text" text, "perfection_col3_image" varchar, "created_at" datetime, "updated_at" datetime);
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-23 06:12:59','2026-03-23 07:18:18');
INSERT INTO history_pages VALUES(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-23 06:56:55','2026-03-23 06:56:55');
CREATE TABLE IF NOT EXISTS "personal_access_tokens" ("id" integer primary key autoincrement not null, "tokenable_type" varchar not null, "tokenable_id" integer not null, "name" text not null, "token" varchar not null, "abilities" text, "last_used_at" datetime, "expires_at" datetime, "created_at" datetime, "updated_at" datetime);
INSERT INTO personal_access_tokens VALUES(4,'App\Models\Customer',9,'customer-token','[REDACTED]','["*"]','2026-03-24 14:43:06',NULL,'2026-03-24 14:42:36','2026-03-24 14:43:06');
INSERT INTO personal_access_tokens VALUES(5,'App\Models\Customer',10,'customer-token','[REDACTED]','["*"]','2026-03-28 04:18:29',NULL,'2026-03-28 04:18:20','2026-03-28 04:18:29');
CREATE TABLE IF NOT EXISTS "newsletter_subscribers" ("id" integer primary key autoincrement not null, "email" varchar not null, "source" varchar not null default 'footer', "ip_address" varchar, "created_at" datetime, "updated_at" datetime);
INSERT INTO newsletter_subscribers VALUES(1,'dvapp.charles@gmail.com','registration','2001:fd8:d027:9f00:c1d:3d01:cebd:a777','2026-03-28 04:18:20','2026-03-28 04:18:20');
INSERT INTO newsletter_subscribers VALUES(2,'karylltest@gmail.com','history_page','2001:4451:136e:2300:6d64:95a:77de:e7fb','2026-03-28 07:37:05','2026-03-28 07:37:05');
INSERT INTO newsletter_subscribers VALUES(3,'test@gmail.com','history_page','2001:4451:136e:2300:6d64:95a:77de:e7fb','2026-03-28 07:45:15','2026-03-28 07:45:15');
CREATE TABLE IF NOT EXISTS "services_pages" ("id" integer primary key autoincrement not null, "hero_image" varchar, "servicing_image" varchar, "preservation_col1_image" varchar, "preservation_col2_image" varchar, "preservation_col3_image" varchar, "cta_image" varchar, "created_at" datetime, "updated_at" datetime);
INSERT INTO services_pages VALUES(1,'cms/services/3SPnqR0pUPp5RaUpWg406mTuM8fQK4BicGq8aQJP.png','cms/services/bLanqJxpsc69fKcbvWFU4B6yRXnyDWc9IRr71n5j.png',NULL,NULL,NULL,'cms/services/NvmK58CYcqPFTPVn95XfAjO57C28hcgksWpAumSj.png','2026-03-25 12:26:10','2026-03-25 12:57:13');
CREATE TABLE IF NOT EXISTS "valuation_bookings" ("id" integer primary key autoincrement not null, "first_name" varchar not null, "last_name" varchar not null, "email" varchar not null, "phone" varchar, "booking_date" date not null, "booking_time" varchar not null, "status" varchar not null default 'pending', "admin_notes" text, "created_at" datetime, "updated_at" datetime);
INSERT INTO valuation_bookings VALUES(1,'John','Doe','johndoe@gmail.com','+6398745632152','2026-03-31 00:00:00','7:00 PM','pending',NULL,'2026-03-27 10:01:06','2026-03-27 10:01:06');
INSERT INTO valuation_bookings VALUES(2,'charlesedward','cabling','dvapp.charles@gmail.com','+639085819330','2026-03-30 00:00:00','11:30 AM','approved',NULL,'2026-03-28 04:21:42','2026-03-28 04:23:16');
INSERT INTO valuation_bookings VALUES(3,'Juan','Dela Cruz','juandelacruz@gmail.com','+6398745625145','2026-03-31 00:00:00','2:30 PM','approved',unistr('for testing\u000a'),'2026-03-28 05:33:10','2026-03-28 06:38:24');
INSERT INTO valuation_bookings VALUES(4,'Jane','Smith','test@gmail.com','+63987456321025','2026-03-31 00:00:00','5:30 PM','pending',NULL,'2026-03-28 06:37:00','2026-03-28 06:37:00');
INSERT INTO valuation_bookings VALUES(5,'Karyll','Test','karylltest@gmail.com','+6398745612357','2026-03-31 00:00:00','7:00 PM','approved',unistr('hello\u000a'),'2026-03-28 06:39:34','2026-03-28 07:42:00');
INSERT INTO valuation_bookings VALUES(6,'Tala','Test','mallaricassie13@gmail.com','09453944179','2026-03-30 00:00:00','1:00 PM','rejected',NULL,'2026-03-28 09:11:25','2026-03-31 13:50:54');
CREATE TABLE IF NOT EXISTS "shifts" ("id" integer primary key autoincrement not null, "user_id" integer not null, "date" date not null, "start_time" time not null, "end_time" time not null, "type" varchar check ("type" in ('morning', 'mid', 'closing', 'custom', 'day_off')) not null default 'morning', "notes" varchar, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("created_by") references "users"("id") on delete set null);
INSERT INTO shifts VALUES(1,3,'2026-03-01 00:00:00','09:00','17:00','morning',NULL,1,'2026-03-27 05:11:55','2026-03-27 05:11:55');
CREATE TABLE IF NOT EXISTS "service_requests" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "phone" varchar, "service_type" varchar not null, "sub_service_type" varchar, "status" varchar not null default 'Pending Approval', "created_at" datetime, "updated_at" datetime);
INSERT INTO service_requests VALUES(1,'Miguel Bustamante','Syrculus@gmail.com','09177026903','Servicing',NULL,'Pending Approval','2026-04-07 12:58:59','2026-04-07 12:58:59');
CREATE TABLE IF NOT EXISTS "consignors" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar, "phone" varchar, "address" text, "default_commission_rate" numeric not null, "is_active" tinyint(1) not null default ('1'), "notes" text, "created_at" datetime, "updated_at" datetime);
INSERT INTO consignors VALUES(1,'Luxury Watch Trading Co.','info@luxwatch.ph','+63 917 123 4567',NULL,15,1,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO consignors VALUES(2,'Premium Timepieces Manila','sales@premiumtime.ph','+63 918 234 5678',NULL,18,1,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO consignors VALUES(3,'Elite Watch Gallery','hello@elitewatch.ph','+63 919 345 6789',NULL,20,1,NULL,'2026-03-23 05:43:15','2026-03-23 05:43:15');
INSERT INTO consignors VALUES(4,'Test','test@gmail.com','09874563215634','test',15,1,'test','2026-03-28 06:34:38','2026-03-28 06:34:38');
CREATE TABLE IF NOT EXISTS "consignments" ("id" integer primary key autoincrement not null, "consignor_id" integer not null, "watch_id" integer not null, "intake_date" date not null, "agreed_price" numeric not null, "commission_rate" numeric not null, "status" varchar not null default ('active'), "settlement_date" date, "settlement_amount" numeric, "notes" text, "created_at" datetime, "updated_at" datetime, foreign key("watch_id") references watches("id") on delete cascade on update no action, foreign key("consignor_id") references consignors("id") on delete cascade on update no action);
CREATE TABLE IF NOT EXISTS "inquiries" ("id" integer primary key autoincrement not null, "watch_id" integer not null, "name" varchar not null, "email" varchar not null, "phone" varchar, "message" text, "status" varchar not null default ('new'), "replied_at" datetime, "replied_by" integer, "created_at" datetime, "updated_at" datetime, "preferred_contact" varchar, foreign key("replied_by") references users("id") on delete set null on update no action, foreign key("watch_id") references watches("id") on delete cascade on update no action);
INSERT INTO inquiries VALUES(10,44,'charles edward','bad@gmail.com','+6390895819343','test','new',NULL,NULL,'2026-04-07 13:14:42','2026-04-07 13:14:42',NULL);
INSERT INTO inquiries VALUES(11,44,'Charles Edward C','ahsidjnjkf@gmail.com','+639084353453','test','new',NULL,NULL,'2026-04-07 13:15:19','2026-04-07 13:15:19',NULL);
INSERT INTO inquiries VALUES(12,44,'Charles Edward','snjkdfsdnfjk@gmail.com','+639034534534','test','new',NULL,NULL,'2026-04-07 13:59:01','2026-04-07 13:59:01','email');
INSERT INTO inquiries VALUES(13,44,'test user','test@example.com','123456','Test inquiry','new',NULL,NULL,'2026-04-07 14:04:13','2026-04-07 14:04:13','email');
INSERT INTO inquiries VALUES(14,44,'test user','test@example.com','123456','Test inquiry','new',NULL,NULL,'2026-04-07 14:04:52','2026-04-07 14:04:52','email');
INSERT INTO inquiries VALUES(15,44,'test user','test@example.com','123456','Test inquiry','new',NULL,NULL,'2026-04-07 14:05:42','2026-04-07 14:05:42',NULL);
INSERT INTO inquiries VALUES(16,44,'test user','test@example.com','123456','Test inquiry','new',NULL,NULL,'2026-04-07 14:06:59','2026-04-07 14:06:59','email');
INSERT INTO inquiries VALUES(17,44,'test user','test@example.com','123456','Test inquiry','new',NULL,NULL,'2026-04-07 14:07:46','2026-04-07 14:07:46',NULL);
INSERT INTO inquiries VALUES(18,44,'Edward Charles','dvapp.charles@gmail.com','+6390435345435',NULL,'replied','2026-04-07 14:16:10',1,'2026-04-07 14:12:27','2026-04-07 14:16:10','email');
INSERT INTO sqlite_sequence VALUES('migrations',37);
INSERT INTO sqlite_sequence VALUES('roles',5);
INSERT INTO sqlite_sequence VALUES('users',14);
INSERT INTO sqlite_sequence VALUES('settings',17);
INSERT INTO sqlite_sequence VALUES('leave_types',4);
INSERT INTO sqlite_sequence VALUES('leave_settings',4);
INSERT INTO sqlite_sequence VALUES('brands',8);
INSERT INTO sqlite_sequence VALUES('customers',11);
INSERT INTO sqlite_sequence VALUES('transactions',17);
INSERT INTO sqlite_sequence VALUES('history_pages',2);
INSERT INTO sqlite_sequence VALUES('watches',60);
INSERT INTO sqlite_sequence VALUES('hero_sections',1);
INSERT INTO sqlite_sequence VALUES('marquee_sections',1);
INSERT INTO sqlite_sequence VALUES('marquee_images',5);
INSERT INTO sqlite_sequence VALUES('instagram_sections',1);
INSERT INTO sqlite_sequence VALUES('appointment_sections',1);
INSERT INTO sqlite_sequence VALUES('consignment_requests',10);
INSERT INTO sqlite_sequence VALUES('reservations',2);
INSERT INTO sqlite_sequence VALUES('personal_access_tokens',5);
INSERT INTO sqlite_sequence VALUES('services_pages',1);
INSERT INTO sqlite_sequence VALUES('permissions',10);
INSERT INTO sqlite_sequence VALUES('shifts',1);
INSERT INTO sqlite_sequence VALUES('valuation_bookings',6);
INSERT INTO sqlite_sequence VALUES('newsletter_subscribers',3);
INSERT INTO sqlite_sequence VALUES('attendances',5);
INSERT INTO sqlite_sequence VALUES('consignors',4);
INSERT INTO sqlite_sequence VALUES('consignments',0);
INSERT INTO sqlite_sequence VALUES('service_requests',1);
INSERT INTO sqlite_sequence VALUES('inquiries',18);
CREATE UNIQUE INDEX "users_email_unique" on "users" ("email");
CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id");
CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity");
CREATE INDEX "cache_expiration_index" on "cache" ("expiration");
CREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration");
CREATE INDEX "jobs_queue_reserved_at_available_at_index" on "jobs" ("queue", "reserved_at", "available_at");
CREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid");
CREATE UNIQUE INDEX "permissions_name_guard_name_unique" on "permissions" ("name", "guard_name");
CREATE UNIQUE INDEX "roles_name_guard_name_unique" on "roles" ("name", "guard_name");
CREATE INDEX "model_has_permissions_model_id_model_type_index" on "model_has_permissions" ("model_id", "model_type");
CREATE INDEX "model_has_roles_model_id_model_type_index" on "model_has_roles" ("model_id", "model_type");
CREATE UNIQUE INDEX "brands_name_unique" on "brands" ("name");
CREATE UNIQUE INDEX "brands_slug_unique" on "brands" ("slug");
CREATE INDEX "watches_brand_index" on "watches" ("brand");
CREATE UNIQUE INDEX "watches_serial_number_unique" on "watches" ("serial_number");
CREATE INDEX "watches_status_index" on "watches" ("status");
CREATE INDEX "reservations_status_index" on "reservations" ("status");
CREATE INDEX "reservations_deadline_index" on "reservations" ("deadline");
CREATE INDEX "transactions_type_index" on "transactions" ("type");
CREATE INDEX "transactions_sold_at_index" on "transactions" ("sold_at");
CREATE INDEX "transactions_staff_id_index" on "transactions" ("staff_id");
CREATE UNIQUE INDEX "transactions_invoice_number_unique" on "transactions" ("invoice_number");
CREATE UNIQUE INDEX "attendances_user_id_date_unique" on "attendances" ("user_id", "date");
CREATE INDEX "attendances_date_index" on "attendances" ("date");
CREATE UNIQUE INDEX "leave_types_code_unique" on "leave_types" ("code");
CREATE UNIQUE INDEX "leave_balances_user_id_leave_type_id_year_unique" on "leave_balances" ("user_id", "leave_type_id", "year");
CREATE INDEX "leaves_status_index" on "leaves" ("status");
CREATE UNIQUE INDEX "settings_key_unique" on "settings" ("key");
CREATE INDEX "consignment_requests_status_index" on "consignment_requests" ("status");
CREATE INDEX "personal_access_tokens_tokenable_type_tokenable_id_index" on "personal_access_tokens" ("tokenable_type", "tokenable_id");
CREATE UNIQUE INDEX "personal_access_tokens_token_unique" on "personal_access_tokens" ("token");
CREATE INDEX "personal_access_tokens_expires_at_index" on "personal_access_tokens" ("expires_at");
CREATE UNIQUE INDEX "newsletter_subscribers_email_unique" on "newsletter_subscribers" ("email");
CREATE UNIQUE INDEX "shifts_user_id_date_unique" on "shifts" ("user_id", "date");
CREATE INDEX "consignments_intake_date_index" on "consignments" ("intake_date");
CREATE INDEX "consignments_status_index" on "consignments" ("status");
CREATE INDEX "inquiries_status_index" on "inquiries" ("status");
COMMIT;
