aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql1
-rw-r--r--sql/updates/characters/2011_08_03_00_characters_characters.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 75a0723235a..00538f6ad41 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1167,6 +1167,7 @@ CREATE TABLE `characters` (
`ammoId` int(10) unsigned NOT NULL DEFAULT '0',
`knownTitles` longtext,
`actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0',
`deleteInfos_Account` int(10) unsigned DEFAULT NULL,
`deleteInfos_Name` varchar(12) DEFAULT NULL,
`deleteDate` int(10) unsigned DEFAULT NULL,
diff --git a/sql/updates/characters/2011_08_03_00_characters_characters.sql b/sql/updates/characters/2011_08_03_00_characters_characters.sql
new file mode 100644
index 00000000000..caa69a8655c
--- /dev/null
+++ b/sql/updates/characters/2011_08_03_00_characters_characters.sql
@@ -0,0 +1 @@
+ALTER TABLE `characters` ADD COLUMN `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `actionBars`;