* Fix SQL for broken MySQL schema

[infobot.git] / setup / mysql / freshmeat.sql

diff --git a/setup/mysql/freshmeat.sql b/setup/mysql/freshmeat.sql
index 4b4f42bed577df317f0156ae4c88f570c0a6885d..fc634188aaba163970aad47d09238cf7c9feb72a 100644 (file)
--- a/setup/mysql/freshmeat.sql
+++ b/setup/mysql/freshmeat.sql
@@ -1,8 +1,8 @@
-CREATE TABLE freshmeat (
- projectname_short VARCHAR(64) NOT NULL,
- latest_version VARCHAR(32) DEFAULT 'none' NOT NULL,
- license VARCHAR(32),
- url_homepage VARCHAR(128),
- desc_short VARCHAR(96) NOT NULL,
- PRIMARY KEY (projectname_short,latest_version)
+CREATE TABLE `freshmeat` (
+ `projectname_short` VARCHAR(64) NOT NULL,
+ `latest_version` VARCHAR(32) DEFAULT 'none' NOT NULL,
+ `license` VARCHAR(32),
+ `url_homepage` VARCHAR(128),
+ `desc_short` VARCHAR(96) NOT NULL,
+ PRIMARY KEY (`projectname_short`,`latest_version`)
 );