X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=c8936554fb00d72db39925414bd552ec48d8cdf2;hb=1bdfa2827063cec81a2520d2096ed019ebe4244d;hp=530591e848c98512c5df697dbe2be923f7315218;hpb=53a936ecab884cd854446b8a43656d2cecb6b9cc;p=mir.git

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 530591e8..c8936554 100755
--- 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)
 --