From c918bbba255c4566dcd6c85c06e19646bd178183 Mon Sep 17 00:00:00 2001
From: redmatrix <git@macgirvin.com>
Date: Sun, 3 Jul 2016 17:10:00 -0700
Subject: more work on x permissions

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

(limited to 'install/schema_mysql.sql')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index d2a5ac85e..223f94162 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -903,6 +903,19 @@ CREATE TABLE IF NOT EXISTS `pconfig` (
   UNIQUE KEY `access` (`uid`,`cat`,`k`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
+
+create table if not exists perm_limits {
+	id int(10) not null AUTO_INCREMENT,
+	perm varchar(64) not null default '',
+	channel_id int(10) unsigned not null default 0,
+	perm_limit int(10) unsigned not null default 0,
+	PRIMARY KEY (`id`),
+  	KEY `perm` (`perm`),
+  	KEY `channel_id` (`channel_id`),
+	KEY `perm_limit` (`perm_limit`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
+
 CREATE TABLE IF NOT EXISTS `photo` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `aid` int(10) unsigned NOT NULL DEFAULT '0',
-- 
cgit v1.2.3

