diff options
Diffstat (limited to 'www-apps/pydio/files/6.4.0.pgsql')
-rw-r--r-- | www-apps/pydio/files/6.4.0.pgsql | 29 |
1 files changed, 0 insertions, 29 deletions
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(); |