diff options
| author | Fabio Comuni <fabrix.xm@gmail.com> | 2011-11-07 17:48:14 +0100 |
|---|---|---|
| committer | Fabio Comuni <fabrix.xm@gmail.com> | 2011-11-07 17:48:14 +0100 |
| commit | d7d889bcd09d4e92e0ded85b6c5f94ef18cc9a75 (patch) | |
| tree | fd9366ab98ae710137f2edaccbf3147cf47ee523 /database.sql | |
| parent | 00c342e13d833fd215e5dc03a508e1abe660fe21 (diff) | |
| download | volse-hubzilla-d7d889bcd09d4e92e0ded85b6c5f94ef18cc9a75.tar.gz volse-hubzilla-d7d889bcd09d4e92e0ded85b6c5f94ef18cc9a75.tar.bz2 volse-hubzilla-d7d889bcd09d4e92e0ded85b6c5f94ef18cc9a75.zip | |
oauth: db update
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/database.sql b/database.sql index 3d11ff4b7..58b81b0ac 100644 --- a/database.sql +++ b/database.sql @@ -460,14 +460,19 @@ CREATE TABLE IF NOT EXISTS `clients` ( `client_id` VARCHAR( 20 ) NOT NULL , `pw` VARCHAR( 20 ) NOT NULL , `redirect_uri` VARCHAR( 200 ) NOT NULL , +`name` VARCHAR( 128 ) NULL DEFAULT NULL, +`icon` VARCHAR( 255 ) NULL DEFAULT NULL, +`uid` INT NOT NULL DEFAULT 0, PRIMARY KEY ( `client_id` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `tokens` ( `id` VARCHAR( 40 ) NOT NULL , +`secret` VARCHAR( 40 ) NOT NULL , `client_id` VARCHAR( 20 ) NOT NULL , `expires` INT NOT NULL , `scope` VARCHAR( 200 ) NOT NULL , +`uid` INT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; |