summaryrefslogtreecommitdiff
path: root/sql-files/main.sql
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2019-09-14 18:49:13 -0300
committerJesusaves <cpntb1@ymail.com>2019-09-14 18:49:13 -0300
commitcaa876d59502c2020e7685adba470a3fae8786bb (patch)
treef3119b50fc1ea6f5369d60e7b1c03ba8bffdf98d /sql-files/main.sql
parente356ef5e200896fbf74803618c5add7dca8b18ce (diff)
downloadserverdata-caa876d59502c2020e7685adba470a3fae8786bb.tar.gz
serverdata-caa876d59502c2020e7685adba470a3fae8786bb.tar.bz2
serverdata-caa876d59502c2020e7685adba470a3fae8786bb.tar.xz
serverdata-caa876d59502c2020e7685adba470a3fae8786bb.zip
Hercules updates (authored by 4144)
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r--sql-files/main.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql
index 45a66e8fa..bafe3265d 100644
--- a/sql-files/main.sql
+++ b/sql-files/main.sql
@@ -241,6 +241,7 @@ CREATE TABLE IF NOT EXISTS `char` (
`uniqueitem_counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`sex` ENUM('M','F','U') NOT NULL DEFAULT 'U',
`hotkey_rowshift` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+ `hotkey_rowshift2` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attendance_count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`attendance_timer` BIGINT(20) NULL DEFAULT '0',
`title_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
@@ -460,6 +461,7 @@ CREATE TABLE IF NOT EXISTS `guild_castle` (
CREATE TABLE IF NOT EXISTS `guild_expulsion` (
`guild_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
+ `char_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(24) NOT NULL DEFAULT '',
`mes` VARCHAR(40) NOT NULL DEFAULT '',
PRIMARY KEY (`guild_id`,`name`)
@@ -936,6 +938,9 @@ INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1532403228); -- 2018-07-2
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1535865732); -- 2018-09-01--05-22.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1544738447); -- 2018-12-14--01-02.sql
INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1546059075); -- 2018-12-29--07-51.sql
+INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1554760320); -- 2019-04-08--21-52.sql
+INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1556147483); -- 2019-04-25--02-12.sql
+INSERT IGNORE INTO `sql_updates` (`timestamp`) VALUES (1557414445); -- 2019-05-09--18-07.sql
--
-- Table structure for table `storage`