text: /**
   * @version v1.9.0
   * @signature 9ef33a062ca3a20190dfad594d594a69
   * @title Add organization features
   *
   */
  
  ALTER TABLE `%TABLE_PREFIX%form`
      CHANGE `type` `type` varchar(8) NOT NULL DEFAULT 'G';
  
  ALTER TABLE `%TABLE_PREFIX%list_items`
      ADD `status` int(11) unsigned NOT NULL DEFAULT 1 AFTER `list_id`,
      ADD `properties` text AFTER `sort`;
  
  ALTER TABLE `%TABLE_PREFIX%organization`
      ADD `status` int(11) unsigned NOT NULL DEFAULT 0 AFTER `staff_id`,
      ADD `domain` varchar(128) NOT NULL DEFAULT '' AFTER `status`,
      ADD `extra` text AFTER `domain`;
  
  ALTER TABLE `%TABLE_PREFIX%filter`
      ADD `status` int(11) unsigned NOT NULL DEFAULT '0' AFTER `isactive`,
      ADD `ext_id` varchar(11) AFTER `topic_id`;
  
  DROP TABLE IF EXISTS `%TABLE_PREFIX%note`;
  CREATE TABLE `%TABLE_PREFIX%note` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `pid` int(11) unsigned,
    `staff_id` int(11) unsigned NOT NULL DEFAULT 0,
    `ext_id` varchar(10),
    `body` text,
    `status` int(11) unsigned NOT NULL DEFAULT 0,
    `sort` int(11) unsigned NOT NULL DEFAULT 0,
    `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) DEFAULT CHARSET=utf8;
  
  -- Finished with patch
  UPDATE `%TABLE_PREFIX%config`
      SET `value` = '9ef33a062ca3a20190dfad594d594a69'
      WHERE `key` = 'schema_signature' AND `namespace` = 'core';
  