Skip to content

armgit / Vvveb

Public Imported from GitHub
0

Powerful and easy to use cms to build websites, blogs or ecommerce stores.

705 B
Raw Blame
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");