file.sqlite3

ADDRESS:
INSERT INTO new_db.lettings_address(number,street,city,state,zip_code,country_iso_code) SELECT number, street, city, state, zip_code, country_iso_code FROM oc_lettings_site_address;

LETTINGS:
INSERT INTO new_db.lettings_letting(id,title,address_id) SELECT id,title,address_id FROM oc_lettings_site_letting;

USERS:
INSERT INTO new_db.auth_user(id, password, last_login, is_superuser, username, first_name, email, is_staff, is_active, date_joined, last_name) SELECT id, password, last_login, is_superuser, username, first_name, email, is_staff, is_active, date_joined, last_name FROM auth_user;

PROFILES:
INSERT INTO new_db.profiles_profile(favorite_city,user_id) SELECT favorite_city, user_id FROM oc_lettings_site_profile;