From d7d889bcd09d4e92e0ded85b6c5f94ef18cc9a75 Mon Sep 17 00:00:00 2001
From: Fabio Comuni <fabrix.xm@gmail.com>
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

