[Phpbb-checkins] CVS: phpBB2/db postgres_basic.sql,1.13,1.14

[Jonathan H. <the...@us...>]

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

Modified Files:
	postgres_basic.sql 
Log Message:
modified to make compatible with postgres 7.0, still works with 7.1


Index: postgres_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/postgres_basic.sql,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -r1.13 -r1.14
*** postgres_basic.sql	2001/10/11 22:26:01	1.13
--- postgres_basic.sql	2001/10/15 16:08:59	1.14
***************
*** 86,94 ****
  
  -- Demo Topic
! INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_last_post_id) VALUES (1, 'Welcome to phpBB 2', 2, EXTRACT(EPOCH FROM TIMESTAMP 'now'), 0, 0, 1, 0, 0, 1);
  
  
  -- Demo Post
! INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, EXTRACT(EPOCH FROM TIMESTAMP 'now'), '', '7F000001');
  INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, '', 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
  
--- 86,94 ----
  
  -- Demo Topic
! INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_last_post_id) VALUES (1, 'Welcome to phpBB 2', 2, date_part('EPOCH', TIMESTAMP 'now'), 0, 0, 1, 0, 0, 1);
  
  
  -- Demo Post
! INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, date_part('EPOCH', TIMESTAMP 'now'), '', '7F000001');
  INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, '', 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');