MpNA0Sga

1$queryCreateUsersTable = "CREATE TABLE IF NOT EXISTS EmailList (
2  `ListName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
3  `FirstName` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
4  `Email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
5  `ID` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
6  `IP` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
7  `ConfirmedEmail` tinyint(1) DEFAULT NULL,
8  `Subscribed` tinyint(1) DEFAULT 0,
9  UNIQUE KEY `ID` (`ID`)
10) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
11
12if(!$conn->query($queryCreateUsersTable))
13{
14    echo "Table creation failed: (" . $dbConnection->errno . ") " . $dbConnection->error;
15}