Skip to content

Instantly share code, notes, and snippets.

@stephenjudkins
Created August 18, 2009 20:31
Show Gist options
  • Save stephenjudkins/169933 to your computer and use it in GitHub Desktop.
Save stephenjudkins/169933 to your computer and use it in GitHub Desktop.
CREATE TABLE `lists` (
`id` int(11) NOT NULL auto_increment,
`uid` varchar(255) NOT NULL,
`casespace_key` text,
`created_at` datetime default NULL,
`updated_at` datetime default NULL,
`title` varchar(255) default NULL,
`description` text,
PRIMARY KEY (`id`),
UNIQUE KEY `index_lists_on_uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment