Перевод хранилища с версии 1.0rc2 на 1.0rc3

[rsdn]

Перевод хранилища с версии 1.0rc2 на 1.0rc3

[abbat]

SQLite:

DROP TABLE `rating`;
CREATE TABLE `rating`
(
    `id_message`  INTEGER NOT NULL,
    `id_topic`    INTEGER NOT NULL,
    `id_user`     INTEGER NOT NULL,
    `user_rating` INTEGER NOT NULL,
    `rate`        INTEGER NOT NULL,
    `rate_date`   INTEGER NOT NULL,
    `rate_type`   INTEGER NOT NULL,
    PRIMARY KEY (`id_message`, `id_user`, `rate_type`)
);
UPDATE `row_version` SET `value` = 'AAAAAAAAAAA=' WHERE `key` = 'rating';

[abbat]

MySQL:

DELETE FROM `rating`;
ALTER TABLE `rating` ADD COLUMN `rate_type` TINYINT(1) NOT NULL COMMENT 'тип оценки (0 - смайл, 1 - +/-, 2 - балл)' AFTER `rate_date`;
ALTER TABLE `rating` DROP PRIMARY KEY;
ALTER TABLE `rating` ADD PRIMARY KEY (`id_message`, `id_user`, `rate_type`);
UPDATE `row_version` SET `value` = 'AAAAAAAAAAA=' WHERE `key` = 'rating';