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 15:57]
Luud
podoc:user_type_sql_table [2007/04/20 15:32] (current)
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table user_type ( +<code> 
-    identifier            integer not null primary key, +create table user_type ( 
-    value                 varchar(15) +  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 ===
Line 21: Line 32:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 36: Line 53:
 Still in use Still in use
  
-== Change history ==+== Schema change history == 
 + 
 += Version 2.5 = 
 + 
 +<code sql> 
 +create table user_type ( 
 +  identifier            integer not null primary key, 
 +  value                 varchar(15) 
 +); 
 +</code> 
 + 
 +== Data change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table user_type ( +<code sql> 
-    identifier            integer not null primary key+insert into user_type values (nextval('user_type_id_sequence'), 'Disabled'); 
-    value                 varchar(15+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.1176393446.txt.gz · Last modified: 2007/04/12 15:57 by Luud