From 54e2167555cd0c01bf44dbb9780662fc863b887f Mon Sep 17 00:00:00 2001
From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Fri, 22 Nov 2002 02:50:47 +0000
Subject: [PATCH] table edits

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@678 c11ca15a-4712-0410-83d8-924469b57eb5
---
 blootbot/setup/freshmeat.sql |  1 -
 blootbot/src/dbm.pl          | 25 +++++++++++++++----------
 2 files changed, 15 insertions(+), 11 deletions(-)

diff --git a/blootbot/setup/freshmeat.sql b/blootbot/setup/freshmeat.sql
index d77e521..385b7a7 100644
--- a/blootbot/setup/freshmeat.sql
+++ b/blootbot/setup/freshmeat.sql
@@ -2,7 +2,6 @@ CREATE TABLE freshmeat (
 	projectname_short VARCHAR(64) NOT NULL,
 	latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,
 	license VARCHAR(32),
-	url_deb VARCHAR(128),
 	url_homepage VARCHAR(128),
 	desc_short VARCHAR(96) NOT NULL,
 
diff --git a/blootbot/src/dbm.pl b/blootbot/src/dbm.pl
index eb66aa9..f7fcd7b 100644
--- a/blootbot/src/dbm.pl
+++ b/blootbot/src/dbm.pl
@@ -17,16 +17,16 @@ use vars qw(%factoids %param);
     my %formats = (
 	'factoids', [
 	    'factoid_key',
-	    'factoid_value',
+	    'requested_by',
+	    'requested_time',
+	    'requested_count',
 	    'created_by',
 	    'created_time',
 	    'modified_by',
 	    'modified_time',
-	    'requested_by',
-	    'requested_time',
-	    'requested_count',
 	    'locked_by',
-	    'locked_time'
+	    'locked_time',
+	    'factoid_value'
 	],
 	'freshmeat', [
 	    'projectname_short',
@@ -47,16 +47,21 @@ use vars qw(%factoids %param);
 	    'time',
 	    'channel',
 	    'host',
-	    'messagecount',
-	    'hehcount',
-	    'karma',
 	    'message'
 	],
 	'stats', [
 	    'nick',
 	    'type',
-	    'counter',
-	    'time'
+	    'channel',
+	    'time',
+	    'counter'
+	],
+	'botmail', [
+	    'srcwho',
+	    'dstwho',
+	    'srcuh',
+	    'time',
+	    'msg'
 	]
     );
 
-- 
2.39.5