--
-- Selected TOC Entries:
--
-\connect - postgres
--
-- TOC Entry ID 2 (OID 19796)
--
--
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" );