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/10/19 20:39] 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')), 
   description       text,   description       text,
   parent_album      integer references album(identifier),   parent_album      integer references album(identifier),
Line 124: 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;
Line 132: Line 131:
 -- Associate events with albums -- Associate events with albums
 alter table album add column event integer references calendar(identifier); 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