CREATE TABLE tblcp_updates(
    id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
    codename VARCHAR(191) NOT NULL,
    title VARCHAR(500) NOT NULL,
    description TEXT NOT NULL,
    image VARCHAR(191) NOT NULL,
    is_released TINYINT(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO tblcp_updates (codename, title, description, image, is_released) VALUES
('quickbooks_sync', 'QuickBooks Sync', "You'll be able to automatically sync your accounting data to QuickBooks Online. This will eliminate the need for double data entry and save you a lot of time and money with basic but time consuming accounting processes.", 'quickbooks.jpg', 1),
('tool_library', 'Tool Library With Bluetooth Tool Tags', "We are developing BLE (Low Energy Bluetooth) Tool Tags that can be affixed to any tool or tool box, so your team will be able to track where tools are at, and who has them. The Tool Tags will have a 5 year battery life and can be attached via 3M double-sided tape, or a rivet! This feature will stop loss and improve accountability.", 'tool_library.png', 1),
('team_chat', 'Team Chat', "We are integrating an in-app chat feature so your team members can communicate with each other while on different job sites.", 'team_chat.png', 1),
('job_schedule', 'Job Schedule', "We are building a comprehensive job schedule where you can manage multiple job sites in parallel, and see a birds-eye view of every job site that's currently active or scheduled/upcoming. You will be able to assign specific employees to a job site and have reference any and all data related to that job in one central location.", 'job_schedule.png', 1),
('employee_dispatching', 'Employee Dispatching', "We are adding dispatching so you can actively track where your employees are currently at and dispatch them to job sites in real-time.", 'employee_dispatching.png', 0),
('lead_generation', 'Lead Generation', "We are adding various Lead Generation packages and featured directory listings to help generate more leads for your business and get you more sales/clients.", 'lead_generation.png', 1),
('additional_payment_options', 'Additional Payment Options', "We are adding additional payment facilitators including YourPay, WePay, Coinbase, CoinPayments.", 'payment_options.jpg', 1),
('mileage_logs', 'Mileage Log', "We are developing a mileage log that will enable you and your team to accurately and automatically log their miles. You'll be able to see how fast your employees are driving, the routes they're taking and more!", 'mileage_logs.png', 0),
('predictive_ai', 'Predictive AI for Tasks & Supplies', "We are working on predictive AI to further speed up the estimating process. Based on the area, we will recommend the most common tasks eliminating the need to type the entire task. Then, under each task, we will recommend the most commonly used supplies. This will save you time and make you more efficient.", 'predictive_ai.jpg', 0),
('staffing_agency', 'Staffing Agency / Job Board', "We are building a staffing agency to connect contractors with a freelance workforce. This means no early morning trips to the Home Depot parking. All participants will be screened and vetted by Contractor+. When you land a big job out of nowhere and need some extra hands to get the work done quickly, we'll connect you with the workers you need at an economical rate.", 'temp_staff.png', 0);