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.migrations16
1 files changed, 2 insertions, 14 deletions
diff --git a/OpenSim/Data/MySQL/Resources/UserProfiles.migrations b/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
index 0759b26..512b6ed 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
3begin; 3begin;
4 4
@@ -44,6 +44,7 @@ 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=MyISAM DEFAULT CHARSET=latin1;
49 50
@@ -66,11 +67,6 @@ CREATE TABLE IF NOT EXISTS `userprofile` (
66 PRIMARY KEY (`useruuid`) 67 PRIMARY KEY (`useruuid`)
67) ENGINE=MyISAM DEFAULT CHARSET=latin1; 68) ENGINE=MyISAM DEFAULT CHARSET=latin1;
68 69
69commit;
70
71:VERSION 2 # -------------------------------
72
73begin;
74CREATE TABLE IF NOT EXISTS `userdata` ( 70CREATE 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,
@@ -79,10 +75,6 @@ CREATE TABLE IF NOT EXISTS `userdata` (
79 PRIMARY KEY (`UserId`,`TagId`) 75 PRIMARY KEY (`UserId`,`TagId`)
80) ENGINE=MyISAM DEFAULT CHARSET=latin1; 76) ENGINE=MyISAM DEFAULT CHARSET=latin1;
81 77
82commit;
83
84:VERSION 3 # -------------------------------
85begin;
86CREATE TABLE IF NOT EXISTS `usersettings` ( 78CREATE 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,
@@ -90,9 +82,5 @@ CREATE TABLE IF NOT EXISTS `usersettings` (
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=MyISAM DEFAULT CHARSET=latin1;
93commit;
94 85
95:VERSION 4 # -------------------------------
96begin;
97ALTER TABLE userpicks ADD COLUMN gatekeeper varchar(255);
98commit; 86commit;