diff options
| author | Andreas Baumann <mail@andreasbaumann.cc> | 2019-11-17 20:45:02 +0100 |
|---|---|---|
| committer | Andreas Baumann <mail@andreasbaumann.cc> | 2019-11-17 20:45:02 +0100 |
| commit | 8df3db566a3a937b45ebf11adb90d265e6f5e2d4 (patch) | |
| tree | 4d541098d751d5a9acf8c12f6fb9f308ace066ac /setup/upgrade/0.9.9/rename_columns.php | |
| download | flyspray-8df3db566a3a937b45ebf11adb90d265e6f5e2d4.tar.xz | |
initial checking of customized version 1.0rc9
Diffstat (limited to 'setup/upgrade/0.9.9/rename_columns.php')
| -rw-r--r-- | setup/upgrade/0.9.9/rename_columns.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/setup/upgrade/0.9.9/rename_columns.php b/setup/upgrade/0.9.9/rename_columns.php new file mode 100644 index 0000000..07a949a --- /dev/null +++ b/setup/upgrade/0.9.9/rename_columns.php @@ -0,0 +1,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); + +?>
\ No newline at end of file |