znt/db/update21.6.1.sql

8 lines
538 B
SQL

ALTER TABLE `zt_task` ADD COLUMN `docs` text NULL AFTER `fromIssue`;
ALTER TABLE `zt_task` ADD COLUMN `docVersions` text NULL AFTER `docs`;
ALTER TABLE `zt_storyspec` ADD COLUMN `docs` text NULL AFTER `files`;
ALTER TABLE `zt_storyspec` ADD COLUMN `docVersions` text NULL AFTER `docs`;
ALTER TABLE `zt_design` ADD COLUMN `docs` text NULL AFTER `storyVersion`;
ALTER TABLE `zt_design` ADD COLUMN `docVersions` text NULL AFTER `docs`;
ALTER TABLE `zt_project` ADD `taskDateLimit` varchar(30) NOT NULL DEFAULT 'auto' AFTER `linkType`;