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

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

Created by: aleph, Last modification: Thu 30 of Jun, 2005 (03:31 UTC)
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+