summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
Diffstat (limited to 'Database')
-rw-r--r--Database/README.txt5
-rw-r--r--Database/gsmselftesting.sql177
2 files changed, 182 insertions, 0 deletions
diff --git a/Database/README.txt b/Database/README.txt
new file mode 100644
index 0000000..0beddc2
--- /dev/null
+++ b/Database/README.txt
@@ -0,0 +1,5 @@
+
+You can import the SQL dumb in to MySQL database.
+This only SQL query to create database and table.
+
+information regarding device configuration are send it by email.
diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql
new file mode 100644
index 0000000..e7d52d6
--- /dev/null
+++ b/Database/gsmselftesting.sql
@@ -0,0 +1,177 @@
+-- phpMyAdmin SQL Dump
+-- version 3.3.10deb1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Nov 09, 2011 at 04:37 PM
+-- Server version: 5.1.54
+-- PHP Version: 5.3.5-1ubuntu7.2
+
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
+/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
+/*!40101 SET NAMES utf8 */;
+
+--
+-- Database: `gsmselftesting`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `DeviceAddressTable`
+--
+
+CREATE TABLE IF NOT EXISTS `DeviceAddressTable` (
+ `deviceName` varchar(15) NOT NULL,
+ `portName` varchar(15) NOT NULL,
+ `number` varchar(20) NOT NULL,
+ `lastChange` datetime NOT NULL,
+ `username` varchar(20) NOT NULL DEFAULT 'root',
+ `password` varchar(20) NOT NULL DEFAULT 'root',
+ `server` varchar(20) NOT NULL,
+ PRIMARY KEY (`deviceName`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+
+
+CREATE TABLE IF NOT EXISTS `ErrorCodeTable` (
+ `respondCode` int(4) NOT NULL,
+ `description` varchar(100) NOT NULL,
+ PRIMARY KEY (`respondCode`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `ErrorCodeTable`
+--
+
+INSERT INTO `ErrorCodeTable` (`respondCode`, `description`) VALUES
+(200, 'Call was OK'),
+(604, 'General Handler Error: Destination handler did not respond. Timeout'),
+(998, 'General Handler Error: Could not connect to the destination handler!'),
+(605, 'General Handler Error: Caller handler did not respond. Timeout'),
+(999, 'General Handler Error: Could not connect to the caller handler!'),
+(486, 'Call Failed'),
+(333, 'Could not establish a connection to the database!'),
+(100, 'Missing account detail'),
+(402, 'Payment Required (Eplus Card)'),
+(801, 'Connection to caller established, but the device does not respond'),
+(802, 'Connection to destination established, but the device does not respond'),
+(501, 'Destination server Internal Error'),
+(500, 'Caller server Internal Error');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `GSMPrefix`
+--
+
+CREATE TABLE IF NOT EXISTS `GSMPrefix` (
+ `carrier` varchar(13) NOT NULL,
+ `prefix` varchar(4) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `GSMPrefix`
+--
+
+INSERT INTO `GSMPrefix` (`carrier`, `prefix`) VALUES
+('GSMExt.Tm', '0151'),
+('GSMExt.Tm', '0160'),
+('GSMExt.Tm', '0170'),
+('GSMExt.Tm', '0175'),
+('GSMExt.Tm', '0171'),
+('GSMExt.Voda', '0162'),
+('GSMExt.Voda', '0172'),
+('GSMExt.Voda', '0173'),
+('GSMExt.Voda', '0174'),
+('GSMExt.Eplus', '0157'),
+('GSMExt.Eplus', '0177'),
+('GSMExt.Eplus', '0155'),
+('GSMExt.Eplus', '0163'),
+('GSMExt.Eplus', '0178'),
+('GSMExt.O2', '0159'),
+('GSMExt.O2', '0176'),
+('GSMExt.O2', '0179'),
+('GSMRZ1', '0761'),
+('GSMExt.Voda', '0152');
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `PingResultTable`
+--
+
+CREATE TABLE IF NOT EXISTS `PingResultTable` (
+ `taskNo` int(11) NOT NULL,
+ `sipServer` int(3) NOT NULL,
+ `sipGate` int(3) NOT NULL,
+ `unisip` int(3) NOT NULL,
+ `gsmBox1` int(3) NOT NULL,
+ `gsmBox2` int(3) NOT NULL,
+ PRIMARY KEY (`taskNo`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `PingResultTable`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `ResultTable`
+--
+
+CREATE TABLE IF NOT EXISTS `ResultTable` (
+ `taskID` int(11) NOT NULL,
+ `result` int(3) NOT NULL,
+ PRIMARY KEY (`taskID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `ResultTable`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `TaskTable`
+--
+
+CREATE TABLE IF NOT EXISTS `TaskTable` (
+ `taskID` int(11) NOT NULL AUTO_INCREMENT,
+ `taskNo` int(11) NOT NULL,
+ `from` varchar(15) NOT NULL,
+ `to` varchar(15) NOT NULL,
+ `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ PRIMARY KEY (`taskID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `TaskTable`
+--
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `TempTaskTable`
+--
+
+CREATE TABLE IF NOT EXISTS `TempTaskTable` (
+ `taskID` int(11) NOT NULL,
+ `taskNo` int(11) NOT NULL,
+ `from` varchar(15) NOT NULL,
+ `to` varchar(15) NOT NULL,
+ PRIMARY KEY (`taskID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `TempTaskTable`
+--
+