diff options
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; |