From 52bd9a771e2b94cec2491c97f418cc51d725d5b8 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Mon, 3 Nov 2014 19:11:14 +0100 Subject: Core/NetworkIO: implemented undelete opcodes and moved char create/delete packets to new packet classes --- sql/base/auth_database.sql | 1 + sql/updates/auth/2014_11_03_00_auth.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 sql/updates/auth/2014_11_03_00_auth.sql (limited to 'sql') diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index accc9eb0d16..bed40c618b2 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -217,6 +217,7 @@ CREATE TABLE `battlenet_accounts` ( `online` tinyint(3) unsigned NOT NULL DEFAULT '0', `locale` tinyint(3) unsigned NOT NULL DEFAULT '0', `os` varchar(3) NOT NULL DEFAULT '', + `LastCharacterUndelete` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Account System'; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/auth/2014_11_03_00_auth.sql b/sql/updates/auth/2014_11_03_00_auth.sql new file mode 100644 index 00000000000..1e0f0835ed5 --- /dev/null +++ b/sql/updates/auth/2014_11_03_00_auth.sql @@ -0,0 +1 @@ +ALTER TABLE `battlenet_accounts` ADD COLUMN `LastCharacterUndelete` INT(10) UNSIGNED DEFAULT 0 NOT NULL AFTER `os`; -- cgit v1.2.3