Viele! :-D
Code:
Tabellen ändern
Alle auswählen
ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX leadmaster ON tl_form
DROP INDEX alias ON tl_form
DROP INDEX leadenabled ON tl_form
DROP INDEX leadenabled_leadmaster ON tl_form
ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid_invisible ON tl_form_field
ALTER TABLE tl_form_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_image_size
ALTER TABLE tl_image_size CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_image_size_item
ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX master_id ON tl_lead
ALTER TABLE tl_lead CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_lead_data
DROP INDEX master_id ON tl_lead_data
ALTER TABLE tl_lead_data CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_lead_export
ALTER TABLE tl_lead_export CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX login_disable_start_stop ON tl_member
DROP INDEX username ON tl_member
DROP INDEX email ON tl_member
ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX disable_start_stop ON tl_member_group
ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX queue_croninterval ON tl_nc_gateway
ALTER TABLE tl_nc_gateway CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_nc_language
DROP INDEX language ON tl_nc_language
ALTER TABLE tl_nc_language CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_nc_message
ALTER TABLE tl_nc_message CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_nc_notification CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX targetgateway ON tl_nc_queue
DROP INDEX message ON tl_nc_queue
DROP INDEX sourcequeue ON tl_nc_queue
ALTER TABLE tl_nc_queue CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX alias ON tl_news
DROP INDEX pid_published_featured_start_stop ON tl_news
ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_news_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX alias ON tl_news_feed
ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_newsletter
ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid_hash ON tl_newsletter_deny_list
ALTER TABLE tl_newsletter_deny_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX active ON tl_newsletter_recipients
DROP INDEX email ON tl_newsletter_recipients
DROP INDEX pid_email ON tl_newsletter_recipients
ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_om_backend_element_classes CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_om_backend_links_main CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_om_backend_links_top CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_om_backend_sysinfo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX token ON tl_opt_in
DROP INDEX removeon ON tl_opt_in
ALTER TABLE tl_opt_in CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX reltable_relid ON tl_opt_in_related
ALTER TABLE tl_opt_in_related CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX type_dns ON tl_page
DROP INDEX pid_published_type_start_stop ON tl_page
DROP INDEX alias ON tl_page
ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX id_published_expiresat ON tl_preview_link
ALTER TABLE tl_preview_link CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX timeslotid ON tl_resource_booking
DROP INDEX pid_member_starttime_endtime ON tl_resource_booking
ALTER TABLE tl_resource_booking CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX published_pid ON tl_resource_booking_resource
ALTER TABLE tl_resource_booking_resource CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_resource_booking_resource_type CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_resource_booking_time_slot
ALTER TABLE tl_resource_booking_time_slot CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_resource_booking_time_slot_type CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_rocksolid_slide
ALTER TABLE tl_rocksolid_slide CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_rocksolid_slider CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX url ON tl_search
DROP INDEX checksum_pid ON tl_search
ALTER TABLE tl_search CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_search_index
ALTER TABLE tl_search_index CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX documentfrequency ON tl_search_term
DROP INDEX term ON tl_search_term
ALTER TABLE tl_search_term CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX pid ON tl_style
ALTER TABLE tl_style CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX name ON tl_style_sheet
ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX username ON tl_user
DROP INDEX email ON tl_user
ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DROP INDEX userid ON tl_version
DROP INDEX pid_fromtable_version ON tl_version
ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
Spalten ändern
Alle auswählen
ALTER TABLE tl_article CHANGE teaser teaser TEXT DEFAULT NULL
ALTER TABLE tl_article CHANGE keywords keywords TEXT DEFAULT NULL
ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_calendar_events CHANGE description description TEXT DEFAULT NULL
ALTER TABLE tl_calendar_events CHANGE teaser teaser TEXT DEFAULT NULL
ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_calendar_feed CHANGE description description TEXT DEFAULT NULL
ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_comments CHANGE reply reply TEXT DEFAULT NULL
ALTER TABLE tl_comments CHANGE comment comment TEXT DEFAULT NULL
ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE data data TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE markdownSource markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE vimeoOptions vimeoOptions TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE playerOptions playerOptions TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE youtubeOptions youtubeOptions TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE start start VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE guests guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortBy sortBy VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE url url TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE code code TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE html html MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE imageUrl imageUrl TEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE size size VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE text text MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_cookie CHANGE scriptConfig scriptConfig TEXT DEFAULT NULL
ALTER TABLE tl_cookie CHANGE scriptUnconfirmed scriptUnconfirmed TEXT DEFAULT NULL
ALTER TABLE tl_cookie CHANGE scriptConfirmed scriptConfirmed TEXT DEFAULT NULL
ALTER TABLE tl_cookie CHANGE blockDescription blockDescription MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_cookie CHANGE detailDescription detailDescription MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_cookie CHANGE description description MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_cookie_config CHANGE scriptConfig scriptConfig TEXT DEFAULT NULL
ALTER TABLE tl_cookie_group CHANGE description description MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_cookie_log CHANGE config config TEXT DEFAULT NULL
ALTER TABLE tl_cookiebar CHANGE infoDescription infoDescription MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_cookiebar CHANGE description description MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_db_cache CHANGE cacheValue cacheValue MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_faq CHANGE description description TEXT DEFAULT NULL
ALTER TABLE tl_faq CHANGE answer answer TEXT DEFAULT NULL
ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
DROP INDEX path ON tl_files
ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_search_term CHANGE term term VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`
ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
Spalten anlegen
Alle auswählen
CREATE INDEX job_id ON tl_crawl_queue (job_id)
CREATE INDEX uri_hash ON tl_crawl_queue (uri_hash)
CREATE INDEX processed ON tl_crawl_queue (processed)
CREATE INDEX name ON tl_cron_job (name)
CREATE INDEX series ON tl_remember_me (series)
CREATE UNIQUE INDEX value ON tl_remember_me (value)
CREATE INDEX alias ON tl_article (alias)
CREATE INDEX pid_published_incolumn_start_stop ON tl_article (
pid, published, incolumn, start, stop
)
CREATE INDEX alias ON tl_calendar_events (alias)
CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (
pid, published, featured, start, stop
)
CREATE INDEX pid ON tl_calendar_events_subscription (pid)
CREATE INDEX member ON tl_calendar_events_subscription (member)
CREATE INDEX alias ON tl_calendar_feed (alias)
CREATE INDEX published ON tl_comments (published)
CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
CREATE INDEX source_parent_active_email ON tl_comments_notify (source, parent, active, email)
CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (
pid, ptable, invisible, start, stop
)
CREATE INDEX type ON tl_content (type)
CREATE INDEX pid_published ON tl_cookie (pid, published)
CREATE INDEX published ON tl_cookie_config (published)
CREATE INDEX pid_published ON tl_cookie_group (pid, published)
CREATE INDEX cid ON tl_cookie_log (cid)
CREATE INDEX pid ON tl_dlstatdets (pid)
CREATE INDEX filename ON tl_dlstats (filename)
CREATE INDEX pid_published ON tl_faq (pid, published)
CREATE INDEX pid ON tl_files (pid)
CREATE UNIQUE INDEX uuid ON tl_files (uuid)
CREATE INDEX extension ON tl_files (extension)
CREATE INDEX path ON tl_files (
path(768)
)
Aber der FEhler passiert offenbar bei tl_files
Code:
'ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci', array(), array())
Lesezeichen