process->pass(): #1 for upgrade processing process->upgrade(): Incoming : appname: phpgwapi, version: 1.8.007, status: U  process->upgrade(): phpgwapi(1.8.007 --> 14.3.909): running phpgwapi_upgrade1_8_007() --> 1.9.013  process->upgrade(): phpgwapi(1.9.013 --> 14.3.909): running phpgwapi_upgrade1_9_013() --> 1.9.014  process->upgrade(): phpgwapi(1.9.014 --> 14.3.909): running phpgwapi_upgrade1_9_014() --> 1.9.015  process->upgrade(): phpgwapi(1.9.015 --> 14.3.909): running phpgwapi_upgrade1_9_015() --> 1.9.016  process->upgrade(): phpgwapi(1.9.016 --> 14.3.909): running phpgwapi_upgrade1_9_016() --> 1.9.017  process->upgrade(): phpgwapi(1.9.017 --> 14.3.909): running phpgwapi_upgrade1_9_017() --> 1.9.018  process->upgrade(): phpgwapi(1.9.018 --> 14.3.909): running phpgwapi_upgrade1_9_018() --> 1.9.019  process->upgrade(): phpgwapi(1.9.019 --> 14.3.909): running phpgwapi_upgrade1_9_019() --> 1.9.020  process->upgrade(): phpgwapi(1.9.020 --> 14.3.909): running phpgwapi_upgrade1_9_020() --> 1.9.021  process->upgrade(): phpgwapi(1.9.021 --> 14.3.909): running phpgwapi_upgrade1_9_021() --> 14.1  process->upgrade(): phpgwapi(14.1 --> 14.3.909): running phpgwapi_upgrade14_1() --> 14.1.900  process->upgrade(): phpgwapi(14.1.900 --> 14.3.909): running phpgwapi_upgrade14_1_900() --> 14.2  process->upgrade(): phpgwapi(14.2 --> 14.3.909): running phpgwapi_upgrade14_2() --> 14.2.001  process->upgrade(): phpgwapi(14.2.001 --> 14.3.909): running phpgwapi_upgrade14_2_001() --> 14.2.002  process->upgrade(): phpgwapi(14.2.002 --> 14.3.909): running phpgwapi_upgrade14_2_002() --> 14.2.003  process->upgrade(): phpgwapi(14.2.003 --> 14.3.909): running phpgwapi_upgrade14_2_003() --> 14.2.004  process->upgrade(): phpgwapi(14.2.004 --> 14.3.909): running phpgwapi_upgrade14_2_004() --> 14.2.005  process->upgrade(): phpgwapi(14.2.005 --> 14.3.909): running phpgwapi_upgrade14_2_005() --> 14.2.006  process->upgrade(): phpgwapi(14.2.006 --> 14.3.909): running phpgwapi_upgrade14_2_006() --> 14.2.007  process->upgrade(): phpgwapi(14.2.007 --> 14.3.909): running phpgwapi_upgrade14_2_007() --> 14.2.008  process->upgrade(): phpgwapi(14.2.008 --> 14.3.909): running phpgwapi_upgrade14_2_008() --> 14.2.009  process->upgrade(): phpgwapi(14.2.009 --> 14.3.909): running phpgwapi_upgrade14_2_009() --> 14.2.010  process->upgrade(): phpgwapi(14.2.010 --> 14.3.909): running phpgwapi_upgrade14_2_010() --> 14.2.011  process->upgrade(): phpgwapi(14.2.011 --> 14.3.909): running phpgwapi_upgrade14_2_011() --> 14.2.012  process->upgrade(): phpgwapi(14.2.012 --> 14.3.909): running phpgwapi_upgrade14_2_012() --> 14.2.013  process->upgrade(): phpgwapi(14.2.013 --> 14.3.909): running phpgwapi_upgrade14_2_013() --> 14.2.014  process->upgrade(): phpgwapi(14.2.014 --> 14.3.909): running phpgwapi_upgrade14_2_014() --> 14.2.015  process->upgrade(): phpgwapi(14.2.015 --> 14.3.909): running phpgwapi_upgrade14_2_015() --> 14.2.016  process->upgrade(): phpgwapi(14.2.016 --> 14.3.909): running phpgwapi_upgrade14_2_016() --> 14.2.017  process->upgrade(): phpgwapi(14.2.017 --> 14.3.909): running phpgwapi_upgrade14_2_017() --> 14.2.018  process->upgrade(): phpgwapi(14.2.018 --> 14.3.909): running phpgwapi_upgrade14_2_018() --> 14.2.019  process->upgrade(): phpgwapi(14.2.019 --> 14.3.909): running phpgwapi_upgrade14_2_019() --> 14.2.020  process->upgrade(): phpgwapi(14.2.020 --> 14.3.909): running phpgwapi_upgrade14_2_020() --> 14.2.021  process->upgrade(): phpgwapi(14.2.021 --> 14.3.909): running phpgwapi_upgrade14_2_021() --> 14.2.022  process->upgrade(): phpgwapi(14.2.022 --> 14.3.909): running phpgwapi_upgrade14_2_022() --> 14.2.023  process->upgrade(): phpgwapi(14.2.023 --> 14.3.909): running phpgwapi_upgrade14_2_023() --> 14.2.024  process->upgrade(): phpgwapi(14.2.024 --> 14.3.909): running phpgwapi_upgrade14_2_024() --> 14.2.025  process->upgrade(): phpgwapi(14.2.025 --> 14.3.909): running phpgwapi_upgrade14_2_025() --> 14.2.026  process->upgrade(): phpgwapi(14.2.026 --> 14.3.909): running phpgwapi_upgrade14_2_026() --> 14.3  process->upgrade(): phpgwapi(14.3 --> 14.3.909): running phpgwapi_upgrade14_3() --> 14.3.001  process->upgrade(): phpgwapi(14.3.001 --> 14.3.909): running phpgwapi_upgrade14_3_001() --> 14.3.002  process->upgrade(): phpgwapi(14.3.002 --> 14.3.909): running phpgwapi_upgrade14_3_002() --> 14.3.003  process->upgrade(): phpgwapi(14.3.003 --> 14.3.909): running phpgwapi_upgrade14_3_003() --> 14.3.004  process->upgrade(): phpgwapi(14.3.004 --> 14.3.909): running phpgwapi_upgrade14_3_004() --> 14.3.005  process->upgrade(): phpgwapi(14.3.005 --> 14.3.909): running phpgwapi_upgrade14_3_005() --> 14.3.006  process->upgrade(): phpgwapi(14.3.006 --> 14.3.909): running phpgwapi_upgrade14_3_006() --> 14.3.007  process->upgrade(): phpgwapi(14.3.007 --> 14.3.909): running phpgwapi_upgrade14_3_007() --> 14.3.900  process->upgrade(): phpgwapi(14.3.900 --> 14.3.909): running phpgwapi_upgrade14_3_900() --> 14.3.901  process->upgrade(): phpgwapi(14.3.901 --> 14.3.909): running phpgwapi_upgrade14_3_901() --> 14.3.902  process->upgrade(): phpgwapi(14.3.902 --> 14.3.909): running phpgwapi_upgrade14_3_902() --> 14.3.903  process->upgrade(): phpgwapi(14.3.903 --> 14.3.909): running phpgwapi_upgrade14_3_903() --> 14.3.904  process->upgrade(): phpgwapi(14.3.904 --> 14.3.909): running phpgwapi_upgrade14_3_904() --> 14.3.905  process->upgrade(): phpgwapi(14.3.905 --> 14.3.909): running phpgwapi_upgrade14_3_905() --> 14.3.906  process->upgrade(): phpgwapi(14.3.906 --> 14.3.909): running phpgwapi_upgrade14_3_906() --> 14.3.907  process->upgrade(): phpgwapi(14.3.907 --> 14.3.909): running phpgwapi_upgrade14_3_907() --> 14.3.908  process->upgrade(): phpgwapi(14.3.908 --> 14.3.909): running phpgwapi_upgrade14_3_908() --> 14.3.909  process->upgrade(): Upgrade of phpgwapi to 14.3.909 is completed.  process->upgrade(): Outgoing : appname: phpgwapi, status: C process->upgrade(): Incoming : appname: emailadmin, version: 1.9.006, status: U  process->upgrade(): emailadmin(1.9.006 --> 14.3.001): running emailadmin_upgrade1_9_006() --> 1.9.007  process->upgrade(): emailadmin(1.9.007 --> 14.3.001): running emailadmin_upgrade1_9_007() --> 1.9.008  process->upgrade(): emailadmin(1.9.008 --> 14.3.001): running emailadmin_upgrade1_9_008() --> 1.9.009  process->upgrade(): emailadmin(1.9.009 --> 14.3.001): running emailadmin_upgrade1_9_009() --> 1.9.010  process->upgrade(): emailadmin(1.9.010 --> 14.3.001): running emailadmin_upgrade1_9_010() --> 1.9.011  process->upgrade(): emailadmin(1.9.011 --> 14.3.001): running emailadmin_upgrade1_9_011() --> 1.9.015  process->upgrade(): emailadmin(1.9.015 --> 14.3.001): running emailadmin_upgrade1_9_015() --> 1.9.016  process->upgrade(): emailadmin(1.9.016 --> 14.3.001): running emailadmin_upgrade1_9_016() --> 1.9.017  process->upgrade(): emailadmin(1.9.017 --> 14.3.001): running emailadmin_upgrade1_9_017() --> 1.9.018  process->upgrade(): emailadmin(1.9.018 --> 14.3.001): running emailadmin_upgrade1_9_018() --> 1.9.019  process->upgrade(): emailadmin(1.9.019 --> 14.3.001): running emailadmin_upgrade1_9_019() --> 14.1  process->upgrade(): emailadmin(14.1 --> 14.3.001): running emailadmin_upgrade14_1() --> 14.2  process->upgrade(): emailadmin(14.2 --> 14.3.001): running emailadmin_upgrade14_2() --> 14.2.001  process->upgrade(): emailadmin(14.2.001 --> 14.3.001): running emailadmin_upgrade14_2_001() --> 14.3  process->upgrade(): emailadmin(14.3 --> 14.3.001): running emailadmin_upgrade14_3() --> 14.3.001  process->upgrade(): Upgrade of emailadmin to 14.3.001 is completed.  process->upgrade(): Outgoing : appname: emailadmin, status: C process->upgrade(): Incoming : appname: api, version: 14.3.907, status: U  process->upgrade(): api(14.3.907 --> 17.1.003): running api_upgrade14_3_907() --> 16.1  process->upgrade(): api(16.1 --> 17.1.003): running api_upgrade16_1() --> 16.1.001  process->upgrade(): api(16.1.001 --> 17.1.003): running api_upgrade16_1_001() --> 16.1.002  process->upgrade(): api(16.1.002 --> 17.1.003): running api_upgrade16_1_002() --> 16.1.003  process->upgrade(): api(16.1.003 --> 17.1.003): running api_upgrade16_1_003() --> 16.1.004  process->upgrade(): api(16.1.004 --> 17.1.003): running api_upgrade16_1_004() --> 16.1.005  process->upgrade(): api(16.1.005 --> 17.1.003): running api_upgrade16_1_005() --> 16.9  process->upgrade(): api(16.9 --> 17.1.003): running api_upgrade16_9() --> 16.9.001  process->upgrade(): api(16.9.001 --> 17.1.003): running api_upgrade16_9_001() --> 16.9.002  process->upgrade(): api(16.9.002 --> 17.1.003): running api_upgrade16_9_002() --> 16.9.003  process->upgrade(): api(16.9.003 --> 17.1.003): running api_upgrade16_9_003() --> 16.9.004  process->upgrade(): api(16.9.004 --> 17.1.003): running api_upgrade16_9_004() --> 17.1  process->upgrade(): api(17.1 --> 17.1.003): running api_upgrade17_1() --> 17.1.001  process->upgrade(): api(17.1.001 --> 17.1.003): running api_upgrade17_1_001() --> 17.1.002  process->upgrade(): api(17.1.002 --> 17.1.003): running api_upgrade17_1_002() --> 17.1.003  process->upgrade(): Upgrade of api to 17.1.003 is completed.  process->upgrade(): Outgoing : appname: api, status: C process->upgrade(): Incoming : appname: admin, version: 1.8, status:  process->upgrade(): admin(1.8 --> 17.1): running admin_upgrade1_8() --> 1.9.001  process->upgrade(): admin(1.9.001 --> 17.1): running admin_upgrade1_9_001() --> 14.1  process->upgrade(): admin(14.1 --> 17.1): running admin_upgrade14_1() --> 14.2.001  process->upgrade(): admin(14.2.001 --> 17.1): running admin_upgrade14_2_001() --> 14.3  process->upgrade(): admin(14.3 --> 17.1): running admin_upgrade14_3() --> 14.3.001  process->upgrade(): admin(14.3.001 --> 17.1): running admin_upgrade14_3_001() --> 16.1  process->upgrade(): admin(16.1 --> 17.1): running admin_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of admin to 17.1 is completed.  process->upgrade(): Outgoing : appname: admin, status: C process->upgrade(): Incoming : appname: preferences, version: 1.8, status:  process->upgrade(): No table upgrade required/availible for preferences  process->upgrade(): Outgoing : appname: preferences, status: C process->upgrade(): Incoming : appname: etemplate, version: 1.8, status:  process->upgrade(): etemplate(1.8 --> 14.1): running etemplate_upgrade1_8() --> 14.1  process->upgrade(): Upgrade of etemplate to 14.1 is completed.  process->upgrade(): Outgoing : appname: etemplate, status: C process->upgrade(): Application not installed: archive process->upgrade(): Incoming : appname: groupdav, version: 1.8, status: U  process->upgrade(): No table upgrade required/availible for groupdav  process->upgrade(): Outgoing : appname: groupdav, status: C process->pass(): phpgwapi skipped on this pass  process->pass(): emailadmin skipped on this pass  process->pass(): api skipped on this pass  process->pass(): admin skipped on this pass  process->pass(): preferences skipped on this pass  process->pass(): etemplate skipped on this pass  process->pass(): groupdav skipped on this pass  process->pass(): #2 for upgrade processing  process->current(): Incoming status: activesync,status: U process->current(): Including: /var/www/vhosts/xxxxxxx/egroupware/activesync/setup/tables_current.inc.php schema_proc::CreateTable('egw_zpush_states', Array ( [fd] => Array ( [id_state] => Array ( [type] => auto [precision] => 4 [nullable] => ) [device_id] => Array ( [type] => ascii [precision] => 50 [nullable] => ) [uuid] => Array ( [type] => ascii [precision] => 50 ) [state_type] => Array ( [type] => ascii [precision] => 50 ) [counter] => Array ( [type] => int [precision] => 4 ) [state_data] => Array ( [type] => blob ) [created_at] => Array ( [type] => timestamp [meta] => timestamp [nullable] => ) [updated_at] => Array ( [type] => timestamp [meta] => timestamp [nullable] => ) ) [pk] => Array ( [0] => id_state ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( [0] => Array ( [0] => device_id [1] => uuid [2] => state_type [3] => counter ) ) ) ) CreateTableSQL('egw_zpush_states','id_state I AUTOINCREMENT NOTNULL PRIMARY, device_id C(50) CONSTRAINT "CHARACTER SET ascii" NOTNULL, uuid C(50) CONSTRAINT "CHARACTER SET ascii", state_type C(50) CONSTRAINT "CHARACTER SET ascii", counter I4, state_data B, created_at T NOTNULL, updated_at T NOTNULL') sql=Array ( [0] => CREATE TABLE `egw_zpush_states` ( `id_state` INTEGER NOT NULL AUTO_INCREMENT, `device_id` VARCHAR(50) CHARACTER SET ascii NOT NULL, `uuid` VARCHAR(50) CHARACTER SET ascii, `state_type` VARCHAR(50) CHARACTER SET ascii, `counter` INTEGER, `state_data` LONGBLOB, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, PRIMARY KEY (`id_state`) )CHARACTER SET utf8 )  CreateIndexSQL('egw_zpush_states',Array ( [0] => device_id [1] => uuid [2] => state_type [3] => counter ) ,Array ( [0] => UNIQUE ) ,'egw_zpush_states_device_id_uuid_state_type_counter') sql=Array ( [0] => ALTER TABLE `egw_zpush_states` ADD UNIQUE INDEX `egw_zpush_states_device_id_uuid_state_type_counter` (`device_id`, `uuid`, `state_type`, `counter`) )  Create Table egw_zpush_states schema_proc::CreateTable('egw_zpush_users', Array ( [fd] => Array ( [username] => Array ( [type] => varchar [precision] => 50 [nullable] => ) [device_id] => Array ( [type] => ascii [precision] => 50 [nullable] => ) ) [pk] => Array ( ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( [0] => Array ( [0] => username [1] => device_id ) ) ) ) CreateTableSQL('egw_zpush_users','username C(50) NOTNULL, device_id C(50) CONSTRAINT "CHARACTER SET ascii" NOTNULL') sql=Array ( [0] => CREATE TABLE `egw_zpush_users` ( `username` VARCHAR(50) NOT NULL, `device_id` VARCHAR(50) CHARACTER SET ascii NOT NULL )CHARACTER SET utf8 )  CreateIndexSQL('egw_zpush_users',Array ( [0] => username [1] => device_id ) ,Array ( [0] => UNIQUE ) ,'egw_zpush_users_username_device_id') sql=Array ( [0] => ALTER TABLE `egw_zpush_users` ADD UNIQUE INDEX `egw_zpush_users_username_device_id` (`username`, `device_id`) )  Create Table egw_zpush_users schema_proc::CreateTable('egw_zpush_settings', Array ( [fd] => Array ( [key_name] => Array ( [type] => ascii [precision] => 50 [nullable] => ) [key_value] => Array ( [type] => varchar [precision] => 50 [nullable] => ) [created_at] => Array ( [type] => timestamp [meta] => timestamp [nullable] => ) [updated_at] => Array ( [type] => timestamp [meta] => timestamp [nullable] => ) ) [pk] => Array ( [0] => key_name ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) ) CreateTableSQL('egw_zpush_settings','key_name C(50) CONSTRAINT "CHARACTER SET ascii" NOTNULL PRIMARY, key_value C(50) NOTNULL, created_at T NOTNULL, updated_at T NOTNULL') sql=Array ( [0] => CREATE TABLE `egw_zpush_settings` ( `key_name` VARCHAR(50) CHARACTER SET ascii NOT NULL, `key_value` VARCHAR(50) NOT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NOT NULL, PRIMARY KEY (`key_name`) )CHARACTER SET utf8 )  Create Table egw_zpush_settings process->current(): Outgoing status: activesync,status: C process->default_records(): Including default records for activesync process->upgrade(): Incoming : appname: addressbook, version: 1.8, status: U  process->upgrade(): No table upgrade required/availible for addressbook  process->upgrade(): Outgoing : appname: addressbook, status: C process->upgrade(): Application not installed: archive process->upgrade(): Incoming : appname: calendar, version: 1.9.004, status: U  process->upgrade(): calendar(1.9.004 --> 17.1.001): running calendar_upgrade1_9_004() AlterColumnSQL('egw_cal_dates','recur_exception',Array ( [type] => bool [default] => [null] => [comment] => date is an exception ) ) sql=Array ( [0] => ALTER TABLE `egw_cal_dates` ADD `recur_exception` TINYINT DEFAULT 0 )  CreateIndexSQL('egw_cal_dates',Array ( [0] => recur_exception [1] => cal_id ) ,Array ( ) ,'egw_cal_dates_recur_exception_id') sql=Array ( [0] => ALTER TABLE `egw_cal_dates` ADD INDEX `egw_cal_dates_recur_exception_id` (`recur_exception`, `cal_id`) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_repeats') = NULL schema_proc::GetTableDefintion('egw_cal_repeats') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [recur_type] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [recur_enddate] => Array ( [type] => int [precision] => 8 ) [recur_interval] => Array ( [type] => int [precision] => 2 [default] => 1 ) [recur_data] => Array ( [type] => int [precision] => 2 [default] => 1 ) [recur_exception] => Array ( [type] => text ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) DropColumnSQL('egw_cal_repeats','recur_exception','cal_id I4 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, recur_type I2 NOTNULL NOQUOTE DEFAULT 0, recur_enddate I8, recur_interval I2 NOQUOTE DEFAULT 1, recur_data I2 NOQUOTE DEFAULT 1') sql=Array ( [0] => ALTER TABLE `egw_cal_repeats` DROP COLUMN `recur_exception` )  --> 1.9.005  process->upgrade(): calendar(1.9.005 --> 17.1.001): running calendar_upgrade1_9_005() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 255 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 30 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [default] => 1 [nullable] => ) [cal_description] => Array ( [type] => text ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 64 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','cal_description C(16384)','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(30) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL DEFAULT '1', cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(64) CONSTRAINT "CHARACTER SET ascii"') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `cal_description` VARCHAR(16384) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 255 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 30 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [default] => 1 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 64 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','cal_category C(64)','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64), cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL DEFAULT '1', cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(64) CONSTRAINT "CHARACTER SET ascii"') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `cal_category` VARCHAR(64) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 255 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 64 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [default] => 1 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 64 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','cal_title C(255) NOTNULL','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL, cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(64) CONSTRAINT "CHARACTER SET ascii"') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `cal_title` VARCHAR(255) NOT NULL )  --> 1.9.006  process->upgrade(): calendar(1.9.006 --> 17.1.001): running calendar_upgrade1_9_006() AlterColumnSQL('egw_cal','range_start',Array ( [type] => int [precision] => 8 [comment] => startdate (of range) ) ) sql=Array ( [0] => ALTER TABLE `egw_cal` ADD `range_start` BIGINT )  AlterColumnSQL('egw_cal','range_end',Array ( [type] => int [precision] => 8 [comment] => enddate (of range, UNTIL of RRULE) ) ) sql=Array ( [0] => ALTER TABLE `egw_cal` ADD `range_end` BIGINT )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_repeats') = NULL schema_proc::GetTableDefintion('egw_cal_repeats') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [recur_type] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [recur_enddate] => Array ( [type] => int [precision] => 8 ) [recur_interval] => Array ( [type] => int [precision] => 2 [default] => 1 ) [recur_data] => Array ( [type] => int [precision] => 2 [default] => 1 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) DropColumnSQL('egw_cal_repeats','recur_enddate','cal_id I4 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, recur_type I2 NOTNULL NOQUOTE DEFAULT 0, recur_interval I2 NOQUOTE DEFAULT 1, recur_data I2 NOQUOTE DEFAULT 1') sql=Array ( [0] => ALTER TABLE `egw_cal_repeats` DROP COLUMN `recur_enddate` )  --> 1.9.007  process->upgrade(): calendar(1.9.007 --> 17.1.001): running calendar_upgrade1_9_007() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 255 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 64 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 64 ) [range_start] => Array ( [type] => int [precision] => 8 ) [range_end] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','range_start I8 NOTNULL','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL, cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(64) CONSTRAINT "CHARACTER SET ascii", range_start I8 NOTNULL, range_end I8') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `range_start` BIGINT NOT NULL )  --> 1.9.008  process->upgrade(): calendar(1.9.008 --> 17.1.001): running calendar_upgrade1_9_008() --> 1.9.009  process->upgrade(): calendar(1.9.009 --> 17.1.001): running calendar_upgrade1_9_009() CreateIndexSQL('egw_cal',Array ( [0] => cal_reference ) ,Array ( ) ,'egw_cal_reference') sql=Array ( [0] => ALTER TABLE `egw_cal` ADD INDEX `egw_cal_reference` (`cal_reference`) )  --> 1.9.010  process->upgrade(): calendar(1.9.010 --> 17.1.001): running calendar_upgrade1_9_010() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 255 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 64 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 64 ) [range_start] => Array ( [type] => int [precision] => 8 [nullable] => ) [range_end] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified [5] => cal_reference ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','caldav_name C(200)','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL, cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(200), range_start I8 NOTNULL, range_end I8') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `caldav_name` VARCHAR(200) )  --> 1.9.011  process->upgrade(): calendar(1.9.011 --> 17.1.001): running calendar_upgrade1_9_011() --> 14.1  process->upgrade(): calendar(14.1 --> 17.1.001): running calendar_upgrade14_1() --> 14.1.001  process->upgrade(): calendar(14.1.001 --> 17.1.001): running calendar_upgrade14_1_001() --> 14.2.002  process->upgrade(): calendar(14.2.002 --> 17.1.001): running calendar_upgrade14_2_002() --> 14.2.003  process->upgrade(): calendar(14.2.003 --> 17.1.001): running calendar_upgrade14_2_003() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 255 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 64 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [range_start] => Array ( [type] => int [precision] => 8 [nullable] => ) [range_end] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified [5] => cal_reference ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','cal_uid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL, cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(200) CONSTRAINT "CHARACTER SET ascii", range_start I8 NOTNULL, range_end I8') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `cal_uid` VARCHAR(128) CHARACTER SET ascii NOT NULL )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 128 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 64 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [range_start] => Array ( [type] => int [precision] => 8 [nullable] => ) [range_end] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified [5] => cal_reference ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','cal_category C(64) CONSTRAINT "CHARACTER SET ascii"','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL, cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(200) CONSTRAINT "CHARACTER SET ascii", range_start I8 NOTNULL, range_end I8') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `cal_category` VARCHAR(64) CHARACTER SET ascii )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal') = NULL schema_proc::GetTableDefintion('egw_cal') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => auto [nullable] => ) [cal_uid] => Array ( [type] => ascii [precision] => 128 [nullable] => ) [cal_owner] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_category] => Array ( [type] => ascii [precision] => 64 ) [cal_modified] => Array ( [type] => int [precision] => 8 ) [cal_priority] => Array ( [type] => int [precision] => 2 [default] => 2 [nullable] => ) [cal_public] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) [cal_title] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [cal_description] => Array ( [type] => varchar [precision] => 16384 ) [cal_location] => Array ( [type] => varchar [precision] => 255 ) [cal_reference] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_modifier] => Array ( [type] => int [precision] => 4 ) [cal_non_blocking] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_special] => Array ( [type] => int [precision] => 2 [default] => 0 ) [cal_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [cal_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [cal_recurrence] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [tz_id] => Array ( [type] => int [precision] => 4 ) [cal_deleted] => Array ( [type] => int [precision] => 8 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [range_start] => Array ( [type] => int [precision] => 8 [nullable] => ) [range_end] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => cal_id ) [fk] => Array ( ) [ix] => Array ( [0] => cal_uid [1] => cal_owner [2] => cal_deleted [3] => caldav_name [4] => cal_modified [5] => cal_reference ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal','caldav_name C(128) CONSTRAINT "CHARACTER SET ascii"','cal_id I AUTOINCREMENT NOTNULL PRIMARY, cal_uid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_owner I4 NOTNULL, cal_category C(64) CONSTRAINT "CHARACTER SET ascii", cal_modified I8, cal_priority I2 NOTNULL NOQUOTE DEFAULT 2, cal_public I2 NOTNULL NOQUOTE DEFAULT 1, cal_title C(255) NOTNULL, cal_description C(16384), cal_location C(255), cal_reference I4 NOTNULL NOQUOTE DEFAULT 0, cal_modifier I4, cal_non_blocking I2 NOQUOTE DEFAULT 0, cal_special I2 NOQUOTE DEFAULT 0, cal_etag I4 NOQUOTE DEFAULT 0, cal_creator I4 NOTNULL, cal_created I8 NOTNULL, cal_recurrence I8 NOTNULL NOQUOTE DEFAULT 0, tz_id I4, cal_deleted I8, caldav_name C(128) CONSTRAINT "CHARACTER SET ascii", range_start I8 NOTNULL, range_end I8') sql=Array ( [0] => ALTER TABLE `egw_cal` MODIFY COLUMN `caldav_name` VARCHAR(128) CHARACTER SET ascii )  --> 14.2.004  process->upgrade(): calendar(14.2.004 --> 17.1.001): running calendar_upgrade14_2_004() schema_proc::RefreshTable('egw_cal_user', Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_recur_date] => Array ( [type] => int [meta] => timestamp [precision] => 8 [nullable] => [default] => 0 ) [cal_user_type] => Array ( [type] => ascii [precision] => 1 [nullable] => [default] => u [comment] => u=user, g=group, c=contact, r=resource, e=email ) [cal_user_id] => Array ( [type] => varchar [meta] => Array ( [cal_user_type='u'] => account ) [precision] => 128 [nullable] => [comment] => id or email-address for type=e ) [cal_status] => Array ( [type] => ascii [precision] => 1 [default] => A [comment] => U=unknown, A=accepted, R=rejected, T=tentative ) [cal_quantity] => Array ( [type] => int [precision] => 4 [default] => 1 [comment] => only for certain types (eg. resources) ) [cal_role] => Array ( [type] => ascii [precision] => 64 [default] => REQ-PARTICIPANT [comment] => CHAIR, REQ-PARTICIPANT, OPT-PARTICIPANT, NON-PARTICIPANT, X-CAT-$cat_id ) [cal_user_modified] => Array ( [type] => timestamp [default] => current_timestamp [comment] => automatic timestamp of last update ) [cal_user_auto] => Array ( [type] => auto [nullable] => ) ) [pk] => Array ( [0] => cal_user_auto ) [fk] => Array ( ) [ix] => Array ( [0] => cal_user_modified [1] => Array ( [0] => cal_user_type [1] => cal_user_id ) ) [uc] => Array ( [0] => Array ( [0] => cal_id [1] => cal_recur_date [2] => cal_user_type [3] => cal_user_id ) ) ) ) schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_user') = NULL schema_proc::GetTableDefintion('egw_cal_user') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_recur_date] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [cal_user_type] => Array ( [type] => ascii [precision] => 1 [default] => u [nullable] => ) [cal_user_id] => Array ( [type] => ascii [precision] => 128 [nullable] => ) [cal_status] => Array ( [type] => ascii [precision] => 1 [default] => A ) [cal_quantity] => Array ( [type] => int [precision] => 4 [default] => 1 ) [cal_role] => Array ( [type] => ascii [precision] => 64 [default] => REQ-PARTICIPANT ) [cal_user_modified] => Array ( [type] => timestamp [default] => current_timestamp [nullable] => ) ) [pk] => Array ( [0] => cal_id [1] => cal_recur_date [2] => cal_user_type [3] => cal_user_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => cal_user_type [1] => cal_user_id ) [1] => cal_user_modified ) [uc] => Array ( ) ) RenameTableSQL('egw_cal_user','tmp_egw_cal_user') sql=Array ( [0] => RENAME TABLE `egw_cal_user` TO `tmp_egw_cal_user` )  schema_proc::CreateTable('egw_cal_user', Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_recur_date] => Array ( [type] => int [meta] => timestamp [precision] => 8 [nullable] => [default] => 0 ) [cal_user_type] => Array ( [type] => ascii [precision] => 1 [nullable] => [default] => u [comment] => u=user, g=group, c=contact, r=resource, e=email ) [cal_user_id] => Array ( [type] => varchar [meta] => Array ( [cal_user_type='u'] => account ) [precision] => 128 [nullable] => [comment] => id or email-address for type=e ) [cal_status] => Array ( [type] => ascii [precision] => 1 [default] => A [comment] => U=unknown, A=accepted, R=rejected, T=tentative ) [cal_quantity] => Array ( [type] => int [precision] => 4 [default] => 1 [comment] => only for certain types (eg. resources) ) [cal_role] => Array ( [type] => ascii [precision] => 64 [default] => REQ-PARTICIPANT [comment] => CHAIR, REQ-PARTICIPANT, OPT-PARTICIPANT, NON-PARTICIPANT, X-CAT-$cat_id ) [cal_user_modified] => Array ( [type] => timestamp [default] => current_timestamp [comment] => automatic timestamp of last update ) [cal_user_auto] => Array ( [type] => auto [nullable] => ) ) [pk] => Array ( [0] => cal_user_auto ) [fk] => Array ( ) [ix] => Array ( [0] => cal_user_modified [1] => Array ( [0] => cal_user_type [1] => cal_user_id ) ) [uc] => Array ( [0] => Array ( [0] => cal_id [1] => cal_recur_date [2] => cal_user_type [3] => cal_user_id ) ) ) ) CreateTableSQL('egw_cal_user','cal_id I4 NOTNULL, cal_recur_date I8 NOTNULL NOQUOTE DEFAULT 0, cal_user_type C(1) CONSTRAINT "CHARACTER SET ascii" NOTNULL DEFAULT 'u', cal_user_id C(128) NOTNULL, cal_status C(1) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'A', cal_quantity I4 NOQUOTE DEFAULT 1, cal_role C(64) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'REQ-PARTICIPANT', cal_user_modified T DEFTIMESTAMP, cal_user_auto I AUTOINCREMENT NOTNULL PRIMARY') sql=Array ( [0] => CREATE TABLE `egw_cal_user` ( `cal_id` INTEGER NOT NULL, `cal_recur_date` BIGINT NOT NULL DEFAULT 0, `cal_user_type` VARCHAR(1) CHARACTER SET ascii NOT NULL DEFAULT 'u', `cal_user_id` VARCHAR(128) NOT NULL, `cal_status` VARCHAR(1) CHARACTER SET ascii DEFAULT 'A', `cal_quantity` INTEGER DEFAULT 1, `cal_role` VARCHAR(64) CHARACTER SET ascii DEFAULT 'REQ-PARTICIPANT', `cal_user_modified` TIMESTAMP, `cal_user_auto` INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (`cal_user_auto`) )CHARACTER SET utf8 )  CreateIndexSQL('egw_cal_user',Array ( [0] => cal_id [1] => cal_recur_date [2] => cal_user_type [3] => cal_user_id ) ,Array ( [0] => UNIQUE ) ,'egw_cal_user_id_recur_date_type_id') sql=Array ( [0] => ALTER TABLE `egw_cal_user` ADD UNIQUE INDEX `egw_cal_user_id_recur_date_type_id` (`cal_id`, `cal_recur_date`, `cal_user_type`, `cal_user_id`) )  CreateIndexSQL('egw_cal_user','cal_user_modified',Array ( ) ,'egw_cal_user_modified') sql=Array ( [0] => ALTER TABLE `egw_cal_user` ADD INDEX `egw_cal_user_modified` (`cal_user_modified`) )  CreateIndexSQL('egw_cal_user',Array ( [0] => cal_user_type [1] => cal_user_id ) ,Array ( ) ,'egw_cal_user_type_id') sql=Array ( [0] => ALTER TABLE `egw_cal_user` ADD INDEX `egw_cal_user_type_id` (`cal_user_type`, `cal_user_id`) )  DropTable('tmp_egw_cal_user') sql=Array ( [0] => DROP TABLE IF EXISTS `tmp_egw_cal_user` )  --> 14.2.005  process->upgrade(): calendar(14.2.005 --> 17.1.001): running calendar_upgrade14_2_005() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_timezones') = NULL schema_proc::GetTableDefintion('egw_cal_timezones') = Array ( [fd] => Array ( [tz_id] => Array ( [type] => auto [nullable] => ) [tz_tzid] => Array ( [type] => ascii [precision] => 128 [nullable] => ) [tz_alias] => Array ( [type] => int [precision] => 4 ) [tz_latitude] => Array ( [type] => int [precision] => 4 ) [tz_longitude] => Array ( [type] => int [precision] => 4 ) [tz_component] => Array ( [type] => text ) ) [pk] => Array ( [0] => tz_id ) [fk] => Array ( ) [ix] => Array ( [0] => tz_alias ) [uc] => Array ( [0] => tz_tzid ) ) AlterColumnSQL('egw_cal_timezones','tz_tzid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL','tz_id I AUTOINCREMENT NOTNULL PRIMARY, tz_tzid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL, tz_alias I4, tz_latitude I4, tz_longitude I4, tz_component X') sql=Array ( [0] => ALTER TABLE `egw_cal_timezones` MODIFY COLUMN `tz_tzid` VARCHAR(128) CHARACTER SET ascii NOT NULL )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_timezones') = NULL schema_proc::GetTableDefintion('egw_cal_timezones') = Array ( [fd] => Array ( [tz_id] => Array ( [type] => auto [nullable] => ) [tz_tzid] => Array ( [type] => ascii [precision] => 128 [nullable] => ) [tz_alias] => Array ( [type] => int [precision] => 4 ) [tz_latitude] => Array ( [type] => int [precision] => 4 ) [tz_longitude] => Array ( [type] => int [precision] => 4 ) [tz_component] => Array ( [type] => text ) ) [pk] => Array ( [0] => tz_id ) [fk] => Array ( ) [ix] => Array ( [0] => tz_alias ) [uc] => Array ( [0] => tz_tzid ) ) AlterColumnSQL('egw_cal_timezones','tz_component C(8192) CONSTRAINT "CHARACTER SET ascii"','tz_id I AUTOINCREMENT NOTNULL PRIMARY, tz_tzid C(128) CONSTRAINT "CHARACTER SET ascii" NOTNULL, tz_alias I4, tz_latitude I4, tz_longitude I4, tz_component C(8192) CONSTRAINT "CHARACTER SET ascii"') sql=Array ( [0] => ALTER TABLE `egw_cal_timezones` MODIFY COLUMN `tz_component` VARCHAR(8192) CHARACTER SET ascii )  --> 14.3  process->upgrade(): calendar(14.3 --> 17.1.001): running calendar_upgrade14_3() AlterColumnSQL('egw_cal_user','cal_user_attendee',Array ( [type] => varchar [precision] => 255 [comment] => email or json object with attr. cn, url, ... ) ) sql=Array ( [0] => ALTER TABLE `egw_cal_user` ADD `cal_user_attendee` VARCHAR(255) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_user') = NULL schema_proc::GetTableDefintion('egw_cal_user') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [cal_recur_date] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [cal_user_type] => Array ( [type] => ascii [precision] => 1 [default] => u [nullable] => ) [cal_user_id] => Array ( [type] => ascii [precision] => 128 [nullable] => ) [cal_status] => Array ( [type] => ascii [precision] => 1 [default] => A ) [cal_quantity] => Array ( [type] => int [precision] => 4 [default] => 1 ) [cal_role] => Array ( [type] => ascii [precision] => 64 [default] => REQ-PARTICIPANT ) [cal_user_modified] => Array ( [type] => timestamp [default] => current_timestamp [nullable] => ) [cal_user_auto] => Array ( [type] => auto [nullable] => ) [cal_user_attendee] => Array ( [type] => varchar [precision] => 255 ) ) [pk] => Array ( [0] => cal_user_auto ) [fk] => Array ( ) [ix] => Array ( [0] => cal_user_modified [1] => Array ( [0] => cal_user_type [1] => cal_user_id ) ) [uc] => Array ( [0] => Array ( [0] => cal_id [1] => cal_recur_date [2] => cal_user_type [3] => cal_user_id ) ) ) AlterColumnSQL('egw_cal_user','cal_user_id C(32) CONSTRAINT "CHARACTER SET ascii" NOTNULL','cal_id I4 NOTNULL, cal_recur_date I8 NOTNULL NOQUOTE DEFAULT 0, cal_user_type C(1) CONSTRAINT "CHARACTER SET ascii" NOTNULL DEFAULT 'u', cal_user_id C(32) CONSTRAINT "CHARACTER SET ascii" NOTNULL, cal_status C(1) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'A', cal_quantity I4 NOQUOTE DEFAULT 1, cal_role C(64) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'REQ-PARTICIPANT', cal_user_modified T DEFTIMESTAMP NOTNULL, cal_user_auto I AUTOINCREMENT NOTNULL PRIMARY, cal_user_attendee C(255)') sql=Array ( [0] => ALTER TABLE `egw_cal_user` MODIFY COLUMN `cal_user_id` VARCHAR(32) CHARACTER SET ascii NOT NULL )  --> 14.3.001  process->upgrade(): calendar(14.3.001 --> 17.1.001): running calendar_upgrade14_3_001() --> 14.3.002  process->upgrade(): calendar(14.3.002 --> 17.1.001): running calendar_upgrade14_3_002() --> 14.3.900  process->upgrade(): calendar(14.3.900 --> 17.1.001): running calendar_upgrade14_3_900() --> 14.3.901  process->upgrade(): calendar(14.3.901 --> 17.1.001): running calendar_upgrade14_3_901() --> 14.3.902  process->upgrade(): calendar(14.3.902 --> 17.1.001): running calendar_upgrade14_3_902() --> 14.3.903  process->upgrade(): calendar(14.3.903 --> 17.1.001): running calendar_upgrade14_3_903() --> 16.1  process->upgrade(): calendar(16.1 --> 17.1.001): running calendar_upgrade16_1() DropTable('egw_cal_holidays') sql=Array ( [0] => DROP TABLE IF EXISTS `egw_cal_holidays` )  --> 16.1.001  process->upgrade(): calendar(16.1.001 --> 17.1.001): running calendar_upgrade16_1_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_cal_extra') = NULL schema_proc::GetTableDefintion('egw_cal_extra') = Array ( [fd] => Array ( [cal_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cal_extra_name] => Array ( [type] => varchar [precision] => 40 [nullable] => ) [cal_extra_value] => Array ( [type] => varchar [precision] => 255 [nullable] => ) ) [pk] => Array ( [0] => cal_id [1] => cal_extra_name ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_cal_extra','cal_extra_value C(16384) NOTNULL DEFAULT ''','cal_id I4 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, cal_extra_name C(40) NOTNULL PRIMARY, cal_extra_value C(16384) NOTNULL DEFAULT ''') sql=Array ( [0] => ALTER TABLE `egw_cal_extra` MODIFY COLUMN `cal_extra_value` VARCHAR(16384) NOT NULL DEFAULT '' )  --> 16.1.002  process->upgrade(): calendar(16.1.002 --> 17.1.001): running calendar_upgrade16_1_002() --> 16.1.003  process->upgrade(): calendar(16.1.003 --> 17.1.001): running calendar_upgrade16_1_003() --> 17.1  process->upgrade(): calendar(17.1 --> 17.1.001): running calendar_upgrade17_1() --> 17.1.001  process->upgrade(): Upgrade of calendar to 17.1.001 is completed.  process->upgrade(): Outgoing : appname: calendar, status: C process->upgrade(): Incoming : appname: developer_tools, version: 1.8, status: U  process->upgrade(): No table upgrade required/availible for developer_tools  process->upgrade(): Outgoing : appname: developer_tools, status: C process->upgrade(): Application not installed: emailadmin process->upgrade(): Incoming : appname: filemanager, version: 1.8, status: U  process->upgrade(): filemanager(1.8 --> 17.1): running filemanager_upgrade1_8() --> 16.1  process->upgrade(): filemanager(16.1 --> 17.1): running filemanager_upgrade16_1() schema_proc::CreateTable('egw_collab_member', Array ( [fd] => Array ( [collab_member_id] => Array ( [type] => auto [nullable] => [comment] => Unique per user and session ) [collab_es_id] => Array ( [type] => varchar [precision] => 64 [nullable] => [comment] => Related editing session id ) [collab_uid] => Array ( [type] => varchar [precision] => 64 ) [collab_color] => Array ( [type] => varchar [precision] => 32 ) [collab_is_active] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [collab_is_guest] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [collab_token] => Array ( [type] => varchar [precision] => 32 ) [collab_status] => Array ( [type] => int [precision] => 2 [default] => 1 [nullable] => ) ) [pk] => Array ( [0] => collab_member_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) ) CreateTableSQL('egw_collab_member','collab_member_id I AUTOINCREMENT NOTNULL PRIMARY, collab_es_id C(64) NOTNULL, collab_uid C(64), collab_color C(32), collab_is_active I2 NOTNULL NOQUOTE DEFAULT 0, collab_is_guest I2 NOTNULL NOQUOTE DEFAULT 0, collab_token C(32), collab_status I2 NOTNULL NOQUOTE DEFAULT 1') sql=Array ( [0] => CREATE TABLE `egw_collab_member` ( `collab_member_id` INTEGER NOT NULL AUTO_INCREMENT, `collab_es_id` VARCHAR(64) NOT NULL, `collab_uid` VARCHAR(64), `collab_color` VARCHAR(32), `collab_is_active` SMALLINT NOT NULL DEFAULT 0, `collab_is_guest` SMALLINT NOT NULL DEFAULT 0, `collab_token` VARCHAR(32), `collab_status` SMALLINT NOT NULL DEFAULT 1, PRIMARY KEY (`collab_member_id`) )CHARACTER SET utf8 )  schema_proc::CreateTable('egw_collab_op', Array ( [fd] => Array ( [collab_seq] => Array ( [type] => auto [nullable] => [comment] => Sequence number ) [collab_es_id] => Array ( [type] => varchar [precision] => 64 [nullable] => [comment] => Editing session id ) [collab_member] => Array ( [type] => int [precision] => 4 [default] => 1 [nullable] => [comment] => User and time specific ) [collab_optype] => Array ( [type] => varchar [precision] => 64 [comment] => Operation type ) [collab_opspec] => Array ( [type] => longtext [comment] => json-string ) ) [pk] => Array ( [0] => collab_seq ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) ) CreateTableSQL('egw_collab_op','collab_seq I AUTOINCREMENT NOTNULL PRIMARY, collab_es_id C(64) NOTNULL, collab_member I4 NOTNULL NOQUOTE DEFAULT 1, collab_optype C(64), collab_opspec XL') sql=Array ( [0] => CREATE TABLE `egw_collab_op` ( `collab_seq` INTEGER NOT NULL AUTO_INCREMENT, `collab_es_id` VARCHAR(64) NOT NULL, `collab_member` INTEGER NOT NULL DEFAULT 1, `collab_optype` VARCHAR(64), `collab_opspec` LONGTEXT, PRIMARY KEY (`collab_seq`) )CHARACTER SET utf8 )  schema_proc::CreateTable('egw_collab_session', Array ( [fd] => Array ( [collab_es_id] => Array ( [type] => varchar [precision] => 64 [nullable] => [comment] => Editing session id ) [collab_genesis_url] => Array ( [type] => varchar [precision] => 512 [comment] => Relative to owner documents storage /template.odt ) [account_id] => Array ( [type] => int [meta] => user [precision] => 4 [nullable] => [comment] => user who created the session ) [collab_last_save] => Array ( [type] => int [meta] => timestamp [precision] => 8 [comment] => timestamp of the last save ) ) [pk] => Array ( [0] => collab_es_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) ) CreateTableSQL('egw_collab_session','collab_es_id C(64) NOTNULL PRIMARY, collab_genesis_url C(512), account_id I4 NOTNULL, collab_last_save I8') sql=Array ( [0] => CREATE TABLE `egw_collab_session` ( `collab_es_id` VARCHAR(64) NOT NULL, `collab_genesis_url` VARCHAR(512), `account_id` INTEGER NOT NULL, `collab_last_save` BIGINT, PRIMARY KEY (`collab_es_id`) )CHARACTER SET utf8 )  --> 16.2  process->upgrade(): filemanager(16.2 --> 17.1): running filemanager_upgrade16_2() --> 17.1  process->upgrade(): Upgrade of filemanager to 17.1 is completed.  process->upgrade(): Outgoing : appname: filemanager, status: C process->upgrade(): Incoming : appname: home, version: 1.8, status: U  process->upgrade(): home(1.8 --> 17.1): running home_upgrade1_8() --> 14.1  process->upgrade(): home(14.1 --> 17.1): running home_upgrade14_1() --> 14.1.001  process->upgrade(): home(14.1.001 --> 17.1): running home_upgrade14_1_001() --> 16.1  process->upgrade(): home(16.1 --> 17.1): running home_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of home to 17.1 is completed.  process->upgrade(): Outgoing : appname: home, status: C process->upgrade(): Incoming : appname: importexport, version: 1.8, status: U  process->upgrade(): importexport(1.8 --> 17.1): running importexport_upgrade1_8() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_importexport_definitions') = NULL schema_proc::GetTableDefintion('egw_importexport_definitions') = Array ( [fd] => Array ( [definition_id] => Array ( [type] => auto [nullable] => ) [name] => Array ( [type] => varchar [precision] => 255 ) [application] => Array ( [type] => varchar [precision] => 50 ) [plugin] => Array ( [type] => varchar [precision] => 100 ) [type] => Array ( [type] => varchar [precision] => 20 ) [allowed_users] => Array ( [type] => varchar [precision] => 255 ) [plugin_options] => Array ( [type] => text ) [owner] => Array ( [type] => int [precision] => 4 ) [description] => Array ( [type] => varchar [precision] => 255 ) ) [pk] => Array ( [0] => definition_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( [0] => name ) ) AlterColumnSQL('egw_importexport_definitions','definition_id I AUTOINCREMENT NOTNULL','definition_id I AUTOINCREMENT NOTNULL PRIMARY, name C(255), application C(50), plugin C(100), type C(20), allowed_users C(255), plugin_options X, owner I4, description C(255)') sql=Array ( [0] => ALTER TABLE `egw_importexport_definitions` MODIFY COLUMN `definition_id` INTEGER NOT NULL AUTO_INCREMENT )  AlterColumnSQL('egw_importexport_definitions','modified',Array ( [type] => timestamp ) ) sql=Array ( [0] => ALTER TABLE `egw_importexport_definitions` ADD `modified` DATETIME )  --> 1.9.001  process->upgrade(): importexport(1.9.001 --> 17.1): running importexport_upgrade1_9_001() --> 1.9.002  process->upgrade(): importexport(1.9.002 --> 17.1): running importexport_upgrade1_9_002() AlterColumnSQL('egw_importexport_definitions','filter',Array ( [type] => longtext ) ) sql=Array ( [0] => ALTER TABLE `egw_importexport_definitions` ADD `filter` LONGTEXT )  --> 1.9.004  process->upgrade(): importexport(1.9.004 --> 17.1): running importexport_upgrade1_9_004() --> 14.1  process->upgrade(): importexport(14.1 --> 17.1): running importexport_upgrade14_1() --> 16.1  process->upgrade(): importexport(16.1 --> 17.1): running importexport_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of importexport to 17.1 is completed.  process->upgrade(): Outgoing : appname: importexport, status: C process->upgrade(): Incoming : appname: infolog, version: 1.9.003, status: U  process->upgrade(): infolog(1.9.003 --> 17.1): running infolog_upgrade1_9_003() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 255 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 64 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','caldav_name C(200)','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des X, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(255) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(200), info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `caldav_name` VARCHAR(200) )  --> 1.9.004  process->upgrade(): infolog(1.9.004 --> 17.1): running infolog_upgrade1_9_004() --> 1.9.005  process->upgrade(): infolog(1.9.005 --> 17.1): running infolog_upgrade1_9_005() --> 1.9.006  process->upgrade(): infolog(1.9.006 --> 17.1): running infolog_upgrade1_9_006() --> 14.1  process->upgrade(): infolog(14.1 --> 17.1): running infolog_upgrade14_1() --> 14.2  process->upgrade(): infolog(14.2 --> 17.1): running infolog_upgrade14_2() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 255 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','info_responsible C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL DEFAULT '0'','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des X, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) CONSTRAINT "CHARACTER SET ascii" NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(255) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(200) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `info_responsible` VARCHAR(255) CHARACTER SET ascii NOT NULL DEFAULT '0' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 255 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public'','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des X, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(255) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(200) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `info_access` VARCHAR(10) CHARACTER SET ascii DEFAULT 'public' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 255 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not'','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des X, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(255) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(200) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `info_confirm` VARCHAR(10) CHARACTER SET ascii DEFAULT 'not' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 255 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','info_uid C(128) CONSTRAINT "CHARACTER SET ascii"','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des X, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(128) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(200) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `info_uid` VARCHAR(128) CHARACTER SET ascii )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 128 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 200 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','caldav_name C(128) CONSTRAINT "CHARACTER SET ascii"','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des X, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(128) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(128) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `caldav_name` VARCHAR(128) CHARACTER SET ascii )  --> 14.2.001  process->upgrade(): infolog(14.2.001 --> 17.1): running infolog_upgrade14_2_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog_extra') = NULL schema_proc::GetTableDefintion('egw_infolog_extra') = Array ( [fd] => Array ( [info_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_extra_name] => Array ( [type] => varchar [precision] => 64 [nullable] => ) [info_extra_value] => Array ( [type] => text ) ) [pk] => Array ( [0] => info_id [1] => info_extra_name ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog_extra','info_extra_value C(16384) NOTNULL','info_id I4 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, info_extra_name C(64) NOTNULL PRIMARY, info_extra_value C(16384) NOTNULL') sql=Array ( [0] => ALTER TABLE `egw_infolog_extra` MODIFY COLUMN `info_extra_value` VARCHAR(16384) NOT NULL )  --> 14.3  process->upgrade(): infolog(14.3 --> 17.1): running infolog_upgrade14_3() --> 16.1  process->upgrade(): infolog(16.1 --> 17.1): running infolog_upgrade16_1() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => text ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 128 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 128 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) [1] => Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) [2] => caldav_name ) [uc] => Array ( ) ) AlterColumnSQL('egw_infolog','info_des XL','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des XL, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_responsible C(255) NOTNULL DEFAULT '0', info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(128) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(128) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` MODIFY COLUMN `info_des` LONGTEXT )  --> 16.1.001  process->upgrade(): infolog(16.1.001 --> 17.1): running infolog_upgrade16_1_001() schema_proc::CreateTable('egw_infolog_users', Array ( [fd] => Array ( [info_res_id] => Array ( [type] => auto [nullable] => [comment] => auto id ) [info_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [account_id] => Array ( [type] => int [meta] => account [precision] => 4 [nullable] => [comment] => attendee ) [info_res_deleted] => Array ( [type] => bool ) [info_res_modified] => Array ( [type] => timestamp [meta] => timestamp [default] => current_timestamp [comment] => last modification time ) [info_res_modifier] => Array ( [type] => int [meta] => user [precision] => 4 [comment] => modifying user ) [info_res_status] => Array ( [type] => varchar [precision] => 16 [default] => NEEDS-ACTION [comment] => attendee status ) [info_res_attendee] => Array ( [type] => varchar [precision] => 255 [comment] => attendee email or json object with attr. cn, url, ... ) ) [pk] => Array ( [0] => info_res_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id ) [uc] => Array ( [0] => Array ( [0] => info_id [1] => account_id ) ) ) ) CreateTableSQL('egw_infolog_users','info_res_id I AUTOINCREMENT NOTNULL PRIMARY, info_id I4 NOTNULL, account_id I4 NOTNULL, info_res_deleted L, info_res_modified T DEFTIMESTAMP, info_res_modifier I4, info_res_status C(16) DEFAULT 'NEEDS-ACTION', info_res_attendee C(255)') sql=Array ( [0] => CREATE TABLE `egw_infolog_users` ( `info_res_id` INTEGER NOT NULL AUTO_INCREMENT, `info_id` INTEGER NOT NULL, `account_id` INTEGER NOT NULL, `info_res_deleted` TINYINT, `info_res_modified` TIMESTAMP, `info_res_modifier` INTEGER, `info_res_status` VARCHAR(16) DEFAULT 'NEEDS-ACTION', `info_res_attendee` VARCHAR(255), PRIMARY KEY (`info_res_id`) )CHARACTER SET utf8 )  CreateIndexSQL('egw_infolog_users',Array ( [0] => info_id [1] => account_id ) ,Array ( [0] => UNIQUE ) ,'egw_infolog_users_id_account_id') sql=Array ( [0] => ALTER TABLE `egw_infolog_users` ADD UNIQUE INDEX `egw_infolog_users_id_account_id` (`info_id`, `account_id`) )  CreateIndexSQL('egw_infolog_users','account_id',Array ( ) ,'egw_infolog_users_account_id') sql=Array ( [0] => ALTER TABLE `egw_infolog_users` ADD INDEX `egw_infolog_users_account_id` (`account_id`) )  --> 16.1.002  process->upgrade(): infolog(16.1.002 --> 17.1): running infolog_upgrade16_1_002() DropIndexSQL('egw_infolog_owner_responsible_status_startdate'(Array ( [0] => info_owner [1] => info_responsible [2] => info_status [3] => info_startdate ) ),'egw_infolog') sql=Array ( [0] => DROP INDEX `egw_infolog_owner_responsible_status_startdate` ON `egw_infolog` )  DropIndexSQL('egw_infolog_id_parent_owner_responsible_status_startdate'(Array ( [0] => info_id_parent [1] => info_owner [2] => info_responsible [3] => info_status [4] => info_startdate ) ),'egw_infolog') sql=Array ( [0] => DROP INDEX `egw_infolog_id_parent_owner_responsible_status_startdate` ON `egw_infolog` )  CreateIndexSQL('egw_infolog','info_owner',Array ( ) ,'egw_infolog_owner') sql=Array ( [0] => ALTER TABLE `egw_infolog` ADD INDEX `egw_infolog_owner` (`info_owner`) )  CreateIndexSQL('egw_infolog','info_id_parent',Array ( ) ,'egw_infolog_id_parent') sql=Array ( [0] => ALTER TABLE `egw_infolog` ADD INDEX `egw_infolog_id_parent` (`info_id_parent`) )  CreateIndexSQL('egw_infolog','info_datemodified',Array ( ) ,'egw_infolog_datemodified') sql=Array ( [0] => ALTER TABLE `egw_infolog` ADD INDEX `egw_infolog_datemodified` (`info_datemodified`) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => longtext ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_responsible] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 128 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 128 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => caldav_name [1] => info_owner [2] => info_id_parent [3] => info_datemodified ) [uc] => Array ( ) ) DropColumnSQL('egw_infolog','info_responsible','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_addr C(255), info_subject C(255), info_des XL, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(128) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(128) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` DROP COLUMN `info_responsible` )  --> 16.1.003  process->upgrade(): infolog(16.1.003 --> 17.1): running infolog_upgrade16_1_003() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_addr] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => longtext ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 128 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 128 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => caldav_name [1] => info_owner [2] => info_id_parent [3] => info_datemodified ) [uc] => Array ( ) ) DropColumnSQL('egw_infolog','info_addr','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_subject C(255), info_des XL, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(128) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_cc C(255), caldav_name C(128) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` DROP COLUMN `info_addr` )  --> 16.1.004  process->upgrade(): infolog(16.1.004 --> 17.1): running infolog_upgrade16_1_004() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog_users') = NULL schema_proc::GetTableDefintion('egw_infolog_users') = Array ( [fd] => Array ( [info_res_id] => Array ( [type] => auto [nullable] => ) [info_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [account_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [info_res_deleted] => Array ( [type] => bool ) [info_res_modified] => Array ( [type] => timestamp [default] => current_timestamp [nullable] => ) [info_res_modifier] => Array ( [type] => int [precision] => 4 ) [info_res_status] => Array ( [type] => varchar [precision] => 16 [default] => NEEDS-ACTION ) [info_res_attendee] => Array ( [type] => varchar [precision] => 255 ) ) [pk] => Array ( [0] => info_res_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id ) [uc] => Array ( [0] => Array ( [0] => info_id [1] => account_id ) ) ) AlterColumnSQL('egw_infolog_users','account_id C(32) CONSTRAINT "CHARACTER SET ascii" NOTNULL','info_res_id I AUTOINCREMENT NOTNULL PRIMARY, info_id I4 NOTNULL, account_id C(32) CONSTRAINT "CHARACTER SET ascii" NOTNULL, info_res_deleted L, info_res_modified T DEFTIMESTAMP NOTNULL, info_res_modifier I4, info_res_status C(16) DEFAULT 'NEEDS-ACTION', info_res_attendee C(255)') sql=Array ( [0] => ALTER TABLE `egw_infolog_users` MODIFY COLUMN `account_id` VARCHAR(32) CHARACTER SET ascii NOT NULL )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_infolog') = NULL schema_proc::GetTableDefintion('egw_infolog') = Array ( [fd] => Array ( [info_id] => Array ( [type] => auto [nullable] => ) [info_type] => Array ( [type] => varchar [precision] => 40 [default] => task [nullable] => ) [info_from] => Array ( [type] => varchar [precision] => 255 ) [info_subject] => Array ( [type] => varchar [precision] => 255 ) [info_des] => Array ( [type] => longtext ) [info_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_access] => Array ( [type] => ascii [precision] => 10 [default] => public ) [info_cat] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_datemodified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_startdate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_enddate] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [info_id_parent] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_planned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_used_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_status] => Array ( [type] => varchar [precision] => 40 [default] => done ) [info_confirm] => Array ( [type] => ascii [precision] => 10 [default] => not ) [info_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_link_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_priority] => Array ( [type] => int [precision] => 2 [default] => 1 ) [pl_id] => Array ( [type] => int [precision] => 4 ) [info_price] => Array ( [type] => float [precision] => -1 ) [info_percent] => Array ( [type] => int [precision] => 2 [default] => 0 ) [info_datecompleted] => Array ( [type] => int [precision] => 8 ) [info_location] => Array ( [type] => varchar [precision] => 255 ) [info_custom_from] => Array ( [type] => int [precision] => 1 ) [info_uid] => Array ( [type] => ascii [precision] => 128 ) [info_replanned_time] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [info_cc] => Array ( [type] => varchar [precision] => 255 ) [caldav_name] => Array ( [type] => ascii [precision] => 128 ) [info_etag] => Array ( [type] => int [precision] => 4 [default] => 0 ) [info_created] => Array ( [type] => int [precision] => 8 ) [info_creator] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => info_id ) [fk] => Array ( ) [ix] => Array ( [0] => caldav_name [1] => info_owner [2] => info_id_parent [3] => info_datemodified ) [uc] => Array ( ) ) DropColumnSQL('egw_infolog','info_cc','info_id I AUTOINCREMENT NOTNULL PRIMARY, info_type C(40) NOTNULL DEFAULT 'task', info_from C(255), info_subject C(255), info_des XL, info_owner I4 NOTNULL NOQUOTE DEFAULT 0, info_access C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'public', info_cat I4 NOTNULL NOQUOTE DEFAULT 0, info_datemodified I8 NOTNULL NOQUOTE DEFAULT 0, info_startdate I8 NOTNULL NOQUOTE DEFAULT 0, info_enddate I8 NOTNULL NOQUOTE DEFAULT 0, info_id_parent I4 NOTNULL NOQUOTE DEFAULT 0, info_planned_time I4 NOTNULL NOQUOTE DEFAULT 0, info_used_time I4 NOTNULL NOQUOTE DEFAULT 0, info_status C(40) DEFAULT 'done', info_confirm C(10) CONSTRAINT "CHARACTER SET ascii" DEFAULT 'not', info_modifier I4 NOTNULL NOQUOTE DEFAULT 0, info_link_id I4 NOTNULL NOQUOTE DEFAULT 0, info_priority I2 NOQUOTE DEFAULT 1, pl_id I4, info_price F, info_percent I2 NOQUOTE DEFAULT 0, info_datecompleted I8, info_location C(255), info_custom_from I1, info_uid C(128) CONSTRAINT "CHARACTER SET ascii", info_replanned_time I4 NOTNULL NOQUOTE DEFAULT 0, caldav_name C(128) CONSTRAINT "CHARACTER SET ascii", info_etag I4 NOQUOTE DEFAULT 0, info_created I8, info_creator I4') sql=Array ( [0] => ALTER TABLE `egw_infolog` DROP COLUMN `info_cc` )  --> 17.1  process->upgrade(): Upgrade of infolog to 17.1 is completed.  process->upgrade(): Outgoing : appname: infolog, status: C process->current(): Incoming status: mail,status: U process->current(): No current tables for mail  process->current(): Outgoing status: mail,status: C process->default_records(): Including default records for mail process->upgrade(): Incoming : appname: news_admin, version: 1.8.001, status: U  process->upgrade(): news_admin(1.8.001 --> 17.1): running news_admin_upgrade1_8_001() --> 1.9.001  process->upgrade(): news_admin(1.9.001 --> 17.1): running news_admin_upgrade1_9_001() --> 14.1  process->upgrade(): news_admin(14.1 --> 17.1): running news_admin_upgrade14_1() --> 14.1.001  process->upgrade(): news_admin(14.1.001 --> 17.1): running news_admin_upgrade14_1_001() --> 16.1  process->upgrade(): news_admin(16.1 --> 17.1): running news_admin_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of news_admin to 17.1 is completed.  process->upgrade(): Outgoing : appname: news_admin, status: C process->upgrade(): Incoming : appname: notifications, version: 1.8, status: U  process->upgrade(): notifications(1.8 --> 17.1.002): running notifications_upgrade1_8() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_notificationpopup') = False schema_proc::GetTableDefintion('egw_notificationpopup') = Array ( [fd] => Array ( [account_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [session_id] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [message] => Array ( [type] => text ) ) [pk] => Array ( ) [fk] => Array ( ) [ix] => Array ( [0] => account_id [1] => session_id ) [uc] => Array ( ) ) DropColumnSQL('egw_notificationpopup','session_id','account_id I4 NOTNULL, message X') sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` DROP COLUMN `session_id` )  --> 1.9.001  process->upgrade(): notifications(1.9.001 --> 17.1.002): running notifications_upgrade1_9_001() --> 1.9.002  process->upgrade(): notifications(1.9.002 --> 17.1.002): running notifications_upgrade1_9_002() schema_proc::RefreshTable('egw_notificationpopup', Array ( [fd] => Array ( [notify_id] => Array ( [type] => auto [nullable] => [comment] => primary key ) [account_id] => Array ( [type] => int [precision] => 20 [nullable] => [comment] => user to notify ) [notify_message] => Array ( [type] => text [comment] => notification message ) [notify_created] => Array ( [type] => timestamp [default] => current_timestamp [comment] => creation time of notification ) ) [pk] => Array ( [0] => notify_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id [1] => notify_created ) [uc] => Array ( ) ) ) schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_notificationpopup') = False schema_proc::GetTableDefintion('egw_notificationpopup') = Array ( [fd] => Array ( [account_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [message] => Array ( [type] => text ) ) [pk] => Array ( ) [fk] => Array ( ) [ix] => Array ( [0] => account_id ) [uc] => Array ( ) ) RenameTableSQL('egw_notificationpopup','tmp_egw_notificationpopup') sql=Array ( [0] => RENAME TABLE `egw_notificationpopup` TO `tmp_egw_notificationpopup` )  schema_proc::CreateTable('egw_notificationpopup', Array ( [fd] => Array ( [notify_id] => Array ( [type] => auto [nullable] => [comment] => primary key ) [account_id] => Array ( [type] => int [precision] => 20 [nullable] => [comment] => user to notify ) [notify_message] => Array ( [type] => text [comment] => notification message ) [notify_created] => Array ( [type] => timestamp [default] => current_timestamp [comment] => creation time of notification ) ) [pk] => Array ( [0] => notify_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id [1] => notify_created ) [uc] => Array ( ) ) ) CreateTableSQL('egw_notificationpopup','notify_id I AUTOINCREMENT NOTNULL PRIMARY, account_id I NOTNULL, notify_message X, notify_created T DEFTIMESTAMP') sql=Array ( [0] => CREATE TABLE `egw_notificationpopup` ( `notify_id` INTEGER NOT NULL AUTO_INCREMENT, `account_id` INTEGER NOT NULL, `notify_message` TEXT, `notify_created` TIMESTAMP, PRIMARY KEY (`notify_id`) )CHARACTER SET utf8 )  CreateIndexSQL('egw_notificationpopup','account_id',Array ( ) ,'egw_notificationpopup_account_id') sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` ADD INDEX `egw_notificationpopup_account_id` (`account_id`) )  CreateIndexSQL('egw_notificationpopup','notify_created',Array ( ) ,'egw_notificationpopup_notify_created') sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` ADD INDEX `egw_notificationpopup_notify_created` (`notify_created`) )  DropTable('tmp_egw_notificationpopup') sql=Array ( [0] => DROP TABLE IF EXISTS `tmp_egw_notificationpopup` )  --> 1.9.003  process->upgrade(): notifications(1.9.003 --> 17.1.002): running notifications_upgrade1_9_003() AlterColumnSQL('egw_notificationpopup','notify_type',Array ( [type] => varchar [precision] => 32 [comment] => notification type ) ) sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` ADD `notify_type` VARCHAR(32) )  --> 1.9.004  process->upgrade(): notifications(1.9.004 --> 17.1.002): running notifications_upgrade1_9_004() --> 14.1  process->upgrade(): notifications(14.1 --> 17.1.002): running notifications_upgrade14_1() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_notificationpopup') = NULL schema_proc::GetTableDefintion('egw_notificationpopup') = Array ( [fd] => Array ( [notify_id] => Array ( [type] => auto [nullable] => ) [account_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [notify_message] => Array ( [type] => text ) [notify_created] => Array ( [type] => timestamp [default] => current_timestamp [nullable] => ) [notify_type] => Array ( [type] => ascii [precision] => 32 ) ) [pk] => Array ( [0] => notify_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id [1] => notify_created ) [uc] => Array ( ) ) AlterColumnSQL('egw_notificationpopup','notify_message C(16384)','notify_id I AUTOINCREMENT NOTNULL PRIMARY, account_id I4 NOTNULL, notify_message C(16384), notify_created T DEFTIMESTAMP NOTNULL, notify_type C(32) CONSTRAINT "CHARACTER SET ascii"') sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` MODIFY COLUMN `notify_message` VARCHAR(16384) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_notificationpopup') = NULL schema_proc::GetTableDefintion('egw_notificationpopup') = Array ( [fd] => Array ( [notify_id] => Array ( [type] => auto [nullable] => ) [account_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [notify_message] => Array ( [type] => varchar [precision] => 16384 ) [notify_created] => Array ( [type] => timestamp [default] => current_timestamp [nullable] => ) [notify_type] => Array ( [type] => ascii [precision] => 32 ) ) [pk] => Array ( [0] => notify_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id [1] => notify_created ) [uc] => Array ( ) ) AlterColumnSQL('egw_notificationpopup','notify_type C(32) CONSTRAINT "CHARACTER SET ascii"','notify_id I AUTOINCREMENT NOTNULL PRIMARY, account_id I4 NOTNULL, notify_message C(16384), notify_created T DEFTIMESTAMP NOTNULL, notify_type C(32) CONSTRAINT "CHARACTER SET ascii"') sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` MODIFY COLUMN `notify_type` VARCHAR(32) CHARACTER SET ascii )  --> 14.3  process->upgrade(): notifications(14.3 --> 17.1.002): running notifications_upgrade14_3() --> 16.1  process->upgrade(): notifications(16.1 --> 17.1.002): running notifications_upgrade16_1() AlterColumnSQL('egw_notificationpopup','notify_status',Array ( [type] => varchar [precision] => 32 [comment] => notification status ) ) sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` ADD `notify_status` VARCHAR(32) )  --> 17.1  process->upgrade(): notifications(17.1 --> 17.1.002): running notifications_upgrade17_1() AlterColumnSQL('egw_notificationpopup','notify_data',Array ( [type] => varchar [precision] => 4096 [comment] => notification actions ) ) sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` ADD `notify_data` VARCHAR(4096) )  --> 17.1.001  process->upgrade(): notifications(17.1.001 --> 17.1.002): running notifications_upgrade17_1_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_notificationpopup') = NULL schema_proc::GetTableDefintion('egw_notificationpopup') = Array ( [fd] => Array ( [notify_id] => Array ( [type] => auto [nullable] => ) [account_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [notify_message] => Array ( [type] => varchar [precision] => 16384 ) [notify_created] => Array ( [type] => timestamp [default] => current_timestamp [nullable] => ) [notify_type] => Array ( [type] => ascii [precision] => 32 ) [notify_status] => Array ( [type] => varchar [precision] => 32 ) [notify_data] => Array ( [type] => varchar [precision] => 4096 ) ) [pk] => Array ( [0] => notify_id ) [fk] => Array ( ) [ix] => Array ( [0] => account_id [1] => notify_created ) [uc] => Array ( ) ) AlterColumnSQL('egw_notificationpopup','notify_message X','notify_id I AUTOINCREMENT NOTNULL PRIMARY, account_id I4 NOTNULL, notify_message X, notify_created T DEFTIMESTAMP NOTNULL, notify_type C(32) CONSTRAINT "CHARACTER SET ascii", notify_status C(32), notify_data C(4096)') sql=Array ( [0] => ALTER TABLE `egw_notificationpopup` MODIFY COLUMN `notify_message` TEXT )  --> 17.1.002  process->upgrade(): Upgrade of notifications to 17.1.002 is completed.  process->upgrade(): Outgoing : appname: notifications, status: C process->upgrade(): Incoming : appname: phpbrain, version: 1.8, status: U  process->upgrade(): phpbrain(1.8 --> 14.1): running phpbrain_upgrade1_8() CreateIndexSQL('egw_kb_articles','cat_id',Array ( ) ,'egw_kb_articles_cat_id') sql=Array ( [0] => ALTER TABLE `egw_kb_articles` ADD INDEX `egw_kb_articles_cat_id` (`cat_id`) )  CreateIndexSQL('egw_kb_articles',Array ( [0] => art_id [1] => cat_id ) ,Array ( ) ,'egw_kb_articles_art_id_cat_id') sql=Array ( [0] => ALTER TABLE `egw_kb_articles` ADD INDEX `egw_kb_articles_art_id_cat_id` (`art_id`, `cat_id`) )  --> 1.8.001  process->upgrade(): phpbrain(1.8.001 --> 14.1): running phpbrain_upgrade1_8_001() --> 14.1  process->upgrade(): Upgrade of phpbrain to 14.1 is completed.  process->upgrade(): Outgoing : appname: phpbrain, status: C process->upgrade(): Incoming : appname: projectmanager, version: 1.8, status: U  process->upgrade(): projectmanager(1.8 --> 17.1): running projectmanager_upgrade1_8() schema_proc::CreateTable('egw_pm_eroles', Array ( [fd] => Array ( [role_id] => Array ( [type] => auto [nullable] => ) [pm_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [role_title] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [role_description] => Array ( [type] => varchar [precision] => 255 ) ) [pk] => Array ( [0] => role_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) ) CreateTableSQL('egw_pm_eroles','role_id I AUTOINCREMENT NOTNULL PRIMARY, pm_id I4 NOQUOTE DEFAULT 0, role_title C(80) NOTNULL, role_description C(255)') sql=Array ( [0] => CREATE TABLE `egw_pm_eroles` ( `role_id` INTEGER NOT NULL AUTO_INCREMENT, `pm_id` INTEGER DEFAULT 0, `role_title` VARCHAR(80) NOT NULL, `role_description` VARCHAR(255), PRIMARY KEY (`role_id`) )CHARACTER SET utf8 )  AlterColumnSQL('egw_pm_elements','pe_eroles',Array ( [type] => varchar [precision] => 255 ) ) sql=Array ( [0] => ALTER TABLE `egw_pm_elements` ADD `pe_eroles` VARCHAR(255) )  --> 1.9  process->upgrade(): projectmanager(1.9 --> 17.1): running projectmanager_upgrade1_9() AlterColumnSQL('egw_pm_eroles','role_multi',Array ( [type] => bool [nullable] => [default] => ) ) sql=Array ( [0] => ALTER TABLE `egw_pm_eroles` ADD `role_multi` TINYINT NOT NULL DEFAULT 0 )  --> 1.9.001  process->upgrade(): projectmanager(1.9.001 --> 17.1): running projectmanager_upgrade1_9_001() --> 1.9.002  process->upgrade(): projectmanager(1.9.002 --> 17.1): running projectmanager_upgrade1_9_002() --> 1.9.003  process->upgrade(): projectmanager(1.9.003 --> 17.1): running projectmanager_upgrade1_9_003() AlterColumnSQL('egw_pm_constraints','type',Array ( [type] => int [precision] => 1 [nullable] => [default] => 0 [comment] => Constraint type, see projectmanager_constraints_so::$constraint_types ) ) sql=Array ( [0] => ALTER TABLE `egw_pm_constraints` ADD `type` TINYINT NOT NULL DEFAULT 0 )  --> 1.9.004  process->upgrade(): projectmanager(1.9.004 --> 17.1): running projectmanager_upgrade1_9_004() --> 14.1  process->upgrade(): projectmanager(14.1 --> 17.1): running projectmanager_upgrade14_1() --> 14.2  process->upgrade(): projectmanager(14.2 --> 17.1): running projectmanager_upgrade14_2() --> 16.1  process->upgrade(): projectmanager(16.1 --> 17.1): running projectmanager_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of projectmanager to 17.1 is completed.  process->upgrade(): Outgoing : appname: projectmanager, status: C process->upgrade(): Incoming : appname: resources, version: 1.9.001, status: U  process->upgrade(): resources(1.9.001 --> 17.1): running resources_upgrade1_9_001() AlterColumnSQL('egw_resources','deleted',Array ( [type] => int [precision] => 8 ) ) sql=Array ( [0] => ALTER TABLE `egw_resources` ADD `deleted` BIGINT )  --> 1.9.002  process->upgrade(): resources(1.9.002 --> 17.1): running resources_upgrade1_9_002() --> 1.9.003  process->upgrade(): resources(1.9.003 --> 17.1): running resources_upgrade1_9_003() AlterColumnSQL('egw_resources','res_creator',Array ( [type] => int [meta] => user [precision] => 11 ) ) sql=Array ( [0] => ALTER TABLE `egw_resources` ADD `res_creator` INTEGER )  AlterColumnSQL('egw_resources','res_created',Array ( [type] => int [meta] => timestamp [precision] => 8 ) ) sql=Array ( [0] => ALTER TABLE `egw_resources` ADD `res_created` BIGINT )  AlterColumnSQL('egw_resources','res_modifier',Array ( [type] => int [meta] => user [precision] => 11 ) ) sql=Array ( [0] => ALTER TABLE `egw_resources` ADD `res_modifier` INTEGER )  AlterColumnSQL('egw_resources','res_modified',Array ( [type] => int [meta] => timestamp [precision] => 8 ) ) sql=Array ( [0] => ALTER TABLE `egw_resources` ADD `res_modified` BIGINT )  --> 1.9.004  process->upgrade(): resources(1.9.004 --> 17.1): running resources_upgrade1_9_004() --> 14.1  process->upgrade(): resources(14.1 --> 17.1): running resources_upgrade14_1() --> 16.1  process->upgrade(): resources(16.1 --> 17.1): running resources_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of resources to 17.1 is completed.  process->upgrade(): Outgoing : appname: resources, status: C process->upgrade(): Incoming : appname: timesheet, version: 1.8, status: U  process->upgrade(): timesheet(1.8 --> 17.1.001): running timesheet_upgrade1_8() --> 1.9.001  process->upgrade(): timesheet(1.9.001 --> 17.1.001): running timesheet_upgrade1_9_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_timesheet') = NULL schema_proc::GetTableDefintion('egw_timesheet') = Array ( [fd] => Array ( [ts_id] => Array ( [type] => auto [nullable] => ) [ts_project] => Array ( [type] => varchar [precision] => 80 ) [ts_title] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [ts_description] => Array ( [type] => text ) [ts_start] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_duration] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_quantity] => Array ( [type] => float [precision] => -1 [default] => 0 [nullable] => ) [ts_unitprice] => Array ( [type] => float [precision] => -1 ) [cat_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [ts_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [ts_modified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [pl_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [ts_status] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => ts_id ) [fk] => Array ( ) [ix] => Array ( [0] => ts_project [1] => ts_owner [2] => ts_status ) [uc] => Array ( ) ) AlterColumnSQL('egw_timesheet','ts_project C(255)','ts_id I AUTOINCREMENT NOTNULL PRIMARY, ts_project C(255), ts_title C(80) NOTNULL, ts_description X, ts_start I8 NOTNULL NOQUOTE DEFAULT 0, ts_duration I8 NOTNULL NOQUOTE DEFAULT 0, ts_quantity F NOTNULL NOQUOTE DEFAULT 0, ts_unitprice F, cat_id I4 NOQUOTE DEFAULT 0, ts_owner I4 NOTNULL NOQUOTE DEFAULT 0, ts_modified I8 NOTNULL NOQUOTE DEFAULT 0, ts_modifier I4 NOTNULL NOQUOTE DEFAULT 0, pl_id I4 NOQUOTE DEFAULT 0, ts_status I4') sql=Array ( [0] => ALTER TABLE `egw_timesheet` MODIFY COLUMN `ts_project` VARCHAR(255) )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_timesheet') = NULL schema_proc::GetTableDefintion('egw_timesheet') = Array ( [fd] => Array ( [ts_id] => Array ( [type] => auto [nullable] => ) [ts_project] => Array ( [type] => varchar [precision] => 255 ) [ts_title] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [ts_description] => Array ( [type] => text ) [ts_start] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_duration] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_quantity] => Array ( [type] => float [precision] => -1 [default] => 0 [nullable] => ) [ts_unitprice] => Array ( [type] => float [precision] => -1 ) [cat_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [ts_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [ts_modified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [pl_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [ts_status] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => ts_id ) [fk] => Array ( ) [ix] => Array ( [0] => ts_project [1] => ts_owner [2] => ts_status ) [uc] => Array ( ) ) AlterColumnSQL('egw_timesheet','ts_title C(255) NOTNULL','ts_id I AUTOINCREMENT NOTNULL PRIMARY, ts_project C(255), ts_title C(255) NOTNULL, ts_description X, ts_start I8 NOTNULL NOQUOTE DEFAULT 0, ts_duration I8 NOTNULL NOQUOTE DEFAULT 0, ts_quantity F NOTNULL NOQUOTE DEFAULT 0, ts_unitprice F, cat_id I4 NOQUOTE DEFAULT 0, ts_owner I4 NOTNULL NOQUOTE DEFAULT 0, ts_modified I8 NOTNULL NOQUOTE DEFAULT 0, ts_modifier I4 NOTNULL NOQUOTE DEFAULT 0, pl_id I4 NOQUOTE DEFAULT 0, ts_status I4') sql=Array ( [0] => ALTER TABLE `egw_timesheet` MODIFY COLUMN `ts_title` VARCHAR(255) NOT NULL )  --> 1.9.002  process->upgrade(): timesheet(1.9.002 --> 17.1.001): running timesheet_upgrade1_9_002() --> 14.1  process->upgrade(): timesheet(14.1 --> 17.1.001): running timesheet_upgrade14_1() --> 16.1  process->upgrade(): timesheet(16.1 --> 17.1.001): running timesheet_upgrade16_1() AlterColumnSQL('egw_timesheet','ts_created',Array ( [type] => int [meta] => timestamp [precision] => 8 [nullable] => 1 ) ) sql=Array ( [0] => ALTER TABLE `egw_timesheet` ADD `ts_created` BIGINT )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_timesheet') = NULL schema_proc::GetTableDefintion('egw_timesheet') = Array ( [fd] => Array ( [ts_id] => Array ( [type] => auto [nullable] => ) [ts_project] => Array ( [type] => varchar [precision] => 255 ) [ts_title] => Array ( [type] => varchar [precision] => 255 [nullable] => ) [ts_description] => Array ( [type] => text ) [ts_start] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_duration] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_quantity] => Array ( [type] => float [precision] => -1 [default] => 0 [nullable] => ) [ts_unitprice] => Array ( [type] => float [precision] => -1 ) [cat_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [ts_owner] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [ts_modified] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [ts_modifier] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [pl_id] => Array ( [type] => int [precision] => 4 [default] => 0 ) [ts_status] => Array ( [type] => int [precision] => 4 ) [ts_created] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => ts_id ) [fk] => Array ( ) [ix] => Array ( [0] => ts_project [1] => ts_owner [2] => ts_status ) [uc] => Array ( ) ) AlterColumnSQL('egw_timesheet','ts_created I8 NOTNULL','ts_id I AUTOINCREMENT NOTNULL PRIMARY, ts_project C(255), ts_title C(255) NOTNULL, ts_description X, ts_start I8 NOTNULL NOQUOTE DEFAULT 0, ts_duration I8 NOTNULL NOQUOTE DEFAULT 0, ts_quantity F NOTNULL NOQUOTE DEFAULT 0, ts_unitprice F, cat_id I4 NOQUOTE DEFAULT 0, ts_owner I4 NOTNULL NOQUOTE DEFAULT 0, ts_modified I8 NOTNULL NOQUOTE DEFAULT 0, ts_modifier I4 NOTNULL NOQUOTE DEFAULT 0, pl_id I4 NOQUOTE DEFAULT 0, ts_status I4, ts_created I8 NOTNULL') sql=Array ( [0] => ALTER TABLE `egw_timesheet` MODIFY COLUMN `ts_created` BIGINT NOT NULL )  --> 17.1  process->upgrade(): timesheet(17.1 --> 17.1.001): running timesheet_upgrade17_1() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_timesheet_extra') = NULL schema_proc::GetTableDefintion('egw_timesheet_extra') = Array ( [fd] => Array ( [ts_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [ts_extra_name] => Array ( [type] => varchar [precision] => 32 [nullable] => ) [ts_extra_value] => Array ( [type] => varchar [precision] => 255 [nullable] => ) ) [pk] => Array ( [0] => ts_id [1] => ts_extra_name ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_timesheet_extra','ts_extra_name C(64) NOTNULL','ts_id I4 NOTNULL PRIMARY, ts_extra_name C(64) NOTNULL PRIMARY, ts_extra_value C(255) NOTNULL') sql=Array ( [0] => ALTER TABLE `egw_timesheet_extra` MODIFY COLUMN `ts_extra_name` VARCHAR(64) NOT NULL )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_timesheet_extra') = NULL schema_proc::GetTableDefintion('egw_timesheet_extra') = Array ( [fd] => Array ( [ts_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [ts_extra_name] => Array ( [type] => varchar [precision] => 64 [nullable] => ) [ts_extra_value] => Array ( [type] => varchar [precision] => 255 [nullable] => ) ) [pk] => Array ( [0] => ts_id [1] => ts_extra_name ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_timesheet_extra','ts_extra_value C(16384) NOTNULL DEFAULT ''','ts_id I4 NOTNULL PRIMARY, ts_extra_name C(64) NOTNULL PRIMARY, ts_extra_value C(16384) NOTNULL DEFAULT ''') sql=Array ( [0] => ALTER TABLE `egw_timesheet_extra` MODIFY COLUMN `ts_extra_value` VARCHAR(16384) NOT NULL DEFAULT '' )  --> 17.1.001  process->upgrade(): Upgrade of timesheet to 17.1.001 is completed.  process->upgrade(): Outgoing : appname: timesheet, status: C process->upgrade(): Incoming : appname: tracker, version: 1.8, status: U  process->upgrade(): tracker(1.8 --> 17.1.002): running tracker_upgrade1_8() schema_proc::RefreshTable('egw_tracker_replies', Array ( [fd] => Array ( [reply_id] => Array ( [type] => auto [nullable] => ) [tr_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [reply_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [reply_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [reply_message] => Array ( [type] => text ) [reply_visible] => Array ( [type] => int [precision] => 1 [nullable] => [default] => 0 ) ) [pk] => Array ( [0] => reply_id ) [fk] => Array ( ) [ix] => Array ( [0] => reply_visible [1] => Array ( [0] => tr_id [1] => reply_created ) ) [uc] => Array ( ) ) ) schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker_replies') = NULL schema_proc::GetTableDefintion('egw_tracker_replies') = Array ( [fd] => Array ( [reply_id] => Array ( [type] => auto [nullable] => ) [tr_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [reply_creator] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [reply_created] => Array ( [type] => int [precision] => 8 [default] => 0 [nullable] => ) [reply_message] => Array ( [type] => text ) ) [pk] => Array ( [0] => reply_id ) [fk] => Array ( ) [ix] => Array ( [0] => Array ( [0] => tr_id [1] => reply_created ) ) [uc] => Array ( ) ) RenameTableSQL('egw_tracker_replies','tmp_egw_tracker_replies') sql=Array ( [0] => RENAME TABLE `egw_tracker_replies` TO `tmp_egw_tracker_replies` )  schema_proc::CreateTable('egw_tracker_replies', Array ( [fd] => Array ( [reply_id] => Array ( [type] => auto [nullable] => ) [tr_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [reply_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [reply_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [reply_message] => Array ( [type] => text ) [reply_visible] => Array ( [type] => int [precision] => 1 [nullable] => [default] => 0 ) ) [pk] => Array ( [0] => reply_id ) [fk] => Array ( ) [ix] => Array ( [0] => reply_visible [1] => Array ( [0] => tr_id [1] => reply_created ) ) [uc] => Array ( ) ) ) CreateTableSQL('egw_tracker_replies','reply_id I AUTOINCREMENT NOTNULL PRIMARY, tr_id I4 NOTNULL, reply_creator I4 NOTNULL, reply_created I8 NOTNULL, reply_message X, reply_visible I1 NOTNULL DEFAULT 0') sql=Array ( [0] => CREATE TABLE `egw_tracker_replies` ( `reply_id` INTEGER NOT NULL AUTO_INCREMENT, `tr_id` INTEGER NOT NULL, `reply_creator` INTEGER NOT NULL, `reply_created` BIGINT NOT NULL, `reply_message` TEXT, `reply_visible` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (`reply_id`) )CHARACTER SET utf8 )  CreateIndexSQL('egw_tracker_replies','reply_visible',Array ( ) ,'egw_tracker_replies_reply_visible') sql=Array ( [0] => ALTER TABLE `egw_tracker_replies` ADD INDEX `egw_tracker_replies_reply_visible` (`reply_visible`) )  CreateIndexSQL('egw_tracker_replies',Array ( [0] => tr_id [1] => reply_created ) ,Array ( ) ,'egw_tracker_replies_tr_id_reply_created') sql=Array ( [0] => ALTER TABLE `egw_tracker_replies` ADD INDEX `egw_tracker_replies_tr_id_reply_created` (`tr_id`, `reply_created`) )  DropTable('tmp_egw_tracker_replies') sql=Array ( [0] => DROP TABLE IF EXISTS `tmp_egw_tracker_replies` )  --> 1.9.001  process->upgrade(): tracker(1.9.001 --> 17.1.002): running tracker_upgrade1_9_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker') = NULL schema_proc::GetTableDefintion('egw_tracker') = Array ( [fd] => Array ( [tr_id] => Array ( [type] => auto [nullable] => ) [tr_summary] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 ) [tr_version] => Array ( [type] => int [precision] => 4 ) [tr_status] => Array ( [type] => int [precision] => 4 [default] => -100 ) [tr_description] => Array ( [type] => text ) [tr_private] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_budget] => Array ( [type] => decimal [precision] => 20 [scale] => 2 ) [tr_completion] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [tr_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [tr_modifier] => Array ( [type] => int [precision] => 4 ) [tr_modified] => Array ( [type] => int [precision] => 8 ) [tr_closed] => Array ( [type] => int [precision] => 8 ) [tr_priority] => Array ( [type] => int [precision] => 2 [default] => 5 ) [tr_resolution] => Array ( [type] => varchar [precision] => 1 [default] => n ) [tr_cc] => Array ( [type] => text ) [tr_group] => Array ( [type] => int [precision] => 4 ) [tr_edit_mode] => Array ( [type] => varchar [precision] => 5 [default] => ascii ) [tr_seen] => Array ( [type] => text ) ) [pk] => Array ( [0] => tr_id ) [fk] => Array ( ) [ix] => Array ( [0] => tr_summary [1] => tr_tracker [2] => tr_version [3] => tr_status [4] => tr_group [5] => Array ( [0] => cat_id [1] => tr_status ) ) [uc] => Array ( ) ) RenameColumnSQL('egw_tracker','tr_resolution','char_tr_resolution') sql=Array ( [0] => ALTER TABLE `egw_tracker` CHANGE COLUMN `tr_resolution` `char_tr_resolution` VARCHAR(1) DEFAULT 'n' )  AlterColumnSQL('egw_tracker','tr_resolution',Array ( [type] => int [precision] => 4 ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD `tr_resolution` INTEGER )  schema_proc::RefreshTable('egw_tracker', Array ( [fd] => Array ( [tr_id] => Array ( [type] => auto [nullable] => ) [tr_summary] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 ) [tr_version] => Array ( [type] => int [precision] => 4 ) [tr_status] => Array ( [type] => int [precision] => 4 [default] => -100 ) [tr_description] => Array ( [type] => text ) [tr_private] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_budget] => Array ( [type] => decimal [precision] => 20 [scale] => 2 ) [tr_completion] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [tr_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [tr_modifier] => Array ( [type] => int [precision] => 4 ) [tr_modified] => Array ( [type] => int [precision] => 8 ) [tr_closed] => Array ( [type] => int [precision] => 8 ) [tr_priority] => Array ( [type] => int [precision] => 2 [default] => 5 ) [tr_resolution] => Array ( [type] => int [precision] => 4 ) [tr_cc] => Array ( [type] => text ) [tr_group] => Array ( [type] => int [precision] => 11 ) [tr_edit_mode] => Array ( [type] => varchar [precision] => 5 [default] => ascii ) [tr_seen] => Array ( [type] => text ) ) [pk] => Array ( [0] => tr_id ) [fk] => Array ( ) [ix] => Array ( [0] => tr_summary [1] => tr_tracker [2] => tr_version [3] => tr_status [4] => tr_resolution [5] => tr_group [6] => Array ( [0] => cat_id [1] => tr_status ) ) [uc] => Array ( ) ) ) schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker') = NULL schema_proc::GetTableDefintion('egw_tracker') = Array ( [fd] => Array ( [tr_id] => Array ( [type] => auto [nullable] => ) [tr_summary] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 ) [tr_version] => Array ( [type] => int [precision] => 4 ) [tr_status] => Array ( [type] => int [precision] => 4 [default] => -100 ) [tr_description] => Array ( [type] => text ) [tr_private] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_budget] => Array ( [type] => decimal [precision] => 20 [scale] => 2 ) [tr_completion] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [tr_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [tr_modifier] => Array ( [type] => int [precision] => 4 ) [tr_modified] => Array ( [type] => int [precision] => 8 ) [tr_closed] => Array ( [type] => int [precision] => 8 ) [tr_priority] => Array ( [type] => int [precision] => 2 [default] => 5 ) [char_tr_resolution] => Array ( [type] => varchar [precision] => 1 [default] => n ) [tr_cc] => Array ( [type] => text ) [tr_group] => Array ( [type] => int [precision] => 4 ) [tr_edit_mode] => Array ( [type] => varchar [precision] => 5 [default] => ascii ) [tr_seen] => Array ( [type] => text ) [tr_resolution] => Array ( [type] => int [precision] => 4 ) ) [pk] => Array ( [0] => tr_id ) [fk] => Array ( ) [ix] => Array ( [0] => tr_summary [1] => tr_tracker [2] => tr_version [3] => tr_status [4] => tr_group [5] => Array ( [0] => cat_id [1] => tr_status ) ) [uc] => Array ( ) ) RenameTableSQL('egw_tracker','tmp_egw_tracker') sql=Array ( [0] => RENAME TABLE `egw_tracker` TO `tmp_egw_tracker` )  schema_proc::CreateTable('egw_tracker', Array ( [fd] => Array ( [tr_id] => Array ( [type] => auto [nullable] => ) [tr_summary] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 ) [tr_version] => Array ( [type] => int [precision] => 4 ) [tr_status] => Array ( [type] => int [precision] => 4 [default] => -100 ) [tr_description] => Array ( [type] => text ) [tr_private] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_budget] => Array ( [type] => decimal [precision] => 20 [scale] => 2 ) [tr_completion] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [tr_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [tr_modifier] => Array ( [type] => int [precision] => 4 ) [tr_modified] => Array ( [type] => int [precision] => 8 ) [tr_closed] => Array ( [type] => int [precision] => 8 ) [tr_priority] => Array ( [type] => int [precision] => 2 [default] => 5 ) [tr_resolution] => Array ( [type] => int [precision] => 4 ) [tr_cc] => Array ( [type] => text ) [tr_group] => Array ( [type] => int [precision] => 11 ) [tr_edit_mode] => Array ( [type] => varchar [precision] => 5 [default] => ascii ) [tr_seen] => Array ( [type] => text ) ) [pk] => Array ( [0] => tr_id ) [fk] => Array ( ) [ix] => Array ( [0] => tr_summary [1] => tr_tracker [2] => tr_version [3] => tr_status [4] => tr_resolution [5] => tr_group [6] => Array ( [0] => cat_id [1] => tr_status ) ) [uc] => Array ( ) ) ) CreateTableSQL('egw_tracker','tr_id I AUTOINCREMENT NOTNULL PRIMARY, tr_summary C(80) NOTNULL, tr_tracker I4 NOTNULL, cat_id I4, tr_version I4, tr_status I4 NOQUOTE DEFAULT -100, tr_description X, tr_private I2 NOQUOTE DEFAULT 0, tr_budget N(20.2), tr_completion I2 NOQUOTE DEFAULT 0, tr_creator I4 NOTNULL, tr_created I8 NOTNULL, tr_modifier I4, tr_modified I8, tr_closed I8, tr_priority I2 NOQUOTE DEFAULT 5, tr_resolution I4, tr_cc X, tr_group I, tr_edit_mode C(5) DEFAULT 'ascii', tr_seen X') sql=Array ( [0] => CREATE TABLE `egw_tracker` ( `tr_id` INTEGER NOT NULL AUTO_INCREMENT, `tr_summary` VARCHAR(80) NOT NULL, `tr_tracker` INTEGER NOT NULL, `cat_id` INTEGER, `tr_version` INTEGER, `tr_status` INTEGER DEFAULT -100, `tr_description` TEXT, `tr_private` SMALLINT DEFAULT 0, `tr_budget` NUMERIC(20,2), `tr_completion` SMALLINT DEFAULT 0, `tr_creator` INTEGER NOT NULL, `tr_created` BIGINT NOT NULL, `tr_modifier` INTEGER, `tr_modified` BIGINT, `tr_closed` BIGINT, `tr_priority` SMALLINT DEFAULT 5, `tr_resolution` INTEGER, `tr_cc` TEXT, `tr_group` INTEGER, `tr_edit_mode` VARCHAR(5) DEFAULT 'ascii', `tr_seen` TEXT, PRIMARY KEY (`tr_id`) )CHARACTER SET utf8 )  CreateIndexSQL('egw_tracker','tr_summary',Array ( ) ,'egw_tracker_tr_summary') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_tr_summary` (`tr_summary`) )  CreateIndexSQL('egw_tracker','tr_tracker',Array ( ) ,'egw_tracker_tr_tracker') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_tr_tracker` (`tr_tracker`) )  CreateIndexSQL('egw_tracker','tr_version',Array ( ) ,'egw_tracker_tr_version') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_tr_version` (`tr_version`) )  CreateIndexSQL('egw_tracker','tr_status',Array ( ) ,'egw_tracker_tr_status') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_tr_status` (`tr_status`) )  CreateIndexSQL('egw_tracker','tr_resolution',Array ( ) ,'egw_tracker_tr_resolution') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_tr_resolution` (`tr_resolution`) )  CreateIndexSQL('egw_tracker','tr_group',Array ( ) ,'egw_tracker_tr_group') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_tr_group` (`tr_group`) )  CreateIndexSQL('egw_tracker',Array ( [0] => cat_id [1] => tr_status ) ,Array ( ) ,'egw_tracker_cat_id_tr_status') sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD INDEX `egw_tracker_cat_id_tr_status` (`cat_id`, `tr_status`) )  DropTable('tmp_egw_tracker') sql=Array ( [0] => DROP TABLE IF EXISTS `tmp_egw_tracker` )  --> 1.9.003  process->upgrade(): tracker(1.9.003 --> 17.1.002): running tracker_upgrade1_9_003() AlterColumnSQL('egw_tracker','tr_startdate',Array ( [type] => int [precision] => 8 [comment] => Date ticket is scheduled to begin ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD `tr_startdate` BIGINT )  AlterColumnSQL('egw_tracker','tr_duedate',Array ( [type] => int [precision] => 8 [comment] => Date ticket is required to be resolved by ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker` ADD `tr_duedate` BIGINT )  --> 1.9.004  process->upgrade(): tracker(1.9.004 --> 17.1.002): running tracker_upgrade1_9_004() AlterColumnSQL('egw_tracker_escalations','esc_reply_visible',Array ( [type] => int [precision] => 1 ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` ADD `esc_reply_visible` TINYINT )  AlterColumnSQL('egw_tracker_escalations','esc_match_repeat',Array ( [type] => int [precision] => 4 [default] => 0 ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` ADD `esc_match_repeat` INTEGER DEFAULT 0 )  --> 1.9.005  process->upgrade(): tracker(1.9.005 --> 17.1.002): running tracker_upgrade1_9_005() AlterColumnSQL('egw_tracker_escalations','esc_notify',Array ( [type] => varchar [precision] => 15 ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` ADD `esc_notify` VARCHAR(15) )  --> 1.9.006  process->upgrade(): tracker(1.9.006 --> 17.1.002): running tracker_upgrade1_9_006() AlterColumnSQL('egw_tracker_escalations','esc_limit',Array ( [type] => int [precision] => 1 [comment] => Limit on how many times one ticket will match ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` ADD `esc_limit` TINYINT )  --> 1.9.007  process->upgrade(): tracker(1.9.007 --> 17.1.002): running tracker_upgrade1_9_007() AlterColumnSQL('egw_tracker_escalated','match_count',Array ( [type] => int [precision] => 1 [nullable] => [default] => 1 ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalated` ADD `match_count` TINYINT NOT NULL DEFAULT 1 )  DropIndexSQL('i45c42f5d1e3a78e012db10558224f'( Array ( [0] => tr_tracker [1] => cat_id [2] => tr_version [3] => tr_status [4] => tr_priority [5] => esc_time [6] => esc_type ) ),'egw_tracker_escalations') sql=Array ( [0] => DROP INDEX `i45c42f5d1e3a78e012db10558224f` ON `egw_tracker_escalations` )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker_escalations') = NULL schema_proc::GetTableDefintion('egw_tracker_escalations') = Array ( [fd] => Array ( [esc_id] => Array ( [type] => auto [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [tr_version] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [tr_status] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [tr_priority] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [esc_title] => Array ( [type] => varchar [precision] => 128 [nullable] => ) [esc_time] => Array ( [type] => int [precision] => 4 [nullable] => ) [esc_type] => Array ( [type] => int [precision] => 1 [default] => 0 [nullable] => ) [esc_tr_assigned] => Array ( [type] => varchar [precision] => 255 ) [esc_add_assigned] => Array ( [type] => bool ) [esc_tr_tracker] => Array ( [type] => int [precision] => 4 ) [esc_cat_id] => Array ( [type] => int [precision] => 4 ) [esc_tr_version] => Array ( [type] => int [precision] => 4 ) [esc_tr_status] => Array ( [type] => int [precision] => 4 ) [esc_tr_priority] => Array ( [type] => int [precision] => 4 ) [esc_reply_message] => Array ( [type] => text ) [esc_reply_visible] => Array ( [type] => int [precision] => 1 ) [esc_match_repeat] => Array ( [type] => int [precision] => 4 [default] => 0 ) [esc_notify] => Array ( [type] => varchar [precision] => 15 ) [esc_limit] => Array ( [type] => int [precision] => 1 ) ) [pk] => Array ( [0] => esc_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker_escalations','tr_tracker C(55) NOTNULL DEFAULT '0'','esc_id I AUTOINCREMENT NOTNULL PRIMARY, tr_tracker C(55) NOTNULL DEFAULT '0', cat_id I4 NOTNULL NOQUOTE DEFAULT 0, tr_version I4 NOTNULL NOQUOTE DEFAULT 0, tr_status C(255) NOTNULL DEFAULT '0', tr_priority I4 NOTNULL NOQUOTE DEFAULT 0, esc_title C(128) NOTNULL, esc_time I4 NOTNULL, esc_type I1 NOTNULL NOQUOTE DEFAULT 0, esc_tr_assigned C(255), esc_add_assigned L, esc_tr_tracker I4, esc_cat_id I4, esc_tr_version I4, esc_tr_status I4, esc_tr_priority I4, esc_reply_message X, esc_reply_visible I1, esc_match_repeat I4 NOQUOTE DEFAULT 0, esc_notify C(15), esc_limit I1') sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` MODIFY COLUMN `tr_tracker` VARCHAR(55) NOT NULL DEFAULT '0' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker_escalations') = NULL schema_proc::GetTableDefintion('egw_tracker_escalations') = Array ( [fd] => Array ( [esc_id] => Array ( [type] => auto [nullable] => ) [tr_tracker] => Array ( [type] => varchar [precision] => 55 [default] => 0 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [tr_version] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [tr_status] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [tr_priority] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [esc_title] => Array ( [type] => varchar [precision] => 128 [nullable] => ) [esc_time] => Array ( [type] => int [precision] => 4 [nullable] => ) [esc_type] => Array ( [type] => int [precision] => 1 [default] => 0 [nullable] => ) [esc_tr_assigned] => Array ( [type] => varchar [precision] => 255 ) [esc_add_assigned] => Array ( [type] => bool ) [esc_tr_tracker] => Array ( [type] => int [precision] => 4 ) [esc_cat_id] => Array ( [type] => int [precision] => 4 ) [esc_tr_version] => Array ( [type] => int [precision] => 4 ) [esc_tr_status] => Array ( [type] => int [precision] => 4 ) [esc_tr_priority] => Array ( [type] => int [precision] => 4 ) [esc_reply_message] => Array ( [type] => text ) [esc_reply_visible] => Array ( [type] => int [precision] => 1 ) [esc_match_repeat] => Array ( [type] => int [precision] => 4 [default] => 0 ) [esc_notify] => Array ( [type] => varchar [precision] => 15 ) [esc_limit] => Array ( [type] => int [precision] => 1 ) ) [pk] => Array ( [0] => esc_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker_escalations','cat_id C(55) NOTNULL DEFAULT '0'','esc_id I AUTOINCREMENT NOTNULL PRIMARY, tr_tracker C(55) NOTNULL DEFAULT '0', cat_id C(55) NOTNULL DEFAULT '0', tr_version I4 NOTNULL NOQUOTE DEFAULT 0, tr_status C(255) NOTNULL DEFAULT '0', tr_priority I4 NOTNULL NOQUOTE DEFAULT 0, esc_title C(128) NOTNULL, esc_time I4 NOTNULL, esc_type I1 NOTNULL NOQUOTE DEFAULT 0, esc_tr_assigned C(255), esc_add_assigned L, esc_tr_tracker I4, esc_cat_id I4, esc_tr_version I4, esc_tr_status I4, esc_tr_priority I4, esc_reply_message X, esc_reply_visible I1, esc_match_repeat I4 NOQUOTE DEFAULT 0, esc_notify C(15), esc_limit I1') sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` MODIFY COLUMN `cat_id` VARCHAR(55) NOT NULL DEFAULT '0' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker_escalations') = NULL schema_proc::GetTableDefintion('egw_tracker_escalations') = Array ( [fd] => Array ( [esc_id] => Array ( [type] => auto [nullable] => ) [tr_tracker] => Array ( [type] => varchar [precision] => 55 [default] => 0 [nullable] => ) [cat_id] => Array ( [type] => varchar [precision] => 55 [default] => 0 [nullable] => ) [tr_version] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [tr_status] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [tr_priority] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [esc_title] => Array ( [type] => varchar [precision] => 128 [nullable] => ) [esc_time] => Array ( [type] => int [precision] => 4 [nullable] => ) [esc_type] => Array ( [type] => int [precision] => 1 [default] => 0 [nullable] => ) [esc_tr_assigned] => Array ( [type] => varchar [precision] => 255 ) [esc_add_assigned] => Array ( [type] => bool ) [esc_tr_tracker] => Array ( [type] => int [precision] => 4 ) [esc_cat_id] => Array ( [type] => int [precision] => 4 ) [esc_tr_version] => Array ( [type] => int [precision] => 4 ) [esc_tr_status] => Array ( [type] => int [precision] => 4 ) [esc_tr_priority] => Array ( [type] => int [precision] => 4 ) [esc_reply_message] => Array ( [type] => text ) [esc_reply_visible] => Array ( [type] => int [precision] => 1 ) [esc_match_repeat] => Array ( [type] => int [precision] => 4 [default] => 0 ) [esc_notify] => Array ( [type] => varchar [precision] => 15 ) [esc_limit] => Array ( [type] => int [precision] => 1 ) ) [pk] => Array ( [0] => esc_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker_escalations','tr_version C(55) NOTNULL DEFAULT '0'','esc_id I AUTOINCREMENT NOTNULL PRIMARY, tr_tracker C(55) NOTNULL DEFAULT '0', cat_id C(55) NOTNULL DEFAULT '0', tr_version C(55) NOTNULL DEFAULT '0', tr_status C(255) NOTNULL DEFAULT '0', tr_priority I4 NOTNULL NOQUOTE DEFAULT 0, esc_title C(128) NOTNULL, esc_time I4 NOTNULL, esc_type I1 NOTNULL NOQUOTE DEFAULT 0, esc_tr_assigned C(255), esc_add_assigned L, esc_tr_tracker I4, esc_cat_id I4, esc_tr_version I4, esc_tr_status I4, esc_tr_priority I4, esc_reply_message X, esc_reply_visible I1, esc_match_repeat I4 NOQUOTE DEFAULT 0, esc_notify C(15), esc_limit I1') sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` MODIFY COLUMN `tr_version` VARCHAR(55) NOT NULL DEFAULT '0' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker_escalations') = NULL schema_proc::GetTableDefintion('egw_tracker_escalations') = Array ( [fd] => Array ( [esc_id] => Array ( [type] => auto [nullable] => ) [tr_tracker] => Array ( [type] => varchar [precision] => 55 [default] => 0 [nullable] => ) [cat_id] => Array ( [type] => varchar [precision] => 55 [default] => 0 [nullable] => ) [tr_version] => Array ( [type] => varchar [precision] => 55 [default] => 0 [nullable] => ) [tr_status] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [tr_priority] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [esc_title] => Array ( [type] => varchar [precision] => 128 [nullable] => ) [esc_time] => Array ( [type] => int [precision] => 4 [nullable] => ) [esc_type] => Array ( [type] => int [precision] => 1 [default] => 0 [nullable] => ) [esc_tr_assigned] => Array ( [type] => varchar [precision] => 255 ) [esc_add_assigned] => Array ( [type] => bool ) [esc_tr_tracker] => Array ( [type] => int [precision] => 4 ) [esc_cat_id] => Array ( [type] => int [precision] => 4 ) [esc_tr_version] => Array ( [type] => int [precision] => 4 ) [esc_tr_status] => Array ( [type] => int [precision] => 4 ) [esc_tr_priority] => Array ( [type] => int [precision] => 4 ) [esc_reply_message] => Array ( [type] => text ) [esc_reply_visible] => Array ( [type] => int [precision] => 1 ) [esc_match_repeat] => Array ( [type] => int [precision] => 4 [default] => 0 ) [esc_notify] => Array ( [type] => varchar [precision] => 15 ) [esc_limit] => Array ( [type] => int [precision] => 1 ) ) [pk] => Array ( [0] => esc_id ) [fk] => Array ( ) [ix] => Array ( ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker_escalations','tr_priority C(55) NOTNULL DEFAULT '0'','esc_id I AUTOINCREMENT NOTNULL PRIMARY, tr_tracker C(55) NOTNULL DEFAULT '0', cat_id C(55) NOTNULL DEFAULT '0', tr_version C(55) NOTNULL DEFAULT '0', tr_status C(255) NOTNULL DEFAULT '0', tr_priority C(55) NOTNULL DEFAULT '0', esc_title C(128) NOTNULL, esc_time I4 NOTNULL, esc_type I1 NOTNULL NOQUOTE DEFAULT 0, esc_tr_assigned C(255), esc_add_assigned L, esc_tr_tracker I4, esc_cat_id I4, esc_tr_version I4, esc_tr_status I4, esc_tr_priority I4, esc_reply_message X, esc_reply_visible I1, esc_match_repeat I4 NOQUOTE DEFAULT 0, esc_notify C(15), esc_limit I1') sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` MODIFY COLUMN `tr_priority` VARCHAR(55) NOT NULL DEFAULT '0' )  AlterColumnSQL('egw_tracker_escalations','tr_resolution',Array ( [type] => varchar [precision] => 55 [nullable] => ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` ADD `tr_resolution` VARCHAR(55) NOT NULL )  --> 1.9.008  process->upgrade(): tracker(1.9.008 --> 17.1.002): running tracker_upgrade1_9_008() AlterColumnSQL('egw_tracker_escalations','esc_run_on_existing',Array ( [type] => int [precision] => 1 [nullable] => [default] => 1 ) ) sql=Array ( [0] => ALTER TABLE `egw_tracker_escalations` ADD `esc_run_on_existing` TINYINT NOT NULL DEFAULT 1 )  --> 1.9.009  process->upgrade(): tracker(1.9.009 --> 17.1.002): running tracker_upgrade1_9_009() --> 1.9.010  process->upgrade(): tracker(1.9.010 --> 17.1.002): running tracker_upgrade1_9_010() --> 1.9.011  process->upgrade(): tracker(1.9.011 --> 17.1.002): running tracker_upgrade1_9_011() --> 1.9.012  process->upgrade(): tracker(1.9.012 --> 17.1.002): running tracker_upgrade1_9_012() --> 14.1  process->upgrade(): tracker(14.1 --> 17.1.002): running tracker_upgrade14_1() --> 14.1.001  process->upgrade(): tracker(14.1.001 --> 17.1.002): running tracker_upgrade14_1_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker') = NULL schema_proc::GetTableDefintion('egw_tracker') = Array ( [fd] => Array ( [tr_id] => Array ( [type] => auto [nullable] => ) [tr_summary] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 ) [tr_version] => Array ( [type] => int [precision] => 4 ) [tr_status] => Array ( [type] => int [precision] => 4 [default] => -100 ) [tr_description] => Array ( [type] => text ) [tr_private] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_budget] => Array ( [type] => decimal [precision] => 20 [scale] => 2 ) [tr_completion] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [tr_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [tr_modifier] => Array ( [type] => int [precision] => 4 ) [tr_modified] => Array ( [type] => int [precision] => 8 ) [tr_closed] => Array ( [type] => int [precision] => 8 ) [tr_priority] => Array ( [type] => int [precision] => 2 [default] => 5 ) [tr_resolution] => Array ( [type] => int [precision] => 4 ) [tr_cc] => Array ( [type] => text ) [tr_group] => Array ( [type] => int [precision] => 4 ) [tr_edit_mode] => Array ( [type] => varchar [precision] => 5 [default] => ascii ) [tr_seen] => Array ( [type] => text ) [tr_startdate] => Array ( [type] => int [precision] => 8 ) [tr_duedate] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => tr_id ) [fk] => Array ( ) [ix] => Array ( [0] => tr_summary [1] => tr_tracker [2] => tr_version [3] => tr_status [4] => tr_resolution [5] => tr_group [6] => Array ( [0] => cat_id [1] => tr_status ) ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker','tr_private I2 NOTNULL NOQUOTE DEFAULT 0','tr_id I AUTOINCREMENT NOTNULL PRIMARY, tr_summary C(80) NOTNULL, tr_tracker I4 NOTNULL, cat_id I4, tr_version I4, tr_status I4 NOQUOTE DEFAULT -100, tr_description X, tr_private I2 NOTNULL NOQUOTE DEFAULT 0, tr_budget N(20.2), tr_completion I2 NOQUOTE DEFAULT 0, tr_creator I4 NOTNULL, tr_created I8 NOTNULL, tr_modifier I4, tr_modified I8, tr_closed I8, tr_priority I2 NOQUOTE DEFAULT 5, tr_resolution I4, tr_cc X, tr_group I4, tr_edit_mode C(5) DEFAULT 'ascii', tr_seen X, tr_startdate I8, tr_duedate I8') sql=Array ( [0] => ALTER TABLE `egw_tracker` MODIFY COLUMN `tr_private` SMALLINT NOT NULL DEFAULT 0 )  --> 14.1.002  process->upgrade(): tracker(14.1.002 --> 17.1.002): running tracker_upgrade14_1_002() --> 16.1  process->upgrade(): tracker(16.1 --> 17.1.002): running tracker_upgrade16_1() --> 17.1  process->upgrade(): tracker(17.1 --> 17.1.002): running tracker_upgrade17_1() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker') = NULL schema_proc::GetTableDefintion('egw_tracker') = Array ( [fd] => Array ( [tr_id] => Array ( [type] => auto [nullable] => ) [tr_summary] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [tr_tracker] => Array ( [type] => int [precision] => 4 [nullable] => ) [cat_id] => Array ( [type] => int [precision] => 4 ) [tr_version] => Array ( [type] => int [precision] => 4 ) [tr_status] => Array ( [type] => int [precision] => 4 [default] => -100 ) [tr_description] => Array ( [type] => text ) [tr_private] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [tr_budget] => Array ( [type] => decimal [precision] => 20 [scale] => 2 ) [tr_completion] => Array ( [type] => int [precision] => 2 [default] => 0 ) [tr_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [tr_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [tr_modifier] => Array ( [type] => int [precision] => 4 ) [tr_modified] => Array ( [type] => int [precision] => 8 ) [tr_closed] => Array ( [type] => int [precision] => 8 ) [tr_priority] => Array ( [type] => int [precision] => 2 [default] => 5 ) [tr_resolution] => Array ( [type] => int [precision] => 4 ) [tr_cc] => Array ( [type] => text ) [tr_group] => Array ( [type] => int [precision] => 4 ) [tr_edit_mode] => Array ( [type] => varchar [precision] => 5 [default] => ascii ) [tr_seen] => Array ( [type] => text ) [tr_startdate] => Array ( [type] => int [precision] => 8 ) [tr_duedate] => Array ( [type] => int [precision] => 8 ) ) [pk] => Array ( [0] => tr_id ) [fk] => Array ( ) [ix] => Array ( [0] => tr_summary [1] => tr_tracker [2] => tr_version [3] => tr_status [4] => tr_resolution [5] => tr_group [6] => Array ( [0] => cat_id [1] => tr_status ) ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker','tr_description XL','tr_id I AUTOINCREMENT NOTNULL PRIMARY, tr_summary C(80) NOTNULL, tr_tracker I4 NOTNULL, cat_id I4, tr_version I4, tr_status I4 NOQUOTE DEFAULT -100, tr_description XL, tr_private I2 NOTNULL NOQUOTE DEFAULT 0, tr_budget N(20.2), tr_completion I2 NOQUOTE DEFAULT 0, tr_creator I4 NOTNULL, tr_created I8 NOTNULL, tr_modifier I4, tr_modified I8, tr_closed I8, tr_priority I2 NOQUOTE DEFAULT 5, tr_resolution I4, tr_cc X, tr_group I4, tr_edit_mode C(5) DEFAULT 'ascii', tr_seen X, tr_startdate I8, tr_duedate I8') sql=Array ( [0] => ALTER TABLE `egw_tracker` MODIFY COLUMN `tr_description` LONGTEXT )  --> 17.1.001  process->upgrade(): tracker(17.1.001 --> 17.1.002): running tracker_upgrade17_1_001() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_tracker_replies') = NULL schema_proc::GetTableDefintion('egw_tracker_replies') = Array ( [fd] => Array ( [reply_id] => Array ( [type] => auto [nullable] => ) [tr_id] => Array ( [type] => int [precision] => 4 [nullable] => ) [reply_creator] => Array ( [type] => int [precision] => 4 [nullable] => ) [reply_created] => Array ( [type] => int [precision] => 8 [nullable] => ) [reply_message] => Array ( [type] => text ) [reply_visible] => Array ( [type] => int [precision] => 1 [default] => 0 [nullable] => ) ) [pk] => Array ( [0] => reply_id ) [fk] => Array ( ) [ix] => Array ( [0] => reply_visible [1] => Array ( [0] => tr_id [1] => reply_created ) ) [uc] => Array ( ) ) AlterColumnSQL('egw_tracker_replies','reply_message XL','reply_id I AUTOINCREMENT NOTNULL PRIMARY, tr_id I4 NOTNULL, reply_creator I4 NOTNULL, reply_created I8 NOTNULL, reply_message XL, reply_visible I1 NOTNULL NOQUOTE DEFAULT 0') sql=Array ( [0] => ALTER TABLE `egw_tracker_replies` MODIFY COLUMN `reply_message` LONGTEXT )  --> 17.1.002  process->upgrade(): Upgrade of tracker to 17.1.002 is completed.  process->upgrade(): Outgoing : appname: tracker, status: C process->upgrade(): Incoming : appname: wiki, version: 1.8, status: U  process->upgrade(): wiki(1.8 --> 17.1): running wiki_upgrade1_8() schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_wiki_pages') = NULL schema_proc::GetTableDefintion('egw_wiki_pages') = Array ( [fd] => Array ( [wiki_id] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [wiki_name] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [wiki_lang] => Array ( [type] => varchar [precision] => 5 [nullable] => ) [wiki_version] => Array ( [type] => int [precision] => 4 [default] => 1 [nullable] => ) [wiki_time] => Array ( [type] => int [precision] => 4 ) [wiki_supercede] => Array ( [type] => int [precision] => 4 ) [wiki_readable] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [wiki_writable] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [wiki_username] => Array ( [type] => varchar [precision] => 80 ) [wiki_hostname] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [wiki_comment] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [wiki_title] => Array ( [type] => varchar [precision] => 80 ) [wiki_body] => Array ( [type] => text ) ) [pk] => Array ( [0] => wiki_id [1] => wiki_name [2] => wiki_lang [3] => wiki_version ) [fk] => Array ( ) [ix] => Array ( [0] => wiki_title [1] => wiki_body ) [uc] => Array ( ) ) AlterColumnSQL('egw_wiki_pages','wiki_readable C(255) NOTNULL DEFAULT '0'','wiki_id I2 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, wiki_name C(80) NOTNULL PRIMARY, wiki_lang C(5) NOTNULL PRIMARY, wiki_version I4 NOTNULL NOQUOTE DEFAULT 1 PRIMARY, wiki_time I4, wiki_supercede I4, wiki_readable C(255) NOTNULL DEFAULT '0', wiki_writable I4 NOTNULL NOQUOTE DEFAULT 0, wiki_username C(80), wiki_hostname C(80) NOTNULL, wiki_comment C(80) NOTNULL, wiki_title C(80), wiki_body X') sql=Array ( [0] => ALTER TABLE `egw_wiki_pages` MODIFY COLUMN `wiki_readable` VARCHAR(255) NOT NULL DEFAULT '0' )  schema_proc::GetTableDefintion: MetaPrimaryKeys('egw_wiki_pages') = NULL schema_proc::GetTableDefintion('egw_wiki_pages') = Array ( [fd] => Array ( [wiki_id] => Array ( [type] => int [precision] => 2 [default] => 0 [nullable] => ) [wiki_name] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [wiki_lang] => Array ( [type] => varchar [precision] => 5 [nullable] => ) [wiki_version] => Array ( [type] => int [precision] => 4 [default] => 1 [nullable] => ) [wiki_time] => Array ( [type] => int [precision] => 4 ) [wiki_supercede] => Array ( [type] => int [precision] => 4 ) [wiki_readable] => Array ( [type] => varchar [precision] => 255 [default] => 0 [nullable] => ) [wiki_writable] => Array ( [type] => int [precision] => 4 [default] => 0 [nullable] => ) [wiki_username] => Array ( [type] => varchar [precision] => 80 ) [wiki_hostname] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [wiki_comment] => Array ( [type] => varchar [precision] => 80 [nullable] => ) [wiki_title] => Array ( [type] => varchar [precision] => 80 ) [wiki_body] => Array ( [type] => text ) ) [pk] => Array ( [0] => wiki_id [1] => wiki_name [2] => wiki_lang [3] => wiki_version ) [fk] => Array ( ) [ix] => Array ( [0] => wiki_title [1] => wiki_body ) [uc] => Array ( ) ) AlterColumnSQL('egw_wiki_pages','wiki_writable C(255) NOTNULL DEFAULT '0'','wiki_id I2 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, wiki_name C(80) NOTNULL PRIMARY, wiki_lang C(5) NOTNULL PRIMARY, wiki_version I4 NOTNULL NOQUOTE DEFAULT 1 PRIMARY, wiki_time I4, wiki_supercede I4, wiki_readable C(255) NOTNULL DEFAULT '0', wiki_writable C(255) NOTNULL DEFAULT '0', wiki_username C(80), wiki_hostname C(80) NOTNULL, wiki_comment C(80) NOTNULL, wiki_title C(80), wiki_body X') sql=Array ( [0] => ALTER TABLE `egw_wiki_pages` MODIFY COLUMN `wiki_writable` VARCHAR(255) NOT NULL DEFAULT '0' )  --> 1.9.002  process->upgrade(): wiki(1.9.002 --> 17.1): running wiki_upgrade1_9_002() DropIndexSQL('egw_wiki_pages_body'(Array ( [0] => wiki_body ) ),'egw_wiki_pages') sql=Array ( [0] => DROP INDEX `egw_wiki_pages_body` ON `egw_wiki_pages` )  --> 1.9.003  process->upgrade(): wiki(1.9.003 --> 17.1): running wiki_upgrade1_9_003() --> 14.1  process->upgrade(): wiki(14.1 --> 17.1): running wiki_upgrade14_1() --> 16.1  process->upgrade(): wiki(16.1 --> 17.1): running wiki_upgrade16_1() --> 17.1  process->upgrade(): Upgrade of wiki to 17.1 is completed.  process->upgrade(): Outgoing : appname: wiki, status: C process->pass(): activesync install completed  process->pass(): addressbook skipped on this pass  process->pass(): calendar skipped on this pass  process->pass(): developer_tools skipped on this pass  process->pass(): filemanager skipped on this pass  process->pass(): home skipped on this pass  process->pass(): importexport skipped on this pass  process->pass(): infolog skipped on this pass  process->pass(): mail install completed  process->pass(): news_admin skipped on this pass  process->pass(): notifications skipped on this pass  process->pass(): phpbrain skipped on this pass  process->pass(): projectmanager skipped on this pass  process->pass(): resources skipped on this pass  process->pass(): timesheet skipped on this pass  process->pass(): tracker skipped on this pass  process->pass(): wiki skipped on this pass  process->pass(): #3 for upgrade processing process->upgrade(): Application not installed: archive process->current(): Incoming status: collabora,status: U process->current(): No current tables for Collabora  process->current(): Outgoing status: collabora,status: C process->default_records(): Including default records for collabora process->upgrade(): Application not installed: emailadmin process->pass(): collabora install completed  process->pass(): #4 for upgrade processing process->upgrade(): Application not installed: archive process->upgrade(): Application not installed: emailadmin