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.
Related sequences
Related indexes
None.
Related functions
None.
Related views
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 14:48 by Luud