-- phpMyAdmin SQL Dump -- version 3.3.10deb1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 06, 2011 at 06:24 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` -- CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `gsmselftesting`; -- -------------------------------------------------------- -- -- Table structure for table `DeviceAddress` -- CREATE TABLE IF NOT EXISTS `DeviceAddress` ( `deviceName` varchar(10) NOT NULL, `deviceIP` varchar(60) NOT NULL, `lastChange` datetime NOT NULL, PRIMARY KEY (`deviceName`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- 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` -- -- -------------------------------------------------------- -- -- 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, `sipLoc` int(3) NOT NULL, `gsmBox1` int(3) NOT NULL, `gsmBox2` int(3) NOT NULL, PRIMARY KEY (`taskNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- Table structure for table `TaskTable` -- CREATE TABLE IF NOT EXISTS `TaskTable` ( `taskID` int(11) NOT NULL, `taskNo` int(11) NOT NULL, `from` varchar(10) NOT NULL, `to` varchar(10) NOT NULL, `status` int(2) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`taskID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `TempTaskTable` -- CREATE TABLE IF NOT EXISTS `TempTaskTable` ( `taskID` int(11) NOT NULL, `from` varchar(10) NOT NULL, `to` varchar(10) NOT NULL, PRIMARY KEY (`taskID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;