InstallTool doesn't update database. Lot of queries pending...

Hello everyone,

One of my prod websites under Contao 4.4 seems to work correctly but InstallTool displays a long list of database updates pending (see below). When I click on Update Database, I get a Contao error page and so... no database update...

I tried to to update manually in phpmyadmin SQL but I get errors too. For example

Code:

---

ALTER TABLE tl_calendar CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL

---

returns

Code:

---

#1075 - Un seul champ automatique est permis et il doit être indexé

---

(Sorry, french version.)

What is the solution ?

Thanks for your help.

Here is the list :

Code:

---

ALTER TABLE tl_article CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_events CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_feed CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments_notify CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_content CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_cron CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_data CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_dlh_geocode CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq_category CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_files CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_form CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_form_field CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_hofff_language_relations_group CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_image_size CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_image_size_item CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_category CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_category_language CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_service CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ks_cc_service_language CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_layout CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_lead CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_lead_data CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_lead_export CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_log CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_member CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_member_group CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ALTER TABLE tl_article CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_events CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_calendar_feed CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_comments_notify CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_content CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_cron CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_data CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_datamaps_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_dlh_geocode CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_elements CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_faq_category CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_files CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULLmetamodel CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_attribute CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dca CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dca_combine CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dca_sortgroup CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dcasetting CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_dcasetting_condition CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_filter CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_filtersetting CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_perimetersearch CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_rendersetting CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_rendersettings CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_searchable_pages CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_tabletext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_tag_relation CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedcheckbox CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedlongblob CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedlongtext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedtabletext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_metamodel_translatedtext CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_module CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_news CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_news_archive CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_news_feed CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter_blacklist CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter_channel CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_newsletter_recipients CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_page CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_pattern CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_search CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_search_index CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_session CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_style CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_style_sheet CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_synccto_clients CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL

CREATE OR REPLACE VIEW hofff_language_relations_news_item AS
SELECT
  root_page.hofff_language_relations_group_id AS group_id,
  root_page.id AS root_page_id,
  page.id AS page_id,
  news.id AS item_id
FROM
  tl_news AS news
  JOIN tl_news_archive AS news_archive ON news_archive.id = news.pid
  JOIN tl_page AS page ON page.id = news_archive.jumpTo
  JOIN tl_page AS root_page ON root_page.id = page.hofff_root_page_id

ALTER TABLE tl_theme CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_undo CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_user CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_user_group CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_version CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_ctocom_cache CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
ALTER TABLE tl_synccto_stats CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL

CREATE OR REPLACE VIEW hofff_language_relations_news_item AS
SELECT
  root_page.hofff_language_relations_group_id AS group_id,
  root_page.id AS root_page_id,
  page.id AS page_id,
  news.id AS item_id
FROM
  tl_news AS news
  JOIN tl_news_archive AS news_archive ON news_archive.id = news.pid
  JOIN tl_page AS page ON page.id = news_archive.jumpTo
  JOIN tl_page AS root_page ON root_page.id = page.hofff_root_page_id

CREATE OR REPLACE VIEW hofff_language_relations_news_aggregate AS
SELECT
  archive.id AS aggregate_id,
  CONCAT('a', archive.id) AS tree_root_id,
  root_page.id AS root_page_id,
  grp.id AS group_id,
  grp.title AS group_title,
  root_page.language AS language
FROM
  tl_news_archive AS archive
  JOIN tl_page AS page ON page.id = archive.jumpTo
  JOIN tl_page AS root_page ON root_page.id = page.hofff_root_page_id
  JOIN tl_hofff_language_relations_group AS grp ON grp.id = root_page.hofff_language_relations_group_id

ALTER TABLE tl_article ADD PRIMARY KEY (id)

CREATE INDEX alias ON tl_article (alias)
CREATE INDEX pid_start_stop_published_sorting ON tl_article (
  pid, start, stop, published, sorting)

ALTER TABLE tl_calendar ADD PRIMARY KEY (id)
ALTER TABLE tl_calendar_events ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_calendar_events (alias)
CREATE INDEX pid_start_stop_published ON tl_calendar_events (pid, start, stop, published)
ALTER TABLE tl_calendar_feed ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_calendar_feed (alias)
ALTER TABLE tl_comments ADD PRIMARY KEY (id)
CREATE INDEX published ON tl_comments (published)
CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
ALTER TABLE tl_comments_notify ADD PRIMARY KEY (id)
CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
CREATE INDEX source_parent_tokenconfirm ON tl_comments_notify (source, parent, tokenconfirm)
ALTER TABLE tl_content ADD PRIMARY KEY (id)
CREATE INDEX pid_ptable_invisible_sorting ON tl_content (pid, ptable, invisible, sorting)
ALTER TABLE tl_cron ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX name ON tl_cron (name)
ALTER TABLE tl_data ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_data (pid)
CREATE INDEX pid_parent ON tl_data (pid, parent)
CREATE INDEX pid_pattern_parent ON tl_data (pid, pattern, parent)
ALTER TABLE tl_datamaps ADD PRIMARY KEY (id)
ALTER TABLE tl_datamaps_elements ADD PRIMARY KEY (id)
ALTER TABLE tl_dlh_geocode ADD PRIMARY KEY (id)
CREATE INDEX address ON tl_dlh_geocode (address)
CREATE INDEX address_language_region ON tl_dlh_geocode (address, language, region)
ALTER TABLE tl_elements ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_elements (pid)
CREATE INDEX alias ON tl_elements (alias)
CREATE INDEX pid_invisible_sorting ON tl_elements (pid, invisible, sorting)
ALTER TABLE tl_faq ADD PRIMARY KEY (id)
CREATE INDEX pid_published_sorting ON tl_faq (pid, published, sorting)
ALTER TABLE tl_faq_category ADD PRIMARY KEY (id)
ALTER TABLE tl_files ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_files (pid)
CREATE UNIQUE INDEX uuid ON tl_files (uuid)
CREATE INDEX path ON tl_files (path(333))
CREATE INDEX extension ON tl_files (extension)
ALTER TABLE tl_form ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_form (alias)
CREATE INDEX leadenabled ON tl_form (leadenabled)
CREATE INDEX leadmaster ON tl_form (leadmaster)
CREATE INDEX leadenabled_leadmaster ON tl_form (leadenabled, leadmaster)
ALTER TABLE tl_form_field ADD PRIMARY KEY (id)
CREATE INDEX pid_invisible_sorting ON tl_form_field (pid, invisible, sorting)
ALTER TABLE tl_hofff_language_relations_group ADD PRIMARY KEY (id)
ALTER TABLE tl_hofff_language_relations_news ADD PRIMARY KEY (item_id,related_item_id)
CREATE INDEX related_item_id ON tl_hofff_language_relations_news (related_item_id)
ALTER TABLE tl_hofff_language_relations_page ADD PRIMARY KEY (item_id,related_item_id)
CREATE INDEX related_item_id ON tl_hofff_language_relations_page (related_item_id)
ALTER TABLE tl_image_size ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_image_size (pid)
ALTER TABLE tl_image_size_item ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_image_size_item (pid)
ALTER TABLE tl_ks_cc_category ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_ks_cc_category (alias)
ALTER TABLE tl_ks_cc_category_language ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_ks_cc_category_language (pid)
CREATE INDEX language ON tl_ks_cc_category_language (language)
ALTER TABLE tl_ks_cc_service ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_ks_cc_service (alias)
ALTER TABLE tl_ks_cc_service_language ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_ks_cc_service_language (pid)
CREATE INDEX language ON tl_ks_cc_service_language (language)
ALTER TABLE tl_layout ADD PRIMARY KEY (id)
ALTER TABLE tl_lead ADD PRIMARY KEY (id)
CREATE INDEX master_id ON tl_lead (master_id)
ALTER TABLE tl_lead_data ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_lead_data (pid)
CREATE INDEX master_id ON tl_lead_data (master_id)
ALTER TABLE tl_lead_export ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_lead_export (pid)
ALTER TABLE tl_log ADD PRIMARY KEY (id)
ALTER TABLE tl_member ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX username ON tl_member (username)
CREATE INDEX email ON tl_member (email)
CREATE UNIQUE INDEX autologin ON tl_member (autologin)
CREATE INDEX activation ON tl_member (activation)
ALTER TABLE tl_member_group ADD PRIMARY KEY (id)
ALTER TABLE tl_metamodel ADD PRIMARY KEY (id)
CREATE INDEX tablename ON tl_metamodel (tablename)
ALTER TABLE tl_metamodel_attribute ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_attribute (pid)
CREATE INDEX colname ON tl_metamodel_attribute (colname)
ALTER TABLE tl_metamodel_dca ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dca (pid)
ALTER TABLE tl_metamodel_dca_combine ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dca_combine (pid)
CREATE INDEX fe_group ON tl_metamodel_dca_combine (fe_group)
CREATE INDEX be_group ON tl_metamodel_dca_combine (be_group)
ALTER TABLE tl_metamodel_dca_sortgroup ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dca_sortgroup (pid)
ALTER TABLE tl_metamodel_dcasetting ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dcasetting (pid)
ALTER TABLE tl_metamodel_dcasetting_condition ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_dcasetting_condition (pid)
ALTER TABLE tl_metamodel_filter ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_filter (pid)
ALTER TABLE tl_metamodel_filtersetting ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_filtersetting (pid)
ALTER TABLE tl_metamodel_perimetersearch ADD PRIMARY KEY (id)
ALTER TABLE tl_metamodel_rendersetting ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_rendersetting (pid)
ALTER TABLE tl_metamodel_rendersettings ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_rendersettings (pid)
ALTER TABLE tl_metamodel_searchable_pages ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_metamodel_searchable_pages (pid)
ALTER TABLE tl_metamodel_tabletext ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_row_col ON tl_metamodel_tabletext (att_id, item_id, row, col)
ALTER TABLE tl_metamodel_tag_relation ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_value_id ON tl_metamodel_tag_relation (att_id, item_id, value_id)
ALTER TABLE tl_metamodel_translatedcheckbox ADD PRIMARY KEY (id)
CREATE INDEX att_id_value_langcode_item_id ON tl_metamodel_translatedcheckbox (att_id, value, langcode, item_id)
ALTER TABLE tl_metamodel_translatedlongblob ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_langcode ON tl_metamodel_translatedlongblob (att_id, item_id, langcode)
ALTER TABLE tl_metamodel_translatedlongtext ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_langcode ON tl_metamodel_translatedlongtext (att_id, item_id, langcode)
ALTER TABLE tl_metamodel_translatedtabletext ADD PRIMARY KEY (id)
CREATE INDEX att_id_item_id_row_col_langcode ON tl_metamodel_translatedtabletext (
  att_id, item_id, row, col, langcode
)
ALTER TABLE tl_metamodel_translatedtext ADD PRIMARY KEY (id)
CREATE INDEX att_id_value_item_id_langcode ON tl_metamodel_translatedtext (att_id, value, item_id, langcode)
ALTER TABLE tl_metamodel_translatedurl ADD PRIMARY KEY (att_id,item_id,language)
CREATE INDEX att_id_language ON tl_metamodel_translatedurl (att_id, language)
ALTER TABLE tl_module ADD PRIMARY KEY (id)
ALTER TABLE tl_news ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_news (alias)
CREATE INDEX pid_start_stop_published ON tl_news (pid, start, stop, published)
ALTER TABLE tl_news_archive ADD PRIMARY KEY (id)
ALTER TABLE tl_news_feed ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_news_feed (alias)
ALTER TABLE tl_newsletter ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_newsletter (pid)
ALTER TABLE tl_newsletter_blacklist ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX pid_hash ON tl_newsletter_blacklist (pid, hash)
ALTER TABLE tl_newsletter_channel ADD PRIMARY KEY (id)
ALTER TABLE tl_newsletter_recipients ADD PRIMARY KEY (id)
CREATE INDEX email ON tl_newsletter_recipients (email)
ALTER TABLE tl_page ADD PRIMARY KEY (id)
CREATE INDEX alias ON tl_page (alias)
CREATE INDEX pid_type_start_stop_published ON tl_page (pid, type, start, stop, published)
CREATE INDEX hofff_root_page_id ON tl_page (hofff_root_page_id)
CREATE INDEX hofff_language_relations_group_id ON tl_page (
  hofff_language_relations_group_id
)
CREATE INDEX languagemain ON tl_page (languagemain)
ALTER TABLE tl_pattern ADD PRIMARY KEY (id)
CREATE INDEX pid_ptable_sorting ON tl_pattern (pid, ptable, sorting)
CREATE INDEX pid_ptable_invisible_sorting ON tl_pattern (pid, ptable, invisible, sorting)
CREATE INDEX pid_ptable_suboption_invisible_sorting ON tl_pattern (
  pid, ptable, suboption, invisible,
  sorting
)
ALTER TABLE tl_search ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX url ON tl_search (url)
CREATE UNIQUE INDEX checksum_pid ON tl_search (checksum, pid)
ALTER TABLE tl_search_index ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_search_index (pid)
CREATE INDEX word ON tl_search_index (word)
ALTER TABLE tl_session ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_session (pid)
CREATE UNIQUE INDEX hash ON tl_session (hash)
ALTER TABLE tl_style ADD PRIMARY KEY (id)
CREATE INDEX pid ON tl_style (pid)
ALTER TABLE tl_style_sheet ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX name ON tl_style_sheet (name)
ALTER TABLE tl_synccto_clients ADD PRIMARY KEY (id)
ALTER TABLE tl_theme ADD PRIMARY KEY (id)
ALTER TABLE tl_undo ADD PRIMARY KEY (id)
ALTER TABLE tl_user ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX username ON tl_user (username)
CREATE INDEX email ON tl_user (email)
ALTER TABLE tl_user_group ADD PRIMARY KEY (id)
ALTER TABLE tl_version ADD PRIMARY KEY (id)
CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
CREATE INDEX userid ON tl_version (userid)
ALTER TABLE tl_ctocom_cache ADD PRIMARY KEY (id)
CREATE INDEX uid ON tl_ctocom_cache (uid)
ALTER TABLE tl_synccto_stats ADD PRIMARY KEY (id)

DROP TABLE tl_newsletter_recipients_backup

---