Index: openacs-4/packages/download/sql/postgresql/download-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/download-create.sql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/download/sql/postgresql/download-create.sql 12 Sep 2013 10:26:11 -0000 1.8 +++ openacs-4/packages/download/sql/postgresql/download-create.sql 16 Sep 2013 09:19:58 -0000 1.9 @@ -264,8 +264,8 @@ on delete cascade, download_date timestamptz not null, download_hostname varchar(400), - download_ip varchar(20), - user_agent varchar(200), + download_ip varchar(40), + user_agent varchar(500), reason_id integer constraint download_downloads_reason_fl references download_reasons(download_reason_id) Index: openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d1-5.2d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d1-5.2d2.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d1-5.2d2.sql 16 Sep 2013 09:19:58 -0000 1.1 @@ -0,0 +1,8 @@ + +UPDATE pg_attribute a SET atttypmod = 504 from pg_class c + where attname = 'user_agent' and c.oid = attrelid and + relname in ('download_downloads', 'download_downloads_repository'); + +UPDATE pg_attribute a SET atttypmod = 44 from pg_class c + where attname = 'download_ip' c.oid = attrelid and + relname in ('download_downloads', 'download_downloads_repository'); \ No newline at end of file