?? db_zh_cn_utf8.sql
字號(hào):
exptime int(11) default NULL,
account decimal(12,2) default NULL,
paytotal decimal(12,2) default NULL,
buytotal decimal(12,2) default NULL,
cent decimal(12,2) default NULL,
ip varchar(26) default NULL,
logincount int(20) default NULL,
logintime int(11) default NULL,
loginip varchar(50) default NULL,
PRIMARY KEY (memberid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member`
#
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_cat`
#
CREATE TABLE sho_member_cat (
catid int(12) NOT NULL auto_increment,
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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_cat`
#
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_func`
#
CREATE TABLE sho_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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_func`
#
INSERT INTO sho_member_func VALUES (13, 0, '用戶(hù)設(shè)置', '', 1, 1, NULL);
INSERT INTO sho_member_func VALUES (1, 13, '修改資料', 'member_modify.php', 6, 1, '');
INSERT INTO sho_member_func VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO sho_member_func VALUES (14, 0, '退出登錄', 'logout.php', 4, 1, NULL);
INSERT INTO sho_member_func VALUES (16, 15, '文章發(fā)布', 'member_fabu.php', 1, 1, '');
INSERT INTO sho_member_func VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_func_11`
#
CREATE TABLE sho_member_func_11 (
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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_func_11`
#
INSERT INTO sho_member_func_11 VALUES (13, 0, '用戶(hù)設(shè)置', '', 1, 1, NULL);
INSERT INTO sho_member_func_11 VALUES (1, 13, '修改資料', 'member_modify.php', 6, 1, '');
INSERT INTO sho_member_func_11 VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO sho_member_func_11 VALUES (14, 0, '退出登錄', 'logout.php', 4, 1, NULL);
INSERT INTO sho_member_func_11 VALUES (16, 15, '文章發(fā)布', 'member_fabu.php', 1, 1, '');
INSERT INTO sho_member_func_11 VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_func_12`
#
CREATE TABLE sho_member_func_12 (
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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_func_12`
#
INSERT INTO sho_member_func_12 VALUES (13, 0, '用戶(hù)設(shè)置', '', 1, 1, NULL);
INSERT INTO sho_member_func_12 VALUES (1, 13, '修改資料', 'member_modify.php', 6, 1, '');
INSERT INTO sho_member_func_12 VALUES (15, 0, '文章管理', '', 1, 1, '');
INSERT INTO sho_member_func_12 VALUES (14, 0, '退出登錄', 'logout.php', 4, 1, NULL);
INSERT INTO sho_member_func_12 VALUES (16, 15, '文章發(fā)布', 'member_fabu.php', 1, 1, '');
INSERT INTO sho_member_func_12 VALUES (17, 15, '文章管理', 'member_guanli.php', 1, 1, '');
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_notice`
#
CREATE TABLE sho_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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_notice`
#
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_nums`
#
CREATE TABLE sho_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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_nums`
#
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_regform`
#
CREATE TABLE sho_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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_regform`
#
INSERT INTO sho_member_regform VALUES (1, '用 戶(hù) 名', 'user', 1, 0, 0, '[5-20位英文或數(shù)字]', 1, NULL);
INSERT INTO sho_member_regform VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, NULL);
INSERT INTO sho_member_regform VALUES (3, '重復(fù)密碼', 'repass', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, NULL);
INSERT INTO sho_member_regform VALUES (6, '單位名稱(chēng)', 'company', 0, 1, 1, '', 1, NULL);
INSERT INTO sho_member_regform VALUES (7, '真實(shí)姓名', 'name', 1, 1, 1, '', 1, NULL);
INSERT INTO sho_member_regform VALUES (8, '性 別', 'sex', 1, 1, 1, '', 1, NULL);
INSERT INTO sho_member_regform VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (10, '所在地區(qū)', 'zoneid', 1, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (11, '所屬行業(yè)', 'catid', 1, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (13, '電話號(hào)碼', 'tel', 0, 1, 1, '', 1, NULL);
INSERT INTO sho_member_regform VALUES (14, '手機(jī)號(hào)碼', 'mov', 0, 1, 1, '', 1, NULL);
INSERT INTO sho_member_regform VALUES (15, '傳真號(hào)碼', 'fax', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (16, '郵政編碼', 'postcode', 0, 1, 1, '', 1, NULL);
INSERT INTO sho_member_regform VALUES (17, '電子郵件', 'email', 1, 1, 0, '[請(qǐng)輸入正確的電子郵件]', 1, NULL);
INSERT INTO sho_member_regform VALUES (18, '網(wǎng)站網(wǎng)址', 'url', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (19, '證件類(lèi)型', 'passtype', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (20, '證件號(hào)碼', 'passcode', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (21, 'QQ號(hào)碼', 'qq', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (22, 'MSN號(hào)碼', 'msn', 0, 1, 1, '', 0, NULL);
INSERT INTO sho_member_regform VALUES (24, '備注留言', 'bz', 0, 1, 1, '', 0, NULL);
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_regform_11`
#
CREATE TABLE sho_member_regform_11 (
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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_regform_11`
#
INSERT INTO sho_member_regform_11 VALUES (1, '用 戶(hù) 名', 'user', 1, 0, 0, '[5-20位英文或數(shù)字]', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (3, '重復(fù)密碼', 'repass', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (6, '所在班級(jí)', 'company', 0, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (7, '學(xué)生姓名', 'name', 1, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (8, '性 別', 'sex', 1, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (10, '所在地區(qū)', 'zoneid', 1, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (11, '所屬行業(yè)', 'catid', 1, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (13, '電話號(hào)碼', 'tel', 0, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (14, '手機(jī)號(hào)碼', 'mov', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (15, '傳真號(hào)碼', 'fax', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (16, '郵政編碼', 'postcode', 0, 1, 1, '', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (17, '電子郵件', 'email', 1, 1, 0, '[請(qǐng)輸入正確的電子郵件]', 1, 0);
INSERT INTO sho_member_regform_11 VALUES (18, '網(wǎng)站網(wǎng)址', 'url', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (19, '證件類(lèi)型', 'passtype', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (20, '證件號(hào)碼', 'passcode', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (21, 'QQ號(hào)碼', 'qq', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (22, 'MSN號(hào)碼', 'msn', 0, 1, 1, '', 0, 0);
INSERT INTO sho_member_regform_11 VALUES (24, '備注留言', 'bz', 0, 1, 1, '', 0, 0);
# --------------------------------------------------------
#
# 數(shù)據(jù)表的結(jié)構(gòu) `sho_member_regform_12`
#
CREATE TABLE sho_member_regform_12 (
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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導(dǎo)出下面的數(shù)據(jù)庫(kù)內(nèi)容 `sho_member_regform_12`
#
INSERT INTO sho_member_regform_12 VALUES (1, '用 戶(hù) 名', 'user', 1, 0, 0, '[5-20位英文或數(shù)字]', 1, 0);
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -