· 9 years ago · Dec 09, 2016, 11:14 PM
1-- MySQL dump 10.14 Distrib 5.5.47-MariaDB, for Linux (x86_64)
2--
3-- Host: localhost Database: sapinfrastructure_dev
4-- ------------------------------------------------------
5-- Server version 5.5.47-MariaDB
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `agent`
20--
21
22DROP TABLE IF EXISTS `agent`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `agent` (
26 `agentKey` varchar(255) DEFAULT NULL,
27 `enabled` tinyint(1) DEFAULT NULL,
28 `connected` tinyint(1) DEFAULT NULL,
29 `socketId` varchar(255) DEFAULT NULL,
30 `server` int(11) DEFAULT NULL,
31 `createdBy` int(11) DEFAULT NULL,
32 `updatedBy` int(11) DEFAULT NULL,
33 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
34 `createdAt` datetime DEFAULT NULL,
35 `updatedAt` datetime DEFAULT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
38/*!40101 SET character_set_client = @saved_cs_client */;
39
40--
41-- Dumping data for table `agent`
42--
43
44LOCK TABLES `agent` WRITE;
45/*!40000 ALTER TABLE `agent` DISABLE KEYS */;
46INSERT INTO `agent` VALUES ('34850d534d9c13f4b7f9978219828ac573b445b22305fad89cc502348d98d67f',1,0,'/#FGzZidS3MQioQafeAAAH',9,1,1,1,'2016-12-01 13:15:32','2016-12-06 09:42:21'),('866c63c8eb707c9e31c900e05e056d29c242db583fe6583d8003153357bb1ca4',1,0,'/#POD2_WMhRBoGnKDcAAAI',12,1,1,2,'2016-12-01 13:27:46','2016-12-06 09:43:10'),('d879e2bdd8712e15322ff04152444e5ecb62b2ad8b1cf500052d3a910e7cccee',1,0,'/#xu1XhfkQlz4OClM0AAAF',11,1,1,3,'2016-12-01 13:33:54','2016-12-06 09:42:52'),('0184edf3c6565cc6de50d20c26eeef913be89686bfbd69eaf35da2c0075963d5',1,0,'/#DwOE6L-ffcdu4VuLAAAD',10,1,1,4,'2016-12-01 13:36:38','2016-12-06 09:42:03'),('27a56b6e9c666bf5939dc0701091ce1474779fcbc9294f60a211f7ef5b50277e',1,1,'/#hcbSmn8yGR13vwUnAAAL',13,NULL,NULL,5,'2016-12-01 14:03:55','2016-12-01 14:05:22'),('2bb2abd39023d80d23164e77d158507d900cdfca2feeb4ea9aa0e4c39ee0a7a0',1,0,'/#irlvOW2xzpyI4XoQAAAN',14,1,1,6,'2016-12-01 14:16:02','2016-12-01 14:45:40');
47/*!40000 ALTER TABLE `agent` ENABLE KEYS */;
48UNLOCK TABLES;
49
50--
51-- Table structure for table `agent_metadata__metadata_agent`
52--
53
54DROP TABLE IF EXISTS `agent_metadata__metadata_agent`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `agent_metadata__metadata_agent` (
58 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
59 `agent_metadata` int(11) DEFAULT NULL,
60 `metadata_agent` int(11) DEFAULT NULL,
61 PRIMARY KEY (`id`)
62) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `agent_metadata__metadata_agent`
67--
68
69LOCK TABLES `agent_metadata__metadata_agent` WRITE;
70/*!40000 ALTER TABLE `agent_metadata__metadata_agent` DISABLE KEYS */;
71INSERT INTO `agent_metadata__metadata_agent` VALUES (1,1,52),(2,2,53),(3,2,54),(4,3,55),(5,4,56),(6,1,57),(7,4,58),(8,3,59),(9,1,60),(10,4,61),(11,4,62),(12,4,63),(13,4,64),(14,3,65),(15,3,66),(16,4,67),(17,3,68),(18,2,69),(19,2,70),(20,1,71),(21,1,72),(22,2,73),(23,2,74),(24,5,75),(25,5,76),(26,5,77),(27,6,78),(28,6,79),(29,6,80),(30,6,81),(31,6,82),(32,6,83);
72/*!40000 ALTER TABLE `agent_metadata__metadata_agent` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `audit`
77--
78
79DROP TABLE IF EXISTS `audit`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `audit` (
83 `id` varchar(255) NOT NULL,
84 `ipAddress` varchar(255) DEFAULT NULL,
85 `method` varchar(255) DEFAULT NULL,
86 `url` varchar(255) DEFAULT NULL,
87 `body` longtext,
88 `user` int(11) DEFAULT NULL,
89 `action` varchar(255) DEFAULT NULL,
90 `controller` varchar(255) DEFAULT NULL,
91 `model` varchar(255) DEFAULT NULL,
92 `createdAt` datetime DEFAULT NULL,
93 `updatedAt` datetime DEFAULT NULL,
94 PRIMARY KEY (`id`)
95) ENGINE=InnoDB DEFAULT CHARSET=utf8;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `audit`
100--
101
102LOCK TABLES `audit` WRITE;
103/*!40000 ALTER TABLE `audit` DISABLE KEYS */;
104/*!40000 ALTER TABLE `audit` ENABLE KEYS */;
105UNLOCK TABLES;
106
107--
108-- Table structure for table `comment`
109--
110
111DROP TABLE IF EXISTS `comment`;
112/*!40101 SET @saved_cs_client = @@character_set_client */;
113/*!40101 SET character_set_client = utf8 */;
114CREATE TABLE `comment` (
115 `message` varchar(255) DEFAULT NULL,
116 `isDeleted` varchar(255) DEFAULT NULL,
117 `createdBy` int(11) DEFAULT NULL,
118 `updatedBy` int(11) DEFAULT NULL,
119 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
120 `createdAt` datetime DEFAULT NULL,
121 `updatedAt` datetime DEFAULT NULL,
122 PRIMARY KEY (`id`)
123) ENGINE=InnoDB DEFAULT CHARSET=utf8;
124/*!40101 SET character_set_client = @saved_cs_client */;
125
126--
127-- Dumping data for table `comment`
128--
129
130LOCK TABLES `comment` WRITE;
131/*!40000 ALTER TABLE `comment` DISABLE KEYS */;
132/*!40000 ALTER TABLE `comment` ENABLE KEYS */;
133UNLOCK TABLES;
134
135--
136-- Table structure for table `comment_server__server_comments`
137--
138
139DROP TABLE IF EXISTS `comment_server__server_comments`;
140/*!40101 SET @saved_cs_client = @@character_set_client */;
141/*!40101 SET character_set_client = utf8 */;
142CREATE TABLE `comment_server__server_comments` (
143 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
144 `comment_server` int(11) DEFAULT NULL,
145 `server_comments` int(11) DEFAULT NULL,
146 PRIMARY KEY (`id`)
147) ENGINE=InnoDB DEFAULT CHARSET=utf8;
148/*!40101 SET character_set_client = @saved_cs_client */;
149
150--
151-- Dumping data for table `comment_server__server_comments`
152--
153
154LOCK TABLES `comment_server__server_comments` WRITE;
155/*!40000 ALTER TABLE `comment_server__server_comments` DISABLE KEYS */;
156/*!40000 ALTER TABLE `comment_server__server_comments` ENABLE KEYS */;
157UNLOCK TABLES;
158
159--
160-- Table structure for table `component`
161--
162
163DROP TABLE IF EXISTS `component`;
164/*!40101 SET @saved_cs_client = @@character_set_client */;
165/*!40101 SET character_set_client = utf8 */;
166CREATE TABLE `component` (
167 `name` varchar(255) DEFAULT NULL,
168 `abbreviation` varchar(255) DEFAULT NULL,
169 `isDeleted` tinyint(1) DEFAULT NULL,
170 `createdBy` int(11) DEFAULT NULL,
171 `updatedBy` int(11) DEFAULT NULL,
172 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
173 `createdAt` datetime DEFAULT NULL,
174 `updatedAt` datetime DEFAULT NULL,
175 PRIMARY KEY (`id`),
176 UNIQUE KEY `name` (`name`)
177) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
178/*!40101 SET character_set_client = @saved_cs_client */;
179
180--
181-- Dumping data for table `component`
182--
183
184LOCK TABLES `component` WRITE;
185/*!40000 ALTER TABLE `component` DISABLE KEYS */;
186INSERT INTO `component` VALUES ('Business Objects','BOBJ',0,1,1,1,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('BW','BW',0,1,1,2,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Vertex','VTX',0,1,1,3,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('GRC','GRC',0,1,1,4,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('OpenText Archive Server','OT',0,1,1,5,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Process Integration','PI',0,1,1,6,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('ERP Central Component','ECC',0,1,1,7,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Enterprise Portal','PT',0,1,1,8,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('PI-DAE','AE',0,1,1,9,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Productivity Pack','PP',0,1,1,10,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('System Landscape Directory','SLD',0,1,1,11,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Vertex O Series','VX',0,1,1,12,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Supplier Relationship Management','SRM',0,1,1,13,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Wily','WY',0,1,1,14,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('Data Service','DS',0,1,1,15,'2016-11-08 18:44:56','2016-11-08 18:44:56'),('BASIS Utility Server','BUS',0,1,1,16,'2016-11-08 18:44:56','2016-11-08 18:44:56');
187/*!40000 ALTER TABLE `component` ENABLE KEYS */;
188UNLOCK TABLES;
189
190--
191-- Table structure for table `group`
192--
193
194DROP TABLE IF EXISTS `group`;
195/*!40101 SET @saved_cs_client = @@character_set_client */;
196/*!40101 SET character_set_client = utf8 */;
197CREATE TABLE `group` (
198 `name` varchar(255) DEFAULT NULL,
199 `accessLevel` int(11) DEFAULT NULL,
200 `isDeleted` tinyint(1) DEFAULT NULL,
201 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
202 `createdAt` datetime DEFAULT NULL,
203 `updatedAt` datetime DEFAULT NULL,
204 PRIMARY KEY (`id`)
205) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
206/*!40101 SET character_set_client = @saved_cs_client */;
207
208--
209-- Dumping data for table `group`
210--
211
212LOCK TABLES `group` WRITE;
213/*!40000 ALTER TABLE `group` DISABLE KEYS */;
214INSERT INTO `group` VALUES ('Admins',2,0,1,'2016-11-09 16:05:59','2016-11-09 16:05:59'),('Users',1,0,2,'2016-11-09 16:05:59','2016-11-09 16:05:59');
215/*!40000 ALTER TABLE `group` ENABLE KEYS */;
216UNLOCK TABLES;
217
218--
219-- Table structure for table `landscape`
220--
221
222DROP TABLE IF EXISTS `landscape`;
223/*!40101 SET @saved_cs_client = @@character_set_client */;
224/*!40101 SET character_set_client = utf8 */;
225CREATE TABLE `landscape` (
226 `name` varchar(255) DEFAULT NULL,
227 `abbreviation` varchar(255) DEFAULT NULL,
228 `isDeleted` tinyint(1) DEFAULT NULL,
229 `createdBy` int(11) DEFAULT NULL,
230 `updatedBy` int(11) DEFAULT NULL,
231 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
232 `createdAt` datetime DEFAULT NULL,
233 `updatedAt` datetime DEFAULT NULL,
234 PRIMARY KEY (`id`),
235 UNIQUE KEY `name` (`name`),
236 UNIQUE KEY `abbreviation` (`abbreviation`)
237) ENGINE=InnoDB DEFAULT CHARSET=utf8;
238/*!40101 SET character_set_client = @saved_cs_client */;
239
240--
241-- Dumping data for table `landscape`
242--
243
244LOCK TABLES `landscape` WRITE;
245/*!40000 ALTER TABLE `landscape` DISABLE KEYS */;
246/*!40000 ALTER TABLE `landscape` ENABLE KEYS */;
247UNLOCK TABLES;
248
249--
250-- Table structure for table `location`
251--
252
253DROP TABLE IF EXISTS `location`;
254/*!40101 SET @saved_cs_client = @@character_set_client */;
255/*!40101 SET character_set_client = utf8 */;
256CREATE TABLE `location` (
257 `name` varchar(255) DEFAULT NULL,
258 `abbreviation` varchar(255) DEFAULT NULL,
259 `isDeleted` tinyint(1) DEFAULT NULL,
260 `createdBy` int(11) DEFAULT NULL,
261 `updatedBy` int(11) DEFAULT NULL,
262 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
263 `createdAt` datetime DEFAULT NULL,
264 `updatedAt` datetime DEFAULT NULL,
265 PRIMARY KEY (`id`),
266 UNIQUE KEY `name` (`name`),
267 UNIQUE KEY `abbreviation` (`abbreviation`)
268) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
269/*!40101 SET character_set_client = @saved_cs_client */;
270
271--
272-- Dumping data for table `location`
273--
274
275LOCK TABLES `location` WRITE;
276/*!40000 ALTER TABLE `location` DISABLE KEYS */;
277INSERT INTO `location` VALUES ('Information Systems Building','ISB',0,NULL,NULL,1,'2016-11-08 18:44:48','2016-11-08 18:44:48'),('East Valley Service Center','EVS',0,NULL,NULL,2,'2016-11-08 18:44:48','2016-11-08 18:44:48');
278/*!40000 ALTER TABLE `location` ENABLE KEYS */;
279UNLOCK TABLES;
280
281--
282-- Table structure for table `metadata`
283--
284
285DROP TABLE IF EXISTS `metadata`;
286/*!40101 SET @saved_cs_client = @@character_set_client */;
287/*!40101 SET character_set_client = utf8 */;
288CREATE TABLE `metadata` (
289 `via` varchar(255) DEFAULT NULL,
290 `data` longtext,
291 `isDeleted` tinyint(1) DEFAULT NULL,
292 `createdBy` int(11) DEFAULT NULL,
293 `updatedBy` int(11) DEFAULT NULL,
294 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
295 `createdAt` datetime DEFAULT NULL,
296 `updatedAt` datetime DEFAULT NULL,
297 PRIMARY KEY (`id`)
298) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;
299/*!40101 SET character_set_client = @saved_cs_client */;
300
301--
302-- Dumping data for table `metadata`
303--
304
305LOCK TABLES `metadata` WRITE;
306/*!40000 ALTER TABLE `metadata` DISABLE KEYS */;
307INSERT INTO `metadata` VALUES ('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.26\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":660959232,\"used\":7593562112},\"swap\":{\"total\":12884897792,\"free\":12657045504,\"used\":227852288}}',0,NULL,NULL,52,'2016-12-01 13:20:36','2016-12-01 13:20:36'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec84\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.28\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":4018774016,\"free\":270680064,\"used\":3747680256},\"swap\":{\"total\":4294963200,\"free\":4294963200,\"used\":0}}',0,NULL,NULL,53,'2016-12-01 13:28:56','2016-12-01 13:28:56'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec84\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.28\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":4018774016,\"free\":268091392,\"used\":3750014976},\"swap\":{\"total\":4294963200,\"free\":4294963200,\"used\":0}}',0,NULL,NULL,54,'2016-12-01 13:29:56','2016-12-01 13:29:56'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec83\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.27\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":145833984,\"used\":8108748800},\"swap\":{\"total\":4294963200,\"free\":0,\"used\":4294963200}}',0,NULL,NULL,55,'2016-12-01 13:34:20','2016-12-01 13:34:20'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":743952384,\"used\":7510376448},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,56,'2016-12-01 13:37:09','2016-12-01 13:37:09'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.26\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":625803264,\"used\":7628779520},\"swap\":{\"total\":12884897792,\"free\":12657045504,\"used\":227852288}}',0,NULL,NULL,57,'2016-12-01 13:38:27','2016-12-01 13:38:27'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":748298240,\"used\":7506030592},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,58,'2016-12-01 13:39:02','2016-12-01 13:39:02'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec83\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.27\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":146505728,\"used\":8108077056},\"swap\":{\"total\":4294963200,\"free\":16384,\"used\":4294946816}}',0,NULL,NULL,59,'2016-12-01 13:39:26','2016-12-01 13:39:26'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.26\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":624230400,\"used\":7629651968},\"swap\":{\"total\":12884897792,\"free\":12657045504,\"used\":227852288}}',0,NULL,NULL,60,'2016-12-01 13:39:27','2016-12-01 13:39:27'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":734547968,\"used\":7519334400},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,61,'2016-12-01 13:40:02','2016-12-01 13:40:02'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":722300928,\"used\":7532138496},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,62,'2016-12-01 13:46:55','2016-12-01 13:46:55'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":722251776,\"used\":7532507136},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,63,'2016-12-01 13:47:37','2016-12-01 13:47:37'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":724156416,\"used\":7530553344},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,64,'2016-12-01 13:47:43','2016-12-01 13:47:43'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec83\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.27\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":188559360,\"used\":8065847296},\"swap\":{\"total\":4294963200,\"free\":0,\"used\":4294963200}}',0,NULL,NULL,65,'2016-12-01 13:48:29','2016-12-01 13:48:29'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec83\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.27\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":187719680,\"used\":8066736128},\"swap\":{\"total\":4294963200,\"free\":0,\"used\":4294963200}}',0,NULL,NULL,66,'2016-12-01 13:48:33','2016-12-01 13:48:33'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec80\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.88\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":724316160,\"used\":7530123264},\"swap\":{\"total\":17179865088,\"free\":16672690176,\"used\":507174912}}',0,NULL,NULL,67,'2016-12-01 13:48:43','2016-12-01 13:48:43'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec83\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.27\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":188792832,\"used\":8065519616},\"swap\":{\"total\":4294963200,\"free\":0,\"used\":4294963200}}',0,NULL,NULL,68,'2016-12-01 13:49:33','2016-12-01 13:49:33'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec84\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.28\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":4018774016,\"free\":267669504,\"used\":3750817792},\"swap\":{\"total\":4294963200,\"free\":4294963200,\"used\":0}}',0,NULL,NULL,69,'2016-12-01 13:49:38','2016-12-01 13:49:38'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec84\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.28\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":4018774016,\"free\":271552512,\"used\":3746537472},\"swap\":{\"total\":4294963200,\"free\":4294963200,\"used\":0}}',0,NULL,NULL,70,'2016-12-01 13:50:38','2016-12-01 13:50:38'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.26\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":588775424,\"used\":7665745920},\"swap\":{\"total\":12884897792,\"free\":12657045504,\"used\":227852288}}',0,NULL,NULL,71,'2016-12-01 13:50:46','2016-12-01 13:50:46'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.26\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":8254996480,\"free\":590950400,\"used\":7663489024},\"swap\":{\"total\":12884897792,\"free\":12657045504,\"used\":227852288}}',0,NULL,NULL,72,'2016-12-01 13:51:46','2016-12-01 13:51:46'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec84\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.28\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":4018774016,\"free\":268161024,\"used\":3750199296},\"swap\":{\"total\":4294963200,\"free\":4294963200,\"used\":0}}',0,NULL,NULL,73,'2016-12-01 13:53:21','2016-12-01 13:53:21'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"unknown\",\"release\":\"unknown\",\"codename\":\"\",\"kernel\":\"2.6.32-642.3.1.el6.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplec84\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.28\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":1},\"memory\":{\"total\":4018774016,\"free\":272187392,\"used\":3746283520},\"swap\":{\"total\":4294963200,\"free\":4294963200,\"used\":0}}',0,NULL,NULL,74,'2016-12-01 13:54:21','2016-12-01 13:54:21'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Red Hat Enterprise Linux Server\",\"release\":\"7.2\",\"codename\":\"\",\"kernel\":\"3.10.0-327.22.2.el7.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplus82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.2\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":2},\"memory\":{\"total\":12431581184,\"free\":2967441408,\"used\":9463500800},\"swap\":{\"total\":20971515904,\"free\":20971515904,\"used\":0}}',0,NULL,NULL,75,'2016-12-01 14:05:04','2016-12-01 14:05:04'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Red Hat Enterprise Linux Server\",\"release\":\"7.2\",\"codename\":\"\",\"kernel\":\"3.10.0-327.22.2.el7.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplus82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.2\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":2},\"memory\":{\"total\":12431581184,\"free\":2967199744,\"used\":9463078912},\"swap\":{\"total\":20971515904,\"free\":20971515904,\"used\":0}}',0,NULL,NULL,76,'2016-12-01 14:05:22','2016-12-01 14:05:22'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Red Hat Enterprise Linux Server\",\"release\":\"7.2\",\"codename\":\"\",\"kernel\":\"3.10.0-327.22.2.el7.x86_64\",\"arch\":\"x64\",\"hostname\":\"srplus82\",\"logofile\":\"linux\"},\"ipv4\":\"10.140.2.2\",\"ipv6\":\"\",\"cpu\":{\"manufacturer\":\"Intel®\",\"brand\":\"Xeon® E5-4650 0\",\"speed\":\"2.70\",\"cores\":2},\"memory\":{\"total\":12431581184,\"free\":2983981056,\"used\":9447194624},\"swap\":{\"total\":20971515904,\"free\":20971515904,\"used\":0}}',0,NULL,NULL,77,'2016-12-01 14:06:22','2016-12-01 14:06:22'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Ubuntu\",\"release\":\"14.04\",\"codename\":\"trusty\",\"kernel\":\"3.4.0+\",\"arch\":\"x64\",\"hostname\":\"NBWK4UF75V1M\",\"logofile\":\"ubuntu\"},\"cpu\":{\"total\":17055182848,\"free\":9770819584,\"used\":7282360320},\"memory\":{\"total\":2550136832,\"free\":2514563072,\"used\":35573760}}',0,NULL,NULL,78,'2016-12-01 14:16:43','2016-12-01 14:16:43'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Ubuntu\",\"release\":\"14.04\",\"codename\":\"trusty\",\"kernel\":\"3.4.0+\",\"arch\":\"x64\",\"hostname\":\"NBWK4UF75V1M\",\"logofile\":\"ubuntu\"},\"cpu\":{\"total\":17055182848,\"free\":9747902464,\"used\":7302856704},\"memory\":{\"total\":2550136832,\"free\":2514563072,\"used\":35573760}}',0,NULL,NULL,79,'2016-12-01 14:30:39','2016-12-01 14:30:39'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Ubuntu\",\"release\":\"14.04\",\"codename\":\"trusty\",\"kernel\":\"3.4.0+\",\"arch\":\"x64\",\"hostname\":\"NBWK4UF75V1M\",\"logofile\":\"ubuntu\"},\"cpu\":{\"total\":17055182848,\"free\":9758121984,\"used\":7288770560},\"memory\":{\"total\":2550136832,\"free\":2514563072,\"used\":35573760}}',0,NULL,NULL,80,'2016-12-01 14:31:39','2016-12-01 14:31:39'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Ubuntu\",\"release\":\"14.04\",\"codename\":\"trusty\",\"kernel\":\"3.4.0+\",\"arch\":\"x64\",\"hostname\":\"NBWK4UF75V1M\",\"logofile\":\"ubuntu\"},\"cpu\":{\"total\":17055182848,\"free\":9745027072,\"used\":7301492736},\"memory\":{\"total\":2550136832,\"free\":2514563072,\"used\":35573760}}',0,NULL,NULL,81,'2016-12-01 14:32:23','2016-12-01 14:32:23'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Ubuntu\",\"release\":\"14.04\",\"codename\":\"trusty\",\"kernel\":\"3.4.0+\",\"arch\":\"x64\",\"hostname\":\"NBWK4UF75V1M\",\"logofile\":\"ubuntu\"},\"cpu\":{\"total\":17055182848,\"free\":9756971008,\"used\":7290114048},\"memory\":{\"total\":2550136832,\"free\":2514563072,\"used\":35573760}}',0,NULL,NULL,82,'2016-12-01 14:33:14','2016-12-01 14:33:14'),('agent','{\"osinfo\":{\"platform\":\"Linux\",\"distro\":\"Ubuntu\",\"release\":\"14.04\",\"codename\":\"trusty\",\"kernel\":\"3.4.0+\",\"arch\":\"x64\",\"hostname\":\"NBWK4UF75V1M\",\"logofile\":\"ubuntu\"},\"cpu\":{\"total\":17055182848,\"free\":9768128512,\"used\":7279308800},\"memory\":{\"total\":2550136832,\"free\":2514563072,\"used\":35573760}}',0,NULL,NULL,83,'2016-12-01 14:33:23','2016-12-01 14:33:23');
308/*!40000 ALTER TABLE `metadata` ENABLE KEYS */;
309UNLOCK TABLES;
310
311--
312-- Table structure for table `role`
313--
314
315DROP TABLE IF EXISTS `role`;
316/*!40101 SET @saved_cs_client = @@character_set_client */;
317/*!40101 SET character_set_client = utf8 */;
318CREATE TABLE `role` (
319 `name` longtext,
320 `abbreviation` varchar(255) DEFAULT NULL,
321 `isDeleted` tinyint(1) DEFAULT NULL,
322 `createdBy` int(11) DEFAULT NULL,
323 `updatedBy` int(11) DEFAULT NULL,
324 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
325 `createdAt` datetime DEFAULT NULL,
326 `updatedAt` datetime DEFAULT NULL,
327 PRIMARY KEY (`id`)
328) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
329/*!40101 SET character_set_client = @saved_cs_client */;
330
331--
332-- Dumping data for table `role`
333--
334
335LOCK TABLES `role` WRITE;
336/*!40000 ALTER TABLE `role` DISABLE KEYS */;
337INSERT INTO `role` VALUES ('Other','OTH',0,NULL,NULL,1,'2016-11-08 18:44:43','2016-11-08 18:44:43'),('SAP Dialog','SAPDI',0,NULL,NULL,2,'2016-11-08 18:44:43','2016-11-08 18:44:43'),('Generic App','APP',0,NULL,NULL,3,'2016-11-08 18:44:43','2016-11-08 18:44:43'),('SAP Message','SAPMS',0,NULL,NULL,4,'2016-11-08 18:44:43','2016-11-08 18:44:43'),('Vertex App','VTX',0,NULL,NULL,5,'2016-11-08 18:44:43','2016-11-08 18:44:43'),('SAP Oracle DB','DB',0,NULL,NULL,6,'2016-11-08 18:44:43','2016-11-08 18:44:43'),('SAP Oracle DG','DG',0,NULL,NULL,7,'2016-11-08 18:44:43','2016-11-08 18:44:43');
338/*!40000 ALTER TABLE `role` ENABLE KEYS */;
339UNLOCK TABLES;
340
341--
342-- Table structure for table `role_servers__server_roles`
343--
344
345DROP TABLE IF EXISTS `role_servers__server_roles`;
346/*!40101 SET @saved_cs_client = @@character_set_client */;
347/*!40101 SET character_set_client = utf8 */;
348CREATE TABLE `role_servers__server_roles` (
349 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
350 `role_servers` int(11) DEFAULT NULL,
351 `server_roles` int(11) DEFAULT NULL,
352 PRIMARY KEY (`id`)
353) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
354/*!40101 SET character_set_client = @saved_cs_client */;
355
356--
357-- Dumping data for table `role_servers__server_roles`
358--
359
360LOCK TABLES `role_servers__server_roles` WRITE;
361/*!40000 ALTER TABLE `role_servers__server_roles` DISABLE KEYS */;
362INSERT INTO `role_servers__server_roles` VALUES (1,6,1),(2,7,4),(3,6,3),(4,1,6);
363/*!40000 ALTER TABLE `role_servers__server_roles` ENABLE KEYS */;
364UNLOCK TABLES;
365
366--
367-- Table structure for table `server`
368--
369
370DROP TABLE IF EXISTS `server`;
371/*!40101 SET @saved_cs_client = @@character_set_client */;
372/*!40101 SET character_set_client = utf8 */;
373CREATE TABLE `server` (
374 `hostname` varchar(255) DEFAULT NULL,
375 `cpu` int(11) DEFAULT NULL,
376 `ram` float DEFAULT NULL,
377 `swap` float DEFAULT NULL,
378 `dns` longtext,
379 `sid` varchar(255) DEFAULT NULL,
380 `ipv4` varchar(255) DEFAULT NULL,
381 `ipv6` varchar(255) DEFAULT NULL,
382 `isDeleted` tinyint(1) DEFAULT NULL,
383 `tags` int(11) DEFAULT NULL,
384 `tier` int(11) DEFAULT NULL,
385 `agent` int(11) DEFAULT NULL,
386 `component` int(11) DEFAULT NULL,
387 `location` int(11) DEFAULT NULL,
388 `createdBy` int(11) DEFAULT NULL,
389 `updatedBy` int(11) DEFAULT NULL,
390 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
391 `createdAt` datetime DEFAULT NULL,
392 `updatedAt` datetime DEFAULT NULL,
393 PRIMARY KEY (`id`),
394 UNIQUE KEY `hostname` (`hostname`)
395) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
396/*!40101 SET character_set_client = @saved_cs_client */;
397
398--
399-- Dumping data for table `server`
400--
401
402LOCK TABLES `server` WRITE;
403/*!40000 ALTER TABLE `server` DISABLE KEYS */;
404INSERT INTO `server` VALUES ('SRPLEC82',NULL,NULL,NULL,NULL,'ECZ','10.140.2.26','',0,NULL,5,1,7,2,1,1,9,'2016-12-01 13:15:32','2016-12-01 13:15:32'),('SRPLEC80',NULL,NULL,NULL,NULL,'ECZ','10.140.2.88','',0,NULL,5,4,7,2,1,1,10,'2016-12-01 13:15:32','2016-12-01 13:36:38'),('SRPLEC83',NULL,NULL,NULL,NULL,'ECZ','10.140.2.27','',0,NULL,5,3,7,2,1,1,11,'2016-12-01 13:15:32','2016-12-01 13:33:54'),('SRPLEC84',NULL,NULL,NULL,NULL,'ECZ','10.140.2.28','',0,NULL,5,2,7,2,1,1,12,'2016-12-01 13:15:32','2016-12-01 13:27:46'),('SRPLUS82',NULL,NULL,NULL,NULL,'BUS','10.140.2.2','',0,NULL,5,5,16,2,1,1,13,NULL,'2016-12-01 14:03:55'),('NBWK4UF75V1M',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,5,6,16,2,1,1,14,NULL,'2016-12-01 14:16:02');
405/*!40000 ALTER TABLE `server` ENABLE KEYS */;
406UNLOCK TABLES;
407
408--
409-- Table structure for table `tag`
410--
411
412DROP TABLE IF EXISTS `tag`;
413/*!40101 SET @saved_cs_client = @@character_set_client */;
414/*!40101 SET character_set_client = utf8 */;
415CREATE TABLE `tag` (
416 `name` varchar(255) DEFAULT NULL,
417 `isDeleted` tinyint(1) DEFAULT NULL,
418 `createdBy` int(11) DEFAULT NULL,
419 `updatedBy` int(11) DEFAULT NULL,
420 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
421 `createdAt` datetime DEFAULT NULL,
422 `updatedAt` datetime DEFAULT NULL,
423 PRIMARY KEY (`id`)
424) ENGINE=InnoDB DEFAULT CHARSET=utf8;
425/*!40101 SET character_set_client = @saved_cs_client */;
426
427--
428-- Dumping data for table `tag`
429--
430
431LOCK TABLES `tag` WRITE;
432/*!40000 ALTER TABLE `tag` DISABLE KEYS */;
433/*!40000 ALTER TABLE `tag` ENABLE KEYS */;
434UNLOCK TABLES;
435
436--
437-- Table structure for table `tier`
438--
439
440DROP TABLE IF EXISTS `tier`;
441/*!40101 SET @saved_cs_client = @@character_set_client */;
442/*!40101 SET character_set_client = utf8 */;
443CREATE TABLE `tier` (
444 `name` varchar(255) DEFAULT NULL,
445 `abbreviation` varchar(255) DEFAULT NULL,
446 `isDeleted` tinyint(1) DEFAULT NULL,
447 `landscape` int(11) DEFAULT NULL,
448 `createdBy` int(11) DEFAULT NULL,
449 `updatedBy` int(11) DEFAULT NULL,
450 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
451 `createdAt` datetime DEFAULT NULL,
452 `updatedAt` datetime DEFAULT NULL,
453 PRIMARY KEY (`id`)
454) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
455/*!40101 SET character_set_client = @saved_cs_client */;
456
457--
458-- Dumping data for table `tier`
459--
460
461LOCK TABLES `tier` WRITE;
462/*!40000 ALTER TABLE `tier` DISABLE KEYS */;
463INSERT INTO `tier` VALUES ('Production','PROD',0,NULL,1,1,1,'2016-11-08 18:44:39','2016-11-08 18:44:39'),('Quality Assurance','QA',0,NULL,1,1,2,'2016-11-08 18:44:39','2016-11-08 18:44:39'),('Test','TEST',0,NULL,1,1,3,'2016-11-08 18:44:39','2016-11-08 18:44:39'),('Development','DEV',0,NULL,1,1,4,'2016-11-08 18:44:39','2016-11-08 18:44:39'),('Technical Sandbox','TSBOX',0,1,1,1,5,'2016-11-08 18:44:39','2016-11-08 18:44:39');
464/*!40000 ALTER TABLE `tier` ENABLE KEYS */;
465UNLOCK TABLES;
466
467--
468-- Table structure for table `user`
469--
470
471DROP TABLE IF EXISTS `user`;
472/*!40101 SET @saved_cs_client = @@character_set_client */;
473/*!40101 SET character_set_client = utf8 */;
474CREATE TABLE `user` (
475 `username` varchar(255) DEFAULT NULL,
476 `password` varchar(255) DEFAULT NULL,
477 `email` varchar(255) DEFAULT NULL,
478 `firstName` varchar(255) DEFAULT NULL,
479 `lastName` varchar(255) DEFAULT NULL,
480 `photo` varchar(255) DEFAULT NULL,
481 `accountType` varchar(255) DEFAULT NULL,
482 `lastLogin` date DEFAULT NULL,
483 `isDeleted` tinyint(1) DEFAULT NULL,
484 `group` int(11) DEFAULT NULL,
485 `createdBy` int(11) DEFAULT NULL,
486 `updatedBy` int(11) DEFAULT NULL,
487 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
488 `createdAt` datetime DEFAULT NULL,
489 `updatedAt` datetime DEFAULT NULL,
490 PRIMARY KEY (`id`),
491 UNIQUE KEY `username` (`username`),
492 UNIQUE KEY `email` (`email`)
493) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
494/*!40101 SET character_set_client = @saved_cs_client */;
495
496--
497-- Dumping data for table `user`
498--
499
500LOCK TABLES `user` WRITE;
501/*!40000 ALTER TABLE `user` DISABLE KEYS */;
502INSERT INTO `user` VALUES ('admin','$2a$10$Fw0oBygrSs8KKYRNIBh8ousXz33GQXw6Nz3qTcTt8Djwd4fqx/L8q','admin@admin.com','Admin','User','','local','2016-12-06',0,1,NULL,NULL,1,'2016-11-09 16:14:13','2016-12-06 09:39:49');
503/*!40000 ALTER TABLE `user` ENABLE KEYS */;
504UNLOCK TABLES;
505/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
506
507/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
508/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
509/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
510/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
511/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
512/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
513/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
514
515-- Dump completed on 2016-12-09 16:11:42