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/20 10:48]
Luud
podoc:user_type_sql_table [2007/04/20 11: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 === === References tables ===
Line 22: Line 24:
 === Is referenced by tables === === Is referenced by tables ===
  
-None.+  * [[system_preferences sql table|system_preferences]](new_user_type) references identifier 
 +  * [[users sql table|users]](type) references identifier
  
 === Related sequences === === Related sequences ===
Line 54: Line 57:
 = Version 2.5 = = Version 2.5 =
  
-  ​create table user_type ( +<code sql> 
-    identifier ​           integer not null primary key, +create table user_type ( 
-    value                 ​varchar(15) +  identifier ​           integer not null primary key, 
-  ); +  value                 ​varchar(15) 
 +); 
 +</​code>​
  
 == Data change history == == Data change history ==
Line 64: Line 68:
 = Version 2.5 = = Version 2.5 =
  
-<​code>​+<​code ​sql>
 insert into user_type values (nextval('​user_type_id_sequence'​),​ '​Disabled'​);​ 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'​),​ '​Client'​);​
podoc/user_type_sql_table.1177080497.txt.gz · Last modified: 2007/04/20 10:48 by Luud