28 lines
1.6 KiB
SQL
28 lines
1.6 KiB
SQL
-- 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 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
|
|
CHANGE `code` `code` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
|
|
ALTER TABLE `zt_product` CHANGE `name` `name` VARCHAR( 90 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
|
|
CHANGE `code` `code` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
|