reverse change from 2 minutes ago.

[mir.git] / dbscripts / create_pg.sql

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 997dfcd..c0a3805 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -1,7 +1,6 @@
 --
 -- Selected TOC Entries:
 --
-\connect - postgres
 --
 -- TOC Entry ID 2 (OID 19796)
 --
@@ -439,7 +438,6 @@ CREATE TABLE "links_imcs" (
 --
 
 CREATE TABLE "audio" (
-       "audio_data" oid,
        "kbits" smallint
 )
 INHERITS ("uploaded_media");
@@ -451,7 +449,6 @@ INHERITS ("uploaded_media");
 --
 
 CREATE TABLE "video" (
-       "video_data" oid
 )
 INHERITS ("uploaded_media");
 
@@ -530,6 +527,11 @@ CREATE  INDEX "comment_checksum_index" on "comment" using btree ( "checksum" "in
 
 CREATE  INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
 
+
+create index idx_comment_webdb_create on comment(webdb_create);
+
+
+
 --
 
 --