/[collab-qa]/udd/src/setup-db.sql
ViewVC logotype

Diff of /udd/src/setup-db.sql

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

revision 1025 by he, Sat Aug 9 00:36:31 2008 UTC revision 1026 by he, Sat Aug 9 01:31:01 2008 UTC
# Line 126  CREATE TABLE carnivore_login Line 126  CREATE TABLE carnivore_login
126   (id int, login text,   (id int, login text,
127     PRIMARY KEY(id));     PRIMARY KEY(id));
128    
129    CREATE DOMAIN lintian_tag_type AS TEXT
130    NOT NULL
131    CHECK(
132         VALUE = 'error'
133      OR VALUE = 'warning'
134      OR VALUE = 'information'
135      OR VALUE = 'experimental'
136      OR VALUE = 'overriden'
137    );
138    
139    CREATE TABLE lintian (
140      package TEXT NOT NULL,
141      tag_type lintian_tag_type,
142      package_type TEXT,
143      tag TEXT NOT NULL
144    );
145    
146  CREATE INDEX packages_source_idx on packages(source);  CREATE INDEX packages_source_idx on packages(source);
147  CREATE INDEX sources_distribution_idx on sources(distribution);  CREATE INDEX sources_distribution_idx on sources(distribution);
148  CREATE INDEX sources_release_idx on sources(release);  CREATE INDEX sources_release_idx on sources(release);
# Line 156  GRANT SELECT ON carnivore_emails TO PUBL Line 173  GRANT SELECT ON carnivore_emails TO PUBL
173  GRANT SELECT ON carnivore_names TO PUBLIC;  GRANT SELECT ON carnivore_names TO PUBLIC;
174  GRANT SELECT ON carnivore_keys TO PUBLIC;  GRANT SELECT ON carnivore_keys TO PUBLIC;
175  GRANT SELECT ON carnivore_login TO PUBLIC;  GRANT SELECT ON carnivore_login TO PUBLIC;
176    GRANT SELECT ON lintian TO PUBLIC;
177    
Legend:
Removed from v.1025  
changed lines
  Added in v.1026
  ViewVC Help
Powered by ViewVC 1.1.5