X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fcreate_pg.sql;h=e29ce4cd64ffc5dfbdbda660990e7463955ae3e2;hb=2931c13b409d157e5206e64fd92ae0d9ef1120a2;hp=a37a74f72166e837c13a6407a2afc3428969de5d;hpb=22a2f276fcc3efb4ae0e2bda7621e607df315129;p=mir.git diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql index a37a74f7..e29ce4cd 100755 --- a/dbscripts/create_pg.sql +++ b/dbscripts/create_pg.sql @@ -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('filter_group_id_seq'::text) NOT NULL, + "date" date NOT NULL, + "description" text +); + +-- +-- model_version +-- + +CREATE TABLE "model_version" ( + "description" character varying(24) +);