diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-17 16:37:45 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-17 16:37:45 +0000 |
| commit | 308bd4a93bf941c5743a47b0009529833573bb0b (patch) | |
| tree | 37cb3d15c9c3d435c65533528ea36955375fbe82 /phpBB/db | |
| parent | a16d51a4a56e62d32b0a7405b3185c7b93ab301c (diff) | |
| download | forums-308bd4a93bf941c5743a47b0009529833573bb0b.tar forums-308bd4a93bf941c5743a47b0009529833573bb0b.tar.gz forums-308bd4a93bf941c5743a47b0009529833573bb0b.tar.bz2 forums-308bd4a93bf941c5743a47b0009529833573bb0b.tar.xz forums-308bd4a93bf941c5743a47b0009529833573bb0b.zip | |
Changed the allow/disallow fields to match the profile template
git-svn-id: file:///svn/phpbb/trunk@313 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 50 | ||||
| -rw-r--r-- | phpBB/db/postgres_schema.sql | 50 |
2 files changed, 50 insertions, 50 deletions
diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index 011b241910..0114912e9b 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -267,30 +267,30 @@ CREATE TABLE phpbb_themes ( themes_name varchar(30) NOT NULL, head_stylesheet varchar(100), body_background varchar(100), - body_bgcolor varchar(6), - body_text varchar(6), - body_link varchar(6), - body_vlink varchar(6), - body_alink varchar(6), - body_hlink varchar(6), - tr_color1 varchar(6), - tr_color2 varchar(6), - tr_color3 varchar(6), - th_color1 varchar(6), - th_color2 varchar(6), - th_color3 varchar(6), - td_color1 varchar(6), - td_color2 varchar(6), - td_color3 varchar(6), - fontface1 varchar(15), - fontface2 varchar(15), - fontface3 varchar(15), + body_bgcolor char(6), + body_text char(6), + body_link char(6), + body_vlink char(6), + body_alink char(6), + body_hlink char(6), + tr_color1 char(6), + tr_color2 char(6), + tr_color3 char(6), + th_color1 char(6), + th_color2 char(6), + th_color3 char(6), + td_color1 char(6), + td_color2 char(6), + td_color3 char(6), + fontface1 varchar(30), + fontface2 varchar(30), + fontface3 varchar(30), fontsize1 tinyint(4), fontsize2 tinyint(4), fontsize3 tinyint(4), - fontcolor1 varchar(6), - fontcolor2 varchar(6), - fontcolor3 varchar(6), + fontcolor1 char(6), + fontcolor2 char(6), + fontcolor3 char(6), img1 varchar(100), img2 varchar(100), img3 varchar(100), @@ -384,16 +384,16 @@ CREATE TABLE phpbb_users ( user_from varchar(100), user_interests varchar(255), user_sig varchar(255), - user_viewemail tinyint(3), user_theme int(11), user_aim varchar(255), user_yim varchar(255), user_msnm varchar(255), user_posts int(11) DEFAULT '0', + user_viewemail tinyint(3), user_attachsig tinyint(3), - user_desmile tinyint(3), - user_html tinyint(3), - user_bbcode tinyint(3), + user_allowhtml tinyint(3), + user_allowbbcode tinyint(3), + user_allowsmile tinyint(3), user_actkey varchar(32), user_newpasswd varchar(32), user_notify tinyint(3), diff --git a/phpBB/db/postgres_schema.sql b/phpBB/db/postgres_schema.sql index 1972cdaaf5..64bf351b66 100644 --- a/phpBB/db/postgres_schema.sql +++ b/phpBB/db/postgres_schema.sql @@ -290,30 +290,30 @@ CREATE TABLE "phpbb_themes" ( "themes_name" varchar(30), "head_stylesheet" varchar(100), "body_background" varchar(100), - "body_bgcolor" varchar(6), - "body_text" varchar(6), - "body_link" varchar(6), - "body_vlink" varchar(6), - "body_alink" varchar(6), - "body_hlink" varchar(6), - "tr_color1" varchar(6), - "tr_color2" varchar(6), - "tr_color3" varchar(6), - "th_color1" varchar(6), - "th_color2" varchar(6), - "th_color3" varchar(6), - "td_color1" varchar(6), - "td_color2" varchar(6), - "td_color3" varchar(6), - "fontface1" varchar(15), - "fontface2" varchar(15), - "fontface3" varchar(15), + "body_bgcolor" char(6), + "body_text" char(6), + "body_link" char(6), + "body_vlink" char(6), + "body_alink" char(6), + "body_hlink" char(6), + "tr_color1" char(6), + "tr_color2" char(6), + "tr_color3" char(6), + "th_color1" char(6), + "th_color2" char(6), + "th_color3" char(6), + "td_color1" char(6), + "td_color2" char(6), + "td_color3" char(6), + "fontface1" varchar(30), + "fontface2" varchar(30), + "fontface3" varchar(30), "fontsize1" int2, "fontsize2" int2, "fontsize3" int2, - "fontcolor1" varchar(6), - "fontcolor2" varchar(6), - "fontcolor3" varchar(6), + "fontcolor1" char(6), + "fontcolor2" char(6), + "fontcolor3" char(6), "img1" varchar(100), "img2" varchar(100), "img3" varchar(100), @@ -399,16 +399,16 @@ CREATE TABLE "phpbb_users" ( "user_from" varchar(100), "user_interests" varchar(255), "user_sig" varchar(255), - "user_viewemail" int2, "user_theme" int4, "user_aim" varchar(255), "user_yim" varchar(255), "user_msnm" varchar(255), "user_posts" int4 DEFAULT '0', + "user_viewemail" int2, "user_attachsig" int2, - "user_desmile" int2, - "user_html" int2, - "user_bbcode" int2, + "user_allowhtml" int2, + "user_allowbbcode" int2, + "user_allowsmile" int2, "user_rank" int4 DEFAULT '0', "user_avatar" varchar(100), "user_level" int4 DEFAULT '1', |