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.2
--- 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	3 Sep 2024 15:37:38 -0000	1.2
@@ -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;