Skip to content

Instantly share code, notes, and snippets.

@sebgates
Last active March 31, 2018 11:31
Show Gist options
  • Save sebgates/a7329c9ba74fd0b93e87434437c80398 to your computer and use it in GitHub Desktop.
Save sebgates/a7329c9ba74fd0b93e87434437c80398 to your computer and use it in GitHub Desktop.
CREATE TABLE `reg_users` (
`user_id` int(11) NOT NULL,
`user_name` varchar(25) NOT NULL,
`user_email` varchar(60) NOT NULL,
`user_password` varchar(255) NOT NULL,
`joining_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `reg_users`
ADD PRIMARY KEY (`user_id`);
ALTER TABLE `reg_users`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment