PHP Classes

File: Schema/Mysql.php

Recommend this page to a friend!
  Classes of kiran  >  Kanboard Group Assign  >  Schema/Mysql.php  >  Download  
File: Schema/Mysql.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: 11 months ago
Size: 900 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` INT DEFAULT '0'");
   
   
$pdo->exec("
        CREATE TABLE `multiselect` (
            id INT NOT NULL AUTO_INCREMENT,
            external_id VARCHAR(255) DEFAULT '',
            PRIMARY KEY(id)
        ) ENGINE=InnoDB CHARSET=utf8
    "
);
   
$pdo->exec("
        CREATE TABLE multiselect_has_users (
            group_id INT NOT NULL,
            user_id INT 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)
        ) ENGINE=InnoDB CHARSET=utf8
    "
);
}

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

For more information send a message to info at phpclasses dot org.