aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/AuthStore.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-06 22:44:57 +0300
committerAlexRa2010-05-18 22:16:10 +0300
commit6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9 (patch)
treed9a809d417ed531fbde0f041156b449d4030708a /OpenSim/Data/SQLite/Resources/AuthStore.migrations
parentConverted MySQL migration history to the new format (diff)
downloadopensim-SC-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.zip
opensim-SC-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.gz
opensim-SC-6e7b3950d70b0dbe3b765d596adc534a6ca3a2a9.tar.bz2
opensim-SC-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
1BEGIN TRANSACTION; 3BEGIN TRANSACTION;
2 4
3CREATE TABLE auth ( 5CREATE TABLE auth (
@@ -16,3 +18,12 @@ CREATE TABLE tokens (
16); 18);
17 19
18COMMIT; 20COMMIT;
21
22:VERSION 2
23
24BEGIN TRANSACTION;
25
26INSERT INTO auth (UUID, passwordHash, passwordSalt, webLoginKey) SELECT `UUID` AS UUID, `passwordHash` AS passwordHash, `passwordSalt` AS passwordSalt, `webLoginKey` AS webLoginKey FROM users;
27
28COMMIT;
29