diff options
Diffstat (limited to 'www-apps/pydio/files')
-rw-r--r-- | www-apps/pydio/files/6.4.0.mysql | 21 | ||||
-rw-r--r-- | www-apps/pydio/files/6.4.0.pgsql | 29 | ||||
-rw-r--r-- | www-apps/pydio/files/7.0.1.mysql | 60 | ||||
-rw-r--r-- | www-apps/pydio/files/7.0.1.pgsql | 51 | ||||
-rw-r--r-- | www-apps/pydio/files/7.0.2.mysql | 6 | ||||
-rw-r--r-- | www-apps/pydio/files/postinst.en.txt | 6 |
6 files changed, 0 insertions, 173 deletions
diff --git a/www-apps/pydio/files/6.4.0.mysql b/www-apps/pydio/files/6.4.0.mysql deleted file mode 100644 index 90121d9..0000000 --- a/www-apps/pydio/files/6.4.0.mysql +++ /dev/null @@ -1,21 +0,0 @@ -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS `ajxp_mail_queue` ( - `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, - `recipient` varchar(255) NOT NULL, - `url` text NOT NULL, - `date_event` int(11) NOT NULL, - `notification_object` longblob NOT NULL, - `html` int(1) NOT NULL -)CHARACTER SET utf8 COLLATE utf8_unicode_ci; -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS `ajxp_mail_sent` ( - `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT, - `recipient` varchar(255) NOT NULL, - `url` text NOT NULL, - `date_event` int(11) NOT NULL, - `notification_object` longblob NOT NULL, - `html` int(1) NOT NULL -)CHARACTER SET utf8 COLLATE utf8_unicode_ci; -/* SEPARATOR */ -CREATE TRIGGER `mail_queue_go_to_sent` BEFORE DELETE ON `ajxp_mail_queue` -FOR EACH ROW INSERT INTO ajxp_mail_sent (id,recipient,url,date_event,notification_object,html) VALUES (old.id,old.recipient,old.url,old.date_event,old.notification_object,old.html);
\ No newline at end of file diff --git a/www-apps/pydio/files/6.4.0.pgsql b/www-apps/pydio/files/6.4.0.pgsql deleted file mode 100644 index 054db1c..0000000 --- a/www-apps/pydio/files/6.4.0.pgsql +++ /dev/null @@ -1,29 +0,0 @@ -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS ajxp_mail_queue ( - id serial PRIMARY KEY, - recipient varchar(255) NOT NULL, - url text NOT NULL, - date_event integer NOT NULL, - notification_object bytea NOT NULL, - html integer NOT NULL -); -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS ajxp_mail_sent ( - id serial PRIMARY KEY, - recipient varchar(255) NOT NULL, - url text NOT NULL, - date_event integer NOT NULL, - notification_object bytea NOT NULL, - html integer NOT NULL -); -/* SEPARATOR */ -CREATE FUNCTION ajxp_send_mail() RETURNS trigger AS $ajxp_send_mail$ - BEGIN - INSERT INTO ajxp_mail_sent (id,recipient,url,date_event,notification_object,html) - VALUES (OLD.id,OLD.recipient,OLD.url,OLD.date_event,OLD.notification_object,OLD.html); - RETURN OLD; - END; -$ajxp_send_mail$ LANGUAGE plpgsql; -/* SEPARATOR */ -CREATE TRIGGER mail_queue_go_to_sent BEFORE DELETE ON ajxp_mail_queue -FOR EACH ROW EXECUTE PROCEDURE ajxp_send_mail(); diff --git a/www-apps/pydio/files/7.0.1.mysql b/www-apps/pydio/files/7.0.1.mysql deleted file mode 100644 index fe431c2..0000000 --- a/www-apps/pydio/files/7.0.1.mysql +++ /dev/null @@ -1,60 +0,0 @@ -/* SEPARATOR */ -DROP TABLE IF EXISTS ajxp_tasks; -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS ajxp_tasks ( - uid VARCHAR(40) NOT NULL, - `type` INTEGER NOT NULL, - parent_uid VARCHAR(40) 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 MEDIUMBLOB NOT NULL, - creation_date INTEGER NOT NULL DEFAULT 0, - status_update INTEGER NOT NULL DEFAULT 0, - PRIMARY KEY (uid) -) CHARACTER SET utf8 COLLATE utf8_unicode_ci; -/* 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` int(11) NOT NULL AUTO_INCREMENT, - `task_uid` varchar(40) NOT NULL, - `node_base_url` varchar(255) NOT NULL, - `node_path` varchar(255) NOT NULL, - PRIMARY KEY (`id`) -) CHARACTER SET utf8 COLLATE utf8_unicode_ci; -/* 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 */ -DROP TABLE IF EXISTS ajxp_mq_queues; -/* SEPARATOR */ -CREATE TABLE IF NOT EXISTS `ajxp_mq_queues` ( - `channel_name` varchar(255) NOT NULL, - `content` LONGBLOB NOT NULL, - PRIMARY KEY (`channel_name`) -) CHARACTER SET utf8 COLLATE utf8_unicode_ci; -/* SEPARATOR */ -DROP TRIGGER IF EXISTS `LOG_UPDATE`; -/* SEPARATOR */ -CREATE TRIGGER `LOG_UPDATE` AFTER UPDATE ON `ajxp_index` -FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type) - VALUES (new.repository_identifier, new.node_id, old.node_path, new.node_path, CASE old.node_path COLLATE utf8_bin = new.node_path COLLATE utf8_bin WHEN true THEN 'content' ELSE 'path' END);
\ No newline at end of file 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) -); diff --git a/www-apps/pydio/files/7.0.2.mysql b/www-apps/pydio/files/7.0.2.mysql deleted file mode 100644 index 9c9f8e2..0000000 --- a/www-apps/pydio/files/7.0.2.mysql +++ /dev/null @@ -1,6 +0,0 @@ -/* SEPARATOR */ -DROP TRIGGER IF EXISTS `LOG_UPDATE`; -/* SEPARATOR */ -CREATE TRIGGER `LOG_UPDATE` AFTER UPDATE ON `ajxp_index` -FOR EACH ROW INSERT INTO ajxp_changes (repository_identifier, node_id,source,target,type) -VALUES (new.repository_identifier, new.node_id, old.node_path, new.node_path, CASE LENGTH(new.node_path) = LENGTH(old.node_path) AND old.node_path COLLATE utf8_bin = new.node_path COLLATE utf8_bin WHEN true THEN 'content' ELSE 'path' END); diff --git a/www-apps/pydio/files/postinst.en.txt b/www-apps/pydio/files/postinst.en.txt deleted file mode 100644 index 77bc593..0000000 --- a/www-apps/pydio/files/postinst.en.txt +++ /dev/null @@ -1,6 +0,0 @@ -SQL scripts to upgrade database can be found in pydio's sqlscripts folder. - -PHP upgrade scripts can be found in <path_to_installation>/upgrade-scripts. - -You must cleanup plugin cache files: -$ find <path_to_installation>/data/cache/plugins_* -type f -delete |