aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (follow)
Commit message (Collapse)AuthorAgeFilesLines
...
* update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing ↵Geir Nøklebye2017-04-192-5/+37
| | | | | | support for fields in the prims table. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* PGSQL: Fixed a failing query in GroupsData for deleting groups messages ↵Geir Nøklebye2017-04-191-2/+2
| | | | | | older than 14 days. The little known abstime function could be used for a double cast. The field TMStamp should be changed to store the data as a proper timestamp. Related to Mantis #7848. Usually this would easily be solved using the to_timestamp function, but there is no support for it in NPGSQL as there are no very close functionality in .NET Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
* store the physics inertia override in SQliteUbitUmarov2017-04-013-5/+19
|
* store the physics inertia override in Mysql and add it to serializer. run ↵UbitUmarov2017-04-012-2/+21
| | | | prebuild is required
* Make the MySqlGeneric layer transaction awareMelanie Thielker2017-03-312-83/+155
|
* Massive tab and trailing space cleanupMelanie Thielker2017-01-0567-652/+652
|
* Create all tables ad InnoDB by defaultMelanie Thielker2017-01-054-22/+22
| | | | | | MyISAM isn't properly replicated using row based replication. With the advances in clustering, these systems are becoming more prevalent and MyISAM isn't up to the task anymore.
* PGSQL fixed a missing cast to uuid in XInventoryDataGeir Nøklebye2017-01-041-1/+1
| | | | Signed-off-by: Melanie Thielker <melanie@t-data.com>
* The new Constant: integer OBJECT_REZZER_KEY = 32;Mandarinka Tasty2016-12-044-2/+26
| | | | | Signed-off-by: Mandarinka Tasty <mandarinka.tasty@gmail.com> Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* fix a typo in dbs region rangeUbitUmarov2016-12-012-2/+2
|
* Increase float precision for windlight needed by scripts. mySQL Migration on ↵AliciaRaven2016-11-261-0/+63
| | | | | | regionwindlight table. mySQL was setup to store smaller values because the viewers editor capped input, scripts can set higher precision so settings could change on region restart. This change brings mySQL more inline with PGSQL which uses doubles for all windlight floats.
* revert changes to asset desc size, my bad.. this field will possible go ↵UbitUmarov2016-11-244-23/+15
| | | | away in future
* change asset description max sizeUbitUmarov2016-11-224-15/+23
|
* fix some invalid string.format argumentsUbitUmarov2016-11-092-3/+17
|
* MySQLFSAssetData asset type is a int not a varcharUbitUmarov2016-09-271-2/+2
|
* MySQLFSAssetData on store, if a asset already exists, assume its a valid ↵UbitUmarov2016-09-271-1/+7
| | | | store or regions will keep retry. The other DBs do replace the item, why doesn't FS do the same?
* fix typo in table name, thx tglionUbitUmarov2016-09-181-1/+1
|
* restore sqlite fixes from commit 0e6874..that got lostUbitUmarov2016-09-171-3/+10
|
* add load baked terrain methodsUbitUmarov2016-09-174-0/+105
|
* add to databases a table to store baked terrain.UbitUmarov2016-09-177-11/+175
|
* Minor, remove unused OSDMap declaration in MySQL profilesAliciaRaven2016-09-151-4/+1
|
* Fix some wrong handling of booleans for SeeAVs, AnyAVSounds and ↵tglion2016-09-051-3/+9
| | | | | | GroupAVSounds fields in sqlite3-database Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* asset tests that still need UploadAttemptsUbitUmarov2016-09-011-0/+18
|
* assets uploads to grid. Change the retry code. Stop using ↵UbitUmarov2016-09-011-18/+0
| | | | asset.UploadAttempts field that should be removed
* workaround potencial memory leaksUbitUmarov2016-08-223-61/+66
|
* PGSQL: Update simulation data with a number of missing fields for parcels. ↵Geir Nøklebye2016-07-152-6/+24
| | | | | | Some of the fields should probably be migrated to type Boolean to avoid the hairy casting in the query. In addition the overall server code relies in the Replace in SQL statement that is proprietary to MySQL, so the PGSQL code is rather unsafe as it is. Should probably set a transaction on the whole operation so that if something goes wrong the database record is not zapped as it is now. PostgreSQL 9.5 has the upsert functionality which would bring the code closer to the MySQL version. This commit also has an update to PGSQLRegionData Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* Mantis #7848: something wrong with a data field in Groups V2Diva Canto2016-06-171-2/+1
|
* Fix incorrect SQLite syntax in MigrationsMelanie Thielker2016-04-281-1/+1
|
* POSTGRES: Update database migrations to be in accordance with MySQL table ↵Geir Nøklebye2016-04-253-1/+39
| | | | | | definitions. Prerequisite for fixing PGSQLSimulationdata Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7846)
* Updated the code to handle Agent Preferences. Thanks to TomDataworks for ↵Geir Nøklebye2016-04-252-13/+5
| | | | | | providing a final solution. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7610)
* Fix Mantis #7805, table handler needs to look for all unique constraints.TomDataworks2016-04-251-21/+16
| | | | Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
* POSTGRES: Added check for Heightfield not equal to Database NULL.. Mirrors ↵Geir Nøklebye2016-04-251-2/+7
| | | | | | OpenSim commit 50d738 Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7845)
* Fix missing id parameter in FSAssets database connector when updating Access ↵AliciaRaven2016-04-051-3/+3
| | | | time.
* Correct case in the names of the Avatar and Friends tablesKevin Cozens2016-03-242-2/+2
|
* Correct the case of the Presence tableMelanie Thielker2016-03-221-1/+1
|
* Add migration to add "active" column on PGSQL. UNTESTED!Melanie Thielker2016-03-221-0/+6
|
* Change casing on UserAccountsMelanie Thielker2016-03-221-1/+1
|
* Fix some artefacts that came from merging the OSGrid code.Melanie Thielker2016-03-221-1/+2
|
* Port the safer database access and the cure for "Chicken Bones" whichMelanie Thielker2016-03-051-188/+191
| | | | | are artefacts that can be created by fsck and would make standard FSAssets choke. These refinements were tested on OSGrid.
* Pushed AssemblyVersion up to VersionInfo, so that we don't need to do global ↵Diva Canto2016-02-215-5/+5
| | | | replace anymore.
* The old sqlite inventory data interface was still around and causing ↵Diva Canto2016-02-213-960/+0
| | | | problems: the only part of the code using it was the data (sqlite) tests. Given that this old interface has been obsolete for several years, it has now been removed, including the tests. TODO: Writing tests for the new (ah!) inventory data interface.
* SQLite: Removed obsolete migration fileDiva Canto2016-02-211-169/+0
|
* Flatten migrations for sqliteDiva Canto2016-02-214-605/+193
| | | | | | Conflicts: OpenSim/Data/SQLite/Resources/RegionStore.migrations (Resolved)
* MySQL migrations: fix one last migration that had been left behindDiva Canto2016-02-211-0/+7
|
* Flatten migrations for MySQL.Diva Canto2016-02-2013-1514/+432
| | | | | | Conflicts: OpenSim/Data/MySQL/Resources/RegionStore.migrations OpenSim/Data/MySQL/Resources/UserAccount.migrations
* Fix region data range selection in the PGSQL backend.TomDataworks2016-01-101-11/+53
| | | | Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
* row format fixed removed to allow creation of regions tableShy Robbiani2015-11-211-1/+5
| | | | | | | | | row_format=fixed is not supported by innodb and has broken the creation of the regions table during the first startup of ROBUST. It must be a relict from MyISAM. Also removed the probably inappropriate table comment. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
* work around some 'tests' errors: assets are modified by the test, on ↵UbitUmarov2015-11-171-0/+18
| | | | current code
* work around some 'tests' errorsUbitUmarov2015-11-161-2/+9
|
* store rotation axis locks in MySql and SQlite dbs ( others need to be ↵UbitUmarov2015-10-204-5/+26
| | | | updated also