From df8d76d414c4fbb2ea15499cc80395895064c7f7 Mon Sep 17 00:00:00 2001 From: Jon Robertson 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 Tested-by: Russ Allbery --- perl/sql/Wallet-Schema-0.08-PostgreSQL.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'perl/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