Hi,
Trying to summarize an IRC discussion on #debian-ftp:
- projectb does not store historical data currently
- but changing that would be easy
- once this is done, the data from UDD can be imported into dak
For reference, the current schema UDD uses is:
CREATE TABLE upload_history
(source text, version debversion, date timestamp with time zone,
changed_by text, changed_by_name text, changed_by_email text,
maintainer text, maintainer_name text, maintainer_email text, nmu
boolean, signed_by text, signed_by_name text, signed_by_email text,
key_id text, distribution text, file text,
fingerprint text,
PRIMARY KEY (source, version));
CREATE TABLE upload_history_architecture
(source text, version debversion, architecture text, file text,
PRIMARY KEY (source, version, architecture),
FOREIGN KEY (source, version) REFERENCES upload_history
DEFERRABLE);
CREATE TABLE upload_history_closes
(source text, version debversion, bug int, file text,
PRIMARY KEY (source, version, bug),
FOREIGN KEY (source, version) REFERENCES upload_history
DEFERRABLE);
Lucas
--
To UNSUBSCRIBE, email to debian-qa-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
Archive: http://lists.debian.org/20130302171423.ga20...@xanadu.blop.info
