X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=install%2Ftables.sql;h=9ceee334fcdd2bed080c5eb8541e957dcf181103;hp=0cc24a4e5882b2ee36acdf73de2535140ff0f7e3;hb=e5527fd38a6585c8466dc28d013f12d21eb7c07a;hpb=419ba600363225629d5b81162e3fc9b52cb2dda2 diff --git a/install/tables.sql b/install/tables.sql index 0cc24a4e58..9ceee334fc 100644 --- a/install/tables.sql +++ b/install/tables.sql @@ -31,36 +31,17 @@ 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, - `url_blacklist` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `auto_purge` TINYINT(3) UNSIGNED NOT NULL DEFAULT 14, - `auto_purge_active` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `last_update` 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, - `profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT 15768000, - `send_prof_update` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `resend_profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT 172800, `patch_level` VARCHAR(100) NOT NULL DEFAULT '0', `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, - `order_multi_page` ENUM('Y','N') NOT NULL DEFAULT 'Y', - `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';