import sqlite3

con = sqlite3.connect('aboj.db') # Warning: This file is created in the current directory
con.execute("CREATE TABLE target (id INTEGER PRIMARY KEY, city char(100) NOT NULL, base char(100) NOT NULL, status bool NOT NULL)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Burlington VT','http://burlington.craigslist.org/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Washington DC','http://washingtondc.craigslist.org/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Montreal CA','http://montreal.fr.craigslist.ca/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Albany NY','http://albany.craigslist.org/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Eastern CT','http://newlondon.craigslist.org/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Hartford CT','http://hartford.craigslist.org/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('New Haven CT','http://newhaven.craigslist.org/search/',0)")
con.execute("INSERT INTO target (city,base,status) VALUES ('Northwest CT','http://nwct.craigslist.org/search/',0)")
con.commit()