Changeset 1583 for trunk/sql/psql/OMERO3__1__OMERO3__4__A_hibtool.sql
- Timestamp:
- 06/03/07 20:39:44 (18 months ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
trunk/sql/psql/OMERO3__1__OMERO3__4__A_hibtool.sql
r1562 r1583 1 2 begin; 1 BEGIN; 2 3 -- Manually added items 4 alter table originalfile alter column size type int8; 5 6 -- Items calculated by <schemaupdate/> 3 7 create table binning (id int8 not null, owner_id int8 not null, group_id int8 not null, creation_id int8 not null, permissions int8 not null, external_id int8 unique, value varchar(255) not null unique, primary key (id)); 4 8 create table coating (id int8 not null, owner_id int8 not null, group_id int8 not null, creation_id int8 not null, permissions int8 not null, external_id int8 unique, value varchar(255) not null unique, primary key (id)); … … 47 51 create table projectannotation (id int8 not null, owner_id int8 not null, group_id int8 not null, creation_id int8 not null, update_id int8 not null, permissions int8 not null, external_id int8 unique, version int4 default 0, project int8 not null, content text not null, primary key (id)); 48 52 create table transmittancerange (id int8 not null, owner_id int8 not null, group_id int8 not null, creation_id int8 not null, update_id int8 not null, permissions int8 not null, external_id int8 unique, version int4 default 0, cutIn int4 not null, cutOut int4 not null, cutInTolerance int4, cutOutTolerance int4, transmittance float4 not null, primary key (id)); 49 50 53 alter table binning add constraint FKbinning_owner_id_experimenter foreign key (owner_id) references experimenter; 51 54 alter table binning add constraint FKbinning_creation_id_event foreign key (creation_id) references event; … … 127 130 alter table transmittancerange add constraint FKtransmittancerange_external_id_externalinfo foreign key (external_id) references externalinfo; 128 131 alter table transmittancerange add constraint FKtransmittancerange_group_id_experimentergroup foreign key (group_id) references experimentergroup; 129 130 132 create sequence seq_binning; 131 133 create sequence seq_coating; … … 143 145 create sequence seq_transmittancerange; 144 146 145 commit;147 COMMIT;
