Page History
...
Wiki Markup PostgreSQL schemas are in _\[DSDOCDEV:dspace-source\]/dspace/etc/postgres/_
Wiki Markup Oracle schemas are in _\[DSDOCDEV:dspace-source\]/dspace/etc/oracle/_ The SQL (DDL) statements to create the tables for the current release, starting with an empty database, aer in _database_schema.sql_. The schema SQL file also creates the two required e-person groups (_Anonymous_ and _Administrator_) that are required for the system to function properly.
Wiki Markup |
---|
Also in _\[DSDOCDEV:dspace-source\]/dspace/etc/\[DSDOCDEV:database\]_ are various SQL files called _database_schema_1x_1y_. These contain the necessary SQL commands to update a live DSpace database from version 1._x_ to 1._y_. Note that this might not be the only part of an upgrade process: see Updating a DSpace Installation for details. |
...
Wiki Markup |
---|
Versions of the *_.sql{_}* files for Oracle are stored in _\[DSDOCDEV:dspace-source\]/dspace/etc/oracle_. These need to be copied over their PostgreSQL counterparts in _\[DSDOCDEV:dspace-source\]/dspace/etc_ prior to installation. |
...
- The fresh_install target loads up the initial contents of the Dublin Core type and bitstream format registries, as well as two entries in the epersongroup table for the system anonymous and administrator groups. Before you restore a raw backup of your database you will need to remove these, since they will already exist in your backup, possibly having been modified. For example, use:
Code Block DELETE FROM dctyperegistry; DELETE FROM bitstreamformatregistry; DELETE FROM epersongroup;
Wiki Markup After restoring a backup, you will need to reset the primary key generation sequences so that they do not produce already-used primary keys. Do this by executing the SQL in _\[DSDOCDEV:dspace-source\]/dspace/etc/update-sequences.sql_, for example with:
Future updates of DSpace may involve minor changes to the database schema. Specific instructions on how to update the schema whilst keeping live data will be included. The current schema also contains a few currently unused database columns, to be used for extra functionality in future releases. These unused columns have been added in advance to minimize the effort required to upgrade.Code Block psql -U dspace -f [dspace-source]/dspace/etc/update-sequences.sql
...
Wiki Markup |
---|
(Remember that _\[DSDOCDEV:dspace\]_ is a placeholder for the actual name of your DSpace install directory). |
...
Overview
Content Tools