aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/Avatar.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-01 17:43:10 +0300
committerAlexRa2010-05-18 22:16:06 +0300
commite4419c34c30e1cf6529ced125f0c05aed24644a4 (patch)
treeb54d5aff69c63fefc27dea2b938c1838974d77ac /OpenSim/Data/MySQL/Resources/Avatar.migrations
parentAdded MySqlMigrations.cs (supports stored proc/funcs) (diff)
downloadopensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.zip
opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.gz
opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.bz2
opensim-SC_OLD-e4419c34c30e1cf6529ced125f0c05aed24644a4.tar.xz
Converted MySQL migration history to the new format
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MySQL/Resources/Avatar.migrations12
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
3BEGIN;
4
5CREATE 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
12COMMIT;