-- 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');