This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Fix Workplace Attendant DB for Upgrade ======
__PGSQL Login__
  psql -p 5433 -U hadb -d attendant_attendantdb
  select * from db_instance ;
#Manual Schema Update:
  UPDATE db_instance SET schema_version = '4-2-0' where name='attendant_attendantdb';
Normally not used! 

__**IF Schema Version 2-0-11:**__
  UPDATE public.tbl_external_db SET db_id = '1' where db_id='0';
  ALTER TABLE tbl_statisticdata_daily drop column if exists outgoingcalls cascade;
  DROP Table  tbl_geo_replication_failed;
  DROP INDEX tbl_attduser_columns_attidviewid;
  DROP INDEX tbl_attendant_users_callnumber;
  DROP INDEX callstarttime_day;
  DROP INDEX tbl_dictionary_businessphone1_u;
  DROP INDEX tbl_notes_e164number;
  DROP INDEX tbl_numbercache_shadownumber;
  DROP INDEX tbl_numbercache_shadownumber_fiid3;
  DROP INDEX tbl_operatorhistory_usr_id;
  DROP INDEX tbl_speeddial_userid;
  DROP INDEX topic_callstarttime_day;
  DROP INDEX tbl_topic_history_callsessionid;

Detach Close

This topic does not exist yet

You've followed a link to a topic that doesn't exist yet. If permissions allow, you may create it by clicking on Create this page.