Index: openacs-4/packages/faq/faq.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq/faq.info,v diff -u -r1.30 -r1.31 --- openacs-4/packages/faq/faq.info 17 May 2018 13:40:59 -0000 1.30 +++ openacs-4/packages/faq/faq.info 12 Jul 2018 08:51:04 -0000 1.31 @@ -7,7 +7,7 @@ f f - + Nima Mazloumi Jennie Kim Housman Elizabeth Wirth @@ -18,7 +18,7 @@ 2 #faq.FAQs# - + Index: openacs-4/packages/faq/sql/postgresql/faq-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-create.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/faq/sql/postgresql/faq-create.sql 7 Aug 2017 23:48:10 -0000 1.8 +++ openacs-4/packages/faq/sql/postgresql/faq-create.sql 12 Jul 2018 08:51:04 -0000 1.9 @@ -11,8 +11,8 @@ 'FAQ', -- pretty_name 'FAQs', -- pretty_plural 'acs_object', -- supertype - 'FAQS', -- table_name - 'FAQ_ID', -- id_column + 'faqs', -- table_name + 'faq_id', -- id_column null, -- package_name 'f', -- abstract_p null, -- type_extension_table @@ -46,8 +46,8 @@ 'FAQ_Q_and_A', -- pretty_name 'FAQ_Q_and_As', -- pretty_plural 'acs_object', -- supertype - 'FAQ_Q_AND_AS', -- table_name - 'ENTRY_ID', -- id_column + 'faq_q_and_as', -- table_name + 'entry_id', -- id_column null, -- package_name 'f', -- abstract_p null, -- type_extension_table Index: openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.10.0d2-5.10.0d3.sql 12 Jul 2018 08:51:04 -0000 1.1 @@ -0,0 +1,9 @@ + + +DO $$ +BEGIN + update acs_object_types set + table_name = lower(table_name), + id_column = lower(id_column) + where object_type in ('faq', 'faq_q_and_a'); +END$$;