User Tools

Site Tools


podoc:user_type_sql_table

This is an old revision of the document!


Database Table Description of "user_type"

Name

user_type

Description

Purpose

Schema

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

References tables

None.

Is referenced by tables

None.

None.

None.

None.

History

Used first

Version 2.5

Used last

Still in use

Schema change history

= Version 2.5 =

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

= 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');
podoc/user_type_sql_table.1177080497.txt.gz · Last modified: 2007/04/20 10:48 by Luud