   `deadline` date NOT NULL,
   `asignee` varchar(100) NOT NULL,
   `notes` varchar(100) NOT NULL,
+  `created` date NOT NULL,
   `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   `project_id` int(11) NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
+
+--
+-- Dumping data for table `tasklist`
+--
+
+INSERT INTO `tasklist` (`id`, `name`, `status`, `priority`, `deadline`, `asignee`, `notes`, `created`, `timestamp`, `project_id`) VALUES
+(1, 'test', 'Not Started', 'Medium', '2016-08-21', 'Logan', '', '2016-08-31', '2016-08-31 22:57:10', 2);
 
 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

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

--
-- Table structure for table `projects`
--


  `asignee` varchar(100) NOT NULL,
  `description` varchar(200) NOT NULL,
  `deliverable` varchar(200) NOT NULL,
  `created` date NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`id`, `name`, `status`, `priority`, `deadline`, `asignee`, `description`, `deliverable`, `created`, `timestamp`) VALUES
(1, '', 0, '', '0000-00-00', '', '', '', '2016-08-31', '2016-08-31 22:50:41'),
(2, 'test', 1, 'High', '0000-00-00', 'Logan', 'test', '', '2016-08-31', '2016-08-31 22:51:54');

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

