/
update_v1.01.sql
15 lines (11 loc) · 3.51 KB
/
update_v1.01.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
INSERT INTO `admin_controls_methods` (`id`, `method`, `arguments`, `order`, `control_id`, `p_id`) VALUES
(2320, 'textInput', 'a:13:{s:4:"name";s:14:"balance_before";s:7:"caption";s:14:"Balance Before";s:8:"required";s:0:"";s:5:"value";s:0:"";s:2:"id";s:0:"";s:13:"db_field_type";s:7:"decimal";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:15:"is_manual_array";s:0:"";s:9:"is_unique";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";}', 7, 261, 0),
(2321, 'textInput', 'a:13:{s:4:"name";s:13:"balance_after";s:7:"caption";s:13:"Balance After";s:8:"required";s:0:"";s:5:"value";s:0:"";s:2:"id";s:0:"";s:13:"db_field_type";s:7:"decimal";s:5:"class";s:0:"";s:7:"jscript";s:0:"";s:5:"style";s:0:"";s:15:"is_manual_array";s:0:"";s:9:"is_unique";s:0:"";s:12:"default_text";s:0:"";s:17:"delete_whitespace";s:0:"";}', 8, 261, 0),
(2322, 'field', 'a:14:{s:4:"name";s:14:"balance_before";s:7:"caption";s:14:"Balance Before";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 7, 262, 0),
(2323, 'field', 'a:14:{s:4:"name";s:13:"balance_after";s:7:"caption";s:13:"Balance After";s:8:"subtable";s:0:"";s:15:"subtable_fields";s:0:"";s:8:"link_url";s:0:"";s:11:"concat_char";s:0:"";s:7:"in_form";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:14:"override_value";s:0:"";s:13:"link_id_field";s:0:"";}', 8, 262, 0),
(2324, 'field', 'a:18:{s:4:"name";s:14:"balance_before";s:8:"subtable";s:0:"";s:14:"header_caption";s:11:"Bal. Before";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 14, 263, 0),
(2325, 'field', 'a:18:{s:4:"name";s:13:"balance_after";s:8:"subtable";s:0:"";s:14:"header_caption";s:10:"Bal. After";s:6:"filter";s:1:"Y";s:8:"link_url";s:0:"";s:15:"subtable_fields";s:0:"";s:22:"subtable_fields_concat";s:0:"";s:5:"class";s:0:"";s:18:"aggregate_function";s:0:"";s:12:"thumb_amount";s:0:"";s:12:"media_amount";s:0:"";s:10:"media_size";s:0:"";s:10:"f_id_field";s:0:"";s:8:"order_by";s:0:"";s:9:"order_asc";s:0:"";s:11:"link_is_tab";s:0:"";s:16:"limit_is_curdate";s:0:"";s:8:"is_media";s:0:"";}', 15, 263, 0);
INSERT INTO `admin_controls_methods` (`id`, `method`, `arguments`, `order`, `control_id`, `p_id`) VALUES
(2327, 'filterAutocomplete', 'a:6:{s:10:"field_name";s:13:"site_users.id";s:7:"caption";s:9:"Find User";s:13:"options_array";s:0:"";s:8:"subtable";s:10:"site_users";s:15:"subtable_fields";a:4:{s:4:"user";s:4:"user";s:10:"first_name";s:10:"first_name";s:9:"last_name";s:9:"last_name";s:5:"email";s:5:"email";}s:5:"class";s:0:"";}', 0, 132, 0),
(2328, 'filterAutocomplete', 'a:6:{s:10:"field_name";s:16:"orders.site_user";s:7:"caption";s:14:"Filter by User";s:13:"options_array";s:0:"";s:8:"subtable";s:10:"site_users";s:15:"subtable_fields";a:4:{s:4:"user";s:4:"user";s:10:"first_name";s:10:"first_name";s:9:"last_name";s:9:"last_name";s:5:"email";s:5:"email";}s:5:"class";s:0:"";}', 10, 215, 0);
UPDATE`status` SET `db_version` = '1.01' WHERE `status`.`id` =1;