summaryrefslogtreecommitdiff
path: root/tools/sql-migrate-20100102.sql
blob: 8000121ded6cdf15bc806565a7c6e975e2266a33 (plain)
1
2
3
4
5
6
7
8
CREATE TABLE sshkeys(
   id SERIAL PRIMARY KEY,
   name TEXT REFERENCES users ON DELETE CASCADE,
   key TEXT
);
CREATE INDEX sshkeys_name ON sshkeys(name);
GRANT ALL ON sshkeys TO pypi;
GRANT ALL ON sshkeys_id_seq TO pypi;