install.sql

城市分类信息,门户网站,我做为地方信息网

DROP TABLE IF EXISTS cbc_admin;
CREATE TABLE cbc_admin (
  adminid smallint(5) unsigned NOT NULL auto_increment,
  admin_name varchar(20) NOT NULL default '',
  admin_password varchar(32) NOT NULL default '',
  admin_prem tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (adminid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_allcomment;
CREATE TABLE cbc_allcomment (
  acid int(10) unsigned NOT NULL auto_increment,
  content mediumtext NOT NULL,
  dateline int(10) unsigned NOT NULL default '0',
  typeid tinyint(1) NOT NULL default '0',
  fid int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (acid),
  KEY uid (uid),
  KEY fid (fid),
  KEY typeid (typeid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizboss;
CREATE TABLE cbc_bizboss (
  bossid mediumint(8) unsigned NOT NULL auto_increment,
  bossname varchar(20) NOT NULL default '',
  bosstel varchar(30) NOT NULL default '',
  bossemail varchar(50) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  bizid mediumint(8) unsigned NOT NULL default '0',
  ischeck tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (bossid),
  KEY uid (uid),
  KEY bizid (bizid)
) TYPE=MyISAM;



DROP TABLE IF EXISTS cbc_bizcard;
CREATE TABLE cbc_bizcard (
  bizid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (bizid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizcate;
CREATE TABLE cbc_bizcate (
  cid smallint(5) unsigned NOT NULL auto_increment,
  name varchar(100) NOT NULL default '',
  number mediumint(8) NOT NULL default '0',
  fup smallint(5) NOT NULL default '0',
  bizs mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY fup (fup)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizcoupon;
CREATE TABLE cbc_bizcoupon (
  cpid mediumint(8) unsigned NOT NULL auto_increment,
  stime int(10) unsigned NOT NULL default '0',
  etime int(10) unsigned NOT NULL default '0',
  subject varchar(100) NOT NULL default '',
  content mediumtext NOT NULL,
  cptype tinyint(1) NOT NULL default '0',
  cpimg varchar(150) NOT NULL default '',
  replies mediumint(8) NOT NULL default '0',
  bizid mediumint(8) unsigned NOT NULL default '0',
  cid mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (cpid),
  KEY bizid (bizid),
  KEY cid (cid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizinfo;
CREATE TABLE cbc_bizinfo (
  bizid mediumint(8) unsigned NOT NULL auto_increment,
  biz_name varchar(60) NOT NULL default '',
  biz_cid mediumint(8) unsigned NOT NULL default '0',
  biz_photo varchar(200) NOT NULL default '',
  biz_address varchar(60) NOT NULL default '',
  biz_district tinyint(1) NOT NULL default '0',
  biz_phone varchar(20) NOT NULL default '',
  biz_fax varchar(20) NOT NULL default '',
  biz_web varchar(100) NOT NULL default '',
  biz_email varchar(50) NOT NULL default '',
  biz_hours varchar(50) NOT NULL default '',
  bus_line varchar(50) NOT NULL default '',
  area_flag varchar(50) NOT NULL default '',
  biz_intro mediumtext NOT NULL,
  biz_sort varchar(30) NOT NULL default '0',
  biz_env varchar(30) NOT NULL default '',
  biz_customer varchar(30) NOT NULL default '',
  biz_scale varchar(30) NOT NULL default '',
  biz_ave_consume varchar(30) NOT NULL default '',
  biz_service varchar(200) NOT NULL default '',
  weizhiX int(10) unsigned NOT NULL default '0',
  weizhiY int(10) unsigned NOT NULL default '0',
  cardtxt varchar(100) NOT NULL default '',
  tuijian tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (bizid),
  KEY biz_cid (biz_cid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizinfo_one;
CREATE TABLE cbc_bizinfo_one (
  bizid mediumint(8) unsigned NOT NULL auto_increment,
  biz_name varchar(60) NOT NULL default '',
  biz_cid mediumint(8) unsigned NOT NULL default '0',
  biz_address varchar(60) NOT NULL default '',
  biz_district tinyint(1) NOT NULL default '0',
  biz_phone varchar(20) NOT NULL default '',
  biz_fax varchar(20) NOT NULL default '',
  biz_web varchar(100) NOT NULL default '',
  biz_email varchar(50) NOT NULL default '',
  biz_hours varchar(50) NOT NULL default '',
  bus_line varchar(50) NOT NULL default '',
  area_flag varchar(50) NOT NULL default '',
  biz_intro mediumtext NOT NULL,
  biz_sort varchar(30) NOT NULL default '0',
  biz_env varchar(30) NOT NULL default '',
  biz_customer varchar(30) NOT NULL default '',
  biz_scale varchar(30) NOT NULL default '',
  biz_ave_consume varchar(30) NOT NULL default '',
  biz_service varchar(200) NOT NULL default '',
  weizhiX int(10) unsigned NOT NULL default '0',
  weizhiY int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (bizid),
  KEY biz_cid (biz_cid),
  KEY uid (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizinfomore;
CREATE TABLE cbc_bizinfomore (
  bmid mediumint(8) unsigned NOT NULL default '0',
  star tinyint(1) unsigned NOT NULL default '0',
  dpnum mediumint(8) unsigned NOT NULL default '0',
  pfnum mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (bmid),
  KEY star (star)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizphoto;
CREATE TABLE cbc_bizphoto (
  pid mediumint(8) unsigned NOT NULL auto_increment,
  bizid mediumint(8) unsigned NOT NULL default '0',
  imgsrc varchar(100) NOT NULL default '',
  PRIMARY KEY  (pid),
  KEY bizid (bizid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizpoint;
CREATE TABLE cbc_bizpoint (
  bpid int(10) unsigned NOT NULL auto_increment,
  bizid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  a tinyint(1) NOT NULL default '0',
  b tinyint(1) NOT NULL default '0',
  c tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (bpid),
  KEY shopid (bizid,uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizproduct;
CREATE TABLE cbc_bizproduct (
  ptid int(10) unsigned NOT NULL auto_increment,
  pname varchar(50) NOT NULL default '',
  imgsrc varchar(200) NOT NULL default '',
  bizid mediumint(8) unsigned NOT NULL default '0',
  ptxt text NOT NULL,
  PRIMARY KEY  (ptid),
  KEY bizid (bizid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_bizuser;
CREATE TABLE cbc_bizuser (
  buid int(10) unsigned NOT NULL auto_increment,
  bizid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(20) NOT NULL default '',
  want tinyint(1) NOT NULL default '0',
  been tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (buid),
  KEY shopid (bizid),
  KEY uid (uid),
  KEY want (want),
  KEY go (been)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_comment;
CREATE TABLE cbc_comment (
  cmtid int(10) unsigned NOT NULL auto_increment,
  typeid tinyint(1) unsigned NOT NULL default '0',
  bizid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(18) NOT NULL default '',
  special_commend varchar(100) NOT NULL default '',
  hint_notice varchar(100) NOT NULL default '',
  content mediumtext NOT NULL,
  good mediumint(8) unsigned NOT NULL default '0',
  bad mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (cmtid),
  KEY typeid (typeid),
  KEY bizid (bizid),
  KEY uid (uid),
  KEY uid_2 (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_commentdp;
CREATE TABLE cbc_commentdp (
  cpid int(10) unsigned NOT NULL auto_increment,
  cmtid int(10) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  dptype tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (cpid),
  KEY cmtid (cmtid),
  KEY uid (uid)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_fleicate;
CREATE TABLE cbc_fleicate (
  cid mediumint(8) unsigned NOT NULL auto_increment,
  name varchar(20) NOT NULL default '',
  fup mediumint(8) unsigned NOT NULL default '0',
  fleis mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (cid),
  KEY fup (fup)
) TYPE=MyISAM;


DROP TABLE IF EXISTS cbc_fleiinfo;
CREATE TABLE cbc_fleiinfo (
  flid int(10) unsigned NOT NULL auto_increment,
  cid mediumint(8) unsigned NOT NULL default '0',
  sortid mediumint(8) unsigned NOT NULL default '0',
  title varchar(200) NOT NULL default '',
  content mediumtext NOT NULL,
  imgsrc varchar(150) NOT NULL default '',
  userfrom smallint(5) NOT NULL default '0',
  usertel varchar(20) NOT NULL default '',
  qq varchar(20) NOT NULL default '',
  replies mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (flid),
  KEY cid (cid),
  KEY sortid (sortid),
  KEY userfrom (userfrom),
  KEY uid (uid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cbc_fleijb;
CREATE TABLE cbc_fleijb (
  jbid int(10) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  flid int(10) unsigned NOT NULL default '0',
  typeid tinyint(1) unsigned NOT NULL default '0',
  dateline int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (jbid),
  KEY uid (uid),
  KEY flid (flid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS cbc_friend;
CREATE TABLE cbc_friend (
  fid int(10) unsigned NOT NULL auto_increment,
  frduid mediumint(8) unsigned NOT NULL default '0',
  frdname varchar(16) NOT NULL default '',
  status tinyint(1) NOT NULL default '0',