#1057

One Primary Address

Design the addresses table for user addresses. It must store id as the primary key, user_id, and the is_primary flag; a user may have many addresses, but the database must prevent more than one row with is_primary = true for the same user_id.

CREATE/ALTER/DROP biss — l-ebda SELECT fl-aħħar mhu meħtieġ.

Ir-riżultat tal-query tiegħek jidher hawn

L-ebda skema tal-bidu

Dan l-eżerċizzju jibda mingħajr tabelli — toħloqhom permezz ta' CREATE TABLE.