This repository has been archived by the owner on Nov 25, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 289
/
6.5.4.sqlite
48 lines (48 loc) · 1.53 KB
/
6.5.4.sqlite
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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`)
);