|
13365.3.2
by William Grant
Stormify OAuthNonce, replace id primary key with (access_token, request_timestamp, nonce). |
1 |
-- Copyright 2011 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
SET client_min_messages=ERROR; |
|
4 |
||
|
13365.3.4
by William Grant
Don't use the evil branchrevision.id backdoor. Just drop the old constraints and add a new one. |
5 |
ALTER TABLE oauthnonce DROP CONSTRAINT oauthnonce_pkey; |
6 |
ALTER TABLE oauthnonce DROP CONSTRAINT |
|
7 |
oauthnonce__access_token__request_timestamp__nonce__key; |
|
8 |
ALTER TABLE oauthnonce ADD PRIMARY KEY |
|
9 |
(access_token, request_timestamp, nonce); |
|
10 |
||
11 |
ALTER TABLE oauthnonce DROP COLUMN id; |
|
|
13365.3.2
by William Grant
Stormify OAuthNonce, replace id primary key with (access_token, request_timestamp, nonce). |
12 |
|
|
7675.1209.1
by William Grant
Fix patch number from last merge from 2208-99-0 to 2208-77-0. Oops. |
13 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 77, 0); |
|
13365.3.2
by William Grant
Stormify OAuthNonce, replace id primary key with (access_token, request_timestamp, nonce). |
14 |