aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/characters.sql1
-rw-r--r--sql/updates/7901_characters_characters.sql1
-rw-r--r--sql/updates/7923_characters_characters.sql2
3 files changed, 3 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql
index 16312e478b1..d07f43cf3a0 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -391,6 +391,7 @@ CREATE TABLE `characters` (
`equipmentCache` longtext,
`ammoId` int(10) UNSIGNED NOT NULL default '0',
`knownTitles` longtext,
+ `actionBars` tinyint(3) UNSIGNED NOT NULL default '0',
PRIMARY KEY (`guid`),
KEY `idx_account` (`account`),
KEY `idx_online` (`online`),
diff --git a/sql/updates/7901_characters_characters.sql b/sql/updates/7901_characters_characters.sql
deleted file mode 100644
index 381cd0399da..00000000000
--- a/sql/updates/7901_characters_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `characters` DROP `actionBars`;
diff --git a/sql/updates/7923_characters_characters.sql b/sql/updates/7923_characters_characters.sql
new file mode 100644
index 00000000000..a9fe4880731
--- /dev/null
+++ b/sql/updates/7923_characters_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE characters
+ ADD COLUMN `actionBars` tinyint(3) UNSIGNED NOT NULL default '0' AFTER knownTitles;