[Demelerlab] Canada databases

[Emre Brookes]

CCH and AUCCANADA have been moved back to demeler9.
Users should be able to resume normal work, albeit on the correct 
servers now.

Alexey - noted a sql difference on CCH on NRCH.
uslims3_CCH : differences dataSource enum in in autoflow & autoflowHistory
<   `dataSource` 
enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') NOT NULL 
DEFAULT 'INSTRUMENT',
---
 >   `dataSource` 
enum('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance') 
NOT NULL DEFAULT 'INSTRUMENT',

I made the equivalent uncommitted local change on 
demeler9:~us3/lims/database/sql
$ git diff
diff --git a/us3.sql b/us3.sql
index 4706095..1f8be0a 100644
--- a/us3.sql
+++ b/us3.sql
@@ -117,7 +117,7 @@ CREATE  TABLE IF NOT EXISTS autoflow (
    devRecord   enum('NO', 'YES', 'Processed') NOT NULL,
    gmpReviewID int(11) NULL,
    expType enum('VELOCITY','ABDE') NOT NULL,
-  dataSource enum ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') 
NOT NULL DEFAULT 'INSTRUMENT',
+  dataSource enum 
('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance') 
NOT NULL DEFAULT 'INSTRUMENT',
    opticsFailedType varchar(300) NULL,

    PRIMARY KEY (ID) )
@@ -159,7 +159,7 @@ CREATE  TABLE IF NOT EXISTS autoflowHistory (
    devRecord   enum('NO', 'YES', 'Processed') NOT NULL,
    gmpReviewID int(11) NULL,
    expType enum('VELOCITY','ABDE') NOT NULL,
-  dataSource enum ('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance') 
NOT NULL DEFAULT 'INSTRUMENT',
+  dataSource enum 
('INSTRUMENT','dataDiskAUC','dataDiskAUC:Absorbance','dataDiskAUC:PseudoAbsorbance') 
NOT NULL DEFAULT 'INSTRUMENT',
    opticsFailedType varchar(300) NULL,

    PRIMARY KEY (ID) )




Borries Demeler wrote:
> Everyone:
> Now that we have our server back online thanks to Saeed's tireless 
> efforts, I want to move the databases back to our server in Canada and 
> disable the CCH and AUCCANADA databases on the NRCH server, so we can 
> move them  back to the demeler9 server. I asked Emre to do that, and 
> perhaps send us a short notice when he plans to do it. During this 
> time please do not use the server on either server until we have the 
> green light from Emre to use the server back in Canada again.
> Thanks! -Borries