[提供] 升級AppServ之後，些許外掛資料庫截半快速修正SQL

[minotaur]

advanced_links_mod_1.2.2 推薦網站

ALTER TABLE `phpbb_link_categories` CHANGE `cat_id` `cat_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE `cat_title` `cat_title` VARCHAR( 100 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `cat_order` `cat_order` MEDIUMINT( 8 ) UNSIGNED DEFAULT '0' NOT NULL

ALTER TABLE `phpbb_link_links` CHANGE `link_title` `link_title` VARCHAR( 100 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `link_desc` `link_desc` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT NULL ,
CHANGE `link_url` `link_url` VARCHAR( 100 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `link_logo_src` `link_logo_src` VARCHAR( 120 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT NULL ,
CHANGE `user_ip` `user_ip` VARCHAR( 8 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `last_user_ip` `last_user_ip` VARCHAR( 8 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL

ALTER TABLE `phpbb_link_config` CHANGE `config_name` `config_name` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `config_value` `config_value` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL


陸續增加各外掛快速修正SQL.......
錯誤請修正.......
遺漏請告知.........
為以後升級做些準備吧!!!!!!

[minotaur]

偽子分區-資料庫整合版 Version : 1.0.1

SQL 語法:
ALTER TABLE `phpbb_forums_control` CHANGE `control_id` `control_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
CHANGE `show_forums` `show_forums` VARCHAR( 3 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT NULL ,
CHANGE `hide_forums` `hide_forums` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT NULL

[minotaur]

phpBB 主題過長無法瀏覽\r

SQL 語法:
ALTER TABLE `phpbb_topics` CHANGE `topic_title` `topic_title` CHAR( 120 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL

ALTER TABLE `phpbb_posts_text` CHANGE `post_subject` `post_subject` VARCHAR( 120 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL

[minotaur]

Log Actions MOD Version: 1.1.6 (紀錄管理者的動作)

SQL 語法:
ALTER TABLE `phpbb_logs` CHANGE `mode` `mode` VARCHAR( 50 ) CHARACTER SET big5 COLLATE big5_chinese_ci,
CHANGE `username` `username` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci,
CHANGE `user_ip` `user_ip` VARCHAR( 8 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT '0' NOT NULL

ALTER TABLE `phpbb_logs_config` CHANGE `config_name` `config_name` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `config_value` `config_value` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL

[minotaur]

CashMod222

SQL 語法:
ALTER TABLE `phpbb_cash` CHANGE `cash_dbfield` `cash_dbfield` VARCHAR( 64 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT 'user_cash' NOT NULL ,
CHANGE `cash_name` `cash_name` VARCHAR( 64 ) CHARACTER SET big5 COLLATE big5_chinese_ci DEFAULT 'cash' NOT NULL ,
CHANGE `cash_imageurl` `cash_imageurl` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `cash_forumlist` `cash_forumlist` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL

ALTER TABLE `phpbb_cash_events` CHANGE `event_name` `event_name` VARCHAR( 32 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `event_data` `event_data` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL

ALTER TABLE `phpbb_cash_log` CHANGE `log_action` `log_action` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL ,
CHANGE `log_text` `log_text` VARCHAR( 255 ) CHARACTER SET big5 COLLATE big5_chinese_ci NOT NULL