forgot to add the Jpeg entry to the media_type table..

[mir.git] / dbscripts / create_pg.sql

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 530591e..c893655 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -333,6 +333,8 @@ CREATE TABLE "uploaded_media" (
 CREATE TABLE "images" (
        "image_data" oid,
        "icon_data" oid,
+       "icon_is_produced" boolean DEFAULT '0' NOT NULL,
+       "icon_path" character varying(255),
        "year" character varying(40),
        "img_width" smallint,
        "img_height" smallint,
@@ -343,7 +345,7 @@ CREATE TABLE "images" (
        "icon_width" smallint,
        "icon_height" smallint
 )
-INHERITS ("uploaded_media");
+INHERITS ("media");
 
 --
 -- TOC Entry ID 29 (OID 29338)
@@ -359,10 +361,13 @@ CREATE TABLE "content" (
        "is_mail_sent" boolean DEFAULT '1' NOT NULL,
        "is_digest_sent" boolean DEFAULT '1' NOT NULL,
        "to_article_type" smallint DEFAULT '0' NOT NULL,
-       "to_content" integer
+       "to_content" integer,
+       "checksum" integer
 )
 INHERITS ("media");
 
+CREATE INDEX content_checksum_index ON content (checksum);
+
 --
 -- TOC Entry ID 30 (OID 29418)
 --