User Tools

Site Tools


podoc:user_type_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
podoc:user_type_sql_table [2007/04/12 08:14]
Luud
podoc:user_type_sql_table [2007/04/20 11:32] (current)
Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description ​of "​user_type" ​=====
  
 === Name === === Name ===
 +
 +user_type
  
 === Description === === Description ===
Line 8: Line 10:
  
 === Schema === === Schema ===
 +
 +<​code>​
 +create table user_type (
 +  identifier ​           integer not null primary key,
 +  value                 ​varchar(15)
 +);
 +</​code>​
 +
 +=== References tables ===
 +
 +None.
 +
 +=== Is referenced by tables ===
 +
 +  * [[system_preferences sql table|system_preferences]](new_user_type) references identifier
 +  * [[users sql table|users]](type) references identifier
  
 === Related sequences === === Related sequences ===
 +
 +  * [[user_type_id_sequence sql sequence|user_type_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
 +
 +=== Related views ===
 +
 +None.
  
 === History === === History ===
Line 25: Line 53:
 Still in use Still in use
  
-== Change ​history ==+== Schema change ​history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  ​create table ... +<code sql> 
-    ​... ​  +create table user_type ​
-  );+  ​identifier ​           integer not null primary key, 
 +  ​value                 ​varchar(15) 
 +); 
 +</​code>​ 
 + 
 +== Data change history == 
 + 
 += Version 2.5 = 
 + 
 +<code sql> 
 +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'​);​ 
 +</​code>​ 
podoc/user_type_sql_table.1176380069.txt.gz · Last modified: 2007/04/12 08:14 by Luud