gridappsd_mysql_dump.sql

CREATE DATABASE gridappsd;

CREATE USER 'gridappsd'@'localhost' IDENTIFIED BY 'gridappsd1234';
GRANT ALL PRIVILEGES ON gridappsd.* TO 'gridappsd'@'localhost';
USE gridappsd;


-- MySQL dump 10.13  Distrib 5.7.17, for Linux (x86_64)
--
-- Host: localhost    Database: gridappsd
-- ------------------------------------------------------
-- Server version	5.7.17-0ubuntu0.16.04.2

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(255) NOT NULL,
  `process_id` varchar(255) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `log_message` TEXT NOT NULL,
  `log_level` varchar(20) NOT NULL,
  `process_status` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `process_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='This table contain log messages and status from variaous processes in gridappsd platform.';

--
-- Table structure for table `expected_results`
--
    DROP TABLE IF EXISTS `expected_results`;
    CREATE TABLE `expected_results` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `app_id` varchar(255) DEFAULT NULL,
      `test_id` varchar(255) DEFAULT NULL,
      `process_id_one` varchar(255) DEFAULT NULL,
      `process_id_two` varchar(255) DEFAULT NULL,
      `index_one` LONG DEFAULT NULL,
      `index_two` LONG DEFAULT NULL,
      `mrid` varchar(255) NOT NULL,
      `property` varchar(255) NOT NULL,
      `expected` varchar(255) NOT NULL,
      `actual` varchar(255)  NOT NULL,
      `difference_direction` varchar(255) NOT NULL,
      `difference_mrid` varchar(255)  NOT NULL,
      `match_flag` BOOL NOT NULL,
      `simulation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='This table contains messages for expected results';