c_voiptariffdst.sql

来自「gnugk软交换产品」· SQL 代码 · 共 30 行

-- 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';