diff options
Diffstat (limited to 'www-apps/pydio/files/7.0.1.pgsql')
-rw-r--r-- | www-apps/pydio/files/7.0.1.pgsql | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/www-apps/pydio/files/7.0.1.pgsql b/www-apps/pydio/files/7.0.1.pgsql deleted file mode 100644 index 7ba1c5a..0000000 --- a/www-apps/pydio/files/7.0.1.pgsql +++ /dev/null @@ -1,51 +0,0 @@ -/* SEPARATOR */ -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 BYTEA 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 */ -DROP TABLE IF EXISTS ajxp_tasks_nodes; -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS ajxp_tasks_nodes ( - id serial PRIMARY KEY, - task_uid VARCHAR(40) NOT NULL, - node_base_url VARCHAR(255) NOT NULL, - node_path VARCHAR(255) 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 bytea NOT NULL, - PRIMARY KEY (channel_name) -); |