cascading-delete-approach_insert-queries.pgsql

INSERT INTO "gdpr_users" ("id", "fullname", "address")
    VALUES (1, 'Jane Doe', '123 Main St - Anytown, USA'),
           (2, 'John Doe', '456 Main St - Anytown, USA');

INSERT INTO "users" ("id", "username", "password", "picture")
    VALUES (1, 'jane.doe', 'some_hash', NULL),
           (2, 'john.doe', 'some_hash', NULL);

INSERT INTO "products" ("id", "name", "description", "price")
    VALUES (1, 'Carrot', 'A bundle of fresh carrots', 2),
           (2, 'Potatoe', 'Some waxy potatoes', 4);

INSERT INTO "orders" ("id", "gdpr_user_id", "product_id", "amount")
    VALUES (1, 1, 1, 2),
           (2, 1, 2, 1),
           (3, 2, 2, 3);

INSERT INTO "comments" ("id", "user_id", "order_id", "comment")
    VALUES (1, 1, 1, 'I like these carrots very much!'),
           (2, 1, 2, 'Very good to cook potatoe wegdes!'),
           (3, 2, 3, 'Excellent potatoes!');