dede重新安装数据库

<?php
// 连接数据库
$host = 'localhost';
$user = 'root';
$pass = '';
$dbname = 'dedecms';

$conn = mysqli_connect($host, $user, $pass, $dbname);

if (!$conn) {
    die('数据库连接失败: ' . mysqli_connect_error());
}

// 初始化数据库
$sql = "CREATE TABLE IF NOT EXISTS `dede_archives` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
    `channel` smallint(5) unsigned NOT NULL DEFAULT '0',
    `arcrank` tinyint(1) NOT NULL DEFAULT '0',
    `click` int(11) NOT NULL DEFAULT '0',
    `title` varchar(200) NOT NULL DEFAULT '',
    `color` varchar(10) NOT NULL DEFAULT '',
    `laiyuan` varchar(200) NOT NULL DEFAULT '',
    `writer` varchar(100) NOT NULL DEFAULT '',
    `source` varchar(100) NOT NULL DEFAULT '',
    `pubdate` int(11) NOT NULL DEFAULT '0',
    `senddate` int(11) NOT NULL DEFAULT '0',
    `adminID` int(11) NOT NULL DEFAULT '0',
    `keywords` varchar(255) NOT NULL DEFAULT '',
    `description` varchar(255) NOT NULL DEFAULT '',
    `filetype` tinyint(1) NOT NULL DEFAULT '0',
    `sortrank` smallint(5) unsigned NOT NULL DEFAULT '0',
    `ismake` tinyint(1) NOT NULL DEFAULT '-1',
    `ismakeindex` tinyint(1) NOT NULL DEFAULT '-1',
    `danmu` tinyint(1) NOT NULL DEFAULT '0',
    `userip` varchar(20) NOT NULL DEFAULT '',
    `lastpost` int(11) NOT NULL DEFAULT '0',
    `scores` int(11) NOT NULL DEFAULT '0',
    `goodpost` smallint(6) NOT NULL DEFAULT '0',
    `badpost` smallint(6) NOT NULL DEFAULT '0',
    `vote` smallint(6) NOT NULL DEFAULT '0',
    `notpost` smallint(6) NOT NULL DEFAULT '0',
    `istop` tinyint(1) NOT NULL DEFAULT '0',
    `isgood` tinyint(1) NOT NULL DEFAULT '0',
    `isbest` tinyint(1) NOT NULL DEFAULT '0',
    `ishot` tinyint(1) NOT NULL DEFAULT '0',
    `iscommend` tinyint(1) NOT NULL DEFAULT '0',
    `issearch` tinyint(1) NOT NULL DEFAULT '0',
    `ismsg` tinyint(1) NOT NULL DEFAULT '0',
    `isthumb` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `idx_typeid` (`typeid`),
    KEY `idx_channel` (`channel`),
    KEY `idx_pubdate` (`pubdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";

if (mysqli_query($conn, $sql)) {
    echo "数据库初始化成功";
} else {
    echo "数据库初始化失败: " . mysqli_error($conn);
}

mysqli_close($conn);
?>