Changeset 1583 for trunk/sql/psql/OMERO3__1__OMERO3__4__C_enums.sql
- Timestamp:
- 06/03/07 20:39:44 (18 months ago)
- Files:
-
- 1 modified
-
trunk/sql/psql/OMERO3__1__OMERO3__4__C_enums.sql (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/psql/OMERO3__1__OMERO3__4__C_enums.sql
r1562 r1583 1 1 begin; 2 3 -- Calculated by hand 2 4 3 5 insert into binning (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_binning'),-35,0,0,0,'8x8'; … … 33 35 insert into jobstatus (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_jobstatus'),-35,0,0,0,'Error'; 34 36 35 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,' lasermediumeFl';36 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,' lasermediumeCl';37 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,' lasermediumeBr';38 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,' lasermediume';37 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,'XeFl'; 38 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,'XeCl'; 39 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,'XeBr'; 40 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,'Xe'; 39 41 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,'Rhodamine-5G'; 40 42 insert into lasermedium (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_lasermedium'),-35,0,0,0,'N'; … … 73 75 insert into photometricinterpretation (id,permissions,owner_id,group_id,creation_id,value) select nextval('seq_photometricinterpretation'),-35,0,0,0,'ColorMap'; 74 76 77 alter table dbpatch add constraint unique_dbpatch unique (currentVersion, currentPatch, previousVersion, previousPatch); 78 alter table dbpatch alter id set default nextval('seq_dbpatch'), 79 alter permissions set default -35, 80 alter message set default 'Updating'; 81 update dbpatch set message = 'Updated.', finished = now() 82 where currentVersion = 'OMERO3' and 83 currentPatch = 4 and 84 previousVersion = 'OMERO3' and 85 previousPatch = 1; 75 86 commit;
