Skip to content

Instantly share code, notes, and snippets.

@jamiew
Created February 23, 2009 00:47
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 jamiew/68708 to your computer and use it in GitHub Desktop.
Save jamiew/68708 to your computer and use it in GitHub Desktop.
CREATE TABLE `audits` (
`id` int(11) NOT NULL auto_increment,
`auditable_id` int(11) default NULL,
`auditable_type` varchar(255) default NULL,
`auditable_user_id` int(11) default NULL,
`user_id` int(11) default NULL,
`user_type` varchar(255) default NULL,
`username` varchar(255) default NULL,
`action` varchar(255) default NULL,
`changes` text,
`version` int(11) default '0',
`created_at` datetime default NULL,
PRIMARY KEY (`id`),
KEY `auditable_index` (`auditable_id`,`auditable_type`),
KEY `user_index` (`user_id`,`user_type`),
KEY `index_audits_on_created_at` (`created_at`)
) ENGINE=MyISAM AUTO_INCREMENT=1839087 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment