summaryrefslogtreecommitdiffstats
path: root/notFinishedCode/gsmselftesting.sql
diff options
context:
space:
mode:
Diffstat (limited to 'notFinishedCode/gsmselftesting.sql')
-rw-r--r--notFinishedCode/gsmselftesting.sql134
1 files changed, 0 insertions, 134 deletions
diff --git a/notFinishedCode/gsmselftesting.sql b/notFinishedCode/gsmselftesting.sql
deleted file mode 100644
index acd1be9..0000000
--- a/notFinishedCode/gsmselftesting.sql
+++ /dev/null
@@ -1,134 +0,0 @@
--- phpMyAdmin SQL Dump
--- version 3.3.10deb1
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generation Time: Jul 26, 2011 at 03:04 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(10) NOT NULL,
- `deviceIP` varchar(60) NOT NULL,
- `number` varchar(20) NOT NULL,
- `lastChange` datetime NOT NULL,
- PRIMARY KEY (`deviceName`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `DeviceAddressTable`
---
-
-
--- --------------------------------------------------------
-
---
--- 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;
-
---
--- 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(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 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(10) NOT NULL,
- `to` varchar(10) NOT NULL,
- PRIMARY KEY (`taskID`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-
---
--- Dumping data for table `TempTaskTable`
---
-