[Demelerlab] Canada databases

[Alexey Savelyev]

Yes, that change is required for the dataDisk Pseudoabsorbance type to 
operate via GMP framework..

There is a PR#20 for SQL repo.

Alexey

On 10/25/25 13:54, Emre Brookes wrote:
> 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
>