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/MySQL/Resources/UserProfiles.migrations | |
| parent | Adding profile partners fix to SQLite and PgSQL drivers (diff) | |
| download | opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.zip opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.gz opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.bz2 opensim-SC_OLD-1842388bb4dcf5ecd57732ffa877b6ca1a3dec7b.tar.xz | |
Add support for user preferences (im via email)
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/UserProfiles.migrations')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/UserProfiles.migrations | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations index c29f1ab..bd325da 100644 --- a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations | |||
| @@ -81,3 +81,13 @@ CREATE TABLE IF NOT EXISTS `userdata` ( | |||
| 81 | 81 | ||
| 82 | commit; | 82 | commit; |
| 83 | 83 | ||
| 84 | :VERSION 3 # ------------------------------- | ||
| 85 | begin; | ||
| 86 | CREATE TABLE IF NOT EXISTS `usersettings` ( | ||
| 87 | `useruuid` varchar(36) NOT NULL, | ||
| 88 | `imviaemail` enum('true','false') NOT NULL, | ||
| 89 | `visible` enum('true','false') NOT NULL, | ||
| 90 | `email` varchar(254) NOT NULL, | ||
| 91 | PRIMARY KEY (`useruuid`) | ||
| 92 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | ||
| 93 | commit; \ No newline at end of file | ||