diff options
| author | Friendika <info@friendika.com> | 2010-11-21 19:10:23 -0800 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2010-11-21 19:10:23 -0800 |
| commit | 552c56102ea70c6c9e32e13675b564a36814a069 (patch) | |
| tree | 6eb32c9a5b8d5d5746c41521f9efdcae9418a272 /database.sql | |
| parent | 890b77a547c1a00ca1cd44db5777366e2e52e2ab (diff) | |
| download | volse-hubzilla-552c56102ea70c6c9e32e13675b564a36814a069.tar.gz volse-hubzilla-552c56102ea70c6c9e32e13675b564a36814a069.tar.bz2 volse-hubzilla-552c56102ea70c6c9e32e13675b564a36814a069.zip | |
oauth2 db
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 28 |
1 files changed, 27 insertions, 1 deletions
diff --git a/database.sql b/database.sql index ffea60c49..a0b121b0a 100644 --- a/database.sql +++ b/database.sql @@ -381,4 +381,30 @@ CREATE TABLE IF NOT EXISTS `register` ( `uid` INT(11) UNSIGNED NOT NULL, `password` CHAR(255) NOT NULL, PRIMARY KEY (`id`) -) ENGINE = MYISAM DEFAULT CHARSET=utf8;
\ No newline at end of file +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE IF NOT EXISTS `clients` ( +`client_id` VARCHAR( 20 ) NOT NULL , +`pw` VARCHAR( 20 ) NOT NULL , +`redirect_uri` VARCHAR( 200 ) NOT NULL , +PRIMARY KEY ( `client_id` ) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `tokens` ( +`id` VARCHAR( 40 ) NOT NULL , +`client_id` VARCHAR( 20 ) NOT NULL , +`expires` INT NOT NULL , +`scope` VARCHAR( 200 ) NOT NULL , +PRIMARY KEY ( `id` ) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS `auth_codes` ( +`id` VARCHAR( 40 ) NOT NULL , +`client_id` VARCHAR( 20 ) NOT NULL , +`redirect_uri` VARCHAR( 200 ) NOT NULL , +`expires` INT NOT NULL , +`scope` VARCHAR( 250 ) NOT NULL , +PRIMARY KEY ( `id` ) +) ENGINE = MYISAM DEFAULT CHARSET=utf8; + |