public AssetMigrator_1() { Version = new Version(0, 0, 1); MigrationName = "Asset"; Schema = new List <SchemaDefinition>(); AddSchema("lslgenericdata", ColDefs( ColDef("Token", ColumnTypes.String50), ColDef("KeySetting", ColumnTypes.String50), ColDef("ValueSetting", ColumnTypes.String50) ), IndexDefs( IndexDef(new string[2] { "Token", "KeySetting" }, IndexType.Primary) )); RenameColumns.Add("UUID", "id"); RenameColumns.Add("Name", "name"); RenameColumns.Add("Description", "description"); RenameColumns.Add("Type", "assetType"); RenameColumns.Add("Local", "local"); RenameColumns.Add("Temporary", "temporary"); RenameColumns.Add("CreatorID", "creatorID"); RenameColumns.Add("Data", "data"); AddSchema("assets", ColDefs( ColDef("id", ColumnTypes.Char36), ColDef("name", ColumnTypes.String64), ColDef("description", ColumnTypes.String64), ColDef("assetType", ColumnTypes.TinyInt4), ColDef("local", ColumnTypes.TinyInt1), ColDef("temporary", ColumnTypes.TinyInt1), ColDef("asset_flags", ColumnTypes.String45), ColDef("creatorID", ColumnTypes.String36), ColDef("data", ColumnTypes.LongBlob), ColDef("create_time", ColumnTypes.Integer11), ColDef("access_time", ColumnTypes.Integer11) ), IndexDefs( IndexDef(new string[1] { "id" }, IndexType.Primary) )); RemoveSchema("assetblob"); RemoveSchema("assettext"); RemoveSchema("assetmesh"); }
public CurrencyMigrator_6() { Version = new Version(0, 0, 6); MigrationName = "SimpleCurrency"; Schema = new List <SchemaDefinition> (); // // Change summary: 19 May 2018 // Change 2 columns in the group_currency table to fix // a bug with the group currency not being stored correctly // Updated 13 Nov 2018 // Change all integer fields to Integer11 rather than the strange Integer30 // AddSchema("user_currency", ColDefs( ColDef("PrincipalID", ColumnTypes.UUID), ColDef("Amount", ColumnTypes.Integer11), ColDef("LandInUse", ColumnTypes.Integer11), ColDef("Tier", ColumnTypes.Integer11), ColDef("IsGroup", ColumnTypes.TinyInt1), // this will be deprecated new ColumnDefinition { Name = "StipendsBalance", Type = new ColumnTypeDef { Type = ColumnType.Integer, Size = 11, defaultValue = "0" } } ), IndexDefs( IndexDef(new string[1] { "PrincipalID" }, IndexType.Primary) )); // Currency Transaction Logs AddSchema("user_currency_history", ColDefs( ColDef("TransactionID", ColumnTypes.UUID), ColDef("Description", ColumnTypes.String128), ColDef("FromPrincipalID", ColumnTypes.UUID), ColDef("FromName", ColumnTypes.String128), ColDef("ToPrincipalID", ColumnTypes.UUID), ColDef("ToName", ColumnTypes.String128), ColDef("Amount", ColumnTypes.Integer11), ColDef("TransType", ColumnTypes.Integer11), ColDef("Created", ColumnTypes.Integer11), ColDef("ToBalance", ColumnTypes.Integer11), ColDef("FromBalance", ColumnTypes.Integer11), ColDef("FromObjectName", ColumnTypes.String50), ColDef("ToObjectName", ColumnTypes.String50), ColDef("RegionID", ColumnTypes.UUID)), IndexDefs( IndexDef(new string[1] { "TransactionID" }, IndexType.Primary) )); // user purchases AddSchema("user_purchased", ColDefs( ColDef("PurchaseID", ColumnTypes.UUID), ColDef("PrincipalID", ColumnTypes.UUID), ColDef("IP", ColumnTypes.String64), ColDef("Amount", ColumnTypes.Integer11), ColDef("RealAmount", ColumnTypes.Integer11), ColDef("Created", ColumnTypes.Integer11), ColDef("Updated", ColumnTypes.Integer11)), IndexDefs( IndexDef(new string[1] { "PurchaseID" }, IndexType.Primary) )); // Group currency RenameColumns.Add("TierCredits", "TotalTierCredits"); RenameColumns.Add("TierDebits", "TotalTierDebits"); AddSchema("group_currency", ColDefs( ColDef("GroupID", ColumnTypes.UUID), ColDef("Balance", ColumnTypes.Integer11), ColDef("GroupFee", ColumnTypes.Integer11), ColDef("LandFee", ColumnTypes.Integer11), ColDef("ObjectFee", ColumnTypes.Integer11), ColDef("ParcelDirectoryFee", ColumnTypes.Integer11), ColDef("TotalTierCredits", ColumnTypes.Integer11), // Changed from TierCredits ColDef("TotalTierDebits", ColumnTypes.Integer11)), // Changed from TierDebits IndexDefs( IndexDef(new string[1] { "GroupID" }, IndexType.Primary) )); // Currency Transaction Logs AddSchema("group_currency_history", ColDefs( ColDef("TransactionID", ColumnTypes.UUID), ColDef("Description", ColumnTypes.String128), ColDef("GroupID", ColumnTypes.UUID), ColDef("GroupName", ColumnTypes.String128), ColDef("AgentID", ColumnTypes.UUID), ColDef("AgentName", ColumnTypes.String128), ColDef("Amount", ColumnTypes.Integer11), ColDef("TransType", ColumnTypes.Integer11), ColDef("Created", ColumnTypes.Integer11), ColDef("GroupBalance", ColumnTypes.Integer11), ColDef("AgentBalance", ColumnTypes.Integer11), ColDef("FromObjectName", ColumnTypes.String50), ColDef("ToObjectName", ColumnTypes.String50), ColDef("RegionID", ColumnTypes.UUID)), IndexDefs( IndexDef(new string[1] { "TransactionID" }, IndexType.Primary) )); }