From 57f0d44ed01cc16fca2012ab4a9fd678631a2db4 Mon Sep 17 00:00:00 2001
From: dms <dms@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Mon, 30 Apr 2001 14:45:25 +0000
Subject: [PATCH] updated to accomodate new freshmeat table

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@469 c11ca15a-4712-0410-83d8-924469b57eb5
---
 scripts/setup_sql.pl | 27 ++++++++++++---------------
 1 file changed, 12 insertions(+), 15 deletions(-)

diff --git a/scripts/setup_sql.pl b/scripts/setup_sql.pl
index 4fe4da1..ec9a910 100755
--- a/scripts/setup_sql.pl
+++ b/scripts/setup_sql.pl
@@ -48,13 +48,16 @@ if ($param{'DBType'} =~ /mysql/i) {
     # retrieve a list of db's from the server.
     my %db;
     foreach ($dbh->func('_ListTables')) {
+	&status("table => $_");
 	$db{$_} = 1;
     }
 
     # create database.
-    &status("Creating database $param{'DBName'}...");
-    $query = "CREATE DATABASE $param{'DBName'}";
-    &dbRaw("create(db $param{'DBName'})", $query);
+    if (!scalar keys %db) {
+	&status("Creating database $param{'DBName'}...");
+	$query = "CREATE DATABASE $param{'DBName'}";
+	&dbRaw("create(db $param{'DBName'})", $query);
+    }
 
     # Step 4.
     print "Step 4: Creating the tables.\n";
@@ -91,20 +94,14 @@ if ($param{'DBType'} =~ /mysql/i) {
 	print "  creating new table freshmeat...\n";
 
 	$query = "CREATE TABLE freshmeat (".
-		"name VARCHAR(64) NOT NULL,".
-		"stable VARCHAR(32),".
-		"devel VARCHAR(32),".
-		"section VARCHAR(40),".
+		"projectname_short VARCHAR(64) NOT NULL,".
+		"latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,".
 		"license VARCHAR(32),".
-		"homepage VARCHAR(128),".
-		"download VARCHAR(128),".
-		"changelog VARCHAR(128),".
-		"deb VARCHAR(128),".
-		"rpm VARCHAR(128),".
-		"link CHAR(55),".
-		"oneliner VARCHAR(96) NOT NULL,".
+		"url_deb VARCHAR(128),".
+		"url_homepage VARCHAR(128),".
+		"desc_short VARCHAR(96) NOT NULL,".
 
-		"PRIMARY KEY (name)".
+		"PRIMARY KEY (projectname_short,latest_version)".
 	")";
 
 	&dbRaw("create(freshmeat)", $query);
-- 
2.39.5