Index: openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-create.sql	5 Apr 2001 18:23:38 -0000	1.1
+++ openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-create.sql	11 Aug 2006 22:23:59 -0000	1.2
@@ -17,19 +17,19 @@
         object_type => 'acs_message',
         pretty_name => 'Message',
         pretty_plural => 'Messages',
-        table_name => 'ACS_MESSAGES',
-        id_column => 'MESSAGE_ID',
-        name_method => 'ACS_MESSAGE.NAME'
+        table_name => 'asc_messages',
+        id_column => 'message_id',
+        name_method => 'acs_message.name'
     );
 
     acs_object_type.create_type (
         supertype => 'content_revision',
         object_type => 'acs_message_revision',
         pretty_name => 'Message Revision',
         pretty_plural => 'Message Revisions',
-        table_name => 'CR_REVISIONS',
-        id_column => 'REVISION_ID',
-        name_method => 'ACS_OBJECT.DEFAULT_NAME'
+        table_name => 'cr_revisions',
+        id_column => 'revision_id',
+        name_method => 'acs_object.default_name'
     );
 
 end;
Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	11 Dec 2003 21:39:54 -0000	1.11
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	11 Aug 2006 22:23:59 -0000	1.12
@@ -15,25 +15,25 @@
     'Message',
     'Messages',
     'content_item',
-    'ACS_MESSAGES',
-    'MESSAGE_ID',
+    'acs_messages',
+    'message_id',
     null,
     'f',
     null,
-    'ACS_MESSAGE.NAME'
+    'acs_message__name'
 );
 
 select acs_object_type__create_type (
     'acs_message_revision',
     'Message Revision',
     'Message Revisions',
     'content_revision',
-    'CR_REVISIONS',
-    'REVISION_ID',
+    'cr_revisions',
+    'revision_id',
     null,
     'f',
     null,
-    'ACS_OBJECT.DEFAULT_NAME'
+    'acs_object__default_name'
 );