SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE DATABASE IF NOT EXISTS `twitter_surveys` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `twitter_surveys`;

CREATE TABLE `Options` (
`ID` int(15) NOT NULL,
  `Name` varchar(140) COLLATE utf8mb4_unicode_ci NOT NULL,
  `SurveyID` int(15) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `Surveys` (
`SurveyID` int(15) NOT NULL,
  `SurveyTag` varchar(140) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `Options`
 ADD PRIMARY KEY (`ID`);

ALTER TABLE `Surveys`
 ADD PRIMARY KEY (`SurveyID`);

ALTER TABLE `Options`
MODIFY `ID` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;

ALTER TABLE `Surveys`
MODIFY `SurveyID` int(15) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;