diff options
| author | UbitUmarov | 2015-09-21 12:07:17 +0100 |
|---|---|---|
| committer | UbitUmarov | 2015-09-21 12:07:17 +0100 |
| commit | f272a023e2ba3d8b44852819b79ce7af1341a695 (patch) | |
| tree | acf8faabb1acd8b10b8b4ad04f6687152d753084 /OpenSim/Data/SQLite/Resources/UserAccount.migrations | |
| parent | revert my change to the range of greyscale image maps, setting it back to 0 ... (diff) | |
| download | opensim-SC_OLD-f272a023e2ba3d8b44852819b79ce7af1341a695.zip opensim-SC_OLD-f272a023e2ba3d8b44852819b79ce7af1341a695.tar.gz opensim-SC_OLD-f272a023e2ba3d8b44852819b79ce7af1341a695.tar.bz2 opensim-SC_OLD-f272a023e2ba3d8b44852819b79ce7af1341a695.tar.xz | |
SQLite db migration update
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/UserAccount.migrations')
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/UserAccount.migrations | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/UserAccount.migrations b/OpenSim/Data/SQLite/Resources/UserAccount.migrations index 854fe69..f37a222 100644 --- a/OpenSim/Data/SQLite/Resources/UserAccount.migrations +++ b/OpenSim/Data/SQLite/Resources/UserAccount.migrations | |||
| @@ -25,3 +25,11 @@ BEGIN TRANSACTION; | |||
| 25 | INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, surname AS LastName, '' as Email, '' AS ServiceURLs, created as Created FROM users; | 25 | INSERT INTO UserAccounts (PrincipalID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, surname AS LastName, '' as Email, '' AS ServiceURLs, created as Created FROM users; |
| 26 | 26 | ||
| 27 | COMMIT; | 27 | COMMIT; |
| 28 | |||
| 29 | :VERSION 3 # ------------------------- | ||
| 30 | |||
| 31 | BEGIN; | ||
| 32 | |||
| 33 | ALTER TABLE `UserAccounts` ADD `active` BOOLEAN NOT NULL DEFAULT TRUE; | ||
| 34 | |||
| 35 | COMMIT; \ No newline at end of file | ||