CREATE TABLE `subscribe_request` (
	`id` INT(10) NOT NULL AUTO_INCREMENT,
	`customer_id` INT(10) NOT NULL,
	`amount` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	`charge` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	`total` DECIMAL(20,2) NOT NULL DEFAULT '0.00',
	`gateway_id` TINYTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`is_paid` TINYINT(3) NOT NULL DEFAULT '0',
	`pay_time` INT(10) NOT NULL DEFAULT '0',
	`created_time` INT(10) NOT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;
CREATE TABLE `customer_subscribe` (
	`id` INT(10) NOT NULL AUTO_INCREMENT,
	`request_id` INT(10) NULL DEFAULT NULL,
	`customer_id` INT(10) NULL DEFAULT NULL,
	`amount` DECIMAL(20,2) NULL DEFAULT NULL,
	`start_date` INT(10) NULL DEFAULT NULL,
	`end_date` INT(10) NULL DEFAULT NULL,
	`created_on` INT(10) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `request_id` (`request_id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;