made images inherit from uploaded_media again..

[mir.git] / dbscripts / create_pg.sql

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 78ee413..ffcec45 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -333,8 +333,6 @@ 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,
@@ -345,7 +343,7 @@ CREATE TABLE "images" (
        "icon_width" smallint,
        "icon_height" smallint
 )
-INHERITS ("media");
+INHERITS ("uploaded_media");
 
 --
 -- TOC Entry ID 29 (OID 29338)