# these tables are no longer done by default but are in plugins, hopefully if any changes are necessary the plugin can handle them
# DROP TABLE `[% table_prefix %]_forum`; 
# DROP TABLE `[% table_prefix %]_forum_t`; 
# DROP TABLE `[% table_prefix %]_link_category`; 
# DROP TABLE `[% table_prefix %]_parser`;
# DROP TABLE `[% table_prefix %]_poll`;
# DROP TABLE `[% table_prefix %]_stat_counter`;
# DROP TABLE `[% table_prefix %]_stat_info`;
# DROP TABLE `[% table_prefix %]_stat_last`;
# DROP TABLE `[% table_prefix %]_wmessage`;
# DROP TABLE `[% table_prefix %]_cache`;
# DROP TABLE `[% table_prefix %]_chatbox`;
# DROP TABLE `[% table_prefix %]_content`;

ALTER TABLE[% table_prefix %]_banner MODIFY COLUMN `banner_active` tinyint(3) unsigned NOT NULL default '0',

ALTER TABLE [% table_prefix %]_comments  ADD COLUMN `comment_lock` tinyint(1) unsigned NOT NULL default '0' AFTER comment_type;

CREATE TABLE `[% table_prefix %]_dblog` (
  `dblog_id` int(10) unsigned NOT NULL auto_increment,
  `dblog_type` varchar(60) NOT NULL default '',
  `dblog_datestamp` int(10) unsigned NOT NULL default '0',
  `dblog_user_id` int(10) unsigned NOT NULL default '0',
  `dblog_ip` varchar(80) NOT NULL default '',
  `dblog_query` text NOT NULL,
  `dblog_remarks` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`dblog_id`)
) ENGINE=MyISAM ;

ALTER TABLE `[% table_prefix %]_download` 
  ADD COLUMN `download_class` varchar(255) NOT NULL default '0' AFTER download_comment,
  ADD COLUMN `download_mirror` text NOT NULL AFTER download_class,
  ADD COLUMN `download_mirror_type` tinyint(1) unsigned NOT NULL default '0' AFTER download_mirror,
  ADD COLUMN `download_visible` varchar(255) NOT NULL default '0' AFTER download_mirror_type,
  ADD KEY `download_category` (`download_category`);

ALTER  TABLE `[% table_prefix %]_download_category` (
 MODIFY COLUMN  `download_category_class` varchar(255) NOT NULL default '0',
 ADD COLUMN `download_category_order` int(10) unsigned NOT NULL default '0' AFTER download_category_class;

CREATE TABLE `[% table_prefix %]_download_mirror` (
  `mirror_id` int(10) unsigned NOT NULL auto_increment,
  `mirror_name` varchar(200) NOT NULL default '',
  `mirror_url` varchar(200) NOT NULL default '',
  `mirror_image` varchar(200) NOT NULL default '',
  `mirror_location` varchar(100) NOT NULL default '',
  `mirror_description` text NOT NULL,
  `mirror_count` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`mirror_id`)
) ENGINE=MyISAM ;

CREATE TABLE `[% table_prefix %]_download_requests` (
  `download_request_id` int(10) unsigned NOT NULL auto_increment,
  `download_request_userid` int(10) unsigned NOT NULL default '0',
  `download_request_ip` varchar(30) NOT NULL default '',
  `download_request_download_id` int(10) unsigned NOT NULL default '0',
  `download_request_datestamp` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`download_request_id`),
  KEY `download_request_userid` (`download_request_userid`),
  KEY `download_request_download_id` (`download_request_download_id`)
) ENGINE=MyISAM ;
 
CREATE TABLE `[% table_prefix %]_generic` (
  `gen_id` int(10) unsigned NOT NULL auto_increment,
  `gen_type` varchar(80) NOT NULL default '',
  `gen_datestamp` int(10) unsigned NOT NULL default '0',
  `gen_user_id` int(10) unsigned NOT NULL default '0',
  `gen_ip` varchar(80) NOT NULL default '',
  `gen_intdata` int(10) unsigned NOT NULL default '0',
  `gen_chardata` text NOT NULL,
  PRIMARY KEY  (`gen_id`)
) ENGINE=MyISAM ;

ALTER TABLE `[% table_prefix %]_links` 
  ADD COLUMN   `link_parent` int(10) unsigned NOT NULL default '0' AFTER link_refer,
  MODIFY COLUMN  `link_class` varchar(255) NOT NULL default '0'; 
 
ALTER TABLE `[% table_prefix %]_menus`
  MODIFY COLUMN  `menu_class` varchar(255) NOT NULL default '0',
  ADD COLUMN   `menu_path` varchar(100) NOT NULL default '' AFTER menu_pages;

INSERT INTO `[% table_prefix %]_menus` VALUES (1,'login_menu',1,1,'0','','login_menu/'),(3,'online_menu',0,0,'0','','online_menu/'),(4,'blogcalendar_menu',0,0,'0','','blogcalendar_menu/'),(5,'tree_menu',0,0,'0','','tree_menu/'),(6,'search_menu',0,0,'0','','search_menu/'),(7,'compliance_menu',0,0,'0','','compliance_menu/'),(8,'userlanguage_menu',0,0,'0','','userlanguage_menu/'),(9,'powered_by_menu',2,2,'0','','powered_by_menu/'),(10,'counter_menu',0,0,'0','','counter_menu/'),(11,'usertheme_menu',0,0,'0','','usertheme_menu/'),(12,'banner_menu',0,0,'0','','banner_menu/'),(13,'online_extended_menu',2,1,'0','','online_extended_menu/'),(14,'clock_menu',0,0,'0','','clock_menu/'),(15,'sitebutton_menu',0,0,'0','','sitebutton_menu/'),(16,'comment_menu',0,0,'0','','comment_menu/'),(17,'lastseen_menu',0,0,'0','','lastseen/'),(18,'other_news_menu',0,0,'0','','other_news_menu/'),(19,'other_news2_menu',0,0,'0','','other_news_menu/'),(20,'admin_menu',0,0,'0','','admin_menu/'),(21,'rss_menu',5,1,'0','','rss_menu/'),(22,'PCMag',3,1,'0','','1');
 
ALTER TABLE `[% table_prefix %]_news` 
  MODIFY COLUMN  `news_class` varchar(255) NOT NULL default '0',
  ADD COLUMN `news_comment_total` int(10) unsigned NOT NULL default '0' AFTER news_render_type,
  ADD COLUMN `news_summary` text NOT NULL AFTER news_comment_total,
  ADD COLUMN `news_thumbnail` text NOT NULL AFTER news_summary,
  ADD COLUMN `news_sticky` tinyint(3) unsigned NOT NULL default '0' AFTER news_thumbnail;

CREATE TABLE `[% table_prefix %]_page` (
  `page_id` int(10) unsigned NOT NULL auto_increment,
  `page_title` varchar(250) NOT NULL default '',
  `page_text` mediumtext NOT NULL,
  `page_author` int(10) unsigned NOT NULL default '0',
  `page_datestamp` int(10) unsigned NOT NULL default '0',
  `page_rating_flag` tinyint(1) unsigned NOT NULL default '0',
  `page_comment_flag` tinyint(1) unsigned NOT NULL default '0',
  `page_password` varchar(50) NOT NULL default '',
  `page_class` varchar(250) NOT NULL default '',
  `page_ip_restrict` text NOT NULL,
  `page_theme` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`page_id`)
) ENGINE=MyISAM ;

ALTER TABLE `[% table_prefix %]_plugin` ADD COLUMN `plugin_rss` varchar(255) NOT NULL default '' AFTER plugin_installflag;

CREATE TABLE `[% table_prefix %]_preset` (
  `preset_id` int(10) unsigned NOT NULL auto_increment,
  `preset_name` varchar(80) NOT NULL default '',
  `preset_field` varchar(80) NOT NULL default '',
  `preset_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`preset_id`)
) ENGINE=MyISAM ;

CREATE TABLE `[% table_prefix %]_user_extended` (
  `user_extended_id` int(10) unsigned NOT NULL default '0',
  `user_hidden_fields` text NOT NULL,
  PRIMARY KEY  (`user_extended_id`)
) ENGINE=MyISAM ;

CREATE TABLE `[% table_prefix %]_user_extended_struct` (
  `user_extended_struct_id` int(10) unsigned NOT NULL auto_increment,
  `user_extended_struct_name` varchar(255) NOT NULL default '',
  `user_extended_struct_text` varchar(255) NOT NULL default '',
  `user_extended_struct_type` tinyint(3) unsigned NOT NULL default '0',
  `user_extended_struct_parms` varchar(255) NOT NULL default '',
  `user_extended_struct_values` text NOT NULL,
  `user_extended_struct_default` varchar(255) NOT NULL default '',
  `user_extended_struct_read` tinyint(3) unsigned NOT NULL default '0',
  `user_extended_struct_write` tinyint(3) unsigned NOT NULL default '0',
  `user_extended_struct_required` tinyint(3) unsigned NOT NULL default '0',
  `user_extended_struct_signup` tinyint(3) unsigned NOT NULL default '0',
  `user_extended_struct_applicable` tinyint(3) unsigned NOT NULL default '0',
  `user_extended_struct_order` int(10) unsigned NOT NULL default '0',
  `user_extended_struct_parent` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_extended_struct_id`)
) ENGINE=MyISAM ;

# save this data, then drop the columns 
#  DROP COLUMN user_homepage,
#  DROP COLUMN user_icq,
#  DROP COLUMN user_aim,
#  DROP COLUMN user_msn,
#  DROP COLUMN user_location,
#  DROP COLUMN user_birthday,

ALTER TABLE `[% table_prefix %]_user
   ADD COLUMN `user_loginname` varchar(100) NOT NULL default '' AFTER user_name,
   MODIFY COLUMN `user_sess` varchar(100) NOT NULL default '',
   ADD COLUMN `user_xup` varchar(100) NOT NULL default '' AFTER user_pwchange,
   ADD KEY `user_ban_index` (`user_ban`);
