CREATE DATABASE 'todo';
USE todo;
CREATE TABLE `task` (
  `taskid` tinyint(3) unsigned NOT NULL auto_increment,
  `userid` tinyint(3) unsigned NOT NULL default '0',
  `priority` tinyint(3) unsigned NOT NULL default '1',
  `title` text NOT NULL,
  `reminder` text NOT NULL,
  PRIMARY KEY  (`taskid`)
) TYPE=InnoDB;
CREATE TABLE `user` (
  `userid` tinyint(3) unsigned NOT NULL auto_increment,
  `user` char(32) default NULL,
  PRIMARY KEY  (`userid`)
) TYPE=InnoDB;
