diff options
Added database exports dev
3 files changed, 182 insertions, 1 deletions
| -rw-r--r-- | README.md | 2 | ||||
| -rw-r--r-- | db-export/devrix_job_board.sql | 111 | ||||
| -rw-r--r-- | db-export/devrix_job_board.xml | 70 |
@@ -2,7 +2,7 @@ The repository for my solution of DevriX's exam for their internship program. -It's an oversimplified job offer website, (roughly) following the MVC design pattern and using the LAMP stack (with MySQL). +It's an oversimplified job offer website, (roughly) following the MVC design pattern and using the LAMP stack (with MySQL). In `src` you can find the source code and in `db-export` you can find the export of a very small demo database. **CREDENTIALS FOR DASHBOARD** ``` 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 @@ +<?xml version="1.0" encoding="utf-8"?> +<!-- +- phpMyAdmin XML 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 +--> + +<pma_xml_export version="1.0" xmlns:pma="https://www.phpmyadmin.net/some_doc_url/"> + <!-- + - Structure schemas + --> + <pma:structure_schemas> + <pma:database name="devrix_job_board" collation="utf8mb4_0900_ai_ci" charset="utf8mb4"> + <pma:table name="companies"> + 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; + </pma:table> + <pma:table name="job_offers"> + 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; + </pma:table> + </pma:database> + </pma:structure_schemas> + + <!-- + - Database: 'devrix_job_board' + --> + <database name="devrix_job_board"> + <!-- Table companies --> + <table name="companies"> + <column name="id">1</column> + <column name="name">MegaCorp</column> + </table> + <table name="companies"> + <column name="id">2</column> + <column name="name">Cool INC.</column> + </table> + <!-- Table job_offers --> + <table name="job_offers"> + <column name="id">1</column> + <column name="title">Programmer</column> + <column name="description">Coding</column> + <column name="companyId">1</column> + <column name="salary">2000.0000</column> + </table> + <table name="job_offers"> + <column name="id">7</column> + <column name="title">Test Job</column> + <column name="description">Testing</column> + <column name="companyId">2</column> + <column name="salary">346.0000</column> + </table> + </database> +</pma_xml_export>
\ No newline at end of file |