aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-05-23The 8th migration statement in AssetStore.migrations didn't look right.Diva Canto1-1/+1
2010-05-23MySQL Migrations: Minor correcton to Region/Estate splitAlexRa2-6/+12
(some Estate SQL left behind in the Region migration)
2010-05-23Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa2-78/+69
ok, so the estate stores now want their own migration files, but as it happened the SQL definition were inside the Region migrations. It seems better/cleaner to keep each 'store' separately updatable. WARNING: any editing in the middle of the migration scripts (as opposite to just appending to them) has the potential of messing up updates of existing databases. As far as I can see, this one is (probably) safe, the worst that could happen is the EstateStore migration silently fail if the estate the tables are already there.
2010-05-23Removed MySql and SQLite-specific asset test filesAlexRa1-92/+0
2010-05-23All data tests made DBMS-independentAlexRa3-327/+0
2010-05-20Cleaned up MySql migrations a bit more, got rid of all old-form migration ↵Diva Canto5-32/+8
files. Restored Presence table to its taboo-breaking form.
2010-05-19MySQLAssetData.cs now supports asset_flags, CreatorIDAlexRa1-5/+7
2010-05-19MySQL: added CreatorID, moved asset_flag to migration scriptAlexRa1-0/+8
2010-05-19Clean up output a bitMelanie1-5/+1
2010-05-19Revert "Allow migration steps to fail again without bringing down the house"Melanie1-1/+1
This reverts commit 167db502593de5f535d8c322005c63ef263940ed.
2010-05-19Allow migration steps to fail again without bringing down the houseMelanie1-1/+1
2010-05-18Make m_log in migrations private. Define new m_log in derived classMelanie1-0/+2
2010-05-19Some more corrections after MySQL connector updateAlexRa2-2/+3
2010-05-19All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa5-92/+68
This was needed if we want to update to the latest MySQL connector dll. It automatically converts CHAR(36) to Guids, so getting them as strings no longer works. By using DBGuid.FromDB(), we unlink from any particular storage format of GUIDs, could even make them BINARY(16) if we like. Actually not all MySql units are touched, but the remaining ones don't seem to be affected (they don't read GUIDs from DB)
2010-05-18Converted MySQL migration history to the new formatAlexRa78-1002/+1228
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-18Added MySqlMigrations.cs (supports stored proc/funcs)AlexRa1-0/+85
Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later.
2010-05-16Converted MySQL migration history to the new formatAlexRa78-1002/+1228
Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
2010-05-16Added MySqlMigrations.cs (supports stored proc/funcs)AlexRa1-0/+85
Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later.
2010-05-09OK, this really fixes it, I promise.Diva Canto1-2/+2
2010-05-09Yey for unit tests. The previous commit had a couple of bugs on SQL ↵Diva Canto1-2/+2
statements. Fixed here.
2010-05-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto3-3/+11
stored in regionsettings. Upon generation of a new tile image, the old one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug with map search where the local sim regions weren't found.
2010-05-09Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie1-0/+18
asset deletion in robust handler.
2010-05-09Add a field asset_flags and a corresponding enum to the asset database. ThisMelanie2-3/+10
CHANGES THE ASSET SERVER PROTOCOL and means you CAN NOT MIX PRIOR VERSIONS WITH LATER ONES. It may also eat your babies, yada, yada, yada. The usual cautions for migrations to the assets table apply. Coding: Can not guarantee nut free.
2010-05-07These files are part of the GridUserService write-up.Diva Canto1-0/+17
2010-05-07GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto5-88/+10
home and position info in the presence service. WARNING: I violated a taboo by deleting 2 migration files and simplifying the original table creation for Presence. This should not cause any problems to anyone, though. Things will work with the new simplified table, as well as with the previous contrived one. If there are any problems, solving them is as easy as dropping the presence table and deleting its row in the migrations table. The presence info only exists during a user's session anyway. BTW, the Meshing files want to be committed too -- EOFs.
2010-05-04Allow regions to get the list of the other regions in the estateMelanie Thielker1-1/+30
2010-05-03Refix the fixMelanie Thielker1-1/+1
2010-05-03Add folder version incrementing to XInventoryService. Fixes offline giveMelanie Thielker1-0/+31
for avatar->avatar
2010-04-28Just a bit of spellchecking in the commentsAlexRa1-2/+2
2010-03-31Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie1-0/+199
This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
2010-03-26* Catch exceptions thrown when MySQLEstateData.LinkRegion() is called. This ↵John Hurliman1-8/+14
won't fix the bug I'm seeing with regions not realizing they are already part of an estate, but it will fix the OpenSim crash if that situation ever comes up
2010-03-23First stage of the new interactive region creation. This will allow creationMelanie1-45/+130
of a region and joining it to an existing estate or creating a new estate, as well as creating an estate owner if in standalone, and assigning estate owners. In Grid mode, existing users must be used. MySQL ONLY!!!! so far, as I can't develop or test for either SQLite or MSSQL.
2010-03-22Somehow the starting estate number in MySQL was lost. This adds a migrationMelanie1-0/+3
to start estates at 100. Existing databases having autcreated estates below 100 will see a gap in estate numbering. Other database implementors need to ensure that no estates with numbers less that 100 are autocreated, unless they are prepared to deal with the viewer's built-in notions of Linden Mainland
2010-03-22Remove the reading of estate_settings.xml and the associated processing ofMelanie1-13/+5
defaults. Adding code to facilitate estate creation / managemment as part of first time start up
2010-03-10Formatting cleanup. Add copyright notices.Jeff Ames3-3/+3
2010-03-05Justin, I must have been dyslexic when I wrote UserGridService as the name ↵Diva Canto1-5/+5
for it. GridUserService makes more sense; it's the user of the grid, "grid user". I changed it everywhere.
2010-03-05add initial UserGrid service classes as per diva's directionJustin Clark-Casey (justincc)2-2/+65
this will initially store home location data instead of the presence service compiles but not enough to actually test yet
2010-03-04remove test presence from NullPresenceData since this appears to stop ↵Justin Clark-Casey (justincc)1-2/+2
existing sessions with home locations from being picked up only tested for a single user so this may still fail for multiple users this may well be all academic anyway since standalone need to persistently store home location in presence data in some way
2010-03-01Fix a few compiler warnings.Jeff Ames2-7/+0
2010-03-01Change friends to handle offers as it was originally designed. This mayMelanie1-1/+1
need to be changed in SQLite & MSSQL as well
2010-02-22Changed asset CreatorID to a stringJohn Hurliman1-1/+1
2010-02-22* Adds CreatorID to asset metadata. This is just the plumbing to support ↵John Hurliman1-1/+1
CreatorID, it doesn't modify database backends or OAR files to support storing/loading it
2010-02-21Deleted obsolete files in the Data layer. Compiles.Diva Canto11-2889/+103
2010-02-12Fix http://opensimulator.org/mantis/view.php?id=4224Justin Clark-Casey (justincc)1-5/+0
This resolves the problem where eyes and hair would turn white on standalone configurations When a client receives body part information, for some insane reason or other it always ends up uploading this back to the server and then immediately re-requesting it. This should have been okay since we stored that asset in cache. However, the standalone asset service connector was not checking this cache properly, so every time the client made the request for the asset it has just loaded it would get a big fat null back in the face, causing it to make clothes and hair white. This bug did not affect grids since they use a different service connector.
2010-02-09Add the friends service skel and correct some namespace issuesMelanie1-1/+1
2010-02-08Make an exception report more clear. Fix a database access in Presence toMelanie1-15/+22
conform to the changes in the generic table handler.
2010-02-07Finish the "Get friends" methodMelanie1-1/+6
2010-02-05Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim15-2629/+2230
This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
2010-02-05Fixing an incorrect logging message in insertUserRowOpenSim Master1-1/+1
2010-02-05* Fixed the Cable Beach inventory server to save the CreatorID as well as ↵OpenSim Master1-2/+2
properly handling null item names and descriptions * Fixed the MySQL reader to safely handle null values in string columns that can be null