install/mysql.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- Adminer 4.6.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `sl_admin`;
CREATE TABLE `sl_admin` (
  `A_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `A_login` text,
  `A_pwd` text,
  `A_part` text,
  `A_textauth` text,
  `A_newsauth` text,
  `A_productauth` text,
  `A_formauth` text,
  `A_bbsauth` text,
  `A_type` int(11) DEFAULT '0',
  `A_del` int(11) DEFAULT '0',
  `A_email` varchar(100) DEFAULT '',
  PRIMARY KEY (`A_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_admin` (`A_id`, `A_login`, `A_pwd`, `A_part`, `A_textauth`, `A_newsauth`, `A_productauth`, `A_formauth`, `A_bbsauth`, `A_type`, `A_del`, `A_email`) VALUES
(12,	'admin',	'7fef6171469e80d32c0559f88b377245',	'1|1|1|1|1|1|1|1|1|1|1|1|1|1|1',	'all',	'all',	'all',	'all',	'all',	1,	0,	'');

DROP TABLE IF EXISTS `sl_bbs`;
CREATE TABLE `sl_bbs` (
  `B_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `B_sort` int(11) DEFAULT '0',
  `B_title` text,
  `B_content` text,
  `B_time` datetime DEFAULT NULL,
  `B_mid` int(11) DEFAULT '0',
  `B_view` int(11) DEFAULT '0',
  `B_sub` int(11) DEFAULT '0',
  `B_sh` int(11) DEFAULT '0',
  `B_del` int(11) DEFAULT '0',
  PRIMARY KEY (`B_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_bbs` (`B_id`, `B_sort`, `B_title`, `B_content`, `B_time`, `B_mid`, `B_view`, `B_sub`, `B_sh`, `B_del`) VALUES
(1,	1,	'第一篇帖子',	'第一篇帖子内容',	'2018-01-01 00:00:00',	7,	0,	0,	0,	0);

DROP TABLE IF EXISTS `sl_brand`;
CREATE TABLE `sl_brand` (
  `B_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `B_title` text,
  `B_content` text,
  `B_pic` text,
  PRIMARY KEY (`B_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `sl_brand` (`B_id`, `B_title`, `B_content`, `B_pic`) VALUES
(1,	'默认品牌',	'介绍文字',	'');

DROP TABLE IF EXISTS `sl_bsort`;
CREATE TABLE `sl_bsort` (
  `S_id` int(10) unsigned NOT NULL AUTO_INCREMENT,