CREATE TABLE `test_table` (
  `id` int(11) NOT NULL,
  `field1_int` int(11) NOT NULL,
  `field2_varchar` varchar(100) NOT NULL,
  `field3_datetime` datetime NOT NULL,
  `field4_null` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `test_table`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `test_table`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

INSERT INTO `Form` (`id`, `name`, `title`, `noteInternal`, `tableName`, `permitNew`, `permitEdit`, `escapeTypeDefault`, `render`, `requiredParameterNew`, `requiredParameterEdit`, `dirtyMode`, `showButton`, `multiMode`, `multiSql`, `multiDetailForm`, `multiDetailFormParameter`, `forwardMode`, `forwardPage`, `bsLabelColumns`, `bsInputColumns`, `bsNoteColumns`, `parameter`, `parameterLanguageA`, `parameterLanguageB`, `parameterLanguageC`, `parameterLanguageD`, `recordLockTimeoutSeconds`, `deleted`, `modified`, `created`) VALUES
(1023, 'test_hidden-sanitize', 'Test sanitizing a hidden field', '18.6.1: Sanitizing a field hidden by dynamic updates as email makes the form unsubmittable.', 'test_table', 'sip', 'sip', 'c', 'bootstrap', '', '', 'exclusive', 'new,delete,close,save', 'none', '', '', '', 'auto', '', '', '', '', '', '', '', '', '', 900, 'no', '2018-08-02 08:42:03', '2018-08-02 10:31:37');

INSERT INTO `FormElement` (`id`, `formId`, `feIdContainer`, `dynamicUpdate`, `enabled`, `name`, `label`, `mode`, `modeSql`, `class`, `type`, `subrecordOption`, `encode`, `checkType`, `checkPattern`, `onChange`, `ord`, `tabindex`, `size`, `maxLength`, `bsLabelColumns`, `bsInputColumns`, `bsNoteColumns`, `rowLabelInputNote`, `note`, `adminNote`, `tooltip`, `placeholder`, `value`, `sql1`, `parameter`, `parameterLanguageA`, `parameterLanguageB`, `parameterLanguageC`, `parameterLanguageD`, `clientJs`, `feGroup`, `deleted`, `modified`, `created`) VALUES
(732, 1019, 0, 'yes', 'yes', 'nodb_checkbox', 'Toggle', 'show', '', 'native', 'checkbox', '', 'specialchar', 'auto', '', '', 10, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '', 'checkBoxMode = single\r\nlabel2 = external speaker\r\nitemList = 1: \r\nchecked = 1\r\n', '', '', '', '', '', '', 'no', '2018-05-31 08:50:12', '2018-05-31 10:50:12'),
(733, 1019, 0, 'yes', 'yes', 'field1_int', 'Enter Int', 'required', '{{ SELECT IF(\'{{nodb_checkbox:FR0}}\'=\'1\', \'hidden\', \'required\') }}', 'native', 'text', '', 'specialchar', 'digit', '', '', 20, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '', '', '', '', '', '', '', '', 'no', '2018-07-27 14:39:07', '2018-05-31 10:50:33'),
(734, 1019, 0, 'yes', 'yes', 'field2_varchar', 'Enter Varchar', 'show', '{{ SELECT IF(\'{{nodb_checkbox:FR0}}\'=\'1\', \'required\', \'hidden\') }}', 'native', 'text', '', 'specialchar', 'auto', '', '', 30, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '', '', '', '', '', '', '', '', 'no', '2018-05-31 08:53:22', '2018-05-31 10:52:17');
