Changeset 10195

Show
Ignore:
Timestamp:
2008-07-29 22:56:56 (4 months ago)
Author:
robert
Message:

Add a dateadded column to the album table. This column was added to the album table and not to the albummeta
table since it may not always be possible to recreate the dateadded() from the moderation data. If we
archive old moderations at some point, we can't fully recreate the data. The changes to CreateTables.sql
will be coming in a later commit -- this commit is geared towards getting niklas back on track.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • mb_server/trunk/admin/sql/updates/20080729.sql

    r10193 r10195  
    1616    SELECT * FROM moderation_closed; 
    1717 
     18-- Add a date added column to album table to support the upcoming discographies feature 
     19ALTER TABLE album ADD COLUMN dateadded TIMESTAMP WITH TIME ZONE DEFAULT '1970-01-01 00:00:00-00'; 
     20ALTER TABLE album ALTER COLUMN dateadded SET DEFAULT now(); 
     21 
    1822COMMIT;