constraints



examples/cars.sql
CREATE TABLE car (
    owner_name    VARCHAR(100),
    color         VARCHAR(20) NOT NULL,
    license_plate VARCHAR(20) UNIQUE,
    motor_number  VARCHAR(20) UNIQUE NOT NULL
);

examples/insert_car.sql
INSERT INTO car (owner_name, color, license_plate, motor_number)
       VALUES ("Foo Bar", "Blue", "12-345-67", "DFAFD3243EGGER");

examples/insert_unsold_car.sql
INSERT INTO car (color, motor_number)
       VALUES ("Yellow", "GFAFD3243EGGER");

examples/insert_another_unsold_car.sql
INSERT INTO car (color, motor_number)
       VALUES ("White", "GFAFD3243EGGER");