db_zh_tw_utf8.sql

网上鲜花管理系统

  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 '',
  fax varchar(20) NOT NULL default '',
  products_id varchar(100) NOT NULL default '',
  products_name varchar(200) NOT NULL default '',
  products_num varchar(9) NOT NULL default '',
  custom1 text NOT NULL,
  custom2 text NOT NULL,
  custom3 text NOT NULL,
  custom4 text NOT NULL,
  custom5 text NOT NULL,
  custom6 text NOT NULL,
  custom7 text NOT NULL,
  ip varchar(20) NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  look int(1) NOT NULL default '0',
  reversion int(1) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE mpshop_gifts_order (
  orderid int(12) NOT NULL auto_increment,
  memberid int(6) NOT NULL default '0',
  `user` varchar(50) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  email varchar(150) NOT NULL default '',
  tel varchar(100) NOT NULL default '',
  addr varchar(100) NOT NULL default '',
  postcode varchar(8) NOT NULL default '',
  mobi varchar(30) NOT NULL default '',
  gid int(12) NOT NULL default '0',
  goodsname varchar(100) NOT NULL default '',
  cent int(12) NOT NULL default '0',
  nums int(10) NOT NULL default '0',
  totalcent int(10) NOT NULL default '0',
  iflook int(1) NOT NULL default '0',
  ifyun int(1) NOT NULL default '0',
  ip varchar(20) NOT NULL default '',
  dtime int(11) NOT NULL default '0',
  yuntime int(11) NOT NULL default '0',
  bz text,
  PRIMARY KEY  (orderid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE mpshop_goodsprop (
  id int(20) NOT NULL auto_increment,
  goodstype char(50) NOT NULL default '',
  propname char(30) NOT NULL default '',
  proptype char(30) NOT NULL default '',
  xuhao int(20) NOT NULL default '0',
  ifsearch int(1) NOT NULL default '0',
  ifsel int(1) NOT NULL default '0',
  ifdetail int(1) NOT NULL default '1',
  PRIMARY KEY  (id),
  KEY xuhao (xuhao)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO mpshop_goodsprop VALUES (87, 'flower', '價格範圍', 'list', 6, 1, 0, 0);
INSERT INTO mpshop_goodsprop VALUES (85, 'flower', '花材包裝', 'show', 4, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (84, 'dangao', '包裝', 'show', 2, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (83, 'dangao', '材料', 'show', 1, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (54, 'flower', '事件用途', 'list', 1, 1, 0, 0);
INSERT INTO mpshop_goodsprop VALUES (55, 'flower', '主要花材', 'list', 2, 1, 0, 0);
INSERT INTO mpshop_goodsprop VALUES (56, 'flower', '贈送對象', 'list', 3, 1, 0, 0);
INSERT INTO mpshop_goodsprop VALUES (57, 'flower', '浪漫花語', 'show', 5, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (64, 'pcdiy', 'CPU', 'show', 1, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (65, 'pcdiy', '記憶體', 'show', 2, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (69, 'pcdiy', '硬碟', 'show', 3, 0, 0, 1);
INSERT INTO mpshop_goodsprop VALUES (67, 'pcdiy', '機箱顏色', 'list', 4, 0, 1, 1);
# --------------------------------------------------------

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

CREATE TABLE mpshop_goodsprop_list (
  id int(12) NOT NULL auto_increment,
  propid int(12) NOT NULL default '0',
  name char(100) NOT NULL default '',
  xuhao int(5) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO mpshop_goodsprop_list VALUES (57, 54, '生日快樂', 2);
INSERT INTO mpshop_goodsprop_list VALUES (56, 54, '浪漫愛情', 1);
INSERT INTO mpshop_goodsprop_list VALUES (59, 54, '友情致謝', 4);
INSERT INTO mpshop_goodsprop_list VALUES (58, 54, '歡慶祝賀', 3);
INSERT INTO mpshop_goodsprop_list VALUES (60, 54, '早日康復', 5);
INSERT INTO mpshop_goodsprop_list VALUES (61, 54, '慶典禮儀', 6);
INSERT INTO mpshop_goodsprop_list VALUES (62, 54, '弔唁懷念', 7);
INSERT INTO mpshop_goodsprop_list VALUES (63, 54, '家居生活', 8);
INSERT INTO mpshop_goodsprop_list VALUES (64, 55, '紅玫瑰', 1);
INSERT INTO mpshop_goodsprop_list VALUES (65, 55, '白玫瑰', 2);
INSERT INTO mpshop_goodsprop_list VALUES (66, 55, '粉玫瑰', 3);
INSERT INTO mpshop_goodsprop_list VALUES (67, 55, '黃玫瑰', 4);
INSERT INTO mpshop_goodsprop_list VALUES (68, 55, '藍玫瑰', 5);
INSERT INTO mpshop_goodsprop_list VALUES (69, 55, '彩玫瑰', 6);
INSERT INTO mpshop_goodsprop_list VALUES (70, 55, '百合花', 7);
INSERT INTO mpshop_goodsprop_list VALUES (71, 55, '康乃馨', 8);
INSERT INTO mpshop_goodsprop_list VALUES (72, 55, '鬱金香', 9);
INSERT INTO mpshop_goodsprop_list VALUES (100, 87, '100元以內', 1);
INSERT INTO mpshop_goodsprop_list VALUES (74, 56, '戀人', 1);
INSERT INTO mpshop_goodsprop_list VALUES (75, 56, '朋友', 2);
INSERT INTO mpshop_goodsprop_list VALUES (76, 56, '父母', 3);
INSERT INTO mpshop_goodsprop_list VALUES (77, 56, '同事', 4);
INSERT INTO mpshop_goodsprop_list VALUES (78, 56, '病人', 5);
INSERT INTO mpshop_goodsprop_list VALUES (79, 56, '老師', 6);
INSERT INTO mpshop_goodsprop_list VALUES (80, 56, '客戶', 7);
INSERT INTO mpshop_goodsprop_list VALUES (81, 56, '兒童', 8);
INSERT INTO mpshop_goodsprop_list VALUES (105, 87, '500元以上', 6);
INSERT INTO mpshop_goodsprop_list VALUES (104, 87, '400-500元', 5);
INSERT INTO mpshop_goodsprop_list VALUES (103, 87, '300-400元', 4);
INSERT INTO mpshop_goodsprop_list VALUES (102, 87, '200-300元', 3);
INSERT INTO mpshop_goodsprop_list VALUES (90, 67, '白色', 1);
INSERT INTO mpshop_goodsprop_list VALUES (91, 67, '黑色', 2);
INSERT INTO mpshop_goodsprop_list VALUES (101, 87, '100-200元', 2);
INSERT INTO mpshop_goodsprop_list VALUES (99, 55, '向日葵', 11);
# --------------------------------------------------------

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

CREATE TABLE mpshop_goodstemp (
  id int(12) NOT NULL auto_increment,
  goodstype varchar(50) NOT NULL default '',
  templates text NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE mpshop_goodstype (
  id int(12) NOT NULL auto_increment,
  goodstype varchar(50) NOT NULL default '',
  name varchar(100) NOT NULL default '',
  moveable int(1) NOT NULL default '1',
  xuhao int(6) NOT NULL default '0',
  spec int(1) NOT NULL default '0',
  intro varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO mpshop_goodstype VALUES (1, 'shop', '其他商品', 0, 4, 0, '');
INSERT INTO mpshop_goodstype VALUES (35, 'cent', '積分贈品', 0, 7, 1, '');
INSERT INTO mpshop_goodstype VALUES (7, 'flower', '鮮 花 類', 0, 1, 0, '');
INSERT INTO mpshop_goodstype VALUES (15, 'tc', '組合套餐', 0, 5, 1, '');
INSERT INTO mpshop_goodstype VALUES (36, 'dangao', '蛋 糕 類', 1, 2, 0, '');
INSERT INTO mpshop_goodstype VALUES (26, 'fushu', '附屬配件', 0, 6, 1, '');
INSERT INTO mpshop_goodstype VALUES (34, 'flowerdiy', '自助訂花', 0, 3, 1, '');
# --------------------------------------------------------

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

CREATE TABLE mpshop_hb (
  id int(12) NOT NULL auto_increment,
  hbname char(50) default NULL,
  hbtype int(1) default NULL,
  hbcode char(20) default NULL,
  hbdanwei char(20) default NULL,
  hl decimal(12,4) default NULL,
  ifdefault int(1) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO mpshop_hb VALUES (1, '人民幣', 1, 'CNY', '元', '1.0000', 1);
INSERT INTO mpshop_hb VALUES (3, '美元', 1, 'USD', 'USD', '0.1250', 0);
INSERT INTO mpshop_hb VALUES (4, '港元', 1, 'HKD', 'HKD', '1.0000', 0);
INSERT INTO mpshop_hb VALUES (6, '日元', 1, 'JPY', 'JPY', '11.0000', 0);
# --------------------------------------------------------

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

CREATE TABLE mpshop_link (
  id int(12) NOT NULL auto_increment,
  showtype varchar(10) default NULL,
  name varchar(200) default NULL,
  url varchar(200) default NULL,
  xuhao int(5) default NULL,
  `type` varchar(20) default NULL,
  src varchar(20) default NULL,
  cl int(10) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

CREATE TABLE mpshop_logo (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  width int(10) default '0',
  height int(10) default '0',
  `type` varchar(20) default '',
  src varchar(100) default '',
  url varchar(200) default '',
  target varchar(100) default '',
  border int(2) default '0',
  hidden int(1) default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO mpshop_logo VALUES (1, 1, 0, 0, 'gif', 'images/logo.gif', '', '', 0, 0);
# --------------------------------------------------------

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

CREATE TABLE mpshop_mailtemp (
  id int(12) NOT NULL auto_increment,
  title varchar(200) NOT NULL default '',
  body text NOT NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO mpshop_mailtemp VALUES (1, '新郵件標題1', '請輸入郵件內容1');
# --------------------------------------------------------

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

CREATE TABLE mpshop_member (
  memberid int(12) NOT NULL auto_increment,
  membertypeid int(3) default NULL,
  `user` varchar(30) default NULL,
  `password` varchar(50) default NULL,
  company varchar(255) default NULL,
  name varchar(255) default NULL,
  sex varchar(20) default NULL,
  birthday int(8) default NULL,
  zoneid int(10) default NULL,
  catid int(10) default NULL,
  addr varchar(255) default NULL,