dashboard
repositories
filestore
activity
search
login
~zyazyz250@sina.com
/
gitlab
forked from
gitlab
summary
commits
tree
docs
forks
compare
blame
|
history
|
raw
gitlab迁移
郑永安
2023-06-19
c8188c0fc9edf6ea3feda5b6f11dcb014af2a89e
[~zyazyz250@sina.com/gitlab.git]
/
xjEnterpriseInformation
/
sql
/
修改有效期为时间段.txt
1
2
3
ALTER TABLE `company`.`com_company_info`
CHANGE COLUMN `validity_date` `validity_date_start` date NULL DEFAULT NULL COMMENT '有效期开始时间' AFTER `certificate_num`,
ADD COLUMN `validity_date_end` date NULL COMMENT '有效期截止时间' AFTER `is_delete`;