summaryrefslogtreecommitdiff
path: root/business/xtuple/init.sql
diff options
context:
space:
mode:
authorHeinz Wiesinger <pprkut@liwjatan.at>2010-05-11 22:53:16 +0200
committerDavid Somero <xgizzmo@slackbuilds.org>2010-05-11 22:53:16 +0200
commit4497f112f569fbfdaf035e186c8e8b8600ec5d47 (patch)
tree4f4e03bad685241c5b04bdd796b4205bf98330e9 /business/xtuple/init.sql
parentd69ddf532ea7808890cc38fb3a0ac588fd19b158 (diff)
downloadslackbuilds-4497f112f569fbfdaf035e186c8e8b8600ec5d47.tar.gz
business/xtuple: Added to 12.1 repository
Diffstat (limited to 'business/xtuple/init.sql')
-rw-r--r--business/xtuple/init.sql21
1 files changed, 21 insertions, 0 deletions
diff --git a/business/xtuple/init.sql b/business/xtuple/init.sql
new file mode 100644
index 0000000000..9076151b68
--- /dev/null
+++ b/business/xtuple/init.sql
@@ -0,0 +1,21 @@
+--
+-- This script creates the group openmfg and the user mfgadmin
+--
+
+--
+-- Create the openmfg group
+--
+CREATE GROUP openmfg;
+
+--
+-- Create the mfgadmin user with createdb and createuser
+-- permissions. Place the user in the openmfg group and
+-- set the password to the default of mfgadmin.
+--
+CREATE USER mfgadmin WITH PASSWORD 'mfgadmin'
+ CREATEDB CREATEUSER
+ IN GROUP openmfg;
+CREATE USER admin WITH PASSWORD 'admin'
+ CREATEDB CREATEUSER
+ IN GROUP openmfg;
+