# -----------------------------------------------------------------------------------------------------
# THIS VALUE GETS UPDATED BY THE INSTALLATION ACTION, ACCORDING TO THE PRESENCE OF MYCRYPT EXTENSION
# -----------------------------------------------------------------------------------------------------
INSERT INTO `setting` VALUES (NULL, 'Domain Passwords are Encrypted', 0, '', 'This setting allows to encrypt Domain Passwords. When the encryption is done, this setting is set to true.', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1);


# --------------------------------------------------------

#
# Dumping data for table `customuserfields`
#

INSERT INTO `customuserfields` VALUES (1, /*T*/'First Name'/*~T*/, 11, 1, 2, 0, 20, 2, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (2, /*T*/'Last Name'/*~T*/, 12, 1, 2, 0, 20, 3, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (3, /*T*/'Address'/*~T*/, 2, 1, 1, 0, 40, 7, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (4, /*T*/'Email'/*~T*/, 13, 1, 2, 0, 35, 4, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (5, /*T*/'City'/*~T*/, 3, 1, 1, 0, 20, 8, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (6, /*T*/'State'/*~T*/, 4, 1, 1, 0, 3, 9, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (7, /*T*/'Zipcode'/*~T*/, 5, 1, 1, 0, 10, 10, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (8, /*T*/'Phone'/*~T*/, 7, 1, 1, 0, 20, 6, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (10, /*T*/'Organization'/*~T*/, 14, 0, 2, 0, 30, 1, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (11, /*T*/'ICQ Number'/*~T*/, 30, 0, 0, 0, 20, 5, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (12, /*T*/'IM on Payment'/*~T*/, 1, 0, 0, 0, 20, 12, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (13, /*T*/'IM on Login'/*~T*/, 1, 0, 0, 0, 20, 13, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (14, /*T*/'IM on New Ticket'/*~T*/, 1, 0, 0, 0, 20, 14, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (15, /*T*/'Country'/*~T*/, 6, 1, 1, 0, 20, 11, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (16, /*T*/'IM on New Signup'/*~T*/, 1, 0, 0, 0, 20, 16, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (17, /*T*/'HTML Email Format'/*~T*/, 1, 1, 0, 0, 55, 18, 1, 1, 0, 1, '');
INSERT INTO `customuserfields` VALUES (18, /*T*/'Language'/*~T*/, 8, 1, 2, 0, 20, 18, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (19, 'TABLESORT_snapshot_invoices', 31, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (20, 'TABLESORT_snapshot_cc', 32, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (21, 'TABLESORT_snapshot_tickets', 33, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (22, 'TABLESORT_snapshot_pending', 34, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (23, 'TABLESORT_snapshot_uninvoiced', 35, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (24, 'DASHBOARD_INVOICEFILTER', 36, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (25, /*T*/'Use Paypal Subscriptions'/*~T*/, 24, 0, 0, 0, 20, 19, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (26, /*T*/'Records per page'/*~T*/, 20, 0, 1, 0, 55, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (27, /*T*/'Dashboard graph totals'/*~T*/, 22, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (28, /*T*/'Dashboard graph legend'/*~T*/, 23, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (29, 'ViewSideBar', 21, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (30, 'selectedDashboardTab', 37, 0, 1, 1, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (31, 'Receive Email Announcements', 16, 1, 2, 0, 55, 18, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (32, 'DASHBOARD_TICKETFILTER',38,0,0,0,20,0,0,0,0,0,'');
INSERT INTO `customuserfields` VALUES (33, 'DASHBOARD_LASTUSEDSNAPSHOT',39,0,0,0,20,0,0,0,0,0,'');
INSERT INTO `customuserfields` VALUES (34, 'QUICK_REPORTS', 40, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (35, 'DASHBOARD_LASTUSEDGRAPH', 41, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (36, 'ViewMenu', '42', '0', '1', '0', '20', '0', '0', '0', '0', '0', '');
INSERT INTO `customuserfields` VALUES (37, 'LastSentFeedbackEmail', 43, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (38, 'TABLESORT_snapshot_event_log', 44, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (39, 'DASHBOARD_DOMAINFILTER',45,0,0,0,20,0,0,0,0,0,'');
INSERT INTO `customuserfields` VALUES (NULL, 'TABLESORT_snapshot_domains', 46, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (NULL, 'VAT Number', 47, 0, 2, 0, 20, 11, 1, 0, 1, 1, '');

# --------------------------------------------------------

#
# Dumping data for table `user_customuserfields`
#

INSERT INTO `user_customuserfields` VALUES (100, 1, 'Admin');
INSERT INTO `user_customuserfields` VALUES (100, 2, 'User');
INSERT INTO `user_customuserfields` VALUES (100, 4, 'admin@domain.com');

# --------------------------------------------------------

#
# Dumping data for table `permissions`
#

INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_edit_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_view_domains', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_view_server_info', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_edit_credit_card', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_edit_isorganization', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'clients_edit_payment_type', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_email_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_view_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_view_domains', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_view_server_info', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_view_eventlog', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_add_notes', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_delete_notes', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'clients_edit_payment_type', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_create_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_passphrase_cc', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_create_customer_packages', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_edit_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_edit_customer_packages', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_email_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_view_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_view_domains', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_view_server_info', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_view_eventlog', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_edit_credit_card', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_add_notes', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_delete_notes', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_edit_isorganization', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_edit_payment_type', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'clients_activate', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_create_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_create_customer_packages', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_edit_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_edit_customer_packages', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_email_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_view', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_view_customers', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_view_domains', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_view_server_info', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_edit_credit_card', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_view_eventlog', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_add_notes', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_delete_notes', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_edit_isorganization', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_activate', 0);
INSERT INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'clients_edit_payment_type', 0);
