ALTER TABLE  sys_goods_type
ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  sys_goods_type
ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'


ALTER TABLE  sys_proj_type
ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  sys_proj_type
ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'  ;


ALTER TABLE  sys_proj_info
ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  sys_proj_info
ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'  ;


ALTER TABLE  sys_module_info
ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  sys_module_info
ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'  ;


ALTER TABLE  shopping_goods
ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  shopping_goods
ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'  ;


ALTER TABLE  shopping_goods_category
    ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  shopping_goods_category
    ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'  ;

ALTER TABLE   sys_depart_info
    ADD COLUMN `shop_id` bigint(20) NULL COMMENT '店铺id' ;

ALTER TABLE  sys_depart_info
    ADD COLUMN `company_id` bigint(20) NULL COMMENT '公司id'  ;


ALTER TABLE `shop_share_qrcord`
CHANGE COLUMN `form_id` `shop_id` long NULL AFTER `qrcode_url`;