File: freshmeat.sql

package info (click to toggle)
blootbot 1.2.0-6.3
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 1,368 kB
  • ctags: 603
  • sloc: perl: 16,607; sh: 147; makefile: 54; sql: 47
file content (10 lines) | stat: -rw-r--r-- 278 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
 
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,

	PRIMARY KEY (projectname_short,latest_version)
);