major re-organisation of the different SQL files; cleanup and fixing of the postgres...

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

diff --git a/setup/sqlite2/freshmeat.sql b/setup/sqlite2/freshmeat.sql
new file mode 100644 (file)
index 0000000..4b4f42b
--- /dev/null
+++ b/setup/sqlite2/freshmeat.sql
@@ -0,0 +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)
+);