-- Convert schema 'lib/auto/Tapper/Schema/Tapper-Schema-ReportsDB-4.001001-MySQL.sql' to 'Tapper::Schema::ReportsDB v4.001002':;

BEGIN;

ALTER TABLE notification_event CHANGE COLUMN type type VARCHAR(255);

ALTER TABLE report CHANGE COLUMN suite_version suite_version VARCHAR(255),
                   CHANGE COLUMN reportername reportername VARCHAR(255) DEFAULT '',
                   CHANGE COLUMN peeraddr peeraddr VARCHAR(255) DEFAULT '',
                   CHANGE COLUMN peerport peerport VARCHAR(255) DEFAULT '',
                   CHANGE COLUMN machine_name machine_name VARCHAR(255) DEFAULT '',
                   ADD INDEX report_idx_created_at (created_at);

ALTER TABLE reportsection CHANGE COLUMN ram ram VARCHAR(255),
                          CHANGE COLUMN uptime uptime VARCHAR(255),
                          CHANGE COLUMN xen_hvbits xen_hvbits VARCHAR(255),
                          ADD INDEX reportsection_idx_report_id (report_id);

ALTER TABLE reporttopic CHANGE COLUMN name name VARCHAR(255) DEFAULT '';

ALTER TABLE suite CHANGE COLUMN type type VARCHAR(255) NOT NULL;


COMMIT;