bygdis.fi

commit d7042bba9976ab8d615b49edd80df16c5a3c728f
parent 1d9d62795bb2b807abe69ae7baf49903b54ac58d
Author: rbckman <rob@tarina.org>
Date:   Tue, 27 Oct 2020 06:39:27 +0200

database update

Diffstat:
M
db/updatedb.sh
 | 
3
+++

1 file changed, 3 insertions(+), 0 deletions(-)
diff --git a/db/updatedb.sh b/db/updatedb.sh
@@ -1,4 +1,7 @@
 #!/bin/sh
 sqlite3 bygdis.db <<EOF
 ALTER TABLE bildadmin ADD COLUMN adminlevel INT;
+UPDATE bildadmin SET adminlevel=3;
+UPDATE bildadmin SET adminlevel=5 WHERE name="admin";
+UPDATE bildadmin SET adminlevel=2 WHERE name="byyssare";
 EOF