SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

ALTER TABLE `sample`.`tblClientAppDevice_base` CHANGE COLUMN `appversion` `appversion` VARCHAR(25) NULL DEFAULT NULL  , CHANGE COLUMN `modified` `modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP  ;

ALTER TABLE `sample`.`tblClientAppDeviceHistory_base` CHANGE COLUMN `appversion` `appversion` VARCHAR(25) NULL DEFAULT NULL  ;

ALTER TABLE `sample`.`tblClientAppDeviceMessage_base` CHANGE COLUMN `modified` `modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP  ;


-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClient`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClient` (`ClientID` INT, `GroupEnabled` INT, `Logo` INT, `BGColor` INT, `Stylesheet` INT, `Name` INT, `mysqlusername` INT, `mysqlpassword` INT, `Username` INT, `Password` INT, `Address` INT, `Phone` INT, `Fax` INT, `Cell` INT, `Contact` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclient`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclient` (`ClientID` INT, `GroupEnabled` INT, `Logo` INT, `BGColor` INT, `Stylesheet` INT, `Name` INT, `mysqlusername` INT, `mysqlpassword` INT, `Username` INT, `Password` INT, `Address` INT, `Phone` INT, `Fax` INT, `Cell` INT, `Contact` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAdmin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAdmin` (`ClientAdminID` INT, `ClientID` INT, `RoleID` INT, `FirstName` INT, `LastName` INT, `Email` INT, `Phone` INT, `Cell` INT, `Username` INT, `Password` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientadmin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientadmin` (`ClientAdminID` INT, `ClientID` INT, `RoleID` INT, `FirstName` INT, `LastName` INT, `Email` INT, `Phone` INT, `Cell` INT, `Username` INT, `Password` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientApp`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientApp` (`ClientAppID` INT, `ClientID` INT, `Username` INT, `Password` INT, `wsuname` INT, `wspwd` INT, `wssecret` INT, `Name` INT, `AppPlatformID` INT, `AppEditorCSS` INT, `EditorCSS` INT, `StyleSet` INT, `appversion` INT, `appid` INT, `ituneslink` INT, `apptimezone` INT, `facebookapi` INT, `facebooksecret` INT, `twitterconsumersecret` INT, `twitterconsumerkey` INT, `flurryapikey` INT, `screenshot` INT, `description` INT, `pushdevcert` INT, `pushprocert` INT, `Status` INT, `LaunchDate` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientapp`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientapp` (`ClientAppID` INT, `ClientID` INT, `Username` INT, `Password` INT, `wsuname` INT, `wspwd` INT, `wssecret` INT, `Name` INT, `AppPlatformID` INT, `AppEditorCSS` INT, `EditorCSS` INT, `StyleSet` INT, `appversion` INT, `appid` INT, `ituneslink` INT, `apptimezone` INT, `facebookapi` INT, `facebooksecret` INT, `twitterconsumersecret` INT, `twitterconsumerkey` INT, `flurryapikey` INT, `screenshot` INT, `description` INT, `pushdevcert` INT, `pushprocert` INT, `Status` INT, `LaunchDate` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppAd`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppAd` (`ClientAppAdID` INT, `ClientID` INT, `ClientAppID` INT, `Name` INT, `Graphic` INT, `Link` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappad`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappad` (`ClientAppAdID` INT, `ClientID` INT, `ClientAppID` INT, `Name` INT, `Graphic` INT, `Link` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppAdministration`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppAdministration` (`ClientAppAdministrationID` INT, `ClientID` INT, `ClientAppID` INT, `AdministrationID` INT, `Name` INT, `CustomListIcon` INT, `OrderID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappadministration`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappadministration` (`ClientAppAdministrationID` INT, `ClientID` INT, `ClientAppID` INT, `AdministrationID` INT, `Name` INT, `CustomListIcon` INT, `OrderID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppDeviceHistory`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppDeviceHistory` (`ClientAppDeviceHistoryID` INT, `ClientID` INT, `ClientAppID` INT, `appname` INT, `appversion` INT, `deviceuid` INT, `devicetoken` INT, `devicename` INT, `devicemodel` INT, `deviceversion` INT, `pushbadge` INT, `pushalert` INT, `pushsound` INT, `development` INT, `status` INT, `archived` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappdevicehistory`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappdevicehistory` (`ClientAppDeviceHistoryID` INT, `ClientID` INT, `ClientAppID` INT, `appname` INT, `appversion` INT, `deviceuid` INT, `devicetoken` INT, `devicename` INT, `devicemodel` INT, `deviceversion` INT, `pushbadge` INT, `pushalert` INT, `pushsound` INT, `development` INT, `status` INT, `archived` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppDeviceMessage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppDeviceMessage` (`ClientAppDeviceMessageID` INT, `ClientID` INT, `ClientAppID` INT, `fk_device` INT, `fk_push` INT, `message` INT, `delivery` INT, `status` INT, `created` INT, `modified` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappdevicemessage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappdevicemessage` (`ClientAppDeviceMessageID` INT, `ClientID` INT, `ClientAppID` INT, `fk_device` INT, `fk_push` INT, `message` INT, `delivery` INT, `status` INT, `created` INT, `modified` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppDevicePush`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppDevicePush` (`ClientAppDevicePushID` INT, `ClientID` INT, `ClientAppID` INT, `alert` INT, `badge` INT, `sound` INT, `delivery` INT, `userdelivery` INT, `usertimezone` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappdevicepush`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappdevicepush` (`ClientAppDevicePushID` INT, `ClientID` INT, `ClientAppID` INT, `alert` INT, `badge` INT, `sound` INT, `delivery` INT, `userdelivery` INT, `usertimezone` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppEventsContent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppEventsContent` (`ClientAppEventsContentID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `InstructionText` INT, `ListTitle` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappeventscontent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappeventscontent` (`ClientAppEventsContentID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `InstructionText` INT, `ListTitle` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppEventsItem`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppEventsItem` (`ClientAppEventsItemID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `ClientAppEventsContentID` INT, `EventStartDate` INT, `EventEndDate` INT, `Title` INT, `ContactName` INT, `ContactEmail` INT, `EmailSubject` INT, `EmailBody` INT, `Information` INT, `Address` INT, `TimeZone` INT, `Lat` INT, `Lng` INT, `ClientAppGroupLocationID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappeventsitem`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappeventsitem` (`ClientAppEventsItemID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `ClientAppEventsContentID` INT, `EventStartDate` INT, `EventEndDate` INT, `Title` INT, `ContactName` INT, `ContactEmail` INT, `EmailSubject` INT, `EmailBody` INT, `Information` INT, `Address` INT, `TimeZone` INT, `Lat` INT, `Lng` INT, `ClientAppGroupLocationID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppLinksContent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppLinksContent` (`ClientAppLinksContentID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `ListTitle` INT, `InstructionText` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientapplinkscontent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientapplinkscontent` (`ClientAppLinksContentID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `ListTitle` INT, `InstructionText` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppLinksItem`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppLinksItem` (`ClientAppLinksItemID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `ClientAppLinksContentID` INT, `LinkText` INT, `Link` INT, `OrderID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientapplinksitem`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientapplinksitem` (`ClientAppLinksItemID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `ClientAppLinksContentID` INT, `LinkText` INT, `Link` INT, `OrderID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblClientAppQuestion`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblClientAppQuestion` (`ClientAppQuestionID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `QuestionTypeID` INT, `Required` INT, `Name` INT, `QuestionText` INT, `IncorrectFeedback` INT, `CorrectFeedback` INT, `Hint` INT, `AnswerKey` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblclientappquestion`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblclientappquestion` (`ClientAppQuestionID` INT, `ClientID` INT, `ClientAppID` INT, `ClientAppSectionID` INT, `QuestionTypeID` INT, `Required` INT, `Name` INT, `QuestionText` INT, `IncorrectFeedback` INT, `CorrectFeedback` INT, `Hint` INT, `AnswerKey` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblQRCodeEmail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblQRCodeEmail` (`QRCodeEmailID` INT, `ClientID` INT, `ClientQRCodeID` INT, `Email` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblqrcodeemail`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblqrcodeemail` (`QRCodeEmailID` INT, `ClientID` INT, `ClientQRCodeID` INT, `Email` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblQRCodePhone`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblQRCodePhone` (`QRCodePhoneID` INT, `ClientID` INT, `ClientQRCodeID` INT, `Phone` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblqrcodephone`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblqrcodephone` (`QRCodePhoneID` INT, `ClientID` INT, `ClientQRCodeID` INT, `Phone` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblQRCodeSMS`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblQRCodeSMS` (`QRCodeSMSID` INT, `ClientID` INT, `ClientQRCodeID` INT, `Phone` INT, `Message` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblqrcodesms`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblqrcodesms` (`QRCodeSMSID` INT, `ClientID` INT, `ClientQRCodeID` INT, `Phone` INT, `Message` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblQRCodeWIFI`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblQRCodeWIFI` (`QRCodeWIFIID` INT, `ClientID` INT, `ClientQRCodeID` INT, `SSID` INT, `Password` INT, `WIFITypeID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);

-- -----------------------------------------------------
-- Placeholder table for view `sample`.`tblqrcodewifi`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sample`.`tblqrcodewifi` (`QRCodeWIFIID` INT, `ClientID` INT, `ClientQRCodeID` INT, `SSID` INT, `Password` INT, `WIFITypeID` INT, `DateCreated` INT, `DateModified` INT, `Active` INT);


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClient`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClient`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClient` AS
SELECT ClientID, GroupEnabled, Logo, BGColor, Stylesheet, Name, mysqlusername, mysqlpassword, Username, Password, Address, Phone, Fax, Cell, Contact, DateCreated, DateModified, Active
FROM tblClient_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclient`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclient`;
DROP VIEW IF EXISTS `sample`.`tblclient` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAdmin`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAdmin`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAdmin` AS
SELECT ClientAdminID, ClientID, RoleID, FirstName, LastName, Email, Phone, Cell, Username, Password, DateCreated, DateModified, Active
FROM tblClientAdmin_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';
;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientadmin`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientadmin`;
DROP VIEW IF EXISTS `sample`.`tblclientadmin` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientApp`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientApp`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientApp` AS
SELECT ClientAppID, ClientID, Username, Password, wsuname, wspwd, wssecret, Name, AppPlatformID, AppEditorCSS, EditorCSS, StyleSet, appversion, appid, ituneslink, apptimezone, facebookapi, facebooksecret, twitterconsumersecret, twitterconsumerkey, flurryapikey, screenshot, description, pushdevcert, pushprocert, Status, LaunchDate, DateCreated, DateModified, Active
FROM tblClientApp_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';
;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientapp`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientapp`;
DROP VIEW IF EXISTS `sample`.`tblclientapp` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppAd`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppAd`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppAd` AS
SELECT ClientAppAdID, ClientID, ClientAppID, Name, Graphic, Link, DateCreated, DateModified, Active
FROM tblClientAppAd_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappad`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappad`;
DROP VIEW IF EXISTS `sample`.`tblclientappad` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppAdministration`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppAdministration`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppAdministration` AS
SELECT ClientAppAdministrationID, ClientID, ClientAppID, AdministrationID, Name, CustomListIcon, OrderID, DateCreated, DateModified, Active
FROM tblClientAppAdministration_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappadministration`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappadministration`;
DROP VIEW IF EXISTS `sample`.`tblclientappadministration` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppDeviceHistory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppDeviceHistory`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppDeviceHistory` AS
SELECT ClientAppDeviceHistoryID, ClientID, ClientAppID, appname, appversion, deviceuid, devicetoken, devicename, devicemodel, deviceversion, pushbadge, pushalert, pushsound, development, status, archived, DateCreated, DateModified, Active
FROM tblClientAppDeviceHistory_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappdevicehistory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappdevicehistory`;
DROP VIEW IF EXISTS `sample`.`tblclientappdevicehistory` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppDeviceMessage`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppDeviceMessage`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppDeviceMessage` AS
SELECT ClientAppDeviceMessageID, ClientID, ClientAppID, fk_device, fk_push, message, delivery, status, created, modified, DateCreated, DateModified, Active
FROM tblClientAppDeviceMessage_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappdevicemessage`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappdevicemessage`;
DROP VIEW IF EXISTS `sample`.`tblclientappdevicemessage` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppDevicePush`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppDevicePush`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppDevicePush` AS
SELECT ClientAppDevicePushID, ClientID, ClientAppID, alert,  badge, sound, delivery, userdelivery, usertimezone, DateCreated, DateModified, Active
FROM tblClientAppDevicePush_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappdevicepush`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappdevicepush`;
DROP VIEW IF EXISTS `sample`.`tblclientappdevicepush` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppEventsContent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppEventsContent`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppEventsContent` AS
SELECT ClientAppEventsContentID, ClientID, ClientAppID, ClientAppSectionID, InstructionText, ListTitle, DateCreated, DateModified, Active
FROM tblClientAppEventsContent_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappeventscontent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappeventscontent`;
DROP VIEW IF EXISTS `sample`.`tblclientappeventscontent` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppEventsItem`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppEventsItem`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppEventsItem` AS
SELECT ClientAppEventsItemID, ClientID, ClientAppID, ClientAppSectionID, ClientAppEventsContentID, EventStartDate, EventEndDate, Title, ContactName, ContactEmail, EmailSubject, EmailBody, Information, Address, TimeZone, Lat, Lng, ClientAppGroupLocationID, DateCreated, DateModified, Active
FROM tblClientAppEventsItem_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappeventsitem`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappeventsitem`;
DROP VIEW IF EXISTS `sample`.`tblclientappeventsitem` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppLinksContent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppLinksContent`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppLinksContent` AS
SELECT ClientAppLinksContentID, ClientID, ClientAppID, ClientAppSectionID, ListTitle, InstructionText, DateCreated, DateModified, Active
FROM tblClientAppLinksContent_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientapplinkscontent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientapplinkscontent`;
DROP VIEW IF EXISTS `sample`.`tblclientapplinkscontent` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppLinksItem`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppLinksItem`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppLinksItem` AS
SELECT ClientAppLinksItemID, ClientID, ClientAppID, ClientAppSectionID, ClientAppLinksContentID, LinkText, Link, OrderID, DateCreated, DateModified, Active
FROM tblClientAppLinksItem_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientapplinksitem`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientapplinksitem`;
DROP VIEW IF EXISTS `sample`.`tblclientapplinksitem` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblClientAppQuestion`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblClientAppQuestion`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblClientAppQuestion` AS
SELECT ClientAppQuestionID, ClientID, ClientAppID, ClientAppSectionID, QuestionTypeID, Required, Name, QuestionText, IncorrectFeedback, CorrectFeedback, Hint, AnswerKey, DateCreated, DateModified, Active
FROM tblClientAppQuestion_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblclientappquestion`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblclientappquestion`;
DROP VIEW IF EXISTS `sample`.`tblclientappquestion` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblQRCodeEmail`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblQRCodeEmail`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblQRCodeEmail` AS
SELECT  QRCodeEmailID, ClientID, ClientQRCodeID, Email, DateCreated, DateModified, Active
FROM tblQRCodeEmail_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';
;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblqrcodeemail`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblqrcodeemail`;
DROP VIEW IF EXISTS `sample`.`tblqrcodeemail` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblQRCodePhone`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblQRCodePhone`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblQRCodePhone` AS
SELECT  QRCodePhoneID, ClientID, ClientQRCodeID, Phone, DateCreated, DateModified, Active
FROM tblQRCodePhone_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';
;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblqrcodephone`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblqrcodephone`;
DROP VIEW IF EXISTS `sample`.`tblqrcodephone` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblQRCodeSMS`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblQRCodeSMS`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblQRCodeSMS` AS
SELECT  QRCodeSMSID, ClientID, ClientQRCodeID, Phone, Message, DateCreated, DateModified, Active
FROM tblQRCodeSMS_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';
;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblqrcodesms`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblqrcodesms`;
DROP VIEW IF EXISTS `sample`.`tblqrcodesms` ;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblQRCodeWIFI`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblQRCodeWIFI`;
USE `sample`;
CREATE  OR REPLACE VIEW `sample`.`tblQRCodeWIFI` AS
SELECT  QRCodeWIFIID, ClientID, ClientQRCodeID, SSID, Password, WIFITypeID, DateCreated, DateModified, Active
FROM tblQRCodeWIFI_base
WHERE tenant = SUBSTRING_INDEX(USER(), '@', 1) OR SUBSTRING_INDEX(USER(), '@', 1) = 'db_god';
;


USE `sample`;

-- -----------------------------------------------------
-- View `sample`.`tblqrcodewifi`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `sample`.`tblqrcodewifi`;
DROP VIEW IF EXISTS `sample`.`tblqrcodewifi` ;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;