diff options
| author | Justin Clark-Casey (justincc) | 2011-04-07 23:16:36 +0100 |
|---|---|---|
| committer | Justin Clark-Casey (justincc) | 2011-04-07 23:20:04 +0100 |
| commit | 9d40c0dcc70462d78d6347676927b05eed245a9a (patch) | |
| tree | 2f7fb8f320a93c15dde9e1bf7ef53d4999743601 /OpenSim/Data/SQLiteLegacy/Resources/001_UserAccount.sql | |
| parent | Bundle a built-from-source Mac OS X sqlite3 universal dylib with OpenSim and ... (diff) | |
| download | opensim-SC_OLD-9d40c0dcc70462d78d6347676927b05eed245a9a.zip opensim-SC_OLD-9d40c0dcc70462d78d6347676927b05eed245a9a.tar.gz opensim-SC_OLD-9d40c0dcc70462d78d6347676927b05eed245a9a.tar.bz2 opensim-SC_OLD-9d40c0dcc70462d78d6347676927b05eed245a9a.tar.xz | |
Remove the SQLite legacy adaptor. This is no longer needed now that the main adaptor works on Mac OS X.
The SQLite legacy adapator was also not at all well maintained, even worse than the mainline sqlite adapator.
Diffstat (limited to 'OpenSim/Data/SQLiteLegacy/Resources/001_UserAccount.sql')
| -rw-r--r-- | OpenSim/Data/SQLiteLegacy/Resources/001_UserAccount.sql | 17 |
1 files changed, 0 insertions, 17 deletions
diff --git a/OpenSim/Data/SQLiteLegacy/Resources/001_UserAccount.sql b/OpenSim/Data/SQLiteLegacy/Resources/001_UserAccount.sql deleted file mode 100644 index c38d9a7..0000000 --- a/OpenSim/Data/SQLiteLegacy/Resources/001_UserAccount.sql +++ /dev/null | |||
| @@ -1,17 +0,0 @@ | |||
| 1 | BEGIN TRANSACTION; | ||
| 2 | |||
| 3 | -- useraccounts table | ||
| 4 | CREATE TABLE UserAccounts ( | ||
| 5 | PrincipalID CHAR(36) primary key, | ||
| 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 | |||
| 17 | COMMIT; \ No newline at end of file | ||