From 3b0cbc90e3046a8bb979c2b9a17fae5a94bb2707 Mon Sep 17 00:00:00 2001 From: Syndamia Date: Sat, 3 Apr 2021 18:19:20 +0300 Subject: Added database exports --- db-export/devrix_job_board.sql | 111 +++++++++++++++++++++++++++++++++++++++++ db-export/devrix_job_board.xml | 70 ++++++++++++++++++++++++++ 2 files changed, 181 insertions(+) create mode 100644 db-export/devrix_job_board.sql create mode 100644 db-export/devrix_job_board.xml (limited to 'db-export') diff --git a/db-export/devrix_job_board.sql b/db-export/devrix_job_board.sql new file mode 100644 index 0000000..a65dbfd --- /dev/null +++ b/db-export/devrix_job_board.sql @@ -0,0 +1,111 @@ +-- phpMyAdmin SQL Dump +-- version 5.1.0 +-- https://www.phpmyadmin.net/ +-- +-- Host: localhost +-- Generation Time: Apr 03, 2021 at 03:15 PM +-- Server version: 8.0.23 +-- PHP Version: 7.4.16 + +SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; +START TRANSACTION; +SET time_zone = "+00:00"; + + +/*!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 utf8mb4 */; + +-- +-- Database: `devrix_job_board` +-- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `companies` +-- + +CREATE TABLE `companies` ( + `id` int NOT NULL, + `name` varchar(100) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- +-- Dumping data for table `companies` +-- + +INSERT INTO `companies` (`id`, `name`) VALUES +(1, 'MegaCorp'), +(2, 'Cool INC.'); + +-- -------------------------------------------------------- + +-- +-- Table structure for table `job_offers` +-- + +CREATE TABLE `job_offers` ( + `id` int NOT NULL, + `title` varchar(100) DEFAULT NULL, + `description` varchar(100) DEFAULT NULL, + `companyId` int DEFAULT NULL, + `salary` double(16,4) DEFAULT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- +-- Dumping data for table `job_offers` +-- + +INSERT INTO `job_offers` (`id`, `title`, `description`, `companyId`, `salary`) VALUES +(1, 'Programmer', 'Coding', 1, 2000.0000), +(7, 'Test Job', 'Testing', 2, 346.0000); + +-- +-- Indexes for dumped tables +-- + +-- +-- Indexes for table `companies` +-- +ALTER TABLE `companies` + ADD PRIMARY KEY (`id`); + +-- +-- Indexes for table `job_offers` +-- +ALTER TABLE `job_offers` + ADD PRIMARY KEY (`id`), + ADD KEY `fk_companyId_companies` (`companyId`); + +-- +-- AUTO_INCREMENT for dumped tables +-- + +-- +-- AUTO_INCREMENT for table `companies` +-- +ALTER TABLE `companies` + MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; + +-- +-- AUTO_INCREMENT for table `job_offers` +-- +ALTER TABLE `job_offers` + MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; + +-- +-- Constraints for dumped tables +-- + +-- +-- Constraints for table `job_offers` +-- +ALTER TABLE `job_offers` + ADD CONSTRAINT `fk_companyId_companies` FOREIGN KEY (`companyId`) REFERENCES `companies` (`id`); +COMMIT; + +/*!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 */; diff --git a/db-export/devrix_job_board.xml b/db-export/devrix_job_board.xml new file mode 100644 index 0000000..5f8488a --- /dev/null +++ b/db-export/devrix_job_board.xml @@ -0,0 +1,70 @@ + + + + + + + + + CREATE TABLE `companies` ( + `id` int NOT NULL AUTO_INCREMENT, + `name` varchar(100) DEFAULT NULL, + PRIMARY KEY (`id`) + ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + + + CREATE TABLE `job_offers` ( + `id` int NOT NULL AUTO_INCREMENT, + `title` varchar(100) DEFAULT NULL, + `description` varchar(100) DEFAULT NULL, + `companyId` int DEFAULT NULL, + `salary` double(16,4) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `fk_companyId_companies` (`companyId`), + CONSTRAINT `fk_companyId_companies` FOREIGN KEY (`companyId`) REFERENCES `companies` (`id`) + ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + + + + + + + + + 1 + MegaCorp +
+ + 2 + Cool INC. +
+ + + 1 + Programmer + Coding + 1 + 2000.0000 +
+ + 7 + Test Job + Testing + 2 + 346.0000 +
+
+
\ No newline at end of file -- cgit v1.3.1-26-gb76a