snail-job的oracle sql（oracle 11g）

官網版本的oracle sql中有自增主鍵，oracle 11g并不支持，
所以改成新建索引和觸發器的方式自增主鍵。（tip：snail-job的最新版本1.0.0必須使用JDK17， jdk8會報錯，所以最后沒用起來）

/*SnailJob Database Transfer ToolSource Server Type    : MySQLTarget Server Type    : Oracle 11GDate: 2024-05-21 09:36:38
*/-- sj_namespace
CREATE SEQUENCE seq_namespace_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_namespace
(id          number                                  NOT NULL,name        varchar2(64)                            NULL,unique_id   varchar2(64)                            NULL,description varchar2(256) DEFAULT ''                NULL,deleted     smallint      DEFAULT 0                 NOT NULL,create_dt   date          DEFAULT SYSDATE NOT NULL,update_dt   date          DEFAULT SYSDATE NOT NULL
);CREATE OR REPLACE TRIGGER trg_namespace_id
BEFORE INSERT ON sj_namespace
FOR EACH ROW
BEGINSELECT seq_namespace_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_namespaceADD CONSTRAINT pk_sj_namespace PRIMARY KEY (id);CREATE INDEX idx_sj_namespace_01 ON sj_namespace (name);COMMENT ON COLUMN sj_namespace.id IS '主鍵';
COMMENT ON COLUMN sj_namespace.name IS '名稱';
COMMENT ON COLUMN sj_namespace.unique_id IS '唯一id';
COMMENT ON COLUMN sj_namespace.description IS '描述';
COMMENT ON COLUMN sj_namespace.deleted IS '邏輯刪除 1、刪除';
COMMENT ON COLUMN sj_namespace.create_dt IS '創建時間';
COMMENT ON COLUMN sj_namespace.update_dt IS '修改時間';
COMMENT ON TABLE sj_namespace IS '命名空間';INSERT INTO sj_namespace(name, unique_id, description, deleted, create_dt, update_dt) VALUES ('Development', 'dev', '', 0, sysdate, sysdate);
INSERT INTO sj_namespace(name, unique_id, description, deleted, create_dt, update_dt) VALUES ('Production', 'prod', '', 0, sysdate, sysdate);-- sj_group_config
CREATE SEQUENCE seq_group_config_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_group_config
(id                number NOT NULL,namespace_id      varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a'    NULL,group_name        varchar2(64)  DEFAULT ''                                    NULL,description       varchar2(256) DEFAULT ''                                    NULL,token             varchar2(64)  DEFAULT 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT' NULL,group_status      smallint      DEFAULT 0                                     NOT NULL,version           number                                                      NOT NULL,group_partition   number                                                      NOT NULL,id_generator_mode smallint      DEFAULT 1                                     NOT NULL,init_scene        smallint      DEFAULT 0                                     NOT NULL,bucket_index      number        DEFAULT 0                                     NOT NULL,create_dt         date          DEFAULT SYSDATE                     NOT NULL,update_dt         date          DEFAULT SYSDATE                     NOT NULL
);CREATE OR REPLACE TRIGGER trg_group_config_id
BEFORE INSERT ON sj_group_config
FOR EACH ROW
BEGINSELECT seq_group_config_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_group_configADD CONSTRAINT pk_sj_group_config PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_group_config_01 ON sj_group_config (namespace_id, group_name);COMMENT ON COLUMN sj_group_config.id IS '主鍵';
COMMENT ON COLUMN sj_group_config.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_group_config.group_name IS '組名稱';
COMMENT ON COLUMN sj_group_config.description IS '組描述';
COMMENT ON COLUMN sj_group_config.token IS 'token';
COMMENT ON COLUMN sj_group_config.group_status IS '組狀態 0、未啟用 1、啟用';
COMMENT ON COLUMN sj_group_config.version IS '版本號';
COMMENT ON COLUMN sj_group_config.group_partition IS '分區';
COMMENT ON COLUMN sj_group_config.id_generator_mode IS '唯一id生成模式 默認號段模式';
COMMENT ON COLUMN sj_group_config.init_scene IS '是否初始化場景 0:否 1:是';
COMMENT ON COLUMN sj_group_config.bucket_index IS 'bucket';
COMMENT ON COLUMN sj_group_config.create_dt IS '創建時間';
COMMENT ON COLUMN sj_group_config.update_dt IS '修改時間';
COMMENT ON TABLE sj_group_config IS '組配置';INSERT INTO sj_group_config (namespace_id, group_name, description, token, group_status, version, group_partition, id_generator_mode, init_scene, bucket_index, create_dt, update_dt) VALUES ('dev', 'slgc_rcms_group', '', 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, sysdate, sysdate);-- sj_notify_config
CREATE SEQUENCE seq_notify_config_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_notify_config
(id                     number NOT NULL,namespace_id           varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name             varchar2(64)                                             NULL,business_id            varchar2(64)                                             NULL,system_task_type       smallint      DEFAULT 3                                  NOT NULL,notify_status          smallint      DEFAULT 0                                  NOT NULL,recipient_ids          varchar2(128)                                            NULL,notify_threshold       number        DEFAULT 0                                  NOT NULL,notify_scene           smallint      DEFAULT 0                                  NOT NULL,rate_limiter_status    smallint      DEFAULT 0                                  NOT NULL,rate_limiter_threshold number        DEFAULT 0                                  NOT NULL,description            varchar2(256) DEFAULT ''                                 NULL,create_dt              date          DEFAULT SYSDATE                  NOT NULL,update_dt              date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_notify_config_id
BEFORE INSERT ON sj_notify_config
FOR EACH ROW
BEGINSELECT seq_notify_config_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_notify_configADD CONSTRAINT pk_sj_notify_config PRIMARY KEY (id);CREATE INDEX idx_sj_notify_config_01 ON sj_notify_config (namespace_id, group_name, business_id);COMMENT ON COLUMN sj_notify_config.id IS '主鍵';
COMMENT ON COLUMN sj_notify_config.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_notify_config.group_name IS '組名稱';
COMMENT ON COLUMN sj_notify_config.business_id IS '業務id  ( job_id或workflow_id或scene_name ) ';
COMMENT ON COLUMN sj_notify_config.system_task_type IS '任務類型 1. 重試任務 2. 重試回調 3、JOB任務 4、WORKFLOW任務';
COMMENT ON COLUMN sj_notify_config.notify_status IS '通知狀態 0、未啟用 1、啟用';
COMMENT ON COLUMN sj_notify_config.recipient_ids IS '接收人id列表';
COMMENT ON COLUMN sj_notify_config.notify_threshold IS '通知閾值';
COMMENT ON COLUMN sj_notify_config.notify_scene IS '通知場景';
COMMENT ON COLUMN sj_notify_config.rate_limiter_status IS '限流狀態 0、未啟用 1、啟用';
COMMENT ON COLUMN sj_notify_config.rate_limiter_threshold IS '每秒限流閾值';
COMMENT ON COLUMN sj_notify_config.description IS '描述';
COMMENT ON COLUMN sj_notify_config.create_dt IS '創建時間';
COMMENT ON COLUMN sj_notify_config.update_dt IS '修改時間';
COMMENT ON TABLE sj_notify_config IS '通知配置';-- sj_notify_recipient
CREATE SEQUENCE seq_notify_recipient_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_notify_recipient
(id               number NOT NULL,namespace_id     varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,recipient_name   varchar2(64)                                             NULL,notify_type      smallint      DEFAULT 0                                  NOT NULL,notify_attribute varchar2(512)                                            NULL,description      varchar2(256) DEFAULT ''                                 NULL,create_dt        date          DEFAULT SYSDATE                  NOT NULL,update_dt        date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_notify_recipient_id
BEFORE INSERT ON sj_notify_recipient
FOR EACH ROW
BEGINSELECT seq_notify_recipient_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_notify_recipientADD CONSTRAINT pk_sj_notify_recipient PRIMARY KEY (id);CREATE INDEX idx_sj_notify_recipient_01 ON sj_notify_recipient (namespace_id);COMMENT ON COLUMN sj_notify_recipient.id IS '主鍵';
COMMENT ON COLUMN sj_notify_recipient.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_notify_recipient.recipient_name IS '接收人名稱';
COMMENT ON COLUMN sj_notify_recipient.notify_type IS '通知類型 1、釘釘 2、郵件 3、企業微信 4 飛書';
COMMENT ON COLUMN sj_notify_recipient.notify_attribute IS '配置屬性';
COMMENT ON COLUMN sj_notify_recipient.description IS '描述';
COMMENT ON COLUMN sj_notify_recipient.create_dt IS '創建時間';
COMMENT ON COLUMN sj_notify_recipient.update_dt IS '修改時間';
COMMENT ON TABLE sj_notify_recipient IS '告警通知接收人';-- sj_retry_dead_letter_0
CREATE SEQUENCE seq_retry_dead_letter_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_retry_dead_letter_0
(id            number NOT NULL,namespace_id  varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,unique_id     varchar2(64)                                             NULL,group_name    varchar2(64)                                             NULL,scene_name    varchar2(64)                                             NULL,idempotent_id varchar2(64)                                             NULL,biz_no        varchar2(64)  DEFAULT ''                                 NULL,executor_name varchar2(512) DEFAULT ''                                 NULL,args_str      clob                                                     NULL,ext_attrs     clob                                                     NULL,task_type     smallint      DEFAULT 1                                  NOT NULL,create_dt     date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_retry_dead_letter_id
BEFORE INSERT ON sj_retry_dead_letter_0
FOR EACH ROW
BEGINSELECT seq_retry_dead_letter_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_retry_dead_letter_0ADD CONSTRAINT pk_sj_retry_dead_letter_0 PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_retry_dead_letter_0_01 ON sj_retry_dead_letter_0 (namespace_id, group_name, unique_id);CREATE INDEX idx_sj_retry_dead_letter_0_01 ON sj_retry_dead_letter_0 (namespace_id, group_name, scene_name);
CREATE INDEX idx_sj_retry_dead_letter_0_02 ON sj_retry_dead_letter_0 (idempotent_id);
CREATE INDEX idx_sj_retry_dead_letter_0_03 ON sj_retry_dead_letter_0 (biz_no);
CREATE INDEX idx_sj_retry_dead_letter_0_04 ON sj_retry_dead_letter_0 (create_dt);COMMENT ON COLUMN sj_retry_dead_letter_0.id IS '主鍵';
COMMENT ON COLUMN sj_retry_dead_letter_0.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_retry_dead_letter_0.unique_id IS '同組下id唯一';
COMMENT ON COLUMN sj_retry_dead_letter_0.group_name IS '組名稱';
COMMENT ON COLUMN sj_retry_dead_letter_0.scene_name IS '場景名稱';
COMMENT ON COLUMN sj_retry_dead_letter_0.idempotent_id IS '冪等id';
COMMENT ON COLUMN sj_retry_dead_letter_0.biz_no IS '業務編號';
COMMENT ON COLUMN sj_retry_dead_letter_0.executor_name IS '執行器名稱';
COMMENT ON COLUMN sj_retry_dead_letter_0.args_str IS '執行方法參數';
COMMENT ON COLUMN sj_retry_dead_letter_0.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_retry_dead_letter_0.task_type IS '任務類型 1、重試數據 2、回調數據';
COMMENT ON COLUMN sj_retry_dead_letter_0.create_dt IS '創建時間';
COMMENT ON TABLE sj_retry_dead_letter_0 IS '死信隊列表';-- sj_retry_task_0
CREATE SEQUENCE seq_retry_task_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_retry_task_0
(id              number NOT NULL,namespace_id    varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,unique_id       varchar2(64)                                             NULL,group_name      varchar2(64)                                             NULL,scene_name      varchar2(64)                                             NULL,idempotent_id   varchar2(64)                                             NULL,biz_no          varchar2(64)  DEFAULT ''                                 NULL,executor_name   varchar2(512) DEFAULT ''                                 NULL,args_str        clob                                                     NULL,ext_attrs       clob                                                     NULL,next_trigger_at date                                                     NOT NULL,retry_count     number        DEFAULT 0                                  NOT NULL,retry_status    smallint      DEFAULT 0                                  NOT NULL,task_type       smallint      DEFAULT 1                                  NOT NULL,create_dt       date          DEFAULT SYSDATE                  NOT NULL,update_dt       date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_retry_task_id
BEFORE INSERT ON sj_retry_task_0
FOR EACH ROW
BEGINSELECT seq_retry_task_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_retry_task_0ADD CONSTRAINT pk_sj_retry_task_0 PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_retry_task_0_01 ON sj_retry_task_0 (namespace_id, group_name, unique_id);CREATE INDEX idx_sj_retry_task_0_01 ON sj_retry_task_0 (namespace_id, group_name, scene_name);
CREATE INDEX idx_sj_retry_task_0_02 ON sj_retry_task_0 (namespace_id, group_name, task_type);
CREATE INDEX idx_sj_retry_task_0_03 ON sj_retry_task_0 (namespace_id, group_name, retry_status);
CREATE INDEX idx_sj_retry_task_0_04 ON sj_retry_task_0 (idempotent_id);
CREATE INDEX idx_sj_retry_task_0_05 ON sj_retry_task_0 (biz_no);
CREATE INDEX idx_sj_retry_task_0_06 ON sj_retry_task_0 (create_dt);COMMENT ON COLUMN sj_retry_task_0.id IS '主鍵';
COMMENT ON COLUMN sj_retry_task_0.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_retry_task_0.unique_id IS '同組下id唯一';
COMMENT ON COLUMN sj_retry_task_0.group_name IS '組名稱';
COMMENT ON COLUMN sj_retry_task_0.scene_name IS '場景名稱';
COMMENT ON COLUMN sj_retry_task_0.idempotent_id IS '冪等id';
COMMENT ON COLUMN sj_retry_task_0.biz_no IS '業務編號';
COMMENT ON COLUMN sj_retry_task_0.executor_name IS '執行器名稱';
COMMENT ON COLUMN sj_retry_task_0.args_str IS '執行方法參數';
COMMENT ON COLUMN sj_retry_task_0.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_retry_task_0.next_trigger_at IS '下次觸發時間';
COMMENT ON COLUMN sj_retry_task_0.retry_count IS '重試次數';
COMMENT ON COLUMN sj_retry_task_0.retry_status IS '重試狀態 0、重試中 1、成功 2、最大重試次數';
COMMENT ON COLUMN sj_retry_task_0.task_type IS '任務類型 1、重試數據 2、回調數據';
COMMENT ON COLUMN sj_retry_task_0.create_dt IS '創建時間';
COMMENT ON COLUMN sj_retry_task_0.update_dt IS '修改時間';
COMMENT ON TABLE sj_retry_task_0 IS '任務表';-- sj_retry_task_log
CREATE SEQUENCE seq_retry_task_log_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_retry_task_log
(id            number NOT NULL,namespace_id  varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,unique_id     varchar2(64)                                             NULL,group_name    varchar2(64)                                             NULL,scene_name    varchar2(64)                                             NULL,idempotent_id varchar2(64)                                             NULL,biz_no        varchar2(64)  DEFAULT ''                                 NULL,executor_name varchar2(512) DEFAULT ''                                 NULL,args_str      clob                                                     NULL,ext_attrs     clob                                                     NULL,retry_status  smallint      DEFAULT 0                                  NOT NULL,task_type     smallint      DEFAULT 1                                  NOT NULL,create_dt     date          DEFAULT SYSDATE                  NOT NULL,update_dt     date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_retry_task_log_id
BEFORE INSERT ON sj_retry_task_log
FOR EACH ROW
BEGINSELECT seq_retry_task_log_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_retry_task_logADD CONSTRAINT pk_sj_retry_task_log PRIMARY KEY (id);CREATE INDEX idx_sj_retry_task_log_01 ON sj_retry_task_log (namespace_id, group_name, scene_name);
CREATE INDEX idx_sj_retry_task_log_02 ON sj_retry_task_log (retry_status);
CREATE INDEX idx_sj_retry_task_log_03 ON sj_retry_task_log (idempotent_id);
CREATE INDEX idx_sj_retry_task_log_04 ON sj_retry_task_log (unique_id);
CREATE INDEX idx_sj_retry_task_log_05 ON sj_retry_task_log (biz_no);
CREATE INDEX idx_sj_retry_task_log_06 ON sj_retry_task_log (create_dt);COMMENT ON COLUMN sj_retry_task_log.id IS '主鍵';
COMMENT ON COLUMN sj_retry_task_log.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_retry_task_log.unique_id IS '同組下id唯一';
COMMENT ON COLUMN sj_retry_task_log.group_name IS '組名稱';
COMMENT ON COLUMN sj_retry_task_log.scene_name IS '場景名稱';
COMMENT ON COLUMN sj_retry_task_log.idempotent_id IS '冪等id';
COMMENT ON COLUMN sj_retry_task_log.biz_no IS '業務編號';
COMMENT ON COLUMN sj_retry_task_log.executor_name IS '執行器名稱';
COMMENT ON COLUMN sj_retry_task_log.args_str IS '執行方法參數';
COMMENT ON COLUMN sj_retry_task_log.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_retry_task_log.retry_status IS '重試狀態 0、重試中 1、成功 2、最大次數';
COMMENT ON COLUMN sj_retry_task_log.task_type IS '任務類型 1、重試數據 2、回調數據';
COMMENT ON COLUMN sj_retry_task_log.create_dt IS '創建時間';
COMMENT ON COLUMN sj_retry_task_log.update_dt IS '修改時間';
COMMENT ON TABLE sj_retry_task_log IS '任務日志基礎信息表';-- sj_retry_task_log_message
CREATE SEQUENCE seq_retry_log_message_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_retry_task_log_message
(id           number NOT NULL,namespace_id varchar2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name   varchar2(64)                                            NULL,unique_id    varchar2(64)                                            NULL,message      clob                                                    NULL,log_num      number       DEFAULT 1                                  NOT NULL,real_time    number       DEFAULT 0                                  NOT NULL,create_dt    date         DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_retry_log_message_id
BEFORE INSERT ON sj_retry_task_log_message
FOR EACH ROW
BEGINSELECT seq_retry_log_message_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_retry_task_log_messageADD CONSTRAINT pk_sj_retry_task_log_message PRIMARY KEY (id);CREATE INDEX idx_sj_retry_log_message_01 ON sj_retry_task_log_message (namespace_id, group_name, unique_id);
CREATE INDEX idx_sj_retry_log_message_02 ON sj_retry_task_log_message (create_dt);COMMENT ON COLUMN sj_retry_task_log_message.id IS '主鍵';
COMMENT ON COLUMN sj_retry_task_log_message.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_retry_task_log_message.group_name IS '組名稱';
COMMENT ON COLUMN sj_retry_task_log_message.unique_id IS '同組下id唯一';
COMMENT ON COLUMN sj_retry_task_log_message.message IS '異常信息';
COMMENT ON COLUMN sj_retry_task_log_message.log_num IS '日志數量';
COMMENT ON COLUMN sj_retry_task_log_message.real_time IS '上報時間';
COMMENT ON COLUMN sj_retry_task_log_message.create_dt IS '創建時間';
COMMENT ON TABLE sj_retry_task_log_message IS '任務調度日志信息記錄表';-- sj_retry_scene_config
CREATE SEQUENCE seq_retry_scene_config_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_retry_scene_config
(id               number NOT NULL,namespace_id     varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,scene_name       varchar2(64)                                             NULL,group_name       varchar2(64)                                             NULL,scene_status     smallint      DEFAULT 0                                  NOT NULL,max_retry_count  number        DEFAULT 5                                  NOT NULL,back_off         smallint      DEFAULT 1                                  NOT NULL,trigger_interval varchar2(16)  DEFAULT ''                                 NULL,deadline_request number        DEFAULT 60000                              NOT NULL,executor_timeout number        DEFAULT 5                                  NOT NULL,route_key        smallint      DEFAULT 4                                  NOT NULL,description      varchar2(256) DEFAULT ''                                 NULL,create_dt        date          DEFAULT SYSDATE                  NOT NULL,update_dt        date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_retry_scene_config_id
BEFORE INSERT ON sj_retry_scene_config
FOR EACH ROW
BEGINSELECT seq_retry_scene_config_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_retry_scene_configADD CONSTRAINT pk_sj_retry_scene_config PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_retry_scene_config_01 ON sj_retry_scene_config (namespace_id, group_name, scene_name);COMMENT ON COLUMN sj_retry_scene_config.id IS '主鍵';
COMMENT ON COLUMN sj_retry_scene_config.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_retry_scene_config.scene_name IS '場景名稱';
COMMENT ON COLUMN sj_retry_scene_config.group_name IS '組名稱';
COMMENT ON COLUMN sj_retry_scene_config.scene_status IS '組狀態 0、未啟用 1、啟用';
COMMENT ON COLUMN sj_retry_scene_config.max_retry_count IS '最大重試次數';
COMMENT ON COLUMN sj_retry_scene_config.back_off IS '1、默認等級 2、固定間隔時間 3、CRON 表達式';
COMMENT ON COLUMN sj_retry_scene_config.trigger_interval IS '間隔時長';
COMMENT ON COLUMN sj_retry_scene_config.deadline_request IS 'Deadline Request 調用鏈超時 單位毫秒';
COMMENT ON COLUMN sj_retry_scene_config.executor_timeout IS '任務執行超時時間，單位秒';
COMMENT ON COLUMN sj_retry_scene_config.route_key IS '路由策略';
COMMENT ON COLUMN sj_retry_scene_config.description IS '描述';
COMMENT ON COLUMN sj_retry_scene_config.create_dt IS '創建時間';
COMMENT ON COLUMN sj_retry_scene_config.update_dt IS '修改時間';
COMMENT ON TABLE sj_retry_scene_config IS '場景配置';-- sj_server_node
CREATE SEQUENCE seq_server_node_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_server_node
(id           number NOT NULL,namespace_id varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name   varchar2(64)                                             NULL,host_id      varchar2(64)                                             NULL,host_ip      varchar2(64)                                             NULL,host_port    number                                                   NOT NULL,expire_at    date                                                     NOT NULL,node_type    smallint                                                 NOT NULL,ext_attrs    varchar2(256) DEFAULT ''                                 NULL,create_dt    date          DEFAULT SYSDATE                  NOT NULL,update_dt    date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_server_node_id
BEFORE INSERT ON sj_server_node
FOR EACH ROW
BEGINSELECT seq_server_node_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_server_nodeADD CONSTRAINT pk_sj_server_node PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_server_node_01 ON sj_server_node (host_id, host_ip);CREATE INDEX idx_sj_server_node_01 ON sj_server_node (namespace_id, group_name);
CREATE INDEX idx_sj_server_node_02 ON sj_server_node (expire_at, node_type);COMMENT ON COLUMN sj_server_node.id IS '主鍵';
COMMENT ON COLUMN sj_server_node.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_server_node.group_name IS '組名稱';
COMMENT ON COLUMN sj_server_node.host_id IS '主機id';
COMMENT ON COLUMN sj_server_node.host_ip IS '機器ip';
COMMENT ON COLUMN sj_server_node.host_port IS '機器端口';
COMMENT ON COLUMN sj_server_node.expire_at IS '過期時間';
COMMENT ON COLUMN sj_server_node.node_type IS '節點類型 1、客戶端 2、是服務端';
COMMENT ON COLUMN sj_server_node.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_server_node.create_dt IS '創建時間';
COMMENT ON COLUMN sj_server_node.update_dt IS '修改時間';
COMMENT ON TABLE sj_server_node IS '服務器節點';-- sj_distributed_lock
CREATE SEQUENCE seq_distributed_lock_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_distributed_lock
(id         number NOT NULL,name       varchar2(64)                              NULL,lock_until Date DEFAULT SYSDATE NOT NULL,locked_at  Date DEFAULT SYSDATE NOT NULL,locked_by  varchar2(255)                             NULL,create_dt  date         DEFAULT SYSDATE    NOT NULL,update_dt  date         DEFAULT SYSDATE    NOT NULL
);CREATE OR REPLACE TRIGGER trg_distributed_lock_id
BEFORE INSERT ON sj_distributed_lock
FOR EACH ROW
BEGINSELECT seq_distributed_lock_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_distributed_lockADD CONSTRAINT pk_sj_distributed_lock PRIMARY KEY (id);COMMENT ON COLUMN sj_distributed_lock.id IS '主鍵';
COMMENT ON COLUMN sj_distributed_lock.name IS '鎖名稱';
COMMENT ON COLUMN sj_distributed_lock.lock_until IS '鎖定時長';
COMMENT ON COLUMN sj_distributed_lock.locked_at IS '鎖定時間';
COMMENT ON COLUMN sj_distributed_lock.locked_by IS '鎖定者';
COMMENT ON COLUMN sj_distributed_lock.create_dt IS '創建時間';
COMMENT ON COLUMN sj_distributed_lock.update_dt IS '修改時間';
COMMENT ON TABLE sj_distributed_lock IS '鎖定表';-- sj_system_user
CREATE SEQUENCE seq_system_user_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_system_user
(id        number NOT NULL,username  varchar2(64)                       NULL,password  varchar2(128)                      NULL,role      smallint DEFAULT 0                 NOT NULL,create_dt date     DEFAULT SYSDATE NOT NULL,update_dt date     DEFAULT SYSDATE NOT NULL
);CREATE OR REPLACE TRIGGER trg_system_user_id
BEFORE INSERT ON sj_system_user
FOR EACH ROW
BEGINSELECT seq_system_user_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_system_userADD CONSTRAINT pk_sj_system_user PRIMARY KEY (id);COMMENT ON COLUMN sj_system_user.id IS '主鍵';
COMMENT ON COLUMN sj_system_user.username IS '賬號';
COMMENT ON COLUMN sj_system_user.password IS '密碼';
COMMENT ON COLUMN sj_system_user.role IS '角色：1-普通用戶、2-管理員';
COMMENT ON COLUMN sj_system_user.create_dt IS '創建時間';
COMMENT ON COLUMN sj_system_user.update_dt IS '修改時間';
COMMENT ON TABLE sj_system_user IS '系統用戶表';-- pwd: admin
INSERT INTO sj_system_user(username, password, role, create_dt, update_dt) VALUES ('admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, sysdate, sysdate);-- sj_system_user_permission
CREATE SEQUENCE seq_user_permission_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_system_user_permission
(id             number NOT NULL,group_name     varchar2(64)                                            NULL,namespace_id   varchar2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,system_user_id number                                                  NOT NULL,create_dt      date         DEFAULT SYSDATE                  NOT NULL,update_dt      date         DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_user_permission_id
BEFORE INSERT ON sj_system_user_permission
FOR EACH ROW
BEGINSELECT seq_user_permission_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_system_user_permissionADD CONSTRAINT pk_sj_system_user_permission PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_user_permission_01 ON sj_system_user_permission (namespace_id, group_name, system_user_id);COMMENT ON COLUMN sj_system_user_permission.id IS '主鍵';
COMMENT ON COLUMN sj_system_user_permission.group_name IS '組名稱';
COMMENT ON COLUMN sj_system_user_permission.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_system_user_permission.system_user_id IS '系統用戶id';
COMMENT ON COLUMN sj_system_user_permission.create_dt IS '創建時間';
COMMENT ON COLUMN sj_system_user_permission.update_dt IS '修改時間';
COMMENT ON TABLE sj_system_user_permission IS '系統用戶權限表';-- sj_sequence_alloc
CREATE SEQUENCE seq_sequence_alloc_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_sequence_alloc
(id           number NOT NULL,namespace_id varchar2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name   varchar2(64) DEFAULT ''                                 NULL,max_id       number       DEFAULT 1                                  NOT NULL,step         number       DEFAULT 100                                NOT NULL,update_dt    date         DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_sequence_alloc_id
BEFORE INSERT ON sj_sequence_alloc
FOR EACH ROW
BEGINSELECT seq_sequence_alloc_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_sequence_allocADD CONSTRAINT pk_sj_sequence_alloc PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_sequence_alloc_01 ON sj_sequence_alloc (namespace_id, group_name);COMMENT ON COLUMN sj_sequence_alloc.id IS '主鍵';
COMMENT ON COLUMN sj_sequence_alloc.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_sequence_alloc.group_name IS '組名稱';
COMMENT ON COLUMN sj_sequence_alloc.max_id IS '最大id';
COMMENT ON COLUMN sj_sequence_alloc.step IS '步長';
COMMENT ON COLUMN sj_sequence_alloc.update_dt IS '更新時間';
COMMENT ON TABLE sj_sequence_alloc IS '號段模式序號ID分配表';-- sj_job
CREATE SEQUENCE seq_sj_job_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_job
(id               number NOT NULL,namespace_id     varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name       varchar2(64)                                             NULL,job_name         varchar2(64)                                             NULL,args_str         clob          DEFAULT NULL                               NULL,args_type        smallint      DEFAULT 1                                  NOT NULL,next_trigger_at  number                                                   NOT NULL,job_status       smallint      DEFAULT 1                                  NOT NULL,task_type        smallint      DEFAULT 1                                  NOT NULL,route_key        smallint      DEFAULT 4                                  NOT NULL,executor_type    smallint      DEFAULT 1                                  NOT NULL,executor_info    varchar2(255) DEFAULT NULL                               NULL,trigger_type     smallint                                                 NOT NULL,trigger_interval varchar2(255)                                            NULL,block_strategy   smallint      DEFAULT 1                                  NOT NULL,executor_timeout number        DEFAULT 0                                  NOT NULL,max_retry_times  number        DEFAULT 0                                  NOT NULL,parallel_num     number        DEFAULT 1                                  NOT NULL,retry_interval   number        DEFAULT 0                                  NOT NULL,bucket_index     number        DEFAULT 0                                  NOT NULL,resident         smallint      DEFAULT 0                                  NOT NULL,description      varchar2(256) DEFAULT ''                                 NULL,ext_attrs        varchar2(256) DEFAULT ''                                 NULL,deleted          smallint      DEFAULT 0                                  NOT NULL,create_dt        date          DEFAULT SYSDATE                  NOT NULL,update_dt        date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_sj_job_id
BEFORE INSERT ON sj_job
FOR EACH ROW
BEGINSELECT seq_sj_job_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_jobADD CONSTRAINT pk_sj_job PRIMARY KEY (id);CREATE INDEX idx_sj_job_01 ON sj_job (namespace_id, group_name);
CREATE INDEX idx_sj_job_02 ON sj_job (job_status, bucket_index);
CREATE INDEX idx_sj_job_03 ON sj_job (create_dt);COMMENT ON COLUMN sj_job.id IS '主鍵';
COMMENT ON COLUMN sj_job.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_job.group_name IS '組名稱';
COMMENT ON COLUMN sj_job.job_name IS '名稱';
COMMENT ON COLUMN sj_job.args_str IS '執行方法參數';
COMMENT ON COLUMN sj_job.args_type IS '參數類型 ';
COMMENT ON COLUMN sj_job.next_trigger_at IS '下次觸發時間';
COMMENT ON COLUMN sj_job.job_status IS '任務狀態 0、關閉、1、開啟';
COMMENT ON COLUMN sj_job.task_type IS '任務類型 1、集群 2、廣播 3、切片';
COMMENT ON COLUMN sj_job.route_key IS '路由策略';
COMMENT ON COLUMN sj_job.executor_type IS '執行器類型';
COMMENT ON COLUMN sj_job.executor_info IS '執行器名稱';
COMMENT ON COLUMN sj_job.trigger_type IS '觸發類型 1.CRON 表達式 2. 固定時間';
COMMENT ON COLUMN sj_job.trigger_interval IS '間隔時長';
COMMENT ON COLUMN sj_job.block_strategy IS '阻塞策略 1、丟棄 2、覆蓋 3、并行';
COMMENT ON COLUMN sj_job.executor_timeout IS '任務執行超時時間，單位秒';
COMMENT ON COLUMN sj_job.max_retry_times IS '最大重試次數';
COMMENT ON COLUMN sj_job.parallel_num IS '并行數';
COMMENT ON COLUMN sj_job.retry_interval IS '重試間隔 ( s ) ';
COMMENT ON COLUMN sj_job.bucket_index IS 'bucket';
COMMENT ON COLUMN sj_job.resident IS '是否是常駐任務';
COMMENT ON COLUMN sj_job.description IS '描述';
COMMENT ON COLUMN sj_job.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_job.deleted IS '邏輯刪除 1、刪除';
COMMENT ON COLUMN sj_job.create_dt IS '創建時間';
COMMENT ON COLUMN sj_job.update_dt IS '修改時間';
COMMENT ON TABLE sj_job IS '任務信息';INSERT INTO sj_job(namespace_id, group_name, job_name, args_str, args_type, next_trigger_at, job_status, task_type, route_key, executor_type, executor_info, trigger_type, trigger_interval, block_strategy,executor_timeout, max_retry_times, parallel_num, retry_interval, bucket_index, resident, description, ext_attrs, deleted, create_dt, update_dt) VALUES ('dev', 'slgc_rcms_group', 'demo-job', NULL, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', '', 0, sysdate, sysdate);-- sj_job_log_message
CREATE SEQUENCE seq_job_log_message_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_job_log_message
(id            number NOT NULL,namespace_id  varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name    varchar2(64)                                             NULL,job_id        number                                                   NOT NULL,task_batch_id number                                                   NOT NULL,task_id       number                                                   NOT NULL,message       clob                                                     NULL,log_num       number        DEFAULT 1                                  NOT NULL,real_time     number        DEFAULT 0                                  NOT NULL,ext_attrs     varchar2(256) DEFAULT ''                                 NULL,create_dt     date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_job_log_message_id
BEFORE INSERT ON sj_job_log_message
FOR EACH ROW
BEGINSELECT seq_job_log_message_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_job_log_messageADD CONSTRAINT pk_sj_job_log_message PRIMARY KEY (id);CREATE INDEX idx_sj_job_log_message_01 ON sj_job_log_message (task_batch_id, task_id);
CREATE INDEX idx_sj_job_log_message_02 ON sj_job_log_message (create_dt);
CREATE INDEX idx_sj_job_log_message_03 ON sj_job_log_message (namespace_id, group_name);COMMENT ON COLUMN sj_job_log_message.id IS '主鍵';
COMMENT ON COLUMN sj_job_log_message.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_job_log_message.group_name IS '組名稱';
COMMENT ON COLUMN sj_job_log_message.job_id IS '任務信息id';
COMMENT ON COLUMN sj_job_log_message.task_batch_id IS '任務批次id';
COMMENT ON COLUMN sj_job_log_message.task_id IS '調度任務id';
COMMENT ON COLUMN sj_job_log_message.message IS '調度信息';
COMMENT ON COLUMN sj_job_log_message.log_num IS '日志數量';
COMMENT ON COLUMN sj_job_log_message.real_time IS '上報時間';
COMMENT ON COLUMN sj_job_log_message.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_job_log_message.create_dt IS '創建時間';
COMMENT ON TABLE sj_job_log_message IS '調度日志';-- sj_job_task
CREATE SEQUENCE seq_job_task_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_job_task
(id             number NOT NULL,namespace_id   varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name     varchar2(64)                                             NULL,job_id         number                                                   NOT NULL,task_batch_id  number                                                   NOT NULL,parent_id      number        DEFAULT 0                                  NOT NULL,task_status    smallint      DEFAULT 0                                  NOT NULL,retry_count    number        DEFAULT 0                                  NOT NULL,client_info    varchar2(128) DEFAULT NULL                               NULL,result_message clob                                                     NULL,args_str       clob          DEFAULT NULL                               NULL,args_type      smallint      DEFAULT 1                                  NOT NULL,ext_attrs      varchar2(256) DEFAULT ''                                 NULL,create_dt      date          DEFAULT SYSDATE                  NOT NULL,update_dt      date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_job_task_id
BEFORE INSERT ON sj_job_task
FOR EACH ROW
BEGINSELECT seq_job_task_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_job_taskADD CONSTRAINT pk_sj_job_task PRIMARY KEY (id);CREATE INDEX idx_sj_job_task_01 ON sj_job_task (task_batch_id, task_status);
CREATE INDEX idx_sj_job_task_02 ON sj_job_task (create_dt);
CREATE INDEX idx_sj_job_task_03 ON sj_job_task (namespace_id, group_name);COMMENT ON COLUMN sj_job_task.id IS '主鍵';
COMMENT ON COLUMN sj_job_task.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_job_task.group_name IS '組名稱';
COMMENT ON COLUMN sj_job_task.job_id IS '任務信息id';
COMMENT ON COLUMN sj_job_task.task_batch_id IS '調度任務id';
COMMENT ON COLUMN sj_job_task.parent_id IS '父執行器id';
COMMENT ON COLUMN sj_job_task.task_status IS '執行的狀態 0、失敗 1、成功';
COMMENT ON COLUMN sj_job_task.retry_count IS '重試次數';
COMMENT ON COLUMN sj_job_task.client_info IS '客戶端地址 clientId#ip:port';
COMMENT ON COLUMN sj_job_task.result_message IS '執行結果';
COMMENT ON COLUMN sj_job_task.args_str IS '執行方法參數';
COMMENT ON COLUMN sj_job_task.args_type IS '參數類型 ';
COMMENT ON COLUMN sj_job_task.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_job_task.create_dt IS '創建時間';
COMMENT ON COLUMN sj_job_task.update_dt IS '修改時間';
COMMENT ON TABLE sj_job_task IS '任務實例';-- sj_job_task_batch
CREATE SEQUENCE seq_job_task_batch_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_job_task_batch
(id                      number NOT NULL,namespace_id            varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name              varchar2(64)                                             NULL,job_id                  number                                                   NOT NULL,workflow_node_id        number        DEFAULT 0                                  NOT NULL,parent_workflow_node_id number        DEFAULT 0                                  NOT NULL,workflow_task_batch_id  number        DEFAULT 0                                  NOT NULL,task_batch_status       smallint      DEFAULT 0                                  NOT NULL,operation_reason        smallint      DEFAULT 0                                  NOT NULL,execution_at            number        DEFAULT 0                                  NOT NULL,system_task_type        smallint      DEFAULT 3                                  NOT NULL,parent_id               varchar2(64)  DEFAULT ''                                 NULL,ext_attrs               varchar2(256) DEFAULT ''                                 NULL,deleted                 smallint      DEFAULT 0                                  NOT NULL,create_dt               date          DEFAULT SYSDATE                  NOT NULL,update_dt               date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_job_task_batch_id
BEFORE INSERT ON sj_job_task_batch
FOR EACH ROW
BEGINSELECT seq_job_task_batch_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_job_task_batchADD CONSTRAINT pk_sj_job_task_batch PRIMARY KEY (id);CREATE INDEX idx_sj_job_task_batch_01 ON sj_job_task_batch (job_id, task_batch_status);
CREATE INDEX idx_sj_job_task_batch_02 ON sj_job_task_batch (create_dt);
CREATE INDEX idx_sj_job_task_batch_03 ON sj_job_task_batch (namespace_id, group_name);
CREATE INDEX idx_sj_job_task_batch_04 ON sj_job_task_batch (workflow_task_batch_id, workflow_node_id);COMMENT ON COLUMN sj_job_task_batch.id IS '主鍵';
COMMENT ON COLUMN sj_job_task_batch.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_job_task_batch.group_name IS '組名稱';
COMMENT ON COLUMN sj_job_task_batch.job_id IS '任務id';
COMMENT ON COLUMN sj_job_task_batch.workflow_node_id IS '工作流節點id';
COMMENT ON COLUMN sj_job_task_batch.parent_workflow_node_id IS '工作流任務父批次id';
COMMENT ON COLUMN sj_job_task_batch.workflow_task_batch_id IS '工作流任務批次id';
COMMENT ON COLUMN sj_job_task_batch.task_batch_status IS '任務批次狀態 0、失敗 1、成功';
COMMENT ON COLUMN sj_job_task_batch.operation_reason IS '操作原因';
COMMENT ON COLUMN sj_job_task_batch.execution_at IS '任務執行時間';
COMMENT ON COLUMN sj_job_task_batch.system_task_type IS '任務類型 3、JOB任務 4、WORKFLOW任務';
COMMENT ON COLUMN sj_job_task_batch.parent_id IS '父節點';
COMMENT ON COLUMN sj_job_task_batch.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_job_task_batch.deleted IS '邏輯刪除 1、刪除';
COMMENT ON COLUMN sj_job_task_batch.create_dt IS '創建時間';
COMMENT ON COLUMN sj_job_task_batch.update_dt IS '修改時間';
COMMENT ON TABLE sj_job_task_batch IS '任務批次';-- sj_job_summary
CREATE SEQUENCE seq_job_summary_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_job_summary
(id               number NOT NULL,namespace_id     varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name       varchar2(64)  DEFAULT ''                                 NULL,business_id      number                                                   NOT NULL,system_task_type smallint      DEFAULT 3                                  NOT NULL,trigger_at       date          DEFAULT SYSDATE                  NOT NULL,success_num      number        DEFAULT 0                                  NOT NULL,fail_num         number        DEFAULT 0                                  NOT NULL,fail_reason      varchar2(512) DEFAULT ''                                 NULL,stop_num         number        DEFAULT 0                                  NOT NULL,stop_reason      varchar2(512) DEFAULT ''                                 NULL,cancel_num       number        DEFAULT 0                                  NOT NULL,cancel_reason    varchar2(512) DEFAULT ''                                 NULL,create_dt        date          DEFAULT SYSDATE                  NOT NULL,update_dt        date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_job_summary_id
BEFORE INSERT ON sj_job_summary
FOR EACH ROW
BEGINSELECT seq_job_summary_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_job_summaryADD CONSTRAINT pk_sj_job_summary PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_job_summary_01 ON sj_job_summary (trigger_at, system_task_type, business_id);CREATE INDEX idx_sj_job_summary_01 ON sj_job_summary (namespace_id, group_name, business_id);COMMENT ON COLUMN sj_job_summary.id IS '主鍵';
COMMENT ON COLUMN sj_job_summary.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_job_summary.group_name IS '組名稱';
COMMENT ON COLUMN sj_job_summary.business_id IS '業務id  ( job_id或workflow_id ) ';
COMMENT ON COLUMN sj_job_summary.system_task_type IS '任務類型 3、JOB任務 4、WORKFLOW任務';
COMMENT ON COLUMN sj_job_summary.trigger_at IS '統計時間';
COMMENT ON COLUMN sj_job_summary.success_num IS '執行成功-日志數量';
COMMENT ON COLUMN sj_job_summary.fail_num IS '執行失敗-日志數量';
COMMENT ON COLUMN sj_job_summary.fail_reason IS '失敗原因';
COMMENT ON COLUMN sj_job_summary.stop_num IS '執行失敗-日志數量';
COMMENT ON COLUMN sj_job_summary.stop_reason IS '失敗原因';
COMMENT ON COLUMN sj_job_summary.cancel_num IS '執行失敗-日志數量';
COMMENT ON COLUMN sj_job_summary.cancel_reason IS '失敗原因';
COMMENT ON COLUMN sj_job_summary.create_dt IS '創建時間';
COMMENT ON COLUMN sj_job_summary.update_dt IS '修改時間';
COMMENT ON TABLE sj_job_summary IS 'DashBoard_Job';-- sj_retry_summary
CREATE SEQUENCE seq_retry_summary_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_retry_summary
(id            number NOT NULL,namespace_id  varchar2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name    varchar2(64) DEFAULT ''                                 NULL,scene_name    varchar2(50) DEFAULT ''                                 NULL,trigger_at    date         DEFAULT SYSDATE                  NOT NULL,running_num   number       DEFAULT 0                                  NOT NULL,finish_num    number       DEFAULT 0                                  NOT NULL,max_count_num number       DEFAULT 0                                  NOT NULL,suspend_num   number       DEFAULT 0                                  NOT NULL,create_dt     date         DEFAULT SYSDATE                  NOT NULL,update_dt     date         DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_retry_summary_id
BEFORE INSERT ON sj_retry_summary
FOR EACH ROW
BEGINSELECT seq_retry_summary_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_retry_summaryADD CONSTRAINT pk_sj_retry_summary PRIMARY KEY (id);CREATE UNIQUE INDEX uk_sj_retry_summary_01 ON sj_retry_summary (namespace_id, group_name, scene_name, trigger_at);CREATE INDEX idx_sj_retry_summary_01 ON sj_retry_summary (trigger_at);COMMENT ON COLUMN sj_retry_summary.id IS '主鍵';
COMMENT ON COLUMN sj_retry_summary.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_retry_summary.group_name IS '組名稱';
COMMENT ON COLUMN sj_retry_summary.scene_name IS '場景名稱';
COMMENT ON COLUMN sj_retry_summary.trigger_at IS '統計時間';
COMMENT ON COLUMN sj_retry_summary.running_num IS '重試中-日志數量';
COMMENT ON COLUMN sj_retry_summary.finish_num IS '重試完成-日志數量';
COMMENT ON COLUMN sj_retry_summary.max_count_num IS '重試到達最大次數-日志數量';
COMMENT ON COLUMN sj_retry_summary.suspend_num IS '暫停重試-日志數量';
COMMENT ON COLUMN sj_retry_summary.create_dt IS '創建時間';
COMMENT ON COLUMN sj_retry_summary.update_dt IS '修改時間';
COMMENT ON TABLE sj_retry_summary IS 'DashBoard_Retry';-- sj_workflow
CREATE SEQUENCE seq_sj_workflow_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_workflow
(id               number NOT NULL,workflow_name    varchar2(64)                                             NULL,namespace_id     varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name       varchar2(64)                                             NULL,workflow_status  smallint      DEFAULT 1                                  NOT NULL,trigger_type     smallint                                                 NOT NULL,trigger_interval varchar2(255)                                            NULL,next_trigger_at  number                                                   NOT NULL,block_strategy   smallint      DEFAULT 1                                  NOT NULL,executor_timeout number        DEFAULT 0                                  NOT NULL,description      varchar2(256) DEFAULT ''                                 NULL,flow_info        clob          DEFAULT NULL                               NULL,bucket_index     number        DEFAULT 0                                  NOT NULL,version          number                                                   NOT NULL,ext_attrs        varchar2(256) DEFAULT ''                                 NULL,deleted          smallint      DEFAULT 0                                  NOT NULL,create_dt        date          DEFAULT SYSDATE                  NOT NULL,update_dt        date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_sj_workflow_id
BEFORE INSERT ON sj_workflow
FOR EACH ROW
BEGINSELECT seq_sj_workflow_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_workflowADD CONSTRAINT pk_sj_workflow PRIMARY KEY (id);CREATE INDEX idx_sj_workflow_01 ON sj_workflow (create_dt);
CREATE INDEX idx_sj_workflow_02 ON sj_workflow (namespace_id, group_name);COMMENT ON COLUMN sj_workflow.id IS '主鍵';
COMMENT ON COLUMN sj_workflow.workflow_name IS '工作流名稱';
COMMENT ON COLUMN sj_workflow.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_workflow.group_name IS '組名稱';
COMMENT ON COLUMN sj_workflow.workflow_status IS '工作流狀態 0、關閉、1、開啟';
COMMENT ON COLUMN sj_workflow.trigger_type IS '觸發類型 1.CRON 表達式 2. 固定時間';
COMMENT ON COLUMN sj_workflow.trigger_interval IS '間隔時長';
COMMENT ON COLUMN sj_workflow.next_trigger_at IS '下次觸發時間';
COMMENT ON COLUMN sj_workflow.block_strategy IS '阻塞策略 1、丟棄 2、覆蓋 3、并行';
COMMENT ON COLUMN sj_workflow.executor_timeout IS '任務執行超時時間，單位秒';
COMMENT ON COLUMN sj_workflow.description IS '描述';
COMMENT ON COLUMN sj_workflow.flow_info IS '流程信息';
COMMENT ON COLUMN sj_workflow.bucket_index IS 'bucket';
COMMENT ON COLUMN sj_workflow.version IS '版本號';
COMMENT ON COLUMN sj_workflow.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_workflow.deleted IS '邏輯刪除 1、刪除';
COMMENT ON COLUMN sj_workflow.create_dt IS '創建時間';
COMMENT ON COLUMN sj_workflow.update_dt IS '修改時間';
COMMENT ON TABLE sj_workflow IS '工作流';-- sj_workflow_node
CREATE SEQUENCE seq_workflow_node_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_workflow_node
(id                   number NOT NULL,namespace_id         varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,node_name            varchar2(64)                                             NULL,group_name           varchar2(64)                                             NULL,job_id               number                                                   NOT NULL,workflow_id          number                                                   NOT NULL,node_type            smallint      DEFAULT 1                                  NOT NULL,expression_type      smallint      DEFAULT 0                                  NOT NULL,fail_strategy        smallint      DEFAULT 1                                  NOT NULL,workflow_node_status smallint      DEFAULT 1                                  NOT NULL,priority_level       number        DEFAULT 1                                  NOT NULL,node_info            clob          DEFAULT NULL                               NULL,version              number                                                   NOT NULL,ext_attrs            varchar2(256) DEFAULT ''                                 NULL,deleted              smallint      DEFAULT 0                                  NOT NULL,create_dt            date          DEFAULT SYSDATE                  NOT NULL,update_dt            date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_workflow_node_id
BEFORE INSERT ON sj_workflow_node
FOR EACH ROW
BEGINSELECT seq_workflow_node_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_workflow_nodeADD CONSTRAINT pk_sj_workflow_node PRIMARY KEY (id);CREATE INDEX idx_sj_workflow_node_01 ON sj_workflow_node (create_dt);
CREATE INDEX idx_sj_workflow_node_02 ON sj_workflow_node (namespace_id, group_name);COMMENT ON COLUMN sj_workflow_node.id IS '主鍵';
COMMENT ON COLUMN sj_workflow_node.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_workflow_node.node_name IS '節點名稱';
COMMENT ON COLUMN sj_workflow_node.group_name IS '組名稱';
COMMENT ON COLUMN sj_workflow_node.job_id IS '任務信息id';
COMMENT ON COLUMN sj_workflow_node.workflow_id IS '工作流ID';
COMMENT ON COLUMN sj_workflow_node.node_type IS '1、任務節點 2、條件節點';
COMMENT ON COLUMN sj_workflow_node.expression_type IS '1、SpEl、2、Aviator 3、QL';
COMMENT ON COLUMN sj_workflow_node.fail_strategy IS '失敗策略 1、跳過 2、阻塞';
COMMENT ON COLUMN sj_workflow_node.workflow_node_status IS '工作流節點狀態 0、關閉、1、開啟';
COMMENT ON COLUMN sj_workflow_node.priority_level IS '優先級';
COMMENT ON COLUMN sj_workflow_node.node_info IS '節點信息 ';
COMMENT ON COLUMN sj_workflow_node.version IS '版本號';
COMMENT ON COLUMN sj_workflow_node.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_workflow_node.deleted IS '邏輯刪除 1、刪除';
COMMENT ON COLUMN sj_workflow_node.create_dt IS '創建時間';
COMMENT ON COLUMN sj_workflow_node.update_dt IS '修改時間';
COMMENT ON TABLE sj_workflow_node IS '工作流節點';-- sj_workflow_task_batch
CREATE SEQUENCE seq_workflow_batch_id MINVALUE 1 MAXVALUE 99999999999999 START WITH 1 INCREMENT BY 1 CACHE 100;CREATE TABLE sj_workflow_task_batch
(id                number NOT NULL,namespace_id      varchar2(64)  DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,group_name        varchar2(64)                                             NULL,workflow_id       number                                                   NOT NULL,task_batch_status smallint      DEFAULT 0                                  NOT NULL,operation_reason  smallint      DEFAULT 0                                  NOT NULL,flow_info         clob          DEFAULT NULL                               NULL,execution_at      number        DEFAULT 0                                  NOT NULL,ext_attrs         varchar2(256) DEFAULT ''                                 NULL,deleted           smallint      DEFAULT 0                                  NOT NULL,create_dt         date          DEFAULT SYSDATE                  NOT NULL,update_dt         date          DEFAULT SYSDATE                  NOT NULL
);CREATE OR REPLACE TRIGGER trg_workflow_batch_id
BEFORE INSERT ON sj_workflow_task_batch
FOR EACH ROW
BEGINSELECT seq_workflow_batch_id.NEXTVALINTO :new.idFROM dual;
END;
/ALTER TABLE sj_workflow_task_batchADD CONSTRAINT pk_sj_workflow_task_batch PRIMARY KEY (id);CREATE INDEX idx_sj_workflow_task_batch_01 ON sj_workflow_task_batch (workflow_id, task_batch_status);
CREATE INDEX idx_sj_workflow_task_batch_02 ON sj_workflow_task_batch (create_dt);
CREATE INDEX idx_sj_workflow_task_batch_03 ON sj_workflow_task_batch (namespace_id, group_name);COMMENT ON COLUMN sj_workflow_task_batch.id IS '主鍵';
COMMENT ON COLUMN sj_workflow_task_batch.namespace_id IS '命名空間id';
COMMENT ON COLUMN sj_workflow_task_batch.group_name IS '組名稱';
COMMENT ON COLUMN sj_workflow_task_batch.workflow_id IS '工作流任務id';
COMMENT ON COLUMN sj_workflow_task_batch.task_batch_status IS '任務批次狀態 0、失敗 1、成功';
COMMENT ON COLUMN sj_workflow_task_batch.operation_reason IS '操作原因';
COMMENT ON COLUMN sj_workflow_task_batch.flow_info IS '流程信息';
COMMENT ON COLUMN sj_workflow_task_batch.execution_at IS '任務執行時間';
COMMENT ON COLUMN sj_workflow_task_batch.ext_attrs IS '擴展字段';
COMMENT ON COLUMN sj_workflow_task_batch.deleted IS '邏輯刪除 1、刪除';
COMMENT ON COLUMN sj_workflow_task_batch.create_dt IS '創建時間';
COMMENT ON COLUMN sj_workflow_task_batch.update_dt IS '修改時間';
COMMENT ON TABLE sj_workflow_task_batch IS '工作流批次';
? 著作權歸作者所有,轉載或內容合作請聯系作者
平臺聲明：文章內容（如有圖片或視頻亦包括在內）由作者上傳并發布，文章內容僅代表作者本人觀點，簡書系信息發布平臺，僅提供信息存儲服務


喜歡的朋友記得點贊、收藏、關注哦！！！

本文來自互聯網用戶投稿，該文觀點僅代表作者本人，不代表本站立場。本站僅提供信息存儲空間服務，不擁有所有權，不承擔相關法律責任。
如若轉載，請注明出處：http://www.pswp.cn/web/87502.shtml
繁體地址，請注明出處：http://hk.pswp.cn/web/87502.shtml
英文地址，請注明出處：http://en.pswp.cn/web/87502.shtml

如若內容造成侵權/違法違規/事實不符，請聯系多彩編程網進行投訴反饋email:809451989@qq.com，一經查實，立即刪除！

相關文章

Windows VMWare Centos Docker部署Nginx并配置對Springboot應用的訪問代理

Windows VMWare Centos Docker部署Nginx并配置對Springboot應用的訪問代理

前置博文 Windows VMWare Centos環境下安裝Docker并配置MySqlhttps://blog.csdn.net/u013224722/article/details/148928081 Windows VMWare Centos Docker部署Springboot應用https://blog.csdn.net/u013224722/article/details/148958480 # 將已存在的容器設置為宿主機重啟后…
閱讀更多...
暑期數據結構第一天

暑期數據結構第一天

暑期數據結構第一天 數據元素與數據對象 數據元素--組成數據的基本單位 與數據的關系：是集合的個體 數據對象--性質相同的數據元素的集合 與數據的關系：集合的子集 邏輯結構 （1）線性結構，所有結點都最多有一個直…
閱讀更多...
vsCode 擴展中 package.nls.json 文件的作用國際化支持

vsCode 擴展中 package.nls.json 文件的作用國際化支持

package.nls.json 代表英文語言文件 {"command.favourite.addtofavourite": "Add to Favourite","command.favourite.deletefavourite": "Remove from Favourite","command.favourite.moveup": "Move Up" } 在 …
閱讀更多...
結構型智能科技的關鍵可行性——信息型智能向結構型智能的轉換（提綱）

結構型智能科技的關鍵可行性——信息型智能向結構型智能的轉換（提綱）

結構型智能科技的關鍵可行性 ——信息型智能向結構型智能的轉換 1.信息型智能科技概述 1.1傳統計算機科技的信息型繼承者 1.2 信息型智能環境 1.3信息型智能主體 1.4機器學習創造的智能 1.5信息型智能科技的問題 2.結構型智能科技概述 2.1傳統計算機科技向真實生命結構…
閱讀更多...
Excel 數據合并助手SheetDataMerge智能識別同類數據，銷售報表處理提升效率

Excel 數據合并助手SheetDataMerge智能識別同類數據，銷售報表處理提升效率

各位Excel小能手們！今天給大家介紹個超厲害的玩意兒——SheetDataMerge，這可是專注Excel數據處理的實用工具！它就像個數據小管家，核心功能就是智能合并工作表里的同類數據。 軟件下載地址安裝包 它有多牛呢？能自動識別…
閱讀更多...
AIStarter平臺使用指南：如何一鍵卸載已下載的AI項目（最新版操作教程）

AIStarter平臺使用指南：如何一鍵卸載已下載的AI項目（最新版操作教程）

如果你正在使用 AIStarter 平臺，但不知道如何卸載不再需要的 AI 項目，那么這篇簡明教程將為你提供清晰的操作指引。 AIStarter 是由知名創作者“熊哥”打造的一款 AI 工具啟動器平臺，旨在幫助用戶快速部署和運行各類 AI 項目。隨著平臺不斷更…
閱讀更多...
項目中大表治理方案實踐

項目中大表治理方案實踐

一、業務背景 目前生產庫數據庫服務器數據存儲達到了13T，其中license_spart表數據量達到了200億，占用7.5T，空間占用率達到54%。而且這張表每年數據增長量達到30億。其中有效VALID數據占20億，無效數據INVALID占180億。由于業務上有…
閱讀更多...
快應用（QuickApp）技術解析與UniApp跨端開發生態探秘優雅草卓伊凡

快應用（QuickApp）技術解析與UniApp跨端開發生態探秘優雅草卓伊凡

快應用（QuickApp）技術解析與UniApp跨端開發生態探秘優雅草卓伊凡引言：一場由快應用引發的技術辯論近日，優雅草科技的資深開發者卓伊凡在與甲方的一次項目溝通中，因技術選型問題展開了激烈討論。甲方對快應用&#xff0…
閱讀更多...
《Font Awesome 參考手冊》

《Font Awesome 參考手冊》

《Font Awesome 參考手冊》 引言 Font Awesome 是一個功能豐富的圖標庫，旨在幫助設計師和開發者快速地在網頁上添加圖標。它提供了超過700個矢量圖標，并且支持響應式設計。本文將為您詳細介紹 Font Awesome 的使用方法、圖標分類、圖標定制以及與 CSS 的結合。 一、Font A…
閱讀更多...
Linux基本命令篇 —— uname命令

Linux基本命令篇 —— uname命令

uname命令是Linux系統中用于顯示系統信息的實用工具，它可以提供關于操作系統、內核版本、硬件架構等重要信息。下面我將詳細介紹這個命令的用法和常見應用場景。 目錄 一、基本語法 二、常用選項 三、使用示例 顯示所有系統信息（最常用） …
閱讀更多...
React Native 開發環境搭建--window--android

React Native 開發環境搭建--window--android

官網： https://reactnative.cn/docs/environment-setup 必須安裝的 node, JDK ,android Studio 安裝node 以前裝了nvm, 用nvm install 18.0.0 就可以了 安裝JDK 1、下載 ---- 我安裝的是11 【JAVA17下載傳送門】 注意！！！1 …
閱讀更多...
ODS 系統是什么？企業為什么需要搭建 ODS？

ODS 系統是什么？企業為什么需要搭建 ODS？

目錄 一、ODS 系統基礎認知：先弄明白它是啥 1. 什么是 ODS 系統？ 2. ODS 系統的起源 3. ODS 系統的特點 二、ODS 系統能干啥？核心功能解析 1. 數據集成 2. 數據清洗和轉換 3. 實時數據更新 4. 數據查詢和分析 三、企業為什么非得搭…
閱讀更多...
通過網頁調用身份證閱讀器http websocket方法-華視電子————仙盟創夢IDE

通過網頁調用身份證閱讀器http websocket方法-華視電子————仙盟創夢IDE

1.安裝全瀏覽器網頁專用監控軟件 2.安裝后 3.配置web接口 4.測試讀取 5.驅動監控地址 時間段內讀取身份證:如超時時間10000ms,則在點擊按鈕10秒內,放上身份證就可以讀成功,超時返回失敗; 讀身份證:把身份證放上去后點擊讀卡,讀成功,再次讀卡需要將身份證拿起來再放回去; 不拿…
閱讀更多...
Spring Cloud 前端調用后端接口方式

Spring Cloud 前端調用后端接口方式

在 Spring Cloud 微服務架構中，前端調用后端接口通常不直接通過 Eureka，而是通過以下兩種核心方式實現： 一、前端直接調用后端服務（需解決跨域和地址管理問題） 1. AJAX 直接調用 前端通過 HTTP 請求（如 …
閱讀更多...
【stm32】HAL庫開發——CubeMX配置RTC，單片機工作模式和看門狗

【stm32】HAL庫開發——CubeMX配置RTC，單片機工作模式和看門狗

目錄 一、CubeMX配置RTC 1.RTC實時重要一環——BKP 寄存器 2.RTC實時時鐘 2.1打開RTC并設置時間 2.2打開外部低速時鐘 2.3代碼實現： 二、單片機工作模式 1.低功耗睡眠模式(Sleep) 2.低功耗停止模式(Stop) 3.低功耗待機模式(StandBy) 三、看門狗 1.獨立看…
閱讀更多...
9.Docker的容器數據卷使用（掛載）

9.Docker的容器數據卷使用（掛載）

什么是容器數據卷技術？ 到這里，我算是入門docker了！ docker的理念：將環境和應用打包成一個鏡像！直接安裝就能使用 如果數據都在容器中，那么我們一旦將容器刪除，數據就會丟失！因為…
閱讀更多...
使用 TCollector 寫入 TDengine

使用 TCollector 寫入 TDengine

TCollector 是 openTSDB 的一部分，它用來采集客戶端日志發送給數據庫。 只需要將 TCollector 的配置修改指向運行 taosAdapter 的服務器域名（或 IP 地址）和相應端口即可將 TCollector 采集的數據存在到 TDengine 中，可以充分利用…
閱讀更多...
高斯消元法詳解

高斯消元法詳解

文章目錄 概念用法特殊情況 我的奇怪方法 概念 什么是高斯消元?讓我們看一看 OI-Wiki 的解釋： 高斯消元法（Gauss–Jordan elimination）是求解線性方程組的經典算法，它在當代數學中有著重要的地位和價值，是線性代數課…
閱讀更多...
暴雨服務器成功中標華中科技大學集成電路學院服務器采購項目

暴雨服務器成功中標華中科技大學集成電路學院服務器采購項目

近日，武漢暴雨信息發展有限公司在激烈的競爭中脫穎而出，成功中標華中科技大學集成電路學院的服務器采購項目。此次中標產品為暴雨旗下的塔式重裝AM400服務器，這一成果標志著暴雨信息在高性能計算領域的卓越實力得到了高校科研機構的高度認可。…
閱讀更多...
集群聊天服務器---MySQL數據庫的建立

集群聊天服務器---MySQL數據庫的建立

數據庫的建立表格 user表 字段名稱字段類型字段說明約束idINT用戶idPRIMARY KEY, AUTO_INCREMENTnameVARCHAR(50)用戶名NOT NULL, UNIQUEpasswordVARCHAR(50)用戶密碼NOT NULLstateENUM(online, offline)當前登錄狀態DEFAULT offline friend表 字段名稱字段類型字段說明約束…
閱讀更多...
最新文章

Copyright @ 2022~2023