diff options
| author | Jesusaves <cpntb1@ymail.com> | 2018-10-16 17:28:24 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2018-10-16 17:28:24 -0300 |
| commit | c60dc31c74313d2de85bf88b7edb17d6f75d2fff (patch) | |
| tree | 445f7bf2932531c78390bb81ae5b167255025c9b /sql-files | |
| parent | e3e4bc9d918a86c3b3699a7256fc229231c0de72 (diff) | |
| download | serverdata-c60dc31c74313d2de85bf88b7edb17d6f75d2fff.tar.gz serverdata-c60dc31c74313d2de85bf88b7edb17d6f75d2fff.tar.bz2 serverdata-c60dc31c74313d2de85bf88b7edb17d6f75d2fff.tar.xz serverdata-c60dc31c74313d2de85bf88b7edb17d6f75d2fff.zip | |
Put some lawn on my cables. :>
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); |