Repository: marmotta Updated Branches: refs/heads/MARMOTTA-584 0fcaf95f7 -> e3f709f57
MARMOTTA-584: added migration h2 script to schema version 5 Project: http://git-wip-us.apache.org/repos/asf/marmotta/repo Commit: http://git-wip-us.apache.org/repos/asf/marmotta/commit/e3f709f5 Tree: http://git-wip-us.apache.org/repos/asf/marmotta/tree/e3f709f5 Diff: http://git-wip-us.apache.org/repos/asf/marmotta/diff/e3f709f5 Branch: refs/heads/MARMOTTA-584 Commit: e3f709f57fdb98da48d693ee727a3cb2ccf4b4e6 Parents: 0fcaf95 Author: Sergio Fernández <[email protected]> Authored: Fri Jul 1 16:30:25 2016 +0200 Committer: Sergio Fernández <[email protected]> Committed: Fri Jul 1 16:30:25 2016 +0200 ---------------------------------------------------------------------- .../apache/marmotta/kiwi/persistence/h2/create_base_tables.sql | 2 +- .../marmotta/kiwi/persistence/h2/upgrade_base_003_004.sql | 2 +- .../marmotta/kiwi/persistence/h2/upgrade_base_004_005.sql | 5 ++--- 3 files changed, 4 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/marmotta/blob/e3f709f5/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql index a491af7..052287c 100644 --- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql +++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/create_base_tables.sql @@ -26,7 +26,7 @@ CREATE TABLE nodes ( lang varchar(5), createdAt timestamp NOT NULL DEFAULT now(), gvalue varchar(2147483647), - srid INT, + srid INT, PRIMARY KEY(id) ); http://git-wip-us.apache.org/repos/asf/marmotta/blob/e3f709f5/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_003_004.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_003_004.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_003_004.sql index f177498..0bf5151 100644 --- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_003_004.sql +++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_003_004.sql @@ -15,4 +15,4 @@ ALTER TABLE nodes ADD tzoffset int default 0 AFTER tvalue; -UPDATE METADATA SET mvalue = '3' WHERE mkey = 'version'; \ No newline at end of file +UPDATE METADATA SET mvalue = '4' WHERE mkey = 'version'; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/marmotta/blob/e3f709f5/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_004_005.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_004_005.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_004_005.sql index 452a238..5ad1963 100644 --- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_004_005.sql +++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/h2/upgrade_base_004_005.sql @@ -13,9 +13,8 @@ -- See the License for the specific language governing permissions and -- limitations under the License. -ALTER TABLE nodes ADD tzoffset int default 0 AFTER tvalue; - --- TODO: new two columns in nodes +ALTER TABLE nodes ADD gvalue varchar(2147483647) default NULL; +ALTER TABLE nodes ADD srid INT default NULL; UPDATE METADATA SET mvalue = '5' WHERE mkey = 'version'; INSERT INTO metadata(mkey,mvalue) VALUES ('updated',to_char(now(),'yyyy-MM-DD HH:mm:ss TZ') ); \ No newline at end of file
