X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F070-add-mailmgmt.sql;h=bfd0a2471fc85d4143a4d2353fbff83962c9c7e8;hb=HEAD;hp=8f8057a7e5baaf305dfd1948b302e47895bef707;hpb=b3b62ac96b554e6e893176d2e6f22ae660587b5c;p=brisk.git

diff --git a/sql/sql.d/070-add-mailmgmt.sql b/sql/sql.d/070-add-mailmgmt.sql
index 8f8057a..bfd0a24 100644
--- a/sql/sql.d/070-add-mailmgmt.sql
+++ b/sql/sql.d/070-add-mailmgmt.sql
@@ -1,7 +1,7 @@
 --
 --  Table to manage mails sent to users
 --
-DROP TABLE #PFX#mails;
+DROP TABLE IF EXISTS #PFX#mails;
 CREATE TABLE #PFX#mails (
        code       SERIAL PRIMARY KEY,
        ucode      integer REFERENCES #PFX#users (code) ON DELETE cascade ON UPDATE cascade,
@@ -10,4 +10,4 @@ CREATE TABLE #PFX#mails (
        subj       text,                              -- email subject
        body_txt   text,                              -- email body (text version)
        body_htm   text,                              -- email body (html version)
-       refs       text);                             -- email references
+       hash       text);                             -- reference hash to complete registration