summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/test/resources/data/schemaset.sql
diff options
context:
space:
mode:
authordanielhanrahan <daniel.hanrahan@est.tech>2023-05-04 22:34:41 +0100
committerdanielhanrahan <daniel.hanrahan@est.tech>2023-05-12 13:17:38 +0100
commitb740156bb50784fc461e2fbda13cd91e3f208b38 (patch)
treeb305c9c827ae7c323e40ac10975a34093e86fecc /cps-ri/src/test/resources/data/schemaset.sql
parent26a51754dd8aa9b467bcb442e6042f22af2ba001 (diff)
Remove dataspace_id column from Fragment table
- Remove dataspace_id column from fragment table and drop associated index, foreign key constraint and uniqueness constaint. - Add uniqueness constraint using only fragment xpath and anchor_id. - Add not-null constraint to anchor_id. - Update code and test data to remove references to dataspace_id. - Repopulate the dataspace_id in Liquibase rollback (verified with manual testing of update/rollback). Issue-ID: CPS-1677 Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech> Change-Id: I467cccba25ac5d884ec790064ca58150281b7e1d
Diffstat (limited to 'cps-ri/src/test/resources/data/schemaset.sql')
-rw-r--r--cps-ri/src/test/resources/data/schemaset.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/cps-ri/src/test/resources/data/schemaset.sql b/cps-ri/src/test/resources/data/schemaset.sql
index ad611664b8..e5bf63b701 100644
--- a/cps-ri/src/test/resources/data/schemaset.sql
+++ b/cps-ri/src/test/resources/data/schemaset.sql
@@ -1,7 +1,7 @@
/*
============LICENSE_START=======================================================
Copyright (C) 2020-2021 Pantheon.tech
- Modifications Copyright (C) 2020-2022 Nordix Foundation.
+ Modifications Copyright (C) 2020-2023 Nordix Foundation.
Modifications Copyright (C) 2020-2021 Bell Canada.
================================================================================
Licensed under the Apache License, Version 2.0 (the "License");
@@ -53,5 +53,5 @@ INSERT INTO ANCHOR (ID, NAME, DATASPACE_ID, SCHEMA_SET_ID) VALUES -- anchors for
(6002, 'ANCHOR2', 1001, 2101),
(6003, 'ANCHOR3', 1001, 2005);
-INSERT INTO FRAGMENT (ID, XPATH, ANCHOR_ID, DATASPACE_ID) VALUES
- (7001, '/XPATH', 6001, 1001); \ No newline at end of file
+INSERT INTO FRAGMENT (ID, XPATH, ANCHOR_ID) VALUES
+ (7001, '/XPATH', 6001);