aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_mysql.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2015-01-19 20:06:12 -0800
committerfriendica <info@friendica.com>2015-01-19 20:06:12 -0800
commite3041b80fd28d88b5f9ba063cb8147b9b0a61668 (patch)
tree34e40ae83ce43d88527d0e45a6c84e8f61596da1 /install/schema_mysql.sql
parentced0685d67a608c3b7ad89dabb3f9af725b49ba2 (diff)
downloadvolse-hubzilla-e3041b80fd28d88b5f9ba063cb8147b9b0a61668.tar.gz
volse-hubzilla-e3041b80fd28d88b5f9ba063cb8147b9b0a61668.tar.bz2
volse-hubzilla-e3041b80fd28d88b5f9ba063cb8147b9b0a61668.zip
oauth permissions table
Diffstat (limited to 'install/schema_mysql.sql')
-rw-r--r--install/schema_mysql.sql16
1 files changed, 16 insertions, 0 deletions
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
@@ -1540,6 +1540,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`
--