INSERT INTO `jos_vm_user_info` 
(`user_info_id`, 
`user_id`, 
`address_type`, 
`address_type_name`, 
`company`, 
`title`, 
`last_name`,
 `first_name`,
 `middle_name`, 
`phone_1`, 
`phone_2`, 
`fax`,
 `address_1`,
 `address_2`, 
`city`, 
`state`,
 `country`,
 `zip`, 
`user_email`, 
`extra_field_1`,
 `extra_field_2`,
 `extra_field_3`, 
`extra_field_4`, 
`extra_field_5`, 
`cdate`, 
`mdate`,
 `perms`,
 `bank_account_nr`, 
`bank_name`,
 `bank_sort_code`,
 `bank_iban`, 
`bank_account_holder`, 
`bank_account_type`) 
VALUES
('<@WACCOUNTID@>f104c7900958d383904e8bd0',
<@KEY@>,
 'BT', 
'-default-', 
'<@SDESCRIPTION@>', 
'', 
'', 
'', 
'', 
'<@STELEPHONE1@>', 
'<@STELEPHONE2@>', 
'<@SFAX@>', 
'<@SPOSTAL1@>', 
'', 
'<@SPOSTAL2@>', 
'<@SPOSTAL3@>', 
'ZAF', 
'<@SPOSTALCODE@>', 
'<@SEMAIL@>', 
'', 
'', 
'', 
'', 
'', 
current_timestamp, 
current_timestamp, 
'shopper', 
'', 
'', 
'', 
'', 
'', 
'Checking')
@@GO@@
INSERT INTO `jos_core_acl_aro` ( `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
( 'users', '<@KEY@>', 0, '<@SDESCRIPTION@>', 0);
@@GO@@
INSERT INTO `jos_core_acl_groups_aro_map` (
`group_id` ,
`section_value` ,
`aro_id`
)
VALUES (
'18', '', LAST_INSERT_ID()
)
@@GO@@


