Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql 10 Sep 2003 08:40:58 -0000 1.5 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.0d2-5.0d3.sql 30 Sep 2003 12:48:00 -0000 1.6 @@ -20,6 +20,7 @@ unique, pretty_name varchar2(4000), help_contact_text varchar2(4000), + help_contact_text_format varchar(200), enabled_p char(1) default 't' constraint auth_authority_enabled_p_nn not null @@ -47,12 +48,6 @@ get_doc_impl_id integer references acs_objects(object_id), -- Id of service contract processing batch sync doc process_doc_impl_id integer references acs_objects(object_id), - -- Are batch syncs snapshots or of incremental type - snapshot_p char(1) default 'f' - constraint auth_authority_snapshot_p_nn - not null - constraint auth_authority_snapshot_p_ck - check (snapshot_p in ('t','f')), batch_sync_enabled_p char(1) default 'f' constraint auth_authority_bs_enabled_p_nn not null Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql 30 Sep 2003 09:32:48 -0000 1.6 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d2-5.0d3.sql 30 Sep 2003 12:48:00 -0000 1.7 @@ -20,6 +20,7 @@ unique, pretty_name varchar(4000), help_contact_text varchar(4000), + help_contact_text_format varchar(200), enabled_p boolean default 't' constraint auth_authority_enabled_p_nn not null, @@ -45,10 +46,6 @@ get_doc_impl_id integer references acs_objects(object_id), -- Id of service contract processing batch sync doc process_doc_impl_id integer references acs_objects(object_id), - -- Are batch syncs snapshots or of incremental type - snapshot_p boolean default 'f' - constraint auth_authority_snapshot_p_nn - not null, batch_sync_enabled_p boolean default 'f' constraint auth_authority_bs_enabled_p_nn not null @@ -174,7 +171,6 @@ return 0; end;' language 'plpgsql'; - -- Create the local authority select authority__new( null, -- authority_id