You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
73 lines
3.8 KiB
73 lines
3.8 KiB
docker run -d -p 5236:5236 --restart=always --name dm8 --privileged=true -e PAGE_SIZE=16 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e INSTANCE_NAME=dm8_01 -v /env/docker/dmdata:/opt/dmdbms/data dm8:dm8_20241230_rev255012_x86_rh6_64
|
|
|
|
|
|
|
|
|
|
|
|
create tablespace "ALOG" datafile '/opt/dmdbms/data/ALOG.DBF' size 128 ;
|
|
alter tablespace "ALOG" datafile '/opt/dmdbms/data/ALOG.DBF' autoextend on next 100 maxsize 10240;
|
|
create user "aa" identified by "Alog!@5212" hash with SHA512 salt
|
|
encrypt by "5212" default tablespace "ALOG";
|
|
GRANT PUBLIC TO ALOG;
|
|
GRANT RESOURCE TO ALOG;
|
|
|
|
-- 授予用户创建表和视图的权限
|
|
GRANT CREATE TABLE TO ALOG;
|
|
GRANT CREATE VIEW TO ALOG;
|
|
|
|
CREATE TABLE ACTION_LOG (
|
|
LOG_ID BIGINT PRIMARY KEY ,
|
|
APP_ID INT null ,
|
|
TITLE VARCHAR(255) null ,
|
|
METHOD_NAME VARCHAR(255) null ,
|
|
BUSINESS_NAME VARCHAR(255) null ,
|
|
BUSINESS_TYPE VARCHAR(255) null ,
|
|
REQUEST_METHOD VARCHAR(255) null ,
|
|
OPERATOR_TYPE TINYINT null ,
|
|
OPER_UID VARCHAR(255) null ,
|
|
OPER_USER_NAME VARCHAR(255) null ,
|
|
DEPT_NAME VARCHAR(255) null ,
|
|
OPER_URL VARCHAR(255) null ,
|
|
OPER_IP VARCHAR(255) null ,
|
|
OPER_LOCATION VARCHAR(255) null ,
|
|
OPER_PARAM TEXT null ,
|
|
JSON_RESULT TEXT null ,
|
|
STATUS TINYINT null ,
|
|
ERROR_MSG TEXT null ,
|
|
CREATE_TIME DATETIME null ,
|
|
BEFORE_VALUE TEXT null ,
|
|
AFTER_VALUE TEXT null ,
|
|
BUSINESS_ID VARCHAR(255) null ,
|
|
RESPONSE_TIME TINYINT null
|
|
|
|
)
|
|
|
|
PARTITION BY RANGE (CREATE_TIME)
|
|
INTERVAL ( NUMTOYMINTERVAL (1, 'month'))
|
|
(
|
|
PARTITION P1 VALUES LESS THAN (TO_DATE ('2025-02-01', 'yyyy-mm-dd'))
|
|
);
|
|
|
|
comment ON COLUMN ACTION_LOG.LOG_ID IS '日志主键';
|
|
comment ON COLUMN ACTION_LOG.APP_ID IS '应用ID';
|
|
comment ON COLUMN ACTION_LOG.TITLE IS '分类名称';
|
|
comment ON COLUMN ACTION_LOG.METHOD_NAME IS '方法名称';
|
|
comment ON COLUMN ACTION_LOG.BUSINESS_NAME IS '操作模块';
|
|
comment ON COLUMN ACTION_LOG.BUSINESS_TYPE IS '业务类型';
|
|
comment ON COLUMN ACTION_LOG.REQUEST_METHOD IS '请求方式';
|
|
comment ON COLUMN ACTION_LOG.OPERATOR_TYPE IS '操作人员（0用户 1系统自动）';
|
|
comment ON COLUMN ACTION_LOG.OPER_UID IS '操作人员ID';
|
|
comment ON COLUMN ACTION_LOG.OPER_USER_NAME IS '操作人员';
|
|
comment ON COLUMN ACTION_LOG.DEPT_NAME IS '部门名称';
|
|
comment ON COLUMN ACTION_LOG.OPER_URL IS '请求URL';
|
|
comment ON COLUMN ACTION_LOG.OPER_IP IS '主机地址';
|
|
comment ON COLUMN ACTION_LOG.OPER_LOCATION IS '操作地点';
|
|
comment ON COLUMN ACTION_LOG.OPER_PARAM IS '请求参数';
|
|
comment ON COLUMN ACTION_LOG.JSON_RESULT IS '返回参数';
|
|
comment ON COLUMN ACTION_LOG.STATUS IS '操作状态（0正常 1异常）';
|
|
comment ON COLUMN ACTION_LOG.ERROR_MSG IS '错误消息';
|
|
comment ON COLUMN ACTION_LOG.CREATE_TIME IS '操作时间';
|
|
comment ON COLUMN ACTION_LOG.BEFORE_VALUE IS '更新前数据';
|
|
comment ON COLUMN ACTION_LOG.AFTER_VALUE IS '更新后数据';
|
|
comment ON COLUMN ACTION_LOG.BUSINESS_ID IS '业务主键';
|
|
comment ON COLUMN ACTION_LOG.RESPONSE_TIME IS '响应时长';
|