Author: bleny Date: 2011-03-17 13:15:58 +0000 (Thu, 17 Mar 2011) New Revision: 1068 Log: update migration for obsDeb samplingplan Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java Modified: trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java =================================================================== --- trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2011-03-17 13:15:23 UTC (rev 1067) +++ trunk/wao-business/src/main/java/fr/ifremer/wao/PostgresMigrationCallback.java 2011-03-17 13:15:58 UTC (rev 1068) @@ -794,7 +794,7 @@ @Override protected void addCreationDateToContacts_3_0(List<String> queries) { - queries.add("ALTER TABLE Contact ADD creationDate TIMESTAMP WITHOUT TIME ZONE NOT NULL"); + queries.add("ALTER TABLE Contact ADD creationDate TIMESTAMP WITHOUT TIME ZONE"); queries.add("UPDATE Contact SET creationDate=topiaCreateDate"); } @@ -824,6 +824,16 @@ queries.add("ALTER TABLE SampleRow ADD observationUnit CHARACTER VARYING(255);"); queries.add("ALTER TABLE SampleRow ADD CONSTRAINT observationUnit_fkey FOREIGN KEY (observationUnit) REFERENCES TerrestrialDivision(topiaId);"); + queries.add("CREATE TABLE SampleRow_Observers (" + + "sampleRow character varying(255) NOT NULL," + + "observers character varying(255) NOT NULL," + + "CONSTRAINT observers_fkey FOREIGN KEY (observers) " + + "REFERENCES WaoUser (topiaid) MATCH SIMPLE " + + "ON UPDATE NO ACTION ON DELETE NO ACTION," + + "CONSTRAINT SampleRow_fkey FOREIGN KEY (SampleRow) " + + "REFERENCES SampleRow (topiaid) MATCH SIMPLE " + + "ON UPDATE NO ACTION ON DELETE NO ACTION);"); + } @Override