# -----------------------------------------------------------------------------------------------------
# THIS VALUE GETS UPDATED BY THE INSTALLATION ACTION, ACCORDING TO THE PRESENCE OF MYCRYPT EXTENSION
# -----------------------------------------------------------------------------------------------------
INSERT INTO `setting` VALUES (NULL, 0, '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, 0);


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

#
# Dumping data for table `customuserfields`
#

INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (1, /*T*/'First Name'/*~T*/, 11, 1, 2, 0, 20, 2, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (2, /*T*/'Last Name'/*~T*/, 12, 1, 2, 0, 20, 3, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (3, /*T*/'Address'/*~T*/, 2, 1, 1, 0, 40, 7, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (4, /*T*/'Email'/*~T*/, 13, 1, 2, 0, 35, 4, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (5, /*T*/'City'/*~T*/, 3, 1, 1, 0, 20, 8, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (6, /*T*/'State'/*~T*/, 4, 1, 2, 0, 3, 9, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (7, /*T*/'Zipcode'/*~T*/, 5, 1, 1, 0, 10, 10, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`, `desc`) VALUES (8, /*T*/'Phone'/*~T*/, 7, 1, 1, 0, 20, 6, 1, 1, 1, 1, '', 'When entering a phone number be sure to include the leading "+" sign followed by the country code.');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`, `desc`) VALUES (10, /*T*/'Organization'/*~T*/, 14, 0, 2, 0, 30, 1, 1, 0, 1, 1, '', 'Select the box and enter a name to create this account as an organization instead of an individual.');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (15, /*T*/'Country'/*~T*/, 6, 1, 2, 0, 20, 11, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (16, /*T*/'IM on New Signup'/*~T*/, 1, 0, 0, 0, 20, 16, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (17, /*T*/'HTML Email Format'/*~T*/, 1, 1, 0, 0, 55, 18, 1, 1, 0, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (18, /*T*/'Language'/*~T*/, 8, 1, 2, 0, 20, 18, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (25, /*T*/'Use Paypal Subscriptions'/*~T*/, 24, 0, 0, 0, 20, 19, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (26, /*T*/'Records per page'/*~T*/, 20, 0, 1, 0, 55, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (27, /*T*/'Dashboard graph totals'/*~T*/, 22, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (28, /*T*/'Dashboard graph legend'/*~T*/, 23, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (30, 'selectedDashboardTab', 37, 0, 1, 1, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`, `desc`) VALUES (31, 'Receive Email Announcements', 16, 1, 2, 0, 55, 18, 1, 0, 1, 1, '', 'We urge you to subscribe to our email announcements however you may opt-out by selecting NO.');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (34, 'QUICK_REPORTS', 40, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (35, 'DASHBOARD_LASTUSEDGRAPH', 41, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (36, 'ViewMenu', '42', '0', '1', '0', '20', '0', '0', '0', '0', '0', '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (37, 'LastSentFeedbackEmail', 43, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (38, 'DASHBOARD_TICKETFILTER',45,0,0,0,20,0,0,0,0,0,'');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (39, 'DASHBOARD_DOMAINFILTER',45,0,0,0,20,0,0,0,0,0,'');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'TABLESORT_snapshot_domains', 46, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'VAT Number', 47, 0, 2, 0, 20, 11, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'DashboardState', 48, 0, 1, 1, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'Ticket_ShowHeader', 50, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'Ticket_Sidebar_PendingItemsToggle', 51, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'Ticket_Sidebar_FilterToggle', 52, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'InvoiceTicketGridState', 54, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'SupportTicketGridState', 55, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'ClientListGridState', 56, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'DomainsListGridState', 57, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'AnnouncementGridState', 58, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'Ticket_Sidebar_RecentToggle', 59, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'Ticket_Sidebar_RecentList', 60, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL , 'Sidebar_Position', 60, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id`, `name`, `type`, `isrequired`, `isChangable`, `isAdminOnly`, `width`, `myOrder`, `showcustomer`, `showadmin`, `InSignup`, `inSettings`, `dropdownoptions`) VALUES (NULL, 'VAT Validation', 51, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` (`id` ,`name` ,`type` ,`isrequired` ,`isChangable` ,`isAdminOnly` ,`width` ,`myOrder` ,`showcustomer` ,`showadmin` ,`InSignup` ,`inSettings` ,`dropdownoptions`) VALUES (NULL , 'Last Status Date', 52, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');

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

#
# 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_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_payment_type', 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_payment_type', 0);

# Dumping data for table `permissions`
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_view', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_view', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_view', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_view', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_manage_domains', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_manage_domains', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_manage_domains', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_manage_domains', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_viewcontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_viewcontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_viewcontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_viewcontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_updatecontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_updatecontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_updatecontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_updatecontactinfo', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_dnssettings', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_dnssettings', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_dnssettings', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_dnssettings', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_transfer', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_transfer', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_transfer', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_transfer', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_nameservers', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_nameservers', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_nameservers', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_nameservers', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_registerns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_registerns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_registerns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_registerns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_editns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_editns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_editns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_editns', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_deletens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_deletens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_deletens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_deletens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_updatens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_updatens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_updatens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_updatens', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_autorenew', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_autorenew', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_autorenew', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_lock', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_lock', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_lock', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_lock', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (1, 1, 'domains_transfer_key', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_transfer_key', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_transfer_key', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_transfer_key', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (3, 1, 'domains_delete', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (4, 1, 'domains_delete', 0);
REPLACE INTO `permissions` (`subject_id`, `is_group`, `permission`, `target_id`) VALUES (5, 1, 'domains_delete', 0);

INSERT INTO `customField` (`id`, `groupId`, `subGroupId`, `fieldType`, `name`, `isRequired`, `isChangeable`, `isAdminOnly`, `fieldOrder`, `showCustomer`, `showAdmin`, `dropDownOptions`, `inSettings`, `InSignup`) VALUES (1, 2, 1, 0, 'IP Address', 1, 0, 0, 0, 0, 0, '', 0, 0);
INSERT INTO `customField`
 (`id`, `groupId`, `subGroupId`, `fieldType`, `name`, `isRequired`, `isChangeable`, `isAdminOnly`, `fieldOrder`, `showCustomer`, `showAdmin`, `dropDownOptions`, `inSettings`, `InSignup`)
 VALUES (NULL, 2, 3, 0, 'Domain Name', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 3, 0, 'Domain Next Pricing', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 3, 0, 'Registrar Order Id', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 3, 0, 'Domain Extra Attr', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 3, 0, 'Auto Renew', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 3, 0, 'Registration Option', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 3, 0, 'Registrar', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL, 2, 1, 0, 'Server Id', 0, 0, 0, 0, 0, 0, '', 0, 0), 
        (NULL, 2, 1, 0, 'User Name', 1, 0, 0, 2, 0, 0, '', 1, 1),
        (NULL, 2, 1, 0, 'Control Panel', 0, 0, 0, 0, 0, 0, '', 0, 0), 
        (NULL, 2, 1, 0, 'Domain Name', 1, 0, 0, 1, 0, 0, '', 1, 1),
        (NULL, 2, 1, 0, 'Password', 1, 0, 0, 3, 0, 0, '', 1, 1),
        (NULL, 2, 1, 0, 'Server Acct Properties', 0, 0, 0, 0, 0, 0, '', 0, 0), 
        (NULL, 2, 1, 0, 'Shared', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL ,2, 0, 0, 'Plugin Status', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL ,2, 0, 0, 'Plugin Properties', 0, 0, 0, 0, 0, 0, '', 0, 0),
        (NULL ,2, 0, 0, 'Last Status Date', 0, 0, 0, 0, 0, 0, '', 0, 0);
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '3', '0', 'Expiration Date', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '3', '0', 'Transfer Status', '0', '0', '0', '0', '0', '0', '', '0', '0');

INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Id', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Type', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Status', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Expiration Date', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Domain', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '10', 'Certificate CSR', '0', '0', '0', '0', '1', '0', '', '1', '1');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Admin Email', '0', '0', '0', '0', '1', '0', '', '1', '1');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Registrar', '0', '0', '0', '0', '0', '0', '', '0', '0');
INSERT INTO `customField` (`id` ,`groupId` ,`subGroupId` ,`fieldType` ,`name` ,`isRequired` ,`isChangeable` ,`isAdminOnly` ,`fieldOrder` ,`showCustomer` ,`showAdmin` ,`dropDownOptions` ,`inSettings` ,`InSignup`) VALUES (NULL , '2', '2', '0', 'Certificate Server Type', '0', '0', '0', '0', '0', '0', '', '0', '0');