INSERT INTO `contacts` (
`id` ,`date_entered`,`date_modified`,
`last_name` ,`first_name` ,
`last_name_furigana` ,`first_name_furigana` ,
`smsgroup`,`contact_status`, `idnumber`, 
`primary_address_postalcode`,
`primary_address_state`, `primary_address_city`, `primary_address_street`,
`phone_home`,
`grade`, `grade_entrance_date`,
`custom_var1`, `custom_var11`,
`company_name`,`assigned_user_id`
)
SELECT id, '2009-04-06 15:15:00',  '2009-04-06 15:15:00', 
last_name, first_name, 
furigana_last_name, furigana_first_name,
'student', '0', idnumber,
postalcode,
state, city, address, 
phone_home, 
grade, grade_start_date,
custom_var1, custom_var11,
account_name, user
FROM student;
