21 lines
875 B
SQL
21 lines
875 B
SQL
DROP TABLE IF EXISTS subscription_plan;
|
|
|
|
-- DROP SEQUENCE IF EXISTS subscription_plan_subscription_plan_id_seq;
|
|
-- CREATE SEQUENCE subscription_plan_subscription_plan_id_seq;
|
|
|
|
|
|
CREATE TABLE "subscription_plan" (
|
|
"subscription_plan_id" int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, -- SERIAL PRIMARY KEY
|
|
"period" TEXT CHECK( period IN ('day','week','month','year') ) NOT NULL DEFAULT 'month',
|
|
"length" INT NOT NULL,
|
|
"cycle" INT NOT NULL,
|
|
"trial_period" TEXT CHECK( trial_period IN ('day','week','month','year') ) NOT NULL DEFAULT 'month',
|
|
"trial_length" INT NOT NULL,
|
|
"trial_cycle" INT NOT NULL,
|
|
"trial_status" smallint NOT NULL,
|
|
"status" smallint NOT NULL DEFAULT 0,
|
|
"sort_order" INT NOT NULL DEFAULT 0
|
|
-- PRIMARY KEY ("subscription_plan_id")
|
|
);
|
|
|
|
SELECT setval('subscription_plan_subscription_plan_id_seq', 5, true); -- last inserted id by sample data |