Index: openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql	17 Oct 2003 00:39:22 -0000	1.5
+++ openacs-4/packages/lars-blogger/sql/oracle/lars-blogger-create.sql	14 Dec 2003 11:10:43 -0000	1.6
@@ -45,7 +45,6 @@
                                 constraint pinds_blog_entr_cnt_format_nn
                                 not null,
     entry_date                  date,
-    posted_date                 date,
     draft_p                     char(1) default 'f'
                                 constraint pinds_blog_entries_draft_ck
                                 check (draft_p in ('t','f')),
@@ -84,7 +83,20 @@
   unique (package_id, user_id)
 );
 
+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          varchar2(500)
+                    constraint weblogger_ping_urls_ping_url_nn
+                    not null,
+  creation_date     date default sysdate,
+  constraint weblogger_ping_urls_pk
+  primary key(package_id, ping_url)
+);
 
+
 @@ lars-blogger-package-create
 @@ rss-register
 @@ notifications-init
