Skip to content

Instantly share code, notes, and snippets.

@CloudyWater
Created January 29, 2017 19:03
Show Gist options
  • Save CloudyWater/d085940bbab00a9e246fff2aa9a0324e to your computer and use it in GitHub Desktop.
Save CloudyWater/d085940bbab00a9e246fff2aa9a0324e to your computer and use it in GitHub Desktop.
Creates our users table
CREATE TABLE `users` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(45) DEFAULT NULL,
`password` varchar(45) DEFAULT NULL,
`creationdate` date DEFAULT NULL,
`email` varchar(80) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID_UNIQUE` (`ID`),
UNIQUE KEY `username_UNIQUE` (`username`),
UNIQUE KEY `email_UNIQUE` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment