text: --
  -- Table structure for table `user`
  --
  
  CREATE TABLE `user` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `created_by` varchar(255) NOT NULL,
    `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_modified_by` varchar(255) NOT NULL,
    `last_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `isAccountNonExpired` bit(1) DEFAULT NULL,
    `isAccountNonLocked` bit(1) DEFAULT NULL,
    `isCredentialsNonExpired` bit(1) DEFAULT NULL,
    `isEnabled` bit(1) DEFAULT NULL,
    `password` varchar(255) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `UK_sb8bbouer5wak8vyiiy4pf2bx` (`username`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Table structure for table `permission`
  --
  
  CREATE TABLE `permission` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `created_by` varchar(255) NOT NULL,
    `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_modified_by` varchar(255) NOT NULL,
    `last_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
  
  --
  -- Table structure for table `role`
  --
  
  CREATE TABLE `role` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `created_by` varchar(255) NOT NULL,
    `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_modified_by` varchar(255) NOT NULL,
    `last_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `name` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
  
  --
  -- Table structure for table `permission_role`
  --
  
  CREATE TABLE `permission_role` (
    `role_id` bigint(20) NOT NULL,
    `permission_id` bigint(20) NOT NULL,
    KEY `FK3tuvkbyi6wcytyg21hvpd6txw` (`permission_id`),
    KEY `FK50sfdcvbvdaclpn7wp4uop4ml` (`role_id`),
    CONSTRAINT `FK3tuvkbyi6wcytyg21hvpd6txw` FOREIGN KEY (`permission_id`) REFERENCES `permission` (`id`),
    CONSTRAINT `FK50sfdcvbvdaclpn7wp4uop4ml` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; 
  
  --
  -- Table structure for table `role_user`
  --
  
  CREATE TABLE `role_user` (
    `user_id` bigint(20) NOT NULL,
    `role_id` bigint(20) NOT NULL,
    KEY `FKiqpmjd2qb4rdkej916ymonic6` (`role_id`),
    KEY `FK4320p8bgvumlxjkohtbj214qi` (`user_id`),
    CONSTRAINT `FK4320p8bgvumlxjkohtbj214qi` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
    CONSTRAINT `FKiqpmjd2qb4rdkej916ymonic6` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Table structure for table `verification_token`
  --
  
  CREATE TABLE `verification_token` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    `last_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_modified_by` varchar(255) NOT NULL,
    `expiry_date` datetime DEFAULT NULL,
    `token` varchar(255) DEFAULT NULL,
    `status` varchar(255) DEFAULT NULL,
    `user_id` bigint(20) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `FKrdn0mss276m9jdobfhhn2qogw` (`user_id`),
    CONSTRAINT `FKrdn0mss276m9jdobfhhn2qogw` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
  
  --
  -- Table structure for table `refresh_token`
  --
  
  CREATE TABLE `refresh_token` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `created_date` datetime DEFAULT NULL,
    `created_by` varchar(255) NOT NULL,
    `last_modified_date` datetime DEFAULT NULL,
    `last_modified_by` varchar(255) NOT NULL,
    `token` varchar(255) DEFAULT NULL,
    `username` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;