From 552c56102ea70c6c9e32e13675b564a36814a069 Mon Sep 17 00:00:00 2001
From: Friendika <info@friendika.com>
Date: Sun, 21 Nov 2010 19:10:23 -0800
Subject: oauth2 db

---
 database.sql | 28 +++++++++++++++++++++++++++-
 1 file changed, 27 insertions(+), 1 deletion(-)

(limited to 'database.sql')

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;
+
-- 
cgit v1.2.3

