[Phpbb-checkins] CVS: phpBB2/db/schemas postgres_schema.sql,1.9,1.10

[Doug K. <dou...@us...>]

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

Modified Files:
	postgres_schema.sql 
Log Message:
Ok, fixing a PostgreSQL bug in the Schema file, prevented install

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -r1.9 -r1.10
*** postgres_schema.sql	2001/12/14 18:19:20	1.9
--- postgres_schema.sql	2001/12/15 01:22:55	1.10
***************
*** 305,309 ****
     themes_id int4 DEFAULT nextval('phpbb_themes_id_seq'::text) NOT NULL,
     style_name varchar(30),
!    template_name varchar(30) NOT NULL default '',
     head_stylesheet varchar(100),
     body_background varchar(100),
--- 305,309 ----
     themes_id int4 DEFAULT nextval('phpbb_themes_id_seq'::text) NOT NULL,
     style_name varchar(30),
!    template_name varchar(30) NOT NULL DEFAULT '',
     head_stylesheet varchar(100),
     body_background varchar(100),
***************
*** 403,407 ****
     topic_vote int2 DEFAULT '0' NOT NULL,
     topic_type int2 DEFAULT '0' NOT NULL,
!    topic_moved_id DEFAULT '0' NOT NULL int4,
     topic_last_post_id int4 DEFAULT '0' NOT NULL,
     CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id)
--- 403,407 ----
     topic_vote int2 DEFAULT '0' NOT NULL,
     topic_type int2 DEFAULT '0' NOT NULL,
!    topic_moved_id int4 DEFAULT '0' NOT NULL,
     topic_last_post_id int4 DEFAULT '0' NOT NULL,
     CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id)