diff options
| author | Teravus Ovares | 2008-01-09 04:13:04 +0000 |
|---|---|---|
| committer | Teravus Ovares | 2008-01-09 04:13:04 +0000 |
| commit | e1aa83e965440b3e830d599e18ff078104e8a886 (patch) | |
| tree | b6f97c44228c41736a7145e8943d4b7c8d535983 /OpenSim/Framework/Data.MySQL/Resources | |
| parent | dump_assets_to_file=true will now cause the asset to go into a UserAssets sub... (diff) | |
| download | opensim-SC_OLD-e1aa83e965440b3e830d599e18ff078104e8a886.zip opensim-SC_OLD-e1aa83e965440b3e830d599e18ff078104e8a886.tar.gz opensim-SC_OLD-e1aa83e965440b3e830d599e18ff078104e8a886.tar.bz2 opensim-SC_OLD-e1aa83e965440b3e830d599e18ff078104e8a886.tar.xz | |
* Added a hashtable based HTTP processor in preparation of the web_login_key
* Added the web_login_key to the users table
* Added happy configurable http error message pages
* This update is large enough to have 'awe' value.. so backup your users or weep.
* Not tested on MSSQL, even though I added code to update the tables!
Diffstat (limited to 'OpenSim/Framework/Data.MySQL/Resources')
| -rw-r--r-- | OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql | 3 | ||||
| -rw-r--r-- | OpenSim/Framework/Data.MySQL/Resources/UpgradeUsersTableToVersion2.sql | 3 |
2 files changed, 5 insertions, 1 deletions
diff --git a/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql b/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql index faac541..d9e8ae2 100644 --- a/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql +++ b/OpenSim/Framework/Data.MySQL/Resources/CreateUsersTable.sql | |||
| @@ -25,9 +25,10 @@ CREATE TABLE `users` ( | |||
| 25 | `profileFirstText` text, | 25 | `profileFirstText` text, |
| 26 | `profileImage` varchar(36) default NULL, | 26 | `profileImage` varchar(36) default NULL, |
| 27 | `profileFirstImage` varchar(36) default NULL, | 27 | `profileFirstImage` varchar(36) default NULL, |
| 28 | `webLoginKey` varchar(36) default NULL, | ||
| 28 | PRIMARY KEY (`UUID`), | 29 | PRIMARY KEY (`UUID`), |
| 29 | UNIQUE KEY `usernames` (`username`,`lastname`) | 30 | UNIQUE KEY `usernames` (`username`,`lastname`) |
| 30 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | 31 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; |
| 31 | 32 | ||
| 32 | -- ---------------------------- | 33 | -- ---------------------------- |
| 33 | -- Records | 34 | -- Records |
diff --git a/OpenSim/Framework/Data.MySQL/Resources/UpgradeUsersTableToVersion2.sql b/OpenSim/Framework/Data.MySQL/Resources/UpgradeUsersTableToVersion2.sql new file mode 100644 index 0000000..99a84a8 --- /dev/null +++ b/OpenSim/Framework/Data.MySQL/Resources/UpgradeUsersTableToVersion2.sql | |||
| @@ -0,0 +1,3 @@ | |||
| 1 | ALTER TABLE `users` | ||
| 2 | ADD COLUMN `webLoginKey` varchar(36) default NULL, | ||
| 3 | COMMENT='Rev. 2'; \ No newline at end of file | ||