diff options
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 56 |
1 files changed, 30 insertions, 26 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index a6d1b7bfa7..241fdc3be8 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -676,6 +676,7 @@ CREATE TABLE [phpbb_posts] ( [post_attachment] [int] DEFAULT (0) NOT NULL , [bbcode_bitfield] [varbinary] (255) DEFAULT (0x) NOT NULL , [bbcode_uid] [varchar] (5) DEFAULT ('') NOT NULL , + [post_postcount] [int] DEFAULT (1) NOT NULL , [post_edit_time] [int] DEFAULT (0) NOT NULL , [post_edit_reason] [varchar] (3000) DEFAULT ('') NOT NULL , [post_edit_user] [int] DEFAULT (0) NOT NULL , @@ -706,6 +707,9 @@ GO CREATE INDEX [post_approved] ON [phpbb_posts]([post_approved]) ON [PRIMARY] GO +CREATE INDEX [post_postcount] ON [phpbb_posts]([post_postcount]) ON [PRIMARY] +GO + CREATE INDEX [post_time] ON [phpbb_posts]([post_time]) ON [PRIMARY] GO @@ -1246,41 +1250,41 @@ CREATE TABLE [phpbb_styles_imageset] ( [sub_forum_new] [varchar] (200) DEFAULT ('') NOT NULL , [folder] [varchar] (200) DEFAULT ('') NOT NULL , [folder_moved] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_new_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_hot] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_hot_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_hot_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_hot_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_hot_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_announce] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_announce_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_announce_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_announce_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_global] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_global_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_global_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_global_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_sticky] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_sticky_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_sticky_posted] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_locked_sticky_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_hot_new_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_new] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_new_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_announce] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_announce_new] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_announce_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_announce_new_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_global] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_global_new] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_global_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_global_new_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_sticky] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_sticky_new] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_sticky_post] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_lock_sticky_new_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_sticky] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_sticky_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_sticky_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_sticky_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_sticky_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_sticky_new_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_announce] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_announce_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_announce_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_announce_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_announce_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_announce_new_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_global] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_global_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_global_post] [varchar] (200) DEFAULT ('') NOT NULL , [folder_global_new] [varchar] (200) DEFAULT ('') NOT NULL , - [folder_global_new_posted] [varchar] (200) DEFAULT ('') NOT NULL , + [folder_global_new_post] [varchar] (200) DEFAULT ('') NOT NULL , [poll_left] [varchar] (200) DEFAULT ('') NOT NULL , [poll_center] [varchar] (200) DEFAULT ('') NOT NULL , [poll_right] [varchar] (200) DEFAULT ('') NOT NULL , |