
SET NAMES utf8mb4;



DROP VIEW IF EXISTS `object_contact_form`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_contact_form` AS select `object_query_contact_form`.`oo_id` AS `oo_id`,`object_query_contact_form`.`oo_classId` AS `oo_classId`,`object_query_contact_form`.`oo_className` AS `oo_className`,`object_query_contact_form`.`fullName` AS `fullName`,`object_query_contact_form`.`email` AS `email`,`object_query_contact_form`.`phone` AS `phone`,`object_query_contact_form`.`message` AS `message`,`object_query_contact_form`.`lang` AS `lang`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount` from (`object_query_contact_form` join `objects` on((`objects`.`id` = `object_query_contact_form`.`oo_id`)));

DROP VIEW IF EXISTS `object_localized_news_de`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_localized_news_de` AS select `object_query_news`.`oo_id` AS `oo_id`,`object_query_news`.`oo_classId` AS `oo_classId`,`object_query_news`.`oo_className` AS `oo_className`,`object_query_news`.`createdOn` AS `createdOn`,`object_query_news`.`previewImage` AS `previewImage`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount`,`de`.`ooo_id` AS `ooo_id`,`de`.`language` AS `language`,`de`.`name` AS `name`,`de`.`url` AS `url`,`de`.`seoDescription` AS `seoDescription`,`de`.`previewText` AS `previewText` from ((`object_query_news` join `objects` on((`objects`.`id` = `object_query_news`.`oo_id`))) left join `object_localized_query_news_de` `de` on(((0 <> 1) and (`object_query_news`.`oo_id` = `de`.`ooo_id`))));

DROP VIEW IF EXISTS `object_localized_news_en`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_localized_news_en` AS select `object_query_news`.`oo_id` AS `oo_id`,`object_query_news`.`oo_classId` AS `oo_classId`,`object_query_news`.`oo_className` AS `oo_className`,`object_query_news`.`createdOn` AS `createdOn`,`object_query_news`.`previewImage` AS `previewImage`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount`,`en`.`ooo_id` AS `ooo_id`,`en`.`language` AS `language`,`en`.`name` AS `name`,`en`.`url` AS `url`,`en`.`seoDescription` AS `seoDescription`,`en`.`previewText` AS `previewText` from ((`object_query_news` join `objects` on((`objects`.`id` = `object_query_news`.`oo_id`))) left join `object_localized_query_news_en` `en` on(((0 <> 1) and (`object_query_news`.`oo_id` = `en`.`ooo_id`))));

DROP VIEW IF EXISTS `object_localized_news_fr`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_localized_news_fr` AS select `object_query_news`.`oo_id` AS `oo_id`,`object_query_news`.`oo_classId` AS `oo_classId`,`object_query_news`.`oo_className` AS `oo_className`,`object_query_news`.`createdOn` AS `createdOn`,`object_query_news`.`previewImage` AS `previewImage`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount`,`fr`.`ooo_id` AS `ooo_id`,`fr`.`language` AS `language`,`fr`.`name` AS `name`,`fr`.`url` AS `url`,`fr`.`seoDescription` AS `seoDescription`,`fr`.`previewText` AS `previewText` from ((`object_query_news` join `objects` on((`objects`.`id` = `object_query_news`.`oo_id`))) left join `object_localized_query_news_fr` `fr` on(((0 <> 1) and (`object_query_news`.`oo_id` = `fr`.`ooo_id`))));

DROP VIEW IF EXISTS `object_news`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_news` AS select `object_query_news`.`oo_id` AS `oo_id`,`object_query_news`.`oo_classId` AS `oo_classId`,`object_query_news`.`oo_className` AS `oo_className`,`object_query_news`.`createdOn` AS `createdOn`,`object_query_news`.`previewImage` AS `previewImage`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount` from (`object_query_news` join `objects` on((`objects`.`id` = `object_query_news`.`oo_id`)));

DROP VIEW IF EXISTS `object_newsletter_form`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_newsletter_form` AS select `object_query_newsletter_form`.`oo_id` AS `oo_id`,`object_query_newsletter_form`.`oo_classId` AS `oo_classId`,`object_query_newsletter_form`.`oo_className` AS `oo_className`,`object_query_newsletter_form`.`newsletterActive` AS `newsletterActive`,`object_query_newsletter_form`.`email` AS `email`,`object_query_newsletter_form`.`lang` AS `lang`,`object_query_newsletter_form`.`firstname` AS `firstname`,`object_query_newsletter_form`.`lastname` AS `lastname`,`object_query_newsletter_form`.`subscribeCode` AS `subscribeCode`,`object_query_newsletter_form`.`unsubscribeCode` AS `unsubscribeCode`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount` from (`object_query_newsletter_form` join `objects` on((`objects`.`id` = `object_query_newsletter_form`.`oo_id`)));

DROP VIEW IF EXISTS `object_user`;
CREATE ALGORITHM=UNDEFINED  VIEW `object_user` AS select `object_query_user`.`oo_id` AS `oo_id`,`object_query_user`.`oo_classId` AS `oo_classId`,`object_query_user`.`oo_className` AS `oo_className`,`object_query_user`.`password` AS `password`,`object_query_user`.`activationCode` AS `activationCode`,`object_query_user`.`passwordResetToken` AS `passwordResetToken`,`object_query_user`.`firstName` AS `firstName`,`object_query_user`.`lastName` AS `lastName`,`object_query_user`.`phone` AS `phone`,`object_query_user`.`email` AS `email`,`object_query_user`.`street` AS `street`,`object_query_user`.`city` AS `city`,`object_query_user`.`zipCode` AS `zipCode`,`object_query_user`.`company` AS `company`,`object_query_user`.`ic` AS `ic`,`object_query_user`.`dic` AS `dic`,`object_query_user`.`lang` AS `lang`,`objects`.`id` AS `id`,`objects`.`parentId` AS `parentId`,`objects`.`type` AS `type`,`objects`.`key` AS `key`,`objects`.`path` AS `path`,`objects`.`index` AS `index`,`objects`.`published` AS `published`,`objects`.`creationDate` AS `creationDate`,`objects`.`modificationDate` AS `modificationDate`,`objects`.`userOwner` AS `userOwner`,`objects`.`userModification` AS `userModification`,`objects`.`classId` AS `classId`,`objects`.`className` AS `className`,`objects`.`childrenSortBy` AS `childrenSortBy`,`objects`.`childrenSortOrder` AS `childrenSortOrder`,`objects`.`versionCount` AS `versionCount` from (`object_query_user` join `objects` on((`objects`.`id` = `object_query_user`.`oo_id`)));
