Skip to content

Instantly share code, notes, and snippets.

@marcometz

marcometz/create_versions.sql

Created November 15, 2013 23:06
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 marcometz/7493222 to your computer and use it in GitHub Desktop.
Save marcometz/7493222 to your computer and use it in GitHub Desktop.
Download ZIP
Papertrail Versions table create
Raw
create_versions.sql
CREATE TABLE `versions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`item_type` varchar(255) NOT NULL,
`item_id` int(11) NOT NULL,
`event` varchar(255) NOT NULL,
`whodunnit` varchar(255) DEFAULT NULL,
`object` text,
`created_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `index_versions_on_item_type_and_item_id` (`item_type`,`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4981004 DEFAULT CHARSET=latin1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment