Code:
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 */;
CREATE DATABASE IF NOT EXISTS `gex` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `gex`;
CREATE TABLE `Sonnen` (
`SonnenID` int(6) NOT NULL,
`SystemID` int(6) NOT NULL,
`GalaxieID` int(2) NOT NULL,
`SonnenSpectralTyp` int(2) NOT NULL,
`SonnenGroessenFaktor` float NOT NULL,
`SonnenFarbe` varchar(21) COLLATE utf8_bin NOT NULL,
`SonnenTemperatur` int(6) NOT NULL,
`SonnenLeuchtkraft` float NOT NULL,
`SonnenMasse` float NOT NULL,
`SonnenDichte` float NOT NULL,
`SonnenGroesse` float NOT NULL,
`SonnenGravitation` float NOT NULL,
`SonnenGeschwindigkeit` float NOT NULL,
`SonnenAbstand` float NOT NULL,
`SonnenRotation` int(6) NOT NULL,
`SonnenWinkel` float NOT NULL,
`SonnenEntdeckung` datetime NOT NULL,
`SonnenEntdecker` int(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Sonnen';
CREATE TABLE `Systeme` (
`SystemID` int(6) NOT NULL,
`GalaxieID` int(2) NOT NULL,
`SystemX` int(6) NOT NULL,
`SystemY` int(6) NOT NULL,
`SystemZ` int(6) NOT NULL,
`SystemSonnenAnzahl` int(2) NOT NULL,
`SystemMasse` float NOT NULL,
`SystemGravitation` float NOT NULL,
`SystemLeuchtkraft` float NOT NULL,
`SystemSonnenFarbe` varchar(21) COLLATE utf8_bin NOT NULL,
`SystemSonnenSpectralTyp` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Systeme';
ALTER TABLE `Sonnen`
ADD PRIMARY KEY (`SonnenID`),
ADD KEY `SonnenID` (`SonnenID`);
ALTER TABLE `Systeme`
ADD PRIMARY KEY (`SystemID`),
ADD KEY `SystemID` (`SystemID`);
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 */;
Das wäre dann die Datenbank