'use strict';

/** @type {import('sequelize-cli').Migration} */
module.exports = {
  async up (queryInterface, Sequelize) {
    // Check if the page already exists
    const [existingPages] = await queryInterface.sequelize.query(
      'SELECT id FROM pages WHERE slug = ?;',
      { replacements: ['privacy-policy'] }
    );
    
    // If the page doesn't exist, insert it
    if (existingPages.length === 0) {
      await queryInterface.bulkInsert('pages', [{
        title: 'Privacy Policy',
        slug: 'privacy-policy',
        content: '{"title":"Privacy Policy","introduction":[{"content":"Our website address is: https://mobilemoney.ph/ under business name Telcom Live Content, Inc., Company Registered no. CS200417553 with principal address 12th Floor Summit One Tower, 530 Shaw Boulevard, Mandaluyong, Philippines, 1552."},{"content":"Telcom Live Content, Inc. (TLCI) is committed to protecting the privacy of our website visitors. We understand that the personal information you share with us is important, and we are committed to protecting it. This privacy policy outlines how we collect, use, and protect your personal information when you visit our website or use our products and services."}],"sections":[{"title":"Information Collection","content":"TLCI may collect your personal information when you visit our website, submit an inquiry or apply for a job, this is to assist you in addressing your inquiry or assessing your job application. This information may include your name, email address, mailing address, phone number, and other relevant details."},{"title":"Use of Information","content":"TLCI uses your personal information only for the specific and legitimate purposes for which it was provided. We assure you that the personal information you provide to us will not be used for any illegal or unethical purposes and will not be shared or sold to any third parties without your consent. We strictly prohibit any form of scam or illegal activities and will take immediate action against any such violation."},{"title":"Retention of Information","content":"TLCI will retain your personal information only for as long as necessary to provide you with our products or services, or for as long as necessary to comply with our legal obligations, resolve disputes, and enforce our agreements."},{"title":"Protection of Information","content":"TLCI takes all reasonable precautions to protect the personal information of our website visitors from unauthorized access, use, alteration, or destruction. We use industry-standard security measures such as encryption and firewalls to safeguard your personal information."},{"title":"Sharing of Information","content":"TLCI does not share, sell, or rent personal information to any third parties without your consent, except as required by law or as necessary to fulfill a request or transaction."},{"title":"Cookies","type":"cookies","content":"TLCI uses cookies to enhance your browsing experience and provide you with the best possible service. Cookies are small text files that are stored on your device by your browser and help us to understand how you use our website.","subtitle":"We use three types of cookies on our website:","items":[{"title":"Required Cookies","description":"These cookies are essential for the proper functioning of our website and cannot be turned off. They allow you to navigate the site, access secure areas and use our services."},{"title":"Preference Cookies","description":"These cookies store your preferences, such as your preferred font sizes and other basic settings, and help us to provide a more personalized experience. You can choose to turn off these cookies, but doing so may limit the functionality of the website."},{"title":"Performance Cookies","description":"These cookies track how you use our website, allowing us to analyze and improve the performance and functionality of our website. They do not store any personal information and are used solely for analytical purposes."}],"additionalInfo":["You can manage your cookie preferences by changing your browser settings to block or restrict cookies. However, please note that disabling cookies may affect your ability to utilize all the features of our website fully.","By using our website, you consent to the use of cookies in accordance with this Cookie Policy."]},{"title":"Third-Party Links","content":"TLCI\'s website may contain links to third-party websites. TLCI is not responsible for the privacy practices of these websites, and we encourage you to read their privacy policies before providing them with your personal information."},{"title":"Changes to this Privacy Policy","content":"TLCI reserves the right to modify this privacy policy at any time. Any changes to this policy will be posted on our website."},{"title":"Contacting TLCI","content":"If you have any questions about this privacy policy or the information we collect, please contact us at dpo@mobilemoney.ph"}],"conclusion":"At TLCI, we value the privacy of our clients and website visitors and we assure you that your personal information will be kept safe and secure with us. We are committed to maintaining the trust and confidence of our customers and we will adhere to the highest standards of data privacy and security. We will also regularly review and update our policies and procedures to ensure that we are in compliance with the latest industry standards and regulations.","finalNote":"TLCI understands that the trust placed in us by our customers is a privilege and we take our responsibility to protect your personal information very seriously. If you have any concerns or questions about our privacy policy, please do not hesitate to contact us. We are always here to help and provide any information you may need."}',
        status: 'published',
        author_id: null,
        created_at: new Date(),
        updated_at: new Date()
      }], {});
    }
  },

  async down (queryInterface, Sequelize) {
    await queryInterface.bulkDelete('pages', { slug: 'privacy-policy' }, {});
  }
};