insert into contactsdb.users (id, username, password, enabled) values('1', 'admin', 'admin', true);

insert into contactsdb.authorities (username, authority) values ('admin', 'ROLE_USER');

insert into contactsdb.contacts 
(id, first_name, last_name, priority, phone_nums, email, web_page, photo_uri)
values('1', 'James', 'McCabe', '9', '07812945617', 
'jamesc@oranda.com', 'http://www.oranda.com', 'JamesMcCabe.jpg');

insert into contactsdb.contacts 
(id, first_name, last_name, priority, phone_nums, email, web_page, photo_uri)
values('2', 'Mrs', 'Wheedle', '5', 
'07882064482 020-86396655', 'wheedle@hotmail.com',  
'http://www.geocities.com/homespace/wheedle', 'MrsWheedle.jpg');
                                                               
insert into contactsdb.contacts 
(id, first_name, last_name, priority, phone_nums, email, web_page, photo_uri)
values('3', 'Maria', 'Eli', '5', '020-34893098', 
'elielim339@hotmail.com', 'http://www.maria-eli.com', 'MariaEli.jpg');

insert into contactsdb.contacts 
(id, first_name, last_name, priority, phone_nums, email, web_page, photo_uri)
values('4', 'Reginald', 'X', '5', '021-34098777', 
'regex3423@gmail.com', 'http://home.yahoo.com/regex', 
'http://public-domain-photos.com/free-stock-photos-4-big/people//face-13.jpg');

insert into contactsdb.contacts 
(id, first_name, last_name, priority, phone_nums, email, web_page, photo_uri)
values('5', 'JoeMary', 'Jones', '5', '07813945617', 
'marylovesjoe@freemail.com', 'http://myspace.com/maryjoe', 'JoeMaryJones.jpg');

insert into contactsdb.comments 
(id, comment_text, comment_date, user_id, contact_id)
values('1', 'Creator of WebOfContacts', now(), 1, 1);

insert into contactsdb.comments  
(id, comment_text, comment_date, user_id, contact_id)
values('2', 'Request for new glasses', now(), 1, 2);

insert into contactsdb.comments  
(id, comment_text, comment_date, user_id, contact_id)
values('3', 
'Order for musical instruments line item 1, line item 2, etc', now(), 1, 3);

insert into contactsdb.comments  
(id, comment_text, comment_date, user_id, contact_id)
values('4', 'Order was cancelled', now(), 1, 4);

insert into contactsdb.comments  
(id, comment_text, comment_date, user_id, contact_id)
values('5', 'Joint bank account', now(), 1, 5);                                          

insert into contactsdb.comments  
(id, comment_text, comment_date, user_id, contact_id)
values('6', 'Age 83', now(), 1, 2);