X-Git-Url: http://mop.ddnsfree.com/gitweb/?p=brisk.git;a=blobdiff_plain;f=sql%2Fsql.d%2F070-add-mailmgmt.sql;h=bfd0a2471fc85d4143a4d2353fbff83962c9c7e8;hp=cef0248632a403c65a4412ed200ea50a159080d2;hb=484a365c1e66ba4b878117275423a1594c209960;hpb=31bfc5e122ec3db5c70e2587a23fabd0dae5ee33 diff --git a/sql/sql.d/070-add-mailmgmt.sql b/sql/sql.d/070-add-mailmgmt.sql index cef0248..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,