[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_schema.sql,1.6,1.7 mssql_schema.sql,1.8,1.9

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv31665/db/schemas

Modified Files:
	mysql_schema.sql mssql_schema.sql 
Log Message:
Fixed bug #490611

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** mysql_schema.sql	2001/12/10 21:53:27	1.6
--- mysql_schema.sql	2001/12/11 02:41:47	1.7
***************
*** 427,431 ****
     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,
     PRIMARY KEY (topic_id),
     KEY forum_id (forum_id),
--- 427,431 ----
     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 DEFAULT '0' NOT NULL,
     PRIMARY KEY (topic_id),
     KEY forum_id (forum_id),

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -r1.8 -r1.9
*** mssql_schema.sql	2001/12/01 01:20:10	1.8
--- mssql_schema.sql	2001/12/11 02:41:47	1.9
***************
*** 288,292 ****
  	[topic_type] [smallint] NOT NULL ,
  	[topic_vote] [smallint] NOT NULL ,
! 	[topic_last_post_id] [int] NULL ,
  	[topic_moved_id] [int] NULL 
  ) ON [PRIMARY]
--- 288,292 ----
  	[topic_type] [smallint] NOT NULL ,
  	[topic_vote] [smallint] NOT NULL ,
! 	[topic_last_post_id] [int] NOT NULL ,
  	[topic_moved_id] [int] NULL 
  ) ON [PRIMARY]
***************
*** 561,565 ****
  	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]
  GO
  
--- 561,566 ----
  	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_moved_id] DEFAULT (0) FOR topic_moved_id
  GO