-public class Whitelist extends SqliteTable {
-
- public Whitelist(String filename) {
- super(filename,
- new String[] {
- "create table if not exists 'whitelist' (email)",
- "create table if not exists 'pending' (spamid,email,message,date)"
- },
- true);
- reap("pending", "date");
+public class Whitelist extends SqliteDB {
+
+ public Whitelist(String filename) throws SQLException {
+ super(filename);
+ SqliteTable whitelist = getTable("whitelist", "(email)");
+ whitelist.createIndex("email");
+ SqliteTable pending = getTable("pending", "(spamid,email,message,date)");
+ pending.reap("date");
+ pending.createIndex("spamid");
+ pending.createIndex("email");