Advertisement
ramov

Crucible 1.1 MySQL mixed capitalization

Jan 27th, 2012
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.57 KB | None | 0 0
  1. -- This script gives the tables the original capitalization.
  2. -- Will probably make no sense on non-unix file systems that are case insensitive.
  3. --
  4. RENAME TABLE `agtagenttypes` TO `agtAgentTypes` ;
  5. RENAME TABLE `agtagents` TO `agtAgents` ;
  6. RENAME TABLE `agtresearchagents` TO `agtResearchAgents` ;
  7. RENAME TABLE `chrancestries` TO `chrAncestries` ;
  8. RENAME TABLE `chrattributes` TO `chrAttributes` ;
  9. RENAME TABLE `chrbloodlines` TO `chrBloodlines` ;
  10. RENAME TABLE `chrfactions` TO `chrFactions` ;
  11. RENAME TABLE `chrraces` TO `chrRaces` ;
  12. RENAME TABLE `crpactivities` TO `crpActivities` ;
  13. RENAME TABLE `crpnpccorporationdivisions` TO `crpNPCCorporationDivisions` ;
  14. RENAME TABLE `crpnpccorporationresearchfields` TO `crpNPCCorporationResearchFields` ;
  15. RENAME TABLE `crpnpccorporations` TO `crpNPCCorporations` ;
  16. RENAME TABLE `crpnpccorporationtrades` TO `crpNPCCorporationTrades` ;
  17. RENAME TABLE `crpnpcdivisions` TO `crpNPCDivisions` ;
  18. RENAME TABLE `crtcategories` TO `crtCategories` ;
  19. RENAME TABLE `crtcertificates` TO `crtCertificates` ;
  20. RENAME TABLE `crtclasses` TO `crtClasses` ;
  21. RENAME TABLE `crtrecommendations` TO `crtRecommendations` ;
  22. RENAME TABLE `crtrelationships` TO `crtRelationships` ;
  23. RENAME TABLE `dgmattributecategories` TO `dgmAttributeCategories` ;
  24. RENAME TABLE `dgmattributetypes` TO `dgmAttributeTypes` ;
  25. RENAME TABLE `dgmeffects` TO `dgmEffects` ;
  26. RENAME TABLE `dgmtypeattributes` TO `dgmTypeAttributes` ;
  27. RENAME TABLE `dgmtypeeffects` TO `dgmTypeEffects` ;
  28. RENAME TABLE `evegraphics` TO `eveGraphics` ;
  29. RENAME TABLE `eveicons` TO `eveIcons` ;
  30. RENAME TABLE `eveunits` TO `eveUnits` ;
  31. RENAME TABLE `invblueprinttypes` TO `invBlueprintTypes` ;
  32. RENAME TABLE `invcategories` TO `invCategories` ;
  33. RENAME TABLE `invcontrabandtypes` TO `invContrabandTypes` ;
  34. RENAME TABLE `invcontroltowerresourcepurposes` TO `invControlTowerResourcePurposes` ;
  35. RENAME TABLE `invcontroltowerresources` TO `invControlTowerResources` ;
  36. RENAME TABLE `invflags` TO `invFlags` ;
  37. RENAME TABLE `invgroups` TO `invGroups` ;
  38. RENAME TABLE `invitems` TO `invItems` ;
  39. RENAME TABLE `invmarketgroups` TO `invMarketGroups` ;
  40. RENAME TABLE `invmetagroups` TO `invMetaGroups` ;
  41. RENAME TABLE `invmetatypes` TO `invMetaTypes` ;
  42. RENAME TABLE `invnames` TO `invNames` ;
  43. RENAME TABLE `invpositions` TO `invPositions` ;
  44. RENAME TABLE `invtypematerials` TO `invTypeMaterials` ;
  45. RENAME TABLE `invtypereactions` TO `invTypeReactions` ;
  46. RENAME TABLE `invtypes` TO `invTypes` ;
  47. RENAME TABLE `invuniquenames` TO `invUniqueNames` ;
  48. RENAME TABLE `mapcelestialstatistics` TO `mapCelestialStatistics` ;
  49. RENAME TABLE `mapconstellationjumps` TO `mapConstellationJumps` ;
  50. RENAME TABLE `mapconstellations` TO `mapConstellations` ;
  51. RENAME TABLE `mapdenormalize` TO `mapDenormalize` ;
  52. RENAME TABLE `mapjumps` TO `mapJumps` ;
  53. RENAME TABLE `maplandmarks` TO `mapLandmarks` ;
  54. RENAME TABLE `maplocationscenes` TO `mapLocationScenes` ;
  55. RENAME TABLE `maplocationwormholeclasses` TO `mapLocationWormholeClasses` ;
  56. RENAME TABLE `mapregionjumps` TO `mapRegionJumps` ;
  57. RENAME TABLE `mapregions` TO `mapRegions` ;
  58. RENAME TABLE `mapsolarsystemjumps` TO `mapSolarSystemJumps` ;
  59. RENAME TABLE `mapsolarsystems` TO `mapSolarSystems` ;
  60. RENAME TABLE `mapuniverse` TO `mapUniverse` ;
  61. RENAME TABLE `planetschematics` TO `planetSchematics` ;
  62. RENAME TABLE `planetschematicspinmap` TO `planetSchematicsPinMap` ;
  63. RENAME TABLE `planetschematicstypemap` TO `planetSchematicsTypeMap` ;
  64. RENAME TABLE `ramactivities` TO `ramActivities` ;
  65. RENAME TABLE `ramassemblylines` TO `ramAssemblyLines` ;
  66. RENAME TABLE `ramassemblylinestations` TO `ramAssemblyLineStations` ;
  67. RENAME TABLE `ramassemblylinetypedetailpercategory` TO `ramAssemblyLineTypeDetailPerCategory` ;
  68. RENAME TABLE `ramassemblylinetypedetailpergroup` TO `ramAssemblyLineTypeDetailPerGroup` ;
  69. RENAME TABLE `ramassemblylinetypes` TO `ramAssemblyLineTypes` ;
  70. RENAME TABLE `raminstallationtypecontents` TO `ramInstallationTypeContents` ;
  71. RENAME TABLE `ramtyperequirements` TO `ramTypeRequirements` ;
  72. RENAME TABLE `stastations` TO `staStations` ;
  73. RENAME TABLE `staoperations` TO `staOperations` ;
  74. RENAME TABLE `staoperationservices` TO `staOperationServices` ;
  75. RENAME TABLE `staservices` TO `staServices` ;
  76. RENAME TABLE `stastationtypes` TO `staStationTypes` ;
  77. RENAME TABLE `translationtables` TO `translationTables` ;
  78. RENAME TABLE `trntranslations` TO `trnTranslations` ;
  79. RENAME TABLE `trntranslationcolumns` TO `trnTranslationColumns` ;
  80. RENAME TABLE `trntranslationlanguages` TO `trnTranslationLanguages` ;
  81. RENAME TABLE `warcombatzones` TO `warCombatZones` ;
  82. RENAME TABLE `warcombatzonesystems` TO `warCombatZoneSystems` ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement