Hier noch ein Update vom heutigen Versuch, diesmal die Debugmeldungen vom Setup:
process->pass(): #1 for new processing
process->current(): Incoming status: phpgwapi,status:
process->current(): Including: /var/www/egroupware/phpgwapi/setup/tables_current.inc.php
schema_proc::CreateTable(‘egw_config’,
Array
(
[fd] => Array
(
[config_app] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
[config_name] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[config_value] => Array
(
[type] => text
)
)
[pk] => Array
(
[0] => config_app
[1] => config_name
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_config’,‘config_app C(50) NOTNULL PRIMARY, config_name C(255) NOTNULL PRIMARY, config_value X’) sql=Array ( [0] => CREATE TABLE “egw_config” ( “config_app” VARCHAR(50) NOT NULL, “config_name” VARCHAR(255) NOT NULL, “config_value” TEXT, PRIMARY KEY (“config_app”, “config_name”) ) )
Create Table egw_config
schema_proc::CreateTable(‘egw_applications’,
Array
(
[fd] => Array
(
[app_id] => Array
(
[type] => auto
[precision] => 4
[nullable] =>
)
[app_name] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
[app_enabled] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[app_order] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[app_tables] => Array
(
[type] => text
[nullable] =>
)
[app_version] => Array
(
[type] => varchar
[precision] => 20
[nullable] =>
[default] => 0.0
)
[app_icon] => Array
(
[type] => varchar
[precision] => 32
)
[app_icon_app] => Array
(
[type] => varchar
[precision] => 25
)
[app_index] => Array
(
[type] => varchar
[precision] => 64
)
)
[pk] => Array
(
[0] => app_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => Array
(
[0] => app_enabled
[1] => app_order
)
)
[uc] => Array
(
[0] => app_name
)
)
)
CreateTableSQL(‘egw_applications’,‘app_id I AUTOINCREMENT NOTNULL PRIMARY, app_name C(25) NOTNULL, app_enabled I4 NOTNULL, app_order I4 NOTNULL, app_tables X NOTNULL, app_version C(20) NOTNULL DEFAULT ‘0.0’, app_icon C(32), app_icon_app C(25), app_index C(64)’) sql=Array ( [0] => CREATE TABLE “egw_applications” ( “app_id” SERIAL, “app_name” VARCHAR(25) NOT NULL, “app_enabled” INT4 NOT NULL, “app_order” INT4 NOT NULL, “app_tables” TEXT, “app_version” VARCHAR(20) DEFAULT ‘0.0’ NOT NULL, “app_icon” VARCHAR(32), “app_icon_app” VARCHAR(25), “app_index” VARCHAR(64), PRIMARY KEY (“app_id”) ) )
CreateIndexSQL(NULL,‘egw_applications’,‘app_name’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_applications_name” ON “egw_applications” (“app_name”) )
CreateIndexSQL(NULL,‘egw_applications’,Array ( [0] => app_enabled [1] => app_order ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_applications_enabled_order” ON “egw_applications” (“app_enabled”, “app_order”) )
Create Table egw_applications
schema_proc::CreateTable(‘egw_acl’,
Array
(
[fd] => Array
(
[acl_appname] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
[acl_location] => Array
(
[type] => varchar
[meta] => account
[precision] => 255
[nullable] =>
)
[acl_account] => Array
(
[type] => int
[meta] => account
[precision] => 4
[nullable] =>
)
[acl_rights] => Array
(
[type] => int
[precision] => 4
)
)
[pk] => Array
(
[0] => acl_appname
[1] => acl_location
[2] => acl_account
)
[fk] => Array
(
)
[ix] => Array
(
[0] => acl_account
[1] => Array
(
[0] => acl_location
[1] => acl_account
)
[2] => Array
(
[0] => acl_appname
[1] => acl_account
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_acl’,‘acl_appname C(50) NOTNULL PRIMARY, acl_location C(255) NOTNULL PRIMARY, acl_account I4 NOTNULL PRIMARY, acl_rights I4’) sql=Array ( [0] => CREATE TABLE “egw_acl” ( “acl_appname” VARCHAR(50) NOT NULL, “acl_location” VARCHAR(255) NOT NULL, “acl_account” INT4 NOT NULL, “acl_rights” INT4, PRIMARY KEY (“acl_appname”, “acl_location”, “acl_account”) ) )
CreateIndexSQL(NULL,‘egw_acl’,‘acl_account’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_acl_account” ON “egw_acl” (“acl_account”) )
CreateIndexSQL(NULL,‘egw_acl’,Array ( [0] => acl_location [1] => acl_account ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_acl_location_account” ON “egw_acl” (“acl_location”, “acl_account”) )
CreateIndexSQL(NULL,‘egw_acl’,Array ( [0] => acl_appname [1] => acl_account ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_acl_appname_account” ON “egw_acl” (“acl_appname”, “acl_account”) )
Create Table egw_acl
schema_proc::CreateTable(‘egw_accounts’,
Array
(
[fd] => Array
(
[account_id] => Array
(
[type] => auto
[meta] => account-abs
[nullable] =>
)
[account_lid] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[account_pwd] => Array
(
[type] => varchar
[precision] => 128
[nullable] =>
)
[account_lastlogin] => Array
(
[type] => int
[precision] => 4
)
[account_lastloginfrom] => Array
(
[type] => varchar
[precision] => 255
)
[account_lastpwd_change] => Array
(
[type] => int
[precision] => 4
)
[account_status] => Array
(
[type] => char
[precision] => 1
[nullable] =>
[default] => A
)
[account_expires] => Array
(
[type] => int
[precision] => 4
)
[account_type] => Array
(
[type] => char
[precision] => 1
)
[account_primary_group] => Array
(
[type] => int
[meta] => group
[precision] => 4
[nullable] =>
[default] => 0
)
)
[pk] => Array
(
[0] => account_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
[0] => account_lid
)
)
)
CreateTableSQL(‘egw_accounts’,‘account_id I AUTOINCREMENT NOTNULL PRIMARY, account_lid C(64) NOTNULL, account_pwd C(128) NOTNULL, account_lastlogin I4, account_lastloginfrom C(255), account_lastpwd_change I4, account_status C(1) NOTNULL DEFAULT ‘A’, account_expires I4, account_type C(1), account_primary_group I4 NOTNULL NOQUOTE DEFAULT 0’) sql=Array ( [0] => CREATE TABLE “egw_accounts” ( “account_id” SERIAL, “account_lid” VARCHAR(64) NOT NULL, “account_pwd” VARCHAR(128) NOT NULL, “account_lastlogin” INT4, “account_lastloginfrom” VARCHAR(255), “account_lastpwd_change” INT4, “account_status” VARCHAR(1) DEFAULT ‘A’ NOT NULL, “account_expires” INT4, “account_type” VARCHAR(1), “account_primary_group” INT4 DEFAULT 0 NOT NULL, PRIMARY KEY (“account_id”) ) )
CreateIndexSQL(NULL,‘egw_accounts’,‘account_lid’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_accounts_account_lid” ON “egw_accounts” (“account_lid”) )
Create Table egw_accounts
schema_proc::CreateTable(‘egw_preferences’,
Array
(
[fd] => Array
(
[preference_owner] => Array
(
[type] => int
[meta] => account-prefs
[precision] => 4
[nullable] =>
)
[preference_app] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
[preference_value] => Array
(
[type] => text
[nullable] =>
)
)
[pk] => Array
(
[0] => preference_owner
[1] => preference_app
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_preferences’,‘preference_owner I4 NOTNULL PRIMARY, preference_app C(25) NOTNULL PRIMARY, preference_value X NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_preferences” ( “preference_owner” INT4 NOT NULL, “preference_app” VARCHAR(25) NOT NULL, “preference_value” TEXT, PRIMARY KEY (“preference_owner”, “preference_app”) ) )
Create Table egw_preferences
schema_proc::CreateTable(‘egw_access_log’,
Array
(
[fd] => Array
(
[sessionid] => Array
(
[type] => auto
[nullable] =>
[comment] => primary key
)
[loginid] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
[comment] => username used to login
)
[ip] => Array
(
[type] => varchar
[precision] => 40
[nullable] =>
[comment] => ip of user
)
[li] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[nullable] =>
[comment] => TS if login
)
[lo] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[comment] => TD of logout
)
[account_id] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
[default] => 0
[comment] => numerical account id
)
[session_dla] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[comment] => TS of last user action
)
[session_action] => Array
(
[type] => varchar
[precision] => 64
[comment] => menuaction or path of last user action
)
[session_php] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
[comment] => php session-id or error-message
)
[notification_heartbeat] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[comment] => TS of last notification request
)
[user_agent] => Array
(
[type] => varchar
[precision] => 255
[comment] => User-agent of browser/device
)
)
[pk] => Array
(
[0] => sessionid
)
[fk] => Array
(
)
[ix] => Array
(
[0] => li
[1] => lo
[2] => session_dla
[3] => session_php
[4] => notification_heartbeat
[5] => Array
(
[0] => account_id
[1] => ip
[2] => li
)
[6] => Array
(
[0] => account_id
[1] => loginid
[2] => li
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_access_log’,‘sessionid I AUTOINCREMENT NOTNULL PRIMARY, loginid C(64) NOTNULL, ip C(40) NOTNULL, li I8 NOTNULL, lo I8, account_id I4 NOTNULL NOQUOTE DEFAULT 0, session_dla I8, session_action C(64), session_php C(64) NOTNULL, notification_heartbeat I8, user_agent C(255)’) sql=Array ( [0] => CREATE TABLE “egw_access_log” ( “sessionid” SERIAL, “loginid” VARCHAR(64) NOT NULL, “ip” VARCHAR(40) NOT NULL, “li” INT8 NOT NULL, “lo” INT8, “account_id” INT4 DEFAULT 0 NOT NULL, “session_dla” INT8, “session_action” VARCHAR(64), “session_php” VARCHAR(64) NOT NULL, “notification_heartbeat” INT8, “user_agent” VARCHAR(255), PRIMARY KEY (“sessionid”) ) )
CreateIndexSQL(NULL,‘egw_access_log’,‘li’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_li” ON “egw_access_log” (“li”) )
CreateIndexSQL(NULL,‘egw_access_log’,‘lo’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_lo” ON “egw_access_log” (“lo”) )
CreateIndexSQL(NULL,‘egw_access_log’,‘session_dla’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_session_dla” ON “egw_access_log” (“session_dla”) )
CreateIndexSQL(NULL,‘egw_access_log’,‘session_php’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_session_php” ON “egw_access_log” (“session_php”) )
CreateIndexSQL(NULL,‘egw_access_log’,‘notification_heartbeat’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_notification_heartbeat” ON “egw_access_log” (“notification_heartbeat”) )
CreateIndexSQL(NULL,‘egw_access_log’,Array ( [0] => account_id [1] => ip [2] => li ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_account_id_ip_li” ON “egw_access_log” (“account_id”, “ip”, “li”) )
CreateIndexSQL(NULL,‘egw_access_log’,Array ( [0] => account_id [1] => loginid [2] => li ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_access_log_account_id_loginid_li” ON “egw_access_log” (“account_id”, “loginid”, “li”) )
Create Table egw_access_log
schema_proc::CreateTable(‘egw_hooks’,
Array
(
[fd] => Array
(
[hook_id] => Array
(
[type] => auto
[nullable] =>
)
[hook_appname] => Array
(
[type] => varchar
[precision] => 255
)
[hook_location] => Array
(
[type] => varchar
[precision] => 255
)
[hook_filename] => Array
(
[type] => varchar
[precision] => 255
)
)
[pk] => Array
(
[0] => hook_id
)
[ix] => Array
(
)
[fk] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_hooks’,‘hook_id I AUTOINCREMENT NOTNULL PRIMARY, hook_appname C(255), hook_location C(255), hook_filename C(255)’) sql=Array ( [0] => CREATE TABLE “egw_hooks” ( “hook_id” SERIAL, “hook_appname” VARCHAR(255), “hook_location” VARCHAR(255), “hook_filename” VARCHAR(255), PRIMARY KEY (“hook_id”) ) )
Create Table egw_hooks
schema_proc::CreateTable(‘egw_languages’,
Array
(
[fd] => Array
(
[lang_id] => Array
(
[type] => varchar
[precision] => 5
[nullable] =>
)
[lang_name] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
)
[pk] => Array
(
[0] => lang_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_languages’,‘lang_id C(5) NOTNULL PRIMARY, lang_name C(50) NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_languages” ( “lang_id” VARCHAR(5) NOT NULL, “lang_name” VARCHAR(50) NOT NULL, PRIMARY KEY (“lang_id”) ) )
Create Table egw_languages
schema_proc::CreateTable(‘egw_lang’,
Array
(
[fd] => Array
(
[lang] => Array
(
[type] => varchar
[precision] => 5
[nullable] =>
[default] =>
)
[app_name] => Array
(
[type] => varchar
[precision] => 32
[nullable] =>
[default] => common
)
[message_id] => Array
(
[type] => varchar
[precision] => 128
[nullable] =>
[default] =>
)
[content] => Array
(
[type] => text
)
)
[pk] => Array
(
[0] => lang
[1] => app_name
[2] => message_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_lang’,‘lang C(5) NOTNULL DEFAULT ‘’ PRIMARY, app_name C(32) NOTNULL DEFAULT ‘common’ PRIMARY, message_id C(128) NOTNULL DEFAULT ‘’ PRIMARY, content X’) sql=Array ( [0] => CREATE TABLE “egw_lang” ( “lang” VARCHAR(5) DEFAULT ‘’ NOT NULL, “app_name” VARCHAR(32) DEFAULT ‘common’ NOT NULL, “message_id” VARCHAR(128) DEFAULT ‘’ NOT NULL, “content” TEXT, PRIMARY KEY (“lang”, “app_name”, “message_id”) ) )
Create Table egw_lang
schema_proc::CreateTable(‘egw_nextid’,
Array
(
[fd] => Array
(
[id] => Array
(
[type] => int
[precision] => 4
[nullable] => 1
)
[appname] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
)
[pk] => Array
(
[0] => appname
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_nextid’,‘id I4, appname C(25) NOTNULL PRIMARY’) sql=Array ( [0] => CREATE TABLE “egw_nextid” ( “id” INT4, “appname” VARCHAR(25) NOT NULL, PRIMARY KEY (“appname”) ) )
Create Table egw_nextid
schema_proc::CreateTable(‘egw_categories’,
Array
(
[fd] => Array
(
[cat_id] => Array
(
[type] => auto
[meta] => category
[precision] => 4
[nullable] =>
)
[cat_main] => Array
(
[type] => int
[meta] => category
[precision] => 4
[nullable] =>
[default] => 0
)
[cat_parent] => Array
(
[type] => int
[meta] => category
[precision] => 4
[nullable] =>
[default] => 0
)
[cat_level] => Array
(
[type] => int
[precision] => 2
[nullable] =>
[default] => 0
)
[cat_owner] => Array
(
[type] => varchar
[meta] => account-commasep
[precision] => 255
[nullable] =>
[default] => 0
)
[cat_access] => Array
(
[type] => varchar
[precision] => 7
)
[cat_appname] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
[cat_name] => Array
(
[type] => varchar
[precision] => 150
[nullable] =>
)
[cat_description] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[cat_data] => Array
(
[type] => text
)
[last_mod] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[nullable] =>
)
)
[pk] => Array
(
[0] => cat_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => Array
(
[0] => cat_appname
[1] => cat_owner
[2] => cat_parent
[3] => cat_level
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_categories’,‘cat_id I AUTOINCREMENT NOTNULL PRIMARY, cat_main I4 NOTNULL NOQUOTE DEFAULT 0, cat_parent I4 NOTNULL NOQUOTE DEFAULT 0, cat_level I2 NOTNULL NOQUOTE DEFAULT 0, cat_owner C(255) NOTNULL DEFAULT ‘0’, cat_access C(7), cat_appname C(50) NOTNULL, cat_name C(150) NOTNULL, cat_description C(255) NOTNULL, cat_data X, last_mod I8 NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_categories” ( “cat_id” SERIAL, “cat_main” INT4 DEFAULT 0 NOT NULL, “cat_parent” INT4 DEFAULT 0 NOT NULL, “cat_level” INT2 DEFAULT 0 NOT NULL, “cat_owner” VARCHAR(255) DEFAULT ‘0’ NOT NULL, “cat_access” VARCHAR(7), “cat_appname” VARCHAR(50) NOT NULL, “cat_name” VARCHAR(150) NOT NULL, “cat_description” VARCHAR(255) NOT NULL, “cat_data” TEXT, “last_mod” INT8 NOT NULL, PRIMARY KEY (“cat_id”) ) )
CreateIndexSQL(NULL,‘egw_categories’,Array ( [0] => cat_appname [1] => cat_owner [2] => cat_parent [3] => cat_level ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_categories_appname_owner_parent_level” ON “egw_categories” (“cat_appname”, “cat_owner”, “cat_parent”, “cat_level”) )
Create Table egw_categories
schema_proc::CreateTable(‘egw_log’,
Array
(
[fd] => Array
(
[log_id] => Array
(
[type] => auto
[precision] => 4
[nullable] =>
)
[log_date] => Array
(
[type] => timestamp
[nullable] =>
)
[log_user] => Array
(
[type] => int
[meta] => account
[precision] => 4
[nullable] =>
)
[log_app] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
[log_severity] => Array
(
[type] => char
[precision] => 1
[nullable] =>
)
)
[pk] => Array
(
[0] => log_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_log’,‘log_id I AUTOINCREMENT NOTNULL PRIMARY, log_date T NOTNULL, log_user I4 NOTNULL, log_app C(50) NOTNULL, log_severity C(1) NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_log” ( “log_id” SERIAL, “log_date” TIMESTAMP NOT NULL, “log_user” INT4 NOT NULL, “log_app” VARCHAR(50) NOT NULL, “log_severity” VARCHAR(1) NOT NULL, PRIMARY KEY (“log_id”) ) )
Create Table egw_log
schema_proc::CreateTable(‘egw_log_msg’,
Array
(
[fd] => Array
(
[log_msg_log_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[log_msg_seq_no] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[log_msg_date] => Array
(
[type] => timestamp
[nullable] =>
)
[log_msg_tx_fid] => Array
(
[type] => varchar
[precision] => 4
[nullable] => 1
)
[log_msg_tx_id] => Array
(
[type] => varchar
[precision] => 4
[nullable] => 1
)
[log_msg_severity] => Array
(
[type] => char
[precision] => 1
[nullable] =>
)
[log_msg_code] => Array
(
[type] => varchar
[precision] => 30
[nullable] =>
)
[log_msg_msg] => Array
(
[type] => text
[nullable] =>
)
[log_msg_parms] => Array
(
[type] => text
[nullable] =>
)
[log_msg_file] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[log_msg_line] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
)
[pk] => Array
(
[0] => log_msg_log_id
[1] => log_msg_seq_no
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_log_msg’,‘log_msg_log_id I4 NOTNULL PRIMARY, log_msg_seq_no I4 NOTNULL PRIMARY, log_msg_date T NOTNULL, log_msg_tx_fid C(4), log_msg_tx_id C(4), log_msg_severity C(1) NOTNULL, log_msg_code C(30) NOTNULL, log_msg_msg X NOTNULL, log_msg_parms X NOTNULL, log_msg_file C(255) NOTNULL, log_msg_line I4 NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_log_msg” ( “log_msg_log_id” INT4 NOT NULL, “log_msg_seq_no” INT4 NOT NULL, “log_msg_date” TIMESTAMP NOT NULL, “log_msg_tx_fid” VARCHAR(4), “log_msg_tx_id” VARCHAR(4), “log_msg_severity” VARCHAR(1) NOT NULL, “log_msg_code” VARCHAR(30) NOT NULL, “log_msg_msg” TEXT, “log_msg_parms” TEXT, “log_msg_file” VARCHAR(255) NOT NULL, “log_msg_line” INT4 NOT NULL, PRIMARY KEY (“log_msg_log_id”, “log_msg_seq_no”) ) )
Create Table egw_log_msg
schema_proc::CreateTable(‘egw_history_log’,
Array
(
[fd] => Array
(
[history_id] => Array
(
[type] => auto
[precision] => 4
[nullable] =>
)
[history_record_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[history_appname] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[history_owner] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
)
[history_status] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[history_new_value] => Array
(
[type] => text
[nullable] =>
)
[history_timestamp] => Array
(
[type] => timestamp
[nullable] =>
[default] => current_timestamp
)
[history_old_value] => Array
(
[type] => text
[nullable] =>
)
[sessionid] => Array
(
[type] => int
[precision] => 4
[comment] => primary key to egw_access_log
)
)
[pk] => Array
(
[0] => history_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => Array
(
[0] => history_appname
[1] => history_record_id
[2] => history_id
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_history_log’,‘history_id I AUTOINCREMENT NOTNULL PRIMARY, history_record_id I4 NOTNULL, history_appname C(64) NOTNULL, history_owner I4 NOTNULL, history_status C(64) NOTNULL, history_new_value X NOTNULL, history_timestamp T DEFTIMESTAMP NOTNULL, history_old_value X NOTNULL, sessionid I4’) sql=Array ( [0] => CREATE TABLE “egw_history_log” ( “history_id” SERIAL, “history_record_id” INT4 NOT NULL, “history_appname” VARCHAR(64) NOT NULL, “history_owner” INT4 NOT NULL, “history_status” VARCHAR(64) NOT NULL, “history_new_value” TEXT, “history_timestamp” TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, “history_old_value” TEXT, “sessionid” INT4, PRIMARY KEY (“history_id”) ) )
CreateIndexSQL(NULL,‘egw_history_log’,Array ( [0] => history_appname [1] => history_record_id [2] => history_id ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_history_log_appname_record_id_id” ON “egw_history_log” (“history_appname”, “history_record_id”, “history_id”) )
Create Table egw_history_log
schema_proc::CreateTable(‘egw_async’,
Array
(
[fd] => Array
(
[async_id] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[async_next] => Array
(
[type] => int
[meta] => timestamp
[precision] => 4
[nullable] =>
[comment] => timestamp of next run
)
[async_times] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
[comment] => serialized array with values for keys hour,min,day,month,year
)
[async_method] => Array
(
[type] => varchar
[precision] => 80
[nullable] =>
[comment] => app.class.method class::method to execute
)
[async_data] => Array
(
[type] => text
[nullable] =>
[comment] => serialized array with data to pass to method
)
[async_account_id] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
[default] => 0
[comment] => creator of job
)
)
[pk] => Array
(
[0] => async_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_async’,‘async_id C(255) NOTNULL PRIMARY, async_next I4 NOTNULL, async_times C(255) NOTNULL, async_method C(80) NOTNULL, async_data X NOTNULL, async_account_id I4 NOTNULL NOQUOTE DEFAULT 0’) sql=Array ( [0] => CREATE TABLE “egw_async” ( “async_id” VARCHAR(255) NOT NULL, “async_next” INT4 NOT NULL, “async_times” VARCHAR(255) NOT NULL, “async_method” VARCHAR(80) NOT NULL, “async_data” TEXT, “async_account_id” INT4 DEFAULT 0 NOT NULL, PRIMARY KEY (“async_id”) ) )
Create Table egw_async
schema_proc::CreateTable(‘egw_api_content_history’,
Array
(
[fd] => Array
(
[sync_appname] => Array
(
[type] => varchar
[precision] => 60
[nullable] =>
)
[sync_contentid] => Array
(
[type] => varchar
[precision] => 60
[nullable] =>
)
[sync_added] => Array
(
[type] => timestamp
)
[sync_modified] => Array
(
[type] => timestamp
)
[sync_deleted] => Array
(
[type] => timestamp
)
[sync_id] => Array
(
[type] => auto
[nullable] =>
)
[sync_changedby] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
)
)
[pk] => Array
(
[0] => sync_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => sync_added
[1] => sync_modified
[2] => sync_deleted
[3] => sync_changedby
[4] => Array
(
[0] => sync_appname
[1] => sync_contentid
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_api_content_history’,‘sync_appname C(60) NOTNULL, sync_contentid C(60) NOTNULL, sync_added T, sync_modified T, sync_deleted T, sync_id I AUTOINCREMENT NOTNULL PRIMARY, sync_changedby I4 NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_api_content_history” ( “sync_appname” VARCHAR(60) NOT NULL, “sync_contentid” VARCHAR(60) NOT NULL, “sync_added” TIMESTAMP, “sync_modified” TIMESTAMP, “sync_deleted” TIMESTAMP, “sync_id” SERIAL, “sync_changedby” INT4 NOT NULL, PRIMARY KEY (“sync_id”) ) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_added’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_api_content_history_sync_added” ON “egw_api_content_history” (“sync_added”) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_modified’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_api_content_history_sync_modified” ON “egw_api_content_history” (“sync_modified”) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_deleted’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_api_content_history_sync_deleted” ON “egw_api_content_history” (“sync_deleted”) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_changedby’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_api_content_history_sync_changedby” ON “egw_api_content_history” (“sync_changedby”) )
CreateIndexSQL(NULL,‘egw_api_content_history’,Array ( [0] => sync_appname [1] => sync_contentid ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_api_content_history_sync_appname_sync_contentid” ON “egw_api_content_history” (“sync_appname”, “sync_contentid”) )
Create Table egw_api_content_history
schema_proc::CreateTable(‘egw_links’,
Array
(
[fd] => Array
(
[link_id] => Array
(
[type] => auto
[nullable] =>
)
[link_app1] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
[link_id1] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
[meta] => Array
(
[link_app1='home-accounts'] => account
)
)
[link_app2] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
[link_id2] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
[meta] => Array
(
[link_app2='home-accounts'] => account
)
)
[link_remark] => Array
(
[type] => varchar
[precision] => 100
)
[link_lastmod] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[nullable] =>
)
[link_owner] => Array
(
[type] => int
[meta] => account
[precision] => 4
[nullable] =>
)
[deleted] => Array
(
[type] => timestamp
)
)
[pk] => Array
(
[0] => link_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => deleted
[1] => Array
(
[0] => link_app1
[1] => link_id1
[2] => link_lastmod
)
[2] => Array
(
[0] => link_app2
[1] => link_id2
[2] => link_lastmod
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_links’,‘link_id I AUTOINCREMENT NOTNULL PRIMARY, link_app1 C(25) NOTNULL, link_id1 C(50) NOTNULL, link_app2 C(25) NOTNULL, link_id2 C(50) NOTNULL, link_remark C(100), link_lastmod I8 NOTNULL, link_owner I4 NOTNULL, deleted T’) sql=Array ( [0] => CREATE TABLE “egw_links” ( “link_id” SERIAL, “link_app1” VARCHAR(25) NOT NULL, “link_id1” VARCHAR(50) NOT NULL, “link_app2” VARCHAR(25) NOT NULL, “link_id2” VARCHAR(50) NOT NULL, “link_remark” VARCHAR(100), “link_lastmod” INT8 NOT NULL, “link_owner” INT4 NOT NULL, “deleted” TIMESTAMP, PRIMARY KEY (“link_id”) ) )
CreateIndexSQL(NULL,‘egw_links’,‘deleted’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_links_deleted” ON “egw_links” (“deleted”) )
CreateIndexSQL(NULL,‘egw_links’,Array ( [0] => link_app1 [1] => link_id1 [2] => link_lastmod ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_links_app1_id1_lastmod” ON “egw_links” (“link_app1”, “link_id1”, “link_lastmod”) )
CreateIndexSQL(NULL,‘egw_links’,Array ( [0] => link_app2 [1] => link_id2 [2] => link_lastmod ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_links_app2_id2_lastmod” ON “egw_links” (“link_app2”, “link_id2”, “link_lastmod”) )
Create Table egw_links
schema_proc::CreateTable(‘egw_addressbook’,
Array
(
[fd] => Array
(
[contact_id] => Array
(
[type] => auto
[nullable] =>
)
[contact_tid] => Array
(
[type] => char
[precision] => 1
[default] => n
)
[contact_owner] => Array
(
[type] => int
[meta] => account
[precision] => 8
[nullable] =>
[comment] => account or group id of the adressbook
)
[contact_private] => Array
(
[type] => int
[precision] => 1
[default] => 0
[comment] => privat or personal
)
[cat_id] => Array
(
[type] => varchar
[meta] => category
[precision] => 255
[comment] => Category(s)
)
[n_family] => Array
(
[type] => varchar
[precision] => 64
[comment] => Family name
)
[n_given] => Array
(
[type] => varchar
[precision] => 64
[comment] => Given Name
)
[n_middle] => Array
(
[type] => varchar
[precision] => 64
)
[n_prefix] => Array
(
[type] => varchar
[precision] => 64
[comment] => Prefix
)
[n_suffix] => Array
(
[type] => varchar
[precision] => 64
[comment] => Suffix
)
[n_fn] => Array
(
[type] => varchar
[precision] => 128
[comment] => Full name
)
[n_fileas] => Array
(
[type] => varchar
[precision] => 255
[comment] => sort as
)
[contact_bday] => Array
(
[type] => varchar
[precision] => 12
[comment] => Birtday
)
[org_name] => Array
(
[type] => varchar
[precision] => 128
[comment] => Organisation
)
[org_unit] => Array
(
[type] => varchar
[precision] => 64
[comment] => Department
)
[contact_title] => Array
(
[type] => varchar
[precision] => 64
[comment] => jobtittle
)
[contact_role] => Array
(
[type] => varchar
[precision] => 64
[comment] => role
)
[contact_assistent] => Array
(
[type] => varchar
[precision] => 64
[comment] => Name of the Assistent (for phone number)
)
[contact_room] => Array
(
[type] => varchar
[precision] => 64
[comment] => room
)
[adr_one_street] => Array
(
[type] => varchar
[precision] => 64
[comment] => street (business)
)
[adr_one_street2] => Array
(
[type] => varchar
[precision] => 64
[comment] => street (business) - 2. line
)
[adr_one_locality] => Array
(
[type] => varchar
[precision] => 64
[comment] => city (business)
)
[adr_one_region] => Array
(
[type] => varchar
[precision] => 64
[comment] => region (business)
)
[adr_one_postalcode] => Array
(
[type] => varchar
[precision] => 64
[comment] => postalcode (business)
)
[adr_one_countryname] => Array
(
[type] => varchar
[precision] => 64
[comment] => countryname (business)
)
[contact_label] => Array
(
[type] => text
[comment] => currently not used
)
[adr_two_street] => Array
(
[type] => varchar
[precision] => 64
[comment] => street (private)
)
[adr_two_street2] => Array
(
[type] => varchar
[precision] => 64
[comment] => street (private) - 2. line
)
[adr_two_locality] => Array
(
[type] => varchar
[precision] => 64
[comment] => city (private)
)
[adr_two_region] => Array
(
[type] => varchar
[precision] => 64
[comment] => region (private)
)
[adr_two_postalcode] => Array
(
[type] => varchar
[precision] => 64
[comment] => postalcode (private)
)
[adr_two_countryname] => Array
(
[type] => varchar
[precision] => 64
[comment] => countryname (private)
)
[tel_work] => Array
(
[type] => varchar
[precision] => 40
[comment] => phone-number (business)
)
[tel_cell] => Array
(
[type] => varchar
[precision] => 40
[comment] => mobil phone (business)
)
[tel_fax] => Array
(
[type] => varchar
[precision] => 40
[comment] => fax-number (business)
)
[tel_assistent] => Array
(
[type] => varchar
[precision] => 40
[comment] => phone-number assistent
)
[tel_car] => Array
(
[type] => varchar
[precision] => 40
)
[tel_pager] => Array
(
[type] => varchar
[precision] => 40
[comment] => pager
)
[tel_home] => Array
(
[type] => varchar
[precision] => 40
[comment] => phone-number (private)
)
[tel_fax_home] => Array
(
[type] => varchar
[precision] => 40
[comment] => fax-number (private)
)
[tel_cell_private] => Array
(
[type] => varchar
[precision] => 40
[comment] => mobil phone (private)
)
[tel_other] => Array
(
[type] => varchar
[precision] => 40
[comment] => other phone
)
[tel_prefer] => Array
(
[type] => varchar
[precision] => 32
[comment] => prefered phone-number
)
[contact_email] => Array
(
[type] => varchar
[precision] => 128
[comment] => email address (business)
)
[contact_email_home] => Array
(
[type] => varchar
[precision] => 128
[comment] => email address (private)
)
[contact_url] => Array
(
[type] => varchar
[precision] => 128
[comment] => website (business)
)
[contact_url_home] => Array
(
[type] => varchar
[precision] => 128
[comment] => website (private)
)
[contact_freebusy_uri] => Array
(
[type] => varchar
[precision] => 128
[comment] => freebusy-url for calendar of the contact
)
[contact_calendar_uri] => Array
(
[type] => varchar
[precision] => 128
[comment] => url for users calendar - currently not used
)
[contact_note] => Array
(
[type] => text
[comment] => notes field
)
[contact_tz] => Array
(
[type] => varchar
[precision] => 8
[comment] => timezone difference
)
[contact_geo] => Array
(
[type] => varchar
[precision] => 32
[comment] => currently not used
)
[contact_pubkey] => Array
(
[type] => text
[comment] => public key
)
[contact_created] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[comment] => timestamp of the creation
)
[contact_creator] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
[comment] => account id of the creator
)
[contact_modified] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[nullable] =>
[comment] => timestamp of the last modified
)
[contact_modifier] => Array
(
[type] => int
[meta] => user
[precision] => 4
[comment] => account id of the last modified
)
[contact_jpegphoto] => Array
(
[type] => blob
[comment] => photo of the contact (attachment)
)
[account_id] => Array
(
[type] => int
[meta] => user
[precision] => 4
[comment] => account id
)
[contact_etag] => Array
(
[type] => int
[precision] => 4
[default] => 0
[comment] => etag of the changes
)
[contact_uid] => Array
(
[type] => varchar
[precision] => 255
[comment] => unique id of the contact
)
[adr_one_countrycode] => Array
(
[type] => varchar
[precision] => 2
[comment] => countrycode (business)
)
[adr_two_countrycode] => Array
(
[type] => varchar
[precision] => 2
[comment] => countrycode (private)
)
[carddav_name] => Array
(
[type] => varchar
[precision] => 200
[comment] => name part of CardDAV URL, if specified by client
)
)
[pk] => Array
(
[0] => contact_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => contact_owner
[1] => cat_id
[2] => n_fileas
[3] => contact_modified
[4] => contact_uid
[5] => carddav_name
[6] => Array
(
[0] => n_family
[1] => n_given
)
[7] => Array
(
[0] => n_given
[1] => n_family
)
[8] => Array
(
[0] => org_name
[1] => n_family
[2] => n_given
)
)
[uc] => Array
(
[0] => account_id
)
)
)
CreateTableSQL(‘egw_addressbook’,‘contact_id I AUTOINCREMENT NOTNULL PRIMARY, contact_tid C(1) DEFAULT ‘n’, contact_owner I8 NOTNULL, contact_private I1 NOQUOTE DEFAULT 0, cat_id C(255), n_family C(64), n_given C(64), n_middle C(64), n_prefix C(64), n_suffix C(64), n_fn C(128), n_fileas C(255), contact_bday C(12), org_name C(128), org_unit C(64), contact_title C(64), contact_role C(64), contact_assistent C(64), contact_room C(64), adr_one_street C(64), adr_one_street2 C(64), adr_one_locality C(64), adr_one_region C(64), adr_one_postalcode C(64), adr_one_countryname C(64), contact_label X, adr_two_street C(64), adr_two_street2 C(64), adr_two_locality C(64), adr_two_region C(64), adr_two_postalcode C(64), adr_two_countryname C(64), tel_work C(40), tel_cell C(40), tel_fax C(40), tel_assistent C(40), tel_car C(40), tel_pager C(40), tel_home C(40), tel_fax_home C(40), tel_cell_private C(40), tel_other C(40), tel_prefer C(32), contact_email C(128), contact_email_home C(128), contact_url C(128), contact_url_home C(128), contact_freebusy_uri C(128), contact_calendar_uri C(128), contact_note X, contact_tz C(8), contact_geo C(32), contact_pubkey X, contact_created I8, contact_creator I4 NOTNULL, contact_modified I8 NOTNULL, contact_modifier I4, contact_jpegphoto B, account_id I4, contact_etag I4 NOQUOTE DEFAULT 0, contact_uid C(255), adr_one_countrycode C(2), adr_two_countrycode C(2), carddav_name C(200)’) sql=Array ( [0] => CREATE TABLE “egw_addressbook” ( “contact_id” SERIAL, “contact_tid” VARCHAR(1) DEFAULT ‘n’, “contact_owner” INT8 NOT NULL, “contact_private” SMALLINT DEFAULT 0, “cat_id” VARCHAR(255), “n_family” VARCHAR(64), “n_given” VARCHAR(64), “n_middle” VARCHAR(64), “n_prefix” VARCHAR(64), “n_suffix” VARCHAR(64), “n_fn” VARCHAR(128), “n_fileas” VARCHAR(255), “contact_bday” VARCHAR(12), “org_name” VARCHAR(128), “org_unit” VARCHAR(64), “contact_title” VARCHAR(64), “contact_role” VARCHAR(64), “contact_assistent” VARCHAR(64), “contact_room” VARCHAR(64), “adr_one_street” VARCHAR(64), “adr_one_street2” VARCHAR(64), “adr_one_locality” VARCHAR(64), “adr_one_region” VARCHAR(64), “adr_one_postalcode” VARCHAR(64), “adr_one_countryname” VARCHAR(64), “contact_label” TEXT, “adr_two_street” VARCHAR(64), “adr_two_street2” VARCHAR(64), “adr_two_locality” VARCHAR(64), “adr_two_region” VARCHAR(64), “adr_two_postalcode” VARCHAR(64), “adr_two_countryname” VARCHAR(64), “tel_work” VARCHAR(40), “tel_cell” VARCHAR(40), “tel_fax” VARCHAR(40), “tel_assistent” VARCHAR(40), “tel_car” VARCHAR(40), “tel_pager” VARCHAR(40), “tel_home” VARCHAR(40), “tel_fax_home” VARCHAR(40), “tel_cell_private” VARCHAR(40), “tel_other” VARCHAR(40), “tel_prefer” VARCHAR(32), “contact_email” VARCHAR(128), “contact_email_home” VARCHAR(128), “contact_url” VARCHAR(128), “contact_url_home” VARCHAR(128), “contact_freebusy_uri” VARCHAR(128), “contact_calendar_uri” VARCHAR(128), “contact_note” TEXT, “contact_tz” VARCHAR(8), “contact_geo” VARCHAR(32), “contact_pubkey” TEXT, “contact_created” INT8, “contact_creator” INT4 NOT NULL, “contact_modified” INT8 NOT NULL, “contact_modifier” INT4, “contact_jpegphoto” BYTEA, “account_id” INT4, “contact_etag” INT4 DEFAULT 0, “contact_uid” VARCHAR(255), “adr_one_countrycode” VARCHAR(2), “adr_two_countrycode” VARCHAR(2), “carddav_name” VARCHAR(200), PRIMARY KEY (“contact_id”) ) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘account_id’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_addressbook_account_id” ON “egw_addressbook” (“account_id”) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘contact_owner’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_contact_owner” ON “egw_addressbook” (“contact_owner”) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘cat_id’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_cat_id” ON “egw_addressbook” (“cat_id”) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘n_fileas’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_n_fileas” ON “egw_addressbook” (“n_fileas”) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘contact_modified’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_contact_modified” ON “egw_addressbook” (“contact_modified”) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘contact_uid’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_contact_uid” ON “egw_addressbook” (“contact_uid”) )
CreateIndexSQL(NULL,‘egw_addressbook’,‘carddav_name’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_carddav_name” ON “egw_addressbook” (“carddav_name”) )
CreateIndexSQL(NULL,‘egw_addressbook’,Array ( [0] => n_family [1] => n_given ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_n_family_n_given” ON “egw_addressbook” (“n_family”, “n_given”) )
CreateIndexSQL(NULL,‘egw_addressbook’,Array ( [0] => n_given [1] => n_family ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_n_given_n_family” ON “egw_addressbook” (“n_given”, “n_family”) )
CreateIndexSQL(NULL,‘egw_addressbook’,Array ( [0] => org_name [1] => n_family [2] => n_given ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_org_name_n_family_n_given” ON “egw_addressbook” (“org_name”, “n_family”, “n_given”) )
Create Table egw_addressbook
schema_proc::CreateTable(‘egw_addressbook_extra’,
Array
(
[fd] => Array
(
[contact_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[contact_owner] => Array
(
[type] => int
[meta] => account
[precision] => 8
)
[contact_name] => Array
(
[type] => varchar
[meta] => cfname
[precision] => 255
[nullable] =>
)
[contact_value] => Array
(
[type] => text
[meta] => cfvalue
)
)
[pk] => Array
(
[0] => contact_id
[1] => contact_name
)
[fk] => Array
(
)
[ix] => Array
(
[0] => contact_name
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_addressbook_extra’,‘contact_id I4 NOTNULL PRIMARY, contact_owner I8, contact_name C(255) NOTNULL PRIMARY, contact_value X’) sql=Array ( [0] => CREATE TABLE “egw_addressbook_extra” ( “contact_id” INT4 NOT NULL, “contact_owner” INT8, “contact_name” VARCHAR(255) NOT NULL, “contact_value” TEXT, PRIMARY KEY (“contact_id”, “contact_name”) ) )
CreateIndexSQL(NULL,‘egw_addressbook_extra’,‘contact_name’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_addressbook_extra_contact_name” ON “egw_addressbook_extra” (“contact_name”) )
Create Table egw_addressbook_extra
schema_proc::CreateTable(‘egw_addressbook_lists’,
Array
(
[fd] => Array
(
[list_id] => Array
(
[type] => auto
[nullable] =>
)
[list_name] => Array
(
[type] => varchar
[precision] => 80
[nullable] =>
)
[list_owner] => Array
(
[type] => int
[meta] => account
[precision] => 4
[nullable] =>
)
[list_created] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
)
[list_creator] => Array
(
[type] => int
[meta] => user
[precision] => 4
)
[list_uid] => Array
(
[type] => varchar
[precision] => 255
)
[list_carddav_name] => Array
(
[type] => varchar
[precision] => 64
)
[list_etag] => Array
(
[type] => int
[precision] => 4
[nullable] =>
[default] => 0
)
[list_modified] => Array
(
[type] => timestamp
[nullable] =>
[default] => current_timestamp
)
[list_modifier] => Array
(
[type] => int
[meta] => user
[precision] => 4
)
)
[pk] => Array
(
[0] => list_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
[0] => list_uid
[1] => list_carddav_name
[2] => Array
(
[0] => list_owner
[1] => list_name
)
)
)
)
CreateTableSQL(‘egw_addressbook_lists’,‘list_id I AUTOINCREMENT NOTNULL PRIMARY, list_name C(80) NOTNULL, list_owner I4 NOTNULL, list_created I8, list_creator I4, list_uid C(255), list_carddav_name C(64), list_etag I4 NOTNULL NOQUOTE DEFAULT 0, list_modified T DEFTIMESTAMP NOTNULL, list_modifier I4’) sql=Array ( [0] => CREATE TABLE “egw_addressbook_lists” ( “list_id” SERIAL, “list_name” VARCHAR(80) NOT NULL, “list_owner” INT4 NOT NULL, “list_created” INT8, “list_creator” INT4, “list_uid” VARCHAR(255), “list_carddav_name” VARCHAR(64), “list_etag” INT4 DEFAULT 0 NOT NULL, “list_modified” TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, “list_modifier” INT4, PRIMARY KEY (“list_id”) ) )
CreateIndexSQL(NULL,‘egw_addressbook_lists’,‘list_uid’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_addressbook_lists_list_uid” ON “egw_addressbook_lists” (“list_uid”) )
CreateIndexSQL(NULL,‘egw_addressbook_lists’,‘list_carddav_name’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_addressbook_lists_list_carddav_name” ON “egw_addressbook_lists” (“list_carddav_name”) )
CreateIndexSQL(NULL,‘egw_addressbook_lists’,Array ( [0] => list_owner [1] => list_name ) ,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_addressbook_lists_list_owner_list_name” ON “egw_addressbook_lists” (“list_owner”, “list_name”) )
Create Table egw_addressbook_lists
schema_proc::CreateTable(‘egw_addressbook2list’,
Array
(
[fd] => Array
(
[contact_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[list_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[list_added] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
)
[list_added_by] => Array
(
[type] => int
[meta] => user
[precision] => 4
)
)
[pk] => Array
(
[0] => contact_id
[1] => list_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_addressbook2list’,‘contact_id I4 NOTNULL PRIMARY, list_id I4 NOTNULL PRIMARY, list_added I8, list_added_by I4’) sql=Array ( [0] => CREATE TABLE “egw_addressbook2list” ( “contact_id” INT4 NOT NULL, “list_id” INT4 NOT NULL, “list_added” INT8, “list_added_by” INT4, PRIMARY KEY (“contact_id”, “list_id”) ) )
Create Table egw_addressbook2list
schema_proc::CreateTable(‘egw_sqlfs’,
Array
(
[fd] => Array
(
[fs_id] => Array
(
[type] => auto
[nullable] =>
)
[fs_dir] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[fs_name] => Array
(
[type] => varchar
[precision] => 200
[nullable] =>
)
[fs_mode] => Array
(
[type] => int
[precision] => 2
[nullable] =>
)
[fs_uid] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
[default] => 0
)
[fs_gid] => Array
(
[type] => int
[meta] => group-abs
[precision] => 4
[nullable] =>
[default] => 0
)
[fs_created] => Array
(
[type] => timestamp
[precision] => 8
[nullable] =>
)
[fs_modified] => Array
(
[type] => timestamp
[precision] => 8
[nullable] =>
)
[fs_mime] => Array
(
[type] => varchar
[precision] => 96
[nullable] =>
)
[fs_size] => Array
(
[type] => int
[precision] => 8
[nullable] =>
)
[fs_creator] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
)
[fs_modifier] => Array
(
[type] => int
[meta] => user
[precision] => 4
)
[fs_active] => Array
(
[type] => bool
[nullable] =>
[default] => t
)
[fs_content] => Array
(
[type] => blob
)
[fs_link] => Array
(
[type] => varchar
[precision] => 255
)
)
[pk] => Array
(
[0] => fs_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => Array
(
[0] => fs_dir
[1] => fs_active
[2] => fs_name
)
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_sqlfs’,‘fs_id I AUTOINCREMENT NOTNULL PRIMARY, fs_dir I4 NOTNULL, fs_name C(200) NOTNULL, fs_mode I2 NOTNULL, fs_uid I4 NOTNULL NOQUOTE DEFAULT 0, fs_gid I4 NOTNULL NOQUOTE DEFAULT 0, fs_created T NOTNULL, fs_modified T NOTNULL, fs_mime C(96) NOTNULL, fs_size I8 NOTNULL, fs_creator I4 NOTNULL, fs_modifier I4, fs_active L NOTNULL NOQUOTE DEFAULT true, fs_content B, fs_link C(255)’) sql=Array ( [0] => CREATE TABLE “egw_sqlfs” ( “fs_id” SERIAL, “fs_dir” INT4 NOT NULL, “fs_name” VARCHAR(200) NOT NULL, “fs_mode” INT2 NOT NULL, “fs_uid” INT4 DEFAULT 0 NOT NULL, “fs_gid” INT4 DEFAULT 0 NOT NULL, “fs_created” TIMESTAMP NOT NULL, “fs_modified” TIMESTAMP NOT NULL, “fs_mime” VARCHAR(96) NOT NULL, “fs_size” INT8 NOT NULL, “fs_creator” INT4 NOT NULL, “fs_modifier” INT4, “fs_active” BOOLEAN DEFAULT true NOT NULL, “fs_content” BYTEA, “fs_link” VARCHAR(255), PRIMARY KEY (“fs_id”) ) )
CreateIndexSQL(NULL,‘egw_sqlfs’,Array ( [0] => fs_dir [1] => fs_active [2] => fs_name ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_sqlfs_fs_dir_fs_active_fs_name” ON “egw_sqlfs” (“fs_dir”, “fs_active”, “fs_name”) )
Create Table egw_sqlfs
schema_proc::CreateTable(‘egw_index_keywords’,
Array
(
[fd] => Array
(
[si_id] => Array
(
[type] => auto
[nullable] =>
)
[si_keyword] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[si_ignore] => Array
(
[type] => bool
)
)
[pk] => Array
(
[0] => si_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
[0] => si_keyword
)
)
)
CreateTableSQL(‘egw_index_keywords’,‘si_id I AUTOINCREMENT NOTNULL PRIMARY, si_keyword C(64) NOTNULL, si_ignore L’) sql=Array ( [0] => CREATE TABLE “egw_index_keywords” ( “si_id” SERIAL, “si_keyword” VARCHAR(64) NOT NULL, “si_ignore” BOOLEAN, PRIMARY KEY (“si_id”) ) )
CreateIndexSQL(NULL,‘egw_index_keywords’,‘si_keyword’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_index_keywords_si_keyword” ON “egw_index_keywords” (“si_keyword”) )
Create Table egw_index_keywords
schema_proc::CreateTable(‘egw_index’,
Array
(
[fd] => Array
(
[si_app] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
[si_app_id] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
[si_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[si_owner] => Array
(
[type] => int
[meta] => account
[precision] => 4
[nullable] =>
)
)
[pk] => Array
(
[0] => si_app
[1] => si_app_id
[2] => si_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => si_id
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_index’,‘si_app C(25) NOTNULL PRIMARY, si_app_id C(50) NOTNULL PRIMARY, si_id I4 NOTNULL PRIMARY, si_owner I4 NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_index” ( “si_app” VARCHAR(25) NOT NULL, “si_app_id” VARCHAR(50) NOT NULL, “si_id” INT4 NOT NULL, “si_owner” INT4 NOT NULL, PRIMARY KEY (“si_app”, “si_app_id”, “si_id”) ) )
CreateIndexSQL(NULL,‘egw_index’,‘si_id’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_index_si_id” ON “egw_index” (“si_id”) )
Create Table egw_index
schema_proc::CreateTable(‘egw_cat2entry’,
Array
(
[fd] => Array
(
[ce_app] => Array
(
[type] => varchar
[precision] => 25
[nullable] =>
)
[ce_app_id] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
)
[cat_id] => Array
(
[type] => int
[meta] => category
[precision] => 4
[nullable] =>
)
[ce_owner] => Array
(
[type] => int
[meta] => account
[precision] => 4
[nullable] =>
)
)
[pk] => Array
(
[0] => ce_app
[1] => ce_app_id
[2] => cat_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => cat_id
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_cat2entry’,‘ce_app C(25) NOTNULL PRIMARY, ce_app_id C(50) NOTNULL PRIMARY, cat_id I4 NOTNULL PRIMARY, ce_owner I4 NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_cat2entry” ( “ce_app” VARCHAR(25) NOT NULL, “ce_app_id” VARCHAR(50) NOT NULL, “cat_id” INT4 NOT NULL, “ce_owner” INT4 NOT NULL, PRIMARY KEY (“ce_app”, “ce_app_id”, “cat_id”) ) )
CreateIndexSQL(NULL,‘egw_cat2entry’,‘cat_id’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_cat2entry_id” ON “egw_cat2entry” (“cat_id”) )
Create Table egw_cat2entry
schema_proc::CreateTable(‘egw_locks’,
Array
(
[fd] => Array
(
[lock_token] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[lock_path] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[lock_expires] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[nullable] =>
)
[lock_owner] => Array
(
[type] => varchar
[precision] => 255
)
[lock_recursive] => Array
(
[type] => bool
[nullable] =>
[default] => 0
)
[lock_write] => Array
(
[type] => bool
[nullable] =>
[default] => 0
)
[lock_exclusive] => Array
(
[type] => bool
[nullable] =>
[default] => 0
)
[lock_created] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[default] => 0
)
[lock_modified] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[default] => 0
)
)
[pk] => Array
(
[0] => lock_token
)
[fk] => Array
(
)
[ix] => Array
(
[0] => lock_path
[1] => lock_expires
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_locks’,‘lock_token C(255) NOTNULL PRIMARY, lock_path C(255) NOTNULL, lock_expires I8 NOTNULL, lock_owner C(255), lock_recursive L NOTNULL NOQUOTE DEFAULT false, lock_write L NOTNULL NOQUOTE DEFAULT false, lock_exclusive L NOTNULL NOQUOTE DEFAULT false, lock_created I8 NOQUOTE DEFAULT 0, lock_modified I8 NOQUOTE DEFAULT 0’) sql=Array ( [0] => CREATE TABLE “egw_locks” ( “lock_token” VARCHAR(255) NOT NULL, “lock_path” VARCHAR(255) NOT NULL, “lock_expires” INT8 NOT NULL, “lock_owner” VARCHAR(255), “lock_recursive” BOOLEAN DEFAULT false NOT NULL, “lock_write” BOOLEAN DEFAULT false NOT NULL, “lock_exclusive” BOOLEAN DEFAULT false NOT NULL, “lock_created” INT8 DEFAULT 0, “lock_modified” INT8 DEFAULT 0, PRIMARY KEY (“lock_token”) ) )
CreateIndexSQL(NULL,‘egw_locks’,‘lock_path’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_locks_path” ON “egw_locks” (“lock_path”) )
CreateIndexSQL(NULL,‘egw_locks’,‘lock_expires’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_locks_expires” ON “egw_locks” (“lock_expires”) )
Create Table egw_locks
schema_proc::CreateTable(‘egw_sqlfs_props’,
Array
(
[fd] => Array
(
[fs_id] => Array
(
[type] => int
[precision] => 4
[nullable] =>
)
[prop_namespace] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[prop_name] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[prop_value] => Array
(
[type] => text
)
)
[pk] => Array
(
[0] => fs_id
[1] => prop_namespace
[2] => prop_name
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_sqlfs_props’,‘fs_id I4 NOTNULL PRIMARY, prop_namespace C(64) NOTNULL PRIMARY, prop_name C(64) NOTNULL PRIMARY, prop_value X’) sql=Array ( [0] => CREATE TABLE “egw_sqlfs_props” ( “fs_id” INT4 NOT NULL, “prop_namespace” VARCHAR(64) NOT NULL, “prop_name” VARCHAR(64) NOT NULL, “prop_value” TEXT, PRIMARY KEY (“fs_id”, “prop_namespace”, “prop_name”) ) )
Create Table egw_sqlfs_props
schema_proc::CreateTable(‘egw_customfields’,
Array
(
[fd] => Array
(
[cf_id] => Array
(
[type] => auto
[nullable] =>
)
[cf_app] => Array
(
[type] => varchar
[precision] => 50
[nullable] =>
[comment] => app-name cf belongs too
)
[cf_name] => Array
(
[type] => varchar
[precision] => 128
[nullable] =>
[comment] => internal name
)
[cf_label] => Array
(
[type] => varchar
[precision] => 128
[comment] => label to display
)
[cf_type] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
[default] => text
[comment] => type of field
)
[cf_type2] => Array
(
[type] => varchar
[precision] => 2048
[comment] => comma-separated subtypes of app, cf is valid for
)
[cf_help] => Array
(
[type] => varchar
[precision] => 256
[comment] => helptext
)
[cf_values] => Array
(
[type] => varchar
[precision] => 8096
[comment] => json object with value label pairs
)
[cf_len] => Array
(
[type] => int
[precision] => 2
[comment] => length or columns of field
)
[cf_rows] => Array
(
[type] => int
[precision] => 2
[comment] => rows of field
)
[cf_order] => Array
(
[type] => int
[precision] => 2
[comment] => order to display fields
)
[cf_needed] => Array
(
[type] => bool
[default] => 0
[comment] => field is required
)
[cf_private] => Array
(
[type] => varchar
[meta] => account-commasep
[precision] => 2048
[comment] => comma-separated account_id
)
[cf_modifier] => Array
(
[type] => int
[meta] => account
[precision] => 4
[comment] => last modifier
)
[cf_modified] => Array
(
[type] => timestamp
[default] => current_timestamp
[comment] => last modification time
)
)
[pk] => Array
(
[0] => cf_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => Array
(
[0] => cf_app
[1] => cf_order
)
)
[uc] => Array
(
[0] => Array
(
[0] => cf_app
[1] => cf_name
)
)
)
)
CreateTableSQL(‘egw_customfields’,‘cf_id I AUTOINCREMENT NOTNULL PRIMARY, cf_app C(50) NOTNULL, cf_name C(128) NOTNULL, cf_label C(128), cf_type C(64) NOTNULL DEFAULT ‘text’, cf_type2 X, cf_help X, cf_values X, cf_len I2, cf_rows I2, cf_order I2, cf_needed L NOQUOTE DEFAULT false, cf_private X, cf_modifier I4, cf_modified T DEFTIMESTAMP’) sql=Array ( [0] => CREATE TABLE “egw_customfields” ( “cf_id” SERIAL, “cf_app” VARCHAR(50) NOT NULL, “cf_name” VARCHAR(128) NOT NULL, “cf_label” VARCHAR(128), “cf_type” VARCHAR(64) DEFAULT ‘text’ NOT NULL, “cf_type2” TEXT, “cf_help” TEXT, “cf_values” TEXT, “cf_len” INT2, “cf_rows” INT2, “cf_order” INT2, “cf_needed” BOOLEAN DEFAULT false, “cf_private” TEXT, “cf_modifier” INT4, “cf_modified” TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (“cf_id”) ) )
CreateIndexSQL(NULL,‘egw_customfields’,Array ( [0] => cf_app [1] => cf_name ) ,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_customfields_cf_app_cf_name” ON “egw_customfields” (“cf_app”, “cf_name”) )
CreateIndexSQL(NULL,‘egw_customfields’,Array ( [0] => cf_app [1] => cf_order ) ,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_customfields_cf_app_cf_order” ON “egw_customfields” (“cf_app”, “cf_order”) )
Create Table egw_customfields
process->current(): Outgoing status: phpgwapi,status: C
process->current(): Incoming status: admin,status:
process->current(): Including: /var/www/egroupware/admin/setup/tables_current.inc.php
schema_proc::CreateTable(‘egw_admin_queue’,
Array
(
[fd] => Array
(
[cmd_id] => Array
(
[type] => auto
[nullable] =>
)
[cmd_uid] => Array
(
[type] => varchar
[precision] => 255
[nullable] =>
)
[cmd_creator] => Array
(
[type] => int
[meta] => user
[precision] => 4
[nullable] =>
)
[cmd_creator_email] => Array
(
[type] => varchar
[precision] => 128
[nullable] =>
)
[cmd_created] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
[nullable] =>
)
[cmd_type] => Array
(
[type] => varchar
[precision] => 32
[nullable] =>
[default] => admin_cmd
)
[cmd_status] => Array
(
[type] => int
[precision] => 1
)
[cmd_scheduled] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
)
[cmd_modified] => Array
(
[type] => int
[meta] => timestamp
[precision] => 8
)
[cmd_modifier] => Array
(
[type] => int
[meta] => user
[precision] => 4
)
[cmd_modifier_email] => Array
(
[type] => varchar
[precision] => 128
)
[cmd_error] => Array
(
[type] => varchar
[precision] => 255
)
[cmd_errno] => Array
(
[type] => int
[precision] => 4
)
[cmd_requested] => Array
(
[type] => int
[precision] => 4
)
[cmd_requested_email] => Array
(
[type] => varchar
[precision] => 128
)
[cmd_comment] => Array
(
[type] => varchar
[precision] => 255
)
[cmd_data] => Array
(
[type] => blob
)
[remote_id] => Array
(
[type] => int
[precision] => 4
)
)
[pk] => Array
(
[0] => cmd_id
)
[fk] => Array
(
)
[ix] => Array
(
[0] => cmd_status
[1] => cmd_scheduled
)
[uc] => Array
(
[0] => cmd_uid
)
)
)
CreateTableSQL(‘egw_admin_queue’,‘cmd_id I AUTOINCREMENT NOTNULL PRIMARY, cmd_uid C(255) NOTNULL, cmd_creator I4 NOTNULL, cmd_creator_email C(128) NOTNULL, cmd_created I8 NOTNULL, cmd_type C(32) NOTNULL DEFAULT ‘admin_cmd’, cmd_status I1, cmd_scheduled I8, cmd_modified I8, cmd_modifier I4, cmd_modifier_email C(128), cmd_error C(255), cmd_errno I4, cmd_requested I4, cmd_requested_email C(128), cmd_comment C(255), cmd_data B, remote_id I4’) sql=Array ( [0] => CREATE TABLE “egw_admin_queue” ( “cmd_id” SERIAL, “cmd_uid” VARCHAR(255) NOT NULL, “cmd_creator” INT4 NOT NULL, “cmd_creator_email” VARCHAR(128) NOT NULL, “cmd_created” INT8 NOT NULL, “cmd_type” VARCHAR(32) DEFAULT ‘admin_cmd’ NOT NULL, “cmd_status” SMALLINT, “cmd_scheduled” INT8, “cmd_modified” INT8, “cmd_modifier” INT4, “cmd_modifier_email” VARCHAR(128), “cmd_error” VARCHAR(255), “cmd_errno” INT4, “cmd_requested” INT4, “cmd_requested_email” VARCHAR(128), “cmd_comment” VARCHAR(255), “cmd_data” BYTEA, “remote_id” INT4, PRIMARY KEY (“cmd_id”) ) )
CreateIndexSQL(NULL,‘egw_admin_queue’,‘cmd_uid’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_admin_queue_cmd_uid” ON “egw_admin_queue” (“cmd_uid”) )
CreateIndexSQL(NULL,‘egw_admin_queue’,‘cmd_status’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_admin_queue_cmd_status” ON “egw_admin_queue” (“cmd_status”) )
CreateIndexSQL(NULL,‘egw_admin_queue’,‘cmd_scheduled’,Array ( ) ) sql=Array ( [0] => CREATE INDEX “egw_admin_queue_cmd_scheduled” ON “egw_admin_queue” (“cmd_scheduled”) )
Create Table egw_admin_queue
schema_proc::CreateTable(‘egw_admin_remote’,
Array
(
[fd] => Array
(
[remote_id] => Array
(
[type] => auto
[nullable] =>
)
[remote_name] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
[remote_hash] => Array
(
[type] => varchar
[precision] => 32
[nullable] =>
)
[remote_url] => Array
(
[type] => varchar
[precision] => 128
[nullable] =>
)
[remote_domain] => Array
(
[type] => varchar
[precision] => 64
[nullable] =>
)
)
[pk] => Array
(
[0] => remote_id
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
[0] => remote_name
)
)
)
CreateTableSQL(‘egw_admin_remote’,‘remote_id I AUTOINCREMENT NOTNULL PRIMARY, remote_name C(64) NOTNULL, remote_hash C(32) NOTNULL, remote_url C(128) NOTNULL, remote_domain C(64) NOTNULL’) sql=Array ( [0] => CREATE TABLE “egw_admin_remote” ( “remote_id” SERIAL, “remote_name” VARCHAR(64) NOT NULL, “remote_hash” VARCHAR(32) NOT NULL, “remote_url” VARCHAR(128) NOT NULL, “remote_domain” VARCHAR(64) NOT NULL, PRIMARY KEY (“remote_id”) ) )
CreateIndexSQL(NULL,‘egw_admin_remote’,‘remote_name’,Array ( [0] => UNIQUE ) ) sql=Array ( [0] => CREATE UNIQUE INDEX “egw_admin_remote_name” ON “egw_admin_remote” (“remote_name”) )
Create Table egw_admin_remote
process->current(): Outgoing status: admin,status: C
process->current(): Incoming status: preferences,status:
process->current(): No current tables for Preferences
process->current(): Outgoing status: preferences,status: C
process->current(): Incoming status: etemplate,status:
process->current(): Including: /var/www/egroupware/etemplate/setup/tables_current.inc.php
schema_proc::CreateTable(‘egw_etemplate’,
Array
(
[fd] => Array
(
[et_name] => Array
(
[type] => varchar
[precision] => 80
[nullable] =>
)
[et_template] => Array
(
[type] => varchar
[precision] => 20
[nullable] =>
[default] =>
)
[et_lang] => Array
(
[type] => varchar
[precision] => 5
[nullable] =>
[default] =>
)
[et_group] => Array
(
[type] => int
[precision] => 4
[nullable] =>
[default] => 0
)
[et_version] => Array
(
[type] => varchar
[precision] => 20
[nullable] =>
[default] =>
)
[et_data] => Array
(
[type] => longtext
)
[et_size] => Array
(
[type] => varchar
[precision] => 128
)
[et_style] => Array
(
[type] => text
)
[et_modified] => Array
(
[type] => int
[meta] => timestamp
[precision] => 4
[nullable] =>
[default] => 0
)
)
[pk] => Array
(
[0] => et_name
[1] => et_template
[2] => et_lang
[3] => et_group
[4] => et_version
)
[fk] => Array
(
)
[ix] => Array
(
)
[uc] => Array
(
)
)
)
CreateTableSQL(‘egw_etemplate’,‘et_name C(80) NOTNULL PRIMARY, et_template C(20) NOTNULL DEFAULT ‘’ PRIMARY, et_lang C(5) NOTNULL DEFAULT ‘’ PRIMARY, et_group I4 NOTNULL NOQUOTE DEFAULT 0 PRIMARY, et_version C(20) NOTNULL DEFAULT ‘’ PRIMARY, et_data XL, et_size C(128), et_style X, et_modified I4 NOTNULL NOQUOTE DEFAULT 0’) sql=Array ( [0] => CREATE TABLE “egw_etemplate” ( “et_name” VARCHAR(80) NOT NULL, “et_template” VARCHAR(20) DEFAULT ‘’ NOT NULL, “et_lang” VARCHAR(5) DEFAULT ‘’ NOT NULL, “et_group” INT4 DEFAULT 0 NOT NULL, “et_version” VARCHAR(20) DEFAULT ‘’ NOT NULL, “et_data” TEXT, “et_size” VARCHAR(128), “et_style” TEXT, “et_modified” INT4 DEFAULT 0 NOT NULL, PRIMARY KEY (“et_name”, “et_template”, “et_lang”, “et_group”, “et_version”) ) )
Create Table egw_etemplate
process->current(): Outgoing status: etemplate,status: C
process->current(): Incoming status: egw-pear,status: U
process->current(): No current tables for egw-pear
process->current(): Outgoing status: egw-pear,status: C
process->current(): Incoming status: groupdav,status: U
process->current(): No current tables for
process->current(): Outgoing status: groupdav,status: C
process->default_records(): Including default records for phpgwapi
Updating sequence 'egw_sqlfs_fs_id_seq using: SELECT setval(‘egw_sqlfs_fs_id_seq’,MAX(fs_id)) FROM egw_sqlfs
Invalid SQL: DELETE FROM egw_acl WHERE acl_appname=‘addressbook’ AND acl_location=’-1’ AND acl_account=-1
FEHLER: aktuelle Transaktion wurde abgebrochen, Befehle werden bis zum Ende der Transaktion ignoriert (-1)
Schritt 1 - Einfache Verwaltung der Anwendungen
nicht komplett
Erstelle Tabellen
Auf Ihre Anforderung hin wird dieses Skript nun versuchen die Kern-Tabellen und die Anwendungen Admin und Einstellungen für Sie installieren…
Status
Wenn Sie keine Fehlermeldungen erhalten, wurden Ihre Anwendungen installiert
Schritt 2 - Konfiguration
Nicht komplett Noch nicht bereit für diesen Schritt
Schritt 3 - Administrator-Konto
Nicht komplett Noch nicht bereit für diesen Schritt
Schritt 4 - Erweiterte Verwaltung der Anwendungen
Nicht komplett Noch nicht bereit für diesen Schritt
Schritt 5 - DB Datensicherung und Wiederherstellung
Nicht komplett Noch nicht bereit für diesen Schritt
Bei der erneuten überprüfung bekomme ich dann diese Fehlermeldung:
Database error
Invalid SQL: SELECT * FROM egw_customfields WHERE cf_app=‘addressbook’ AND (cf_private IS NULL OR “,”||cf_private||"," LIKE ‘%,%’) ORDER BY cf_order ASC
FEHLER: Spalte »,« existiert nicht
LINE 1: …E cf_app=‘addressbook’ AND (cf_private IS NULL OR “,”||cf_pr…
^ (-1)
