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/10/19 20:21] 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')), 
   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+  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 113: 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;
Line 125: Line 126:
 -- Drop 'orderby' fields; they're useless now. -- Drop 'orderby' fields; they're useless now.
 alter table album drop orderby; 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.txt · Last modified: 2007/10/19 20:45 by Luud