25/01/09

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

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.