tools/sql-migrate-20090914.sql


1
2
3
4
5
6
7
8
9
10
11
12

CREATE TABLE ratings(
   name TEXT,
   version TEXT,
   user_name TEXT REFERENCES users ON DELETE CASCADE,
   date TIMESTAMP,
   rating INTEGER,
   message TEXT,
   PRIMARY KEY (name, version, user_name),
   FOREIGN KEY (name, version) REFERENCES releases ON UPDATE CASCADE ON DELETE CASCADE
);
CREATE INDEX rating_name_version ON ratings(name, version);
GRANT ALL ON ratings TO pypi;