CREATE TABLE sqliimport_scheduled (
  id INT NOT NULL,
  handler VARCHAR(50),
  label VARCHAR(255),
  options_serialized CLOB,
  frequency VARCHAR(30) NOT NULL,
  NEXT INT DEFAULT 0,
  user_id INT,
  requested_time INT,
  is_active SMALLINT DEFAULT 0,
  manual_frequency INT DEFAULT 0,
  PRIMARY KEY (id)
);

CREATE TABLE sqliimport_item (
  id INT NOT NULL,
  handler VARCHAR(50),
  options_serialized CLOB,
  user_id INT,
  requested_time INT DEFAULT 0,
  STATUS SMALLINT DEFAULT 0,
  percentage_int SMALLINT DEFAULT 0,
  TYPE SMALLINT DEFAULT 1,
  progression_notes CLOB,
  process_time INT DEFAULT 0,
  scheduled_id INT,
  PRIMARY KEY (id)
);

CREATE SEQUENCE se_sqliimport_item;
CREATE SEQUENCE se_sqliimport_scheduled;

CREATE OR REPLACE TRIGGER tr_sqliimport_scheduled_id
BEFORE INSERT ON sqliimport_scheduled
FOR EACH ROW
WHEN ( NEW.ID IS NULL )
BEGIN
    SELECT se_sqliimport_scheduled.nextval
    INTO :NEW.ID
    FROM dual;
END;
/

CREATE OR REPLACE TRIGGER tr_sqliimport_item_id
BEFORE INSERT ON sqliimport_item
FOR EACH ROW
WHEN ( NEW.ID IS NULL )
BEGIN
    SELECT se_sqliimport_item.nextval
    INTO :NEW.ID
    FROM dual;
END;
/