Index: openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-create.sql,v
diff -u -N -r1.9 -r1.10
--- openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-create.sql	8 Dec 2003 05:10:23 -0000	1.9
+++ openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-create.sql	13 Dec 2003 20:02:28 -0000	1.10
@@ -79,6 +79,21 @@
   unique (package_id, user_id)
 );
 
+-- Add a table for ping URLs i.e. services that use the weblogs.com
+-- ping interface.
+create table weblogger_ping_urls (
+    package_id      integer
+                    constraint weblogger_ping_urls_package_id_fk
+                        references apm_packages(package_id)
+			on delete cascade,
+    ping_url        varchar(500)
+                    constraint weblogger_ping_urls_ping_url_nn
+                        not null,
+    creation_date   timestamptz default now(),
+    constraint weblogger_ping_urls_pk
+        primary key(package_id, ping_url)
+);
+
 \i lars-blogger-pb.sql
 
 \i rss-register.sql
