aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources (unfollow)
Commit message (Collapse)AuthorFilesLines
2011-06-11Switched order of SQL statements in Friends migration -- resulted in the ↵Diva Canto1-1/+1
wrong key
2011-06-10For MySQL, migrate region tables to the MyISAM storage engine rather than InnoDBJustin Clark-Casey (justincc)1-0/+16
Using MyISAM proves vastly faster for persisting scene objects. For instance, a scene object that took 9 seconds to persist before now takes 1. This also improves the experience of loading large OARs. We don't use any of the transactional features of InnoDB. The only thing that may have an impact is that InnoDB does row locking on inserts while MyISAM does table locking. However, field reports say there is no noticeable difference.
2011-06-01This is the better solution: make the combined key be only on the first 36 ↵Diva Canto1-1/+2
characters of each field -- that's the UUIDs. Thanks coyled. WARNING: Again, people who have gone through this migration and failed need to run it manually.
2011-06-01It looks like there's a better solution for that problem.Diva Canto1-2/+1
Revert "Changed Friends table to have 165-sized varchars on PrincipalID and FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually." This reverts commit 3fa54a156a83e498a7d5d0949a5f848fe82fe86f.
2011-06-01Changed Friends table to have 165-sized varchars on PrincipalID and ↵Diva Canto1-1/+2
FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually.
2011-05-19HG Friends working to some extent: friendships offered and accepted ↵Diva Canto1-0/+6
correctly handled. Friends list showing correct foreign names. TODO: GrantRights.
2010-12-05Fixed some inconsistency with trailing /. Made debug messages consistent. ↵Diva Canto1-0/+7
Changed the stored region names of HG regions. Increased the size of regionName in DB.
2010-11-21Added creator info across the board -- TaskInventoryItems and InventoryItems ↵Diva Canto2-0/+9
themselves. Tested. Seems to be working, main tests pass. Nothing done for IARs or HG transfers yet -- this only works for OARs for the time being. New migration in inventory table in order to make CreatorID varchar(255).
2010-11-21Global creator information working on MySQL DB and on load/save OARs. ↵Diva Canto1-0/+8
Creator name properly shown on the viewer as first.last @authority. New option added to save oar -profile=url. Migration on RegionStore making CreatorID be 255 chars. Moved Handling of user UUID -> name requests to a new module UserManagement/UserManagementModule.
2010-10-30Fix logins and avatar appearance. Contains a Migration. May contain nuts.Melanie1-0/+8
This will cause visual params to be persisted along with worn items. With this, alpha and tattoo laters will be saved. Multiple layers MAY work, but not tested because I don't use Viewer 2.
2010-10-18Bump migration version on LastSeen field so it is actually runMelanie1-1/+1
2010-10-13Ensure no UUID.Zero region ID is ever written to presence. Add a MigrationMelanie Thielker1-0/+8
to add a LastSeen field of type "Timestamp" to Presence for MySQL
2010-08-30Implements parcel media setting persistence and packet / CAPS handlingJonathan Freedman1-2/+12
properly for the new media settings. Signed-off-by: Melanie <melanie@t-data.com>
2010-08-30local commit with parcel media bitsJonathan Freedman1-2/+12
Signed-off-by: Melanie <melanie@t-data.com>
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)1-1/+8
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)1-1/+8
2010-06-14* Deleted duplicated migration that was failing anyway.Diva Canto1-2/+0
* Added an error message in initial estate owner creation that makes it clear what needs to happen.
2010-06-09Add the BEGIN; I had missedMelanie1-0/+1
2010-06-09Re-add Migration version 32, which apparently got dropped completely.Melanie1-0/+72
2010-06-08* Changed CreatorIDs consistently to varchar(128)Diva Canto2-1/+9
* Deleted redundant migration for assets in SQLite * Rewrote XInventory migrations in SQLite in the new style
2010-06-08Add a migration to adjust types in the WL table. The new connector likes thatMelanie1-0/+6
better
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-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-19MySQL: added CreatorID, moved asset_flag to migration scriptAlexRa1-0/+8
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-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-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto1-0/+3
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-09Add a field asset_flags and a corresponding enum to the asset database. ThisMelanie1-0/+5
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 Canto3-19/+4
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-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-02-05Implement the friends data adaptorMelanie2-0/+10
2010-01-16Fixed a missing field in the last regions table migration.Diva Canto1-0/+1
2010-01-15Add a handful of new region flags and a small migrationMelanie1-0/+6
2010-01-10Add last_seen field to regions tableMelanie1-0/+5
2010-01-09Preliminary work on the new default region setting mechanismMelanie1-0/+6
2010-01-08Add migrations to add fields to user and auth tablesMelanie2-0/+13
2010-01-04AvatarStore. Untested, but completeMelanie1-0/+5
2010-01-01Auth data migration.Diva Canto1-0/+5
2009-12-29Fixed a couple of bugs that were bombing the data migration.Diva Canto2-2/+2
2009-12-29Give the new user tables the once-over. Strip the current set of methodsMelanie3-2/+16
from IUserAccountService, we need to define what goes in there. Change the handler to the generic handler. Adjust migrations, add index
2009-12-29* Added useraccount tableDiva Canto1-0/+13
2009-12-28Add the indices to really make this table workMelanie1-0/+6
2009-12-28Add a migration to add the 3 new fieldsMelanie1-0/+7
2009-12-28Add the second step of the friends migration to pull data from the old table ↵Melanie1-0/+5
into the new
2009-12-28Add the migration for friends and guard the presence Report functionMelanie1-0/+9
2009-12-28Forgot the migration fileMelanie1-0/+15
2009-09-27Add the Migration for the regions tableMelanie1-0/+6