INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Advertising');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Sales Commissions');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Bad Debts');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Dues & Subscriptions');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Employee Mileage');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Entertainment Meals');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Licenses, Commissions & Fees');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Research Materials');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Supplies & Materials');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Bank Charges');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Insurance');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Interest Paid');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Miscellaneous Expense');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Office/General Administrative Expenses');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Repairs & Maintenance');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Shipping, Freight & Delivery');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Utilities');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Employee Benefit Programs');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Wages');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Contractors');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Legal & Professional Services');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Rent or Lease of Buildings');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Taxes Paid');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Hardware & Software');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Machinery & Equipment');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Vehicles');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Web & Data Services');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Travel');
INSERT INTO `tblexpenses_categories_static`(`name`) VALUES ('Travel, Meals & Entertainment');

INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Advertisement');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Cold Call');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Employee Referral');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('External Referral');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Online Store');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Partner');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Public Relations');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Sales Email Alias');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Seminar Partner');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Internal Seminar');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Trade Show');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Web Download');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Web Research');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Chat');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Twitter');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Facebook');
INSERT INTO `tblleads_sources_static`(`name`) VALUES ('Google+');

ALTER TABLE `tblestimates` ADD `property_street_2` VARCHAR(200) NULL DEFAULT NULL AFTER `property_street`;
ALTER TABLE `tblinvoices` ADD `property_street_2` VARCHAR(200) NULL DEFAULT NULL AFTER `property_street`;
ALTER TABLE `tblpost_inspections` ADD `property_street_2` VARCHAR(200) NULL DEFAULT NULL AFTER `property_street`;

INSERT INTO `tblpayment_modes_static` (`id`, `name`, `description`, `show_on_pdf`, `invoices_only`, `expenses_only`, `selected_by_default`, `active`) VALUES
(NULL, 'Cash', NULL, '1', '1', '1', '1', '1'),
(NULL, 'Check', NULL, '1', '1', '1', '0', '1'),
(NULL, 'Money Order', NULL, '1', '1', '1', '0', '1'),
(NULL, 'Credit Card', NULL, '1', '1', '1', '0', '1'),
(NULL, 'PayPal', NULL, '1', '1', '1', '0', '1'),
(NULL, 'CashApp', NULL, '1', '1', '1', '0', '1'),
(NULL, 'Bank Transfer', NULL, '1', '1', '1', '0', '1'),
(NULL, 'Bitcoin', NULL, '1', '1', '1', '0', '1'),
(NULL, 'Other', NULL, '1', '1', '1', '0', '1');