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

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 7092165f..c8936554 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -326,12 +326,15 @@ CREATE TABLE "media" (
 
 CREATE TABLE "uploaded_media" (
 	"icon_is_produced" boolean DEFAULT '0' NOT NULL,
-	"icon_path" character varying(255)
+	"icon_path" character varying(255),
+    "size" integer
 ) INHERITS ("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,
@@ -342,7 +345,7 @@ CREATE TABLE "images" (
 	"icon_width" smallint,
 	"icon_height" smallint
 )
-INHERITS ("uploaded_media");
+INHERITS ("media");
 
 --
 -- TOC Entry ID 29 (OID 29338)
@@ -358,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)
 --