BEGIN;
-- User

INSERT INTO
 users(`name`,lastName,email,`password`,created_at,updated_at)
 VALUES('admin','user','admin@developmentlogics.com','$2y$10$BdE6z5dK0CuBg48MCFz3T.dy51Df.DeijYwbzM5tbkyialIhEnllm',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());


-- Attendance Type

INSERT INTO
 attendance_requests(`name`)
 VALUES('Biometric');

INSERT INTO
 attendance_requests(`name`)
 VALUES('Self Service');

INSERT INTO
 attendance_requests(`name`)
 VALUES('On Request');


 -- Permission Type

 INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Administration Module','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Apply Leave','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Holiday Calendar','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Shift Management','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Attendance','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Notification','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP()); 

INSERT INTO
 permissions(`name`,guard_name,created_at,updated_at)
 VALUES('Report','web',CURRENT_TIMESTAMP(),CURRENT_TIMESTAMP());

INSERT INTO roles (`id`, `name`, `guard_name`, `created_at`,`updated_at`) VALUES ('1', 'admin', 'web' ,'2019-10-03 11:38:27','2019-10-03 11:38:27');
INSERT INTO role_has_permissions (`permission_id`, `role_id`) VALUES ('1', '1');
INSERT INTO model_has_roles (`role_id`, `model_type`, `model_id`) VALUES ('1', 'App\\Models\\Auth\\User', '1');

INSERT INTO `buffer_ons`(`id`, `buffer_on`) VALUES (1,`Check In`);
INSERT INTO `buffer_ons`(`id`, `buffer_on`) VALUES (2,`Check Out`);
INSERT INTO `buffer_ons`(`id`, `buffer_on`) VALUES (3,`Total Time`);

 
 COMMIT;