supply an output column list in site_users_to_member.sql

otherwise SQL assumes all columns in the table, which will be incorrect
as we add columns to bse_siteusers.

diff --git a/schema/site_users_to_members.sql b/schema/site_users_to_members.sql
index 242210dbb6347daceb1d1dd255a52f78f4693874..bd816f676f8462c1243d5781cc01f9bf788351d0 100644 (file)
--- a/schema/site_users_to_members.sql
+++ b/schema/site_users_to_members.sql
@@ -11,7 +11,17 @@ begin
   if sucount <> 0 then
     call error_bse_siteusers_must_be_empty;
   end if;
-  insert into bse_siteusers
+  insert into bse_siteusers(id, idUUID, userId, password, password_type,
+       email, whenRegistered, lastLogon, title, name1, name2, street, street2,
+       suburb, state, postcode, country, telephone, facsimile, mobile,
+       organization, confirmed, confirmSecret, waitingForConfirmation,
+       textOnlyMail, previousLogon, delivTitle, delivEmail, delivFirstName,
+       delivLastName, delivStreet, delivStreet2, delivSuburb, delivState,
+       delivPostCode, delivCountry, delivTelephone, delivFacsimile,
+       delivMobile, delivOrganization, instructions, adminNotes, disabled,
+       flags, affiliate_name, lost_today, lost_date, lost_id,
+       customText1, customText2, customText3, customStr1, customStr2,
+       customStr3, customInt1, customInt2, customWhen1)
 select
   id,
   uuid() as "idUUID",