--
-- Selected TOC Entries:
--
-\connect - postgres
--
-- TOC Entry ID 2 (OID 19796)
--
"name" character varying(30) NOT NULL
);
---
--- TOC Entry ID 18 (OID 20063)
---
--- Name: language Type: TABLE Owner: postgres
---
+-- language
+
+CREATE SEQUENCE "language_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;\r
+\r
CREATE TABLE "language" (
- "id" integer NOT NULL,
- "name" character varying(40) NOT NULL,
- "code" character varying(2) NOT NULL,
- Constraint "language_pkey" Primary Key ("id")
+ "id" integer DEFAULT nextval('language_id_seq') NOT NULL,
+ "name" character varying(40) NOT NULL,
+ "code" character varying(2) NOT NULL,
+ Constraint "language_pkey" Primary Key ("id")
);
--
"topic_id" integer NOT NULL
);
---
--- TOC Entry ID 23 (OID 20172)
---
--- Name: article_type Type: TABLE Owner: postgres
---
+-- article type
+CREATE SEQUENCE "article_type_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;\r
+\r
CREATE TABLE "article_type" (
- "id" integer NOT NULL,
- "name" character varying(20) NOT NULL
-);
+ "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)
"to_media" integer NOT NULL,
"to_comment_status" smallint,
"checksum" integer,
+ "is_html" boolean DEFAULT '0' NOT NULL,
Constraint "comment_pkey" Primary Key ("id")
);
"webdb_create" timestamp with time zone NOT NULL
);
---
--- TOC Entry ID 32 (OID 20577)
---
--- Name: comment_status Type: TABLE Owner: postgres
---
+-- comment_status
+
+CREATE SEQUENCE "comment_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;\r
+\r
CREATE TABLE "comment_status" (
- "id" smallint NOT NULL,
- "name" character varying(40) NOT NULL
+ "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 TABLE "audio" (
- "audio_data" oid,
"kbits" smallint
)
INHERITS ("uploaded_media");
--
CREATE TABLE "video" (
- "video_data" oid
)
INHERITS ("uploaded_media");
CREATE INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
+
+create index idx_comment_webdb_create on comment(webdb_create);
+
+
+
--
--
CREATE INDEX "idx_comment_tomedia_ispublished" on "comment" using btree ( "to_media" "int4_ops", "is_published" "bool_ops" );
+CREATE UNIQUE INDEX "idx_comment_id" on "comment" using btree ( "id" "int4_ops" );