INSERT INTO hw2_role (name, description) values ('demo', 'Limited access for viewing demo slides');
INSERT INTO hw2_user (password, login_count, first_name, last_name, address_1, address_2, city, state, zipcode, laboratory, company, phone, email, shipping_no, confirmed_at, active, last_login_at, last_login_ip, sample_return_requested, current_login_at, current_login_ip, country_id, aws_payment_to_date) VALUES ('$pbkdf2-sha512$12000$HSMEoDTGGGPsvRdijLFWSg$kIsyU4k2vpqgK30ZTYkWkWIHBTdE50eaBgMQLmS5VE7saYUojJIeMhiWE5VmBS.j3RWq/PXthGVuJWQ8Tlt4KQ',1,'Demo','User','123 Demo Road','','New York','NY','10024','Demo Laboratory','Demo Company','212-555-1212','demo@histowiz.com','','2015-07-21 16:51:29',1,'2015-07-21 23:51:32','127.0.0.1',0,'2015-07-21 23:51:32','127.0.0.1',233,0.00);
INSERT INTO hw2_user_role (user_id, role_id) SELECT u.id, r.id FROM hw2_user u, hw2_role r where u.email='demo@histowiz.com' and r.name='demo';