Index: openacs-4/packages/acs-events/acs-events.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/acs-events.info,v
diff -u -r1.29 -r1.30
--- openacs-4/packages/acs-events/acs-events.info 4 Jul 2018 17:26:55 -0000 1.29
+++ openacs-4/packages/acs-events/acs-events.info 11 Jul 2018 16:21:58 -0000 1.30
@@ -7,14 +7,14 @@
f
t
-
+
OpenACS
API support for relationships between intervals in time, activities, and parties.
2017-08-06
OpenACS
The events service is primarily intended for use by writers of application packages and other service packages. The service allows developers to specify and manipulate relationships (possibly recurring) between an object and another object.
2
-
+
Index: openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql,v
diff -u -r1.24 -r1.25
--- openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 4 Jul 2018 17:26:55 -0000 1.24
+++ openacs-4/packages/acs-events/sql/postgresql/acs-events-create.sql 11 Jul 2018 16:21:58 -0000 1.25
@@ -26,12 +26,12 @@
-- Event object
PERFORM acs_object_type__create_type (
- 'acs_event', -- object_type
+ 'acs_event', -- object_type
'ACS Event', -- pretty_name
'ACS Events', -- pretty_plural
- 'acs_object', -- supertype
- 'ACS_EVENTS', -- table_name
- 'EVENT_ID', -- id_column
+ 'acs_object', -- supertype
+ 'acs_events', -- table_name
+ 'event_id', -- id_column
null, -- package_name (default)
'f', -- abstract_p (default)
null, -- type_extension_table (default)
Index: openacs-4/packages/acs-events/sql/postgresql/activity-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/activity-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-events/sql/postgresql/activity-create.sql 4 Jul 2018 17:26:55 -0000 1.8
+++ openacs-4/packages/acs-events/sql/postgresql/activity-create.sql 11 Jul 2018 16:21:58 -0000 1.9
@@ -25,8 +25,8 @@
'Activity', -- pretty_name
'Activities', -- pretty_plural
'acs_object', -- supertype
- 'ACS_ACTIVITIES', -- table_name
- 'ACTIVITY_ID', -- id_column
+ 'acs_activities', -- table_name
+ 'activity_id', -- id_column
'null', -- package_name (default)
'f', -- abstract_p (default)
null, -- type_extension_table (default)
Index: openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-events/sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql 11 Jul 2018 16:21:58 -0000 1.1
@@ -0,0 +1,8 @@
+
+DO $$
+BEGIN
+ update acs_object_types set
+ table_name = lower(table_name),
+ id_column = lower(id_column)
+ where object_type in ('acs_activity', 'acs_event');
+END$$;