USE [% ncls %];

ALTER TABLE `[% table_prefix %]_nucleus_blog`
CHANGE COLUMN `bnotify` `bnotify` varchar(128) DEFAULT NULL;

ALTER TABLE `[% table_prefix %]_nucleus_comment`
ADD INDEX `cblog` (`cblog`);

ALTER TABLE `[% table_prefix %]_nucleus_item`
ADD INDEX `idraft` (`idraft`);

ALTER TABLE `[% table_prefix %]_nucleus_item`
ADD INDEX `iblog` (`iblog`);

ALTER TABLE `[% table_prefix %]_nucleus_item`
ADD INDEX `icat` (`icat`);

UPDATE `[% table_prefix %]_nucleus_config`
SET `value`='350'
WHERE `name`='DatabaseVersion';

