1 files changed, 31 insertions, 1 deletions

diff --git a/sql/osprofile.sql b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
index bcd5be0..87e99fa 100644
--- a/sql/osprofile.sql
+++ b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
@@ -1,3 +1,7 @@
+:VERSION 1         # -------------------------------
+
+begin;
+
 CREATE TABLE IF NOT EXISTS `classifieds` (
   `classifieduuid` char(36) NOT NULL,
   `creatoruuid` char(36) NOT NULL,
@@ -15,7 +19,8 @@ CREATE TABLE IF NOT EXISTS `classifieds` (
   `classifiedflags` int(8) NOT NULL,
   `priceforlisting` int(5) NOT NULL,
   PRIMARY KEY (`classifieduuid`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
 
 CREATE TABLE IF NOT EXISTS `usernotes` (
   `useruuid` varchar(36) NOT NULL,
@@ -24,6 +29,7 @@ CREATE TABLE IF NOT EXISTS `usernotes` (
   UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+
 CREATE TABLE IF NOT EXISTS `userpicks` (
   `pickuuid` varchar(36) NOT NULL,
   `creatoruuid` varchar(36) NOT NULL,
@@ -41,6 +47,7 @@ CREATE TABLE IF NOT EXISTS `userpicks` (
   PRIMARY KEY (`pickuuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+
 CREATE TABLE IF NOT EXISTS `userprofile` (
   `useruuid` varchar(36) NOT NULL,
   `profilePartner` varchar(36) NOT NULL,
@@ -59,6 +66,23 @@ CREATE TABLE IF NOT EXISTS `userprofile` (
   PRIMARY KEY (`useruuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
+commit;
+
+:VERSION 2         # -------------------------------
+ 
+begin;
+CREATE TABLE IF NOT EXISTS `userdata` (
+    `UserId` char(36) NOT NULL,
+    `TagId` varchar(64) NOT NULL,
+    `DataKey` varchar(255),
+    `DataVal` varchar(255),
+    PRIMARY KEY (`UserId`,`TagId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+commit;
+
+:VERSION 3         # -------------------------------
+begin;
 CREATE TABLE IF NOT EXISTS `usersettings` (
   `useruuid` varchar(36) NOT NULL,
   `imviaemail` enum('true','false') NOT NULL,
@@ -66,3 +90,9 @@ CREATE TABLE IF NOT EXISTS `usersettings` (
   `email` varchar(254) NOT NULL,
   PRIMARY KEY (`useruuid`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+commit;
+
+:VERSION 4         # -------------------------------
+begin;
+ALTER TABLE userpicks ADD COLUMN gatekeeper varchar(255);
+commit;