Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql 7 Aug 2017 23:47:56 -0000 1.2 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade--5.9.1d15-5.9.1d16.sql 12 Feb 2022 20:11:02 -0000 1.2.2.1 @@ -1,5 +1,5 @@ -- add extended attribute to rel types -alter table acs_rel_types add column composable_p boolean default 't' not null; +alter table acs_rel_types add composable_p char(1) default 't' not null; update acs_rel_types set composable_p = 'f' where rel_type = 'admin_rel'; create or replace trigger membership_rels_in_tr Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql 25 Aug 2020 13:38:12 -0000 1.1.2.1 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql 12 Feb 2022 20:11:02 -0000 1.1.2.2 @@ -1,5 +1,19 @@ +-- Oracle version of +-- alter table add column ... if exists ... +-- +DECLARE + v_col_exists NUMBER; +BEGIN + SELECT count(*) INTO v_col_exists + FROM user_tab_cols + WHERE column_name = 'OBJECT_ID' + AND table_name = 'LANG_MESSAGE_KEYS'; --- Untested! -alter table lang_message_keys add column if not exists object_id integer + IF (v_col_exists = 0) THEN + EXECUTE IMMEDIATE 'alter table lang_message_keys add object_id integer constraint lang_message_keys_object_id_fk - references acs_objects(object_id) on delete cascade; + references acs_objects(object_id) on delete cascade'; + END IF; +END; +/ + Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.11-0.12.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.11-0.12.sql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.11-0.12.sql 27 Mar 2018 17:08:50 -0000 1.3 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.11-0.12.sql 12 Feb 2022 20:11:02 -0000 1.3.2.1 @@ -1,4 +1,4 @@ -alter table as_item_data add column file_id integer constraint as_item_data_file_id_fk references cr_revisions(revision_id); +alter table as_item_data add file_id integer constraint as_item_data_file_id_fk references cr_revisions(revision_id); insert into as_item_types_map (item_type, display_type) values ('fu', 'f'); -- File Upload Item Index: openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.12-0.13.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.12-0.13.sql,v diff -u -r1.2 -r1.2.12.1 --- openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.12-0.13.sql 12 Jun 2006 02:49:50 -0000 1.2 +++ openacs-4/packages/assessment/sql/oracle/upgrade/upgrade-0.12-0.13.sql 12 Feb 2022 20:11:02 -0000 1.2.12.1 @@ -1 +1 @@ -alter table as_assessments add column type integer; \ No newline at end of file +alter table as_assessments add type integer; Index: openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql 10 Feb 2021 13:36:55 -0000 1.1.2.1 +++ openacs-4/packages/bulk-mail/sql/oracle/upgrade/upgrade-2.10.0d2-2.10.0d3.sql 12 Feb 2022 20:11:02 -0000 1.1.2.2 @@ -1,5 +1,5 @@ -alter table bulk_mail_messages add column to_display_name text; +alter table bulk_mail_messages add to_display_name text; drop view bulk_mail_messages_unsent; Index: openacs-4/packages/chat/sql/oracle/upgrade/upgrade-5.0.1d6-5.0.1d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/chat/sql/oracle/upgrade/upgrade-5.0.1d6-5.0.1d7.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/chat/sql/oracle/upgrade/upgrade-5.0.1d6-5.0.1d7.sql 28 Feb 2019 16:09:03 -0000 1.1.2.1 +++ openacs-4/packages/chat/sql/oracle/upgrade/upgrade-5.0.1d6-5.0.1d7.sql 12 Feb 2022 20:11:02 -0000 1.1.2.2 @@ -3,7 +3,7 @@ drop package chat_room; drop package chat_transcript; - alter table chat_rooms add column messages_time_window integer default 600; + alter table chat_rooms add messages_time_window integer default 600; alter table chat_rooms drop constraint chat_rooms_room_id_fk; alter table chat_rooms add constraint chat_rooms_room_id_fk Index: openacs-4/packages/faq/sql/oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/faq/sql/oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql 29 Jan 2019 17:10:34 -0000 1.1 +++ openacs-4/packages/faq/sql/oracle/upgrade/upgrade-5.10.0d5-5.10.0d6.sql 12 Feb 2022 20:11:02 -0000 1.1.2.1 @@ -47,12 +47,12 @@ -- This is a solution for Oracle in plain SQL, which might sound a bit -- hamfisted... -- - create a temp column with the value of faq_id -alter table faq_q_and_as add column tmp_faq_id integer; +alter table faq_q_and_as add tmp_faq_id integer; update faq_q_and_as set tmp_faq_id = faq_id; -- - drop faq_id column alter table faq_q_and_as drop column faq_id; -- - re-create it with values stored in temp column -alter table faq_q_and_as add column faq_id integer; +alter table faq_q_and_as add faq_id integer; update faq_q_and_as set faq_id = tmp_faq_id; -- - update constraints alter table faq_q_and_as alter column faq_id set not null; Index: openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3-1.3d1.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3-1.3d1.sql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3-1.3d1.sql 27 Sep 2017 11:07:52 -0000 1.1 +++ openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3-1.3d1.sql 12 Feb 2022 20:11:02 -0000 1.1.2.1 @@ -1,7 +1,7 @@ begin; alter table forums_forums - add column new_questions_allowed_p char(1) + add new_questions_allowed_p char(1) default 't' constraint forums_new_questions_allowed_p_nn not null Index: openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql 13 Nov 2017 12:52:59 -0000 1.2 +++ openacs-4/packages/forums/sql/oracle/upgrade/upgrade-1.3.1d2-1.3.1d3.sql 12 Feb 2022 20:11:02 -0000 1.2.2.1 @@ -13,7 +13,7 @@ drop table forums_reading_info_user; alter table forums_reading_info - add column forum_id integer + add forum_id integer constraint forum_read_forum_id_fk references forums_forums (forum_id) on delete cascade;