V1_2_2__reports.sql

CREATE TABLE `reports` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(70) NOT NULL,
  `descr` varchar(250) DEFAULT NULL,
  `with_params` tinyint(1) DEFAULT NULL,
  `report` mediumblob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE `report_params` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `varName` varchar(50) NOT NULL,
  `regex` varchar(50) DEFAULT NULL,
  `regexMes` varchar(250) DEFAULT NULL,
  `valueExpr` varchar(250) DEFAULT NULL,
  `wrapValues` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE `reports_params` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `reportId` int(10) NOT NULL,
  `paramId` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE `text_mark` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;