diff options
author | Christopher Burger <burgerc@freeside.biz> | 2018-01-23 14:05:02 -0500 |
---|---|---|
committer | Christopher Burger <burgerc@freeside.biz> | 2018-02-01 11:21:01 -0500 |
commit | 363ec7a60a60634f59046276264bb663bb3b2b72 (patch) | |
tree | c76b6b89d917824ae55c9dfdca4d89b608d4889b /FS/FS/cdr | |
parent | 2f1002b23f483e25dc193a4f060e385bdc30dccc (diff) |
RT# 76398 - fixed sybase query for detecting tables and adding columns
Diffstat (limited to 'FS/FS/cdr')
-rw-r--r-- | FS/FS/cdr/Import.pm | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/FS/FS/cdr/Import.pm b/FS/FS/cdr/Import.pm index aa5f5744f..c0c192f40 100644 --- a/FS/FS/cdr/Import.pm +++ b/FS/FS/cdr/Import.pm @@ -195,9 +195,7 @@ sub get_queries { #Check for freeside status table Sybase has not been tested my %dbi_check_statustable = ( - 'Sybase' => "SELECT systables.name FROM sysobjects - JOIN systables ON sysobjects.id = systables.id - WHERE sysobjects.name LIKE '$info->{table}' AND systables.name = $info->{status_table}", + 'Sybase' => "SELECT * FROM sysobjects WHERE name = $info->{status_table}", 'Pg' => "SELECT * FROM information_schema.columns WHERE table_schema = 'public' AND table_name = '$info->{status_table}' AND column_name = '$info->{status_column}'", ); @@ -217,7 +215,7 @@ sub get_queries { #Check for freeside status column Sybase has not been tested my %dbi_create_statuscolumn = ( - 'Sybase' => "ALTER TABLE $info->{table} ADD COLUMN $info->{status_column} $info->{status_column_info}", + 'Sybase' => "ALTER TABLE $info->{table} ADD $info->{status_column} $info->{status_column_info}", 'Pg' => "ALTER TABLE $info->{table} ADD COLUMN $info->{status_column} $info->{status_column_info}", ); |