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 tax_rule;
-- DROP SEQUENCE IF EXISTS tax_rule_tax_rule_id_seq;
-- CREATE SEQUENCE tax_rule_tax_rule_id_seq;
CREATE TABLE tax_rule (
"tax_rule_id" int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, -- SERIAL PRIMARY KEY
"tax_type_id" int check ("tax_type_id" > 0) NOT NULL,
"tax_rate_id" int check ("tax_rate_id" > 0) NOT NULL,
"based" varchar(10) NOT NULL,
"priority" int NOT NULL DEFAULT 1
-- PRIMARY KEY("tax_rule_id")
);
CREATE INDEX "tax_rule" ON tax_rule ("tax_type_id","tax_rate_id");
SELECT setval('tax_rule_tax_rule_id_seq', 2, true); -- last inserted id by sample data