aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorNay <dnpd.dd@gmail.com>2012-09-15 21:03:40 +0100
committerNay <dnpd.dd@gmail.com>2012-09-15 21:03:40 +0100
commit0d3554d4bfb63b9f8fcfba3c8320f2acc425c80f (patch)
treecba5b6ad0d4762386a87af219e5e2edc7cad36ab /sql/updates/characters
parent80006a275f890be065f69a1696fa265bc5f54af2 (diff)
TDB 335.49 - 2012/09/15TDB335.49
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;