Zum Inhalt springen

Php-Fehlermeldung, Site sehr langsam

Erstellt am 29. September 2005 · 1 Antwort · letzte Antwort am 29. September 2005

Tags: Datenbank, Cache & Performance, Frage

roadrunner568 ·

Hallo!

Folgendes Problem.

Meine Site ist sehr langsam (Seitenaufbau ca.20 sec) und im Installtool krieg ich nach compare folgende Fehlermeldung (ganz oben, oberhalb des Installtools:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/quickstart/quickstart/typo3/t3lib/class.t3lib_db.php on line 913

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/quickstart/quickstart/typo3/t3lib/class.t3lib_db.php on line 931

Was hab ich gemacht:

Ich habe die Ordner der bisherigen Webseite (war eine "normale" htm Site) gelöscht um nur noch die Typo3 Seite zu verwenden. Da waren auch Ordner dabei die bisherige PHP Funktionen enthielten, die nun nicht mehr in Verwendung sind.

Ich hab schon die beiden Tabellen cache_pages und cache_pagesections neu angelegt, es ändert nichts an dem Problem.

Wie find ich raus, wo hier der Fehler begraben liegt?

mfg
Leo

roadrunner568 ·

Ergänzung dazu:

Wenn ich im Install-Tool auf Database Analyzer gehe und auf

Update required tables COMPARE drücke schlägt das Tool nur vor ein paar alte Tabellen endgültig zu löschen.

Wenn ich aber auf das 2 Zeilen darunter stehende Compare:

typo3conf/database.sql (1.2 M) COMPARE IMPORT VIEW drücke dann kommt folgendes obwohl diese Tabellen alle da sind und auch nicht invalid sind.

Ich verstehe erstens nicht wo der Unterschied zwischen den beiden COMPARE Befehlen liegt und warum er diese TAbellen anlegen will obwohl sie da sind.

Update database tables and fields:
Table and field definitions should be updated
There seems to be a number of differencies between the database and the selected SQL-file. Please select which statements you want to execute in order to update your database:

Add tables
CREATE TABLE `be_groups` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`title` varchar(20) NOT NULL default '',
`non_exclude_fields` blob NOT NULL,
`db_mountpoints` varchar(40) NOT NULL default '',
`pagetypes_select` tinyblob NOT NULL,
`tables_select` blob NOT NULL,
`tables_modify` blob NOT NULL,
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`groupMods` tinyblob NOT NULL,
`file_mountpoints` varchar(40) NOT NULL default '',
`hidden` tinyint(3) unsigned NOT NULL default '0',
`inc_access_lists` tinyint(3) unsigned NOT NULL default '0',
`description` text NOT NULL,
`lockToDomain` varchar(50) NOT NULL default '',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`TSconfig` blob NOT NULL,
`subgroup` tinyblob NOT NULL,
`hide_in_lists` tinyint(4) NOT NULL default '0',
`explicit_allowdeny` blob NOT NULL,
`allowed_languages` tinyblob NOT NULL,
`custom_options` blob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `be_sessions` (
`ses_id` varchar(32) NOT NULL default '',
`ses_name` varchar(32) NOT NULL default '',
`ses_userid` int(11) unsigned NOT NULL default '0',
`ses_tstamp` int(11) unsigned NOT NULL default '0',
`ses_data` mediumblob NOT NULL,
`ses_iplock` varchar(39) NOT NULL default '',
`ses_hashlock` int(11) NOT NULL default '0',
PRIMARY KEY (`ses_id`,`ses_name`)
) TYPE=MyISAM;
CREATE TABLE `be_users` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`admin` tinyint(4) unsigned NOT NULL default '0',
`usergroup` tinyblob NOT NULL,
`disable` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`lang` char(2) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`db_mountpoints` varchar(40) NOT NULL default '',
`options` tinyint(4) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`realName` varchar(80) NOT NULL default '',
`userMods` tinyblob NOT NULL,
`uc` blob NOT NULL,
`file_mountpoints` varchar(40) NOT NULL default '',
`fileoper_perms` tinyint(4) NOT NULL default '0',
`lockToDomain` varchar(50) NOT NULL default '',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`TSconfig` blob NOT NULL,
`lastlogin` int(10) unsigned NOT NULL default '0',
`createdByAction` int(11) NOT NULL default '0',
`usergroup_cached_list` tinytext NOT NULL,
`disableIPlock` tinyint(3) unsigned NOT NULL default '0',
`allowed_languages` tinyblob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `username` (`username`)
) TYPE=MyISAM;
CREATE TABLE `cache_hash` (
`hash` varchar(32) NOT NULL default '',
`content` mediumblob NOT NULL,
`tstamp` int(11) unsigned NOT NULL default '0',
`ident` varchar(20) NOT NULL default '',
PRIMARY KEY (`hash`)
) TYPE=MyISAM;
CREATE TABLE `cache_imagesizes` (
`md5hash` varchar(32) NOT NULL default '',
`md5filename` varchar(32) NOT NULL default '',
`tstamp` int(11) NOT NULL default '0',
`filename` tinytext NOT NULL,
`imagewidth` mediumint(11) unsigned NOT NULL default '0',
`imageheight` mediumint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`md5filename`)
) TYPE=MyISAM;
CREATE TABLE `cache_md5params` (
`md5hash` varchar(20) NOT NULL default '',
`tstamp` int(11) NOT NULL default '0',
`type` tinyint(3) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`md5hash`)
) TYPE=MyISAM;
CREATE TABLE `cache_pages` (
`id` int(11) unsigned NOT NULL auto_increment,
`hash` varchar(32) NOT NULL default '',
`page_id` int(11) unsigned NOT NULL default '0',
`HTML` mediumblob NOT NULL,
`tstamp` int(11) unsigned NOT NULL default '0',
`expires` int(10) unsigned NOT NULL default '0',
`cache_data` mediumblob NOT NULL,
`reg1` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `page_id` (`page_id`),
KEY `sel` (`hash`,`page_id`)
) TYPE=MyISAM;
CREATE TABLE `cache_pagesection` (
`page_id` int(11) unsigned NOT NULL default '0',
`mpvar_hash` int(11) unsigned NOT NULL default '0',
`content` blob NOT NULL,
`tstamp` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`page_id`,`mpvar_hash`)
) TYPE=MyISAM;
CREATE TABLE `cache_typo3temp_log` (
`md5hash` varchar(32) NOT NULL default '',
`tstamp` int(11) NOT NULL default '0',
`filename` tinytext NOT NULL,
`orig_filename` tinytext NOT NULL,
PRIMARY KEY (`md5hash`)
) TYPE=MyISAM;
CREATE TABLE `fe_groups` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`title` varchar(20) NOT NULL default '',
`hidden` tinyint(3) unsigned NOT NULL default '0',
`lockToDomain` varchar(50) NOT NULL default '',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`description` text NOT NULL,
`TSconfig` blob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `fe_session_data` (
`hash` varchar(32) NOT NULL default '',
`content` mediumblob NOT NULL,
`tstamp` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`hash`)
) TYPE=MyISAM;
CREATE TABLE `fe_sessions` (
`ses_id` varchar(32) NOT NULL default '',
`ses_name` varchar(32) NOT NULL default '',
`ses_userid` int(11) unsigned NOT NULL default '0',
`ses_tstamp` int(11) unsigned NOT NULL default '0',
`ses_data` blob NOT NULL,
`ses_iplock` varchar(39) NOT NULL default '',
`ses_hashlock` int(11) NOT NULL default '0',
PRIMARY KEY (`ses_id`,`ses_name`)
) TYPE=MyISAM;
CREATE TABLE `fe_users` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`password` varchar(40) NOT NULL default '',
`usergroup` tinyblob NOT NULL,
`disable` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`name` varchar(80) NOT NULL default '',
`address` tinytext NOT NULL,
`telephone` varchar(20) NOT NULL default '',
`fax` varchar(20) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`lockToDomain` varchar(50) NOT NULL default '',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`uc` blob NOT NULL,
`title` varchar(40) NOT NULL default '',
`zip` varchar(10) NOT NULL default '',
`city` varchar(50) NOT NULL default '',
`country` varchar(40) NOT NULL default '',
`www` varchar(80) NOT NULL default '',
`company` varchar(80) NOT NULL default '',
`image` tinyblob NOT NULL,
`TSconfig` blob NOT NULL,
`module_sys_dmail_category` int(10) unsigned NOT NULL default '0',
`module_sys_dmail_html` tinyint(3) unsigned NOT NULL default '0',
`fe_cruser_id` int(10) unsigned NOT NULL default '0',
`lastlogin` int(10) unsigned NOT NULL default '0',
`is_online` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `username` (`username`),
KEY `pid` (`pid`,`username`),
KEY `is_online` (`is_online`)
) TYPE=MyISAM;
CREATE TABLE `pages` (
`uid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`sorting` int(11) unsigned NOT NULL default '0',
`deleted` tinyint(4) unsigned NOT NULL default '0',
`perms_userid` int(11) unsigned NOT NULL default '0',
`perms_groupid` int(11) unsigned NOT NULL default '0',
`perms_user` tinyint(4) unsigned NOT NULL default '0',
`perms_group` tinyint(4) unsigned NOT NULL default '0',
`perms_everybody` tinyint(4) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`doktype` tinyint(3) unsigned NOT NULL default '0',
`TSconfig` blob NOT NULL,
`storage_pid` int(11) NOT NULL default '0',
`is_siteroot` tinyint(4) NOT NULL default '0',
`php_tree_stop` tinyint(4) NOT NULL default '0',
`tx_impexp_origuid` int(11) NOT NULL default '0',
`url` tinytext NOT NULL,
`hidden` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`urltype` tinyint(4) unsigned NOT NULL default '0',
`shortcut` int(10) unsigned NOT NULL default '0',
`shortcut_mode` int(10) unsigned NOT NULL default '0',
`no_cache` int(10) unsigned NOT NULL default '0',
`fe_group` int(11) NOT NULL default '0',
`subtitle` tinytext NOT NULL,
`layout` tinyint(3) unsigned NOT NULL default '0',
`target` varchar(20) NOT NULL default '',
`media` blob NOT NULL,
`lastUpdated` int(10) unsigned NOT NULL default '0',
`keywords` text NOT NULL,
`cache_timeout` int(10) unsigned NOT NULL default '0',
`newUntil` int(10) unsigned NOT NULL default '0',
`description` text NOT NULL,
`no_search` tinyint(3) unsigned NOT NULL default '0',
`SYS_LASTCHANGED` int(10) unsigned NOT NULL default '0',
`abstract` text NOT NULL,
`module` varchar(10) NOT NULL default '',
`extendToSubpages` tinyint(3) unsigned NOT NULL default '0',
`author` tinytext NOT NULL,
`author_email` varchar(80) NOT NULL default '',
`nav_title` tinytext NOT NULL,
`content_from_pid` int(10) unsigned NOT NULL default '0',
`mount_pid` int(10) unsigned NOT NULL default '0',
`alias` varchar(20) NOT NULL default '',
`nav_hide` tinyint(4) NOT NULL default '0',
`mount_pid_ol` tinyint(4) NOT NULL default '0',
`t3ver_oid` int(11) unsigned NOT NULL default '0',
`t3ver_id` int(11) unsigned NOT NULL default '0',
`t3ver_label` varchar(30) NOT NULL default '',
`editlock` tinyint(4) unsigned NOT NULL default '0',
`l18n_cfg` tinyint(4) NOT NULL default '0',
`fe_login_mode` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `alias` (`alias`),
KEY `t3ver_oid` (`t3ver_oid`)
) TYPE=MyISAM;
CREATE TABLE `pages_language_overlay` (
`uid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`sys_language_uid` int(11) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`hidden` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`subtitle` tinytext NOT NULL,
`media` tinyblob NOT NULL,
`keywords` text NOT NULL,
`description` text NOT NULL,
`abstract` text NOT NULL,
`author` tinytext NOT NULL,
`author_email` varchar(80) NOT NULL default '',
`tx_impexp_origuid` int(11) NOT NULL default '0',
`nav_title` tinytext NOT NULL,
`t3ver_oid` int(11) unsigned NOT NULL default '0',
`t3ver_id` int(11) unsigned NOT NULL default '0',
`t3ver_label` varchar(30) NOT NULL default '',
`l18n_diffsource` mediumblob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `t3ver_oid` (`t3ver_oid`)
) TYPE=MyISAM;
CREATE TABLE `static_template` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`include_static` tinyblob NOT NULL,
`constants` blob NOT NULL,
`config` blob NOT NULL,
`description` text NOT NULL,
`editorcfg` blob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `static_tsconfig_help` (
`uid` int(11) NOT NULL auto_increment,
`guide` int(11) NOT NULL default '0',
`md5hash` varchar(32) NOT NULL default '',
`description` text NOT NULL,
`obj_string` tinytext NOT NULL,
`appdata` blob NOT NULL,
`title` tinytext NOT NULL,
PRIMARY KEY (`uid`),
KEY `guide` (`guide`,`md5hash`)
) TYPE=MyISAM;
CREATE TABLE `sys_be_shortcuts` (
`uid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`module_name` tinytext NOT NULL,
`url` text NOT NULL,
`description` tinytext NOT NULL,
`sorting` int(11) NOT NULL default '0',
`sc_group` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `event` (`userid`)
) TYPE=MyISAM;
CREATE TABLE `sys_domain` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`hidden` tinyint(4) unsigned NOT NULL default '0',
`domainName` varchar(80) NOT NULL default '',
`redirectTo` varchar(120) NOT NULL default '',
`sorting` int(10) unsigned NOT NULL default '0',
`prepend_params` int(10) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_filemounts` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`title` varchar(30) NOT NULL default '',
`path` varchar(120) NOT NULL default '',
`base` tinyint(4) unsigned NOT NULL default '0',
`hidden` tinyint(3) unsigned NOT NULL default '0',
`deleted` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_history` (
`uid` int(11) unsigned NOT NULL auto_increment,
`sys_log_uid` int(11) NOT NULL default '0',
`history_data` mediumblob NOT NULL,
`fieldlist` blob NOT NULL,
`recuid` int(11) NOT NULL default '0',
`tablename` varchar(40) NOT NULL default '',
`tstamp` int(11) NOT NULL default '0',
`history_files` mediumblob NOT NULL,
`snapshot` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `recordident` (`tablename`,`recuid`),
KEY `sys_log_uid` (`sys_log_uid`)
) TYPE=MyISAM;
CREATE TABLE `sys_language` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`hidden` tinyint(4) unsigned NOT NULL default '0',
`title` varchar(80) NOT NULL default '',
`static_lang_isocode` int(11) unsigned NOT NULL default '0',
`flag` varchar(20) NOT NULL default '',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_lockedrecords` (
`uid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`record_table` varchar(40) NOT NULL default '',
`record_uid` int(11) NOT NULL default '0',
`record_pid` int(11) NOT NULL default '0',
`username` varchar(20) NOT NULL default '',
PRIMARY KEY (`uid`),
KEY `event` (`userid`,`tstamp`)
) TYPE=MyISAM;
CREATE TABLE `sys_log` (
`uid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`action` tinyint(4) unsigned NOT NULL default '0',
`recuid` int(11) unsigned NOT NULL default '0',
`tablename` varchar(40) NOT NULL default '',
`recpid` int(11) NOT NULL default '0',
`error` tinyint(4) unsigned NOT NULL default '0',
`details` tinytext NOT NULL,
`tstamp` int(11) unsigned NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '0',
`details_nr` tinyint(3) unsigned NOT NULL default '0',
`IP` varchar(39) NOT NULL default '',
`log_data` tinyblob NOT NULL,
`event_pid` int(11) NOT NULL default '-1',
`NEWid` varchar(20) NOT NULL default '',
PRIMARY KEY (`uid`),
KEY `event` (`userid`,`event_pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_note` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser` int(11) unsigned NOT NULL default '0',
`author` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`subject` tinytext NOT NULL,
`message` text NOT NULL,
`personal` tinyint(3) unsigned NOT NULL default '0',
`category` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_notepad` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`note` text NOT NULL,
`crdate` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `cruser_id` (`cruser_id`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_template` (
`uid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`sorting` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`sitetitle` tinytext NOT NULL,
`hidden` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`root` tinyint(4) unsigned NOT NULL default '0',
`clear` tinyint(4) unsigned NOT NULL default '0',
`include_static` tinyblob NOT NULL,
`include_static_file` blob NOT NULL,
`constants` blob NOT NULL,
`config` blob NOT NULL,
`editorcfg` blob NOT NULL,
`resources` blob NOT NULL,
`nextLevel` varchar(5) NOT NULL default '',
`description` text NOT NULL,
`basedOn` tinyblob NOT NULL,
`deleted` tinyint(3) unsigned NOT NULL default '0',
`includeStaticAfterBasedOn` tinyint(4) unsigned NOT NULL default '0',
`static_file_mode` tinyint(4) unsigned NOT NULL default '0',
`tx_impexp_origuid` int(11) NOT NULL default '0',
`t3ver_oid` int(11) unsigned NOT NULL default '0',
`t3ver_id` int(11) unsigned NOT NULL default '0',
`t3ver_label` varchar(30) NOT NULL default '',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `t3ver_oid` (`t3ver_oid`)
) TYPE=MyISAM;
CREATE TABLE `sys_todos` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`deleted` tinyint(4) unsigned NOT NULL default '0',
`type` varchar(11) NOT NULL default '',
`deadline` int(11) unsigned NOT NULL default '0',
`finished` tinyint(3) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `cruser_id` (`cruser_id`)
) TYPE=MyISAM;
CREATE TABLE `sys_todos_users_mm` (
`uid_local` int(11) unsigned NOT NULL default '0',
`uid_foreign` int(11) NOT NULL default '0',
`status` tinyint(4) NOT NULL default '0',
`status_log` mediumblob NOT NULL,
`is_read` tinyint(4) NOT NULL default '0',
`tstamp` int(11) NOT NULL default '0',
`mm_uid` int(11) NOT NULL auto_increment,
`deleted` tinyint(4) NOT NULL default '0',
`rec_reference` varchar(50) NOT NULL default '',
`finalized` tinyint(4) NOT NULL default '0',
`finished_instance` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`mm_uid`),
KEY `uid_local` (`uid_local`),
KEY `uid_foreign` (`uid_foreign`)
) TYPE=MyISAM;
CREATE TABLE `sys_workflows` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`description` text NOT NULL,
`tablename` varchar(60) NOT NULL default '',
`working_area` int(11) NOT NULL default '0',
`allowed_groups` int(11) NOT NULL default '0',
`review_users` int(11) NOT NULL default '0',
`final_target` int(11) NOT NULL default '0',
`final_unhide` tinyint(4) NOT NULL default '0',
`final_perms_userid` int(11) NOT NULL default '0',
`final_perms_groupid` int(11) NOT NULL default '0',
`final_perms_user` tinyint(11) NOT NULL default '0',
`final_perms_group` tinyint(11) NOT NULL default '0',
`final_perms_everybody` tinyint(11) NOT NULL default '0',
`hidden` tinyint(4) NOT NULL default '0',
`final_set_perms` tinyint(4) NOT NULL default '0',
`target_groups` tinyblob NOT NULL,
`publishing_users` int(11) NOT NULL default '0',
`existing_record` blob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `sys_workflows_algr_mm` (
`uid_local` int(11) unsigned NOT NULL default '0',
`uid_foreign` int(11) unsigned NOT NULL default '0',
`sorting` int(11) unsigned NOT NULL default '0',
KEY `uid_local` (`uid_local`),
KEY `uid_foreign` (`uid_foreign`)
) TYPE=MyISAM;
CREATE TABLE `sys_workflows_pubuser_mm` (
`uid_local` int(11) unsigned NOT NULL default '0',
`uid_foreign` int(11) unsigned NOT NULL default '0',
`sorting` int(11) unsigned NOT NULL default '0',
KEY `uid_local` (`uid_local`),
KEY `uid_foreign` (`uid_foreign`)
) TYPE=MyISAM;
CREATE TABLE `sys_workflows_rvuser_mm` (
`uid_local` int(11) unsigned NOT NULL default '0',
`uid_foreign` int(11) unsigned NOT NULL default '0',
`sorting` int(11) unsigned NOT NULL default '0',
KEY `uid_local` (`uid_local`),
KEY `uid_foreign` (`uid_foreign`)
) TYPE=MyISAM;
CREATE TABLE `tt_board` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`author` varchar(80) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`subject` tinytext NOT NULL,
`message` text NOT NULL,
`hidden` tinyint(4) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL default '0',
`notify_me` tinyint(3) unsigned NOT NULL default '0',
`doublePostCheck` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `parent_select` (`pid`,`parent`)
) TYPE=MyISAM;
CREATE TABLE `tt_content` (
`uid` int(11) NOT NULL auto_increment,
`pid` int(11) NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`hidden` tinyint(4) unsigned NOT NULL default '0',
`sorting` int(11) unsigned NOT NULL default '0',
`CType` varchar(30) NOT NULL default '',
`header` tinytext NOT NULL,
`header_position` varchar(6) NOT NULL default '',
`bodytext` mediumtext NOT NULL,
`image` blob NOT NULL,
`imagewidth` mediumint(11) unsigned NOT NULL default '0',
`imageorient` tinyint(4) unsigned NOT NULL default '0',
`imagecaption` text NOT NULL,
`imagecols` tinyint(4) unsigned NOT NULL default '0',
`imageborder` tinyint(4) unsigned NOT NULL default '0',
`media` blob NOT NULL,
`layout` tinyint(3) unsigned NOT NULL default '0',
`deleted` tinyint(4) unsigned NOT NULL default '0',
`cols` tinyint(3) unsigned NOT NULL default '0',
`records` blob NOT NULL,
`pages` tinyblob NOT NULL,
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`colPos` tinyint(3) unsigned NOT NULL default '0',
`subheader` tinytext NOT NULL,
`spaceBefore` tinyint(4) unsigned NOT NULL default '0',
`spaceAfter` tinyint(4) unsigned NOT NULL default '0',
`fe_group` int(11) NOT NULL default '0',
`header_link` tinytext NOT NULL,
`imagecaption_position` varchar(6) NOT NULL default '',
`image_link` tinytext NOT NULL,
`image_zoom` tinyint(3) unsigned NOT NULL default '0',
`image_noRows` tinyint(3) unsigned NOT NULL default '0',
`image_effects` tinyint(3) unsigned NOT NULL default '0',
`image_compression` tinyint(3) unsigned NOT NULL default '0',
`header_layout` varchar(30) NOT NULL default '0',
`text_align` varchar(6) NOT NULL default '',
`text_face` tinyint(3) unsigned NOT NULL default '0',
`text_size` tinyint(3) unsigned NOT NULL default '0',
`text_color` tinyint(3) unsigned NOT NULL default '0',
`text_properties` tinyint(3) unsigned NOT NULL default '0',
`menu_type` varchar(30) NOT NULL default '0',
`list_type` varchar(36) NOT NULL default '0',
`table_border` tinyint(3) unsigned NOT NULL default '0',
`table_cellspacing` tinyint(3) unsigned NOT NULL default '0',
`table_cellpadding` tinyint(3) unsigned NOT NULL default '0',
`table_bgColor` tinyint(3) unsigned NOT NULL default '0',
`select_key` varchar(80) NOT NULL default '',
`sectionIndex` tinyint(3) unsigned NOT NULL default '0',
`linkToTop` tinyint(3) unsigned NOT NULL default '0',
`filelink_size` tinyint(3) unsigned NOT NULL default '0',
`section_frame` tinyint(3) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`splash_layout` varchar(30) NOT NULL default '0',
`multimedia` tinyblob NOT NULL,
`image_frames` tinyint(3) unsigned NOT NULL default '0',
`recursive` tinyint(3) unsigned NOT NULL default '0',
`imageheight` mediumint(8-) unsigned NOT NULL default '0',
`module_sys_dmail_category` int(10) unsigned NOT NULL default '0',
`rte_enabled` tinyint(4) NOT NULL default '0',
`sys_language_uid` int(11) NOT NULL default '0',
`tx_impexp_origuid` int(11) NOT NULL default '0',
`tx_mininews_frontpage_list` int(11) unsigned NOT NULL default '0',
`pi_flexform` mediumtext NOT NULL,
`t3ver_oid` int(11) unsigned NOT NULL default '0',
`t3ver_id` int(11) unsigned NOT NULL default '0',
`t3ver_label` varchar(30) NOT NULL default '',
`l18n_parent` int(11) NOT NULL default '0',
`l18n_diffsource` mediumblob NOT NULL,
PRIMARY KEY (`uid`),
KEY `parent` (`pid`),
KEY `t3ver_oid` (`t3ver_oid`)
) TYPE=MyISAM;
CREATE TABLE `tt_guest` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`title` tinytext NOT NULL,
`note` text NOT NULL,
`cr_name` varchar(80) NOT NULL default '',
`cr_email` varchar(80) NOT NULL default '',
`hidden` tinyint(4) unsigned NOT NULL default '0',
`deleted` tinyint(3) unsigned NOT NULL default '0',
`www` tinytext NOT NULL,
`doublePostCheck` int(11) NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;
CREATE TABLE `tx_impexp_presets` (
`uid` int(11) NOT NULL auto_increment,
`user_uid` int(11) NOT NULL default '0',
`title` tinytext NOT NULL,
`public` tinyint(3) NOT NULL default '0',
`item_uid` int(11) NOT NULL default '0',
`preset_data` blob NOT NULL,
PRIMARY KEY (`uid`),
KEY `lookup` (`item_uid`)
) TYPE=MyISAM;
CREATE TABLE `tx_mininews_news` (
`uid` int(11) unsigned NOT NULL auto_increment,
`pid` int(11) unsigned NOT NULL default '0',
`tstamp` int(11) unsigned NOT NULL default '0',
`crdate` int(11) unsigned NOT NULL default '0',
`cruser_id` int(11) unsigned NOT NULL default '0',
`deleted` tinyint(4) unsigned NOT NULL default '0',
`hidden` tinyint(4) unsigned NOT NULL default '0',
`starttime` int(11) unsigned NOT NULL default '0',
`endtime` int(11) unsigned NOT NULL default '0',
`fe_group` int(11) NOT NULL default '0',
`datetime` int(11) NOT NULL default '0',
`title` tinytext NOT NULL,
`teaser` text NOT NULL,
`full_text` text NOT NULL,
`front_page` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`),
KEY `parent` (`pid`)
) TYPE=MyISAM;