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
podoc:album_sql_table [2007/04/20 13:07] Luudpodoc: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, 
 +  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 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>
  
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.1177074440.txt.gz · Last modified: 2007/04/20 13:07 by Luud