summaryrefslogtreecommitdiffstats
path: root/Database
diff options
context:
space:
mode:
authorgsmselgtest2011-09-02 11:12:33 +0200
committergsmselgtest2011-09-02 11:12:33 +0200
commite2c779ed909218d5aa2ef692e816e1b668e17f12 (patch)
tree135e65d036a32c79de0517190b59c0863744862f /Database
parentclean the comment (diff)
downloadgsm-selftest-e2c779ed909218d5aa2ef692e816e1b668e17f12.tar.gz
gsm-selftest-e2c779ed909218d5aa2ef692e816e1b668e17f12.tar.xz
gsm-selftest-e2c779ed909218d5aa2ef692e816e1b668e17f12.zip
insert data for device table
Diffstat (limited to 'Database')
-rw-r--r--Database/gsmselftesting.sql3
1 files changed, 2 insertions, 1 deletions
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', '', '', '');
-- --------------------------------------------------------