-- Convert schema 'lib/auto/Tapper/Schema/Tapper-Schema-ReportsDB-4.001001-PostgreSQL.sql' to 'lib/auto/Tapper/Schema/Tapper-Schema-ReportsDB-4.001002-PostgreSQL.sql':;
BEGIN;
--
-- temporarily drop View: "view_testrun_overview"
--
DROP VIEW "view_testrun_overview";
ALTER TABLE report ALTER COLUMN suite_version TYPE character varying(255);
ALTER TABLE report ALTER COLUMN reportername TYPE character varying(255);
ALTER TABLE report ALTER COLUMN peeraddr TYPE character varying(255);
ALTER TABLE report ALTER COLUMN peerport TYPE character varying(255);
ALTER TABLE report ALTER COLUMN machine_name TYPE character varying(255);
ALTER TABLE reportsection ALTER COLUMN ram TYPE character varying(255);
ALTER TABLE reportsection ALTER COLUMN uptime TYPE character varying(255);
ALTER TABLE reportsection ALTER COLUMN xen_hvbits TYPE character varying(255);
ALTER TABLE reporttopic ALTER COLUMN name TYPE character varying(255);
ALTER TABLE suite ALTER COLUMN type TYPE character varying(255);
CREATE INDEX report_idx_created_at on report (created_at);
CREATE INDEX reportsection_idx_report_id on reportsection (report_id);
CREATE VIEW "view_testrun_overview" ( "vtor_primary_report_id", "vtor_rgt_testrun_id", "vtor_rgts_success_ratio", "report_id", "report_machine_name", "report_created_at", "report_suite_id", "report_suite_name" ) AS
select vtor.primary_report_id as vtor_primary_report_id , vtor.rgt_testrun_id as vtor_rgt_testrun_id , vtor.rgts_success_ratio as vtor_rgts_success_ratio , report.id as report_id , report.machine_name as report_machine_name , report.created_at as report_created_at , report.suite_id as report_suite_id , suite.name as report_suite_name from view_testrun_overview_reports vtor, report report, suite suite where CAST(vtor.primary_report_id as INTEGER)=report.id and report.suite_id=suite.id
;
COMMIT;