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 revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
podoc:user_type_sql_table [2007/04/12 12:33] Luudpodoc: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 === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 27: 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