User Tools

Site Tools


podoc:access_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
podoc:access_type_sql_table [2007/04/19 08:31] Luudpodoc:access_type_sql_table [2007/04/20 15:23] (current) Luud
Line 17: Line 17:
 === Schema === === Schema ===
  
-  create table access_type ( +<code sql> 
-    identifier            integer not null primary key, +create table access_type ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[album sql table|album]](access_rights) references identifier 
 +  * [[camera sql table|camera]](access_rights) references identifier 
 +  * [[film sql table|film]](access_rights) references identifier 
 +  * [[filter sql table|filter]](access_rights) references identifier 
 +  * [[flash sql table|flash]](access_rights) references identifier 
 +  * [[folder sql table|folder]](access_rights) references identifier 
 +  * [[photo sql table|photo]](access_rights) references identifier 
 +  * [[scanner sql table|scanner]](access_rights) references identifier 
 +  * [[support sql table|support]](access_rights) references identifier
  
 === Related sequences === === Related sequences ===
Line 36: Line 54:
 === Related views === === Related views ===
  
 +  * [[view_camera sql view|view_camera]]
 +  * [[view_film sql view|view_film]]
   * [[view_filter sql view|view_filter]]   * [[view_filter sql view|view_filter]]
   * [[view_flash sql view|view_flash]]   * [[view_flash sql view|view_flash]]
Line 57: Line 77:
 = Version 2.5 = = Version 2.5 =
  
-  create table access_type ( +<code sql> 
-    identifier            integer not null primary key, +create table access_type ( 
-    value                 varchar(10) +  identifier            integer not null primary key, 
-  );+  value                 varchar(10) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 66: Line 88:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into access_type values (nextval('access_type_id_sequence'), 'Public'); insert into access_type values (nextval('access_type_id_sequence'), 'Public');
 insert into access_type values (nextval('access_type_id_sequence'), 'Protected'); insert into access_type values (nextval('access_type_id_sequence'), 'Protected');
 insert into access_type values (nextval('access_type_id_sequence'), 'Private'); insert into access_type values (nextval('access_type_id_sequence'), 'Private');
 </code> </code>
 +
podoc/access_type_sql_table.1176971491.txt.gz · Last modified: 2007/04/19 08:31 by Luud