From e11330a5c8e5111d08d6aee1f4dc6dda6f7c7f2a Mon Sep 17 00:00:00 2001 From: redmatrix Date: Thu, 7 Jul 2016 16:44:58 -0700 Subject: revise how we store perm_limits --- install/schema_mysql.sql | 12 ------------ 1 file changed, 12 deletions(-) (limited to 'install/schema_mysql.sql') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 223f94162..9a67cada0 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -904,18 +904,6 @@ CREATE TABLE IF NOT EXISTS `pconfig` ( ) 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