add documentation

assorted other fixes


git-svn-id: file:///home/lennart/svn/public/pgets/trunk@4 768266df-afd4-0310-94a7-d396c829e022

2 files changed, 23 insertions, 2 deletions

diff --git a/sql/Makefile.am b/sql/Makefile.am
new file mode 100644
index 0000000..acb7ee6
--- /dev/null
+++ b/sql/Makefile.am
@@ -0,0 +1,19 @@
+# $Id$
+
+# This file is part of pgets.
+#
+# pgets is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 2 of the License, or
+# (at your option) any later version.
+#
+# pgets is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+# General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with pgets; if not, write to the Free Software Foundation,
+# Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA.
+
+EXTRA_DIST = pgets-access.sql pgets.sql
diff --git a/sql/pgets-access.sql b/sql/pgets-access.sql
index e4507f5..3ecfa10 100644
--- a/sql/pgets-access.sql
+++ b/sql/pgets-access.sql
@@ -29,10 +29,12 @@ CREATE DATABASE pgets;
 
 -- Manage access rights
 
+-- A user for the transfer program with write access to the table
 DROP USER pgets_fill;
 CREATE USER pgets_fill PASSWORD 'mahatma';
+GRANT INSERT ON pgets_accounting TO pgets_fill;
+
+-- A user for the web frontend with read access to the table
 DROP USER pgets_web;
 CREATE USER pgets_web PASSWORD 'gandhi';
-
-GRANT INSERT ON pgets_accounting TO pgets_fill;
 GRANT SELECT ON pgets_accounting TO pgets_web;