root/trunk/sql/README.txt
| Revision 1562, 0.8 kB (checked in by jmoore, 20 months ago) |
|---|
| Line | |
|---|---|
| 1 | |
| 2 | DATABASE SCRIPTS: |
| 3 | ================ |
| 4 | |
| 5 | The directories which are named after the supported database profiles (currently "psql") |
| 6 | contains scripts for creating fresh databases as well as for upgrading existing database. |
| 7 | |
| 8 | All scripts are of the form: |
| 9 | |
| 10 | CURRENTVERSION__CURRENTPATCH__TARGETVERSION__TARGETPATCH.sql |
| 11 | |
| 12 | with the exception of: |
| 13 | |
| 14 | CURRENTVERSION__0__bootstrap.sql Adds the "dbpatch" table to earlier databases |
| 15 | CURRENTVERSION__0__schema.sql Creates a fresh database |
| 16 | CURRENTVERSION__0__data.sql Adds OMERO-specific data to a fresh database |
| 17 | |
| 18 | |
| 19 | To create the update scripts, first cleaned version of each schema are compared |
| 20 | (where cleaned means simple formatting differences, random foreign key names, etc. |
| 21 | are removed). Then it is necessary to compare the values in all enumerations. |
Note: See TracBrowser
for help on using the browser.
