db_zh_cn_utf8.mysql3x.sql

网上鲜花管理系统

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

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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)
);

#
# 导出下面的数据库内容 `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,
  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,