DROP TABLE IF EXISTS ajxp_tasks;
/* SEPARATOR */
CREATE TABLE IF NOT EXISTS ajxp_tasks (
    uid VARCHAR(255) NOT NULL ,
    type INTEGER NOT NULL,
    parent_uid VARCHAR(255) DEFAULT NULL,
    flags INTEGER NOT NULL,
    label VARCHAR(255) NOT NULL,
    user_id VARCHAR(255) NOT NULL,
    ws_id VARCHAR(32) NOT NULL,
    status INTEGER NOT NULL,
    status_msg VARCHAR(500) NOT NULL,
    progress INTEGER NOT NULL,
    schedule INTEGER NOT NULL,
    schedule_value VARCHAR(255) DEFAULT NULL,
    action VARCHAR(255) NOT NULL,
    parameters TEXT NOT NULL,
    creation_date INTEGER NOT NULL DEFAULT 0,
    status_update INTEGER NOT NULL DEFAULT 0,
    PRIMARY KEY (uid)
);
/* SEPARATOR */
CREATE INDEX ajxp_task_usr_idx ON ajxp_tasks (user_id);
/* SEPARATOR */
CREATE INDEX ajxp_task_status_idx ON ajxp_tasks (status);
/* SEPARATOR */
CREATE INDEX ajxp_task_type ON ajxp_tasks (type);
/* SEPARATOR */
CREATE INDEX ajxp_task_schedule ON ajxp_tasks (schedule);
/* SEPARATOR */
CREATE TABLE IF NOT EXISTS ajxp_tasks_nodes (
  id integer NOT NULL primary key autoincrement,
  task_uid TEXT NOT NULL,
  node_base_url TEXT NOT NULL,
  node_path TEXT NOT NULL
);
/* SEPARATOR */
CREATE INDEX ajxp_taskn_tuid_idx ON ajxp_tasks_nodes (task_uid);
/* SEPARATOR */
CREATE INDEX ajxp_taskn_base_idx ON ajxp_tasks_nodes (node_base_url);
/* SEPARATOR */
CREATE INDEX ajxp_taskn_path_idx ON ajxp_tasks_nodes (node_path);
/* SEPARATOR */
CREATE TABLE IF NOT EXISTS ajxp_mq_queues (
  channel_name varchar(255) NOT NULL,
  content BLOB NOT NULL,
  PRIMARY KEY (`channel_name`)
);