aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2017-03-31Make the MySqlGeneric layer transaction awareMelanie Thielker2-83/+155
2017-01-05Massive tab and trailing space cleanupMelanie Thielker16-169/+169
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.
2016-12-04The new Constant: integer OBJECT_REZZER_KEY = 32;Mandarinka Tasty2-2/+15
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 rangeUbitUmarov1-1/+1
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 ↵UbitUmarov2-13/+5
away in future
2016-11-22change asset description max sizeUbitUmarov2-5/+13
2016-11-09fix some invalid string.format argumentsUbitUmarov1-2/+7
2016-11-03MyISAM is still much better performing for OpenSim.David Walter Seikel17-40/+40
This time we got the file system asset server, even better still. B-)
2016-11-03Initial update to OpenSim 0.8.2.1 source code.David Walter Seikel35-879/+3504
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-17 add load baked terrain methodsUbitUmarov1-0/+35
2016-09-17 add to databases a table to store baked terrain.UbitUmarov2-0/+58
2016-09-15Minor, remove unused OSDMap declaration in MySQL profilesAliciaRaven1-4/+1
2016-08-22workaround potencial memory leaksUbitUmarov2-36/+39
2016-06-17Mantis #7848: something wrong with a data field in Groups V2Diva Canto1-2/+1
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-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 Canto1-1/+1
replace anymore.
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
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-10-20 store rotation axis locks in MySql and SQlite dbs ( others need to be ↵UbitUmarov2-3/+15
updated also
2015-09-28 put back virtual declarationsUbitUmarov1-14/+14
2015-09-28 remove virtual declarations master doesnt haveUbitUmarov1-14/+14
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-03 at last we can login and see objects ( friends is dead and disable inUbitUmarov6-90/+54
scenepresence)
2015-09-02seems to compile ( tests comented out)UbitUmarov3-109/+33
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 mySQL ( ignoring other dbs )UbitUmarov1-1/+2
2015-08-11Removed unused code that checked wait_timeout in MySQLEstateDataOren Hurvitz1-34/+0
2015-07-14Correcting errors in previous change: MySQL needs int unsigned, notMelanie Thielker1-1/+1
unsigned int. PGSQL has no unsigned types, changing to bigint.
2015-07-14Mantis #7629: Change LandFlags column to unsigned. Thanks, Jim!Melanie Thielker1-0/+8
2015-07-12Bringing FSAssets more inline with current OpenSim standards. * If no ↵AliciaRaven2-25/+100
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
2015-07-11Rename for uniformity, add data moduleMelanie Thielker1-0/+361
2015-06-14Removing the Store methods in the DB layer of AgentPreferences, as they were ↵Diva Canto1-5/+0
simply calling the base ones.
2015-06-14Quell three new warnings I introduced with AgentPrefsData, return an empty ↵Cinder1-2/+2
llsd map instead of an empty llsd block when no AgentPrefs service is available to try and appease Firestorm Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13Refactor AgentPreferences so that database operations happen centrally. the ↵Cinder1-15/+2
opensim way. Signed-off-by: Diva Canto <diva@metaverseink.com>
2015-06-13Relicense AgentPreferences files to BSD and OpenSimulatorCinder1-23/+24
Signed-off-by: Diva Canto <diva@metaverseink.com>