X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=install%2Ftables.sql;h=4169ca541557b1f59afbee39ce0ff281f1f74665;hp=564c7d1f67078223196de9a4a1f40a3aed45f8c7;hb=c89bf2a2baabaf9d0597399bcd340750149019d6;hpb=2eef921aeac777e1306bea94f498f1618f02832b diff --git a/install/tables.sql b/install/tables.sql index 564c7d1f67..4169ca5415 100644 --- a/install/tables.sql +++ b/install/tables.sql @@ -1,33 +1,35 @@ -DROP TABLE IF EXISTS `{!prefix!}admin_menu`; -CREATE TABLE `{!prefix!}admin_menu` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_admin_menu`; +CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu` ( `id` BIGINT(22) NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, `title` VARCHAR(50) NOT NULL DEFAULT '', `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - `descr` BLOB NOT NULL, + `descr` TEXT NOT NULL, PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}admins`; -CREATE TABLE `{!prefix!}admins` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_admins`; +CREATE TABLE `{?_MYSQL_PREFIX?}_admins` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `login` VARCHAR(100) NOT NULL DEFAULT '', `password` VARCHAR(40) NOT NULL DEFAULT '', - PRIMARY KEY (`id`) -) TYPE={!type!}; + `email` VARCHAR(255) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY (`login`) +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}cats`; -CREATE TABLE `{!prefix!}cats` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_cats`; +CREATE TABLE `{?_MYSQL_PREFIX?}_cats` ( `id` BIGINT(22) 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`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}config`; -CREATE TABLE `{!prefix!}config` ( +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, `points_register` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -41,13 +43,34 @@ CREATE TABLE `{!prefix!}config` ( `max_tlength` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1000', `test_subj` ENUM('Y','N') NOT NULL DEFAULT 'Y', `autosend_active` ENUM('Y','N') NOT NULL DEFAULT 'N', - PRIMARY KEY (`config`) -) TYPE={!type!}; - -INSERT INTO `{!prefix!}config` VALUES (0,5,2000,200,5,'Y','N','Y',86400,'Y',1000,'Y','N'); - -DROP TABLE IF EXISTS `{!prefix!}guest_menu`; -CREATE TABLE `{!prefix!}guest_menu` ( + `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 '78', + `patch_ctime` VARCHAR(10) NOT NULL DEFAULT 0, + `code_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5, + `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`) +) TYPE={?_TABLE_TYPE?}; + +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_guest_menu`; +CREATE TABLE `{?_MYSQL_PREFIX?}_guest_menu` ( `id` BIGINT(22) NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, @@ -57,18 +80,18 @@ CREATE TABLE `{!prefix!}guest_menu` ( `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y', `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}max_receive`; -CREATE TABLE `{!prefix!}max_receive` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_max_receive`; +CREATE TABLE `{?_MYSQL_PREFIX?}_max_receive` ( `id` BIGINT(22) NOT NULL AUTO_INCREMENT, `value` MEDIUMINT(9) NOT NULL DEFAULT 0, `comment` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}member_menu`; -CREATE TABLE `{!prefix!}member_menu` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_member_menu`; +CREATE TABLE `{?_MYSQL_PREFIX?}_member_menu` ( `id` BIGINT(22) NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, @@ -78,10 +101,10 @@ CREATE TABLE `{!prefix!}member_menu` ( `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y', `counter` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}mod_reg`; -CREATE TABLE `{!prefix!}mod_reg` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_mod_reg`; +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', @@ -91,151 +114,114 @@ CREATE TABLE `{!prefix!}mod_reg` ( `mem_only` ENUM('Y','N') NOT NULL DEFAULT 'N', `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) TYPE={!type!}; - -INSERT INTO `{!prefix!}mod_reg` VALUES (1,'admin','N','N','Y','','N',0); -INSERT INTO `{!prefix!}mod_reg` VALUES (2,'index','N','N','N','','N',0); -INSERT INTO `{!prefix!}mod_reg` VALUES (3,'frameset','Y','N','N','','N',0); -INSERT INTO `{!prefix!}mod_reg` VALUES (4,'login','N','N','N','','Y',0); -INSERT INTO `{!prefix!}mod_reg` VALUES (6,'frametester','N','Y','N','','N',0); -INSERT INTO `{!prefix!}mod_reg` VALUES (7,'loader','N','Y','N','','N',0); -INSERT INTO `{!prefix!}mod_reg` VALUES (8,'order','N','N','N','','N',0); - -DROP TABLE IF EXISTS `{!prefix!}payments`; -CREATE TABLE `{!prefix!}payments` ( +) TYPE={?_TABLE_TYPE?}; + +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', `mail_title` VARCHAR(255) NOT NULL DEFAULT '', `price` FLOAT(5,5) UNSIGNED NOT NULL DEFAULT '0.00000', PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}pool`; -CREATE TABLE `{!prefix!}pool` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_pool`; +CREATE TABLE `{?_MYSQL_PREFIX?}_pool` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sender` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `subject` VARCHAR(200) NOT NULL DEFAULT '', - `text` LONGBLOB NOT NULL, - `receivers` LONGBLOB NOT NULL, + `text` LONGTEXT NOT NULL, + `receivers` LONGTEXT NOT NULL, `payment_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, - `data_type` ENUM('TEMP','SEND','NEW','ADMIN') NOT NULL DEFAULT 'TEMP', + `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP', `timestamp` VARCHAR(10) NOT NULL DEFAULT 0, `url` TINYTEXT NOT NULL, `target_send` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, - PRIMARY KEY (`id`) -) TYPE={!type!}; - -DROP TABLE IF EXISTS `{!prefix!}refbanner`; -CREATE TABLE `{!prefix!}refbanner` ( + `zip` VARCHAR(6) NOT NULL DEFAULT '', + PRIMARY KEY (`id`), + INDEX (`sender`), + INDEX (`payment_id`), + INDEX (`cat_id`) +) TYPE={?_TABLE_TYPE?}; + +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_refbanner`; +CREATE TABLE `{?_MYSQL_PREFIX?}_refbanner` ( `id` BIGINT(22) NOT NULL AUTO_INCREMENT, `url` TEXT NOT NULL, `alternate` TEXT NOT NULL, `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y', `counter` BIGINT(22) NOT NULL DEFAULT 0, + `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}refdepths`; -CREATE TABLE `{!prefix!}refdepths` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_refdepths`; +CREATE TABLE `{?_MYSQL_PREFIX?}_refdepths` ( `id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, `level` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, `percents` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -) TYPE={!type!}; - -INSERT INTO `{!prefix!}refdepths` VALUES (1,0,100); -INSERT INTO `{!prefix!}refdepths` VALUES (2,1,30); -INSERT INTO `{!prefix!}refdepths` VALUES (3,2,15); -INSERT INTO `{!prefix!}refdepths` VALUES (4,3,10); -INSERT INTO `{!prefix!}refdepths` VALUES (5,4,8); -INSERT INTO `{!prefix!}refdepths` VALUES (6,5,5); +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}refsystem`; -CREATE TABLE `{!prefix!}refsystem` ( +DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_refsystem`; +CREATE TABLE `{?_MYSQL_PREFIX?}_refsystem` ( `id` BIGINT(22) 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`) -) TYPE={!type!}; - -ALTER TABLE `{!prefix!}config` ADD `max_send` TINYINT(3) UNSIGNED NOT NULL DEFAULT '100'; -ALTER TABLE `{!prefix!}config` ADD `url_blacklist` ENUM('Y','N') NOT NULL DEFAULT 'Y'; -ALTER TABLE `{!prefix!}config` ADD `auto_purge` TINYINT(3) UNSIGNED NOT NULL DEFAULT '14'; -ALTER TABLE `{!prefix!}config` ADD `auto_purge_active` ENUM('Y','N') NOT NULL DEFAULT 'Y'; - -ALTER TABLE `{!prefix!}pool` MODIFY `url` TINYTEXT NOT NULL; -ALTER TABLE `{!prefix!}pool` CHANGE `url` `url` TINYBLOB NOT NULL; -ALTER TABLE `{!prefix!}pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP'; +) TYPE={?_TABLE_TYPE?}; -ALTER TABLE `{!prefix!}config` ADD `last_update` VARCHAR(10) NOT NULL DEFAULT 0; - -INSERT INTO `{!prefix!}mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0); -ALTER TABLE `{!prefix!}pool` MODIFY `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP'; -ALTER TABLE `{!prefix!}config` ADD `unconfirmed` BIGINT(20) UNSIGNED NOT NULL DEFAULT '100'; -ALTER TABLE `{!prefix!}config` ADD `profile_lock` BIGINT(20) UNSIGNED NOT NULL DEFAULT '86400'; -ALTER TABLE `{!prefix!}refbanner` ADD `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0; -ALTER TABLE `{!prefix!}config` ADD `online_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT '1800'; - -ALTER TABLE `{!prefix!}config` ADD `mad_timestamp` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0; -ALTER TABLE `{!prefix!}config` ADD `mad_count` BIGINT(20) UNSIGNED NOT NULL; -ALTER TABLE `{!prefix!}config` ADD `profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT '15768000'; -ALTER TABLE `{!prefix!}config` ADD `send_prof_update` ENUM('Y','N') NOT NULL DEFAULT 'Y'; -ALTER TABLE `{!prefix!}config` ADD `resend_profile_update` BIGINT(20) UNSIGNED NOT NULL DEFAULT '172800'; - -ALTER TABLE `{!prefix!}config` ADD `patch_level` VARCHAR(100) NOT NULL DEFAULT '78'; -ALTER TABLE `{!prefix!}config` ADD `patch_ctime` VARCHAR(10) NOT NULL DEFAULT 0; - -ALTER TABLE `{!prefix!}admins` ADD `email` VARCHAR(255) NOT NULL; - -DROP TABLE IF EXISTS `{!prefix!}task_system`; -CREATE TABLE `{!prefix!}task_system` ( +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, `status` ENUM('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL DEFAULT 'NEW', - `task_type` ENUM('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS','EXTENSION','EXTENSION_UPDATE') NOT NULL DEFAULT 'FIRST_USER', + `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER', `subject` VARCHAR(255) NOT NULL DEFAULT '', - `text` LONGBLOB NOT NULL, + `text` LONGTEXT NOT NULL, `task_created` VARCHAR(10) NOT NULL DEFAULT 0, - KEY (`assigned_admin`), + INDEX (`assigned_admin`), + INDEX (`userid`), + INDEX (`assigned_admin`), PRIMARY KEY (`id`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -ALTER TABLE `{!prefix!}pool` ADD INDEX (`sender`); -ALTER TABLE `{!prefix!}pool` ADD INDEX (`payment_id`); -ALTER TABLE `{!prefix!}pool` ADD INDEX (`cat_id`); -ALTER TABLE `{!prefix!}refsystem` ADD INDEX (`userid`); -ALTER TABLE `{!prefix!}task_system` ADD INDEX (`assigned_admin`); -ALTER TABLE `{!prefix!}task_system` ADD INDEX (`userid`); - -ALTER TABLE `{!prefix!}config` ADD `code_length` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5; -ALTER TABLE `{!prefix!}config` ADD `guest_stats` ENUM('MEMBERS','MODULES','INACTIVE') NOT NULL DEFAULT 'MEMBERS'; -ALTER TABLE `{!prefix!}config` ADD `ref_payout` TINYINT(3) UNSIGNED NOT NULL DEFAULT 5; - -DROP TABLE IF EXISTS `{!prefix!}extensions`; -CREATE TABLE `{!prefix!}extensions` ( +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`) -) TYPE={!type!}; +) TYPE={?_TABLE_TYPE?}; -DROP TABLE IF EXISTS `{!prefix!}jackpot`; -CREATE TABLE `{!prefix!}jackpot` ( +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', PRIMARY KEY (`ok`) -) TYPE={!type!}; - -ALTER TABLE `{!prefix!}config` ADD `activate_xchange` BIGINT(20) UNSIGNED NOT NULL DEFAULT 100; -ALTER TABLE `{!prefix!}config` ADD `order_multi_page` ENUM('Y','N') NOT NULL DEFAULT 'Y'; -ALTER TABLE `{!prefix!}config` ADD `display_refid` ENUM('Y','N') NOT NULL DEFAULT 'Y'; -ALTER TABLE `{!prefix!}config` ADD `ip_timeout` BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400; -ALTER TABLE `{!prefix!}pool` ADD `zip` VARCHAR(6) NOT NULL DEFAULT ''; - -ALTER TABLE `{!prefix!}task_system` CHANGE `task_type` `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER'; -ALTER TABLE `{!prefix!}config` ADD `allow_direct_pay` ENUM('Y','N') NOT NULL DEFAULT 'N'; +) TYPE={?_TABLE_TYPE?}; + +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 ('index','N','N','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 ('login','N','N','N','','Y'); +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 ('frametester','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 ('confirm','N','Y','N','','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?}_refdepths` (`level`,`percents`) VALUES (0,100); +INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`,`percents`) VALUES (1,30); +INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`,`percents`) VALUES (2,15); +INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`,`percents`) VALUES (3,10); +INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`,`percents`) VALUES (4,8); +INSERT INTO `{?_MYSQL_PREFIX?}_refdepths` (`level`,`percents`) VALUES (5,5);