INSERT INTO `sf_guard_group` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Boss group', '2017-11-14 11:48:47', '2017-11-14 11:48:47'),
(2, 'sales', 'Sales group', '2017-12-06 23:33:00', '2017-12-06 23:33:00'),
(3, 'partner', 'Affiliate partner group', '2018-04-13 17:51:43', '2018-04-13 17:51:43'),
(4, 'client-plus', 'Plus user group', '2018-04-13 17:51:43', '2018-04-13 17:51:43'),
(5, 'client-pro', 'Pro user group', '2018-04-13 17:51:43', '2018-04-13 17:51:43');

INSERT INTO `sf_guard_permission` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator permission', '2017-11-14 11:48:47', '2017-11-14 11:48:47'),
(2, 'sales', 'Sales permission', '2017-12-06 23:33:00', '2017-12-06 23:33:00'),
(3, 'partner', 'Partner permission', '2018-04-13 17:55:00', '2018-04-13 17:55:00'),
(4, 'client-plus', 'Client Plus permission', '2018-01-08 23:58:00', '2018-01-08 23:58:00'),
(5, 'client-pro', 'Client Pro permission', '2018-01-08 23:58:00', '2018-01-08 23:58:00');

INSERT INTO `sf_guard_group_permission` (`group_id`, `permission_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2017-11-14 11:48:47', '2017-11-14 11:48:47'),
(1, 2, '2017-12-06 23:33:00', '2017-12-06 23:33:00'),
(1, 3, '2018-04-13 17:58:00', '2018-04-13 17:58:00'),
(1, 4, '2018-04-13 17:58:00', '2018-04-13 17:58:00'),
(1, 5, '2018-04-13 17:58:00', '2018-04-13 17:58:00'),
(2, 2, '2017-12-07 01:42:15', '2017-12-07 01:42:15'),
(3, 3, '2018-04-13 17:58:00', '2018-04-13 17:58:00'),
(4, 4, '2018-04-13 17:58:00', '2018-04-13 17:58:00'),
(5, 4, '2018-04-13 17:58:00', '2018-04-13 17:58:00'),
(5, 5, '2018-04-13 17:58:00', '2018-04-13 17:58:00');

INSERT INTO `sf_guard_user_group` (`user_id`, `group_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2017-10-12 00:05:41', '2017-10-12 00:05:41');


--SUBSCRIPTION
INSERT INTO `subscription` (`id`, `name`, `vat_id`, `country`, `zip`, `city`, `address`, `package`, `validity_date`, `created_at`, `updated_at`) VALUES
(1, 'Velvel Kft', '14759817-2-05', 'hu', '3593', 'Hejőbába', 'Széchenyi u. 21.', 'free', NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

INSERT INTO `subscription_event` (`subscription_id`, `user_id`, `company_id`, `type`, `comment`, `created_at`) VALUES
(1, 1, 1, 'register', 'package: free', '2017-10-12 00:05:41');


--COMPANY
INSERT INTO `company` (`id`, `website`, `created_at`, `updated_at`) VALUES
(1, 'velvel.hu', '2017-12-12 00:05:41', '2017-12-12 00:05:41');


--COMPANY-USER-SUBSCRIPTION
INSERT INTO `company_user_relation` (`user_id`, `company_id`) VALUES
(1, 1);

INSERT INTO `company_subscription_relation` (`subscription_id`, `company_id`) VALUES
(1, 1);


--AGENT
INSERT INTO `agent_profile` (`nickname`, `percent`, `is_active`, `subscription_id`, `created_at`, `updated_at`) VALUES ('sys', 0, 1, 1, '2018-04-19 02:41:31', '2018-04-19 02:41:31');