Index: openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql,v
diff -u -N -r1.2 -r1.2.8.1
--- openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql	28 Mar 2003 10:10:44 -0000	1.2
+++ openacs-4/packages/bug-tracker/sql/oracle/bug-tracker-create-tables.sql	7 Nov 2005 19:40:53 -0000	1.2.8.1
@@ -28,6 +28,9 @@
                                 references cr_folders(folder_id),
   root_keyword_id               integer
                                 constraint bt_projects_keyword_fk
+                                references cr_keywords(keyword_id),
+  component_keyword_id          integer
+                                constraint bt_component_keyword_fk
                                 references cr_keywords(keyword_id)
 );
 
@@ -311,3 +314,17 @@
 
 create index bt_patch_bug_map_patch_id_idx on bt_patch_bug_map(patch_id);
 create index bt_patch_bug_map_bug_id_idx on bt_patch_bug_map(bug_id);
+
+create table bt_keyword_component_map (
+	keyword_id      integer
+		        constraint bt_component_keyword_fk
+                        references cr_keywords(keyword_id),
+	component_id    integer
+                        constraint bt_patches_components_fk
+                        references bt_components(component_id),
+	constraint bt_keyword_component_map_pk
+	primary key (keyword_id, component_id)
+);
+
+create index bt_keyword_component_map_keyword_idx on bt_keyword_component_map(keyword_id);
+create index bt_keyword_component_map_component_idx on bt_keyword_component_map(component_id);