X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=install%2Ftables.sql;h=9ceee334fcdd2bed080c5eb8541e957dcf181103;hb=35fd597b272983427fd88f541ea55642e0b42c9e;hp=a2af6a821dc27e3e7c958c35a04741b75571c534;hpb=84dd2fecd5b013cf6f4c4e7dee8b0d470b6a5f5c;p=mailer.git diff --git a/install/tables.sql b/install/tables.sql index a2af6a821d..9ceee334fc 100644 --- a/install/tables.sql +++ b/install/tables.sql @@ -31,21 +31,10 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_cats` ( DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_config`; CREATE TABLE `{?_MYSQL_PREFIX?}_config` ( `config` TINYINT(1) NOT NULL DEFAULT 0, - `pass_len` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5, + `min_password_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5, `points_register` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `points_ref` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `least_cats` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5, - `check_double_email` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `admin_notify` ENUM('Y','N') NOT NULL DEFAULT 'Y', `url_tlock` BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400, - `max_tlength` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1000, - `autosend_active` ENUM('Y','N') NOT NULL DEFAULT 'N', - `max_send` TINYINT(3) UNSIGNED NOT NULL DEFAULT 100, - `auto_purge` TINYINT(3) UNSIGNED NOT NULL DEFAULT 14, - `auto_purge_active` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `last_daily` VARCHAR(10) NOT NULL DEFAULT '0', - `unconfirmed` BIGINT(20) UNSIGNED NOT NULL DEFAULT 100, - `profile_lock` BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400, `online_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT 1800, `mad_timestamp` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `mad_count` BIGINT(20) UNSIGNED NOT NULL, @@ -53,9 +42,6 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_config` ( `patch_ctime` VARCHAR(10) NOT NULL DEFAULT '0', `guest_stats` ENUM('MEMBERS','MODULES','INACTIVE') NOT NULL DEFAULT 'MEMBERS', `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5, - `activate_xchange` BIGINT(20) UNSIGNED NOT NULL DEFAULT 100, - `display_refid` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `ip_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400, `allow_direct_pay` ENUM('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (`config`) ) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Configuration';