table edits

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@678 c11ca15a-4712-0410-83d8-924469b57eb5

diff --git a/setup/freshmeat.sql b/setup/freshmeat.sql
index d77e521477a4e7fccf4ff03a9c4294b2a041944c..385b7a743bb9083a8cc323ff68e46ab76b1c4413 100644 (file)
--- a/setup/freshmeat.sql
+++ b/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/src/dbm.pl b/src/dbm.pl
index eb66aa96c7a5e519e0a749c2a7fa113f52afea9a..f7fcd7b38be1ae460f32f87b03cc46e55e7cbb90 100644 (file)
--- a/src/dbm.pl
+++ b/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'
        ]
     );