#-- =============================================
-- /sql/jll_build.sql
-- =============================================

-- =============================================
--
-- File storing for any SQL statements that need
-- applying to the SIMS database for the
-- upcoming patch.
--
-- Category SQL
-- Package HAP
-- Subpackage Database
-- Author: Lee Zerafa <lee.zerafa@s2partnership.co.uk>
-- Copyright 2008-2022 S2 Partnership Ltd.
-- Version Release: 3.0
-- Link http://api.s2partnership.co.uk/sims/api/index.html
-- =============================================

-- =============================================
-- DROP Statements
-- =============================================

-- =============================================
-- CREATE Statements
-- =============================================

-- ============================================
-- ALTER Statements
-- =============================================

-- =============================================
-- DELETE Statements
-- =============================================

-- ============================================
-- INSERT Statements
-- =============================================

#Version 1.6
INSERT INTO `translations` (`expr_key`, `expr_value`, `language`, `created`, `date_deleted`, `deleted`)
VALUES

-- Leaving this statement to use as a template for any new translations.
-- ('MOBILE.PAGES.SMART_SYNC.WELCOME_MESSAGE', 'Welcome to the JLL app, please make a selection of relevant properties you’d like to log / review inspections and actions against. This can be done using the following filters. Once you’ve made your selection, please sync this information to the app to get started!', 'en', NOW(), '0000-00-00 00:00:00', '0');

-- =============================================
-- UPDATE Statements

-- =============================================
-- REPLACE Statements
-- =============================================

-- =============================================
-- OTHER
-- =============================================