-- phpMyAdmin SQL Dump -- version 3.3.10deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 02, 2011 at 02:10 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` -- DROP DATABASE IF EXISTS `gsmselftesting`; CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `gsmselftesting`; -- -------------------------------------------------------- -- -- Table structure for table `DeviceAddressTable` -- CREATE TABLE IF NOT EXISTS `DeviceAddressTable` ( `deviceName` varchar(15) NOT NULL, `deviceIP` varchar(60) NOT NULL, `number` varchar(20) NOT NULL, `lastChange` datetime NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(20) NOT NULL, `server` varchar(20) NOT NULL, PRIMARY KEY (`deviceName`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `DeviceAddressTable` -- INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChange`, `username`, `password`, `server`) VALUES ('sip', 'localhost', '07612034661928', '2011-07-26 00:00:00', 'mpselftest1', '1mpselftest', '132.230.4.8'), ('unisip', 'localhost', '076120397898', '2011-07-27 00:00:00', '4976120397898', 'itzEfmLkzvS9', '132.230.252.228'), ('landline', 'localhost', '076145875681', '2011-07-26 00:00:00', '1289459', 'MMW9AX', 'sipgate.de'), ('GSMRZ1', 'localhost', '07612034661xxx', '2011-07-27 15:47:08', '', '', ''), ('GSMRZ2', 'localhost', '07612034661455', '2011-07-27 15:48:04', '', '', ''), ('GSMExt.Eplus', 'localhost', '015782677224', '2011-07-28 14:33:43', '', '', ''), ('GSMExt.Voda', 'localhost', '015252423662', '2011-07-28 14:35:33', '', '', ''), ('GSMExt.Tm', 'localhost', '015128040906', '2011-08-29 14:47:18', '', '', ''), ('GSMExt.O2', 'localhost', '017678038038', '2011-07-28 14:36:13', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `ErrorCodeTable` -- CREATE TABLE IF NOT EXISTS `ErrorCodeTable` ( `errorcode` int(4) NOT NULL, `description` varchar(100) NOT NULL, PRIMARY KEY (`errorcode`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ErrorCodeTable` -- INSERT INTO `ErrorCodeTable` (`errorcode`, `description`) VALUES (200, 'Call was OK'), (604, 'General Handler Error: Destination handler no respond timeout'), (998, 'General Handler Error: Could not connect Destination handler'), (605, 'General Handler Error: caller handler no respond timeout'), (999, 'General Handler Error: Could not connect to Caller handler'), (486, 'Call Failed'), (500, 'Server Internal Error'), (333, 'No connection to Database'), (100, 'Missing account detail'); -- -------------------------------------------------------- -- -- 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` -- INSERT INTO `ResultTable` (`taskID`, `result`) VALUES (1, 486), (2, 486); -- -------------------------------------------------------- -- -- 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=25 ; -- -- 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` --