?? db_zh_cn_utf8.mysql3x.sql

#

CREATE TABLE mpshop_member_buylist (
  id int(12) NOT NULL auto_increment,
  memberid int(12) NOT NULL default '0',
  orderid int(12) NOT NULL default '0',
  payid int(12) NOT NULL default '0',
  paytype varchar(50) NOT NULL default '0',
  payhb varchar(30) NOT NULL default '',
  payhl decimal(12,4) NOT NULL default '0.0000',
  paytotal decimal(12,2) NOT NULL default '0.00',
  daytime int(11) NOT NULL default '0',
  ip varchar(20) NOT NULL default '',
  OrderNo varchar(30) NOT NULL default '',
  logname varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
);

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

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

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

CREATE TABLE mpshop_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)
);

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

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

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

CREATE TABLE mpshop_member_fav (
  id int(4) NOT NULL auto_increment,
  memberid int(20) default NULL,
  gid int(20) default NULL,
  PRIMARY KEY  (id)
);

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

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

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

CREATE TABLE mpshop_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)
);

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

INSERT INTO mpshop_member_func VALUES (1, 0, '會員資料修改', 'member_modify.php', 2, 1, '');
INSERT INTO mpshop_member_func VALUES (2, 0, '商品清單', 'member_goods.php', 3, 1, '');
INSERT INTO mpshop_member_func VALUES (3, 0, '商品收藏', 'member_mygoods.php', 4, 1, '');
INSERT INTO mpshop_member_func VALUES (4, 0, '未完成訂單', 'member_order.php', 5, 1, '');
INSERT INTO mpshop_member_func VALUES (5, 0, '已存檔訂單', 'member_order1.php', 6, 1, '');
INSERT INTO mpshop_member_func VALUES (6, 0, '我的帳戶信息', 'member_account.php', 7, 1, '');
INSERT INTO mpshop_member_func VALUES (7, 0, '付款記錄查詢', 'member_paylist.php', 8, 1, '');
INSERT INTO mpshop_member_func VALUES (8, 0, '購買記錄查詢', 'member_buylist.php', 9, 1, '');
INSERT INTO mpshop_member_func VALUES (9, 0, '積分記錄查詢', 'member_centlist.php', 10, 1, '');
INSERT INTO mpshop_member_func VALUES (10, 0, '預付帳戶充值', 'member_pay.php', 11, 1, '');
INSERT INTO mpshop_member_func VALUES (11, 0, '文章投稿', 'member_fabu.php', 12, 1, '');
INSERT INTO mpshop_member_func VALUES (12, 0, '文章管理', 'member_guanli.php', 13, 1, '');
INSERT INTO mpshop_member_func VALUES (13, 0, '推廣鏈盟', 'member_lmadd.php', 14, 1, '');
INSERT INTO mpshop_member_func VALUES (14, 0, '退出登錄', 'logout.php', 15, 1, NULL);
# --------------------------------------------------------

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

CREATE TABLE mpshop_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)
);

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

INSERT INTO mpshop_member_func_10 VALUES (1, 0, '會員資料修改', 'member_modify.php', 2, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (2, 0, '商品清單', 'member_goods.php', 3, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (3, 0, '商品收藏', 'member_mygoods.php', 4, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (4, 0, '未完成訂單', 'member_order.php', 5, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (5, 0, '已存檔訂單', 'member_order1.php', 6, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (6, 0, '我的帳戶信息', 'member_account.php', 7, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (7, 0, '付款記錄查詢', 'member_paylist.php', 8, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (8, 0, '購買記錄查詢', 'member_buylist.php', 9, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (9, 0, '積分記錄查詢', 'member_centlist.php', 10, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (10, 0, '預付帳戶充值', 'member_pay.php', 11, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (11, 0, '文章投稿', 'member_fabu.php', 12, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (12, 0, '文章管理', 'member_guanli.php', 13, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (13, 0, '推廣鏈盟', 'member_lmadd.php', 14, 1, '');
INSERT INTO mpshop_member_func_10 VALUES (14, 0, '退出登錄', 'logout.php', 15, 1, NULL);
# --------------------------------------------------------

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

CREATE TABLE mpshop_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)
);

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

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

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

CREATE TABLE mpshop_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)
);

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

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

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

CREATE TABLE mpshop_member_pay (
  id int(11) NOT NULL auto_increment,
  memberid int(20) NOT NULL default '0',
  payid int(11) NOT NULL default '0',
  payhb varchar(30) NOT NULL default '',
  payhl decimal(12,4) NOT NULL default '0.0000',
  oof decimal(12,2) NOT NULL default '0.00',
  method varchar(200) NOT NULL default '',
  `type` varchar(50) NOT NULL default '',
  addtime int(11) NOT NULL default '0',
  fpnum varchar(100) NOT NULL default '',
  memo varchar(255) NOT NULL default '',
  ip varchar(20) NOT NULL default '',
  logname varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
);

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

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

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

CREATE TABLE mpshop_member_paynotice (
  id int(20) NOT NULL auto_increment,
  memberid int(20) NOT NULL default '0',
  orderid int(12) NOT NULL default '0',
  paytype varchar(100) NOT NULL default '',
  payhb varchar(50) NOT NULL default '',
  paytotal decimal(12,2) NOT NULL default '0.00',
  paytime varchar(30) NOT NULL default '',
  payby varchar(100) NOT NULL default '',
  cno varchar(100) NOT NULL default '',
  iflook int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
);

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

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

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

CREATE TABLE mpshop_member_price (
  id int(4) NOT NULL auto_increment,
  memberid int(20) default NULL,
  gid int(20) default NULL,
  price decimal(12,2) default NULL,
  PRIMARY KEY  (id)
);

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

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

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

CREATE TABLE mpshop_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)
);

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

INSERT INTO mpshop_member_regform VALUES (1, '會員名稱', 'user', 1, 0, 0, '[5-20位英文或數(shù)字]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (3, '重復密碼', 'repass', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (6, '企業(yè)名稱', 'company', 0, 1, 1, '', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (7, '您的姓名', 'name', 1, 1, 1, '', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (8, '性　　別', 'sex', 1, 1, 1, '', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (10, '所在地區(qū)', 'zoneid', 1, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (11, '所屬行業(yè)', 'catid', 1, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (12, '通信地址', 'addr', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (13, '電話號碼', 'tel', 0, 1, 1, '', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (14, '手機號碼', 'mov', 0, 1, 1, '', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (15, '傳真號碼', 'fax', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (16, '郵政編碼', 'postcode', 0, 1, 1, '', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (17, '電子郵件', 'email', 1, 1, 0, '[請輸入正確的電子郵件]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (18, '網(wǎng)站網(wǎng)址', 'url', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (19, '證件類型', 'passtype', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (20, '證件號碼', 'passcode', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (21, 'QQ號碼', 'qq', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (22, 'MSN號碼', 'msn', 0, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (24, '備注留言', 'bz', 0, 1, 1, '', 0, NULL);
# --------------------------------------------------------

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

CREATE TABLE mpshop_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)
);

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

INSERT INTO mpshop_member_regform_10 VALUES (1, '會 員 名', 'user', 1, 0, 0, '[5-20位英文或數(shù)字]', 1, 0);
INSERT INTO mpshop_member_regform_10 VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, 0);
INSERT INTO mpshop_member_regform_10 VALUES (3, '重復密碼', 'repass', 1, 1, 0, '[5-20位英文或數(shù)字]', 1, 0);
INSERT INTO mpshop_member_regform_10 VALUES (6, '企業(yè)名稱', 'company', 0, 1, 1, '', 0, 0);
INSERT INTO mpshop_member_regform_10 VALUES (7, '會員姓名', 'name', 1, 1, 1, '', 1, 0);
INSERT INTO mpshop_member_regform_10 VALUES (8, '您的稱呼', 'sex', 1, 1, 1, '', 1, 0);
INSERT INTO mpshop_member_regform_10 VALUES (9, '出生年月', 'birthday', 0, 1, 1, '', 1, 0
上一頁 1 2 3 45
?? 文件大小 4878 K
?? 上傳用戶 hard
?? 所屬分類其他
?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

?? db_zh_cn_utf8.mysql3x.sql

?? 快捷鍵說明
