dedecms一键安装包

<?php
// 数据库配置
$db_host = 'localhost';
$db_user = 'root';
$db_pass = 'password';
$db_name = 'dedecms';

// 连接数据库
$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);

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` smallint(5) unsigned NOT NULL DEFAULT '0',
    `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
    `click` int(11) unsigned NOT NULL DEFAULT '0',
    `title` varchar(200) NOT NULL DEFAULT '',
    `color` varchar(10) NOT NULL DEFAULT '',
    `writer` varchar(30) NOT NULL DEFAULT '',
    `source` varchar(100) NOT NULL DEFAULT '',
    `litpic` varchar(100) NOT NULL DEFAULT '',
    `pubdate` int(11) unsigned NOT NULL DEFAULT '0',
    `senddate` int(11) unsigned NOT NULL DEFAULT '0',
    `adminID` smallint(5) unsigned NOT NULL DEFAULT '0',
    `keywords` varchar(60) NOT NULL DEFAULT '',
    `description` varchar(250) NOT NULL DEFAULT '',
    `filetype` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `sortrank` int(11) unsigned NOT NULL DEFAULT '0',
    `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
    `ismake` tinyint(1) unsigned NOT NULL DEFAULT '-1',
    `ishot` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `istop` tiny` tinyint(1) unsigned NOT NULL DEFAULT '0',
    `redirecturl` varchar(255) NOT NULL DEFAULT '',
    `template` varchar(30) NOT NULL DEFAULT '',
    `userip` varchar(20) NOT NULL DEFAULT '',
    `lastpost` int(11) unsigned NOT NULL DEFAULT '0',
    `scores` int(11) NOT NULL DEFAULT '0',
    `goodpost` smallint(6) unsigned NOT NULL DEFAULT '0',
    `badpost` smallint(6) unsigned NOT NULL DEFAULT '0',
    `vote` smallint(6) unsigned NOT NULL DEFAULT '0',
    `notpost` smallint(6) unsigned NOT NULL DEFAULT '0',
    `access` int(11) unsigned NOT NULL DEFAULT '0',
    ` uptime` int(11) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`),
    KEY `idx_typeid` (`typeid`),
    KEY `idx_channel` (`channel`),
    KEY `idx_pubdate` (`pubdate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4";

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

mysqli_close($conn);
?>