Skip to content

Instantly share code, notes, and snippets.

@CodingTricksHub

CodingTricksHub/createTables.sql Secret

Last active June 15, 2017 21:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save CodingTricksHub/cb40c092c5938597e40aa6cb32f1c106 to your computer and use it in GitHub Desktop.
Save CodingTricksHub/cb40c092c5938597e40aa6cb32f1c106 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
createTables.sql
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL,
`categoryName` text NOT NULL
);
CREATE TABLE IF NOT EXISTS `favouritecategories` (
`id` int(11) NOT NULL,
`email` text NOT NULL,
`categoryId` text NOT NULL
);
ALTER TABLE `favouritecategories`
ADD PRIMARY KEY (`id`);
ALTER TABLE `favouritecategories`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment