Skip to content

Instantly share code, notes, and snippets.

@ramielrowe
Created July 29, 2013 17:58
Show Gist options
  • Save ramielrowe/6106243 to your computer and use it in GitHub Desktop.
Save ramielrowe/6106243 to your computer and use it in GitHub Desktop.
CREATE TABLE `notifications` (
`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
`key` varchar(300),
`value` varchar(300),
`index` varchar(300),
`message_id` varchar(50)
);
CREATE INDEX `notifications_key` ON `notifications` (`key`);
CREATE INDEX `notifications_value` ON `notifications` (`value`);
CREATE INDEX `notifications_message_id` ON `notifications` (`message_id`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment