User Tools

Site Tools


avaya:breeze:workplaceattendantdb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
avaya:breeze:workplaceattendantdb [2025/06/12 15:11] – created reto1avaya:breeze:workplaceattendantdb [2026/01/20 21:45] (current) – external edit 127.0.0.1
Line 6: Line 6:
   UPDATE db_instance SET schema_version = '4-2-0' where name='attendant_attendantdb';   UPDATE db_instance SET schema_version = '4-2-0' where name='attendant_attendantdb';
 Normally not used!  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;

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.

avaya/breeze/workplaceattendantdb.1749741102.txt.gz · Last modified: (external edit)