
手动安装呆错后台管理框架MYSQL版本的方法
人气:1,125 更新:2022-03-14
第一步:通过phpmyadmin导入install.sql或mysql命令还原install.sql
第二步:修改数据库连接(./apps/database.php)
第三步:使用初始用户名与密码(admin/admin888)进入网站后台、后台管理路径为admin.php(可以随意修改)。
第四步:在地址栏输入(admin.php/tool/clear)即可导入初始数据。
install.sql 建表语句如下
DROP TABLE IF EXISTS `dc_info`;
CREATE TABLE `dc_info` (
`info_id` bigint(20) NOT NULL,
`info_name` varchar(255) DEFAULT NULL,
`info_slug` varchar(255) DEFAULT NULL,
`info_excerpt` text,
`info_content` longtext,
`info_password` varchar(255) DEFAULT NULL,
`info_create_time` int(11) DEFAULT '0',
`info_update_time` int(11) DEFAULT '0',
`info_parent` bigint(20) DEFAULT '0',
`info_order` int(11) DEFAULT '0',
`info_user_id` bigint(20) DEFAULT '0',
`info_type` varchar(100) DEFAULT NULL,
`info_mime_type` varchar(100) DEFAULT NULL,
`info_status` varchar(60) DEFAULT 'normal',
`info_comment_status` varchar(100) DEFAULT 'open',
`info_comment_count` bigint(20) DEFAULT '0',
`info_views` bigint(20) DEFAULT '0',
`info_hits` bigint(20) DEFAULT '0',
`info_module` varchar(100) DEFAULT 'common',
`info_controll` varchar(100) DEFAULT NULL,
`info_action` varchar(100) DEFAULT NULL,
`info_title` varchar(255) DEFAULT NULL,
`info_keywords` varchar(255) DEFAULT NULL,
`info_description` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_info_meta`;
CREATE TABLE `dc_info_meta` (
`info_meta_id` bigint(20) NOT NULL,
`info_meta_key` varchar(255) NOT NULL,
`info_meta_value` longtext,
`info_id` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_log`;
CREATE TABLE `dc_log` (
`log_id` bigint(20) NOT NULL,
`log_user_id` bigint(20) NOT NULL DEFAULT '0',
`log_info_id` bigint(20) NOT NULL DEFAULT '0',
`log_value` int(11) NOT NULL DEFAULT '0' COMMENT '整数值',
`log_decimal` decimal(18,2) NOT NULL DEFAULT '0.00' COMMENT '小数值',
`log_status` varchar(60) NOT NULL DEFAULT 'normal',
`log_module` varchar(150) DEFAULT NULL,
`log_controll` varchar(150) DEFAULT NULL,
`log_action` varchar(150) DEFAULT NULL,
`log_type` varchar(100) DEFAULT NULL,
`log_ip` varchar(250) DEFAULT NULL,
`log_name` varchar(250) DEFAULT NULL,
`log_info` tinytext,
`log_create_time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_op`;
CREATE TABLE `dc_op` (
`op_id` bigint(20) NOT NULL,
`op_name` varchar(150) NOT NULL,
`op_value` longtext,
`op_module` varchar(50) DEFAULT NULL,
`op_controll` varchar(50) DEFAULT NULL,
`op_action` varchar(50) DEFAULT NULL,
`op_order` int(11) DEFAULT '0',
`op_autoload` varchar(20) DEFAULT 'yes',
`op_status` varchar(60) DEFAULT 'normal'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_term`;
CREATE TABLE `dc_term` (
`term_id` bigint(20) NOT NULL,
`term_name` varchar(255) DEFAULT NULL,
`term_slug` varchar(255) DEFAULT NULL,
`term_module` varchar(100) DEFAULT 'common',
`term_controll` varchar(100) DEFAULT 'common',
`term_action` varchar(100) DEFAULT 'common',
`term_status` varchar(60) DEFAULT 'normal',
`term_order` int(11) DEFAULT '0',
`term_type` varchar(100) DEFAULT NULL,
`term_info` text,
`term_parent` bigint(20) NOT NULL DEFAULT '0',
`term_count` int(11) NOT NULL DEFAULT '0',
`term_title` varchar(255) DEFAULT NULL,
`term_keywords` varchar(255) DEFAULT NULL,
`term_description` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_term_map`;
CREATE TABLE `dc_term_map` (
`detail_id` bigint(20) DEFAULT '0',
`term_id` bigint(20) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_term_meta`;
CREATE TABLE `dc_term_meta` (
`term_meta_id` bigint(20) NOT NULL,
`term_meta_key` varchar(255) NOT NULL,
`term_meta_value` longtext,
`term_id` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `dc_user`;
CREATE TABLE `dc_user` (
`user_id` bigint(20) NOT NULL,
`user_email` varchar(150) DEFAULT NULL,
`user_name` varchar(150) NOT NULL,
`user_nice_name` varchar(255) DEFAULT NULL,
`user_mobile` varchar(20) DEFAULT NULL,
`user_pass` varchar(32) NOT NULL,
`user_status` varchar(60) NOT NULL DEFAULT 'normal',
`user_create_time` int(11) DEFAULT '0',
`user_update_time` int(11) DEFAULT '0',
`user_create_ip` varchar(32) DEFAULT NULL,
`user_update_ip` varchar(32) DEFAULT NULL,
`user_slug` varchar(255) DEFAULT NULL,
`user_views` bigint(20) DEFAULT '0',
`user_hits` bigint(20) DEFAULT '0',
`user_token` varchar(255) DEFAULT NULL,
`user_module` varchar(100) DEFAULT 'common',
`user_controll` varchar(100) DEFAULT NULL,
`user_action` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `dc_user` (`user_id`, `user_email`, `user_name`, `user_nice_name`, `user_mobile`, `user_pass`, `user_status`, `user_create_time`, `user_update_time`, `user_create_ip`, `user_update_ip`, `user_slug`, `user_views`, `user_hits`, `user_token`, `user_module`, `user_controll`, `user_action`) VALUES
(1, 'admin@daicuo.org', 'admin', '', '13800138000', '7fef6171469e80d32c0559f88b377245', 'normal', 0, 1599138991, '0', '127.0.0.1', '', 0, 0, NULL, 'common', '', '');
DROP TABLE IF EXISTS `dc_user_meta`;
CREATE TABLE `dc_user_meta` (
`user_meta_id` bigint(20) NOT NULL,
`user_meta_key` varchar(255) NOT NULL,
`user_meta_value` longtext,
`user_id` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `dc_user_meta` (`user_meta_id`, `user_meta_key`, `user_meta_value`, `user_id`) VALUES
(20, 'user_capabilities', 'a:2:{i:0;s:5:\"guest\";i:1;s:13:\"administrator\";}', 1);
ALTER TABLE `dc_info`
ADD PRIMARY KEY (`info_id`),
ADD KEY `info_type` (`info_type`),
ADD KEY `info_module` (`info_module`),
ADD KEY `info_controll` (`info_controll`),
ADD KEY `info_action` (`info_action`),
ADD KEY `info_slug` (`info_slug`),
ADD KEY `info_status` (`info_status`),
ADD KEY `info_parent` (`info_parent`),
ADD KEY `info_user_id` (`info_user_id`);
ALTER TABLE `dc_info_meta`
ADD PRIMARY KEY (`info_meta_id`),
ADD KEY `info_id_meta` (`info_id`),
ADD KEY `info_meta_key` (`info_meta_key`);
ALTER TABLE `dc_log`
ADD PRIMARY KEY (`log_id`),
ADD KEY `log_user_id` (`log_user_id`),
ADD KEY `log_info_id` (`log_info_id`),
ADD KEY `log_status` (`log_status`),
ADD KEY `log_module` (`log_module`),
ADD KEY `log_controll` (`log_controll`),
ADD KEY `log_action` (`log_action`),
ADD KEY `log_type` (`log_type`);
ALTER TABLE `dc_op`
ADD PRIMARY KEY (`op_id`),
ADD KEY `op_module` (`op_module`),
ADD KEY `op_status` (`op_status`);
ALTER TABLE `dc_term`
ADD PRIMARY KEY (`term_id`),
ADD KEY `term_name` (`term_name`),
ADD KEY `term_slug` (`term_slug`),
ADD KEY `term_status` (`term_status`),
ADD KEY `term_type` (`term_type`),
ADD KEY `term_parent` (`term_parent`),
ADD KEY `term_module` (`term_module`),
ADD KEY `term_controll` (`term_controll`),
ADD KEY `term_action` (`term_action`);
ALTER TABLE `dc_term_map`
ADD KEY `map_term_id` (`term_id`),
ADD KEY `map_info_id` (`detail_id`);
ALTER TABLE `dc_term_meta`
ADD PRIMARY KEY (`term_meta_id`),
ADD KEY `term_id` (`term_id`),
ADD KEY `term_meta_key` (`term_meta_key`);
ALTER TABLE `dc_user`
ADD PRIMARY KEY (`user_id`),
ADD KEY `user_name` (`user_name`),
ADD KEY `user_email` (`user_email`),
ADD KEY `user_status` (`user_status`);
ALTER TABLE `dc_user_meta`
ADD PRIMARY KEY (`user_meta_id`),
ADD KEY `user_id` (`user_id`),
ADD KEY `user_meta_key` (`user_meta_key`);
ALTER TABLE `dc_info`
MODIFY `info_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_info_meta`
MODIFY `info_meta_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_log`
MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_op`
MODIFY `op_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_term`
MODIFY `term_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_term_meta`
MODIFY `term_meta_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_user`
MODIFY `user_id` bigint(20) NOT NULL AUTO_INCREMENT;
ALTER TABLE `dc_user_meta`
MODIFY `user_meta_id` bigint(20) NOT NULL AUTO_INCREMENT;
database.php 配置如下
return [
'type' => 'mysql',
'charset' => 'utf8',
'hostname' => '127.0.0.1',//服务器地址
'database' => 'demo',//数据库名
'username' => 'root',//帐号
'password' => 'root',//密码
'hostport' => '3306',//端口
'prefix' => 'dc_',//前缀
'resultset_type' => 'collection',
];