-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             7.0.0.4355
-- --------------------------------------------------------


-- Dumping structure for table process_event_logs.activities
CREATE TABLE IF NOT EXISTS `activities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.activities: ~0 rows (approximately)
DELETE FROM `activities`;


-- Dumping structure for table process_event_logs.log-based-graph-edges
CREATE TABLE IF NOT EXISTS `log-based-graph-edges` (
  `processId` int(11) NOT NULL,
  `sourceActivityId` int(11) NOT NULL,
  `targetActivityId` int(11) NOT NULL,
  `weight` int(11) DEFAULT NULL,
  PRIMARY KEY (`processId`,`sourceActivityId`,`targetActivityId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.log-based-graph-edges: ~0 rows (approximately)
DELETE FROM `log-based-graph-edges`;


-- Dumping structure for table process_event_logs.log-based-neighborhood-context-graph-edges
CREATE TABLE IF NOT EXISTS `log-based-neighborhood-context-graph-edges` (
  `processId` int(11) NOT NULL,
  `rootActivityId` int(11) NOT NULL,
  `sourceActivityId` int(11) NOT NULL,
  `targetActivityId` int(11) NOT NULL,
  `zone` int(11) NOT NULL,
  `weight` int(11) DEFAULT '0',
  PRIMARY KEY (`processId`,`rootActivityId`,`sourceActivityId`,`targetActivityId`,`zone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.log-based-neighborhood-context-graph-edges: ~0 rows (approximately)
DELETE FROM `log-based-neighborhood-context-graph-edges`;


-- Dumping structure for table process_event_logs.processes
CREATE TABLE IF NOT EXISTS `processes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.processes: ~0 rows (approximately)
DELETE FROM `processes`;


-- Dumping structure for table process_event_logs.process_activities
CREATE TABLE IF NOT EXISTS `process_activities` (
  `processId` int(11) NOT NULL,
  `activityId` int(11) NOT NULL,
  PRIMARY KEY (`processId`,`activityId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.process_activities: ~0 rows (approximately)
DELETE FROM `process_activities`;


-- Dumping structure for table process_event_logs.similarities
CREATE TABLE IF NOT EXISTS `similarities` (
  `processId1` varchar(45) NOT NULL,
  `activityId1` varchar(45) NOT NULL,
  `processId2` varchar(45) NOT NULL,
  `activityId2` varchar(45) NOT NULL,
  `zone` int(11) NOT NULL,
  `similarity` double DEFAULT '0',
  PRIMARY KEY (`processId1`,`activityId1`,`processId2`,`activityId2`,`zone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.similarities: ~0 rows (approximately)
DELETE FROM `similarities`;


-- Dumping structure for table process_event_logs.similarities-zoneweight
CREATE TABLE IF NOT EXISTS `similarities-zoneweight` (
  `processId1` varchar(45) NOT NULL,
  `activityId1` varchar(45) NOT NULL,
  `processId2` varchar(45) NOT NULL,
  `activityId2` varchar(45) NOT NULL,
  `kvalue` int(11) NOT NULL,
  `similarity` double DEFAULT '0',
  PRIMARY KEY (`kvalue`,`activityId2`,`processId2`,`activityId1`,`processId1`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table process_event_logs.similarities-zoneweight: ~0 rows (approximately)
DELETE FROM `similarities-zoneweight`;
