etrade_admin_1.0.3.sql
4.77 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
USE dili_etrade;
CREATE TABLE `market_location` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`created_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`modified_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
`market_id` bigint(0) NOT NULL COMMENT '市场ID',
`market_code` varchar(20) NULL DEFAULT NULL,
`market_name` varchar(50) NULL DEFAULT NULL,
`market_gitude` decimal(10, 6) NULL DEFAULT NULL COMMENT '市场纬度',
`market_latitude` decimal(10, 6) NULL DEFAULT NULL COMMENT '市场经度',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_market_id` (`market_id`) USING BTREE COMMENT '市场ID索引'
) ENGINE = InnoDB COMMENT = '市场位置信息经纬度配置' ROW_FORMAT = Dynamic;
INSERT INTO `market_location` VALUES (1, '2023-10-30 11:39:28', '2023-10-30 11:39:28', 1, 'group', '集团', NULL, NULL);
INSERT INTO `market_location` VALUES (2, '2023-10-30 11:39:28', '2023-10-31 13:46:31', 2, 'hd', '哈尔滨哈达农副产品股份有限公司', 45.679112, 126.618306);
INSERT INTO `market_location` VALUES (3, '2023-10-30 11:39:28', '2023-10-30 15:07:45', 3, 'cd', '成都聚和', 30.587640, 104.302182);
INSERT INTO `market_location` VALUES (4, '2023-10-30 11:39:28', '2023-10-31 11:28:45', 4, 'qqhe', '齐齐哈尔哈达', 47.323586, 123.950500);
INSERT INTO `market_location` VALUES (5, '2023-10-30 11:39:28', '2023-10-30 15:06:31', 5, 'mdj', '牡丹江牡达', 44.602702, 129.687702);
INSERT INTO `market_location` VALUES (6, '2023-10-30 11:39:28', '2023-10-31 11:30:41', 6, 'gy', '贵阳地利', 26.465871, 106.613613);
INSERT INTO `market_location` VALUES (7, '2023-10-30 11:39:28', '2023-10-31 11:31:46', 7, 'cc', '长春地利', 43.942355, 125.316270);
INSERT INTO `market_location` VALUES (8, '2023-10-30 11:39:28', '2023-10-30 15:09:26', 8, 'sg', '寿光地利农产品物流园有限公司', 36.897288, 118.717510);
INSERT INTO `market_location` VALUES (9, '2023-10-30 11:39:28', '2023-10-31 11:33:17', 9, 'sy', '沈阳地利', 41.823945, 123.522344);
INSERT INTO `market_location` VALUES (10, '2023-10-30 11:39:28', '2023-10-31 13:46:17', 10, 'dlk', '达利凯', 45.679112, 126.618306);
INSERT INTO `market_location` VALUES (11, '2023-10-30 11:39:28', '2023-10-30 12:47:58', 11, 'hzsc', '杭州水产', 30.376836, 120.113697);
INSERT INTO `market_location` VALUES (12, '2023-10-30 11:39:28', '2023-10-31 11:34:43', 12, 'szpt', '数字平台部', 30.659067, 104.070310);
INSERT INTO `market_location` VALUES (13, '2023-10-30 11:39:28', '2023-10-30 12:48:00', 14, 'hzve', '杭州蔬菜物流有限公司', 30.376836, 120.113697);
INSERT INTO `market_location` VALUES (14, '2023-10-30 11:39:28', '2023-10-30 12:48:01', 15, 'hzgp', '杭州果品批发有限公司', 30.376836, 120.113697);
INSERT INTO `market_location` VALUES (15, '2023-10-30 11:39:28', '2023-10-30 11:39:28', 16, 'jygl', '经营管理办公室', NULL, NULL);
INSERT INTO `market_location` VALUES (16, '2023-10-30 11:39:28', '2023-10-31 13:46:05', 17, 'gx', '革新', 45.679112, 126.618306);
INSERT INTO `market_location` VALUES (17, '2023-10-30 11:39:28', '2023-10-31 13:45:52', 18, 'xfh', '北京鑫丰辉农业科技有限公司', 39.966969, 116.598039);
INSERT INTO `market_location` VALUES (18, '2023-10-30 11:39:28', '2023-10-31 13:44:41', 19, 'JDM', '沈阳金东贸置业有限公司', 41.823945, 123.522344);
INSERT INTO `market_location` VALUES (19, '2023-10-30 11:39:28', '2023-10-31 13:47:01', 20, 'sydl', '沈阳地利农副产品有限公司', 41.823945, 123.522344);
INSERT INTO `market_location` VALUES (20, '2023-10-30 11:39:28', '2023-10-31 13:48:38', 21, 'SCMC', '供应链客户', 39.971035, 116.398601);
INSERT INTO `market_location` VALUES (21, '2023-10-30 11:39:28', '2023-10-30 11:39:28', 22, 'external', '外部公司', NULL, NULL);
INSERT INTO `market_location` VALUES (22, '2023-10-30 11:39:28', '2023-10-31 13:49:48', 23, 'szjl', '深圳市佳利供应链有限公司', 22.655955, 114.001382);
INSERT INTO `market_location` VALUES (23, '2023-10-30 11:39:28', '2023-10-31 13:50:40', 24, 'YYCC', '哈尔滨友谊仓储', 45.679112, 126.618306);
INSERT INTO `market_location` VALUES (24, '2023-10-30 11:39:28', '2023-10-31 13:52:06', 25, 'szjlmy', '深圳市佳利供应链有限公司（贸易）', 22.655955, 114.001382);
INSERT INTO `market_location` VALUES (25, '2023-10-30 11:39:28', '2023-10-31 13:53:03', 26, 'SGJY', '寿光市佳源供应链有限公司', 36.897288, 118.717510);
INSERT INTO `market_location` VALUES (26, '2023-10-30 11:39:28', '2023-10-31 13:53:16', 28, 'HXJ', '哈尔滨新吉公共设施有限公司', 45.679112, 126.618306);
INSERT INTO `market_location` VALUES (27, '2023-10-30 11:39:28', '2023-10-31 13:53:31', 29, 'syhl', '沈阳惠利农产品服务有限公司', 41.823945, 123.522344);