diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/UserProfiles.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UserProfiles.migrations | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations index 008e455..cfcc18b 100644 --- a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations | |||
@@ -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=MyISAM DEFAULT CHARSET=latin1; | 30 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
31 | 31 | ||
32 | 32 | ||
33 | CREATE TABLE IF NOT EXISTS `userpicks` ( | 33 | CREATE 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=MyISAM DEFAULT CHARSET=latin1; | 49 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
50 | 50 | ||
51 | 51 | ||
52 | CREATE TABLE IF NOT EXISTS `userprofile` ( | 52 | CREATE 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=MyISAM DEFAULT CHARSET=latin1; | 68 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
69 | 69 | ||
70 | CREATE TABLE IF NOT EXISTS `userdata` ( | 70 | CREATE 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=MyISAM DEFAULT CHARSET=latin1; | 76 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
77 | 77 | ||
78 | CREATE TABLE IF NOT EXISTS `usersettings` ( | 78 | CREATE 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=MyISAM DEFAULT CHARSET=latin1; | 84 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
85 | 85 | ||
86 | commit; | 86 | commit; |