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/13 09:15] Luudpodoc:access_type_sql_table [2007/04/20 15:23] (current) Luud
Line 6: Line 6:
  
 === Description === === Description ===
 +
 +Contains a mapping of 'permissions' to textual names of those pemissions.
  
 === Purpose === === Purpose ===
 +
 +To enforce referential integrity.
 +
 +* Note, this table will go away as part of the permission model rewrite (see [[pobug>8]])
  
 === 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 21: Line 45:
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +  * [[view_camera sql view|view_camera]]
 +  * [[view_film sql view|view_film]]
 +  * [[view_filter sql view|view_filter]]
 +  * [[view_flash sql view|view_flash]]
 +  * [[view_lens sql view|view_lens]]
 +  * [[view_photo sql view|view_photo]]
 +  * [[view_scanner sql view|view_scanner]]
 +  * [[view_support sql view|view_support]]
  
 === History === === History ===
Line 40: 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 49: 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.1176455701.txt.gz · Last modified: 2007/04/13 09:15 by Luud