人事系统开发
1ba6efd8ed
包含：登录失败锁定、90天密码有效期、30分钟会话超时、 强制改密、登录审计日志、屏幕水印、企业背景图、 备案信息固定底部、favicon、JS空集合保护、 会话过期体验优化（403 JSON）、display_errors 关闭、 固定 key 根治 Integrity check failed 等全部改动 注意：config.inc.php/.htaccess/.user.ini 含敏感信息， 通过 .gitignore 排除，勿推送到公开仓库。
23 lines
868 B
SQL
23 lines
868 B
SQL
# Change the status fields in the entry and repeat tables
|
|
# to be unsigned rather than signed (they are used as bit fields)
|
|
# Note: PostgreSQL does not have unsigned, but as the status
|
|
# fields there are smallints (there are no tinyints in PostgreSQL)
|
|
# it does not matter.
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%entry
|
|
CHANGE status status tinyint unsigned NOT NULL DEFAULT 0;
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%repeat
|
|
CHANGE status status tinyint unsigned NOT NULL DEFAULT 0;
|
|
|
|
|
|
# Add two new settings to the area table. (Note: we could combine
|
|
# all the various 'booleans' into a integer field, in the same
|
|
# way as status is handled in the entry and repeat tables, but
|
|
# as there are relatively few rows in the area table, this does
|
|
# not seem worth doing).
|
|
|
|
ALTER TABLE %DB_TBL_PREFIX%area
|
|
ADD COLUMN confirmation_enabled tinyint,
|
|
ADD COLUMN confirmed_default tinyint;
|