aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/UserProfiles.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/UserProfiles.migrations12
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
index cfcc18b..512b6ed 100644
--- a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
+++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
@@ -19,7 +19,7 @@ CREATE TABLE IF NOT EXISTS `classifieds` (
19 `classifiedflags` int(8) NOT NULL, 19 `classifiedflags` int(8) NOT NULL,
20 `priceforlisting` int(5) NOT NULL, 20 `priceforlisting` int(5) NOT NULL,
21 PRIMARY KEY (`classifieduuid`) 21 PRIMARY KEY (`classifieduuid`)
22) ENGINE=InnoDB DEFAULT CHARSET=latin1; 22) ENGINE=MyISAM DEFAULT CHARSET=latin1;
23 23
24 24
25CREATE TABLE IF NOT EXISTS `usernotes` ( 25CREATE TABLE IF NOT EXISTS `usernotes` (
@@ -27,7 +27,7 @@ CREATE TABLE IF NOT EXISTS `usernotes` (
27 `targetuuid` varchar(36) NOT NULL, 27 `targetuuid` varchar(36) NOT NULL,
28 `notes` text NOT NULL, 28 `notes` text NOT NULL,
29 UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`) 29 UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1; 30) ENGINE=MyISAM DEFAULT CHARSET=latin1;
31 31
32 32
33CREATE TABLE IF NOT EXISTS `userpicks` ( 33CREATE TABLE IF NOT EXISTS `userpicks` (
@@ -46,7 +46,7 @@ CREATE TABLE IF NOT EXISTS `userpicks` (
46 `enabled` enum('true','false') NOT NULL, 46 `enabled` enum('true','false') NOT NULL,
47 `gatekeeper` varchar(255), 47 `gatekeeper` varchar(255),
48 PRIMARY KEY (`pickuuid`) 48 PRIMARY KEY (`pickuuid`)
49) ENGINE=InnoDB DEFAULT CHARSET=latin1; 49) ENGINE=MyISAM DEFAULT CHARSET=latin1;
50 50
51 51
52CREATE TABLE IF NOT EXISTS `userprofile` ( 52CREATE TABLE IF NOT EXISTS `userprofile` (
@@ -65,7 +65,7 @@ CREATE TABLE IF NOT EXISTS `userprofile` (
65 `profileFirstImage` varchar(36) NOT NULL, 65 `profileFirstImage` varchar(36) NOT NULL,
66 `profileFirstText` text NOT NULL, 66 `profileFirstText` text NOT NULL,
67 PRIMARY KEY (`useruuid`) 67 PRIMARY KEY (`useruuid`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1; 68) ENGINE=MyISAM DEFAULT CHARSET=latin1;
69 69
70CREATE TABLE IF NOT EXISTS `userdata` ( 70CREATE TABLE IF NOT EXISTS `userdata` (
71 `UserId` char(36) NOT NULL, 71 `UserId` char(36) NOT NULL,
@@ -73,7 +73,7 @@ CREATE TABLE IF NOT EXISTS `userdata` (
73 `DataKey` varchar(255), 73 `DataKey` varchar(255),
74 `DataVal` varchar(255), 74 `DataVal` varchar(255),
75 PRIMARY KEY (`UserId`,`TagId`) 75 PRIMARY KEY (`UserId`,`TagId`)
76) ENGINE=InnoDB DEFAULT CHARSET=latin1; 76) ENGINE=MyISAM DEFAULT CHARSET=latin1;
77 77
78CREATE TABLE IF NOT EXISTS `usersettings` ( 78CREATE TABLE IF NOT EXISTS `usersettings` (
79 `useruuid` varchar(36) NOT NULL, 79 `useruuid` varchar(36) NOT NULL,
@@ -81,6 +81,6 @@ CREATE TABLE IF NOT EXISTS `usersettings` (
81 `visible` enum('true','false') NOT NULL, 81 `visible` enum('true','false') NOT NULL,
82 `email` varchar(254) NOT NULL, 82 `email` varchar(254) NOT NULL,
83 PRIMARY KEY (`useruuid`) 83 PRIMARY KEY (`useruuid`)
84) ENGINE=InnoDB DEFAULT CHARSET=latin1; 84) ENGINE=MyISAM DEFAULT CHARSET=latin1;
85 85
86commit; 86commit;