diff options
| author | Melanie | 2010-01-08 18:10:59 +0000 |
|---|---|---|
| committer | Melanie | 2010-01-08 18:10:59 +0000 |
| commit | d14589d1abf4ca39a5fc5ba7be10e57edff4333c (patch) | |
| tree | 2d3215a7abfa0f45898139b8a44d38ac58d09e80 /OpenSim/Data/MySQL | |
| parent | Inching ahead... This compiles, but very likely does not run. (diff) | |
| download | opensim-SC_OLD-d14589d1abf4ca39a5fc5ba7be10e57edff4333c.zip opensim-SC_OLD-d14589d1abf4ca39a5fc5ba7be10e57edff4333c.tar.gz opensim-SC_OLD-d14589d1abf4ca39a5fc5ba7be10e57edff4333c.tar.bz2 opensim-SC_OLD-d14589d1abf4ca39a5fc5ba7be10e57edff4333c.tar.xz | |
Add migrations to add fields to user and auth tables
Diffstat (limited to 'OpenSim/Data/MySQL')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/003_AuthStore.sql | 5 | ||||
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/004_UserAccount.sql | 8 |
2 files changed, 13 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/003_AuthStore.sql b/OpenSim/Data/MySQL/Resources/003_AuthStore.sql new file mode 100644 index 0000000..af9ffe6 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/003_AuthStore.sql | |||
| @@ -0,0 +1,5 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | ALTER TABLE `auth` ADD COLUMN `accountType` VARCHAR(32) NOT NULL DEFAULT 'UserAccount'; | ||
| 4 | |||
| 5 | COMMIT; | ||
diff --git a/OpenSim/Data/MySQL/Resources/004_UserAccount.sql b/OpenSim/Data/MySQL/Resources/004_UserAccount.sql new file mode 100644 index 0000000..8abcd53 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/004_UserAccount.sql | |||
| @@ -0,0 +1,8 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | ALTER TABLE UserAccounts ADD COLUMN UserLevel integer NOT NULL DEFAULT 0; | ||
| 4 | ALTER TABLE UserAccounts ADD COLUMN UserFlags integer NOT NULL DEFAULT 0; | ||
| 5 | ALTER TABLE UserAccounts ADD COLUMN UserTitle varchar(64) NOT NULL DEFAULT ''; | ||
| 6 | |||
| 7 | COMMIT; | ||
| 8 | |||