insert.sql

INSERT INTO postcodes VALUES ("BT1 5DP", "Northern Ireland", "Belfast", "Down");
INSERT INTO postcodes VALUES ("BN7 0AH", "Northern Ireland", "Lurgan", "Armagh");
INSERT INTO postcodes VALUES ("BT1 1QF", "Northern Ireland", "Belfast", "Down");
INSERT INTO postcodes VALUES ("L3 9RF", "England", "Liverpool", "Lancashire");
INSERT INTO postcodes VALUES ("M3 7GJ", "England", "London", "Kent");

INSERT INTO accounts VALUES (null, 89, "2017/10/04", 0);
INSERT INTO accounts VALUES (null, 8, "2017/10/04", 0);
INSERT INTO accounts VALUES (null, 456, "2017/10/03", 0);
INSERT INTO accounts VALUES (null, 829, "2017/10/02", 0);

INSERT INTO customers VALUES (null, "Alex", "Robinson", "1970/06/24", 'm', "52 Old Edinburgh Road", "07758081437", "arob@gmail.com", "BT1 5DP");
INSERT INTO customers VALUES (null, "Francesca", "Hanson", "1995/02/25", 'f', "15 Cunnery Rd", "07754356242", "fhanson@hotmail.com", "BN7 0AH");
INSERT INTO customers VALUES (null, "Nicole", "Carpenter", "1987/03/17", 'f', "59 Petworth Rd", "07817318863", "ncarp@outlook.com", "BT1 1QF");
INSERT INTO customers VALUES (null, "Finlay", "Clark", "1977/06/06", 'm', "24 Princes Street", "07010123183", "finlayc@live.co.uk", "L3 9RF");
INSERT INTO customers VALUES (null, "Evie", "Lord", "1982/01/30", 'f', "12 Nenthead Road", "07963731473", "elord@gmail.com", "M3 7GJ");

INSERT INTO customers_accounts VALUES (1, 1);
INSERT INTO customers_accounts VALUES (2, 2);
INSERT INTO customers_accounts VALUES (3, 3);
INSERT INTO customers_accounts VALUES (4, 4);