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 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,
"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