use [% pwki %]
#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 16.01.2008 13:44
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: dedipco_pwki1
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: dedipco_pwki0
# --------------------------------------------------------
#

SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
ALTER TABLE accesslog
    MODIFY remote_host varchar(100) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
#  Fieldformat of
#    accesslog.remote_host changed from varchar(50) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(100) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
#  Possibly data modifications needed!
#

ALTER TABLE link
    ADD relation int(11) NULL DEFAULT '0' COMMENT '' AFTER linkto,
    ADD INDEX relation (relation);


ALTER TABLE pref
    MODIFY userid varchar(48) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_bin,
    MODIFY passwd varchar(48) NULL DEFAULT '' COMMENT '' COLLATE latin1_bin,
    MODIFY groupname varchar(48) NULL DEFAULT 'users' COMMENT '' COLLATE latin1_bin;
#
#  Fieldformats of
#    pref.userid changed from char(48) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_bin to varchar(48) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_bin.
#    pref.passwd changed from char(48) NULL DEFAULT '' COMMENT '' COLLATE latin1_bin to varchar(48) NULL DEFAULT '' COMMENT '' COLLATE latin1_bin.
#    pref.groupname changed from char(48) NULL DEFAULT 'users' COMMENT '' COLLATE latin1_bin to varchar(48) NULL DEFAULT 'users' COMMENT '' COLLATE latin1_bin.
#  Possibly data modifications needed!
#

#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;
