supply an output column list in site_users_to_member.sql
authorTony Cook <tony@develop-help.com>
Mon, 17 Jun 2013 11:36:42 +0000 (21:36 +1000)
committerTony Cook <tony@develop-help.com>
Mon, 17 Jun 2013 11:36:42 +0000 (21:36 +1000)
otherwise SQL assumes all columns in the table, which will be incorrect
as we add columns to bse_siteusers.

schema/site_users_to_members.sql

index 242210d..bd816f6 100644 (file)
@@ -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",