Re: Sakila database, film_actor table. How do we order them?

[Melissa Melbourne]

I know how to query!
I just can't choose which variant to choose:
1) film_actor(id, film_id, actor_id, order_index, last_updated), id is autoincrement pk
2) film_actor(film_id, actor_id, order_index, last_updated)

In first variant I add autoincrement id, as I read somewhere every table need it.
Second variant is same sakila but with order_index tiny_int column. I programmatically add needed value for order_index.