Contents of /udd/src/schema/upload_history

CREATE TABLE %(table)s
 (id serial, package text, version text, date timestamp with time zone,
 changed_by text, maintainer text, nmu boolean, signed_by text, key_id text,
 closes int);

CREATE TABLE %(table)s_architecture
 (id int, architecture text,
 PRIMARY KEY (id, architecture));
  

GRANT SELECT ON %(table)s TO PUBLIC;
GRANT SELECT ON %(table)s_architecture TO PUBLIC;
1	CREATE TABLE %(table)s
2	(id serial, package text, version text, date timestamp with time zone,
3	changed_by text, maintainer text, nmu boolean, signed_by text, key_id text,
4	closes int);
5
6	CREATE TABLE %(table)s_architecture
7	(id int, architecture text,
8	PRIMARY KEY (id, architecture));
9
10
11	GRANT SELECT ON %(table)s TO PUBLIC;
12	GRANT SELECT ON %(table)s_architecture TO PUBLIC;