 	(10915, 'eStability Subset Report.xls', NULL, '', 405, 505, NULL, 101),
 	(10916, 'eStability Subset Report.htm', NULL, '', 406, 505, NULL, 101);
 
-
---
+-- ----------------------------------------------------------------------------
 -- Data for table `STANDARD_REPORT`
---
-
+-- ----------------------------------------------------------------------------
 INSERT INTO `STANDARD_REPORT` (`REPORT_ID`,`BASED_ON_TEMPLATE`) VALUES
 	(11015, 202),
 	(11016, 202),

-- Create Report Writer database
--
-- ------------------------------------------------------

--
-- Insert reportwriter data
--

USE @database.name@;

--
-- Data for table `USER`
--

INSERT INTO `USER` (`ID`,`LOGIN_NAME`) VALUES
 (101,'@rw.admin.user.name@'),
 (102,'@rw.user.name@');

--
-- Data for table `hi_value`
-- Note: Need to set hi_value whenever you manually add rows to a table.
--

INSERT INTO `hi_value` (`next_value`) VALUES
	(110);

--
-- Data for table `REPORT_FORMAT`
--

INSERT INTO `REPORT_FORMAT` (`ID`,`DESCRIPTION`) VALUES
 (404,'Text (tab delimited)'),
 (405,'Microsoft Office Excel'),
 (406,'HyperText Markup Language');

--
-- Data for table `REPORT_STATUS`
--

INSERT INTO `REPORT_STATUS` (`ID`,`LABEL`,`DESCRIPTION`,`ACTIVE`) VALUES
 (505,'DRAFT','REPORT is a draft, not ready for download.',1),
 (506,'APPROVED','REPORT has been approved for download by USERs',1);

--
-- Data for table `STANDARD_REPORT_TEMPLATE`
--

INSERT INTO `standard_report_template` (`ID`, `LABEL`, `ROOT_CONCEPT_CODE`, `ASSOCIATION_NAME`, `DIRECTION`, `CODING_SCHEME_NAME`, `CODING_SCHEME_VERSION`, `LEVEL`, `DELIMITER`) VALUES
	(202, 'FDA-UNII Subset REPORT', 'C63923', 'Concept_In_Subset', 0, 'NCI Thesaurus', '11.11d', -1, '$'),
	(2323, 'Individual Case Safety (ICS) Subset REPORT', 'C54447', 'Concept_In_Subset', 0, 'NCI Thesaurus', '11.10e', -1, '$'),

	(10915, 10100),
	(10916, 10100);

-- ----------------------------------------------------------------------------
COMMIT;