diff options
Diffstat (limited to 'phpBB/db/schemas')
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 5 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 2 |
2 files changed, 4 insertions, 3 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 6c39728549..26c1f870e9 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -287,7 +287,7 @@ CREATE TABLE [phpbb_topics] ( [topic_status] [smallint] NOT NULL , [topic_type] [smallint] NOT NULL , [topic_vote] [smallint] NOT NULL , - [topic_last_post_id] [int] NULL , + [topic_last_post_id] [int] NOT NULL , [topic_moved_id] [int] NULL ) ON [PRIMARY] GO @@ -560,7 +560,8 @@ ALTER TABLE [phpbb_topics] WITH NOCHECK ADD CONSTRAINT [DF_phpbb_topics_topic_replies] DEFAULT (0) FOR [topic_replies], CONSTRAINT [DF_phpbb_topics_topic_status] DEFAULT (0) FOR [topic_status], CONSTRAINT [DF_phpbb_topics_topic_type] DEFAULT (0) FOR [topic_type], - CONSTRAINT [DF_phpbb_topics_topic_vote] DEFAULT (0) FOR [topic_vote] + CONSTRAINT [DF_phpbb_topics_topic_vote] DEFAULT (0) FOR [topic_vote], + CONSTRAINT [DF_phpbb_topics_topic_moved_id] DEFAULT (0) FOR topic_moved_id GO ALTER TABLE [phpbb_users] WITH NOCHECK ADD diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 3d33dfe65f..65c9fe95e0 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -426,7 +426,7 @@ CREATE TABLE phpbb_topics ( topic_vote tinyint(1) DEFAULT '0' NOT NULL, topic_type tinyint(3) DEFAULT '0' NOT NULL, topic_last_post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, - topic_moved_id mediumint(8) UNSIGNED, + topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (topic_id), KEY forum_id (forum_id), KEY topic_moved_id (topic_moved_id), |