Changeset 10195

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:

• mb_server/trunk/admin/PopulateAlbumDateAdded.pl (added)
• mb_server/trunk/admin/sql/updates/20080729.sql (modified) (1 diff)

mb_server/trunk/admin/sql/updates/20080729.sql

@@ -16 +16 @@
-    SELECT * FROM moderation_closed;
-
+-- Add a date added column to album table to support the upcoming discographies feature
+ALTER TABLE album ADD COLUMN dateadded TIMESTAMP WITH TIME ZONE DEFAULT '1970-01-01 00:00:00-00';
+ALTER TABLE album ALTER COLUMN dateadded SET DEFAULT now();
+
-COMMIT;