added new metadata value to keep track when the schema has been updated Project: http://git-wip-us.apache.org/repos/asf/marmotta/repo Commit: http://git-wip-us.apache.org/repos/asf/marmotta/commit/206a01a1 Tree: http://git-wip-us.apache.org/repos/asf/marmotta/tree/206a01a1 Diff: http://git-wip-us.apache.org/repos/asf/marmotta/diff/206a01a1
Branch: refs/heads/MARMOTTA-584 Commit: 206a01a179db37ef29720ed32c5f07ce29d0b180 Parents: d27424a Author: Sergio Fernández <[email protected]> Authored: Thu Aug 20 11:50:05 2015 +0200 Committer: Sergio Fernández <[email protected]> Committed: Thu Aug 20 11:50:05 2015 +0200 ---------------------------------------------------------------------- .../marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/marmotta/blob/206a01a1/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql ---------------------------------------------------------------------- diff --git a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql index 00d184d..75cc875 100644 --- a/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql +++ b/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql @@ -37,4 +37,5 @@ CREATE EXTENSION IF NOT EXISTS POSTGIS; --adding geometry colum ALTER TABLE nodes ADD COLUMN gvalue geometry; -UPDATE METADATA SET mvalue = '5' WHERE mkey = 'version'; \ No newline at end of file +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') );
