From: Matteo Nastasi (mop) <nastasi@alternativeoutput.it>
Date: Mon, 14 Jan 2013 06:16:36 +0000 (+0100)
Subject: sql builder little enhancement and user table field rename
X-Git-Tag: v4.5.5~1
X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=commitdiff_plain;h=1f0962213dd12c7b36e0206f2477083a4f5c7ce0

sql builder little enhancement and user table field rename
---

diff --git a/sql/builder.sh b/sql/builder.sh
index 7cdcdf2..2c4bbfa 100755
--- a/sql/builder.sh
+++ b/sql/builder.sh
@@ -90,7 +90,7 @@ elif [ "$1" = "dumpall" ]; then
         pg_dump -h $DBHOST -U $DBUSER $DBBASE > $2
     fi
 elif [ "$1" = "add" ]; then
-    cat "$2" | psql $pg_args
+    cat "$2" | sqlexe $sht
 else
     echo " USAGE"
     echo "   ./builder create"
diff --git a/sql/sql.d/052-user-rename-tsusp.sql b/sql/sql.d/052-user-rename-tsusp.sql
new file mode 100644
index 0000000..e219983
--- /dev/null
+++ b/sql/sql.d/052-user-rename-tsusp.sql
@@ -0,0 +1 @@
+ALTER TABLE #PFX#users RENAME COLUMN tsusp TO lintm;