-- $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);