
CREATE TABLE topup_plans
(
id int NOT NULL AUTO_INCREMENT,
type varchar(255),
phone_no varchar(255),
amount varchar(255),
country_id bigint,
user_id bigint,
operator_type varchar(255),
status varchar(255),
`created_at` timestamp,
`updated_at` timestamp,
`deleted_at` timestamp,
PRIMARY KEY (id)
);


Date: 18-04-22
ALTER TABLE `topup_plans` ADD `payment_response` TEXT NULL AFTER `plan_id`;
ALTER TABLE `topup_plans` ADD `transaction_id` VARCHAR(255) NULL AFTER `payment_response`;

Date: 21-04-22
ALTER TABLE `topup_plans` ADD `coupon_id` bigint NULL AFTER `transaction_id`;
ALTER TABLE `topup_plans` ADD `coupon_amount` VARCHAR(255) NULL AFTER `coupon_id`;
ALTER TABLE `topup_plans` ADD `number_of_usage` bigint NULL AFTER `coupon_amount`;
