2 -- Add the browse_list field in the artifact_group_list
4 -- This is to support the customization of columns in the
7 -- Alain Peyrat Sep-2006
9 DROP VIEW "artifact_group_list_vw";
11 ALTER TABLE "artifact_group_list" ADD COLUMN "browse_list" text;
12 UPDATE "artifact_group_list"
13 SET browse_list='summary,open_date,assigned_to,submitted_by';
14 ALTER TABLE "artifact_group_list" ALTER COLUMN browse_list SET NOT NULL;
15 ALTER TABLE "artifact_group_list" ALTER COLUMN browse_list
16 SET DEFAULT 'summary,open_date,assigned_to,submitted_by';
18 CREATE VIEW "artifact_group_list_vw" AS
19 SELECT agl.group_artifact_id, agl.group_id, agl.name, agl.description,
20 agl.is_public, agl.allow_anon, agl.email_all_updates, agl.email_address,
21 agl.due_period, agl.submit_instructions, agl.browse_instructions,
22 agl.browse_list, agl.datatype, agl.status_timeout, agl.custom_status_field,
23 agl.custom_renderer, aca.count, aca.open_count
24 FROM artifact_group_list agl
25 LEFT JOIN artifact_counts_agg aca USING (group_artifact_id);