-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 05, 2008 at 08:22 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `shopcartdb`
--

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

--
-- Table structure for table `tbl_task`
--

CREATE TABLE IF NOT EXISTS `tbl_task` (
  `task_id` int(10) NOT NULL auto_increment,
  `task_created_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `task_last_updated_on` datetime NOT NULL default '0000-00-00 00:00:00',
  `task_name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL default '',
  `task_description` text character set utf8 collate utf8_unicode_ci NOT NULL,
  `task_status` int(11) NOT NULL,
  `task_comment` text collate latin1_general_ci NOT NULL,
  `task_comment_delete` text collate latin1_general_ci NOT NULL,
  `task_delivery_by_id` int(11) NOT NULL,
  `task_create_by_id` int(11) NOT NULL,
  `task_time_required` varchar(10) collate latin1_general_ci NOT NULL default '',
  `task_due_date` varchar(8) collate latin1_general_ci NOT NULL default '',
  `task_priority` enum('standart','urgent') collate latin1_general_ci NOT NULL default 'urgent',
  `task_authorisation_required` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
  `task_user_authorisation_id` int(10) default NULL,
  `task_date_approval` datetime default NULL,
  `task_attach_file` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`task_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `tbl_task`
--

