aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/001_UserAccount.sql
diff options
context:
space:
mode:
authorDiva Canto2010-02-20 17:52:38 -0800
committerDiva Canto2010-02-20 17:52:38 -0800
commit0ab6aac05255078a9d190f6623b2d86d5253d955 (patch)
tree311cb082d2a7f41496ae000562b38bdb2b7111d5 /OpenSim/Data/SQLite/Resources/001_UserAccount.sql
parent* Added a sanity check for missing asset data in LLClientView (diff)
downloadopensim-SC-0ab6aac05255078a9d190f6623b2d86d5253d955.zip
opensim-SC-0ab6aac05255078a9d190f6623b2d86d5253d955.tar.gz
opensim-SC-0ab6aac05255078a9d190f6623b2d86d5253d955.tar.bz2
opensim-SC-0ab6aac05255078a9d190f6623b2d86d5253d955.tar.xz
Added UserAccountData and auth to the SQLite connector. Compiles, runs, but access to these tables doesn't work.
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/001_UserAccount.sql')
-rw-r--r--OpenSim/Data/SQLite/Resources/001_UserAccount.sql17
1 files changed, 17 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/001_UserAccount.sql b/OpenSim/Data/SQLite/Resources/001_UserAccount.sql
new file mode 100644
index 0000000..f9bf24c
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/001_UserAccount.sql
@@ -0,0 +1,17 @@
1BEGIN TRANSACTION;
2
3-- useraccounts table
4CREATE TABLE UserAccounts (
5 PrincipalID CHAR(36) NOT NULL,
6 ScopeID CHAR(36) NOT NULL,
7 FirstName VARCHAR(64) NOT NULL,
8 LastName VARCHAR(64) NOT NULL,
9 Email VARCHAR(64),
10 ServiceURLs TEXT,
11 Created INT(11),
12 UserLevel integer NOT NULL DEFAULT 0,
13 UserFlags integer NOT NULL DEFAULT 0,
14 UserTitle varchar(64) NOT NULL DEFAULT ''
15);
16
17COMMIT; \ No newline at end of file