From e2c779ed909218d5aa2ef692e816e1b668e17f12 Mon Sep 17 00:00:00 2001 From: gsmselgtest Date: Fri, 2 Sep 2011 11:12:33 +0200 Subject: insert data for device table --- Database/gsmselftesting.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'Database') diff --git a/Database/gsmselftesting.sql b/Database/gsmselftesting.sql index be80cb2..cba3741 100644 --- a/Database/gsmselftesting.sql +++ b/Database/gsmselftesting.sql @@ -18,7 +18,7 @@ SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `gsmselftesting` -- -DROP DATABASE `gsmselftesting`; +DROP DATABASE IF EXISTS `gsmselftesting`; CREATE DATABASE `gsmselftesting` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `gsmselftesting`; @@ -52,6 +52,7 @@ INSERT INTO `DeviceAddressTable` (`deviceName`, `deviceIP`, `number`, `lastChang ('GSMRZ2', 'localhost', '07612034661455', '2011-07-27 15:48:04', '', '', ''), ('GSMExt.Eplus', 'localhost', '015782677224', '2011-07-28 14:33:43', '', '', ''), ('GSMExt.Voda', 'localhost', '015252423662', '2011-07-28 14:35:33', '', '', ''), +('GSMExt.Tm', 'localhost', '015128040906', '2011-08-29 14:47:18', '', '', ''), ('GSMExt.O2', 'localhost', '017678038038', '2011-07-28 14:36:13', '', '', ''); -- -------------------------------------------------------- -- cgit v1.2.3-55-g7522