From df8d76d414c4fbb2ea15499cc80395895064c7f7 Mon Sep 17 00:00:00 2001
From: Jon Robertson <jonrober@stanford.edu>
Date: Wed, 16 Oct 2013 22:35:34 -0700
Subject: Changed postgres schema file to remove reference

The reference from object_history to the objects table needed to be
removed.  We still want the relationship in the DBIx::Class files, but
we don't want the relationship enforced as we want to keep history
entries for deleted objects.

Change-Id: Id927404b996fe171a8f5fc0747ccb0abddcbe1f2
Reviewed-on: https://gerrit.stanford.edu/1324
Reviewed-by: Russ Allbery <rra@stanford.edu>
Tested-by: Russ Allbery <rra@stanford.edu>
---
 perl/sql/Wallet-Schema-0.08-PostgreSQL.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'perl/sql/Wallet-Schema-0.08-PostgreSQL.sql')

diff --git a/perl/sql/Wallet-Schema-0.08-PostgreSQL.sql b/perl/sql/Wallet-Schema-0.08-PostgreSQL.sql
index a5de23d..296909f 100644
--- a/perl/sql/Wallet-Schema-0.08-PostgreSQL.sql
+++ b/perl/sql/Wallet-Schema-0.08-PostgreSQL.sql
@@ -1,4 +1,4 @@
--- 
+--
 -- Created by SQL::Translator::Producer::PostgreSQL
 -- Created on Fri Jan 25 14:12:02 2013
 --
@@ -23,7 +23,7 @@
 -- CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT,
 -- TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE
 -- SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
--- 
+--
 --
 -- Table: acl_history
 --
@@ -218,6 +218,6 @@ ALTER TABLE "objects" ADD FOREIGN KEY ("ob_acl_store")
 ALTER TABLE "objects" ADD FOREIGN KEY ("ob_type")
   REFERENCES "types" ("ty_name") DEFERRABLE;
 
-ALTER TABLE "object_history" ADD FOREIGN KEY ("oh_type", "oh_name")
-  REFERENCES "objects" ("ob_type", "ob_name") DEFERRABLE;
+--ALTER TABLE "object_history" ADD FOREIGN KEY ("oh_type", "oh_name")
+--  REFERENCES "objects" ("ob_type", "ob_name") DEFERRABLE;
 
-- 
cgit v1.2.3

