| Anonymous | Login | Signup for a new account | 2020-01-20 06:16 PST |  |
| Main | My View | View Issues | Change Log | Roadmap | Summary | My Account |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||
| 0008204 | opensim | [REGION] OpenSim Core | public | 2017-06-29 12:06 | 2017-07-04 23:20 | |||||
| Reporter | testdev627 | |||||||||
| Assigned To | ||||||||||
| Priority | normal | Severity | major | Reproducibility | always | |||||
| Status | new | Resolution | open | |||||||
| Platform | OS | OS Version | ||||||||
| Product Version | master (dev code) | |||||||||
| Target Version | Fixed in Version | |||||||||
| Summary | 0008204: PGSQL need to replace 36 with 128 in the AssetSore.migration file under the appropriate VERSION for the creatorid | |||||||||
| Description | On a fresh install the PGSQL AssetSore.migration will create the creatorid to be of length 36 instead of 128. Many creatorids are urls with or without guids. This data will be truncated without a fix. | |||||||||
| Steps To Reproduce | A fresh install of OpenSimulator using Postgresql as the Database. | |||||||||
| Tags | No tags attached. | |||||||||
| Git Revision or version number | ||||||||||
| Run Mode | Grid (Multiple Regions per Sim) | |||||||||
| Physics Engine | BulletSim | |||||||||
| Script Engine | ||||||||||
| Environment | Unknown | |||||||||
| Mono Version | None | |||||||||
| Viewer | ||||||||||
| Attached Files | ||||||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0032122) Gavin Hird (reporter) 2017-07-04 23:20 |
That field was never intended for hyper grid use, but is populated by the UUID of local users when they create assets. To replace a UUID native datatype with a 128 char string is a particularly bad idea for all kinds of reasons. A better approach to accommodate the need to identify creators would be to create a new table for the purpose that will hold all the information required to identify an asset creator and relate to this table everywhere the information needs to be displayed. Adding a new table will both make for better storage and indexing, centralise the information that is now repeated across tables and enable foreign key operations. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-06-29 12:06 | testdev627 | New Issue | |
| 2017-07-04 23:20 | Gavin Hird | Note Added: 0032122 | |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group |
 |