X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=install%2Ftables.sql;h=9ceee334fcdd2bed080c5eb8541e957dcf181103;hp=528c4deac4b271eacf05a8483649a09d316ff9b2;hb=6d08952d672c5a5de7d8522f894a5665599a2a4a;hpb=51987bfef4e13f3a35643d1bf80a1a1d7e6aee0a diff --git a/install/tables.sql b/install/tables.sql index 528c4deac4..9ceee334fc 100644 --- a/install/tables.sql +++ b/install/tables.sql @@ -1,13 +1,13 @@ DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_admin_menu`; CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, `title` VARCHAR(255) NOT NULL DEFAULT '', `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `descr` TEXT NOT NULL, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Admin menu'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_admins`; CREATE TABLE `{?_MYSQL_PREFIX?}_admins` ( @@ -16,58 +16,48 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_admins` ( `password` VARCHAR(255) NOT NULL DEFAULT '', `email` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`), - UNIQUE (`login`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; + UNIQUE INDEX (`login`) +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Administrator accounts'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_cats`; CREATE TABLE `{?_MYSQL_PREFIX?}_cats` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `cat` VARCHAR(255) NOT NULL DEFAULT '', `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y', `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'General categories'; 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, + `config` TINYINT(1) NOT NULL DEFAULT 0, + `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', + `url_tlock` 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, + `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; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Configuration'; + +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_extensions`; +CREATE TABLE `{?_MYSQL_PREFIX?}_extensions` ( + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, + `ext_name` VARCHAR(255) NOT NULL DEFAULT '', + `ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N', + `ext_version` VARCHAR(255) NOT NULL DEFAULT 'INVALID', + PRIMARY KEY (`id`) +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Extension registry'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_guest_menu`; CREATE TABLE `{?_MYSQL_PREFIX?}_guest_menu` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, `title` VARCHAR(255) NOT NULL DEFAULT '', @@ -76,19 +66,19 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_guest_menu` ( `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y', `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Guest menu'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_max_receive`; CREATE TABLE `{?_MYSQL_PREFIX?}_max_receive` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, - `value` MEDIUMINT(9) NOT NULL DEFAULT 0, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, + `value` MEDIUMINT(9) UNSIGNED NOT NULL DEFAULT 0, `comment` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Mails per day setup'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_member_menu`; CREATE TABLE `{?_MYSQL_PREFIX?}_member_menu` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, `title` VARCHAR(255) NOT NULL DEFAULT '', @@ -97,7 +87,7 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_member_menu` ( `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y', `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Member menu'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_mod_reg`; CREATE TABLE `{?_MYSQL_PREFIX?}_mod_reg` ( @@ -110,17 +100,17 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_mod_reg` ( `mem_only` ENUM('Y','N') NOT NULL DEFAULT 'N', `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Module registry'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_payments`; CREATE TABLE `{?_MYSQL_PREFIX?}_payments` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `time` INT(7) NOT NULL DEFAULT 0, - `payment` FLOAT(5,3) UNSIGNED NOT NULL DEFAULT '0.000', + `time` INT(7) UNSIGNED NOT NULL DEFAULT 0, + `payment` FLOAT(5,3) UNSIGNED NOT NULL DEFAULT 0.000, `mail_title` VARCHAR(255) NOT NULL DEFAULT '', - `price` FLOAT(5,5) UNSIGNED NOT NULL DEFAULT '0.00000', + `price` FLOAT(5,5) UNSIGNED NOT NULL DEFAULT 0.00000, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Payment types'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_pool`; CREATE TABLE `{?_MYSQL_PREFIX?}_pool` ( @@ -140,18 +130,18 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_pool` ( INDEX (`sender`), INDEX (`payment_id`), INDEX (`cat_id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Sending pool'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_refbanner`; CREATE TABLE `{?_MYSQL_PREFIX?}_refbanner` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `url` TEXT NOT NULL, `alternate` TEXT NOT NULL, `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y', `counter` BIGINT(20) NOT NULL DEFAULT 0, `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Referral banner'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_refdepths`; CREATE TABLE `{?_MYSQL_PREFIX?}_refdepths` ( @@ -159,25 +149,25 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_refdepths` ( `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, `percents` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Referral levels'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_refsystem`; CREATE TABLE `{?_MYSQL_PREFIX?}_refsystem` ( - `id` BIGINT(20) NOT NULL AUTO_INCREMENT, + `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, INDEX (`userid`), PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Referral system (not points)'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_task_system`; CREATE TABLE `{?_MYSQL_PREFIX?}_task_system` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `assigned_admin` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, + `assigned_admin` BIGINT(20) UNSIGNED NULL DEFAULT NULL, + `userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL, `status` ENUM('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL DEFAULT 'NEW', - `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER', + `task_type` VARCHAR(255) NOT NULL DEFAULT 'UNKNOWN', `subject` VARCHAR(255) NOT NULL DEFAULT '', `text` LONGTEXT NOT NULL, `task_created` VARCHAR(10) NOT NULL DEFAULT 0, @@ -185,23 +175,14 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_task_system` ( INDEX (`userid`), INDEX (`assigned_admin`), PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; - -DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_extensions`; -CREATE TABLE `{?_MYSQL_PREFIX?}_extensions` ( - `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, - `ext_name` VARCHAR(255) NOT NULL DEFAULT '', - `ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N', - `ext_version` VARCHAR(255) NOT NULL DEFAULT 'INVALID', - PRIMARY KEY (`id`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Task system'; DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_jackpot`; CREATE TABLE `{?_MYSQL_PREFIX?}_jackpot` ( `ok` CHAR(2) NOT NULL DEFAULT 'ok', - `points` FLOAT(20,3) NOT NULL DEFAULT '0.000', + `points` FLOAT(20,3) NOT NULL DEFAULT 0.000, PRIMARY KEY (`ok`) -) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci; +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT 'Jackpot'; INSERT INTO `{?_MYSQL_PREFIX?}_config` (`config`) VALUES (0);