db_zh_tw_utf8.sql

网上鲜花管理系统

  tel varchar(255) default NULL,
  mov varchar(255) default NULL,
  fax varchar(255) default NULL,
  postcode varchar(255) default NULL,
  email varchar(255) default NULL,
  url varchar(255) default NULL,
  passtype varchar(255) default NULL,
  passcode varchar(255) default NULL,
  qq varchar(100) default NULL,
  msn varchar(100) default NULL,
  maillist int(1) default NULL,
  bz text,
  checked int(1) default NULL,
  regtime int(11) default NULL,
  exptime int(11) default NULL,
  account decimal(12,2) NOT NULL default '0.00',
  paytotal decimal(12,2) NOT NULL default '0.00',
  buytotal decimal(12,2) NOT NULL default '0.00',
  cent decimal(12,2) NOT NULL default '0.00',
  ip varchar(26) default NULL,
  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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 導出下面的資料庫內容 `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)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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