?? db_zh_tw_utf8.mysql3x.sql

?? 網上鮮花管理系統
?? SQL
?? 第 1 頁 / 共 5 頁
字號:
上一頁 1 2 3 45
  logincount int(20) default NULL,
  logintime int(11) default NULL,
  loginip varchar(50) default NULL,
  agentid int(12) NOT NULL default '0',
  PRIMARY KEY  (memberid)
);

#
# 導出下面的資料庫內容 `mpshop_member`
#

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

#
# 資料表的結構 `mpshop_member_buylist`
#

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)
);

#
# 導出下面的資料庫內容 `mpshop_member_buylist`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_cat`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_fav`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `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);
# --------------------------------------------------------

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `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);
# --------------------------------------------------------

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_notice`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_nums`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_pay`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_paynotice`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_price`
#

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

#
# 資料表的結構 `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)
);

#
# 導出下面的資料庫內容 `mpshop_member_regform`
#

INSERT INTO mpshop_member_regform VALUES (1, '會員名稱', 'user', 1, 0, 0, '[5-20位元英文或數位]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (2, '登錄密碼', 'password', 1, 1, 0, '[5-20位元英文或數位]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (3, '重複密碼', 'repass', 1, 1, 0, '[5-20位元英文或數位]', 1, NULL);
INSERT INTO mpshop_member_regform VALUES (6, '企業名稱', '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, '所在地區', 'zoneid', 1, 1, 1, '', 0, NULL);
INSERT INTO mpshop_member_regform VALUES (11, '所屬行業', '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, '網站網址', '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);
# --------------------------------------------------------

#
# 資料表的結構 `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
上一頁 1 2 3 45
?? 文件大小 6170 K
?? 上傳用戶 bobey
?? 所屬分類 MySQL數據庫
??? 相關標簽

#管理系統
?? 快捷鍵說明

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

?? db_zh_tw_utf8.mysql3x.sql

?? 快捷鍵說明
