PHP Classes

File: Schema/Sqlite.php

Recommend this page to a friend!
  Classes of kiran   Kanboard Group Assign   Schema/Sqlite.php   Download  
File: Schema/Sqlite.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Kanboard Group Assign
Plugin to assign tasks to groups or multiple users
Author: By
Last change:
Date: 3 years ago
Size: 810 bytes
 

Contents

Class file image Download
<?php

namespace Kanboard\Plugin\group_assign\Schema;

use
PDO;

const
VERSION = 2;

function
version_2(PDO $pdo)
{
   
$pdo->exec("ALTER TABLE tasks ADD COLUMN owner_ms INTEGER DEFAULT '0'");
   
   
$pdo->exec("
        CREATE TABLE multiselect (
            id INTEGER PRIMARY KEY,
            external_id TEXT DEFAULT ''
        )
    "
);
   
   
$pdo->exec("
        CREATE TABLE multiselect_has_users (
            group_id INTEGER NOT NULL,
            user_id INTEGER NOT NULL,
            FOREIGN KEY(group_id) REFERENCES multiselect(id) ON DELETE CASCADE,
            FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,
            UNIQUE(group_id, user_id)
        )
    "
);
}

function
version_1(PDO $pdo)
{
   
$pdo->exec("ALTER TABLE tasks ADD COLUMN owner_gp INTEGER DEFAULT '0'");
}