User Tools

Site Tools


podoc:album_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:album_sql_table [2007/10/19 14:55]
Luud
podoc:album_sql_table [2007/10/19 20:45] (current)
Luud
Line 22: Line 22:
   date_of_creation  timestamp,   date_of_creation  timestamp,
   access_rights     integer not null references access_type(identifier),   access_rights     integer not null references access_type(identifier),
-  type              char(1) check (type in ('c', 'u')), 
-  orderby           integer, 
   description       text,   description       text,
   parent_album      integer references album(identifier),   parent_album      integer references album(identifier),
-  password              text+  password          text
 +  date_changed      timestamp without time zone, 
 +  event             integer references calendar(identifier)
   );   );
 </code> </code>
Line 33: Line 33:
  
   * access_rights references [[access_type sql table|access_type]](identifier)   * access_rights references [[access_type sql table|access_type]](identifier)
 +  * event references [[calendar sql table|calendar]](identifier)
   * parent_album references [[album sql table|album]](identifier) // **self reference** //   * parent_album references [[album sql table|album]](identifier) // **self reference** //
   * users references [[users sql table|users]](identifier)   * users references [[users sql table|users]](identifier)
Line 47: Line 48:
 === Related indexes === === Related indexes ===
  
-  * [[album_id_idx sql index|album_id_idx]]+  * [[album_event_idx sql index|album_event_idx]] 
 +  * <del>[[album_id_idx sql index|album_id_idx]]</del> removed in 2.34
   * [[album_users_idx sql index|album_users_idx]]   * [[album_users_idx sql index|album_users_idx]]
  
Line 112: Line 114:
 = Version 2.34 = = Version 2.34 =
  
-<codesql>+<code sql>
 -- Add password support to albums -- Add password support to albums
 alter table album add password text; alter table album add password text;
 +</code>
 +
 +<code sql>
 +alter table album add date_changed timestamp without time zone;
 +</code>
 +
 +<code sql>
 +-- Drop 'orderby' fields; they're useless now.
 +alter table album drop orderby;
 +</code>
 +
 +<code sql>
 +-- Associate events with albums
 +alter table album add column event integer references calendar(identifier);
 +</code>
 +
 +<code sql>
 +-- this is obselete                    
 +alter table album drop column type;
 </code> </code>
  
podoc/album_sql_table.1192805706.txt.gz · Last modified: 2007/10/19 14:55 by Luud