17 lines
423 B
MySQL
17 lines
423 B
MySQL
|
#
|
||
|
|
# $Id: update-0.08-0.09.sql 145 2009-10-11 20:00:45Z alba $
|
||
|
|
#
|
||
|
|
# Update from version 0.08 to 0.09
|
||
|
|
|
||
|
|
# First use create.sql to create table @sample@_reply
|
||
|
|
|
||
|
|
# Copy column Answer to table @sample@_reply
|
||
|
|
INSERT INTO @sample@_reply
|
||
|
|
(article_id, reply_date, reply_message)
|
||
|
|
SELECT a.id, IFNULL(a.Moddatum, NOW()), a.answer
|
||
|
|
FROM @sample@ a
|
||
|
|
WHERE a.answer is not null;
|
||
|
|
|
||
|
|
# Drop column Answer
|
||
|
|
ALTER TABLE @sample@ DROP COLUMN answer;
|