All Versions
- DSpace 7.x (Current Release)
- DSpace 8.x (Unreleased)
- DSpace 6.x (EOL)
- DSpace 5.x (EOL)
- More Versions...
...
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. |
...
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: |
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). |
...