18 lines
817 B
SQL
18 lines
817 B
SQL
CREATE TABLE `zt_taskteam` (
|
|
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
|
|
`task` mediumint(8) unsigned NOT NULL,
|
|
`account` char(30) NOT NULL,
|
|
`estimate` decimal(12,2) NOT NULL,
|
|
`consumed` decimal(12,2) NOT NULL,
|
|
`left` decimal(12,2) NOT NULL,
|
|
`transfer` char(30) NOT NULL,
|
|
`status` enum('wait','doing','done') NOT NULL DEFAULT 'wait',
|
|
`order` tinyint(3) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `task` (`task`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
ALTER TABLE `zt_taskestimate` ADD `order` tinyint unsigned NOT NULL DEFAULT '0';
|
|
ALTER TABLE `zt_effort` ADD `order` tinyint unsigned NOT NULL DEFAULT '0' AFTER `end`;
|
|
ALTER TABLE `zt_storyspec` ADD `files` text NOT NULL AFTER `verify`;
|
|
ALTER TABLE `zt_block` CHANGE `block` `block` varchar(30) COLLATE 'utf8_general_ci' NOT NULL AFTER `source`;
|