diff options
author | Alexander Sulfrian <alex@spline.inf.fu-berlin.de> | 2015-01-25 19:08:16 +0100 |
---|---|---|
committer | Alexander Sulfrian <alex@spline.inf.fu-berlin.de> | 2015-01-25 19:16:02 +0100 |
commit | 443c1d93ea7847355e78bd524955d9051bca96d0 (patch) | |
tree | 153623f243dda01a783d2ac9a58dfa267c1aa153 /Kernel | |
parent | dc3c36a7b3893ad6b8e9724dc00b679e1ead23c2 (diff) | |
download | DefaultRecipient-443c1d93ea7847355e78bd524955d9051bca96d0.tar.gz DefaultRecipient-443c1d93ea7847355e78bd524955d9051bca96d0.tar.bz2 DefaultRecipient-443c1d93ea7847355e78bd524955d9051bca96d0.zip |
Rename table columns.
"to" is a reserved word in postgres and so it could not used as column
name.
Diffstat (limited to 'Kernel')
-rw-r--r-- | Kernel/System/DefaultRecipient.pm | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Kernel/System/DefaultRecipient.pm b/Kernel/System/DefaultRecipient.pm index fec60fd..1c052cf 100644 --- a/Kernel/System/DefaultRecipient.pm +++ b/Kernel/System/DefaultRecipient.pm @@ -47,7 +47,7 @@ sub Add { # insert new DefaultRecipient return if !$DBObject->Do( SQL => 'INSERT INTO default_recipient ' - . '(title, remove_to, to, cc, bcc, comments, ' + . '(title, remove_to, to_addr, cc_addr, bcc_addr, comments, ' . ' create_time, create_by, change_time, change_by) ' . 'VALUES (?, ?, ?, ?, ?, ?, ' . 'current_timestamp, ?, current_timestamp, ?)', @@ -105,7 +105,7 @@ sub Update { # insert new DefaultRecipient return if !$DBObject->Do( SQL => 'UPDATE default_recipient SET title = ?, remove_to = ?, ' - . 'to = ?, cc = ?, bcc = ?, comments = ?, ' + . 'to_addr = ?, cc_addr = ?, bcc_addr = ?, comments = ?, ' . 'change_by = ?, change_time = current_timestamp ' . 'WHERE id = ?', Bind => [ @@ -140,7 +140,7 @@ sub Get { # get RrsponseChangeDefaultTO obejct return if !$DBObject->Prepare( - SQL => 'SELECT id, title, remove_to, to, cc, bcc, ' + SQL => 'SELECT id, title, remove_to, to_addr, cc_addr, bcc_addr, ' . 'comments, create_time, create_by, change_time, change_by ' . 'FROM default_recipient WHERE id = ?', Bind => [ \$Param{ID} ], |