Angepinnt DB-Changes

    Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

    • Upcoming changes:
      - creature_names and creature_proto going to be in one table creature_properties

      Rename:
      - Rename: event_names -> event_properties
      - Rename: gamobject_namse -> gameobject_properties
      - Rename: items -> item_properties
      - Rename: itempages -> item_pages
      - Rename: items_extendedcost -> item_extended_cost
      - Rename: items_linked_itemsets -> itemset_linked_itemsetbonus
      - Rename: quests -> quest_properties
      - Rename: teleport_coords -> spell_teleport_coords

      - Rename: localized tables:
      -- creature_name_localized ->locales_creature
      -- gameobject_names_localized -> locales_gameobject
      -- items_localized -> locales_item
      -- itempages_lacalized -> locales_item_pages
      -- npc_monstersay_localized -> locales_npc_monstersay
      -- npc_script_text_localized -> locales_npc_script_text
      -- npc_text_localized -> locales_npc_text
      -- worldbroadcast_localized -> locales_worldbroadcast
      -- worldstring_tables_localized -> locales_worldstring_table

      We will list the major .sqls here for simple update your world db.
    • For custom users:
      You need to execute the following 3 .sql files:
      [IMG:http://i.imgur.com/62aBdHP.jpg]








      1. The first sql will rename a bunch of tables.
      2. The secodn sql converts your creature_proto to creature_properties and copies all data from creature_names into it..
      3. The third sql will delete your creature_names and creature_proto table..


      The world_db wiki page is updated: AscEmu Wiki: World_DB