aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/db/schemas
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-01-28 01:37:50 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-01-28 01:37:50 +0000
commit62dd3bd84def39f1f05df6295f322f0f5ed9ab0a (patch)
tree1f00835f142e47de5d51ad3d4cc591580e64a06f /phpBB/db/schemas
parent6c2406d7dfb5cf339e705b9150f8c289abac7b94 (diff)
downloadforums-62dd3bd84def39f1f05df6295f322f0f5ed9ab0a.tar
forums-62dd3bd84def39f1f05df6295f322f0f5ed9ab0a.tar.gz
forums-62dd3bd84def39f1f05df6295f322f0f5ed9ab0a.tar.bz2
forums-62dd3bd84def39f1f05df6295f322f0f5ed9ab0a.tar.xz
forums-62dd3bd84def39f1f05df6295f322f0f5ed9ab0a.zip
Updated themes_name field lengths to 50 as per other schemas
git-svn-id: file:///svn/phpbb/trunk@1981 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/schemas')
-rw-r--r--phpBB/db/schemas/mssql_schema.sql62
1 files changed, 31 insertions, 31 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql
index 998e05a76a..dd92f7e3a5 100644
--- a/phpBB/db/schemas/mssql_schema.sql
+++ b/phpBB/db/schemas/mssql_schema.sql
@@ -243,36 +243,36 @@ GO
CREATE TABLE [phpbb_themes_name] (
[themes_id] [int] NOT NULL ,
- [tr_color1_name] [varchar] (25) NULL ,
- [tr_color2_name] [varchar] (25) NULL ,
- [tr_color3_name] [varchar] (25) NULL ,
- [tr_class1_name] [varchar] (25) NULL ,
- [tr_class2_name] [varchar] (25) NULL ,
- [tr_class3_name] [varchar] (25) NULL ,
- [th_color1_name] [varchar] (25) NULL ,
- [th_color2_name] [varchar] (25) NULL ,
- [th_color3_name] [varchar] (25) NULL ,
- [th_class1_name] [varchar] (25) NULL ,
- [th_class2_name] [varchar] (25) NULL ,
- [th_class3_name] [varchar] (25) NULL ,
- [td_color1_name] [varchar] (25) NULL ,
- [td_color2_name] [varchar] (25) NULL ,
- [td_color3_name] [varchar] (25) NULL ,
- [td_class1_name] [varchar] (25) NULL ,
- [td_class2_name] [varchar] (25) NULL ,
- [td_class3_name] [varchar] (25) NULL ,
- [fontface1_name] [varchar] (25) NULL ,
- [fontface2_name] [varchar] (25) NULL ,
- [fontface3_name] [varchar] (25) NULL ,
- [fontsize1_name] [varchar] (25) NULL ,
- [fontsize2_name] [varchar] (25) NULL ,
- [fontsize3_name] [varchar] (25) NULL ,
- [fontcolor1_name] [varchar] (25) NULL ,
- [fontcolor2_name] [varchar] (25) NULL ,
- [fontcolor3_name] [varchar] (25) NULL ,
- [span_class1_name] [varchar] (25) NULL ,
- [span_class2_name] [varchar] (25) NULL ,
- [span_class3_name] [varchar] (25) NULL
+ [tr_color1_name] [varchar] (50) NULL ,
+ [tr_color2_name] [varchar] (50) NULL ,
+ [tr_color3_name] [varchar] (50) NULL ,
+ [tr_class1_name] [varchar] (50) NULL ,
+ [tr_class2_name] [varchar] (50) NULL ,
+ [tr_class3_name] [varchar] (50) NULL ,
+ [th_color1_name] [varchar] (50) NULL ,
+ [th_color2_name] [varchar] (50) NULL ,
+ [th_color3_name] [varchar] (50) NULL ,
+ [th_class1_name] [varchar] (50) NULL ,
+ [th_class2_name] [varchar] (50) NULL ,
+ [th_class3_name] [varchar] (50) NULL ,
+ [td_color1_name] [varchar] (50) NULL ,
+ [td_color2_name] [varchar] (50) NULL ,
+ [td_color3_name] [varchar] (50) NULL ,
+ [td_class1_name] [varchar] (50) NULL ,
+ [td_class2_name] [varchar] (50) NULL ,
+ [td_class3_name] [varchar] (50) NULL ,
+ [fontface1_name] [varchar] (50) NULL ,
+ [fontface2_name] [varchar] (50) NULL ,
+ [fontface3_name] [varchar] (50) NULL ,
+ [fontsize1_name] [varchar] (50) NULL ,
+ [fontsize2_name] [varchar] (50) NULL ,
+ [fontsize3_name] [varchar] (50) NULL ,
+ [fontcolor1_name] [varchar] (50) NULL ,
+ [fontcolor2_name] [varchar] (50) NULL ,
+ [fontcolor3_name] [varchar] (50) NULL ,
+ [span_class1_name] [varchar] (50) NULL ,
+ [span_class2_name] [varchar] (50) NULL ,
+ [span_class3_name] [varchar] (50) NULL
) ON [PRIMARY]
GO
@@ -615,7 +615,7 @@ GO
CREATE INDEX [IX_phpbb_privmsgs] ON [phpbb_privmsgs]([privmsgs_from_userid], [privmsgs_to_userid]) ON [PRIMARY]
GO
- CREATE INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_max], [rank_special]) ON [PRIMARY]
+ CREATE INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_special]) ON [PRIMARY]
GO
CREATE INDEX [IX_phpbb_search_results] ON [phpbb_search_results]([session_id]) ON [PRIMARY]