aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/Avatar.migrations
diff options
context:
space:
mode:
authorAlexRa2010-05-01 17:43:10 +0300
committerAlexRa2010-05-16 17:04:13 +0300
commitee713cb253c1ef2d09de235964e02e7621649dd8 (patch)
treeb85373e71ddc2ece69726ea60c0f636ccc302c72 /OpenSim/Data/MySQL/Resources/Avatar.migrations
parentAdded MySqlMigrations.cs (supports stored proc/funcs) (diff)
downloadopensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.zip
opensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.tar.gz
opensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.tar.bz2
opensim-SC_OLD-ee713cb253c1ef2d09de235964e02e7621649dd8.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 'OpenSim/Data/MySQL/Resources/Avatar.migrations')
-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;