TB worker 任务设置相关sql脚本

CREATE SMALLFILE TABLESPACE "TMS_WORK" DATAFILE 'D:\APP\YFLIJIE\ORADATA\ORCL\MS_WORK' SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

create table PAMIRS_SCHEDULE_QUEUE

(

  id             NUMBER not null,

  task_type       VARCHAR2(50) not null,

  queue_id       VARCHAR2(50) not null,

  own_sign       VARCHAR2(50) not null,

  base_task_type VARCHAR2(50),

  cur_server     VARCHAR2(100),

  req_server     VARCHAR2(100),

  gmt_create     DATE not null,

  gmt_modified   DATE not null

)

tablespace TMS_WORK

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

comment on table PAMIRS_SCHEDULE_QUEUE

  is '调度队列';

comment on column PAMIRS_SCHEDULE_QUEUE.id

  is '主键ID';

comment on column PAMIRS_SCHEDULE_QUEUE.task_type

  is '任务类型,由BASE_TASK_TYPE-OWN_SIGN构成，如果是BASE，则是BASE_TASK_TYPE';

comment on column PAMIRS_SCHEDULE_QUEUE.queue_id

  is '任务队列编号';

comment on column PAMIRS_SCHEDULE_QUEUE.own_sign

  is '环境，例如 开发、测试、预发、线上。缺省BASE，2.0版本新增';

comment on column PAMIRS_SCHEDULE_QUEUE.base_task_type

  is '基础任务类型，2.0版本新增';

comment on column PAMIRS_SCHEDULE_QUEUE.cur_server

  is '当前持有的调度服务器';

comment on column PAMIRS_SCHEDULE_QUEUE.req_server

  is '请求调度的服务器';

comment on column PAMIRS_SCHEDULE_QUEUE.gmt_create

  is '创建时间';

comment on column PAMIRS_SCHEDULE_QUEUE.gmt_modified

  is '修改时间';

create unique index IND_PAMIRS_SCHEDULE_QUEUEID on PAMIRS_SCHEDULE_QUEUE (TASK_TYPE, QUEUE_ID, OWN_SIGN)

  tablespace TMS_WORK

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

alter table PAMIRS_SCHEDULE_QUEUE

  add constraint PK_PAMIRS_SCHEDULE_QUEUE primary key (ID)

  using index 

  tablespace TMS_WORK

  pctfree 10

  initrans 2

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

create table PAMIRS_SCHEDULE_SERVER

(

  id                   NUMBER not null,

  uuid                 VARCHAR2(100) not null,

  task_type           VARCHAR2(50) not null,

  own_sign             VARCHAR2(50) not null,

  base_task_type       VARCHAR2(50) not null,

  ip                   VARCHAR2(50) not null,

  host_name           VARCHAR2(50) not null,

  manager_port         NUMBER not null,

  thread_num           NUMBER not null,

  register_time       DATE not null,

  heartbeat_time       DATE not null,

  version             NUMBER not null,

  jmx_url             VARCHAR2(200),

  dealinfo_desc       VARCHAR2(1000),

  next_run_start_time VARCHAR2(100),

  next_run_end_time   VARCHAR2(100),

  gmt_create           DATE not null,

  gmt_modified         DATE not null

)

tablespace TMS_WORK

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64K

    next 1M

    minextents 1

    maxextents unlimited

  );

comment on table PAMIRS_SCHEDULE_SERVER

  is '调度服务器';

comment on column PAMIRS_SCHEDULE_SERVER.id

  is '主键ID';

comment on column PAMIRS_SCHEDULE_SERVER.uuid

  is '调度服务器唯一编号';

comment on column PAMIRS_SCHEDULE_SERVER.task_type

  is '任务类型。由BASE_TASK_TYPE-OWN_SIGN构成，如果是BASE，则是BASE_TASK_TYPE