Skip to content

armgit / Vvveb

Public Imported from GitHub
0

Powerful and easy to use cms to build websites, blogs or ecommerce stores.

1.0 KB
Raw Blame
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;