070319_emibzt5o-1.sql

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

# Identify: MTE3NDMwMzY0MiwxLjAuMCwx
# <?exit();?>
# Socity! Multi-Volume Data Dump Vol.1
# Time: 2007-03-19 19:27:22
# Table Prefix: cbc_
# --------------------------------------------------------


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

INSERT INTO cbc_admin VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3','10');

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


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

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

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;

INSERT INTO cbc_bizcard VALUES ('2','1173157663');

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

INSERT INTO cbc_bizcate VALUES ('1','餐饮','0','0','1');
INSERT INTO cbc_bizcate VALUES ('2','娱乐','0','0','0');
INSERT INTO cbc_bizcate VALUES ('3','旅游','0','0','1');
INSERT INTO cbc_bizcate VALUES ('4','购物','0','0','0');
INSERT INTO cbc_bizcate VALUES ('5','生活','0','0','0');
INSERT INTO cbc_bizcate VALUES ('6','综合服务','0','0','0');
INSERT INTO cbc_bizcate VALUES ('7','快餐','0','1','1');
INSERT INTO cbc_bizcate VALUES ('8','小吃/面','0','1','1');
INSERT INTO cbc_bizcate VALUES ('9','火锅/砂锅','0','1','0');
INSERT INTO cbc_bizcate VALUES ('10','蛋糕/甜点','0','1','0');
INSERT INTO cbc_bizcate VALUES ('11','日韩菜','0','1','0');
INSERT INTO cbc_bizcate VALUES ('12','湘菜','0','1','0');
INSERT INTO cbc_bizcate VALUES ('13','淇淋/冷饮','0','1','0');
INSERT INTO cbc_bizcate VALUES ('14','烧烤','0','1','0');
INSERT INTO cbc_bizcate VALUES ('15','粤港菜','0','1','0');
INSERT INTO cbc_bizcate VALUES ('16','西餐','0','1','0');
INSERT INTO cbc_bizcate VALUES ('17','川菜','0','1','0');
INSERT INTO cbc_bizcate VALUES ('18','家常菜','0','1','0');
INSERT INTO cbc_bizcate VALUES ('19','网吧','0','2','0');
INSERT INTO cbc_bizcate VALUES ('20','影剧院','0','2','0');
INSERT INTO cbc_bizcate VALUES ('21','书店/音像','0','2','0');
INSERT INTO cbc_bizcate VALUES ('22','健身/体育场所','0','2','0');
INSERT INTO cbc_bizcate VALUES ('23','美容美发美体','0','2','0');
INSERT INTO cbc_bizcate VALUES ('24','书店/音像','0','2','0');
INSERT INTO cbc_bizcate VALUES ('25','洗浴/按摩','0','2','0');
INSERT INTO cbc_bizcate VALUES ('26','KTV/迪吧','0','2','0');
INSERT INTO cbc_bizcate VALUES ('27','茶馆','0','2','0');
INSERT INTO cbc_bizcate VALUES ('28','咖啡馆','0','2','0');
INSERT INTO cbc_bizcate VALUES ('29','酒吧','0','2','0');
INSERT INTO cbc_bizcate VALUES ('30','景区/景点','0','3','1');
INSERT INTO cbc_bizcate VALUES ('31','户外游','0','3','1');
INSERT INTO cbc_bizcate VALUES ('32','车辆租赁','0','3','0');
INSERT INTO cbc_bizcate VALUES ('33','驾校','0','3','0');
INSERT INTO cbc_bizcate VALUES ('34','物流/快递','0','3','0');
INSERT INTO cbc_bizcate VALUES ('35','旅行社','0','3','0');
INSERT INTO cbc_bizcate VALUES ('36','票务中心','0','3','0');
INSERT INTO cbc_bizcate VALUES ('37','旅馆','0','3','0');
INSERT INTO cbc_bizcate VALUES ('38','交通信息','0','3','0');
INSERT INTO cbc_bizcate VALUES ('39','宾馆/酒店','0','3','0');
INSERT INTO cbc_bizcate VALUES ('40','建材/装潢','0','4','0');
INSERT INTO cbc_bizcate VALUES ('41','电器/家电','0','4','0');
INSERT INTO cbc_bizcate VALUES ('42','电脑硬件/软件','0','4','0');
INSERT INTO cbc_bizcate VALUES ('43','办公用品','0','4','0');
INSERT INTO cbc_bizcate VALUES ('44','家具/家居','0','4','0');
INSERT INTO cbc_bizcate VALUES ('45','花店/宠物','0','4','0');
INSERT INTO cbc_bizcate VALUES ('46','通讯/数码产品','0','4','0');
INSERT INTO cbc_bizcate VALUES ('47','车类','0','4','0');
INSERT INTO cbc_bizcate VALUES ('48','饰品/化妆品','0','4','0');
INSERT INTO cbc_bizcate VALUES ('49','服饰','0','4','0');
INSERT INTO cbc_bizcate VALUES ('50','礼品/工艺品','0','4','0');
INSERT INTO cbc_bizcate VALUES ('51','摄影/冲洗','0','5','0');
INSERT INTO cbc_bizcate VALUES ('52','眼镜店','0','5','0');
INSERT INTO cbc_bizcate VALUES ('53','文印/图文店','0','5','0');
INSERT INTO cbc_bizcate VALUES ('54','学校/培训','0','5','0');
INSERT INTO cbc_bizcate VALUES ('55','邮局','0','5','0');
INSERT INTO cbc_bizcate VALUES ('56','药店/医院','0','5','0');
INSERT INTO cbc_bizcate VALUES ('57','花店/礼品','0','5','0');
INSERT INTO cbc_bizcate VALUES ('58','银行','0','5','0');
INSERT INTO cbc_bizcate VALUES ('59','住宅区','0','5','0');
INSERT INTO cbc_bizcate VALUES ('60','便民商店','0','5','0');
INSERT INTO cbc_bizcate VALUES ('61','商品市场','0','5','0');
INSERT INTO cbc_bizcate VALUES ('62','综合店','0','5','0');
INSERT INTO cbc_bizcate VALUES ('63','宠物医院','0','6','0');
INSERT INTO cbc_bizcate VALUES ('64','保姆/钟点工','0','6','0');
INSERT INTO cbc_bizcate VALUES ('65','维修','0','6','0');
INSERT INTO cbc_bizcate VALUES ('66','婚介/婚庆礼仪','0','6','0');
INSERT INTO cbc_bizcate VALUES ('67','洗衣店','0','6','0');
INSERT INTO cbc_bizcate VALUES ('68','家教','0','6','0');
INSERT INTO cbc_bizcate VALUES ('69','送水/液化气','0','6','0');
INSERT INTO cbc_bizcate VALUES ('70','装修装璜','0','6','0');
INSERT INTO cbc_bizcate VALUES ('71','搬家','0','6','0');
INSERT INTO cbc_bizcate VALUES ('72','家政/保洁','0','6','0');

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


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

INSERT INTO cbc_bizinfo VALUES ('1','龙马旅游社','1','2007/02/13/4e3015818e65befa9c3abecba16cf228_s.jpg','','1','','','','','','','','d','7,8','1','7','1','1','1','2690980','11261365','','0');
INSERT INTO cbc_bizinfo VALUES ('2','eeee','3','','d','1','','','','','','','','dddd','30,31','','','','','16','2690734','11264110','联盟商家','0');

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 '',