CREATE TABLE `projects` (
  `project_id` int(11) NOT NULL auto_increment,
  `projectname` varchar(255) default NULL,
  PRIMARY KEY  (`project_id`)
) TYPE=MyISAM;

CREATE TABLE `timespent` (
  `timespent_id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `project_id` int(11) NOT NULL default '0',
  `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
  `endtime` datetime default NULL,
  PRIMARY KEY  (`timespent_id`)
) TYPE=MyISAM;

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` varchar(255) default NULL,
  `playbook_id` varchar(255) default NULL,
  `manager_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;