diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2012-09-28 16:17:21 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2012-09-28 16:17:21 +0200 |
| commit | dc2835af785c6bf0209d91791f27a931fb334a5b (patch) | |
| tree | f3a66315af9c84f7f0e3239289f6bcd93012ab5e /phpBB/install/schemas/mssql_schema.sql | |
| parent | 8b2181eb851081a103802764517f7189ba8fc114 (diff) | |
| download | forums-dc2835af785c6bf0209d91791f27a931fb334a5b.tar forums-dc2835af785c6bf0209d91791f27a931fb334a5b.tar.gz forums-dc2835af785c6bf0209d91791f27a931fb334a5b.tar.bz2 forums-dc2835af785c6bf0209d91791f27a931fb334a5b.tar.xz forums-dc2835af785c6bf0209d91791f27a931fb334a5b.zip | |
[feature/soft-delete] Add columns for soft delete details
PHPBB3-9657
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 37f1618e92..070a504d73 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -819,7 +819,10 @@ CREATE TABLE [phpbb_posts] ( [post_edit_reason] [varchar] (255) DEFAULT ('') NOT NULL , [post_edit_user] [int] DEFAULT (0) NOT NULL , [post_edit_count] [int] DEFAULT (0) NOT NULL , - [post_edit_locked] [int] DEFAULT (0) NOT NULL + [post_edit_locked] [int] DEFAULT (0) NOT NULL , + [post_delete_time] [int] DEFAULT (0) NOT NULL , + [post_delete_reason] [varchar] (255) DEFAULT ('') NOT NULL , + [post_delete_user] [int] DEFAULT (0) NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO @@ -1379,7 +1382,10 @@ CREATE TABLE [phpbb_topics] ( [poll_length] [int] DEFAULT (0) NOT NULL , [poll_max_options] [int] DEFAULT (1) NOT NULL , [poll_last_vote] [int] DEFAULT (0) NOT NULL , - [poll_vote_change] [int] DEFAULT (0) NOT NULL + [poll_vote_change] [int] DEFAULT (0) NOT NULL , + [topic_delete_time] [int] DEFAULT (0) NOT NULL , + [topic_delete_reason] [varchar] (255) DEFAULT ('') NOT NULL , + [topic_delete_user] [int] DEFAULT (0) NOT NULL ) ON [PRIMARY] GO |