-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `phkay_pos`
--

-- --------------------------------------------------------

--
-- Table structure for table `currencies`
--

CREATE TABLE IF NOT EXISTS `currencies` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency_symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exchange_in_rate` double(15,4) NOT NULL DEFAULT '0.0000',
  `exchange_out_rate` double(15,4) NOT NULL DEFAULT '0.0000',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_based` tinyint(1) NOT NULL DEFAULT '1',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `currency_symbol`, `exchange_in_rate`, `exchange_out_rate`, `is_active`, `is_based`, `image`, `user_id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'USD', '$', 1.0000, 1.0000, 1, 1, '1', 1, NULL, '2024-04-10 10:45:40', '2024-04-10 10:48:08'),
(2, 'THB', 'B', 36.6700, 36.6700, 1, 0, '1', 1, NULL, '2024-04-10 10:45:40', '2024-04-10 10:48:03'),
(3, 'KHR', '៛', 4117.8800, 4117.8800, 1, 0, '1', 1, NULL, '2024-04-10 10:46:20', '2024-04-24 08:48:04');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 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;

-- --------------------------------------------------------

--
-- Table structure for table `main_categories`
--

CREATE TABLE IF NOT EXISTS `main_categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(16,4) NOT NULL DEFAULT '0.0000',
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2022_04_15_130146_create_permission_tables', 1),
(6, '2023_08_06_161442_create_currencies_table', 1),
(7, '2023_08_19_114315_create_settings_table', 1),
(8, '2024_04_17_134213_create_products_table', 2),
(15, '2024_04_19_135123_create_main_categories_table', 3),
(16, '2024_04_19_135131_create_product_categories_table', 3),
(90, '2024_04_19_135141_create_products_table', 4),
(91, '2024_04_19_135158_create_sales_table', 4),
(92, '2024_05_07_173808_add_column_to_product_table', 4),
(93, '2024_05_08_114751_add_column_invoice_to_product_table', 4),
(94, '2024_05_08_150657_add_column_sale_currency_id_to_table_sale', 4),
(95, '2024_05_16_112441_add_column_discount_to_table_sales', 4),
(96, '2024_05_29_113626_add_column_to_usd_exchange_rate_to_table_product_categories', 4),
(97, '2024_05_29_145146_modify_table_sales_table', 4),
(98, '2024_05_29_150930_add_column_to_table_sale', 4),
(99, '2024_05_31_104129_add_column_to_table_sale', 4),
(100, '2024_06_10_101859_modify_column_is_active_from_table_sale', 4),
(101, '2024_06_24_122415_add_column_to_table_product', 5),
(102, '2024_06_26_135550_create_product_category_prices_table', 5),
(103, '2024_06_27_130833_add_column_to_table_categories', 5),
(104, '2024_06_27_162834_add_parent_id_product_categories_table', 5);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint UNSIGNED NOT NULL,
  `model_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(3, 'App\\Models\\User', 3);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'role-list', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(2, 'role-create', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(3, 'role-edit', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(4, 'role-delete', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(5, 'user-list', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(6, 'user-create', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(7, 'user-edit', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(8, 'user-delete', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(9, 'currency-list', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(10, 'currency-create', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(11, 'currency-edit', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(12, 'currency-delete', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(13, 'setting-list', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(14, 'setting-create', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(15, 'setting-edit', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(16, 'setting-delete', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(17, 'product-list', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(18, 'product-create', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(19, 'product-edit', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(20, 'product-delete', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(21, 'product-category-list', 'web', '2024-06-11 04:50:45', '2024-06-11 04:50:45'),
(22, 'product-category-create', 'web', '2024-06-11 04:50:45', '2024-06-11 04:50:45'),
(23, 'product-category-edit', 'web', '2024-06-11 04:50:45', '2024-06-11 04:50:45'),
(24, 'product-category-delete', 'web', '2024-06-11 04:50:45', '2024-06-11 04:50:45'),
(25, 'sale-list', 'web', '2024-06-11 04:50:45', '2024-06-11 04:50:45'),
(26, 'sale-delete', 'web', '2024-06-11 04:50:46', '2024-06-11 04:50:46'),
(27, 'report-list', 'web', '2024-06-11 04:50:46', '2024-06-11 04:50:46'),
(28, 'point-to-sale', 'web', '2024-06-11 04:50:46', '2024-06-11 04:50:46');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `part_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double(16,2) NOT NULL,
  `cost` double(16,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(16,4) NOT NULL,
  `product_category_id` bigint UNSIGNED DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `grn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL DEFAULT '0',
  `diamond_size` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice` bigint DEFAULT NULL,
  `wages` double NOT NULL,
  `for_sale` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `part_number`, `name`, `price`, `cost`, `is_active`, `description`, `image`, `weight`, `product_category_id`, `user_id`, `deleted_at`, `created_at`, `updated_at`, `grn`, `qty`, `diamond_size`, `invoice`, `wages`, `for_sale`) VALUES
(5, '429333405', 'ខ្សែក', 0.00, 1816.00, 1, '', '', 699.0000, 12, 2, NULL, '2024-07-01 09:38:28', NULL, '508818350', 0, '', 697144314, 155, 1),
(6, '394192112', 'បន្តោងខ្សែកពេជ្រ', 0.00, 116.00, 1, '', '', 45.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '657133832', 34, '1.55លី', 493432415, 129, 1),
(7, '744676547', 'បន្តោងខ្សែកពេជ្រ', 0.00, 116.00, 1, '', '', 45.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '966299330', 2, '1.25លី', 785607583, 129, 1),
(8, '357823957', 'បន្តោងខ្សែកពេជ្រ', 0.00, 116.00, 1, '', '', 45.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '903396744', 1, '1.10លី', 483169524, 129, 1),
(9, '166682179', 'ចិញ្ជៀនពេជ្រ', 0.00, 218.00, 1, '', '', 84.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '518412727', 1, '1.55លី', 452381661, 104, 1),
(10, '191611316', 'ចិញ្ជៀនពេជ្រ', 0.00, 218.00, 1, '', '', 84.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '888482311', 12, '1.25លី', 664980800, 104, 1),
(11, '227650727', 'ចិញ្ជៀនពេជ្រ', 0.00, 161.00, 1, '', '', 62.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '105875145', 1, '2.60លី', 666560457, 103, 1),
(12, '12326779', 'ចិញ្ជៀនពេជ្រ', 0.00, 161.00, 1, '', '', 62.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '268344845', 2, '2.40លី', 185017772, 103, 1),
(13, '802748235', 'ចិញ្ជៀនពេជ្រ', 0.00, 161.00, 1, '', '', 62.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '685273885', 6, '2.05លី', 941446855, 103, 1),
(14, '302155991', 'បន្តោងខ្សែកពេជ្រ', 0.00, 57.00, 1, '', '', 22.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '851572571', 1, '3.80លី', 597026475, 78, 1),
(15, '164919017', 'បន្តោងខ្សែកពេជ្រ', 0.00, 57.00, 1, '', '', 22.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '477166108', 2, '3.10លី', 312834074, 78, 1),
(16, '930653108', 'ចិញ្ជៀនពេជ្រ', 0.00, 192.00, 1, '', '', 74.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '49240033', 1, '4.00លី', 471347793, 156, 1),
(17, '253514498', 'ចិញ្ជៀនពេជ្រ', 0.00, 192.00, 1, '', '', 74.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '835489452', 52, '1.55លី', 10539739, 156, 1),
(18, '582911583', 'ចិញ្ជៀនពេជ្រ', 0.00, 192.00, 1, '', '', 74.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '69263921', 12, '1.25លី', 81816529, 156, 1),
(19, '800944852', 'ក្រវិលពេជ្រ', 0.00, 174.00, 1, '', '', 67.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '644403111', 2, '4.10លី', 959327738, 129, 1),
(20, '127784216', 'ក្រវិលពេជ្រ', 0.00, 174.00, 1, '', '', 67.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '91444371', 36, '1.55លី', 684005250, 129, 1),
(21, '213352779', 'ក្រវិលពេជ្រ', 0.00, 80.00, 1, '', '', 31.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '666124110', 6, '2.05លី', 123179305, 78, 1),
(22, '423203405', 'ក្រវិលពេជ្រ', 0.00, 80.00, 1, '', '', 31.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '437495816', 6, '1.60លី', 898233395, 78, 1),
(23, '676682500', 'បន្តោងខ្សែកពេជ្រ', 0.00, 532.00, 1, '', '', 205.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '399303715', 1, '2.60លី', 624306754, 208, 1),
(24, '71312683', 'បន្តោងខ្សែកពេជ្រ', 0.00, 532.00, 1, '', '', 205.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '171311631', 1, '2.00លី', 126777028, 208, 1),
(25, '933907178', 'បន្តោងខ្សែកពេជ្រ', 0.00, 532.00, 1, '', '', 205.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '216375731', 2, '1.70លី', 222712017, 208, 1),
(26, '171787052', 'បន្តោងខ្សែកពេជ្រ', 0.00, 532.00, 1, '', '', 205.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '444189374', 2, '1.80លី', 158521763, 208, 1),
(27, '225972788', 'បន្តោងខ្សែកពេជ្រ', 0.00, 532.00, 1, '', '', 205.0000, 1, 2, NULL, '2024-07-01 09:38:28', NULL, '391545418', 52, '1.60លី', 198282443, 208, 1),
(28, '184786613', 'កងដៃ', 0.00, 1426.00, 1, '', '', 549.0000, 12, 2, NULL, '2024-07-01 09:38:28', '2024-07-01 09:43:55', '342816858', 0, '', 506097752, 182, 1);

-- --------------------------------------------------------

--
-- Table structure for table `product_categories`
--

CREATE TABLE IF NOT EXISTS `product_categories` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `to_usd_exchange_rate` double DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` bigint UNSIGNED DEFAULT NULL,
  `is_main` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`id`, `name`, `is_active`, `user_id`, `deleted_at`, `created_at`, `updated_at`, `to_usd_exchange_rate`, `icon`, `parent_id`, `is_main`) VALUES
(1, 'ពេជ្រ', 1, 2, NULL, '2024-04-25 08:09:26', '2024-07-01 09:41:51', 334, 'icon-png/1803369223393088.png', NULL, 1),
(2, 'មាស', 1, 2, NULL, '2024-04-25 10:59:00', '2024-07-01 09:41:40', 435, 'icon-png/1803369211411851.png', NULL, 1),
(3, 'ផ្លាកទីន', 1, 2, NULL, '2024-04-25 10:59:13', '2024-07-01 09:41:30', 455, 'icon-png/1803369201782315.png', NULL, 1),
(12, 'ផ្លាកទីនទឹក7.5', 1, 2, NULL, '2024-06-11 10:18:18', '2024-07-01 09:41:15', 46, 'icon-png/1803369184973737.png', 3, 0);

-- --------------------------------------------------------

--
-- Table structure for table `product_category_prices`
--

CREATE TABLE IF NOT EXISTS `product_category_prices` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_category_id` bigint UNSIGNED DEFAULT NULL,
  `price` double(16,2) NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(2, 'Supervisor', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40'),
(3, 'Staff', 'web', '2024-04-10 10:45:40', '2024-04-10 10:45:40');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint UNSIGNED NOT NULL,
  `role_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(1, 2),
(2, 2),
(3, 2),
(4, 2),
(5, 2),
(6, 2),
(7, 2),
(8, 2),
(9, 2),
(10, 2),
(11, 2),
(12, 2),
(13, 2),
(14, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(19, 2),
(20, 2),
(21, 2),
(22, 2),
(23, 2),
(24, 2),
(25, 2),
(26, 2),
(27, 2),
(28, 2),
(1, 3),
(2, 3),
(3, 3),
(4, 3),
(5, 3),
(6, 3),
(7, 3),
(8, 3),
(9, 3),
(10, 3),
(11, 3),
(12, 3),
(13, 3),
(14, 3),
(15, 3),
(16, 3),
(17, 3),
(18, 3),
(19, 3),
(20, 3),
(21, 3),
(22, 3),
(23, 3),
(24, 3),
(25, 3),
(26, 3),
(27, 3),
(28, 3);

-- --------------------------------------------------------

--
-- Table structure for table `sales`
--

CREATE TABLE IF NOT EXISTS `sales` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint UNSIGNED DEFAULT NULL,
  `part_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cost` double(16,2) NOT NULL,
  `description` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` double(16,4) NOT NULL,
  `product_category_id` bigint UNSIGNED DEFAULT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `usd_amount` double DEFAULT NULL,
  `khr_amount` double DEFAULT NULL,
  `thb_amount` double DEFAULT NULL,
  `wages` double DEFAULT NULL,
  `invoice_no` bigint NOT NULL,
  `grn` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qty` int NOT NULL DEFAULT '1',
  `diamond_size` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `shop_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fav_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` int NOT NULL DEFAULT '1',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `shop_name`, `address`, `phone`, `logo`, `fav_icon`, `is_active`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Crown Jewelry', 'ភូមិក្បាលស្ពាន១ សង្កាត់ប៉ោយប៉ែត ក្រុងប៉ោយប៉ែត ខេត្តបន្ទាយមានជ័យ', '012-XXX-XXX', 'logo.png', 'fav.ico', 1, NULL, '2024-04-10 10:45:35', '2024-04-17 06:37:34');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

