1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
--
-- 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;
|
