070319_emibzt5o-2.sql

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

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



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');
INSERT INTO cbc_fleicate VALUES ('80','医疗/护理','8','0');
INSERT INTO cbc_fleicate VALUES ('81','其他','8','0');

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

INSERT INTO cbc_fleiinfo VALUES ('1','3','31','aaaaaaaa','aaaaaaaaaaaaa','2007/02/14/9d3138b3a4bce40595a7ca2e58e04acc.jpg','1','','','0','1','1171390652','127.0.0.1');
INSERT INTO cbc_fleiinfo VALUES ('6','2','19','aaa','aaa','','1','','','0','1','1173860386','127.0.0.1');
INSERT INTO cbc_fleiinfo VALUES ('7','3','31','sdf','sdfsdf','','1','','','0','1','1174198896','127.0.0.1');
INSERT INTO cbc_fleiinfo VALUES ('3','2','19','aaaaaaa','bbbbbbbb','','1','','','0','1','1172423319','127.0.0.1');
INSERT INTO cbc_fleiinfo VALUES ('4','2','19','eee','eeeeeeeeeeeeeee','','1','','','0','1','1172424232','127.0.0.1');
INSERT INTO cbc_fleiinfo VALUES ('5','2','19','dbc','ccc','2007/02/26/867f1faeaa31a2e1b7c293ec5b89a147.jpg','1','','','0','1','1172470721','127.0.0.1');
INSERT INTO cbc_fleiinfo VALUES ('8','2','19','abc','sdfsdf','','1','','','0','1','1174198948','127.0.0.1');

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


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',
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `uname` varchar(16) NOT NULL default '',
  `addtime` int(10) unsigned NOT NULL default '0',
  `allowtime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`fid`),
  KEY `uid` (`uid`)
) TYPE=MyISAM AUTO_INCREMENT=1;


DROP TABLE IF EXISTS cbc_message;
CREATE TABLE `cbc_message` (
  `messid` int(10) unsigned NOT NULL auto_increment,
  `fromuid` mediumint(8) unsigned NOT NULL default '0',
  `fromuser` varchar(16) NOT NULL default '',
  `touid` mediumint(8) unsigned NOT NULL default '0',
  `touser` varchar(16) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `content` mediumtext NOT NULL,
  `viewed` tinyint(1) NOT NULL default '0',
  `sys` tinyint(1) NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  `fromdel` tinyint(1) NOT NULL default '0',
  `todel` tinyint(1) NOT NULL default '0',
  `jumped` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`messid`),
  KEY `fromuid` (`fromuid`,`touid`),
  KEY `touid` (`touid`),
  KEY `sys` (`sys`)
) TYPE=MyISAM AUTO_INCREMENT=1;


DROP TABLE IF EXISTS cbc_newaction;
CREATE TABLE `cbc_newaction` (
  `naid` int(10) unsigned NOT NULL auto_increment,
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `username` varchar(20) NOT NULL default '',
  `title` varchar(200) NOT NULL default '',
  `id` int(10) unsigned NOT NULL default '0',
  `type` tinyint(1) unsigned NOT NULL default '0',
  `dateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`naid`)
) TYPE=MyISAM AUTO_INCREMENT=11;

INSERT INTO cbc_newaction VALUES ('1','1','admin','aaaaaaaa','1','2','1171390652');
INSERT INTO cbc_newaction VALUES ('7','1','admin','eeee','2','1','1173164437');
INSERT INTO cbc_newaction VALUES ('3','1','admin','aaaaaaa','3','2','1172423319');
INSERT INTO cbc_newaction VALUES ('6','1','admin','eeee','2','1','1173164359');
INSERT INTO cbc_newaction VALUES ('8','1','admin','aaa','6','2','1173860386');
INSERT INTO cbc_newaction VALUES ('9','1','admin','sdf','7','2','1174198896');
INSERT INTO cbc_newaction VALUES ('10','1','admin','abc','8','2','1174198948');

DROP TABLE IF EXISTS cbc_settings;
CREATE TABLE `cbc_settings` (
  `variable` varchar(32) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`variable`)
) TYPE=MyISAM;

INSERT INTO cbc_settings VALUES ('webname','新衡阳');
INSERT INTO cbc_settings VALUES ('citypy','hengyang');
INSERT INTO cbc_settings VALUES ('icp','123');
INSERT INTO cbc_settings VALUES ('webclosed','0');
INSERT INTO cbc_settings VALUES ('closedreason','');
INSERT INTO cbc_settings VALUES ('censoruser','电脑*\r\nb\r\nc');
INSERT INTO cbc_settings VALUES ('seccodestatus','0');
INSERT INTO cbc_settings VALUES ('webmsgopen','1');
INSERT INTO cbc_settings VALUES ('webmsglist','10');
INSERT INTO cbc_settings VALUES ('webcommentlist','10');
INSERT INTO cbc_settings VALUES ('webcommentchar','10');
INSERT INTO cbc_settings VALUES ('webbizlist','10');
INSERT INTO cbc_settings VALUES ('webcouponlist','10');
INSERT INTO cbc_settings VALUES ('webfleilist','10');
INSERT INTO cbc_settings VALUES ('weballcommentlist','10');
INSERT INTO cbc_settings VALUES ('weballcommentchar','7');
INSERT INTO cbc_settings VALUES ('webuserlist','15');
INSERT INTO cbc_settings VALUES ('webdzapi','1');
INSERT INTO cbc_settings VALUES ('webdzurl','http://localhost/dz55/');
INSERT INTO cbc_settings VALUES ('webdzapikey','1234567890');
INSERT INTO cbc_settings VALUES ('webindexdianp','1');
INSERT INTO cbc_settings VALUES ('webuserweek','300');
INSERT INTO cbc_settings VALUES ('webfleitxtchar','111');
INSERT INTO cbc_settings VALUES ('webfleicut','abc|aaa');
INSERT INTO cbc_settings VALUES ('banip','');
INSERT INTO cbc_settings VALUES ('search_space','30');
INSERT INTO cbc_settings VALUES ('search_life','3600');

DROP TABLE IF EXISTS cbc_searchindex;
CREATE TABLE `cbc_searchindex` (
  `sid` mediumint(8) unsigned NOT NULL auto_increment,
  `stype` tinyint(1) unsigned NOT NULL default '0',
  `keywords` varchar(200) NOT NULL default '',
  `useip` varchar(15) NOT NULL default '',
  `dateline` int(10) unsigned NOT NULL default '0',
  `expiration` int(10) unsigned NOT NULL default '0',
  `nums` smallint(6) unsigned NOT NULL default '0',
  `tids` text NOT NULL,
  PRIMARY KEY  (`sid`),
  KEY `stype` (`stype`)
) TYPE=MyISAM AUTO_INCREMENT=8;

INSERT INTO cbc_searchindex VALUES ('1','1','aa','127.0.0.1','1173860808','1173868008','3','0,1,6,3');
INSERT INTO cbc_searchindex VALUES ('2','0','sdfesdf','127.0.0.1','1173860843','1173868043','0','0');
INSERT INTO cbc_searchindex VALUES ('3','0','abc','127.0.0.1','1173860986','1173868186','0','0');
INSERT INTO cbc_searchindex VALUES ('4','0','abcd','127.0.0.1','1173861333','1173868533','0','0');
INSERT INTO cbc_searchindex VALUES ('5','0','搜索:如蛋糕,搜索商家:如肯德基...','127.0.0.1','1173861434','1173868634','0','0');
INSERT INTO cbc_searchindex VALUES ('6','0','ee','127.0.0.1','1173861753','1173865353','1','0,2');
INSERT INTO cbc_searchindex VALUES ('7','0','sdf','127.0.0.1','1173862881','1173866481','0','0');

DROP TABLE IF EXISTS cbc_users;
CREATE TABLE `cbc_users` (
  `uid` mediumint(8) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(32) NOT NULL default '',
  `nickname` varchar(16) NOT NULL default '',
  `realname` varchar(16) NOT NULL default '',
  `gender` tinyint(1) NOT NULL default '0',
  `email` varchar(50) NOT NULL default '',
  `face` varchar(150) NOT NULL default '',
  `age` varchar(10) NOT NULL default '',
  `userfrom` smallint(5) unsigned NOT NULL default '0',
  `bizname` varchar(150) NOT NULL default '',
  `bizboss` varchar(16) NOT NULL default '',
  `biztel` varchar(30) NOT NULL default '',
  `utype` tinyint(1) NOT NULL default '0',
  `regip` varchar(15) NOT NULL default '',
  `regdateline` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`uid`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=7;

INSERT INTO cbc_users VALUES ('1','admin','21232f297a57a5a743894a0e4a801fc3','','','0','[e-mail]','','25','1','','','','0','127.0.0.1','1173715006');
INSERT INTO cbc_users VALUES ('2','中文','0b4e7a0e5fe84ad35fb5f95b9ceeac79','','','0','[e-mail]','','25','1','','','','0','127.0.0.1','1173720684');
INSERT INTO cbc_users VALUES ('3','达到','74b87337454200d4d33f80c4663dc5e5','','','0','[e-mail]','','25','1','','','','0','127.0.0.1','1173720809');
INSERT INTO cbc_users VALUES ('4','eeww','0b4e7a0e5fe84ad35fb5f95b9ceeac79','','','0','[e-mail]','','25','1','','','','0','127.0.0.1','1173721645');
INSERT INTO cbc_users VALUES ('5','eeqq','74b87337454200d4d33f80c4663dc5e5','','','0','[e-mail]','','25','1','','','','0','127.0.0.1','1173721861');
INSERT INTO cbc_users VALUES ('6','eeqwer','74b87337454200d4d33f80c4663dc5e5','','','0','[e-mail]','','25','1','','','','0','127.0.0.1','1173721895');