Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
/**
* @version v1.8.1
* @signature 8473721890e9eddb6417076c96b715a1
* @title Various schema improvements and bug fixes
*
*/
-- [#317](https://github.com/osTicket/osTicket-1.8/issues/317)
ALTER TABLE `%TABLE_PREFIX%faq`
CHANGE `created` `created` datetime NOT NULL,
CHANGE `updated` `updated` datetime NOT NULL;
-- [#328](https://github.com/osTicket/osTicket-1.8/issues/328)
UPDATE `%TABLE_PREFIX%filter_rule`
SET `how` = 'equal' WHERE `how` IS NULL;
-- [#331](https://github.com/osTicket/osTicket-1.8/issues/331)
ALTER TABLE `%TABLE_PREFIX%ticket_email_info`
CHANGE `message_id` `thread_id` int(11) unsigned NOT NULL,
ADD PRIMARY KEY (`thread_id`),
DROP INDEX `message_id`,
ADD INDEX `email_mid` (`email_mid`);
-- [#386](https://github.com/osTicket/osTicket-1.8/issues/386)
UPDATE `%TABLE_PREFIX%email_template`
SET `body` = REPLACE(`body`, '%{recipient}', '%{recipient.name}');
-- Change EndUser link to be recipient specific
UPDATE `%TABLE_PREFIX%email_template`
SET `body` = REPLACE(`body`, '%{ticket.client_link}', '%{recipient.ticket_link}');
-- Add inline flag and drop ref_type
ALTER TABLE `%TABLE_PREFIX%ticket_attachment`
ADD `inline` tinyint(1) NOT NULL default 0 AFTER `ref_id`,
DROP `ref_type`;
ALTER TABLE `%TABLE_PREFIX%ticket_thread`
ADD `user_id` int(11) unsigned not null default 0 AFTER `staff_id`;
ALTER TABLE `%TABLE_PREFIX%ticket`
ADD `email_id` int(11) unsigned not null default 0 AFTER `team_id`,
CHANGE `ticketID` `number` varchar(20);
ALTER TABLE `%TABLE_PREFIX%ticket_collaborator`
ADD`created` datetime NOT NULL AFTER `role`;
-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
SET `value` = '8473721890e9eddb6417076c96b715a1'
WHERE `key` = 'schema_signature' AND `namespace` = 'core';