Removed deprecated 'hidden' column from mod_reg table.

[mailer.git] / install / tables.sql

diff --git a/install/tables.sql b/install/tables.sql
index 9ceee334fcdd2bed080c5eb8541e957dcf181103..aa034d0308412fdd5d01411920bbdb5fd17b0981 100644 (file)
--- a/install/tables.sql
+++ b/install/tables.sql
@@ -94,7 +94,6 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_mod_reg` (
   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
   `module` VARCHAR(50) NOT NULL DEFAULT '',
   `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',
-  `hidden` ENUM('Y','N') NOT NULL DEFAULT 'N',
   `admin_only` ENUM('Y','N') NOT NULL DEFAULT 'N',
   `title` VARCHAR(255) NOT NULL DEFAULT '',
   `mem_only` ENUM('Y','N') NOT NULL DEFAULT 'N',
@@ -186,16 +185,16 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_jackpot` (
 
 INSERT INTO `{?_MYSQL_PREFIX?}_config` (`config`) VALUES (0);
 
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('admin','N','N','Y','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('chk_login','N','Y','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('confirm','N','Y','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('css','N','Y','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('frametester','N','Y','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('index','N','N','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('js','N','Y','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('loader','N','Y','N','','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('login','N','N','N','','Y');
-INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `hidden`, `admin_only`, `title`, `mem_only`) VALUES ('ref','N','Y','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('admin','N','Y','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('chk_login','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('confirm','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('css','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('frametester','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('index','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('js','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('loader','N','N','','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('login','N','N','','Y');
+INSERT INTO `{?_MYSQL_PREFIX?}_mod_reg` (`module`, `locked`, `admin_only`, `title`, `mem_only`) VALUES ('ref','N','N','','N');
 
 INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES (0,100);
 INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`, `percents`) VALUES (1,30);