db.sql

购物网设计的购物系统是基于WEB开发的大型购物系统。 它以构建电子商务网站为目标

#

DROP TABLE IF EXISTS bookshop_advs_float;
CREATE TABLE bookshop_advs_float (
  id int(4) NOT NULL auto_increment,
  menuid int(10) NOT NULL default '0',
  title varchar(200) default NULL,
  float_advs_type varchar(10) NOT NULL default '',
  hidden int(1) NOT NULL default '0',
  float_width int(3) NOT NULL default '0',
  float_height int(3) NOT NULL default '0',
  float_url varchar(255) NOT NULL default '',
  float_target varchar(40) NOT NULL default '',
  src varchar(255) NOT NULL default '',
  float_speed int(4) NOT NULL default '0',
  border int(3) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_advs_float`
#

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

#
# 数据表的结构 `bookshop_advs_left`
#

DROP TABLE IF EXISTS bookshop_advs_left;
CREATE TABLE bookshop_advs_left (
  id int(4) NOT NULL auto_increment,
  menuid int(20) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  type char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
  border int(2) default NULL,
  hidden int(1) default NULL,
  toppadding int(5) default NULL,
  sidepadding int(5) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_advs_left`
#

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

#
# 数据表的结构 `bookshop_advs_menu`
#

DROP TABLE IF EXISTS bookshop_advs_menu;
CREATE TABLE bookshop_advs_menu (
  id int(4) NOT NULL auto_increment,
  menuid int(20) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  type char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
  border int(2) default NULL,
  hidden int(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_advs_menu`
#

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

#
# 数据表的结构 `bookshop_advs_pop`
#

DROP TABLE IF EXISTS bookshop_advs_pop;
CREATE TABLE bookshop_advs_pop (
  id int(12) NOT NULL auto_increment,
  menuid int(12) default NULL,
  title text,
  body text,
  ifpop int(1) default NULL,
  popwidth int(10) default NULL,
  popheight int(10) default NULL,
  popleft int(10) default NULL,
  poptop int(10) default NULL,
  poptoolbar int(1) default NULL,
  popmenubar int(1) default NULL,
  popstatus int(1) default NULL,
  poplocation int(1) default NULL,
  popscrollbars varchar(50) default NULL,
  popresizable int(1) default NULL,
  tempid int(6) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_advs_pop`
#

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

#
# 数据表的结构 `bookshop_advs_right`
#

DROP TABLE IF EXISTS bookshop_advs_right;
CREATE TABLE bookshop_advs_right (
  id int(4) NOT NULL auto_increment,
  menuid int(20) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  type char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
  border int(2) default NULL,
  hidden int(1) default NULL,
  toppadding int(5) default NULL,
  sidepadding int(5) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_advs_right`
#

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

#
# 数据表的结构 `bookshop_cent`
#

DROP TABLE IF EXISTS bookshop_cent;
CREATE TABLE bookshop_cent (
  id int(8) NOT NULL auto_increment,
  name char(100) default NULL,
  event char(30) default NULL,
  type int(1) default NULL,
  method int(1) default NULL,
  cent int(10) default NULL,
  mult int(10) default NULL,
  allowminus int(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_cent`
#

INSERT INTO bookshop_cent VALUES (1, '订单付款确认', 'OrderPayCheck', 1, 1, 0, 1, 1);
INSERT INTO bookshop_cent VALUES (2, '付款订单退回', 'OrderPayback', 2, 1, 0, 1, 1);
# --------------------------------------------------------

#
# 数据表的结构 `bookshop_cent_list`
#

DROP TABLE IF EXISTS bookshop_cent_list;
CREATE TABLE bookshop_cent_list (
  id int(4) NOT NULL auto_increment,
  memberid int(8) default NULL,
  cent decimal(12,2) default NULL,
  reason char(255) default NULL,
  daytime int(11) default NULL,
  ip char(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_cent_list`
#

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

#
# 数据表的结构 `bookshop_colfunc`
#

DROP TABLE IF EXISTS bookshop_colfunc;
CREATE TABLE bookshop_colfunc (
  id int(12) NOT NULL auto_increment,
  coltype varchar(30) default NULL,
  func varchar(50) default NULL,
  link varchar(255) default NULL,
  xuhao int(3) default NULL,
  pages varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `bookshop_colfunc`
#

INSERT INTO bookshop_colfunc VALUES (1, 'ns', '类别管理', 'd_ns_cat_frame.php', 2, '');
INSERT INTO bookshop_colfunc VALUES (3, 'ns', '文章管理', 'd_ns_frame.php', 4, '');
INSERT INTO bookshop_colfunc VALUES (39, 'form', '表单设置', 'd_form.php', 1, '');
INSERT INTO bookshop_colfunc VALUES (37, 'show', '内容管理', 'd_show.php', 2, '');
INSERT INTO bookshop_colfunc VALUES (36, 'show', '内容添加', 'd_show_add.php', 1, '');