Current directory: /home/klas4s23/domains/585455.klas4s23.mid-ica.nl/public_html/Gastenboek/uploads
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 10, 2024 at 10:00 AM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.2.12 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: `portfolio` -- CREATE DATABASE IF NOT EXISTS `portfolio` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; USE `portfolio`; -- -------------------------------------------------------- -- -- Table structure for table `projects` -- CREATE TABLE `projects` ( `projectID` bigint(20) NOT NULL, `projectname` varchar(500) NOT NULL, `bannerlocation` varchar(500) NOT NULL, `LinkToProjectpage` varchar(750) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `projects` -- INSERT INTO `projects` (`projectID`, `projectname`, `bannerlocation`, `LinkToProjectpage`) VALUES (1, 'Technowire', 'projecten/coppy technowire/logos Technowire/TechnoWire _banner.png', 'projecten/coppy technowire/index.html'), (2, 'GameCraft', 'projecten/gamecraft/assets/images/Gamecraft logo.webp', 'projecten/gamecraft/html/index.html'), (3, 'Yard Job Application', 'projecten/yard/research/download.jpg', 'projecten/yard/websiterecreation/index.html'), (4, 'a game made in javascript', '', 'projecten/javascriptgame/gamepageplatformer.html'), (5, 'TestPageMessageSystem', '', 'projecten/message site/system basic/index.php'), (6, 'Full MessageSite', '', 'projecten/message site/full system/index.php'), (7, 'Ergowijzer', 'projecten/ergowijser/images/ergowijzer logo.png', 'projecten/Ergowijzer/ErgoWijzer.html'); -- -- Indexes for dumped tables -- -- -- Indexes for table `projects` -- ALTER TABLE `projects` ADD PRIMARY KEY (`projectID`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `projects` -- ALTER TABLE `projects` MODIFY `projectID` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; 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 */;