podoc:user_type_sql_table
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
- system_preferences(new_user_type) references identifier
- users(type) references identifier
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.txt · Last modified: 2007/04/20 15:32 by Luud