use 1.42 iso 1.3

delcroip · delcroip · commit 764b9f67fb2f · 2021-09-24T13:31:15.000+02:00
diff --git a/.github/workflows/openmis-module-test.yml b/.github/workflows/openmis-module-test.yml
@@ -37,18 +37,18 @@ jobs:
             mkdir ./oldMain 
             wget https://raw.githubusercontent.com/openimis/database_ms_sqlserver/main/Empty%20databases/openIMIS_ONLINE.sql -O oldMain/openIMIS_ONLINE.sql
             wget https://raw.githubusercontent.com/openimis/database_ms_sqlserver/main/Demo%20database/openIMIS_demo_ONLINE.sql -O oldMain/openIMIS_demo_ONLINE.sql
-            mkdir ./1.30
-            wget https://raw.githubusercontent.com/openimis/database_ms_sqlserver/v1.3.0/Empty%20databases/openIMIS_ONLINE.sql -O 1.30/openIMIS_ONLINE.sql        
+            mkdir ./1.42
+            wget https://raw.githubusercontent.com/openimis/database_ms_sqlserver/v1.4.2/Empty%20databases/openIMIS_ONLINE.sql -O 1.30/openIMIS_ONLINE.sql        
             curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
             curl https://packages.microsoft.com/config/ubuntu/20.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list
             sudo apt-get update
             sudo ACCEPT_EULA=Y apt-get install -y  mssql-tools build-essential dialog apt-utils unixodbc-dev -y
             python -m pip install --upgrade pip
-      - name: DB migration 1.30
+      - name: DB migration 1.42
         run: |
             /opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'DROP DATABASE IF EXISTS imis'
             /opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -Q 'CREATE DATABASE imis'
-            /opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i 1.30/openIMIS_ONLINE.sql | grep . | uniq -c
+            /opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i 1.42/openIMIS_ONLINE.sql | grep . | uniq -c
             /opt/mssql-tools/bin/sqlcmd -S localhost,1433 -U SA -P $SA_PASSWORD -d imis -i "new/Migration script/openIMIS migration latest.sql" | grep . | uniq -c
         env:
             SA_PASSWORD: GitHub999
