1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| CREATE TABLE IF NOT EXISTS `addressbook` (
`contact_id` int(11) NOT NULL auto_increment,
`contact_tid` varchar(1) default 'n',
`contact_owner` bigint(20) NOT NULL,
`contact_private` tinyint(4) default '0',
`cat_id` varchar(255) default NULL,
`n_family` varchar(64) default NULL,
`n_given` varchar(64) default NULL,
`n_middle` varchar(64) default NULL,
`n_prefix` varchar(64) default NULL,
`n_suffix` varchar(64) default NULL,
`n_fn` varchar(128) default NULL,
`account_id` int(11) default NULL,
PRIMARY KEY (`contact_id`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=103 ;
CREATE TABLE IF NOT EXISTS `timesheet` (
`ts_id` int(11) NOT NULL auto_increment,
`ts_project` varchar(80) default NULL,
`ts_title` varchar(80) NOT NULL,
`ts_description` text,
`ts_start` bigint(20) NOT NULL,
`ts_duration` bigint(20) NOT NULL default '0',
`ts_quantity` double NOT NULL,
`ts_unitprice` double default NULL,
`cat_id` int(11) default '0',
`ts_owner` int(11) NOT NULL,
`ts_modified` bigint(20) NOT NULL,
`ts_modifier` int(11) NOT NULL,
`pl_id` int(11) default '0',
PRIMARY KEY (`ts_id`),
KEY timesheet_ts_project` (`ts_project`),
KEY `timesheet_ts_owner` (`ts_owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19833 ; |
Partager