You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@marmotta.apache.org by wi...@apache.org on 2016/07/01 14:30:30 UTC
marmotta git commit: MARMOTTA-584: added migration h2 script to
schema version 5
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 <wi...@apache.org>
Authored: Fri Jul 1 16:30:25 2016 +0200
Committer: Sergio Fern�ndez <wi...@apache.org>
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