mauirixxx
/
gwtt
1
0
Forka 0
Codice Problemi 0 Pull Requests 0 Rilasci 0 Wiki Attività
Just a web script to help track when, where, and what you got from the free treasures scattered about Nightfall in the game Guild Wars.
Non puoi selezionare più di 25 argomenti Gli argomenti devono iniziare con una lettera o un numero, possono includere trattini ('-') e possono essere lunghi fino a 35 caratteri.
310 Commit
2 Rami (Branch)
176 KiB
 
 
 
Ramo (Branch): master
Rami (Branch) Tag
${ item.name }
Crea branch ${ searchTerm }
da 'master'
${ noResults }
gwtt/db/gw-treasure-listrunes.sql

32 righe
2.1 KiB
Originale Permalink Blame Cronologia 

  1. /*

  2. SQLyog Ultimate - MySQL GUI v8.2 

  3. MySQL - 5.5.52-MariaDB : Database - mauirixxx

  4. *********************************************************************

  5. */


  6. 

  7. /*!40101 SET NAMES utf8 */;

  8. 

  9. /*!40101 SET SQL_MODE=''*/;

  10. 

  11. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

  12. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

  13. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

  14. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

  15. /*Table structure for table `listrunes` */

  16. 

  17. CREATE TABLE `listrunes` (

  18.   `runeid` int(2) NOT NULL AUTO_INCREMENT,

  19.   `runeclassid` int(2) DEFAULT NULL,

  20.   `runes` varchar(19) DEFAULT NULL,

  21.   PRIMARY KEY (`runeid`)

  22. ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;

  23. 

  24. /*Data for the table `listrunes` */

  25. 

  26. insert  into `listrunes`(`runeid`,`runeclassid`,`runes`) values (1,1,'Attunement'),(2,1,'Clarity'),(3,1,'Purity'),(4,1,'Recovery'),(5,1,'Restoration'),(6,1,'Vigor'),(7,1,'Vitae'),(8,2,'Absorption'),(9,2,'Axe Mastery'),(10,2,'Hammer Mastery'),(11,2,'Strength'),(12,2,'Swordsmanship'),(13,2,'Tactics'),(14,3,'Beast Mastery'),(15,3,'Expertise'),(16,3,'Marksmanship'),(17,3,'Wilderness Survival'),(18,4,'Divine Favor'),(19,4,'Healing Prayers'),(20,4,'Protection Prayer'),(21,4,'Smiting Prayers'),(22,5,'Blood Magic'),(23,5,'Curses'),(24,5,'Death Magic'),(25,5,'Soul Reaping'),(26,6,'Domination Magic'),(27,6,'Fast Casting'),(28,6,'Illusion Magic'),(29,6,'Inspiration Magic'),(30,7,'Air Magic'),(31,7,'Earth Magic'),(32,7,'Energy Storage'),(33,7,'Fire Magic'),(34,7,'Water Magic'),(35,8,'Critical Strikes'),(36,8,'Dagger Mastery'),(37,8,'Deadly Arts'),(38,8,'Shadow Arts'),(39,9,'Channeling Magic'),(40,9,'Communing'),(41,9,'Restoration Magic'),(42,9,'Spawning Power'),(43,10,'Command'),(44,10,'Leadership'),(45,10,'Motivation'),(46,10,'Spear Mastery'),(47,11,'Earth Prayers'),(48,11,'Mysticism'),(49,11,'Scythe Mastery'),(50,11,'Wind Prayers');

  27. 

  28. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

  29. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

  30. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

  31. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;