Mercurial > ~dholland > hg > swallowtail > index.cgi
diff database/schema/subscription.sql @ 29:cd36b49f4437
fix.
now loads into postgresql92
| author | David A. Holland |
|---|---|
| date | Sun, 26 May 2013 23:24:45 -0400 |
| parents | 68cc276ac118 |
| children | 40f64a96481f |
line wrap: on
line diff
--- a/database/schema/subscription.sql Sun May 26 22:13:33 2013 -0400 +++ b/database/schema/subscription.sql Sun May 26 23:24:45 2013 -0400 @@ -14,7 +14,7 @@ CREATE TABLE subscriptions ( pr bigint not null references PRs (id), - user bigint not null references users (id), + userid bigint not null references users (id), batch boolean not null, reporter boolean not null, responsible boolean not null @@ -25,7 +25,7 @@ -- -- SELECT id, responsible FROM PRs, subscriptions, users -- WHERE PRs.id = subscriptions.id --- AND subscriptions.user = users.id +-- AND subscriptions.userid = users.id -- AND PRs.state <> 'closed' -- AND subscriptions.responsible -- AND NOT users.responsible @@ -35,7 +35,7 @@ -- -- SELECT id, responsible FROM PRs, subscriptions, users -- WHERE PRs.id = subscriptions.id --- AND subscriptions.user = users.id +-- AND subscriptions.userid = users.id -- AND PRs.state = 'closed' -- AND subscriptions.responsible -- AND NOT users.oldresponsible