aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql72
-rw-r--r--sql/updates/characters/2014_10_23_02_characters.sql36
-rw-r--r--sql/updates/world/2014_10_23_01_world.sql1
3 files changed, 73 insertions, 36 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 7a620dc3ecf..94dfc7adf8e 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -688,31 +688,31 @@ DROP TABLE IF EXISTS `character_equipmentsets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_equipmentsets` (
- `guid` int(10) NOT NULL DEFAULT '0',
+ `guid` bigint(20) NOT NULL DEFAULT '0',
`setguid` bigint(20) NOT NULL AUTO_INCREMENT,
`setindex` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(31) NOT NULL,
`iconname` varchar(100) NOT NULL,
`ignore_mask` int(11) unsigned NOT NULL DEFAULT '0',
- `item0` int(11) unsigned NOT NULL DEFAULT '0',
- `item1` int(11) unsigned NOT NULL DEFAULT '0',
- `item2` int(11) unsigned NOT NULL DEFAULT '0',
- `item3` int(11) unsigned NOT NULL DEFAULT '0',
- `item4` int(11) unsigned NOT NULL DEFAULT '0',
- `item5` int(11) unsigned NOT NULL DEFAULT '0',
- `item6` int(11) unsigned NOT NULL DEFAULT '0',
- `item7` int(11) unsigned NOT NULL DEFAULT '0',
- `item8` int(11) unsigned NOT NULL DEFAULT '0',
- `item9` int(11) unsigned NOT NULL DEFAULT '0',
- `item10` int(11) unsigned NOT NULL DEFAULT '0',
- `item11` int(11) unsigned NOT NULL DEFAULT '0',
- `item12` int(11) unsigned NOT NULL DEFAULT '0',
- `item13` int(11) unsigned NOT NULL DEFAULT '0',
- `item14` int(11) unsigned NOT NULL DEFAULT '0',
- `item15` int(11) unsigned NOT NULL DEFAULT '0',
- `item16` int(11) unsigned NOT NULL DEFAULT '0',
- `item17` int(11) unsigned NOT NULL DEFAULT '0',
- `item18` int(11) unsigned NOT NULL DEFAULT '0',
+ `item0` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item1` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item2` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item3` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item4` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item5` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item6` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item7` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item8` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item9` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item10` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item11` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item12` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item13` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item14` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item15` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item16` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item17` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item18` bigint(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`setguid`),
UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),
KEY `Idx_setindex` (`setindex`)
@@ -736,8 +736,8 @@ DROP TABLE IF EXISTS `character_gifts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_gifts` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
- `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
+ `item_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`entry` int(10) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`item_guid`),
@@ -762,7 +762,7 @@ DROP TABLE IF EXISTS `character_glyphs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_glyphs` (
- `guid` int(10) unsigned NOT NULL,
+ `guid` bigint(20) unsigned NOT NULL,
`spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
`glyph1` smallint(5) unsigned DEFAULT '0',
`glyph2` smallint(5) unsigned DEFAULT '0',
@@ -794,7 +794,7 @@ DROP TABLE IF EXISTS `character_homebind`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_homebind` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
`zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
`posX` float NOT NULL DEFAULT '0',
@@ -821,7 +821,7 @@ DROP TABLE IF EXISTS `character_instance`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_instance` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
`instance` int(10) unsigned NOT NULL DEFAULT '0',
`permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`instance`),
@@ -846,10 +846,10 @@ DROP TABLE IF EXISTS `character_inventory`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_inventory` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
- `bag` int(10) unsigned NOT NULL DEFAULT '0',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `bag` bigint(20) unsigned NOT NULL DEFAULT '0',
`slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
+ `item` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
PRIMARY KEY (`item`),
UNIQUE KEY `guid` (`guid`,`bag`,`slot`),
KEY `idx_guid` (`guid`)
@@ -941,7 +941,7 @@ DROP TABLE IF EXISTS `character_queststatus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_queststatus` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`explored` tinyint(3) unsigned NOT NULL DEFAULT '0',
@@ -976,7 +976,7 @@ DROP TABLE IF EXISTS `character_queststatus_daily`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_queststatus_daily` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
`time` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`,`quest`),
@@ -1001,7 +1001,7 @@ DROP TABLE IF EXISTS `character_queststatus_monthly`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_queststatus_monthly` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`guid`,`quest`),
KEY `idx_guid` (`guid`)
@@ -1025,7 +1025,7 @@ DROP TABLE IF EXISTS `character_queststatus_rewarded`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_queststatus_rewarded` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
`active` tinyint(10) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`guid`,`quest`)
@@ -1049,7 +1049,7 @@ DROP TABLE IF EXISTS `character_queststatus_seasonal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_queststatus_seasonal` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
`event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier',
PRIMARY KEY (`guid`,`quest`),
@@ -1074,7 +1074,7 @@ DROP TABLE IF EXISTS `character_queststatus_weekly`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_queststatus_weekly` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
PRIMARY KEY (`guid`,`quest`),
KEY `idx_guid` (`guid`)
@@ -1098,7 +1098,7 @@ DROP TABLE IF EXISTS `character_reputation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_reputation` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
+ `guid` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
`faction` smallint(5) unsigned NOT NULL DEFAULT '0',
`standing` int(11) NOT NULL DEFAULT '0',
`flags` smallint(5) unsigned NOT NULL DEFAULT '0',
@@ -1123,7 +1123,7 @@ DROP TABLE IF EXISTS `character_skills`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `character_skills` (
- `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier',
+ `guid` bigint(20) unsigned NOT NULL COMMENT 'Global Unique Identifier',
`skill` smallint(5) unsigned NOT NULL,
`value` smallint(5) unsigned NOT NULL,
`max` smallint(5) unsigned NOT NULL,
diff --git a/sql/updates/characters/2014_10_23_02_characters.sql b/sql/updates/characters/2014_10_23_02_characters.sql
new file mode 100644
index 00000000000..7861a548089
--- /dev/null
+++ b/sql/updates/characters/2014_10_23_02_characters.sql
@@ -0,0 +1,36 @@
+ALTER TABLE `character_equipmentsets` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item0` `item0` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item1` `item1` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item2` `item2` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item3` `item3` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item4` `item4` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item5` `item5` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item6` `item6` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item7` `item7` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item8` `item8` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item9` `item9` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item10` `item10` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item11` `item11` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item12` `item12` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item13` `item13` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item14` `item14` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item15` `item15` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item16` `item16` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item17` `item17` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_equipmentsets` CHANGE `item18` `item18` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_gifts` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_gifts` CHANGE `item_guid` `item_guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_glyphs` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_homebind` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_instance` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_inventory` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_inventory` CHANGE `bag` `bag` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_inventory` CHANGE `item` `item` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_queststatus` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_queststatus_daily` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_queststatus_monthly` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_queststatus_rewarded` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_queststatus_seasonal` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_queststatus_weekly` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_reputation` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
+ALTER TABLE `character_skills` CHANGE `guid` `guid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0';
diff --git a/sql/updates/world/2014_10_23_01_world.sql b/sql/updates/world/2014_10_23_01_world.sql
new file mode 100644
index 00000000000..adedfe28d28
--- /dev/null
+++ b/sql/updates/world/2014_10_23_01_world.sql
@@ -0,0 +1 @@
+UPDATE `trinity_string` SET `content_default`='%s - owner: %s (%s account: %u) %s' WHERE `entry`=508;