From 1f0962213dd12c7b36e0206f2477083a4f5c7ce0 Mon Sep 17 00:00:00 2001
From: "Matteo Nastasi (mop)" <nastasi@alternativeoutput.it>
Date: Mon, 14 Jan 2013 07:16:36 +0100
Subject: [PATCH] sql builder little enhancement and user table field rename

---
 sql/builder.sh                      | 2 +-
 sql/sql.d/052-user-rename-tsusp.sql | 1 +
 2 files changed, 2 insertions(+), 1 deletion(-)
 create mode 100644 sql/sql.d/052-user-rename-tsusp.sql

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;
-- 
2.17.1