diff options
| author | Jon Robertson <jonrober@stanford.edu> | 2013-10-16 22:35:34 -0700 |
|---|---|---|
| committer | Russ Allbery <eagle@eyrie.org> | 2013-11-05 12:33:19 -0800 |
| commit | 01b4e4257f9bdd82ebf1f5b0cc0a07aae70a17f1 (patch) | |
| tree | 9666cb258f6101e5391e7bc3286527ead8bcdcec | |
| parent | f731dc6f63074ff4e304962ca8d2279d58756404 (diff) | |
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>
| -rw-r--r-- | perl/sql/Wallet-Schema-0.08-PostgreSQL.sql | 8 |
1 files changed, 4 insertions, 4 deletions
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; |