text: 
  INSERT INTO role (id, code, label)
  VALUES (1, 'ROLE_USER', 'User');
  INSERT INTO role (id, code, label) 
  VALUES (2, 'ROLE_ADMIN', 'Admin');
  INSERT INTO role (id, code, label) 
  VALUES (3, 'ROLE_SYSADMIN', 'System Admin');
  
  INSERT INTO account (username, password, enabled, credentialsexpired, expired, locked) 
  VALUES ('jane', '$2a$04$wAfjP9FidceDBvtM.w4N4uMt25h6l4A/GOmLoeKm8ifZTnxKRn/26', true, false, false, false);
  INSERT INTO account (username, password, enabled, credentialsexpired, expired, locked) 
  VALUES ('pete', '$2a$04$wAfjP9FidceDBvtM.w4N4uMt25h6l4A/GOmLoeKm8ifZTnxKRn/26', true, false, false, false);
  INSERT INTO account (username, password, enabled, credentialsexpired, expired, locked) 
  VALUES ('shogo', '$2a$04$wAfjP9FidceDBvtM.w4N4uMt25h6l4A/GOmLoeKm8ifZTnxKRn/26', true, false, false, false);
  INSERT INTO account (username, password, enabled, credentialsexpired, expired, locked) 
  VALUES ('kris', '$2a$04$wAfjP9FidceDBvtM.w4N4uMt25h6l4A/GOmLoeKm8ifZTnxKRn/26', true, false, false, false);
  
  INSERT INTO profile (account_id, firstname, lastname, email, phone_number, picture_link, website, facebook,
  about, date_of_registration) 
  VALUES (1, 'Janice', 'Jones', 'jane@example.com', '062/123456', 
  'https://i.guim.co.uk/img/static/sys-images/Media/Pix/pictures/2011/7/20/1311186215351/Janice-Hadlow-007.
  jpg?w=470&q=55&auto=format&usm=12&fit=max&s=dad4c5433205104558516bc23c823f7b',
  'http://www.somelink1.rs', 'http://www.facebook/someprofile1',
  'My name is Jane, and I enjoy meeting new people and finding ways to help them have an uplifting experience. 
  I have had a variety of customer service opportunities, through which I was able to have fewer returned products and 
  increased repeat customers, when compared with co-workers. I am dedicated, outgoing, and a team player.','2016-01-19');
  INSERT INTO profile (account_id, firstname, lastname, email, phone_number, picture_link, website, facebook,
  about, date_of_registration) 
  VALUES (2, 'Peter', 'Peterson', 'pete@example.com', '062/223456', 
  'http://www.istanbulexpats.com/wp-content/uploads/2014/11/odd-job-handyman-istanbul.jpg', 
  'http://www.somelink2.rs', 'http://www.facebook/someprofile2',
  'People find me to be an upbeat, self-motivated team player with excellent communication skills.
   For the past several years I have worked in lead qualification, telemarketing, and customer service in the technology industry.
   My experience includes successfully calling people in director-level positions of technology departments
   and developing viable leads. ', '2015-08-22');
  INSERT INTO profile (account_id, firstname, lastname, email, phone_number, picture_link, website, facebook,
  about, date_of_registration) 
  VALUES (3, 'Makishima', 'Shogo', 'shogo@example.com', '062/323456',
  'http://www.kicnano.cornell.edu/wp-content/uploads/2010/12/shogo-hamada-pic.jpg',
  'http://www.somelink2.rs', 'http://www.facebook/someprofile2',
  'I am a dedicated person with a family of four. I enjoy reading, and the knowledge and perspective that my reading gives
   me has strengthened my teaching skills and presentation abilities. I have been successful at raising a family, and 
  I attribute this success to my ability to plan, schedule, and handle many different tasks at once. This flexibility 
  will help me in the classroom, where there are many different personalities and learning styles.', '2014-11-30');
  INSERT INTO profile (account_id, firstname, lastname, email, phone_number, picture_link, website, facebook,
  about, date_of_registration) 
  VALUES (4, 'Kristofer', 'Dahl', 'kris@example.com', '062/8053456',
  'http://ll-media.tmz.com/2015/10/02/1002-kristofer-buckle-getty-4.jpg',
  'http://www.somelink3.rs', 'http://www.facebook/someprofile3',
  'I am an experienced professional hairdresser. I enjoy working on challenging cases, and learning new things that will  help
  work on my skills and creative abilities. I have been highly successful at achieving world renowned results, and 
  I attribute this success to my ability to organize, assess, and implement. This abliity 
  will help me achieve the best results, while maintaining a professional demeanor.', '2014-11-30');
  
  INSERT INTO account_role (account_id, role_id) VALUES (1, 1);
  INSERT INTO account_role (account_id, role_id) VALUES (2, 1);
  INSERT INTO account_role (account_id, role_id) VALUES (2, 2);
  INSERT INTO account_role (account_id, role_id) VALUES (3, 1);
  INSERT INTO account_role (account_id, role_id) VALUES (3, 2);
  INSERT INTO account_role (account_id, role_id) VALUES (3, 3);
  INSERT INTO account_role (account_id, role_id) VALUES (4, 1);
  
  
  INSERT INTO category (name) VALUES ('Therapy');
  INSERT INTO category (name) VALUES ('Technology');
  INSERT INTO category (name) VALUES ('Education');
  INSERT INTO category (name) VALUES ('Cosmetics');
  INSERT INTO category (name) VALUES ('Design');
  
  INSERT INTO service (name, category_id) VALUES ('Massage', 1);
  INSERT INTO service (name, category_id) VALUES ('Physiotherapy', 1);
  INSERT INTO service (name, category_id) VALUES ('Plumbing', 2);
  INSERT INTO service (name, category_id) VALUES ('Electrical maintenance', 2);
  INSERT INTO service (name, category_id) VALUES ('Computer repair', 2);
  INSERT INTO service (name, category_id) VALUES ('Car mechanics', 2);
  INSERT INTO service (name, category_id) VALUES ('English lessons', 3);
  INSERT INTO service (name, category_id) VALUES ('Guitar lessons', 3);
  INSERT INTO service (name, category_id) VALUES ('Swimming lessons', 3);
  INSERT INTO service (name, category_id) VALUES ('Manicure/pedicure', 4);
  INSERT INTO service (name, category_id) VALUES ('Hairstyling', 4);
  INSERT INTO service (name, category_id) VALUES ('Makeup', 4);
  INSERT INTO service (name, category_id) VALUES ('Face treatment', 4);
  INSERT INTO service (name, category_id) VALUES ('Graphic design', 5);
  INSERT INTO service (name, category_id) VALUES ('Web design', 5);
  INSERT INTO service (name, category_id) VALUES ('Interior design', 5);
  INSERT INTO service (name, category_id) VALUES ('Tailoring/sewing', 5);
  
  INSERT INTO deal (profile_id, service_id, service_cost, description, long_description) 
  VALUES (1, 1, 1200.0, 'Shiatsu massage, now on discount!',
  'Over four years of physical therapy experience, working with progressively more challenging 
  cases and more diverse clients.');
  INSERT INTO deal (profile_id, service_id, service_cost, description, long_description) 
  VALUES (2, 3, 950.0, 'All types of plumbing maintenance!', 
  'Nine years of experience developing, implementing, and managing complex projects 
  within time and budgetary constraings.');
  INSERT INTO deal (profile_id, service_id, service_cost, description, long_description) 
  VALUES (3, 7, 500.0, 'Prepare for your IELTS certification!',
  'More than six years of advanced English teaching experience, with strong emphasis on  
  business skills and a broad range of teaching methods.');
  INSERT INTO deal (profile_id, service_id, service_cost, description, long_description) 
  VALUES (2, 12, 1000.0, 'Pro makeup for all occasions: weddings, birthdays, parties...', 
  'A self-motivated and organized professional with over 10 years of experience providing thorough and skillful
  support to aforementioned department.');
  INSERT INTO deal (profile_id, service_id, service_cost, description, long_description) 
  VALUES (4, 11, 2400.0, 'Professional hairdresser, for both men and women.', 
  'I am a professional hairdresser with over 20 years of experience having worked with the most demanding
  styles and customers.');
  
  INSERT INTO location (country, city, street, number, latitude, longitude, deal_id) 
  VALUES ('Serbia', 'Novi Sad', 'Branka Bajica', '46', 45.258327, 19.821259, 1);
  INSERT INTO location (country, city, street, number, latitude, longitude, deal_id) 
  VALUES ('Serbia', 'Novi Sad', 'Todora Toze Jovanovica', '13', 45.254718, 19.804984, 2);
  INSERT INTO location (country, city, street, number, latitude, longitude, deal_id) 
  VALUES ('Serbia', 'Novi Sad', 'Isidore Sekulic', '5',45.249271, 19.799630, 3);
  INSERT INTO location (country, city, street, number, latitude, longitude, deal_id) 
  VALUES ('Serbia', 'Novi Sad', 'Jovana Popovica', '18',45.245052, 19.811276, 4);
  INSERT INTO location (country, city, street, number, latitude, longitude, deal_id) 
  VALUES ('Serbia', 'Novi Sad', 'Bulevar Oslobodjenja', '33',45.259742, 19.832404, 5);
  
  INSERT INTO rating (comment, customer_name, time_of_rating, rating, deal_id) 
  VALUES ('Awesome! I highly recommend it!', 'CicaMica', now(), 5, 1);
  INSERT INTO rating (comment, customer_name, time_of_rating, rating, deal_id) 
  VALUES ('Not too bad..', 'Anonymous', now(), 4, 2);
  INSERT INTO rating (comment, customer_name, time_of_rating, rating, deal_id) 
  VALUES ('not really that great, tbh...', 'jblnk', now(), 2, 3);
  INSERT INTO rating (comment, customer_name, time_of_rating, rating, deal_id) 
  VALUES ('its really as good as it says', 'Anonymous', now(), 5, 5);
  
  