Skip to content

Instantly share code, notes, and snippets.

@AngeloR
Created April 29, 2011 16:36
Show Gist options
  • Select an option

  • Save AngeloR/948590 to your computer and use it in GitHub Desktop.

Select an option

Save AngeloR/948590 to your computer and use it in GitHub Desktop.
SQL for lemondoo
CREATE DATABASE `lemondoo` DEFAULT CHARSET utf8;
USE `lemondoo`;
CREATE TABLE `todo` (
`todo_id` int(11) not null auto_increment,
`todo_title` varchar(100),
`todo_text` text,
`completed` tinyint(4) default '0',
PRIMARY KEY (`todo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment