diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/Avatar.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/Avatar.migrations | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/Avatar.migrations b/OpenSim/Data/MySQL/Resources/Avatar.migrations new file mode 100644 index 0000000..8d0eee6 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/Avatar.migrations | |||
@@ -0,0 +1,12 @@ | |||
1 | :VERSION 1 | ||
2 | |||
3 | BEGIN; | ||
4 | |||
5 | CREATE TABLE Avatars ( | ||
6 | PrincipalID CHAR(36) NOT NULL, | ||
7 | Name VARCHAR(32) NOT NULL, | ||
8 | Value VARCHAR(255) NOT NULL DEFAULT '', | ||
9 | PRIMARY KEY(PrincipalID, Name), | ||
10 | KEY(PrincipalID)); | ||
11 | |||
12 | COMMIT; | ||