here is the prompt I used:
help me create a script to generate two tables in my local postgres instance:
1. a table containing cocktail recipes: id, name(unique and indexed), url, rank (floating number) optional
2. an ingredients table, containing: ingredient name, amount, and related cocktail (by id). index ingredient name, and PK should be (cocktail id, ingredient name)
