X-Git-Url: http://git.megacz.com/?a=blobdiff_plain;f=src%2Forg%2Fibex%2Fmail%2FGraylist.java;fp=src%2Forg%2Fibex%2Fmail%2FGraylist.java;h=a23581eb5f412fb8bac273affa4f65d91f27e02b;hb=36e19d8a6c5c04fc1d48c166ca7d951b763093a1;hp=0a0ad538e783d21fc057233cd9f02bd84a65b9c5;hpb=24ff72d2529147b2dcbda9bfed28836bb674c6ad;p=org.ibex.mail.git diff --git a/src/org/ibex/mail/Graylist.java b/src/org/ibex/mail/Graylist.java index 0a0ad53..a23581e 100644 --- a/src/org/ibex/mail/Graylist.java +++ b/src/org/ibex/mail/Graylist.java @@ -9,13 +9,11 @@ import java.sql.Timestamp; public class Graylist extends SqliteDB { - public Graylist(String filename) { - super(filename, - new String[] { - "create table if not exists 'whitelist' (ip unique)", - "create table if not exists 'graylist' (ip,fromaddr,toaddr,date, primary key(ip,fromaddr,toaddr))" - }); - getTable("graylist").reap("date"); + public Graylist(String filename) throws SQLException { + super(filename); + SqliteTable whitelist = getTable("whitelist", "(ip unique)"); + SqliteTable graylist = getTable("graylist", "(ip,fromaddr,toaddr,date,PRIMARY KEY(ip,fromaddr,toaddr))"); + graylist.reap("date"); } public synchronized void addWhitelist(InetAddress ip) {