aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/XAssetStore.migrations (follow)
Commit message (Collapse)AuthorAgeFilesLines
* MySQL default character set to utfmb4.onefang2021-08-171-2/+2
| | | | Coz on one box they defaulted to utfmb3, which .NET doesn't support.
* Various database fixups.onefang2020-07-311-4/+4
| | | | | | | InnoDB -> MyISAM utf8 if not exists white space
* Alter the migrations so that it is a no-op as the columns are unused and the ↵BlueWall2015-03-041-3/+0
| | | | operation is very expensive
* Chase latest change to asset description length with an update to ↵Cinder2015-03-041-1/+9
| | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Revert "Chase latest change to asset description length with an update to ↵BlueWall2015-03-041-9/+1
| | | | | | XAssetStore db tables" This reverts commit e520364f65e1915e13d28b829e9dd62f6904957d.
* Chase latest change to asset description length with an update to ↵Cinder2015-03-041-1/+9
| | | | | | XAssetStore db tables Signed-off-by: BlueWall <jamesh@bluewallgroup.com>
* Change the table and field names of XAssetService mysql db tables to be ↵Justin Clark-Casey (justincc)2013-03-151-15/+15
| | | | | | | | capitalized like Avatars, Friends, etc. Also fixes access time being set on assets rather than XAssetsMeta This is to try and be somewhat consistent with other service tables that are mainly in this style. No migration is supplied, since nobody should be using this service yet except on a test basis.
* Switch to sha256 from sha1 in order to avoid future asset hash collisions.Justin Clark-Casey (justincc)2012-03-061-2/+2
| | | | | | | Some successful collision attacks have been carried out on sha1 with speculation that more are possible. http://en.wikipedia.org/wiki/Cryptographic_hash_function#Cryptographic_hash_algorithms No successful attacks have been shown on sha256, which makes it less likely that anybody will be able to engineer an asset hash collision in the future. Tradeoff is more storage required for hashes, and more cpu to hash, though this is neglible compared to db operations and network access.
* Make XAssetService a de-duplicating asset service.Justin Clark-Casey (justincc)2012-03-021-0/+27
This is an extremely crude implemenation which almost works by accident. Nevertheless it does work. It can be tested with the instructions at http://opensimulator.org/wiki/Feature_Proposals/Deduplicating_Asset_Service#Testing It does not interact at all with the existing asset service or any data stored there. This code is subject to change without notice and should not be used for anything other than gawking.