SHARE
TWEET

Untitled

a guest Jun 18th, 2019 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- --------------------------------------------------------
  2. -- Host:                         127.0.0.1
  3. -- Server Version:               10.3.13-MariaDB - mariadb.org binary distribution
  4. -- Server Betriebssystem:        Win64
  5. -- HeidiSQL Version:             9.5.0.5196
  6. -- --------------------------------------------------------
  7.  
  8. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  9. /*!40101 SET NAMES utf8 */;
  10. /*!50503 SET NAMES utf8mb4 */;
  11. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  12. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  13.  
  14.  
  15. -- Exportiere Datenbank Struktur für processeddata
  16. CREATE DATABASE IF NOT EXISTS `processeddata` /*!40100 DEFAULT CHARACTER SET utf8 */;
  17. USE `processeddata`;
  18.  
  19. -- Exportiere Struktur von Tabelle processeddata.company
  20. CREATE TABLE IF NOT EXISTS `company` (
  21.   `name` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  22.   `displayName` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  23.   `city` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  24.   `employeeCount` int(11) DEFAULT NULL,
  25.   `website` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  26.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  27.   PRIMARY KEY (`id`)
  28. ) ENGINE=InnoDB AUTO_INCREMENT=15400 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  29.  
  30. -- Daten Export vom Benutzer nicht ausgewählt
  31. -- Exportiere Struktur von Tabelle processeddata.companyperk
  32. CREATE TABLE IF NOT EXISTS `companyperk` (
  33.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  34.   `name` varchar(80) DEFAULT NULL,
  35.   PRIMARY KEY (`id`)
  36. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  37.  
  38. -- Daten Export vom Benutzer nicht ausgewählt
  39. -- Exportiere Struktur von Tabelle processeddata.companyperk_joboffer
  40. CREATE TABLE IF NOT EXISTS `companyperk_joboffer` (
  41.   `jobofferId` bigint(20),
  42.   `companyperkId` bigint(20),
  43.   KEY `companyPerkId` (`companyperkId`),
  44.   KEY `fk_jobofferId_companyperkId` (`jobofferId`),
  45.   CONSTRAINT `fk_companyperkId_joboffer` FOREIGN KEY (`companyperkId`) REFERENCES `companyperk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  46.   CONSTRAINT `fk_jobofferId_companyperkId` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE
  47. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  48.  
  49. -- Daten Export vom Benutzer nicht ausgewählt
  50. -- Exportiere Struktur von Tabelle processeddata.joboffer
  51. CREATE TABLE IF NOT EXISTS `joboffer` (
  52.   `stepstoneId` bigint(20) NOT NULL,
  53.   `employmentType` varchar(50) DEFAULT NULL,
  54.   `minYears` int(11) DEFAULT NULL,
  55.   `rank` varchar(80) DEFAULT NULL,
  56.   `workingHours` varchar(50) DEFAULT NULL,
  57.   `title` varchar(200) DEFAULT NULL,
  58.   `location` varchar(200) DEFAULT NULL,
  59.   `salutation` tinyint(4) DEFAULT NULL COMMENT '1=sitzen',
  60.   `companyId` bigint(20) DEFAULT NULL,
  61.   PRIMARY KEY (`stepstoneId`),
  62.   KEY `fk_company_joboffer` (`companyId`),
  63.   CONSTRAINT `fk_company_joboffer` FOREIGN KEY (`companyId`) REFERENCES `company` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  64. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  65.  
  66. -- Daten Export vom Benutzer nicht ausgewählt
  67. -- Exportiere Struktur von Tabelle processeddata.keyword
  68. CREATE TABLE IF NOT EXISTS `keyword` (
  69.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  70.   `name` varchar(120) DEFAULT NULL,
  71.   PRIMARY KEY (`id`)
  72. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  73.  
  74. -- Daten Export vom Benutzer nicht ausgewählt
  75. -- Exportiere Struktur von Tabelle processeddata.keyword_joboffer
  76. CREATE TABLE IF NOT EXISTS `keyword_joboffer` (
  77.   `keywordId` bigint(20) DEFAULT NULL,
  78.   `jobofferId` bigint(20) DEFAULT NULL,
  79.   KEY `fk_jobofferId_keyword` (`jobofferId`),
  80.   KEY `fk_keywordId_joboffer` (`keywordId`),
  81.   CONSTRAINT `fk_jobofferId_keyword` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  82.   CONSTRAINT `fk_keywordId_joboffer` FOREIGN KEY (`keywordId`) REFERENCES `keyword` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  83. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  84.  
  85. -- Daten Export vom Benutzer nicht ausgewählt
  86. -- Exportiere Struktur von Tabelle processeddata.location
  87. CREATE TABLE IF NOT EXISTS `location` (
  88.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  89.   `name` varchar(100) DEFAULT NULL,
  90.   PRIMARY KEY (`id`)
  91. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  92.  
  93. -- Daten Export vom Benutzer nicht ausgewählt
  94. -- Exportiere Struktur von Tabelle processeddata.location_joboffer
  95. CREATE TABLE IF NOT EXISTS `location_joboffer` (
  96.   `locationId` bigint(20) NOT NULL,
  97.   `jobofferId` bigint(20) NOT NULL,
  98.   KEY `fk_locationId_joboffer` (`locationId`),
  99.   KEY `fk_jobofferId_location` (`jobofferId`),
  100.   CONSTRAINT `fk_jobofferId_location` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  101.   CONSTRAINT `fk_locationId_joboffer` FOREIGN KEY (`locationId`) REFERENCES `location` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  102. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  103.  
  104. -- Daten Export vom Benutzer nicht ausgewählt
  105. -- Exportiere Struktur von Tabelle processeddata.requirement
  106. CREATE TABLE IF NOT EXISTS `requirement` (
  107.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  108.   `name` varchar(100) NOT NULL,
  109.   PRIMARY KEY (`id`)
  110. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  111.  
  112. -- Daten Export vom Benutzer nicht ausgewählt
  113. -- Exportiere Struktur von Tabelle processeddata.requirement_joboffer
  114. CREATE TABLE IF NOT EXISTS `requirement_joboffer` (
  115.   `requirementId` bigint(20) NOT NULL,
  116.   `jobofferId` bigint(20) NOT NULL,
  117.   KEY `fk_jobofferId_requirement` (`jobofferId`),
  118.   KEY `fk_requirementId_joboffer` (`requirementId`),
  119.   CONSTRAINT `fk_jobofferId_requirement` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  120.   CONSTRAINT `fk_requirementId_joboffer` FOREIGN KEY (`requirementId`) REFERENCES `requirement` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  121. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  122.  
  123. -- Daten Export vom Benutzer nicht ausgewählt
  124. -- Exportiere Struktur von Tabelle processeddata.technology
  125. CREATE TABLE IF NOT EXISTS `technology` (
  126.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
  127.   `name` varchar(120) NOT NULL,
  128.   PRIMARY KEY (`id`)
  129. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  130.  
  131. -- Daten Export vom Benutzer nicht ausgewählt
  132. -- Exportiere Struktur von Tabelle processeddata.technology_joboffer
  133. CREATE TABLE IF NOT EXISTS `technology_joboffer` (
  134.   `technologyId` bigint(20) NOT NULL,
  135.   `jobofferId` bigint(20) NOT NULL,
  136.   KEY `fk_technologyId_joboffer` (`technologyId`),
  137.   KEY `fk_jobofferId_technology` (`jobofferId`),
  138.   CONSTRAINT `fk_jobofferId_technology` FOREIGN KEY (`jobofferId`) REFERENCES `joboffer` (`stepstoneId`) ON DELETE CASCADE ON UPDATE CASCADE,
  139.   CONSTRAINT `fk_technologyId_joboffer` FOREIGN KEY (`technologyId`) REFERENCES `technology` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  140. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  141.  
  142. -- Daten Export vom Benutzer nicht ausgewählt
  143. /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  144. /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  145. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top