From c60dc31c74313d2de85bf88b7edb17d6f75d2fff Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Tue, 16 Oct 2018 17:28:24 -0300 Subject: Put some lawn on my cables. :> --- sql-files/main.sql | 9 +++++++++ sql-files/upgrades/2018-08-03--11-37.sql | 7 +++++++ 2 files changed, 16 insertions(+) (limited to 'sql-files') diff --git a/sql-files/main.sql b/sql-files/main.sql index 2d4de5237..eba0291a0 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -277,6 +277,15 @@ CREATE TABLE IF NOT EXISTS `charlog` ( `hair_color` INT(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM; +-- +-- Table structure for table `discord` +-- + +CREATE TABLE IF NOT EXISTS `discord` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `discord_id` VARCHAR(255) NOT NULL DEFAULT '' +) ENGINE=MyISAM; + -- -- Table structure for table `elemental` -- diff --git a/sql-files/upgrades/2018-08-03--11-37.sql b/sql-files/upgrades/2018-08-03--11-37.sql index 1dde29fd6..c9a532b26 100644 --- a/sql-files/upgrades/2018-08-03--11-37.sql +++ b/sql-files/upgrades/2018-08-03--11-37.sql @@ -21,4 +21,11 @@ ALTER TABLE `quest` CHANGE `count1` `count1` INT(11) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `quest` CHANGE `count2` `count2` INT(11) UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `quest` CHANGE `count3` `count3` INT(11) UNSIGNED NOT NULL DEFAULT '0'; + +CREATE TABLE IF NOT EXISTS `discord` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `discord_id` VARCHAR(255) NOT NULL DEFAULT '' +) ENGINE=MyISAM; + + INSERT INTO `sql_updates` (`timestamp`) VALUES (1533307076); -- cgit v1.2.3-60-g2f50