diff options
Diffstat (limited to 'OpenSim/Data/PGSQL/Resources/AuthStore.migrations')
-rw-r--r-- | OpenSim/Data/PGSQL/Resources/AuthStore.migrations | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/OpenSim/Data/PGSQL/Resources/AuthStore.migrations b/OpenSim/Data/PGSQL/Resources/AuthStore.migrations index a1f5b61..043a8f7 100644 --- a/OpenSim/Data/PGSQL/Resources/AuthStore.migrations +++ b/OpenSim/Data/PGSQL/Resources/AuthStore.migrations | |||
@@ -30,3 +30,11 @@ BEGIN TRANSACTION; | |||
30 | 30 | ||
31 | COMMIT; | 31 | COMMIT; |
32 | 32 | ||
33 | :VERSION 3 | ||
34 | |||
35 | BEGIN TRANSACTION; | ||
36 | |||
37 | CREATE UNIQUE INDEX auth_pkey ON auth USING btree (uuid); | ||
38 | ALTER TABLE tokens ADD CONSTRAINT "uuid_token" UNIQUE ("uuid","token") NOT DEFERRABLE INITIALLY IMMEDIATE; | ||
39 | |||
40 | COMMIT; \ No newline at end of file | ||