DROP TABLE IF EXISTS `order_subscription`;

CREATE TABLE `order_subscription` (
  `order_subscription_id`  INTEGER PRIMARY KEY AUTOINCREMENT,
  `order_product_id` INT NOT NULL,
  `order_id` INT NOT NULL,
  `product_id` INT NOT NULL,
  `subscription_plan_id` INT NOT NULL,
  `trial_price` decimal(10,4) NOT NULL,
  `trial_tax` decimal(15,4) NOT NULL,
  `trial_period` TEXT CHECK( trial_period IN ('day','week','month','year') ) NOT NULL DEFAULT 'month',
  `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` TEXT CHECK( period IN ('day','week','month','year') ) NOT NULL DEFAULT 'month',
  `cycle` smallint(6) NOT NULL,
  `length` smallint(6) NOT NULL
--  PRIMARY KEY (`order_subscription_id`),
--  KEY `order_id` (`order_id`)
);

CREATE INDEX `order_subscription_order_id` ON `order_subscription` (`order_id`);
CREATE INDEX `order_subscription_product_id` ON `order_subscription` (`product_id`);
CREATE INDEX `order_subscription_subscription_plan_id` ON `order_subscription` (`subscription_plan_id`);
