diff options
Diffstat (limited to 'sql/pgets.sql')
-rw-r--r-- | sql/pgets.sql | 28 |
1 files changed, 28 insertions, 0 deletions
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); |