diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/UserProfiles.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UserProfiles.migrations | 28 |
1 files changed, 8 insertions, 20 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations index 0759b26..cfcc18b 100644 --- a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations +++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations | |||
@@ -1,4 +1,4 @@ | |||
1 | :VERSION 1 # ------------------------------- | 1 | :VERSION 5 # ------------------------------- |
2 | 2 | ||
3 | begin; | 3 | begin; |
4 | 4 | ||
@@ -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=MyISAM DEFAULT CHARSET=latin1; | 22 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
23 | 23 | ||
24 | 24 | ||
25 | CREATE TABLE IF NOT EXISTS `usernotes` ( | 25 | CREATE 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=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` ( |
@@ -44,8 +44,9 @@ CREATE TABLE IF NOT EXISTS `userpicks` ( | |||
44 | `posglobal` varchar(255) NOT NULL, | 44 | `posglobal` varchar(255) NOT NULL, |
45 | `sortorder` int(2) NOT NULL, | 45 | `sortorder` int(2) NOT NULL, |
46 | `enabled` enum('true','false') NOT NULL, | 46 | `enabled` enum('true','false') NOT NULL, |
47 | `gatekeeper` varchar(255), | ||
47 | PRIMARY KEY (`pickuuid`) | 48 | PRIMARY KEY (`pickuuid`) |
48 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 49 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
49 | 50 | ||
50 | 51 | ||
51 | CREATE TABLE IF NOT EXISTS `userprofile` ( | 52 | CREATE TABLE IF NOT EXISTS `userprofile` ( |
@@ -64,35 +65,22 @@ CREATE TABLE IF NOT EXISTS `userprofile` ( | |||
64 | `profileFirstImage` varchar(36) NOT NULL, | 65 | `profileFirstImage` varchar(36) NOT NULL, |
65 | `profileFirstText` text NOT NULL, | 66 | `profileFirstText` text NOT NULL, |
66 | PRIMARY KEY (`useruuid`) | 67 | PRIMARY KEY (`useruuid`) |
67 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 68 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
68 | 69 | ||
69 | commit; | ||
70 | |||
71 | :VERSION 2 # ------------------------------- | ||
72 | |||
73 | begin; | ||
74 | CREATE TABLE IF NOT EXISTS `userdata` ( | 70 | CREATE TABLE IF NOT EXISTS `userdata` ( |
75 | `UserId` char(36) NOT NULL, | 71 | `UserId` char(36) NOT NULL, |
76 | `TagId` varchar(64) NOT NULL, | 72 | `TagId` varchar(64) NOT NULL, |
77 | `DataKey` varchar(255), | 73 | `DataKey` varchar(255), |
78 | `DataVal` varchar(255), | 74 | `DataVal` varchar(255), |
79 | PRIMARY KEY (`UserId`,`TagId`) | 75 | PRIMARY KEY (`UserId`,`TagId`) |
80 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 76 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
81 | |||
82 | commit; | ||
83 | 77 | ||
84 | :VERSION 3 # ------------------------------- | ||
85 | begin; | ||
86 | CREATE TABLE IF NOT EXISTS `usersettings` ( | 78 | CREATE TABLE IF NOT EXISTS `usersettings` ( |
87 | `useruuid` varchar(36) NOT NULL, | 79 | `useruuid` varchar(36) NOT NULL, |
88 | `imviaemail` enum('true','false') NOT NULL, | 80 | `imviaemail` enum('true','false') NOT NULL, |
89 | `visible` enum('true','false') NOT NULL, | 81 | `visible` enum('true','false') NOT NULL, |
90 | `email` varchar(254) NOT NULL, | 82 | `email` varchar(254) NOT NULL, |
91 | PRIMARY KEY (`useruuid`) | 83 | PRIMARY KEY (`useruuid`) |
92 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 84 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
93 | commit; | ||
94 | 85 | ||
95 | :VERSION 4 # ------------------------------- | ||
96 | begin; | ||
97 | ALTER TABLE userpicks ADD COLUMN gatekeeper varchar(255); | ||
98 | commit; | 86 | commit; |