18 lines
592 B
MySQL
18 lines
592 B
MySQL
|
#
|
||
|
|
# $Id: update-0.05-to-0.06.sql 102 2009-09-16 18:46:27Z alba $
|
||
|
|
#
|
||
|
|
# Update from version 0.05 to 0.06
|
||
|
|
|
||
|
|
# Check for errors (should return no rows)
|
||
|
|
SELECT status,posted FROM @sample@ WHERE posted and status <> 'moderated';
|
||
|
|
SELECT status,posted FROM @sample@ WHERE status = 0;
|
||
|
|
|
||
|
|
# Add value 'posted' to column 'status'.
|
||
|
|
ALTER TABLE @sample@ CHANGE Status Status enum('pending','spam','moderated','rejected','deleted','posted');
|
||
|
|
|
||
|
|
# Transfer column 'posted' to column 'status'.
|
||
|
|
UPDATE @sample@ SET Status = 'posted' WHERE posted;
|
||
|
|
|
||
|
|
# Remove column 'posted'.
|
||
|
|
ALTER TABLE @sample@ DROP column posted;
|