TripOn

This task is to extend the hotel_master table by adding login credentials for each hotel. When a hotel is created, the system should automatically generate a username and password. The username will be created using the hotel ID and hotel name, replacing spaces with underscores. The password will be automatically generated by the system. After creating the credentials, the system should send the username and password to the hotel’s email address so the hotel can log in to the system.

Table

hotel_master(Updated Fileds)

• email VARCHAR(150) Hotel email address
• username VARCHAR(200) Auto-generated login username
• password VARCHAR(255) Auto-generated password (stored encrypted)
• is_active BOOLEAN DEFAULT TRUE Active / inactive status

Validations

Email

• Must be valid email format

Duplicate

• Prevent duplicate email.
• Each hotel must have a unique email.

Username

• Username must be unique
• System generated
• Cannot be manually edited
• Username should be created automatically
• if the hotel name has spaces, replace them with underscore(_)
• All characters should be converted to lowercase

Password

• Must be auto generated
• Must be encrypted before saving
• Cannot store plain password