diff options
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/main.sql | 9 | ||||
| -rw-r--r-- | sql-files/upgrades/2018-08-03--11-37.sql | 7 |
2 files changed, 16 insertions, 0 deletions
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 @@ -278,6 +278,15 @@ CREATE TABLE IF NOT EXISTS `charlog` ( ) 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); |