use [% xoops %];
## mysqldiff 0.30
##
## run on Thu Jan 17 09:35:20 2008
##
## ---   db: cpaddons_xoops1 (host=192.168.98.20 port=3306 user=cpaddons_xoops1)
## +++   db: cpaddons_xoops2 (host=192.168.98.20 port=3306 user=cpaddons_xoops2)

ALTER TABLE `[% table_prefix %]_block_instance` DROP INDEX `join`; # was INDEX (`instanceid`,`visible`,`weight`)
ALTER TABLE `[% table_prefix %]_block_instance` ADD INDEX `joinkeys` (`instanceid`,`visible`,`weight`);
ALTER TABLE `[% table_prefix %]_config` CHANGE COLUMN `conf_title` `conf_title` varchar(255) NOT NULL default ''; # was varchar(30) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_config` ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=66 DEFAULT CHARSET=latin1
ALTER TABLE `[% table_prefix %]_configcategory` CHANGE COLUMN `confcat_name` `confcat_name` varchar(255) NOT NULL default ''; # was varchar(25) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_configcategory` CHANGE COLUMN `confcat_id` `confcat_id` smallint(5) unsigned NOT NULL; # was smallint(5) unsigned NOT NULL default '0'
ALTER TABLE `[% table_prefix %]_configoption` ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1
ALTER TABLE `[% table_prefix %]_group_permission` ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1
ALTER TABLE `[% table_prefix %]_modules` ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
ALTER TABLE `[% table_prefix %]_ranks` CHANGE COLUMN `rank_image` `rank_image` varchar(255) default ''; # was varchar(255) default NULL
ALTER TABLE `[% table_prefix %]_tplfile` ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `theme` `theme` varchar(255) NOT NULL; # was varchar(255) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `last_login` `last_login` int(10) NOT NULL; # was int(10) NOT NULL default '0'
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `timezone_offset` `timezone_offset` varchar(255) NOT NULL; # was varchar(255) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `attachsig` `attachsig` int(1) NOT NULL; # was int(1) NOT NULL default '0'
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `actkey` `actkey` text NOT NULL; # was varchar(255) NOT NULL default ''
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `user_regdate` `user_regdate` int(10) NOT NULL; # was int(10) NOT NULL default '0'
ALTER TABLE `[% table_prefix %]_user_profile` CHANGE COLUMN `posts` `posts` int(10) NOT NULL; # was int(10) NOT NULL default '0'
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_viewemail` int(1) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `bio` text NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_aim` varchar(255) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `newemail` varchar(100) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_sig` text NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_from` varchar(255) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_yim` varchar(255) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `url` varchar(100) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_icq` varchar(255) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `pm_link` text NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_intrest` varchar(150) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_msnm` varchar(255) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile` ADD COLUMN `user_occ` varchar(100) NOT NULL;
ALTER TABLE `[% table_prefix %]_user_profile_field` ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; # was ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1
CREATE TABLE `[% table_prefix %]_priv_msgs` (
  `msg_id` mediumint(8) unsigned NOT NULL auto_increment,
  `msg_image` varchar(100) default NULL,
  `subject` varchar(255) NOT NULL default '',
  `from_userid` mediumint(8) unsigned NOT NULL default '0',
  `to_userid` mediumint(8) unsigned NOT NULL default '0',
  `msg_time` int(10) unsigned NOT NULL default '0',
  `msg_text` text NOT NULL,
  `read_msg` tinyint(1) unsigned NOT NULL default '0',
  `from_delete` tinyint(1) unsigned NOT NULL default '0',
  `from_save` tinyint(1) unsigned NOT NULL default '0',
  `to_delete` tinyint(1) unsigned NOT NULL default '0',
  `to_save` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`msg_id`),
  KEY `to_userid` (`to_userid`),
  KEY `inbox` (`to_userid`,`read_msg`),
  KEY `outbox` (`from_userid`,`read_msg`),
  KEY `prune` (`msg_time`,`read_msg`,`from_save`,`to_delete`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `[% table_prefix %]_profile_category`;

CREATE TABLE `[% table_prefix %]_profile_category` (
  `catid` int(12) unsigned NOT NULL auto_increment,
  `cat_title` varchar(255) NOT NULL default '',
  `cat_description` text NOT NULL,
  `cat_weight` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `[% table_prefix %]_profile_fieldcategory`;

CREATE TABLE `[% table_prefix %]_profile_fieldcategory` (
  `fieldid` int(12) unsigned NOT NULL,
  `catid` int(12) unsigned NOT NULL,
  `field_weight` tinyint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `[% table_prefix %]_ranks`;


