user_type

create table user_type (
  identifier            integer not null primary key,
  value                 varchar(15)
);

None.

• system_preferences(new_user_type) references identifier
• users(type) references identifier

• user_type_id_sequence

None.

None.

None.

Version 2.5

Still in use

= Version 2.5 =

CREATE TABLE user_type (
  identifier            integer NOT NULL PRIMARY KEY,
  value                 varchar(15)
);

= Version 2.5 =

INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'Disabled');
INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'Client');
INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'User');
INSERT INTO user_type VALUES (NEXTVAL('user_type_id_sequence'), 'Administrator');