By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
18 rows affected
| (No column name) |
|---|
| <root><Gear id="1"><materials><material><id>1</id><material_name>Bar</material_name></material><material><id>2</id><material_name>Leather</material_name></material></materials><category><id>1</id><name>Warrior Weapons</name></category><equipment><id>1</id><equipment_name>Claymore</equipment_name><category>1</category></equipment><recipes><recipe><equipment_id>1</equipment_id><material_id>1</material_id><material_quantity>20</material_quantity></recipe><recipe><equipment_id>1</equipment_id><material_id>2</material_id><material_quantity>12</material_quantity></recipe></recipes></Gear><Gear id="2"><materials><material><id>3</id><material_name>Plank</material_name></material></materials><category><id>2</id><name>Hunter Weapons</name></category><equipment><id>2</id><equipment_name>Bow</equipment_name><category>2</category></equipment><recipes><recipe><equipment_id>2</equipment_id><material_id>3</material_id><material_quantity>32</material_quantity></recipe></recipes></Gear><Gear id="3"><materials><material><id>1</id><material_name>Bar</material_name></material><material><id>3</id><material_name>Plank</material_name></material></materials><category><id>3</id><name>Mage Weapons</name></category><equipment><id>3</id><equipment_name>Fire Staff</equipment_name><category>3</category></equipment><recipes><recipe><equipment_id>3</equipment_id><material_id>3</material_id><material_quantity>16</material_quantity></recipe><recipe><equipment_id>3</equipment_id><material_id>1</material_id><material_quantity>8</material_quantity></recipe></recipes></Gear><Gear id="4"><materials><material><id>1</id><material_name>Bar</material_name></material></materials><category><id>4</id><name>Warrior Armours</name></category><equipment><id>4</id><equipment_name>Knight Armor</equipment_name><category>4</category></equipment><recipes><recipe><equipment_id>4</equipment_id><material_id>1</material_id><material_quantity>16</material_quantity></recipe></recipes></Gear></root> |