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

Next revision
Previous revision
Next revision Both sides next revision
podoc:user_type_sql_table [2007/04/12 12:08]
Luud created
podoc:user_type_sql_table [2007/04/20 14:48]
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 ===
 +
 +  create table user_type (
 +    identifier            integer not null primary key,
 +    value                 varchar(15)
 +  );
 +
 +=== References tables ===
 +
 +None.
 +
 +=== Is referenced by tables ===
 +
 +None.
  
 === Related sequences === === Related sequences ===
 +
 +  * [[user_type_id_sequence sql sequence|user_type_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +None.
 +
 +=== Related functions ===
 +
 +None.
 +
 +=== Related views ===
 +
 +None.
  
 === History === === History ===
Line 17: Line 44:
 == Used first == == Used first ==
  
-Verions 2.5+Version 2.5
  
 == Used last == == Used last ==
Line 23: Line 50:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table ... +  create table user_type 
-    ...  +    identifier            integer not null primary key, 
 +    value                 varchar(15)
   );   );
 +
 +
 +== Data change history ==
 +
 += Version 2.5 =
 +
 +<code>
 +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 15:32 by Luud