Permalink
Fetching contributors…
Cannot retrieve contributors at this time
22 lines (20 sloc) 639 Bytes
-- COLUMN REFERENCES
--
-- package packages(id)
-- doneby users(handle)
CREATE TABLE releases (
id int(11) NOT NULL default '0',
package int(11) NOT NULL default '0',
version varchar(20) NOT NULL default '',
state enum('stable','beta','alpha','snapshot','devel') default 'stable',
doneby varchar(20) NOT NULL default '',
license varchar(20) default NULL,
summary text,
description text,
releasedate datetime NOT NULL default '0000-00-00 00:00:00',
releasenotes text,
PRIMARY KEY (id),
UNIQUE KEY package (package,version),
KEY releasedate (releasedate,package),
KEY state (state)
);