use [% ncls %];
#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 17.01.2008 10:26
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: dedipco_ncls1
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: dedipco_ncls0
# --------------------------------------------------------
#

SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
ALTER TABLE [% table_prefix %]_nucleus_blog
    ADD breqemail tinyint(2) NOT NULL COMMENT '' AFTER bincludesearch,
    ADD bfuturepost tinyint(2) NOT NULL COMMENT '' AFTER breqemail;


ALTER TABLE [% table_prefix %]_nucleus_category
    MODIFY cname varchar(200) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformat of
#    [% table_prefix %]_nucleus_category.cname changed from varchar(40) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(200) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE [% table_prefix %]_nucleus_comment
    ADD cemail varchar(100) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER cmail;


ALTER TABLE [% table_prefix %]_nucleus_item
    ADD iposted tinyint(2) NOT NULL DEFAULT '1' COMMENT '' AFTER ikarmaneg;


#
# DDL END
#

#
# DML START
#

REPLACE INTO [% table_prefix %]_nucleus_config (name,value) VALUES ('DatabaseVersion','330');

REPLACE INTO [% table_prefix %]_nucleus_plugin (pid,pfile,porder) VALUES ('1','NP_SkinFiles','1');

REPLACE INTO [% table_prefix %]_nucleus_plugin_event (pid,event) VALUES ('1','QuickMenu');

#
# DML END
#
