diff options
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/auth_database.sql | 45 | ||||
| -rw-r--r-- | sql/base/characters_database.sql | 9 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 3662 |
3 files changed, 3705 insertions, 11 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index 1150602ffc8..090a90597b5 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) +-- MySQL dump 10.15 Distrib 10.0.12-MariaDB, for Win64 (x86) -- -- Host: localhost Database: auth -- ------------------------------------------------------ --- Server version 5.6.9-rc +-- Server version 10.0.12-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -34,6 +34,7 @@ CREATE TABLE `account` ( `reg_mail` varchar(255) NOT NULL DEFAULT '', `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', + `last_attempt_ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', `failed_logins` int(10) unsigned NOT NULL DEFAULT '0', `locked` tinyint(3) unsigned NOT NULL DEFAULT '0', `lock_country` varchar(2) NOT NULL DEFAULT '00', @@ -224,7 +225,7 @@ DROP TABLE IF EXISTS `logs`; CREATE TABLE `logs` ( `time` int(10) unsigned NOT NULL, `realm` int(10) unsigned NOT NULL, - `type` varchar(250), + `type` varchar(250) NOT NULL, `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `string` text CHARACTER SET latin1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -240,6 +241,36 @@ LOCK TABLES `logs` WRITE; UNLOCK TABLES; -- +-- Table structure for table `logs_ip_actions` +-- + +DROP TABLE IF EXISTS `logs_ip_actions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `logs_ip_actions` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique Identifier', + `account_id` int(10) unsigned NOT NULL COMMENT 'Account ID', + `character_guid` int(10) unsigned NOT NULL COMMENT 'Character Guid', + `type` tinyint(3) unsigned NOT NULL, + `ip` varchar(15) NOT NULL DEFAULT '127.0.0.1', + `systemnote` text COMMENT 'Notes inserted by system', + `unixtime` int(10) unsigned NOT NULL COMMENT 'Unixtime', + `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp', + `comment` text COMMENT 'Allows users to add a comment', + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Used to log ips of individual actions'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `logs_ip_actions` +-- + +LOCK TABLES `logs_ip_actions` WRITE; +/*!40000 ALTER TABLE `logs_ip_actions` DISABLE KEYS */; +/*!40000 ALTER TABLE `logs_ip_actions` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `rbac_account_permissions` -- @@ -289,7 +320,7 @@ CREATE TABLE `rbac_default_permissions` ( LOCK TABLES `rbac_default_permissions` WRITE; /*!40000 ALTER TABLE `rbac_default_permissions` DISABLE KEYS */; -INSERT INTO `rbac_default_permissions` VALUES (3,192),(2,193),(1,194),(0,195); +INSERT INTO `rbac_default_permissions` VALUES (0,195),(1,194),(2,193),(3,192); /*!40000 ALTER TABLE `rbac_default_permissions` ENABLE KEYS */; UNLOCK TABLES; @@ -317,7 +348,7 @@ CREATE TABLE `rbac_linked_permissions` ( LOCK TABLES `rbac_linked_permissions` WRITE; /*!40000 ALTER TABLE `rbac_linked_permissions` DISABLE KEYS */; -INSERT INTO `rbac_linked_permissions` VALUES (192,21),(192,42),(192,43),(192,193),(192,196),(193,48),(193,194),(193,197),(194,1),(194,2),(194,11),(194,13),(194,14),(194,15),(194,16),(194,17),(194,18),(194,19),(194,20),(194,22),(194,23),(194,25),(194,26),(194,27),(194,28),(194,29),(194,30),(194,31),(194,32),(194,33),(194,34),(194,35),(194,36),(194,37),(194,38),(194,39),(194,40),(194,41),(194,44),(194,46),(194,47),(194,195),(194,198),(195,3),(195,4),(195,5),(195,6),(195,24),(195,49),(195,199),(196,200),(196,201),(196,226),(196,227),(196,230),(196,231),(196,233),(196,234),(196,235),(196,238),(196,239),(196,240),(196,241),(196,242),(196,243),(196,244),(196,245),(196,246),(196,247),(196,248),(196,249),(196,250),(196,251),(196,252),(196,253),(196,254),(196,255),(196,256),(196,257),(196,258),(196,259),(196,260),(196,261),(196,262),(196,264),(196,265),(196,266),(196,267),(196,268),(196,269),(196,270),(196,271),(196,272),(196,279),(196,280),(196,283),(196,287),(196,288),(196,289),(196,290),(196,291),(196,292),(196,293),(196,294),(196,295),(196,296),(196,297),(196,298),(196,299),(196,302),(196,303),(196,304),(196,305),(196,306),(196,307),(196,308),(196,309),(196,310),(196,313),(196,314),(196,319),(196,320),(196,321),(196,322),(196,323),(196,324),(196,325),(196,326),(196,327),(196,328),(196,329),(196,330),(196,331),(196,332),(196,333),(196,334),(196,335),(196,336),(196,337),(196,338),(196,339),(196,340),(196,341),(196,342),(196,343),(196,344),(196,345),(196,346),(196,347),(196,348),(196,349),(196,350),(196,351),(196,352),(196,353),(196,354),(196,355),(196,356),(196,357),(196,358),(196,359),(196,360),(196,361),(196,362),(196,363),(196,364),(196,365),(196,366),(196,373),(196,375),(196,400),(196,401),(196,402),(196,403),(196,404),(196,405),(196,406),(196,407),(196,417),(196,418),(196,419),(196,420),(196,421),(196,422),(196,423),(196,424),(196,425),(196,426),(196,427),(196,428),(196,429),(196,434),(196,435),(196,436),(196,437),(196,438),(196,439),(196,440),(196,441),(196,442),(196,443),(196,444),(196,445),(196,446),(196,447),(196,448),(196,449),(196,450),(196,451),(196,452),(196,453),(196,454),(196,455),(196,456),(196,457),(196,458),(196,459),(196,461),(196,463),(196,464),(196,465),(196,472),(196,473),(196,474),(196,475),(196,476),(196,477),(196,478),(196,488),(196,489),(196,491),(196,492),(196,493),(196,495),(196,497),(196,498),(196,499),(196,500),(196,502),(196,503),(196,505),(196,508),(196,511),(196,513),(196,514),(196,516),(196,519),(196,522),(196,523),(196,526),(196,527),(196,529),(196,530),(196,533),(196,535),(196,536),(196,537),(196,538),(196,539),(196,540),(196,541),(196,556),(196,581),(196,582),(196,592),(196,593),(196,596),(196,602),(196,603),(196,604),(196,605),(196,606),(196,607),(196,608),(196,609),(196,610),(196,611),(196,612),(196,613),(196,614),(196,615),(196,616),(196,617),(196,618),(196,619),(196,620),(196,621),(196,622),(196,623),(196,624),(196,625),(196,626),(196,627),(196,628),(196,629),(196,630),(196,631),(196,632),(196,633),(196,634),(196,635),(196,636),(196,637),(196,638),(196,639),(196,640),(196,641),(196,642),(196,643),(196,644),(196,645),(196,646),(196,647),(196,648),(196,649),(196,650),(196,651),(196,652),(196,653),(196,654),(196,655),(196,656),(196,657),(196,658),(196,659),(196,660),(196,661),(196,662),(196,663),(196,664),(196,665),(196,666),(196,667),(196,668),(196,669),(196,670),(196,671),(196,672),(196,673),(196,674),(196,675),(196,676),(196,677),(196,678),(196,679),(196,680),(196,681),(196,682),(196,683),(196,684),(196,685),(196,686),(196,687),(196,688),(196,689),(196,690),(196,691),(196,692),(196,693),(196,694),(196,695),(196,696),(196,697),(196,698),(196,699),(196,700),(196,701),(196,702),(196,703),(196,704),(196,705),(196,706),(196,707),(196,708),(196,709),(196,710),(196,711),(196,712),(196,713),(196,714),(196,715),(196,716),(196,717),(196,718),(196,719),(196,721),(196,722),(196,723),(196,724),(196,725),(196,726),(196,727),(196,728),(196,729),(196,730),(196,733),(196,734),(196,735),(196,736),(196,738),(196,739),(196,748),(196,753),(196,757),(196,773),(197,232),(197,236),(197,237),(197,273),(197,274),(197,275),(197,276),(197,277),(197,284),(197,285),(197,286),(197,301),(197,311),(197,387),(197,388),(197,389),(197,390),(197,391),(197,392),(197,393),(197,394),(197,395),(197,396),(197,397),(197,398),(197,399),(197,479),(197,480),(197,481),(197,482),(197,485),(197,486),(197,487),(197,494),(197,506),(197,509),(197,510),(197,517),(197,518),(197,521),(197,542),(197,543),(197,550),(197,558),(197,568),(197,571),(197,572),(197,573),(197,574),(197,575),(197,576),(197,577),(197,578),(197,579),(197,580),(197,583),(197,584),(197,585),(197,586),(197,587),(197,588),(197,589),(197,590),(197,591),(197,594),(197,595),(197,601),(197,743),(197,750),(197,758),(197,761),(197,762),(197,763),(197,764),(197,765),(197,766),(197,767),(197,768),(197,769),(197,770),(197,771),(197,772),(197,774),(198,218),(198,300),(198,312),(198,315),(198,316),(198,317),(198,318),(198,367),(198,368),(198,369),(198,370),(198,371),(198,372),(198,374),(198,376),(198,377),(198,378),(198,379),(198,380),(198,381),(198,382),(198,383),(198,384),(198,385),(198,386),(198,408),(198,409),(198,410),(198,411),(198,412),(198,413),(198,414),(198,415),(198,416),(198,430),(198,431),(198,432),(198,433),(198,462),(198,466),(198,467),(198,468),(198,469),(198,470),(198,471),(198,483),(198,484),(198,490),(198,504),(198,512),(198,515),(198,520),(198,524),(198,528),(198,531),(198,532),(198,544),(198,545),(198,546),(198,547),(198,548),(198,549),(198,551),(198,552),(198,553),(198,554),(198,555),(198,557),(198,559),(198,560),(198,561),(198,562),(198,563),(198,564),(198,565),(198,566),(198,567),(198,569),(198,570),(198,597),(198,598),(198,599),(198,600),(198,737),(198,740),(198,741),(198,742),(198,744),(198,745),(198,746),(198,747),(198,749),(198,751),(198,752),(198,754),(198,755),(198,756),(198,759),(198,760),(199,217),(199,221),(199,222),(199,223),(199,225),(199,263),(199,496),(199,501),(199,507),(199,525),(199,534); +INSERT INTO `rbac_linked_permissions` VALUES (192,21),(192,42),(192,43),(192,193),(192,196),(193,48),(193,194),(193,197),(194,1),(194,2),(194,11),(194,13),(194,14),(194,15),(194,16),(194,17),(194,18),(194,19),(194,20),(194,22),(194,23),(194,25),(194,26),(194,27),(194,28),(194,29),(194,30),(194,31),(194,32),(194,33),(194,34),(194,35),(194,36),(194,37),(194,38),(194,39),(194,40),(194,41),(194,44),(194,46),(194,47),(194,195),(194,198),(195,3),(195,4),(195,5),(195,6),(195,24),(195,49),(195,199),(196,200),(196,201),(196,226),(196,227),(196,230),(196,231),(196,233),(196,234),(196,235),(196,238),(196,239),(196,240),(196,241),(196,242),(196,243),(196,244),(196,245),(196,246),(196,247),(196,248),(196,249),(196,250),(196,251),(196,252),(196,253),(196,254),(196,255),(196,256),(196,257),(196,258),(196,259),(196,260),(196,261),(196,262),(196,264),(196,265),(196,266),(196,267),(196,268),(196,269),(196,270),(196,271),(196,272),(196,279),(196,280),(196,283),(196,287),(196,288),(196,289),(196,290),(196,291),(196,292),(196,293),(196,294),(196,295),(196,296),(196,297),(196,298),(196,299),(196,302),(196,303),(196,304),(196,305),(196,306),(196,307),(196,308),(196,309),(196,310),(196,313),(196,314),(196,319),(196,320),(196,321),(196,322),(196,323),(196,324),(196,325),(196,326),(196,327),(196,328),(196,329),(196,330),(196,331),(196,332),(196,333),(196,334),(196,335),(196,336),(196,337),(196,338),(196,339),(196,340),(196,341),(196,342),(196,343),(196,344),(196,345),(196,346),(196,347),(196,348),(196,349),(196,350),(196,351),(196,352),(196,353),(196,354),(196,355),(196,356),(196,357),(196,358),(196,359),(196,360),(196,361),(196,362),(196,363),(196,364),(196,365),(196,366),(196,373),(196,375),(196,400),(196,401),(196,402),(196,403),(196,404),(196,405),(196,406),(196,407),(196,417),(196,418),(196,419),(196,420),(196,421),(196,422),(196,423),(196,424),(196,425),(196,426),(196,427),(196,428),(196,429),(196,434),(196,435),(196,436),(196,437),(196,438),(196,439),(196,440),(196,441),(196,442),(196,443),(196,444),(196,445),(196,446),(196,447),(196,448),(196,449),(196,450),(196,451),(196,452),(196,453),(196,454),(196,455),(196,456),(196,457),(196,458),(196,459),(196,461),(196,463),(196,464),(196,465),(196,472),(196,473),(196,474),(196,475),(196,476),(196,477),(196,478),(196,488),(196,489),(196,491),(196,492),(196,493),(196,495),(196,497),(196,498),(196,499),(196,500),(196,502),(196,503),(196,505),(196,508),(196,511),(196,513),(196,514),(196,516),(196,519),(196,522),(196,523),(196,526),(196,527),(196,529),(196,530),(196,533),(196,535),(196,536),(196,537),(196,538),(196,539),(196,540),(196,541),(196,556),(196,581),(196,582),(196,592),(196,593),(196,596),(196,602),(196,603),(196,604),(196,605),(196,606),(196,607),(196,608),(196,609),(196,610),(196,611),(196,612),(196,613),(196,614),(196,615),(196,616),(196,617),(196,618),(196,619),(196,620),(196,621),(196,622),(196,623),(196,624),(196,625),(196,626),(196,627),(196,628),(196,629),(196,630),(196,631),(196,633),(196,634),(196,635),(196,636),(196,637),(196,638),(196,639),(196,640),(196,641),(196,642),(196,643),(196,644),(196,645),(196,646),(196,647),(196,648),(196,649),(196,650),(196,651),(196,652),(196,653),(196,654),(196,655),(196,656),(196,657),(196,658),(196,659),(196,660),(196,661),(196,662),(196,663),(196,664),(196,665),(196,666),(196,667),(196,668),(196,669),(196,670),(196,671),(196,672),(196,673),(196,674),(196,675),(196,676),(196,677),(196,678),(196,679),(196,680),(196,681),(196,682),(196,683),(196,684),(196,685),(196,686),(196,687),(196,688),(196,689),(196,690),(196,691),(196,692),(196,693),(196,694),(196,695),(196,696),(196,697),(196,698),(196,699),(196,700),(196,701),(196,702),(196,703),(196,704),(196,705),(196,706),(196,707),(196,708),(196,709),(196,710),(196,711),(196,712),(196,713),(196,714),(196,715),(196,716),(196,717),(196,718),(196,719),(196,721),(196,722),(196,723),(196,724),(196,725),(196,726),(196,727),(196,728),(196,729),(196,730),(196,733),(196,734),(196,735),(196,736),(196,738),(196,739),(196,748),(196,753),(196,757),(196,773),(196,777),(197,232),(197,236),(197,237),(197,273),(197,274),(197,275),(197,276),(197,277),(197,284),(197,285),(197,286),(197,301),(197,311),(197,387),(197,388),(197,389),(197,390),(197,391),(197,392),(197,393),(197,394),(197,395),(197,396),(197,397),(197,398),(197,399),(197,479),(197,480),(197,481),(197,482),(197,485),(197,486),(197,487),(197,494),(197,506),(197,509),(197,510),(197,517),(197,518),(197,521),(197,542),(197,543),(197,550),(197,558),(197,568),(197,571),(197,572),(197,573),(197,574),(197,575),(197,576),(197,577),(197,578),(197,579),(197,580),(197,583),(197,584),(197,585),(197,586),(197,587),(197,588),(197,589),(197,590),(197,591),(197,594),(197,595),(197,601),(197,743),(197,750),(197,758),(197,761),(197,762),(197,763),(197,764),(197,765),(197,766),(197,767),(197,768),(197,769),(197,770),(197,771),(197,772),(197,774),(198,218),(198,300),(198,312),(198,315),(198,316),(198,317),(198,318),(198,367),(198,368),(198,369),(198,370),(198,371),(198,372),(198,374),(198,376),(198,377),(198,378),(198,379),(198,380),(198,381),(198,382),(198,383),(198,384),(198,385),(198,386),(198,408),(198,409),(198,410),(198,411),(198,412),(198,413),(198,414),(198,415),(198,416),(198,430),(198,431),(198,432),(198,433),(198,462),(198,466),(198,467),(198,468),(198,469),(198,470),(198,471),(198,483),(198,484),(198,490),(198,504),(198,512),(198,515),(198,520),(198,524),(198,528),(198,531),(198,532),(198,544),(198,545),(198,546),(198,547),(198,548),(198,549),(198,551),(198,552),(198,553),(198,554),(198,555),(198,557),(198,559),(198,560),(198,561),(198,562),(198,563),(198,564),(198,565),(198,566),(198,567),(198,569),(198,570),(198,597),(198,598),(198,599),(198,600),(198,737),(198,740),(198,741),(198,742),(198,744),(198,745),(198,746),(198,747),(198,749),(198,751),(198,752),(198,754),(198,755),(198,756),(198,759),(198,760),(199,217),(199,221),(199,222),(199,223),(199,225),(199,263),(199,496),(199,501),(199,507),(199,525),(199,534); /*!40000 ALTER TABLE `rbac_linked_permissions` ENABLE KEYS */; UNLOCK TABLES; @@ -341,7 +372,7 @@ CREATE TABLE `rbac_permissions` ( LOCK TABLES `rbac_permissions` WRITE; /*!40000 ALTER TABLE `rbac_permissions` DISABLE KEYS */; -INSERT INTO `rbac_permissions` VALUES (1,'Instant logout'),(2,'Skip Queue'),(3,'Join Normal Battleground'),(4,'Join Random Battleground'),(5,'Join Arenas'),(6,'Join Dungeon Finder'),(11,'Log GM trades'),(13,'Skip Instance required bosses check'),(14,'Skip character creation team mask check'),(15,'Skip character creation class mask check'),(16,'Skip character creation race mask check'),(17,'Skip character creation reserved name check'),(18,'Skip character creation heroic min level check'),(19,'Skip needed requirements to use channel check'),(20,'Skip disable map check'),(21,'Skip reset talents when used more than allowed check'),(22,'Skip spam chat check'),(23,'Skip over-speed ping check'),(24,'Two side faction characters on the same account'),(25,'Allow say chat between factions'),(26,'Allow channel chat between factions'),(27,'Two side mail interaction'),(28,'See two side who list'),(29,'Add friends of other faction'),(30,'Save character without delay with .save command'),(31,'Use params with .unstuck command'),(32,'Can be assigned tickets with .assign ticket command'),(33,'Notify if a command was not found'),(34,'Check if should appear in list using .gm ingame command'),(35,'See all security levels with who command'),(36,'Filter whispers'),(37,'Use staff badge in chat'),(38,'Resurrect with full Health Points'),(39,'Restore saved gm setting states'),(40,'Allows to add a gm to friend list'),(41,'Use Config option START_GM_LEVEL to assign new character level'),(42,'Allows to use CMSG_WORLD_TELEPORT opcode'),(43,'Allows to use CMSG_WHOIS opcode'),(44,'Receive global GM messages/texts'),(45,'Join channels without announce'),(46,'Change channel settings without being channel moderator'),(47,'Enables lower security than target check'),(48,'Enable IP, Last Login and EMail output in pinfo'),(49,'Forces to enter the email for confirmation on password change'),(50,'Allow user to check his own email with .account'),(192,'Role: Sec Level Administrator'),(193,'Role: Sec Level Gamemaster'),(194,'Role: Sec Level Moderator'),(195,'Role: Sec Level Player'),(196,'Role: Administrator Commands'),(197,'Role: Gamemaster Commands'),(198,'Role: Moderator Commands'),(199,'Role: Player Commands'),(200,'Command: rbac'),(201,'Command: rbac account'),(202,'Command: rbac account list'),(203,'Command: rbac account grant'),(204,'Command: rbac account deny'),(205,'Command: rbac account revoke'),(206,'Command: rbac list'),(217,'Command: account'),(218,'Command: account addon'),(219,'Command: account create'),(220,'Command: account delete'),(221,'Command: account lock'),(222,'Command: account lock country'),(223,'Command: account lock ip'),(224,'Command: account onlinelist'),(225,'Command: account password'),(226,'Command: account set'),(227,'Command: account set addon'),(228,'Command: account set gmlevel'),(229,'Command: account set password'),(230,'Command: achievement'),(231,'Command: achievement add'),(232,'Command: arena'),(233,'Command: arena captain'),(234,'Command: arena create'),(235,'Command: arena disband'),(236,'Command: arena info'),(237,'Command: arena lookup'),(238,'Command: arena rename'),(239,'Command: ban'),(240,'Command: ban account'),(241,'Command: ban character'),(242,'Command: ban ip'),(243,'Command: ban playeraccount'),(244,'Command: baninfo'),(245,'Command: baninfo account'),(246,'Command: baninfo character'),(247,'Command: baninfo ip'),(248,'Command: banlist'),(249,'Command: banlist account'),(250,'Command: banlist character'),(251,'Command: banlist ip'),(252,'Command: unban'),(253,'Command: unban account'),(254,'Command: unban character'),(255,'Command: unban ip'),(256,'Command: unban playeraccount'),(257,'Command: bf'),(258,'Command: bf start'),(259,'Command: bf stop'),(260,'Command: bf switch'),(261,'Command: bf timer'),(262,'Command: bf enable'),(263,'Command: account email'),(264,'Command: account set sec'),(265,'Command: account set sec email'),(266,'Command: account set sec regmail'),(267,'Command: cast'),(268,'Command: cast back'),(269,'Command: cast dist'),(270,'Command: cast self'),(271,'Command: cast target'),(272,'Command: cast dest'),(273,'Command: character'),(274,'Command: character customize'),(275,'Command: character changefaction'),(276,'Command: character changerace'),(277,'Command: character deleted'),(279,'Command: character deleted list'),(280,'Command: character deleted restore'),(283,'Command: character level'),(284,'Command: character rename'),(285,'Command: character reputation'),(286,'Command: character titles'),(287,'Command: levelup'),(288,'Command: pdump'),(289,'Command: pdump load'),(290,'Command: pdump write'),(291,'Command: cheat'),(292,'Command: cheat casttime'),(293,'Command: cheat cooldown'),(294,'Command: cheat explore'),(295,'Command: cheat god'),(296,'Command: cheat power'),(297,'Command: cheat status'),(298,'Command: cheat taxi'),(299,'Command: cheat waterwalk'),(300,'Command: debug'),(301,'Command: debug anim'),(302,'Command: debug areatriggers'),(303,'Command: debug arena'),(304,'Command: debug bg'),(305,'Command: debug entervehicle'),(306,'Command: debug getitemstate'),(307,'Command: debug getitemvalue'),(308,'Command: debug getvalue'),(309,'Command: debug hostil'),(310,'Command: debug itemexpire'),(311,'Command: debug lootrecipient'),(312,'Command: debug los'),(313,'Command: debug mod32value'),(314,'Command: debug moveflags'),(315,'Command: debug play'),(316,'Command: debug play cinematics'),(317,'Command: debug play movie'),(318,'Command: debug play sound'),(319,'Command: debug send'),(320,'Command: debug send buyerror'),(321,'Command: debug send channelnotify'),(322,'Command: debug send chatmessage'),(323,'Command: debug send equiperror'),(324,'Command: debug send largepacket'),(325,'Command: debug send opcode'),(326,'Command: debug send qinvalidmsg'),(327,'Command: debug send qpartymsg'),(328,'Command: debug send sellerror'),(329,'Command: debug send setphaseshift'),(330,'Command: debug send spellfail'),(331,'Command: debug setaurastate'),(332,'Command: debug setbit'),(333,'Command: debug setitemvalue'),(334,'Command: debug setvalue'),(335,'Command: debug setvid'),(336,'Command: debug spawnvehicle'),(337,'Command: debug threat'),(338,'Command: debug update'),(339,'Command: debug uws'),(340,'Command: wpgps'),(341,'Command: deserter'),(342,'Command: deserter bg'),(343,'Command: deserter bg add'),(344,'Command: deserter bg remove'),(345,'Command: deserter instance'),(346,'Command: deserter instance add'),(347,'Command: deserter instance remove'),(348,'Command: disable'),(349,'Command: disable add'),(350,'Command: disable add achievement_criteria'),(351,'Command: disable add battleground'),(352,'Command: disable add map'),(353,'Command: disable add mmap'),(354,'Command: disable add outdoorpvp'),(355,'Command: disable add quest'),(356,'Command: disable add spell'),(357,'Command: disable add vmap'),(358,'Command: disable remove'),(359,'Command: disable remove achievement_criteria'),(360,'Command: disable remove battleground'),(361,'Command: disable remove map'),(362,'Command: disable remove mmap'),(363,'Command: disable remove outdoorpvp'),(364,'Command: disable remove quest'),(365,'Command: disable remove spell'),(366,'Command: disable remove vmap'),(367,'Command: event'),(368,'Command: event activelist'),(369,'Command: event start'),(370,'Command: event stop'),(371,'Command: gm'),(372,'Command: gm chat'),(373,'Command: gm fly'),(374,'Command: gm ingame'),(375,'Command: gm list'),(376,'Command: gm visible'),(377,'Command: go'),(378,'Command: go creature'),(379,'Command: go graveyard'),(380,'Command: go grid'),(381,'Command: go object'),(382,'Command: go taxinode'),(383,'Command: go ticket'),(384,'Command: go trigger'),(385,'Command: go xyz'),(386,'Command: go zonexy'),(387,'Command: gobject'),(388,'Command: gobject activate'),(389,'Command: gobject add'),(390,'Command: gobject add temp'),(391,'Command: gobject delete'),(392,'Command: gobject info'),(393,'Command: gobject move'),(394,'Command: gobject near'),(395,'Command: gobject set'),(396,'Command: gobject set phase'),(397,'Command: gobject set state'),(398,'Command: gobject target'),(399,'Command: gobject turn'),(400,'debug transport'),(401,'Command: guild'),(402,'Command: guild create'),(403,'Command: guild delete'),(404,'Command: guild invite'),(405,'Command: guild uninvite'),(406,'Command: guild rank'),(407,'Command: guild rename'),(408,'Command: honor'),(409,'Command: honor add'),(410,'Command: honor add kill'),(411,'Command: honor update'),(412,'Command: instance'),(413,'Command: instance listbinds'),(414,'Command: instance unbind'),(415,'Command: instance stats'),(416,'Command: instance savedata'),(417,'Command: learn'),(418,'Command: learn all'),(419,'Command: learn all my'),(420,'Command: learn all my class'),(421,'Command: learn all my pettalents'),(422,'Command: learn all my spells'),(423,'Command: learn all my talents'),(424,'Command: learn all gm'),(425,'Command: learn all crafts'),(426,'Command: learn all default'),(427,'Command: learn all lang'),(428,'Command: learn all recipes'),(429,'Command: unlearn'),(430,'Command: lfg'),(431,'Command: lfg player'),(432,'Command: lfg group'),(433,'Command: lfg queue'),(434,'Command: lfg clean'),(435,'Command: lfg options'),(436,'Command: list'),(437,'Command: list creature'),(438,'Command: list item'),(439,'Command: list object'),(440,'Command: list auras'),(441,'Command: list mail'),(442,'Command: lookup'),(443,'Command: lookup area'),(444,'Command: lookup creature'),(445,'Command: lookup event'),(446,'Command: lookup faction'),(447,'Command: lookup item'),(448,'Command: lookup itemset'),(449,'Command: lookup object'),(450,'Command: lookup quest'),(451,'Command: lookup player'),(452,'Command: lookup player ip'),(453,'Command: lookup player account'),(454,'Command: lookup player email'),(455,'Command: lookup skill'),(456,'Command: lookup spell'),(457,'Command: lookup spell id'),(458,'Command: lookup taxinode'),(459,'Command: lookup tele'),(460,'Command: lookup title'),(461,'Command: lookup map'),(462,'Command: announce'),(463,'Command: channel'),(464,'Command: channel set'),(465,'Command: channel set ownership'),(466,'Command: gmannounce'),(467,'Command: gmnameannounce'),(468,'Command: gmnotify'),(469,'Command: nameannounce'),(470,'Command: notify'),(471,'Command: whispers'),(472,'Command: group'),(473,'Command: group leader'),(474,'Command: group disband'),(475,'Command: group remove'),(476,'Command: group join'),(477,'Command: group list'),(478,'Command: group summon'),(479,'Command: pet'),(480,'Command: pet create'),(481,'Command: pet learn'),(482,'Command: pet unlearn'),(483,'Command: send'),(484,'Command: send items'),(485,'Command: send mail'),(486,'Command: send message'),(487,'Command: send money'),(488,'Command: additem'),(489,'Command: additemset'),(490,'Command: appear'),(491,'Command: aura'),(492,'Command: bank'),(493,'Command: bindsight'),(494,'Command: combatstop'),(495,'Command: cometome'),(496,'Command: commands'),(497,'Command: cooldown'),(498,'Command: damage'),(499,'Command: dev'),(500,'Command: die'),(501,'Command: dismount'),(502,'Command: distance'),(503,'Command: flusharenapoints'),(504,'Command: freeze'),(505,'Command: gps'),(506,'Command: guid'),(507,'Command: help'),(508,'Command: hidearea'),(509,'Command: itemmove'),(510,'Command: kick'),(511,'Command: linkgrave'),(512,'Command: listfreeze'),(513,'Command: maxskill'),(514,'Command: movegens'),(515,'Command: mute'),(516,'Command: neargrave'),(517,'Command: pinfo'),(518,'Command: playall'),(519,'Command: possess'),(520,'Command: recall'),(521,'Command: repairitems'),(522,'Command: respawn'),(523,'Command: revive'),(524,'Command: saveall'),(525,'Command: save'),(526,'Command: setskill'),(527,'Command: showarea'),(528,'Command: summon'),(529,'Command: unaura'),(530,'Command: unbindsight'),(531,'Command: unfreeze'),(532,'Command: unmute'),(533,'Command: unpossess'),(534,'Command: unstuck'),(535,'Command: wchange'),(536,'Command: mmap'),(537,'Command: mmap loadedtiles'),(538,'Command: mmap loc'),(539,'Command: mmap path'),(540,'Command: mmap stats'),(541,'Command: mmap testarea'),(542,'Command: morph'),(543,'Command: demorph'),(544,'Command: modify'),(545,'Command: modify arenapoints'),(546,'Command: modify bit'),(547,'Command: modify drunk'),(548,'Command: modify energy'),(549,'Command: modify faction'),(550,'Command: modify gender'),(551,'Command: modify honor'),(552,'Command: modify hp'),(553,'Command: modify mana'),(554,'Command: modify money'),(555,'Command: modify mount'),(556,'Command: modify phase'),(557,'Command: modify rage'),(558,'Command: modify reputation'),(559,'Command: modify runicpower'),(560,'Command: modify scale'),(561,'Command: modify speed'),(562,'Command: modify speed all'),(563,'Command: modify speed backwalk'),(564,'Command: modify speed fly'),(565,'Command: modify speed walk'),(566,'Command: modify speed swim'),(567,'Command: modify spell'),(568,'Command: modify standstate'),(569,'Command: modify talentpoints'),(570,'Command: npc'),(571,'Command: npc add'),(572,'Command: npc add formation'),(573,'Command: npc add item'),(574,'Command: npc add move'),(575,'Command: npc add temp'),(576,'Command: npc add delete'),(577,'Command: npc add delete item'),(578,'Command: npc add follow'),(579,'Command: npc add follow stop'),(580,'Command: npc set'),(581,'Command: npc set allowmove'),(582,'Command: npc set entry'),(583,'Command: npc set factionid'),(584,'Command: npc set flag'),(585,'Command: npc set level'),(586,'Command: npc set link'),(587,'Command: npc set model'),(588,'Command: npc set movetype'),(589,'Command: npc set phase'),(590,'Command: npc set spawndist'),(591,'Command: npc set spawntime'),(592,'Command: npc set data'),(593,'Command: npc info'),(594,'Command: npc near'),(595,'Command: npc move'),(596,'Command: npc playemote'),(597,'Command: npc say'),(598,'Command: npc textemote'),(599,'Command: npc whisper'),(600,'Command: npc yell'),(601,'Command: npc tame'),(602,'Command: quest'),(603,'Command: quest add'),(604,'Command: quest complete'),(605,'Command: quest remove'),(606,'Command: quest reward'),(607,'Command: reload'),(608,'Command: reload access_requirement'),(609,'Command: reload achievement_criteria_data'),(610,'Command: reload achievement_reward'),(611,'Command: reload all'),(612,'Command: reload all achievement'),(613,'Command: reload all area'),(614,'Command: reload all eventai'),(615,'Command: reload all gossips'),(616,'Command: reload all item'),(617,'Command: reload all locales'),(618,'Command: reload all loot'),(619,'Command: reload all npc'),(620,'Command: reload all quest'),(621,'Command: reload all scripts'),(622,'Command: reload all spell'),(623,'Command: reload areatrigger_involvedrelation'),(624,'Command: reload areatrigger_tavern'),(625,'Command: reload areatrigger_teleport'),(626,'Command: reload auctions'),(627,'Command: reload autobroadcast'),(628,'Command: reload command'),(629,'Command: reload conditions'),(630,'Command: reload config'),(631,'Command: reload creature_text'),(632,'Command: reload creature_ai_scripts'),(633,'Command: reload creature_ai_texts'),(634,'Command: reload creature_questender'),(635,'Command: reload creature_linked_respawn'),(636,'Command: reload creature_loot_template'),(637,'Command: reload creature_onkill_reputation'),(638,'Command: reload creature_queststarter'),(639,'Command: reload creature_summon_groups'),(640,'Command: reload creature_template'),(641,'Command: reload disables'),(642,'Command: reload disenchant_loot_template'),(643,'Command: reload event_scripts'),(644,'Command: reload fishing_loot_template'),(645,'Command: reload game_graveyard_zone'),(646,'Command: reload game_tele'),(647,'Command: reload gameobject_questender'),(648,'Command: reload gameobject_loot_template'),(649,'Command: reload gameobject_queststarter'),(650,'Command: reload gm_tickets'),(651,'Command: reload gossip_menu'),(652,'Command: reload gossip_menu_option'),(653,'Command: reload item_enchantment_template'),(654,'Command: reload item_loot_template'),(655,'Command: reload item_set_names'),(656,'Command: reload lfg_dungeon_rewards'),(657,'Command: reload locales_achievement_reward'),(658,'Command: reload locales_creature'),(659,'Command: reload locales_creature_text'),(660,'Command: reload locales_gameobject'),(661,'Command: reload locales_gossip_menu_option'),(662,'Command: reload locales_item'),(663,'Command: reload locales_item_set_name'),(664,'Command: reload locales_npc_text'),(665,'Command: reload locales_page_text'),(666,'Command: reload locales_points_of_interest'),(667,'Command: reload locales_quest'),(668,'Command: reload mail_level_reward'),(669,'Command: reload mail_loot_template'),(670,'Command: reload milling_loot_template'),(671,'Command: reload npc_spellclick_spells'),(672,'Command: reload npc_trainer'),(673,'Command: reload npc_vendor'),(674,'Command: reload page_text'),(675,'Command: reload pickpocketing_loot_template'),(676,'Command: reload points_of_interest'),(677,'Command: reload prospecting_loot_template'),(678,'Command: reload quest_poi'),(679,'Command: reload quest_template'),(680,'Command: reload rbac'),(681,'Command: reload reference_loot_template'),(682,'Command: reload reserved_name'),(683,'Command: reload reputation_reward_rate'),(684,'Command: reload reputation_spillover_template'),(685,'Command: reload skill_discovery_template'),(686,'Command: reload skill_extra_item_template'),(687,'Command: reload skill_fishing_base_level'),(688,'Command: reload skinning_loot_template'),(689,'Command: reload smart_scripts'),(690,'Command: reload spell_required'),(691,'Command: reload spell_area'),(692,'Command: reload spell_bonus_data'),(693,'Command: reload spell_group'),(694,'Command: reload spell_learn_spell'),(695,'Command: reload spell_loot_template'),(696,'Command: reload spell_linked_spell'),(697,'Command: reload spell_pet_auras'),(698,'Command: reload spell_proc_event'),(699,'Command: reload spell_proc'),(700,'Command: reload spell_scripts'),(701,'Command: reload spell_target_position'),(702,'Command: reload spell_threats'),(703,'Command: reload spell_group_stack_rules'),(704,'Command: reload trinity_string'),(705,'Command: reload warden_action'),(706,'Command: reload waypoint_scripts'),(707,'Command: reload waypoint_data'),(708,'Command: reload vehicle_accessory'),(709,'Command: reload vehicle_template_accessory'),(710,'Command: reset'),(711,'Command: reset achievements'),(712,'Command: reset honor'),(713,'Command: reset level'),(714,'Command: reset spells'),(715,'Command: reset stats'),(716,'Command: reset talents'),(717,'Command: reset all'),(718,'Command: server'),(719,'Command: server corpses'),(720,'Command: server exit'),(721,'Command: server idlerestart'),(722,'Command: server idlerestart cancel'),(723,'Command: server idleshutdown'),(724,'Command: server idleshutdown cancel'),(725,'Command: server info'),(726,'Command: server plimit'),(727,'Command: server restart'),(728,'Command: server restart cancel'),(729,'Command: server set'),(730,'Command: server set closed'),(731,'Command: server set difftime'),(732,'Command: server set loglevel'),(733,'Command: server set motd'),(734,'Command: server shutdown'),(735,'Command: server shutdown cancel'),(736,'Command: server motd'),(737,'Command: tele'),(738,'Command: tele add'),(739,'Command: tele del'),(740,'Command: tele name'),(741,'Command: tele group'),(742,'Command: ticket'),(743,'Command: ticket assign'),(744,'Command: ticket close'),(745,'Command: ticket closedlist'),(746,'Command: ticket comment'),(747,'Command: ticket complete'),(748,'Command: ticket delete'),(749,'Command: ticket escalate'),(750,'Command: ticket escalatedlist'),(751,'Command: ticket list'),(752,'Command: ticket onlinelist'),(753,'Command: ticket reset'),(754,'Command: ticket response'),(755,'Command: ticket response append'),(756,'Command: ticket response appendln'),(757,'Command: ticket togglesystem'),(758,'Command: ticket unassign'),(759,'Command: ticket viewid'),(760,'Command: ticket viewname'),(761,'Command: titles'),(762,'Command: titles add'),(763,'Command: titles current'),(764,'Command: titles remove'),(765,'Command: titles set'),(766,'Command: titles set mask'),(767,'Command: wp'),(768,'Command: wp add'),(769,'Command: wp event'),(770,'Command: wp load'),(771,'Command: wp modify'),(772,'Command: wp unload'),(773,'Command: wp reload'),(774,'Command: wp show'); +INSERT INTO `rbac_permissions` VALUES (1,'Instant logout'),(2,'Skip Queue'),(3,'Join Normal Battleground'),(4,'Join Random Battleground'),(5,'Join Arenas'),(6,'Join Dungeon Finder'),(11,'Log GM trades'),(13,'Skip Instance required bosses check'),(14,'Skip character creation team mask check'),(15,'Skip character creation class mask check'),(16,'Skip character creation race mask check'),(17,'Skip character creation reserved name check'),(18,'Skip character creation heroic min level check'),(19,'Skip needed requirements to use channel check'),(20,'Skip disable map check'),(21,'Skip reset talents when used more than allowed check'),(22,'Skip spam chat check'),(23,'Skip over-speed ping check'),(24,'Two side faction characters on the same account'),(25,'Allow say chat between factions'),(26,'Allow channel chat between factions'),(27,'Two side mail interaction'),(28,'See two side who list'),(29,'Add friends of other faction'),(30,'Save character without delay with .save command'),(31,'Use params with .unstuck command'),(32,'Can be assigned tickets with .assign ticket command'),(33,'Notify if a command was not found'),(34,'Check if should appear in list using .gm ingame command'),(35,'See all security levels with who command'),(36,'Filter whispers'),(37,'Use staff badge in chat'),(38,'Resurrect with full Health Points'),(39,'Restore saved gm setting states'),(40,'Allows to add a gm to friend list'),(41,'Use Config option START_GM_LEVEL to assign new character level'),(42,'Allows to use CMSG_WORLD_TELEPORT opcode'),(43,'Allows to use CMSG_WHOIS opcode'),(44,'Receive global GM messages/texts'),(45,'Join channels without announce'),(46,'Change channel settings without being channel moderator'),(47,'Enables lower security than target check'),(48,'Enable IP, Last Login and EMail output in pinfo'),(49,'Forces to enter the email for confirmation on password change'),(50,'Allow user to check his own email with .account'),(192,'Role: Sec Level Administrator'),(193,'Role: Sec Level Gamemaster'),(194,'Role: Sec Level Moderator'),(195,'Role: Sec Level Player'),(196,'Role: Administrator Commands'),(197,'Role: Gamemaster Commands'),(198,'Role: Moderator Commands'),(199,'Role: Player Commands'),(200,'Command: rbac'),(201,'Command: rbac account'),(202,'Command: rbac account list'),(203,'Command: rbac account grant'),(204,'Command: rbac account deny'),(205,'Command: rbac account revoke'),(206,'Command: rbac list'),(217,'Command: account'),(218,'Command: account addon'),(219,'Command: account create'),(220,'Command: account delete'),(221,'Command: account lock'),(222,'Command: account lock country'),(223,'Command: account lock ip'),(224,'Command: account onlinelist'),(225,'Command: account password'),(226,'Command: account set'),(227,'Command: account set addon'),(228,'Command: account set gmlevel'),(229,'Command: account set password'),(230,'Command: achievement'),(231,'Command: achievement add'),(232,'Command: arena'),(233,'Command: arena captain'),(234,'Command: arena create'),(235,'Command: arena disband'),(236,'Command: arena info'),(237,'Command: arena lookup'),(238,'Command: arena rename'),(239,'Command: ban'),(240,'Command: ban account'),(241,'Command: ban character'),(242,'Command: ban ip'),(243,'Command: ban playeraccount'),(244,'Command: baninfo'),(245,'Command: baninfo account'),(246,'Command: baninfo character'),(247,'Command: baninfo ip'),(248,'Command: banlist'),(249,'Command: banlist account'),(250,'Command: banlist character'),(251,'Command: banlist ip'),(252,'Command: unban'),(253,'Command: unban account'),(254,'Command: unban character'),(255,'Command: unban ip'),(256,'Command: unban playeraccount'),(257,'Command: bf'),(258,'Command: bf start'),(259,'Command: bf stop'),(260,'Command: bf switch'),(261,'Command: bf timer'),(262,'Command: bf enable'),(263,'Command: account email'),(264,'Command: account set sec'),(265,'Command: account set sec email'),(266,'Command: account set sec regmail'),(267,'Command: cast'),(268,'Command: cast back'),(269,'Command: cast dist'),(270,'Command: cast self'),(271,'Command: cast target'),(272,'Command: cast dest'),(273,'Command: character'),(274,'Command: character customize'),(275,'Command: character changefaction'),(276,'Command: character changerace'),(277,'Command: character deleted'),(279,'Command: character deleted list'),(280,'Command: character deleted restore'),(283,'Command: character level'),(284,'Command: character rename'),(285,'Command: character reputation'),(286,'Command: character titles'),(287,'Command: levelup'),(288,'Command: pdump'),(289,'Command: pdump load'),(290,'Command: pdump write'),(291,'Command: cheat'),(292,'Command: cheat casttime'),(293,'Command: cheat cooldown'),(294,'Command: cheat explore'),(295,'Command: cheat god'),(296,'Command: cheat power'),(297,'Command: cheat status'),(298,'Command: cheat taxi'),(299,'Command: cheat waterwalk'),(300,'Command: debug'),(301,'Command: debug anim'),(302,'Command: debug areatriggers'),(303,'Command: debug arena'),(304,'Command: debug bg'),(305,'Command: debug entervehicle'),(306,'Command: debug getitemstate'),(307,'Command: debug getitemvalue'),(308,'Command: debug getvalue'),(309,'Command: debug hostil'),(310,'Command: debug itemexpire'),(311,'Command: debug lootrecipient'),(312,'Command: debug los'),(313,'Command: debug mod32value'),(314,'Command: debug moveflags'),(315,'Command: debug play'),(316,'Command: debug play cinematics'),(317,'Command: debug play movie'),(318,'Command: debug play sound'),(319,'Command: debug send'),(320,'Command: debug send buyerror'),(321,'Command: debug send channelnotify'),(322,'Command: debug send chatmessage'),(323,'Command: debug send equiperror'),(324,'Command: debug send largepacket'),(325,'Command: debug send opcode'),(326,'Command: debug send qinvalidmsg'),(327,'Command: debug send qpartymsg'),(328,'Command: debug send sellerror'),(329,'Command: debug send setphaseshift'),(330,'Command: debug send spellfail'),(331,'Command: debug setaurastate'),(332,'Command: debug setbit'),(333,'Command: debug setitemvalue'),(334,'Command: debug setvalue'),(335,'Command: debug setvid'),(336,'Command: debug spawnvehicle'),(337,'Command: debug threat'),(338,'Command: debug update'),(339,'Command: debug uws'),(340,'Command: wpgps'),(341,'Command: deserter'),(342,'Command: deserter bg'),(343,'Command: deserter bg add'),(344,'Command: deserter bg remove'),(345,'Command: deserter instance'),(346,'Command: deserter instance add'),(347,'Command: deserter instance remove'),(348,'Command: disable'),(349,'Command: disable add'),(350,'Command: disable add achievement_criteria'),(351,'Command: disable add battleground'),(352,'Command: disable add map'),(353,'Command: disable add mmap'),(354,'Command: disable add outdoorpvp'),(355,'Command: disable add quest'),(356,'Command: disable add spell'),(357,'Command: disable add vmap'),(358,'Command: disable remove'),(359,'Command: disable remove achievement_criteria'),(360,'Command: disable remove battleground'),(361,'Command: disable remove map'),(362,'Command: disable remove mmap'),(363,'Command: disable remove outdoorpvp'),(364,'Command: disable remove quest'),(365,'Command: disable remove spell'),(366,'Command: disable remove vmap'),(367,'Command: event'),(368,'Command: event activelist'),(369,'Command: event start'),(370,'Command: event stop'),(371,'Command: gm'),(372,'Command: gm chat'),(373,'Command: gm fly'),(374,'Command: gm ingame'),(375,'Command: gm list'),(376,'Command: gm visible'),(377,'Command: go'),(378,'Command: go creature'),(379,'Command: go graveyard'),(380,'Command: go grid'),(381,'Command: go object'),(382,'Command: go taxinode'),(383,'Command: go ticket'),(384,'Command: go trigger'),(385,'Command: go xyz'),(386,'Command: go zonexy'),(387,'Command: gobject'),(388,'Command: gobject activate'),(389,'Command: gobject add'),(390,'Command: gobject add temp'),(391,'Command: gobject delete'),(392,'Command: gobject info'),(393,'Command: gobject move'),(394,'Command: gobject near'),(395,'Command: gobject set'),(396,'Command: gobject set phase'),(397,'Command: gobject set state'),(398,'Command: gobject target'),(399,'Command: gobject turn'),(400,'debug transport'),(401,'Command: guild'),(402,'Command: guild create'),(403,'Command: guild delete'),(404,'Command: guild invite'),(405,'Command: guild uninvite'),(406,'Command: guild rank'),(407,'Command: guild rename'),(408,'Command: honor'),(409,'Command: honor add'),(410,'Command: honor add kill'),(411,'Command: honor update'),(412,'Command: instance'),(413,'Command: instance listbinds'),(414,'Command: instance unbind'),(415,'Command: instance stats'),(416,'Command: instance savedata'),(417,'Command: learn'),(418,'Command: learn all'),(419,'Command: learn all my'),(420,'Command: learn all my class'),(421,'Command: learn all my pettalents'),(422,'Command: learn all my spells'),(423,'Command: learn all my talents'),(424,'Command: learn all gm'),(425,'Command: learn all crafts'),(426,'Command: learn all default'),(427,'Command: learn all lang'),(428,'Command: learn all recipes'),(429,'Command: unlearn'),(430,'Command: lfg'),(431,'Command: lfg player'),(432,'Command: lfg group'),(433,'Command: lfg queue'),(434,'Command: lfg clean'),(435,'Command: lfg options'),(436,'Command: list'),(437,'Command: list creature'),(438,'Command: list item'),(439,'Command: list object'),(440,'Command: list auras'),(441,'Command: list mail'),(442,'Command: lookup'),(443,'Command: lookup area'),(444,'Command: lookup creature'),(445,'Command: lookup event'),(446,'Command: lookup faction'),(447,'Command: lookup item'),(448,'Command: lookup itemset'),(449,'Command: lookup object'),(450,'Command: lookup quest'),(451,'Command: lookup player'),(452,'Command: lookup player ip'),(453,'Command: lookup player account'),(454,'Command: lookup player email'),(455,'Command: lookup skill'),(456,'Command: lookup spell'),(457,'Command: lookup spell id'),(458,'Command: lookup taxinode'),(459,'Command: lookup tele'),(460,'Command: lookup title'),(461,'Command: lookup map'),(462,'Command: announce'),(463,'Command: channel'),(464,'Command: channel set'),(465,'Command: channel set ownership'),(466,'Command: gmannounce'),(467,'Command: gmnameannounce'),(468,'Command: gmnotify'),(469,'Command: nameannounce'),(470,'Command: notify'),(471,'Command: whispers'),(472,'Command: group'),(473,'Command: group leader'),(474,'Command: group disband'),(475,'Command: group remove'),(476,'Command: group join'),(477,'Command: group list'),(478,'Command: group summon'),(479,'Command: pet'),(480,'Command: pet create'),(481,'Command: pet learn'),(482,'Command: pet unlearn'),(483,'Command: send'),(484,'Command: send items'),(485,'Command: send mail'),(486,'Command: send message'),(487,'Command: send money'),(488,'Command: additem'),(489,'Command: additemset'),(490,'Command: appear'),(491,'Command: aura'),(492,'Command: bank'),(493,'Command: bindsight'),(494,'Command: combatstop'),(495,'Command: cometome'),(496,'Command: commands'),(497,'Command: cooldown'),(498,'Command: damage'),(499,'Command: dev'),(500,'Command: die'),(501,'Command: dismount'),(502,'Command: distance'),(503,'Command: flusharenapoints'),(504,'Command: freeze'),(505,'Command: gps'),(506,'Command: guid'),(507,'Command: help'),(508,'Command: hidearea'),(509,'Command: itemmove'),(510,'Command: kick'),(511,'Command: linkgrave'),(512,'Command: listfreeze'),(513,'Command: maxskill'),(514,'Command: movegens'),(515,'Command: mute'),(516,'Command: neargrave'),(517,'Command: pinfo'),(518,'Command: playall'),(519,'Command: possess'),(520,'Command: recall'),(521,'Command: repairitems'),(522,'Command: respawn'),(523,'Command: revive'),(524,'Command: saveall'),(525,'Command: save'),(526,'Command: setskill'),(527,'Command: showarea'),(528,'Command: summon'),(529,'Command: unaura'),(530,'Command: unbindsight'),(531,'Command: unfreeze'),(532,'Command: unmute'),(533,'Command: unpossess'),(534,'Command: unstuck'),(535,'Command: wchange'),(536,'Command: mmap'),(537,'Command: mmap loadedtiles'),(538,'Command: mmap loc'),(539,'Command: mmap path'),(540,'Command: mmap stats'),(541,'Command: mmap testarea'),(542,'Command: morph'),(543,'Command: demorph'),(544,'Command: modify'),(545,'Command: modify arenapoints'),(546,'Command: modify bit'),(547,'Command: modify drunk'),(548,'Command: modify energy'),(549,'Command: modify faction'),(550,'Command: modify gender'),(551,'Command: modify honor'),(552,'Command: modify hp'),(553,'Command: modify mana'),(554,'Command: modify money'),(555,'Command: modify mount'),(556,'Command: modify phase'),(557,'Command: modify rage'),(558,'Command: modify reputation'),(559,'Command: modify runicpower'),(560,'Command: modify scale'),(561,'Command: modify speed'),(562,'Command: modify speed all'),(563,'Command: modify speed backwalk'),(564,'Command: modify speed fly'),(565,'Command: modify speed walk'),(566,'Command: modify speed swim'),(567,'Command: modify spell'),(568,'Command: modify standstate'),(569,'Command: modify talentpoints'),(570,'Command: npc'),(571,'Command: npc add'),(572,'Command: npc add formation'),(573,'Command: npc add item'),(574,'Command: npc add move'),(575,'Command: npc add temp'),(576,'Command: npc add delete'),(577,'Command: npc add delete item'),(578,'Command: npc add follow'),(579,'Command: npc add follow stop'),(580,'Command: npc set'),(581,'Command: npc set allowmove'),(582,'Command: npc set entry'),(583,'Command: npc set factionid'),(584,'Command: npc set flag'),(585,'Command: npc set level'),(586,'Command: npc set link'),(587,'Command: npc set model'),(588,'Command: npc set movetype'),(589,'Command: npc set phase'),(590,'Command: npc set spawndist'),(591,'Command: npc set spawntime'),(592,'Command: npc set data'),(593,'Command: npc info'),(594,'Command: npc near'),(595,'Command: npc move'),(596,'Command: npc playemote'),(597,'Command: npc say'),(598,'Command: npc textemote'),(599,'Command: npc whisper'),(600,'Command: npc yell'),(601,'Command: npc tame'),(602,'Command: quest'),(603,'Command: quest add'),(604,'Command: quest complete'),(605,'Command: quest remove'),(606,'Command: quest reward'),(607,'Command: reload'),(608,'Command: reload access_requirement'),(609,'Command: reload achievement_criteria_data'),(610,'Command: reload achievement_reward'),(611,'Command: reload all'),(612,'Command: reload all achievement'),(613,'Command: reload all area'),(614,'Command: broadcast_text'),(615,'Command: reload all gossips'),(616,'Command: reload all item'),(617,'Command: reload all locales'),(618,'Command: reload all loot'),(619,'Command: reload all npc'),(620,'Command: reload all quest'),(621,'Command: reload all scripts'),(622,'Command: reload all spell'),(623,'Command: reload areatrigger_involvedrelation'),(624,'Command: reload areatrigger_tavern'),(625,'Command: reload areatrigger_teleport'),(626,'Command: reload auctions'),(627,'Command: reload autobroadcast'),(628,'Command: reload command'),(629,'Command: reload conditions'),(630,'Command: reload config'),(631,'Command: reload battleground_template'),(633,'Command: reload creature_linked_respawn'),(634,'Command: reload creature_loot_template'),(635,'Command: reload creature_onkill_reputation'),(636,'Command: reload creature_questender'),(637,'Command: reload creature_queststarter'),(638,'Command: reload creature_summon_groups'),(639,'Command: reload creature_template'),(640,'Command: reload creature_text'),(641,'Command: reload disables'),(642,'Command: reload disenchant_loot_template'),(643,'Command: reload event_scripts'),(644,'Command: reload fishing_loot_template'),(645,'Command: reload game_graveyard_zone'),(646,'Command: reload game_tele'),(647,'Command: reload gameobject_questender'),(648,'Command: reload gameobject_loot_template'),(649,'Command: reload gameobject_queststarter'),(650,'Command: reload gm_tickets'),(651,'Command: reload gossip_menu'),(652,'Command: reload gossip_menu_option'),(653,'Command: reload item_enchantment_template'),(654,'Command: reload item_loot_template'),(655,'Command: reload item_set_names'),(656,'Command: reload lfg_dungeon_rewards'),(657,'Command: reload locales_achievement_reward'),(658,'Command: reload locales_creature'),(659,'Command: reload locales_creature_text'),(660,'Command: reload locales_gameobject'),(661,'Command: reload locales_gossip_menu_option'),(662,'Command: reload locales_item'),(663,'Command: reload locales_item_set_name'),(664,'Command: reload locales_npc_text'),(665,'Command: reload locales_page_text'),(666,'Command: reload locales_points_of_interest'),(667,'Command: reload locales_quest'),(668,'Command: reload mail_level_reward'),(669,'Command: reload mail_loot_template'),(670,'Command: reload milling_loot_template'),(671,'Command: reload npc_spellclick_spells'),(672,'Command: reload npc_trainer'),(673,'Command: reload npc_vendor'),(674,'Command: reload page_text'),(675,'Command: reload pickpocketing_loot_template'),(676,'Command: reload points_of_interest'),(677,'Command: reload prospecting_loot_template'),(678,'Command: reload quest_poi'),(679,'Command: reload quest_template'),(680,'Command: reload rbac'),(681,'Command: reload reference_loot_template'),(682,'Command: reload reserved_name'),(683,'Command: reload reputation_reward_rate'),(684,'Command: reload reputation_spillover_template'),(685,'Command: reload skill_discovery_template'),(686,'Command: reload skill_extra_item_template'),(687,'Command: reload skill_fishing_base_level'),(688,'Command: reload skinning_loot_template'),(689,'Command: reload smart_scripts'),(690,'Command: reload spell_required'),(691,'Command: reload spell_area'),(692,'Command: reload spell_bonus_data'),(693,'Command: reload spell_group'),(694,'Command: reload spell_learn_spell'),(695,'Command: reload spell_loot_template'),(696,'Command: reload spell_linked_spell'),(697,'Command: reload spell_pet_auras'),(698,'Command: reload spell_proc_event'),(699,'Command: reload spell_proc'),(700,'Command: reload spell_scripts'),(701,'Command: reload spell_target_position'),(702,'Command: reload spell_threats'),(703,'Command: reload spell_group_stack_rules'),(704,'Command: reload trinity_string'),(705,'Command: reload warden_action'),(706,'Command: reload waypoint_scripts'),(707,'Command: reload waypoint_data'),(708,'Command: reload vehicle_accessory'),(709,'Command: reload vehicle_template_accessory'),(710,'Command: reset'),(711,'Command: reset achievements'),(712,'Command: reset honor'),(713,'Command: reset level'),(714,'Command: reset spells'),(715,'Command: reset stats'),(716,'Command: reset talents'),(717,'Command: reset all'),(718,'Command: server'),(719,'Command: server corpses'),(720,'Command: server exit'),(721,'Command: server idlerestart'),(722,'Command: server idlerestart cancel'),(723,'Command: server idleshutdown'),(724,'Command: server idleshutdown cancel'),(725,'Command: server info'),(726,'Command: server plimit'),(727,'Command: server restart'),(728,'Command: server restart cancel'),(729,'Command: server set'),(730,'Command: server set closed'),(731,'Command: server set difftime'),(732,'Command: server set loglevel'),(733,'Command: server set motd'),(734,'Command: server shutdown'),(735,'Command: server shutdown cancel'),(736,'Command: server motd'),(737,'Command: tele'),(738,'Command: tele add'),(739,'Command: tele del'),(740,'Command: tele name'),(741,'Command: tele group'),(742,'Command: ticket'),(743,'Command: ticket assign'),(744,'Command: ticket close'),(745,'Command: ticket closedlist'),(746,'Command: ticket comment'),(747,'Command: ticket complete'),(748,'Command: ticket delete'),(749,'Command: ticket escalate'),(750,'Command: ticket escalatedlist'),(751,'Command: ticket list'),(752,'Command: ticket onlinelist'),(753,'Command: ticket reset'),(754,'Command: ticket response'),(755,'Command: ticket response append'),(756,'Command: ticket response appendln'),(757,'Command: ticket togglesystem'),(758,'Command: ticket unassign'),(759,'Command: ticket viewid'),(760,'Command: ticket viewname'),(761,'Command: titles'),(762,'Command: titles add'),(763,'Command: titles current'),(764,'Command: titles remove'),(765,'Command: titles set'),(766,'Command: titles set mask'),(767,'Command: wp'),(768,'Command: wp add'),(769,'Command: wp event'),(770,'Command: wp load'),(771,'Command: wp modify'),(772,'Command: wp unload'),(773,'Command: wp reload'),(774,'Command: wp show'),(777,'Command: mailbox'); /*!40000 ALTER TABLE `rbac_permissions` ENABLE KEYS */; UNLOCK TABLES; @@ -440,4 +471,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2013-09-10 23:18:53 +-- Dump completed on 2014-07-08 11:39:12 diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index f414424cfd3..c7e1372e9a1 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -221,12 +221,12 @@ DROP TABLE IF EXISTS `banned_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banned_addons` ( - `Id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, + `Id` int(10) unsigned NOT NULL AUTO_INCREMENT, `Name` varchar(255) NOT NULL, `Version` varchar(255) NOT NULL DEFAULT '', `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Id`), - UNIQUE KEY `idx_name_ver` (`Name`, `Version`) + UNIQUE KEY `idx_name_ver` (`Name`,`Version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1632,6 +1632,7 @@ CREATE TABLE `groups` ( `groupType` tinyint(3) unsigned NOT NULL, `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', `raiddifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', + `masterLooterGuid` int(10) unsigned NOT NULL, PRIMARY KEY (`guid`), KEY `leaderGuid` (`leaderGuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups'; @@ -1662,7 +1663,7 @@ CREATE TABLE `guild` ( `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0', `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0', - `info` text NOT NULL, + `info` varchar(500) NOT NULL DEFAULT '', `motd` varchar(128) NOT NULL DEFAULT '', `createdate` int(10) unsigned NOT NULL DEFAULT '0', `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0', @@ -2456,4 +2457,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2013-02-04 16:22:06 +-- Dump completed on 2014-01-26 14:39:20 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql new file mode 100644 index 00000000000..633b59e0556 --- /dev/null +++ b/sql/base/dev/world_database.sql @@ -0,0 +1,3662 @@ +-- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) +-- +-- Host: localhost Database: world +-- ------------------------------------------------------ +-- Server version 5.6.9-rc + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `access_requirement` +-- + +DROP TABLE IF EXISTS `access_requirement`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `access_requirement` ( + `mapId` mediumint(8) unsigned NOT NULL, + `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', + `level_min` tinyint(3) unsigned NOT NULL DEFAULT '0', + `level_max` tinyint(3) unsigned NOT NULL DEFAULT '0', + `item_level` smallint(5) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0', + `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_failed_text` text, + `comment` text, + PRIMARY KEY (`mapId`,`difficulty`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `achievement_criteria_data` +-- + +DROP TABLE IF EXISTS `achievement_criteria_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_criteria_data` ( + `criteria_id` mediumint(8) NOT NULL, + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `value1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `value2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ScriptName` char(64) NOT NULL DEFAULT '', + PRIMARY KEY (`criteria_id`,`type`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `achievement_dbc` +-- + +DROP TABLE IF EXISTS `achievement_dbc`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_dbc` ( + `ID` int(10) unsigned NOT NULL, + `requiredFaction` int(11) NOT NULL DEFAULT '-1', + `mapID` int(11) NOT NULL DEFAULT '-1', + `points` int(10) unsigned NOT NULL DEFAULT '0', + `flags` int(10) unsigned NOT NULL DEFAULT '0', + `count` int(10) unsigned NOT NULL DEFAULT '0', + `refAchievement` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `achievement_reward` +-- + +DROP TABLE IF EXISTS `achievement_reward`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_reward` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `title_A` mediumint(8) unsigned NOT NULL DEFAULT '0', + `title_H` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `sender` mediumint(8) unsigned NOT NULL DEFAULT '0', + `subject` varchar(255) DEFAULT NULL, + `text` text, + `mailTemplate` mediumint(8) unsigned DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `areatrigger_involvedrelation` +-- + +DROP TABLE IF EXISTS `areatrigger_involvedrelation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `areatrigger_involvedrelation` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `areatrigger_scripts` +-- + +DROP TABLE IF EXISTS `areatrigger_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `areatrigger_scripts` ( + `entry` mediumint(8) NOT NULL, + `ScriptName` char(64) NOT NULL, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `areatrigger_tavern` +-- + +DROP TABLE IF EXISTS `areatrigger_tavern`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `areatrigger_tavern` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `name` text, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `areatrigger_teleport` +-- + +DROP TABLE IF EXISTS `areatrigger_teleport`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `areatrigger_teleport` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `name` text, + `target_map` smallint(5) unsigned NOT NULL DEFAULT '0', + `target_position_x` float NOT NULL DEFAULT '0', + `target_position_y` float NOT NULL DEFAULT '0', + `target_position_z` float NOT NULL DEFAULT '0', + `target_orientation` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`id`), + FULLTEXT KEY `name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `battleground_template` +-- + +DROP TABLE IF EXISTS `battleground_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `battleground_template` ( + `id` mediumint(8) unsigned NOT NULL, + `MinPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0', + `MaxPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0', + `MinLvl` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxLvl` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AllianceStartLoc` mediumint(8) unsigned NOT NULL, + `AllianceStartO` float NOT NULL, + `HordeStartLoc` mediumint(8) unsigned NOT NULL, + `HordeStartO` float NOT NULL, + `StartMaxDist` float NOT NULL DEFAULT '0', + `Weight` tinyint(3) unsigned NOT NULL DEFAULT '1', + `ScriptName` char(64) NOT NULL DEFAULT '', + `Comment` char(32) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `battlemaster_entry` +-- + +DROP TABLE IF EXISTS `battlemaster_entry`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `battlemaster_entry` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature', + `bg_template` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `broadcast_text` +-- + +DROP TABLE IF EXISTS `broadcast_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `broadcast_text` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Language` mediumint(8) unsigned NOT NULL DEFAULT '0', + `MaleText` longtext, + `FemaleText` longtext, + `EmoteID0` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteID1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteID2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteDelay0` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteDelay1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `EmoteDelay2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `SoundId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Unk1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Unk2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `command` +-- + +DROP TABLE IF EXISTS `command`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `command` ( + `name` varchar(50) NOT NULL DEFAULT '', + `permission` smallint(5) unsigned NOT NULL DEFAULT '0', + `help` longtext, + PRIMARY KEY (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `conditions` +-- + +DROP TABLE IF EXISTS `conditions`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `conditions` ( + `SourceTypeOrReferenceId` mediumint(8) NOT NULL DEFAULT '0', + `SourceGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', + `SourceEntry` mediumint(8) NOT NULL DEFAULT '0', + `SourceId` int(11) NOT NULL DEFAULT '0', + `ElseGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionTypeOrReference` mediumint(8) NOT NULL DEFAULT '0', + `ConditionTarget` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ConditionValue1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionValue2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ConditionValue3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `NegativeCondition` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ErrorType` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ErrorTextId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ScriptName` char(64) NOT NULL DEFAULT '', + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Condition System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature` +-- + +DROP TABLE IF EXISTS `creature`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature` ( + `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', + `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1', + `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', + `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `equipment_id` tinyint(3) NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120', + `spawndist` float NOT NULL DEFAULT '0', + `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0', + `curhealth` int(10) unsigned NOT NULL DEFAULT '1', + `curmana` int(10) unsigned NOT NULL DEFAULT '0', + `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', + `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`guid`), + KEY `idx_map` (`map`), + KEY `idx_id` (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_addon` +-- + +DROP TABLE IF EXISTS `creature_addon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_addon` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0', + `path_id` int(10) unsigned NOT NULL DEFAULT '0', + `mount` mediumint(8) unsigned NOT NULL DEFAULT '0', + `bytes1` int(10) unsigned NOT NULL DEFAULT '0', + `bytes2` int(10) unsigned NOT NULL DEFAULT '0', + `emote` int(10) unsigned NOT NULL DEFAULT '0', + `auras` text, + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_classlevelstats` +-- + +DROP TABLE IF EXISTS `creature_classlevelstats`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_classlevelstats` ( + `level` tinyint(3) unsigned NOT NULL, + `class` tinyint(3) unsigned NOT NULL, + `basehp0` smallint(5) unsigned NOT NULL DEFAULT '1', + `basehp1` smallint(5) unsigned NOT NULL DEFAULT '1', + `basehp2` smallint(5) unsigned NOT NULL DEFAULT '1', + `basemana` smallint(5) unsigned NOT NULL DEFAULT '0', + `basearmor` smallint(5) unsigned NOT NULL DEFAULT '1', + `attackpower` smallint(5) unsigned NOT NULL DEFAULT '0', + `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0', + `damage_base` float NOT NULL DEFAULT '0', + `damage_exp1` float NOT NULL DEFAULT '0', + `damage_exp2` float NOT NULL DEFAULT '0', + `comment` text, + PRIMARY KEY (`level`,`class`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_equip_template` +-- + +DROP TABLE IF EXISTS `creature_equip_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_equip_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `id` tinyint(3) unsigned NOT NULL DEFAULT '0', + `itemEntry1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `itemEntry2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `itemEntry3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_formations` +-- + +DROP TABLE IF EXISTS `creature_formations`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_formations` ( + `leaderGUID` int(10) unsigned NOT NULL, + `memberGUID` int(10) unsigned NOT NULL, + `dist` float unsigned NOT NULL, + `angle` float unsigned NOT NULL, + `groupAI` int(10) unsigned NOT NULL, + `point_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `point_2` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`memberGUID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_loot_template` +-- + +DROP TABLE IF EXISTS `creature_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_model_info` +-- + +DROP TABLE IF EXISTS `creature_model_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_model_info` ( + `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `bounding_radius` float NOT NULL DEFAULT '0', + `combat_reach` float NOT NULL DEFAULT '0', + `gender` tinyint(3) unsigned NOT NULL DEFAULT '2', + `modelid_other_gender` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`modelid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Model related info)'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_onkill_reputation` +-- + +DROP TABLE IF EXISTS `creature_onkill_reputation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_onkill_reputation` ( + `creature_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', + `RewOnKillRepFaction1` smallint(6) NOT NULL DEFAULT '0', + `RewOnKillRepFaction2` smallint(6) NOT NULL DEFAULT '0', + `MaxStanding1` tinyint(4) NOT NULL DEFAULT '0', + `IsTeamAward1` tinyint(4) NOT NULL DEFAULT '0', + `RewOnKillRepValue1` mediumint(8) NOT NULL DEFAULT '0', + `MaxStanding2` tinyint(4) NOT NULL DEFAULT '0', + `IsTeamAward2` tinyint(4) NOT NULL DEFAULT '0', + `RewOnKillRepValue2` mediumint(9) NOT NULL DEFAULT '0', + `TeamDependent` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`creature_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_questender` +-- + +DROP TABLE IF EXISTS `creature_questender`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_questender` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`id`,`quest`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_queststarter` +-- + +DROP TABLE IF EXISTS `creature_queststarter`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_queststarter` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`id`,`quest`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_summon_groups` +-- + +DROP TABLE IF EXISTS `creature_summon_groups`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_summon_groups` ( + `summonerId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `summonerType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `summonType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `summonTime` int(10) unsigned NOT NULL DEFAULT '0' +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_template` +-- + +DROP TABLE IF EXISTS `creature_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `difficulty_entry_1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `difficulty_entry_2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `difficulty_entry_3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `KillCredit1` int(10) unsigned NOT NULL DEFAULT '0', + `KillCredit2` int(10) unsigned NOT NULL DEFAULT '0', + `modelid1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `modelid2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `modelid3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `modelid4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name` char(100) NOT NULL DEFAULT '0', + `subname` char(100) DEFAULT NULL, + `IconName` char(100) DEFAULT NULL, + `gossip_menu_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `minlevel` tinyint(3) unsigned NOT NULL DEFAULT '1', + `maxlevel` tinyint(3) unsigned NOT NULL DEFAULT '1', + `exp` smallint(6) NOT NULL DEFAULT '0', + `faction` smallint(5) unsigned NOT NULL DEFAULT '0', + `npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `speed_walk` float NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value', + `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value', + `scale` float NOT NULL DEFAULT '1', + `rank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mindmg` float NOT NULL DEFAULT '0', + `maxdmg` float NOT NULL DEFAULT '0', + `dmgschool` tinyint(4) NOT NULL DEFAULT '0', + `attackpower` int(10) unsigned NOT NULL DEFAULT '0', + `dmg_multiplier` float NOT NULL DEFAULT '1', + `baseattacktime` int(10) unsigned NOT NULL DEFAULT '0', + `rangeattacktime` int(10) unsigned NOT NULL DEFAULT '0', + `unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', + `unit_flags2` int(10) unsigned NOT NULL DEFAULT '0', + `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0', + `family` tinyint(4) NOT NULL DEFAULT '0', + `trainer_type` tinyint(4) NOT NULL DEFAULT '0', + `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0', + `minrangedmg` float NOT NULL DEFAULT '0', + `maxrangedmg` float NOT NULL DEFAULT '0', + `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0', + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `type_flags` int(10) unsigned NOT NULL DEFAULT '0', + `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `pickpocketloot` mediumint(8) unsigned NOT NULL DEFAULT '0', + `skinloot` mediumint(8) unsigned NOT NULL DEFAULT '0', + `resistance1` smallint(6) NOT NULL DEFAULT '0', + `resistance2` smallint(6) NOT NULL DEFAULT '0', + `resistance3` smallint(6) NOT NULL DEFAULT '0', + `resistance4` smallint(6) NOT NULL DEFAULT '0', + `resistance5` smallint(6) NOT NULL DEFAULT '0', + `resistance6` smallint(6) NOT NULL DEFAULT '0', + `spell1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell5` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell6` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell7` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell8` mediumint(8) unsigned NOT NULL DEFAULT '0', + `PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0', + `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0', + `AIName` char(64) NOT NULL DEFAULT '', + `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3', + `HoverHeight` float NOT NULL DEFAULT '1', + `Health_mod` float NOT NULL DEFAULT '1', + `Mana_mod` float NOT NULL DEFAULT '1', + `Armor_mod` float NOT NULL DEFAULT '1', + `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0', + `questItem1` int(10) unsigned NOT NULL DEFAULT '0', + `questItem2` int(10) unsigned NOT NULL DEFAULT '0', + `questItem3` int(10) unsigned NOT NULL DEFAULT '0', + `questItem4` int(10) unsigned NOT NULL DEFAULT '0', + `questItem5` int(10) unsigned NOT NULL DEFAULT '0', + `questItem6` int(10) unsigned NOT NULL DEFAULT '0', + `movementId` int(11) unsigned NOT NULL DEFAULT '0', + `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1', + `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0', + `flags_extra` int(10) unsigned NOT NULL DEFAULT '0', + `ScriptName` char(64) NOT NULL DEFAULT '', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`), + KEY `idx_name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_template_addon` +-- + +DROP TABLE IF EXISTS `creature_template_addon`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_template_addon` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `path_id` int(10) unsigned NOT NULL DEFAULT '0', + `mount` mediumint(8) unsigned NOT NULL DEFAULT '0', + `bytes1` int(10) unsigned NOT NULL DEFAULT '0', + `bytes2` int(10) unsigned NOT NULL DEFAULT '0', + `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', + `auras` text, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_text` +-- + +DROP TABLE IF EXISTS `creature_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_text` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `id` tinyint(3) unsigned NOT NULL DEFAULT '0', + `text` longtext, + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `language` tinyint(3) unsigned NOT NULL DEFAULT '0', + `probability` float NOT NULL DEFAULT '0', + `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', + `duration` mediumint(8) unsigned NOT NULL DEFAULT '0', + `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT '', + `BroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`,`groupid`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `db_script_string` +-- + +DROP TABLE IF EXISTS `db_script_string`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `db_script_string` ( + `entry` int(10) unsigned NOT NULL DEFAULT '0', + `content_default` text NOT NULL, + `content_loc1` text, + `content_loc2` text, + `content_loc3` text, + `content_loc4` text, + `content_loc5` text, + `content_loc6` text, + `content_loc7` text, + `content_loc8` text, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `disables` +-- + +DROP TABLE IF EXISTS `disables`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `disables` ( + `sourceType` int(10) unsigned NOT NULL, + `entry` int(10) unsigned NOT NULL, + `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `params_0` varchar(255) NOT NULL DEFAULT '', + `params_1` varchar(255) NOT NULL DEFAULT '', + `comment` varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (`sourceType`,`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `disenchant_loot_template` +-- + +DROP TABLE IF EXISTS `disenchant_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `disenchant_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Recommended id selection: item_level*100 + item_quality', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(9) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `event_scripts` +-- + +DROP TABLE IF EXISTS `event_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `event_scripts` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `delay` int(10) unsigned NOT NULL DEFAULT '0', + `command` mediumint(8) unsigned NOT NULL DEFAULT '0', + `datalong` mediumint(8) unsigned NOT NULL DEFAULT '0', + `datalong2` int(10) unsigned NOT NULL DEFAULT '0', + `dataint` int(11) NOT NULL DEFAULT '0', + `x` float NOT NULL DEFAULT '0', + `y` float NOT NULL DEFAULT '0', + `z` float NOT NULL DEFAULT '0', + `o` float NOT NULL DEFAULT '0' +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `exploration_basexp` +-- + +DROP TABLE IF EXISTS `exploration_basexp`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `exploration_basexp` ( + `level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `basexp` mediumint(8) NOT NULL DEFAULT '0', + PRIMARY KEY (`level`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `fishing_loot_template` +-- + +DROP TABLE IF EXISTS `fishing_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `fishing_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event` +-- + +DROP TABLE IF EXISTS `game_event`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before', + `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler', + `occurence` bigint(20) unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event', + `length` bigint(20) unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event', + `holiday` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', + `description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console', + `world_event` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event', + `announce` tinyint(3) unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', + PRIMARY KEY (`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_arena_seasons` +-- + +DROP TABLE IF EXISTS `game_event_arena_seasons`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_arena_seasons` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `season` tinyint(3) unsigned NOT NULL COMMENT 'Arena season number', + UNIQUE KEY `season` (`season`,`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_battleground_holiday` +-- + +DROP TABLE IF EXISTS `game_event_battleground_holiday`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_battleground_holiday` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `bgflag` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_condition` +-- + +DROP TABLE IF EXISTS `game_event_condition`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_condition` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `condition_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `req_num` float DEFAULT '0', + `max_world_state_field` smallint(5) unsigned NOT NULL DEFAULT '0', + `done_world_state_field` smallint(5) unsigned NOT NULL DEFAULT '0', + `description` varchar(25) NOT NULL DEFAULT '', + PRIMARY KEY (`eventEntry`,`condition_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_creature` +-- + +DROP TABLE IF EXISTS `game_event_creature`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_creature` ( + `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', + `guid` int(10) unsigned NOT NULL, + PRIMARY KEY (`guid`,`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_creature_quest` +-- + +DROP TABLE IF EXISTS `game_event_creature_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_creature_quest` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event.', + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`quest`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_gameobject` +-- + +DROP TABLE IF EXISTS `game_event_gameobject`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_gameobject` ( + `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', + `guid` int(10) unsigned NOT NULL, + PRIMARY KEY (`guid`,`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_gameobject_quest` +-- + +DROP TABLE IF EXISTS `game_event_gameobject_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_gameobject_quest` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`quest`,`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_model_equip` +-- + +DROP TABLE IF EXISTS `game_event_model_equip`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_model_equip` ( + `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event.', + `guid` int(10) unsigned NOT NULL DEFAULT '0', + `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `equipment_id` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_npc_vendor` +-- + +DROP TABLE IF EXISTS `game_event_npc_vendor`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_npc_vendor` ( + `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event.', + `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `slot` smallint(6) NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0', + `incrtime` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`item`), + KEY `slot` (`slot`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_npcflag` +-- + +DROP TABLE IF EXISTS `game_event_npcflag`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_npcflag` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `npcflag` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`eventEntry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_pool` +-- + +DROP TABLE IF EXISTS `game_event_pool`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_pool` ( + `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', + `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool', + PRIMARY KEY (`pool_entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_prerequisite` +-- + +DROP TABLE IF EXISTS `game_event_prerequisite`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_prerequisite` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', + `prerequisite_event` mediumint(8) unsigned NOT NULL, + PRIMARY KEY (`eventEntry`,`prerequisite_event`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_quest_condition` +-- + +DROP TABLE IF EXISTS `game_event_quest_condition`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_quest_condition` ( + `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event.', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0', + `condition_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `num` float DEFAULT '0', + PRIMARY KEY (`quest`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_event_seasonal_questrelation` +-- + +DROP TABLE IF EXISTS `game_event_seasonal_questrelation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_event_seasonal_questrelation` ( + `questId` int(10) unsigned NOT NULL COMMENT 'Quest Identifier', + `eventEntry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event', + PRIMARY KEY (`questId`,`eventEntry`), + KEY `idx_quest` (`questId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Player System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_graveyard_zone` +-- + +DROP TABLE IF EXISTS `game_graveyard_zone`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_graveyard_zone` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ghost_zone` mediumint(8) unsigned NOT NULL DEFAULT '0', + `faction` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`ghost_zone`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_tele` +-- + +DROP TABLE IF EXISTS `game_tele`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_tele` ( + `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `map` smallint(5) unsigned NOT NULL DEFAULT '0', + `name` varchar(100) NOT NULL DEFAULT '', + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=1424 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `game_weather` +-- + +DROP TABLE IF EXISTS `game_weather`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `game_weather` ( + `zone` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spring_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `spring_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `spring_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `summer_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `summer_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `summer_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `fall_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `fall_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `fall_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `winter_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `winter_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `winter_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', + `ScriptName` char(64) NOT NULL DEFAULT '', + PRIMARY KEY (`zone`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gameobject` +-- + +DROP TABLE IF EXISTS `gameobject`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject` ( + `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier', + `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', + `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1', + `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `rotation0` float NOT NULL DEFAULT '0', + `rotation1` float NOT NULL DEFAULT '0', + `rotation2` float NOT NULL DEFAULT '0', + `rotation3` float NOT NULL DEFAULT '0', + `spawntimesecs` int(11) NOT NULL DEFAULT '0', + `animprogress` tinyint(3) unsigned NOT NULL DEFAULT '0', + `state` tinyint(3) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM AUTO_INCREMENT=255094 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gameobject_loot_template` +-- + +DROP TABLE IF EXISTS `gameobject_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gameobject_questender` +-- + +DROP TABLE IF EXISTS `gameobject_questender`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_questender` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`id`,`quest`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gameobject_queststarter` +-- + +DROP TABLE IF EXISTS `gameobject_queststarter`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_queststarter` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + PRIMARY KEY (`id`,`quest`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gameobject_template` +-- + +DROP TABLE IF EXISTS `gameobject_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gameobject_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `displayId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name` varchar(100) NOT NULL DEFAULT '', + `IconName` varchar(100) NOT NULL DEFAULT '', + `castBarCaption` varchar(100) NOT NULL DEFAULT '', + `unk1` varchar(100) NOT NULL DEFAULT '', + `faction` smallint(5) unsigned NOT NULL DEFAULT '0', + `flags` int(10) unsigned NOT NULL DEFAULT '0', + `size` float NOT NULL DEFAULT '1', + `questItem1` int(11) unsigned NOT NULL DEFAULT '0', + `questItem2` int(11) unsigned NOT NULL DEFAULT '0', + `questItem3` int(11) unsigned NOT NULL DEFAULT '0', + `questItem4` int(11) unsigned NOT NULL DEFAULT '0', + `questItem5` int(11) unsigned NOT NULL DEFAULT '0', + `questItem6` int(11) unsigned NOT NULL DEFAULT '0', + `data0` int(10) unsigned NOT NULL DEFAULT '0', + `data1` int(11) NOT NULL DEFAULT '-1', + `data2` int(10) unsigned NOT NULL DEFAULT '0', + `data3` int(10) unsigned NOT NULL DEFAULT '0', + `data4` int(10) unsigned NOT NULL DEFAULT '0', + `data5` int(10) unsigned NOT NULL DEFAULT '0', + `data6` int(11) NOT NULL DEFAULT '-1', + `data7` int(10) unsigned NOT NULL DEFAULT '0', + `data8` int(10) unsigned NOT NULL DEFAULT '0', + `data9` int(10) unsigned NOT NULL DEFAULT '0', + `data10` int(10) unsigned NOT NULL DEFAULT '0', + `data11` int(10) unsigned NOT NULL DEFAULT '0', + `data12` int(10) unsigned NOT NULL DEFAULT '0', + `data13` int(10) unsigned NOT NULL DEFAULT '0', + `data14` int(10) unsigned NOT NULL DEFAULT '0', + `data15` int(10) unsigned NOT NULL DEFAULT '0', + `data16` int(10) unsigned NOT NULL DEFAULT '0', + `data17` int(10) unsigned NOT NULL DEFAULT '0', + `data18` int(10) unsigned NOT NULL DEFAULT '0', + `data19` int(10) unsigned NOT NULL DEFAULT '0', + `data20` int(10) unsigned NOT NULL DEFAULT '0', + `data21` int(10) unsigned NOT NULL DEFAULT '0', + `data22` int(10) unsigned NOT NULL DEFAULT '0', + `data23` int(10) unsigned NOT NULL DEFAULT '0', + `AIName` char(64) NOT NULL DEFAULT '', + `ScriptName` varchar(64) NOT NULL DEFAULT '', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`), + KEY `idx_name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gossip_menu` +-- + +DROP TABLE IF EXISTS `gossip_menu`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gossip_menu` ( + `entry` smallint(5) unsigned NOT NULL DEFAULT '0', + `text_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`,`text_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `gossip_menu_option` +-- + +DROP TABLE IF EXISTS `gossip_menu_option`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gossip_menu_option` ( + `menu_id` smallint(5) unsigned NOT NULL DEFAULT '0', + `id` smallint(5) unsigned NOT NULL DEFAULT '0', + `option_icon` mediumint(8) unsigned NOT NULL DEFAULT '0', + `option_text` text, + `OptionBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', + `option_id` tinyint(3) unsigned NOT NULL DEFAULT '0', + `npc_option_npcflag` int(10) unsigned NOT NULL DEFAULT '0', + `action_menu_id` int(10) unsigned NOT NULL DEFAULT '0', + `action_poi_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `box_coded` tinyint(3) unsigned NOT NULL DEFAULT '0', + `box_money` int(10) unsigned NOT NULL DEFAULT '0', + `box_text` text, + `BoxBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`menu_id`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `instance_encounters` +-- + +DROP TABLE IF EXISTS `instance_encounters`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `instance_encounters` ( + `entry` int(10) unsigned NOT NULL COMMENT 'Unique entry from DungeonEncounter.dbc', + `creditType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `creditEntry` int(10) unsigned NOT NULL DEFAULT '0', + `lastEncounterDungeon` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in', + `comment` varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `instance_template` +-- + +DROP TABLE IF EXISTS `instance_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `instance_template` ( + `map` smallint(5) unsigned NOT NULL, + `parent` smallint(5) unsigned NOT NULL, + `script` varchar(128) NOT NULL DEFAULT '', + `allowMount` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`map`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_enchantment_template` +-- + +DROP TABLE IF EXISTS `item_enchantment_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_enchantment_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ench` mediumint(8) unsigned NOT NULL DEFAULT '0', + `chance` float unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`,`ench`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_loot_template` +-- + +DROP TABLE IF EXISTS `item_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_set_names` +-- + +DROP TABLE IF EXISTS `item_set_names`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_set_names` ( + `entry` mediumint(8) unsigned NOT NULL, + `name` varchar(255) NOT NULL DEFAULT '', + `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_template` +-- + +DROP TABLE IF EXISTS `item_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `subclass` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundOverrideSubclass` tinyint(3) NOT NULL DEFAULT '-1', + `name` varchar(255) NOT NULL DEFAULT '', + `displayid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `FlagsExtra` int(10) unsigned NOT NULL DEFAULT '0', + `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT '1', + `BuyPrice` bigint(20) NOT NULL DEFAULT '0', + `SellPrice` int(10) unsigned NOT NULL DEFAULT '0', + `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AllowableClass` int(11) NOT NULL DEFAULT '-1', + `AllowableRace` int(11) NOT NULL DEFAULT '-1', + `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0', + `requiredspell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `requiredhonorrank` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredCityRank` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredReputationRank` smallint(5) unsigned NOT NULL DEFAULT '0', + `maxcount` int(11) NOT NULL DEFAULT '0', + `stackable` int(11) DEFAULT '1', + `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StatsCount` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_type1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value1` smallint(6) NOT NULL DEFAULT '0', + `stat_type2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value2` smallint(6) NOT NULL DEFAULT '0', + `stat_type3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value3` smallint(6) NOT NULL DEFAULT '0', + `stat_type4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value4` smallint(6) NOT NULL DEFAULT '0', + `stat_type5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value5` smallint(6) NOT NULL DEFAULT '0', + `stat_type6` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value6` smallint(6) NOT NULL DEFAULT '0', + `stat_type7` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value7` smallint(6) NOT NULL DEFAULT '0', + `stat_type8` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value8` smallint(6) NOT NULL DEFAULT '0', + `stat_type9` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value9` smallint(6) NOT NULL DEFAULT '0', + `stat_type10` tinyint(3) unsigned NOT NULL DEFAULT '0', + `stat_value10` smallint(6) NOT NULL DEFAULT '0', + `ScalingStatDistribution` smallint(6) NOT NULL DEFAULT '0', + `ScalingStatValue` int(10) unsigned NOT NULL DEFAULT '0', + `dmg_min1` float NOT NULL DEFAULT '0', + `dmg_max1` float NOT NULL DEFAULT '0', + `dmg_type1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `dmg_min2` float NOT NULL DEFAULT '0', + `dmg_max2` float NOT NULL DEFAULT '0', + `dmg_type2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `armor` smallint(5) unsigned NOT NULL DEFAULT '0', + `holy_res` tinyint(3) unsigned NOT NULL DEFAULT '0', + `fire_res` tinyint(3) unsigned NOT NULL DEFAULT '0', + `nature_res` tinyint(3) unsigned NOT NULL DEFAULT '0', + `frost_res` tinyint(3) unsigned NOT NULL DEFAULT '0', + `shadow_res` tinyint(3) unsigned NOT NULL DEFAULT '0', + `arcane_res` tinyint(3) unsigned NOT NULL DEFAULT '0', + `delay` smallint(5) unsigned NOT NULL DEFAULT '1000', + `ammo_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RangedModRange` float NOT NULL DEFAULT '0', + `spellid_1` mediumint(8) NOT NULL DEFAULT '0', + `spelltrigger_1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `spellcharges_1` smallint(6) NOT NULL DEFAULT '0', + `spellppmRate_1` float NOT NULL DEFAULT '0', + `spellcooldown_1` int(11) NOT NULL DEFAULT '-1', + `spellcategory_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellcategorycooldown_1` int(11) NOT NULL DEFAULT '-1', + `spellid_2` mediumint(8) NOT NULL DEFAULT '0', + `spelltrigger_2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `spellcharges_2` smallint(6) NOT NULL DEFAULT '0', + `spellppmRate_2` float NOT NULL DEFAULT '0', + `spellcooldown_2` int(11) NOT NULL DEFAULT '-1', + `spellcategory_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellcategorycooldown_2` int(11) NOT NULL DEFAULT '-1', + `spellid_3` mediumint(8) NOT NULL DEFAULT '0', + `spelltrigger_3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `spellcharges_3` smallint(6) NOT NULL DEFAULT '0', + `spellppmRate_3` float NOT NULL DEFAULT '0', + `spellcooldown_3` int(11) NOT NULL DEFAULT '-1', + `spellcategory_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellcategorycooldown_3` int(11) NOT NULL DEFAULT '-1', + `spellid_4` mediumint(8) NOT NULL DEFAULT '0', + `spelltrigger_4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `spellcharges_4` smallint(6) NOT NULL DEFAULT '0', + `spellppmRate_4` float NOT NULL DEFAULT '0', + `spellcooldown_4` int(11) NOT NULL DEFAULT '-1', + `spellcategory_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellcategorycooldown_4` int(11) NOT NULL DEFAULT '-1', + `spellid_5` mediumint(8) NOT NULL DEFAULT '0', + `spelltrigger_5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `spellcharges_5` smallint(6) NOT NULL DEFAULT '0', + `spellppmRate_5` float NOT NULL DEFAULT '0', + `spellcooldown_5` int(11) NOT NULL DEFAULT '-1', + `spellcategory_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellcategorycooldown_5` int(11) NOT NULL DEFAULT '-1', + `bonding` tinyint(3) unsigned NOT NULL DEFAULT '0', + `description` varchar(255) NOT NULL DEFAULT '', + `PageText` mediumint(8) unsigned NOT NULL DEFAULT '0', + `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PageMaterial` tinyint(3) unsigned NOT NULL DEFAULT '0', + `startquest` mediumint(8) unsigned NOT NULL DEFAULT '0', + `lockid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Material` tinyint(4) NOT NULL DEFAULT '0', + `sheath` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RandomProperty` mediumint(8) NOT NULL DEFAULT '0', + `RandomSuffix` mediumint(8) unsigned NOT NULL DEFAULT '0', + `block` mediumint(8) unsigned NOT NULL DEFAULT '0', + `itemset` mediumint(8) unsigned NOT NULL DEFAULT '0', + `MaxDurability` smallint(5) unsigned NOT NULL DEFAULT '0', + `area` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Map` smallint(6) NOT NULL DEFAULT '0', + `BagFamily` mediumint(8) NOT NULL DEFAULT '0', + `TotemCategory` mediumint(8) NOT NULL DEFAULT '0', + `socketColor_1` tinyint(4) NOT NULL DEFAULT '0', + `socketContent_1` mediumint(8) NOT NULL DEFAULT '0', + `socketColor_2` tinyint(4) NOT NULL DEFAULT '0', + `socketContent_2` mediumint(8) NOT NULL DEFAULT '0', + `socketColor_3` tinyint(4) NOT NULL DEFAULT '0', + `socketContent_3` mediumint(8) NOT NULL DEFAULT '0', + `socketBonus` mediumint(8) NOT NULL DEFAULT '0', + `GemProperties` mediumint(8) NOT NULL DEFAULT '0', + `RequiredDisenchantSkill` smallint(6) NOT NULL DEFAULT '-1', + `ArmorDamageModifier` float NOT NULL DEFAULT '0', + `duration` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLimitCategory` smallint(6) NOT NULL DEFAULT '0', + `HolidayId` int(11) unsigned NOT NULL DEFAULT '0', + `ScriptName` varchar(64) NOT NULL DEFAULT '', + `DisenchantID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `FoodType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `minMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0', + `maxMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0', + `flagsCustom` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`), + KEY `idx_name` (`name`), + KEY `items_index` (`class`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `lfg_dungeon_rewards` +-- + +DROP TABLE IF EXISTS `lfg_dungeon_rewards`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `lfg_dungeon_rewards` ( + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc', + `maxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Max level at which this reward is rewarded', + `firstQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for first dungeon this day', + `otherQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for Nth dungeon this day', + PRIMARY KEY (`dungeonId`,`maxLevel`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `lfg_entrances` +-- + +DROP TABLE IF EXISTS `lfg_entrances`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `lfg_entrances` ( + `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Unique id from LFGDungeons.dbc', + `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL, + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`dungeonId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `linked_respawn` +-- + +DROP TABLE IF EXISTS `linked_respawn`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `linked_respawn` ( + `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature', + `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature', + `linkType` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`,`linkType`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_achievement_reward` +-- + +DROP TABLE IF EXISTS `locales_achievement_reward`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_achievement_reward` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `subject_loc1` varchar(100) NOT NULL DEFAULT '', + `subject_loc2` varchar(100) NOT NULL DEFAULT '', + `subject_loc3` varchar(100) NOT NULL DEFAULT '', + `subject_loc4` varchar(100) NOT NULL DEFAULT '', + `subject_loc5` varchar(100) NOT NULL DEFAULT '', + `subject_loc6` varchar(100) NOT NULL DEFAULT '', + `subject_loc7` varchar(100) NOT NULL DEFAULT '', + `subject_loc8` varchar(100) NOT NULL DEFAULT '', + `text_loc1` text, + `text_loc2` text, + `text_loc3` text, + `text_loc4` text, + `text_loc5` text, + `text_loc6` text, + `text_loc7` text, + `text_loc8` text, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_broadcast_text` +-- + +DROP TABLE IF EXISTS `locales_broadcast_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_broadcast_text` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `MaleText_loc1` longtext, + `MaleText_loc2` longtext, + `MaleText_loc3` longtext, + `MaleText_loc4` longtext, + `MaleText_loc5` longtext, + `MaleText_loc6` longtext, + `MaleText_loc7` longtext, + `MaleText_loc8` longtext, + `FemaleText_loc1` longtext, + `FemaleText_loc2` longtext, + `FemaleText_loc3` longtext, + `FemaleText_loc4` longtext, + `FemaleText_loc5` longtext, + `FemaleText_loc6` longtext, + `FemaleText_loc7` longtext, + `FemaleText_loc8` longtext, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_creature` +-- + +DROP TABLE IF EXISTS `locales_creature`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_creature` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name_loc1` varchar(100) NOT NULL DEFAULT '', + `name_loc2` varchar(100) NOT NULL DEFAULT '', + `name_loc3` varchar(100) NOT NULL DEFAULT '', + `name_loc4` varchar(100) NOT NULL DEFAULT '', + `name_loc5` varchar(100) NOT NULL DEFAULT '', + `name_loc6` varchar(100) NOT NULL DEFAULT '', + `name_loc7` varchar(100) NOT NULL DEFAULT '', + `name_loc8` varchar(100) NOT NULL DEFAULT '', + `subname_loc1` varchar(100) DEFAULT NULL, + `subname_loc2` varchar(100) DEFAULT NULL, + `subname_loc3` varchar(100) DEFAULT NULL, + `subname_loc4` varchar(100) DEFAULT NULL, + `subname_loc5` varchar(100) DEFAULT NULL, + `subname_loc6` varchar(100) DEFAULT NULL, + `subname_loc7` varchar(100) DEFAULT NULL, + `subname_loc8` varchar(100) DEFAULT NULL, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_creature_text` +-- + +DROP TABLE IF EXISTS `locales_creature_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_creature_text` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `id` tinyint(3) unsigned NOT NULL DEFAULT '0', + `text_loc1` text, + `text_loc2` text, + `text_loc3` text, + `text_loc4` text, + `text_loc5` text, + `text_loc6` text, + `text_loc7` text, + `text_loc8` text, + PRIMARY KEY (`entry`,`groupid`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_gameobject` +-- + +DROP TABLE IF EXISTS `locales_gameobject`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_gameobject` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name_loc1` varchar(100) NOT NULL DEFAULT '', + `name_loc2` varchar(100) NOT NULL DEFAULT '', + `name_loc3` varchar(100) NOT NULL DEFAULT '', + `name_loc4` varchar(100) NOT NULL DEFAULT '', + `name_loc5` varchar(100) NOT NULL DEFAULT '', + `name_loc6` varchar(100) NOT NULL DEFAULT '', + `name_loc7` varchar(100) NOT NULL DEFAULT '', + `name_loc8` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc1` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc2` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc3` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc4` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc5` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc6` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc7` varchar(100) NOT NULL DEFAULT '', + `castbarcaption_loc8` varchar(100) NOT NULL DEFAULT '', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_gossip_menu_option` +-- + +DROP TABLE IF EXISTS `locales_gossip_menu_option`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_gossip_menu_option` ( + `menu_id` smallint(6) unsigned NOT NULL DEFAULT '0', + `id` smallint(6) unsigned NOT NULL DEFAULT '0', + `option_text_loc1` text, + `option_text_loc2` text, + `option_text_loc3` text, + `option_text_loc4` text, + `option_text_loc5` text, + `option_text_loc6` text, + `option_text_loc7` text, + `option_text_loc8` text, + `box_text_loc1` text, + `box_text_loc2` text, + `box_text_loc3` text, + `box_text_loc4` text, + `box_text_loc5` text, + `box_text_loc6` text, + `box_text_loc7` text, + `box_text_loc8` text, + PRIMARY KEY (`menu_id`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_item` +-- + +DROP TABLE IF EXISTS `locales_item`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_item` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name_loc1` varchar(100) NOT NULL DEFAULT '', + `name_loc2` varchar(100) NOT NULL DEFAULT '', + `name_loc3` varchar(100) NOT NULL DEFAULT '', + `name_loc4` varchar(100) NOT NULL DEFAULT '', + `name_loc5` varchar(100) NOT NULL DEFAULT '', + `name_loc6` varchar(100) NOT NULL DEFAULT '', + `name_loc7` varchar(100) NOT NULL DEFAULT '', + `name_loc8` varchar(100) NOT NULL DEFAULT '', + `description_loc1` varchar(255) DEFAULT NULL, + `description_loc2` varchar(255) DEFAULT NULL, + `description_loc3` varchar(255) DEFAULT NULL, + `description_loc4` varchar(255) DEFAULT NULL, + `description_loc5` varchar(255) DEFAULT NULL, + `description_loc6` varchar(255) DEFAULT NULL, + `description_loc7` varchar(255) DEFAULT NULL, + `description_loc8` varchar(255) DEFAULT NULL, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_item_set_names` +-- + +DROP TABLE IF EXISTS `locales_item_set_names`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_item_set_names` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name_loc1` varchar(100) NOT NULL DEFAULT '', + `name_loc2` varchar(100) NOT NULL DEFAULT '', + `name_loc3` varchar(100) NOT NULL DEFAULT '', + `name_loc4` varchar(100) NOT NULL DEFAULT '', + `name_loc5` varchar(100) NOT NULL DEFAULT '', + `name_loc6` varchar(100) NOT NULL DEFAULT '', + `name_loc7` varchar(100) NOT NULL DEFAULT '', + `name_loc8` varchar(100) NOT NULL DEFAULT '', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_npc_text` +-- + +DROP TABLE IF EXISTS `locales_npc_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_npc_text` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Text0_0_loc1` longtext, + `Text0_0_loc2` longtext, + `Text0_0_loc3` longtext, + `Text0_0_loc4` longtext, + `Text0_0_loc5` longtext, + `Text0_0_loc6` longtext, + `Text0_0_loc7` longtext, + `Text0_0_loc8` longtext, + `Text0_1_loc1` longtext, + `Text0_1_loc2` longtext, + `Text0_1_loc3` longtext, + `Text0_1_loc4` longtext, + `Text0_1_loc5` longtext, + `Text0_1_loc6` longtext, + `Text0_1_loc7` longtext, + `Text0_1_loc8` longtext, + `Text1_0_loc1` longtext, + `Text1_0_loc2` longtext, + `Text1_0_loc3` longtext, + `Text1_0_loc4` longtext, + `Text1_0_loc5` longtext, + `Text1_0_loc6` longtext, + `Text1_0_loc7` longtext, + `Text1_0_loc8` longtext, + `Text1_1_loc1` longtext, + `Text1_1_loc2` longtext, + `Text1_1_loc3` longtext, + `Text1_1_loc4` longtext, + `Text1_1_loc5` longtext, + `Text1_1_loc6` longtext, + `Text1_1_loc7` longtext, + `Text1_1_loc8` longtext, + `Text2_0_loc1` longtext, + `Text2_0_loc2` longtext, + `Text2_0_loc3` longtext, + `Text2_0_loc4` longtext, + `Text2_0_loc5` longtext, + `Text2_0_loc6` longtext, + `Text2_0_loc7` longtext, + `Text2_0_loc8` longtext, + `Text2_1_loc1` longtext, + `Text2_1_loc2` longtext, + `Text2_1_loc3` longtext, + `Text2_1_loc4` longtext, + `Text2_1_loc5` longtext, + `Text2_1_loc6` longtext, + `Text2_1_loc7` longtext, + `Text2_1_loc8` longtext, + `Text3_0_loc1` longtext, + `Text3_0_loc2` longtext, + `Text3_0_loc3` longtext, + `Text3_0_loc4` longtext, + `Text3_0_loc5` longtext, + `Text3_0_loc6` longtext, + `Text3_0_loc7` longtext, + `Text3_0_loc8` longtext, + `Text3_1_loc1` longtext, + `Text3_1_loc2` longtext, + `Text3_1_loc3` longtext, + `Text3_1_loc4` longtext, + `Text3_1_loc5` longtext, + `Text3_1_loc6` longtext, + `Text3_1_loc7` longtext, + `Text3_1_loc8` longtext, + `Text4_0_loc1` longtext, + `Text4_0_loc2` longtext, + `Text4_0_loc3` longtext, + `Text4_0_loc4` longtext, + `Text4_0_loc5` longtext, + `Text4_0_loc6` longtext, + `Text4_0_loc7` longtext, + `Text4_0_loc8` longtext, + `Text4_1_loc1` longtext, + `Text4_1_loc2` longtext, + `Text4_1_loc3` longtext, + `Text4_1_loc4` longtext, + `Text4_1_loc5` longtext, + `Text4_1_loc6` longtext, + `Text4_1_loc7` longtext, + `Text4_1_loc8` longtext, + `Text5_0_loc1` longtext, + `Text5_0_loc2` longtext, + `Text5_0_loc3` longtext, + `Text5_0_loc4` longtext, + `Text5_0_loc5` longtext, + `Text5_0_loc6` longtext, + `Text5_0_loc7` longtext, + `Text5_0_loc8` longtext, + `Text5_1_loc1` longtext, + `Text5_1_loc2` longtext, + `Text5_1_loc3` longtext, + `Text5_1_loc4` longtext, + `Text5_1_loc5` longtext, + `Text5_1_loc6` longtext, + `Text5_1_loc7` longtext, + `Text5_1_loc8` longtext, + `Text6_0_loc1` longtext, + `Text6_0_loc2` longtext, + `Text6_0_loc3` longtext, + `Text6_0_loc4` longtext, + `Text6_0_loc5` longtext, + `Text6_0_loc6` longtext, + `Text6_0_loc7` longtext, + `Text6_0_loc8` longtext, + `Text6_1_loc1` longtext, + `Text6_1_loc2` longtext, + `Text6_1_loc3` longtext, + `Text6_1_loc4` longtext, + `Text6_1_loc5` longtext, + `Text6_1_loc6` longtext, + `Text6_1_loc7` longtext, + `Text6_1_loc8` longtext, + `Text7_0_loc1` longtext, + `Text7_0_loc2` longtext, + `Text7_0_loc3` longtext, + `Text7_0_loc4` longtext, + `Text7_0_loc5` longtext, + `Text7_0_loc6` longtext, + `Text7_0_loc7` longtext, + `Text7_0_loc8` longtext, + `Text7_1_loc1` longtext, + `Text7_1_loc2` longtext, + `Text7_1_loc3` longtext, + `Text7_1_loc4` longtext, + `Text7_1_loc5` longtext, + `Text7_1_loc6` longtext, + `Text7_1_loc7` longtext, + `Text7_1_loc8` longtext, + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_page_text` +-- + +DROP TABLE IF EXISTS `locales_page_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_page_text` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Text_loc1` longtext, + `Text_loc2` longtext, + `Text_loc3` longtext, + `Text_loc4` longtext, + `Text_loc5` longtext, + `Text_loc6` longtext, + `Text_loc7` longtext, + `Text_loc8` longtext, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_points_of_interest` +-- + +DROP TABLE IF EXISTS `locales_points_of_interest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_points_of_interest` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `icon_name_loc1` text, + `icon_name_loc2` text, + `icon_name_loc3` text, + `icon_name_loc4` text, + `icon_name_loc5` text, + `icon_name_loc6` text, + `icon_name_loc7` text, + `icon_name_loc8` text, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `locales_quest` +-- + +DROP TABLE IF EXISTS `locales_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `locales_quest` ( + `Id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Title_loc1` text, + `Title_loc2` text, + `Title_loc3` text, + `Title_loc4` text, + `Title_loc5` text, + `Title_loc6` text, + `Title_loc7` text, + `Title_loc8` text, + `Details_loc1` text, + `Details_loc2` text, + `Details_loc3` text, + `Details_loc4` text, + `Details_loc5` text, + `Details_loc6` text, + `Details_loc7` text, + `Details_loc8` text, + `Objectives_loc1` text, + `Objectives_loc2` text, + `Objectives_loc3` text, + `Objectives_loc4` text, + `Objectives_loc5` text, + `Objectives_loc6` text, + `Objectives_loc7` text, + `Objectives_loc8` text, + `OfferRewardText_loc1` text, + `OfferRewardText_loc2` text, + `OfferRewardText_loc3` text, + `OfferRewardText_loc4` text, + `OfferRewardText_loc5` text, + `OfferRewardText_loc6` text, + `OfferRewardText_loc7` text, + `OfferRewardText_loc8` text, + `RequestItemsText_loc1` text, + `RequestItemsText_loc2` text, + `RequestItemsText_loc3` text, + `RequestItemsText_loc4` text, + `RequestItemsText_loc5` text, + `RequestItemsText_loc6` text, + `RequestItemsText_loc7` text, + `RequestItemsText_loc8` text, + `EndText_loc1` text, + `EndText_loc2` text, + `EndText_loc3` text, + `EndText_loc4` text, + `EndText_loc5` text, + `EndText_loc6` text, + `EndText_loc7` text, + `EndText_loc8` text, + `CompletedText_loc1` text, + `CompletedText_loc2` text, + `CompletedText_loc3` text, + `CompletedText_loc4` text, + `CompletedText_loc5` text, + `CompletedText_loc6` text, + `CompletedText_loc7` text, + `CompletedText_loc8` text, + `ObjectiveText1_loc1` text, + `ObjectiveText1_loc2` text, + `ObjectiveText1_loc3` text, + `ObjectiveText1_loc4` text, + `ObjectiveText1_loc5` text, + `ObjectiveText1_loc6` text, + `ObjectiveText1_loc7` text, + `ObjectiveText1_loc8` text, + `ObjectiveText2_loc1` text, + `ObjectiveText2_loc2` text, + `ObjectiveText2_loc3` text, + `ObjectiveText2_loc4` text, + `ObjectiveText2_loc5` text, + `ObjectiveText2_loc6` text, + `ObjectiveText2_loc7` text, + `ObjectiveText2_loc8` text, + `ObjectiveText3_loc1` text, + `ObjectiveText3_loc2` text, + `ObjectiveText3_loc3` text, + `ObjectiveText3_loc4` text, + `ObjectiveText3_loc5` text, + `ObjectiveText3_loc6` text, + `ObjectiveText3_loc7` text, + `ObjectiveText3_loc8` text, + `ObjectiveText4_loc1` text, + `ObjectiveText4_loc2` text, + `ObjectiveText4_loc3` text, + `ObjectiveText4_loc4` text, + `ObjectiveText4_loc5` text, + `ObjectiveText4_loc6` text, + `ObjectiveText4_loc7` text, + `ObjectiveText4_loc8` text, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`Id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `mail_level_reward` +-- + +DROP TABLE IF EXISTS `mail_level_reward`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `mail_level_reward` ( + `level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `raceMask` mediumint(8) unsigned NOT NULL DEFAULT '0', + `mailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `senderEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`level`,`raceMask`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Mail System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `mail_loot_template` +-- + +DROP TABLE IF EXISTS `mail_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `mail_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `milling_loot_template` +-- + +DROP TABLE IF EXISTS `milling_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `milling_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `npc_spellclick_spells` +-- + +DROP TABLE IF EXISTS `npc_spellclick_spells`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `npc_spellclick_spells` ( + `npc_entry` int(10) unsigned NOT NULL COMMENT 'reference to creature_template', + `spell_id` int(10) unsigned NOT NULL COMMENT 'spell which should be casted ', + `cast_flags` tinyint(3) unsigned NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit', + `user_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'relation with summoner: 0-no 1-friendly 2-raid 3-party player can click', + PRIMARY KEY (`npc_entry`,`spell_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `npc_text` +-- + +DROP TABLE IF EXISTS `npc_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `npc_text` ( + `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `text0_0` longtext, + `text0_1` longtext, + `BroadcastTextID0` mediumint(6) NOT NULL DEFAULT '0', + `lang0` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob0` float NOT NULL DEFAULT '0', + `em0_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em0_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em0_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em0_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em0_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em0_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text1_0` longtext, + `text1_1` longtext, + `BroadcastTextID1` mediumint(6) NOT NULL DEFAULT '0', + `lang1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob1` float NOT NULL DEFAULT '0', + `em1_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em1_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em1_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em1_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em1_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em1_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text2_0` longtext, + `text2_1` longtext, + `BroadcastTextID2` mediumint(6) NOT NULL DEFAULT '0', + `lang2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob2` float NOT NULL DEFAULT '0', + `em2_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em2_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em2_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em2_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em2_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em2_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text3_0` longtext, + `text3_1` longtext, + `BroadcastTextID3` mediumint(6) NOT NULL DEFAULT '0', + `lang3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob3` float NOT NULL DEFAULT '0', + `em3_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em3_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em3_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em3_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em3_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em3_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text4_0` longtext, + `text4_1` longtext, + `BroadcastTextID4` mediumint(6) NOT NULL DEFAULT '0', + `lang4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob4` float NOT NULL DEFAULT '0', + `em4_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em4_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em4_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em4_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em4_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em4_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text5_0` longtext, + `text5_1` longtext, + `BroadcastTextID5` mediumint(6) NOT NULL DEFAULT '0', + `lang5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob5` float NOT NULL DEFAULT '0', + `em5_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em5_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em5_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em5_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em5_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em5_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text6_0` longtext, + `text6_1` longtext, + `BroadcastTextID6` mediumint(6) NOT NULL DEFAULT '0', + `lang6` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob6` float NOT NULL DEFAULT '0', + `em6_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em6_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em6_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em6_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em6_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em6_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `text7_0` longtext, + `text7_1` longtext, + `BroadcastTextID7` mediumint(6) NOT NULL DEFAULT '0', + `lang7` tinyint(3) unsigned NOT NULL DEFAULT '0', + `prob7` float NOT NULL DEFAULT '0', + `em7_0` smallint(5) unsigned NOT NULL DEFAULT '0', + `em7_1` smallint(5) unsigned NOT NULL DEFAULT '0', + `em7_2` smallint(5) unsigned NOT NULL DEFAULT '0', + `em7_3` smallint(5) unsigned NOT NULL DEFAULT '0', + `em7_4` smallint(5) unsigned NOT NULL DEFAULT '0', + `em7_5` smallint(5) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `npc_trainer` +-- + +DROP TABLE IF EXISTS `npc_trainer`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `npc_trainer` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `spell` mediumint(8) NOT NULL DEFAULT '0', + `spellcost` int(10) unsigned NOT NULL DEFAULT '0', + `reqskill` smallint(5) unsigned NOT NULL DEFAULT '0', + `reqskillvalue` smallint(5) unsigned NOT NULL DEFAULT '0', + `reqlevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`,`spell`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `npc_vendor` +-- + +DROP TABLE IF EXISTS `npc_vendor`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `npc_vendor` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `slot` smallint(6) NOT NULL DEFAULT '0', + `item` mediumint(8) NOT NULL DEFAULT '0', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '0', + `incrtime` int(10) unsigned NOT NULL DEFAULT '0', + `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`,`item`,`ExtendedCost`), + KEY `slot` (`slot`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `outdoorpvp_template` +-- + +DROP TABLE IF EXISTS `outdoorpvp_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `outdoorpvp_template` ( + `TypeId` tinyint(3) unsigned NOT NULL, + `ScriptName` char(64) NOT NULL DEFAULT '', + `comment` text, + PRIMARY KEY (`TypeId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='OutdoorPvP Templates'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `page_text` +-- + +DROP TABLE IF EXISTS `page_text`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `page_text` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `text` longtext NOT NULL, + `next_page` mediumint(8) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pet_levelstats` +-- + +DROP TABLE IF EXISTS `pet_levelstats`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pet_levelstats` ( + `creature_entry` mediumint(8) unsigned NOT NULL, + `level` tinyint(3) unsigned NOT NULL, + `hp` smallint(5) unsigned NOT NULL, + `mana` smallint(5) unsigned NOT NULL, + `armor` int(10) unsigned NOT NULL DEFAULT '0', + `str` smallint(5) unsigned NOT NULL, + `agi` smallint(5) unsigned NOT NULL, + `sta` smallint(5) unsigned NOT NULL, + `inte` smallint(5) unsigned NOT NULL, + `spi` smallint(5) unsigned NOT NULL, + PRIMARY KEY (`creature_entry`,`level`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pet_name_generation` +-- + +DROP TABLE IF EXISTS `pet_name_generation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pet_name_generation` ( + `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, + `word` tinytext NOT NULL, + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `half` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pickpocketing_loot_template` +-- + +DROP TABLE IF EXISTS `pickpocketing_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pickpocketing_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_classlevelstats` +-- + +DROP TABLE IF EXISTS `player_classlevelstats`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_classlevelstats` ( + `class` tinyint(3) unsigned NOT NULL, + `level` tinyint(3) unsigned NOT NULL, + `basehp` smallint(5) unsigned NOT NULL, + `basemana` smallint(5) unsigned NOT NULL, + PRIMARY KEY (`class`,`level`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_factionchange_achievement` +-- + +DROP TABLE IF EXISTS `player_factionchange_achievement`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_factionchange_achievement` ( + `alliance_id` int(10) unsigned NOT NULL, + `horde_id` int(10) unsigned NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_factionchange_items` +-- + +DROP TABLE IF EXISTS `player_factionchange_items`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_factionchange_items` ( + `race_A` int(10) unsigned NOT NULL, + `alliance_id` int(10) unsigned NOT NULL, + `commentA` text, + `race_H` int(10) unsigned NOT NULL, + `horde_id` int(10) unsigned NOT NULL, + `commentH` text, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_factionchange_quests` +-- + +DROP TABLE IF EXISTS `player_factionchange_quests`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_factionchange_quests` ( + `alliance_id` int(10) unsigned NOT NULL, + `horde_id` int(10) unsigned NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`), + UNIQUE KEY `alliance_uniq` (`alliance_id`), + UNIQUE KEY `horde_uniq` (`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_factionchange_reputations` +-- + +DROP TABLE IF EXISTS `player_factionchange_reputations`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_factionchange_reputations` ( + `alliance_id` int(10) unsigned NOT NULL, + `horde_id` int(10) unsigned NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_factionchange_spells` +-- + +DROP TABLE IF EXISTS `player_factionchange_spells`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_factionchange_spells` ( + `alliance_id` int(10) unsigned NOT NULL, + `horde_id` int(10) unsigned NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_factionchange_titles` +-- + +DROP TABLE IF EXISTS `player_factionchange_titles`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_factionchange_titles` ( + `alliance_id` int(8) NOT NULL, + `horde_id` int(8) NOT NULL, + PRIMARY KEY (`alliance_id`,`horde_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_levelstats` +-- + +DROP TABLE IF EXISTS `player_levelstats`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_levelstats` ( + `race` tinyint(3) unsigned NOT NULL, + `class` tinyint(3) unsigned NOT NULL, + `level` tinyint(3) unsigned NOT NULL, + `str` tinyint(3) unsigned NOT NULL, + `agi` tinyint(3) unsigned NOT NULL, + `sta` tinyint(3) unsigned NOT NULL, + `inte` tinyint(3) unsigned NOT NULL, + `spi` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`race`,`class`,`level`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `player_xp_for_level` +-- + +DROP TABLE IF EXISTS `player_xp_for_level`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `player_xp_for_level` ( + `lvl` tinyint(3) unsigned NOT NULL, + `xp_for_next_level` int(10) unsigned NOT NULL, + PRIMARY KEY (`lvl`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `playercreateinfo` +-- + +DROP TABLE IF EXISTS `playercreateinfo`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playercreateinfo` ( + `race` tinyint(3) unsigned NOT NULL DEFAULT '0', + `class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `map` smallint(5) unsigned NOT NULL DEFAULT '0', + `zone` mediumint(8) unsigned NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + PRIMARY KEY (`race`,`class`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `playercreateinfo_action` +-- + +DROP TABLE IF EXISTS `playercreateinfo_action`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playercreateinfo_action` ( + `race` tinyint(3) unsigned NOT NULL DEFAULT '0', + `class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `button` smallint(5) unsigned NOT NULL DEFAULT '0', + `action` int(10) unsigned NOT NULL DEFAULT '0', + `type` smallint(5) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`race`,`class`,`button`), + KEY `playercreateinfo_race_class_index` (`race`,`class`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `playercreateinfo_item` +-- + +DROP TABLE IF EXISTS `playercreateinfo_item`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playercreateinfo_item` ( + `race` tinyint(3) unsigned NOT NULL DEFAULT '0', + `class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `itemid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `amount` tinyint(4) NOT NULL DEFAULT '1', + PRIMARY KEY (`race`,`class`,`itemid`), + KEY `playercreateinfo_race_class_index` (`race`,`class`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `playercreateinfo_skills` +-- + +DROP TABLE IF EXISTS `playercreateinfo_skills`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playercreateinfo_skills` ( + `raceMask` int(10) unsigned NOT NULL, + `classMask` int(10) unsigned NOT NULL, + `skill` smallint(5) unsigned NOT NULL, + `rank` smallint(5) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`raceMask`,`classMask`,`skill`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `playercreateinfo_spell_custom` +-- + +DROP TABLE IF EXISTS `playercreateinfo_spell_custom`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playercreateinfo_spell_custom` ( + `racemask` int(10) unsigned NOT NULL DEFAULT '0', + `classmask` int(10) unsigned NOT NULL DEFAULT '0', + `Spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Note` varchar(255) DEFAULT NULL, + PRIMARY KEY (`racemask`,`classmask`,`Spell`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `points_of_interest` +-- + +DROP TABLE IF EXISTS `points_of_interest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `points_of_interest` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `x` float NOT NULL DEFAULT '0', + `y` float NOT NULL DEFAULT '0', + `icon` mediumint(8) unsigned NOT NULL DEFAULT '0', + `flags` mediumint(8) unsigned NOT NULL DEFAULT '0', + `data` mediumint(8) unsigned NOT NULL DEFAULT '0', + `icon_name` text NOT NULL, + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pool_creature` +-- + +DROP TABLE IF EXISTS `pool_creature`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pool_creature` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0', + `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `chance` float unsigned NOT NULL DEFAULT '0', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`guid`), + KEY `idx_guid` (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pool_gameobject` +-- + +DROP TABLE IF EXISTS `pool_gameobject`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pool_gameobject` ( + `guid` int(10) unsigned NOT NULL DEFAULT '0', + `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `chance` float unsigned NOT NULL DEFAULT '0', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`guid`), + KEY `idx_guid` (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pool_pool` +-- + +DROP TABLE IF EXISTS `pool_pool`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pool_pool` ( + `pool_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `mother_pool` mediumint(8) unsigned NOT NULL DEFAULT '0', + `chance` float NOT NULL DEFAULT '0', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`pool_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pool_quest` +-- + +DROP TABLE IF EXISTS `pool_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pool_quest` ( + `entry` int(10) unsigned NOT NULL DEFAULT '0', + `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`entry`), + KEY `idx_guid` (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `pool_template` +-- + +DROP TABLE IF EXISTS `pool_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pool_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', + `max_limit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit', + `description` varchar(255) DEFAULT NULL, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `prospecting_loot_template` +-- + +DROP TABLE IF EXISTS `prospecting_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `prospecting_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_poi` +-- + +DROP TABLE IF EXISTS `quest_poi`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_poi` ( + `questId` int(10) unsigned NOT NULL DEFAULT '0', + `id` int(10) unsigned NOT NULL DEFAULT '0', + `objIndex` int(11) NOT NULL DEFAULT '0', + `mapid` int(10) unsigned NOT NULL DEFAULT '0', + `WorldMapAreaId` int(10) unsigned NOT NULL DEFAULT '0', + `FloorId` int(10) unsigned NOT NULL DEFAULT '0', + `unk3` int(10) unsigned NOT NULL DEFAULT '0', + `unk4` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`questId`,`id`), + KEY `idx` (`questId`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_poi_points` +-- + +DROP TABLE IF EXISTS `quest_poi_points`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_poi_points` ( + `questId` int(10) unsigned NOT NULL DEFAULT '0', + `id` int(10) unsigned NOT NULL DEFAULT '0', + `idx` int(10) unsigned NOT NULL DEFAULT '0', + `x` int(11) NOT NULL DEFAULT '0', + `y` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`questId`,`id`,`idx`), + KEY `questId_id` (`questId`,`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_template` +-- + +DROP TABLE IF EXISTS `quest_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_template` ( + `Id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Method` tinyint(3) unsigned NOT NULL DEFAULT '2', + `Level` smallint(3) NOT NULL DEFAULT '1', + `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ZoneOrSort` smallint(6) NOT NULL DEFAULT '0', + `Type` smallint(5) unsigned NOT NULL DEFAULT '0', + `SuggestedPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LimitTime` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredClasses` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredRaces` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkillId` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkillPoints` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredFactionId1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredFactionId2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredFactionValue1` mediumint(8) NOT NULL DEFAULT '0', + `RequiredFactionValue2` mediumint(8) NOT NULL DEFAULT '0', + `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredMinRepValue` mediumint(8) NOT NULL DEFAULT '0', + `RequiredMaxRepValue` mediumint(8) NOT NULL DEFAULT '0', + `PrevQuestId` mediumint(8) NOT NULL DEFAULT '0', + `NextQuestId` mediumint(8) NOT NULL DEFAULT '0', + `ExclusiveGroup` mediumint(8) NOT NULL DEFAULT '0', + `NextQuestIdChain` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardXPId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RewardOrRequiredMoney` int(11) NOT NULL DEFAULT '0', + `RewardMoneyMaxLevel` int(10) unsigned NOT NULL DEFAULT '0', + `RewardSpell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardSpellCast` int(11) NOT NULL DEFAULT '0', + `RewardHonor` int(11) NOT NULL DEFAULT '0', + `RewardHonorMultiplier` float NOT NULL DEFAULT '1', + `RewardMailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardMailDelay` int(11) unsigned NOT NULL DEFAULT '0', + `SourceItemId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `SourceItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SourceSpellId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RewardTitleId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredPlayerKills` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RewardTalents` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RewardArenaPoints` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardChoiceItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardFactionId1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', + `RewardFactionId2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', + `RewardFactionId3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', + `RewardFactionId4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', + `RewardFactionId5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', + `RewardFactionValueId1` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueId2` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueId3` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueId4` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueId5` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueIdOverride1` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueIdOverride2` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueIdOverride3` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueIdOverride4` mediumint(8) NOT NULL DEFAULT '0', + `RewardFactionValueIdOverride5` mediumint(8) NOT NULL DEFAULT '0', + `PointMapId` smallint(5) unsigned NOT NULL DEFAULT '0', + `PointX` float NOT NULL DEFAULT '0', + `PointY` float NOT NULL DEFAULT '0', + `PointOption` mediumint(8) unsigned NOT NULL DEFAULT '0', + `Title` text, + `Objectives` text, + `Details` text, + `EndText` text, + `OfferRewardText` text, + `RequestItemsText` text, + `CompletedText` text, + `RequiredNpcOrGo1` mediumint(8) NOT NULL DEFAULT '0', + `RequiredNpcOrGo2` mediumint(8) NOT NULL DEFAULT '0', + `RequiredNpcOrGo3` mediumint(8) NOT NULL DEFAULT '0', + `RequiredNpcOrGo4` mediumint(8) NOT NULL DEFAULT '0', + `RequiredNpcOrGoCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredNpcOrGoCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredNpcOrGoCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredNpcOrGoCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSourceItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0', + `Unknown0` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ObjectiveText1` text, + `ObjectiveText2` text, + `ObjectiveText3` text, + `ObjectiveText4` text, + `DetailsEmote1` smallint(5) unsigned NOT NULL DEFAULT '0', + `DetailsEmote2` smallint(5) unsigned NOT NULL DEFAULT '0', + `DetailsEmote3` smallint(5) unsigned NOT NULL DEFAULT '0', + `DetailsEmote4` smallint(5) unsigned NOT NULL DEFAULT '0', + `DetailsEmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0', + `DetailsEmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0', + `DetailsEmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0', + `DetailsEmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0', + `EmoteOnIncomplete` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteOnComplete` smallint(5) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmote1` smallint(5) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmote2` smallint(5) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmote3` smallint(5) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmote4` smallint(5) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0', + `OfferRewardEmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`Id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `reference_loot_template` +-- + +DROP TABLE IF EXISTS `reference_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `reference_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `reputation_reward_rate` +-- + +DROP TABLE IF EXISTS `reputation_reward_rate`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `reputation_reward_rate` ( + `faction` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_rate` float NOT NULL DEFAULT '1', + `quest_daily_rate` float NOT NULL DEFAULT '1', + `quest_weekly_rate` float NOT NULL DEFAULT '1', + `quest_monthly_rate` float NOT NULL DEFAULT '1', + `quest_repeatable_rate` float NOT NULL DEFAULT '1', + `creature_rate` float NOT NULL DEFAULT '1', + `spell_rate` float NOT NULL DEFAULT '1', + PRIMARY KEY (`faction`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `reputation_spillover_template` +-- + +DROP TABLE IF EXISTS `reputation_spillover_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `reputation_spillover_template` ( + `faction` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction entry', + `faction1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction to give spillover for', + `rate_1` float NOT NULL DEFAULT '0' COMMENT 'the given rep points * rate', + `rank_1` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'max rank,above this will not give any spillover', + `faction2` smallint(5) unsigned NOT NULL DEFAULT '0', + `rate_2` float NOT NULL DEFAULT '0', + `rank_2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `faction3` smallint(5) unsigned NOT NULL DEFAULT '0', + `rate_3` float NOT NULL DEFAULT '0', + `rank_3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `faction4` smallint(5) unsigned NOT NULL DEFAULT '0', + `rate_4` float NOT NULL DEFAULT '0', + `rank_4` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`faction`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `script_waypoint` +-- + +DROP TABLE IF EXISTS `script_waypoint`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `script_waypoint` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', + `pointid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `location_x` float NOT NULL DEFAULT '0', + `location_y` float NOT NULL DEFAULT '0', + `location_z` float NOT NULL DEFAULT '0', + `waittime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', + `point_comment` text, + PRIMARY KEY (`entry`,`pointid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `skill_discovery_template` +-- + +DROP TABLE IF EXISTS `skill_discovery_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `skill_discovery_template` ( + `spellId` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell', + `reqSpell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement', + `reqSkillValue` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'skill points requirement', + `chance` float NOT NULL DEFAULT '0' COMMENT 'chance to discover', + PRIMARY KEY (`spellId`,`reqSpell`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Discovery System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `skill_extra_item_template` +-- + +DROP TABLE IF EXISTS `skill_extra_item_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `skill_extra_item_template` ( + `spellId` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell', + `requiredSpecialization` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id', + `additionalCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create add', + `additionalMaxNum` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'max num of adds', + PRIMARY KEY (`spellId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `skill_fishing_base_level` +-- + +DROP TABLE IF EXISTS `skill_fishing_base_level`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `skill_fishing_base_level` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier', + `skill` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Base skill level requirement', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Fishing system'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `skinning_loot_template` +-- + +DROP TABLE IF EXISTS `skinning_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `skinning_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `smart_scripts` +-- + +DROP TABLE IF EXISTS `smart_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `smart_scripts` ( + `entryorguid` int(11) NOT NULL, + `source_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `id` smallint(5) unsigned NOT NULL DEFAULT '0', + `link` smallint(5) unsigned NOT NULL DEFAULT '0', + `event_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_phase_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_chance` tinyint(3) unsigned NOT NULL DEFAULT '100', + `event_flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `event_param1` int(10) unsigned NOT NULL DEFAULT '0', + `event_param2` int(10) unsigned NOT NULL DEFAULT '0', + `event_param3` int(10) unsigned NOT NULL DEFAULT '0', + `event_param4` int(10) unsigned NOT NULL DEFAULT '0', + `action_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `action_param1` int(10) unsigned NOT NULL DEFAULT '0', + `action_param2` int(10) unsigned NOT NULL DEFAULT '0', + `action_param3` int(10) unsigned NOT NULL DEFAULT '0', + `action_param4` int(10) unsigned NOT NULL DEFAULT '0', + `action_param5` int(10) unsigned NOT NULL DEFAULT '0', + `action_param6` int(10) unsigned NOT NULL DEFAULT '0', + `target_type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `target_param1` int(10) unsigned NOT NULL DEFAULT '0', + `target_param2` int(10) unsigned NOT NULL DEFAULT '0', + `target_param3` int(10) unsigned NOT NULL DEFAULT '0', + `target_x` float NOT NULL DEFAULT '0', + `target_y` float NOT NULL DEFAULT '0', + `target_z` float NOT NULL DEFAULT '0', + `target_o` float NOT NULL DEFAULT '0', + `comment` text NOT NULL COMMENT 'Event Comment', + PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_area` +-- + +DROP TABLE IF EXISTS `spell_area`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_area` ( + `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', + `area` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_start` mediumint(8) unsigned NOT NULL DEFAULT '0', + `quest_end` mediumint(8) unsigned NOT NULL DEFAULT '0', + `aura_spell` mediumint(8) NOT NULL DEFAULT '0', + `racemask` mediumint(8) unsigned NOT NULL DEFAULT '0', + `gender` tinyint(3) unsigned NOT NULL DEFAULT '2', + `autocast` tinyint(3) unsigned NOT NULL DEFAULT '0', + `quest_start_status` int(11) NOT NULL DEFAULT '64', + `quest_end_status` int(11) NOT NULL DEFAULT '11', + PRIMARY KEY (`spell`,`area`,`quest_start`,`aura_spell`,`racemask`,`gender`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_bonus_data` +-- + +DROP TABLE IF EXISTS `spell_bonus_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_bonus_data` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `direct_bonus` float NOT NULL DEFAULT '0', + `dot_bonus` float NOT NULL DEFAULT '0', + `ap_bonus` float NOT NULL DEFAULT '0', + `ap_dot_bonus` float NOT NULL DEFAULT '0', + `comments` varchar(255) DEFAULT NULL, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_custom_attr` +-- + +DROP TABLE IF EXISTS `spell_custom_attr`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_custom_attr` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', + `attributes` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SpellInfo custom attributes'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_dbc` +-- + +DROP TABLE IF EXISTS `spell_dbc`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_dbc` ( + `Id` int(10) unsigned NOT NULL, + `Dispel` int(10) unsigned NOT NULL DEFAULT '0', + `Mechanic` int(10) unsigned NOT NULL DEFAULT '0', + `Attributes` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx2` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx6` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx7` int(10) unsigned NOT NULL DEFAULT '0', + `Stances` int(10) unsigned NOT NULL DEFAULT '0', + `StancesNot` int(10) unsigned NOT NULL DEFAULT '0', + `Targets` int(10) unsigned NOT NULL DEFAULT '0', + `CastingTimeIndex` int(10) unsigned NOT NULL DEFAULT '1', + `AuraInterruptFlags` int(10) unsigned NOT NULL DEFAULT '0', + `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0', + `ProcChance` int(10) unsigned NOT NULL DEFAULT '0', + `ProcCharges` int(10) unsigned NOT NULL DEFAULT '0', + `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', + `BaseLevel` int(10) unsigned NOT NULL DEFAULT '0', + `SpellLevel` int(10) unsigned NOT NULL DEFAULT '0', + `DurationIndex` int(10) unsigned NOT NULL DEFAULT '0', + `RangeIndex` int(10) unsigned NOT NULL DEFAULT '1', + `StackAmount` int(10) unsigned NOT NULL DEFAULT '0', + `EquippedItemClass` int(11) NOT NULL DEFAULT '-1', + `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0', + `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0', + `Effect1` int(10) unsigned NOT NULL DEFAULT '0', + `Effect2` int(10) unsigned NOT NULL DEFAULT '0', + `Effect3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectDieSides1` int(11) NOT NULL DEFAULT '0', + `EffectDieSides2` int(11) NOT NULL DEFAULT '0', + `EffectDieSides3` int(11) NOT NULL DEFAULT '0', + `EffectRealPointsPerLevel1` float NOT NULL DEFAULT '0', + `EffectRealPointsPerLevel2` float NOT NULL DEFAULT '0', + `EffectRealPointsPerLevel3` float NOT NULL DEFAULT '0', + `EffectBasePoints1` int(11) NOT NULL DEFAULT '0', + `EffectBasePoints2` int(11) NOT NULL DEFAULT '0', + `EffectBasePoints3` int(11) NOT NULL DEFAULT '0', + `EffectMechanic1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectMechanic2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectMechanic3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectImplicitTargetA1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectImplicitTargetA2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectImplicitTargetA3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectImplicitTargetB1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectImplicitTargetB2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectImplicitTargetB3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectRadiusIndex1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectRadiusIndex2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectRadiusIndex3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectApplyAuraName1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectApplyAuraName2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectApplyAuraName3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectAmplitude1` int(11) NOT NULL DEFAULT '0', + `EffectAmplitude2` int(11) NOT NULL DEFAULT '0', + `EffectAmplitude3` int(11) NOT NULL DEFAULT '0', + `EffectMultipleValue1` float NOT NULL DEFAULT '0', + `EffectMultipleValue2` float NOT NULL DEFAULT '0', + `EffectMultipleValue3` float NOT NULL DEFAULT '0', + `EffectMiscValue1` int(11) NOT NULL DEFAULT '0', + `EffectMiscValue2` int(11) NOT NULL DEFAULT '0', + `EffectMiscValue3` int(11) NOT NULL DEFAULT '0', + `EffectMiscValueB1` int(11) NOT NULL DEFAULT '0', + `EffectMiscValueB2` int(11) NOT NULL DEFAULT '0', + `EffectMiscValueB3` int(11) NOT NULL DEFAULT '0', + `EffectTriggerSpell1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectTriggerSpell2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectTriggerSpell3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskA1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskA2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskA3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskB1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskB2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskB3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0', + `MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyName` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags2` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags3` int(10) unsigned NOT NULL DEFAULT '0', + `MaxAffectedTargets` int(10) unsigned NOT NULL DEFAULT '0', + `DmgClass` int(10) unsigned NOT NULL DEFAULT '0', + `PreventionType` int(10) unsigned NOT NULL DEFAULT '0', + `DmgMultiplier1` float NOT NULL DEFAULT '0', + `DmgMultiplier2` float NOT NULL DEFAULT '0', + `DmgMultiplier3` float NOT NULL DEFAULT '0', + `AreaGroupId` int(11) NOT NULL DEFAULT '0', + `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0', + `Comment` text NOT NULL, + PRIMARY KEY (`Id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_enchant_proc_data` +-- + +DROP TABLE IF EXISTS `spell_enchant_proc_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_enchant_proc_data` ( + `entry` int(10) unsigned NOT NULL, + `customChance` int(10) unsigned NOT NULL DEFAULT '0', + `PPMChance` float unsigned NOT NULL DEFAULT '0', + `procEx` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_group` +-- + +DROP TABLE IF EXISTS `spell_group`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_group` ( + `id` int(10) unsigned NOT NULL DEFAULT '0', + `spell_id` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`spell_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_group_stack_rules` +-- + +DROP TABLE IF EXISTS `spell_group_stack_rules`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_group_stack_rules` ( + `group_id` int(11) unsigned NOT NULL DEFAULT '0', + `stack_rule` tinyint(3) NOT NULL DEFAULT '0', + PRIMARY KEY (`group_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_learn_spell` +-- + +DROP TABLE IF EXISTS `spell_learn_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_learn_spell` ( + `entry` smallint(5) unsigned NOT NULL DEFAULT '0', + `SpellID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Active` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`SpellID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_linked_spell` +-- + +DROP TABLE IF EXISTS `spell_linked_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_linked_spell` ( + `spell_trigger` mediumint(8) NOT NULL, + `spell_effect` mediumint(8) NOT NULL DEFAULT '0', + `type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `comment` text NOT NULL, + UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_loot_template` +-- + +DROP TABLE IF EXISTS `spell_loot_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_loot_template` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `item` mediumint(8) unsigned NOT NULL DEFAULT '0', + `ChanceOrQuestChance` float NOT NULL DEFAULT '100', + `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', + `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', + `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', + `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', + PRIMARY KEY (`entry`,`item`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_pet_auras` +-- + +DROP TABLE IF EXISTS `spell_pet_auras`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_pet_auras` ( + `spell` mediumint(8) unsigned NOT NULL COMMENT 'dummy spell id', + `effectId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `pet` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all', + `aura` mediumint(8) unsigned NOT NULL COMMENT 'pet aura id', + PRIMARY KEY (`spell`,`effectId`,`pet`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_proc` +-- + +DROP TABLE IF EXISTS `spell_proc`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_proc` ( + `spellId` mediumint(8) NOT NULL DEFAULT '0', + `schoolMask` tinyint(4) NOT NULL DEFAULT '0', + `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', + `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', + `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', + `typeMask` int(10) unsigned NOT NULL DEFAULT '0', + `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', + `spellPhaseMask` int(11) NOT NULL DEFAULT '0', + `hitMask` int(11) NOT NULL DEFAULT '0', + `attributesMask` int(10) unsigned NOT NULL DEFAULT '0', + `ratePerMinute` float NOT NULL DEFAULT '0', + `chance` float NOT NULL DEFAULT '0', + `cooldown` float unsigned NOT NULL DEFAULT '0', + `charges` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`spellId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_proc_event` +-- + +DROP TABLE IF EXISTS `spell_proc_event`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_proc_event` ( + `entry` mediumint(8) NOT NULL DEFAULT '0', + `SchoolMask` tinyint(4) NOT NULL DEFAULT '0', + `SpellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', + `SpellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', + `procFlags` int(10) unsigned NOT NULL DEFAULT '0', + `procEx` int(10) unsigned NOT NULL DEFAULT '0', + `ppmRate` float NOT NULL DEFAULT '0', + `CustomChance` float NOT NULL DEFAULT '0', + `Cooldown` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_ranks` +-- + +DROP TABLE IF EXISTS `spell_ranks`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_ranks` ( + `first_spell_id` int(10) unsigned NOT NULL DEFAULT '0', + `spell_id` int(10) unsigned NOT NULL DEFAULT '0', + `rank` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`first_spell_id`,`rank`), + UNIQUE KEY `spell_id` (`spell_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Rank Data'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_required` +-- + +DROP TABLE IF EXISTS `spell_required`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_required` ( + `spell_id` mediumint(8) NOT NULL DEFAULT '0', + `req_spell` mediumint(8) NOT NULL DEFAULT '0', + PRIMARY KEY (`spell_id`,`req_spell`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_script_names` +-- + +DROP TABLE IF EXISTS `spell_script_names`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_script_names` ( + `spell_id` int(11) NOT NULL, + `ScriptName` char(64) NOT NULL, + UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_scripts` +-- + +DROP TABLE IF EXISTS `spell_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_scripts` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `effIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `delay` int(10) unsigned NOT NULL DEFAULT '0', + `command` mediumint(8) unsigned NOT NULL DEFAULT '0', + `datalong` mediumint(8) unsigned NOT NULL DEFAULT '0', + `datalong2` int(10) unsigned NOT NULL DEFAULT '0', + `dataint` int(11) NOT NULL DEFAULT '0', + `x` float NOT NULL DEFAULT '0', + `y` float NOT NULL DEFAULT '0', + `z` float NOT NULL DEFAULT '0', + `o` float NOT NULL DEFAULT '0' +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_target_position` +-- + +DROP TABLE IF EXISTS `spell_target_position`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_target_position` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', + `effIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `target_map` smallint(5) unsigned NOT NULL DEFAULT '0', + `target_position_x` float NOT NULL DEFAULT '0', + `target_position_y` float NOT NULL DEFAULT '0', + `target_position_z` float NOT NULL DEFAULT '0', + `target_orientation` float NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(5) DEFAULT '0', + PRIMARY KEY (`id`,`effIndex`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spell_threat` +-- + +DROP TABLE IF EXISTS `spell_threat`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_threat` ( + `entry` mediumint(8) unsigned NOT NULL, + `flatMod` int(11) DEFAULT NULL, + `pctMod` float NOT NULL DEFAULT '1' COMMENT 'threat multiplier for damage/healing', + `apPctMod` float NOT NULL DEFAULT '0' COMMENT 'additional threat bonus from attack power', + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `spelldifficulty_dbc` +-- + +DROP TABLE IF EXISTS `spelldifficulty_dbc`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spelldifficulty_dbc` ( + `id` int(11) unsigned NOT NULL DEFAULT '0', + `spellid0` int(11) unsigned NOT NULL DEFAULT '0', + `spellid1` int(11) unsigned NOT NULL DEFAULT '0', + `spellid2` int(11) unsigned NOT NULL DEFAULT '0', + `spellid3` int(11) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `transports` +-- + +DROP TABLE IF EXISTS `transports`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `transports` ( + `guid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `name` text, + `ScriptName` char(64) NOT NULL DEFAULT '', + PRIMARY KEY (`guid`), + UNIQUE KEY `idx_entry` (`entry`) +) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `trinity_string` +-- + +DROP TABLE IF EXISTS `trinity_string`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `trinity_string` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `content_default` text NOT NULL, + `content_loc1` text, + `content_loc2` text, + `content_loc3` text, + `content_loc4` text, + `content_loc5` text, + `content_loc6` text, + `content_loc7` text, + `content_loc8` text, + PRIMARY KEY (`entry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `vehicle_accessory` +-- + +DROP TABLE IF EXISTS `vehicle_accessory`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `vehicle_accessory` ( + `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `accessory_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `seat_id` tinyint(4) NOT NULL DEFAULT '0', + `minion` tinyint(3) unsigned NOT NULL DEFAULT '0', + `description` text NOT NULL, + `summontype` tinyint(3) unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', + `summontimer` int(10) unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', + PRIMARY KEY (`guid`,`seat_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `vehicle_template_accessory` +-- + +DROP TABLE IF EXISTS `vehicle_template_accessory`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `vehicle_template_accessory` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `accessory_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `seat_id` tinyint(4) NOT NULL DEFAULT '0', + `minion` tinyint(3) unsigned NOT NULL DEFAULT '0', + `description` text NOT NULL, + `summontype` tinyint(3) unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', + `summontimer` int(10) unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', + PRIMARY KEY (`entry`,`seat_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `version` +-- + +DROP TABLE IF EXISTS `version`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `version` ( + `core_version` varchar(120) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', + `core_revision` varchar(120) DEFAULT NULL, + `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.', + `cache_id` int(11) DEFAULT '0', + PRIMARY KEY (`core_version`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `warden_checks` +-- + +DROP TABLE IF EXISTS `warden_checks`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `warden_checks` ( + `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, + `type` tinyint(3) unsigned DEFAULT NULL, + `data` varchar(48) DEFAULT NULL, + `str` varchar(20) DEFAULT NULL, + `address` int(10) unsigned DEFAULT NULL, + `length` tinyint(3) unsigned DEFAULT NULL, + `result` varchar(24) DEFAULT NULL, + `comment` varchar(50) DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=787 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `waypoint_data` +-- + +DROP TABLE IF EXISTS `waypoint_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `waypoint_data` ( + `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature GUID', + `point` mediumint(8) unsigned NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `orientation` float NOT NULL DEFAULT '0', + `delay` int(10) unsigned NOT NULL DEFAULT '0', + `move_flag` tinyint(4) NOT NULL DEFAULT '0', + `action` int(11) NOT NULL DEFAULT '0', + `action_chance` smallint(6) NOT NULL DEFAULT '100', + `wpguid` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`point`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `waypoint_scripts` +-- + +DROP TABLE IF EXISTS `waypoint_scripts`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `waypoint_scripts` ( + `id` int(11) unsigned NOT NULL DEFAULT '0', + `delay` int(11) unsigned NOT NULL DEFAULT '0', + `command` int(11) unsigned NOT NULL DEFAULT '0', + `datalong` int(11) unsigned NOT NULL DEFAULT '0', + `datalong2` int(11) unsigned NOT NULL DEFAULT '0', + `dataint` int(11) unsigned NOT NULL DEFAULT '0', + `x` float NOT NULL DEFAULT '0', + `y` float NOT NULL DEFAULT '0', + `z` float NOT NULL DEFAULT '0', + `o` float NOT NULL DEFAULT '0', + `guid` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`guid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `waypoints` +-- + +DROP TABLE IF EXISTS `waypoints`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `waypoints` ( + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `pointid` mediumint(8) unsigned NOT NULL DEFAULT '0', + `position_x` float NOT NULL DEFAULT '0', + `position_y` float NOT NULL DEFAULT '0', + `position_z` float NOT NULL DEFAULT '0', + `point_comment` text, + PRIMARY KEY (`entry`,`pointid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature waypoints'; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping routines for database 'world' +-- +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2014-07-28 22:43:25 |