aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Provide the interface for StoreAsset to report success or failureTom Grimshaw2010-06-281-1/+3
|
* Merge branch 'master' into careminster-presence-refactorMelanie2010-06-271-1/+9
|\
| * Added checks to XInventory DB layer to truncate names and descriptions.Diva Canto2010-06-271-1/+9
| |
| * Revert "This is a HACK! Downright nasty. For some reason, the devs of the mysql"Melanie2010-06-191-7/+0
| | | | | | | | | | | | Didn't do what it said on the package! This reverts commit 8643db3ef0c4dca709d85fc37240a18fd9049520.
| * This is a HACK! Downright nasty. For some reason, the devs of the mysqlMelanie2010-06-191-0/+7
| | | | | | | | | | connector have decided that their vision of timeouts is the only valid one. This uses reflection to show them the finger. Please test.
| * Revert "Set command timeout to infinity on migrations"Melanie2010-06-171-1/+0
| | | | | | | | This reverts commit 51d30fd34a950e0cd71d61ce0666a6d1e90bf233.
| * Set command timeout to infinity on migrationsMelanie2010-06-171-0/+1
| |
* | Correctly update the LastSeen fieldMelanie Thielker2010-06-211-1/+1
| |
* | Bump the migration version, ot it would never happenMelanie Thielker2010-06-211-1/+1
| |
* | Fix build breakMelanie Thielker2010-06-211-1/+1
| |
* | Ensure no UUID.Zero region ID is ever written to presence. Add a MigrationMelanie Thielker2010-06-212-1/+11
| | | | | | | | to add a LastSeen field of type "Timestamp" to Presence for MySQL
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-06-161-2/+0
|\ \ | |/
| * * Deleted duplicated migration that was failing anyway.Diva Canto2010-06-141-2/+0
| | | | | | | | * Added an error message in initial estate owner creation that makes it clear what needs to happen.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-06-092-1/+9
|\ \ | |/
| * Add the BEGIN; I had missedMelanie2010-06-091-0/+1
| |
| * Re-add Migration version 32, which apparently got dropped completely.Melanie2010-06-091-0/+72
| |
| * * Changed CreatorIDs consistently to varchar(128)Diva Canto2010-06-082-1/+9
| | | | | | | | | | * Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-06-081-0/+6
|\ \ | |/
| * Add a migration to adjust types in the WL table. The new connector likes thatMelanie2010-06-081-0/+6
| | | | | | | | better
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-266-497/+81
|\ \ | |/
| * Merge branch 'unitests'Melanie2010-05-266-503/+81
| |\ | | | | | | | | | Signed-off-by: Melanie <melanie@t-data.com>
| | * MySQL Migrations: Minor correcton to Region/Estate splitAlexRa2010-05-232-6/+12
| | | | | | | | | | | | (some Estate SQL left behind in the Region migration)
| | * Split migrations for RegionStore and EstateStore (see WARNING!)AlexRa2010-05-232-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.
| | * Removed MySql and SQLite-specific asset test filesAlexRa2010-05-231-92/+0
| | |
| | * All data tests made DBMS-independentAlexRa2010-05-233-327/+0
| | |
* | | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-241-1/+1
|\ \ \ | |/ /
| * | The 8th migration statement in AssetStore.migrations didn't look right.Diva Canto2010-05-231-1/+1
| |/
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-2187-1164/+1435
|\ \ | |/
| * Cleaned up MySql migrations a bit more, got rid of all old-form migration ↵Diva Canto2010-05-205-32/+8
| | | | | | | | files. Restored Presence table to its taboo-breaking form.
| * MySQLAssetData.cs now supports asset_flags, CreatorIDAlexRa2010-05-191-5/+7
| |
| * MySQL: added CreatorID, moved asset_flag to migration scriptAlexRa2010-05-191-0/+8
| |
| * Clean up output a bitMelanie2010-05-191-5/+1
| |
| * Revert "Allow migration steps to fail again without bringing down the house"Melanie2010-05-191-1/+1
| | | | | | | | This reverts commit 167db502593de5f535d8c322005c63ef263940ed.
| * Allow migration steps to fail again without bringing down the houseMelanie2010-05-191-1/+1
| |
| * Make m_log in migrations private. Define new m_log in derived classMelanie2010-05-181-0/+2
| |
| * Some more corrections after MySQL connector updateAlexRa2010-05-192-2/+3
| |
| * All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa2010-05-195-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)
| * Converted MySQL migration history to the new formatAlexRa2010-05-1678-1002/+1228
| | | | | | | | | | Replaced all NNN_StoreName.sql migration resources with a more readable, single-file-per-store
| * Added MySqlMigrations.cs (supports stored proc/funcs)AlexRa2010-05-161-0/+85
| | | | | | | | | | Uses MySqlScript class to correctly run proc/func definitions that need delimiter change. Requires MySql.Data.dll 6.2 or later.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-103-4/+12
|\ \ | |/
| * OK, this really fixes it, I promise.Diva Canto2010-05-091-2/+2
| |
| * Yey for unit tests. The previous commit had a couple of bugs on SQL ↵Diva Canto2010-05-091-2/+2
| | | | | | | | statements. Fixed here.
| * * Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto2010-05-093-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.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-091-0/+18
|\ \ | |/
| * Implement the "delete" path for assets. Adds a new option to allow remote ↵Melanie2010-05-091-0/+18
| | | | | | | | asset deletion in robust handler.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-092-3/+10
|\ \ | |/
| * Add a field asset_flags and a corresponding enum to the asset database. ThisMelanie2010-05-092-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.
* | Merge branch 'master' into careminster-presence-refactorMelanie2010-05-086-88/+27
|\ \ | |/
| * These files are part of the GridUserService write-up.Diva Canto2010-05-071-0/+17
| |
| * GridUserService in place. Replaces the contrived concept of storing user's ↵Diva Canto2010-05-075-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.