Setup

Please execute this SQL scripts to setup the website on your server.

Person table

INSERT INTO `person` (`id`, `username`, `username_canonical`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `confirmation_token`, `password_requested_at`, `roles`) VALUES
(1, 'PP-0001', 'pp-0001', 'nicolas.boulfroy@hotmail.fr', 'nicolas.boulfroy@hotmail.fr', 1, NULL, '$2y$13$YB87URRl19CHP2ux8Im0U.7UyPjvyqIhMAVJ5Ut/PZjtjntpTxGRy', '2018-01-28 14:32:23', NULL, NULL, 'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}'),
(2, 'PP-0002', 'pp-0002', 'pierre@osef.com', 'pierre@osef.com', 1, NULL, '$2y$13$4LBtpJGm3Gf7E5b8G6guSO5kl87q.VLvzQw2bWjngkWF0qhnRopPy', '2018-01-28 14:29:07', NULL, NULL, 'a:1:{i:0;s:15:\"ROLE_PROSPECTOR\";}'),
(3, 'PP-0003', 'pp-0003', 'michel@osef.com', 'michel@osef.com', 1, NULL, '$2y$13$wruSCguoqKzbNj6xwi3jTu.VUHt4X6USLhs4GEU0aHBFQvREOJyfC', '2018-01-28 14:29:25', NULL, NULL, 'a:1:{i:0;s:15:\"ROLE_ACCOUNTANT\";}'),
(4, 'PP-0004', 'pp-0004', 'charles@osef.com', 'charles@osef.com', 1, NULL, '$2y$13$f5Wt2gaMmuU9BSMhMD6RCO0ovKwJrDRtk81LYJjwa5JYz8h.C3ze.', '2018-01-28 14:29:35', NULL, NULL, 'a:1:{i:0;s:15:\"ROLE_SUPERVISOR\";}');

Power table

INSERT INTO `power`(`id`, `designation`, `cost`) VALUES 
(1, '4CV', 0.493), (2, '5CV', 0.543), (3, '6CV', 0.568), (4, '7CV', 0.595);

Car table

INSERT INTO `car`(`id`, `power_id`, `numberPlate`) VALUES 
(1, 1, 'DE57UGK');

Profile table

INSERT INTO `profile`(`id`, `person_id`, `car_id`, `lastName`, `firstName`, `mobilePhoneNumber`, `phoneNumber`) VALUES 
(1, 2, 1, 'SILVERLIGHT', 'Bill', '0646581978', '0148963349');