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 post_content;
CREATE TABLE post_content (
"post_id" int check ("post_id" > 0) NOT NULL,
"language_id" int check ("language_id" > 0) NOT NULL,
"name" varchar(191) NOT NULL,
"slug" varchar(191) NOT NULL,
"content" text NOT NULL,
"excerpt" text,
"meta_keywords" text NOT NULL DEFAULT '',
"meta_description" text NOT NULL DEFAULT '',
PRIMARY KEY ("post_id","language_id")
);
CREATE INDEX "post_content_slug" ON post_content ("slug");
CREATE INDEX "post_content_name" ON post_content USING gin (to_tsvector('english', name));
CREATE INDEX "post_content_content" ON post_content USING gin (to_tsvector('english', content));
-- FULLTEXT KEY "search" ("name","content");