Index: openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql,v
diff -u -r1.13 -r1.14
--- openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql	22 Sep 2003 11:49:01 -0000	1.13
+++ openacs-4/packages/acs-lang/sql/postgresql/message-catalog.sql	11 Dec 2003 21:39:53 -0000	1.14
@@ -27,9 +27,6 @@
                        on delete cascade
                        constraint lang_message_keys_package_key_nn
                        not null,
-    upgrade_status     varchar(30)
-                       constraint lang_message_keys_us_ck
-                       check (upgrade_status in ('no_upgrade', 'added','deleted')),
     description        text,
     constraint lang_message_keys_pk
     primary key (message_key, package_key)
@@ -48,6 +45,9 @@
                        constraint lang_messages_locale_nn
                        not null,
     message            text,
+    deleted_p          boolean default 'f',
+    sync_time          timestamptz,
+    conflict_p         boolean default 'f',
     upgrade_status     varchar(30)
                        constraint lang_messages_us_ck
                        check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated')),
@@ -77,10 +77,15 @@
                        references ad_locales(locale)
                        constraint lang_messages_audit_l_nn
                        not null,
-
     -- The old, overwritten message, not the new message being
     -- entered on this date by this user.
     old_message        text,
+    deleted_p          boolean default 'f',
+    sync_time          timestamptz,
+    conflict_p         boolean default 'f',
+    upgrade_status     varchar(30)
+                       constraint lang_messages_us_ck
+                       check (upgrade_status in ('no_upgrade', 'added', 'deleted', 'updated')),
     comment_text       text,
     overwrite_date     timestamptz 
                        default now() 
@@ -141,5 +146,3 @@
 );
 
 end;
-
-