Handling Users

• Your users table might start out like

create table users (
        user_id                 integer primary key,
        first_names             varchar(50),
        last_name               varchar(50) not null,
        email                   varchar(100) not null unique,
        -- we encrypt passwords using operating system crypt function
        password                varchar(30) not null,
        registration_date       timestamp(0)
);