-- language
-CREATE SEQUENCE "language_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;\r
-\r
+CREATE SEQUENCE "language_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
+
CREATE TABLE "language" (
"id" integer DEFAULT nextval('language_id_seq') NOT NULL,
"name" character varying(40) NOT NULL,
-- article type
-CREATE SEQUENCE "article_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;\r
-\r
+CREATE SEQUENCE "article_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
+
CREATE TABLE "article_type" (
"id" integer DEFAULT nextval('article_type_id_seq') NOT NULL,
"name" character varying(40) NOT NULL,
CONSTRAINT "article_type_pkey" PRIMARY KEY ("id")
-);\r
+);
--
-- TOC Entry ID 24 (OID 20183)
"address" character varying(80),
"phone" character varying(20),
"webdb_create" timestamp with time zone NOT NULL,
+ "webdb_lastchange" timestamp with time zone,
"is_published" boolean DEFAULT '1' NOT NULL,
"to_language" integer DEFAULT '0' NOT NULL,
"to_media" integer NOT NULL,
-- comment_status
-CREATE SEQUENCE "comment_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;\r
-\r
+CREATE SEQUENCE "comment_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
+
CREATE TABLE "comment_status" (
"id" integer DEFAULT nextval('comment_status_id_seq') NOT NULL,
"name" character varying(40) NOT NULL,
CONSTRAINT "comment_status_pkey" PRIMARY KEY ("id")
);
-\r
+
--
-- TOC Entry ID 33 (OID 20588)
CREATE UNIQUE INDEX "idx_comment_id" on "comment" using btree ( "id" "int4_ops" );
+CREATE TABLE "comment_x_media" (
+ "comment_id" integer,
+ "media_id" integer
+);
+
+CREATE UNIQUE INDEX idx_comment_media on comment_x_media (comment_id, media_id);
+CREATE UNIQUE INDEX idx_media_comment on comment_x_media (media_id, comment_id);