<commit_before>-- 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
 (70);

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

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

--
-- 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`<commit_msg>GF29243: Modified insert-data-rw.sql to insert HTML as a report format.<commit_after>-- 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
 (70);

--
-- 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`
{'fraction_non_alphanumeric': 0.2239795918367347, 'fraction_numerical': 0.026530612244897958, 'mean_word_length': 3.102510460251046, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '137496', 'n_tokens_mistral': 696, 'n_tokens_neox': 628, 'n_words': 187}