200_rc_3.php

CMS系统

<?php

// get rid of cookiedomain and cookiepath, since forum systems are updated to use "", "/"
$DB->query("ALTER TABLE " . TABLE_PREFIX . "usersystems DROP cookiedomain, DROP cookiepath");

// add new keys
$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories     ADD PRIMARY KEY (`categoryid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories     ADD INDEX       (`displayorder`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "comments       ADD PRIMARY KEY (`commentid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "customplugins  ADD PRIMARY KEY (`custompluginid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "designs        ADD PRIMARY KEY (`designid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "mainsettings   ADD PRIMARY KEY (`settingid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p2_news        ADD PRIMARY KEY (`articleid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p2_news        ADD INDEX       (`categoryid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p4_guestbook   ADD PRIMARY KEY (`messageid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p7_chatterbox  ADD PRIMARY KEY (`commentid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p16_links      ADD PRIMARY KEY (`linkid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p16_sections   ADD PRIMARY KEY (`sectionid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_images     ADD PRIMARY KEY (`imageid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_sections   ADD PRIMARY KEY (`sectionid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "plugins        ADD PRIMARY KEY (`pluginid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "phrases        ADD PRIMARY KEY (`phraseid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "phrases        ADD INDEX       (`pluginid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "pluginsettings ADD PRIMARY KEY (`settingid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "pluginsettings ADD INDEX       (`pluginid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "skins          ADD PRIMARY KEY (`skinid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "smilies        ADD PRIMARY KEY (`smilieid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "users          ADD PRIMARY KEY (`userid`)");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "usersystems    ADD PRIMARY KEY (`usersystemid`)");

// remove old keys
$DB->query("ALTER TABLE " . TABLE_PREFIX . "categories     DROP INDEX `categoryid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "comments       DROP INDEX `commentid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "customplugins  DROP INDEX `custompluginid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "designs        DROP INDEX `designid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "mainsettings   DROP INDEX `settingid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p2_news        DROP INDEX `articleid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p4_guestbook   DROP INDEX `messageid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p7_chatterbox  DROP INDEX `commentid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p16_links      DROP INDEX `linkid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p16_sections   DROP INDEX `sectionid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_images     DROP INDEX `imageid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "p17_sections   DROP INDEX `sectionid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "plugins        DROP INDEX `pluginid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "phrases        DROP INDEX `phraseid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "pluginsettings DROP INDEX `settingid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "skins          DROP INDEX `skinid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "smilies        DROP INDEX `smilieid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "users          DROP INDEX `userid`");
$DB->query("ALTER TABLE " . TABLE_PREFIX . "usersystems    DROP INDEX `usersystemid`");

// optimize tables
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "categories");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "comments");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "customplugins");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "designs");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "mainsettings");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p2_news");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p4_guestbook");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p7_chatterbox");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p16_links");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p16_sections");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p17_images");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "p17_sections");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "pagesort");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "phrases");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "plugins");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "pluginsettings");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "sessions");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "skins");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "smilies");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "usergroups");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "users");
$DB->query("OPTIMIZE TABLE " . TABLE_PREFIX . "usersystems");

?>