gforge-db-postgresql 5.1.1-2 / usr / share / gforge / db / 20031124.sql

--
--	Making system oracle-safe
--
ALTER TABLE forum RENAME date TO post_date;

DROP VIEW forum_group_list_vw;
CREATE VIEW forum_group_list_vw AS
SELECT forum_group_list.*, forum_agg_msg_count.count as total,
    (SELECT max(post_date) AS recent FROM forum WHERE group_forum_id=forum_group_list.group_forum_id) AS recent,
    (SELECT count(*) FROM
        (SELECT thread_id
            FROM forum
            WHERE group_forum_id=forum_group_list.group_forum_id GROUP BY thread_id) as tmp) AS threads
    FROM forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id);


DROP VIEW forum_user_vw;
CREATE VIEW forum_user_vw AS select forum.*,users.user_name,users.realname
        FROM forum,users WHERE forum.posted_by=users.user_id;

ALTER TABLE session RENAME TO user_session;

ALTER TABLE news_bytes RENAME date TO post_date;

ALTER TABLE people_job RENAME date TO post_date;

ALTER TABLE snippet_package_version RENAME date TO post_date;

ALTER TABLE snippet_version RENAME date TO post_date;

ALTER TABLE survey_rating_response RENAME date TO post_date;

ALTER TABLE survey_responses RENAME date TO post_date;

ALTER TABLE group_history RENAME date TO adddate;