aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
authorMelanie2009-12-29 18:31:27 +0000
committerMelanie2009-12-29 18:31:27 +0000
commit18ca978b81fb504b53bddadf292319b85807a299 (patch)
tree6b692d64a318d056246aa64a1edd89b37a048802 /OpenSim/Data/MySQL/Resources
parent* Added useraccount table (diff)
downloadopensim-SC_OLD-18ca978b81fb504b53bddadf292319b85807a299.zip
opensim-SC_OLD-18ca978b81fb504b53bddadf292319b85807a299.tar.gz
opensim-SC_OLD-18ca978b81fb504b53bddadf292319b85807a299.tar.bz2
opensim-SC_OLD-18ca978b81fb504b53bddadf292319b85807a299.tar.xz
Give the new user tables the once-over. Strip the current set of methods
from IUserAccountService, we need to define what goes in there. Change the handler to the generic handler. Adjust migrations, add index
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/001_UserAccount.sql4
-rw-r--r--OpenSim/Data/MySQL/Resources/002_UserAccount.sql5
-rw-r--r--OpenSim/Data/MySQL/Resources/003_UserAccount.sql9
3 files changed, 16 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_UserAccount.sql b/OpenSim/Data/MySQL/Resources/001_UserAccount.sql
index f946430..7d63816 100644
--- a/OpenSim/Data/MySQL/Resources/001_UserAccount.sql
+++ b/OpenSim/Data/MySQL/Resources/001_UserAccount.sql
@@ -1,7 +1,7 @@
1BEGIN; 1BEGIN;
2 2
3CREATE TABLE `useraccount` ( 3CREATE TABLE `UserAccounts` (
4 `UserID` CHAR(36) NOT NULL, 4 `PrincipalID` CHAR(36) NOT NULL,
5 `ScopeID` CHAR(36) NOT NULL, 5 `ScopeID` CHAR(36) NOT NULL,
6 `FirstName` VARCHAR(64) NOT NULL, 6 `FirstName` VARCHAR(64) NOT NULL,
7 `LastName` VARCHAR(64) NOT NULL, 7 `LastName` VARCHAR(64) NOT NULL,
diff --git a/OpenSim/Data/MySQL/Resources/002_UserAccount.sql b/OpenSim/Data/MySQL/Resources/002_UserAccount.sql
new file mode 100644
index 0000000..08a0f87
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/002_UserAccount.sql
@@ -0,0 +1,5 @@
1BEGIN;
2
3INSERT INTO UserAccounts (UserID, ScopeID, FirstName, LastName, Email, ServiceURLs, Created) SELECT `UUID` AS PrincipalID, '00000000-0000-0000-0000-000000000000' AS ScopeID, username AS FirstName, lastname AS LastName, email as Email, CONCAT('AssetServerURI=', userAssetURI, ' InventoryServerURI=', userInventoryURI, ' GatewayURI= HomeURI=') AS ServiceURLs, created as Created FROM users;
4
5COMMIT;
diff --git a/OpenSim/Data/MySQL/Resources/003_UserAccount.sql b/OpenSim/Data/MySQL/Resources/003_UserAccount.sql
new file mode 100644
index 0000000..e42d93b
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/003_UserAccount.sql
@@ -0,0 +1,9 @@
1BEGIN;
2
3CREATE UNIQUE INDEX PrincipalID ON UserAccounts(PrincipalID);
4CREATE INDEX Email ON UserAccounts(Email);
5CREATE INDEX FirstName ON UserAccounts(FirstName);
6CREATE INDEX LastName ON UserAccounts(LastName);
7CREATE INDEX Name ON UserAccounts(FirstName,LastName);
8
9COMMIT;