/[collab-qa]/udd/sql/ftpnew.sql
ViewVC logotype

Diff of /udd/sql/ftpnew.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1473 by tille, Tue Jun 9 21:50:03 2009 UTC revision 1474 by tille, Wed Jun 10 11:29:30 2009 UTC
# Line 2  Line 2 
2    
3  BEGIN;  BEGIN;
4    
5    DROP TABLE IF EXISTS new_sources CASCADE;
6    DROP TABLE IF EXISTS new_packages CASCADE;
7    
8  -- Sources  -- Sources
9  CREATE TABLE new_sources (  CREATE TABLE new_sources (
10         source text,         source text,
# Line 19  CREATE TABLE new_sources ( Line 22  CREATE TABLE new_sources (
22         vcs_type text,             -- by parsing http://ftp-master.debian.org/new/<src>_<version>.html#dsc field "Vcs-*:"         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-*:"         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:"         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,         distribution text,
28         closes int,                -- WNPP bug #         closes int,                -- WNPP bug #
29         license text,              -- trying to parse http://ftp-master.debian.org/new/<bin1>_<version>.html#binary-<bin1>-copyright field "License:"         license text,              -- trying to parse http://ftp-master.debian.org/new/<bin1>_<version>.html#binary-<bin1>-copyright field "License:"
# Line 47  CREATE TABLE new_packages ( Line 52  CREATE TABLE new_packages (
52         conflicts text,         conflicts text,
53         installed_size integer,         installed_size integer,
54         homepage text,         homepage text,
        section text,  
55         long_description text,         long_description text,
56           section text,
57           component text,
58         distribution text,         distribution text,
59         license text,              -- trying to parse http://ftp-master.debian.org/new/<package>_<version>.html#binary-<package>-copyright field "License:"         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)      PRIMARY KEY (package, version, architecture)
Legend:
Removed from v.1473  
changed lines
  Added in v.1474
  ViewVC Help
Powered by ViewVC 1.1.5