Permanent Users List Not Loading - Database Schema Mismatch

[mrtshoot]

The permanent users list page fails to load when attempting to view users in the system. The endpoint returns an error instead of displaying the user list.

What's Happening

When trying to access the permanent users section, the system attempts to retrieve user statistics (counting users by their status), but encounters a problem because the expected database structure doesn't match what the code is looking for.

Impact

• Cannot view the list of permanent users
• Unable to manage or interact with permanent users through the web interface
• API calls to retrieve permanent users fail

Steps to Reproduce

1. Log into the system
2. Navigate to the Permanent Users section
3. The page fails to load or shows an error
4. Check error logs to see database-related errors

Request URL Example

GET /cake4/rd_cake/permanent-users/index.json?cloud_id=24&token=XXX

[Andile-coder]

same issue permanent user is missing the admin_state column

[linjun771]

Add updated SQL. By default only the basic rd.sql and min.sql are built.