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

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 9173fdf5..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)