/Aurora/DataManager/Migration/Migrators/UserAccounts/UserAccountsMigrator_1.cs
C# | 84 lines | 48 code | 8 blank | 28 comment | 0 complexity | 6f5c978c7d325f0d6d8548a4ea3a8600 MD5 | raw file
1/* 2 * Copyright (c) Contributors, http://aurora-sim.org/ 3 * See CONTRIBUTORS.TXT for a full list of copyright holders. 4 * 5 * Redistribution and use in source and binary forms, with or without 6 * modification, are permitted provided that the following conditions are met: 7 * * Redistributions of source code must retain the above copyright 8 * notice, this list of conditions and the following disclaimer. 9 * * Redistributions in binary form must reproduce the above copyright 10 * notice, this list of conditions and the following disclaimer in the 11 * documentation and/or other materials provided with the distribution. 12 * * Neither the name of the Aurora-Sim Project nor the 13 * names of its contributors may be used to endorse or promote products 14 * derived from this software without specific prior written permission. 15 * 16 * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY 17 * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED 18 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 19 * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY 20 * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES 21 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; 22 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 23 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 24 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS 25 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 26 */ 27 28using System; 29using System.Collections.Generic; 30using Aurora.Framework; 31using Aurora.Framework.Utilities; 32 33namespace Aurora.DataManager.Migration.Migrators 34{ 35 public class UserAccountsMigrator_1 : Migrator 36 { 37 public UserAccountsMigrator_1() 38 { 39 Version = new Version(0, 0, 1); 40 MigrationName = "UserAccounts"; 41 42 schema = new List<SchemaDefinition>(); 43 44 //Remove the old name 45 this.RemoveSchema("UserAccounts"); 46 //Add the `Name` column 47 AddSchema("useraccounts", ColDefs( 48 ColDef("PrincipalID", ColumnTypes.Char36), 49 ColDef("ScopeID", ColumnTypes.Char36), 50 ColDef("FirstName", ColumnTypes.String64), 51 ColDef("LastName", ColumnTypes.String64), 52 ColDef("Email", ColumnTypes.String64), 53 ColDef("ServiceURLs", ColumnTypes.Text), 54 ColDef("Created", ColumnTypes.Integer11), 55 ColDef("UserLevel", ColumnTypes.Integer11), 56 ColDef("UserFlags", ColumnTypes.Integer11), 57 ColDef("UserTitle", ColumnTypes.String64), 58 ColDef("Name", ColumnTypes.String255) 59 ), IndexDefs( 60 IndexDef(new string[1] {"PrincipalID"}, IndexType.Primary) 61 )); 62 } 63 64 protected override void DoCreateDefaults(IDataConnector genericData) 65 { 66 EnsureAllTablesInSchemaExist(genericData); 67 } 68 69 protected override bool DoValidate(IDataConnector genericData) 70 { 71 return TestThatAllTablesValidate(genericData); 72 } 73 74 protected override void DoMigrate(IDataConnector genericData) 75 { 76 DoCreateDefaults(genericData); 77 } 78 79 protected override void DoPrepareRestorePoint(IDataConnector genericData) 80 { 81 CopyAllTablesToTempVersions(genericData); 82 } 83 } 84}