summaryrefslogtreecommitdiff
path: root/setup/upgrade/0.9.9/rename_columns.php
blob: 07a949aca7b3b30e71e540d621dff9a9ac287124 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
   /**********************************************************\
   | This script renames columns, adodb seems to have prob here|
   \**********************************************************/

$dict = NewDataDictionary($db->dblink);

$sqlarray = $dict->RenameColumnSQL($conf['database']['dbprefix'] . 'tasks', 'attached_to_project', 'project_id', 'TYPE INT(3) NOTNULL  DEFAULT 0');
$dict->ExecuteSQLArray($sqlarray);

$sqlarray = $dict->RenameColumnSQL($conf['database']['dbprefix'] . 'groups', 'belongs_to_project', 'project_id', ' TYPE INT(3) NOTNULL  DEFAULT 0');
$dict->ExecuteSQLArray($sqlarray);

?>