28 lines
1.4 KiB
MySQL
28 lines
1.4 KiB
MySQL
|
-- 2010-03-20 adjust bug table.
|
||
|
|
ALTER TABLE `zt_bug` ADD `pri` TINYINT UNSIGNED NOT NULL AFTER `severity`;
|
||
|
|
ALTER TABLE `zt_bug` ADD `keywords` VARCHAR( 255 ) NOT NULL AFTER `title`;
|
||
|
|
ALTER TABLE `zt_case` ADD `keywords` VARCHAR( 255 ) NOT NULL AFTER `title`;
|
||
|
|
ALTER TABLE `zt_case` ADD `stage` VARCHAR( 255 ) NOT NULL AFTER `type`;
|
||
|
|
ALTER TABLE `zt_case` ADD `howRun` VARCHAR( 30 ) NOT NULL AFTER `stage`,
|
||
|
|
ADD `scriptedBy` VARCHAR( 30 ) NOT NULL AFTER `howRun`,
|
||
|
|
ADD `scriptedDate` DATE NOT NULL AFTER `scriptedBy`,
|
||
|
|
ADD `scriptStatus` VARCHAR( 30 ) NOT NULL AFTER `scriptedDate`,
|
||
|
|
ADD `scriptLocation` VARCHAR( 255 ) NOT NULL AFTER `scriptStatus`,
|
||
|
|
ADD `linkCase` VARCHAR( 255 ) NOT NULL AFTER `version`;
|
||
|
|
|
||
|
|
-- 2010-03-27 fix bug 43
|
||
|
|
update zt_projectStory,zt_story set zt_projectStory.product=zt_story.product where zt_projectStory.story=zt_story.id;
|
||
|
|
|
||
|
|
-- 2010-03-27 add keywords to story.
|
||
|
|
ALTER TABLE `zt_story` ADD `keywords` VARCHAR( 255 ) NOT NULL AFTER `title`;
|
||
|
|
|
||
|
|
-- 2010-03-29 add fields of project.
|
||
|
|
ALTER TABLE `zt_project` ADD `acl` ENUM( 'open', 'private', 'custom' ) NOT NULL DEFAULT 'open',
|
||
|
|
ADD `whitelist` VARCHAR( 255 ) NOT NULL;
|
||
|
|
|
||
|
|
-- 2010-03-29 adjust the field length.
|
||
|
|
ALTER TABLE `zt_project` CHANGE `name` `name` VARCHAR( 90 ) NOT NULL,
|
||
|
|
CHANGE `code` `code` VARCHAR( 45 ) NOT NULL;
|
||
|
|
ALTER TABLE `zt_product` CHANGE `name` `name` VARCHAR( 90 ) NOT NULL,
|
||
|
|
CHANGE `code` `code` VARCHAR( 45 ) NOT NULL;
|