⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 install.sql

📁 城市分类信息,门户网站,我做为地方信息网
💻 SQL
📖 第 1 页 / 共 2 页
字号:
🔍
12 
  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;


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;

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;


DROP TABLE IF EXISTS cbc_sessions;
CREATE TABLE cbc_sessions (
  flyid varchar(6) NOT NULL default '',
  ip1 tinyint(3) unsigned NOT NULL default '0',
  ip2 tinyint(3) unsigned NOT NULL default '0',
  ip3 tinyint(3) unsigned NOT NULL default '0',
  ip4 tinyint(3) unsigned NOT NULL default '0',
  username varchar(24) NOT NULL default '',
  uid mediumint(8) unsigned NOT NULL default '0',
  seccode varchar(4) NOT NULL default '0',
  lastactivity int(10) unsigned NOT NULL default '0',
  UNIQUE KEY flyid (flyid)
) TYPE=HEAP;


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;

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 '',
  fid mediumint(8) unsigned NOT NULL default '0',
  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),
  KEY fid (fid)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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;

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

INSERT INTO cbc_bizcate VALUES (1, '餐饮', 0, 0, 0);
INSERT INTO cbc_bizcate VALUES (2, '娱乐', 0, 0, 0);
INSERT INTO cbc_bizcate VALUES (3, '旅游', 0, 0, 0);
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, 0);
INSERT INTO cbc_bizcate VALUES (8, '小吃/面', 0, 1, 0);
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, 0);
INSERT INTO cbc_bizcate VALUES (31, '户外游', 0, 3, 0);
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, 2);
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);



INSERT INTO cbc_fleicate VALUES (1, '房产信息', 0, 0);
INSERT INTO cbc_fleicate VALUES (2, '生活服务', 0, 0);
INSERT INTO cbc_fleicate VALUES (3, '跳蚤市场', 0, 0);
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, 0);
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, 0);
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);

INSERT INTO cbc_settings VALUES ('webname', '新衡阳');
INSERT INTO cbc_settings VALUES ('citypy', 'hengyang');
INSERT INTO cbc_settings VALUES ('icp', '');
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', '0');
INSERT INTO cbc_settings VALUES ('webdzurl', '');
INSERT INTO cbc_settings VALUES ('webdzapikey', '');
INSERT INTO cbc_settings VALUES ('webindexdianp', '600');
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', '0');
INSERT INTO cbc_settings VALUES ('search_life', '0');
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -