ALTER TABLE `order_statuses` ADD `completed` INT NULL DEFAULT '0' AFTER `date_time`;

06-10-2024
ALTER TABLE `kyc` ADD `passport_picture` TEXT NULL AFTER `personal_picture_with_identity`, ADD `id_card_front` TEXT NULL AFTER `passport_picture`, ADD `id_card_back` TEXT NULL AFTER `id_card_front`;

14-02-2024
ALTER TABLE `settings` ADD `is_down_site` INT NULL AFTER `address`, ADD `maintenance_msg` TEXT NULL AFTER `is_down_site`;

22-02-2024
ALTER TABLE `topup_orders` ADD `reference` VARCHAR(255) NULL   AFTER `total`;

ALTER TABLE `visa_orders` ADD `reference` VARCHAR(255)  NULL AFTER `total`;

ALTER TABLE `passport_nicop_orders` ADD `reference` VARCHAR(255) NOT NULL AFTER `total`;

ALTER TABLE `utility_bill_orders` ADD `reference` VARCHAR(255) NOT NULL AFTER `total`;

26-02-2024 / 27
ALTER TABLE `orders` ADD `reference` VARCHAR(30) NOT NULL AFTER `total`;

ALTER TABLE `legalization_orders` ADD `reference` VARCHAR(255) NOT NULL AFTER `total`;

29/02/2024
ALTER TABLE `education_orders` ADD `reference_no` VARCHAR(40) NOT NULL AFTER `dated`, ADD `receiver_name` VARCHAR(255) NULL AFTER `reference_no`;

04-03-2024
ALTER TABLE `contents` ADD `about_image` VARCHAR NULL AFTER `about`;