summaryrefslogtreecommitdiffstats
path: root/Database/localhost.sql
diff options
context:
space:
mode:
authorTriatmoko2011-10-30 22:29:21 +0100
committerTriatmoko2011-10-30 22:29:21 +0100
commit92eed03aeeb1c905a33546392a7bff3337b607c8 (patch)
tree465e96d6d58656bb1b99cf20c1866f653ac16a72 /Database/localhost.sql
parentsmarttest php (diff)
downloadgsm-selftest-92eed03aeeb1c905a33546392a7bff3337b607c8.tar.gz
gsm-selftest-92eed03aeeb1c905a33546392a7bff3337b607c8.tar.xz
gsm-selftest-92eed03aeeb1c905a33546392a7bff3337b607c8.zip
rearrange the files and edit ssh connection for class controller
Diffstat (limited to 'Database/localhost.sql')
-rw-r--r--Database/localhost.sql135
1 files changed, 0 insertions, 135 deletions
diff --git a/Database/localhost.sql b/Database/localhost.sql
deleted file mode 100644
index ed64338..0000000
--- a/Database/localhost.sql
+++ /dev/null
@@ -1,135 +0,0 @@
--- phpMyAdmin SQL Dump
--- version 3.3.10deb1
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generation Time: Jul 19, 2011 at 02:01 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 `DeviceAddressTable`
---
-
-CREATE TABLE IF NOT EXISTS `DeviceAddressTable` (
- `deviceName` varchar(10) NOT NULL,
- `deviceIP` varchar(60) 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`
---
-