New upstream version 3.3.3+dfsg1.upstream/3.3.3+dfsg1

4 files changed, 537 insertions, 0 deletions

diff --git a/.github/workflows/lin_release.yml b/.github/workflows/lin_release.yml
new file mode 100644
index 0000000..b95453c
--- /dev/null
+++ b/.github/workflows/lin_release.yml
@@ -0,0 +1,167 @@
+env:
+    QT_VERSION: '5.15.2'
+    TCL_VERSION: '8.6'
+    SQLITE_VERSION: '3350400'
+    SQLITE_RELEASE_YEAR: '2021'
+    PORTABLE_DIR: ${{ github.workspace }}/output/portable/SQLiteStudio
+
+name: Linux release build
+
+on:
+    repository_dispatch:
+        types: [lin_release]
+
+jobs:
+    build:
+        runs-on: ubuntu-18.04
+
+        steps:
+            - name: Cache Qt
+              id: cache-qt
+              uses: actions/cache@v1
+              with:
+                path: ${{ github.workspace }}/../Qt
+                key: ${{ runner.os }}-Qt-${{ env.QT_VERSION }}-Linux-Cache
+                
+            - name: Install Qt
+              uses: jurplel/install-qt-action@v2
+              with:
+                cached: ${{ steps.cache-qt.outputs.cache-hit }}
+                version: ${{ env.QT_VERSION }}
+                host: 'linux'
+                dir: '${{ github.workspace }}/..'
+                modules: 'qtscript'
+                
+            - name: Clone repo
+              uses: actions/checkout@v2
+              with:
+                ref: ${{ github.event.client_payload.branch }}
+
+            - name: Install SQLite3
+              run: |
+                sudo rm -f /usr/lib/libsqlite* /usr/local/lib/libsqlite* /usr/include/sqlite* /usr/local/include/sqlite* /usr/lib/x86_64-linux-gnu/libsqlite*
+                wget http://sqlite.org/$SQLITE_RELEASE_YEAR/sqlite-amalgamation-$SQLITE_VERSION.zip
+                unzip sqlite-amalgamation-$SQLITE_VERSION.zip
+                cd sqlite-amalgamation-$SQLITE_VERSION
+                gcc sqlite3.c -lpthread -ldl -lm -Os -fpic -shared -o libsqlite3.so \
+                    -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
+                    -DSQLITE_ENABLE_DBSTAT_VTAB \
+                    -DSQLITE_ENABLE_BYTECODE_VTAB \
+                    -DSQLITE_ENABLE_COLUMN_METADATA \
+                    -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
+                    -DSQLITE_ENABLE_FTS3 \
+                    -DSQLITE_ENABLE_FTS4 \
+                    -DSQLITE_ENABLE_FTS5 \
+                    -DSQLITE_ENABLE_GEOPOLY \
+                    -DSQLITE_ENABLE_JSON1 \
+                    -DSQLITE_ENABLE_RTREE \
+                    -DSQLITE_ENABLE_MATH_FUNCTIONS
+                strip libsqlite3.so
+                sudo cp -P libsqlite3.so* /usr/local/lib/
+                sudo cp *.h /usr/local/include/
+
+            - name: Install Tcl
+              run: sudo apt-get install -qq libtcl$TCL_VERSION tcl$TCL_VERSION-dev
+              
+            - name: Install other tools/dependencies
+              run: |
+                sudo apt install libreadline-dev libncurses5-dev patchelf
+                echo "${{ github.workspace }}/../Qt/${{ env.QT_VERSION }}/gcc_64/bin" >> $GITHUB_PATH
+ 
+            - name: Prepare output dir
+              run: mkdir output output/build output/build/Plugins
+            
+            - name: Compile SQLiteStudio3
+              working-directory: output/build
+              run: |
+                qmake CONFIG+=portable ../../SQLiteStudio3
+                make -j 2
+            
+            - name: Compile Plugins
+              working-directory: output/build/Plugins
+              run: |
+                qmake CONFIG+=portable ../../../Plugins
+                make -j 2
+              
+            - name: Prepare portable dir
+              working-directory: output
+              run: |
+                mkdir portable
+                cp -R SQLiteStudio portable/
+
+            - name: Copy SQLite3 to portable dir
+              working-directory: ${{ env.PORTABLE_DIR }}
+              run: cp -P /usr/local/lib/libsqlite3.so* lib/
+
+            - name: Copy Qt to portable dir
+              working-directory: ${{ env.PORTABLE_DIR }}
+              run: |
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Core.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5DBus.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Concurrent.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Gui.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Network.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5PrintSupport.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Script.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Widgets.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Xml.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5Svg.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libQt5XcbQpa.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libicui18n.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libicuuc.so* lib/
+                cp -P ${{ env.Qt5_Dir }}/lib/libicudata.so* lib/
+
+            - name: Copy Qt plugins to portable dir
+              working-directory: ${{ env.PORTABLE_DIR }}
+              run: |
+                mkdir platforms imageformats iconengines printsupport platformthemes
+                cp -P ${{ env.Qt5_Dir }}/plugins/platforms/libqxcb.so platforms/libqxcb.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqgif.so imageformats/libqgif.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqicns.so imageformats/libqicns.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqico.so imageformats/libqico.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqjpeg.so imageformats/libqjpeg.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqsvg.so imageformats/libqsvg.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqtga.so imageformats/libqtga.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/imageformats/libqtiff.so imageformats/libqtiff.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/iconengines/libqsvgicon.so iconengines/libqsvgicon.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/printsupport/libcupsprintersupport.so printsupport/libcupsprintersupport.so
+                cp -P ${{ env.Qt5_Dir }}/plugins/platformthemes/libqgtk3.so platformthemes/libqgtk3.so
+
+            - name: Fix dependency paths
+              working-directory: ${{ env.PORTABLE_DIR }}
+              run: |
+                chrpath -k -r \$ORIGIN/../lib   platforms/*.so imageformats/*.so iconengines/*.so printsupport/*.so platformthemes/*.so plugins/*.so 2>&1 >/dev/null
+                chrpath -k -r \$ORIGIN          lib/libcoreSQLiteStudio.so lib/libguiSQLiteStudio.so 2>&1 >/dev/null
+                chrpath -k -r \$ORIGIN/lib      sqlitestudio 2>&1 >/dev/null
+                chrpath -k -r \$ORIGIN/lib      sqlitestudiocli 2>&1 >/dev/null
+                chrpath -l platforms/*.so imageformats/*.so iconengines/*.so printsupport/*.so platformthemes/*.so plugins/*.so
+                chrpath -l lib/libcoreSQLiteStudio.so lib/libguiSQLiteStudio.so
+                chrpath -l sqlitestudio
+                chrpath -l sqlitestudiocli
+
+            - name: Final preparations for packaging
+              working-directory: ${{ env.PORTABLE_DIR }}
+              run: |
+                cp `ldd sqlitestudiocli | grep readline | awk '{print $3}'` lib/
+                cp `ldd lib/libreadline* | grep tinfo | awk '{print $3}'` lib/
+                strip lib/*.so sqlitestudio sqlitestudiocli platforms/*.so imageformats/*.so iconengines/*.so printsupport/*.so platformthemes/*.so plugins/*.so
+                patchelf --set-rpath '$ORIGIN' lib/libreadline*
+
+            - name: Determine SQLiteStudio version
+              working-directory: ${{ env.PORTABLE_DIR }}
+              run: echo "SQLITESTUDIO_VERSION=$(./sqlitestudiocli --version | cut -f 2 -d ' ')" >> $GITHUB_ENV
+
+            - name: Assemble portable package
+              shell: bash
+              working-directory: ${{ env.PORTABLE_DIR }}/..
+              run: |
+                tar cf sqlitestudio-$SQLITESTUDIO_VERSION.tar SQLiteStudio
+                xz -z sqlitestudio-$SQLITESTUDIO_VERSION.tar
+                pwd
+                ls -l
+
+            - name: Upload package artifact
+              uses: actions/upload-artifact@v1
+              with:
+                name: sqlitestudio-${{ env.SQLITESTUDIO_VERSION }}.tar.xz
+                path: output/portable/sqlitestudio-${{ env.SQLITESTUDIO_VERSION }}.tar.xz
diff --git a/.github/workflows/mac_release.yml b/.github/workflows/mac_release.yml
new file mode 100644
index 0000000..109b31b
--- /dev/null
+++ b/.github/workflows/mac_release.yml
@@ -0,0 +1,106 @@
+env:
+    QT_VERSION: '5.15.2'
+    TCL_VERSION: '8.6'
+    SQLITE_VERSION: '3350400'
+    SQLITE_RELEASE_YEAR: '2021'
+    PORTABLE_DIR: ${{ github.workspace }}/output/portable/SQLiteStudio
+
+name: MaxOSX release build
+
+on:
+    repository_dispatch:
+        types: [mac_release]
+
+jobs:
+    build:
+        runs-on: macos-latest
+
+        steps:
+            # - name: Debug
+              # run: |
+                # ls -l /usr/local/
+                # ls -l /usr/local/include
+                # ls -l /usr/local/opt/
+                # ls -l /usr/local/opt/openssl/include/
+                # ls -l /usr/local/opt/expat/include
+
+            - name: Cache Qt
+              id: cache-qt
+              uses: actions/cache@v1
+              with:
+                path: ${{ github.workspace }}/../Qt
+                key: ${{ runner.os }}-Qt-${{ env.QT_VERSION }}-Mac-Cache
+                
+            - name: Install Qt
+              uses: jurplel/install-qt-action@v2
+              with:
+                cached: ${{ steps.cache-qt.outputs.cache-hit }}
+                version: ${{ env.QT_VERSION }}
+                host: 'mac'
+                dir: '${{ github.workspace }}/..'
+                modules: 'qtscript'
+                
+            - name: Clone repo
+              uses: actions/checkout@v2
+              with:
+                ref: ${{ github.event.client_payload.branch }}
+
+            - name: Install SQLite3
+              run: |
+                wget http://sqlite.org/$SQLITE_RELEASE_YEAR/sqlite-amalgamation-$SQLITE_VERSION.zip
+                unzip sqlite-amalgamation-$SQLITE_VERSION.zip
+                cd sqlite-amalgamation-$SQLITE_VERSION
+                gcc sqlite3.c -lpthread -ldl -lm -Os -fpic -shared -o libsqlite3.0.dylib \
+                    -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
+                    -DSQLITE_ENABLE_DBSTAT_VTAB \
+                    -DSQLITE_ENABLE_BYTECODE_VTAB \
+                    -DSQLITE_ENABLE_COLUMN_METADATA \
+                    -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
+                    -DSQLITE_ENABLE_FTS3 \
+                    -DSQLITE_ENABLE_FTS4 \
+                    -DSQLITE_ENABLE_FTS5 \
+                    -DSQLITE_ENABLE_GEOPOLY \
+                    -DSQLITE_ENABLE_JSON1 \
+                    -DSQLITE_ENABLE_RTREE \
+                    -DSQLITE_ENABLE_MATH_FUNCTIONS
+                sudo cp libsqlite3.0.dylib /usr/local/lib/
+                sudo ln -f -s /usr/local/lib/libsqlite3.0.dylib /usr/local/lib/libsqlite3.dylib
+                sudo cp *.h /usr/local/include/
+                echo "DYLD_LIBRARY_PATH=/usr/local/lib" >> $GITHUB_ENV
+
+            - name: Prepare deps
+              run: |
+                mkdir ../lib ../include
+                cp /usr/local/lib/libsqlite3* ../lib
+                cp /usr/local/include/sqlite3* ../include
+            
+            - name: Prepare output dir
+              run: mkdir output output/build output/build/Plugins
+            
+            - name: Compile SQLiteStudio3
+              working-directory: output/build
+              run: |
+                qmake CONFIG+=portable ../../SQLiteStudio3
+                make -j 2
+            
+            - name: Compile Plugins
+              working-directory: output/build/Plugins
+              run: |
+                qmake CONFIG+=portable ../../../Plugins
+                make -j 2
+              
+            - name: Build packages
+              working-directory: output/build
+              run: |
+                make pkg
+                
+            - name: Determine SQLiteStudio version
+              working-directory: output/SQLiteStudio
+              run: |
+                echo "SQLITESTUDIO_VERSION=$(SQLiteStudio.app/Contents/MacOS/sqlitestudiocli -v | awk '{print $2}')" >> $GITHUB_ENV
+
+            - name: Upload package artifact
+              uses: actions/upload-artifact@v1
+              with:
+                name: sqlitestudio-${{ env.SQLITESTUDIO_VERSION }}.dmg
+                path: output/SQLiteStudio/sqlitestudio-${{ env.SQLITESTUDIO_VERSION }}.dmg
diff --git a/.github/workflows/tests.yml b/.github/workflows/tests.yml
new file mode 100644
index 0000000..3453b57
--- /dev/null
+++ b/.github/workflows/tests.yml
@@ -0,0 +1,107 @@
+env:
+    TCL_VERSION: '8.6'
+    SQLITE_VERSION: '3350400'
+    SQLITE_RELEASE_YEAR: '2021'
+    PORTABLE_DIR: ${{ github.workspace }}/output/portable/SQLiteStudio
+
+name: Unit tests
+
+on:
+    push:
+        branches:
+            - master
+            - 3.2
+            - 3.3
+        paths:
+            - '**.cpp'
+            - '**.hpp'
+            - '**.c'
+            - '**.h'
+            - '**.pro'
+            - '**.pri'
+            - '**.ui'
+            - '**/tests.yml'
+
+jobs:
+    build:
+        runs-on: ubuntu-18.04
+
+        strategy:
+            matrix:
+                QT_VERSION: ['5.12.10', '5.15.2']
+
+        steps:
+            - name: Cache Qt
+              id: cache-qt
+              uses: actions/cache@v1
+              with:
+                path: ${{ github.workspace }}/../Qt
+                key: ${{ runner.os }}-Qt-${{ matrix.QT_VERSION }}-Linux-Cache
+
+            - name: Install Qt
+              uses: jurplel/install-qt-action@v2
+              with:
+                cached: ${{ steps.cache-qt.outputs.cache-hit }}
+                version: ${{ matrix.QT_VERSION }}
+                host: 'linux'
+                dir: '${{ github.workspace }}/..'
+                modules: 'qtscript'
+
+            - name: Clone repo
+              uses: actions/checkout@v2
+              with:
+                ref: ${{ env.GITHUB_REF }}
+
+            - name: Install SQLite3
+              run: |
+                sudo rm -f /usr/lib/libsqlite* /usr/local/lib/libsqlite* /usr/include/sqlite* /usr/local/include/sqlite* /usr/lib/x86_64-linux-gnu/libsqlite*
+                wget http://sqlite.org/$SQLITE_RELEASE_YEAR/sqlite-amalgamation-$SQLITE_VERSION.zip
+                unzip sqlite-amalgamation-$SQLITE_VERSION.zip
+                cd sqlite-amalgamation-$SQLITE_VERSION
+                gcc sqlite3.c -lpthread -ldl -lm -Os -fpic -shared -o libsqlite3.so \
+                    -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
+                    -DSQLITE_ENABLE_DBSTAT_VTAB \
+                    -DSQLITE_ENABLE_BYTECODE_VTAB \
+                    -DSQLITE_ENABLE_COLUMN_METADATA \
+                    -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
+                    -DSQLITE_ENABLE_FTS3 \
+                    -DSQLITE_ENABLE_FTS4 \
+                    -DSQLITE_ENABLE_FTS5 \
+                    -DSQLITE_ENABLE_GEOPOLY \
+                    -DSQLITE_ENABLE_JSON1 \
+                    -DSQLITE_ENABLE_RTREE \
+                    -DSQLITE_ENABLE_MATH_FUNCTIONS
+                strip libsqlite3.so
+                sudo cp -P libsqlite3.so* /usr/local/lib/
+                sudo cp *.h /usr/local/include/
+
+            - name: Install Tcl
+              run: sudo apt-get install -qq libtcl$TCL_VERSION tcl$TCL_VERSION-dev
+
+            - name: Install other tools/dependencies
+              run: |
+                sudo apt install libreadline-dev libncurses5-dev
+                echo "${{ github.workspace }}/../Qt/${{ matrix.QT_VERSION }}/gcc_64/bin" >> $GITHUB_PATH
+
+            - name: Prepare output dir
+              run: mkdir output output/build output/build/Plugins
+
+            - name: Compile SQLiteStudio3
+              working-directory: output/build
+              run: |
+                qmake CONFIG+=portable CONFIG+=debug DEFINES+=tests ../../SQLiteStudio3
+                make -j 2
+
+            - name: Compile Plugins
+              working-directory: output/build/Plugins
+              run: |
+                qmake CONFIG+=portable CONFIG+=debug DEFINES+=tests ../../../Plugins
+                make -j 2
+
+            - name: Run tests
+              working-directory: output/SQLiteStudio
+              run: |
+                sudo cp -P /usr/local/lib/libsqlite3.so* ./lib/
+                export LD_LIBRARY_PATH="./lib"
+                ldd tst_tablemodifiertest
+                for f in tst_*; do ./$f; done
diff --git a/.github/workflows/win_release.yml b/.github/workflows/win_release.yml
new file mode 100644
index 0000000..1a5307d
--- /dev/null
+++ b/.github/workflows/win_release.yml
@@ -0,0 +1,157 @@
+env:
+    QT_VERSION: '5.15.2'
+    SQLITE_VERSION: '3350400'
+    SQLITE_RELEASE_YEAR: '2021'
+    QT_ARCH: 'win64_mingw81'
+    MINGW_DIR: ../Qt/Tools/mingw810_64
+    QT_BIN_DIR: ../Qt/5.15.2/mingw81_64/bin
+    PORTABLE_DIR: output/portable/SQLiteStudio
+    MINGW_URL: https://download.qt.io/online/qtsdkrepository/windows_x86/desktop/tools_mingw/qt.tools.win64_mingw810/8.1.0-1-202004170606x86_64-8.1.0-release-posix-seh-rt_v6-rev0.7z
+    DEPS_URL: https://www.dropbox.com/s/2dpem7vy0ee19tu/win64_deps.zip?dl=1
+
+name: Windows release build
+
+on:
+    repository_dispatch:
+        types: [win_release]
+
+jobs:
+    build:
+        runs-on: windows-2019
+
+        steps:
+            - name: Cache Qt
+              id: cache-qt
+              uses: actions/cache@v1
+              with:
+                path: ${{ github.workspace }}\..\Qt
+                key: ${{ runner.os }}-${{ env.QT_VERSION }}-Qt-Cache
+                
+            - name: Install Qt
+              uses: jurplel/install-qt-action@v2
+              with:
+                cached: ${{ steps.cache-qt.outputs.cache-hit }}
+                version: ${{ env.QT_VERSION }}
+                host: 'windows'
+                arch: ${{ env.QT_ARCH }}
+                # jurplel/install-qt-action has a bug due to which we cannot use ${{ github.workspace }} for the "dir" property, because it will fail.
+                dir: 'D:/'
+                modules: 'qtscript'
+                setup-python: 'false'
+                
+            - name: Install mingw
+              if: steps.cache-qt.outputs.cache-hit != 'true'
+              shell: bash
+              run: |
+                curl -L ${{ env.MINGW_URL }} --output ../mingw.7z
+                7z x -o"../Qt" ../mingw.7z
+                echo "${{ env.MINGW_DIR }}/bin" >> $GITHUB_PATH
+ 
+            - name: Clone repo
+              uses: actions/checkout@v2
+              with:
+                ref: ${{ github.event.client_payload.branch }}
+
+            - name: Install dependencies
+              shell: bash
+              run: |
+                curl -L ${{ env.DEPS_URL }} --output ../win64_deps.zip
+                7z x -o".." ../win64_deps.zip
+                echo "../lib" >> $GITHUB_PATH
+ 
+            - name: Install SQLite3
+              shell: bash
+              run: |
+                cd ..
+                curl -L http://sqlite.org/$SQLITE_RELEASE_YEAR/sqlite-amalgamation-$SQLITE_VERSION.zip --output sqlite-amalgamation-$SQLITE_VERSION.zip
+                7z x sqlite-amalgamation-$SQLITE_VERSION.zip
+                cd sqlite-amalgamation-$SQLITE_VERSION
+                gcc.exe sqlite3.c -Os -fpic -DWIN64 -m64 -I. -shared -o sqlite3.dll \
+                    -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
+                    -DSQLITE_ENABLE_DBSTAT_VTAB \
+                    -DSQLITE_ENABLE_BYTECODE_VTAB \
+                    -DSQLITE_ENABLE_COLUMN_METADATA \
+                    -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
+                    -DSQLITE_ENABLE_FTS3 \
+                    -DSQLITE_ENABLE_FTS4 \
+                    -DSQLITE_ENABLE_FTS5 \
+                    -DSQLITE_ENABLE_GEOPOLY \
+                    -DSQLITE_ENABLE_JSON1 \
+                    -DSQLITE_ENABLE_RTREE \
+                    -DSQLITE_ENABLE_MATH_FUNCTIONS
+                cp -f sqlite3.dll ../lib/
+                cp -f sqlite3.h ../include/
+                cp -f sqlite3ext.h ../include/
+
+            - name: Prepare output dir
+              shell: bash
+              run: mkdir output output/build output/build/Plugins
+
+            - name: Compile SQLiteStudio3
+              working-directory: output/build
+              run: |
+                qmake.exe CONFIG+=portable ..\..\SQLiteStudio3
+                mingw32-make.exe -j 2
+            
+            - name: Compile Plugins
+              working-directory: output/build/Plugins
+              run: |
+                qmake.exe CONFIG+=portable ..\..\..\Plugins
+                mingw32-make.exe -j 2
+              
+            - name: Prepare portable dir
+              shell: bash
+              working-directory: output
+              run: |
+                mkdir portable
+                cp -R SQLiteStudio portable/
+
+            - name: Clean-up portable dir
+              shell: bash
+              run: |
+                cd ${{ env.PORTABLE_DIR }}
+                rm -f *.a
+                rm -f plugins/*.a
+                rm -f styles/*.a
+                echo "ABSOLUTE_PORTABLE_DIR=`pwd`" >> $GITHUB_ENV
+
+            - name: Prepare portable distro (Qt)
+              shell: bash
+              working-directory: ${{ env.Qt5_Dir }}
+              run: |
+                for f in Qt5Core Qt5Gui Qt5Network Qt5PrintSupport Qt5Script Qt5Svg Qt5Widgets Qt5Xml libgcc_s_seh-1 libstdc++-6 libwinpthread-1; do cp bin/$f.dll "$ABSOLUTE_PORTABLE_DIR"; done
+                cp bin/qt.conf "$ABSOLUTE_PORTABLE_DIR"
+                mkdir -p "$ABSOLUTE_PORTABLE_DIR/iconengines"
+                mkdir -p "$ABSOLUTE_PORTABLE_DIR/platforms"
+                mkdir -p "$ABSOLUTE_PORTABLE_DIR/printsupport"
+                mkdir -p "$ABSOLUTE_PORTABLE_DIR/styles"
+                mkdir -p "$ABSOLUTE_PORTABLE_DIR/imageformats"
+                cp plugins/iconengines/qsvgicon.dll "$ABSOLUTE_PORTABLE_DIR/iconengines"
+                cp plugins/platforms/qwindows.dll "$ABSOLUTE_PORTABLE_DIR/platforms"
+                cp plugins/styles/qwindowsvistastyle.dll "$ABSOLUTE_PORTABLE_DIR/styles"
+                cp plugins/printsupport/windowsprintersupport.dll "$ABSOLUTE_PORTABLE_DIR/printsupport"
+                for f in qgif qicns qico qjpeg qsvg qtga qtiff qwbmp; do cp plugins/imageformats/$f.dll "$ABSOLUTE_PORTABLE_DIR/imageformats"; done
+
+            - name: Prepare portable distro (Deps)
+              shell: bash
+              run: |
+                cd ../lib
+                cp *.dll "$ABSOLUTE_PORTABLE_DIR"
+
+            - name: Determine SQLiteStudio version
+              shell: bash
+              run: |
+                cd $ABSOLUTE_PORTABLE_DIR
+                echo "SQLITESTUDIO_VERSION=$(./sqlitestudiocli.exe --version | cut -f 2 -d ' ')" >> $GITHUB_ENV
+
+            - name: Assemble portable package
+              shell: bash
+              run: |
+                cd $ABSOLUTE_PORTABLE_DIR/..
+                7z a -r sqlitestudio-$SQLITESTUDIO_VERSION.zip SQLiteStudio
+
+            - name: Upload package artifact
+              uses: actions/upload-artifact@v1
+              with:
+                name: sqlitestudio-${{ env.SQLITESTUDIO_VERSION }}.zip
+                path: output/portable/sqlitestudio-${{ env.SQLITESTUDIO_VERSION }}.zip