--    This file is part of LCR-AGI.
--
--    LCR-AGI 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 3 of the License, or
--    (at your option) any later version.
--
--    LCR-AGI 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 LCR-AGI.  If not, see <http://www.gnu.org/licenses/>.
--
-- Copyright (C) 2009 Alkaloid Networks LLC
-- Author: Ben Klang <ben@alkaloid.net>
-- Alkaloid Networks LLC - http://projects.alkaloid.net
-- $Id$

CREATE TABLE phoneroutes (
    callsource ENUM("any", "intrastate", "interstate", "international"),
    destination BIGINT UNSIGNED,
    cost DECIMAL(6,6),
    carrier ENUM('broadriver', 'voipjet', 'gafachi')
);

CREATE TABLE areacodes (
    npa SMALLINT NOT NULL,
    location VARCHAR(64) NOT NULL,
    primary key (npa), unique npa (npa)
);