

CREATE TABLE `company_list` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED NOT NULL,
  `name` varchar(128) NOT NULL,
  `website` varchar(128) DEFAULT NULL,
  `image` varchar(40) NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `company_list_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `company_list_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `contacts` (
  `id` int(10) UNSIGNED NOT NULL,
  `date` datetime NOT NULL,
  `name` varchar(128) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(256) NOT NULL,
  `message` varchar(5120) NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `contributions_to_support_local_communities` (
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `csr` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `csr_image` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `csr_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `csr_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `title` varchar(128) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `footer` (
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `founder` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `image` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `founder_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `founder_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `image_slider` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL,
  `created_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `image_slider_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `image_slider_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `text` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `languages` (
  `languages_id` varchar(2) NOT NULL,
  `name` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `our_mission` (
  `languages_id` varchar(2) NOT NULL,
  `title` varchar(128) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `our_project` (
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `our_services` (
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `our_vision` (
  `languages_id` varchar(2) NOT NULL,
  `title` varchar(128) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `overview` (
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL,
  `year` year(4) NOT NULL,
  `project_type_id` int(10) UNSIGNED NOT NULL,
  `location` varchar(1024) NOT NULL,
  `youtube` varchar(1024) DEFAULT NULL,
  `youtube_id` varchar(11) DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_gallery` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_on_media` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL,
  `image_thumb` varchar(40) NOT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `order` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_on_media_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_on_media_id` int(11) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `magazine_name` varchar(128) NOT NULL,
  `magazine_edition` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_thumbnail` (
  `id` int(5) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL,
  `project_type_id` int(10) UNSIGNED NOT NULL,
  `colour` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_type` (
  `id` int(10) UNSIGNED NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_type_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_type_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `service_list` (
  `id` int(10) UNSIGNED NOT NULL,
  `order` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `project_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `project_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `title` varchar(128) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `service_list_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `service_list_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `name` varchar(128) NOT NULL,
  `description` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `several_sisters_company` (
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `team_management` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `team_management_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `team_management_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `title` varchar(128) NOT NULL,
  `description` varchar(5120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `testimonials` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(128) NOT NULL,
  `company` varchar(128) NOT NULL,
  `order` int(4) NOT NULL,
  `created_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `testimonials_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `testimonials_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `message` varchar(1024) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `welcome` (
  `id` int(10) UNSIGNED NOT NULL,
  `image` varchar(40) NOT NULL,
  `created_at` datetime NOT NULL,
  `deleted_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `welcome_translation` (
  `id` int(10) UNSIGNED NOT NULL,
  `welcome_id` int(10) UNSIGNED NOT NULL,
  `languages_id` varchar(2) NOT NULL,
  `description` varchar(2048) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `company_list`
  ADD PRIMARY KEY (`id`,`name`);
ALTER TABLE `company_list_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `company_list_id` (`company_list_id`);
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `contributions_to_support_local_communities`
  ADD PRIMARY KEY (`languages_id`);
ALTER TABLE `csr`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `csr_image`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `csr_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `csr_id` (`csr_id`);
ALTER TABLE `founder`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `founder_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `founder_id` (`founder_id`);
ALTER TABLE `image_slider`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `image_slider_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `image_slider_id` (`image_slider_id`);
ALTER TABLE `our_project`
  ADD KEY `languages_id` (`languages_id`);
ALTER TABLE `project`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `project_gallery`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `project_on_media`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `project_on_media_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_on_media_id` (`project_on_media_id`);
ALTER TABLE `project_thumbnail`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `project_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_id` (`project_id`);
ALTER TABLE `project_type`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `project_type_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `project_type_id` (`project_type_id`);
ALTER TABLE `service_list`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `service_list_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_list_id` (`service_list_id`);
ALTER TABLE `several_sisters_company`
  ADD PRIMARY KEY (`languages_id`);
ALTER TABLE `team_management`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `team_management_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `team_management_id` (`team_management_id`);
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `testimonials_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `testimonials_id` (`testimonials_id`);
ALTER TABLE `welcome`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `welcome_translation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `welcome_id` (`welcome_id`);
ALTER TABLE `company_list`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `company_list_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
ALTER TABLE `contacts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `csr`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `csr_image`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `csr_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
ALTER TABLE `founder`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `founder_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `image_slider`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `image_slider_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `project`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `project_gallery`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
ALTER TABLE `project_on_media`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `project_on_media_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `project_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `project_type`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
ALTER TABLE `project_type_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
ALTER TABLE `service_list`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
ALTER TABLE `service_list_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
ALTER TABLE `team_management`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `team_management_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `testimonials`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `testimonials_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `welcome`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
ALTER TABLE `welcome_translation`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
ALTER TABLE `company_list_translation`
  ADD CONSTRAINT `company_list_translation_ibfk_1` FOREIGN KEY (`company_list_id`) REFERENCES `company_list` (`id`);
ALTER TABLE `csr_translation`
  ADD CONSTRAINT `csr_translation_ibfk_1` FOREIGN KEY (`csr_id`) REFERENCES `csr` (`id`);
ALTER TABLE `founder_translation`
  ADD CONSTRAINT `founder_translation_ibfk_1` FOREIGN KEY (`founder_id`) REFERENCES `founder` (`id`);
ALTER TABLE `image_slider_translation`
  ADD CONSTRAINT `image_slider_translation_ibfk_1` FOREIGN KEY (`image_slider_id`) REFERENCES `image_slider` (`id`);
ALTER TABLE `project_on_media_translation`
  ADD CONSTRAINT `project_on_media_translation_ibfk_1` FOREIGN KEY (`project_on_media_id`) REFERENCES `project_on_media` (`id`);
ALTER TABLE `project_translation`
  ADD CONSTRAINT `project_translation_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `project` (`id`);
ALTER TABLE `project_type_translation`
  ADD CONSTRAINT `project_type_translation_ibfk_1` FOREIGN KEY (`project_type_id`) REFERENCES `project_type` (`id`);
ALTER TABLE `service_list_translation`
  ADD CONSTRAINT `service_list_translation_ibfk_1` FOREIGN KEY (`service_list_id`) REFERENCES `service_list` (`id`);
ALTER TABLE `team_management_translation`
  ADD CONSTRAINT `team_management_translation_ibfk_1` FOREIGN KEY (`team_management_id`) REFERENCES `team_management` (`id`);
ALTER TABLE `testimonials_translation`
  ADD CONSTRAINT `testimonials_translation_ibfk_1` FOREIGN KEY (`testimonials_id`) REFERENCES `testimonials` (`id`);
ALTER TABLE `welcome_translation`
  ADD CONSTRAINT `welcome_translation_ibfk_1` FOREIGN KEY (`welcome_id`) REFERENCES `welcome` (`id`);

INSERT INTO `company_list` (`id`, `order`, `name`, `website`, `image`, `deleted_at`) VALUES
(1, 1, 'Abhiartha', 'https://www.facebook.com/abhiartha.abhinaya', '7vOBOd2zoPp0XBmo5zuz.jpeg', NULL),
(2, 2, 'Taru Bumi Kita', 'http://tarubumikita.com/', 'TKNJMgPRnBY5EAbeyc6p.jpeg', NULL),
(3, 3, 'Simetris Consulting', 'http://simetris-consulting.com/', 'u7DcQxaasMg0cNCistnw.jpeg', NULL),
(4, 4, 'Cahaya Langit Nusantara', 'http://tarubumikita.com/', 'iB4lDMBiPp3aqUq0iNca.jpeg', NULL);

INSERT INTO `company_list_translation` (`id`, `company_list_id`, `languages_id`, `description`) VALUES
(1, 1, 'en', 'a villa management, property maintenance service, housing development, procurement services, business support, material supplier and building material store.'),
(2, 1, 'id', '[Indonesia] a villa management, property maintenance service, housing development, procurement services, business support, material supplier and building material store.'),
(3, 2, 'en', 'PT. Simetris Consulting, a well-known quantity surveyor company, project management, and engineering design in Bali. '),
(4, 2, 'id', '[Indonesia] PT. Simetris Consulting, a well-known quantity surveyor company, project management, and engineering design in Bali. '),
(5, 3, 'en', 'PT. Simetris Consulting, a well-known quantity surveyor company, project management, and engineering design in Bali. '),
(6, 3, 'id', '[Indonesia] PT. Simetris Consulting, a well-known quantity surveyor company, project management, and engineering design in Bali. '),
(7, 4, 'en', 'PT. Simetris Consulting, a well-known quantity surveyor company, project management, and engineering design in Bali. '),
(8, 4, 'id', '[Indonesia] PT. Simetris Consulting, a well-known quantity surveyor company, project management, and engineering design in Bali. ');

INSERT INTO `contributions_to_support_local_communities` (`languages_id`, `description`) VALUES
('en', 'PT. Bingkai Langit Constructions is a reliable company deals with general building construction and the application through managing efficiency and professional skill. Presently, PT. Bingkai Langit Constructions is the only innovative, effective and reliable building construction company in Bali which is able to give single-door-service from construction planning, project management, until construction implementation and application in one package of working contract.\r\n\r\nWe trust in a long-term partnership with our clients, and we commit to bring success into reality by helping clients through our best services and our excellent shots.\r\naahuman resource working in our comapany that grows and develops asustainably at present and the future.'),
('id', '[Indonesia] PT. Bingkai Langit Constructions is a reliable company deals with general building construction and the application through managing efficiency and professional skill. Presently, PT. Bingkai Langit Constructions is the only innovative, effective and reliable building construction company in Bali which is able to give single-door-service from construction planning, project management, until construction implementation and application in one package of working contract.\r\n\r\nWe trust in a long-term partnership with our clients, and we commit to bring success into reality by helping clients through our best services and our excellent shots.\r\naahuman resource working in our comapany that grows and develops asustainably at present and the future.');

INSERT INTO `csr` (`id`, `order`, `deleted_at`) VALUES
(1, 1, NULL),
(2, 2, NULL),
(3, 3, NULL),
(4, 4, NULL);

INSERT INTO `csr_image` (`id`, `image`) VALUES
(1, 'YXwX7bFnEAcAKxOF4VS2.jpeg');

INSERT INTO `csr_translation` (`id`, `csr_id`, `languages_id`, `title`, `description`) VALUES
(1, 1, 'en', 'FACILITATING CITIZENSHIP EMPOWERMENT', 'Facilitating citizenship empowerment such as cooperation to improve society economy level.'),
(2, 1, 'id', '[Indonesia] Facilitating citizenship empowerment', 'Facilitating citizenship empowerment such as cooperation to improve society economy level.'),
(3, 2, 'en', 'SUPPORTING ACTIVITIES TO EDUCATE SOCIETY', 'Supporting activities to educate society such as: Funding books - publishing to support the process of creating enlighten society, organizing education based-activities, education based - workshop events and education based - seminars.'),
(4, 2, 'id', '[Indonesia] SUPPORTING ACTIVITIES TO EDUCATE SOCIETY', '[Indonesia] Supporting activities to educate society such as: Funding books - publishing to support the process of creating enlighten society, organizing education based-activities, education based - workshop events and education based - seminars.'),
(5, 3, 'en', 'SUPPPORTING THE REPAIR AND MAINTENANCE OF FACILITIES IN EDUCATION', 'Supporting the repair and maintenance of facilities in formal and informal education through non profit collaborator to educate society.'),
(6, 3, 'id', '[Indonesia] SUPPPORTING THE REPAIR AND MAINTENANCE OF FACILITIES IN EDUCATION', '[Indonesia] Supporting the repair and maintenance of facilities in formal and informal education through non profit collaborator to educate society.'),
(7, 4, 'en', 'SUPPORTING SOCIAL CAMPAIGN', 'Actively participating and supporting social campaigns which appoint the issue of diversity, heterogeneity and harmony to appreciate disparity each other in the concept of nationality.'),
(8, 4, 'id', '[Indonesia] SUPPORTING SOCIAL CAMPAIGN', '[Indonesia] Actively participating and supporting social campaigns which appoint the issue of diversity, heterogeneity and harmony to appreciate disparity each other in the concept of nationality.');

INSERT INTO `footer` (`languages_id`, `description`) VALUES
('en', 'We sustainably grow and innovate to ensure that we are able to adapt and comply with the highest standard of our clients\' order through our solid and highly effective team works. That is the reason why we place every project handled as our best masterpiece.'),
('id', '[Indonesia] We sustainably grow and innovate to ensure that we are able to adapt and comply with the highest standard of our clients\' order through our solid and highly effective team works. That is the reason why we place every project handled as our best masterpiece.');

INSERT INTO `founder` (`id`, `name`, `image`) VALUES
(1, 'FATIN HAMAMAH', 'pbB2Fcy1OWb8HmOTIjwb.jpeg'),
(2, 'Wayan Gede Sudhiartaa', 'I7fdL3qpnDrymx3wg8qP.jpeg');

INSERT INTO `founder_translation` (`id`, `founder_id`, `languages_id`, `description`) VALUES
(1, 1, 'en', 'Fatin Hamamah with her background and experiences as a Planning Manager gives the color of professionalism through professional skill, carefulness, and an ability to see every detail attentively so that she always presents precise planning.'),
(2, 1, 'id', '[Indonesia] Fatin Hamamah with her background and experiences as a Planning Manager gives the color of professionalism through professional skill, carefulness, and an ability to see every detail attentively so that she always presents precise planning.'),
(3, 2, 'en', 'Wayan Gede Sudhiarta with his background and experiences as a construction Manager owns a touch of how to be practical, simple, communicative and is able to hold team well with solid and highly effective team works.'),
(4, 2, 'id', '[Indonesia] Wayan Gede Sudhiarta with his background and experiences as a construction Manager owns a touch of how to be practical, simple, communicative and is able to hold team well with solid and highly effective team works.');

INSERT INTO `image_slider` (`id`, `order`, `image`, `created_at`, `deleted_at`) VALUES
(1, 1, 'yqwk2FfAKSiQaD5DjsUx.jpeg', '2017-11-27 14:29:53', NULL);

INSERT INTO `image_slider_translation` (`id`, `image_slider_id`, `languages_id`, `text`) VALUES
(1, 1, 'en', 'Lorem ipsum dolor sit amet, te pri laudem gubergren, splendide mnesarchum vis id'),
(2, 1, 'id', '[Indonesia] Lorem ipsum dolor sit amet, te pri laudem gubergren, splendide mnesarchum vis id.');

INSERT INTO `languages` (`languages_id`, `name`) VALUES
('en', 'ENGLISH'),
('id', 'INDONESIA');

INSERT INTO `our_mission` (`languages_id`, `title`, `description`) VALUES
('en', 'FINDING SELF IDENTITY', 'Pouring and translating spirit, trust, solid and high effective team works, love to profession and the expression of finding self identity through professional skill of work, services and creativities.\r\n\r\nPresenting our masterpieces as \'dreams that come to reality\' for the owner, as well as being the \'media of self-actualization process in the reaching of prosperity and happiness\' for every one involved in the process.'),
('id', '[Indonesia] FINDING SELF IDENTITY', '[Indonesia] Pouring and translating spirit, trust, solid and high effective team works, love to profession and the expression of finding self identity through professional skill of work, services and creativities.\r\n\r\nPresenting our masterpieces as \'dreams that come to reality\' for the owner, as well as being the \'media of self-actualization process in the reaching of prosperity and happiness\' for every one involved in the process.');

INSERT INTO `our_project` (`languages_id`, `description`) VALUES
('en', 'We always work proactively, effectively and communicatively based on a strong services and mentality. This is able to offer solution quality at the competitive price level. '),
('id', '[Indonesia] We always work proactively, effectively and communicatively based on a strong services and mentality. This is able to offer solution quality at the competitive price level. ');

INSERT INTO `our_services` (`languages_id`, `description`) VALUES
('en', 'We believe in the perspective of Global world, we should keep holding locality values, so that we can communicate and understand local communities better from bureaucracy level, up to area instruction given for our staffs. The scope that we handle are General Constructions, Cost & Fee Project, and Design & Built Project. Please contact us for more information.'),
('id', '[Indonesia] We believe in the perspective of Global world, we should keep holding locality values, so that we can communicate and understand local communities better from bureaucracy level, up to area instruction given for our staffs. The scope that we handle are General Constructions, Cost & Fee Project, and Design & Built Project. Please contact us for more information.');

INSERT INTO `our_vision` (`languages_id`, `title`, `description`) VALUES
('en', 'DREAM THAT COMES TO REALITY', 'Presenting our masterpieces as \'dreams that come to reality\' for the owner, as well as being the \'media of self-actualization process in the reaching of prosperity and happiness\' for every one involved in the process.'),
('id', '[Indonesia] DREAM THAT COMES TO REALITY', '[Indonesia] Presenting our masterpieces as \'dreams that come to reality\' for the owner, as well as being the \'media of self-actualization process in the reaching of prosperity and happiness\' for every one involved in the process.');

INSERT INTO `overview` (`languages_id`, `description`) VALUES
('en', 'Once seeing the future, the management of Bingkai Langit Constructions has been developing a new vision and mission for the company to always grow and develop. We have been realizing that we own potential and talent to be better of our clients\' expectation through our professional skill and solid and highly effective team works. We are also in charge of being the honorable player for every working partner. Furthermore, we would like to make Bingkai Langit Constructions as the leading company in construction into reality.'),
('id', '[Indonesia] Once seeing the future, the management of Bingkai Langit Constructions has been developing a new vision and mission for the company to always grow and develop. We have been realizing that we own potential and talent to be better of our clients\' expectation through our professional skill and solid and highly effective team works. We are also in charge of being the honorable player for every working partner. Furthermore, we would like to make Bingkai Langit Constructions as the leading company in construction into reality.');

INSERT INTO `project` (`id`, `image`, `year`, `project_type_id`, `location`, `youtube`, `youtube_id`, `deleted_at`) VALUES
(1, 'EZboqM9XnZJXPdMVo2kr.jpeg', 2017, 2, 'Canggu, Bali', 'https://www.youtube.com/watch?time_continue=1&v=o-Ph5zsYvpE', 'o-Ph5zsYvpE', NULL),
(2, 'VtHnvwSBZ9FYGSWBSI08.jpeg', 2016, 1, 'Gianyar, Bali', 'https://www.youtube.com/watch?time_continue=1&v=o-Ph5zsYvpE', 'o-Ph5zsYvpE', NULL);

INSERT INTO `project_gallery` (`id`, `project_id`, `image`, `deleted_at`) VALUES
(1, 1, 'P0M0qg8L7KuWkW9abxq2.jpeg', NULL),
(2, 1, '9PY3fdQZDbedlCLTsgXK.jpeg', NULL),
(3, 1, 'UBaiNZuP480EhdpwXToD.jpeg', NULL),
(4, 1, 'dhGxtuj6Nnc0bwOjTfXx.jpeg', NULL),
(5, 1, '6fRC5lJ2oog0rD92SBxS.jpeg', NULL),
(6, 1, 'OslBQRLBdXiUQ0W6mdeF.jpeg', NULL),
(7, 1, '6F8wg4PUSCKgfoy2EqSZ.jpeg', NULL),
(8, 1, 'rZIENaHt9taL9yHcIiWI.jpeg', NULL),
(9, 2, 'PKVB3sDlwNTZVC0fvznZ.jpeg', NULL),
(10, 2, 'OXzZgrRqp1TFyHUNZGBa.jpeg', NULL),
(11, 2, 'TpgxreexQ1F7pJoLgult.jpeg', NULL),
(12, 2, 'M6Z6DdWIQkfXNRQxwdnC.jpeg', NULL),
(13, 2, 'mAKw6t63klF2qPJ4XsoT.jpeg', NULL),
(14, 2, 'Z9OhpNAMu5rMrLg0rW71.jpeg', NULL),
(15, 2, 'ipjfPItw6lIH0wJ05JAQ.jpeg', NULL),
(16, 2, 'OJ59sCeckbD1LvjjAAYc.jpeg', NULL);

INSERT INTO `project_on_media` (`id`, `image`, `image_thumb`, `deleted_at`, `order`) VALUES
(1, 'CtSpi274WX55jK3IzNOi.jpeg', '2epoPbyUkwPkZCkIhIUq.jpeg', NULL, 1),
(2, 'lVWYyt8tBgyKmqANMhkI.jpeg', 'dWUDE2qJF3KYsabAaIXI.jpeg', NULL, 2);

INSERT INTO `project_on_media_translation` (`id`, `project_on_media_id`, `languages_id`, `magazine_name`, `magazine_edition`) VALUES
(1, 1, 'en', 'Lorem Ipsum Magazine', 'Edition 1.0'),
(2, 1, 'id', '[Indonesia] Lorem Ipsum Magazine', 'Edition 1.0'),
(3, 2, 'en', 'Lorem Ipsum Magazine', 'Edition 2.0'),
(4, 2, 'id', 'Lorem Ipsum Magazine', 'Edition 2.0');

INSERT INTO `project_thumbnail` (`id`, `image`, `project_type_id`, `colour`) VALUES
(1, 1, 'GLfilaSwjQUPhN7bHc3f.jpeg', 1, 'orange'),
(2, 2, 'r9Quus64i8MtY8Ay0gW2.jpeg', 2, 'purple'),
(3, 3, 'GfyL8FwFrKRAfsqXGWRo.jpeg', 3, 'green');

INSERT INTO `project_translation` (`id`, `project_id`, `languages_id`, `title`, `description`) VALUES
(1, 1, 'en', 'THE GARDEN OF SARASVATI', 'As the extension of the Villa Sarasvati, this second area is incorporates the Gladak, complete with ensuite bathroom, kitchenette and verandah. This gorgeous old house is a traditional high-peaked teakwood building representing a bygone era, yet with all the comforts of modern day living. There is also an antique wooden spa building, a timber relaxation gazebo, an elevated rice field shelter known as a \'Pondok\', a free form swimming pool, a giant chess set and a Pétanque court, set within an exceptional rambling garden, which rolls down to the rice fields. Built on 2009, designed by German Architect Walter Wagner from Habitat5 www.habitat5.com'),
(2, 1, 'id', '[Indonesia] THE GARDEN OF SARASVATI', 'As the extension of the Villa Sarasvati, this second area is incorporates the Gladak, complete with ensuite bathroom, kitchenette and verandah. This gorgeous old house is a traditional high-peaked teakwood building representing a bygone era, yet with all the comforts of modern day living. There is also an antique wooden spa building, a timber relaxation gazebo, an elevated rice field shelter known as a \'Pondok\', a free form swimming pool, a giant chess set and a Pétanque court, set within an exceptional rambling garden, which rolls down to the rice fields. Built on 2009, designed by German Architect Walter Wagner from Habitat5 www.habitat5.com'),
(3, 2, 'en', 'THE GARDEN OF SARASVATI 2', 'As the extension of the Villa Sarasvati, this second area is incorporates the Gladak, complete with ensuite bathroom, kitchenette and verandah. This gorgeous old house is a traditional high-peaked teakwood building representing a bygone era, yet with all the comforts of modern day living. There is also an antique wooden spa building, a timber relaxation gazebo, an elevated rice field shelter known as a \'Pondok\', a free form swimming pool, a giant chess set and a Pétanque court, set within an exceptional rambling garden, which rolls down to the rice fields. Built on 2009, designed by German Architect Walter Wagner from Habitat5 www.habitat5.com'),
(4, 2, 'id', '[Indonesia] THE GARDEN OF SARASVATI 2', '[Indonesia] As the extension of the Villa Sarasvati, this second area is incorporates the Gladak, complete with ensuite bathroom, kitchenette and verandah. This gorgeous old house is a traditional high-peaked teakwood building representing a bygone era, yet with all the comforts of modern day living. There is also an antique wooden spa building, a timber relaxation gazebo, an elevated rice field shelter known as a \'Pondok\', a free form swimming pool, a giant chess set and a Pétanque court, set within an exceptional rambling garden, which rolls down to the rice fields. Built on 2009, designed by German Architect Walter Wagner from Habitat5 www.habitat5.com');

INSERT INTO `project_type` (`id`, `status`, `deleted_at`) VALUES
(1, NULL),
(2, NULL),
(3, NULL);

INSERT INTO `project_type_translation` (`id`, `project_type_id`, `languages_id`, `description`) VALUES
(1, 1, 'en', 'Private House'),
(2, 1, 'id', '[Indonesia] Private House'),
(3, 2, 'en', 'Villa'),
(4, 2, 'id', '[Indonesia] Villa'),
(5, 3, 'en', 'Spa & Restaurant'),
(6, 3, 'id', '[Indonesia] Spa & Restaurant');

INSERT INTO `service_list` (`id`, `order`, `image`) VALUES
(1, 2, 'jpZnVv79Q9kXlUKmEx3o.jpeg'),
(2, 1, 'qfYjv3i4BQDr6Cv2Z56e.jpeg'),
(3, 3, 'sUo7cncXed6DzjbEa7pQ.jpeg');

INSERT INTO `service_list_translation` (`id`, `service_list_id`, `languages_id`, `name`, `description`) VALUES
(1, 1, 'en', 'COST & FEE PROJECT', 'Lorem ipsum dolor sit amet\r\nLorem ipsum dolor sit amet\r\nBisa lebih dari 3'),
(2, 1, 'id', '[Indonesia] COST & FEE PROJECT', '[Indonesia] Lorem ipsum dolor sit amet\r\nLorem ipsum dolor sit amet\r\nBisa lebih dari 3'),
(3, 2, 'en', 'DESIGN & BUILT PROJECT', 'Lorem ipsum dolor sit amet\r\nLorem ipsum dolor sit amet\r\nBisa lebih dari 3'),
(4, 2, 'id', 'DESIGN & BUILT PROJECT', '[Indonesia] Lorem ipsum dolor sit amet\r\nLorem ipsum dolor sit amet\r\nBisa lebih dari 3'),
(5, 3, 'en', 'GENERAL CONSTRUCTIONS', 'Lorem ipsum dolor sit amet\r\nLorem ipsum dolor sit amet\r\nBisa lebih dari 3'),
(6, 3, 'id', '[Indonesia] GENERAL CONSTRUCTIONS', '[Indonesia] Lorem ipsum dolor sit amet\r\nLorem ipsum dolor sit amet\r\nBisa lebih dari 3');

INSERT INTO `several_sisters_company` (`languages_id`, `description`) VALUES
('en', 'In the development for nine years, \'Bingkai Langit Constructions\' is able to transform to be not only an independent company, but also grows as a pioneer company that gives rise to several sisters - companies in \'Abhinaya Artha Mandala Group of Companies\'.\r\n\r\nThe existence of those sisters companies complete Bingkai Langit Constructions as the only one - stop - constructions - service in Bali that is able to perform together in a project as interdependently companies so that it can give excellent services with competitive prices.'),
('id', '[Indonesia] In the development for nine years, \'Bingkai Langit Constructions\' is able to transform to be not only an independent company, but also grows as a pioneer company that gives rise to several sisters - companies in \'Abhinaya Artha Mandala Group of Companies\'.\r\n\r\nThe existence of those sisters companies complete Bingkai Langit Constructions as the only one - stop - constructions - service in Bali that is able to perform together in a project as interdependently companies so that it can give excellent services with competitive prices.');

INSERT INTO `team_management` (`id`, `image`) VALUES
(1, 'ITPVz9foQyHtVtZCgkJR.jpeg');

INSERT INTO `team_management_translation` (`id`, `team_management_id`, `languages_id`, `title`, `description`) VALUES
(1, 1, 'en', 'MOVING AHEAD WITH TALENTED AND HIGHLY MOTIVATED EMPLOYEES', 'An evolved team within the process of finding the highness of self identity is a key to our success, since achievement and success will never be reached without the involvement and being motivated by those who work in our company. We believe that work actualization is a projection of self actualization of our employees. And that is the embodiment of young professionals\' spirit, professional skill and motivation who are enthusiastic and are experienced in their field.'),
(2, 1, 'id', '[Indonesia] Moving ahead with talented and highly motivated employees', '[Indonesia] An evolved team within the process of finding the highness of self identity is a key to our success, since achievement and success will never be reached without the involvement and being motivated by those who work in our company. We believe that work actualization is a projection of self actualization of our employees. And that is the embodiment of young professionals\' spirit, professional skill and motivation who are enthusiastic and are experienced in their field.');

INSERT INTO `testimonials` (`id`, `name`, `company`, `order`, `created_at`, `deleted_at`) VALUES
(1, 'John Doe', 'Timedoor Indonesia', 1, '2017-11-27 14:52:43', NULL);

INSERT INTO `testimonials_translation` (`id`, `testimonials_id`, `languages_id`, `message`) VALUES
(1, 1, 'en', 'Thank you so much for your help really. I am really enjoying living in my new place and Miso is totally happy too. Needless to say if anyone wants to find a house to live I will recommend you first in the future!!! THANK YOU SO MUCH! And I will stop by someday soon to say hello'),
(2, 1, 'id', '[Indonesia] Thank you so much for your help really. I am really enjoying living in my new place and Miso is totally happy too. Needless to say if anyone wants to find a house to live I will recommend you first in the future!!! THANK YOU SO MUCH! And I will stop by someday soon to say hello');

INSERT INTO `welcome` (`id`, `image`, `created_at`, `deleted_at`) VALUES
(1, 'W5Il4vIxfL7j9wZZmwXN.jpeg', '2017-11-03 15:27:02', NULL);

INSERT INTO `welcome_translation` (`id`, `welcome_id`, `languages_id`, `description`) VALUES
(1, 1, 'en', 'PT. Bingkai Langit Constructions is a reliable company deals with general building construction and the application through managing efficiency and professional skill. Presently, PT. Bingkai Langit Constructions is the only innovative, effective and reliable building construction company in Bali which is able to give single-door-service from construction planning, project management, until construction implementation and application in one package of working contract.\r\n\r\nWe trust in a long-term partnership with our clients, and we commit to bring success into reality by helping clients through our best services and our excellent shots.\r\n\r\nWe focus on quality and totality of human resource working in our company that grows and develops sustainably at present and the future.'),
(2, 1, 'id', '[Indonesia] PT. Bingkai Langit Constructions is a reliable company deals with general building construction and the application through managing efficiency and professional skill. Presently, PT. Bingkai Langit Constructions is the only innovative, effective and reliable building construction company in Bali which is able to give single-door-service from construction planning, project management, until construction implementation and application in one package of working contract.\r\n\r\nWe trust in a long-term partnership with our clients, and we commit to bring success into reality by helping clients through our best services and our excellent shots.\r\n\r\nWe focus on quality and totality of human resource working in our company that grows and develops sustainably at present and the future.');
