From e3041b80fd28d88b5f9ba063cb8147b9b0a61668 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Mon, 19 Jan 2015 20:06:12 -0800
Subject: oauth permissions table

---
 install/schema_mysql.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index ce3f07a89..52570898b 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1539,6 +1539,22 @@ CREATE TABLE IF NOT EXISTS `xlink` (
 
 -- --------------------------------------------------------
 
+--
+-- Table structure for table `xperm`
+--
+
+CREATE TABLE IF NOT EXISTS `xperm` (
+  `xp_id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+  `xp_client` VARCHAR( 20 ) NOT NULL DEFAULT '',
+  `xp_channel` INT UNSIGNED NOT NULL DEFAULT '0',
+  `xp_perm` VARCHAR( 64 ) NOT NULL DEFAULT '',
+  KEY `xp_client` (`xp_client`),
+  KEY `xp_channel` (`xp_channel`),
+  KEY `xp_perm` (`xp_perm`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
+-- --------------------------------------------------------
+
 --
 -- Table structure for table `xprof`
 --
-- 
cgit v1.2.3

