INSERT INTO mpshop_config VALUES (93, '前臺(tái)圖片上傳尺寸限制(Byte)', 'input', '30', 'PicSizeLimit', '102400', '前臺(tái)網(wǎng)站上傳圖片時(shí)單個(gè)圖片尺寸的限制');
INSERT INTO mpshop_config VALUES (65, '是否啟用非會(huì)員訂購', 'YN', '30', 'NoMemberOrder', '1', '啟用非會(huì)員訂購時(shí),允許未登錄者在訂單填寫時(shí)填寫簡單會(huì)員資料,同時(shí)注冊(cè)為會(huì)員;不啟用非會(huì)員訂購時(shí),未登錄者直接跳轉(zhuǎn)到登錄界面');
INSERT INTO mpshop_config VALUES (66, '非會(huì)員訂購自動(dòng)注冊(cè)會(huì)員類型', 'NoMemberType', '30', 'NoMemberType', '10', '在啟用非會(huì)員訂購時(shí),訂購?fù)瑫r(shí)填寫會(huì)員資料自動(dòng)注冊(cè)的會(huì)員類型');
INSERT INTO mpshop_config VALUES (68, '后臺(tái)是否允許欠費(fèi)扣款支付訂單', 'YN', '30', 'OrderPayFu', '0', '后臺(tái)從會(huì)員帳戶扣款支付訂單時(shí),是否允許會(huì)員預(yù)付款帳戶出現(xiàn)欠費(fèi)');
INSERT INTO mpshop_config VALUES (69, '是否允許未付款發(fā)貨和已發(fā)貨退款', 'YN', '30', 'OrderYunNoPay', '0', '當(dāng)訂單處于未付款狀態(tài)時(shí),是否允許進(jìn)行發(fā)貨確認(rèn);當(dāng)訂單全部或部分發(fā)貨時(shí)是否允許退款操作');
INSERT INTO mpshop_config VALUES (58, '商品搜索熱門關(guān)鍵詞', 'input', '30', 'GoodsHotWords', '哈利·波特,賈平凹,理財(cái),股市,房產(chǎn)', '顯示在商品搜索表單的熱門關(guān)鍵詞,以逗號(hào)分隔');
INSERT INTO mpshop_config VALUES (72, '推廣鏈盟提成比例(%)', 'input', '30', 'LmPercent', '0.5', '來自推廣鏈盟成員網(wǎng)站的訪問者在訂購付款后,鏈盟成員獲得提成的比例.按訂單商品總金額的百分比計(jì)算');
INSERT INTO mpshop_config VALUES (70, '賣方訂單通知', 'YN', '30', 'OrderSellerNotice', '0', '在顧客提交訂單和訂單支付時(shí),發(fā)送郵件通知商家.適合不能經(jīng)常進(jìn)入后臺(tái)查詢訂單的商家;如果訂單量較多,有專人值守的商家,不推薦啟用此功能,因郵件發(fā)送過程可能使顧客提交訂單的速度受到影響');
INSERT INTO mpshop_config VALUES (71, '買方訂單通知', 'YN', '30', 'OrderBuyerNotice', '0', '管理員審核確認(rèn)訂單時(shí),訂單發(fā)貨完成時(shí),發(fā)郵件通知顧客');
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `mpshop_cp_cat`
#

# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `mpshop_cp_con`
#

# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `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);
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `mpshop_down_cat`
#

INSERT INTO mpshop_down_cat VALUES (1, 0, 5, '測試下載', 1, '0001:', 0, 0, 0);
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `mpshop_down_con`
#

# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `mpshop_form`
#

INSERT INTO mpshop_form VALUES (1, '留言標(biāo)題', 1, 35, 'title', '', 1, 1, '', 1, 1, 1);
INSERT INTO mpshop_form VALUES (2, '留言內(nèi)容', 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, '聯(lián)系電話', 1, 30, 'tel', '', 0, 1, '', 0, 0, 5);
INSERT INTO mpshop_form VALUES (6, '聯(lián)系地址', 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, '網(wǎng)址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 8);
INSERT INTO mpshop_form VALUES (9, 'QQ號(hào)碼', 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, '傳真號(hào)碼', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO mpshop_form VALUES (14, '產(chǎn)品編號(hào)', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO mpshop_form VALUES (15, '產(chǎn)品名稱', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO mpshop_form VALUES (16, '訂購數(shù)量', 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);
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `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)
);

#
# 導(dǎo)出下面的數(shù)據(jù)庫內(nèi)容 `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, '聯(lián)系電話', 1, 30, 'tel', '', 0, 1, '', 1, 0, 4);
INSERT INTO mpshop_form_85 VALUES (6, '聯(lián)系地址', 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, '網(wǎng)址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (9, 'QQ號(hào)碼', 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, '傳真號(hào)碼', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO mpshop_form_85 VALUES (14, '產(chǎn)品編號(hào)', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO mpshop_form_85 VALUES (15, '產(chǎn)品名稱', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO mpshop_form_85 VALUES (16, '訂購數(shù)量', 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);
# --------------------------------------------------------

#
# 數(shù)據(jù)表的結(jié)構(gòu) `mpshop_form_feedback`
#

CREATE TABLE mpshop_form_feedback (
  id int(12) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title varchar(255) NOT NULL default '',
  content text NOT NULL,
  name varchar(200) NOT NULL default '',
  sex varchar(10) NOT NULL default '',
  tel varchar(100) NOT NULL default '',
  address varchar(255) NOT NULL default '',
  email varchar(255) NOT NULL default '',
  url varchar(255) NOT NULL default '',
  qq varchar(20) NOT NULL default '',
  company varchar(255) NOT NULL default '',
  company_address varchar(255) NOT NULL default '',
  zip varchar(6) NOT NULL default '',