Dear Wiki user, You have subscribed to a wiki page or wiki category on "Marmotta Wiki" for change notification.
The "MARMOTTA-584/DeveloperDocumentation" page has been changed by Francisco Sumba: https://wiki.apache.org/marmotta/MARMOTTA-584/DeveloperDocumentation?action=diff&rev1=11&rev2=12 In this section, the process performed for updating the database to Version 5 and achieve POSTGIS support is described. - One of the most important processes of the project was the update of the scripts to the creation, update and delete of the database, wich are allowed in the resources packages of [[ http://marmotta.apache.org/kiwi/triplestore.html | kiwi-triplestore ]] module. At next, the changes over each script are detailed. + One of the most important processes of the project was the update of the scripts for the creation and update of the database, wich are allowed in the resources packages of [[ http://marmotta.apache.org/kiwi/triplestore.html | kiwi-triplestore ]] module. At next, the changes over each script are detailed. + '''''[[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql | create_base_tables.sql ]]''''' - '''''[[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/create_base_tables.sql || create_base_tables.sql]]''''' + This script was modified to upgrade the database into the '''version 5''', also, the script allows the creation of a new enumtype called "geom", which allows to identify the new geometry literals. In the table "nodes" a new column called "gvalue" was added, whose data type is Geometry. For the database supporting the spatial functions and the new Geometry data type is necessary the execution of the SQL Statement "CREATE EXTENSION POSTGIS". - This script was modified to upgrade the database into the '''version 5''', also, the script allows the creation of a new enumtype called "geom", which allows to identify the new geometry literals. In the table "nodes" a new column called "gvalue" was added, whose data type is Geometry. For the support of the spatial functions and the new Geometry data type is necessary the execution of the SQL Statement "CREATE EXTENSION POSTGIS". + '''''[[https://github.com/cuent/marmotta/blob/MARMOTTA-584/libraries/kiwi/kiwi-triplestore/src/main/resources/org/apache/marmotta/kiwi/persistence/pgsql/upgrade_base_004_005.sql | upgrade_base_004_005.sql ]]''''' + In case that Marmotta detects an older version of the database, this script allows the upgrade to version 5 with all the changes performed in create_base_tables.sql. - - -
