aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2017-11-03Add a new experimental implementation of PGSQL FSAssetsTomTheDragon2-0/+330
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-07-23mantis 8212 fix sqlite parameter prefixingUbitUmarov1-1/+1
2017-07-22mantis 8212 do use defined sqlite connectionUbitUmarov1-7/+1
2017-05-22PGSQL: Another missing cast in XInventoryDataGeir Nøklebye1-1/+1
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-13fix passcollisions bool value on storeUbitUmarov1-2/+2
2017-05-13PGSQL: Convert PassCollision in table prims to bool to avoid a hopeless cast ↵Geir Nøklebye2-3/+18
that fails with newer versions of NPGSQL. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-09PGSQL: Rewrote EstateStore.migrations as it errored out in version 8 leaving ↵Geir Nøklebye1-299/+104
the database without any estate tables on first run. It also lacked primary keys on estate_map and estate_settings. Syntax requires Postgresql 9.5 or higher. Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-08PGSQL: Add missing AgentPrefs.migrationsGeir Nøklebye1-0/+19
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-05-07take more heavy work out of opened dbconn sectionsUbitUmarov1-14/+22
2017-05-06 oops closed too soonUbitUmarov1-82/+87
2017-05-06 a few more changes on mysqlUbitUmarov4-48/+60
2017-05-06 don't hold dbconn longer than necessartUbitUmarov1-21/+31
2017-05-06 another misplaced closeUbitUmarov1-21/+21
2017-05-06 build const strings a compile time...UbitUmarov1-201/+146
2017-05-06 GZipStream does have a CopyTo()UbitUmarov2-14/+14
2017-05-06 dispose some MemoryStreamsUbitUmarov2-10/+14
2017-05-06 fix a few wrong placement ( this is a test by the way )UbitUmarov1-7/+7
2017-05-06 fix wrong placementUbitUmarov1-2/+1
2017-05-06 MySQLConnector is not a MS productUbitUmarov12-14/+110
2017-05-04Change the engine of the groups table back to MyISAM, because MySQL 5.5 and ↵Diva Canto1-1/+1
older don't support full test search on InnoDB
2017-04-20store the physics inertia override in the databaseGeir Nøklebye2-4/+22
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2017-04-19update for The new Constant: integer OBJECT_REZZER_KEY = 32 + adding missing ↵Geir Nøklebye2-5/+37
support for fields in the prims table. Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2017-04-19PGSQL: Fixed a failing query in GroupsData for deleting groups messages ↵Geir Nøklebye1-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>
2017-04-01 store the physics inertia override in SQliteUbitUmarov3-5/+19
2017-04-01 store the physics inertia override in Mysql and add it to serializer. run ↵UbitUmarov2-2/+21
prebuild is required
2017-03-31Make the MySqlGeneric layer transaction awareMelanie Thielker2-83/+155
2017-01-05Massive tab and trailing space cleanupMelanie Thielker67-652/+652
2017-01-05Create all tables ad InnoDB by defaultMelanie Thielker4-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.
2017-01-04PGSQL fixed a missing cast to uuid in XInventoryDataGeir Nøklebye1-1/+1
Signed-off-by: Melanie Thielker <melanie@t-data.com>
2016-12-04The new Constant: integer OBJECT_REZZER_KEY = 32;Mandarinka Tasty4-2/+26
Signed-off-by: Mandarinka Tasty <mandarinka.tasty@gmail.com> Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-12-01 fix a typo in dbs region rangeUbitUmarov2-2/+2
2016-11-26Increase float precision for windlight needed by scripts. mySQL Migration on ↵AliciaRaven1-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.
2016-11-24 revert changes to asset desc size, my bad.. this field will possible go ↵UbitUmarov4-23/+15
away in future
2016-11-22change asset description max sizeUbitUmarov4-15/+23
2016-11-09fix some invalid string.format argumentsUbitUmarov2-3/+17
2016-09-27MySQLFSAssetData asset type is a int not a varcharUbitUmarov1-2/+2
2016-09-27MySQLFSAssetData on store, if a asset already exists, assume its a valid ↵UbitUmarov1-1/+7
store or regions will keep retry. The other DBs do replace the item, why doesn't FS do the same?
2016-09-18fix typo in table name, thx tglionUbitUmarov1-1/+1
2016-09-17restore sqlite fixes from commit 0e6874..that got lostUbitUmarov1-3/+10
2016-09-17 add load baked terrain methodsUbitUmarov4-0/+105
2016-09-17 add to databases a table to store baked terrain.UbitUmarov7-11/+175
2016-09-15Minor, remove unused OSDMap declaration in MySQL profilesAliciaRaven1-4/+1
2016-09-05Fix some wrong handling of booleans for SeeAVs, AnyAVSounds and ↵tglion1-3/+9
GroupAVSounds fields in sqlite3-database Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2016-09-01asset tests that still need UploadAttemptsUbitUmarov1-0/+18
2016-09-01assets uploads to grid. Change the retry code. Stop using ↵UbitUmarov1-18/+0
asset.UploadAttempts field that should be removed
2016-08-22workaround potencial memory leaksUbitUmarov3-61/+66
2016-07-15PGSQL: Update simulation data with a number of missing fields for parcels. ↵Geir Nøklebye2-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>
2016-06-17Mantis #7848: something wrong with a data field in Groups V2Diva Canto1-2/+1
2016-04-28Fix incorrect SQLite syntax in MigrationsMelanie Thielker1-1/+1
2016-04-25POSTGRES: Update database migrations to be in accordance with MySQL table ↵Geir Nøklebye3-1/+39
definitions. Prerequisite for fixing PGSQLSimulationdata Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7846)
generated by cgit v1.1 at 2024-12-27 14:44:19 +0000