You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
720 B
20 lines
720 B
/**
|
|
* @signature e7dfe82131b906a14f6a13163943855f
|
|
* @version v1.11.0
|
|
* @title Nested Knowledgebase Categories
|
|
*
|
|
* This patch adds a new field, category_pid, to the faq_category table
|
|
* to allow for adding nested categories to the knowledgebase.
|
|
*/
|
|
ALTER TABLE `%TABLE_PREFIX%faq_category`
|
|
ADD `category_pid` int(10) unsigned DEFAULT NULL AFTER `category_id`;
|
|
|
|
-- Phone Field `name` and `flags`
|
|
UPDATE `%TABLE_PREFIX%form_field`
|
|
SET `flags` = `flags` + 262144
|
|
WHERE `type` = 'phone' AND `name` = 'phone' AND `form_id` = 1 AND `id` < 10;
|
|
|
|
-- Finished with patch
|
|
UPDATE `%TABLE_PREFIX%config`
|
|
SET `value` = 'e7dfe82131b906a14f6a13163943855f'
|
|
WHERE `key` = 'schema_signature' AND `namespace` = 'core';
|