Skip to content

Instantly share code, notes, and snippets.

@andyhawthorne
Created November 2, 2012 22:17
Show Gist options
  • Save andyhawthorne/4004688 to your computer and use it in GitHub Desktop.
Save andyhawthorne/4004688 to your computer and use it in GitHub Desktop.
schema for task_lists table
CREATE TABLE `tasks_list` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(200) DEFAULT NULL,
`body` text,
`due` date DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`completed` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment