Commit Diff


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