📄 db_zh_cn_utf8.sql
字号:
poptop int(10) default NULL,
poptoolbar int(1) default NULL,
popmenubar int(1) default NULL,
popstatus int(1) default NULL,
poplocation int(1) default NULL,
popscrollbars varchar(50) default NULL,
popresizable int(1) default NULL,
menuid int(12) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_advs_pop`
#
# --------------------------------------------------------
#
# 数据表的结构 `sho_advs_right`
#
CREATE TABLE sho_advs_right (
id int(4) NOT NULL auto_increment,
menuid int(12) NOT NULL default '0',
title char(200) default NULL,
width int(10) default NULL,
height int(10) default NULL,
`type` char(20) default NULL,
src char(100) default NULL,
url char(200) default NULL,
target char(100) default NULL,
border int(2) default NULL,
hidden int(1) default NULL,
toppadding int(5) default NULL,
sidepadding int(5) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_advs_right`
#
# --------------------------------------------------------
#
# 数据表的结构 `sho_coltype`
#
CREATE TABLE sho_coltype (
id int(12) NOT NULL auto_increment,
coltype varchar(30) NOT NULL default '',
colname varchar(50) NOT NULL default '',
ifmul int(1) NOT NULL default '0',
moveable int(1) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_coltype`
#
INSERT INTO sho_coltype VALUES (1, 'index', '网站首页', 0, 0);
INSERT INTO sho_coltype VALUES (2, 'member', '会员中心', 0, 0);
INSERT INTO sho_coltype VALUES (3, 'url', '自定链接', 1, 1);
INSERT INTO sho_coltype VALUES (4, 'page', '单页频道', 1, 1);
INSERT INTO sho_coltype VALUES (5, 'news', '文章频道', 1, 1);
INSERT INTO sho_coltype VALUES (6, 'cp', '图文频道', 1, 1);
INSERT INTO sho_coltype VALUES (7, 'down', '下载频道', 1, 1);
INSERT INTO sho_coltype VALUES (8, 'form', '自定表单', 1, 1);
INSERT INTO sho_coltype VALUES (9, 'comment', '会员社区', 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `sho_comment`
#
CREATE TABLE sho_comment (
id int(20) NOT NULL auto_increment,
pid int(20) default NULL,
menuid int(20) default NULL,
coltype varchar(30) default NULL,
rid int(20) default NULL,
name varchar(100) default NULL,
title varchar(200) default NULL,
body text,
star int(1) default NULL,
uptime int(11) default NULL,
ip varchar(16) default NULL,
fabu int(1) default NULL,
tuijian int(1) default NULL,
face varchar(10) default NULL,
cl int(10) default NULL,
lastname varchar(50) NOT NULL default '',
picsrc varchar(150) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_comment`
#
# --------------------------------------------------------
#
# 数据表的结构 `sho_comment_cat`
#
CREATE TABLE sho_comment_cat (
catid int(12) NOT NULL auto_increment,
cat varchar(50) default NULL,
coltype varchar(30) default NULL,
xuhao int(4) default NULL,
moveable int(1) default NULL,
PRIMARY KEY (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_comment_cat`
#
INSERT INTO sho_comment_cat VALUES (1, '文章评论', 'news', 1, 0);
INSERT INTO sho_comment_cat VALUES (2, '图片评论', 'cp', 2, 0);
INSERT INTO sho_comment_cat VALUES (3, '下载评论', 'down', 3, 0);
# --------------------------------------------------------
#
# 数据表的结构 `sho_config`
#
CREATE TABLE sho_config (
xuhao int(3) NOT NULL default '0',
vname varchar(50) NOT NULL default '',
coltype varchar(30) NOT NULL default 'input',
colwidth varchar(3) NOT NULL default '30',
variable varchar(32) NOT NULL default '',
`value` text NOT NULL,
intro text NOT NULL,
PRIMARY KEY (variable)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_config`
#
INSERT INTO sho_config VALUES (1, '网站名称', 'input', '30', 'SiteName', '学校网站系统', '用于在网页标题、导航栏处显示');
INSERT INTO sho_config VALUES (2, '网站网址', 'input', '30', 'SiteHttp', 'http://www.abc.com/', '网站的实际访问网址,末尾加“/”');
INSERT INTO sho_config VALUES (3, '服务邮箱', 'input', '30', 'SiteEmail', 'service@mydomain.com', '在发送系统邮件时作为发件人邮件');
INSERT INTO sho_config VALUES (4, '邮件转发方式', 'ownersys', '1', 'ownersys', '0', 'LINUX/UNIX服务器一般可使用内置邮件系统转发邮件；WINDOWS服务器建议使用外部SMTP邮箱转发，并设置以下SMTP邮箱参数');
INSERT INTO sho_config VALUES (6, 'SMTP服务器', 'input', '30', 'owner_m_smtp', 'mail.mydomain.com', '');
INSERT INTO sho_config VALUES (7, 'SMTP邮箱用户', 'input', '30', 'owner_m_user', 'alex@mydomain.com', '');
INSERT INTO sho_config VALUES (8, 'SMTP邮箱密码', 'input', '30', 'owner_m_pass', '123456', '');
INSERT INTO sho_config VALUES (5, 'SMTP转发邮箱', 'input', '30', 'owner_m_mail', 'alex@mydomain.com', '');
INSERT INTO sho_config VALUES (9, 'SMTP身份验证', 'YN', '10', 'owner_m_check', '1', '');
INSERT INTO sho_config VALUES (10, '是否生成并使用静态HTML网页', 'YN', '10', 'CatchOpen', '0', '');
INSERT INTO sho_config VALUES (11, 'HTML静态网页更新时间(秒)', 'input', '8', 'CatchTime', '7200', '超过此时间访问静态页面时自动跳转到动态页面，并重新生成静态页面');
INSERT INTO sho_config VALUES (12, 'INDEX.HTML优先', 'YN', '10', 'IndexOrder', '1', '当主机的index.html优先于index.php时，栏目链接直接指向目录访问静态网页，使网址较简洁，PHP虚拟主机大多支持此设置');
INSERT INTO sho_config VALUES (21, 'DISCUZ论坛URL', 'input', '30', 'DiscuzUrl', 'http://', '请输入您的DISCUZ论坛网址,如:http://www.abc.com/bbs');
INSERT INTO sho_config VALUES (22, 'DISCUZ论坛连接私钥', 'input', '30', 'DiscuzCode', '', 'Discuz论坛后台设置的接口私钥与本处设置务必一致');
INSERT INTO sho_config VALUES (20, 'DISCUZ论坛会员接口是否启用', 'YN', '30', 'DiscuzOpen', '0', '启用Discuz会员接口时,会员注册和登录时将向论坛发送注册和登录信息.请在Discuz论坛后台通行证设置中进行相应接口设置');
INSERT INTO sho_config VALUES (30, '前台图片上传尺寸限制(Byte)', 'input', '30', 'PicSizeLimit', '204800', '前台网站上传图片时单个图片尺寸的限制');
# --------------------------------------------------------
#
# 数据表的结构 `sho_cp_cat`
#
CREATE TABLE sho_cp_cat (
catid int(12) NOT NULL auto_increment,
pid int(12) default NULL,
menuid int(10) NOT NULL default '3',
cat char(100) default NULL,
xuhao int(12) default NULL,
catpath char(255) default NULL,
nums int(20) default NULL,
secure int(1) NOT NULL default '0',
tj int(1) NOT NULL default '0',
PRIMARY KEY (catid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_cp_cat`
#
INSERT INTO sho_cp_cat VALUES (1, 0, 82, '校园风光', 1, '0001:', 6, 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `sho_cp_con`
#
CREATE TABLE sho_cp_con (
id int(12) NOT NULL auto_increment,
menuid int(10) NOT NULL default '3',
catid int(12) default NULL,
catpath varchar(255) default NULL,
title varchar(255) default NULL,
memo text NOT NULL,
body text,
dtime int(11) default '0',
xuhao int(5) default '0',
cl int(20) default NULL,
tj int(1) default NULL,
iffb int(1) default '0',
ifbold int(1) default '0',
ifred int(1) default '0',
`type` varchar(30) NOT NULL default '',
src varchar(150) NOT NULL default '',
uptime int(11) default '0',
author varchar(100) default NULL,
source varchar(100) default NULL,
memberid varchar(100) default NULL,
proj varchar(255) NOT NULL default '',
secure int(11) NOT NULL default '0',
prop1 varchar(255) NOT NULL default '',
prop2 varchar(255) NOT NULL default '',
prop3 varchar(255) NOT NULL default '',
prop4 varchar(255) NOT NULL default '',
prop5 varchar(255) NOT NULL default '',
prop6 varchar(255) NOT NULL default '',
prop7 varchar(255) NOT NULL default '',
prop8 varchar(255) NOT NULL default '',
prop9 varchar(255) NOT NULL default '',
prop10 varchar(255) NOT NULL default '',
prop11 varchar(255) NOT NULL default '',
prop12 varchar(255) NOT NULL default '',
prop13 varchar(255) NOT NULL default '',
prop14 varchar(255) NOT NULL default '',
prop15 varchar(255) NOT NULL default '',
prop16 varchar(255) NOT NULL default '',
prop17 varchar(255) NOT NULL default '',
prop18 varchar(255) NOT NULL default '',
prop19 varchar(255) NOT NULL default '',
prop20 varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_cp_con`
#
INSERT INTO sho_cp_con VALUES (1, 82, 1, '0001:', '主教学楼', '主教学楼', '', 1164559497, 1, 4, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165094410.jpg', 1165094410, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_cp_con VALUES (2, 82, 1, '0001:', '体育馆', '体育馆', '', 1164559737, 1, 5, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165094459.jpg', 1165094459, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_cp_con VALUES (3, 82, 1, '0001:', '报告厅', '报告厅', '', 1164560078, 1, 7, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165094402.jpg', 1165094402, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_cp_con VALUES (4, 82, 1, '0001:', '图书馆', '', '', 1164560096, 1, 6, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165094454.jpg', 1165094454, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_cp_con VALUES (5, 82, 1, '0001:', '学生宿舍', '学生宿舍', '', 1164560223, 1, 6, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165094394.jpg', 1165094394, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO sho_cp_con VALUES (6, 82, 1, '0001:', '艺术楼', '艺术楼', '', 1164560329, 1, 15, 0, 1, 0, 0, 'gif', 'xyfm/html/images/1165094448.jpg', 1165094448, '', '', '0', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
# --------------------------------------------------------
#
# 数据表的结构 `sho_default_rights`
#
CREATE TABLE sho_default_rights (
id int(12) NOT NULL auto_increment,
membertypeid int(50) default NULL,
secureid int(50) default NULL,
securetype char(100) default NULL,
secureset int(100) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 导出下面的数据库内容 `sho_default_rights`
#
INSERT INTO sho_default_rights VALUES (112, 11, 7, 'func', 0);
INSERT INTO sho_default_rights VALUES (111, 11, 4, 'con', 0);
INSERT INTO sho_default_rights VALUES (110, 11, 3, 'menu', 0);
INSERT INTO sho_default_rights VALUES (109, 11, 2, 'func', 0);
INSERT INTO sho_default_rights VALUES (108, 11, 6, 'func', 0);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -