-- -------------------------------------------------------------
-- TablePlus 6.2.1(578)
--
-- https://tableplus.com/
--
-- Database: laravel_11
-- -------------------------------------------------------------



CREATE TABLE `cat_tbl` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delstat` char(2) DEFAULT '0' COMMENT '0= published, 1= deleted',
  `mtitle` varchar(200) DEFAULT NULL,
  `mdes` varchar(222) DEFAULT NULL,
  `mkey` varchar(222) DEFAULT NULL,
  `category` varchar(50) NOT NULL DEFAULT '',
  `category_label` varchar(50) DEFAULT '0',
  `r_category` varchar(50) DEFAULT 'none',
  `pic_thumb` varchar(100) DEFAULT NULL,
  `pic_banner` varchar(100) DEFAULT NULL,
  `details` tinytext,
  `others` tinytext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category` (`category`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

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;

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;

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_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `main_tbl` (
  `id` int NOT NULL AUTO_INCREMENT,
  `r_cat` varchar(55) NOT NULL DEFAULT '',
  `cat` varchar(50) DEFAULT NULL,
  `pname` varchar(100) NOT NULL DEFAULT '',
  `supplier` varchar(50) DEFAULT NULL,
  `code` varchar(20) NOT NULL DEFAULT '',
  `pubprv` int DEFAULT '0' COMMENT 'for future seperation public and privilidged',
  `status` int DEFAULT '0',
  `carat` char(3) DEFAULT '22' COMMENT 'differenciate  purity of product',
  `showdel` int DEFAULT '0' COMMENT '0=show,1=deleted, 2, unpublished',
  `col_temp` int DEFAULT '1',
  `mtitle` varchar(222) DEFAULT NULL,
  `mkey` longtext,
  `mdes` longtext,
  `pic_small` varchar(50) DEFAULT NULL,
  `pic_big` varchar(50) DEFAULT NULL,
  `pic_XL` varchar(111) DEFAULT '../ images/ noImage. jpg',
  `details` longtext,
  `size_details` longtext,
  `size_met` varchar(25) DEFAULT 'na',
  `size_max` decimal(5,2) DEFAULT '0.00',
  `size_met2` varchar(25) DEFAULT 'na',
  `size_max2` decimal(5,2) DEFAULT '0.00',
  `price` decimal(8,1) DEFAULT NULL,
  `make_ch` decimal(8,0) NOT NULL DEFAULT '0',
  `usd` decimal(9,0) NOT NULL DEFAULT '0',
  `make_cc` varchar(8) DEFAULT NULL,
  `precious` varchar(55) NOT NULL DEFAULT '0',
  `markup` varchar(22) DEFAULT '33',
  `stock` varchar(55) DEFAULT '0',
  `hitCount` decimal(10,0) DEFAULT '50',
  `comments` longtext,
  `billCom` longtext,
  `others` longtext,
  `m_cat` tinytext COMMENT 'multi C: s_cat val seperated by ,\n',
  `m_col` tinytext COMMENT 'added for multipe collection Jan 11 09',
  `timeS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `timeSfirst` datetime DEFAULT '2007-11-13 13:19:02',
  PRIMARY KEY (`id`),
  KEY `id_code_pname_usd` (`id`,`code`,`pname`,`usd`),
  KEY `major_fields` (`id`,`cat`,`pname`,`code`,`pic_XL`,`price`,`make_ch`,`usd`,`make_cc`,`precious`,`markup`,`stock`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `r_cat_tbl` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delstat` char(2) DEFAULT '0' COMMENT '0= published, 1= deleted',
  `mtitle` varchar(200) DEFAULT NULL,
  `mdes` varchar(222) DEFAULT NULL,
  `mkey` varchar(222) DEFAULT NULL,
  `r_category` varchar(30) NOT NULL,
  `r_cat_label` varchar(88) DEFAULT NULL,
  `srt` varchar(2) DEFAULT '1',
  `pic_banner` varchar(100) DEFAULT NULL,
  `details` tinytext,
  `others` tinytext,
  PRIMARY KEY (`id`),
  UNIQUE KEY `r_category` (`r_category`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

CREATE TABLE `s_cart_db` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(55) NOT NULL DEFAULT '',
  `dtOrd` varchar(55) NOT NULL DEFAULT '',
  `avW` decimal(5,1) DEFAULT NULL,
  `gRate` decimal(4,2) DEFAULT NULL,
  `subTotal` decimal(8,2) DEFAULT NULL,
  `shi` decimal(8,2) DEFAULT NULL,
  `tax` decimal(8,2) DEFAULT NULL,
  `grandTotal` decimal(8,2) DEFAULT NULL,
  `cc4dg` varchar(25) DEFAULT NULL,
  `status` varchar(5) NOT NULL COMMENT '0 ord rec, 1= under rev, 1.5 chk. pay.pend. 1.6 = spec. org.accep., 2= processed, 2.5=spec. ord. proc., 2.9 =sch Dispatch,  3 = dispatched, 4 = delivered, 5 = void, 6= internal\n',
  `ship_add` varchar(222) DEFAULT NULL,
  `ch_log` varchar(250) NOT NULL DEFAULT '',
  `comments` text,
  `comment_customers` text COMMENT 'customers comments',
  `p_comments` text,
  `p_comments_flag` decimal(2,1) DEFAULT '0.0' COMMENT '0 = General, 1 = Follow-up Required, 2 = Reminder, 3 =\nInterested, 4 = Important, 5 = URGENT, 6 = DISPUTE',
  `final_note` text,
  `ipDns` varchar(250) DEFAULT NULL,
  `post_pur_q1` int DEFAULT '0',
  `post_pur_q2` int DEFAULT '0',
  `post_pur_q3` int DEFAULT '0',
  `post_pur_comments` tinytext,
  `timeS` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `timeSfirst` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

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;

CREATE TABLE `shopping_cart` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(55) DEFAULT '0',
  `code` varchar(22) DEFAULT NULL,
  `thumb_img` varchar(222) DEFAULT '../images/noImage.jpg',
  `prod` varchar(200) DEFAULT NULL,
  `supp` varchar(200) DEFAULT NULL,
  `r_cat` varchar(100) DEFAULT 'none',
  `cat` varchar(200) DEFAULT NULL,
  `price` decimal(8,2) DEFAULT NULL,
  `piece` int DEFAULT NULL,
  `avW` decimal(5,1) DEFAULT '0.0',
  `stat` int DEFAULT '0' COMMENT '0= on cart, 1 = deleteed, 2 checked out, 3 = wish list',
  `dtAdd` varchar(222) DEFAULT NULL,
  `dtOrd` varchar(50) DEFAULT '0',
  `others` varchar(200) DEFAULT NULL,
  `timeSfirst` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `cat` (`cat`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

CREATE TABLE `telescope_entries` (
  `sequence` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `family_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `should_display_on_index` tinyint(1) NOT NULL DEFAULT '1',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`sequence`),
  UNIQUE KEY `telescope_entries_uuid_unique` (`uuid`),
  KEY `telescope_entries_batch_id_index` (`batch_id`),
  KEY `telescope_entries_family_hash_index` (`family_hash`),
  KEY `telescope_entries_created_at_index` (`created_at`),
  KEY `telescope_entries_type_should_display_on_index_index` (`type`,`should_display_on_index`)
) ENGINE=InnoDB AUTO_INCREMENT=9374 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `telescope_entries_tags` (
  `entry_uuid` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`entry_uuid`,`tag`),
  KEY `telescope_entries_tags_tag_index` (`tag`),
  CONSTRAINT `telescope_entries_tags_entry_uuid_foreign` FOREIGN KEY (`entry_uuid`) REFERENCES `telescope_entries` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `telescope_monitoring` (
  `tag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `cat_tbl` (`id`, `delstat`, `mtitle`, `mdes`, `mkey`, `category`, `category_label`, `r_category`, `pic_thumb`, `pic_banner`, `details`, `others`) VALUES
(1, '0', NULL, NULL, NULL, 'sCat 1.1', '0', 'rCat 1 r_category', NULL, NULL, NULL, NULL),
(2, '0', NULL, NULL, NULL, 'sCat 1.2', '0', 'rCat 1 r_category', NULL, NULL, NULL, NULL),
(3, '0', NULL, NULL, NULL, 'sCat 1.3', '0', 'rCat 1 r_category', NULL, NULL, NULL, NULL),
(4, '0', NULL, NULL, NULL, 'sCat 2.1', '0', 'rCat 2 r_category', NULL, NULL, NULL, NULL),
(5, '0', NULL, NULL, NULL, 'sCat 2.2', '0', 'rCat 2 r_category', NULL, NULL, NULL, NULL),
(6, '0', NULL, NULL, NULL, 'sCat 3.1', '0', 'rCat 3 r_category', NULL, NULL, NULL, NULL);

INSERT INTO `main_tbl` (`id`, `r_cat`, `cat`, `pname`, `supplier`, `code`, `pubprv`, `status`, `carat`, `showdel`, `col_temp`, `mtitle`, `mkey`, `mdes`, `pic_small`, `pic_big`, `pic_XL`, `details`, `size_details`, `size_met`, `size_max`, `size_met2`, `size_max2`, `price`, `make_ch`, `usd`, `make_cc`, `precious`, `markup`, `stock`, `hitCount`, `comments`, `billCom`, `others`, `m_cat`, `m_col`, `timeS`, `timeSfirst`) VALUES
(1, 'rCat 1 r_category', 'sCat 1.1', 'Pr 1', 'sup1', 'PrCo1', 0, 0, '22', 0, 1, NULL, NULL, NULL, NULL, NULL, '../ images/ noImage. jpg', NULL, NULL, 'na', 0.00, 'na', 0.00, 2.1, 0, 1501, NULL, '0', '33', '0', 50, NULL, NULL, NULL, NULL, NULL, '2025-02-21 22:08:32', '2007-11-13 13:19:02'),
(2, 'rCat 1 r_category', 'sCat 1.1', 'Pr 2', 'sup2', 'PrCo2', 0, 0, '22', 0, 1, NULL, NULL, NULL, NULL, NULL, '../ images/ noImage. jpg', NULL, NULL, 'na', 0.00, 'na', 0.00, 2.2, 0, 1502, NULL, '0', '33', '0', 50, NULL, NULL, NULL, NULL, NULL, '2025-02-21 22:08:32', '2007-11-13 13:19:02');

INSERT INTO `migrations` (`id`, `migration`, `batch`) 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, '2025_02_18_154138_create_telescope_entries_table', 1);

INSERT INTO `r_cat_tbl` (`id`, `delstat`, `mtitle`, `mdes`, `mkey`, `r_category`, `r_cat_label`, `srt`, `pic_banner`, `details`, `others`) VALUES
(1, '0', 'rCat 1 mt', 'rCat 1 mdes', 'rCat 1 mkey', 'rCat 1 r_category', 'rCat 1 label', '1', 'rCat 1 pic_banner', 'rCat 1 details', 'rCat 1 others'),
(2, '0', 'rCat 2 mt', 'rCat 2 mdes', 'rCat 2 mkey', 'rCat 2 r_category', 'rCat 2 label', '2', 'rCat 2 pic_banner', 'rCat 2 details', 'rCat 2 others'),
(3, '0', 'rCat 3 mt', 'rCat 3 mdes', 'rCat 3 mkey', 'rCat 3 r_category', 'rCat 3 label', '3', 'rCat 3 pic_banner', 'rCat 3 details', 'rCat 3 others');

INSERT INTO `s_cart_db` (`id`, `uid`, `dtOrd`, `avW`, `gRate`, `subTotal`, `shi`, `tax`, `grandTotal`, `cc4dg`, `status`, `ship_add`, `ch_log`, `comments`, `comment_customers`, `p_comments`, `p_comments_flag`, `final_note`, `ipDns`, `post_pur_q1`, `post_pur_q2`, `post_pur_q3`, `post_pur_comments`, `timeS`, `timeSfirst`) VALUES
(1, 'psingh@my.dom', '080308>11:03:11', 9.6, 29.00, 811.00, 28.39, 1.07, 896.16, NULL, '6', NULL, '    March 8, 2008, 11:26 am', 'Dear Mrs. P Singh,\nSeptember 13, 2013, 2:30 pm+-Singh\n_________________________\n_________________________\n', NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2008-08-02 02:05:58', '2008-03-08 11:03:11'),
(2, 'psingh@my.dom', '080308>11:03:37', 30.0, 40.00, 1500.00, 0.00, 1.07, 1605.00, NULL, '6', NULL, '  March 8, 2008, 11:27 am', 'Dear Mrs. P Singh,\nSeptember 13, 2013, 2:30 pm+-Singh\n_________________________\nYour order is under review. You will be notified at the email address provided by you at the time of registration / Signup.\nThank you,\nmy.dom\n', NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2008-08-02 02:05:58', '2008-03-08 11:03:37'),
(3, 'psingh@my.dom', '2025-02-24T20:37:07+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:37:07', NULL),
(4, 'psingh@my.dom', '2025-02-24T20:38:59+00:00', NULL, NULL, 3002.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:38:59', '2025-02-24 20:38:59'),
(5, 'psingh@my.dom', '2025-02-24T20:40:31+00:00', NULL, NULL, 15020.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:40:31', '2025-02-24 20:40:31'),
(6, 'psingh@my.dom', '2025-02-24T20:42:30+00:00', NULL, NULL, 1502.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:42:29', '2025-02-24 20:42:30'),
(7, 'psingh@my.dom', '2025-02-24T20:43:19+00:00', NULL, NULL, 1502.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:43:19', '2025-02-24 20:43:19'),
(8, 'psingh@my.dom', '2025-02-24T20:43:49+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:43:49', '2025-02-24 20:43:49'),
(9, 'psingh@my.dom', '2025-02-24T20:44:04+00:00', NULL, NULL, 3002.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:44:04', '2025-02-24 20:44:04'),
(10, 'psingh@my.dom', '2025-02-24T20:53:19+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:53:18', '2025-02-24 20:53:19'),
(11, 'psingh@my.dom', '2025-02-24T20:53:19+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:53:19', '2025-02-24 20:53:19'),
(12, 'psingh@my.dom', '2025-02-24T20:53:20+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:53:20', '2025-02-24 20:53:20'),
(13, 'psingh@my.dom', '2025-02-24T20:53:20+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:53:20', '2025-02-24 20:53:20'),
(14, 'psingh@my.dom', '2025-02-24T20:53:20+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:53:20', '2025-02-24 20:53:20'),
(15, 'psingh@my.dom', '2025-02-24T20:53:48+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:53:47', '2025-02-24 20:53:48'),
(16, 'psingh@my.dom', '2025-02-24T20:55:34+00:00', NULL, NULL, 0.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:55:33', '2025-02-24 20:55:34'),
(17, 'psingh@my.dom', '2025-02-24T20:56:17+00:00', NULL, NULL, 1501.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:56:17', '2025-02-24 20:56:17'),
(18, 'psingh@my.dom', '2025-02-24T20:56:53+00:00', NULL, NULL, 1501.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:56:52', '2025-02-24 20:56:53'),
(19, 'psingh@my.dom', '2025-02-24T20:58:06+00:00', NULL, NULL, 9009.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 20:58:06', '2025-02-24 20:58:06'),
(20, 'psingh@my.dom', '2025-02-24T21:06:08+00:00', NULL, NULL, 1501.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 21:06:08', '2025-02-24 21:06:08'),
(21, 'psingh@my.dom', '2025-02-24T21:06:30+00:00', NULL, NULL, 7508.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 21:06:30', '2025-02-24 21:06:30'),
(22, 'test@test.com', '2025-02-24T21:16:58+00:00', NULL, NULL, 85612.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 21:16:57', '2025-02-24 21:16:58'),
(23, 'test@test.com', '2025-02-24T21:17:33+00:00', NULL, NULL, 4506.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 21:17:33', '2025-02-24 21:17:33'),
(24, 'test@test.com', '2025-02-24T21:18:29+00:00', NULL, NULL, 1502.00, NULL, NULL, NULL, NULL, '0', NULL, '', NULL, NULL, NULL, 0.0, NULL, NULL, 0, 0, 0, NULL, '2025-02-24 21:18:29', '2025-02-24 21:18:29');

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('LotAD03Ae6uEvWyDwiwX8hUBba6czx5ZHr4BKKiJ', 2, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWTFRTmhhYlcyMmJVU0RiY0h0cUlrRXBvMmdMVEJiaHBROWN3VHJ5dCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC90d2lnIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjt9', 1740432116),
('PmDp25N2x98YdSq4bS3MnjRswvdx4xe6QRiinfJp', 2, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiU1NDelhIdlN2NnpwM3p6RklJczNDZVc5dTRMQ0dJRTZoWVRHaEZDOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9jYXJ0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjt9', 1740426193),
('zshVVNWdOLvxwHJFSLLwe0XZkDgRFufED8PX8Mhj', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0NMUEtHSnpDc0JaMlpjT3BWdk5raFZnSEsyb2dGcTVkM2RxbHlpTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1740427021);

INSERT INTO `shopping_cart` (`id`, `uid`, `code`, `thumb_img`, `prod`, `supp`, `r_cat`, `cat`, `price`, `piece`, `avW`, `stat`, `dtAdd`, `dtOrd`, `others`, `timeSfirst`) VALUES
(1, 'test@test.com', 'BaSt6961', '/img/location1.jpg', 'test prod 1', 'MJ', 'Bangles', 'Stone Bangles', 441.00, 1, 9.3, 2, '100221>15:02:32', '100221150203', NULL, '2010-02-21 15:21:03'),
(2, 'psingh@my.dom', 'PeOm6010', '/img/location2.jpg', 'test prod 2', 'MJ', 'Pendants', 'Om Pendants', 282.00, 1, 3.9, 2, '100617>15:06:15', '100617150619', NULL, '2010-06-17 15:56:19'),
(3, 'psingh@my.dom', 'ErWg5050', '/img/location3.jpg', 'test prod 3', 'MJ', 'Earrings', 'White Gold Earrings', 145.00, 1, 1.7, 2, '110104>19:01:59', '110104190132', NULL, '2011-01-04 19:23:32'),
(4, 'psingh@my.dom', 'BaKa12751', '/img/location3.jpg', 'test prod 4', 'ZB-AJ', 'Bangles', 'Gold Bangles', 709.00, 1, 9.6, 2, '130418>12:04:38', '130418120400', NULL, '2013-04-18 12:24:00'),
(5, 'psingh@my.dom', 'BaKa12751', '/img/location3.jpg', 'test prod 4', 'ZB-AJ', 'Bangles', 'Gold Bangles', 811.00, 1, 9.6, 2, '080308>11:03:11', '080308>11:03:11', NULL, '2013-04-18 12:24:00'),
(6, 'psingh@my.dom', 'FaKe1', '/img/location3.jpg', 'test prod 4', 'ZB-AJ', 'Fa', 'Ke', 500.00, 1, 10.0, 2, '130418>12:04:38', '080308>11:03:37', NULL, '2013-04-18 12:24:00'),
(7, 'psingh@my.dom', 'FaKe2', '/img/location3.jpg', 'test prod 4', 'ZB-AJ', 'Fa', 'Ke', 1000.00, 1, 20.0, 2, '130418>12:04:38', '080308>11:03:37', NULL, '2013-04-18 12:24:00'),
(8, '0', NULL, '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 0, NULL, '0', NULL, NULL),
(9, 'test@test.com', NULL, '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 1, NULL, '0', NULL, NULL),
(10, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 1, NULL, '0', NULL, NULL),
(11, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 1, NULL, '0', NULL, NULL),
(12, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 1, NULL, '0', NULL, NULL),
(13, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 1, NULL, '0', NULL, NULL),
(14, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, NULL, 0.0, 1, NULL, '0', NULL, NULL),
(15, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, 1, 0.0, 1, NULL, '0', NULL, NULL),
(16, 'test@test.com', 'PrCo1', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, 1, 0.0, 1, NULL, '0', NULL, NULL),
(17, 'test@test.com', 'PrCo2', '../images/noImage.jpg', NULL, NULL, 'none', NULL, NULL, 2, 0.0, 1, NULL, '0', NULL, NULL),
(18, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', NULL, NULL, 'none', NULL, NULL, 3, 0.0, 1, NULL, '0', NULL, NULL),
(19, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', NULL, 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 1, NULL, '0', NULL, NULL),
(20, 'test@test.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', NULL, 'rCat 1 r_category', 'sCat 1.1', 1502.00, 2, 2.2, 1, NULL, '0', NULL, NULL),
(21, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 1, NULL, '0', NULL, NULL),
(22, 'test@test.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 1, 2.2, 1, 'Fri Feb 21 2025 22:10:37 GMT+0000', '0', NULL, '2025-02-21 22:10:37'),
(23, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 1, 'Fri Feb 21 2025 22:12:04 GMT+0000', '0', NULL, '2025-02-21 22:12:04'),
(24, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 4, 2.1, 1, 'Fri Feb 21 2025 22:12:10 GMT+0000', '0', NULL, '2025-02-21 22:12:10'),
(25, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 5, 2.1, 1, 'Fri Feb 21 2025 22:12:15 GMT+0000', '0', NULL, '2025-02-21 22:12:15'),
(26, 'one@one.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 0, 'Fri Feb 21 2025 22:12:58 GMT+0000', '0', NULL, '2025-02-21 22:12:58'),
(27, 'one@one.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 1, 2.2, 0, 'Fri Feb 21 2025 22:13:29 GMT+0000', '0', NULL, '2025-02-21 22:13:29'),
(28, 'one@one.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 5, 2.1, 0, 'Fri Feb 21 2025 22:14:07 GMT+0000', '0', NULL, '2025-02-21 22:14:07'),
(29, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 5, 2.1, 1, 'Mon Feb 24 2025 19:41:25 GMT+0000', '0', NULL, '2025-02-24 19:41:25'),
(30, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 11, 2.1, 1, 'Mon Feb 24 2025 19:42:01 GMT+0000', '0', NULL, '2025-02-24 19:42:01'),
(31, 'test@test.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 2, 2.2, 1, 'Mon Feb 24 2025 19:42:16 GMT+0000', '0', NULL, '2025-02-24 19:42:16'),
(32, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 13, 2.1, 1, 'Mon Feb 24 2025 19:43:00 GMT+0000', '0', NULL, '2025-02-24 19:43:00'),
(33, 'test@test.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 55, 2.2, 2, 'Mon Feb 24 2025 19:43:13 GMT+0000', '2025-02-24T21:16:58+00:00', NULL, '2025-02-24 19:43:13'),
(34, 'second@second.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 1, 'Mon Feb 24 2025 19:58:20 GMT+0000', '0', NULL, '2025-02-24 19:58:20'),
(35, 'second@second.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 0, 'Mon Feb 24 2025 19:59:59 GMT+0000', '0', NULL, '2025-02-24 19:59:59'),
(36, 'second@second.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 1, 2.2, 0, 'Mon Feb 24 2025 20:00:07 GMT+0000', '0', NULL, '2025-02-24 20:00:07'),
(37, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 2, 2.1, 2, 'Mon Feb 24 2025 20:26:21 GMT+0000', '2025-02-24T20:36:44+00:00', NULL, '2025-02-24 20:26:21'),
(38, 'psingh@my.dom', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 10, 2.2, 2, 'Mon Feb 24 2025 20:27:00 GMT+0000', '2025-02-24T20:36:44+00:00', NULL, '2025-02-24 20:27:00'),
(39, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 2, 2.1, 2, 'Mon Feb 24 2025 20:38:51 GMT+0000', '2025-02-24T20:38:59+00:00', NULL, '2025-02-24 20:38:51'),
(40, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 10, 2.1, 2, 'Mon Feb 24 2025 20:40:13 GMT+0000', '2025-02-24T20:40:31+00:00', NULL, '2025-02-24 20:40:13'),
(41, 'psingh@my.dom', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 10, 2.2, 2, 'Mon Feb 24 2025 20:40:18 GMT+0000', '2025-02-24T20:40:31+00:00', NULL, '2025-02-24 20:40:18'),
(42, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 20:42:18 GMT+0000', '2025-02-24T20:42:30+00:00', NULL, '2025-02-24 20:42:18'),
(43, 'psingh@my.dom', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 1, 2.2, 2, 'Mon Feb 24 2025 20:42:20 GMT+0000', '2025-02-24T20:42:30+00:00', NULL, '2025-02-24 20:42:20'),
(44, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 20:43:11 GMT+0000', '2025-02-24T20:43:19+00:00', NULL, '2025-02-24 20:43:11'),
(45, 'psingh@my.dom', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 1, 2.2, 2, 'Mon Feb 24 2025 20:43:13 GMT+0000', '2025-02-24T20:43:19+00:00', NULL, '2025-02-24 20:43:13'),
(46, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 20:44:00 GMT+0000', '2025-02-24T20:44:04+00:00', NULL, '2025-02-24 20:44:00'),
(47, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 20:44:02 GMT+0000', '2025-02-24T20:44:04+00:00', NULL, '2025-02-24 20:44:02'),
(48, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 20:56:14 GMT+0000', '2025-02-24T20:56:17+00:00', NULL, '2025-02-24 20:56:14'),
(49, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 20:56:51 GMT+0000', '2025-02-24T20:56:53+00:00', NULL, '2025-02-24 20:56:51'),
(50, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 3, 2.1, 2, 'Mon Feb 24 2025 20:57:55 GMT+0000', '2025-02-24T20:58:06+00:00', NULL, '2025-02-24 20:57:55'),
(51, 'psingh@my.dom', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 3, 2.2, 2, 'Mon Feb 24 2025 20:57:59 GMT+0000', '2025-02-24T20:58:06+00:00', NULL, '2025-02-24 20:57:59'),
(52, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 1, 'Mon Feb 24 2025 20:58:16 GMT+0000', '0', NULL, '2025-02-24 20:58:16'),
(53, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 2, 'Mon Feb 24 2025 21:06:06 GMT+0000', '2025-02-24T21:06:08+00:00', NULL, '2025-02-24 21:06:06'),
(54, 'psingh@my.dom', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 2, 2.1, 2, 'Mon Feb 24 2025 21:06:19 GMT+0000', '2025-02-24T21:06:30+00:00', NULL, '2025-02-24 21:06:19'),
(55, 'psingh@my.dom', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 3, 2.2, 2, 'Mon Feb 24 2025 21:06:23 GMT+0000', '2025-02-24T21:06:30+00:00', NULL, '2025-02-24 21:06:23'),
(56, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 2, 2.1, 2, 'Mon Feb 24 2025 21:16:50 GMT+0000', '2025-02-24T21:16:58+00:00', NULL, '2025-02-24 21:16:50'),
(57, 'test@test.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 3, 2.2, 2, 'Mon Feb 24 2025 21:17:30 GMT+0000', '2025-02-24T21:17:33+00:00', NULL, '2025-02-24 21:17:30'),
(58, 'test@test.com', 'PrCo1', '../ images/ noImage. jpg', 'Pr 1', 'sup1', 'rCat 1 r_category', 'sCat 1.1', 1501.00, 1, 2.1, 1, 'Mon Feb 24 2025 21:18:20 GMT+0000', '0', NULL, '2025-02-24 21:18:20'),
(59, 'test@test.com', 'PrCo2', '../ images/ noImage. jpg', 'Pr 2', 'sup2', 'rCat 1 r_category', 'sCat 1.1', 1502.00, 1, 2.2, 2, 'Mon Feb 24 2025 21:18:27 GMT+0000', '2025-02-24T21:18:29+00:00', NULL, '2025-02-24 21:18:27');



