diff options
| author | the_systech <the_systech@users.sourceforge.net> | 2001-10-15 16:08:59 +0000 |
|---|---|---|
| committer | the_systech <the_systech@users.sourceforge.net> | 2001-10-15 16:08:59 +0000 |
| commit | 0aec2082eb551192b09eaa3561cc10dd9f99db7c (patch) | |
| tree | 32a4ca1c20ac108c2f06fcfb5017bb10a2321d2f /phpBB | |
| parent | 4e6cff3a80ab54de0aff1844947990ffaedb7526 (diff) | |
| download | forums-0aec2082eb551192b09eaa3561cc10dd9f99db7c.tar forums-0aec2082eb551192b09eaa3561cc10dd9f99db7c.tar.gz forums-0aec2082eb551192b09eaa3561cc10dd9f99db7c.tar.bz2 forums-0aec2082eb551192b09eaa3561cc10dd9f99db7c.tar.xz forums-0aec2082eb551192b09eaa3561cc10dd9f99db7c.zip | |
modified to make compatible with postgres 7.0, still works with 7.1
git-svn-id: file:///svn/phpbb/trunk@1206 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB')
| -rwxr-xr-x | phpBB/db/postgres_basic.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/db/postgres_basic.sql b/phpBB/db/postgres_basic.sql index b1a94e54cc..8a85a51a51 100755 --- a/phpBB/db/postgres_basic.sql +++ b/phpBB/db/postgres_basic.sql @@ -85,11 +85,11 @@ INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0); -- 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); +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, EXTRACT(EPOCH FROM TIMESTAMP 'now'), '', '7F000001'); +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!'); |