# 25/01/09

* Added new base to migration.sql for ui users.

```sql
CREATE TABLE IF NOT EXISTS user_ui (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    access INTEGER DEFAULT 0,
    created TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
```

* Creation of functions: addUser, getUserById, getUserByName, updatePassword, updateAccess, deleteUserById, getAllUsers, verifyCredentials, getUsersByAccess. in the server part to use the database.
