+INHERITS ("uploaded_media");
+
+--
+-- TOC Entry ID 36 (OID 37284)
+--
+-- Name: video Type: TABLE Owner: postgres
+--
+
+CREATE TABLE "video" (
+)
+INHERITS ("uploaded_media");
+
+--
+-- TOC Entry ID 37 (OID 45396)
+--
+-- Name: other_media Type: TABLE Owner: postgres
+--
+
+CREATE TABLE "other_media" (
+
+)
+INHERITS ("uploaded_media");
+
+--
+-- TOC Entry ID 40 (OID 20143)
+--
+-- Name: "idx_webdb_user_log_pas_is_admin" Type: INDEX Owner: postgres
+--
+
+CREATE INDEX "idx_webdb_user_log_pas_is_admin" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops", "is_admin" "bool_ops" );
+
+--
+-- TOC Entry ID 41 (OID 20143)
+--
+-- Name: "idx_webdb_user_log_pas" Type: INDEX Owner: postgres
+--
+
+CREATE INDEX "idx_webdb_user_log_pas" on "webdb_users" using btree ( "login" "varchar_ops", "password" "varchar_ops" );
+
+--
+-- TOC Entry ID 42 (OID 20161)
+--
+-- Name: "idx_content" Type: INDEX Owner: postgres
+--
+
+CREATE UNIQUE INDEX "idx_content" on "content_x_topic" using btree ( "content_id" "int4_ops", "topic_id" "int4_ops" );
+
+--
+-- TOC Entry ID 43 (OID 20161)
+--
+-- Name: "idx_topic" Type: INDEX Owner: postgres
+--
+
+CREATE UNIQUE INDEX "idx_topic" on "content_x_topic" using btree ( "topic_id" "int4_ops", "content_id" "int4_ops" );
+
+--
+-- TOC Entry ID 44 (OID 20183)
+--
+-- Name: "idx_topic_title" Type: INDEX Owner: postgres
+--
+
+CREATE INDEX "idx_topic_title" on "topic" using btree ( "title" "varchar_ops" );
+
+--
+-- TOC Entry ID 45 (OID 20183)
+--
+-- Name: "idx_topic_id" Type: INDEX Owner: postgres
+--
+
+CREATE UNIQUE INDEX "idx_topic_id" on "topic" using btree ( "id" "int4_ops" );
+
+--
+-- TOC Entry ID 38 (OID 20219)
+--
+-- Name: "comment_checksum_index" Type: INDEX Owner: postgres
+--
+
+CREATE INDEX "comment_checksum_index" on "comment" using btree ( "checksum" "int4_ops" );
+
+--
+-- TOC Entry ID 46 (OID 20219)
+--
+-- Name: "idx_comment_to_media" Type: INDEX Owner: postgres
+--
+