login | register
Tue 02 of Dec, 2008 [03:28 UTC]

voip-info.org

ASTCC-SampleSQLDB

Created by: aleph,Last modification on Thu 30 of Jun, 2005 [03:31 UTC]
Here is the SQL code to create a database populated with the info shown in the ASTCC-Screenshots Page

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 29, 2005 at 11:31 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.2
--
-- Database: `astcc`
--

-- --------------------------------------------------------

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
 `name` char(40) NOT NULL default '',
 `language` char(10) default NULL,
 `publishednum` char(40) default NULL,
 `did` char(40) default NULL,
 `markup` int(11) default NULL,
 `inc` int(11) default NULL,
 `fee` int(11) default NULL,
 `days` int(11) default NULL,
 PRIMARY KEY  (`name`)
) TYPE=MyISAM;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` VALUES ('default', 'en', 'N/A', 'N/A', 0, 6, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `cards`
--

CREATE TABLE `cards` (
 `number` char(20) NOT NULL default '',
 `language` char(10) default NULL,
 `facevalue` int(11) default NULL,
 `used` int(11) NOT NULL default '0',
 `inc` int(11) NOT NULL default '0',
 `markup` int(11) NOT NULL default '0',
 `creation` timestamp(14) NOT NULL,
 `firstuse` timestamp(14) NOT NULL,
 `expiration` timestamp(14) NOT NULL,
 `inuse` int(11) default NULL,
 `brand` char(40) default NULL,
 `nextfee` int(11) default NULL,
 `pin` int(11) default NULL,
 PRIMARY KEY  (`number`)
) TYPE=MyISAM;

--
-- Dumping data for table `cards`
--

INSERT INTO `cards` VALUES ('3954', 'en', 10000, 0, 6, 0, '20050629204233', '00000000000000', '00000000000000', NULL, 'default', 0, 4580);
INSERT INTO `cards` VALUES ('7742', 'en', 10000, 3050, 6, 0, '20050629213505', '20050629205128', '00000000000000', 0, 'default', 0, 2203);

-- --------------------------------------------------------

--
-- Table structure for table `cdrs`
--

CREATE TABLE `cdrs` (
 `cardnum` char(40) default NULL,
 `callerid` char(80) default NULL,
 `callednum` char(80) default NULL,
 `trunk` char(40) default NULL,
 `disposition` char(20) default NULL,
 `billseconds` int(11) default NULL,
 `billcost` int(11) default NULL,
 `callstart` char(24) default NULL
) TYPE=MyISAM;

--
-- Dumping data for table `cdrs`
--

INSERT INTO `cdrs` VALUES ('7742', '"" <12>', '17808473033', 'Aleph', 'ANSWER', 30, 500, 'Wed Jun 29 21:10:17 2005');
INSERT INTO `cdrs` VALUES ('7742', '"" <12>', '17808473033', 'Aleph', 'ANSWER', 44, 800, 'Wed Jun 29 21:20:49 2005');
INSERT INTO `cdrs` VALUES ('7742', '"" <12>', '17808473033', 'Aleph', 'ANSWER', 43, 500, 'Wed Jun 29 21:31:19 2005');
INSERT INTO `cdrs` VALUES ('7742', '"" <12>', '17808473033', 'Aleph', 'ANSWER', 35, 750, 'Wed Jun 29 21:35:05 2005');

-- --------------------------------------------------------

--
-- Table structure for table `routes`
--

CREATE TABLE `routes` (
 `pattern` char(40) NOT NULL default '',
 `comment` char(80) default NULL,
 `trunks` char(80) default NULL,
 `connectcost` int(11) NOT NULL default '0',
 `includedseconds` int(11) NOT NULL default '0',
 `cost` int(11) NOT NULL default '0',
 PRIMARY KEY  (`pattern`)
) TYPE=MyISAM;

--
-- Dumping data for table `routes`
--

INSERT INTO `routes` VALUES ('1403.*', 'Southern Alberta, Canada', 'Aleph', 500, 10, 500);
INSERT INTO `routes` VALUES ('1780.*', 'Northern Alberta, Canada', 'Aleph', 500, 10, 500);

-- --------------------------------------------------------

--
-- Table structure for table `trunks`
--

CREATE TABLE `trunks` (
 `name` char(40) NOT NULL default '',
 `tech` char(10) default NULL,
 `path` char(40) NOT NULL default '',
 PRIMARY KEY  (`name`)
) TYPE=MyISAM;

--
-- Dumping data for table `trunks`
--

INSERT INTO `trunks` VALUES ('Aleph', 'IAX2', 'alephiax');
       

Comments