INSERT INTO sys_dict_type ( dict_name, dict_type, status, create_by, create_time, update_by, update_time, remark) VALUES('地图拓客货币币种码值', 'cust_map_cur_metric', '0', 'admin', '2025-05-23 10:06:15', '', NULL, NULL);

INSERT INTO sys_dict_data (dict_sort, dict_label, dict_value, dict_type, css_class, list_class, is_default, status, create_by, create_time, update_by, update_time, remark) values
(0, '人民币元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '加元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '哥伦比亚比索', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '德国马克', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '挪威马克', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '新加坡元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '日元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '欧元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '法国法郎', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '港元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '澳大利亚元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '瑞典克朗', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '瑞士法郎', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '美元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '英镑', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '阿富汗尼', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '韩元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '新台币', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL),
(0, '新西兰元', '101', 'cust_map_cur_metric', NULL, 'default', 'N', '0', 'admin', '2025-05-23 10:14:00', '', NULL, NULL);

-- dept_address definition

CREATE TABLE `dept_address` (
  `dept_id` bigint(21) NOT NULL COMMENT '部门id',
  `address` longtext,
  `city` varchar(100) DEFAULT NULL,
  `lng` decimal(15,8) DEFAULT NULL,
  `lat` decimal(15,8) DEFAULT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构地址表';

CREATE TABLE cust_map_favorite(
    id bigint(21) NOT NULL   COMMENT '主键' ,
    user_name VARCHAR(100)    COMMENT '用户名' ,
    cust_name VARCHAR(100)    COMMENT '企业名称' ,
    lp_name VARCHAR(100)    COMMENT '法人姓名' ,
    phone_number VARCHAR(100)    COMMENT '联系方式' ,
    regist_capi_show VARCHAR(100)    COMMENT '注册资本展示字段' ,
    province VARCHAR(100)    COMMENT '省' ,
    city VARCHAR(100)    COMMENT '市' ,
    address_detail longtext    COMMENT '详细地址' ,
    longitude DECIMAL(15,15)    COMMENT '经度' ,
    latitude DECIMAL(15,15)    COMMENT '纬度' ,
    start_date DATE    COMMENT '成立年限' ,
    PRIMARY KEY (id)
)  COMMENT = '地图拓客收藏表';

INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965000,'临海市大洋街道河阳路299号','台州市',121.19534176,28.88832500),
	 (965010,'临海市大洋街道河阳路299号','台州市',121.19534176,28.88832500),
	 (965013,'临海市凯歌路2号','台州市',121.15229963,28.86509170),
	 (965020,'临海市古城街道巾山中路2号','台州市',121.14417311,28.85059030),
	 (965022,'临海市古城街道洪池路108号、110号、112号','台州市',121.13400420,28.85616354),
	 (965030,'临海市大洋街道柏叶中路291号','台州市',121.18192853,28.87585265),
	 (965035,'临海市大田街道东方大道659号','台州市',121.20797193,28.91396531),
	 (965036,'临海市大洋街道绿化村','台州市',121.16425365,28.88920773),
	 (965040,'临海市江南街道江南大道4号','台州市',121.14258149,28.82589609),
	 (965041,'临海市江南街道小溪村1-98号','台州市',121.13226023,28.78969755);
INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965042,'临海市古城街道两水村','台州市',121.16166680,28.84179629),
	 (965050,'临海市大田街道奋进东街258号','台州市',121.21702020,28.91170836),
	 (965052,'临海市大田街道奋进西街119号','台州市',121.20810766,28.91187499),
	 (965060,'临海市汛桥镇汛汇路2号','台州市',121.18481972,28.79844536),
	 (965070,'临海市东塍镇川津路427号8－12','台州市',121.26984057,28.93071358),
	 (965071,'临海市东塍镇屈家村2－157A','台州市',121.26016734,28.94013888),
	 (965072,'临海市东塍镇康一村371号','台州市',121.40748541,28.93156402),
	 (965080,'临海市邵家渡街道邵临东路54号','台州市',121.22261494,28.86553519),
	 (965081,'临海市邵家渡街道中台村265号','台州市',121.20895872,28.82085263),
	 (965090,'临海市小芝镇溪滨北路1号','台州市',121.46179992,28.85924349);
INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965100,'临海市杜桥镇滨海路599号','台州市',121.50550545,28.75783738),
	 (965102,'临海市杜桥镇西岸村4-82号','台州市',121.53366274,28.73910159),
	 (965104,'临海市杜桥镇汾东村15-14、15-15号','台州市',121.48521237,28.74923323),
	 (965108,'临海市杜桥镇杜下浦村','台州市',121.54213682,28.72408230),
	 (965109,'临海市杜桥镇下街路耀达商城16幢','台州市',121.51490541,28.76573292),
	 (965110,'浙江省临海市上盘镇西大路10号','台州市',121.58828484,28.75916566),
	 (965111,'浙江省临海市上盘镇银山街267号','台州市',121.60305280,28.75354870),
	 (965112,'浙江省临海市台州湾经济技术开发区乐安路77、79、81、83号','台州市',121.64550133,28.72767696),
	 (965120,'临海市桃渚镇东洋大道北7号','台州市',121.59241345,28.82726747),
	 (965121,'临海市桃渚镇连盘南路124号','台州市',121.58664399,28.78455584);
INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965122,'临海市桃渚镇顺南路119号','台州市',121.60391437,28.83248647),
	 (965123,'临海市桃渚镇项庄村','台州市',121.62403138,28.82529239),
	 (965124,'临海市桃渚镇城外村桃江路61号','台州市',121.54135916,28.83171938),
	 (965130,'临海市尤溪镇义城路205号','台州市',121.11074788,28.74381794),
	 (965140,'临海市涌泉镇灵泉街171号','台州市',121.32395548,28.76260117),
	 (965141,'临海市涌泉镇后泾村','台州市',121.35571399,28.72437942),
	 (965142,'临海市涌泉镇管岙村1-92号','台州市',121.25998355,28.78789657),
	 (965150,'临海市沿江镇水洋大道49号','台州市',121.24849270,28.74755964),
	 (965151,'临海市沿江镇西岑村4-291A','台州市',121.30993131,28.73750480),
	 (965152,'临海市沿江镇下岙村83号','台州市',121.30750795,28.70469465);
INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965153,'临海市沿江镇长甸三村49号','台州市',121.28051118,28.74876826),
	 (965160,'河头镇人民路82号','台州市',121.10915626,28.99917355),
	 (965161,'河头镇兰桥村26-1号','台州市',121.14503737,29.01422584),
	 (965170,'临海市括苍镇塍园路28号','台州市',120.99303455,28.86399880),
	 (965171,'临海市括苍镇小海门村3-197A','台州市',120.98924397,28.87119176),
	 (965180,'临海市永丰镇留贤村1-188号','台州市',121.07890061,28.89838696),
	 (965182,'临海市永丰镇赤缪一村赤缪街115号','台州市',121.07668503,28.89874271),
	 (965183,'临海市永丰镇更楼村3-68号','台州市',121.04637306,28.88508833),
	 (965190,'浙江省临海市白水洋镇黄沙大道81号','台州市',120.91519961,28.90253586),
	 (965191,'浙江省临海市白水洋镇永安路170号','台州市',120.90808171,28.90108097);
INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965192,'浙江省临海市白水洋镇中和路117号','台州市',120.96164309,28.95953814),
	 (965193,'浙江省临海市白水洋镇店前村1－2E','台州市',120.94016855,28.95268686),
	 (965194,'浙江省临海市白水洋镇黄坦村','台州市',120.91435125,28.90211277),
	 (965850,'临海市汇溪镇两头门村甬临路3号','台州市',121.22307505,28.95837869),
	 (965870,'临海市古城街道鹿城路170号','台州市',121.13738389,28.84895560),
	 (965871,'临海市古城街道赤城路50-20号','台州市',121.12452133,28.85063894),
	 (965872,'临海市古城街道巾山西路59号','台州市',121.12246636,28.84882874),
	 (965880,'临海市大洋街道大洋西路309号','台州市',121.15621300,28.86242371),
	 (965881,'临海市大洋街道东方大道120号','台州市',121.20797193,28.91396531),
	 (965890,'临海市杜桥镇府前街372号','台州市',121.50395605,28.76635382);
INSERT INTO dept_address (dept_id,address,city,lng,lat) VALUES
	 (965891,'临海市杜桥镇解放街269号','台州市',121.50254679,28.76962042),
	 (965892,'临海市杜桥镇三房村2-145号','台州市',121.56718993,28.75758802),
	 (965893,'临海市杜桥镇溪口村2-105号','台州市',121.42106787,28.78712796);

ALTER TABLE visit_trajectory_965 ADD head_id BIGINT NULL;
ALTER TABLE visit_trajectory_965 ADD branch_id BIGINT NULL;
ALTER TABLE visit_trajectory_965 ADD outlet_id BIGINT NULL;
ALTER TABLE visit_trajectory_965 ADD user_name VARCHAR(50) NULL;



--szq

ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_365cnt varchar(100) NULL COMMENT '近365天已走访人数';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_180cnt varchar(100) NULL COMMENT '近180天已走访人数';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_90cnt varchar(100) NULL COMMENT '近90天已走访人数';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_30cnt varchar(100) NULL COMMENT '近30天已走访人数';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_365rt varchar(100) NULL COMMENT '近365天走访率';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_180rt varchar(100) NULL COMMENT '近180天走访率';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_90rt varchar(100) NULL COMMENT '近90天走访率';
ALTER TABLE ibs.grid_shape_count_lingshou_965 ADD zf_30rt varchar(100) NULL COMMENT '近30天走访率';

ALTER TABLE ibs.grid_shape_cust_lingshou_965 ADD is_365zf varchar(100) NULL COMMENT '近365天有无走访';
ALTER TABLE ibs.grid_shape_cust_lingshou_965 ADD is_180zf varchar(100) NULL COMMENT '近180天有无走访';
ALTER TABLE ibs.grid_shape_cust_lingshou_965 ADD is_90zf varchar(100) NULL COMMENT '近90天有无走访';
ALTER TABLE ibs.grid_shape_cust_lingshou_965 ADD is_30zf varchar(100) NULL COMMENT '近30天有无走访';