task status tracking system

task status tracking system
-------------------------------

CREATE TABLE `task_list` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`task_name` VARCHAR( 255 ) NOT NULL ,
`task_description` TEXT NOT NULL ,
`technology` VARCHAR( 255 ) NOT NULL
) ;

CREATE TABLE `my_task_status` (
`tsid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`task_id` INT NOT NULL ,
`status` INT NOT NULL ,
`date_finished` INT NOT NULL ,
`date_updated` INT NOT NULL
) ;

ALTER TABLE `my_task_status` ADD `uid` INT NOT NULL ;