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
Last revision Both sides next revision
podoc:user_type_sql_table [2007/04/20 10:48]
Luud
podoc:user_type_sql_table [2007/04/20 11:29]
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
  
 === Related sequences === === Related sequences ===
Line 54: Line 56:
 = 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 67:
 = 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.txt · Last modified: 2007/04/20 11:32 by Luud