aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/2012_06_13_00_characters_character_equipmentsets.sql22
-rw-r--r--sql/updates/characters/2012_08_07_00_characters_characters.sql2
-rw-r--r--sql/updates/characters/2012_09_07_00_characters_characters.sql2
3 files changed, 0 insertions, 26 deletions
diff --git a/sql/updates/characters/2012_06_13_00_characters_character_equipmentsets.sql b/sql/updates/characters/2012_06_13_00_characters_character_equipmentsets.sql
deleted file mode 100644
index ebf12062be3..00000000000
--- a/sql/updates/characters/2012_06_13_00_characters_character_equipmentsets.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-ALTER TABLE `character_equipmentsets`
-MODIFY COLUMN `item0` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item1` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item2` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item3` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item4` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item5` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item6` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item7` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item8` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item9` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item10` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item11` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item12` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item13` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item14` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item15` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item16` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item17` int(11) unsigned NOT NULL DEFAULT 0,
-MODIFY COLUMN `item18` int(11) unsigned NOT NULL DEFAULT 0;
-
-ALTER TABLE `character_equipmentsets` ADD COLUMN `ignore_mask` int(11) unsigned NOT NULL DEFAULT 0 AFTER `iconname`;
diff --git a/sql/updates/characters/2012_08_07_00_characters_characters.sql b/sql/updates/characters/2012_08_07_00_characters_characters.sql
deleted file mode 100644
index e9bea82ad4b..00000000000
--- a/sql/updates/characters/2012_08_07_00_characters_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-UPDATE characters SET drunk = (drunk / 256) & 0xFF;
-ALTER TABLE characters CHANGE drunk drunk tinyint(3) unsigned NOT NULL DEFAULT '0';
diff --git a/sql/updates/characters/2012_09_07_00_characters_characters.sql b/sql/updates/characters/2012_09_07_00_characters_characters.sql
deleted file mode 100644
index 26ad904b4a0..00000000000
--- a/sql/updates/characters/2012_09_07_00_characters_characters.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-ALTER TABLE `characters` MODIFY `name`
- VARCHAR(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;