Dach dem fünften mal anstossen kam ich ein Stück weiter:
Code:
CREATE INDEX tstamp ON tl_article (tstamp)
CREATE INDEX tstamp ON tl_calendar (tstamp)
ALTER TABLE tl_calendar_events ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL, CHANGE startTime startTime BIGINT DEFAULT NULL, CHANGE endTime endTime BIGINT DEFAULT NULL, CHANGE startDate startDate BIGINT DEFAULT NULL, CHANGE endDate endDate BIGINT DEFAULT NULL
CREATE INDEX tstamp ON tl_calendar_events (tstamp)
CREATE INDEX tstamp ON tl_calendar_feed (tstamp)
CREATE INDEX tstamp ON tl_comments_notify (tstamp)
DROP INDEX pid_ptable_invisible_start_stop ON tl_content
ALTER TABLE tl_content ADD closeSections TINYINT(1) DEFAULT 0 NOT NULL, ADD sectionHeadline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
CREATE INDEX tstamp ON tl_content (tstamp)
CREATE INDEX ptable_pid_invisible_start_stop ON tl_content (ptable, pid, invisible, start, stop)
CREATE INDEX tstamp ON tl_faq (tstamp)
ALTER TABLE tl_faq_category CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL, CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
CREATE INDEX tstamp ON tl_faq_category (tstamp)
CREATE INDEX jumpto ON tl_faq_category (jumpto)
CREATE INDEX tstamp ON tl_favorites (tstamp)
CREATE INDEX tstamp ON tl_files (tstamp)
CREATE INDEX tstamp ON tl_form (tstamp)
CREATE INDEX tstamp ON tl_form_field (tstamp)
ALTER TABLE tl_image_size ADD imageQuality INT DEFAULT NULL, ADD preserveMetadata VARCHAR(12) DEFAULT 'default' NOT NULL, ADD preserveMetadataFields BLOB DEFAULT NULL
CREATE INDEX tstamp ON tl_image_size (tstamp)
CREATE INDEX tstamp ON tl_image_size_item (tstamp)
CREATE INDEX tstamp ON tl_layout (tstamp)
CREATE INDEX tstamp ON tl_log (tstamp)
CREATE INDEX tstamp ON tl_member (tstamp)
CREATE INDEX tstamp ON tl_member_group (tstamp)
ALTER TABLE tl_module ADD news_keepCanonical TINYINT(1) DEFAULT 0 NOT NULL, ADD cal_keepCanonical TINYINT(1) DEFAULT 0 NOT NULL, ADD pwResetPage INT UNSIGNED DEFAULT 0 NOT NULL
CREATE INDEX tstamp ON tl_module (tstamp)
ALTER TABLE tl_news ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
CREATE INDEX tstamp ON tl_news (tstamp)
ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL
CREATE INDEX tstamp ON tl_news_archive (tstamp)
CREATE INDEX jumpto ON tl_news_archive (jumpto)
ALTER TABLE tl_newsletter ADD preheader VARCHAR(255) DEFAULT '' NOT NULL
CREATE INDEX tstamp ON tl_newsletter (tstamp)
CREATE INDEX tstamp ON tl_newsletter_channel (tstamp)
CREATE INDEX tstamp ON tl_newsletter_recipients (tstamp)
CREATE INDEX tstamp ON tl_opt_in (tstamp)
CREATE INDEX pid ON tl_opt_in_related (pid)
DROP INDEX type_dns ON tl_page
ALTER TABLE tl_page ADD enableCsp TINYINT(1) DEFAULT 0 NOT NULL, ADD csp LONGTEXT DEFAULT NULL, ADD cspReportOnly TINYINT(1) DEFAULT 0 NOT NULL, ADD cspReportLog TINYINT(1) DEFAULT 0 NOT NULL
CREATE INDEX tstamp ON tl_page (tstamp)
CREATE INDEX type_dns_fallback_published_start_stop ON tl_page (type, dns, fallback, published, start, stop)
CREATE INDEX tstamp ON tl_preview_link (tstamp)
DROP INDEX checksum_pid ON tl_search
CREATE INDEX tstamp ON tl_search (tstamp)
CREATE UNIQUE INDEX pid_checksum ON tl_search (pid, checksum)
CREATE INDEX tstamp ON tl_theme (tstamp)
CREATE INDEX pid ON tl_undo (pid)
CREATE INDEX tstamp ON tl_undo (tstamp)
ALTER TABLE tl_user ADD frontendModules BLOB DEFAULT NULL
CREATE INDEX tstamp ON tl_user (tstamp)
CREATE INDEX tstamp ON tl_user_group (tstamp)
CREATE INDEX tstamp ON tl_version (tstamp)
Danach noch weitere zweimal ...
Jetzt ist die Datenbank aktuell :-)
Hat das mit dem Manager oder mit dem Hoster (Hostpoint) zu tun?
Cyon macht da auch keine bessere Figur.