OMIProjectBranding/Schema/Sqlite.php

<?php namespace Kanboard\Plugin\OMIProjectBranding\Schema;

use PDO;

const VERSION = 3;

function version_3(PDO $pdo) {
  $pdo->exec('DROP TABLE project_branding;');
  $pdo->exec('
    CREATE TABLE IF NOT EXISTS project_branding (
      id INTEGER PRIMARY KEY,
      project_id INTEGER NOT NULL,
      logo_url TEXT,
      foreground_color TEXT,
      background_color TEXT,
      second_background_color TEXT,
      enabled INTEGER DEFAULT 0,
      FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
    );
  ');
}

function version_2(PDO $pdo) {
  $pdo->exec('DROP TABLE project_branding;');
  $pdo->exec('
    CREATE TABLE IF NOT EXISTS project_branding (
      id INTEGER PRIMARY KEY,
      project_id INTEGER NOT NULL,
      logo_url TEXT,
      accent_color TEXT,
      enabled INTEGER DEFAULT 0,
      FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
    );
  ');
}

function version_1(PDO $pdo) {
  $pdo->exec('
    CREATE TABLE IF NOT EXISTS project_branding (
      id INTEGER PRIMARY KEY,
      project_id INTEGER NOT NULL,
      logo_url TEXT,
      accent_color TEXT,
      enabled INTEGER DEFAULT 0,
      FOREIGN KEY(project_id) REFERENCES projects(id) ON DELETE CASCADE
    );
  ');
}