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
Last revision Both sides next revision
podoc:user_type_sql_table [2007/04/12 08:14]
Luud
podoc:user_type_sql_table [2007/04/20 11:29]
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
  
 === 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 52:
 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.txt · Last modified: 2007/04/20 11:32 by Luud