CREATE TABLE children (
    id integer NOT NULL,
    name character varying(120),
    is_nice boolean,
    country_id integer
);

CREATE TABLE country (
    id integer NOT NULL,
    name character varying(120)
);

CREATE TABLE letter (
    id integer NOT NULL,
    letter_date date,
    children_id integer
);

CREATE TABLE purchase (
    id integer NOT NULL,
    request_id integer,
    price numeric(7,2),
    order_date date,
    store character varying(100),
    delivery_date date
);

CREATE TABLE request (
    id integer NOT NULL,
    letter_id integer,
    toy_id integer
);

CREATE TABLE toy (
    id integer NOT NULL,
    name character varying(120),
    category character varying(120)
);

INSERT INTO country (id, name) VALUES (1, 'Burundi');
INSERT INTO country (id, name) VALUES (2, 'Cameroon');
INSERT INTO country (id, name) VALUES (3, 'Central African Republic');
INSERT INTO country (id, name) VALUES (4, 'Egypt');
INSERT INTO country (id, name) VALUES (5, 'Kenya');
INSERT INTO country (id, name) VALUES (6, 'Madagascar');
INSERT INTO country (id, name) VALUES (7, 'Sierra Leone');
INSERT INTO country (id, name) VALUES (8, 'Sweden');
INSERT INTO country (id, name) VALUES (9, 'Tunisia');
INSERT INTO country (id, name) VALUES (10, 'Western Sahara');
INSERT INTO country (id, name) VALUES (11, 'Argentina');
INSERT INTO country (id, name) VALUES (12, 'Canada');
INSERT INTO country (id, name) VALUES (13, 'Chile');
INSERT INTO country (id, name) VALUES (14, 'Greenland');
INSERT INTO country (id, name) VALUES (15, 'Haiti');
INSERT INTO country (id, name) VALUES (16, 'Jamaica');
INSERT INTO country (id, name) VALUES (17, 'Mexico');
INSERT INTO country (id, name) VALUES (18, 'Paraguay');
INSERT INTO country (id, name) VALUES (19, 'Peru');
INSERT INTO country (id, name) VALUES (20, 'United States');
INSERT INTO country (id, name) VALUES (21, 'China');
INSERT INTO country (id, name) VALUES (22, 'India');
INSERT INTO country (id, name) VALUES (23, 'Indonesia');
INSERT INTO country (id, name) VALUES (24, 'Japan');
INSERT INTO country (id, name) VALUES (25, 'Kuwait');
INSERT INTO country (id, name) VALUES (26, 'Oman');
INSERT INTO country (id, name) VALUES (27, 'Palau');
INSERT INTO country (id, name) VALUES (28, 'Philippines');
INSERT INTO country (id, name) VALUES (29, 'Turkey');
INSERT INTO country (id, name) VALUES (30, 'Vietnam');
INSERT INTO country (id, name) VALUES (31, 'Cyprus');
INSERT INTO country (id, name) VALUES (32, 'Denmark');
INSERT INTO country (id, name) VALUES (33, 'Finland');
INSERT INTO country (id, name) VALUES (34, 'Greece');
INSERT INTO country (id, name) VALUES (35, 'Hungary');
INSERT INTO country (id, name) VALUES (36, 'Italy');
INSERT INTO country (id, name) VALUES (37, 'Lithuania');
INSERT INTO country (id, name) VALUES (38, 'Netherlands');
INSERT INTO country (id, name) VALUES (39, 'Poland');
INSERT INTO country (id, name) VALUES (40, 'Russia');
INSERT INTO country (id, name) VALUES (41, 'Spain');
INSERT INTO country (id, name) VALUES (42, 'Switzerland');
INSERT INTO country (id, name) VALUES (43, 'United Kingdom ');
INSERT INTO country (id, name) VALUES (44, 'Australia');
INSERT INTO country (id, name) VALUES (45, 'New Zealand');
INSERT INTO country (id, name) VALUES (46, 'Wonderland');
INSERT INTO country (id, name) VALUES (47, 'Woodland');
INSERT INTO country (id, name) VALUES (48, 'Sweetsland');



INSERT INTO children (id, name, is_nice, country_id) VALUES (1, 'Emma ', true, 21);
INSERT INTO children (id, name, is_nice, country_id) VALUES (2, 'Noah', true, 34);
INSERT INTO children (id, name, is_nice, country_id) VALUES (3, 'Olivia ', false, 32);
INSERT INTO children (id, name, is_nice, country_id) VALUES (4, 'Liam', true, 42);
INSERT INTO children (id, name, is_nice, country_id) VALUES (5, 'Ava ', true, 11);
INSERT INTO children (id, name, is_nice, country_id) VALUES (6, 'William ', false, 13);
INSERT INTO children (id, name, is_nice, country_id) VALUES (7, 'Sophia ', true, 5);
INSERT INTO children (id, name, is_nice, country_id) VALUES (8, 'Mason', true, 7);
INSERT INTO children (id, name, is_nice, country_id) VALUES (9, 'Isabella ', true, 22);
INSERT INTO children (id, name, is_nice, country_id) VALUES (10, 'James', true, 5);
INSERT INTO children (id, name, is_nice, country_id) VALUES (11, 'Mia ', true, 1);
INSERT INTO children (id, name, is_nice, country_id) VALUES (12, 'Benjamin', true, 21);
INSERT INTO children (id, name, is_nice, country_id) VALUES (13, 'Charlotte', false, 31);
INSERT INTO children (id, name, is_nice, country_id) VALUES (14, 'Jacob', true, 39);
INSERT INTO children (id, name, is_nice, country_id) VALUES (15, 'Abigail ', true, 33);
INSERT INTO children (id, name, is_nice, country_id) VALUES (16, 'Michael', true, 35);
INSERT INTO children (id, name, is_nice, country_id) VALUES (17, 'Emily', true, 43);
INSERT INTO children (id, name, is_nice, country_id) VALUES (18, 'Elijah', true, 11);
INSERT INTO children (id, name, is_nice, country_id) VALUES (19, 'Harper', true, 3);
INSERT INTO children (id, name, is_nice, country_id) VALUES (20, 'Ethan', false, 17);
INSERT INTO children (id, name, is_nice, country_id) VALUES (21, 'Amelia ', true, 31);
INSERT INTO children (id, name, is_nice, country_id) VALUES (22, 'Alexander', false, 24);
INSERT INTO children (id, name, is_nice, country_id) VALUES (23, 'Evelyn ', true, 32);
INSERT INTO children (id, name, is_nice, country_id) VALUES (24, 'Oliver', true, 11);
INSERT INTO children (id, name, is_nice, country_id) VALUES (25, 'Elizabeth ', true, 7);
INSERT INTO children (id, name, is_nice, country_id) VALUES (26, 'Daniel', true, 8);
INSERT INTO children (id, name, is_nice, country_id) VALUES (27, 'Sofia ', true, 25);
INSERT INTO children (id, name, is_nice, country_id) VALUES (28, 'Lucas', true, 28);
INSERT INTO children (id, name, is_nice, country_id) VALUES (29, 'Madison ', true, 16);
INSERT INTO children (id, name, is_nice, country_id) VALUES (30, 'Ezekiel', true, 11);
INSERT INTO children (id, name, is_nice, country_id) VALUES (31, 'Avery ', true, 37);
INSERT INTO children (id, name, is_nice, country_id) VALUES (32, 'Aiden ', true, 15);
INSERT INTO children (id, name, is_nice, country_id) VALUES (33, 'Ella ', true, 5);
INSERT INTO children (id, name, is_nice, country_id) VALUES (34, 'Zoe', true, 45);
INSERT INTO children (id, name, is_nice, country_id) VALUES (35, 'Scarlett ', true, 12);
INSERT INTO children (id, name, is_nice, country_id) VALUES (36, 'Logan', true, 20);
INSERT INTO children (id, name, is_nice, country_id) VALUES (37, 'Grace ', true, 42);
INSERT INTO children (id, name, is_nice, country_id) VALUES (38, 'David ', true, 1);
INSERT INTO children (id, name, is_nice, country_id) VALUES (39, 'Chloe ', true, 25);
INSERT INTO children (id, name, is_nice, country_id) VALUES (40, 'Kevin', true, 20);
INSERT INTO children (id, name, is_nice, country_id) VALUES (41, 'Victoria ', true, 20);
INSERT INTO children (id, name, is_nice, country_id) VALUES (42, 'Samuel', true, 27);
INSERT INTO children (id, name, is_nice, country_id) VALUES (43, 'Riley ', true, 9);
INSERT INTO children (id, name, is_nice, country_id) VALUES (44, 'Henry', true, 19);
INSERT INTO children (id, name, is_nice, country_id) VALUES (45, 'Aria ', true, 29);
INSERT INTO children (id, name, is_nice, country_id) VALUES (46, 'Owen', true, 13);
INSERT INTO children (id, name, is_nice, country_id) VALUES (47, 'Lily ', true, 14);
INSERT INTO children (id, name, is_nice, country_id) VALUES (48, 'Sebastian', true, 21);
INSERT INTO children (id, name, is_nice, country_id) VALUES (49, 'Aubrey ', true, 18);
INSERT INTO children (id, name, is_nice, country_id) VALUES (50, 'Gabriel', true, 19);
INSERT INTO children (id, name, is_nice, country_id) VALUES (51, 'Zoey ', true, 15);
INSERT INTO children (id, name, is_nice, country_id) VALUES (52, 'Carter', true, 28);
INSERT INTO children (id, name, is_nice, country_id) VALUES (53, 'Ella', true, 12);
INSERT INTO children (id, name, is_nice, country_id) VALUES (54, 'Bethany', true, 27);
INSERT INTO children (id, name, is_nice, country_id) VALUES (55, 'Eleanor', true, 43);
INSERT INTO children (id, name, is_nice, country_id) VALUES (56, 'Olivia', true, 1);
INSERT INTO children (id, name, is_nice, country_id) VALUES (57, 'Laura', true, 12);
INSERT INTO children (id, name, is_nice, country_id) VALUES (58, 'Holly', true, 19);
INSERT INTO children (id, name, is_nice, country_id) VALUES (59, 'Amber', true, 11);
INSERT INTO children (id, name, is_nice, country_id) VALUES (60, 'Caitlin', true, 12);
INSERT INTO children (id, name, is_nice, country_id) VALUES (61, 'Jade', true, 30);
INSERT INTO children (id, name, is_nice, country_id) VALUES (62, 'Joseph', true, 2);
INSERT INTO children (id, name, is_nice, country_id) VALUES (63, 'Victoria ', true, 12);
INSERT INTO children (id, name, is_nice, country_id) VALUES (64, 'Samuel', true, 20);
INSERT INTO children (id, name, is_nice, country_id) VALUES (65, 'Elizabeth ', true, 30);
INSERT INTO children (id, name, is_nice, country_id) VALUES (66, 'Daniel', true, 25);
INSERT INTO children (id, name, is_nice, country_id) VALUES (67, 'Sofia ', true, 22);
INSERT INTO children (id, name, is_nice, country_id) VALUES (68, 'Lucas', true, 1);
INSERT INTO children (id, name, is_nice, country_id) VALUES (69, 'Liam', true, 40);
INSERT INTO children (id, name, is_nice, country_id) VALUES (70, 'Ava ', true, 6);
INSERT INTO children (id, name, is_nice, country_id) VALUES (71, 'William ', true, 34);
INSERT INTO children (id, name, is_nice, country_id) VALUES (72, 'Emma ', true, 36);
INSERT INTO children (id, name, is_nice, country_id) VALUES (73, 'Noah', true, 15);
INSERT INTO children (id, name, is_nice, country_id) VALUES (74, 'Jacob', true, 35);
INSERT INTO children (id, name, is_nice, country_id) VALUES (75, 'Daniel', true, 31);
INSERT INTO children (id, name, is_nice, country_id) VALUES (76, 'Thomas', false, 8);
INSERT INTO children (id, name, is_nice, country_id) VALUES (77, 'James', true, 10);
INSERT INTO children (id, name, is_nice, country_id) VALUES (78, 'Adam', true, 17);
INSERT INTO children (id, name, is_nice, country_id) VALUES (79, 'Harry', true, 34);
INSERT INTO children (id, name, is_nice, country_id) VALUES (80, 'Samuel', true, 33);
INSERT INTO children (id, name, is_nice, country_id) VALUES (81, 'Jack', true, 28);
INSERT INTO children (id, name, is_nice, country_id) VALUES (82, 'Oliver', false, 35);
INSERT INTO children (id, name, is_nice, country_id) VALUES (83, 'Ryan', true, 16);
INSERT INTO children (id, name, is_nice, country_id) VALUES (84, 'Lucas', true, 4);
INSERT INTO children (id, name, is_nice, country_id) VALUES (85, 'Emma ', true, 28);
INSERT INTO children (id, name, is_nice, country_id) VALUES (86, 'Noah', true, 26);
INSERT INTO children (id, name, is_nice, country_id) VALUES (87, 'Jacob', true, 9);
INSERT INTO children (id, name, is_nice, country_id) VALUES (88, 'Daniel', true, 11);
INSERT INTO children (id, name, is_nice, country_id) VALUES (89, 'Thomas', true, 36);
INSERT INTO children (id, name, is_nice, country_id) VALUES (90, 'James', true, 32);
INSERT INTO children (id, name, is_nice, country_id) VALUES (91, 'Adam', true, 25);
INSERT INTO children (id, name, is_nice, country_id) VALUES (92, 'Harry', true, 43);
INSERT INTO children (id, name, is_nice, country_id) VALUES (93, 'Samuel', true, 1);
INSERT INTO children (id, name, is_nice, country_id) VALUES (94, 'Jack', true, 28);
INSERT INTO children (id, name, is_nice, country_id) VALUES (95, 'Oliver', true, 2);
INSERT INTO children (id, name, is_nice, country_id) VALUES (96, 'Ryan', true, 12);
INSERT INTO children (id, name, is_nice, country_id) VALUES (97, 'Alice', true, 46);
INSERT INTO children (id, name, is_nice, country_id) VALUES (98, 'Pinokio', false, 47);
INSERT INTO children (id, name, is_nice, country_id) VALUES (99, 'Gerda', true, 48);
INSERT INTO children (id, name, is_nice, country_id) VALUES (100, 'Flora', true, 47);


INSERT INTO letter (id, letter_date, children_id) VALUES (1, '2017-12-19', 74);
INSERT INTO letter (id, letter_date, children_id) VALUES (2, '2017-12-20', 33);
INSERT INTO letter (id, letter_date, children_id) VALUES (3, '2017-12-06', 29);
INSERT INTO letter (id, letter_date, children_id) VALUES (4, '2017-12-17', 89);
INSERT INTO letter (id, letter_date, children_id) VALUES (5, '2017-12-10', 69);
INSERT INTO letter (id, letter_date, children_id) VALUES (6, '2017-12-18', 100);
INSERT INTO letter (id, letter_date, children_id) VALUES (7, '2017-12-17', 72);
INSERT INTO letter (id, letter_date, children_id) VALUES (8, '2017-12-10', 41);
INSERT INTO letter (id, letter_date, children_id) VALUES (9, '2017-12-03', 58);
INSERT INTO letter (id, letter_date, children_id) VALUES (10, '2017-12-11', 77);
INSERT INTO letter (id, letter_date, children_id) VALUES (11, '2017-12-10', 38);
INSERT INTO letter (id, letter_date, children_id) VALUES (12, '2017-12-23', 36);
INSERT INTO letter (id, letter_date, children_id) VALUES (13, '2017-12-10', 19);
INSERT INTO letter (id, letter_date, children_id) VALUES (14, '2017-12-12', 54);
INSERT INTO letter (id, letter_date, children_id) VALUES (15, '2017-12-24', 29);
INSERT INTO letter (id, letter_date, children_id) VALUES (16, '2017-12-05', 15);
INSERT INTO letter (id, letter_date, children_id) VALUES (17, '2017-12-12', 90);
INSERT INTO letter (id, letter_date, children_id) VALUES (18, '2017-12-17', 58);
INSERT INTO letter (id, letter_date, children_id) VALUES (19, '2017-12-04', 19);
INSERT INTO letter (id, letter_date, children_id) VALUES (20, '2017-12-05', 24);
INSERT INTO letter (id, letter_date, children_id) VALUES (21, '2017-12-07', 62);
INSERT INTO letter (id, letter_date, children_id) VALUES (22, '2017-12-02', 55);
INSERT INTO letter (id, letter_date, children_id) VALUES (23, '2017-12-17', 80);
INSERT INTO letter (id, letter_date, children_id) VALUES (24, '2017-12-19', 1);
INSERT INTO letter (id, letter_date, children_id) VALUES (25, '2017-12-08', 19);
INSERT INTO letter (id, letter_date, children_id) VALUES (26, '2017-12-05', 14);
INSERT INTO letter (id, letter_date, children_id) VALUES (27, '2017-12-05', 43);
INSERT INTO letter (id, letter_date, children_id) VALUES (28, '2017-12-16', 45);
INSERT INTO letter (id, letter_date, children_id) VALUES (29, '2017-12-23', 49);
INSERT INTO letter (id, letter_date, children_id) VALUES (30, '2017-12-12', 73);
INSERT INTO letter (id, letter_date, children_id) VALUES (31, '2017-12-01', 5);
INSERT INTO letter (id, letter_date, children_id) VALUES (32, '2017-12-11', 37);
INSERT INTO letter (id, letter_date, children_id) VALUES (33, '2017-12-18', 36);
INSERT INTO letter (id, letter_date, children_id) VALUES (34, '2017-12-14', 61);
INSERT INTO letter (id, letter_date, children_id) VALUES (35, '2017-12-12', 27);
INSERT INTO letter (id, letter_date, children_id) VALUES (36, '2017-12-21', 33);
INSERT INTO letter (id, letter_date, children_id) VALUES (37, '2017-12-16', 72);
INSERT INTO letter (id, letter_date, children_id) VALUES (38, '2017-12-22', 46);
INSERT INTO letter (id, letter_date, children_id) VALUES (39, '2017-12-06', 22);
INSERT INTO letter (id, letter_date, children_id) VALUES (40, '2017-12-08', 12);
INSERT INTO letter (id, letter_date, children_id) VALUES (41, '2017-12-13', 17);
INSERT INTO letter (id, letter_date, children_id) VALUES (42, '2017-12-20', 92);
INSERT INTO letter (id, letter_date, children_id) VALUES (43, '2017-12-14', 100);
INSERT INTO letter (id, letter_date, children_id) VALUES (44, '2017-12-11', 13);
INSERT INTO letter (id, letter_date, children_id) VALUES (45, '2017-12-13', 20);
INSERT INTO letter (id, letter_date, children_id) VALUES (46, '2017-12-03', 66);
INSERT INTO letter (id, letter_date, children_id) VALUES (47, '2017-12-19', 89);
INSERT INTO letter (id, letter_date, children_id) VALUES (48, '2017-12-13', 29);
INSERT INTO letter (id, letter_date, children_id) VALUES (49, '2017-12-03', 65);
INSERT INTO letter (id, letter_date, children_id) VALUES (50, '2017-12-11', 76);
INSERT INTO letter (id, letter_date, children_id) VALUES (51, '2017-12-13', 82);
INSERT INTO letter (id, letter_date, children_id) VALUES (52, '2017-12-19', 54);
INSERT INTO letter (id, letter_date, children_id) VALUES (53, '2017-12-17', 57);
INSERT INTO letter (id, letter_date, children_id) VALUES (54, '2017-12-06', 92);
INSERT INTO letter (id, letter_date, children_id) VALUES (55, '2017-12-12', 3);
INSERT INTO letter (id, letter_date, children_id) VALUES (56, '2017-12-22', 93);
INSERT INTO letter (id, letter_date, children_id) VALUES (57, '2017-12-02', 45);
INSERT INTO letter (id, letter_date, children_id) VALUES (58, '2017-12-04', 19);
INSERT INTO letter (id, letter_date, children_id) VALUES (59, '2017-12-07', 100);
INSERT INTO letter (id, letter_date, children_id) VALUES (60, '2017-12-24', 29);
INSERT INTO letter (id, letter_date, children_id) VALUES (61, '2017-12-21', 67);
INSERT INTO letter (id, letter_date, children_id) VALUES (62, '2017-12-06', 44);
INSERT INTO letter (id, letter_date, children_id) VALUES (63, '2017-12-05', 13);
INSERT INTO letter (id, letter_date, children_id) VALUES (64, '2017-12-09', 4);
INSERT INTO letter (id, letter_date, children_id) VALUES (65, '2017-12-10', 76);
INSERT INTO letter (id, letter_date, children_id) VALUES (66, '2017-12-02', 49);
INSERT INTO letter (id, letter_date, children_id) VALUES (67, '2017-12-18', 39);
INSERT INTO letter (id, letter_date, children_id) VALUES (68, '2017-12-11', 78);
INSERT INTO letter (id, letter_date, children_id) VALUES (69, '2017-12-04', 64);
INSERT INTO letter (id, letter_date, children_id) VALUES (70, '2017-12-22', 8);
INSERT INTO letter (id, letter_date, children_id) VALUES (71, '2017-12-07', 51);
INSERT INTO letter (id, letter_date, children_id) VALUES (72, '2017-12-04', 24);
INSERT INTO letter (id, letter_date, children_id) VALUES (73, '2017-12-21', 35);
INSERT INTO letter (id, letter_date, children_id) VALUES (74, '2017-12-11', 17);
INSERT INTO letter (id, letter_date, children_id) VALUES (75, '2017-12-09', 46);
INSERT INTO letter (id, letter_date, children_id) VALUES (76, '2017-12-06', 31);
INSERT INTO letter (id, letter_date, children_id) VALUES (77, '2017-12-05', 51);
INSERT INTO letter (id, letter_date, children_id) VALUES (78, '2017-12-23', 21);
INSERT INTO letter (id, letter_date, children_id) VALUES (79, '2017-12-01', 39);
INSERT INTO letter (id, letter_date, children_id) VALUES (80, '2017-12-19', 54);
INSERT INTO letter (id, letter_date, children_id) VALUES (81, '2017-12-06', 59);
INSERT INTO letter (id, letter_date, children_id) VALUES (82, '2017-12-21', 8);
INSERT INTO letter (id, letter_date, children_id) VALUES (83, '2017-12-07', 18);
INSERT INTO letter (id, letter_date, children_id) VALUES (84, '2017-12-17', 25);
INSERT INTO letter (id, letter_date, children_id) VALUES (85, '2017-12-01', 14);
INSERT INTO letter (id, letter_date, children_id) VALUES (86, '2017-12-08', 64);
INSERT INTO letter (id, letter_date, children_id) VALUES (87, '2017-12-11', 76);
INSERT INTO letter (id, letter_date, children_id) VALUES (88, '2017-12-06', 36);
INSERT INTO letter (id, letter_date, children_id) VALUES (89, '2017-12-05', 54);
INSERT INTO letter (id, letter_date, children_id) VALUES (90, '2017-12-11', 40);
INSERT INTO letter (id, letter_date, children_id) VALUES (91, '2017-12-14', 24);
INSERT INTO letter (id, letter_date, children_id) VALUES (92, '2017-12-17', 97);
INSERT INTO letter (id, letter_date, children_id) VALUES (93, '2017-12-19', 48);
INSERT INTO letter (id, letter_date, children_id) VALUES (94, '2017-12-14', 5);
INSERT INTO letter (id, letter_date, children_id) VALUES (95, '2017-12-08', 65);
INSERT INTO letter (id, letter_date, children_id) VALUES (96, '2017-12-24', 90);
INSERT INTO letter (id, letter_date, children_id) VALUES (97, '2017-12-14', 52);
INSERT INTO letter (id, letter_date, children_id) VALUES (98, '2017-12-19', 93);
INSERT INTO letter (id, letter_date, children_id) VALUES (99, '2017-12-23', 7);
INSERT INTO letter (id, letter_date, children_id) VALUES (100, '2017-12-24', 97);


--
-- Data for Name: toy; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO toy (id, name, category) VALUES (2, 'train', 'electronics');
INSERT INTO toy (id, name, category) VALUES (3, 'lego blocks', 'blocks');
INSERT INTO toy (id, name, category) VALUES (5, 'play cards', 'games');
INSERT INTO toy (id, name, category) VALUES (6, 'plush bear', 'mascot');
INSERT INTO toy (id, name, category) VALUES (7, 'textile doll', 'dolls');
INSERT INTO toy (id, name, category) VALUES (8, 'sport car', 'cars');
INSERT INTO toy (id, name, category) VALUES (9, 'spinner', 'games');
INSERT INTO toy (id, name, category) VALUES (10, 'laptop', 'electronics');
INSERT INTO toy (id, name, category) VALUES (11, 'headphones', 'electronics');
INSERT INTO toy (id, name, category) VALUES (12, 'textile monkey', 'mascot');
INSERT INTO toy (id, name, category) VALUES (13, 'cat', 'mascot');
INSERT INTO toy (id, name, category) VALUES (14, 'fairlytales', 'books');
INSERT INTO toy (id, name, category) VALUES (15, 'educational games', 'games');
INSERT INTO toy (id, name, category) VALUES (16, 'modern art.', 'decoration');
INSERT INTO toy (id, name, category) VALUES (17, 'airplane mobile', 'electronics');
INSERT INTO toy (id, name, category) VALUES (18, 'chocolate', 'sweets');
INSERT INTO toy (id, name, category) VALUES (19, 'Barbie', 'dolls');
INSERT INTO toy (id, name, category) VALUES (20, 'ball', 'sports');
INSERT INTO toy (id, name, category) VALUES (21, 'sky bouncers', 'sports');
INSERT INTO toy (id, name, category) VALUES (22, 'pencil', 'commodities');
INSERT INTO toy (id, name, category) VALUES (23, 'pen', 'commodities');
INSERT INTO toy (id, name, category) VALUES (25, 'crayons', 'commodities');
INSERT INTO toy (id, name, category) VALUES (26, 'guitar', 'music');
INSERT INTO toy (id, name, category) VALUES (27, 'piano', 'music');
INSERT INTO toy (id, name, category) VALUES (28, 'candy', 'sweets');
INSERT INTO toy (id, name, category) VALUES (4, 'monopoly game', 'games');
INSERT INTO toy (id, name, category) VALUES (1, 'magneblocks', 'blocks');
INSERT INTO toy (id, name, category) VALUES (24, 'pencil box', 'commodities');


--
-- Data for Name: request; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO request (id, letter_id, toy_id) VALUES (1, 21, 13);
INSERT INTO request (id, letter_id, toy_id) VALUES (2, 96, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (3, 24, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (4, 53, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (5, 45, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (6, 51, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (7, 37, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (8, 85, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (9, 80, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (10, 78, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (11, 76, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (12, 27, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (13, 98, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (14, 3, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (15, 32, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (16, 47, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (17, 88, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (18, 30, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (19, 86, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (20, 47, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (21, 89, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (22, 16, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (23, 30, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (24, 79, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (25, 31, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (26, 66, 19);
INSERT INTO request (id, letter_id, toy_id) VALUES (27, 47, 10);
INSERT INTO request (id, letter_id, toy_id) VALUES (28, 93, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (29, 71, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (30, 38, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (31, 60, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (32, 80, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (33, 58, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (34, 66, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (35, 30, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (36, 58, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (37, 39, 19);
INSERT INTO request (id, letter_id, toy_id) VALUES (38, 51, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (39, 4, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (40, 83, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (41, 13, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (42, 7, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (43, 26, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (44, 20, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (45, 24, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (46, 80, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (47, 6, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (48, 71, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (49, 10, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (50, 13, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (51, 35, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (52, 2, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (53, 17, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (54, 77, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (55, 92, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (56, 43, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (57, 39, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (58, 68, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (59, 11, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (60, 13, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (61, 45, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (62, 5, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (63, 93, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (64, 28, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (65, 54, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (66, 35, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (67, 50, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (68, 36, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (69, 37, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (70, 78, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (71, 95, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (72, 22, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (73, 76, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (74, 75, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (75, 69, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (76, 63, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (77, 28, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (78, 76, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (79, 67, 13);
INSERT INTO request (id, letter_id, toy_id) VALUES (80, 77, 19);
INSERT INTO request (id, letter_id, toy_id) VALUES (81, 1, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (82, 5, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (83, 45, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (84, 19, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (85, 87, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (86, 70, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (87, 87, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (88, 80, 13);
INSERT INTO request (id, letter_id, toy_id) VALUES (89, 15, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (90, 84, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (91, 71, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (92, 4, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (93, 33, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (94, 16, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (95, 18, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (96, 64, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (97, 71, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (98, 80, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (99, 49, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (100, 29, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (101, 56, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (102, 26, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (103, 45, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (104, 72, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (105, 77, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (106, 99, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (107, 62, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (108, 97, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (109, 26, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (110, 14, 10);
INSERT INTO request (id, letter_id, toy_id) VALUES (111, 21, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (112, 54, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (113, 37, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (114, 20, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (115, 25, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (116, 60, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (117, 72, 10);
INSERT INTO request (id, letter_id, toy_id) VALUES (118, 78, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (119, 48, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (120, 11, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (121, 19, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (122, 55, 19);
INSERT INTO request (id, letter_id, toy_id) VALUES (123, 85, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (124, 100, 15);
INSERT INTO request (id, letter_id, toy_id) VALUES (125, 74, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (126, 73, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (127, 55, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (128, 13, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (129, 47, 13);
INSERT INTO request (id, letter_id, toy_id) VALUES (130, 12, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (131, 80, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (132, 68, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (133, 71, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (134, 36, 15);
INSERT INTO request (id, letter_id, toy_id) VALUES (135, 85, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (136, 32, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (137, 63, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (138, 19, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (139, 25, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (140, 71, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (141, 48, 23);
INSERT INTO request (id, letter_id, toy_id) VALUES (142, 69, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (143, 17, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (144, 2, 13);
INSERT INTO request (id, letter_id, toy_id) VALUES (145, 16, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (146, 75, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (147, 60, 14);
INSERT INTO request (id, letter_id, toy_id) VALUES (148, 51, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (149, 88, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (150, 46, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (151, 33, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (152, 30, 10);
INSERT INTO request (id, letter_id, toy_id) VALUES (153, 50, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (154, 60, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (155, 23, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (156, 57, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (157, 77, 15);
INSERT INTO request (id, letter_id, toy_id) VALUES (158, 93, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (159, 4, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (160, 98, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (161, 35, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (162, 42, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (163, 53, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (164, 49, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (165, 63, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (166, 92, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (167, 85, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (168, 91, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (169, 55, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (170, 62, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (171, 85, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (172, 3, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (173, 35, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (174, 43, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (175, 62, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (176, 35, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (177, 6, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (178, 5, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (179, 83, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (180, 63, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (181, 88, 3);
INSERT INTO request (id, letter_id, toy_id) VALUES (182, 32, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (183, 61, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (184, 36, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (185, 69, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (186, 49, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (187, 53, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (188, 15, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (189, 54, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (190, 51, 23);
INSERT INTO request (id, letter_id, toy_id) VALUES (191, 81, 17);
INSERT INTO request (id, letter_id, toy_id) VALUES (192, 68, 23);
INSERT INTO request (id, letter_id, toy_id) VALUES (193, 79, 9);
INSERT INTO request (id, letter_id, toy_id) VALUES (194, 73, 10);
INSERT INTO request (id, letter_id, toy_id) VALUES (195, 1, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (196, 19, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (197, 90, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (198, 88, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (199, 30, 13);
INSERT INTO request (id, letter_id, toy_id) VALUES (200, 27, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (201, 79, 2);
INSERT INTO request (id, letter_id, toy_id) VALUES (202, 28, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (203, 66, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (204, 16, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (205, 28, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (206, 82, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (207, 32, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (208, 13, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (209, 77, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (210, 51, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (211, 24, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (212, 46, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (213, 97, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (214, 82, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (215, 24, 21);
INSERT INTO request (id, letter_id, toy_id) VALUES (216, 59, 1);
INSERT INTO request (id, letter_id, toy_id) VALUES (217, 40, 15);
INSERT INTO request (id, letter_id, toy_id) VALUES (218, 20, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (219, 42, 18);
INSERT INTO request (id, letter_id, toy_id) VALUES (220, 75, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (221, 67, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (222, 85, 6);
INSERT INTO request (id, letter_id, toy_id) VALUES (223, 60, 22);
INSERT INTO request (id, letter_id, toy_id) VALUES (224, 69, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (225, 87, 20);
INSERT INTO request (id, letter_id, toy_id) VALUES (226, 39, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (227, 100, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (228, 52, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (229, 88, 25);
INSERT INTO request (id, letter_id, toy_id) VALUES (230, 13, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (231, 4, 16);
INSERT INTO request (id, letter_id, toy_id) VALUES (232, 56, 23);
INSERT INTO request (id, letter_id, toy_id) VALUES (233, 22, 7);
INSERT INTO request (id, letter_id, toy_id) VALUES (234, 18, 19);
INSERT INTO request (id, letter_id, toy_id) VALUES (235, 47, 28);
INSERT INTO request (id, letter_id, toy_id) VALUES (236, 27, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (237, 44, 27);
INSERT INTO request (id, letter_id, toy_id) VALUES (238, 30, 26);
INSERT INTO request (id, letter_id, toy_id) VALUES (239, 18, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (240, 70, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (241, 53, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (242, 66, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (243, 8, 4);
INSERT INTO request (id, letter_id, toy_id) VALUES (244, 10, 8);
INSERT INTO request (id, letter_id, toy_id) VALUES (245, 75, 10);
INSERT INTO request (id, letter_id, toy_id) VALUES (246, 35, 24);
INSERT INTO request (id, letter_id, toy_id) VALUES (247, 86, 5);
INSERT INTO request (id, letter_id, toy_id) VALUES (248, 11, 12);
INSERT INTO request (id, letter_id, toy_id) VALUES (249, 100, 11);
INSERT INTO request (id, letter_id, toy_id) VALUES (250, 37, 26);


--
-- Data for Name: purchase; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (1, 1, 86.00, '2017-12-08', 'Toy Planet', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (3, 3, 15.00, '2017-12-21', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (4, 4, 29.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (5, 5, 25.00, '2017-12-14', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (7, 7, 7.00, '2017-12-19', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (8, 8, 23.00, '2017-12-02', 'Harry Potter Shop', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (9, 9, 45.00, '2017-12-21', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (10, 10, 26.00, '2017-12-23', 'Disney Store', '2017-12-23');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (11, 11, 2.00, '2017-12-07', 'Chocolate House', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (12, 12, 90.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (13, 13, 47.00, '2017-12-21', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (14, 14, 29.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (15, 15, 90.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (16, 16, 560.00, '2017-12-21', 'Harry Potter Shop', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (17, 17, 38.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (18, 18, 100.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (19, 19, 560.00, '2017-12-09', 'Harry Potter Shop', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (20, 20, 47.00, '2017-12-21', 'Disney Store', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (21, 21, 56.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (22, 22, 76.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (23, 23, 38.00, '2017-12-14', 'Harry Potter Shop', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (24, 24, 56.00, '2017-12-02', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (25, 25, 4.00, '2017-12-02', 'Chocolate House', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (26, 26, 15.00, '2017-12-04', 'Disney Store', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (27, 27, 450.00, '2017-12-21', 'Disney Store', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (28, 28, 4.00, '2017-12-21', 'Chocolate House', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (29, 29, 47.00, '2017-12-08', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (30, 30, 460.00, '2017-12-22', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (31, 31, 14.00, '2017-12-24', 'Toy Planet', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (32, 32, 70.00, '2017-12-21', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (33, 33, 52.00, '2017-12-06', 'Harry Potter Shop', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (34, 34, 14.00, '2017-12-04', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (35, 35, 52.00, '2017-12-13', 'Harry Potter Shop', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (36, 36, 52.00, '2017-12-06', 'Harry Potter Shop', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (37, 37, 15.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (38, 38, 18.00, '2017-12-16', 'Harry Potter Shop', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (39, 39, 460.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (40, 40, 70.00, '2017-12-08', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (41, 41, 70.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (42, 42, 14.00, '2017-12-20', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (45, 45, 70.00, '2017-12-21', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (46, 46, 24.00, '2017-12-21', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (47, 47, 76.00, '2017-12-20', 'Disney Store', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (48, 48, 70.00, '2017-12-08', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (49, 49, 4.00, '2017-12-15', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (50, 50, 100.00, '2017-12-15', 'Toy Planet', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (51, 51, 90.00, '2017-12-14', 'Toy Planet', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (52, 52, 47.00, '2017-12-22', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (53, 53, 6.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (54, 54, 70.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (55, 55, 25.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (56, 56, 26.00, '2017-12-18', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (57, 57, 4.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (58, 58, 29.00, '2017-12-12', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (59, 59, 47.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (60, 60, 2.00, '2017-12-15', 'Chocolate House', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (61, 61, 17.00, '2017-12-16', 'Harry Potter Shop', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (62, 62, 76.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (63, 63, 4.00, '2017-12-21', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (64, 64, 4.00, '2017-12-19', 'Harry Potter Shop', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (65, 65, 4.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (66, 66, 6.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (67, 67, 38.00, '2017-12-12', 'Harry Potter Shop', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (68, 68, 4.00, '2017-12-22', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (69, 69, 15.00, '2017-12-19', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (70, 70, 52.00, '2017-12-23', 'Harry Potter Shop', '2017-12-23');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (71, 71, 70.00, '2017-12-09', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (72, 72, 460.00, '2017-12-04', 'Disney Store', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (73, 73, 250.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (74, 74, 76.00, '2017-12-10', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (75, 75, 38.00, '2017-12-06', 'Harry Potter Shop', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (76, 76, 7.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (77, 77, 90.00, '2017-12-19', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (78, 78, 6.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (79, 79, 86.00, '2017-12-20', 'Toy Planet', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (80, 80, 15.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (81, 81, 18.00, '2017-12-21', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (82, 82, 4.00, '2017-12-15', 'Harry Potter Shop', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (83, 83, 460.00, '2017-12-18', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (84, 84, 70.00, '2017-12-05', 'Disney Store', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (85, 85, 15.00, '2017-12-12', 'Toy Planet', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (86, 86, 100.00, '2017-12-22', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (87, 87, 7.00, '2017-12-15', 'Toy Planet', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (88, 88, 88.00, '2017-12-21', 'Toy Planet', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (90, 90, 15.00, '2017-12-20', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (91, 91, 4.00, '2017-12-09', 'Harry Potter Shop', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (92, 92, 2.00, '2017-12-20', 'Chocolate House', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (93, 93, 70.00, '2017-12-20', 'Disney Store', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (94, 94, 100.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (95, 95, 38.00, '2017-12-20', 'Harry Potter Shop', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (96, 96, 6.00, '2017-12-10', 'Toy Planet', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (97, 97, 30.00, '2017-12-08', 'Harry Potter Shop', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (98, 98, 70.00, '2017-12-20', 'Disney Store', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (99, 99, 7.00, '2017-12-04', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (100, 100, 460.00, '2017-12-23', 'Disney Store', '2017-12-23');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (101, 101, 4.00, '2017-12-22', 'Chocolate House', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (102, 102, 26.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (103, 103, 70.00, '2017-12-18', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (104, 104, 250.00, '2017-12-06', 'Harry Potter Shop', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (105, 105, 18.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (106, 106, 24.00, '2017-12-23', 'Toy Planet', '2017-12-23');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (107, 107, 56.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (108, 108, 76.00, '2017-12-18', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (109, 109, 29.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (110, 110, 450.00, '2017-12-13', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (111, 111, 18.00, '2017-12-09', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (112, 112, 52.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (113, 113, 37.00, '2017-12-18', 'Harry Potter Shop', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (114, 114, 460.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (115, 115, 17.00, '2017-12-09', 'Harry Potter Shop', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (116, 116, 90.00, '2017-12-24', 'Toy Planet', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (117, 117, 450.00, '2017-12-06', 'Disney Store', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (118, 118, 70.00, '2017-12-23', 'Disney Store', '2017-12-23');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (119, 119, 25.00, '2017-12-16', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (120, 120, 70.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (121, 121, 2.00, '2017-12-05', 'Chocolate House', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (122, 122, 23.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (123, 123, 80.00, '2017-12-02', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (124, 124, 124.00, '2017-12-24', 'Toy Planet', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (125, 125, 120.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (126, 126, 460.00, '2017-12-22', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (127, 127, 4.00, '2017-12-13', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (128, 128, 70.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (129, 129, 88.00, '2017-12-21', 'Toy Planet', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (131, 131, 5.00, '2017-12-21', 'Chocolate House', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (132, 132, 24.00, '2017-12-12', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (133, 133, 460.00, '2017-12-09', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (134, 134, 124.00, '2017-12-22', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (135, 135, 4.00, '2017-12-02', 'Harry Potter Shop', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (136, 136, 24.00, '2017-12-12', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (137, 137, 47.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (138, 138, 37.00, '2017-12-06', 'Harry Potter Shop', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (139, 139, 18.00, '2017-12-09', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (140, 140, 55.00, '2017-12-08', 'Toy Planet', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (141, 141, 3.00, '2017-12-18', 'Toy Planet', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (142, 142, 24.00, '2017-12-06', 'Toy Planet', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (143, 143, 35.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (144, 144, 90.00, '2017-12-21', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (145, 145, 90.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (146, 146, 7.00, '2017-12-10', 'Toy Planet', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (147, 147, 17.00, '2017-12-24', 'Harry Potter Shop', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (148, 148, 26.00, '2017-12-18', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (149, 149, 18.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (150, 150, 18.00, '2017-12-04', 'Harry Potter Shop', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (151, 151, 5.00, '2017-12-20', 'Chocolate House', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (152, 152, 450.00, '2017-12-13', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (153, 153, 37.00, '2017-12-13', 'Harry Potter Shop', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (154, 154, 250.00, '2017-12-24', 'Harry Potter Shop', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (155, 155, 3.00, '2017-12-20', 'World of Sweets', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (156, 156, 250.00, '2017-12-04', 'Harry Potter Shop', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (157, 157, 128.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (158, 158, 26.00, '2017-12-21', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (159, 159, 460.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (160, 160, 37.00, '2017-12-21', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (161, 161, 30.00, '2017-12-13', 'Harry Potter Shop', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (162, 162, 250.00, '2017-12-21', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (163, 163, 37.00, '2017-12-20', 'Harry Potter Shop', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (164, 164, 6.00, '2017-12-04', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (165, 165, 120.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (166, 166, 278.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (167, 167, 55.00, '2017-12-02', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (168, 168, 70.00, '2017-12-18', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (169, 169, 4.00, '2017-12-13', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (170, 170, 18.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (171, 171, 55.00, '2017-12-02', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (172, 172, 56.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (173, 173, 18.00, '2017-12-14', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (174, 174, 4.00, '2017-12-18', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (175, 175, 43.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (176, 176, 4.00, '2017-12-13', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (177, 177, 3.00, '2017-12-20', 'World of Sweets', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (179, 179, 2.00, '2017-12-08', 'Chocolate House', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (180, 180, 460.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (181, 181, 55.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (182, 182, 24.00, '2017-12-12', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (183, 183, 7.00, '2017-12-22', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (185, 185, 56.00, '2017-12-06', 'Disney Store', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (186, 186, 29.00, '2017-12-05', 'Disney Store', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (187, 187, 24.00, '2017-12-20', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (189, 189, 43.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (191, 191, 30.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (192, 192, 3.00, '2017-12-15', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (193, 193, 4.00, '2017-12-02', 'Harry Potter Shop', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (194, 194, 450.00, '2017-12-22', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (195, 195, 70.00, '2017-12-20', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (196, 196, 278.00, '2017-12-06', 'Disney Store', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (198, 198, 80.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (199, 199, 90.00, '2017-12-13', 'Harry Potter Shop', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (200, 200, 8.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (201, 201, 90.00, '2017-12-02', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (202, 202, 56.00, '2017-12-19', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (203, 203, 70.00, '2017-12-04', 'Disney Store', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (204, 204, 24.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (205, 205, 37.00, '2017-12-18', 'Harry Potter Shop', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (206, 206, 120.00, '2017-12-22', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (207, 207, 35.00, '2017-12-15', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (208, 208, 3.00, '2017-12-15', 'World of Sweets', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (209, 209, 8.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (210, 210, 278.00, '2017-12-16', 'Disney Store', '2017-12-19');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (211, 211, 29.00, '2017-12-21', 'Disney Store', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (212, 212, 18.00, '2017-12-04', 'Harry Potter Shop', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (213, 213, 7.00, '2017-12-18', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (214, 214, 8.00, '2017-12-22', 'Harry Potter Shop', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (216, 216, 37.00, '2017-12-09', 'Harry Potter Shop', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (217, 217, 128.00, '2017-12-09', 'Toy Planet', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (218, 218, 7.00, '2017-12-07', 'Toy Planet', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (219, 219, 3.00, '2017-12-21', 'World of Sweets', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (220, 220, 80.00, '2017-12-10', 'Toy Planet', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (221, 221, 7.00, '2017-12-20', 'Toy Planet', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (222, 222, 24.00, '2017-12-02', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (223, 223, 8.00, '2017-12-24', 'Harry Potter Shop', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (224, 224, 35.00, '2017-12-06', 'Toy Planet', '2017-12-11');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (225, 225, 70.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (226, 226, 56.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (227, 227, 120.00, '2017-12-24', 'Disney Store', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (228, 228, 3.00, '2017-12-20', 'World of Sweets', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (229, 229, 18.00, '2017-12-07', 'Harry Potter Shop', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (230, 230, 460.00, '2017-12-15', 'Disney Store', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (231, 231, 7.00, '2017-12-20', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (232, 232, 3.00, '2017-12-22', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (233, 233, 26.00, '2017-12-04', 'Disney Store', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (234, 234, 23.00, '2017-12-20', 'Toy Planet', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (235, 235, 3.00, '2017-12-20', 'World of Sweets', '2017-12-21');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (236, 236, 56.00, '2017-12-07', 'Disney Store', '2017-12-14');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (237, 237, 460.00, '2017-12-15', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (238, 238, 278.00, '2017-12-13', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (239, 239, 4.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (240, 240, 80.00, '2017-12-22', 'Toy Planet', '2017-12-22');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (241, 241, 120.00, '2017-12-20', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (242, 242, 19.00, '2017-12-04', 'Toy Planet', '2017-12-10');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (243, 243, 80.00, '2017-12-15', 'Toy Planet', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (244, 244, 56.00, '2017-12-12', 'Disney Store', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (245, 245, 450.00, '2017-12-10', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (246, 246, 35.00, '2017-12-13', 'Toy Planet', '2017-12-18');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (247, 247, 4.00, '2017-12-09', 'Disney Store', '2017-12-15');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (248, 248, 19.00, '2017-12-15', 'Toy Planet', '2017-12-17');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (249, 249, 120.00, '2017-12-24', 'Disney Store', '2017-12-24');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (250, 250, 278.00, '2017-12-19', 'Disney Store', '2017-12-20');
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (2, 2, 14.00, '2017-12-24', 'Toy Planet', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (44, 44, 5.00, '2017-12-07', 'Toy Planet', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (188, 188, 4.00, '2017-12-24', 'Harry Potter Shop', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (197, 197, 29.00, '2017-12-12', 'Disney Store', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (215, 215, 18.00, '2017-12-21', 'Disney Store', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (89, 89, 70.00, '2017-12-24', 'Disney Store', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (6, 6, 100.00, NULL, 'Toy Planet', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (43, 43, 4.00, NULL, 'Disney Store', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (130, 130, 250.00, NULL, 'Harry Potter Shop', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (178, 178, 80.00, NULL, 'Toy Planet', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (184, 184, 6.00, NULL, 'Toy Planet', NULL);
INSERT INTO purchase (id, request_id, price, order_date, store, delivery_date) VALUES (190, 190, 3.00, NULL, 'Toy Planet', NULL);




ALTER TABLE ONLY children
    ADD CONSTRAINT children_pkey PRIMARY KEY (id);

ALTER TABLE ONLY country
    ADD CONSTRAINT country_pkey PRIMARY KEY (id);



ALTER TABLE ONLY letter
    ADD CONSTRAINT letter_pkey PRIMARY KEY (id);

ALTER TABLE ONLY request
    ADD CONSTRAINT request_pkey PRIMARY KEY (id);



ALTER TABLE ONLY purchase
    ADD CONSTRAINT shedule_pkey PRIMARY KEY (id);



ALTER TABLE ONLY toy
    ADD CONSTRAINT toy_pkey PRIMARY KEY (id);

ALTER TABLE ONLY children
    ADD CONSTRAINT children_country_id_fkey FOREIGN KEY (country_id) REFERENCES country(id);



ALTER TABLE ONLY letter
    ADD CONSTRAINT letter_children_id_fkey FOREIGN KEY (children_id) REFERENCES children(id);



ALTER TABLE ONLY request
    ADD CONSTRAINT request_letter_id_fkey FOREIGN KEY (letter_id) REFERENCES letter(id);



ALTER TABLE ONLY request
    ADD CONSTRAINT request_toy_id_fkey FOREIGN KEY (toy_id) REFERENCES toy(id);



ALTER TABLE ONLY purchase
ADD CONSTRAINT shedule_request_id_fkey FOREIGN KEY (request_id) REFERENCES request(id);
