USE [% wp %];
 
ALTER TABLE `[% table_prefix %]_categories`
 MODIFY COLUMN `category_parent` bigint(20) NOT NULL default '0',
 ADD COLUMN `category_count` bigint(20) NOT NULL default '0' AFTER category_parent;

ALTER TABLE `[% table_prefix %]_comments` 
 MODIFY COLUMN  `comment_parent` bigint(20) NOT NULL default '0',
 MODIFY COLUMN `user_id` bigint(20) NOT NULL default '0';
 
ALTER TABLE `[% table_prefix %]_links` 
 MODIFY COLUMN  `link_category` bigint(20) NOT NULL default '0';


ALTER TABLE `[% table_prefix %]_postmeta` 
 MODIFY COLUMN  `meta_value` longtext;

ALTER TABLE `[% table_prefix %]_posts` 
 MODIFY COLUMN `post_author` bigint(20) NOT NULL default '0',
 MODIFY COLUMN  `post_status` enum('publish','draft','private','static','object','attachment') NOT NULL default 'publish',
 MODIFY COLUMN  `post_parent` bigint(20) NOT NULL default '0',
 ADD COLUMN  `post_type` varchar(100) NOT NULL default '' AFTER menu_order,
 ADD COLUMN  `post_mime_type` varchar(100) NOT NULL default '' AFTER post_type,
 ADD COLUMN  `comment_count` bigint(20) NOT NULL default '0' AFTER post_mime_type;
   
CREATE TABLE `[% table_prefix %]_usermeta` (
  `umeta_id` bigint(20) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL default '0',
  `meta_key` varchar(255) default NULL,
  `meta_value` longtext,
  PRIMARY KEY  (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM [% _default_charset_latin1 %];
 
# columns left in so it can be saved and then dropped:
#  `user_firstname` varchar(50) NOT NULL default '',
#  `user_lastname` varchar(50) NOT NULL default '',
#  `user_nickname` varchar(50) NOT NULL default '',
#  `user_icq` int(10) unsigned NOT NULL default '0',
#  `user_ip` varchar(15) NOT NULL default '',
#  `user_domain` varchar(200) NOT NULL default '',
#  `user_browser` varchar(200) NOT NULL default '',
#  `user_level` int(2) unsigned NOT NULL default '0',
#  `user_aim` varchar(50) NOT NULL default '',
#  `user_msn` varchar(100) NOT NULL default '',
#  `user_yim` varchar(50) NOT NULL default '',
#  `user_idmode` varchar(20) NOT NULL default '',
#  `user_description` longtext NOT NULL,

ALTER TABLE `[% table_prefix %]_users` (
 ADD COLUMN `display_name` varchar(250) NOT NULL default '' AFTER user_description;
