diff options
| author | BlueWall | 2013-12-06 02:52:13 -0500 |
|---|---|---|
| committer | BlueWall | 2013-12-06 02:52:13 -0500 |
| commit | 1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b (patch) | |
| tree | 0d1feaac1a3ae79aa11cc435553f086a3d581581 /OpenSim/Data/SQLite/Resources | |
| parent | Adding profile partners fix to SQLite and PgSQL drivers (diff) | |
| download | opensim-SC-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.zip opensim-SC-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.gz opensim-SC-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.bz2 opensim-SC-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.xz | |
Add support for user preferences (im via email)
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
| -rw-r--r-- | OpenSim/Data/SQLite/Resources/UserProfiles.migrations | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/OpenSim/Data/SQLite/Resources/UserProfiles.migrations b/OpenSim/Data/SQLite/Resources/UserProfiles.migrations index 16581f6..86434e8 100644 --- a/OpenSim/Data/SQLite/Resources/UserProfiles.migrations +++ b/OpenSim/Data/SQLite/Resources/UserProfiles.migrations | |||
| @@ -88,3 +88,15 @@ CREATE TABLE IF NOT EXISTS userdata ( | |||
| 88 | 88 | ||
| 89 | commit; | 89 | commit; |
| 90 | 90 | ||
| 91 | |||
| 92 | :VERSION 3 # ------------------------------- | ||
| 93 | |||
| 94 | begin; | ||
| 95 | CREATE TABLE IF NOT EXISTS usersettings ( | ||
| 96 | useruuid char(36) NOT NULL, | ||
| 97 | imviaemail binary(1) NOT NULL, | ||
| 98 | visible binary(1) NOT NULL, | ||
| 99 | email varchar(254) NOT NULL, | ||
| 100 | PRIMARY KEY (useruuid) | ||
| 101 | ) | ||
| 102 | commit; \ No newline at end of file | ||