diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-11 02:41:47 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-11 02:41:47 +0000 |
| commit | dea6471387ccac1bf09a28bf36c8b75852b8409d (patch) | |
| tree | 71dc7da2a3b4fdd20511ad244b1802a89c887c2a /phpBB/db | |
| parent | 1e11060934f95a1e347179f95497544ddbc29592 (diff) | |
| download | forums-dea6471387ccac1bf09a28bf36c8b75852b8409d.tar forums-dea6471387ccac1bf09a28bf36c8b75852b8409d.tar.gz forums-dea6471387ccac1bf09a28bf36c8b75852b8409d.tar.bz2 forums-dea6471387ccac1bf09a28bf36c8b75852b8409d.tar.xz forums-dea6471387ccac1bf09a28bf36c8b75852b8409d.zip | |
Fixed bug #490611
git-svn-id: file:///svn/phpbb/trunk@1551 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -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), |