salix/db/versions/11298-wheatIvy/00-closure.sql

4 lines
213 B
MySQL
Raw Permalink Normal View History

2024-10-15 06:17:03 +00:00
ALTER TABLE `vn`.`ticketConfig`
ADD COLUMN `closureDaysAgo` int(11) NOT NULL DEFAULT 2 COMMENT 'Number of days to look back for ticket closure',
ADD CONSTRAINT `closureDaysAgo_check` CHECK (`closureDaysAgo` > 0);