Changeset 1546 for branches/dbupdates
- Timestamp:
- 05/21/07 13:33:08 (18 months ago)
- Location:
- branches/dbupdates/sql
- Files:
-
- 4 added
- 1 modified
- 3 moved
-
VERSIONS.txt (added)
-
psql/OMERO3__0__TEST__1.sql (added)
-
psql/OMERO3__0__bootstrap.sql (moved) (moved from branches/dbupdates/sql/psql/3.0-TRUNK__0__bootstrap.sql) (2 diffs)
-
psql/OMERO3__4__data.sql (moved) (moved from branches/dbupdates/sql/psql/3.0-TRUNK__0__data.sql) (2 diffs)
-
psql/OMERO3__4__schema.sql (moved) (moved from branches/dbupdates/sql/psql/3.0-TRUNK__0__schema.sql)
-
psql/TEST__1__TEST__2.sql (added)
-
templates/bootstrap.sql (modified) (2 diffs)
-
templates/current.sql (added)
Legend:
- Unmodified
- Added
- Removed
-
branches/dbupdates/sql/psql/OMERO3__0__bootstrap.sql
r1525 r1546 1 1 begin; 2 3 create sequence seq_dbpatch; 2 4 3 5 create table dbpatch ( … … 23 25 unique (currentVersion, currentPatch, previousVersion, previousPatch); 24 26 25 create sequence seq_dbpatch; 26 27 insert into dbpatch (currentVersion, currentPatch, previousVersion, previousPatch, message, finished) 28 values ('3.0-TRUNK',0,'3.0-TRUNK',1, 'Bootstrapped', now()); 27 insert into dbpatch (currentVersion, currentPatch, previousVersion, previousPatch, message, finished) 28 values ('OMERO3', 0, 'OMERO3', 1, 'Bootstrapped', now()); 29 29 30 30 commit; -
branches/dbupdates/sql/psql/OMERO3__4__data.sql
r1526 r1546 21 21 -- 22 22 insert into dbpatch (currentVersion, currentPatch, previousVersion, previousPatch, message) 23 values (' 3.0-TRUNK', @DBPATCH@, '3.0-TRUNK',0, 'Initializing');23 values ('OMERO3', @DBPATCH@, 'OMERO3', 0, 'Initializing'); 24 24 25 25 -- … … 436 436 -- Here we have finished initializing this database. 437 437 update dbpatch set message = 'Database ready.', finished = now() 438 where currentVersion = '3.0-TRUNK' and439 currentPatch = @DBPATCH@ and440 previousVersion = ' 3.0-TRUNK' and441 previousPatch = 0;438 where currentVersion = 'OMERO3' and 439 currentPatch = @DBPATCH@ and 440 previousVersion = 'OMERO3' and 441 previousPatch = 0; 442 442 443 443 commit; -
branches/dbupdates/sql/templates/bootstrap.sql
r1525 r1546 10 10 -- 11 11 begin; 12 13 create sequence seq_dbpatch; 12 14 13 15 create table dbpatch ( … … 33 35 unique (currentVersion, currentPatch, previousVersion, previousPatch); 34 36 35 create sequence seq_dbpatch;36 37 37 insert into dbpatch (currentVersion, currentPatch, previousVersion, previousPatch, message, finished) 38 38 values ('@CURRENTVERSION@',0,'@CURRENTVERSION@',1, 'Bootstrapped', now());
