aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
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)
2016-04-25Updated the code to handle Agent Preferences. Thanks to TomDataworks for ↵Geir Nøklebye2-13/+5
providing a final solution. Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7610)
2016-04-25Fix Mantis #7805, table handler needs to look for all unique constraints.TomDataworks1-21/+16
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
2016-04-25POSTGRES: Added check for Heightfield not equal to Database NULL.. Mirrors ↵Geir Nøklebye1-2/+7
OpenSim commit 50d738 Signed-off-by: Kevin Cozens <kevin@ve3syb.ca> (mantis #7845)
2016-04-05Fix missing id parameter in FSAssets database connector when updating Access ↵AliciaRaven1-3/+3
time.
2016-03-24Correct case in the names of the Avatar and Friends tablesKevin Cozens2-2/+2
2016-03-22Correct the case of the Presence tableMelanie Thielker1-1/+1
2016-03-22Add migration to add "active" column on PGSQL. UNTESTED!Melanie Thielker1-0/+6
2016-03-22Change casing on UserAccountsMelanie Thielker1-1/+1
2016-03-22Fix some artefacts that came from merging the OSGrid code.Melanie Thielker1-1/+2
2016-03-05Port the safer database access and the cure for "Chicken Bones" whichMelanie Thielker1-188/+191
are artefacts that can be created by fsck and would make standard FSAssets choke. These refinements were tested on OSGrid.
2016-02-21Pushed AssemblyVersion up to VersionInfo, so that we don't need to do global ↵Diva Canto5-5/+5
replace anymore.
2016-02-21The old sqlite inventory data interface was still around and causing ↵Diva Canto3-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.
2016-02-21SQLite: Removed obsolete migration fileDiva Canto1-169/+0
2016-02-21Flatten migrations for sqliteDiva Canto4-605/+193
Conflicts: OpenSim/Data/SQLite/Resources/RegionStore.migrations (Resolved)
2016-02-21MySQL migrations: fix one last migration that had been left behindDiva Canto1-0/+7
2016-02-20Flatten migrations for MySQL.Diva Canto13-1514/+432
Conflicts: OpenSim/Data/MySQL/Resources/RegionStore.migrations OpenSim/Data/MySQL/Resources/UserAccount.migrations
2016-01-10Fix region data range selection in the PGSQL backend.TomDataworks1-11/+53
Signed-off-by: UbitUmarov <ajlduarte@sapo.pt>
2015-11-21row format fixed removed to allow creation of regions tableShy Robbiani1-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>
2015-11-17 work around some 'tests' errors: assets are modified by the test, on ↵UbitUmarov1-0/+18
current code
2015-11-16 work around some 'tests' errorsUbitUmarov1-2/+9
2015-10-20 store rotation axis locks in MySql and SQlite dbs ( others need to be ↵UbitUmarov4-5/+26
updated also
2015-09-28 put back virtual declarationsUbitUmarov1-14/+14
2015-09-28 remove virtual declarations master doesnt haveUbitUmarov1-14/+14
2015-09-21 SQLite db migration updateUbitUmarov3-6/+57
2015-09-15Added migration for UserAccounts table.Kevin Cozens1-0/+7
2015-09-15 remove redundant using(){}UbitUmarov1-47/+40
2015-09-14 try to add a mysql migration to avnUbitUmarov1-0/+15
2015-09-12remove a silly and not necessary List i addedUbitUmarov1-6/+6
2015-09-03 at last we can login and see objects ( friends is dead and disable inUbitUmarov8-93/+66
scenepresence)
2015-09-02seems to compile ( tests comented out)UbitUmarov7-112/+42
2015-08-25 let mysql be happy with a NULL heighmap ( yeap i made several )UbitUmarov1-2/+5
2015-08-23 fix db region find by range for varregions ( ignoring others than Mysql)UbitUmarov1-0/+33
2015-08-23 fix db region search by a position, for varregions ( ignoring other thatUbitUmarov1-0/+40
mysql for now )
2015-08-23 fix region range compareUbitUmarov1-3/+5
2015-08-23 fix mySQL ( ignoring other dbs )UbitUmarov1-1/+2
2015-08-11Removed unused code that checked wait_timeout in MySQLEstateDataOren Hurvitz1-34/+0
2015-08-08Corrected spelling of SQLITE. Fixes mantis #7675.Kevin Cozens1-1/+1
2015-08-03Merged the two "Version 2" migrations in PGSQLOren Hurvitz1-6/+0
2015-08-03PGSL Presence migration to correct a double version 2 migration that existedGeir Nøklebye1-0/+10
The migration file had a version 2 migration defined twice and therefore the LastSeen field most likely never was defined in the presence file. This migration adds the field and migrates the table to version 4. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-31PGSQL migrations for IM_Store, UserProfiles, removal of casting exception ↵Geir Nøklebye4-1/+33
for UserProfiles and adding double precision to PGSQL Manager PGSQL migrations for IM_Store, UserProfiles, removal of casting exception for UserProfiles and adding double precision to PGSQL Manager. Fixes the Offline IM to Email toggle and prepares for fixing Offline IM. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-26Update PGSQL groups handler to accept search queries from the viewerGeir Nøklebye3-17/+26
Update PGSQL groups handler to accept search queries from the viewer. Fixed malformed query strings. Signed-off-by: Oren Hurvitz <orenh@kitely.com>
2015-07-23Add quotes aroung LandFlags as PGSQL seems to choke on the word whenMelanie Thielker1-1/+1
it's bare.
2015-07-14Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker2-3/+3
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker2-0/+16
2015-07-12Bringing FSAssets more inline with current OpenSim standards. * If no ↵AliciaRaven3-25/+147
connection string found in assets config, fallback to using default database config * Create database storage interface to allow other db connectors to be written at some point * Add MySQL migrations file to create the initial db table * Added new config option named DaysBetweenAccessTimeUpdates to reduce db load by only updating access times when fetching assets if the last access time was over the threshold. This idea was taken from XAssets service. * Change log message headers to indicate FS assets is the source not just assets Signed-off-by: Melanie Thielker <melanie@t-data.com>
2015-07-11Some cleanup, add prebuild project, correct pathMelanie Thielker1-4/+0
generated by cgit v1.1 at 2024-12-21 10:03:41 +0000