summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authorMac-Linux2011-07-29 22:32:18 +0200
committerMac-Linux2011-07-29 22:32:18 +0200
commite4d13cd04463900fa43064e1656ff9640db9fb34 (patch)
tree9f9d07031a574c44a229d2f97124d9952685a612 /Database
parentMerge branch 'master' of lab.ks.uni-freiburg.de:lsfks/projekte/gsm-selftest (diff)
downloadgsm-selftest-e4d13cd04463900fa43064e1656ff9640db9fb34.tar.gz
gsm-selftest-e4d13cd04463900fa43064e1656ff9640db9fb34.tar.xz
gsm-selftest-e4d13cd04463900fa43064e1656ff9640db9fb34.zip
insert for device add table
Diffstat (limited to 'Database')
-rw-r--r--Database/DeviceAddressTable.sql49
1 files changed, 49 insertions, 0 deletions
diff --git a/Database/DeviceAddressTable.sql b/Database/DeviceAddressTable.sql
new file mode 100644
index 0000000..a9efc7b
--- /dev/null
+++ b/Database/DeviceAddressTable.sql
@@ -0,0 +1,49 @@
+-- phpMyAdmin SQL Dump
+-- version 3.3.10deb1
+-- http://www.phpmyadmin.net
+--
+-- Host: localhost
+-- Generation Time: Jul 29, 2011 at 10:31 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`
+--
+
+DROP TABLE IF EXISTS `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`
+--
+
+INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChange`) VALUES
+('sip', 'localhost', '07612034661928', '2011-07-26 00:00:00'),
+('unisip', 'localhost', '076120397897', '2011-07-27 00:00:00'),
+('landline', 'localhost', '076145875681', '2011-07-26 00:00:00'),
+('gsmr1', 'localhost', '07612034661xxx', '2011-07-27 15:47:08'),
+('gsmr2', '132.230.4.64', '07612034661455', '2011-07-27 15:48:04'),
+('gsmeE', 'localhost', '015782677224', '2011-07-28 14:33:43'),
+('gsmeV', 'localhost', '015252423662', '2011-07-28 14:35:33'),
+('gsmeO', 'localhost', '017678038038', '2011-07-28 14:36:13');