udd/sql/ftpnew.sql

-- http://ftp-master.debian.org/new.822

BEGIN;

DROP TABLE IF EXISTS new_sources CASCADE;
DROP TABLE IF EXISTS new_packages CASCADE;

-- Sources
CREATE TABLE new_sources (
       source text,
       version text,
       maintainer text,
       maintainer_name text,
       maintainer_email text,
       format text,
       files text,
       uploaders text,
       binaries text,             -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Binary:"
       changed_by text,           -- Uploader?
       architecture text,
       homepage text,             -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Homepage:"
       vcs_type text,             -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-*:"
       vcs_url text,              -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-*:"
       vcs_browser text,          -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-Browser:"
       section text,
       component text,
       distribution text,
       closes int,                -- WNPP bug #
       license text,              -- trying to parse http://ftp-master.debian.org/new/<bin1>_<version>.html#binary-<bin1>-copyright field "License:"
       last_modified timestamp,
       queue text,
    PRIMARY KEY (source, version, distribution)
);


-- Packages
CREATE TABLE new_packages (
       package text,
       version text,
       architecture text,
       maintainer text,
       description text,          -- by parsing http://ftp-master.debian.org/new/<bin>_<version>.html#control field "Description:"
       source text,
       depends text,
       recommends text,
       suggests text,
       enhances text,
       pre_depends text,
       breaks text,
       replaces text,
       provides text,
       conflicts text,
       installed_size integer,
       homepage text,
       long_description text,
       section text,
       component text,
       distribution text,
       license text,              -- trying to parse http://ftp-master.debian.org/new/<package>_<version>.html#binary-<package>-copyright field "License:"
    PRIMARY KEY (package, version, architecture)
);

COMMIT;

1	-- http://ftp-master.debian.org/new.822
2
3	BEGIN;
4
5	DROP TABLE IF EXISTS new_sources CASCADE;
6	DROP TABLE IF EXISTS new_packages CASCADE;
7
8	-- Sources
9	CREATE TABLE new_sources (
10	source text,
11	version text,
12	maintainer text,
13	maintainer_name text,
14	maintainer_email text,
15	format text,
16	files text,
17	uploaders text,
18	binaries text, -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Binary:"
19	changed_by text, -- Uploader?
20	architecture text,
21	homepage text, -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Homepage:"
22	vcs_type text, -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-*:"
23	vcs_url text, -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-*:"
24	vcs_browser text, -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-Browser:"
25	section text,
26	component text,
27	distribution text,
28	closes int, -- WNPP bug #
29	license text, -- trying to parse http://ftp-master.debian.org/new/<bin1>_<version>.html#binary-<bin1>-copyright field "License:"
30	last_modified timestamp,
31	queue text,
32	PRIMARY KEY (source, version, distribution)
33	);
34
35
36	-- Packages
37	CREATE TABLE new_packages (
38	package text,
39	version text,
40	architecture text,
41	maintainer text,
42	description text, -- by parsing http://ftp-master.debian.org/new/<bin>_<version>.html#control field "Description:"
43	source text,
44	depends text,
45	recommends text,
46	suggests text,
47	enhances text,
48	pre_depends text,
49	breaks text,
50	replaces text,
51	provides text,
52	conflicts text,
53	installed_size integer,
54	homepage text,
55	long_description text,
56	section text,
57	component text,
58	distribution text,
59	license text, -- trying to parse http://ftp-master.debian.org/new/<package>_<version>.html#binary-<package>-copyright field "License:"
60	PRIMARY KEY (package, version, architecture)
61	);
62
63	COMMIT;
64