diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/10548_characters_channel.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/updates/10548_characters_channel.sql b/sql/updates/10548_characters_channel.sql index 905d3583e4a..126a51ca5bb 100644 --- a/sql/updates/10548_characters_channel.sql +++ b/sql/updates/10548_characters_channel.sql @@ -5,4 +5,5 @@ CHANGE `m_announce` `m_announce` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, CHANGE `m_public` `m_ownership` TINYINT(3) UNSIGNED DEFAULT '1' NOT NULL, CHANGE `m_password` `m_password` VARCHAR(32) NULL, ADD COLUMN `last_used` INT(10) UNSIGNED NOT NULL AFTER `BannedList`; -SET last_used = UNIX_TIMESTAMP(); +-- Set already existing/current channels to use current timestamp (saves them from being unneccesarily cleaned up) +UPDATE `channels` SET last_used = UNIX_TIMESTAMP(); |