Powerful and easy to use cms to build websites, blogs or ecommerce stores.
HTML backendblogblog-engineblog-platformbloggingcmscontent-managementcontent-management-systemecommerceecommerce-platformno-codepage-builderphpphp-cmsphp7php8self-hostedshopping-cartweb-applicationwebsite-builder
DROP TABLE IF EXISTS `order_subscription`;
CREATE TABLE `order_subscription` (
`order_subscription_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`order_product_id` int(10) UNSIGNED NOT NULL,
`order_id` int(10) UNSIGNED NOT NULL,
`product_id` int(10) UNSIGNED NOT NULL,
`subscription_plan_id` int(10) UNSIGNED NOT NULL,
-- trial
`trial_price` decimal(10,4) NOT NULL,
`trial_tax` decimal(15,4) NOT NULL,
`trial_period` enum('day','week','month','year') NOT NULL,
`trial_cycle` smallint(6) NOT NULL,
`trial_length` smallint(6) NOT NULL,
`trial_left` smallint(6) NOT NULL,
`trial_status` tinyint NOT NULL,
`price` decimal(10,4) NOT NULL,
`tax` decimal(15,4) NOT NULL,
`period` enum('day','week','month','year') NOT NULL,
`cycle` smallint(6) NOT NULL,
`length` smallint(6) NOT NULL,
PRIMARY KEY (`order_subscription_id`),
KEY `order_id` (`order_id`),
KEY `product_id` (`product_id`),
KEY `subscription_plan_id` (`subscription_plan_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;