Index: openacs-4/contrib/packages/classified-ads/sql/postgresql/attributes-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/classified-ads/sql/postgresql/attributes-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/classified-ads/sql/postgresql/attributes-create.sql	16 Jul 2003 04:52:31 -0000	1.1
+++ openacs-4/contrib/packages/classified-ads/sql/postgresql/attributes-create.sql	24 Jul 2003 00:11:03 -0000	1.2
@@ -63,7 +63,21 @@
                         constraint ca_awv_widget_nn
                         not null,
     label               varchar(200),
+    --
+    -- RBM: We have keyword_id here so we can have per-category
+    --      custom fields. Selling books requires ISBN, but motorcycles
+    --      requires something else.
+    --
+    keyword_id		integer
+    			constraint ca_awv_keyword_id_fk
+			references cr_keywords(keyword_id)
+			constraint ca_awv_keyword_id_nn
+			not null,
     html_options        varchar(400),
+    --
+    -- RBM: If this is not null, use the form builder's -help_text.
+    --
+    help_text		text,
     select_options      text,
     validate            text,
     optional_p          char(1)