commit - 098972ca906d1ab1819dcaee04c7145342dad23d
commit + 06f87bd405601a5be503a0d9d6277594aa619616
blob - 2ca3e331f5b9209f87d3459f3b60de9062d88ef7
blob + c9d569b0b171468bfb882f8cfca37b3f21916782
--- README.md
+++ README.md
# 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
```
+## Save branch
+
+```bash
+# cd /var/www/securitx
+# got ci -m "update production"
+```
+
## Start daemons
```bash
## 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
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
+#/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