23 lines
717 B
SQL
23 lines
717 B
SQL
ALTER TABLE `shop_goods`
|
|
ADD COLUMN `usage_instruction` VARCHAR(512) NULL COMMENT '商品使用说明'
|
|
AFTER `goods_detail`;
|
|
|
|
ALTER TABLE `qy_user`
|
|
ADD COLUMN `sys_role_id` BIGINT DEFAULT NULL COMMENT '系统角色id'
|
|
AFTER `balance`;
|
|
|
|
ALTER TABLE `qy_user`
|
|
ADD COLUMN `use_balance` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '已使用用户余额'
|
|
AFTER `balance`;
|
|
|
|
ALTER TABLE `qy_user`
|
|
ADD COLUMN `balance_limit` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT '余额额度'
|
|
AFTER `use_balance`;
|
|
|
|
ALTER TABLE `qy_user`
|
|
ADD COLUMN `ab98_user_id` bigint NULL COMMENT '汇邦云用户id'
|
|
AFTER `userid`;
|
|
|
|
ALTER TABLE `ab98_user`
|
|
ADD COLUMN `qy_user_id` bigint NULL COMMENT '企业用户id'
|
|
AFTER `userid`; |