Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.14 Distrib 5.5.47-MariaDB, for Linux (x86_64)
- --
- -- Host: localhost Database: sapinfrastructure_dev
- -- ------------------------------------------------------
- -- Server version 5.5.47-MariaDB
- /*!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 */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `agent`
- --
- DROP TABLE IF EXISTS `agent`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `agent` (
- `agentKey` varchar(255) DEFAULT NULL,
- `enabled` tinyint(1) DEFAULT NULL,
- `connected` tinyint(1) DEFAULT NULL,
- `socketId` varchar(255) DEFAULT NULL,
- `server` int(11) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `agent`
- --
- LOCK TABLES `agent` WRITE;
- /*!40000 ALTER TABLE `agent` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `agent` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `agent_metadata__metadata_agent`
- --
- DROP TABLE IF EXISTS `agent_metadata__metadata_agent`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `agent_metadata__metadata_agent` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `agent_metadata` int(11) DEFAULT NULL,
- `metadata_agent` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `agent_metadata__metadata_agent`
- --
- LOCK TABLES `agent_metadata__metadata_agent` WRITE;
- /*!40000 ALTER TABLE `agent_metadata__metadata_agent` DISABLE KEYS */;
- INSERT 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);
- /*!40000 ALTER TABLE `agent_metadata__metadata_agent` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `audit`
- --
- DROP TABLE IF EXISTS `audit`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `audit` (
- `id` varchar(255) NOT NULL,
- `ipAddress` varchar(255) DEFAULT NULL,
- `method` varchar(255) DEFAULT NULL,
- `url` varchar(255) DEFAULT NULL,
- `body` longtext,
- `user` int(11) DEFAULT NULL,
- `action` varchar(255) DEFAULT NULL,
- `controller` varchar(255) DEFAULT NULL,
- `model` varchar(255) DEFAULT NULL,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `audit`
- --
- LOCK TABLES `audit` WRITE;
- /*!40000 ALTER TABLE `audit` DISABLE KEYS */;
- /*!40000 ALTER TABLE `audit` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `comment`
- --
- DROP TABLE IF EXISTS `comment`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `comment` (
- `message` varchar(255) DEFAULT NULL,
- `isDeleted` varchar(255) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `comment`
- --
- LOCK TABLES `comment` WRITE;
- /*!40000 ALTER TABLE `comment` DISABLE KEYS */;
- /*!40000 ALTER TABLE `comment` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `comment_server__server_comments`
- --
- DROP TABLE IF EXISTS `comment_server__server_comments`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `comment_server__server_comments` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `comment_server` int(11) DEFAULT NULL,
- `server_comments` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `comment_server__server_comments`
- --
- LOCK TABLES `comment_server__server_comments` WRITE;
- /*!40000 ALTER TABLE `comment_server__server_comments` DISABLE KEYS */;
- /*!40000 ALTER TABLE `comment_server__server_comments` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `component`
- --
- DROP TABLE IF EXISTS `component`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `component` (
- `name` varchar(255) DEFAULT NULL,
- `abbreviation` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`)
- ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `component`
- --
- LOCK TABLES `component` WRITE;
- /*!40000 ALTER TABLE `component` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `component` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `group`
- --
- DROP TABLE IF EXISTS `group`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `group` (
- `name` varchar(255) DEFAULT NULL,
- `accessLevel` int(11) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `group`
- --
- LOCK TABLES `group` WRITE;
- /*!40000 ALTER TABLE `group` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `group` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `landscape`
- --
- DROP TABLE IF EXISTS `landscape`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `landscape` (
- `name` varchar(255) DEFAULT NULL,
- `abbreviation` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- UNIQUE KEY `abbreviation` (`abbreviation`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `landscape`
- --
- LOCK TABLES `landscape` WRITE;
- /*!40000 ALTER TABLE `landscape` DISABLE KEYS */;
- /*!40000 ALTER TABLE `landscape` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `location`
- --
- DROP TABLE IF EXISTS `location`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `location` (
- `name` varchar(255) DEFAULT NULL,
- `abbreviation` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `name` (`name`),
- UNIQUE KEY `abbreviation` (`abbreviation`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `location`
- --
- LOCK TABLES `location` WRITE;
- /*!40000 ALTER TABLE `location` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `location` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `metadata`
- --
- DROP TABLE IF EXISTS `metadata`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `metadata` (
- `via` varchar(255) DEFAULT NULL,
- `data` longtext,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `metadata`
- --
- LOCK TABLES `metadata` WRITE;
- /*!40000 ALTER TABLE `metadata` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `metadata` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `role`
- --
- DROP TABLE IF EXISTS `role`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role` (
- `name` longtext,
- `abbreviation` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `role`
- --
- LOCK TABLES `role` WRITE;
- /*!40000 ALTER TABLE `role` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `role` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `role_servers__server_roles`
- --
- DROP TABLE IF EXISTS `role_servers__server_roles`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `role_servers__server_roles` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `role_servers` int(11) DEFAULT NULL,
- `server_roles` int(11) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `role_servers__server_roles`
- --
- LOCK TABLES `role_servers__server_roles` WRITE;
- /*!40000 ALTER TABLE `role_servers__server_roles` DISABLE KEYS */;
- INSERT INTO `role_servers__server_roles` VALUES (1,6,1),(2,7,4),(3,6,3),(4,1,6);
- /*!40000 ALTER TABLE `role_servers__server_roles` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `server`
- --
- DROP TABLE IF EXISTS `server`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `server` (
- `hostname` varchar(255) DEFAULT NULL,
- `cpu` int(11) DEFAULT NULL,
- `ram` float DEFAULT NULL,
- `swap` float DEFAULT NULL,
- `dns` longtext,
- `sid` varchar(255) DEFAULT NULL,
- `ipv4` varchar(255) DEFAULT NULL,
- `ipv6` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `tags` int(11) DEFAULT NULL,
- `tier` int(11) DEFAULT NULL,
- `agent` int(11) DEFAULT NULL,
- `component` int(11) DEFAULT NULL,
- `location` int(11) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `hostname` (`hostname`)
- ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `server`
- --
- LOCK TABLES `server` WRITE;
- /*!40000 ALTER TABLE `server` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `server` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `tag`
- --
- DROP TABLE IF EXISTS `tag`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `tag` (
- `name` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `tag`
- --
- LOCK TABLES `tag` WRITE;
- /*!40000 ALTER TABLE `tag` DISABLE KEYS */;
- /*!40000 ALTER TABLE `tag` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `tier`
- --
- DROP TABLE IF EXISTS `tier`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `tier` (
- `name` varchar(255) DEFAULT NULL,
- `abbreviation` varchar(255) DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `landscape` int(11) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `tier`
- --
- LOCK TABLES `tier` WRITE;
- /*!40000 ALTER TABLE `tier` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `tier` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user`
- --
- DROP TABLE IF EXISTS `user`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!40101 SET character_set_client = utf8 */;
- CREATE TABLE `user` (
- `username` varchar(255) DEFAULT NULL,
- `password` varchar(255) DEFAULT NULL,
- `email` varchar(255) DEFAULT NULL,
- `firstName` varchar(255) DEFAULT NULL,
- `lastName` varchar(255) DEFAULT NULL,
- `photo` varchar(255) DEFAULT NULL,
- `accountType` varchar(255) DEFAULT NULL,
- `lastLogin` date DEFAULT NULL,
- `isDeleted` tinyint(1) DEFAULT NULL,
- `group` int(11) DEFAULT NULL,
- `createdBy` int(11) DEFAULT NULL,
- `updatedBy` int(11) DEFAULT NULL,
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `createdAt` datetime DEFAULT NULL,
- `updatedAt` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `username` (`username`),
- UNIQUE KEY `email` (`email`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `user`
- --
- LOCK TABLES `user` WRITE;
- /*!40000 ALTER TABLE `user` DISABLE KEYS */;
- INSERT 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');
- /*!40000 ALTER TABLE `user` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2016-12-09 16:11:42
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement