User Tools

Site Tools



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]
podoc:album_sql_table [2007/10/19 20:45] (current)
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 sql>
 +-- Associate events with albums
 +alter table album add column event integer references calendar(identifier);
 +<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