aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/Avatar.migrations
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/Avatar.migrations')
-rw-r--r--OpenSim/Data/MySQL/Resources/Avatar.migrations23
1 files changed, 8 insertions, 15 deletions
diff --git a/OpenSim/Data/MySQL/Resources/Avatar.migrations b/OpenSim/Data/MySQL/Resources/Avatar.migrations
index f7cf176..c5ec9ca 100644
--- a/OpenSim/Data/MySQL/Resources/Avatar.migrations
+++ b/OpenSim/Data/MySQL/Resources/Avatar.migrations
@@ -1,20 +1,13 @@
1:VERSION 1 1:VERSION 3
2 2
3BEGIN; 3BEGIN;
4 4
5CREATE TABLE Avatars ( 5CREATE TABLE IF NOT EXISTS `Avatars` (
6 PrincipalID CHAR(36) NOT NULL, 6 `PrincipalID` char(36) NOT NULL,
7 Name VARCHAR(32) NOT NULL, 7 `Name` varchar(32) NOT NULL,
8 Value VARCHAR(255) NOT NULL DEFAULT '', 8 `Value` text,
9 PRIMARY KEY(PrincipalID, Name), 9 PRIMARY KEY (`PrincipalID`,`Name`),
10 KEY(PrincipalID)); 10 KEY `PrincipalID` (`PrincipalID`)
11 11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12COMMIT;
13
14:VERSION 2
15
16BEGIN;
17
18alter table Avatars change column Value Value text;
19 12
20COMMIT; 13COMMIT;