From 221f681dec865d1d67adc7cbd635ebdb4c458f6f Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Fri, 24 Oct 2008 15:16:48 +0000
Subject: [PATCH] upgrade_log table for tracking schema changes

git-svn-id: svn://svn.open-ils.org/ILS/trunk@10896 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/002.schema.config.sql | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 01badcc900..5fb1aa03f3 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -46,6 +46,11 @@ COMMENT ON SCHEMA config IS $$
  */
 $$;
 
+CREATE TABLE config.upgrade_log (
+    version         TEXT    PRIMARY KEY,
+    install_date    TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
+);
+
 CREATE TABLE config.bib_source (
 	id		SERIAL	PRIMARY KEY,
 	quality		INT	CHECK ( quality BETWEEN 0 AND 100 ),
-- 
2.11.0