From e35c2621a7823981d7842de7a0260d8b218bfc2e Mon Sep 17 00:00:00 2001 From: wuxw <928255095@qq.com> Date: 星期一, 21 十月 2019 22:06:07 +0800 Subject: [PATCH] 优化商户ID判断 --- java110-db/db/StoreService/create_resource.sql | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/java110-db/db/StoreService/create_resource.sql b/java110-db/db/StoreService/create_resource.sql index 14f6477..063c490 100644 --- a/java110-db/db/StoreService/create_resource.sql +++ b/java110-db/db/StoreService/create_resource.sql @@ -30,6 +30,7 @@ create table resource_order( res_order_id varchar(30) not null comment '璁㈠崟ID', `b_id` varchar(30) NOT NULL COMMENT '涓氬姟Id', + `store_id` VARCHAR(30) NOT NULL COMMENT '鍟嗘埛ID', res_order_type varchar(8) not null comment '鍑哄簱绫诲瀷 10000 鍏ュ簱 20000 鍑哄簱 鍦╰_dict琛ㄦ煡鐪�', state varchar(8) not null comment '瀹℃牳鐘舵��', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', @@ -41,6 +42,7 @@ create table business_resource_order( res_order_id varchar(30) not null comment '璁㈠崟ID', `b_id` varchar(30) NOT NULL COMMENT '涓氬姟Id', + `store_id` VARCHAR(30) NOT NULL COMMENT '鍟嗘埛ID', res_order_type varchar(8) not null comment '鍑哄簱绫诲瀷 10000 鍏ュ簱 20000 鍑哄簱 鍦╰_dict琛ㄦ煡鐪�', state varchar(8) not null comment '瀹℃牳鐘舵��', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', @@ -52,9 +54,10 @@ res_item_id varchar(30) not null comment '璁㈠崟椤笽D', res_order_id varchar(30) not null comment '璁㈠崟ID', `b_id` varchar(30) NOT NULL COMMENT '涓氬姟Id', + `store_id` VARCHAR(30) NOT NULL COMMENT '鍟嗘埛ID', `res_id` varchar(30) NOT NULL COMMENT '璧勬簮ID', `res_count` int(11) DEFAULT NULL COMMENT '鏁伴噺', - remark varchar(200) comment '澶囨敞' + remark varchar(200) comment '澶囨敞', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', status_cd varchar(2) not null default '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僼_dict琛紝0, 鍦ㄧ敤 1澶辨晥' ); @@ -65,6 +68,7 @@ res_item_id varchar(30) not null comment '璁㈠崟椤笽D', res_order_id varchar(30) not null comment '璁㈠崟ID', `b_id` varchar(30) NOT NULL COMMENT '涓氬姟Id', + `store_id` VARCHAR(30) NOT NULL COMMENT '鍟嗘埛ID', `res_id` varchar(30) NOT NULL COMMENT '璧勬簮ID', `res_count` int(11) DEFAULT NULL COMMENT '鏁伴噺', remark varchar(200) comment '澶囨敞', -- Gitblit v1.8.0