Index: openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/upgrade/Attic/upgrade-1.0a3-1.0a4.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql 13 Dec 2003 18:03:35 -0000 1.1 @@ -0,0 +1,14 @@ +-- 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), + 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) +);