commit 06f87bd405601a5be503a0d9d6277594aa619616 from: Tracey Emery date: Tue Apr 11 15:08:25 2023 UTC fix type on phone in members table commit - 098972ca906d1ab1819dcaee04c7145342dad23d commit + 06f87bd405601a5be503a0d9d6277594aa619616 blob - 2ca3e331f5b9209f87d3459f3b60de9062d88ef7 blob + c9d569b0b171468bfb882f8cfca37b3f21916782 --- README.md +++ README.md @@ -42,6 +42,7 @@ family caregiver, POA, etc. # got clone -a ssh://git@github.com/basepr1me/SecuritX.git # cd /var/www # got co /var/www/got/public/SecuritX.git securitx +# got br production ``` ## Edit global.php @@ -160,6 +161,13 @@ server "securitx.localhost" { ``` +## Save branch + +```bash +# cd /var/www/securitx +# got ci -m "update production" +``` + ## Start daemons ```bash @@ -182,11 +190,13 @@ and primary administrator. ## Updating SecuritX ```bash -# cd /var/www/got/public/SecuritX.git -# git fetch origin main:main # cd /var/www/securitx +# got up -b main +# got fetch +# got rb production # got up ``` +Then run any scripts available in data/upgrade for the version downloaded. # Author blob - c85f047e2462b5cc51364562d8ae5bb103a8508f blob + 0c106c3a418f2912c6ed47fb870bf6273a739a92 --- data/schema.sql +++ data/schema.sql @@ -17,7 +17,7 @@ CREATE TABLE members ( ip_address TEXT, twofa INTEGER, twofa_moddate INTEGER, - phone INTEGER, + phone TEXT, blocked INTEGER ); blob - /dev/null blob + 5f814b2e7e6ee132ff12971e83d825ae852e888a (mode 755) --- /dev/null +++ data/upgrade/sql_update_1.5.sh @@ -0,0 +1,8 @@ +#/bin/sh + +echo '.dump' | sqlite3 ../securitx.db > tmp.dump +sed -i 's/phone INTEGER/phone TEXT/g' tmp.dump +mv ../securitx.db ../securitx.db.bak +cat tmp.dump | sqlite3 ../securitx.db +rm tmp.dump +doas chown www:www ../securitx.db