1 CREATE TABLE frs_dlstats_file(
8 DROP TABLE cache_store;
10 ALTER TABLE users ADD COLUMN jabber_address text;
11 ALTER TABLE users ADD COLUMN jabber_only int;
14 drop table stats_ftp_downloads;
15 drop table stats_http_downloads;
20 CREATE INDEX groupcvshistory_groupid ON group_cvs_history(group_id);
25 DROP INDEX forum_forumid_isfollowupto;
26 CREATE VIEW forum_user_vw AS select forum.*,users.user_name,users.realname
27 FROM forum,users WHERE forum.posted_by=users.user_id;
28 CREATE VIEW forum_group_list_vw AS SELECT forum_group_list.*, forum_agg_msg_count.count as total
29 FROM forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id);
30 ALTER TABLE forum_group_list ADD CONSTRAINT forumgrouplist_groupid
31 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL ON DELETE CASCADE;
32 ALTER TABLE forum ADD CONSTRAINT forum_groupforumid
33 FOREIGN KEY (group_forum_id) REFERENCES forum_group_list(group_forum_id) MATCH FULL ON DELETE CASCADE;
34 ALTER TABLE forum ADD CONSTRAINT forum_userid
35 FOREIGN KEY (posted_by) REFERENCES users(user_id) MATCH FULL;
38 -- Don't leave it empty
40 update users set realname='Nobody' where user_id=100;