=================================== 17 Feb 2025 ================= ALTER TABLE `tbl_commercial_import` ADD `order_number` VARCHAR(20) NULL AFTER `import_date`; =================================== =================================== 18 Feb 2025 ================= ALTER TABLE `tbl_commercial_import` ADD `is_insured` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `tracking_id`, ADD `insurance_company` VARCHAR(255) NOT NULL DEFAULT '' AFTER `is_insured`, ADD `insurance_document` TEXT NULL DEFAULT NULL AFTER `insurance_company`; =================================== =================================== 20 Feb 2025 ================= ALTER TABLE `tbl_commercial_import` ADD `import_accounting` TEXT NULL DEFAULT NULL AFTER `contract_document`, ADD `customs_broker_invoice` TEXT NULL DEFAULT NULL AFTER `import_accounting`; =================================== 24 Feb 2025 ================= ALTER TABLE `tbl_courier` ADD `type` ENUM('0','1') NULL DEFAULT NULL COMMENT '0 = Local, 1 = International' AFTER `image`; =================================== 25 Feb 2025 ================= ALTER TABLE `tbl_commercial_import_expense` ADD `expanse_document` VARCHAR(255) NULL AFTER `amount_in_usd`; =================================== 27 Feb 2025 ================= ALTER TABLE `tbl_orders` ADD `freeze_status` ENUM('0','1') NOT NULL DEFAULT '1' COMMENT '\'0:Freeze,1:unFreeze\'' AFTER `shipping_provider`, ADD `freeze_notes` TEXT NULL DEFAULT NULL AFTER `freeze_status`; =================================== 28 Feb 2025 ================= ALTER TABLE `tbl_product_stock_log` CHANGE `status` `status` ENUM('0','1','2','3','4','5') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0:Admin stock in 1:Admin stock out 2:Supplier stock in 3:Supplier stock out 4:Customer stock in 5:Customer stock out'; ALTER TABLE `tbl_product_stock_log` ADD `customer_order_id` BIGINT NOT NULL DEFAULT '0' AFTER `price`; 28 Feb 2025 ================= ALTER TABLE `tbl_commercial_import` ADD `insurance_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes ' AFTER `insurance_document`; =================================== =================================== 03 Mar 2025 pending in main admin db =================================== ALTER TABLE `tbl_commercial_import` ADD `commercial_invoice_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes ' AFTER `insurance_document_required`; ALTER TABLE `tbl_commercial_import` ADD `package_list_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes ' AFTER `commercial_invoice_document_required`; ALTER TABLE `tbl_commercial_import` ADD `inspection_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `package_list_document_required`; ALTER TABLE `tbl_commercial_import` ADD `import_declaration_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `inspection_document_required`; ALTER TABLE `tbl_commercial_import` ADD `contract_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes ' AFTER `import_declaration_document_required`; ALTER TABLE `tbl_commercial_import` ADD `import_accounting_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `contract_document_required`; ALTER TABLE `tbl_commercial_import` ADD `customs_broker_invoice_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `import_accounting_document_required`; =================================== 04 Mar 2025 =================================== ALTER TABLE `tbl_product_stock_log` CHANGE `tbl_customer_order_id` `customer_order_id` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `tbl_product_stock_log` CHANGE `tbl_supplier_order_id` `supplier_order_id` INT(11) NOT NULL DEFAULT '0'; ALTER TABLE `tbl_product_stock_log` CHANGE `tbl_commercial_import_id` `commercial_import_id` INT(11) NOT NULL DEFAULT '0'; =================================== 05 Mar 2025 =================================== ALTER TABLE `tbl_product_stock_log` ADD `total` DOUBLE(9,2) NOT NULL DEFAULT '0.00' AFTER `price`; =================================== 07 Mar 2025 =================================== ALTER TABLE `tbl_error_log` CHANGE `error_code` `order_id` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL; ALTER TABLE `tbl_error_log` CHANGE `type` `type` ENUM('0','1','2','3','4') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0:global error 1:order; 2:Supplier Order; 3:Sku Error; 4:Rivhit Journal Update Error;'; =================================== ALTER TABLE `tbl_orders` ADD `payment_type` ENUM('0','1','2') NOT NULL DEFAULT '0' COMMENT 'Payment Types (0: credit card 1: bank transfer 2:Cash)' AFTER `final_total`; =================================== ALTER TABLE `tbl_general_setting` ADD `setting_category` BIGINT(20) NULL AFTER `setting_type`; ALTER TABLE `tbl_setting_category` ADD `slug` VARCHAR(255) NULL DEFAULT NULL AFTER `name`; 12 Mar 2025 =================================== ALTER TABLE `tbl_orders` CHANGE `billing_address_1` `billing_address` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `shipping_address_1` `shipping_address` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `tbl_orders` ADD `payment_method` ENUM('0','1','2') NOT NULL DEFAULT '0' COMMENT '0)Credit cart 1) Cash 2)Bank' AFTER `tracking_id`, ADD `payment_card_number` VARCHAR(20) NULL DEFAULT NULL AFTER `payment_method`; ALTER TABLE `tbl_orders` CHANGE `payment_method` `payment_method` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ============================================================================ 18 Mar 2025 ============================================================================ ALTER TABLE `tbl_document_library` ADD `text` LONGTEXT NULL DEFAULT NULL AFTER `parent_id`; ALTER TABLE `tbl_order_refunds` ADD `send_mail` ENUM('0','1') NOT NULL DEFAULT '0' AFTER `status`; ============================================================================= ============================================================================ 29 April 2025 ============================================================================ ALTER TABLE `tbl_commercial_import_expense` ADD `journal_id` VARCHAR(150) NULL DEFAULT NULL AFTER `expanse_document`; ============================================================================= ============================================================================ 04 July 2025 ============================================================================ ALTER TABLE `tbl_products` CHANGE `product_type` `product_type` ENUM('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0:regular products; 1:general products; 2:in development'; ============================================================================= ============================================================================ 07 July 2025 ============================================================================ ALTER TABLE `tbl_product_documents` ADD `test_id` VARCHAR(255) NULL DEFAULT NULL AFTER `name`; ALTER TABLE `tbl_commercial_import` ADD `delivery_order` TEXT NULL DEFAULT NULL AFTER `customs_broker_invoice`, ADD `importer_statement` TEXT NOT NULL AFTER `delivery_order`; ALTER TABLE `tbl_commercial_import` ADD `delivery_order_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `customs_broker_invoice_document_required`, ADD `importer_statement_document_required` ENUM('0','1') NOT NULL DEFAULT '0' COMMENT '0)No 1)Yes' AFTER `delivery_order_document_required`; ============================================================================= ALTER TABLE `tbl_commercial_import_items` ADD `order_number` VARCHAR(20) NULL DEFAULT NULL AFTER `commercial_import_id`; ============================================================================ 03 Sept 2025 ============================================================================ ALTER TABLE `tbl_product_stock_log` ADD `comments` TEXT NULL DEFAULT NULL AFTER `sale_price`; ============================================================================ 04 Sept 2025 ============================================================================ ALTER TABLE `tbl_products` CHANGE `product_type` `product_type` ENUM('0','1','2','3') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0:regular products; 1:general products; 2:in development; 3:service product'; ============================================================================ 15 Sept 2025 ============================================================================ ALTER TABLE `tbl_products` ADD `specification` TEXT NULL DEFAULT NULL AFTER `customs_tax`; ALTER TABLE `tbl_product_documents` ADD `url` TEXT NULL AFTER `file`; ALTER TABLE `tbl_products` ADD `supplier_id` INT(11) NOT NULL DEFAULT '0' AFTER `employee_id`;