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` (
 commit;
+:VERSION 3         # -------------------------------
+begin;
+CREATE TABLE IF NOT EXISTS `usersettings` (
+  `useruuid` varchar(36) NOT NULL,
+  `imviaemail` enum('true','false') NOT NULL,
+  `visible` enum('true','false') NOT NULL,
+  `email` varchar(254) NOT NULL,
+  PRIMARY KEY (`useruuid`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+commit;
+\ No newline at end of file

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