ASTCC-SampleSQLDB

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 `bit_brands`
—

CREATE TABLE `bit_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 `bit_brands`
—

INSERT INTO `bit_brands` VALUES (‘default’, ‘en’, ‘N/A’, ‘N/A’, 0, 6, 0, 0);

— ——————————————————–

—
— Table structure for table `bit_cards`
—

CREATE TABLE `bit_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 `bit_cards`
—

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

— ——————————————————–

—
— Table structure for table `bit_cdrs`
—

CREATE TABLE `bit_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 `bit_cdrs`
—

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

— ——————————————————–

—
— Table structure for table `bit_routes`
—

CREATE TABLE `bit_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 `bit_routes`
—

INSERT INTO `bit_routes` VALUES (‘1403.*’, ‘Southern Alberta, Canada’, ‘Aleph’, 500, 10, 500);
INSERT INTO `bit_routes` VALUES (‘1780.*’, ‘Northern Alberta, Canada’, ‘Aleph’, 500, 10, 500);

— ——————————————————–

—
— Table structure for table `bit_trunks`
—

CREATE TABLE `bit_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 `bit_trunks`
—

INSERT INTO `bit_trunks` VALUES (‘Aleph’, ‘IAX2’, ‘alephiax’);