-- Laundry Box Database Dump
-- Generated on 2026-01-18 17:31:45


-- Structure for table `migrations`
CREATE TABLE `migrations` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `migration` VARCHAR(255) NOT NULL  ,
  `batch` BIGINT NOT NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `migrations`
INSERT INTO `migrations` VALUES
('1', '0001_01_01_000001_create_cache_table', '1'),
('2', '0001_01_01_000002_create_jobs_table', '1'),
('3', '2014_10_12_000000_create_users_table', '1'),
('4', '2014_10_12_100000_create_password_resets_table', '1'),
('5', '2019_08_19_000000_create_failed_jobs_table', '1'),
('6', '2019_12_14_000001_create_personal_access_tokens_table', '1'),
('7', '2022_02_21_092427_create_countries_table', '1'),
('8', '2022_02_21_092427_create_financial_years_table', '1'),
('9', '2022_02_21_092430_create_master_settings_table', '1'),
('10', '2022_02_21_092644_create_expense_categories_table', '1'),
('11', '2022_02_21_092944_create_expenses_table', '1'),
('12', '2022_02_21_093542_create_customers_table', '1'),
('13', '2022_02_21_093811_create_service_types_table', '1'),
('14', '2022_02_21_093939_create_services_table', '1'),
('15', '2022_02_21_094046_create_service_details_table', '1'),
('16', '2022_02_21_094504_create_addons_table', '1'),
('17', '2022_02_21_094505_create_orders_table', '1'),
('18', '2022_02_21_095107_create_order_details_table', '1'),
('19', '2022_02_21_095437_create_order_addon_details_table', '1'),
('20', '2022_02_21_095622_create_payments_table', '1'),
('21', '2022_02_23_170213_create_translations_table', '1'),
('22', '2022_02_25_050554_add_addon_id', '1'),
('23', '2022_03_21_035629_add_is_rtl_to_translations_table', '1'),
('24', '2022_06_07_070019_add_color_code_in_order_details', '1'),
('25', '2022_06_08_052536_add_created_by_in_expenses', '1'),
('26', '2022_06_08_052748_add_created_by_in_expense_categories', '1'),
('27', '2024_07_12_053525_add_tax_type_to_orders_table', '1'),
('28', '2024_07_12_055754_add_taxable_amount_to_orders_table', '1'),
('29', '2024_10_05_110712_create_permissions_table', '1'),
('30', '2024_10_05_120219_create_user_roles_table', '1'),
('31', '2024_10_07_054648_create_user_role_permissions_table', '1'),
('32', '2024_10_07_063444_add_role_id_to_users_table', '1');

-- Structure for table `failed_jobs`
CREATE TABLE `failed_jobs` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `uuid` VARCHAR(255) 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 ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Structure for table `countries`
CREATE TABLE `countries` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `country_code` VARCHAR(255) NOT NULL  ,
  `country_name` VARCHAR(255) NOT NULL  ,
  `phone_code` VARCHAR(255) NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `countries`
INSERT INTO `countries` VALUES
('1', 'AF', 'Afghanistan', '93', NULL, NULL),
('2', 'AL', 'Albania', '355', NULL, NULL),
('3', 'DZ', 'Algeria', '213', NULL, NULL),
('4', 'AS', 'American Samoa', '1684', NULL, NULL),
('5', 'AD', 'Andorra', '376', NULL, NULL),
('6', 'AO', 'Angola', '244', NULL, NULL),
('7', 'AI', 'Anguilla', '1264', NULL, NULL),
('8', 'AQ', 'Antarctica', '0', NULL, NULL),
('9', 'AG', 'Antigua And Barbuda', '1268', NULL, NULL),
('10', 'AR', 'Argentina', '54', NULL, NULL),
('11', 'AM', 'Armenia', '374', NULL, NULL),
('12', 'AW', 'Aruba', '297', NULL, NULL),
('13', 'AU', 'Australia', '61', NULL, NULL),
('14', 'AT', 'Austria', '43', NULL, NULL),
('15', 'AZ', 'Azerbaijan', '994', NULL, NULL),
('16', 'BS', 'Bahamas The', '1242', NULL, NULL),
('17', 'BH', 'Bahrain', '973', NULL, NULL),
('18', 'BD', 'Bangladesh', '880', NULL, NULL),
('19', 'BB', 'Barbados', '1246', NULL, NULL),
('20', 'BY', 'Belarus', '375', NULL, NULL),
('21', 'BE', 'Belgium', '32', NULL, NULL),
('22', 'BZ', 'Belize', '501', NULL, NULL),
('23', 'BJ', 'Benin', '229', NULL, NULL),
('24', 'BM', 'Bermuda', '1441', NULL, NULL),
('25', 'BT', 'Bhutan', '975', NULL, NULL),
('26', 'BO', 'Bolivia', '591', NULL, NULL),
('27', 'BA', 'Bosnia and Herzegovina', '387', NULL, NULL),
('28', 'BW', 'Botswana', '267', NULL, NULL),
('29', 'BV', 'Bouvet Island', '0', NULL, NULL),
('30', 'BR', 'Brazil', '55', NULL, NULL),
('31', 'IO', 'British Indian Ocean Territory', '246', NULL, NULL),
('32', 'BN', 'Brunei', '673', NULL, NULL),
('33', 'BG', 'Bulgaria', '359', NULL, NULL),
('34', 'BF', 'Burkina Faso', '226', NULL, NULL),
('35', 'BI', 'Burundi', '257', NULL, NULL),
('36', 'KH', 'Cambodia', '855', NULL, NULL),
('37', 'CM', 'Cameroon', '237', NULL, NULL),
('38', 'CA', 'Canada', '1', NULL, NULL),
('39', 'CV', 'Cape Verde', '238', NULL, NULL),
('40', 'KY', 'Cayman Islands', '1345', NULL, NULL),
('41', 'CF', 'Central African Republic', '236', NULL, NULL),
('42', 'TD', 'Chad', '235', NULL, NULL),
('43', 'CL', 'Chile', '56', NULL, NULL),
('44', 'CN', 'China', '86', NULL, NULL),
('45', 'CX', 'Christmas Island', '61', NULL, NULL),
('46', 'CC', 'Cocos (Keeling) Islands', '672', NULL, NULL),
('47', 'CO', 'Colombia', '57', NULL, NULL),
('48', 'KM', 'Comoros', '269', NULL, NULL),
('49', 'CG', 'Republic Of The Congo', '242', NULL, NULL),
('50', 'CD', 'Democratic Republic Of The Congo', '242', NULL, NULL),
('51', 'CK', 'Cook Islands', '682', NULL, NULL),
('52', 'CR', 'Costa Rica', '506', NULL, NULL),
('53', 'CI', 'Cote D Ivoire (Ivory Coast)', '225', NULL, NULL),
('54', 'HR', 'Croatia (Hrvatska)', '385', NULL, NULL),
('55', 'CU', 'Cuba', '53', NULL, NULL),
('56', 'CY', 'Cyprus', '357', NULL, NULL),
('57', 'CZ', 'Czech Republic', '420', NULL, NULL),
('58', 'DK', 'Denmark', '45', NULL, NULL),
('59', 'DJ', 'Djibouti', '253', NULL, NULL),
('60', 'DM', 'Dominica', '1767', NULL, NULL),
('61', 'DO', 'Dominican Republic', '1809', NULL, NULL),
('62', 'TP', 'East Timor', '670', NULL, NULL),
('63', 'EC', 'Ecuador', '593', NULL, NULL),
('64', 'EG', 'Egypt', '20', NULL, NULL),
('65', 'SV', 'El Salvador', '503', NULL, NULL),
('66', 'GQ', 'Equatorial Guinea', '240', NULL, NULL),
('67', 'ER', 'Eritrea', '291', NULL, NULL),
('68', 'EE', 'Estonia', '372', NULL, NULL),
('69', 'ET', 'Ethiopia', '251', NULL, NULL),
('70', 'XA', 'External Territories of Australia', '61', NULL, NULL),
('71', 'FK', 'Falkland Islands', '500', NULL, NULL),
('72', 'FO', 'Faroe Islands', '298', NULL, NULL),
('73', 'FJ', 'Fiji Islands', '679', NULL, NULL),
('74', 'FI', 'Finland', '358', NULL, NULL),
('75', 'FR', 'France', '33', NULL, NULL),
('76', 'GF', 'French Guiana', '594', NULL, NULL),
('77', 'PF', 'French Polynesia', '689', NULL, NULL),
('78', 'TF', 'French Southern Territories', '0', NULL, NULL),
('79', 'GA', 'Gabon', '241', NULL, NULL),
('80', 'GM', 'Gambia The', '220', NULL, NULL),
('81', 'GE', 'Georgia', '995', NULL, NULL),
('82', 'DE', 'Germany', '49', NULL, NULL),
('83', 'GH', 'Ghana', '233', NULL, NULL),
('84', 'GI', 'Gibraltar', '350', NULL, NULL),
('85', 'GR', 'Greece', '30', NULL, NULL),
('86', 'GL', 'Greenland', '299', NULL, NULL),
('87', 'GD', 'Grenada', '1473', NULL, NULL),
('88', 'GP', 'Guadeloupe', '590', NULL, NULL),
('89', 'GU', 'Guam', '1671', NULL, NULL),
('90', 'GT', 'Guatemala', '502', NULL, NULL),
('91', 'XU', 'Guernsey and Alderney', '44', NULL, NULL),
('92', 'GN', 'Guinea', '224', NULL, NULL),
('93', 'GW', 'Guinea-Bissau', '245', NULL, NULL),
('94', 'GY', 'Guyana', '592', NULL, NULL),
('95', 'HT', 'Haiti', '509', NULL, NULL),
('96', 'HM', 'Heard and McDonald Islands', '0', NULL, NULL),
('97', 'HN', 'Honduras', '504', NULL, NULL),
('98', 'HK', 'Hong Kong S.A.R.', '852', NULL, NULL),
('99', 'HU', 'Hungary', '36', NULL, NULL),
('100', 'IS', 'Iceland', '354', NULL, NULL),
('101', 'IN', 'India', '91', NULL, NULL),
('102', 'ID', 'Indonesia', '62', NULL, NULL),
('103', 'IR', 'Iran', '98', NULL, NULL),
('104', 'IQ', 'Iraq', '964', NULL, NULL),
('105', 'IE', 'Ireland', '353', NULL, NULL),
('106', 'IL', 'Israel', '972', NULL, NULL),
('107', 'IT', 'Italy', '39', NULL, NULL),
('108', 'JM', 'Jamaica', '1876', NULL, NULL),
('109', 'JP', 'Japan', '81', NULL, NULL),
('110', 'XJ', 'Jersey', '44', NULL, NULL),
('111', 'JO', 'Jordan', '962', NULL, NULL),
('112', 'KZ', 'Kazakhstan', '7', NULL, NULL),
('113', 'KE', 'Kenya', '254', NULL, NULL),
('114', 'KI', 'Kiribati', '686', NULL, NULL),
('115', 'KP', 'Korea North', '850', NULL, NULL),
('116', 'KR', 'Korea South', '82', NULL, NULL),
('117', 'KW', 'Kuwait', '965', NULL, NULL),
('118', 'KG', 'Kyrgyzstan', '996', NULL, NULL),
('119', 'LA', 'Laos', '856', NULL, NULL),
('120', 'LV', 'Latvia', '371', NULL, NULL),
('121', 'LB', 'Lebanon', '961', NULL, NULL),
('122', 'LS', 'Lesotho', '266', NULL, NULL),
('123', 'LR', 'Liberia', '231', NULL, NULL),
('124', 'LY', 'Libya', '218', NULL, NULL),
('125', 'LI', 'Liechtenstein', '423', NULL, NULL),
('126', 'LT', 'Lithuania', '370', NULL, NULL),
('127', 'LU', 'Luxembourg', '352', NULL, NULL),
('128', 'MO', 'Macau S.A.R.', '853', NULL, NULL),
('129', 'MK', 'Macedonia', '389', NULL, NULL),
('130', 'MG', 'Madagascar', '261', NULL, NULL),
('131', 'MW', 'Malawi', '265', NULL, NULL),
('132', 'MY', 'Malaysia', '60', NULL, NULL),
('133', 'MV', 'Maldives', '960', NULL, NULL),
('134', 'ML', 'Mali', '223', NULL, NULL),
('135', 'MT', 'Malta', '356', NULL, NULL),
('136', 'XM', 'Man (Isle of)', '44', NULL, NULL),
('137', 'MH', 'Marshall Islands', '692', NULL, NULL),
('138', 'MQ', 'Martinique', '596', NULL, NULL),
('139', 'MR', 'Mauritania', '222', NULL, NULL),
('140', 'MU', 'Mauritius', '230', NULL, NULL),
('141', 'YT', 'Mayotte', '269', NULL, NULL),
('142', 'MX', 'Mexico', '52', NULL, NULL),
('143', 'FM', 'Micronesia', '691', NULL, NULL),
('144', 'MD', 'Moldova', '373', NULL, NULL),
('145', 'MC', 'Monaco', '377', NULL, NULL),
('146', 'MN', 'Mongolia', '976', NULL, NULL),
('147', 'MS', 'Montserrat', '1664', NULL, NULL),
('148', 'MA', 'Morocco', '212', NULL, NULL),
('149', 'MZ', 'Mozambique', '258', NULL, NULL),
('150', 'MM', 'Myanmar', '95', NULL, NULL),
('151', 'NA', 'Namibia', '264', NULL, NULL),
('152', 'NR', 'Nauru', '674', NULL, NULL),
('153', 'NP', 'Nepal', '977', NULL, NULL),
('154', 'AN', 'Netherlands Antilles', '599', NULL, NULL),
('155', 'NL', 'Netherlands The', '31', NULL, NULL),
('156', 'NC', 'New Caledonia', '687', NULL, NULL),
('157', 'NZ', 'New Zealand', '64', NULL, NULL),
('158', 'NI', 'Nicaragua', '505', NULL, NULL),
('159', 'NE', 'Niger', '227', NULL, NULL),
('160', 'NG', 'Nigeria', '234', NULL, NULL),
('161', 'NU', 'Niue', '683', NULL, NULL),
('162', 'NF', 'Norfolk Island', '672', NULL, NULL),
('163', 'MP', 'Northern Mariana Islands', '1670', NULL, NULL),
('164', 'NO', 'Norway', '47', NULL, NULL),
('165', 'OM', 'Oman', '968', NULL, NULL),
('166', 'PK', 'Pakistan', '92', NULL, NULL),
('167', 'PW', 'Palau', '680', NULL, NULL),
('168', 'PS', 'Palestinian Territory Occupied', '970', NULL, NULL),
('169', 'PA', 'Panama', '507', NULL, NULL),
('170', 'PG', 'Papua new Guinea', '675', NULL, NULL),
('171', 'PY', 'Paraguay', '595', NULL, NULL),
('172', 'PE', 'Peru', '51', NULL, NULL),
('173', 'PH', 'Philippines', '63', NULL, NULL),
('174', 'PN', 'Pitcairn Island', '0', NULL, NULL),
('175', 'PL', 'Poland', '48', NULL, NULL),
('176', 'PT', 'Portugal', '351', NULL, NULL),
('177', 'PR', 'Puerto Rico', '1787', NULL, NULL),
('178', 'QA', 'Qatar', '974', NULL, NULL),
('179', 'RE', 'Reunion', '262', NULL, NULL),
('180', 'RO', 'Romania', '40', NULL, NULL),
('181', 'RU', 'Russia', '70', NULL, NULL),
('182', 'RW', 'Rwanda', '250', NULL, NULL),
('183', 'SH', 'Saint Helena', '290', NULL, NULL),
('184', 'KN', 'Saint Kitts And Nevis', '1869', NULL, NULL),
('185', 'LC', 'Saint Lucia', '1758', NULL, NULL),
('186', 'PM', 'Saint Pierre and Miquelon', '508', NULL, NULL),
('187', 'VC', 'Saint Vincent And The Grenadines', '1784', NULL, NULL),
('188', 'WS', 'Samoa', '684', NULL, NULL),
('189', 'SM', 'San Marino', '378', NULL, NULL),
('190', 'ST', 'Sao Tome and Principe', '239', NULL, NULL),
('191', 'SA', 'Saudi Arabia', '966', NULL, NULL),
('192', 'SN', 'Senegal', '221', NULL, NULL),
('193', 'RS', 'Serbia', '381', NULL, NULL),
('194', 'SC', 'Seychelles', '248', NULL, NULL),
('195', 'SL', 'Sierra Leone', '232', NULL, NULL),
('196', 'SG', 'Singapore', '65', NULL, NULL),
('197', 'SK', 'Slovakia', '421', NULL, NULL),
('198', 'SI', 'Slovenia', '386', NULL, NULL),
('199', 'XG', 'Smaller Territories of the UK', '44', NULL, NULL),
('200', 'SB', 'Solomon Islands', '677', NULL, NULL),
('201', 'SO', 'Somalia', '252', NULL, NULL),
('202', 'ZA', 'South Africa', '27', NULL, NULL),
('203', 'GS', 'South Georgia', '0', NULL, NULL),
('204', 'SS', 'South Sudan', '211', NULL, NULL),
('205', 'ES', 'Spain', '34', NULL, NULL),
('206', 'LK', 'Sri Lanka', '94', NULL, NULL),
('207', 'SD', 'Sudan', '249', NULL, NULL),
('208', 'SR', 'Suricountry_name', '597', NULL, NULL),
('209', 'SJ', 'Svalbard And Jan Mayen Islands', '47', NULL, NULL),
('210', 'SZ', 'Swaziland', '268', NULL, NULL),
('211', 'SE', 'Sweden', '46', NULL, NULL),
('212', 'CH', 'Switzerland', '41', NULL, NULL),
('213', 'SY', 'Syria', '963', NULL, NULL),
('214', 'TW', 'Taiwan', '886', NULL, NULL),
('215', 'TJ', 'Tajikistan', '992', NULL, NULL),
('216', 'TZ', 'Tanzania', '255', NULL, NULL),
('217', 'TH', 'Thailand', '66', NULL, NULL),
('218', 'TG', 'Togo', '228', NULL, NULL),
('219', 'TK', 'Tokelau', '690', NULL, NULL),
('220', 'TO', 'Tonga', '676', NULL, NULL),
('221', 'TT', 'Trincountry_idad And Tobago', '1868', NULL, NULL),
('222', 'TN', 'Tunisia', '216', NULL, NULL),
('223', 'TR', 'Turkey', '90', NULL, NULL),
('224', 'TM', 'Turkmenistan', '7370', NULL, NULL),
('225', 'TC', 'Turks And Caicos Islands', '1649', NULL, NULL),
('226', 'TV', 'Tuvalu', '688', NULL, NULL),
('227', 'UG', 'Uganda', '256', NULL, NULL),
('228', 'UA', 'Ukraine', '380', NULL, NULL),
('229', 'AE', 'United Arab Emirates', '971', NULL, NULL),
('230', 'GB', 'United Kingdom', '44', NULL, NULL),
('231', 'US', 'United States', '1', NULL, NULL),
('232', 'UM', 'United States Minor Outlying Islands', '1', NULL, NULL),
('233', 'UY', 'Uruguay', '598', NULL, NULL),
('234', 'UZ', 'Uzbekistan', '998', NULL, NULL),
('235', 'VU', 'Vanuatu', '678', NULL, NULL),
('236', 'VA', 'Vatican City State (Holy See)', '39', NULL, NULL),
('237', 'VE', 'Venezuela', '58', NULL, NULL),
('238', 'VN', 'Vietnam', '84', NULL, NULL),
('239', 'VG', 'Virgin Islands (British)', '1284', NULL, NULL),
('240', 'VI', 'Virgin Islands (US)', '1340', NULL, NULL),
('241', 'WF', 'Wallis And Futuna Islands', '681', NULL, NULL),
('242', 'EH', 'Western Sahara', '212', NULL, NULL),
('243', 'YE', 'Yemen', '967', NULL, NULL),
('244', 'YU', 'Yugoslavia', '38', NULL, NULL),
('245', 'ZM', 'Zambia', '260', NULL, NULL),
('246', 'ZW', 'Zimbabwe', '26', NULL, NULL);

-- Structure for table `financial_years`
CREATE TABLE `financial_years` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `year` VARCHAR(255) NOT NULL  ,
  `starting_date` DATE NULL  ,
  `ending_date` DATE NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `financial_years`
INSERT INTO `financial_years` VALUES
('1', '2025-2026', '2025-01-01', '2026-01-01', '2026-01-03 06:20:53', '2026-01-03 06:20:53');

-- Structure for table `master_settings`
CREATE TABLE `master_settings` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `master_title` VARCHAR(255) NULL  ,
  `master_value` TEXT NULL  ,
  `is_active` BIGINT NOT NULL DEFAULT '1' ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `master_settings`
INSERT INTO `master_settings` VALUES
('1', 'default_currency', 'Rp', '1', NULL, NULL),
('2', 'default_application_name', 'Sultan Laundry', '1', NULL, NULL),
('3', 'default_phone_number', '123456', '1', NULL, NULL),
('4', 'default_tax_percentage', '1', '1', NULL, NULL),
('5', 'default_state', 'DKI Jakarta', '1', NULL, NULL),
('6', 'default_city', 'Jakarta Timur', '1', NULL, NULL),
('7', 'default_country', 'ID', '1', NULL, NULL),
('8', 'default_zip_code', 'carjastiraihan@gmail.com', '1', NULL, NULL),
('9', 'default_address', 'Jl. Damai No.60, RT.9/RW.3, Pulo Gebang, Kec. Cakung.', '1', NULL, NULL),
('10', 'store_email', 'store@store.com', '1', NULL, NULL),
('11', 'store_tax_number', 'tax@tax', '1', NULL, NULL),
('12', 'default_printer', '4', '1', NULL, NULL),
('13', 'forget_password_enable', '1', '1', NULL, NULL),
('14', 'country_code', '62', '1', NULL, NULL),
('15', 'default_currency_alignment', '1', '1', NULL, NULL),
('16', 'sms_createorder', 'Hi <name> An Order #<order_number> was created and will be delivered on <delivery_date> Your Order Total is <total>.', '1', NULL, NULL),
('17', 'sms_statuschange', 'Hi <name> Your Order #<order_number> status has been changed to <status> on <current_time>', '1', NULL, NULL),
('18', 'default_financial_year', '1', '1', NULL, NULL),
('19', 'default_district', 'Cakung', '1', NULL, NULL),
('20', 'default_tax_mode', '1', '1', NULL, NULL),
('21', 'admin_panel_theme', 'magenta', '1', NULL, NULL),
('22', 'default_logo', '/logo/1767875215.jpg', '1', NULL, NULL),
('23', 'default_favicon', '/favicon/1767875215.jpg', '1', NULL, NULL);

-- Structure for table `expense_categories`
CREATE TABLE `expense_categories` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `expense_category_name` VARCHAR(255) NOT NULL  ,
  `expense_category_type` BIGINT NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  `created_by` BIGINT NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `expense_categories`
INSERT INTO `expense_categories` VALUES
('1', 'Gaji', '2', '2026-01-03 08:51:44', '2026-01-03 08:51:44', '1'),
('2', 'Listrik', '2', '2026-01-03 08:51:54', '2026-01-03 08:51:54', '1'),
('3', 'Air', '2', '2026-01-03 08:52:00', '2026-01-03 08:52:00', '1'),
('4', 'Sewa Ruko', '2', '2026-01-03 18:34:41', '2026-01-03 18:34:41', '1');

-- Structure for table `expenses`
CREATE TABLE `expenses` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `expense_date` DATE NOT NULL  ,
  `expense_category_id` BIGINT NULL  ,
  `expense_amount` DOUBLE NOT NULL  ,
  `payment_mode` BIGINT NULL  ,
  `tax_included` BIGINT NOT NULL  ,
  `tax_percentage` DOUBLE NULL  ,
  `note` TEXT NULL  ,
  `financial_year_id` BIGINT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  `created_by` BIGINT NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `expenses`
INSERT INTO `expenses` VALUES
('2', '2026-01-31', '1', '1500000', '1', '0', NULL, '', '1', '2026-01-03 18:35:34', '2026-01-03 18:35:34', '1');

-- Structure for table `customers`
CREATE TABLE `customers` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL  ,
  `email` VARCHAR(255) NULL  ,
  `phone` VARCHAR(255) NOT NULL  ,
  `tax_number` VARCHAR(255) NULL  ,
  `address` TEXT NULL  ,
  `is_active` BIGINT NOT NULL DEFAULT '0' ,
  `created_by` BIGINT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `customers`
INSERT INTO `customers` VALUES
('1', 'Siti', 'carjastiraihan@gmail.com', '08128383838', NULL, NULL, '1', NULL, '2026-01-03 06:30:36', '2026-01-03 06:30:36'),
('2', 'Marya', NULL, '089383829', NULL, NULL, '1', NULL, '2026-01-03 08:21:25', '2026-01-03 08:21:25'),
('3', 'tes', NULL, '081282694613', NULL, NULL, '1', NULL, '2026-01-17 05:24:01', '2026-01-17 05:24:01');

-- Structure for table `service_types`
CREATE TABLE `service_types` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `service_type_name` VARCHAR(255) NOT NULL  ,
  `is_active` BIGINT NOT NULL DEFAULT '1' ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `service_types`
INSERT INTO `service_types` VALUES
('1', '1 KG', '1', '2026-01-03 06:31:09', '2026-01-03 06:32:18'),
('2', '2 KG', '1', '2026-01-03 06:32:23', '2026-01-03 06:32:23'),
('3', '3 KG', '1', '2026-01-03 06:32:28', '2026-01-03 06:32:28'),
('4', '4 KG', '1', '2026-01-03 06:32:34', '2026-01-03 06:32:34'),
('5', '5 KG', '1', '2026-01-03 06:32:38', '2026-01-03 06:32:38'),
('6', 'Handuk (Satuan)', '1', '2026-01-06 22:51:36', '2026-01-06 22:51:36'),
('7', 'Bed Cover (Satuan)', '1', '2026-01-06 22:51:51', '2026-01-06 22:51:51');

-- Structure for table `services`
CREATE TABLE `services` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `service_name` VARCHAR(255) NOT NULL  ,
  `icon` VARCHAR(255) NULL  ,
  `is_active` BIGINT NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `services`
INSERT INTO `services` VALUES
('1', 'Kiloan Reguler', 'tshirt.png', '1', '2026-01-03 06:33:51', '2026-01-03 18:38:51'),
('2', 'Kiloan Express', 'tshirt.png', '1', '2026-01-03 18:38:41', '2026-01-03 18:38:41'),
('3', 'Handuk', 'bed-sheets.png', '1', '2026-01-06 22:53:16', '2026-01-06 22:53:16'),
('4', 'Bed Cover', 'bed-sheets.png', '1', '2026-01-06 22:53:50', '2026-01-06 22:53:50');

-- Structure for table `service_details`
CREATE TABLE `service_details` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `service_id` BIGINT NULL  ,
  `service_type_id` BIGINT NULL  ,
  `service_price` DOUBLE NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `service_details`
INSERT INTO `service_details` VALUES
('6', '2', '1', '8000', '2026-01-03 18:38:41', '2026-01-03 18:38:41'),
('7', '2', '2', '16000', '2026-01-03 18:38:41', '2026-01-03 18:38:41'),
('8', '2', '3', '24000', '2026-01-03 18:38:41', '2026-01-03 18:38:41'),
('9', '2', '4', '32000', '2026-01-03 18:38:41', '2026-01-03 18:38:41'),
('10', '2', '5', '40000', '2026-01-03 18:38:41', '2026-01-03 18:38:41'),
('11', '1', '1', '6000', '2026-01-03 18:38:51', '2026-01-03 18:38:51'),
('12', '1', '2', '12000', '2026-01-03 18:38:51', '2026-01-03 18:38:51'),
('13', '1', '3', '18000', '2026-01-03 18:38:51', '2026-01-03 18:38:51'),
('14', '1', '4', '24000', '2026-01-03 18:38:51', '2026-01-03 18:38:51'),
('15', '1', '5', '30000', '2026-01-03 18:38:51', '2026-01-03 18:38:51'),
('17', '3', '6', '5000', '2026-01-06 22:53:23', '2026-01-06 22:53:23'),
('19', '4', '7', '10000', '2026-01-06 22:54:28', '2026-01-06 22:54:28');

-- Structure for table `addons`
CREATE TABLE `addons` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `addon_name` VARCHAR(255) NOT NULL  ,
  `addon_price` VARCHAR(255) NOT NULL  ,
  `is_active` BIGINT NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `addons`
INSERT INTO `addons` VALUES
('1', 'Tas Reguler', '5000', '1', '2026-01-03 18:36:15', '2026-01-03 18:36:15'),
('2', 'Tas Besar', '10000', '1', '2026-01-03 18:36:31', '2026-01-03 18:36:31'),
('3', 'Parfum Premium', '1500', '1', '2026-01-06 22:52:39', '2026-01-06 22:52:39');

-- Structure for table `orders`
CREATE TABLE `orders` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `order_number` VARCHAR(255) NULL  ,
  `customer_id` BIGINT NULL  ,
  `customer_name` VARCHAR(255) NULL  ,
  `phone_number` VARCHAR(255) NULL  ,
  `order_date` DATETIME NULL  ,
  `delivery_date` DATETIME NULL  ,
  `sub_total` DOUBLE NOT NULL DEFAULT '0' ,
  `addon_total` DOUBLE NOT NULL DEFAULT '0' ,
  `discount` DOUBLE NOT NULL DEFAULT '0' ,
  `tax_percentage` DOUBLE NOT NULL DEFAULT '0' ,
  `tax_amount` DOUBLE NOT NULL DEFAULT '0' ,
  `total` DOUBLE NOT NULL DEFAULT '0' ,
  `note` TEXT NULL  ,
  `status` BIGINT NOT NULL DEFAULT '0' ,
  `order_type` BIGINT NULL  ,
  `created_by` BIGINT NULL  ,
  `financial_year_id` BIGINT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  `tax_type` BIGINT NULL  ,
  `taxable_amount` DOUBLE NOT NULL DEFAULT '0' ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `orders`
INSERT INTO `orders` VALUES
('1', 'ORD-0001', '1', 'Siti', '08128383838', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '14400', '0', '0', '1', '144', '14544', NULL, '3', '1', '1', '1', '2026-01-03 06:35:46', '2026-01-03 08:47:06', NULL, '0'),
('5', 'ORD-0005', '1', 'Siti', '08128383838', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '27600', '0', '0', '1', '276', '27876', NULL, '3', '1', '1', '1', '2026-01-03 08:04:12', '2026-01-03 08:46:59', NULL, '0'),
('6', 'ORD-0006', '2', 'Marya', '089383829', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '33600', '0', '0', '1', '336', '33936', 'payment nanti', '3', '1', '2', '1', '2026-01-03 08:22:08', '2026-01-03 08:28:32', NULL, '0'),
('7', 'ORD-0007', '2', 'Marya', '089383829', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '6000', '0', '0', '1', '60', '6060', NULL, '3', '1', '2', '1', '2026-01-03 08:23:21', '2026-01-03 08:26:19', NULL, '0'),
('8', 'ORD-0008', NULL, NULL, NULL, '2026-01-03 00:00:00', '2026-01-03 00:00:00', '31800', '0', '0', '1', '318', '32118', NULL, '3', '1', '2', '1', '2026-01-03 08:41:48', '2026-01-03 08:43:40', NULL, '0'),
('9', 'ORD-0009', '2', 'Marya', '089383829', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '40200', '0', '0', '1', '402', '40602', NULL, '3', '1', '2', '1', '2026-01-03 08:42:16', '2026-01-03 08:43:32', NULL, '0'),
('10', 'ORD-0010', '1', 'Siti', '08128383838', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '63000', '0', '0', '1', '630', '63630', NULL, '3', '1', '2', '1', '2026-01-03 08:42:50', '2026-01-03 08:43:25', NULL, '0'),
('11', 'ORD-0011', NULL, NULL, NULL, '2026-01-03 00:00:00', '2026-01-03 00:00:00', '44800', '0', '0', '1', '448', '45248', NULL, '3', '1', '1', '1', '2026-01-03 18:45:20', '2026-01-03 18:45:52', NULL, '0'),
('12', 'ORD-0012', '1', 'Siti', '08128383838', '2026-01-03 00:00:00', '2026-01-03 00:00:00', '27200', '0', '0', '1', '272', '27472', NULL, '3', '1', '1', '1', '2026-01-03 18:54:45', '2026-01-03 19:04:07', NULL, '0'),
('13', 'ORD-0013', NULL, NULL, NULL, '2026-01-03 00:00:00', '2026-01-03 00:00:00', '8000', '0', '0', '1', '80', '8080', NULL, '3', '1', '1', '1', '2026-01-03 19:36:27', '2026-01-03 19:38:43', NULL, '0'),
('14', 'ORD-0014', NULL, NULL, NULL, '2026-01-03 00:00:00', '2026-01-03 00:00:00', '18600', '0', '0', '1', '186', '18786', NULL, '3', '1', '1', '1', '2026-01-03 19:38:24', '2026-01-03 19:38:48', NULL, '0'),
('15', 'ORD-0015', NULL, NULL, NULL, '2026-01-06 00:00:00', '2026-01-06 00:00:00', '60400', '10000', '0', '1', '604', '61004', NULL, '3', '1', '1', '1', '2026-01-06 20:37:11', '2026-01-06 22:48:25', NULL, '0'),
('16', 'ORD-0016', '1', 'Siti', '08128383838', '2026-01-06 00:00:00', '2026-01-06 00:00:00', '78500', '11500', '0', '1', '785', '79285', NULL, '3', '1', '1', '1', '2026-01-06 22:55:37', '2026-01-06 23:02:49', NULL, '0'),
('17', 'ORD-0017', '1', 'Siti', '08128383838', '2026-01-07 00:00:00', '2026-01-07 00:00:00', '41600', '0', '0', '1', '416', '42016', NULL, '3', '1', '1', '1', '2026-01-07 18:02:00', '2026-01-14 04:43:04', NULL, '0'),
('18', 'ORD-0018', NULL, NULL, NULL, '2026-01-07 00:00:00', '2026-01-07 00:00:00', '89400', '0', '0', '1', '894', '90294', NULL, '3', '1', '1', '1', '2026-01-07 18:40:59', '2026-01-14 04:43:02', NULL, '0'),
('19', 'ORD-0019', NULL, NULL, NULL, '2026-01-08 00:00:00', '2026-01-09 00:00:00', '80000', '0', '0', '1', '800', '80800', NULL, '3', '1', '1', '1', '2026-01-07 18:43:33', '2026-01-14 04:43:01', NULL, '0'),
('20', 'ORD-0020', NULL, NULL, NULL, '2026-01-08 00:00:00', '2026-01-08 00:00:00', '67200', '0', '0', '1', '672', '67872', NULL, '3', '1', '1', '1', '2026-01-08 20:20:10', '2026-01-14 04:42:58', NULL, '0'),
('21', 'ORD-0021', NULL, NULL, NULL, '2026-01-14 00:00:00', '2026-01-14 00:00:00', '40000', '0', '0', '1', '400', '40400', NULL, '3', '1', '1', '1', '2026-01-14 02:56:38', '2026-01-14 04:42:57', NULL, '0'),
('22', 'ORD-0022', NULL, NULL, NULL, '2026-01-14 00:00:00', '2026-01-14 00:00:00', '77000', '0', '0', '1', '770', '77770', NULL, '3', '1', '1', '1', '2026-01-14 04:14:41', '2026-01-14 04:42:55', NULL, '0'),
('23', 'ORD-0023', NULL, NULL, NULL, '2026-01-14 00:00:00', '2026-01-14 00:00:00', '10000', '0', '0', '1', '100', '10100', NULL, '3', '1', '1', '1', '2026-01-14 04:23:17', '2026-01-14 04:42:53', NULL, '0'),
('24', 'ORD-0024', NULL, NULL, NULL, '2026-01-14 00:00:00', '2026-01-14 00:00:00', '12000', '0', '0', '1', '120', '12120', NULL, '3', '1', '1', '1', '2026-01-14 04:34:26', '2026-01-14 04:42:49', NULL, '0'),
('25', 'ORD-0025', NULL, NULL, NULL, '2026-01-14 00:00:00', '2026-01-14 00:00:00', '5000', '0', '0', '1', '50', '5050', NULL, '3', '1', '1', '1', '2026-01-14 04:35:15', '2026-01-14 04:45:58', NULL, '0'),
('26', 'ORD-0026', '1', 'Siti', '08128383838', '2026-01-14 00:00:00', '2026-01-14 00:00:00', '5000', '0', '0', '1', '50', '5050', NULL, '0', '1', '1', '1', '2026-01-14 05:12:24', '2026-01-14 05:12:24', NULL, '0'),
('27', 'ORD-0027', '1', 'Siti', '08128383838', '2026-01-14 00:00:00', '2026-01-14 00:00:00', '20800', '0', '0', '1', '208', '21008', NULL, '0', '1', '1', '1', '2026-01-14 15:30:00', '2026-01-14 15:30:00', NULL, '0'),
('28', 'ORD-0028', NULL, 'Walk-in Customer', NULL, '2026-01-16 00:00:00', '2026-01-16 00:00:00', '33600', '0', '0', '1', '336', '33936', NULL, '3', '1', '1', '1', '2026-01-16 16:49:03', '2026-01-18 01:51:48', NULL, '0'),
('29', 'ORD-0029', '1', 'Siti', '08128383838', '2026-01-18 00:00:00', '2026-01-18 00:00:00', '36000', '0', '0', '1', '360', '36360', NULL, '0', '1', '1', '1', '2026-01-18 01:39:41', '2026-01-18 01:39:41', NULL, '0'),
('30', 'ORD-0030', '1', 'Siti', '08128383838', '2026-01-18 00:00:00', '2026-01-18 00:00:00', '14400', '0', '0', '1', '144', '14544', NULL, '0', '1', '1', '1', '2026-01-18 18:18:56', '2026-01-18 18:18:56', NULL, '0');

-- Structure for table `order_details`
CREATE TABLE `order_details` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `order_id` BIGINT NOT NULL  ,
  `service_id` BIGINT NOT NULL  ,
  `service_name` VARCHAR(255) NULL  ,
  `service_price` DOUBLE NULL  ,
  `service_quantity` VARCHAR(255) NULL  ,
  `service_detail_total` DOUBLE NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  `color_code` TEXT NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `order_details`
INSERT INTO `order_details` VALUES
('1', '1', '1', '1 KG', '6000', '2.4', '14400', '2026-01-03 06:35:46', '2026-01-03 06:35:46', ''),
('5', '5', '1', '1 KG', '6000', '4.6', '27600', '2026-01-03 08:04:13', '2026-01-03 08:04:13', ''),
('6', '6', '1', '1 KG', '6000', '5.6', '33600', '2026-01-03 08:22:08', '2026-01-03 08:22:08', ''),
('7', '7', '1', '1 KG', '6000', '1', '6000', '2026-01-03 08:23:21', '2026-01-03 08:23:21', ''),
('8', '8', '1', '1 KG', '6000', '5.3', '31800', '2026-01-03 08:41:48', '2026-01-03 08:41:48', ''),
('9', '9', '1', '1 KG', '6000', '6.7', '40200', '2026-01-03 08:42:16', '2026-01-03 08:42:16', ''),
('10', '10', '1', '1 KG', '6000', '10.5', '63000', '2026-01-03 08:42:50', '2026-01-03 08:42:50', ''),
('11', '11', '2', '1 KG', '8000', '5.6', '44800', '2026-01-03 18:45:20', '2026-01-03 18:45:20', ''),
('12', '12', '2', '1 KG', '8000', '3.4', '27200', '2026-01-03 18:54:46', '2026-01-03 18:54:46', ''),
('13', '13', '2', '1 KG', '8000', '1', '8000', '2026-01-03 19:36:27', '2026-01-03 19:36:27', ''),
('14', '14', '1', '1 KG', '6000', '3.1', '18600', '2026-01-03 19:38:24', '2026-01-03 19:38:24', ''),
('15', '15', '2', '1 KG', '8000', '6.3', '50400', '2026-01-06 20:37:11', '2026-01-06 20:37:11', ''),
('16', '16', '2', '1 KG', '8000', '6.5', '52000', '2026-01-06 22:55:37', '2026-01-06 22:55:37', ''),
('17', '16', '3', 'Handuk (Satuan)', '5000', '1', '5000', '2026-01-06 22:55:37', '2026-01-06 22:55:37', ''),
('18', '16', '4', 'Bed Cover (Satuan)', '10000', '1', '10000', '2026-01-06 22:55:37', '2026-01-06 22:55:37', ''),
('19', '17', '2', '1 KG', '8000', '5.2', '41600', '2026-01-07 18:02:00', '2026-01-07 18:02:00', ''),
('20', '18', '4', 'Bed Cover (Satuan)', '10000', '2', '20000', '2026-01-07 18:40:59', '2026-01-07 18:40:59', ''),
('21', '18', '3', 'Handuk (Satuan)', '5000', '3', '15000', '2026-01-07 18:40:59', '2026-01-07 18:40:59', ''),
('22', '18', '2', '1 KG', '8000', '6.8', '54400', '2026-01-07 18:40:59', '2026-01-07 18:40:59', ''),
('23', '19', '2', '1 KG', '8000', '10', '80000', '2026-01-07 18:43:33', '2026-01-07 18:43:33', ''),
('24', '20', '2', '1 KG', '8000', '5.9', '47200', '2026-01-08 20:20:10', '2026-01-08 20:20:10', ''),
('25', '20', '4', 'Bed Cover (Satuan)', '10000', '1', '10000', '2026-01-08 20:20:10', '2026-01-08 20:20:10', ''),
('26', '20', '3', 'Handuk (Satuan)', '5000', '2', '10000', '2026-01-08 20:20:10', '2026-01-08 20:20:10', ''),
('27', '21', '4', 'Bed Cover (Satuan)', '10000', '1', '10000', '2026-01-14 02:56:38', '2026-01-14 02:56:38', ''),
('28', '21', '1', '1 KG', '6000', '5', '30000', '2026-01-14 02:56:38', '2026-01-14 02:56:38', ''),
('29', '22', '2', '1 KG', '8000', '2.6', '20800', '2026-01-14 04:14:41', '2026-01-14 04:14:41', ''),
('30', '22', '1', '1 KG', '6000', '2.3', '13800', '2026-01-14 04:14:41', '2026-01-14 04:14:41', ''),
('31', '22', '2', '1 KG', '8000', '5.3', '42400', '2026-01-14 04:14:41', '2026-01-14 04:14:41', ''),
('32', '23', '3', 'Handuk (Satuan)', '5000', '2', '10000', '2026-01-14 04:23:17', '2026-01-14 04:23:17', ''),
('33', '24', '1', '1 KG', '6000', '2', '12000', '2026-01-14 04:34:26', '2026-01-14 04:34:26', ''),
('34', '25', '3', 'Handuk (Satuan)', '5000', '1', '5000', '2026-01-14 04:35:15', '2026-01-14 04:35:15', ''),
('35', '26', '3', 'Handuk (Satuan)', '5000', '1', '5000', '2026-01-14 05:12:24', '2026-01-14 05:12:24', ''),
('36', '27', '2', '1 KG', '8000', '2.6', '20800', '2026-01-14 15:30:00', '2026-01-14 15:30:00', ''),
('37', '28', '1', '1 KG', '6000', '5.6', '33600', '2026-01-16 16:49:03', '2026-01-16 16:49:03', ''),
('38', '29', '2', '1 KG', '8000', '4.5', '36000', '2026-01-18 01:39:41', '2026-01-18 01:39:41', ''),
('39', '30', '1', '1 KG', '6000', '2.4', '14400', '2026-01-18 18:18:56', '2026-01-18 18:18:56', '');

-- Structure for table `payments`
CREATE TABLE `payments` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `payment_date` DATETIME NULL  ,
  `customer_id` BIGINT NULL  ,
  `customer_name` VARCHAR(255) NULL  ,
  `order_id` BIGINT NOT NULL  ,
  `received_amount` DOUBLE NOT NULL DEFAULT '0' ,
  `payment_type` BIGINT NOT NULL  ,
  `payment_note` TEXT NULL  ,
  `created_by` BIGINT NULL  ,
  `financial_year_id` BIGINT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `payments`
INSERT INTO `payments` VALUES
('1', '2026-01-03 00:00:00', '1', 'Siti', '1', '14544', '6', NULL, '1', '1', '2026-01-03 07:15:26', '2026-01-03 07:15:26'),
('8', '2026-01-03', '1', 'Siti', '5', '27876', '6', NULL, '1', '1', '2026-01-03 08:04:33', '2026-01-03 08:04:33'),
('9', '2026-01-03', '2', 'Marya', '7', '6060', '6', NULL, '2', '1', '2026-01-03 08:25:42', '2026-01-03 08:25:42'),
('10', '2026-01-03', '2', 'Marya', '6', '33936', '1', NULL, '2', '1', '2026-01-03 08:27:21', '2026-01-03 08:27:21'),
('11', '2026-01-03', NULL, NULL, '8', '32118', '6', NULL, '2', '1', '2026-01-03 08:41:48', '2026-01-03 08:41:48'),
('12', '2026-01-03', '1', 'Siti', '10', '63630', '1', NULL, '2', '1', '2026-01-03 08:42:50', '2026-01-03 08:42:50'),
('13', '2026-01-03', '2', 'Marya', '9', '40602', '6', NULL, '2', '1', '2026-01-03 08:43:19', '2026-01-03 08:43:19'),
('14', '2026-01-03', NULL, NULL, '11', '45248', '6', NULL, '1', '1', '2026-01-03 18:45:20', '2026-01-03 18:45:20'),
('15', '2026-01-03', NULL, NULL, '11', '0', '1', NULL, '1', '1', '2026-01-03 18:45:20', '2026-01-03 18:45:20'),
('16', '2026-01-03', '1', 'Siti', '12', '27472', '1', NULL, '1', '1', '2026-01-03 19:04:56', '2026-01-03 19:04:56'),
('17', '2026-01-03', NULL, NULL, '13', '8080', '1', NULL, '1', '1', '2026-01-03 19:36:27', '2026-01-03 19:36:27'),
('18', '2026-01-03', NULL, NULL, '14', '18786', '1', NULL, '1', '1', '2026-01-03 19:38:24', '2026-01-03 19:38:24'),
('19', '2026-01-06', NULL, NULL, '15', '61004', '1', NULL, '1', '1', '2026-01-06 20:37:11', '2026-01-06 20:37:11'),
('20', '2026-01-06', '1', 'Siti', '16', '79285', '6', NULL, '1', '1', '2026-01-06 22:55:37', '2026-01-06 22:55:37'),
('21', '2026-01-07', '1', 'Siti', '17', '42016', '6', NULL, '1', '1', '2026-01-07 18:02:00', '2026-01-07 18:02:00'),
('22', '2026-01-07', NULL, NULL, '18', '90294', '1', NULL, '1', '1', '2026-01-07 18:40:59', '2026-01-07 18:40:59'),
('23', '2026-01-08', NULL, NULL, '19', '80800', '6', NULL, '1', '1', '2026-01-07 18:43:33', '2026-01-07 18:43:33'),
('24', '2026-01-08', NULL, NULL, '20', '67872', '1', NULL, '1', '1', '2026-01-08 20:20:10', '2026-01-08 20:20:10'),
('25', '2026-01-14', NULL, NULL, '21', '40400', '1', NULL, '1', '1', '2026-01-14 02:56:38', '2026-01-14 02:56:38'),
('26', '2026-01-14', NULL, NULL, '22', '77770', '1', NULL, '1', '1', '2026-01-14 04:14:41', '2026-01-14 04:14:41'),
('27', '2026-01-14', NULL, NULL, '23', '10100', '1', NULL, '1', '1', '2026-01-14 04:23:17', '2026-01-14 04:23:17'),
('28', '2026-01-14', NULL, NULL, '24', '12120', '1', NULL, '1', '1', '2026-01-14 04:34:26', '2026-01-14 04:34:26'),
('29', '2026-01-14', NULL, NULL, '25', '5050', '1', NULL, '1', '1', '2026-01-14 04:35:15', '2026-01-14 04:35:15'),
('30', '2026-01-14', '1', 'Siti', '27', '21008', '6', NULL, '1', '1', '2026-01-14 15:30:00', '2026-01-14 15:30:00'),
('31', '2026-01-16', NULL, NULL, '28', '33936', '1', NULL, '1', '1', '2026-01-16 16:49:03', '2026-01-16 16:49:03'),
('32', '2026-01-18', '1', 'Siti', '29', '36360', '6', NULL, '1', '1', '2026-01-18 04:07:51', '2026-01-18 04:07:51');

-- Structure for table `translations`
CREATE TABLE `translations` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL  ,
  `data` TEXT NOT NULL  ,
  `is_active` BIGINT NULL  ,
  `default` BIGINT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  `is_rtl` BIGINT NOT NULL DEFAULT '0' ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Structure for table `order_addon_details`
CREATE TABLE `order_addon_details` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `order_id` BIGINT NOT NULL  ,
  `addon_name` VARCHAR(255) NOT NULL  ,
  `addon_price` VARCHAR(255) NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  `addon_id` BIGINT NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `order_addon_details`
INSERT INTO `order_addon_details` VALUES
('1', '15', 'Tas Besar', '10000', '2026-01-06 20:37:11', '2026-01-06 20:37:11', '2'),
('2', '16', 'Parfum Premium', '1500', '2026-01-06 22:55:37', '2026-01-06 22:55:37', '3'),
('3', '16', 'Tas Besar', '10000', '2026-01-06 22:55:37', '2026-01-06 22:55:37', '2');

-- Structure for table `permissions`
CREATE TABLE `permissions` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL  ,
  `display_name` VARCHAR(255) NULL  ,
  `category` VARCHAR(255) NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `permissions`
INSERT INTO `permissions` VALUES
('1', 'order_list', 'Order List', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('2', 'order_view', 'Order View', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('3', 'order_create', 'Order Create', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('4', 'order_edit', 'Order Edit', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('5', 'order_delete', 'Order Delete', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('6', 'order_print', 'Print Order', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('7', 'order_status_change', 'Change Order Status', 'Order', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('8', 'customer_list', 'Customer List', 'Customer', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('9', 'customer_view', 'Customer View', 'Customer', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('10', 'customer_create', 'Customer Create', 'Customer', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('11', 'customer_edit', 'Customer Edit', 'Customer', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('12', 'customer_delete', 'Customer Delete', 'Customer', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('13', 'service_type_list', 'Service Type List', 'Service Type', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('14', 'service_type_view', 'Service Type View', 'Service Type', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('15', 'service_type_create', 'Service Type Create', 'Service Type', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('16', 'service_type_edit', 'Service Type Edit', 'Service Type', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('17', 'service_type_delete', 'Service Type Delete', 'Service Type', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('18', 'service_list', 'Service List', 'Service', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('19', 'service_view', 'Service View', 'Service', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('20', 'service_create', 'Service Create', 'Service', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('21', 'service_edit', 'Service Edit', 'Service', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('22', 'service_delete', 'Service Delete', 'Service', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('23', 'addon_list', 'Addon List', 'Addon', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('24', 'addon_view', 'Addon View', 'Addon', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('25', 'addon_create', 'Addon Create', 'Addon', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('26', 'addon_edit', 'Addon Edit', 'Addon', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('27', 'addon_delete', 'Addon Delete', 'Addon', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('28', 'expense_list', 'Expense List', 'Expense', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('29', 'expense_view', 'Expense View', 'Expense', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('30', 'expense_create', 'Expense Create', 'Expense', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('31', 'expense_edit', 'Expense Edit', 'Expense', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('32', 'expense_delete', 'Expense Delete', 'Expense', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('33', 'expense_category_list', 'Expense Category List', 'Expense Category', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('34', 'expense_category_view', 'Expense Category View', 'Expense Category', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('35', 'expense_category_create', 'Expense Category Create', 'Expense Category', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('36', 'expense_category_edit', 'Expense Category Edit', 'Expense Category', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('37', 'expense_category_delete', 'Expense Category Delete', 'Expense Category', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('38', 'payment_list', 'Payment List', 'Payment', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('39', 'payment_view', 'Payment View', 'Payment', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('40', 'payment_create', 'Payment Create', 'Payment', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('41', 'payment_edit', 'Payment Edit', 'Payment', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('42', 'payment_delete', 'Payment Delete', 'Payment', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('43', 'report_download', 'Report Download', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('44', 'report_print', 'Report Print', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('45', 'report_daily', 'Daily Report', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('46', 'report_expense', 'Expense Report', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('47', 'report_order', 'Order Report', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('48', 'report_ledger', 'Ledger Report', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('49', 'report_tax', 'Tax Report', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('50', 'report_sales', 'Sales Report', 'Report', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('51', 'setting_view', 'Setting View', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('52', 'setting_file_tools', 'File Tools Settings', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('53', 'setting_financial_year', 'Financial Year Settings', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('54', 'setting_mail', 'Mail Settings', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('55', 'setting_sms', 'SMS Settings', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('56', 'setting_master', 'Master Settings', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('57', 'setting_theme', 'Theme Settings', 'Setting', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('58', 'user_list', 'User List', 'User', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('59', 'user_view', 'User View', 'User', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('60', 'user_create', 'User Create', 'User', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('61', 'user_edit', 'User Edit', 'User', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('62', 'user_delete', 'User Delete', 'User', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('63', 'role_list', 'Role List', 'Role', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('64', 'role_view', 'Role View', 'Role', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('65', 'role_create', 'Role Create', 'Role', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('66', 'role_edit', 'Role Edit', 'Role', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('67', 'role_delete', 'Role Delete', 'Role', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('68', 'translation_list', 'Translation List', 'Translation', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('69', 'translation_view', 'Translation View', 'Translation', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('70', 'translation_create', 'Translation Create', 'Translation', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('71', 'translation_edit', 'Translation Edit', 'Translation', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('72', 'translation_delete', 'Translation Delete', 'Translation', '2025-12-31 12:48:49', '2025-12-31 12:48:49'),
('73', 'report_monthly_summary', 'Monthly Summary', 'Report', '2026-01-03 09:56:56', '2026-01-03 09:56:56');

-- Structure for table `user_roles`
CREATE TABLE `user_roles` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL  ,
  `description` VARCHAR(255) NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `user_roles`
INSERT INTO `user_roles` VALUES
('1', 'Karyawan', NULL, '2026-01-03 08:18:55', '2026-01-03 08:18:55');

-- Structure for table `user_role_permissions`
CREATE TABLE `user_role_permissions` (
  `id` BIGINT NOT NULL  AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL  ,
  `permission_name` VARCHAR(255) NOT NULL  ,
  `role_id` BIGINT NOT NULL  ,
  `permission_id` BIGINT NOT NULL  ,
  `created_at` DATETIME NULL  ,
  `updated_at` DATETIME NULL  ,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `user_role_permissions`
INSERT INTO `user_role_permissions` VALUES
('31', 'Karyawan', 'order_list', '1', '1', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('32', 'Karyawan', 'order_view', '1', '2', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('33', 'Karyawan', 'order_create', '1', '3', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('34', 'Karyawan', 'order_edit', '1', '4', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('35', 'Karyawan', 'order_delete', '1', '5', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('36', 'Karyawan', 'order_print', '1', '6', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('37', 'Karyawan', 'order_status_change', '1', '7', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('38', 'Karyawan', 'customer_list', '1', '8', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('39', 'Karyawan', 'customer_view', '1', '9', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('40', 'Karyawan', 'customer_create', '1', '10', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('41', 'Karyawan', 'customer_edit', '1', '11', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('42', 'Karyawan', 'customer_delete', '1', '12', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('43', 'Karyawan', 'expense_list', '1', '28', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('44', 'Karyawan', 'expense_view', '1', '29', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('45', 'Karyawan', 'expense_create', '1', '30', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('46', 'Karyawan', 'expense_edit', '1', '31', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('47', 'Karyawan', 'expense_delete', '1', '32', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('48', 'Karyawan', 'expense_category_list', '1', '33', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('49', 'Karyawan', 'expense_category_view', '1', '34', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('50', 'Karyawan', 'expense_category_create', '1', '35', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('51', 'Karyawan', 'expense_category_edit', '1', '36', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('52', 'Karyawan', 'expense_category_delete', '1', '37', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('53', 'Karyawan', 'report_download', '1', '43', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('54', 'Karyawan', 'report_print', '1', '44', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('55', 'Karyawan', 'report_daily', '1', '45', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('56', 'Karyawan', 'report_expense', '1', '46', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('57', 'Karyawan', 'report_order', '1', '47', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('58', 'Karyawan', 'report_ledger', '1', '48', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('59', 'Karyawan', 'report_tax', '1', '49', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('60', 'Karyawan', 'report_sales', '1', '50', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('61', 'Karyawan', 'payment_list', '1', '38', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('62', 'Karyawan', 'payment_edit', '1', '41', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('63', 'Karyawan', 'payment_view', '1', '39', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('64', 'Karyawan', 'payment_delete', '1', '42', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('65', 'Karyawan', 'payment_create', '1', '40', '2026-01-03 08:24:15', '2026-01-03 08:24:15'),
('66', 'Karyawan', 'report_monthly_summary', '1', '73', '2026-01-03 09:56:57', '2026-01-03 09:56:57');

