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$$;