From 8df3db566a3a937b45ebf11adb90d265e6f5e2d4 Mon Sep 17 00:00:00 2001
From: Andreas Baumann <mail@andreasbaumann.cc>
Date: Sun, 17 Nov 2019 20:45:02 +0100
Subject: initial checking of customized version 1.0rc9

---
 setup/upgrade/0.9.9/rename_columns.php | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 setup/upgrade/0.9.9/rename_columns.php

(limited to 'setup/upgrade/0.9.9/rename_columns.php')

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
-- 
cgit v1.2.3-54-g00ecf