aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/mysql_41_schema.sql
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2007-07-28 11:47:02 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2007-07-28 11:47:02 +0000
commit1db9e62e084e29638e785c93f917e6e2acc13986 (patch)
tree727bd87831f69023d882c01644e2dc8905f604ce /phpBB/install/schemas/mysql_41_schema.sql
parent5d52b5185300af5d13dc5db7062759bce7ee949e (diff)
downloadforums-1db9e62e084e29638e785c93f917e6e2acc13986.tar
forums-1db9e62e084e29638e785c93f917e6e2acc13986.tar.gz
forums-1db9e62e084e29638e785c93f917e6e2acc13986.tar.bz2
forums-1db9e62e084e29638e785c93f917e6e2acc13986.tar.xz
forums-1db9e62e084e29638e785c93f917e6e2acc13986.zip
same right for all. ;) Groups table using same column types as the users table for avatars.
git-svn-id: file:///svn/phpbb/trunk@7968 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/mysql_41_schema.sql')
-rw-r--r--phpBB/install/schemas/mysql_41_schema.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql
index f9535aaacc..022c3ecbfe 100644
--- a/phpBB/install/schemas/mysql_41_schema.sql
+++ b/phpBB/install/schemas/mysql_41_schema.sql
@@ -303,9 +303,9 @@ CREATE TABLE phpbb_groups (
group_desc_uid varchar(5) DEFAULT '' NOT NULL,
group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
group_avatar varchar(255) DEFAULT '' NOT NULL,
- group_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
- group_avatar_width tinyint(4) DEFAULT '0' NOT NULL,
- group_avatar_height tinyint(4) DEFAULT '0' NOT NULL,
+ group_avatar_type tinyint(2) DEFAULT '0' NOT NULL,
+ group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
+ group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
group_colour varchar(6) DEFAULT '' NOT NULL,
group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,