From 61792dfed649685adf7d68e2b4b25195dd2712a1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Thu, 14 Jul 2011 16:02:08 +0000 Subject: [PATCH] Even them a bit longer... --- inc/extensions/ext-user.php | 2 +- install/tables.sql | 10 +++++----- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/inc/extensions/ext-user.php b/inc/extensions/ext-user.php index c10a003f36..02fb15ab4f 100644 --- a/inc/extensions/ext-user.php +++ b/inc/extensions/ext-user.php @@ -130,7 +130,7 @@ INDEX (`stats_id`)", `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `payment_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, -`subject` VARCHAR(200) NOT NULL DEFAULT '', +`subject` VARCHAR(255) NOT NULL DEFAULT '', `url` TINYTEXT NOT NULL, `max_rec` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, diff --git a/install/tables.sql b/install/tables.sql index 52cb6ba6d1..b5d36fb5da 100644 --- a/install/tables.sql +++ b/install/tables.sql @@ -3,7 +3,7 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_admin_menu` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, - `title` VARCHAR(50) NOT NULL DEFAULT '', + `title` VARCHAR(255) NOT NULL DEFAULT '', `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `descr` TEXT NOT NULL, PRIMARY KEY (`id`) @@ -70,7 +70,7 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_guest_menu` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, - `title` VARCHAR(50) NOT NULL DEFAULT '', + `title` VARCHAR(255) NOT NULL DEFAULT '', `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y', `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y', @@ -91,7 +91,7 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_member_menu` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT, `action` VARCHAR(255) NOT NULL DEFAULT '', `what` VARCHAR(255) NULL DEFAULT NULL, - `title` VARCHAR(50) NOT NULL DEFAULT '', + `title` VARCHAR(255) NOT NULL DEFAULT '', `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y', `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y', @@ -106,7 +106,7 @@ CREATE TABLE `{?_MYSQL_PREFIX?}_mod_reg` ( `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(200) NOT NULL DEFAULT '', + `title` VARCHAR(255) NOT NULL DEFAULT '', `mem_only` ENUM('Y','N') NOT NULL DEFAULT 'N', `clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`id`) @@ -126,7 +126,7 @@ 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 '', + `subject` VARCHAR(255) NOT NULL DEFAULT '', `text` LONGTEXT NOT NULL, `receivers` LONGTEXT NOT NULL, `payment_id` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0, -- 2.30.2