diff options
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/AuthStore.migrations (renamed from OpenSim/Data/SQLite/Resources/001_AuthStore.sql) | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_AuthStore.sql b/OpenSim/Data/SQLite/Resources/AuthStore.migrations index 468567d..ca6bdf5 100644 --- a/OpenSim/Data/SQLite/Resources/001_AuthStore.sql +++ b/OpenSim/Data/SQLite/Resources/AuthStore.migrations | |||
@@ -1,3 +1,5 @@ | |||
1 | :VERSION 1 | ||
2 | |||
1 | BEGIN TRANSACTION; | 3 | BEGIN TRANSACTION; |
2 | 4 | ||
3 | CREATE TABLE auth ( | 5 | CREATE TABLE auth ( |
@@ -16,3 +18,12 @@ CREATE TABLE tokens ( | |||
16 | ); | 18 | ); |
17 | 19 | ||
18 | COMMIT; | 20 | COMMIT; |
21 | |||
22 | :VERSION 2 | ||
23 | |||
24 | BEGIN TRANSACTION; | ||
25 | |||
26 | INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users; | ||
27 | |||
28 | COMMIT; | ||
29 | |||