--liquibase formatted sql

--changeset jason:insert group authority
--comment: insert group authority

LOCK TABLES `authority` WRITE;
/*!40000 ALTER TABLE `authority` DISABLE KEYS */;
INSERT INTO `authority` VALUES (1,'SUPPRESS_REMINDER','Suppress Reminder','Reminder','Allow to suppress reminder'),(2,'VIEW_EVENT','View Event','Event','Allow to view event'),(3,'EDIT_EVENT','Edit Event','Event','Allow to edit event'),(4,'DELETE_EVENT','Delete Event','Event','Allow to delete event'),(5,'VIEW_APPLICATION','View Application','Application','Allow to view application'),(6,'EDIT_APPLICATION','Edit Application','Application','Allow to edit application'),(7,'DELETE_APPLICATION','Delete Application','Application','Allow to delete application'),(8,'VIEW_AWARD','View Award','Award','Allow to view award'),(9,'EDIT_AWARD','Edit Award','Award','Allow to edit award'),(10,'DELETE_AWARD','Delete Award','Award','Allow to delete award'),(11,'MAINTAIN_CATEGORY','Maintain Category','System Administration','Allow to maintain category'),(12,'MAINTAIN_TAG','Maintain Tag','System Administration','Allow to maintain tag'),(13,'MAINTAIN_PROMOTION_CHANNEL','Maintain Promotion Channel','System Administration','Allow to maintain promotion channel'),(14,'MAINTAIN_DIVISION','Maintain Division','System Administration','Allow to maintain division'),(15,'MAINTAIN_USER_GROUP','Maintain User Group','System Administration','Allow to maintain user group'),(16,'MAINTAIN_USER','Maintain User','System Administration','Allow to maintain user'),(17,'VIEW_AUDIT_LOG','View Audit Log','System Administration','Allow to view audit log'),(18,'VIEW_LOGIN_LOG','View Login Log','System Administration','Allow to view login log'),(19,'MANAGE_PASSWORD_POLICY','Manage Password Policy','System Administration','Allow to manage password policy'),(20,'MANAGE_SYSTEM_CONFIGURATION','Manage System Configuration','System Administration','Allow to manage system configuration'),(21,'VIEW_ALL_RECORD','View All Records','Other','\"Allow to view all records in event, application and award\"'),(22,'EDIT_ALL_RECORD','Edit All Records','Other','\"Allow to view all records in event, application and award\"');
/*!40000 ALTER TABLE `authority` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `group`
--

LOCK TABLES `group` WRITE;
/*!40000 ALTER TABLE `group` DISABLE KEYS */;
INSERT INTO `group` VALUES 
    (1,'2023-10-04 14:37:26',1,0,'2023-10-04 14:37:26',1,0,'Viewer','Viewer Group'),
    (2,'2023-10-04 14:38:02',1,0,'2023-10-04 14:38:02',1,0,'Editor','Editor Group'),
    (3,'2023-10-04 14:39:11',1,0,'2023-10-04 14:39:11',1,0,'System Administrator','System Administrator Group'),
    (4,'2023-10-04 14:38:02',1,0,'2023-10-04 14:38:02',1,0,'Editor 2','Editor Group 2')
    ;
/*!40000 ALTER TABLE `group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `group_authority`
--

LOCK TABLES `group_authority` WRITE;
/*!40000 ALTER TABLE `group_authority` DISABLE KEYS */;
INSERT INTO `group_authority` VALUES (1,2),(1,5),(1,8),(2,1),(2,2),(2,3),(2,4),(2,5),(2,6),(2,7),(2,8),(2,9),(2,10),(3,1),(3,2),(3,3),(3,4),(3,5),(3,6),(3,7),(3,8),(3,9),(3,10),(3,11),(3,12),(3,13),(3,14),(3,15),(3,16),(3,17),(3,18),(3,19),(3,20),(3,21),(3,22);
/*!40000 ALTER TABLE `group_authority` ENABLE KEYS */;
UNLOCK TABLES;
