General Programming Q&A thread! Ask any questions about programming, answer the questions of other users, or post suggestions for future threads.

Don't forget to format your code using the triple backticks or tildes:

Here is my schema:

```sql
CREATE TABLE article_to_warehouse (
  article_id   INTEGER
, warehouse_id INTEGER
)
;
```

How do I add a `UNIQUE` constraint?

The Guardian live update thread

CNN live update thread

The Guardian exit polling

• The CDU and SPD are tied, although it seems the SPD is for now leading by a slim margin

• The 3 left-of-center parties have a minority of seats together, meaning they couldn't form a government together if they wanted to

• Die Linke is close to the electoral cut-off of entering parliament, and risks getting nothing this election (it appears this is not the case because Linke usually win more than 3 constituency seats, which invalidates the 5% threshold.)

• The AfD and the FDP seem to be likely to get the same amount of votes that got in 2017

• The Greens and SPD have grown by similar margins (but the current polling rise is the SPD's polling rise)

How do you feel about the election as it stands? Also include any more live updates if you know of them.

This thread is posted weekly, and is intended as a place for more-casual discussion of the coronavirus and questions/updates that may not warrant their own dedicated topics. Tell us about what the situation is like where you live!

I’m trying to find movies where Rock and Roll is a character, not movies about the music.

Examples I can think of include:

Heavy Metal
Xanadu
Sgt Pepper’s Lonely Hearts Club Band
Rock and Rule

Maybe
Streets of Fire
The Hunger
Grease (technically a musical i guess)
Guardians of the Galaxy

As part of a weekly series, these topics are a place for users to casually discuss the things they did — or didn't do — during their weekend. Did you make any plans? Take a trip? Do nothing at all? Tell us about it!

I get very confused and urgent and it can be many minutes before I understand that I'm arguing from nothing but internal stress. It's a maddening habit that everyone around me finds repulsive. I have thought that it would be possible to make friends who could help to intervene when I am losing polite perspective, but I am not sure if this expectation has ever really functioned. I don't want to disavow any responsibility in telling my friends they have to jump in on my frequent malfunctions, that sounds unfair. But I'm not making much progress on getting over myself by myself. What to do.

In the discussion "Does the internet feel American centric to you?", various people mentioned living in different countries. In particular @Adys mentioned living in 5 different European countries and offered to give advice to those who are interested in moving to another country. I'd love to hear what the challenges are, and in particular how you get the courage to speak to native speakers in a language you don't speak very well.

For me, my spouse and I are considering (someday) buying property in Greece. Her family is of Greek descent, though she was born and grew up in the states. We're both learning Greek now and hope that in the future we can get back there and possibly even have a vacation home there one day. She has relatives who have homes there and in the states.

Since the recurring thread here is about recent changes you make to your diet or events where you eat things you usually don't eat these threads tend to be kinda empty so I made this post.

(Bonus question: When you first began buying your own food did you try new stuff or stuck to the diet you already had?)

Anyway:

The breakfast is usually "Hokkaido milk bread" (this loaf but less tall which we just call "Pão de leite" or "Milk bread" here) with mayonnaise and a slice of bologna.

The lunch and dinner are the 2 Brazilian staples of Rice and Beans with the "mix" (at least that's the translation of what my parents call it) which is just the third food, usually either meat, eggs or chicken, the meat and chicken being in a more often flattened or less often more cubical shape. (I'm not sure how to describe this.) and more occasionally sausage and nuggets, and strogonoff. Sometimes there's also usually screw noodles. I cook the eggs and nuggets myself and basically try to get them to be crunchy without them getting burnt.

Often around 5 PM I will eat a few guava barrinhas.

On Saturday the dinner is instead either Sfihas (That's what they're called in English? That's the weirdest anglicization I've heard of. If you don't know, it's just a smaller pizza that's usually not eaten in slices.) from which I usually pick the ones of chicken with catupiry but increasingly more pepperoni with catupiry or Whoppers, which I prefer without Pickles or tomatoes.

After a meal I'll usually drink either juice in they sell in sachets or cartons or I'll drink guaraná soft drinks if they're there. After a snack I'll drink strawberry yogurt.

If I bought my own food I would try a lot of different vegetables to see if any of them are any good and I would try to see if there's a healthier replacement for basically putting the oil you use to cook on my plate, since I've heard consuming that oil is quite unhealthy.