[gerik]

Hallo,

ich habe mir ein SUSE 10.3 mit TYPO3 4.1.3 eingerichtet und bekomme zahlreiche Meldungen unter Install / Database Analyser / Compare with $TCA.

Was da faul? Kann mir jemand einen Tip geben?

Tables and fields in $TCA, but not in database:
Table and field definitions OK
All fields and tables configured in $TCA appeared to exist in the database as well


Tables from database, but not in $TCA:
static_tsconfig_help
Field name: Info:
uid int(11) auto_increment
guide int(11) default '0'
md5hash varchar(32) default ''
description text
obj_string tinytext
appdata blob
title tinytext



tx_impexp_presets
Field name: Info:
uid int(11) auto_increment
user_uid int(11) default '0'
title tinytext
public tinyint(3) default '0'
item_uid int(11) default '0'
preset_data blob



Extra tables in the database
There are some tables in the database which are not configured in the $TCA array. You should probably not worry about this, but please make sure that you know what these tables are about and why they are not configured in $TCA.



Fields from database, but not in $TCA:
be_users
Field name: Info / Suggestion for the field:
workspace_id int(11) default '0'
--------------------------------------------------------------------------------

'workspace_id' => array (
'label' => 'WORKSPACE_ID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

'workspace_id' => array (
'label' => 'WORKSPACE_ID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
workspace_preview tinyint(3) default '1'
--------------------------------------------------------------------------------

'workspace_preview' => array (
'label' => 'WORKSPACE_PREVIEW:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

'workspace_preview' => array (
'label' => 'WORKSPACE_PREVIEW:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),



fe_users
Field name: Info / Suggestion for the field:
is_online int(10) unsigned default '0'
--------------------------------------------------------------------------------

'is_online' => array (
'label' => 'IS_ONLINE:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

'is_online' => array (
'label' => 'IS_ONLINE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),



pages
Field name: Info / Suggestion for the field:
t3ver_oid int(11) default '0'
--------------------------------------------------------------------------------

't3ver_oid' => array (
'label' => 'T3VER_OID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_oid' => array (
'label' => 'T3VER_OID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_id int(11) default '0'
--------------------------------------------------------------------------------

't3ver_id' => array (
'label' => 'T3VER_ID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_id' => array (
'label' => 'T3VER_ID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_wsid int(11) default '0'
--------------------------------------------------------------------------------

't3ver_wsid' => array (
'label' => 'T3VER_WSID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_wsid' => array (
'label' => 'T3VER_WSID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_state tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_state' => array (
'label' => 'T3VER_STATE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_state' => array (
'label' => 'T3VER_STATE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3ver_stage tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_stage' => array (
'label' => 'T3VER_STAGE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_stage' => array (
'label' => 'T3VER_STAGE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3ver_count int(11) default '0'
--------------------------------------------------------------------------------

't3ver_count' => array (
'label' => 'T3VER_COUNT:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_count' => array (
'label' => 'T3VER_COUNT:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_tstamp int(11) default '0'
--------------------------------------------------------------------------------

't3ver_tstamp' => array (
'label' => 'T3VER_TSTAMP:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_tstamp' => array (
'label' => 'T3VER_TSTAMP:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_swapmode tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_swapmode' => array (
'label' => 'T3VER_SWAPMODE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_swapmode' => array (
'label' => 'T3VER_SWAPMODE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3_origuid int(11) default '0'
--------------------------------------------------------------------------------

't3_origuid' => array (
'label' => 'T3_ORIGUID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3_origuid' => array (
'label' => 'T3_ORIGUID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),



pages_language_overlay
Field name: Info / Suggestion for the field:
t3ver_oid int(11) default '0'
--------------------------------------------------------------------------------

't3ver_oid' => array (
'label' => 'T3VER_OID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_oid' => array (
'label' => 'T3VER_OID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_id int(11) default '0'
--------------------------------------------------------------------------------

't3ver_id' => array (
'label' => 'T3VER_ID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_id' => array (
'label' => 'T3VER_ID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_wsid int(11) default '0'
--------------------------------------------------------------------------------

't3ver_wsid' => array (
'label' => 'T3VER_WSID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_wsid' => array (
'label' => 'T3VER_WSID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_state tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_state' => array (
'label' => 'T3VER_STATE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_state' => array (
'label' => 'T3VER_STATE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3ver_stage tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_stage' => array (
'label' => 'T3VER_STAGE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_stage' => array (
'label' => 'T3VER_STAGE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3ver_count int(11) default '0'
--------------------------------------------------------------------------------

't3ver_count' => array (
'label' => 'T3VER_COUNT:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_count' => array (
'label' => 'T3VER_COUNT:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_tstamp int(11) default '0'
--------------------------------------------------------------------------------

't3ver_tstamp' => array (
'label' => 'T3VER_TSTAMP:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_tstamp' => array (
'label' => 'T3VER_TSTAMP:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3_origuid int(11) default '0'
--------------------------------------------------------------------------------

't3_origuid' => array (
'label' => 'T3_ORIGUID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3_origuid' => array (
'label' => 'T3_ORIGUID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),



tt_content
Field name: Info / Suggestion for the field:
t3ver_oid int(11) default '0'
--------------------------------------------------------------------------------

't3ver_oid' => array (
'label' => 'T3VER_OID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_oid' => array (
'label' => 'T3VER_OID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_id int(11) default '0'
--------------------------------------------------------------------------------

't3ver_id' => array (
'label' => 'T3VER_ID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_id' => array (
'label' => 'T3VER_ID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_wsid int(11) default '0'
--------------------------------------------------------------------------------

't3ver_wsid' => array (
'label' => 'T3VER_WSID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_wsid' => array (
'label' => 'T3VER_WSID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_state tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_state' => array (
'label' => 'T3VER_STATE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_state' => array (
'label' => 'T3VER_STATE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3ver_stage tinyint(4) default '0'
--------------------------------------------------------------------------------

't3ver_stage' => array (
'label' => 'T3VER_STAGE:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('Item number 1', '1'),
array('Item number 2', '2'),
array('-----', '--div--'),
array('Item number 3', '3')
),
'default' => '1'
)
),

----- OR -----

't3ver_stage' => array (
'label' => 'T3VER_STAGE:',
'exclude' => 0,
'config' => array (
'type' => 'check',
'default' => '1'
)
),
t3ver_count int(11) default '0'
--------------------------------------------------------------------------------

't3ver_count' => array (
'label' => 'T3VER_COUNT:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_count' => array (
'label' => 'T3VER_COUNT:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3ver_tstamp int(11) default '0'
--------------------------------------------------------------------------------

't3ver_tstamp' => array (
'label' => 'T3VER_TSTAMP:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3ver_tstamp' => array (
'label' => 'T3VER_TSTAMP:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),
t3_origuid int(11) default '0'
--------------------------------------------------------------------------------

't3_origuid' => array (
'label' => 'T3_ORIGUID:',
'exclude' => 0,
'config' => array (
'type' => 'input',
'size' => '8',
'max' => '20',
'eval' => 'date',
'default' => '0',
'checkbox' => '0'
)
),

----- OR -----

't3_origuid' => array (
'label' => 'T3_ORIGUID:',
'exclude' => 0,
'config' => array (
'type' => 'select',
'items' => array (
array('[nothing]', 0),
array('Extra choice! Only negative values here.', -1),
array('__Divider:__', '--div--')
),
'foreign_table' => '[some_table_name]'
)
),



Extra fields in the database
There are some additional fields the database tables which are not configured in the $TCA array. You should probably not worry about this, but please make sure that you know what these fields are about and why they are not configured in $TCA.



Comparison between database and $TCA:
Actual and suggested field definitions
This table shows you the suggested field definitions which are calculated based on the configuration in $TCA. If the suggested value differs from the actual current database value, you should not panic, but simply check if the datatype of that field is sufficient compared to the data, you want TYPO3 to put there.


pages
Field name: Suggested value from $TCA: Actual value from database:
doktype int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
title tinytext NOT NULL tinytext
TSconfig text NOT NULL text
php_tree_stop tinyint(3) NOT NULL default '0' tinyint(4) default '0'
is_siteroot tinyint(3) NOT NULL default '0' tinyint(4) default '0'
storage_pid int(11) NOT NULL default '0' int(11) default '0'
t3ver_label varchar(30) NOT NULL default '' varchar(30) default ''
editlock tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
layout int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
fe_group blob NOT NULL varchar(100) default '0'
extendToSubpages tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
nav_title tinytext NOT NULL tinytext
nav_hide tinyint(3) NOT NULL default '0' tinyint(4) default '0'
subtitle tinytext NOT NULL tinytext
target varchar(20) NOT NULL default '' varchar(20) default ''
alias varchar(32) NOT NULL default '' varchar(32) default ''
url tinytext NOT NULL tinytext
urltype int(11) NOT NULL default '0' tinyint(4) unsigned default '0'
lastUpdated int(11) NOT NULL default '0' int(10) unsigned default '0'
newUntil int(11) NOT NULL default '0' int(10) unsigned default '0'
cache_timeout int(11) NOT NULL default '0' int(10) unsigned default '0'
no_cache tinyint(3) NOT NULL default '0' int(10) unsigned default '0'
no_search tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
shortcut int(11) NOT NULL default '0' int(10) unsigned default '0'
shortcut_mode int(11) NOT NULL default '0' int(10) unsigned default '0'
content_from_pid int(11) NOT NULL default '0' int(10) unsigned default '0'
mount_pid int(11) NOT NULL default '0' int(10) unsigned default '0'
keywords text NOT NULL text
description tinytext NOT NULL text
abstract text NOT NULL text
author varchar(80) NOT NULL default '' tinytext
author_email varchar(80) NOT NULL default '' varchar(80) default ''
media blob NOT NULL blob
mount_pid_ol tinyint(3) NOT NULL default '0' tinyint(4) default '0'
module varchar(8) NOT NULL default '' varchar(10) default ''
fe_login_mode int(11) NOT NULL default '0' tinyint(4) default '0'
l18n_cfg tinyint(3) NOT NULL default '0' tinyint(4) default '0'



be_users
Field name: Suggested value from $TCA: Actual value from database:
username varchar(50) NOT NULL default '' varchar(50) default ''
password varchar(40) NOT NULL default '' varchar(40) default ''
usergroup blob NOT NULL tinytext
lockToDomain varchar(50) NOT NULL default '' varchar(50) default ''
db_mountpoints blob NOT NULL varchar(255) default ''
file_mountpoints blob NOT NULL varchar(255) default ''
email varchar(80) NOT NULL default '' varchar(80) default ''
realName varchar(80) NOT NULL default '' varchar(80) default ''
disable tinyint(3) NOT NULL default '0' tinyint(1) unsigned default '0'
disableIPlock tinyint(3) NOT NULL default '0' tinyint(1) unsigned default '0'
admin tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
options tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
fileoper_perms tinyint(3) NOT NULL default '0' tinyint(4) default '0'
workspace_perms tinyint(3) NOT NULL default '0' tinyint(3) default '1'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
lang varchar(2) NOT NULL default '' char(2) default ''
userMods tinyblob NOT NULL tinytext
allowed_languages tinyblob NOT NULL tinytext
TSconfig text NOT NULL text



be_groups
Field name: Suggested value from $TCA: Actual value from database:
title varchar(50) NOT NULL default '' varchar(50) default ''
db_mountpoints blob NOT NULL varchar(255) default ''
file_mountpoints blob NOT NULL varchar(255) default ''
workspace_perms tinyint(3) NOT NULL default '0' tinyint(3) default '1'
pagetypes_select blob NOT NULL tinytext
tables_modify tinyblob NOT NULL text
tables_select tinyblob NOT NULL text
non_exclude_fields tinyblob NOT NULL text
explicit_allowdeny tinyblob NOT NULL text
allowed_languages tinyblob NOT NULL tinytext
custom_options tinyblob NOT NULL text
hidden tinyint(3) NOT NULL default '0' tinyint(1) unsigned default '0'
lockToDomain varchar(50) NOT NULL default '' varchar(50) default ''
groupMods tinyblob NOT NULL text
inc_access_lists tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
description text NOT NULL text
TSconfig text NOT NULL text
hide_in_lists tinyint(3) NOT NULL default '0' tinyint(4) default '0'
subgroup blob NOT NULL tinytext



sys_filemounts
Field name: Suggested value from $TCA: Actual value from database:
title varchar(30) NOT NULL default '' varchar(30) default ''
path varchar(120) NOT NULL default '' varchar(120) default ''
hidden tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
base int(11) NOT NULL default '0' tinyint(4) unsigned default '0'



sys_workspace
Field name: Suggested value from $TCA: Actual value from database:
title varchar(30) NOT NULL default '' varchar(30) default ''
description text NOT NULL tinytext
adminusers blob NOT NULL tinytext
members tinyblob NOT NULL text
reviewers tinyblob NOT NULL text
db_mountpoints blob NOT NULL varchar(255) default ''
file_mountpoints blob NOT NULL varchar(255) default ''
publish_time int(11) NOT NULL default '0' int(11) default '0'
unpublish_time int(11) NOT NULL default '0' int(11) default '0'
freeze tinyint(3) NOT NULL default '0' tinyint(3) default '0'
live_edit tinyint(3) NOT NULL default '0' tinyint(3) default '0'
review_stage_edit tinyint(3) NOT NULL default '0' tinyint(3) default '0'
disable_autocreate tinyint(3) NOT NULL default '0' tinyint(1) default '0'
swap_modes int(11) NOT NULL default '0' tinyint(3) default '0'
vtypes tinyint(3) NOT NULL default '0' tinyint(3) default '0'
publish_access tinyint(3) NOT NULL default '0' tinyint(3) default '0'
stagechg_notification int(11) NOT NULL default '0' tinyint(3) default '0'



sys_language
Field name: Suggested value from $TCA: Actual value from database:
title varchar(80) NOT NULL default '' varchar(80) default ''
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
static_lang_isocode int(11) NOT NULL default '0' int(11) unsigned default '0'
flag int(11) NOT NULL default '0' varchar(20) default ''



tt_content
Field name: Suggested value from $TCA: Actual value from database:
CType varchar(10) NOT NULL default '' varchar(30) default ''
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
fe_group blob NOT NULL varchar(100) default '0'
sys_language_uid int(11) NOT NULL default '0' int(11) default '0'
l18n_parent int(11) NOT NULL default '0' int(11) default '0'
layout int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
colPos int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
date int(11) NOT NULL default '0' int(10) unsigned default '0'
header tinytext NOT NULL tinytext
header_position varchar(6) NOT NULL default '' varchar(6) default ''
header_link tinytext NOT NULL tinytext
header_layout int(11) NOT NULL default '0' varchar(30) default '0'
subheader tinytext NOT NULL tinytext
bodytext text NOT NULL mediumtext
text_align varchar(6) NOT NULL default '' varchar(6) default ''
text_face int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
text_size int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
text_color int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
text_properties tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
image tinyblob NOT NULL blob
imagewidth int(11) NOT NULL default '0' mediumint(11) unsigned default '0'
imageheight int(11) NOT NULL default '0' mediumint(8) unsigned default '0'
imageorient int(11) NOT NULL default '0' tinyint(4) unsigned default '0'
imageborder tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
image_noRows tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
image_link tinytext NOT NULL tinytext
image_zoom tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
image_effects int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
image_frames int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
image_compression int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
imagecols int(11) NOT NULL default '0' tinyint(4) unsigned default '0'
imagecaption text NOT NULL text
imagecaption_position varchar(6) NOT NULL default '' varchar(6) default ''
altText text NOT NULL text
titleText text NOT NULL text
longdescURL text NOT NULL text
cols int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
pages blob NOT NULL tinyblob
recursive int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
menu_type int(11) NOT NULL default '0' varchar(30) default '0'
list_type varchar(20) NOT NULL default '' varchar(36) default '0'
select_key varchar(80) NOT NULL default '' varchar(80) default ''
table_bgColor int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
table_border int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
table_cellspacing int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
table_cellpadding int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
media tinyblob NOT NULL blob
multimedia blob NOT NULL tinyblob
filelink_size tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
records tinyblob NOT NULL blob
spaceBefore int(11) NOT NULL default '0' tinyint(4) unsigned default '0'
spaceAfter int(11) NOT NULL default '0' tinyint(4) unsigned default '0'
section_frame int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
splash_layout int(11) NOT NULL default '0' varchar(30) default '0'
sectionIndex tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
linkToTop tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
rte_enabled tinyint(3) NOT NULL default '0' tinyint(4) default '0'
t3ver_label varchar(30) NOT NULL default '' varchar(30) default ''



fe_users
Field name: Suggested value from $TCA: Actual value from database:
username varchar(50) NOT NULL default '' varchar(50) default ''
password varchar(40) NOT NULL default '' varchar(40) default ''
usergroup tinyblob NOT NULL tinyblob
lockToDomain varchar(50) NOT NULL default '' varchar(50) default ''
name varchar(80) NOT NULL default '' varchar(80) default ''
address text NOT NULL tinytext
telephone varchar(20) NOT NULL default '' varchar(20) default ''
fax varchar(20) NOT NULL default '' varchar(20) default ''
email varchar(80) NOT NULL default '' varchar(80) default ''
title varchar(40) NOT NULL default '' varchar(40) default ''
zip varchar(10) NOT NULL default '' varchar(10) default ''
city varchar(50) NOT NULL default '' varchar(50) default ''
country varchar(40) NOT NULL default '' varchar(40) default ''
www varchar(80) NOT NULL default '' varchar(80) default ''
company varchar(80) NOT NULL default '' varchar(80) default ''
image blob NOT NULL tinyblob
disable tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
TSconfig text NOT NULL blob



fe_groups
Field name: Suggested value from $TCA: Actual value from database:
hidden tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'
title varchar(50) NOT NULL default '' varchar(50) default ''
subgroup blob NOT NULL tinyblob
lockToDomain varchar(50) NOT NULL default '' varchar(50) default ''
description text NOT NULL text
TSconfig text NOT NULL blob



sys_domain
Field name: Suggested value from $TCA: Actual value from database:
domainName varchar(80) NOT NULL default '' varchar(80) default ''
redirectTo varchar(120) NOT NULL default '' varchar(120) default ''
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
prepend_params tinyint(3) NOT NULL default '0' int(10) default '0'



pages_language_overlay
Field name: Suggested value from $TCA: Actual value from database:
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
title tinytext NOT NULL tinytext
subtitle tinytext NOT NULL tinytext
nav_title tinytext NOT NULL tinytext
keywords text NOT NULL text
description tinytext NOT NULL text
abstract text NOT NULL text
author varchar(80) NOT NULL default '' tinytext
author_email varchar(80) NOT NULL default '' varchar(80) default ''
media blob NOT NULL tinyblob
sys_language_uid int(11) NOT NULL default '0' int(11) unsigned default '0'
t3ver_label varchar(30) NOT NULL default '' varchar(30) default ''



sys_template
Field name: Suggested value from $TCA: Actual value from database:
title tinytext NOT NULL tinytext
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
root tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
clear tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
sitetitle tinytext NOT NULL tinytext
constants text NOT NULL blob
resources tinyblob NOT NULL blob
nextLevel int(11) NOT NULL default '0' varchar(5) default ''
include_static blob NOT NULL tinyblob
include_static_file blob NOT NULL blob
basedOn tinyblob NOT NULL tinyblob
includeStaticAfterBasedOn tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
config text NOT NULL blob
editorcfg text NOT NULL blob
description text NOT NULL text
static_file_mode int(11) NOT NULL default '0' tinyint(4) unsigned default '0'
t3ver_label varchar(30) NOT NULL default '' varchar(30) default ''



static_template
Field name: Suggested value from $TCA: Actual value from database:
title tinytext NOT NULL tinytext
constants text NOT NULL blob
include_static blob NOT NULL tinyblob
config text NOT NULL blob
editorcfg text NOT NULL blob
description text NOT NULL text



sys_note
Field name: Suggested value from $TCA: Actual value from database:
category int(11) NOT NULL default '0' tinyint(3) unsigned default '0'
subject tinytext NOT NULL tinytext
message text NOT NULL text
author varchar(80) NOT NULL default '' varchar(80) default ''
email varchar(80) NOT NULL default '' varchar(80) default ''
personal tinyint(3) NOT NULL default '0' tinyint(3) unsigned default '0'



tx_rtehtmlarea_acronym
Field name: Suggested value from $TCA: Actual value from database:
hidden tinyint(3) NOT NULL default '0' tinyint(4) unsigned default '0'
starttime int(11) NOT NULL default '0' int(11) unsigned default '0'
endtime int(11) NOT NULL default '0' int(11) unsigned default '0'
sys_language_uid int(11) NOT NULL default '0' int(11) default '0'
type int(11) NOT NULL default '0' tinyint(3) unsigned default '1'
term tinytext NOT NULL tinytext
acronym tinytext NOT NULL tinytext




--------------------------------------------------------------------------------
OS detected: UNIX
UNIX/CGI detected: NO
PATH_thisScript: /srv/www/vhosts/esg-consulting.com/typo3/install/index.php

Backend admin in new window.
Frontend website in new window.

Viele Grüße

Gerik