aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/UserProfiles.migrations
diff options
context:
space:
mode:
authoronefang2019-05-19 21:24:15 +1000
committeronefang2019-05-19 21:24:15 +1000
commit5e4d6cab00cb29cd088ab7b62ab13aff103b64cb (patch)
treea9fbc62df9eb2d1d9ba2698d8552eae71eca20d8 /OpenSim/Data/MySQL/Resources/UserProfiles.migrations
parentAdd a build script. (diff)
downloadopensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.zip
opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.gz
opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.bz2
opensim-SC_OLD-5e4d6cab00cb29cd088ab7b62ab13aff103b64cb.tar.xz
Dump OpenSim 0.9.0.1 into it's own branch.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/UserProfiles.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/UserProfiles.migrations28
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
3begin; 3begin;
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
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=MyISAM DEFAULT CHARSET=latin1; 30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31 31
32 32
33CREATE TABLE IF NOT EXISTS `userpicks` ( 33CREATE 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
51CREATE TABLE IF NOT EXISTS `userprofile` ( 52CREATE 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
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,
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
82commit;
83 77
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,
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;
93commit;
94 85
95:VERSION 4 # -------------------------------
96begin;
97ALTER TABLE userpicks ADD COLUMN gatekeeper varchar(255);
98commit; 86commit;