Skip to content

Instantly share code, notes, and snippets.

@stuartchaney
Created September 15, 2011 14:11
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 stuartchaney/1219331 to your computer and use it in GitHub Desktop.
Save stuartchaney/1219331 to your computer and use it in GitHub Desktop.
| notices | CREATE TABLE `notices` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`error_message` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
`project_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_new_notices_on_created_at` (`created_at`),
KEY `index_new_notices_on_group_id_and_created_at` (`group_id`,`created_at`),
KEY `index_new_notices_on_group_id` (`group_id`),
KEY `index_new_notices_on_project_id_and_rails_env_and_created_at` (`project_id`,`created_at`),
KEY `index_new_notices_on_project_id` (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2441303338 DEFAULT CHARSET=utf8 |
| old_notices | CREATE TABLE `old_notices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`error_message` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`group_id` int(11) DEFAULT NULL,
`project_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_notices_on_group_id` (`group_id`),
KEY `index_notices_on_created_at` (`created_at`),
KEY `index_notices_on_project_id` (`project_id`),
KEY `index_notices_on_group_id_and_created_at` (`group_id`,`created_at`),
KEY `index_notices_on_project_id_and_rails_env_and_created_at` (`project_id`,`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2069681974 DEFAULT CHARSET=utf8 DELAY_KEY_WRITE=1 |
@hgmnz
Copy link

hgmnz commented Sep 15, 2011

line 20, int(11). That's the problem. What server is that on?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment