srchub

srchub Git Source Tree


Root/indefero/src/IDF/Migrations/34GitSSHTracking.php

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
 
function IDF_Migrations_34GitSSHTracking_up()
{
    $table = Pluf::factory('IDF_Key')->getSqlTable();
 
    $sql = array();
 
    $sql["MySQL"] = <<<EOD
ALTER TABLE `$table`
    ADD COLUMN `last_used` DATETIME NOT NULL AFTER `content`,
    ADD COLUMN `creation_dtime` DATETIME NOT NULL AFTER `last_used`,
    ADD COLUMN `ipaddress` VARCHAR(255) NOT NULL AFTER `creation_dtime`,
    ADD INDEX `last_used` (`last_used`),
    ADD INDEX `creation_dtime` (`creation_dtime`);
 
UPDATE indefero_idf_keys SET creation_dtime = '2016-04-30 03:19:54';
EOD;
 
 
    $db = Pluf::db();
    $engine = Pluf::f('db_engine');
 
    $db->execute($sql[$engine]);
}
 
function IDF_Migrations_34GitSSHTracking_down()
{
    $table = Pluf::factory('IDF_Key')->getSqlTable();
 
    $sql = array();
 
    $sql["MySQL"] = <<<EOD
ALTER TABLE `$table`
    DROP COLUMN `last_used` DATETIME NOT NULL AFTER `content`,
    DROP COLUMN `creation_dtime` DATETIME NOT NULL AFTER `last_used`,
    DROP COLUMN `ipaddress` VARCHAR(255) NOT NULL AFTER `creation_dtime`,
    DROP INDEX `last_used` (`last_used`),
    DROP INDEX `creation_dtime` (`creation_dtime`);
EOD;
 
 
    $db = Pluf::db();
    $engine = Pluf::f('db_engine');
 
    $db->execute($sql[$engine]);
}

Archive Download this file

Branches

Number of commits:
Page rendered in 0.26467s using 11 queries.