1 DROP TABLE artifact_category CASCADE;
2 DROP TABLE artifact_group CASCADE;
3 DROP TABLE artifact_resolution CASCADE;
4 ALTER TABLE artifact DROP COLUMN artifact_group_id;
5 ALTER TABLE artifact DROP COLUMN resolution_id;
6 ALTER TABLE artifact DROP COLUMN category_id;
7 ALTER TABLE artifact_group_list DROP COLUMN use_resolution CASCADE;
9 CREATE VIEW artifact_group_list_vw AS
10 SELECT agl.*,aca.count,aca.open_count
11 FROM artifact_group_list agl
12 LEFT JOIN artifact_counts_agg aca USING (group_artifact_id);
14 CREATE VIEW artifact_vw
16 SELECT artifact.artifact_id,
17 artifact.group_artifact_id,
20 artifact.submitted_by,
26 u.user_name AS assigned_unixname,
27 u.realname AS assigned_realname,
28 u.email AS assigned_email,
29 u2.user_name AS submitted_unixname,
30 u2.realname AS submitted_realname,
31 u2.email AS submitted_email,
32 artifact_status.status_name,
33 artifact.last_modified_date
38 WHERE artifact.assigned_to = u.user_id
39 AND artifact.submitted_by = u2.user_id
40 AND artifact.status_id = artifact_status.id;
42 DELETE FROM user_preferences WHERE preference_name LIKE 'art_cust%';