diff options
author | AlexRa | 2010-05-01 17:43:10 +0300 |
---|---|---|
committer | AlexRa | 2010-05-16 17:04:13 +0300 |
commit | ee713cb253c1ef2d09de235964e02e7621649dd8 (patch) | |
tree | b85373e71ddc2ece69726ea60c0f636ccc302c72 /OpenSim/Data/MySQL/Resources/UserStore.migrations | |
parent | Added MySqlMigrations.cs (supports stored proc/funcs) (diff) | |
download | opensim-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 '')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UserStore.migrations (renamed from OpenSim/Data/MySQL/Resources/001_UserStore.sql) | 63 |
1 files changed, 62 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_UserStore.sql b/OpenSim/Data/MySQL/Resources/UserStore.migrations index 29ebc7d..f054611 100644 --- a/OpenSim/Data/MySQL/Resources/001_UserStore.sql +++ b/OpenSim/Data/MySQL/Resources/UserStore.migrations | |||
@@ -1,3 +1,5 @@ | |||
1 | :VERSION 1 # ----------------------------- | ||
2 | |||
1 | BEGIN; | 3 | BEGIN; |
2 | 4 | ||
3 | SET FOREIGN_KEY_CHECKS=0; | 5 | SET FOREIGN_KEY_CHECKS=0; |
@@ -104,4 +106,63 @@ CREATE TABLE `users` ( | |||
104 | -- ---------------------------- | 106 | -- ---------------------------- |
105 | -- Records | 107 | -- Records |
106 | -- ---------------------------- | 108 | -- ---------------------------- |
107 | COMMIT; \ No newline at end of file | 109 | COMMIT; |
110 | |||
111 | :VERSION 2 # ----------------------------- | ||
112 | |||
113 | BEGIN; | ||
114 | |||
115 | ALTER TABLE users add homeRegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000'; | ||
116 | |||
117 | COMMIT; | ||
118 | |||
119 | :VERSION 3 # ----------------------------- | ||
120 | |||
121 | BEGIN; | ||
122 | |||
123 | ALTER TABLE users add userFlags integer NOT NULL default 0; | ||
124 | ALTER TABLE users add godLevel integer NOT NULL default 0; | ||
125 | |||
126 | COMMIT; | ||
127 | |||
128 | :VERSION 4 # ----------------------------- | ||
129 | |||
130 | BEGIN; | ||
131 | |||
132 | ALTER TABLE users add customType varchar(32) not null default ''; | ||
133 | ALTER TABLE users add partner char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
134 | |||
135 | COMMIT; | ||
136 | |||
137 | :VERSION 5 # ----------------------------- | ||
138 | |||
139 | BEGIN; | ||
140 | |||
141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=InnoDB; | ||
142 | |||
143 | COMMIT; | ||
144 | |||
145 | :VERSION 6 # ----------------------------- | ||
146 | |||
147 | BEGIN; | ||
148 | |||
149 | ALTER TABLE agents add currentLookAt varchar(36) not null default ''; | ||
150 | |||
151 | COMMIT; | ||
152 | |||
153 | :VERSION 7 # ----------------------------- | ||
154 | |||
155 | BEGIN; | ||
156 | |||
157 | ALTER TABLE users add email varchar(250); | ||
158 | |||
159 | COMMIT; | ||
160 | |||
161 | :VERSION 8 # ----------------------------- | ||
162 | |||
163 | BEGIN; | ||
164 | |||
165 | ALTER TABLE users add scopeID char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
166 | |||
167 | COMMIT; | ||
168 | |||