

INSERT INTO jobberland_payment_modules (id, name, module_key, class_file, formfile, enabled) VALUES 
(1, 'PayPal', 'paypal', 'paypal.php', 'frmpaypal.tpl', 'N'),
(2, 'Authorize.Net', 'authorizenet', 'authorizenet.php', 'frmauthorizenet.tpl', 'N'),
(3, '2Checkout', 'pm2checkout', 'pm2checkout.php', 'frmpm2checkout.tpl', 'N'),
(4, 'Credit Card', 'cc', 'cc.php', 'frmcc.tpl', 'N'),
(5, 'iPayment', 'ipayment', 'ipayment.php', 'frmipayment.tpl', 'N'),
(6, 'NOCHEX', 'nochex', 'nochex.php', 'frmnochex.tpl', 'N'),
(7, 'SECPay', 'secpay', 'secpay.php', 'frmsecpay.tpl', 'N'),
(8, 'PSiGate', 'psigate', 'psigate.php', 'frmpsigate.tpl', 'N'),
(9, 'E-Gold', 'egold', 'egold.php', 'frmegold.tpl', 'N'),
(10, 'ccBill', 'ccbill', 'ccbill.php', 'frmccbill.tpl', 'N');

REPLACE INTO jobberland_setting_category (id, category_name, var_name, category_desc ) VALUES 
(1, 'Main Settings',  'main_setting', 'The main settings. This includes settings such as site name, meta-tags etc.'),
(2, 'SEO Setting', 'seo_setting', 'Search Engine Optimization '),
(3, 'Mailer Settings ', 'mail_setting', 'Setting for PHP Mailler. Server name ect...'),
(4, 'Spam Settings', 'spam_setting', 'Set your spam setting. Built-in support for ReCaptcha. Before you can enable this, you''ll need to register a free key at recaptcha.net.'),
(5, 'Search / Pagination Settings ', 'search', 'Settings that change the amount of jobs to display per page. Spotlight Jobs, Latest Jobs, Search Job per page, ect...'),
(6, 'Payment Setting', 'payment', 'Setting for Paypal, ect..'),
(7, 'User/Employee ', 'user_setting', 'Setting for User/Employee, number cv upload/letters ect..'),
(8, 'Employer', 'employer_setting', 'Setting for Employer/Clint'),
(9, 'Currency', 'currency_setting', 'Setting your currency');



INSERT INTO `jobberland_career_degree` (`id`, `var_name`, `career_name`, `is_active`) VALUES
(1, 'none-of-these', 'None of these', 'Y'),
(2, 'student-higher-education-graduate', 'Student (Higher education/Graduate)', 'Y'),
(3, 'entry-level', 'Entry Level', 'Y'),
(4, 'experienced-non-manager', 'Experienced (Non-Manager)', 'Y'),
(5, 'manager-manager-supervisor-of-staff', 'Manager (Manager/Supervisor of Staff)', 'Y'),
(6, 'executive-director-department-head', 'Executive (Director, Department Head)', 'Y'),
(7, 'senior-executive-chairman-md-ceo', 'Senior Executive (Chairman, MD, CEO)', 'Y');

INSERT INTO `jobberland_category` (`id`, `var_name`, `cat_name`) VALUES
(1, 'accounting-and-auditing-services', 'Accounting and Auditing Services'),
(2, 'advertising-and-pr-services', 'Advertising and PR Services'),
(3, 'aerospace-and-defence', 'Aerospace and Defence'),
(4, 'agriculture-forestry-fishing', 'Agriculture/Forestry/Fishing'),
(5, 'architectural-and-design-services', 'Architectural and Design Services'),
(6, 'automotive-and-parts-mfg', 'Automotive and Parts Mfg'),
(7, 'automotive-sales-and-repair-services', 'Automotive Sales and Repair Services'),
(8, 'banking-and-consumer-lending', 'Banking and Consumer Lending'),
(9, 'biotechnology-pharmaceuticals', 'Biotechnology/Pharmaceuticals'),
(10, 'broadcasting-music-and-film', 'Broadcasting, Music, and Film'),
(11, 'business-services-other', 'Business Services - Other'),
(12, 'chemicals-petro-chemicals', 'Chemicals/Petro-Chemicals'),
(13, 'clothing-and-textile-manufacturing', 'Clothing and Textile Manufacturing'),
(14, 'computer-hardware', 'Computer Hardware'),
(15, 'computer-software', 'Computer Software'),
(16, 'computer-it-services', 'Computer/IT Services'),
(17, 'construction-industrial-facilities-and-infrastructure', 'Construction - Industrial Facilities and Infrastructure'),
(18, 'construction-residential-commercial-office', 'Construction - Residential & Commercial/Office'),
(19, 'education', 'Education'),
(20, 'electronics-components-and-semiconductor-mfg', 'Electronics, Components, and Semiconductor Mfg'),
(21, 'energy-and-utilities', 'Energy and Utilities'),
(22, 'engineering-services', 'Engineering Services'),
(23, 'entertainment-venues-and-theatres', 'Entertainment Venues and Theatres'),
(24, 'financial-services', 'Financial Services'),
(25, 'food-and-beverage-production', 'Food and Beverage Production'),
(26, 'government-and-public-sector', 'Government and Public Sector'),
(27, 'healthcare-services', 'Healthcare Services'),
(28, 'hotels-and-lodging', 'Hotels and Lodging'),
(29, 'insurance', 'Insurance '),
(30, 'internet-services', 'Internet Services'),
(31, 'legal-services', 'Legal Services'),
(32, 'management-consulting-services', 'Management Consulting Services'),
(33, 'manufacturing-other', 'Manufacturing - Other'),
(34, 'marine-mfg-services', 'Marine Mfg & Services'),
(35, 'medical-devices-and-supplies', 'Medical Devices and Supplies'),
(36, 'metals-and-minerals', 'Metals and Minerals'),
(37, 'non-profit-charitable-organisations', 'Non profit Charitable Organisations'),
(38, 'other-not-classified', 'Other/Not Classified'),
(39, 'performing-and-fine-arts', 'Performing and Fine Arts'),
(40, 'personal-and-household-services', 'Personal and Household Services'),
(41, 'personal-care-products-and-cosmetics', 'Personal Care Products and Cosmetics'),
(42, 'printing-and-publishing', 'Printing and Publishing '),
(43, 'real-estate-and-property-management', 'Real Estate and Property Management'),
(44, 'rental-services', 'Rental Services'),
(45, 'restaurant-food-services', 'Restaurant/Food Services'),
(46, 'retail', 'Retail'),
(47, 'security-and-surveillance', 'Security and Surveillance'),
(48, 'sports-and-physical-recreation', 'Sports and Physical Recreation'),
(49, 'staffing-employment-agencies', 'Staffing/Employment Agencies'),
(50, 'telecommunications-services', 'Telecommunications Services'),
(51, 'transport-and-storage-materials', 'Transport and Storage - Materials '),
(52, 'travel-transportation-and-tourism', 'Travel, Transportation and Tourism '),
(53, 'waste-management', 'Waste Management'),
(54, 'wholesale-trade-import-export', 'Wholesale Trade/Import-Export');

INSERT INTO `jobberland_education` (`id`, `var_name`, `education_name`, `is_active`) VALUES
(1, 'some-secondary-school-coursework', 'Some Secondary School Coursework', 'Y'),
(2, 'secondary-school-or-equivalent', 'Secondary School or equivalent', 'Y'),
(3, 'a-level-higher-or-equivalent', 'A Level/Higher or Equivalent', 'Y'),
(4, 'vocational', 'Vocational', 'Y'),
(5, 'some-college-coursework-completed', 'Some College Coursework Completed', 'Y'),
(6, 'hnd-hnc-or-equivalent', 'HND/HNC or equivalent', 'Y'),
(7, 'doctorate', 'Doctorate', 'Y'),
(8, 'professional', 'Professional', 'Y');

INSERT INTO `jobberland_experience` (`id`, `var_name`, `experience_name`, `is_active`) VALUES
(1, 'less-than-1-year', 'Less than 1 Year', 'Y'),
(2, '1-to-2-years', '1+ to 2 Years', 'Y'),
(3, '2-to-5-years', '2+ to 5 Years', 'Y'),
(4, '5-to-7-years', '5+ to 7 Years', 'Y'),
(5, '7-to-10-years', '7+ to 10 Years', 'Y'),
(6, '10-to-15-years', '10 to 15 Years', 'Y'),
(7, 'more-than-15-years', 'More than 15 Years', 'Y');


INSERT INTO `jobberland_job_status` (`id`, `var_name`, `status_name`, `is_active`) VALUES
(1, 'permanent', 'Permanent', 'Y'),
(2, 'part-time', 'Part-Time', 'Y'),
(3, 'contract', 'Contract', 'Y'),
(4, 'temporary', 'Temporary', 'Y');

INSERT INTO `jobberland_job_type` (`id`, `var_name`, `type_name`, `is_active`) VALUES
(1, 'full-time', 'Full-time', 'Y'),
(2, 'part-time', 'Part-time', 'Y'),
(3, 'per-day', 'Per Day', 'Y'),
(4, 'permanent', 'Permanent', 'Y'),
(5, 'temporary-contract-project', 'Temporary/Contract/Project', 'Y'),
(6, 'placement-student', 'Placement Student', 'Y'),
(7, 'seasonal', 'Seasonal', 'Y');














