-- Adminer 4.8.1 MySQL 10.5.18-MariaDB-cll-lve dump SET NAMES utf8; SET time_zone = '+00:00'; SET foreign_key_checks = 0; SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO'; CREATE DATABASE `wyvernsi_ivanC` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci */; USE `wyvernsi_ivanC`; DROP TABLE IF EXISTS `Class23_Student`; CREATE TABLE `Class23_Student` ( `StudentID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, auto increments', `FirstName` tinytext NOT NULL COMMENT 'up to 255 chars', `Surname` tinytext NOT NULL COMMENT 'up to 255 chars', `DoB` datetime DEFAULT NULL COMMENT 'YYYY-MM-DD, empty if dob unknown', `LikesMarmite` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=hates,1=likes', PRIMARY KEY (`StudentID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; INSERT INTO `Class23_Student` (`StudentID`, `FirstName`, `Surname`, `DoB`, `LikesMarmite`) VALUES (1, 'Heath', 'Justice', '2006-05-02 00:00:00', 0), (2, 'Nicodemus', 'Steele', '2006-03-03 00:00:00', 0), (3, 'Ethan', 'Guo', '2005-02-08 00:00:00', 0), (4, 'Shayan', 'Rezaei', '2006-08-17 00:00:00', 1), (5, 'Adam', 'Li', '2005-06-02 00:00:00', 0), (6, 'Ivan', 'Chen', '2006-02-08 00:00:00', 1); DROP TABLE IF EXISTS `GermanScientists`; CREATE TABLE `GermanScientists` ( `ScientistID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key, auto increment', `FirstName` tinytext CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'up to 255 chars', `LastName` tinytext CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'up to 255 chars', `DoB` datetime NOT NULL COMMENT 'YYYY-MM-DD, empty if dob unknown', `MilitaryAllegiance` tinytext NOT NULL DEFAULT 'None' COMMENT 'who the scientist was working for (if military)', `FieldOfResearch` text NOT NULL, `HasNobel` int(11) NOT NULL DEFAULT -1 COMMENT '-1 for true, 0 if false', PRIMARY KEY (`ScientistID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; INSERT INTO `GermanScientists` (`ScientistID`, `FirstName`, `LastName`, `DoB`, `MilitaryAllegiance`, `FieldOfResearch`, `HasNobel`) VALUES (1, 'Werner', 'Heisenberg', '1901-12-05 00:00:00', 'Nazi Germany', 'theoretical physics', -1), (2, 'Wernher', 'Von Braun', '1912-03-23 00:00:00', 'Nazi Germany', 'rocket propulsion', 0), (3, 'Max', 'Planck', '1858-04-23 00:00:00', 'None', 'theoretical physics, quantum physics', -1), (4, 'Albert', 'Einstein', '1879-04-18 00:00:00', 'None', 'quantum physics, relativity', -1), (5, 'Adolf', 'Hitler', '1889-04-20 00:00:00', 'German Empire, Nazi Germany', 'Utopian Social Theorist', 0), (6, 'Fritz', 'Haber', '1868-12-09 00:00:00', 'German Empire', 'physical chemistry', -1); DROP TABLE IF EXISTS `MrMortonWasHere`; CREATE TABLE `MrMortonWasHere` ( `VisitCount` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`VisitCount`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- 2023-03-06 10:18:05