1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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);
|