diff options
| author | Jon Robertson <jonrober@stanford.edu> | 2013-10-16 22:35:34 -0700 |
|---|---|---|
| committer | Russ Allbery <rra@stanford.edu> | 2013-10-29 15:26:18 -0700 |
| commit | df8d76d414c4fbb2ea15499cc80395895064c7f7 (patch) | |
| tree | a792390174f245026efb86c3ea8d29ca5939ae90 /perl/sql | |
| parent | 27b99cd55e70c3efe082da4a106456d700662afc (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>
Diffstat (limited to 'perl/sql')
| -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; |