📄 db_zh_cn_utf8.mysql3x.sql
字号:
pid int(12) default NULL,
cat char(100) default NULL,
xuhao int(4) default NULL,
catpath char(255) default NULL,
nums int(20) default NULL,
PRIMARY KEY (catid)
);
#
# 导出下面的数据库内容 `law_member_cat`
#
# --------------------------------------------------------
#
# 数据表的结构 `law_member_func`
#
CREATE TABLE law_member_func (
id int(10) NOT NULL auto_increment,
pid int(10) default NULL,
menu char(50) default NULL,
link char(100) default NULL,
xuhao int(10) default NULL,
used int(1) default NULL,
intro char(255) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_func`
#
INSERT INTO law_member_func VALUES (13, 0, '会员设置', '', 1, 1, NULL);
INSERT INTO law_member_func VALUES (1, 13, '修改资料', 'member_modify.php', 6, 1, '');
INSERT INTO law_member_func VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO law_member_func VALUES (14, 0, '退出登录', 'logout.php', 4, 1, NULL);
INSERT INTO law_member_func VALUES (16, 15, '文章发布', 'member_fabu.php', 1, 1, '');
INSERT INTO law_member_func VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------
#
# 数据表的结构 `law_member_func_10`
#
CREATE TABLE law_member_func_10 (
id int(10) NOT NULL auto_increment,
pid int(10) default NULL,
menu char(50) default NULL,
link char(100) default NULL,
xuhao int(10) default NULL,
used int(1) default NULL,
intro char(255) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_func_10`
#
INSERT INTO law_member_func_10 VALUES (13, 0, '会员设置', '', 1, 1, NULL);
INSERT INTO law_member_func_10 VALUES (1, 13, '修改资料', 'member_modify.php', 6, 1, '');
INSERT INTO law_member_func_10 VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO law_member_func_10 VALUES (14, 0, '退出登录', 'logout.php', 4, 1, NULL);
INSERT INTO law_member_func_10 VALUES (16, 15, '文章发布', 'member_fabu.php', 1, 1, '');
INSERT INTO law_member_func_10 VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------
#
# 数据表的结构 `law_member_notice`
#
CREATE TABLE law_member_notice (
id int(12) NOT NULL auto_increment,
membertypeid int(20) default NULL,
title varchar(255) default NULL,
body text,
dtime int(11) default NULL,
xuhao int(5) default NULL,
cl int(20) default NULL,
ifnew int(1) default NULL,
ifred int(1) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_notice`
#
# --------------------------------------------------------
#
# 数据表的结构 `law_member_nums`
#
CREATE TABLE law_member_nums (
id int(12) NOT NULL auto_increment,
memberid int(50) default NULL,
secureid int(50) default NULL,
nums int(20) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_nums`
#
# --------------------------------------------------------
#
# 数据表的结构 `law_member_regform`
#
CREATE TABLE law_member_regform (
id int(12) NOT NULL auto_increment,
formname varchar(200) default NULL,
formcolname varchar(200) default NULL,
mustfill int(1) default NULL,
canrepeat int(1) default NULL,
moveable int(1) default NULL,
intro text,
used int(1) default NULL,
xuhao int(20) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_regform`
#
INSERT INTO law_member_regform VALUES (1, '会员名称', 'user', 1, 0, 0, '[5-20位英文或数字]', 1, NULL);
INSERT INTO law_member_regform VALUES (2, '登录密码', 'password', 1, 1, 0, '[5-20位英文或数字]', 1, NULL);
INSERT INTO law_member_regform VALUES (3, '重复密码', 'repass', 1, 1, 0, '[5-20位英文或数字]', 1, NULL);
INSERT INTO law_member_regform VALUES (6, '企业名称', 'company', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (7, '您的姓名', 'name', 1, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (8, '性 别', 'sex', 1, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (10, '所在地区', 'zoneid', 1, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (11, '所属行业', 'catid', 1, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (13, '电话号码', 'tel', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (14, '手机号码', 'mov', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (15, '传真号码', 'fax', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (16, '邮政编码', 'postcode', 0, 1, 1, '', 1, NULL);
INSERT INTO law_member_regform VALUES (17, '电子邮件', 'email', 1, 1, 0, '[请输入正确的电子邮件]', 1, NULL);
INSERT INTO law_member_regform VALUES (18, '网站网址', 'url', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (19, '证件类型', 'passtype', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (20, '证件号码', 'passcode', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (21, 'QQ号码', 'qq', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (22, 'MSN号码', 'msn', 0, 1, 1, '', 0, NULL);
INSERT INTO law_member_regform VALUES (24, '备注留言', 'bz', 0, 1, 1, '', 0, NULL);
# --------------------------------------------------------
#
# 数据表的结构 `law_member_regform_10`
#
CREATE TABLE law_member_regform_10 (
id int(12) NOT NULL auto_increment,
formname varchar(200) default NULL,
formcolname varchar(200) default NULL,
mustfill int(1) default NULL,
canrepeat int(1) default NULL,
moveable int(1) default NULL,
intro text,
used int(1) default NULL,
xuhao int(20) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_regform_10`
#
INSERT INTO law_member_regform_10 VALUES (1, '会 员 名', 'user', 1, 0, 0, '[5-20位英文或数字]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (2, '登录密码', 'password', 1, 1, 0, '[5-20位英文或数字]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (3, '重复密码', 'repass', 1, 1, 0, '[5-20位英文或数字]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (6, '企业名称', 'company', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (7, '会员姓名', 'name', 1, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (8, '您的称呼', 'sex', 1, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (10, '所在地区', 'zoneid', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (11, '所属行业', 'catid', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (13, '电话号码', 'tel', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (14, '手机号码', 'mov', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (15, '传真号码', 'fax', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (16, '邮政编码', 'postcode', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (17, '电子邮件', 'email', 1, 1, 0, '[请输入正确的电子邮件]', 1, 0);
INSERT INTO law_member_regform_10 VALUES (18, '网站网址', 'url', 0, 1, 1, '', 1, 0);
INSERT INTO law_member_regform_10 VALUES (19, '证件类型', 'passtype', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (20, '证件号码', 'passcode', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (21, 'QQ号码', 'qq', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (22, 'MSN号码', 'msn', 0, 1, 1, '', 0, 0);
INSERT INTO law_member_regform_10 VALUES (24, '备注留言', 'bz', 0, 1, 1, '', 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `law_member_rights`
#
CREATE TABLE law_member_rights (
id int(12) NOT NULL auto_increment,
memberid int(50) default NULL,
secureid int(50) default NULL,
securetype char(100) default NULL,
secureset int(20) default NULL,
PRIMARY KEY (id)
);
#
# 导出下面的数据库内容 `law_member_rights`
#
INSERT INTO law_member_rights VALUES (10, 1, 7, 'func', 0);
INSERT INTO law_member_rights VALUES (9, 1, 4, 'con', 0);
INSERT INTO law_member_rights VALUES (8, 1, 3, 'menu', 0);
INSERT INTO law_member_rights VALUES (7, 1, 2, 'func', 0);
INSERT INTO law_member_rights VALUES (6, 1, 6, 'func', 0);
INSERT INTO law_member_rights VALUES (11, 1, 8, 'func', 0);
INSERT INTO law_member_rights VALUES (12, 1, 9, 'func', 0);
INSERT INTO law_member_rights VALUES (13, 1, 10, 'func', 0);
# --------------------------------------------------------
#
# 数据表的结构 `law_member_type`
#
CREATE TABLE law_member_type (
membertypeid int(6) NOT NULL auto_increment,
membertype varchar(100) default NULL,
memberprop int(1) NOT NULL default '0',
ifcanreg int(1) default NULL,
ifchecked int(1) default NULL,
regxy text,
regmail text,
expday int(8) default NULL,
startcent int(20) default NULL,
endcent int(20) default NULL,
PRIMARY KEY (membertypeid)
);
#
# 导出下面的数据库内容 `law_member_type`
#
INSERT INTO law_member_type VALUES (10, '普通会员', 0, 1, 1, '', '{#name#}{#sex#},您好!\r\n\r\n感谢您在本站注册!\r\n\r\n会员名: {#user#}\r\n密码: {#password#}\r\n\r\n网址:http://', 0, 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `law_member_zone`
#
CREATE TABLE law_member_zone (
catid int(12) NOT NULL auto_increment,
pid int(12) default NULL,
cat char(50) default NULL,
xuhao int(4) default NULL,
catpath char(255) default NULL,
PRIMARY KEY (catid)
);
#
# 导出下面的数据库内容 `law_member_zone`
#
# --------------------------------------------------------
#
# 数据表的结构 `law_menu`
#
CREATE TABLE law_menu (
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -