diff options
| author | martin.von.loewis <devnull@localhost> | 2009-09-25 16:32:49 +0000 |
|---|---|---|
| committer | martin.von.loewis <devnull@localhost> | 2009-09-25 16:32:49 +0000 |
| commit | 6a2fcb639f2aa4876d5c7acc4e08d7f0756ccd8b (patch) | |
| tree | f2d28bf78fbf85117cde5b51fcad6e8e4f4776f7 /pkgbase_schema.sql | |
| parent | 2708870ed2f07deac1a7d91f0872f832d022bf38 (diff) | |
| download | decorator-6a2fcb639f2aa4876d5c7acc4e08d7f0756ccd8b.tar.gz | |
Copy ratings table from tools script.
Diffstat (limited to 'pkgbase_schema.sql')
| -rw-r--r-- | pkgbase_schema.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/pkgbase_schema.sql b/pkgbase_schema.sql index 9d2a8d1..9c6da96 100644 --- a/pkgbase_schema.sql +++ b/pkgbase_schema.sql @@ -283,3 +283,16 @@ CREATE TABLE mirrors ( user_name TEXT REFERENCES users ); +-- ratings +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); + |