reporting.sql

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

USE PRRM;

## ----------------- report  ------------------------------------------------
CREATE TABLE IF NOT EXISTS `REPORT` (
  `NAME` VARCHAR(30) NOT NULL DEFAULT '',
  `DESCRIPTION` VARCHAR(100) DEFAULT '',
  `SOURCEFILE` VARCHAR(100) NOT NULL DEFAULT '',
  `JNDIDATASOURCENAME` VARCHAR(50) NOT NULL DEFAULT '',
  `ENABLED` TINYINT(1) NOT NULL DEFAULT '0',
  `VERSION` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`NAME`)
) ENGINE=INNODB;

## ----------------- report_role  ------------------------------------------------
CREATE TABLE IF NOT EXISTS `REPORT_ROLE` (
  `REPORT_NAME` VARCHAR(30) NOT NULL DEFAULT '0',
  `ROLE_NAME` VARCHAR(50) NOT NULL DEFAULT '',
  PRIMARY KEY  (`ROLE_NAME`,`REPORT_NAME`),
    INDEX (REPORT_NAME),
		FOREIGN KEY (REPORT_NAME) REFERENCES REPORT (NAME) ON DELETE CASCADE,
		INDEX (ROLE_NAME),
		FOREIGN KEY (ROLE_NAME) REFERENCES ROLE (NAME) ON DELETE CASCADE
) ENGINE=INNODB;

## ----------------- subreport  ------------------------------------------------
CREATE TABLE IF NOT EXISTS `SUBREPORT` (
  `PARENT_NAME` VARCHAR(30) NOT NULL DEFAULT '',
  `NAME` VARCHAR(30) NOT NULL DEFAULT '',
  `SOURCEFILE` VARCHAR(100) DEFAULT '',
  PRIMARY KEY  (`PARENT_NAME`,`NAME`)
) ENGINE=INNODB;