Index: openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql,v diff -u -r1.5 -r1.5.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql 16 Sep 2002 21:52:41 -0000 1.5 +++ openacs-4/packages/acs-kernel/sql/oracle/acs-metadata-create.sql 26 Feb 2003 21:39:15 -0000 1.5.2.1 @@ -246,6 +246,16 @@ values ('enumeration', null); + insert into acs_datatypes + (datatype, max_n_values) + values + ('url', null); + + insert into acs_datatypes + (datatype, max_n_values) + values + ('email', null); + commit; end; / Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/Attic/upgrade-4.6-4.6.1.sql,v diff -u -r1.1.2.9 -r1.1.2.10 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql 26 Feb 2003 02:22:49 -0000 1.1.2.9 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-4.6-4.6.1.sql 26 Feb 2003 21:38:36 -0000 1.1.2.10 @@ -1,7 +1,20 @@ +-- Add two new datatypes (supported by templating already). +-- + insert into acs_datatypes + (datatype, max_n_values) + values + ('url', null); + + insert into acs_datatypes + (datatype, max_n_values) + values + ('email', null); + -- This giant package body is here since we are adding -- two lines to acs_object.delete() to delete direct permissions -- granted on the object which we are deleting -- + create or replace package body acs_object as Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql,v diff -u -r1.15.2.2 -r1.15.2.3 --- openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 22 Jan 2003 02:26:35 -0000 1.15.2.2 +++ openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql 26 Feb 2003 21:37:55 -0000 1.15.2.3 @@ -338,7 +338,17 @@ values (''enumeration'', null); + insert into acs_datatypes + (datatype, max_n_values) + values + (''url'', null); + insert into acs_datatypes + (datatype, max_n_values) + values + (''email'', null); + + return 0; end;' language 'plpgsql'; Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-4.6-4.6.1.sql,v diff -u -r1.1.2.7 -r1.1.2.8 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql 26 Feb 2003 03:08:09 -0000 1.1.2.7 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.6-4.6.1.sql 26 Feb 2003 21:37:25 -0000 1.1.2.8 @@ -4,7 +4,19 @@ -- @creation-date 2002-12-17 -- @cvs-id $Id$ +-- Add two new datatypes (supported by templating already). +-- +insert into acs_datatypes + (datatype, max_n_values) +values + ('url', null); + +insert into acs_datatypes + (datatype, max_n_values) +values + ('email', null); + -- declaring this function isstrict,iscachable can make a significant -- performance difference since this is used in some potentially -- expensive queries