diff options
Diffstat (limited to 'sql-files/main.sql')
-rw-r--r-- | sql-files/main.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql-files/main.sql b/sql-files/main.sql index a6e6c1a06..6810f74a6 100644 --- a/sql-files/main.sql +++ b/sql-files/main.sql @@ -315,6 +315,20 @@ CREATE TABLE IF NOT EXISTS `discord` ( ) ENGINE=MyISAM; -- +-- Table structure for table `patreon` +-- + +-- account_id (Game issued) +-- client_id (Patreon issued) +CREATE TABLE IF NOT EXISTS `patreon` ( + `account_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', + `client_id` VARCHAR(255) NOT NULL DEFAULT '', + `access_token` VARCHAR(255) NOT NULL DEFAULT '', + `currently_entitled_amount_cents` INT(11) DEFAULT '0', + `verified` ENUM('0', '1') NOT NULL DEFAULT '0' +) ENGINE=MyISAM; + +-- -- Table structure for table `elemental` -- |