diff options
| author | AlexRa | 2010-05-06 22:44:57 +0300 |
|---|---|---|
| committer | AlexRa | 2010-05-18 22:16:10 +0300 |
| commit | 6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9 (patch) | |
| tree | d9a809d417ed531fbde0f041156b449d4030708a /OpenSim/Data/SQLite/Resources/001_AuthStore.sql | |
| parent | Converted MySQL migration history to the new format (diff) | |
| download | opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.zip opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.gz opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.bz2 opensim-SC_OLD-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.xz | |
Migrations for SQLite converted to new format
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 | |||