diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/pgets-access.sql | 38 | ||||
-rw-r--r-- | sql/pgets.sql | 28 |
2 files changed, 66 insertions, 0 deletions
diff --git a/sql/pgets-access.sql b/sql/pgets-access.sql new file mode 100644 index 0000000..e4507f5 --- /dev/null +++ b/sql/pgets-access.sql @@ -0,0 +1,38 @@ +-- $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. + +-- Create database + +DROP DATABASE pgets; +CREATE DATABASE pgets; + +\c pgets + +-- Create tables + +\i pgets.sql + +-- Manage access rights + +DROP USER pgets_fill; +CREATE USER pgets_fill PASSWORD 'mahatma'; +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; diff --git a/sql/pgets.sql b/sql/pgets.sql new file mode 100644 index 0000000..0ba22aa --- /dev/null +++ b/sql/pgets.sql @@ -0,0 +1,28 @@ +-- $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. + +CREATE TABLE pgets_accounting ( + remote_msn CHAR(22) NOT NULL, + local_mm SMALLINT NOT NULL, + participant SMALLINT NOT NULL, + incoming BOOL NOT NULL, + _timestamp TIMESTAMP NOT NULL, + duration INT NOT NULL); + +CREATE INDEX pgets_accounting_timestamp ON pgets_accounting(_timestamp); +CREATE UNIQUE INDEX pgets_accounting_unique ON pgets_accounting(remote_msn, local_mm, participant, incoming, _timestamp, duration); |