Here is a listing when you try to create a new domain TEST.CZ
spacer
Hlavní menu instalátoru
ball
Zpět na přihlášení uživatele http://192.168.1.23/egroupware/index.php
ball
Zkontrolovat instalaci
http://192.168.1.23/egroupware/setup/check_install.php
ball
Clear cache and register hooks
http://192.168.1.23/egroupware/setup/applications.php?hooks=1
ball
Odhlásit http://192.168.1.23/egroupware/setup/index.php?FormLogout=config
ball
Manuál / Nápověda
<http://manual.egroupware.org/egroupware/manual/index.php?referer=http%3A%2F
%2Fmanual.egroupware.org%2Fegroupware%2Fsetup%2Findex.php&lang=cs>
Instalátor - Doména: test.cz(mysqli)
process->pass(): #1 for new processing
process->current(): Incoming status: phpgwapi,status:
process->current(): Including:
/usr/share/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)
)CHARACTER SET utf8 )
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 INTEGER NOT NULL AUTO_INCREMENT, app_name
VARCHAR(25) NOT NULL, app_enabled INTEGER NOT NULL, app_order INTEGER
NOT NULL, app_tables TEXT, app_version VARCHAR(20) NOT NULL DEFAULT
’0.0’, app_icon VARCHAR(32), app_icon_app VARCHAR(25), app_index
VARCHAR(64), PRIMARY KEY (app_id) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_applications’,‘app_name’,Array ( [0] => UNIQUE ) )
sql=Array ( [0] => ALTER TABLE egw_applications ADD UNIQUE INDEX
egw_applications_name (app_name) )
CreateIndexSQL(NULL,‘egw_applications’,Array ( [0] => app_enabled [1] =>
app_order ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_applications
ADD INDEX egw_applications_enabled_order (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 INTEGER NOT NULL,
acl_rights INTEGER, PRIMARY KEY (acl_appname, acl_location,
acl_account) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_acl’,‘acl_account’,Array ( ) ) sql=Array ( [0] =>
ALTER TABLE egw_acl ADD INDEX egw_acl_account (acl_account) )
CreateIndexSQL(NULL,‘egw_acl’,Array ( [0] => acl_location [1] => acl_account
) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_acl ADD INDEX
egw_acl_location_account (acl_location, acl_account) )
CreateIndexSQL(NULL,‘egw_acl’,Array ( [0] => acl_appname [1] => acl_account
) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_acl ADD INDEX
egw_acl_appname_account (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 INTEGER NOT NULL AUTO_INCREMENT,
account_lid VARCHAR(64) NOT NULL, account_pwd VARCHAR(128) NOT NULL,
account_lastlogin INTEGER, account_lastloginfrom VARCHAR(255),
account_lastpwd_change INTEGER, account_status VARCHAR(1) NOT NULL
DEFAULT ‘A’, account_expires INTEGER, account_type VARCHAR(1),
account_primary_group INTEGER NOT NULL DEFAULT 0, PRIMARY KEY
(account_id) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_accounts’,‘account_lid’,Array ( [0] => UNIQUE ) )
sql=Array ( [0] => ALTER TABLE egw_accounts ADD UNIQUE INDEX
egw_accounts_account_lid (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 INTEGER NOT
NULL, preference_app VARCHAR(25) NOT NULL, preference_value TEXT,
PRIMARY KEY (preference_owner, preference_app) )CHARACTER SET utf8 )
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 INTEGER NOT NULL
AUTO_INCREMENT, loginid VARCHAR(64) NOT NULL, ip VARCHAR(40) NOT NULL,
li BIGINT NOT NULL, lo BIGINT, account_id INTEGER NOT NULL DEFAULT 0,
session_dla BIGINT, session_action VARCHAR(64), session_php
VARCHAR(64) NOT NULL, notification_heartbeat BIGINT, user_agent
VARCHAR(255), PRIMARY KEY (sessionid) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_access_log’,‘li’,Array ( ) ) sql=Array ( [0] =>
ALTER TABLE egw_access_log ADD INDEX egw_access_log_li (li) )
CreateIndexSQL(NULL,‘egw_access_log’,‘lo’,Array ( ) ) sql=Array ( [0] =>
ALTER TABLE egw_access_log ADD INDEX egw_access_log_lo (lo) )
CreateIndexSQL(NULL,‘egw_access_log’,‘session_dla’,Array ( ) ) sql=Array (
[0] => ALTER TABLE egw_access_log ADD INDEX egw_access_log_session_dla
(session_dla) )
CreateIndexSQL(NULL,‘egw_access_log’,‘session_php’,Array ( ) ) sql=Array (
[0] => ALTER TABLE egw_access_log ADD INDEX egw_access_log_session_php
(session_php) )
CreateIndexSQL(NULL,‘egw_access_log’,‘notification_heartbeat’,Array ( ) )
sql=Array ( [0] => ALTER TABLE egw_access_log ADD INDEX
egw_access_log_notification_heartbeat (notification_heartbeat) )
CreateIndexSQL(NULL,‘egw_access_log’,Array ( [0] => account_id [1] => ip [2]
=> li ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_access_log ADD
INDEX egw_access_log_account_id_ip_li (account_id, ip, li) )
CreateIndexSQL(NULL,‘egw_access_log’,Array ( [0] => account_id [1] =>
loginid [2] => li ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE
egw_access_log ADD INDEX egw_access_log_account_id_loginid_li
(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 INTEGER NOT NULL
AUTO_INCREMENT, hook_appname VARCHAR(255), hook_location VARCHAR(255),
hook_filename VARCHAR(255), PRIMARY KEY (hook_id) )CHARACTER SET utf8 )
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) )CHARACTER SET utf8 )
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) NOT NULL DEFAULT ‘’, app_name VARCHAR(32) NOT NULL DEFAULT
’common’, message_id VARCHAR(128) NOT NULL DEFAULT ‘’, content TEXT,
PRIMARY KEY (lang, app_name, message_id) )CHARACTER SET utf8 )
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 INTEGER, appname
VARCHAR(25) NOT NULL, PRIMARY KEY (appname) )CHARACTER SET utf8 )
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 INTEGER NOT NULL
AUTO_INCREMENT, cat_main INTEGER NOT NULL DEFAULT 0, cat_parent INTEGER
NOT NULL DEFAULT 0, cat_level SMALLINT NOT NULL DEFAULT 0, cat_owner
VARCHAR(255) NOT NULL DEFAULT ‘0’, 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 BIGINT NOT NULL, PRIMARY
KEY (cat_id) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_categories’,Array ( [0] => cat_appname [1] =>
cat_owner [2] => cat_parent [3] => cat_level ) ,Array ( ) ) sql=Array ( [0]
=> ALTER TABLE egw_categories ADD INDEX
egw_categories_appname_owner_parent_level (cat_appname, cat_owner,
cat_parent, cat_level) )
Create Table egw_categories
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 INTEGER NOT NULL AUTO_INCREMENT, history_record_id INTEGER
NOT NULL, history_appname VARCHAR(64) NOT NULL, history_owner INTEGER
NOT NULL, history_status VARCHAR(64) NOT NULL, history_new_value TEXT,
history_timestamp TIMESTAMP NOT NULL, history_old_value TEXT,
sessionid INTEGER, PRIMARY KEY (history_id) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_history_log’,Array ( [0] => history_appname [1] =>
history_record_id [2] => history_id ) ,Array ( ) ) sql=Array ( [0] => ALTER
TABLE egw_history_log ADD INDEX egw_history_log_appname_record_id_id
(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
INTEGER NOT NULL, async_times VARCHAR(255) NOT NULL, async_method
VARCHAR(80) NOT NULL, async_data TEXT, async_account_id INTEGER NOT NULL
DEFAULT 0, PRIMARY KEY (async_id) )CHARACTER SET utf8 )
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
DATETIME, sync_modified DATETIME, sync_deleted DATETIME, sync_id
INTEGER NOT NULL AUTO_INCREMENT, sync_changedby INTEGER NOT NULL, PRIMARY
KEY (sync_id) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_added’,Array ( ) )
sql=Array ( [0] => ALTER TABLE egw_api_content_history ADD INDEX
egw_api_content_history_sync_added (sync_added) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_modified’,Array ( ) )
sql=Array ( [0] => ALTER TABLE egw_api_content_history ADD INDEX
egw_api_content_history_sync_modified (sync_modified) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_deleted’,Array ( ) )
sql=Array ( [0] => ALTER TABLE egw_api_content_history ADD INDEX
egw_api_content_history_sync_deleted (sync_deleted) )
CreateIndexSQL(NULL,‘egw_api_content_history’,‘sync_changedby’,Array ( ) )
sql=Array ( [0] => ALTER TABLE egw_api_content_history ADD INDEX
egw_api_content_history_sync_changedby (sync_changedby) )
CreateIndexSQL(NULL,‘egw_api_content_history’,Array ( [0] => sync_appname
[1] => sync_contentid ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE
egw_api_content_history ADD INDEX
egw_api_content_history_sync_appname_sync_contentid (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 INTEGER NOT NULL AUTO_INCREMENT, 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 BIGINT NOT NULL, link_owner INTEGER NOT NULL,
deleted DATETIME, PRIMARY KEY (link_id) )CHARACTER SET utf8 )
CreateIndexSQL(NULL,‘egw_links’,‘deleted’,Array ( ) ) sql=Array ( [0] =>
ALTER TABLE egw_links ADD INDEX egw_links_deleted (deleted) )
CreateIndexSQL(NULL,‘egw_links’,Array ( [0] => link_app1 [1] => link_id1 [2]
=> link_lastmod ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_links
ADD INDEX egw_links_app1_id1_lastmod (link_app1, link_id1,
link_lastmod) )
CreateIndexSQL(NULL,‘egw_links’,Array ( [0] => link_app2 [1] => link_id2 [2]
=> link_lastmod ) ,Array ( ) ) sql=Array ( [0] => ALTER TABLE egw_links
ADD INDEX egw_links_app2_id2_lastmod (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
(
