X-Git-Url: http://git.megacz.com/?a=blobdiff_plain;f=src%2Forg%2Fibex%2Fmail%2FGraylist.java;h=a23581eb5f412fb8bac273affa4f65d91f27e02b;hb=0af90c1a1f14e24e1eb6790228be021b3e8e65b4;hp=ec1fe128834a8b332a688aefcba24f97f5b4d663;hpb=4ca1c5dde661520f29ec5faf80db43e1a68aeb5f;p=org.ibex.mail.git diff --git a/src/org/ibex/mail/Graylist.java b/src/org/ibex/mail/Graylist.java index ec1fe12..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))" - }); - reap("graylist", "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) {