-- Database dump for CSCI403
-- Delightful Homework #1
-- Host: hades.local
-- Generation Time: Feb 15, 2008 at 04:20 PM
-- Server version: 5.0.45

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `tasklist`
--

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `user_id` int(4) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `user_id`) VALUES
(1, 'personal', 1),
(2, 'business', 1),
(3, 'school', 1),
(4, 'fitness', 1),
(5, 'goals', 1),
(6, 'fun', 2),
(7, 'work', 2);

-- --------------------------------------------------------

--
-- Table structure for table `priorities`
--

CREATE TABLE `priorities` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `name` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `priorities`
--

INSERT INTO `priorities` (`id`, `name`) VALUES
(1, 'high'),
(2, 'kinda-high'),
(3, 'med'),
(4, 'sorta-low'),
(5, 'whenever');

-- --------------------------------------------------------

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `description` varchar(64) NOT NULL default '',
  `due_date` date NOT NULL,
  `status` tinyint(1) NOT NULL,
  `category_id` int(4) default NULL,
  `priority_id` int(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `description`, `due_date`, `status`, `category_id`, `priority_id`) VALUES
(1, 'walk dog', '2008-02-03', 0, 1, 1),
(2, 'change oil', '2008-02-03', 0, NULL, 3),
(3, 'water plants', '2008-02-03', 0, NULL, 1),
(4, 'wash car', '2008-02-03', 0, 1, 3),
(5, 'implement project database', '2008-02-03', 0, 3, 2),
(6, 'read ''SQL Performance Tuning''', '2008-02-03', 0, 2, 1),
(7, 'pickup keg for party', '2008-02-03', 0, 6, 1),
(8, 'get pa system from Mike', '2008-02-03', 0, 6, 2),
(9, 'pickup smoke machine', '2008-02-03', 0, 6, 2),
(10, 'get cleaning supplies', '2008-02-03', 0, 6, 3),
(11, 'call in sick', '2008-02-04', 0, 6, 1),
(12, 'update kernel', '2008-02-04', 0, 7, 2);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `username` varchar(32) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`) VALUES
(1, 'gwbush', 'encrypted'),
(2, 'lskywalker', 'encrypted');