# phpMyAdmin SQL Dump
# version 2.5.5-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Mar 05, 2005 at 12:34 PM
# Server version: 4.0.17
# PHP Version: 4.3.4
# 
# Database : `clientexec_stable`
# 

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

#
# Dumping data for table `billingtype`
#

INSERT INTO `billingtype` VALUES (1, 'Hosting', 'New Domain Hosting', 'domain.com (/month) x  = $');
INSERT INTO `billingtype` VALUES (2, 'Maintenance', 'Maintenance', 'Default maintenance detail');
INSERT INTO `billingtype` VALUES (3, 'Development', 'Development', 'Default development detail');
INSERT INTO `billingtype` VALUES (4, 'Installation', 'Installation', 'Default installation detail');
INSERT INTO `billingtype` VALUES (5, 'Misc.', 'Misc.', 'Default Misc. description');
INSERT INTO `billingtype` VALUES (6, 'Overusage', 'Overusage', 'Default overusage detail');
INSERT INTO `billingtype` VALUES('-2', 'Domain Name', 'Domain Name Registration', 'Default name registration detail');
INSERT INTO `billingtype` VALUES ('-3', 'Discount', 'Discount', 'Discount generated by a discount coupon entered at signup');
INSERT INTO `billingtype` VALUES ('-4', 'Package add-on', 'Package add-on', 'Package add-on fee');

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

#
# Dumping data for table `cache`
#

INSERT INTO `cache` VALUES ('ADMINSUMMARY', '2003-02-14 22:29:43', '');

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

#
# Dumping data for table `country`
#

INSERT INTO `country` VALUES (1, 'Afghanistan', 'AF', '93');
INSERT INTO `country` VALUES (2, 'Albania', 'AL', '355');
INSERT INTO `country` VALUES (3, 'Algeria', 'DZ', '213');
INSERT INTO `country` VALUES (4, 'American Samoa', 'AS', '684');
INSERT INTO `country` VALUES (5, 'Andorra', 'AD', '376');
INSERT INTO `country` VALUES (6, 'Angola', 'AO', '244');
INSERT INTO `country` VALUES (7, 'Anguilla', 'AI', '1');
INSERT INTO `country` VALUES (8, 'Antarctica', 'AQ', '672');
INSERT INTO `country` VALUES (9, 'Antigua and Barbuda', 'AG', '1');
INSERT INTO `country` VALUES (10, 'Argentina', 'AR', '54');
INSERT INTO `country` VALUES (11, 'Armenia', 'AM', '374');
INSERT INTO `country` VALUES (12, 'Aruba', 'AW', '297');
INSERT INTO `country` VALUES (13, 'Australia', 'AU', '61');
INSERT INTO `country` VALUES (14, 'Austria', 'AT', '43');
INSERT INTO `country` VALUES (15, 'Azerbaijan', 'AZ', '994');
INSERT INTO `country` VALUES (16, 'Bahamas', 'BS', '1');
INSERT INTO `country` VALUES (17, 'Bahrain', 'BH', '973');
INSERT INTO `country` VALUES (18, 'Bangladesh', 'BD', '880');
INSERT INTO `country` VALUES (19, 'Barbados', 'BB', '1');
INSERT INTO `country` VALUES (20, 'Belarus', 'BY', '375');
INSERT INTO `country` VALUES (21, 'Belgium', 'BE', '32');
INSERT INTO `country` VALUES (22, 'Belize', 'BZ', '501');
INSERT INTO `country` VALUES (23, 'Benin', 'BJ', '229');
INSERT INTO `country` VALUES (24, 'Bermuda', 'BM', '1');
INSERT INTO `country` VALUES (25, 'Bhutan', 'BT', '975');
INSERT INTO `country` VALUES (26, 'Bolivia', 'BO', '591');
INSERT INTO `country` VALUES (27, 'Bosnia and Herzegovina', 'BA', '387');
INSERT INTO `country` VALUES (28, 'Botswana', 'BW', '267');
INSERT INTO `country` VALUES (29, 'Bouvet Island', 'BV', '');
INSERT INTO `country` VALUES (30, 'Brazil', 'BR', '55');
INSERT INTO `country` VALUES (31, 'Brunei Darussalam', 'BN', '673');
INSERT INTO `country` VALUES (32, 'Bulgaria', 'BG', '359');
INSERT INTO `country` VALUES (33, 'Burkina Faso', 'BF', '226');
INSERT INTO `country` VALUES (34, 'Burundi', 'BI', '257');
INSERT INTO `country` VALUES (35, 'Cambodia', 'KH', '855');
INSERT INTO `country` VALUES (36, 'Cameroon', 'CM', '237');
INSERT INTO `country` VALUES (37, 'Canada', 'CA', '1');
INSERT INTO `country` VALUES (38, 'Cape Verde', 'CV', '238');
INSERT INTO `country` VALUES (39, 'Cayman Islands', 'KY', '1');
INSERT INTO `country` VALUES (40, 'Central African Republic', 'CF', '236');
INSERT INTO `country` VALUES (41, 'Chad', 'TD', '235');
INSERT INTO `country` VALUES (42, 'Chile', ' C', '56');
INSERT INTO `country` VALUES (43, 'China', 'CN', '86');
INSERT INTO `country` VALUES (44, 'Christmas Island', 'CX', '');
INSERT INTO `country` VALUES (45, 'Cocos (Keeling) Islands', 'CC', '61');
INSERT INTO `country` VALUES (46, 'Colombia', 'CO', '57');
INSERT INTO `country` VALUES (47, 'Comoros', 'KM', '269');
INSERT INTO `country` VALUES (48, 'Congo', 'CG', '242');
INSERT INTO `country` VALUES (49, 'Cook Islands', 'CK', '682');
INSERT INTO `country` VALUES (50, 'Costa Rica', 'CR', '506');
INSERT INTO `country` VALUES (51, 'Cote D''ivoire', 'CI', '225');
INSERT INTO `country` VALUES (52, 'Croatia', 'HR', '385');
INSERT INTO `country` VALUES (53, 'Cuba', 'CU', '53');
INSERT INTO `country` VALUES (54, 'Cyprus', 'CY', '357');
INSERT INTO `country` VALUES (55, 'Czech Republic', 'CZ', '420');
INSERT INTO `country` VALUES (56, 'Denmark', 'DK', '45');
INSERT INTO `country` VALUES (57, 'Djibouti', 'DJ', '253');
INSERT INTO `country` VALUES (58, 'Dominica', 'DM', '1');
INSERT INTO `country` VALUES (59, 'Dominican Republic', 'DO', '1');
INSERT INTO `country` VALUES (60, 'East Timor', 'TP', '670');
INSERT INTO `country` VALUES (61, 'Ecuador', 'EC', '593');
INSERT INTO `country` VALUES (62, 'Egypt', 'EG', '20');
INSERT INTO `country` VALUES (63, 'El Salvador', 'SV', '503');
INSERT INTO `country` VALUES (64, 'Equatorial Guinea', 'GQ', '240');
INSERT INTO `country` VALUES (65, 'Eritrea', 'ER', '291');
INSERT INTO `country` VALUES (66, 'Estonia', 'EE', '372');
INSERT INTO `country` VALUES (67, 'Ethiopia', 'ET', '251');
INSERT INTO `country` VALUES (68, 'Faroe Islands', 'FO', '298');
INSERT INTO `country` VALUES (69, 'Fiji', 'FJ', '679');
INSERT INTO `country` VALUES (70, 'Finland', 'FI', '358');
INSERT INTO `country` VALUES (71, 'France', 'FR', '33');
INSERT INTO `country` VALUES (72, 'France, Metropolitan', 'FX', '33');
INSERT INTO `country` VALUES (73, 'French Guiana', 'GF', '594');
INSERT INTO `country` VALUES (74, 'French Polynesia', 'PF', '689');
INSERT INTO `country` VALUES (75, 'Gabon', 'GA', '241');
INSERT INTO `country` VALUES (76, 'Gambia', 'GM', '220');
INSERT INTO `country` VALUES (77, 'Georgia', 'GE', '995');
INSERT INTO `country` VALUES (78, 'Germany', 'DE', '49');
INSERT INTO `country` VALUES (79, 'Ghana', 'GH', '233');
INSERT INTO `country` VALUES (80, 'Gibraltar', 'GI', '350');
INSERT INTO `country` VALUES (81, 'Greece', 'GR', '30');
INSERT INTO `country` VALUES (82, 'Greenland', 'GL', '299');
INSERT INTO `country` VALUES (83, 'Grenada', 'GD', '1');
INSERT INTO `country` VALUES (84, 'Guadeloupe', 'GP', '590');
INSERT INTO `country` VALUES (85, 'Guam', 'GU', '1');
INSERT INTO `country` VALUES (86, 'Guatemala', 'GT', '502');
INSERT INTO `country` VALUES (87, 'Guinea', 'GN', '224');
INSERT INTO `country` VALUES (88, 'Guinea-bissau', 'GW', '245');
INSERT INTO `country` VALUES (89, 'Guyana', 'GY', '592');
INSERT INTO `country` VALUES (90, 'Haiti', 'HT', '509');
INSERT INTO `country` VALUES (91, 'Honduras', 'HN', '504');
INSERT INTO `country` VALUES (92, 'Hong Kong', 'HK', '852');
INSERT INTO `country` VALUES (93, 'Hungary', 'HU', '36');
INSERT INTO `country` VALUES (94, 'Iceland', 'IS', '354');
INSERT INTO `country` VALUES (95, 'India', 'IN', '91');
INSERT INTO `country` VALUES (96, 'Indonesia', 'ID', '62');
INSERT INTO `country` VALUES (97, 'Iran (Islamic Republic of)', 'IR', '98');
INSERT INTO `country` VALUES (98, 'Iraq', 'IQ', '964');
INSERT INTO `country` VALUES (99, 'Ireland', 'IE', '353');
INSERT INTO `country` VALUES (100, 'Israel', 'IL', '972');
INSERT INTO `country` VALUES (101, 'Italy', 'IT', '39');
INSERT INTO `country` VALUES (102, 'Jamaica', 'JM', '1');
INSERT INTO `country` VALUES (103, 'Japan', 'JP', '81');
INSERT INTO `country` VALUES (104, 'Jordan', 'JO', '962');
INSERT INTO `country` VALUES (105, 'Kazakhstan', 'KZ', '7');
INSERT INTO `country` VALUES (106, 'Kenya', 'KE', '254');
INSERT INTO `country` VALUES (107, 'Kiribati', 'KI', '686');
INSERT INTO `country` VALUES (108, 'Korea', 'KR', '82');
INSERT INTO `country` VALUES (109, 'Kuwait', 'KW', '965');
INSERT INTO `country` VALUES (110, 'Kyrgyzstan', 'KG', '996');
INSERT INTO `country` VALUES (111, 'Latvia', 'LV', '371');
INSERT INTO `country` VALUES (112, 'Lebanon', 'LB', '961');
INSERT INTO `country` VALUES (113, 'Lesotho', 'LS', '266');
INSERT INTO `country` VALUES (114, 'Liberia', 'LR', '231');
INSERT INTO `country` VALUES (115, 'Libya', 'LY', '218');
INSERT INTO `country` VALUES (116, 'Liechtenstein', 'LI', '423');
INSERT INTO `country` VALUES (117, 'Lithuania', 'LT', '370');
INSERT INTO `country` VALUES (118, 'Luxembourg', 'LU', '352');
INSERT INTO `country` VALUES (119, 'Macau', 'MO', '853');
INSERT INTO `country` VALUES (120, 'Madagascar', 'MG', '261');
INSERT INTO `country` VALUES (121, 'Malawi', 'MW', '265');
INSERT INTO `country` VALUES (122, 'Malaysia', 'MY', '60');
INSERT INTO `country` VALUES (123, 'Maldives', 'MV', '960');
INSERT INTO `country` VALUES (124, 'Mali', 'ML', '223');
INSERT INTO `country` VALUES (125, 'Malta', 'MT', '356');
INSERT INTO `country` VALUES (126, 'Martinique', 'MQ', '596');
INSERT INTO `country` VALUES (127, 'Mauritania', 'MR', '222');
INSERT INTO `country` VALUES (128, 'Mauritius', 'MU', '230');
INSERT INTO `country` VALUES (129, 'Mayotte', 'YT', '269');
INSERT INTO `country` VALUES (130, 'Mexico', 'MX', '52');
INSERT INTO `country` VALUES (131, 'Monaco', 'MC', '377');
INSERT INTO `country` VALUES (132, 'Mongolia', 'MN', '976');
INSERT INTO `country` VALUES (133, 'Montserrat', 'MS', '1');
INSERT INTO `country` VALUES (134, 'Morocco', 'MA', '212');
INSERT INTO `country` VALUES (135, 'Mozambique', 'MZ', '258');
INSERT INTO `country` VALUES (136, 'Myanmar', 'MM', '95');
INSERT INTO `country` VALUES (137, 'Namibia', 'NA', '264');
INSERT INTO `country` VALUES (138, 'Nauru', 'NR', '674');
INSERT INTO `country` VALUES (139, 'Nepal', 'NP', '977');
INSERT INTO `country` VALUES (140, 'Netherlands', 'NL', '31');
INSERT INTO `country` VALUES (141, 'New Caledonia', 'NC', '687');
INSERT INTO `country` VALUES (142, 'New Zealand', 'NZ', '64');
INSERT INTO `country` VALUES (143, 'Nicaragua', 'NI', '505');
INSERT INTO `country` VALUES (144, 'Niger', 'NE', '227');
INSERT INTO `country` VALUES (145, 'Nigeria', 'NG', '234');
INSERT INTO `country` VALUES (146, 'Niue', 'NU', '683');
INSERT INTO `country` VALUES (147, 'Norfolk Island', 'NF', '672');
INSERT INTO `country` VALUES (148, 'Norway', 'NO', '47');
INSERT INTO `country` VALUES (149, 'Oman', 'OM', '968');
INSERT INTO `country` VALUES (150, 'Pakistan', 'PK', '92');
INSERT INTO `country` VALUES (151, 'Palau', 'PW', '680');
INSERT INTO `country` VALUES (152, 'Panama', 'PA', '507');
INSERT INTO `country` VALUES (153, 'Papua New Guinea', 'PG', '675');
INSERT INTO `country` VALUES (154, 'Paraguay', 'PY', '595');
INSERT INTO `country` VALUES (155, 'Peru', 'PE', '51');
INSERT INTO `country` VALUES (156, 'Philippines', 'PH', '63');
INSERT INTO `country` VALUES (157, 'Pitcairn', 'PN', '');
INSERT INTO `country` VALUES (158, 'Poland', 'PL', '48');
INSERT INTO `country` VALUES (159, 'Portugal', 'PT', '351');
INSERT INTO `country` VALUES (160, 'Puerto Rico', 'PR', '1');
INSERT INTO `country` VALUES (161, 'Qatar', 'QA', '974');
INSERT INTO `country` VALUES (162, 'Reunion', 'RE', '262');
INSERT INTO `country` VALUES (163, 'Romania', 'RO', '40');
INSERT INTO `country` VALUES (164, 'Russian Federation', 'RU', '7');
INSERT INTO `country` VALUES (165, 'Rwanda', 'RW', '250');
INSERT INTO `country` VALUES (166, 'Saint Kitts and Nevis', 'KN', '1');
INSERT INTO `country` VALUES (167, 'Saint Lucia', 'LC', '1');
INSERT INTO `country` VALUES (168, 'Samoa', 'WS', '');
INSERT INTO `country` VALUES (169, 'San Marino', 'SM', '378');
INSERT INTO `country` VALUES (170, 'Sao Tome and Principe', 'ST', '239');
INSERT INTO `country` VALUES (171, 'Saudi Arabia', 'SA', '966');
INSERT INTO `country` VALUES (172, 'Senegal', 'SN', '221');
INSERT INTO `country` VALUES (173, 'Seychelles', 'SC', '248');
INSERT INTO `country` VALUES (174, 'Sierra Leone', 'SL', '232');
INSERT INTO `country` VALUES (175, 'Singapore', 'SG', '65');
INSERT INTO `country` VALUES (176, 'Slovakia (Slovak Republic)', 'SK', '421');
INSERT INTO `country` VALUES (177, 'Slovenia', 'SI', '386');
INSERT INTO `country` VALUES (178, 'Solomon Islands', 'SB', '677');
INSERT INTO `country` VALUES (179, 'Somalia', 'SO', '252');
INSERT INTO `country` VALUES (180, 'South Africa', 'ZA', '27');
INSERT INTO `country` VALUES (181, 'Spain', 'ES', '34');
INSERT INTO `country` VALUES (182, 'Sri Lanka', 'LK', '94');
INSERT INTO `country` VALUES (183, 'St. Helena', 'SH', '');
INSERT INTO `country` VALUES (184, 'Sudan', 'SD', '249');
INSERT INTO `country` VALUES (185, 'Suriname', 'SR', '597');
INSERT INTO `country` VALUES (186, 'Swaziland', 'SZ', '268');
INSERT INTO `country` VALUES (187, 'Sweden', 'SE', '46');
INSERT INTO `country` VALUES (188, 'Switzerland', 'CH', '41');
INSERT INTO `country` VALUES (189, 'Syrian Arab Republic', 'SY', '963');
INSERT INTO `country` VALUES (190, 'Taiwan', 'TW', '886');
INSERT INTO `country` VALUES (191, 'Tajikistan', 'TJ', '992');
INSERT INTO `country` VALUES (192, 'Thailand', 'TH', '66');
INSERT INTO `country` VALUES (193, 'Togo', 'TG', '228');
INSERT INTO `country` VALUES (194, 'Tokelau', 'TK', '690');
INSERT INTO `country` VALUES (195, 'Tonga', 'TO', '676');
INSERT INTO `country` VALUES (196, 'Trinidad and Tobago', 'TT', '1');
INSERT INTO `country` VALUES (197, 'Tunisia', 'TN', '216');
INSERT INTO `country` VALUES (198, 'Turkey', 'TR', '90');
INSERT INTO `country` VALUES (199, 'Turkmenistan', 'TM', '993');
INSERT INTO `country` VALUES (200, 'Tuvalu', 'TV', '688');
INSERT INTO `country` VALUES (201, 'Uganda', 'UG', '256');
INSERT INTO `country` VALUES (202, 'Ukraine', 'UA', '380');
INSERT INTO `country` VALUES (203, 'United Arab Emirates', 'AE', '971');
INSERT INTO `country` VALUES (204, 'United Kingdom', 'GB', '44');
INSERT INTO `country` VALUES (205, 'United States', 'US', '1');
INSERT INTO `country` VALUES (206, 'Uruguay', 'UY', '598');
INSERT INTO `country` VALUES (207, 'Uzbekistan', 'UZ', '998');
INSERT INTO `country` VALUES (208, 'Vanuatu', 'VU', '678');
INSERT INTO `country` VALUES (209, 'Venezuela', 'VE', '58');
INSERT INTO `country` VALUES (210, 'Viet Nam', 'VN', '84');
INSERT INTO `country` VALUES (211, 'Virgin Islands (British)', 'VG', '');
INSERT INTO `country` VALUES (212, 'Virgin Islands (U.S.)', 'VI', '');
INSERT INTO `country` VALUES (213, 'Wallis and Futuna Islands', 'WF', '681');
INSERT INTO `country` VALUES (214, 'Western Sahara', 'EH', '');
INSERT INTO `country` VALUES (215, 'Yemen', 'YE', '967');
INSERT INTO `country` VALUES (216, 'Yugoslavia', 'YU', '');
INSERT INTO `country` VALUES (217, 'Zambia', 'ZM', '260');
INSERT INTO `country` VALUES (218, 'Zimbabwe', 'ZW', '263');

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

#
# Dumping data for table `currency`
#

INSERT INTO `currency` VALUES (1, 'Slovenia Tolar', 'SIT', 'SIT');
INSERT INTO `currency` VALUES (2, 'Swiss Franc', 'CHF', 'CHF');
INSERT INTO `currency` VALUES (3, 'Malaysian Ringgit', 'MYR', 'MYR');
INSERT INTO `currency` VALUES (4, 'Australian Dollar', '$', 'AUD');
INSERT INTO `currency` VALUES (5, 'US Dollar', '$', 'USD');
INSERT INTO `currency` VALUES (6, 'Canadian Dollar', '$', 'CAD');
INSERT INTO `currency` VALUES (7, 'New Zealand Dollars', 'NZ$', 'NZD');
INSERT INTO `currency` VALUES (8, 'Saudi Riyal', 'SR', 'SAR');
INSERT INTO `currency` VALUES (9, 'Turkish Lira', 'TRL', 'TRL');
INSERT INTO `currency` VALUES (10, 'Swedish Krona', 'Sk', 'SEK');
INSERT INTO `currency` VALUES (11, 'Singapore Dollar', '$', 'SGD');
INSERT INTO `currency` VALUES (12, 'Euro', '€', 'EUR');
INSERT INTO `currency` VALUES (13, 'Indian Rupees', 'Rs.', 'INR');
INSERT INTO `currency` VALUES (14, 'Philippine Peso', 'PHP', 'PHP');
INSERT INTO `currency` VALUES (15, 'Yen', '¥', 'JPY');
INSERT INTO `currency` VALUES (16, 'Pound Sterling (GBP)', '£', 'GBP');
INSERT INTO `currency` VALUES (17, 'Indonesia Rupiah (Rp)', 'Rp', 'IDR');

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

#
# Dumping data for table `customdomainfields`
#

INSERT INTO `customdomainfields` VALUES (1, 'IP Address', 0, 1, 0, 0, 30, 0, 0, 0, '', 0, 0);

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

#
# Dumping data for table `customuserfields`
#

INSERT INTO `customuserfields` VALUES (1, 'First Name', 11, 1, 2, 0, 20, 2, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (2, 'Last Name', 12, 1, 2, 0, 20, 3, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (3, 'Address', 2, 1, 1, 0, 45, 7, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (4, 'Email', 13, 1, 2, 0, 35, 4, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (5, 'City', 3, 1, 1, 0, 20, 8, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (6, 'State', 4, 1, 1, 0, 3, 9, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (7, 'Zipcode', 5, 1, 1, 0, 10, 10, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (8, 'Phone', 7, 1, 1, 0, 20, 6, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (10, 'Organization', 14, 0, 2, 0, 30, 1, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (11, 'ICQ Number', 0, 0, 0, 0, 20, 5, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (12, 'IM on Payment', 1, 0, 0, 0, 20, 12, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (13, 'IM on Login', 1, 0, 0, 0, 20, 13, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (14, 'IM on New Ticket', 1, 0, 0, 0, 20, 14, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (15, 'Country', 6, 1, 1, 0, 20, 11, 1, 0, 1, 1, '');
INSERT INTO `customuserfields` VALUES (16, 'IM on New Signup', 1, 0, 0, 0, 20, 16, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (17, 'HTML Email Format', 1, 1, 0, 0, 55, 18, 1, 1, 0, 1, '');
INSERT INTO `customuserfields` VALUES (18, 'Language', 8, 1, 2, 0, 20, 18, 1, 1, 1, 1, '');
INSERT INTO `customuserfields` VALUES (19, 'TABLESORT_snapshot_invoices', 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (20, 'TABLESORT_snapshot_cc', 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (21, 'TABLESORT_snapshot_tickets', 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (22, 'TABLESORT_snapshot_pending', 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (23, 'TABLESORT_snapshot_uninvoiced', 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (24, 'DASHBOARD_INVOICEFILTER', 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (25, 'Use Paypal Subscriptions', 24, 0, 0, 0, 20, 19, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (26, 'Records per page', 20, 0, 1, 0, 55, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (27, 'Dashboard graph totals', 22, 0, 1, 0, 20, 0, 0, 0, 0, 0, '');
INSERT INTO `customuserfields` VALUES (28, 'Dashboard graph legend', 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', 0, 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',0,0,0,0,20,0,0,0,0,0,'');
Insert into `customuserfields` VALUES (33, 'DASHBOARD_LASTUSEDSNAPSHOT',0,0,0,0,20,0,0,0,0,0,'');

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

#
# Dumping data for table `domain_customdomainfields`
#

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

#
# Dumping data for table `domain_packageaddon_prices`
#

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

#
# Dumping data for table `domains`
#

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

#
# Dumping data for table `files`
#


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

#
# Dumping data for table `files_cats`
#


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

#
# Dumping data for table `files_cats_clienttypes`
#


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

#
# Dumping data for table `files_cats_servers`
#


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

#
# Dumping data for table `files_cats_users`
#


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

#
# Dumping data for table `files_clienttypes`
#


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

#
# Dumping data for table `files_servers`
#


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

#
# Dumping data for table `files_users`
#


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

#
# Dumping data for table `groups`
#

INSERT INTO `groups` VALUES (1, 'User', 0);
INSERT INTO `groups` VALUES (2, 'Site Admin', 0);
INSERT INTO `groups` VALUES (3, 'Tech Support', 0);

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

#
# Dumping data for table `help`
#

INSERT INTO `help` VALUES (1, 'Welcome Email Tags', '[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name<br>[<font class=bodyhighlight>ACCOUNTINFORMATION</font>]<br> Includes Domain Name, Username, Password, IP<br>[<font class=bodyhighlight>DOMAINNAME</font>]<br> domain name without http://www.<br>[<font class=bodyhighlight>DOMAINUSERNAME</font>]<br> Domain User Name<br>[<font class=bodyhighlight>DOMAINPASSWORD</font>]<br> Domain Password<br>[<font class=bodyhighlight>DOMAINIP</font>]<br> IP Address to Domain<br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your web site<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> E-mail to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<br>[<font class=bodyhighlight>CLIENTNAME</font>]<br>Both first and last name<br>[<font class=bodyhighlight>CLIENTEMAIL</font>]<br>[<font class=bodyhighlight>NAMESERVERS</font>]<br>lists only hostnames<br>[<font class=bodyhighlight>NAMESERVERSANDIPS</font>]<br>lists both IPs and hostnames<br>[<font class=bodyhighlight>SERVERHOSTNAME</font>]<br>example server1.yourdomain.com<br>[<font class=bodyhighlight>SERVERSHAREDIP</font>]<br>shared IP for server<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name<br>[<font class=bodyhighlight>CUSTOMPACKAGE_xxxx</font>]<br>where xxx is custom package field name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (2, 'Invoice Template Tags', '[<font class=bodyhighlight>DATE</font>] Date payment is due.<br>[<font class=bodyhighlight>SENTDATE</font>] Date invoice was originally sent.<br>[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>INVOICENUMBER</font>]<br>[<font class=bodyhighlight>INVOICEDESCRIPTION</font>]<br>[<font class=bodyhighlight>TAX</font>]<br>[<font class=bodyhighlight>AMOUNT_EX_TAX</font>] The total price excluding taxes.<br>[<font class=bodyhighlight>AMOUNT</font>] The total price due.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] E-mail address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (3, 'Recommend Us Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>COMPANYURL</font>] URL to your companies website, not ClientExec\'s<br>[<font class=bodyhighlight>CUSTOM_xxxx</font>]<br>where xxx is custom field name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (4, 'Reset Password Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>]<br>[<font class=bodyhighlight>REQUESTIP</font>] IP of the machine which requested the password change.<br>[<font class=bodyhighlight>CONFIRMATION URL</font>] URL that user must press to confirm the password change<br>[<font class=bodyhighlight>CUSTOM_xxxx</font>]<br>where xxx is custom field name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (5, 'Recurring Invoice Setting', '<img src=images/sub_dot.gif>&nbsp;Generate Uninvoiced Work:<br>Creates an uninvoiced work entry for your customer. You will need to create an invoice, or merge it INTO an invoice and send.<br><br><img src=images/sub_dot.gif>&nbsp;Generate Invoice:<br>Creates an invoice with one entry for the hosting work. Invoice will still need to be sent.<br><br><img src=images/sub_dot.gif>&nbsp;Generate Invoice & Send:<br>Creates the invoice and sends.', 'Click for more detailed info', 240, 320);
INSERT INTO `help` VALUES (6, 'Ticket Template Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>TICKETNUMBER</font>]<br>[<font class=bodyhighlight>DESCRIPTION</font>]<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>CUSTOM_xxxx</font>]<br>where xxx is custom field name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (7, 'Signup Completion Tags', '[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYURL</font>]<br> URL to your web site<br>[<font class=bodyhighlight>SUPPORTEMAIL</font>]<br> E-mail to support staff<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>]<br> URL to ClientExec.', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (8, 'Run schedule format', 'In the Run Schedule fields you can enter any format accepted by the Cron utility. For example for the field Minute: <ul> <li>* : every minute <li>Number: e.g. 4 will make it run at :04 <li>Range: e.g. 1-3 will make it run at :01, :02, :03 <li>List: e.g. 1,3,7 will make it run at :01, :03, :07 <li>Step: e.g. */3 will make it run every third minute <li>Range and step: 0-30/2 will make it run every other minute till :30 </ul> In Day of the Week you can enter a number in the range 0-7 (0 for Sunday) or a 3 letter shortcut (e.g. sun).', 'Click to view schedule format', 240, 420);
INSERT INTO `help` VALUES (9, 'Batch Invoice Notifier Tags', '[<font class=bodyhighlight>DATE</font>] Date payment is due.<br>[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>] <br>[<font class=bodyhighlight>AMOUNT</font>] The total price due.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to ClientExec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] E-mail address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name', 'Click to view available tags', '240', '320');
INSERT INTO `help` VALUES (10, 'Expiring CC Template', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>CLIENTEMAIL</font>]<br>[<font class=bodyhighlight>CCLASTFOUR</font>] The last four digits of the customer\'s credit card.<br>[<font class=bodyhighlight>CCEXPDATE</font>] The expiration date of the customer\'s credit card.<br>[<font class=bodyhighlight>CLIENTAPPLICATIONURL</font>] URL to Client Exec.<br>[<font class=bodyhighlight>FORGOTPASSWORDURL</font>] URL to retrieve forgotten password.<BR>[<font class=bodyhighlight>COMPANYNAME</font>] <BR>[<font class=bodyhighlight>BILLINGEMAIL</font>] Email address for billing inquiries<br>[<font class=bodyhighlight>CUSTOMPROFILE_xxxx</font>]<br>where xxx is custom profile field name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (11, 'Announcement Tags', '[<font class=bodyhighlight>CLIENTNAME</font>]<br> Includes name and last name<br>[<font class=bodyhighlight>FIRSTNAME</font>]<br> First name of the client<br>[<font class=bodyhighlight>LASTNAME</font>]<br> Last name of the client<br>[<font class=bodyhighlight>ORGANIZATION</font>]<br> Client\'s Organization<br>[<font class=bodyhighlight>DATE</font>]<br> Actual Date<br>[<font class=bodyhighlight>COMPANYNAME</font>] <br> Company name', 'Click to view available tags', 240, 320);
INSERT INTO `help` VALUES (12, 'Get New Password Tags', '[<font class=bodyhighlight>CLIENTNAME</font>] <br>[<font class=bodyhighlight>NEWPASSWORD</font>] <br>[<font class=bodyhighlight>CLIENTEXEC URL</font>] <br>[<font class=bodyhighlight>COMPANYNAME</font>] <br>[<font class=bodyhighlight>COMPANYEMAIL</font>]', 'Click to view available tags', 240, 320);

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

#
# Dumping data for table `invoice`
#


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

#
# Dumping data for table `invoiceentry`
#


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

#
# Dumping data for table `invoicetransaction`
#


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

#
# Dumping data for table `module`
#

INSERT INTO `module` VALUES (2, 'HOME', 'This is an example Home Text string! You can change this in Admin-settings', 1, 0);
INSERT INTO `module` VALUES (3, 'CLIENTS', 'This is an example Client Text string! You can change this in Admin-settings', 2, 0);
INSERT INTO `module` VALUES (4, 'BILLING', 'This is an example Support Text string! You can change this in Admin-settings', 3, 1);
INSERT INTO `module` VALUES (5, 'SUPPORT', 'This is an example Support Text string! You can change this in Admin-settings', 4, 1);
INSERT INTO `module` VALUES (6, 'ADMIN', 'This is an example Admin Text string! You can change this in Admin-settings', 5, 0);
INSERT INTO `module` VALUES (7, 'REPORT', 'Report module description', 6, 0);
INSERT INTO `module` VALUES (8, 'FILES', 'Files module description', 7, 0);

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

#
# Dumping data for table `module_group`
#

INSERT INTO `module_group` VALUES (2, 2, 1, 1);
INSERT INTO `module_group` VALUES (3, 2, 1, 1);
INSERT INTO `module_group` VALUES (4, 2, 1, 1);
INSERT INTO `module_group` VALUES (5, 2, 1, 1);
INSERT INTO `module_group` VALUES (6, 2, 1, 1);
INSERT INTO `module_group` VALUES (2, 3, 1, 0);
INSERT INTO `module_group` VALUES (3, 3, 1, 0);
INSERT INTO `module_group` VALUES (4, 3, 0, 0);
INSERT INTO `module_group` VALUES (5, 3, 1, 1);
INSERT INTO `module_group` VALUES (6, 3, 1, 0);
INSERT INTO `module_group` VALUES (2, 1, 1, 0);
INSERT INTO `module_group` VALUES (3, 1, 1, 0);
INSERT INTO `module_group` VALUES (4, 1, 1, 0);
INSERT INTO `module_group` VALUES (5, 1, 1, 0);
INSERT INTO `module_group` VALUES (6, 1, 0, 0);
INSERT INTO `module_group` VALUES (7, 3, 1, 0);
INSERT INTO `module_group` VALUES (7, 1, 0, 0);
INSERT INTO `module_group` VALUES (7, 2, 1, 1);
INSERT INTO `module_group` VALUES (2, 4, 1, 0);
INSERT INTO `module_group` VALUES (3, 4, 1, 1);
INSERT INTO `module_group` VALUES (4, 4, 1, 1);
INSERT INTO `module_group` VALUES (5, 4, 1, 0);
INSERT INTO `module_group` VALUES (6, 4, 1, 0);
INSERT INTO `module_group` VALUES (7, 4, 1, 0);
INSERT INTO `module_group` VALUES (2, 5, 1, 0);
INSERT INTO `module_group` VALUES (3, 5, 1, 1);
INSERT INTO `module_group` VALUES (4, 5, 0, 0);
INSERT INTO `module_group` VALUES (5, 5, 1, 1);
INSERT INTO `module_group` VALUES (6, 5, 1, 0);
INSERT INTO `module_group` VALUES (7, 5, 1, 0);
INSERT INTO `module_group` VALUES (8, 1, 1, 0);
INSERT INTO `module_group` VALUES (8, 2, 1, 1);
INSERT INTO `module_group` VALUES (8, 3, 1, 0);
INSERT INTO `module_group` VALUES (8, 4, 1, 0);
INSERT INTO `module_group` VALUES (8, 5, 1, 0);

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

#
# Dumping data for table `nameserver`
#


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

#
# Dumping data for table `package`
#

INSERT INTO `package` VALUES (1, 'Basic', 'Plan Features:<br>\r\n1Gig Bandwidth<br>\r\n75MB Diskspace<br>\r\n...', 5, '9.95', 1, '29.85', '59.7', '119.4', 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 0);
INSERT INTO `package` VALUES (2, 'Standard', 'Plan Features:<br>\r\n3Gig Bandwidth<br> \r\n150MB Diskspace<br>\r\n...', 5, '17.95', 1, '53.85', '107.7', '215.4', 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 0);
INSERT INTO `package` VALUES (3, 'Charity', 'Only for charity sites with low bandwidth and diskspace<br><br>\r\nPlan Features:<br>\r\n500Gig Bandwidth<br> \r\n10MB Diskspace<br>\r\n...', 5, '3', 1, '9', '18', '36', 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 0);
INSERT INTO `package` VALUES (13, 'Free', 'Plan Features:<br>\r\n1Gig Bandwidth<br> \r\n75MB Diskspace<br>\r\n...', 5, '0', 1, '0', '0', '0', 1, 1, 1, 1, '0', 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 0);

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

#
# Dumping data for table `package_variable`
#

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

#
# Dumping data for table `packageaddon`
#

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

#
# Dumping data for table `packageaddon_prices`
#

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

#
# Dumping data for table `promotion`
#

INSERT INTO `promotion` VALUES (5, 'NORMAL', 'This client type is used for everyone signing up for our services through our advertised rates on our website, normal clients. (non promotions)', 1, 1, 'Here is the information for your web hosting account.\r\n\r\n[ACCOUNTINFORMATION]\r\n\r\nFTP Username and password\r\nFTP Username:[DOMAINUSERNAME]@[DOMAINNAME]\r\nFTP Password:[DOMAINPASSWORD]\r\n\r\nYou can log in by FTP using either the domain name or the IP address.\r\n\r\nIf you recently changed your domain registration record or your domain was only recently registered, you may have to use the IP address for 2 or 3 days until the change is reflected across all the DNS servers around the Internet.\r\n\r\nIf your domain name was previously hosted somewhere else, you will need to update your DNS information to the following:\r\n\r\n[NAMESERVERS]\r\n\r\nFor those who wish to use CGI scripts, the Perl path is:\r\n  /usr/bin/perl\r\nIf you need to use sendmail, it can be found in:\r\n  /usr/sbin/sendmail\r\nYou absolute server path for cgi-bin directory is:\r\n  /home/virtual/[DOMAINNAME]/var/www/cgi-bin\r\nand for the browsable html dir:\r\n  /home/virtual/[DOMAINNAME]/var/www/html\r\n\r\nBe sure to secure your scripts, as any spam sent out using sendmail will result in account deactivation.\r\n\r\nTo add, delete, or modify email accounts and customize some settings for your hosting account please visit the URL\r\n\r\n  http://[DOMAINIP]/admin\r\n\r\nOnce your domain name resolves to the new server, you can use the URL\r\n\r\n  http://[DOMAINNAME]/admin\r\n\r\nUpload your web files into the &quot; mainwebsite_html &quot; directory. CGI files have to be placed in the cgi-bin \r\ndirectory located one level up the browsable html dir. \r\nNOTE: when you log in via FTP, you will initially see the directory called mainwebsite_html if you enter that directory you will see the files that are accessable via browser.\r\n\r\nYou must back up one directory to see the /cgi-bin and the /html directory. \r\n\r\n/mainwebsite_html dir and /html dir \r\n\r\nTo access your MYSQL database you need the following information:\r\nmysql host: localhost\r\nmysql username: [DOMAINUSERNAME]\r\nmysql password: must be set in your control panel\r\nmysql database name: domainname_ext\r\n(example: yahoo.com -> yahoo_com for db name)\r\n\r\nYou can manage your database via command line or use PhpMyAdmin located at this URL:\r\nhttp://[DOMAINIP]/MyAdmin/index.php\r\nLogin with your mysql username and password.\r\n\r\nIf you have any questions about your account, please direct them to [SUPPORTEMAIL]  for fastest response.\r\n\r\nThanks for choosing our company.', 1, 'Shared Web Hosting', 1, 0, 'yourdomain.com', 1, 0, 1, 1);

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

#
# Dumping data for table `recurringfee`
#

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

#
# Dumping data for table `registrars`
#

INSERT INTO `registrars` VALUES ('enom', 'us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:1:"9";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"14";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"14";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"10";s:11:"description";s:19:"Application Purpose";s:7:"options";a:5:{s:10:"For Profit";a:2:{s:11:"description";s:23:"Business use for profit";s:5:"value";s:2:"P1";}s:10:"Non-profit";a:2:{s:11:"description";s:68:"Non-profit business, club, association, religious organization, etc.";s:5:"value";s:2:"P2";}s:8:"Personal";a:2:{s:11:"description";s:12:"Personal use";s:5:"value";s:2:"P3";}s:11:"Educational";a:2:{s:11:"description";s:20:"Educational purposes";s:5:"value";s:2:"P4";}s:10:"Government";a:2:{s:11:"description";s:19:"Government purposes";s:5:"value";s:2:"P5";}}}}');
INSERT INTO `registrars` VALUES ('enom', 'ca', 'a:4:{s:15:"cira_legal_type";a:3:{s:2:"ID";s:1:"1";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:18:{s:11:"Corporation";a:3:{s:11:"description";s:571:"A corporation under the laws of Canada or any province or territory of Canada, Charities, Cooperative, Council.<br/>Requirements: Registrant name must be the full legal name of the corporation and must be followed by the jurisdiction of incorporation (eg. Canada, Ontario, NWT...), unless it is obvious from the corporation''s name. Canadian Internet Registration Authority (Canada). For Charities, the NFP should be included in the organization name. If this is a not-for-profit organization, you are also required to submit the registration number i.e.: 123456789 RR0001";s:5:"value";s:3:"CCO";s:8:"requires";a:1:{i:0;s:2:"42";}}s:16:"Canadian Citizen";a:2:{s:11:"description";s:886:"A Canadian citizen of the age of majority under the laws of the province or territory in Canada in which he or she resides or last resided.<br/>Requirements: The Registrant''s name must be the full legal name of the Canadian Citizen who will hold the domain name registration as the name would appear on a passport, driver''s license or other identification document issued by a government. The name can be followed by a space and "o/a xxxx" where "o/a" stands for "Operating As" and "xxxx" can be any alpha-numeric string designated by the applicant and subject to applicable rules and length restrictions (e.g. "John Doe o/a Doe Consulting Group"). The name may also be followed by a space and a degree granted to the registrant (eg. PhD.) Full legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''''), hyphen(-), period(.).";s:5:"value";s:3:"CCT";}s:17:"Canadian Resident";a:2:{s:11:"description";s:1536:"A permanent resident as defined in the Immigration and Refugee Protection Act (Canada) S.C. 2001, c.27, as amended from time to time, who is "ordinarily resident" (as defined below) in Canada and of the age of majority under the laws of the province or territory in Canada in which he or she resides or last resided. "Ordinarily resident in Canada" means an individual who resides in Canada for more than 183 days in the twelve month period immediately preceding the date of the applicable request for registration of the .ca domain name or sub-domain name and in each twelve month period thereafter for the duration of the domain name registration.<br/>Requirements: The Registrant''s name must be the full legal name of the Permanent Resident who will hold the domain name registration as the name would appear on a driver''s license or other identification document issued by a government. The full legal name may be followed by a space and "o/a xxxx" where "o/a" stands for "Operating As" and "xxxx" can be any alpha-numeric string designated by the applicant and subject to applicable rules and length restrictions (e.g. "John Doe o/a Doe Consulting Group"). The name may also be followed by a space and andegree granted to the registrant by a recognized degree granting institution or a recognized professional designation which the registrant has the right to use  (eg. PhD, MD, DDS.) Full legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''''), hyphen(-), period(.).";s:5:"value";s:3:"RES";}s:17:"Government Entity";a:2:{s:11:"description";s:732:"Her Majesty the Queen in right of Canada, a province or a territory; an agent of Her Majesty the Queen in right of Canada, of a province or of a territory; a federal, provincial or territorial Crown corporation, government agency or government entity; or a regional, municipal or local area government.<br />Requirements: The Registrant''s name must be the complete official name of the entity that will hold the domain name registration, without any abbreviations. (A common abbreviation may follow the official name in parentheses). If the Registrant is not a government, the Registrant''s name must be followed by the name of the jurisdiction (eg. Canada, province, territory, municipality, etc) to which the Registrant is related.";s:5:"value";s:3:"GOV";}s:11:"Educational";a:2:{s:11:"description";s:983:"(i) A university or college which is located in Canada and which is authorized or recognized as a university or college under an Act of the legislature of a province or territory of Canada; or<br />(ii) A college, post-secondary school, vocational school, secondary school, pre-school or other school or educational institution which is located in Canada and which is recognized by the educational authorities of a province or territory of Canada or licensed under or maintained by an Act of Parliament of Canada or of the legislature of a province or territory of Canada.<br />Requirements: The Registrant''s name must be the complete official name of the institution that will hold the domain name registration, without any abbreviations. A common abbreviation may follow the official name in parentheses. The Registrant name must be followed by the jurisdiction (e.g. name of province, municipality) in which the institution is accredited if not obvious from the Registrant''s name.";s:5:"value";s:3:"EDU";}s:26:"Unincorporated Association";a:3:{s:11:"description";s:1067:"This Registrant Type is principally intended for religious congregations, social and sports clubs and community groups, council (not registered) or society (not registered) which are based and operating in Canada. An unincorporated organization, association or club:<br />(i) At least 80% of whose members: (A) are ordinarily resident in Canada (if such members are individuals); or (B) meet the requirements of any one of the following Registrant Types: Corporation (Canada or Canadian province or territory), Canadian citizen, Permanent Resident of Canada, Partnership Registered in Canada, Trust established in Canada, Legal Representative of a Canadian Citizen or Permanent Resident; and<br />(ii) At least 80% of whose directors, officers, employees, managers, administrators or other representatives are ordinarily resident in Canada.<br />Requirements: The Registrant''s name must be the complete name of the association that will hold the domain name registration, without any abbreviations. (A common abbreviation may follow the complete name in parentheses).";s:5:"value";s:3:"ASS";s:8:"requires";a:1:{i:0;s:2:"42";}}s:8:"Hospital";a:2:{s:11:"description";s:565:"A hospital which is located in Canada and which is licensed, authorized or approved to operate as a hospital under an Act of the legislature of a province or territory of Canada<br />Requirements: The Registrant''s name must be the complete official name of the hospital that will hold the domain name registration, without any abbreviations. (A common abbreviation may follow the complete name in parentheses.) The Registrant''s name must be followed by the jurisdiction (eg. name of province) which accredited the hospital if not obvious from the Registrant''s name.";s:5:"value";s:3:"HOP";}s:11:"Partnership";a:3:{s:11:"description";s:666:"A partnership, more than 66 2/3 per cent of whose partners meet the requirements of one of the following Registrant Types: Corporation (Canada or Canadian province or territory), Canadian citizen, Permanent Resident of Canada, Trust established in Canada or a Legal Representative of a Canadian Citizen or Permanent Resident, which is registered as a partnership under the laws of any province or territory of Canada.<br />Requirements: The Registrant''s name must be the registered name of the partnership that will hold the domain name registration. The Registrant name must be followed by the jurisdiction of registration (eg. Alberta) and the registration number.";s:5:"value";s:3:"PRT";s:8:"requires";a:1:{i:0;s:2:"42";}}s:10:"Trade-mark";a:3:{s:11:"description";s:898:"A Person which does not fall under any other registrant type, but which is the owner of a trade-mark which is the subject of a registration under the Trade-marks Act (Canada) R.S.C. 1985, c.T-13 as amended from time to time, but in this case such permission is limited to a request to register a .ca domain name consisting of or including the exact word component of that registered trade-mark.<br />This Registrant Type is only intended for Registrants which do not meet the requirements associated with any other registrant type but which have a trade-mark registered in Canada. (Trade-marks subject of trade-mark applications and trade-marks registered in other jurisdictions, such as the United States, do not qualify.)<br />The domain name to be registered must include the trade-mark. (eg. If the trade-mark is AVEA this type of registrant can register avea.ca or aveaisus.ca but not xyz.ca).";s:5:"value";s:3:"TDM";s:8:"requires";a:1:{i:0;s:2:"41";}}s:11:"Trade Union";a:2:{s:11:"description";s:526:"A trade union which is recognized by a labour board under the laws of Canada or any province or territory of Canada and which has its head office in Canada.<br />Requirements: The Registrant''s name must be the complete official name of the trade union that will hold the domain name registration, without abbreviations. (A common abbreviation may follow the official name in parentheses.) The Registrant name must be followed by the jurisdiction in Canada which recognizes it (if it is not obvious from the Registrant''s name.)";s:5:"value";s:3:"TRD";}s:15:"Political Party";a:2:{s:11:"description";s:482:"A political party registered under a relevant electoral law of Canada or any province or territory of Canada<br />Requirements: The Registrant''s name must be the complete official name of the political party holding the domain name registration, without abbreviations. (A common abbreviation may follow the official name in parentheses.) The Registrant name must also by followed by the jurisdiction in Canada in which it is registered (if it is not obvious from the official name).";s:5:"value";s:3:"PLT";}s:26:"Library, Archive or Museum";a:2:{s:11:"description";s:633:"An institution, whether or not incorporated, that:<br />(i) is located in Canada; and<br />(ii) is not established or conducted for profit or does not form part of, or is not administered or directly or indirectly controlled by, a body that is established or conducted for profit in which is held and maintained a collection of documents and other materials that is open to the public or to researchers.<br />Requirements: The Registrant''s name  must be the complete legal name of the institution which will hold the domain name registration without abbreviations. (A common abbreviation may follow the complete name in parentheses.)";s:5:"value";s:3:"LAM";}s:5:"Trust";a:2:{s:11:"description";s:760:"A trust established and subsisting under the laws of a province or territory of Canada, more than 66 2/3 % of whose trustees meet the requirements of one of the following Registrant Types: Corporation (Canada or Canadian province or territory), Canadian citizen, Permanent Resident of Canada, or a Legal Representative of a Canadian Citizen or Permanent Resident.<br />Requirements: The Registrant''s name must be the complete official name of the trust, without any abbreviations. (A common abbreviation may follow the official name in parentheses.) The Registrant name must also indicate the total percentage of the trustees that meet one or more of the following requirements: Canadian citizen, permanent resident, Canadian corporation, legal representative.";s:5:"value";s:3:"TRS";}s:18:"Aboriginal Peoples";a:2:{s:11:"description";s:1346:"Any individual belonging to any Inuit, First Nation, Metis or other people indigenous to Canada.<br />Requirements: The Registrant''s name must be the full legal name of the Aboriginal Person applying for the Registration as it would appear on a driver''s license or other identification document issued by government.<br />The Registrant may enter its full legal name followed by a space and "o/a xxxx" where "o/a" stands for "Operating As" and "xxxx" can be any alpha-numeric string designated by the applicant and subject to applicable rules and length restrictions (e.g. "John Doe o/a Doe Consulting Group"). The name may also be followed by a space and a degree granted to the registrant by a recognized degree granting institution or a recognized professional designation which the registrant has the right to use  (eg. PhD, MD, DDS.)<br />Full legal names of individuals may only consist of alphabetic characters and the special characters: single quote mark(''''), hyphen(-), period(.).<br/>Groups: Any Inuit, First Nation, Metis or other people indigenous to Canada, and any collectivity of such Aboriginal peoples.<br />Requirements: The Registrant''s name must be the complete official name of the indigenous people a collectivity of Aboriginal Persons or, if there is no official name, the name by which the collectivity is commonly known.";s:5:"value";s:3:"ABO";}s:11:"Indian Band";a:2:{s:11:"description";s:272:"Any Indian band as defined in the Indian Act, R.S.C. 1985, c. I-5, as amended from time to time, and any group of Indian bands;<br />Requirements: The name of Registrant must be the Indian Band Name as registered with the Department of Indian and Northern Affairs, Canada.";s:5:"value";s:3:"INB";}s:20:"Legal Representative";a:2:{s:11:"description";s:865:"An executor, administrator or other legal representative of a Person listed as a Canadian Citizen or Permanent Resident of Canada.<br />Note: This registrant type is only available to a person or entity that has been appointed by legal process to represent an individual who is not competent to represent him or herself. It is not available to anyone who represents a Canadian or foreign corporation  in any capacity.<br />Requirements: The Registrant''s name must be the full legal name of the Canadian Citizen or Permanent Resident of Canada who is being represented as it would appear on a passport, driver''s license or other government identification document. This must be followed by the full legal name and capacity of at least one of the official representatives. The representative should be identified as the administrative contact for these registrations.";s:5:"value";s:3:"LGR";}s:13:"Official Mark";a:2:{s:11:"description";s:1242:"A Person which does not meet the requirements for any other Registrant Type, but which is a Person intended to be protected by Subsection 9(1) of the Trade-Marks Act (Canada) at whose request the Registrar of Trade-marks has published notice of adoption of any badge, crest, emblem, official mark or other mark pursuant to Subsection 9(1), but in this case such permission is limited to a request to register a .ca domain name consisting of or including the exact word component of such badge, crest, emblem, official mark or other mark in respect of which such Person requested publications.<br />Notes: This registrant type is only intended for Registrants which do not meet the requirements associated with any other registrant type but which have an Official Mark registered in Canada. The domain name must include the official mark (eg. If the official mark is WIPO, the registrant can register wipo.ca but not intellectual-property.ca)<br />Requirements: The Registrant''s name must be the complete official name of the entity holding the domain name registration without any abbreviations. (A common abbreviation may follow the complete name in parentheses.) The registration number of the official mark must follow the Registrant Name.";s:5:"value";s:3:"OMK";}s:9:"The Queen";a:2:{s:11:"description";s:182:"Her Majesty Queen Elizabeth the Second and her successors.Requirements: The Registrant?s name must be that of Her Majesty the Queen or, after a succession, the name of her successor.";s:5:"value";s:3:"MAJ";}}}s:15:"cira-registrant";a:3:{s:2:"ID";s:2:"39";s:11:"description";s:51:"Registrant of domain (individual or company''s name)";s:7:"options";a:0:{}}s:17:"cira-trademark-no";a:3:{s:2:"ID";s:2:"41";s:11:"description";s:16:"Trademark Number";s:7:"options";a:0:{}}s:22:"cira-org-registered-in";a:3:{s:2:"ID";s:2:"42";s:11:"description";s:32:"Organization registered location";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('enom', 'co.uk', 'a:3:{s:14:"registered_for";a:3:{s:2:"ID";s:2:"15";s:11:"description";s:95:"Company or person domain is registered for (this must be accurate and cannot be changed easily)";s:7:"options";a:0:{}}s:13:"uk_legal_type";a:3:{s:2:"ID";s:1:"2";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:16:{s:13:"UK Individual";a:2:{s:11:"description";s:33:"UK Individual (our default value)";s:5:"value";s:3:"IND";}s:37:"Non-UK Individual (representing self)";a:2:{s:11:"description";s:37:"Non-UK Individual (representing self)";s:5:"value";s:6:"Non-UK";}s:18:"UK Limited Company";a:3:{s:11:"description";s:18:"UK Limited Company";s:5:"value";s:3:"LTD";s:8:"requires";a:1:{i:0;s:1:"4";}}s:25:"UK Public Limited Company";a:3:{s:11:"description";s:25:"UK Public Limited Company";s:5:"value";s:3:"PLC";s:8:"requires";a:1:{i:0;s:1:"4";}}s:14:"UK Partnership";a:2:{s:11:"description";s:14:"UK Partnership";s:5:"value";s:4:"PTNR";}s:6:"UK LLP";a:3:{s:11:"description";s:32:"UK Limited Liability Partnership";s:5:"value";s:3:"LLP";s:8:"requires";a:1:{i:0;s:1:"4";}}s:14:"UK Sole Trader";a:2:{s:11:"description";s:14:"UK Sole Trader";s:5:"value";s:4:"STRA";}s:21:"UK Registered Charity";a:2:{s:11:"description";s:21:"UK Registered Charity";s:5:"value";s:5:"RCHAR";}s:42:"UK Industrial/Provident Registered Company";a:2:{s:11:"description";s:42:"UK Industrial/Provident Registered Company";s:5:"value";s:2:"ip";}s:9:"UK School";a:2:{s:11:"description";s:9:"UK School";s:5:"value";s:3:"SCH";}s:18:"UK Government Body";a:2:{s:11:"description";s:18:"UK Government Body";s:5:"value";s:3:"GOV";}s:31:"UK Corporation by Royal Charter";a:2:{s:11:"description";s:31:"UK Corporation by Royal Charter";s:5:"value";s:3:"CRC";}s:22:"UK Statutory Body FIND";a:2:{s:11:"description";s:22:"UK Statutory Body FIND";s:5:"value";s:4:"STAT";}s:17:"UK Entity (other)";a:2:{s:11:"description";s:17:"UK Entity (other)";s:5:"value";s:5:"OTHER";}s:18:"Non-UK Corporation";a:2:{s:11:"description";s:18:"Non-UK Corporation";s:5:"value";s:5:"FCORP";}s:27:"Non-UK Organization (other)";a:2:{s:11:"description";s:19:"Non-UK Organization";s:5:"value";s:6:"FOTHER";}}}s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:1:"4";s:11:"description";s:32:"UK company identification number";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('enom', 'org.uk', 'a:3:{s:14:"registered_for";a:3:{s:2:"ID";s:2:"16";s:11:"description";s:95:"Company or person domain is registered for (this must be accurate and cannot be changed easily)";s:7:"options";a:0:{}}s:13:"uk_legal_type";a:3:{s:2:"ID";s:1:"3";s:11:"description";s:32:"Legal type of registrant contact";s:7:"options";a:16:{s:13:"UK Individual";a:2:{s:11:"description";s:33:"UK Individual (our default value)";s:5:"value";s:3:"IND";}s:37:"Non-UK Individual (representing self)";a:2:{s:11:"description";s:37:"Non-UK Individual (representing self)";s:5:"value";s:6:"Non-UK";}s:18:"UK Limited Company";a:3:{s:11:"description";s:18:"UK Limited Company";s:5:"value";s:3:"LTD";s:8:"requires";a:1:{i:0;s:1:"5";}}s:25:"UK Public Limited Company";a:3:{s:11:"description";s:25:"UK Public Limited Company";s:5:"value";s:3:"PLC";s:8:"requires";a:1:{i:0;s:1:"5";}}s:14:"UK Partnership";a:2:{s:11:"description";s:14:"UK Partnership";s:5:"value";s:4:"PTNR";}s:6:"UK LLP";a:3:{s:11:"description";s:32:"UK Limited Liability Partnership";s:5:"value";s:3:"LLP";s:8:"requires";a:1:{i:0;s:1:"5";}}s:14:"UK Sole Trader";a:2:{s:11:"description";s:14:"UK Sole Trader";s:5:"value";s:4:"STRA";}s:21:"UK Registered Charity";a:2:{s:11:"description";s:21:"UK Registered Charity";s:5:"value";s:5:"RCHAR";}s:42:"UK Industrial/Provident Registered Company";a:2:{s:11:"description";s:42:"UK Industrial/Provident Registered Company";s:5:"value";s:2:"ip";}s:9:"UK School";a:2:{s:11:"description";s:9:"UK School";s:5:"value";s:3:"SCH";}s:18:"UK Government Body";a:2:{s:11:"description";s:18:"UK Government Body";s:5:"value";s:3:"GOV";}s:31:"UK Corporation by Royal Charter";a:2:{s:11:"description";s:31:"UK Corporation by Royal Charter";s:5:"value";s:3:"CRC";}s:22:"UK Statutory Body FIND";a:2:{s:11:"description";s:22:"UK Statutory Body FIND";s:5:"value";s:4:"STAT";}s:17:"UK Entity (other)";a:2:{s:11:"description";s:17:"UK Entity (other)";s:5:"value";s:5:"OTHER";}s:18:"Non-UK Corporation";a:2:{s:11:"description";s:18:"Non-UK Corporation";s:5:"value";s:5:"FCORP";}s:27:"Non-UK Organization (other)";a:2:{s:11:"description";s:19:"Non-UK Organization";s:5:"value";s:6:"FOTHER";}}}s:12:"uk_reg_co_no";a:3:{s:2:"ID";s:1:"5";s:11:"description";s:32:"UK company identification number";s:7:"options";a:0:{}}}');
INSERT INTO `registrars` VALUES ('enom', 'de', 'a:1:{s:14:"confirmaddress";a:3:{s:2:"ID";s:2:"26";s:11:"description";s:23:"Confirmation of address";s:7:"options";a:1:{s:47:"I confirm the below Admin contact is in Germany";a:2:{s:11:"description";s:68:"I confirm the Administrative address below is a valid German address";s:5:"value";s:2:"DE";}}}}');
INSERT INTO `registrars` VALUES ('enom', 'kids.us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:2:"18";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"19";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"19";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"20";s:11:"description";s:19:"Application Purpose";s:7:"options";a:5:{s:10:"For Profit";a:2:{s:11:"description";s:23:"Business use for profit";s:5:"value";s:2:"P1";}s:10:"Non-profit";a:2:{s:11:"description";s:68:"Non-profit business, club, association, religious organization, etc.";s:5:"value";s:2:"P2";}s:8:"Personal";a:2:{s:11:"description";s:12:"Personal use";s:5:"value";s:2:"P3";}s:11:"Educational";a:2:{s:11:"description";s:20:"Educational purposes";s:5:"value";s:2:"P4";}s:10:"Government";a:2:{s:11:"description";s:19:"Government purposes";s:5:"value";s:2:"P5";}}}}');
INSERT INTO `registrars` VALUES ('directi', 'us', 'a:2:{s:8:"us_nexus";a:3:{s:2:"ID";s:1:"9";s:11:"description";s:14:"Nexus Category";s:7:"options";a:5:{s:10:"US Citizen";a:2:{s:11:"description";s:36:"A natural person who is a US Citizen";s:5:"value";s:3:"C11";}s:18:"Permanent Resident";a:2:{s:11:"description";s:44:"A natural person who is a Permanent Resident";s:5:"value";s:3:"C12";}s:15:"Business Entity";a:2:{s:11:"description";s:100:"An entity or organization that is (i) incorporated within one of the fifty US states, the District o";s:5:"value";s:3:"C21";}s:14:"Foreign Entity";a:3:{s:11:"description";s:100:"A foreign organization that regularly engages in lawful activities (sales of goods or services or ot";s:5:"value";s:3:"C31";s:8:"requires";a:1:{i:0;s:2:"14";}}s:15:"US Based Office";a:3:{s:11:"description";s:100:"An organization has an office or other facility in the U.S., where CC equals to the county code of t";s:5:"value";s:3:"C32";s:8:"requires";a:1:{i:0;s:2:"14";}}}}s:10:"us_purpose";a:3:{s:2:"ID";s:2:"10";s:11:"description";s:19:"Application Purpose";s:7:"options";a:5:{s:10:"For Profit";a:2:{s:11:"description";s:23:"Business use for profit";s:5:"value";s:2:"P1";}s:10:"Non-profit";a:2:{s:11:"description";s:68:"Non-profit business, club, association, religious organization, etc.";s:5:"value";s:2:"P2";}s:8:"Personal";a:2:{s:11:"description";s:12:"Personal use";s:5:"value";s:2:"P3";}s:11:"Educational";a:2:{s:11:"description";s:20:"Educational purposes";s:5:"value";s:2:"P4";}s:10:"Government";a:2:{s:11:"description";s:19:"Government purposes";s:5:"value";s:2:"P5";}}}}');

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

#
# Dumping data for table `server`
#

INSERT INTO `server` VALUES (1, 'server1', 'server1.yourserver.com', '00.00.00.00', 1, '', '0000-00-00 00:00:00', 0, '', 0);

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

#
# Dumping data for table `serverip`
#


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

#
# Dumping data for table `serverplugin_options`
#


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

#
# Dumping data for table `setting`
#

INSERT INTO `setting` VALUES (1, 'Title', 'Member Center :', 'String that is visible in the browser title. This string with the slogan variable make up the title for all pages.', 1, 0, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (3, 'Company URL', 'http://www.domain.com', 'Your company''s domain name with http:// preceding the domain name<br>(example: http://www.clientexec.com)', 1, 1, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (4, 'Company Name', 'DOMAIN.COM', 'Your company name', 1, 1, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (69, 'ClientExec Version', '2.8.4', 'Version of ClientExec', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (6, 'Template', 'Raleigh', 'Select the template you wish your users to see. For new templates to be visible you must place the new style in the templates folder, which is off of the ClientExec root directory.', 2, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (7, 'PopUpBackColor', '#FFFFCC', 'Background color used for popups throughout the site.<br>A sample TABLE has been colored in with the color you have selected.', 2, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (8, 'PopUpTextColor', '#000000', 'Text color used for popups throughout the site.<br>A sample TABLE has been colored in with the color you have selected.', 2, 1, 0, 0, 0, 3, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (13, 'SMTP Host', '', 'This is the SMTP host information to relay your E-mail through.', 3, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (14, 'SMTP Username', '', 'Username required for relaying E-mail through your SMTP Host.<br>NOTE: Only fill this in if your server requires server authentication. Filling this setting in will set SMTP authentication on.', 3, 0, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (15, 'SMTP Password', '', 'Password required for relaying E-mail through your SMTP Host.<br>NOTE: Only fill this in if your server requires server authentication.', 3, 0, 0, 0, 0, 3, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (20, 'Billing E-mail', 'billing@domain.com', 'This is the E-mail address that is visible to users after receiving an invoice payment request by E-mail.', 4, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (21, 'Invoice Subject', 'Billing Department', 'Subject to be displayed to clients when they receive an invoice payment request by E-mail.', 4, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (22, 'Billing Name', 'Billing', 'Real Name to be used for Invoice Payment Requests.', 4, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (107, 'Default Country Currency2', '', 'Default Currency Used In ClientExec.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (101, 'Send Invoice Offset', '15', 'Select the number of days prior to your invoice''s due date to send your customer their invoice.', 4, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (24, 'ClientExec URL', 'http://yourdomain.com/clientexec', 'The URL to this application. This value is used in many places where the client is sent a link or where any 3rd party billing might return to give control back to this site.<br>NOTE: Make sure you include http:// in front of the domain name<br>(example: http://www.clientexec.com)', 1, 1, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (106, 'Path to cURL', '', 'Please enter the absolute path to cURL on your system.<br>NOTE: Leaving this blank will instruct CE to assume you have PHP compiled with libCurl.', 1, 0, 0, 0, 0, 3, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (23, 'Invoice BCC', '1', 'Select YES if you want the application to send a BCC, Blind Carbon Copy, to your BILLING E-mail each time an invoice is sent.', 4, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (40, 'Advertising or Banner', '', 'This section can be used to display any extra information you want to share with your clients.<bR>Note: The setting ''Show Information Window'' must be set to use for this to be seen by your customers.', 1, 0, 0, 1, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (61, 'Archive Invoices After Payment', '0', 'Automatically archive invoices for customer after payment is made.', 4, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (62, 'Trouble Ticket Start Number', '1000', 'Determine the number you wish to start numbering your trouble tickets.', 8, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (63, 'Trouble Ticket Template', 'ATTN: [CLIENTNAME],\n\nTrouble Ticket #[TICKETNUMBER] has been updated\n\nDescription:\n[DESCRIPTION]\n\nIf you want to view the entire log of this ticket log onto our client management site at [CLIENTAPPLICATIONURL] with your username and password.\n\nIf you have any questions regarding this response or any other support questions please feel free to contact us.\n\nThank you,\n[COMPANYNAME]', 'Template for E-mails that get sent out to clients after their tickets have been commented on or closed.', 7, 1, 0, 1, 0, 9, 6, 0, 0, 0);
INSERT INTO `setting` VALUES (98, 'PopUpBorderColor', '#FFCC00', 'Border color used for popups throughout the site.<br>A sample TABLE has been colored in with the color you have selected.', 2, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (99, 'Default Country Name', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (58, 'Access Via Domain Username', '1', 'Allow user to access ClientExec with any one of their domain''s username and password.', 1, 1, 1, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (45, 'Show Client UserID', '0', 'Allow your clients to view their userid when browsing their profile.', 1, 1, 1, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (35, 'Payment Receipt Template', 'Dear [CLIENTNAME],\r\n\r\nPayment receipt for Invoice #[INVOICENUMBER], sent on [DATE].\r\n\r\nCompany: [COMPANYNAME].  \r\nTotal Charge: [AMOUNT] \r\n\r\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]\r\n\r\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\r\n\r\nNote: This email will serve as an official receipt for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]', 'Template for the E-mail sent to clients after invoice is paid.', 7, 1, 0, 1, 0, 2, 2, 0, 0, 0);
INSERT INTO `setting` VALUES (70, 'Default Gateway', 'paypal', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (71, 'Default Currency', 'USD', 'Select the default currency you would like ClientExec to use for your customers. This will also be the currency used during customer signup', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (34, 'Invoice Template', 'Due Date: [DATE]\r\nInvoice #[INVOICENUMBER]\r\n\r\nATTN: [CLIENTNAME],\r\n\r\nYou currently have a balance of [AMOUNT] due on your account with [COMPANYNAME].  \r\n\r\nInvoice Description:\r\n[INVOICEDESCRIPTION]\r\n\r\nTotal Due: [AMOUNT]\r\n\r\nPayment Instructions:\r\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\r\n2) Click on the "Billing" tab\r\n3) Select the invoice you want to pay\r\n4) Click on pay invoice\r\n\r\nWe greatly appreciate your efforts to ensure that payment\r\nis received in a timely matter.\r\n\r\nIf you have any questions regarding your account or if \r\nyou wish to pay by check, please feel free to contact us.\r\n\r\nNote: This email will serve as an official invoice for this payment.\r\n\r\n[COMPANYNAME]\r\n[BILLINGEMAIL]', 'Template for invoices sent through E-mail.', 7, 1, 0, 1, 0, 1, 2, 0, 0, 0);
INSERT INTO `setting` VALUES (36, 'Support E-mail', 'support@domain.com', 'E-mail address you want all support questions sent to.  This E-mail address is used as an entry to some template based E-mails, such as the welcome E-mail template.', 8, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (73, 'Include Saved Percentage', '1', 'Select YES if you want to show percentage saved in signup script when a customer selects a longer billing cycle.', 10, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (38, 'Integrate Control Panel', '1', 'Select YES if you want to integrate with a specific hosting control panel. NOTE: You must provide the required information for the control panel you select.', 9, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (117, 'Attach PDF When Mailing Invoice', '1', 'Select YES if you want to send the PDF invoice as an attachment when sending invoices.', 4, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (39, 'Cpanel Port', '2082', 'List the port number used in your installation of the Cpanel Control Panel. NOTE: This is usually set to 2082 as the default setting', 9, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (74, 'Check Domain Availability', '1', 'Select YES if you want ClientExec to check on customer''s domain availability during signup.', 10, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (43, 'Recommend Us Template', 'Hi,\r\n\r\nYour Friend, [CLIENTNAME], considered our hosting services at [COMPANYNAME] interesting and wanted to send you our link.  Please feel free to contact us with any questions you might have about what we can do for you.\r\n\r\n[COMPANYNAME]\r\n[COMPANYURL] ', 'Allow your clients to recommend your services to both their associates and friends.', 7, 0, 0, 1, 0, 6, 3, 0, 0, 0);
INSERT INTO `setting` VALUES (65, 'Additional Notes For Invoices', '', 'Additional information to provide for those clients that make payments via checks. This text will be provided as well in the PDF invoices if the field is not left blank.', 4, 0, 0, 1, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (46, 'Forgot Password Template', '[CLIENTNAME],\r\n\r\nA web user from [REQUESTIP] has just requested to change the password on this account.\r\n\r\nBy clicking on the confimation link below you will be sent a new password and are recommended to change it after logging in.\r\n\r\nConfirmation URL: [CONFIRMATION URL]\r\n\r\nThank you,\r\n[COMPANYNAME]', 'Initial E-mail customer receives to confirm a password change to their account.', 7, 0, 0, 1, 0, 7, 4, 0, 0, 0);
INSERT INTO `setting` VALUES (47, 'Mail Type', '0', 'Select the method you want ClientExec to send mail.<br>NOTE: If you have selected SMTP you will need to complete the SMTP settings as well.', 3, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (49, 'Invoice Start Number', '1000', 'Determine the number you wish to start numbering your invoices.', 4, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (51, 'Enable Pay Invoice', '1', 'Determine if you want your clients to view the pay invoice button.', 4, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (52, 'Language', 'English', 'Determine the default language for your site.', 1, 1, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (118, 'Support Ticket Assigned Template', 'ATTN: [COMPANYNAME] Support Staff,\r\n\r\nTrouble Ticket #[TICKETNUMBER], submitted by [CLIENTNAME] has just been assigned to you.  Please take a look at your earliest convenience.\r\n\r\nDescription:\r\n[DESCRIPTION]\r\n\r\nMember Center:\r\n[CLIENTAPPLICATIONURL]\r\n\r\nThank you,\r\n[COMPANYNAME]', 'Template for the E-mail sent to support staff after a ticket is assigned.', 7, 1, 0, 1, 0, 11, 6, 0, 0, 0);
INSERT INTO `setting` VALUES (54, 'Recurring Invoice Setting', '1', 'The following setting will allow you to determine how to handle recurring invoices from within the application.', 4, 1, 0, 0, 0, 0, 5, 0, 0, 0);
INSERT INTO `setting` VALUES (55, 'Show Change Domain Password', '0', 'This setting determines if you want to allow customers to change their domain password.', 1, 1, 1, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (64, 'Display Tickets Ascending', '1', 'Select YES if you want to display trouble tickets in the order they were entered.  NO will display the tickets in Descending order, the latest one on top.', 8, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (56, 'Show All Settings', '1', 'This setting allows you to view all settings for a given type at once.', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (67, 'E-mail For New Trouble Tickets', '', 'E-mail addresses ClientExec will send E-mail notification on all new trouble tickets. You can separate E-mails by a comma.<br>Example: support1@domain.com, support2@domain.com', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (68, 'Date Format', 'm/d/Y', 'Select the date format you want sitewide.', 1, 0, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (76, 'Forward To Gateway', '1', 'Select YES if you want ClientExec to forward all new customers to the gateway selected for payment. CHECK and MONEY ORDER selections will just create the pending account and notify admin.', 10, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (78, 'Signup Completion Template', '<center><b>Thank you for your order</b><br><br>You should receive your invoice information shortly,  followed by your account information. If you do not receive your account information within 24 hours, please contact our sales team at [SUPPORTEMAIL]<br><br>Thank you for choosing [COMPANYNAME]!</center>', 'Text shown upon signup completion for new customers that are not forwarded to a payment gateway.<br><b>NOTE:</b> HTML is accepted.<br>', 10, 0, 0, 1, 0, 0, 7, 0, 0, 0);
INSERT INTO `setting` VALUES (79, 'Show Terms and Conditions', '0', 'Select YES if you want ClientExec to show the terms and conditions and enforce approval before completing the signup process.', 10, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (80, 'Terms and Conditions', '<span style="color:red">Your terms and conditions go here...</span>', 'Terms and Conditions that new customers need to agree to before receiving your services. The setting, Show Terms and Conditions, will need to be set to YES before this content is displayed in the signup process.<br><b>NOTE:</b> HTML is accepted.', 10, 0, 0, 1, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (95, 'Document Root', '', '', 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (96, 'E-mail For New Signups', '', 'E-mail addresses ClientExec will send E-mail notifications to after all new signups. You can separate E-mails by a comma.<br>Example: support1@domain.com, support2@domain.com', 10, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (97, 'Default Country', 'US', 'Default Country for your ClientExec installation', 1, 0, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (103, 'Default Country Currency', '', 'Default Currency Used In ClientExec.', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (104, 'LastDateGenerateInvoices', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (105, 'LastDateRunBatch', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (108, 'Character Set', 'iso-8859-1', 'Please enter the charset you want to use in your application.<br />If you change this make sure the database connection uses the same encoding by adding the following line to config.php (example for UTF-8):<br />$dbencoding = \'utf8\'', 1, 1, 0, 0, 0, 3, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (110, 'Show Open Support Tickets', '1', 'Select YES if you want ClientExec to show all open support tickets in dashboard.', 11, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (111, 'Show Users and Packages Awaiting Activation', '1', 'Select YES if you want ClientExec to show all packages awaiting activation in the dashboard.', 11, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (112, 'Show Outstanding Invoices', '1', 'Select YES if you want ClientExec to show all outstanding invoices in dashboard.', 11, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (113, 'Show Credit Cards Needing Validation', '0', 'Select YES if you want ClientExec to show all customers with credit cards needing validation in dashboard.', 11, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (114, 'Highlight Selected Column', '1', 'Select YES if you want ClientExec to highlight the entire sorted column when clicking on a new header.', 11, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (115, 'Show Uninvoiced Work', '1', 'Select YES if you want ClientExec to show all uninvoiced work in dashboard.', 11, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (116, 'Invoice Receipt Subject', 'Billing Department', 'Subject to be displayed to clients when they receive a receipt for payment.', 4, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (119, 'Enable MaxMind Fraud Control', '0', 'Setting allows MaxMind customers to check orders for fraud.', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (120, 'MaxMind License Key', '', 'Enter your MaxMind License Key here.<br>You can obtain a license at <br><a href=http://www.maxmind.com/app/ccv_buynow?rId=clientexec target=_blank>http://www.maxmind.com/app/ccv_buynow</a>', 12, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (121, 'Reject Free E-mail Service', '0', 'Setting allows you to reject any order using free E-mail services like Hotmail and Yahoo (free E-mail = higher risk).<br><b>NOTE: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (122, 'Reject Country Mismatch', '1', 'Setting allows you to reject any order where country of IP address does not match the billing address country (mismatch = higher risk).<br><b>NOTE: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (123, 'Reject Anonymous Proxy', '1', 'Setting allows you to reject any order where the IP address is an Anonymous Proxy (anonymous proxy = very high risk).<br><b>NOTE: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (124, 'Reject High Risk Country', '0', 'Setting allows you to reject any order where the country the IP is based from is considered a country where fraudulent order is likely.<br><b>NOTE: </b>Requires MaxMind', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (125, 'MaxMind Fraud Risk Score', 'none', 'MaxMind risk score is based on known risk factors and their likelihood to indicate possible fraud. Select the threshold you want ClientExec to reject on. ( 0=low risk 10=high risk)<br><b>NOTE:</b> Requires MaxMind<br>To see how the fraud score is obtained visit <br><a href=http://www.maxmind.com/app/web_services_score2?rId=clientexec target=_blank>http://www.maxmind.com/app/web_services_score2</a>', 12, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (126, 'Alternate Support Address', '', '<i>For E-mail piping only</i><br>In the event that a user submits an E-mail to your support E-mail piping address without an existing account or recognizable E-mail address, ClientExec will forward to this E-mail address. Leaving this setting blank will signal ClientExec to bounce back the E-mail with the text found in the ''Bounce Back Template'' Setting.', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (127, 'Bounce Back Template', 'Your support E-mail cannot be processed at this time because our support center did not recognize your E-mail as one belonging to one of our customers. If you need assistance please E-mail using your E-mail of record or submit a support ticket. Support Team', '<i>For E-mail piping only</i><br>Text used in the bounced E-mail sent by ClientExec when an E-mail is received via the pipe cron that does not belong to one of your customers.', 8, 0, 0, 1, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (128, 'license', '', '', -1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (129, 'Prorate To Day', '0', 'Select the day you want to prorate all new orders to.', 10, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (130, 'Include Following Payment', '-1', '<i>prorate option</i><br>Select if you want to include the next payment when prorating.', 10, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (131, 'Signup Rejection Template', '<center><b>Thank you for your order.  Unfortunately it has been rejected by our merchant.</b><br><br>Please contact our sales team at [SUPPORTEMAIL] for additional information.<br><br>Thank you for choosing [COMPANYNAME]!</center>', 'Text shown to customer upon signup rejection.<br><b>NOTE:</b> HTML accepted<br>', 10, 0, 0, 1, 0, 0, 7, 0, 0, 0);
INSERT INTO `setting` VALUES (132, 'View Customer DropDown', '1', 'Select YES if you want to view all of your customers in a dropdown for faster navigation.<br><b>NOTE:</b> Performance will suffer with more customers', 1, 1, 1, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (133, 'Login Disabled', '0', 'Temporarily disable login from customers without admin privileges', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (134, 'Login disabled system message', 'Login for users is currently disabled due to server maintenance', 'System message for explaining to customers why the login is temporary disabled. If it is empty, default message will be displayed.', 1, 0, 0, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (135, 'E-mail For New High Priority Trouble Tickets', '', 'E-mail addresses to CC notification messages for new high priority tickets', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (136, 'Enable MaxMind Telephone Verification', '0', 'This setting will\r\nenable the Maxmind telephone verification plugin on signup for new\r\ncustomers. (Phone credits are bought separate from regular credit card\r\nfraud detection services)<br><a\r\nhref="http://www.maxmind.com/app/telephone_buynow?rId=clientexec">http://www.maxmind.com/app/telephone_buynow</a>', 12, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (137, 'Minimum Bill Amount to Trigger Telephone Verification', '0', 'If MaxMind Telephone Verification is enabled, only trigger the verification call if the total bill amount exceeds this amount', 12, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (138, 'Number of displayed announcements', '2', 'Number of announcements by category displayed in the dashboard.', 11, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (139, 'Request Access Code', '1', 'Select this option if you want to display an Access code to prevent signup flooding and require the form to be filled in by a human', 10, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (140, 'Disable CE Tickets Support System', '0', 'Select YES if you want to disable the embedded ClientExec support system. <br> Additionally, you can define a URL to redirect your customers to an external support system of your own.', 8, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (141, '3rd Party Support URL', '', 'URL of an external support system, different to Clientexec''s.', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (142, 'Accept Coupons', '1', 'Select YES to enable the coupons functionality.', '10', '1', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `setting` VALUES (143, 'Use Effects', '0', 'Selecting YES will enable effects in ClientExec for both administrators and end users', 2, 1, 1, 0, 0, 5, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (144, 'Show MaxMind Logo', '1', 'Setting this to YES will show the MaxMind fraud screening logo in the signup footer if credit card fraud detection or phone verification is turned on.', '12', '1', '1', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `setting` VALUES (145, 'New Trouble Ticket Autoresponder Template', '[CLIENTNAME],\r\n\r\nThank you for submitting a ticket with [COMPANYNAME].  Your request has been assigned the ticket number [TICKETNUMBER].  A technician will respond to your request shortly.\r\n\r\nMember Center:\r\n[CLIENTAPPLICATIONURL]\r\n\r\nThank you,\r\n[COMPANYNAME]', 'Template for E-mails that get sent out to clients after a new ticket is added by E-mail through the support pipe.', 7, 1, 0, 1, 0, 10, 6, 0, 0, 0);
INSERT INTO `setting` VALUES (146, 'Application Error Notification', '', 'Enter an E-mail address if you want to be notified when a catchable error occurs in your ClientExec installation.', 1, 0, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (147, 'Custom Logout URL', '', 'Enter the URL you want clients to be redirected to after logging out.<br><b>NOTE:</b> Leave this field blank to use the login page.', 1, 0, 0, 0, 0, 2, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (148, 'Allow Customer File Uploads', '0', 'Set this to YES if you wish to allow customers to upload files to support tickets.', 8, 1, 1, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (149, 'Allowed File Extensions', 'jpg,jpeg,gif,zip,txt,log', 'Enter the file extensions that you allow uploaded to support tickets separated by commas.  * means allow all file extensions(security risk).', 8, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (150, 'Overdue Invoice Template', 'Due Date: [DATE]\nInvoice # [INVOICENUMBER]\n\nATTN: [CLIENTNAME],\n\nYou currently have an overdue invoice of [AMOUNT] due on your account with [COMPANYNAME].\n\nInvoice Description:\n[INVOICEDESCRIPTION]\nTotal Due: [AMOUNT]\n\nPayment Instructions:\n1) Log into our client management site at [CLIENTAPPLICATIONURL] with your username and password\n2) Click on the "Billing" tab\n3) Select the invoice you want to pay\n4) Click on pay invoice\n\nWe greatly appreciate your efforts to ensure that payment is received in a timely matter.\n\nIf you have any questions regarding your account or if you wish to pay by check, please feel free to contact us.\n\nNote: This E-mail will serve as an official invoice for this payment.\n\n[COMPANYNAME]\n[BILLINGEMAIL]', 'E-mail template used when notifying customer of outstanding invoices using the Invoice Reminder service.', 7, 1, 0, 1, 0, 3, 2, 0, 0, 0);
INSERT INTO `setting` VALUES (151, 'Minimum Fraud Score to Trigger Telephone Verification',0,'If MaxMind Telephone Verification and Fraud Control are enabled, only trigger the verification call if the fraud score exceeds this number.', 12, 1, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (152 , 'Batch Invoice Notification Template', 'ATTN: [CLIENTNAME],\n\nYou have an upcoming invoice for [AMOUNT] on [DATE] that will be charged to your credit card on file with [COMPANYNAME].  If you do not approve of this charge and would like to cancel your subscription please contact us immediately.\n\nYou may review your invoice history at any time by logging in at: [CLIENTAPPLICATIONURL]\n\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\n\n\n[COMPANYNAME]\n[BILLINGEMAIL]', 'Template for the E-mail sent to clients by the upcoming batch invoice notifier service.', 7, 1, 0, 1, 0, 4, 2, 0, 0, 0);
INSERT INTO `setting` VALUES (153, 'SMTP Port', '', 'This is the SMTP port that will be used when sending E-mail.  Leaving this blank will use port 25 by default.', 3, 0, 0, 0, 0, 4, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (154, 'Days To Allow Tickets To Be Reopened', '', 'Number of days that a customer is able to reopen a closed ticket. Leave blank to always allow a ticket to be reopened.', '8', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `setting` VALUES (155, 'Expiring CC Template', 'ATTN: [CLIENTNAME],\n\nYour credit card ending with [CCLASTFOUR] will soon be expiring on [CCEXPDATE].  Please login to update your credit card information as soon as possible at: [CLIENTAPPLICATIONURL]\n\nIf you have any questions regarding your account, please feel free to contact us at [BILLINGEMAIL].\n\n\n[COMPANYNAME]\n[BILLINGEMAIL]', 'Template for the E-mail sent to clients by the expiring credit card notifier service.', 7, 1, 0, 1, 0, 5, 10, 0, 0, 0);
INSERT INTO `setting` VALUES (156, 'Allow run services from URL', '0', 'Select Yes if you want to allow executing services from a URL.<br><b>NOTE:</b> Set it to <b>YES</b> if your server is running under Windows, or if you have no access to CRONTAB', 1, 1, 1, 0, 0, 3, 0, 0, 0, 0);
INSERT INTO `setting` VALUES (157, 'Get New Password Template', '[CLIENTNAME],\r\n\r\nYour password has been reset successfully.\r\n\r\nNew password: [NEWPASSWORD]\r\n\r\nPlease goto [CLIENTEXEC URL] to login.\r\n\r\nThank you,\r\n[COMPANYNAME]\r\n[COMPANYEMAIL]', 'Initial E-mail the customer receives to know the new password to their account.', 7, 0, 0, 1, 0, 8, 12, 0, 0, 0);
INSERT INTO `setting` VALUES (158, 'Email Piping In Use', 0, 'If E-mail piping is in use set this to true so the reply above this line can be added to support ticket E-mails.', 8, 0, 1, 0, 0, 0, 0, 0, 0, 1);
INSERT INTO `setting` VALUES (159, 'Show Execution Time', '0', 'Select YES to show the script\'s execution time in the footer.', 1, 1, 1, 0, 0, 3, 0, 0, 0, 0);

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

#
# Dumping data for table `setting_options`
#


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

#
# Dumping data for table `taxrule`
#


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

#
# Dumping data for table `tld`
#

INSERT INTO `tld` VALUES (1, 'net', 1, '9.95', '0', 0, 0);
INSERT INTO `tld` VALUES (2, 'com', 1, '9.95', '0', 0, 0);
INSERT INTO `tld` VALUES (3, 'org', 1, '9.95', '0', 0, 0);

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

#
# Dumping data for table `troubleticket`
#

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

# 
# Dumping data for table `troubleticket_files`
# 


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

#
# Dumping data for table `troubleticket_log`
#


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

#
# Dumping data for table `troubleticket_type`
#

INSERT INTO `troubleticket_type` VALUES ('Software', 0);
INSERT INTO `troubleticket_type` VALUES ('Billing Issues', 1);
INSERT INTO `troubleticket_type` VALUES ('Control Panel', 2);
INSERT INTO `troubleticket_type` VALUES ('E-mail Problems', 3);
INSERT INTO `troubleticket_type` VALUES ('Upgrades', 4);
INSERT INTO `troubleticket_type` VALUES ('Other', 5);

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

#
# 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 `users`
#

INSERT INTO `users` VALUES (100, 0, 'Admin user', '2checkout', 0, 2, '43e9a4ab75570f5b', '0000-00-00', 'admin@domain.com\r\nReinventing Support!', '2003-02-14 22:29:45', 0, 1, 1, 'USD', '', 0, '0', '0', '', '', '', 0, 0, 0, 1, 'Admin', 'User', 'admin@domain.com', '', '', '', 0, 0);
