2 -- Making system oracle-safe
4 ALTER TABLE forum RENAME date TO post_date;
6 DROP VIEW forum_group_list_vw;
7 CREATE VIEW forum_group_list_vw AS
8 SELECT forum_group_list.*, forum_agg_msg_count.count as total,
9 (SELECT max(post_date) AS recent FROM forum WHERE group_forum_id=forum_group_list.group_forum_id) AS recent,
13 WHERE group_forum_id=forum_group_list.group_forum_id GROUP BY thread_id) as tmp) AS threads
14 FROM forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id);
17 DROP VIEW forum_user_vw;
18 CREATE VIEW forum_user_vw AS select forum.*,users.user_name,users.realname
19 FROM forum,users WHERE forum.posted_by=users.user_id;
21 ALTER TABLE session RENAME TO user_session;
23 ALTER TABLE news_bytes RENAME date TO post_date;
25 ALTER TABLE people_job RENAME date TO post_date;
27 ALTER TABLE snippet_package_version RENAME date TO post_date;
29 ALTER TABLE snippet_version RENAME date TO post_date;
31 ALTER TABLE survey_rating_response RENAME date TO post_date;
33 ALTER TABLE survey_responses RENAME date TO post_date;
35 ALTER TABLE group_history RENAME date TO adddate;