Re: [Planner Dev] MySQL tables

[Malcolm Tredinnick <malcolm commsecure com au>]

Hey Lars,

One quick question, because I have not used MySQL in a few years...

On Thu, 2004-02-05 at 18:44, Lars Brandi Jensen wrote:
[...]
> # DROP TABLE IF EXISTS task;
> CREATE TABLE `task` (
>   `task_id` int(11) NOT NULL auto_increment,
>   `parent_id` int(11) default NULL,
>   `proj_id` int(11) default NULL,
>   `name` text NOT NULL,
>   `note` text,
>   `start` timestamp(14) NOT NULL,
>   `finish` timestamp(14) NOT NULL,
>   `work` int(11) default NULL,
>   `duration` int(11) default NULL,
>   `percent_complete` int(11) default NULL,
>   `is_milestone` tinyint(4) NOT NULL default '0',
>   `is_fixed_work` tinyint(4) NOT NULL default '0',
>   `constraint_type` text NOT NULL,
>   `constraint_time` timestamp(14) NOT NULL,
>   KEY `task_id` (`task_id`)
> ) TYPE=MyISAM;

Does MySQL's timestamp property include the time zone by default? If
not, you need to add the timezone to 'start' and 'finish'.

Cheers,
Malcolm