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 coupon;
-- DROP SEQUENCE IF EXISTS coupon_coupon_id_seq;
-- CREATE SEQUENCE coupon_coupon_id_seq;
CREATE TABLE coupon (
"coupon_id" int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, -- SERIAL PRIMARY KEY
"name" varchar(128) NOT NULL,
"code" varchar(20) NOT NULL,
"type" char(1) NOT NULL,
"discount" decimal(15,4) NOT NULL,
"total" decimal(15,4) NOT NULL,
"limit" int check ("limit" > 0) NOT NULL,
"limit_user" varchar(11) NOT NULL,
"logged_in" smallint NOT NULL,
"free_shipping" smallint NOT NULL,
"status" smallint NOT NULL,
"from_date" date,
"to_date" date,
"created_at" timestamp(0) NOT NULL DEFAULT now(),
"updated_at" timestamp(0) NOT NULL DEFAULT now()
-- PRIMARY KEY("coupon_id")
);
SELECT setval('coupon_coupon_id_seq', 3, true); -- last inserted id by sample data