DROP TABLE IF EXISTS `business_areas`;
CREATE TABLE `business_areas` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`did` int(11) unsigned NOT NULL COMMENT '区ID',
`name` VARCHAR(50) NOT NULL COMMENT '商圈名',
`flag` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:有效,其它无效',
`ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`utime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='商圈数据表';
INSERT INTO `business_areas` (did, name) VALUES (110101, '安定门');
INSERT INTO `business_areas` (did, name) VALUES (110101, '北新桥/簋街');
INSERT INTO `business_areas` (did, name) VALUES (110101, '朝阳门');
INSERT INTO `business_areas` (did, name) VALUES (110101, '崇文门');
INSERT INTO `business_areas` (did, name) VALUES (110101, '崇文门新世界');
INSERT INTO `business_areas` (did, name) VALUES (110101, '东四');
INSERT INTO `business_areas` (did, name) VALUES (110101, '东四十条');
INSERT INTO `business_areas` (did, name) VALUES (110101, '东直门');
INSERT INTO `business_areas` (did, name) VALUES (110101, '广渠门');
INSERT INTO `business_areas` (did, name) VALUES (110101, '和平里');
INSERT INTO `business_areas` (did, name) VALUES (110101, '建国门/北京站');
INSERT INTO `business_areas` (did, name) VALUES (110101, '南锣鼓巷');
INSERT INTO `business_areas` (did, name) VALUES (110101, '沙子口');
INSERT INTO `business_areas` (did, name) VALUES (110101, '天坛');
INSERT INTO `business_areas` (did, name) VALUES (110101, '王府井/东单');
INSERT INTO `business_areas` (did, name) VALUES (110101, '雍和宫');
INSERT INTO `business_areas` (did, name) VALUES (110101, '左安门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '白纸坊');
INSERT INTO `business_areas` (did, name) VALUES (110102, '菜市口/陶然亭');
INSERT INTO `business_areas` (did, name) VALUES (110102, '德外大街');
INSERT INTO `business_areas` (did, name) VALUES (110102, '地安门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '阜成门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '复兴门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '广内大街');
INSERT INTO `business_areas` (did, name) VALUES (110102, '广外大街');
INSERT INTO `business_areas` (did, name) VALUES (110102, '和平门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '后海/什刹海');
INSERT INTO `business_areas` (did, name) VALUES (110102, '虎坊桥');
INSERT INTO `business_areas` (did, name) VALUES (110102, '金融街');
INSERT INTO `business_areas` (did, name) VALUES (110102, '牛街');
INSERT INTO `business_areas` (did, name) VALUES (110102, '前门/大栅栏');
INSERT INTO `business_areas` (did, name) VALUES (110102, '西便门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '西单');
INSERT INTO `business_areas` (did, name) VALUES (110102, '西四');
INSERT INTO `business_areas` (did, name) VALUES (110102, '西直门/动物园');
INSERT INTO `business_areas` (did, name) VALUES (110102, '新街口');
INSERT INTO `business_areas` (did, name) VALUES (110102, '宣武门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '右安门');
INSERT INTO `business_areas` (did, name) VALUES (110102, '月坛');
INSERT INTO `business_areas` (did, name) VALUES (110105, '安贞');
INSERT INTO `business_areas` (did, name) VALUES (110105, '八里庄');
INSERT INTO `business_areas` (did, name) VALUES (110105, '百子湾');
INSERT INTO `business_areas` (did, name) VALUES (110105, '北京东站');
INSERT INTO `business_areas` (did, name) VALUES (110105, '北京欢乐谷');
INSERT INTO `business_areas` (did, name) VALUES (110105, '北沙滩');
INSERT INTO `business_areas` (did, name) VALUES (110105, '北苑家园');
INSERT INTO `business_areas` (did, name) VALUES (110105, '常营');
INSERT INTO `business_areas` (did, name) VALUES (110105, '朝外大街');
INSERT INTO `business_areas` (did, name) VALUES (110105, '朝阳大悦城');
INSERT INTO `business_areas` (did, name) VALUES (110105, '朝阳公园');
INSERT INTO `business_areas` (did, name) VALUES (110105, '传媒大学');
INSERT INTO `business_areas` (did, name) VALUES (110105, '大屯');
INSERT INTO `business_areas` (did, name) VALUES (110105, '大望路');
INSERT INTO `business_areas` (did, name) VALUES (110105, '东坝');
INSERT INTO `business_areas` (did, name) VALUES (110105, '对外经贸');
INSERT INTO `business_areas` (did, name) VALUES (110105, '高碑店');
INSERT INTO `business_areas` (did, name) VALUES (110105, '工体');
INSERT INTO `business_areas` (did, name) VALUES (110105, '管庄');
INSERT INTO `business_areas` (did, name) VALUES (110105, '国贸');
INSERT INTO `business_areas` (did, name) VALUES (110105, '建外大街');
INSERT INTO `business_areas` (did, name) VALUES (110105, '劲松');
INSERT INTO `business_areas` (did, name) VALUES (110105, '酒仙桥');
INSERT INTO `business_areas` (did, name) VALUES (110105, '蓝色港湾');
INSERT INTO `business_areas` (did, name) VALUES (110105, '立水桥');
INSERT INTO `business_areas` (did, name) VALUES (110105, '亮马桥');
INSERT INTO `business_areas` (did, name) VALUES (110105, '鸟巢/水立方');
INSERT INTO `business_areas` (did, name) VALUES (110105, '农业展览馆');
INSERT INTO `business_areas` (did, name) VALUES (110105, '潘家园');
INSERT INTO `business_areas` (did, name) VALUES (110105, '三里屯');
INSERT INTO `business_areas` (did, name) VALUES (110105, '三元桥');
INSERT INTO `business_areas` (did, name) VALUES (110105, '十八里店');
INSERT INTO `business_areas` (did, name) VALUES (110105, '十里堡');
INSERT INTO `business_areas` (did, name) VALUES (110105, '十里河');
INSERT INTO `business_areas` (did, name) VALUES (110105, '石佛营');
INSERT INTO `business_areas` (did, name) VALUES (110105, '世贸天阶');
INSERT INTO `business_areas` (did, name) VALUES (110105, '双井');
INSERT INTO `business_areas` (did, name) VALUES (110105, '双桥');
INSERT INTO `business_areas` (did, name) VALUES (110105, '四惠');
INSERT INTO `business_areas` (did, name) VALUES (110105, '四惠东');
INSERT INTO `business_areas` (did, name) VALUES (110105, '太阳宫');
INSERT INTO `business_areas` (did, name) VALUES (110105, '甜水园');
INSERT INTO `business_areas` (did, name) VALUES (110105, '团结湖');
INSERT INTO `business_areas` (did, name) VALUES (110105, '望京');
INSERT INTO `business_areas` (did, name) VALUES (110105, '霄云路');
INSERT INTO `business_areas` (did, name) VALUES (110105, '小营');
INSERT INTO `business_areas` (did, name) VALUES (110105, '亚运村');
INSERT INTO `business_areas` (did, name) VALUES (110105, '燕莎');
INSERT INTO `business_areas` (did, name) VALUES (110105, '姚家园');
INSERT INTO `business_areas` (did, name) VALUES (110105, '悠唐生活广场');
INSERT INTO `business_areas` (did, name) VALUES (110105, '左家庄');
INSERT INTO `business_areas` (did, name) VALUES (110106, '北大地/万丰路');
INSERT INTO `business_areas` (did, name) VALUES (110106, '北京南站/开阳里');
INSERT INTO `business_areas` (did, name) VALUES (110106, '北京西站/六里桥');
INSERT INTO `business_areas` (did, name) VALUES (110106, '草桥/公益西桥');
INSERT INTO `business_areas` (did, name) VALUES (110106, '大红门');
INSERT INTO `business_areas` (did, name) VALUES (110106, '方庄/蒲黄榆');
INSERT INTO `business_areas` (did, name) VALUES (110106, '分钟寺/成寿寺');
INSERT INTO `business_areas` (did, name) VALUES (110106, '花乡/新发地');
INSERT INTO `business_areas` (did, name) VALUES (110106, '看丹桥');
INSERT INTO `business_areas` (did, name) VALUES (110106, '丽泽桥/丰管路');
INSERT INTO `business_areas` (did, name) VALUES (110106, '刘�
评论3
最新资源