-- Tariff Destination -- -- VoIP Billing Platform for GnuGk -- Copyright (c) 2004, Michal Zygmuntowicz -- -- This work is published under the GNU Public License (GPL) -- see file COPYING for details -- tariff destination (prefix) CREATE SEQUENCE voiptariffdst_id_seq CYCLE; CREATE TABLE voiptariffdst ( id INT DEFAULT nextval('voiptariffdst_id_seq'), -- whether this destination (prefix) can be dialed active BOOLEAN NOT NULL DEFAULT TRUE, -- E.164 prefix or a special value 'PC' that specifies all -- non-E.164 (H.323 id) aliases starting with a letter, not digit prefix TEXT NOT NULL, -- description (like country name) description TEXT NOT NULL, -- FALSE for prefix like matching, TRUE for H.323 ID matching exactmatch BOOLEAN NOT NULL DEFAULT FALSE, CONSTRAINT voiptariffdst_pkey PRIMARY KEY (id), CONSTRAINT voiptariffdst_unique UNIQUE (prefix) ); CREATE UNIQUE INDEX voiptariffdst_pfx_idx ON voiptariffdst(prefix); CREATE UNIQUE INDEX voiptariffdst_h323id_idx ON voiptariffdst(prefix) WHERE exactmatch; CREATE INDEX voiptariffdst_pc_idx ON voiptariffdst(prefix) WHERE prefix = 'PC';