diff options
Diffstat (limited to 'phpBB/db/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 190 |
1 files changed, 0 insertions, 190 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index f88e506ae0..6c39728549 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -9,142 +9,6 @@ BEGIN TRANSACTION GO -if exists (select * from dbo.sysobjects where id = object_id(N'[FK_phpbb_user_group_phpbb_groups]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) -ALTER TABLE [phpbb_user_group] DROP CONSTRAINT FK_phpbb_user_group_phpbb_groups -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[FK_phpbb_posts_text_phpbb_posts]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) -ALTER TABLE [phpbb_posts_text] DROP CONSTRAINT FK_phpbb_posts_text_phpbb_posts -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[FK_phpbb_privmsgs_text_phpbb_privmsgs]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) -ALTER TABLE [phpbb_privmsgs_text] DROP CONSTRAINT FK_phpbb_privmsgs_text_phpbb_privmsgs -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[FK_phpbb_search_wordmatch_phpbb_search_wordlist]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) -ALTER TABLE [phpbb_search_wordmatch] DROP CONSTRAINT FK_phpbb_search_wordmatch_phpbb_search_wordlist -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[FK_phpbb_themes_name_phpbb_themes]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) -ALTER TABLE [phpbb_themes_name] DROP CONSTRAINT FK_phpbb_themes_name_phpbb_themes -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[FK_phpbb_topics_watch_phpbb_topics]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) -ALTER TABLE [phpbb_topics_watch] DROP CONSTRAINT FK_phpbb_topics_watch_phpbb_topics -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_auth_access]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_auth_access] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_banlist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_banlist] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_categories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_categories] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_config] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_disallow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_disallow] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_forum_prune]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_forum_prune] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_forums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_forums] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_groups] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_posts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_posts] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_posts_text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_posts_text] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_privmsgs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_privmsgs] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_privmsgs_text]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_privmsgs_text] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_ranks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_ranks] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_search_results]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_search_results] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_search_wordlist]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_search_wordlist] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_search_wordmatch]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_search_wordmatch] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_sessions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_sessions] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_smilies]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_smilies] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_themes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_themes] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_themes_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_themes_name] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_topics]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_topics] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_topics_watch]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_topics_watch] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_user_group]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_user_group] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_users] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_vote_desc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_vote_desc] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_vote_results]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_vote_results] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_vote_voters]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_vote_voters] -GO - -if exists (select * from dbo.sysobjects where id = object_id(N'[phpbb_words]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) -drop table [phpbb_words] -GO - CREATE TABLE [phpbb_auth_access] ( [group_id] [int] NULL , [forum_id] [int] NULL , @@ -789,59 +653,5 @@ GO CREATE INDEX [IX_phpbb_vote_voters_1] ON [phpbb_vote_voters]([vote_user_id]) ON [PRIMARY] GO -ALTER TABLE [phpbb_posts_text] ADD - CONSTRAINT [FK_phpbb_posts_text_phpbb_posts] FOREIGN KEY - ( - [post_id] - ) REFERENCES [phpbb_posts] ( - [post_id] - ) -GO - -ALTER TABLE [phpbb_privmsgs_text] ADD - CONSTRAINT [FK_phpbb_privmsgs_text_phpbb_privmsgs] FOREIGN KEY - ( - [privmsgs_text_id] - ) REFERENCES [phpbb_privmsgs] ( - [privmsgs_id] - ) -GO - -ALTER TABLE [phpbb_search_wordmatch] ADD - CONSTRAINT [FK_phpbb_search_wordmatch_phpbb_search_wordlist] FOREIGN KEY - ( - [word_id] - ) REFERENCES [phpbb_search_wordlist] ( - [word_id] - ) -GO - -ALTER TABLE [phpbb_themes_name] ADD - CONSTRAINT [FK_phpbb_themes_name_phpbb_themes] FOREIGN KEY - ( - [themes_id] - ) REFERENCES [phpbb_themes] ( - [themes_id] - ) -GO - -ALTER TABLE [phpbb_topics_watch] ADD - CONSTRAINT [FK_phpbb_topics_watch_phpbb_topics] FOREIGN KEY - ( - [topic_id] - ) REFERENCES [phpbb_topics] ( - [topic_id] - ) -GO - -ALTER TABLE [phpbb_user_group] ADD - CONSTRAINT [FK_phpbb_user_group_phpbb_groups] FOREIGN KEY - ( - [group_id] - ) REFERENCES [phpbb_groups] ( - [group_id] - ) -GO - COMMIT GO |