adding db_patches and model_version to the database creation scripts.

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index a37a74f..e29ce4c 100755 (executable)
--- 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)
+);
 

diff --git a/dbscripts/createmirdb.sh b/dbscripts/createmirdb.sh
index 82f5f20..28efe16 100755 (executable)
--- a/dbscripts/createmirdb.sh
+++ b/dbscripts/createmirdb.sh
@@ -54,7 +54,8 @@ echo "grant all on video           to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on content         to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on comment         to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on media_folder    to $3;"   >> ${SCRIPT_FILE}
-                         
+echo "grant all on db_patches      to $3;"   >> ${SCRIPT_FILE}
+echo "grant all on model_version   to $3;"   >> ${SCRIPT_FILE}
 
 echo "grant all on media_id_seq    to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on media_folder_id_seq to $3;"   >> ${SCRIPT_FILE}
@@ -67,7 +68,7 @@ echo "grant all on media_type_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on comment_status_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on article_type_id_seq to $3;"   >> ${SCRIPT_FILE}
 echo "grant all on language_id_seq to $3;"   >> ${SCRIPT_FILE}
-
+echo "grant all on db_patches_id_seq to $3;"   >> ${SCRIPT_FILE}
 
 # execute the script
 psql -U $2 -f ${SCRIPT_FILE} -d template1