drop table   JOB_RUNTIME_DETAIL_INFO ;
drop table   RESOURCE_MODULE ;
drop table   TEMPLATE_INFO ;
drop table  JOB_TEMPLATE  ;
drop table TEMPLATE_RESOURCE;


create table IF not exists JOB_RUNTIME_DETAIL_INFO(
  task_id VARCHAR(100),
  collector_id  VARCHAR(100),
  interval varchar(100),
  PRIMARY KEY (task_id)
);

create table IF not exists TEMPLATE_INFO(
  id bigint generated BY DEFAULT AS IDENTITY,
  template_id varchar(100),
  template_name varchar(100),
  PRIMARY KEY (id)
);

CREATE TABLE  IF NOT EXISTS RESOURCE_MODULE(
  id bigint generated BY DEFAULT AS IDENTITY,
  resource_id VARCHAR(100),
  version VARCHAR(20),
  protocol VARCHAR(20),
  url VARCHAR(200),
  ip_addr VARCHAR(20),
  port VARCHAR(10),
  user_name VARCHAR(50),
  password VARCHAR(100),
  ext_params VARCHAR(2000),
  PRIMARY KEY (id)
);