📄 db_zh_tw_utf8.sql
字号:
INSERT INTO mpshop_config VALUES (51, '會員積分名稱', 'input', '30', 'CentName', '會員積分', '自定義顯示積分的名稱');
INSERT INTO mpshop_config VALUES (53, '是否按積分自動轉換會員類型', 'YN', '30', 'CentUpdate', '0', '如果按積分自動轉換會員類型,當達到設定的積分範圍,再次登錄時,將自動轉變會員類型.自動轉換會員類型的積分範圍可在會員類型設置->參數設置中修改');
INSERT INTO mpshop_config VALUES (62, '默認計量單位', 'input', '30', 'ShopDw', '束', '在添加一種類型的商品前設定默認計量單位,可在輸入時不需重複填寫');
INSERT INTO mpshop_config VALUES (67, '是否人工確認訂單', 'YN', '30', 'OrderNeedCheck', '0', '需要人工確認訂單時,訂單提交後處於未確認狀態,經管理員確認後才能付款,適於需要協商調整價格的情況;不需人工確認訂單時,訂單提交後直接進入未完成訂單,可直接付款');
INSERT INTO mpshop_config VALUES (52, '商品積分方式', 'CentMethod', '30', 'CentMethod', '1', '設置按商品指定積分時,不論以什麼價格購買商品均按商品積分值計算積分;設置按購買價格積分時,在商品輸入時填寫的積分值無效');
INSERT INTO mpshop_config VALUES (50, '是否啟用會員積分', 'YN', '30', 'UseCent', '1', '積分功能的總開關,當設置啟用積分時,以下積分設置才起作用');
INSERT INTO mpshop_config VALUES (56, '商品縮圖生成', 'YN', '30', 'ImgStMake', '1', '在商品詳圖片上傳時,自動生成縮圖,需PHP的GD庫支援.但如果上傳了縮圖或填寫了縮圖網址,就不再生成縮圖');
INSERT INTO mpshop_config VALUES (57, '商品縮圖生成參考尺寸', 'input', '30', 'ImgStSize', '100', '以此數值作為參考尺寸,按比例智能確定縮圖尺寸');
INSERT INTO mpshop_config VALUES (55, '商品評分星級設置', 'input', '30', 'StarMethod', '1,10,30,50,100', '將商品評分轉換為星星數量時,1-5顆星分別對應的分數,以逗號分隔');
INSERT INTO mpshop_config VALUES (93, '前臺圖片上傳尺寸限制(Byte)', 'input', '30', 'PicSizeLimit', '102400', '前臺網站上傳圖片時單個圖片尺寸的限制');
INSERT INTO mpshop_config VALUES (65, '是否啟用非會員訂購', 'YN', '30', 'NoMemberOrder', '1', '啟用非會員訂購時,允許未登錄者在訂單填寫時填寫簡單會員資料,同時註冊為會員;不啟用非會員訂購時,未登錄者直接跳轉到登錄介面');
INSERT INTO mpshop_config VALUES (66, '非會員訂購自動註冊會員類型', 'NoMemberType', '30', 'NoMemberType', '10', '在啟用非會員訂購時,訂購同時填寫會員資料自動註冊的會員類型');
INSERT INTO mpshop_config VALUES (68, '後臺是否允許欠費扣款支付訂單', 'YN', '30', 'OrderPayFu', '0', '後臺從會員帳戶扣款支付訂單時,是否允許會員預付款帳戶出現欠費');
INSERT INTO mpshop_config VALUES (69, '是否允許未付款發貨和已發貨退款', 'YN', '30', 'OrderYunNoPay', '0', '當訂單處於未付款狀態時,是否允許進行發貨確認;當訂單全部或部分發貨時是否允許退款操作');
INSERT INTO mpshop_config VALUES (58, '商品搜索熱門關鍵字', 'input', '30', 'GoodsHotWords', '生日送花,玫瑰,水晶禮品,手鏈,蛋稿', '顯示在商品搜索表單的熱門關鍵字,以逗號分隔');
INSERT INTO mpshop_config VALUES (72, '推廣鏈盟提成比例(%)', 'input', '30', 'LmPercent', '0.5', '來自推廣鏈盟成員網站的訪問者在訂購付款後,鏈盟成員獲得提成的比例.按訂單商品總金額的百分比計算');
INSERT INTO mpshop_config VALUES (70, '賣方訂單通知', 'YN', '30', 'OrderSellerNotice', '0', '在顧客提交訂單和訂單支付時,發送郵件通知商家.適合不能經常進入後臺查詢訂單的商家;如果訂單量較多,有專人值守的商家,不推薦啟用此功能,因郵件發送過程可能使顧客提交訂單的速度受到影響');
INSERT INTO mpshop_config VALUES (71, '買方訂單通知', 'YN', '30', 'OrderBuyerNotice', '0', '管理員審核確認訂單時,訂單發貨完成時,發郵件通知顧客');
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_cp_cat`
#
CREATE TABLE mpshop_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;
#
# 導出下面的資料庫內容 `mpshop_cp_cat`
#
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_cp_con`
#
CREATE TABLE mpshop_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;
#
# 導出下面的資料庫內容 `mpshop_cp_con`
#
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_default_rights`
#
CREATE TABLE mpshop_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;
#
# 導出下面的資料庫內容 `mpshop_default_rights`
#
INSERT INTO mpshop_default_rights VALUES (144, 10, 30, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (143, 10, 7, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (142, 10, 4, 'con', 0);
INSERT INTO mpshop_default_rights VALUES (141, 10, 3, 'menu', 0);
INSERT INTO mpshop_default_rights VALUES (140, 10, 2, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (139, 10, 6, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (145, 10, 11, 'price', 1);
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_down_cat`
#
CREATE TABLE mpshop_down_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;
#
# 導出下面的資料庫內容 `mpshop_down_cat`
#
INSERT INTO mpshop_down_cat VALUES (1, 0, 5, '測試下載', 1, '0001:', 0, 0, 0);
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_down_con`
#
CREATE TABLE mpshop_down_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',
filesize varchar(30) default NULL,
url varchar(255) default NULL,
`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;
#
# 導出下面的資料庫內容 `mpshop_down_con`
#
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_form`
#
CREATE TABLE mpshop_form (
id int(3) NOT NULL auto_increment,
field_caption varchar(200) NOT NULL default '',
field_type int(1) NOT NULL default '0',
field_size int(2) NOT NULL default '0',
field_name varchar(200) NOT NULL default '',
field_value varchar(255) NOT NULL default '',
field_null int(1) NOT NULL default '0',
value_repeat int(1) NOT NULL default '0',
field_intro varchar(255) NOT NULL default '',
use_field int(1) NOT NULL default '0',
moveable int(1) NOT NULL default '0',
xuhao int(3) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `mpshop_form`
#
INSERT INTO mpshop_form VALUES (1, '留言標題', 1, 35, 'title', '', 1, 1, '', 1, 1, 1);
INSERT INTO mpshop_form VALUES (2, '留言內容', 2, 34, 'content', '', 1, 1, '', 1, 1, 2);
INSERT INTO mpshop_form VALUES (3, '您的姓名', 1, 35, 'name', '', 1, 1, '', 1, 1, 3);
INSERT INTO mpshop_form VALUES (5, '聯繫電話', 1, 30, 'tel', '', 0, 1, '', 0, 0, 5);
INSERT INTO mpshop_form VALUES (6, '聯繫地址', 1, 35, 'address', '', 0, 1, '', 0, 0, 6);
INSERT INTO mpshop_form VALUES (7, '電子郵件', 1, 35, 'email', '', 1, 1, '', 1, 1, 7);
INSERT INTO mpshop_form VALUES (8, '網址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 8);
INSERT INTO mpshop_form VALUES (9, 'QQ號碼', 1, 16, 'qq', '', 0, 1, '', 0, 0, 9);
INSERT INTO mpshop_form VALUES (10, '公司名稱', 1, 35, 'company', '', 0, 1, '', 0, 0, 10);
INSERT INTO mpshop_form VALUES (11, '公司地址', 1, 35, 'company_address', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form VALUES (4, '性 別', 5, 21, 'sex', '男;女', 0, 1, '', 0, 0, 4);
INSERT INTO mpshop_form VALUES (12, '郵遞區號', 1, 6, 'zip', '', 0, 1, '', 0, 0, 12);
INSERT INTO mpshop_form VALUES (13, '傳真號碼', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO mpshop_form VALUES (14, '產品編號', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO mpshop_form VALUES (15, '產品名稱', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO mpshop_form VALUES (16, '訂購數量', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO mpshop_form VALUES (19, '自定義一', 5, 35, 'custom1', '100;200;300;400;500', 0, 1, '', 0, 0, 17);
INSERT INTO mpshop_form VALUES (18, '自定義二', 5, 35, 'custom2', '100;200;300;400;500', 0, 1, '', 0, 0, 18);
INSERT INTO mpshop_form VALUES (17, '自定義三', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO mpshop_form VALUES (20, '自定義四', 1, 35, 'custom4', '', 0, 1, '', 0, 0, 20);
INSERT INTO mpshop_form VALUES (21, '自定義五', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO mpshop_form VALUES (22, '自定義六', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO mpshop_form VALUES (23, '自定義七', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_form_85`
#
CREATE TABLE mpshop_form_85 (
id int(3) NOT NULL auto_increment,
field_caption varchar(200) default NULL,
field_type int(1) default NULL,
field_size int(3) default NULL,
field_name varchar(200) default NULL,
field_value varchar(255) default NULL,
field_null int(1) default NULL,
value_repeat int(1) default NULL,
field_intro varchar(255) default NULL,
use_field int(1) default NULL,
moveable int(1) default NULL,
xuhao int(3) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
#
# 導出下面的資料庫內容 `mpshop_form_85`
#
INSERT INTO mpshop_form_85 VALUES (1, '需求商品', 1, 35, 'title', '[缺貨]{#title#}', 1, 1, '', 1, 1, 1);
INSERT INTO mpshop_form_85 VALUES (2, '需求描述', 2, 34, 'content', '', 1, 1, '', 1, 1, 2);
INSERT INTO mpshop_form_85 VALUES (3, '您的姓名', 1, 35, 'name', '', 1, 1, '', 1, 1, 3);
INSERT INTO mpshop_form_85 VALUES (5, '聯繫電話', 1, 30, 'tel', '', 0, 1, '', 1, 0, 4);
INSERT INTO mpshop_form_85 VALUES (6, '聯繫地址', 1, 35, 'address', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (7, '電子郵件', 1, 35, 'email', '', 1, 1, '', 1, 1, 5);
INSERT INTO mpshop_form_85 VALUES (8, '網址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (9, 'QQ號碼', 1, 16, 'qq', '', 0, 1, '', 0, 0, 6);
INSERT INTO mpshop_form_85 VALUES (10, '公司名稱', 1, 35, 'company', '', 0, 1, '', 0, 0, 10);
INSERT INTO mpshop_form_85 VALUES (11, '公司地址', 1, 35, 'company_address', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (4, '性 別', 5, 21, 'sex', '男;女', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (12, '郵遞區號', 1, 6, 'zip', '', 0, 1, '', 0, 0, 12);
INSERT INTO mpshop_form_85 VALUES (13, '傳真號碼', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO mpshop_form_85 VALUES (14, '產品編號', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO mpshop_form_85 VALUES (15, '產品名稱', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO mpshop_form_85 VALUES (16, '訂購數量', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO mpshop_form_85 VALUES (19, '自定義一', 5, 35, 'custom1', '100;200;300;400;500', 0, 1, '', 0, 0, 17);
INSERT INTO mpshop_form_85 VALUES (18, '自定義二', 5, 35, 'custom2', '100;200;300;400;500', 0, 1, '', 0, 0, 18);
INSERT INTO mpshop_form_85 VALUES (17, '自定義三', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO mpshop_form_85 VALUES (20, '自定義四', 1, 35, 'custom4', '', 0, 1, '', 0, 0, 20);
INSERT INTO mpshop_form_85 VALUES (21, '自定義五', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO mpshop_form_85 VALUES (22, '自定義六', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO mpshop_form_85 VALUES (23, '自定義七', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------
#
# 資料表的結構 `mpshop_form_feedback`
#
CREATE TABLE mpshop_form_feedback (
id int(12) NOT NULL auto_increment,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -