GhiTbLgX

1c1 = '''
2CREATE TABLE IF NOT EXISTS id (
3    id INTEGER,
4    host_id INTEGER,
5    PRIMARY KEY (id, host_id)
6);
7'''
8
9c2 = '''
10INSERT OR IGNORE INTO id
11SELECT 
12    id,
13    host_id
14FROM listings;
15''' 
16     
17c1 = '''
18CREATE TABLE IF NOT EXISTS listing_info (
19    id INTEGER,
20    neighborhood TEXT,
21    latitude REAL,
22    longitude REAL,
23    room_type TEXT,
24    price REAL,
25    security_deposit REAL,
26    cleaning_fee REAL,
27    FOREIGN KEY (id) REFERENCES id(id)
28);
29'''
30
31c2 = '''
32INSERT OR IGNORE INTO listing_info
33SELECT 
34    id,
35    neighbourhood,
36    latitude,
37    longitude,
38    room_type,
39    price,
40    security_deposit,
41    cleaning_fee
42FROM listings;
43'''