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:40] 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 59: 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 68: 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.1176972038.txt.gz · Last modified: 2007/04/19 08:40 by Luud