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 20:21]
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')), 
   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 122: Line 123:
 </code> </code>
  
-<code>+<code sql>
 -- 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.1192825279.txt.gz · Last modified: 2007/10/19 20:21 by Luud