1
|
CREATE TABLE `test_table` (
|
2
|
`id` int(11) NOT NULL,
|
3
|
`field1_int` int(11) NOT NULL,
|
4
|
`field2_varchar` varchar(100) NOT NULL,
|
5
|
`field3_datetime` datetime NOT NULL,
|
6
|
`field4_null` int(11) DEFAULT NULL
|
7
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
8
|
|
9
|
ALTER TABLE `test_table`
|
10
|
ADD PRIMARY KEY (`id`);
|
11
|
|
12
|
ALTER TABLE `test_table`
|
13
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
|
14
|
|
15
|
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
|
16
|
(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');
|
17
|
|
18
|
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
|
19
|
(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'),
|
20
|
(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'),
|
21
|
(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');
|