070319_emibzt5o-1.sql

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

  `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 AUTO_INCREMENT=4;

INSERT INTO cbc_bizinfo_one VALUES ('3','12222','2','','1','','','','','','','','d','19,20,25','','','','','','2690263','11261058','1');

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;

INSERT INTO cbc_bizinfomore VALUES ('1','0','0','0');
INSERT INTO cbc_bizinfomore VALUES ('2','3','2','1');

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 AUTO_INCREMENT=8;

INSERT INTO cbc_bizphoto VALUES ('7','1','2007/02/13/4e3015818e65befa9c3abecba16cf228.jpg');

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 AUTO_INCREMENT=2;

INSERT INTO cbc_bizpoint VALUES ('1','2','1','6','6','6');

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',
  PRIMARY KEY  (`ptid`),
  KEY `bizid` (`bizid`)
) TYPE=MyISAM AUTO_INCREMENT=1;


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 AUTO_INCREMENT=1;


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 AUTO_INCREMENT=3;

INSERT INTO cbc_comment VALUES ('1','1','2','1','admin','','','dsdsfsdfdsf','0','0','1173164359','127.0.0.1');
INSERT INTO cbc_comment VALUES ('2','1','2','1','admin','2','3','fdfddfddfgd','0','0','1173164437','127.0.0.1');

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 AUTO_INCREMENT=1;


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 AUTO_INCREMENT=82;

INSERT INTO cbc_fleicate VALUES ('1','房产信息','0','0');
INSERT INTO cbc_fleicate VALUES ('2','生活服务','0','5');
INSERT INTO cbc_fleicate VALUES ('3','跳蚤市场','0','2');
INSERT INTO cbc_fleicate VALUES ('4','交友征婚','0','0');
INSERT INTO cbc_fleicate VALUES ('5','维权投诉','0','0');
INSERT INTO cbc_fleicate VALUES ('6','企业招聘','0','0');
INSERT INTO cbc_fleicate VALUES ('7','个人求职','0','0');
INSERT INTO cbc_fleicate VALUES ('8','兼职信息','0','0');
INSERT INTO cbc_fleicate VALUES ('9','个人出租','1','0');
INSERT INTO cbc_fleicate VALUES ('10','中介出租','1','0');
INSERT INTO cbc_fleicate VALUES ('11','房屋求租','1','0');
INSERT INTO cbc_fleicate VALUES ('12','房屋合租','1','0');
INSERT INTO cbc_fleicate VALUES ('13','个人出售','1','0');
INSERT INTO cbc_fleicate VALUES ('14','中介出售','1','0');
INSERT INTO cbc_fleicate VALUES ('15','房屋求购','1','0');
INSERT INTO cbc_fleicate VALUES ('16','商业房屋租售','1','0');
INSERT INTO cbc_fleicate VALUES ('17','装修装饰','1','0');
INSERT INTO cbc_fleicate VALUES ('18','其它','1','0');
INSERT INTO cbc_fleicate VALUES ('19','教育培训','2','5');
INSERT INTO cbc_fleicate VALUES ('20','娱乐/餐饮','2','0');
INSERT INTO cbc_fleicate VALUES ('21','家教服务','2','0');
INSERT INTO cbc_fleicate VALUES ('22','家政/保姆','2','0');
INSERT INTO cbc_fleicate VALUES ('23','搬家快递','2','0');
INSERT INTO cbc_fleicate VALUES ('24','维修服务','2','0');
INSERT INTO cbc_fleicate VALUES ('25','旅游服务','2','0');
INSERT INTO cbc_fleicate VALUES ('26','网络服务','2','0');
INSERT INTO cbc_fleicate VALUES ('27','寻人寻物','2','0');
INSERT INTO cbc_fleicate VALUES ('28','商业合作','2','0');
INSERT INTO cbc_fleicate VALUES ('29','打折促销','2','0');
INSERT INTO cbc_fleicate VALUES ('30','其它服务','2','0');
INSERT INTO cbc_fleicate VALUES ('31','票务','3','2');
INSERT INTO cbc_fleicate VALUES ('32','电脑/配件','3','0');
INSERT INTO cbc_fleicate VALUES ('33','手机/通信产品','3','0');
INSERT INTO cbc_fleicate VALUES ('34','数码产品/摄影','3','0');
INSERT INTO cbc_fleicate VALUES ('35','家具/家电','3','0');
INSERT INTO cbc_fleicate VALUES ('36','图书音像','3','0');
INSERT INTO cbc_fleicate VALUES ('37','化妆/服装','3','0');
INSERT INTO cbc_fleicate VALUES ('38','成人用品','3','0');
INSERT INTO cbc_fleicate VALUES ('39','办公/文体用品','3','0');
INSERT INTO cbc_fleicate VALUES ('40','其它物品','3','0');
INSERT INTO cbc_fleicate VALUES ('41','兴趣交友','4','0');
INSERT INTO cbc_fleicate VALUES ('42','男找女友','4','0');
INSERT INTO cbc_fleicate VALUES ('43','女找男友','4','0');
INSERT INTO cbc_fleicate VALUES ('44','同乡会','4','0');
INSERT INTO cbc_fleicate VALUES ('45','男士征婚','4','0');
INSERT INTO cbc_fleicate VALUES ('46','女士征婚','4','0');
INSERT INTO cbc_fleicate VALUES ('47','活动伙伴','4','0');
INSERT INTO cbc_fleicate VALUES ('48','其它','4','0');
INSERT INTO cbc_fleicate VALUES ('49','乱收费','5','0');
INSERT INTO cbc_fleicate VALUES ('50','服务恶劣','5','0');
INSERT INTO cbc_fleicate VALUES ('51','产品质量','5','0');
INSERT INTO cbc_fleicate VALUES ('52','虚假广告','5','0');
INSERT INTO cbc_fleicate VALUES ('53','公共道德','5','0');
INSERT INTO cbc_fleicate VALUES ('54','违法现象','5','0');
INSERT INTO cbc_fleicate VALUES ('55','奇闻轶事','5','0');
INSERT INTO cbc_fleicate VALUES ('56','感谢表扬','5','0');
INSERT INTO cbc_fleicate VALUES ('57','其他','5','0');
INSERT INTO cbc_fleicate VALUES ('58','业务/销售','6','0');
INSERT INTO cbc_fleicate VALUES ('59','市场/管理','6','0');
INSERT INTO cbc_fleicate VALUES ('60','软件/网络','6','0');
INSERT INTO cbc_fleicate VALUES ('61','广告/设计','6','0');
INSERT INTO cbc_fleicate VALUES ('62','行政/文秘','6','0');
INSERT INTO cbc_fleicate VALUES ('63','财务/会计','6','0');
INSERT INTO cbc_fleicate VALUES ('64','客服/编辑','6','0');
INSERT INTO cbc_fleicate VALUES ('65','其他','6','0');
INSERT INTO cbc_fleicate VALUES ('66','普通求职','7','0');
INSERT INTO cbc_fleicate VALUES ('67','实习/应届','7','0');
INSERT INTO cbc_fleicate VALUES ('68','高级求职','7','0');
INSERT INTO cbc_fleicate VALUES ('69','带车求职','7','0');
INSERT INTO cbc_fleicate VALUES ('70','其他','7','0');
INSERT INTO cbc_fleicate VALUES ('71','家教/辅导','8','0');
INSERT INTO cbc_fleicate VALUES ('72','电脑/网站','8','0');
INSERT INTO cbc_fleicate VALUES ('73','动画/设计','8','0');
INSERT INTO cbc_fleicate VALUES ('74','翻译/录入','8','0');
INSERT INTO cbc_fleicate VALUES ('75','写作/教育','8','0');
INSERT INTO cbc_fleicate VALUES ('76','广告/艺术','8','0');
INSERT INTO cbc_fleicate VALUES ('77','歌手/教练','8','0');
INSERT INTO cbc_fleicate VALUES ('78','财务/会计','8','0');
INSERT INTO cbc_fleicate VALUES ('79','律师/顾问','8','0');