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 revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
podoc:album_sql_table [2007/04/20 13:07] Luudpodoc:album_sql_table [2007/10/19 20:44] 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, 
 +  date_changed      timestamp without time zone, 
 +  event             integer references calendar(identifier)
   );   );
 </code> </code>
Line 32: 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 46: 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 107: Line 110:
 <code sql> <code sql>
 alter table album add column  parent_album integer references album(identifier); alter table album add column  parent_album integer references album(identifier);
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +-- Add password support to albums
 +alter table album add password text;
 +</code>
 +
 +<code sql>
 +alter table album add date_changed timestamp without time zone;
 +</code>
 +
 +<code>
 +-- 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>
  
Line 127: Line 156:
 <code sql> <code sql>
 update album set parent_album=null; update album set parent_album=null;
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +-- Add the 'Spool' Album for everyone.
 +
 +insert into album (identifier, parent_album, users, caption, type,
 +                    date_of_creation, access_rights, orderby, description)
 +  select nextval('album_id_sequence') as identifier,
 +         null as parent_album,
 +         identifier as users,
 +         'Spool' as caption,
 +         'u' as type,
 +         now() as date_of_creation,
 +         3 as access_rights,
 +         7 as orderby,
 +         null as description
 +    from users;
 </code> </code>
  
podoc/album_sql_table.txt · Last modified: 2007/10/19 20:45 by Luud