X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=4070d4612c8749b1a074e0ab88d65d0852c3c550;hb=04b4ac65a0b00082225ba81e116202246aec55b3;hp=272693902e8b3201c0232476c191b7cd3622a36f;hpb=213122e7c65211f549722f05aa8e0135f15af35c;p=mir.git

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index 27269390..4070d461 100755
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -222,8 +222,8 @@ CREATE UNIQUE INDEX "idx_uploaded_media_is_published" on "uploaded_media" using
 --
 
 CREATE TABLE "images" (
-	"image_data" oid,
-	"icon_data" oid,
+	"image_data" bytea,
+	"icon_data" bytea,
 	"year" character varying(40),
 	"img_width" smallint,
 	"img_height" smallint,
@@ -425,4 +425,23 @@ CREATE TABLE "filter_group" (
   "priority" integer
 );
 
+--
+-- db_patches
+--
+
+CREATE SEQUENCE "db_patches_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
+
+CREATE TABLE "db_patches" (
+  "id" integer DEFAULT nextval('db_patches_id_seq'::text) NOT NULL,
+  "date" date NOT NULL,
+  "description" text
+);
+
+--
+-- model_version
+--
+
+CREATE TABLE "model_version" (
+  "description"  character varying(24)
+);