From 05724453118769ed99b6021c602d9e987c97b9f3 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Felix=20D=C3=B6rre?= Date: Mon, 22 Sep 2014 23:45:45 +0200 Subject: [PATCH] UPD: cleanup reminders of old table. --- doc/tableStructure.sql | 2 +- src/org/cacert/gigi/email/EmailProvider.java | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/doc/tableStructure.sql b/doc/tableStructure.sql index c141f0ad..8fd14c88 100644 --- a/doc/tableStructure.sql +++ b/doc/tableStructure.sql @@ -67,7 +67,7 @@ DROP TABLE IF EXISTS `emailPinglog`; CREATE TABLE `emailPinglog` ( `when` datetime NOT NULL, `uid` int(11) NOT NULL, - `emailid` int(11) NOT NULL, + `email` varchar(255) NOT NULL, `type` enum('fast', 'active') NOT NULL, `status` enum('open', 'success', 'failed') NOT NULL, `result` varchar(255) NOT NULL diff --git a/src/org/cacert/gigi/email/EmailProvider.java b/src/org/cacert/gigi/email/EmailProvider.java index 64902429..b67c4430 100644 --- a/src/org/cacert/gigi/email/EmailProvider.java +++ b/src/org/cacert/gigi/email/EmailProvider.java @@ -115,7 +115,7 @@ public abstract class EmailProvider { pw.print("QUIT\r\n"); pw.flush(); - GigiPreparedStatement statmt = DatabaseConnection.getInstance().prepare("insert into `pinglog` set `when`=NOW(), `email`=?, `result`=?, `uid`=?"); + GigiPreparedStatement statmt = DatabaseConnection.getInstance().prepare("insert into `emailPinglog` set `when`=NOW(), `email`=?, `result`=?, `uid`=?"); statmt.setString(1, address); statmt.setString(2, line); statmt.setInt(3, forUid); @@ -130,7 +130,7 @@ public abstract class EmailProvider { } } - GigiPreparedStatement statmt = DatabaseConnection.getInstance().prepare("insert into `pinglog` set `when`=NOW(), `email`=?, `result`=?, `uid`=?"); + GigiPreparedStatement statmt = DatabaseConnection.getInstance().prepare("insert into `emailPinglog` set `when`=NOW(), `email`=?, `result`=?, `uid`=?"); statmt.setString(1, address); statmt.setString(2, "Failed to make a connection to the mail server"); statmt.setInt(3, forUid); -- 2.39.2