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 -N -r1.5 -r1.6 --- openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql 14 Dec 2003 13:02:38 -0000 1.5 +++ openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-1.0a3-1.0a4.sql 14 Dec 2003 16:26:26 -0000 1.6 @@ -191,3 +191,16 @@ return v_entry_id; end; ' language 'plpgsql'; + +-- Cache for the Technorati API calls +create table weblogger_technorati_cache ( + package_id integer + constraint weblogger_ping_urls_package_id_fk + references apm_packages(package_id) + on delete cascade, + name varchar(500), + url varchar(500), + creation_date timestamptz + default now() +); +