人事系统开发
1ba6efd8ed
包含：登录失败锁定、90天密码有效期、30分钟会话超时、 强制改密、登录审计日志、屏幕水印、企业背景图、 备案信息固定底部、favicon、JS空集合保护、 会话过期体验优化（403 JSON）、display_errors 关闭、 固定 key 根治 Integrity check failed 等全部改动 注意：config.inc.php/.htaccess/.user.ini 含敏感信息， 通过 .gitignore 排除，勿推送到公开仓库。
25 lines
790 B
SQL
25 lines
790 B
SQL
-- Replace rep_num_weeks and rep_num_months by interval
|
|
|
|
-- No need to save the current timestamp because timestamps do not auto-update
|
|
-- in PostgreSQL. However we do need to disable the triggger which does the
|
|
-- update and then re-enable it at the end.
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%repeat
|
|
DISABLE TRIGGER USER;
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%repeat
|
|
ADD COLUMN rep_interval smallint DEFAULT 1 NOT NULL;
|
|
|
|
UPDATE %DB_TBL_PREFIX%repeat
|
|
SET rep_interval=rep_num_weeks WHERE rep_type=2 AND rep_num_weeks IS NOT NULL;
|
|
|
|
UPDATE %DB_TBL_PREFIX%repeat
|
|
SET rep_interval=rep_num_months WHERE rep_type=3 AND rep_num_months IS NOT NULL;
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%repeat
|
|
DROP COLUMN rep_num_weeks,
|
|
DROP COLUMN rep_num_months;
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%repeat
|
|
ENABLE TRIGGER USER;
|
|
|