#NEWLINE# def initialize_database( connection = None ) : #NEWLINE# #INDENT# queries = [ 'CREATE TABLE IF NOT EXISTS merchant (\n    dbid INTEGER PRIMARY KEY,\n    npc INTEGER NOT NULL REFERENCES npc(dbid),\n    buyer TEXT,\n    markup NUMBER,\n    buys_types TEXT,\n    sale_items TEXT\n)' ] #NEWLINE# conn = ( connection or sqlite3 . connect ( DB_NAME ) ) #NEWLINE# cursor = conn . cursor ( ) #NEWLINE# for query in queries : #NEWLINE# #INDENT# cursor . execute ( query )