-- Adminer 4.8.1 MySQL 10.5.19-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 `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), (7, 'Robert', 'Oppenheimer', '1904-04-22 00:00:00', 'Allies', 'theoretical physics', 0), (10, 'Donald', 'Trump', '2019-06-19 00:00:00', 'Nazi Germany', 'rocket propulsion', 0), (11, 'Donald', 'Trump Jnr', '2019-06-19 00:00:00', 'Nazi Germany', 'rocket propulsion', -1), (12, 'afawef', 'aewsfawef', '1978-08-04 00:00:00', 'Nazi Germany', 'quantum physics', -1), (13, 'test', 'scientist', '1984-09-06 00:00:00', 'Nazi Germany', 'quantum physics', -1), (14, 'The Red', 'Skull', '2020-11-12 00:00:00', 'Nazi Germany', 'quantum physics', -1); DROP TABLE IF EXISTS `MilitaryAllegiances`; CREATE TABLE `MilitaryAllegiances` ( `MilitaryAllegianceID` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`MilitaryAllegianceID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- 2023-03-09 11:35:35