summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'www-apps/pydio/files')
-rw-r--r--www-apps/pydio/files/6.4.0.mysql21
-rw-r--r--www-apps/pydio/files/6.4.0.pgsql29
-rw-r--r--www-apps/pydio/files/7.0.1.mysql60
-rw-r--r--www-apps/pydio/files/7.0.1.pgsql51
-rw-r--r--www-apps/pydio/files/7.0.2.mysql6
-rw-r--r--www-apps/pydio/files/postinst.en.txt6
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