SHARE
TWEET

Untitled

a guest May 21st, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.8.4
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: May 21, 2019 at 01:32 PM
  7. -- Server version: 10.3.11-MariaDB
  8. -- PHP Version: 5.6.39
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  13. SET time_zone = "+00:00";
  14.  
  15.  
  16. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  17. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  18. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  19. /*!40101 SET NAMES utf8mb4 */;
  20.  
  21. --
  22. -- Database: `ehvrsstripper`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Table structure for table `Competences`
  29. --
  30.  
  31. CREATE TABLE `Competences` (
  32.   `ID` int(11) NOT NULL,
  33.   `Name` varchar(100) NOT NULL,
  34.   `CvID` int(11) NOT NULL
  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  36.  
  37. -- --------------------------------------------------------
  38.  
  39. --
  40. -- Table structure for table `CourseExperiences`
  41. --
  42.  
  43. CREATE TABLE `CourseExperiences` (
  44.   `ID` int(11) NOT NULL,
  45.   `Name` varchar(100) NOT NULL,
  46.   `Year` datetime NOT NULL,
  47.   `Certificate` tinyint(1) NOT NULL,
  48.   `CVID` int(11) NOT NULL,
  49.   `OrganizationName` varchar(100) NOT NULL,
  50.   `LocationOrganization` varchar(100) NOT NULL
  51. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  52.  
  53. --
  54. -- Dumping data for table `CourseExperiences`
  55. --
  56.  
  57. INSERT INTO `CourseExperiences` (`ID`, `Name`, `Year`, `Certificate`, `CVID`, `OrganizationName`, `LocationOrganization`) VALUES
  58. (1, 'corse', '2001-01-01 00:00:00', 1, 1, 'inst', 'loca');
  59.  
  60. -- --------------------------------------------------------
  61.  
  62. --
  63. -- Table structure for table `CVs`
  64. --
  65.  
  66. CREATE TABLE `CVs` (
  67.   `ID` int(11) NOT NULL,
  68.   `Name` varchar(100) NOT NULL,
  69.   `Prefix` varchar(100) DEFAULT NULL,
  70.   `Surname` varchar(100) NOT NULL,
  71.   `Gender` int(11) NOT NULL,
  72.   `Residence` varchar(100) NOT NULL,
  73.   `Country` varchar(100) NOT NULL,
  74.   `DateOfBirth` datetime NOT NULL,
  75.   `Profile` varchar(20000) DEFAULT NULL
  76. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  77.  
  78. --
  79. -- Dumping data for table `CVs`
  80. --
  81.  
  82. INSERT INTO `CVs` (`ID`, `Name`, `Prefix`, `Surname`, `Gender`, `Residence`, `Country`, `DateOfBirth`, `Profile`) VALUES
  83. (1, 'bob', 'de', 'vries', 0, 'taco', 'land', '1997-02-05 00:00:00', 'wowow profiel'),
  84. (2, 'da', 'da', 'da', 0, 'da', 'da', '1997-05-05 00:00:00', NULL);
  85.  
  86. -- --------------------------------------------------------
  87.  
  88. --
  89. -- Table structure for table `EducationExperiences`
  90. --
  91.  
  92. CREATE TABLE `EducationExperiences` (
  93.   `ID` int(11) NOT NULL,
  94.   `Name` varchar(100) NOT NULL,
  95.   `LevelOfEducation` longtext NOT NULL,
  96.   `Diploma` tinyint(1) NOT NULL,
  97.   `BeginDate` datetime NOT NULL,
  98.   `EndDate` datetime NOT NULL,
  99.   `CVID` int(11) NOT NULL,
  100.   `OrganizationName` varchar(100) NOT NULL,
  101.   `LocationOrganization` varchar(100) NOT NULL
  102. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  103.  
  104. -- --------------------------------------------------------
  105.  
  106. --
  107. -- Table structure for table `Hobbies`
  108. --
  109.  
  110. CREATE TABLE `Hobbies` (
  111.   `ID` int(11) NOT NULL,
  112.   `Name` varchar(100) NOT NULL,
  113.   `CVID` int(11) NOT NULL
  114. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  115.  
  116. -- --------------------------------------------------------
  117.  
  118. --
  119. -- Table structure for table `Languages`
  120. --
  121.  
  122. CREATE TABLE `Languages` (
  123.   `ID` int(11) NOT NULL,
  124.   `Name` varchar(100) NOT NULL,
  125.   `Level` int(11) NOT NULL,
  126.   `LevelOfListening` int(11) NOT NULL,
  127.   `LevelOfSpeaking` int(11) NOT NULL,
  128.   `LevelOfWriting` int(11) NOT NULL,
  129.   `IsSimple` tinyint(1) NOT NULL,
  130.   `CV_ID` int(11) DEFAULT NULL
  131. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  132.  
  133. -- --------------------------------------------------------
  134.  
  135. --
  136. -- Table structure for table `LicenseCVs`
  137. --
  138.  
  139. CREATE TABLE `LicenseCVs` (
  140.   `License_ID` int(11) NOT NULL,
  141.   `CV_ID` int(11) NOT NULL
  142. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  143.  
  144. -- --------------------------------------------------------
  145.  
  146. --
  147. -- Table structure for table `Licenses`
  148. --
  149.  
  150. CREATE TABLE `Licenses` (
  151.   `ID` int(11) NOT NULL,
  152.   `Type` int(11) NOT NULL
  153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  154.  
  155. -- --------------------------------------------------------
  156.  
  157. --
  158. -- Table structure for table `References`
  159. --
  160.  
  161. CREATE TABLE `References` (
  162.   `ID` int(11) NOT NULL,
  163.   `CVID` int(11) NOT NULL,
  164.   `Name` varchar(100) NOT NULL,
  165.   `CompanyName` varchar(100) NOT NULL,
  166.   `JobTitle` varchar(100) NOT NULL,
  167.   `Email` longtext NOT NULL,
  168.   `PhoneNumber` longtext NOT NULL
  169. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  170.  
  171. -- --------------------------------------------------------
  172.  
  173. --
  174. -- Table structure for table `SidelineExperiences`
  175. --
  176.  
  177. CREATE TABLE `SidelineExperiences` (
  178.   `ID` int(11) NOT NULL,
  179.   `JobTitle` varchar(100) NOT NULL,
  180.   `TaskDescription` varchar(2000) NOT NULL,
  181.   `BeginDate` datetime NOT NULL,
  182.   `EndDate` datetime NOT NULL,
  183.   `CVID` int(11) NOT NULL,
  184.   `OrganizationName` varchar(100) NOT NULL,
  185.   `LocationOrganization` varchar(100) NOT NULL
  186. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  187.  
  188. -- --------------------------------------------------------
  189.  
  190. --
  191. -- Table structure for table `Skills`
  192. --
  193.  
  194. CREATE TABLE `Skills` (
  195.   `ID` int(11) NOT NULL,
  196.   `Name` varchar(100) NOT NULL,
  197.   `CVID` int(11) NOT NULL
  198. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  199.  
  200. -- --------------------------------------------------------
  201.  
  202. --
  203. -- Table structure for table `WorkExperiences`
  204. --
  205.  
  206. CREATE TABLE `WorkExperiences` (
  207.   `ID` int(11) NOT NULL,
  208.   `JobTitle` varchar(100) NOT NULL,
  209.   `TaskDescription` varchar(2000) NOT NULL,
  210.   `BeginDate` datetime NOT NULL,
  211.   `EndDate` datetime NOT NULL,
  212.   `CVID` int(11) NOT NULL,
  213.   `OrganizationName` varchar(100) NOT NULL,
  214.   `LocationOrganization` varchar(100) NOT NULL
  215. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  216.  
  217. -- --------------------------------------------------------
  218.  
  219. --
  220. -- Table structure for table `__MigrationHistory`
  221. --
  222.  
  223. CREATE TABLE `__MigrationHistory` (
  224.   `MigrationId` varchar(150) NOT NULL,
  225.   `ContextKey` varchar(300) NOT NULL,
  226.   `Model` longblob NOT NULL,
  227.   `ProductVersion` varchar(32) NOT NULL
  228. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  229.  
  230. --
  231. -- Dumping data for table `__MigrationHistory`
  232. --
  233.  
  234. INSERT INTO `__MigrationHistory` (`MigrationId`, `ContextKey`, `Model`, `ProductVersion`) VALUES
  235. ('201904291242434_initialmigration', 'ResumeStripper.Migrations.Configuration', 0x1f8b0800000000000400ed1dd96ee3c8f13d40fe41d063306bd99ecc66d7b077614bf6c6898fc1c8a34d9e0c5a6ccbc4f0d0f230ac04f9b23ce493f20b69de7d545f24257126c40003ab8feaeaae83ddd5d555fffdf77f4e7f7ef3dcd12b0a2327f0cfc6470787e311f29781edf8abb371123f7ff7c3f8e79f7effbbd34bdb7b1b2dca76efd376b8a71f9d8d5fe2787d329944cb17e459d181e72cc3200a9ee38365e04d2c3b981c1f1efe38393a9a200c628c618d46a79f123f763c94fdc03fa781bf44eb38b1dcdbc0466e5494e39a790675746779285a5b4b7436fe84a2c443f33874d66b141eccce6fc6a373d7b1302673e43e8f4796ef07b115633c4f3e4769c3c05fcdd7b8c0721f366b84db3d5b6e840afc4feae6ba53393c4ea732a93b96a0964914079e21c0a3f7c5da4cd8ee8d56785cad1d5ebd4bbccaf1269d75b68267e369e0ad518c098ca7cf0e773275c3b429b7c4394d0eeabeef46748b77156360fe49ffbd1b4d13374e4274e6a3240e2df7dde863f2e43acbbfa2cd43f005f9677ee2ba24aa18595c4715e0a28f6180c1c79b4fe8b998c0f56c3c9ad0fd266cc7aa1bd1279fd8b51fbf3f1e8feef0e0d6938b2a4e2016611e0721fa05f928b462647fb4e218859890d736cad6921b9d192bfdbf1c2d5d1e7f351edd5a6f37c85fc52f58be0eb1dc5c396fc82e4b0a0c3efb0e163adc290e130460281f75faaa9e2303e1ce7a7556d9943958634c5e37ab8a5e9c752e5604f51fd3165761e07d0a5c8aa570c5e33c48c294b91e02a8f6c10a5728a671399dd45c2ae7dd45039e5d0cbcda335efd18a267e7ad8371e5c3cc93d0dfcbfc303d6c1456e3a6b253161942c28cebd8b9aedeb94209f0073adcec7ee019e6e4fbe70b278c5fcac1d3a207c76bc269c1b3e3ca560f7f379b319b587b56fa2e6aa3464b4509abd152c9ea2395849110a1b4eef20db77740b4b86a0039be8d298a9776b2cc5103b1acaa8588c22d385c05cd4cd1fd73f0f4e4085634addb30d895651c3e558529063796bf4aac9588aa8b47a201414ea29cff569395d0a75a8a8fb344be88c98acac7e982c28628e61686ac335d1bfc0946a14406178f640b6a75ea0a6879885ad3f59963557ee3f80294d25a17d70ad91b6cc02d1adcca74f9e65f1cd715e09956b1a815653c3665852902bf06e1977a0a3026741b0625ae92c38d6f0121a9bf376554a0f94e95982fa793873dac70acfdec61ff8eacb0f5f6648aff769e1dfc39aa66701160e6b47c73500be3f31f03e13e5c59bef38f8c26fb59d39b20ff309398ec000bf373b0f17e893f138bf7548db40fb0a969a7800080830eea990eba41afc8bd7fae4825c100ffb995b39ab3763187b5555e1768e5f833420b36d6a897bedd099c419dee4c9d363ed8b14a5571fe6ba457b3c399b926cdba0dfab267fab281509b32b3f4e4cf322c671268c4a2e581dd9c4bcb9e03a3f68c51b30f3b653f2e4955d434db28dc38518cfc6c0e5d839eaf91f5652b907f0d9db85bc0d7d1dcf1d6b555586fd7a22f8fb9d9aa8138e61d0769148e958e4331c22c7452c7856ac99babf34563b325abd52193662346aa4c8de6ac54751d98493856fb2dfe9e763181b7b6fccd7e06ff4bf0f4e0c4d21bb52d8d7ce9598ebbfb13eec797c0477789f7445ce86e69706dc5c0dbf8dbd97a787883dae8a1043c58d197198a9698248aa3fcb1ee9df660a719ec34ba47db861794ecf6487e8dd94c1fa6b78ce62a30eb36683ae158dfac91467a85cdf12b7bb7dd8845e9cbe6769f6b1ad6c0c0c2b1864ff5f0a9febffc541b7ac6b02a4fec3ba3a7fb128fd07ca5e7eb7574e55aabfae985b106c460a3c28fb62b9d87e980a1b91b4c37922fe9c5bf45e9e1af98cdad95aa9385e526f8c7214728aaed15f2c8d647fcf2e50b25593cc6d0d9cd1a5240f7b7941756e42c75d7f29720b0452bc9b6c513d850ed8fe5edeff0dabdd6747adf804eac1db21b42d150f747a9bbc0d766fa735d2a9d1fe9d2e7fc58441baee56dd5f28ff2961755c30f8a869755cbef152dd76e12558dff246f3cad1afea068588fffa3a265bda0470a224d8f6aa8470a3acdea960a3acd08a00a42cd085c15949a91b82a88f550b7fc5e478acfa328583a99440abc38d36f273d20de0e8d341cbdea3b0ade31f4168ba9b3c68289bf9e67e33f7073920f51f9b112432c58a04734d618e8bd3f432e8ad1e87c993f4c9c5ad1d2b2f9cd065e299b2e296e13d2e79353bccfc0aac5f163fe78e0f84b676db96ad499ae9a678b14b56a10b66686d6e9cec08fd5b4d1193ddfabf2e357c3304ba65aa1d309c16a720e14b8c3883844e51b533309e822a8cf8aaad715fde64639f63b6048399d7ace9395578b88397817979a1d0a172a7d4ee35fcaf49bb7587c77c04dec7af79c7fa8b748c26f1df8304946fac383037ef3220008f052ed3825e54d837992de0222ac40d70102a9f208a12f2fe01b2ad9ba359f20fd6e4ab2f0d023aa9d49b108136071081f0bd58237db05414bb18bfd0f34f19e6b09f88249445ac56d534d62e8b65c5fb814afeefafd659222bf032e94d2a8efdc585e12093983bb3122782ebf91346033ee0565cf398bc17717ccc4ac77cff987b7c18b682f31c8d74cc05e20eab396e4256cbf794c88f80e984d48939e731d1d5c426c560203f69036ab3a489489b50a0c60d16f2e0391de89850aa0811677bdee88bbf2eb3ddc27c63d2a1b6b79fd9096a3b718b8dbf81ca1e27a232a2e38598649e1ce51ccf16c341ed5778a002b729cc7007a05012cd41d196b218c076bc65500052c3e105cd02ca7005dc51ee1a015c616457f22300807a13e15ab8054e13e7818e5215601828cc1c101218e660a30fc361382079d0354808b30183cac7c7fa7e8ce05b1e0e0b05f75062021986266cdaef789969257eaacced0bbcba8a6050a0aa788f46e2f48a0af1c184a27e1461acb227a46caaf8c8e85ddc4c64e4c059679c91229acea9daf52fd3e915f17d8ca2bb7f31208564a49325dceb4dbf904e9b0478058084d916a63a41c59b5ed91e84fe0d87acad41b257ec642a3a4d22c49e25b297bc9a42143e436084c7e36400a8b6c941a564a331a03c64502008967eb790bdcaff9f96b98d10c0c69c474c0cfac647de4a6b3ce19a3f6ea05d60434e6c8cd39e4cc8b7d806cb2ac01a7f3f9014e7dfc441556074dbb03813bb78791ac81d8d2d0bd16a0832842db1fe14158e3284c6d7988d38974b3031d7e1b4fbcf4aeac8e5f55dde9248f885d149c4e04a1b34f6fadf5daf1574428eda26434cfe3684fbf9b9b0798f672189325a55bd9c36235521c84f833c7d4a6ab65a32b278ce299155b4f567a5698da1ed78c3d6c0af6dbe568fc7992a757b9032ffba47f97a71136ac3879f8e48fe605842b3c412f3dd767deea20e7f09d47695c73cbb542c03d7e1ab889e78b8d0ce2deb95334d93f2fd187901b174808b0b921e53b66fe9c41825b6bce7e43934f8fb8afed89ba68424ca0535f8958c65726619465fa50aaf0c92498aa501f4ee9004e8229cbf4a1109190494044b1019397a18d293e2f0bf5e150918a4958548509dd8a68c534e18ac2fe8820670468ad6519d35a135dab02d15761cd03499210f212037626a348522c4d5618c05b70df00f042430c817fa84342e36bf521c30f7048e8708bde080f68216a293f9009d95c84b4a0f4558af85088144f70b5064abe0c714829f8b2501f0ef1208f844414ebc3aa9ee49190aac241d219f8fb91f4d21eda52b8f31b1d737116f4ebab00ebb3e29ec829b31a1b11b4ba6033a7a9b86b5fc95a3c5ce4947103dd4e44af03743b516b0cb90e5e0700ae2b8de156a1eb00b0559d3ed43a6e1d45d1aab43fa2525e16b49594e21ab981a0887a6e474ef2b87464ffbca43714915e8818d1a4be9537a78aa4ef76e8d27e7fd3c1878d0cd7461b1c880a7d7875500b12585d6ab08bcc23aa517bc8bcc8c064418647a3cc1664456fe400bac26a2910805b89b964e800d98e8874c74e5ccc134a1fb295c3c1693838898434bf6d6d2b97998b56035184fbf57583ddfb73137b81dc92ac8cc79c397d550006353ba8591dc85f8f9aa57d0c98bb1cca5d4e716d4a36d5354da41e121c5579df3a7e51b4841083829de189510d1112be0068ac15a4d84c03df76b2071cd7511a06ac0a19a49c26eb3c624c7bca6f50e7209eb7149cb5f90b7260a5012fc3860b5d42ea80fc80dbe2aed8514d43ce0f886d52698fa2a4fa5df901153e3894735036a3d4d5279b4954f803b14e397993f108e3fe8a4f28e1d9f87633ffcd3d48eb0fb23fa72efe8cc6758b5bace99e5114e7f1a6c61f0e3e8c47e7ae6345b95b56e16e74c2be19d1f23f3a7a5f24b89fb0ddcdbd9852285164531b3d28a723ecc1b38bf0984ebaacca00982d22d6fbaf56b87c49af9ad988852d52cf6758732f82ae7d1bbd9d8dff997538195dffed31edf36e741f629639191d8efed5556874560b0d94821c83f4c136c8b3de19b6741af56c95dba64fef8ee7e9ece89dc105929fdbb828ce02ae62f22d9d2ce2dfb809eda954e820c645327419f99be7c31de45208944c26db11b981d4b24f41609e2c898cdaabaddc1746ca9d1f5414e8b7b30597c5f16d3848ab54ad836c8849254872ea061866f600b95dced24652c145d7ee486a9958db5de98241863b9661c0b96690da1db39c7982cc815e626122334e36d96a8b524cb680c5e6946c018a4922d904129b35b2e16eeab1895c3c8a05a3c50e1d7492f96ac522f7b8d1a56f83248cdfc632ed652fb09d4f0c9f07b133d86ce698ce0053590c1b6f6181a4849ab0dae418fc3604606ba415e4fc111a5a8643c770e8301349de33e5ab95c26ffed0217333f96aa936e8ce41777e9dba53e0a4a02789525f03beb9c05b4325bbe42866a4af7bb66280ee0fa706146b998a67b1a7f8f25c5048120be3c43f0d43ccef23a14edf03e11aa6d1d9170381d13f09441a25ede9311be93d55ef15272993dfec8b778a58afc4d09aa9767acc1fa2d7cebde208cd7436edb2d7d4717809289a296bfa4d63c90368cdcdd48ee8acf256e5435feaa4f2d99236a877b8000eca1c404d3946fc44b77bb611f9199befd977cd3c9057710f3e20fb61991d2919236ed9a796d1cda9b51f1e21a2b013c36f3f6dd62e7844f696bd571b0eb3cc58fb621528c03e8147933c5c3d661ead77dffde2225546abbd314e9e4d81e415bdfc597d660fc1f3e35e71847e8eaa7db1069b2083c0c13423568f9945f9a8b9575ca399636a6f26d93a5f10658cd5cf68d5634e9106a406b864bfb9a2f828df2cd58a57a41c67291241e50f13cfc6f65380a99c5f364802b5f3032d0489a240c00b0d809cad1fc09f6d02cf4291614727cf946e9a2908019d14366042aa8d381d15348e205d8c305795345515348038c50a374469a8e147286bc001043951c469aee459aea031242944d851a0fd35371cd4081a5723d7079c2d4b9c2c0b1c064caca148a4a591470b1a4b91c942c415a0aa20ea249c01298e1da6f45ad0e927b83478cc6713566070746dee83dca7745d661397a84f6158e4f6d36f9987cb6c8a94762682c3b69f4667d9b64ca6c37e11e8f823ed2705a5c292a6d51284b280ae07f8b819f2a9b23a8889b8d1ed64cba435f2c9c221329a5373eb53ec306398c9c4b8af3e1303b3fdc4b69612cc6ca2e28d8728b66107536f97eccb7082e4c6860812d77e1a9de7f4329b18bcaf82c2a47520859d65ec32dcd7b0474a363793fed40c7272f13177f0e13af153dfd0fcd70c45ceaa0691c681f2d1923a56576daefde7a03cdb3318954d1857be5b145b363e739fa74100ac658cabb16a8bb227700bcb4dd27d8ff784ec6bff3e89d7498ca78cbc2797da12a45602d9f859e2311ae7d3fbcc7d37ea620a184d2775a7bdf72f12c7b52bbcaf009f420188d4fc50783fa7b48c532fe8d5a6827417f89a808ae5abac260fc85bbb185874efcfad57d404b7cf11ba412b6bb92923278981a809412ffbe9ccb156a1e545058cba3ffe8979d8f6de7efa1f7e90e225f8c90000, '6.2.0-61023');
  236.  
  237. --
  238. -- Indexes for dumped tables
  239. --
  240.  
  241. --
  242. -- Indexes for table `Competences`
  243. --
  244. ALTER TABLE `Competences`
  245.   ADD PRIMARY KEY (`ID`),
  246.   ADD KEY `IX_CvID` (`CvID`) USING HASH;
  247.  
  248. --
  249. -- Indexes for table `CourseExperiences`
  250. --
  251. ALTER TABLE `CourseExperiences`
  252.   ADD PRIMARY KEY (`ID`),
  253.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  254.  
  255. --
  256. -- Indexes for table `CVs`
  257. --
  258. ALTER TABLE `CVs`
  259.   ADD PRIMARY KEY (`ID`);
  260.  
  261. --
  262. -- Indexes for table `EducationExperiences`
  263. --
  264. ALTER TABLE `EducationExperiences`
  265.   ADD PRIMARY KEY (`ID`),
  266.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  267.  
  268. --
  269. -- Indexes for table `Hobbies`
  270. --
  271. ALTER TABLE `Hobbies`
  272.   ADD PRIMARY KEY (`ID`),
  273.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  274.  
  275. --
  276. -- Indexes for table `Languages`
  277. --
  278. ALTER TABLE `Languages`
  279.   ADD PRIMARY KEY (`ID`),
  280.   ADD KEY `IX_CV_ID` (`CV_ID`) USING HASH;
  281.  
  282. --
  283. -- Indexes for table `LicenseCVs`
  284. --
  285. ALTER TABLE `LicenseCVs`
  286.   ADD PRIMARY KEY (`License_ID`,`CV_ID`),
  287.   ADD KEY `IX_License_ID` (`License_ID`) USING HASH,
  288.   ADD KEY `IX_CV_ID` (`CV_ID`) USING HASH;
  289.  
  290. --
  291. -- Indexes for table `Licenses`
  292. --
  293. ALTER TABLE `Licenses`
  294.   ADD PRIMARY KEY (`ID`);
  295.  
  296. --
  297. -- Indexes for table `References`
  298. --
  299. ALTER TABLE `References`
  300.   ADD PRIMARY KEY (`ID`),
  301.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  302.  
  303. --
  304. -- Indexes for table `SidelineExperiences`
  305. --
  306. ALTER TABLE `SidelineExperiences`
  307.   ADD PRIMARY KEY (`ID`),
  308.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  309.  
  310. --
  311. -- Indexes for table `Skills`
  312. --
  313. ALTER TABLE `Skills`
  314.   ADD PRIMARY KEY (`ID`),
  315.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  316.  
  317. --
  318. -- Indexes for table `WorkExperiences`
  319. --
  320. ALTER TABLE `WorkExperiences`
  321.   ADD PRIMARY KEY (`ID`),
  322.   ADD KEY `IX_CVID` (`CVID`) USING HASH;
  323.  
  324. --
  325. -- Indexes for table `__MigrationHistory`
  326. --
  327. ALTER TABLE `__MigrationHistory`
  328.   ADD PRIMARY KEY (`MigrationId`);
  329.  
  330. --
  331. -- AUTO_INCREMENT for dumped tables
  332. --
  333.  
  334. --
  335. -- AUTO_INCREMENT for table `Competences`
  336. --
  337. ALTER TABLE `Competences`
  338.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  339.  
  340. --
  341. -- AUTO_INCREMENT for table `CourseExperiences`
  342. --
  343. ALTER TABLE `CourseExperiences`
  344.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  345.  
  346. --
  347. -- AUTO_INCREMENT for table `CVs`
  348. --
  349. ALTER TABLE `CVs`
  350.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  351.  
  352. --
  353. -- AUTO_INCREMENT for table `EducationExperiences`
  354. --
  355. ALTER TABLE `EducationExperiences`
  356.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  357.  
  358. --
  359. -- AUTO_INCREMENT for table `Hobbies`
  360. --
  361. ALTER TABLE `Hobbies`
  362.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  363.  
  364. --
  365. -- AUTO_INCREMENT for table `Languages`
  366. --
  367. ALTER TABLE `Languages`
  368.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  369.  
  370. --
  371. -- AUTO_INCREMENT for table `Licenses`
  372. --
  373. ALTER TABLE `Licenses`
  374.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  375.  
  376. --
  377. -- AUTO_INCREMENT for table `References`
  378. --
  379. ALTER TABLE `References`
  380.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  381.  
  382. --
  383. -- AUTO_INCREMENT for table `SidelineExperiences`
  384. --
  385. ALTER TABLE `SidelineExperiences`
  386.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  387.  
  388. --
  389. -- AUTO_INCREMENT for table `Skills`
  390. --
  391. ALTER TABLE `Skills`
  392.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  393.  
  394. --
  395. -- AUTO_INCREMENT for table `WorkExperiences`
  396. --
  397. ALTER TABLE `WorkExperiences`
  398.   MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
  399.  
  400. --
  401. -- Constraints for dumped tables
  402. --
  403.  
  404. --
  405. -- Constraints for table `Competences`
  406. --
  407. ALTER TABLE `Competences`
  408.   ADD CONSTRAINT `FK_Competences_CVs_CvID` FOREIGN KEY (`CvID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  409.  
  410. --
  411. -- Constraints for table `CourseExperiences`
  412. --
  413. ALTER TABLE `CourseExperiences`
  414.   ADD CONSTRAINT `FK_CourseExperiences_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  415.  
  416. --
  417. -- Constraints for table `EducationExperiences`
  418. --
  419. ALTER TABLE `EducationExperiences`
  420.   ADD CONSTRAINT `FK_EducationExperiences_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  421.  
  422. --
  423. -- Constraints for table `Hobbies`
  424. --
  425. ALTER TABLE `Hobbies`
  426.   ADD CONSTRAINT `FK_Hobbies_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  427.  
  428. --
  429. -- Constraints for table `Languages`
  430. --
  431. ALTER TABLE `Languages`
  432.   ADD CONSTRAINT `FK_Languages_CVs_CV_ID` FOREIGN KEY (`CV_ID`) REFERENCES `CVs` (`ID`);
  433.  
  434. --
  435. -- Constraints for table `LicenseCVs`
  436. --
  437. ALTER TABLE `LicenseCVs`
  438.   ADD CONSTRAINT `FK_LicenseCVs_CVs_CV_ID` FOREIGN KEY (`CV_ID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  439.   ADD CONSTRAINT `FK_LicenseCVs_Licenses_License_ID` FOREIGN KEY (`License_ID`) REFERENCES `Licenses` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  440.  
  441. --
  442. -- Constraints for table `References`
  443. --
  444. ALTER TABLE `References`
  445.   ADD CONSTRAINT `FK_References_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  446.  
  447. --
  448. -- Constraints for table `SidelineExperiences`
  449. --
  450. ALTER TABLE `SidelineExperiences`
  451.   ADD CONSTRAINT `FK_SidelineExperiences_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  452.  
  453. --
  454. -- Constraints for table `Skills`
  455. --
  456. ALTER TABLE `Skills`
  457.   ADD CONSTRAINT `FK_Skills_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  458.  
  459. --
  460. -- Constraints for table `WorkExperiences`
  461. --
  462. ALTER TABLE `WorkExperiences`
  463.   ADD CONSTRAINT `FK_WorkExperiences_CVs_CVID` FOREIGN KEY (`CVID`) REFERENCES `CVs` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE;
  464. COMMIT;
  465.  
  466. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  467. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  468. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
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