reporting_setup.sql

来自「Java的框架」· SQL 代码 · 共 35 行

USE PRRM;

--
-- Dumping data for table `prrm`.`report`
--

/*!40000 ALTER TABLE `REPORT` DISABLE KEYS */;
INSERT INTO `REPORT` (`NAME`,`DESCRIPTION`,`SOURCEFILE`,`JNDIDATASOURCENAME`,`ENABLED`,`VERSION`) VALUES 
 ('Report01','Report 01','/WEB-INF/reports/Report01/report01.jrxml','prrmDS',1,0),
 ('Report02','Report 02','/WEB-INF/reports/Report02/report02.jrxml','prrmDS',1,0),
 ('RoadInspectionReport','Road Inspection Report','/WEB-INF/reports/RoadInspectionReport/RoadInspection.jrxml','prrmDS',0,0);
/*!40000 ALTER TABLE `REPORT` ENABLE KEYS */;


--
-- Dumping data for table `prrm`.`report_role`
--

/*!40000 ALTER TABLE `REPORT_ROLE` DISABLE KEYS */;
INSERT INTO `REPORT_ROLE` (`REPORT_NAME`,`ROLE_NAME`) VALUES 
 ('Report01','admin'),
 ('Report02','admin'),
 ('RoadInspectionReport','admin');
/*!40000 ALTER TABLE `REPORT_ROLE` ENABLE KEYS */;


--
-- Dumping data for table `prrm`.`subreport`
--

/*!40000 ALTER TABLE `SUBREPORT` DISABLE KEYS */;
INSERT INTO `SUBREPORT` (`PARENT_NAME`,`NAME`,`SOURCEFILE`) VALUES 
 ('Report02','Subreport','/WEB-INF/reports/Report02/subreports/subreport02.jrxml'),
 ('RoadInspectionReport','picsubreport','/WEB-INF/reports/RoadInspectionReport/subreports/RoadInspectionSubReport.jrxml');
/*!40000 ALTER TABLE `SUBREPORT` ENABLE KEYS */;