summaryrefslogtreecommitdiff
path: root/tools/sql-migrate-20070721.sql
blob: 74410d80daf4eead834d0f3e93079424c32e5792 (plain)
1
2
3
4
5
6
7
8
9
10
11
CREATE TABLE description_urls (
   name TEXT,
   version TEXT,
   url TEXT,
   FOREIGN KEY (name, version) REFERENCES releases (name, version)
);
CREATE INDEX description_urls_name_idx ON description_urls(name);
CREATE INDEX description_urls_name_version_idx ON description_urls(name, version);
grant all on description_urls to pypi;

-- run 'store.py config.ini updateurls' after installing this change