From d7d889bcd09d4e92e0ded85b6c5f94ef18cc9a75 Mon Sep 17 00:00:00 2001 From: Fabio Comuni Date: Mon, 7 Nov 2011 17:48:14 +0100 Subject: oauth: db update --- database.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'database.sql') 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; -- cgit v1.2.3