diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-05-25 19:21:50 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-05-25 19:21:50 +0000 |
| commit | 8dc9fc089bf3a45bd5f23986d5c9f4992196834f (patch) | |
| tree | 47d04a69a6ae9d220085b96c7a158bd771a1a1b4 | |
| parent | fec41273a4ae2f24ec8beb11dc473222cfd04b53 (diff) | |
| download | forums-8dc9fc089bf3a45bd5f23986d5c9f4992196834f.tar forums-8dc9fc089bf3a45bd5f23986d5c9f4992196834f.tar.gz forums-8dc9fc089bf3a45bd5f23986d5c9f4992196834f.tar.bz2 forums-8dc9fc089bf3a45bd5f23986d5c9f4992196834f.tar.xz forums-8dc9fc089bf3a45bd5f23986d5c9f4992196834f.zip | |
...
git-svn-id: file:///svn/phpbb/trunk@5966 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 98584dc68c..f6c2beae03 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -27,7 +27,7 @@ CREATE TABLE [phpbb_attachments] ( [filesize] [int] NOT NULL , [filetime] [int] NOT NULL , [thumbnail] [int] NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_attachments] WITH NOCHECK ADD @@ -131,7 +131,7 @@ CREATE TABLE [phpbb_auth_roles] ( [role_description] [varchar] (8000) , [role_type] [varchar] (10) NOT NULL , [role_order] [int] NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_auth_roles] WITH NOCHECK ADD @@ -219,7 +219,7 @@ CREATE TABLE [phpbb_banlist] ( [ban_exclude] [int] NOT NULL , [ban_reason] [varchar] (3000) , [ban_give_reason] [varchar] (3000) -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD @@ -309,7 +309,7 @@ CREATE TABLE [phpbb_bots] ( [user_id] [int] NOT NULL , [bot_agent] [varchar] (255) NOT NULL , [bot_ip] [varchar] (255) NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_bots] WITH NOCHECK ADD @@ -904,7 +904,7 @@ CREATE TABLE [phpbb_poll_results] ( [topic_id] [int] NOT NULL , [poll_option_text] [varchar] (3000) , [poll_option_total] [int] NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_poll_results] WITH NOCHECK ADD @@ -1216,7 +1216,7 @@ CREATE TABLE [phpbb_profile_fields] ( [field_no_view] [int] NOT NULL , [field_active] [int] NOT NULL , [field_order] [int] NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_profile_fields] WITH NOCHECK ADD @@ -1393,7 +1393,7 @@ CREATE TABLE [phpbb_reports_reasons] ( [reason_title] [varchar] (255) NOT NULL , [reason_description] [varchar] (8000) , [reason_order] [int] NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_reports_reasons] WITH NOCHECK ADD @@ -1415,7 +1415,7 @@ GO CREATE TABLE [phpbb_search_results] ( [search_key] [varchar] (32) NOT NULL , [search_time] [int] NOT NULL , - [search_keywords] [text] , + [search_keywords] [varchar] (8000) , [search_authors] [text] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO @@ -1950,7 +1950,7 @@ CREATE TABLE [phpbb_topics] ( [poll_max_options] [int] NOT NULL , [poll_last_vote] [int] NULL , [poll_vote_change] [int] NOT NULL -) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] +) ON [PRIMARY] GO ALTER TABLE [phpbb_topics] WITH NOCHECK ADD |