Bug #90754 » compare.txt

Daniel Siepmann, 2020-03-13 10:01

 
1
 Compares the database table and field definitions of the current database with the specifications from all loaded extensions' ext_tables.sql files. Depending on the specification, the analyzer can update, delete, and change tables and fields.
2
Remove unused fields (rename with prefix)
3

    
4
    select/deselect all
5
    DROP INDEX t3ver_oid_f068716b
6
    DROP INDEX translation_source_c9bb4567
7
    DROP INDEX parent_90041b40
8
    DROP INDEX slug_d357d1e2
9
    DROP INDEX language_identifier_8c77f4c2
10
    DROP INDEX determineSiteRoot_5c54427f
11
    CREATE TEMPORARY TABLE __temp__pages AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM "pages"
12
    DROP TABLE "pages"
13
    CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
14
    INSERT INTO "pages" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM __temp__pages
15
    DROP TABLE __temp__pages
16
    CREATE INDEX t3ver_oid_f068716b ON "pages" (t3ver_oid, t3ver_wsid)
17
    CREATE INDEX translation_source_c9bb4567 ON "pages" (l10n_source)
18
    CREATE INDEX parent_90041b40 ON "pages" (pid, deleted, hidden)
19
    CREATE INDEX slug_d357d1e2 ON "pages" (slug)
20
    CREATE INDEX language_identifier_8c77f4c2 ON "pages" (l10n_parent, sys_language_uid)
21
    CREATE INDEX determineSiteRoot_5c54427f ON "pages" (is_siteroot)
22
    CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
23
    CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_alias" VARCHAR(32) DEFAULT '' NOT NULL)
24
    DROP INDEX t3ver_oid_2afb6cbb
25
    DROP INDEX parent_8d466b11
26
    DROP INDEX fal_filelist_3fe1fc5b
27
    DROP INDEX file_a8a43bc7
28
    CREATE TEMPORARY TABLE __temp__sys_file_metadata AS SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM "sys_file_metadata"
29
    DROP TABLE "sys_file_metadata"
30
    CREATE TABLE "sys_file_metadata" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, file INTEGER DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, width INTEGER DEFAULT 0 NOT NULL, height INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, categories INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
31
    INSERT INTO "sys_file_metadata" (uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM __temp__sys_file_metadata
32
    DROP TABLE __temp__sys_file_metadata
33
    CREATE INDEX t3ver_oid_2afb6cbb ON "sys_file_metadata" (t3ver_oid, t3ver_wsid)
34
    CREATE INDEX parent_8d466b11 ON "sys_file_metadata" (pid)
35
    CREATE INDEX fal_filelist_3fe1fc5b ON "sys_file_metadata" (l10n_parent, sys_language_uid)
36
    CREATE INDEX file_a8a43bc7 ON "sys_file_metadata" (file)
37
    CREATE TABLE "sys_file_metadata" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, file INTEGER DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, width INTEGER DEFAULT 0 NOT NULL, height INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
38
    DROP INDEX t3ver_oid_08d845fb
39
    DROP INDEX parent_3efdb54b
40
    DROP INDEX combined_1_b25ed807
41
    DROP INDEX uid_foreign_84870ada
42
    DROP INDEX uid_local_6e063d86
43
    DROP INDEX deleted_ec55f9ff
44
    DROP INDEX tablenames_fieldname_2fe50272
45
    CREATE TEMPORARY TABLE __temp__sys_file_reference AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM "sys_file_reference"
46
    DROP TABLE "sys_file_reference"
47
    CREATE TABLE "sys_file_reference" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, uid_local INTEGER DEFAULT 0 NOT NULL, uid_foreign INTEGER DEFAULT 0 NOT NULL, tablenames VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, fieldname VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, sorting_foreign INTEGER DEFAULT 0 NOT NULL, table_local VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, crop VARCHAR(4000) DEFAULT '' NOT NULL COLLATE BINARY, autoplay SMALLINT DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
48
    INSERT INTO "sys_file_reference" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM __temp__sys_file_reference
49
    DROP TABLE __temp__sys_file_reference
50
    CREATE INDEX t3ver_oid_08d845fb ON "sys_file_reference" (t3ver_oid, t3ver_wsid)
51
    CREATE INDEX parent_3efdb54b ON "sys_file_reference" (pid, deleted, hidden)
52
    CREATE INDEX combined_1_b25ed807 ON "sys_file_reference" (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
53
    CREATE INDEX uid_foreign_84870ada ON "sys_file_reference" (uid_foreign)
54
    CREATE INDEX uid_local_6e063d86 ON "sys_file_reference" (uid_local)
55
    CREATE INDEX deleted_ec55f9ff ON "sys_file_reference" (deleted)
56
    CREATE INDEX tablenames_fieldname_2fe50272 ON "sys_file_reference" (tablenames, fieldname)
57
    CREATE TABLE "sys_file_reference" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, uid_local INTEGER DEFAULT 0 NOT NULL, uid_foreign INTEGER DEFAULT 0 NOT NULL, tablenames VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, fieldname VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, sorting_foreign INTEGER DEFAULT 0 NOT NULL, table_local VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, crop VARCHAR(4000) DEFAULT '' NOT NULL COLLATE BINARY, autoplay SMALLINT DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
58
    DROP INDEX t3ver_oid_d19f62d6
59
    DROP INDEX parent_cfb58add
60
    CREATE TEMPORARY TABLE __temp__sys_file_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM "sys_file_collection"
61
    DROP TABLE "sys_file_collection"
62
    CREATE TABLE "sys_file_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(30) DEFAULT 'static' NOT NULL COLLATE BINARY, files INTEGER DEFAULT 0 NOT NULL, storage INTEGER DEFAULT 0 NOT NULL, folder CLOB DEFAULT NULL COLLATE BINARY, recursive SMALLINT DEFAULT 0 NOT NULL, category INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
63
    INSERT INTO "sys_file_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM __temp__sys_file_collection
64
    DROP TABLE __temp__sys_file_collection
65
    CREATE INDEX t3ver_oid_d19f62d6 ON "sys_file_collection" (t3ver_oid, t3ver_wsid)
66
    CREATE INDEX parent_cfb58add ON "sys_file_collection" (pid, deleted, hidden)
67
    CREATE TABLE "sys_file_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(30) DEFAULT 'static' NOT NULL COLLATE BINARY, files INTEGER DEFAULT 0 NOT NULL, storage INTEGER DEFAULT 0 NOT NULL, folder CLOB DEFAULT NULL COLLATE BINARY, recursive SMALLINT DEFAULT 0 NOT NULL, category INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
68
    DROP INDEX t3ver_oid_f30873cd
69
    DROP INDEX parent_9a244dea
70
    CREATE TEMPORARY TABLE __temp__sys_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM "sys_collection"
71
    DROP TABLE "sys_collection"
72
    CREATE TABLE "sys_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(32) DEFAULT 'static' NOT NULL COLLATE BINARY, table_name CLOB DEFAULT NULL COLLATE BINARY, items INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
73
    INSERT INTO "sys_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM __temp__sys_collection
74
    DROP TABLE __temp__sys_collection
75
    CREATE INDEX t3ver_oid_f30873cd ON "sys_collection" (t3ver_oid, t3ver_wsid)
76
    CREATE INDEX parent_9a244dea ON "sys_collection" (pid, deleted, hidden)
77
    CREATE TABLE "sys_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(32) DEFAULT 'static' NOT NULL COLLATE BINARY, table_name CLOB DEFAULT NULL COLLATE BINARY, items INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
78
    DROP INDEX recordident_2_78d43f6c
79
    DROP INDEX recordident_1_e1dd6ed6
80
    CREATE TEMPORARY TABLE __temp__sys_history AS SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM "sys_history"
81
    DROP TABLE "sys_history"
82
    CREATE TABLE "sys_history" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, actiontype SMALLINT DEFAULT 0 NOT NULL, usertype VARCHAR(2) DEFAULT 'BE' NOT NULL COLLATE BINARY, userid INTEGER UNSIGNED DEFAULT NULL, originaluserid INTEGER UNSIGNED DEFAULT NULL, recuid INTEGER DEFAULT 0 NOT NULL, tablename VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, history_data CLOB DEFAULT NULL COLLATE BINARY, workspace INTEGER DEFAULT 0, correlation_id VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, "zzz_deleted_pid" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
83
    INSERT INTO "sys_history" (uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid) SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM __temp__sys_history
84
    DROP TABLE __temp__sys_history
85
    CREATE INDEX recordident_2_78d43f6c ON "sys_history" (tablename, tstamp)
86
    CREATE INDEX recordident_1_e1dd6ed6 ON "sys_history" (tablename, recuid)
87
    DROP INDEX parent_b7280232
88
    CREATE TEMPORARY TABLE __temp__sys_language AS SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM "sys_language"
89
    DROP TABLE "sys_language"
90
    CREATE TABLE "sys_language" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, title VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, flag VARCHAR(20) DEFAULT '' NOT NULL COLLATE BINARY, language_isocode VARCHAR(2) DEFAULT '' NOT NULL COLLATE BINARY, static_lang_isocode INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_static_lang_isocode" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
91
    INSERT INTO "sys_language" (uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode) SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM __temp__sys_language
92
    DROP TABLE __temp__sys_language
93
    CREATE INDEX parent_b7280232 ON "sys_language" (pid, hidden)
94
    DROP INDEX t3ver_oid_0fc5a153
95
    DROP INDEX parent_a4d3f12f
96
    DROP INDEX category_list_9214ae08
97
    DROP INDEX category_parent_f5445003
98
    CREATE TEMPORARY TABLE __temp__sys_category AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM "sys_category"
99
    DROP TABLE "sys_category"
100
    CREATE TABLE "sys_category" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB NOT NULL COLLATE BINARY, parent INTEGER DEFAULT 0 NOT NULL, items INTEGER DEFAULT 0 NOT NULL, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
101
    INSERT INTO "sys_category" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM __temp__sys_category
102
    DROP TABLE __temp__sys_category
103
    CREATE INDEX t3ver_oid_0fc5a153 ON "sys_category" (t3ver_oid, t3ver_wsid)
104
    CREATE INDEX parent_a4d3f12f ON "sys_category" (pid, deleted, hidden)
105
    CREATE INDEX category_list_9214ae08 ON "sys_category" (pid, deleted, sys_language_uid)
106
    CREATE INDEX category_parent_f5445003 ON "sys_category" (parent)
107
    CREATE TABLE "sys_category" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB NOT NULL COLLATE BINARY, parent INTEGER DEFAULT 0 NOT NULL, items INTEGER DEFAULT 0 NOT NULL, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
108
    DROP INDEX t3ver_oid_01f605d5
109
    DROP INDEX parent_a0d332a6
110
    DROP INDEX roottemplate_b05d9c09
111
    CREATE TEMPORARY TABLE __temp__sys_template AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM "sys_template"
112
    DROP TABLE "sys_template"
113
    CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
114
    INSERT INTO "sys_template" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM __temp__sys_template
115
    DROP TABLE __temp__sys_template
116
    CREATE INDEX t3ver_oid_01f605d5 ON "sys_template" (t3ver_oid, t3ver_wsid)
117
    CREATE INDEX parent_a0d332a6 ON "sys_template" (pid, deleted, hidden)
118
    CREATE INDEX roottemplate_b05d9c09 ON "sys_template" (deleted, hidden, root)
119
    CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
120
    CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_nextLevel" VARCHAR(5) DEFAULT '' NOT NULL)
121
    DROP INDEX translation_source_fcef6e2f
122
    DROP INDEX language_6f2c39a6
123
    DROP INDEX t3ver_oid_be974a6e
124
    DROP INDEX parent_8b16a914
125
    CREATE TEMPORARY TABLE __temp__tt_content AS SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM "tt_content"
126
    DROP TABLE "tt_content"
127
    CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
128
    INSERT INTO "tt_content" (uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id) SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM __temp__tt_content
129
    DROP TABLE __temp__tt_content
130
    CREATE INDEX translation_source_fcef6e2f ON "tt_content" (l10n_source)
131
    CREATE INDEX language_6f2c39a6 ON "tt_content" (l18n_parent, sys_language_uid)
132
    CREATE INDEX t3ver_oid_be974a6e ON "tt_content" (t3ver_oid, t3ver_wsid)
133
    CREATE INDEX parent_8b16a914 ON "tt_content" (pid, sorting)
134
    CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL)
135
    CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_spaceBefore" SMALLINT UNSIGNED DEFAULT 0 NOT NULL)
136
    CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_spaceAfter" SMALLINT UNSIGNED DEFAULT 0 NOT NULL)
137
    DROP INDEX t3ver_oid_8dc31fea
138
    DROP INDEX parent_30db6e61
139
    CREATE TEMPORARY TABLE __temp__backend_layout AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM "backend_layout"
140
    DROP TABLE "backend_layout"
141
    CREATE TABLE "backend_layout" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, config CLOB NOT NULL COLLATE BINARY, icon CLOB DEFAULT NULL COLLATE BINARY, "zzz_deleted_t3ver_id" INTEGER UNSIGNED DEFAULT 0 NOT NULL)
142
    INSERT INTO "backend_layout" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM __temp__backend_layout
143
    DROP TABLE __temp__backend_layout
144
    CREATE INDEX t3ver_oid_8dc31fea ON "backend_layout" (t3ver_oid, t3ver_wsid)
145
    CREATE INDEX parent_30db6e61 ON "backend_layout" (pid, deleted, hidden)
146
    CREATE TABLE "backend_layout" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, config CLOB NOT NULL COLLATE BINARY, icon CLOB DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, "zzz_deleted_t3ver_label" VARCHAR(255) DEFAULT '' NOT NULL) 
147

    
148
Drop fields (really!)
149

    
150
    select/deselect all
151
    DROP INDEX t3ver_oid_f068716b
152
    DROP INDEX translation_source_c9bb4567
153
    DROP INDEX parent_90041b40
154
    DROP INDEX slug_d357d1e2
155
    DROP INDEX language_identifier_8c77f4c2
156
    DROP INDEX determineSiteRoot_5c54427f
157
    CREATE TEMPORARY TABLE __temp__pages AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM "pages"
158
    DROP TABLE "pages"
159
    CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, TSconfig CLOB DEFAULT NULL COLLATE BINARY, is_siteroot SMALLINT DEFAULT 0 NOT NULL, php_tree_stop SMALLINT DEFAULT 0 NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, lastUpdated INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL COLLATE BINARY, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, newUntil INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, abstract CLOB DEFAULT NULL COLLATE BINARY, module VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, author VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, author_email VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, nav_hide SMALLINT DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, alias VARCHAR(32) DEFAULT '' NOT NULL COLLATE BINARY, l18n_cfg SMALLINT DEFAULT 0 NOT NULL, fe_login_mode SMALLINT DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, tsconfig_includes CLOB DEFAULT NULL COLLATE BINARY, legacy_overlay_uid INTEGER UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, no_index SMALLINT DEFAULT 0 NOT NULL, no_follow SMALLINT DEFAULT 0 NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, og_description CLOB DEFAULT NULL COLLATE BINARY, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, twitter_description CLOB DEFAULT NULL COLLATE BINARY, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, canonical_link VARCHAR(2048) DEFAULT '' NOT NULL COLLATE BINARY, sitemap_priority NUMERIC(1, 1) DEFAULT '0.5' NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL COLLATE BINARY, twitter_card VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
160
    INSERT INTO "pages" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, title, slug, doktype, TSconfig, is_siteroot, php_tree_stop, url, shortcut, shortcut_mode, subtitle, layout, target, media, lastUpdated, keywords, cache_timeout, cache_tags, newUntil, description, no_search, SYS_LASTCHANGED, abstract, module, extendToSubpages, author, author_email, nav_title, nav_hide, content_from_pid, mount_pid, mount_pid_ol, alias, l18n_cfg, fe_login_mode, backend_layout, backend_layout_next_level, tsconfig_includes, legacy_overlay_uid, categories, seo_title, no_index, no_follow, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, canonical_link, sitemap_priority, sitemap_changefreq, twitter_card, zzz_deleted_t3ver_id FROM __temp__pages
161
    DROP TABLE __temp__pages
162
    CREATE INDEX t3ver_oid_f068716b ON "pages" (t3ver_oid, t3ver_wsid)
163
    CREATE INDEX translation_source_c9bb4567 ON "pages" (l10n_source)
164
    CREATE INDEX parent_90041b40 ON "pages" (pid, deleted, hidden)
165
    CREATE INDEX slug_d357d1e2 ON "pages" (slug)
166
    CREATE INDEX language_identifier_8c77f4c2 ON "pages" (l10n_parent, sys_language_uid)
167
    CREATE INDEX determineSiteRoot_5c54427f ON "pages" (is_siteroot)
168
    DROP INDEX t3ver_oid_2afb6cbb
169
    DROP INDEX parent_8d466b11
170
    DROP INDEX fal_filelist_3fe1fc5b
171
    DROP INDEX file_a8a43bc7
172
    CREATE TEMPORARY TABLE __temp__sys_file_metadata AS SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM "sys_file_metadata"
173
    DROP TABLE "sys_file_metadata"
174
    CREATE TABLE "sys_file_metadata" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, file INTEGER DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, width INTEGER DEFAULT 0 NOT NULL, height INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
175
    INSERT INTO "sys_file_metadata" (uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, file, title, width, height, description, alternative, categories, zzz_deleted_t3ver_id FROM __temp__sys_file_metadata
176
    DROP TABLE __temp__sys_file_metadata
177
    CREATE INDEX t3ver_oid_2afb6cbb ON "sys_file_metadata" (t3ver_oid, t3ver_wsid)
178
    CREATE INDEX parent_8d466b11 ON "sys_file_metadata" (pid)
179
    CREATE INDEX fal_filelist_3fe1fc5b ON "sys_file_metadata" (l10n_parent, sys_language_uid)
180
    CREATE INDEX file_a8a43bc7 ON "sys_file_metadata" (file)
181
    DROP INDEX t3ver_oid_08d845fb
182
    DROP INDEX parent_3efdb54b
183
    DROP INDEX combined_1_b25ed807
184
    DROP INDEX uid_foreign_84870ada
185
    DROP INDEX uid_local_6e063d86
186
    DROP INDEX deleted_ec55f9ff
187
    DROP INDEX tablenames_fieldname_2fe50272
188
    CREATE TEMPORARY TABLE __temp__sys_file_reference AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM "sys_file_reference"
189
    DROP TABLE "sys_file_reference"
190
    CREATE TABLE "sys_file_reference" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, uid_local INTEGER DEFAULT 0 NOT NULL, uid_foreign INTEGER DEFAULT 0 NOT NULL, tablenames VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, fieldname VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, sorting_foreign INTEGER DEFAULT 0 NOT NULL, table_local VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, title CLOB DEFAULT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, alternative CLOB DEFAULT NULL COLLATE BINARY, link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, crop VARCHAR(4000) DEFAULT '' NOT NULL COLLATE BINARY, autoplay SMALLINT DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
191
    INSERT INTO "sys_file_reference" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sys_language_uid, l10n_parent, l10n_state, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, uid_local, uid_foreign, tablenames, fieldname, sorting_foreign, table_local, title, description, alternative, link, crop, autoplay, zzz_deleted_t3ver_id FROM __temp__sys_file_reference
192
    DROP TABLE __temp__sys_file_reference
193
    CREATE INDEX t3ver_oid_08d845fb ON "sys_file_reference" (t3ver_oid, t3ver_wsid)
194
    CREATE INDEX parent_3efdb54b ON "sys_file_reference" (pid, deleted, hidden)
195
    CREATE INDEX combined_1_b25ed807 ON "sys_file_reference" (l10n_parent, t3ver_oid, t3ver_wsid, t3ver_state, deleted)
196
    CREATE INDEX uid_foreign_84870ada ON "sys_file_reference" (uid_foreign)
197
    CREATE INDEX uid_local_6e063d86 ON "sys_file_reference" (uid_local)
198
    CREATE INDEX deleted_ec55f9ff ON "sys_file_reference" (deleted)
199
    CREATE INDEX tablenames_fieldname_2fe50272 ON "sys_file_reference" (tablenames, fieldname)
200
    DROP INDEX t3ver_oid_d19f62d6
201
    DROP INDEX parent_cfb58add
202
    CREATE TEMPORARY TABLE __temp__sys_file_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM "sys_file_collection"
203
    DROP TABLE "sys_file_collection"
204
    CREATE TABLE "sys_file_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(30) DEFAULT 'static' NOT NULL COLLATE BINARY, files INTEGER DEFAULT 0 NOT NULL, storage INTEGER DEFAULT 0 NOT NULL, folder CLOB DEFAULT NULL COLLATE BINARY, recursive SMALLINT DEFAULT 0 NOT NULL, category INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
205
    INSERT INTO "sys_file_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, files, storage, folder, recursive, category, zzz_deleted_t3ver_id FROM __temp__sys_file_collection
206
    DROP TABLE __temp__sys_file_collection
207
    CREATE INDEX t3ver_oid_d19f62d6 ON "sys_file_collection" (t3ver_oid, t3ver_wsid)
208
    CREATE INDEX parent_cfb58add ON "sys_file_collection" (pid, deleted, hidden)
209
    DROP INDEX t3ver_oid_f30873cd
210
    DROP INDEX parent_9a244dea
211
    CREATE TEMPORARY TABLE __temp__sys_collection AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM "sys_collection"
212
    DROP TABLE "sys_collection"
213
    CREATE TABLE "sys_collection" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB DEFAULT NULL COLLATE BINARY, type VARCHAR(32) DEFAULT 'static' NOT NULL COLLATE BINARY, table_name CLOB DEFAULT NULL COLLATE BINARY, items INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
214
    INSERT INTO "sys_collection" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, type, table_name, items, zzz_deleted_t3ver_id FROM __temp__sys_collection
215
    DROP TABLE __temp__sys_collection
216
    CREATE INDEX t3ver_oid_f30873cd ON "sys_collection" (t3ver_oid, t3ver_wsid)
217
    CREATE INDEX parent_9a244dea ON "sys_collection" (pid, deleted, hidden)
218
    DROP INDEX recordident_2_78d43f6c
219
    DROP INDEX recordident_1_e1dd6ed6
220
    CREATE TEMPORARY TABLE __temp__sys_history AS SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM "sys_history"
221
    DROP TABLE "sys_history"
222
    CREATE TABLE "sys_history" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, actiontype SMALLINT DEFAULT 0 NOT NULL, usertype VARCHAR(2) DEFAULT 'BE' NOT NULL COLLATE BINARY, userid INTEGER UNSIGNED DEFAULT NULL, originaluserid INTEGER UNSIGNED DEFAULT NULL, recuid INTEGER DEFAULT 0 NOT NULL, tablename VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, history_data CLOB DEFAULT NULL COLLATE BINARY, workspace INTEGER DEFAULT 0, correlation_id VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, zzz_deleted_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL)
223
    INSERT INTO "sys_history" (uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid) SELECT uid, pid, tstamp, actiontype, usertype, userid, originaluserid, recuid, tablename, history_data, workspace, correlation_id, zzz_deleted_pid FROM __temp__sys_history
224
    DROP TABLE __temp__sys_history
225
    CREATE INDEX recordident_2_78d43f6c ON "sys_history" (tablename, tstamp)
226
    CREATE INDEX recordident_1_e1dd6ed6 ON "sys_history" (tablename, recuid)
227
    DROP INDEX parent_b7280232
228
    CREATE TEMPORARY TABLE __temp__sys_language AS SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM "sys_language"
229
    DROP TABLE "sys_language"
230
    CREATE TABLE "sys_language" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, title VARCHAR(80) DEFAULT '' NOT NULL COLLATE BINARY, flag VARCHAR(20) DEFAULT '' NOT NULL COLLATE BINARY, language_isocode VARCHAR(2) DEFAULT '' NOT NULL COLLATE BINARY, static_lang_isocode INTEGER UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_static_lang_isocode INTEGER UNSIGNED DEFAULT 0 NOT NULL)
231
    INSERT INTO "sys_language" (uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode) SELECT uid, pid, tstamp, hidden, sorting, title, flag, language_isocode, static_lang_isocode, zzz_deleted_static_lang_isocode FROM __temp__sys_language
232
    DROP TABLE __temp__sys_language
233
    CREATE INDEX parent_b7280232 ON "sys_language" (pid, hidden)
234
    DROP INDEX t3ver_oid_0fc5a153
235
    DROP INDEX parent_a4d3f12f
236
    DROP INDEX category_list_9214ae08
237
    DROP INDEX category_parent_f5445003
238
    CREATE TEMPORARY TABLE __temp__sys_category AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM "sys_category"
239
    DROP TABLE "sys_category"
240
    CREATE TABLE "sys_category" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title CLOB NOT NULL COLLATE BINARY, parent INTEGER DEFAULT 0 NOT NULL, items INTEGER DEFAULT 0 NOT NULL, slug VARCHAR(2048) DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
241
    INSERT INTO "sys_category" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, sys_language_uid, l10n_parent, l10n_state, t3_origuid, l10n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, parent, items, slug, zzz_deleted_t3ver_id FROM __temp__sys_category
242
    DROP TABLE __temp__sys_category
243
    CREATE INDEX t3ver_oid_0fc5a153 ON "sys_category" (t3ver_oid, t3ver_wsid)
244
    CREATE INDEX parent_a4d3f12f ON "sys_category" (pid, deleted, hidden)
245
    CREATE INDEX category_list_9214ae08 ON "sys_category" (pid, deleted, sys_language_uid)
246
    CREATE INDEX category_parent_f5445003 ON "sys_category" (parent)
247
    DROP INDEX t3ver_oid_01f605d5
248
    DROP INDEX parent_a0d332a6
249
    DROP INDEX roottemplate_b05d9c09
250
    CREATE TEMPORARY TABLE __temp__sys_template AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM "sys_template"
251
    DROP TABLE "sys_template"
252
    CREATE TABLE "sys_template" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sitetitle VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, root SMALLINT UNSIGNED DEFAULT 0 NOT NULL, clear SMALLINT UNSIGNED DEFAULT 0 NOT NULL, include_static_file CLOB DEFAULT NULL COLLATE BINARY, constants CLOB DEFAULT NULL COLLATE BINARY, config CLOB DEFAULT NULL COLLATE BINARY, nextLevel VARCHAR(5) DEFAULT '' NOT NULL COLLATE BINARY, basedOn CLOB DEFAULT NULL COLLATE BINARY, includeStaticAfterBasedOn SMALLINT UNSIGNED DEFAULT 0 NOT NULL, static_file_mode SMALLINT UNSIGNED DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
253
    INSERT INTO "sys_template" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, sitetitle, root, clear, include_static_file, constants, config, nextLevel, basedOn, includeStaticAfterBasedOn, static_file_mode, zzz_deleted_t3ver_id FROM __temp__sys_template
254
    DROP TABLE __temp__sys_template
255
    CREATE INDEX t3ver_oid_01f605d5 ON "sys_template" (t3ver_oid, t3ver_wsid)
256
    CREATE INDEX parent_a0d332a6 ON "sys_template" (pid, deleted, hidden)
257
    CREATE INDEX roottemplate_b05d9c09 ON "sys_template" (deleted, hidden, root)
258
    DROP INDEX translation_source_fcef6e2f
259
    DROP INDEX language_6f2c39a6
260
    DROP INDEX t3ver_oid_be974a6e
261
    DROP INDEX parent_8b16a914
262
    CREATE TEMPORARY TABLE __temp__tt_content AS SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM "tt_content"
263
    DROP TABLE "tt_content"
264
    CREATE TABLE "tt_content" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, rowDescription CLOB DEFAULT NULL COLLATE BINARY, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL COLLATE BINARY, sorting INTEGER DEFAULT 0 NOT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l18n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, l18n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, CType VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_position VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, bodytext CLOB DEFAULT NULL COLLATE BINARY, bullets_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_description SMALLINT UNSIGNED DEFAULT 0 NOT NULL, uploads_type SMALLINT UNSIGNED DEFAULT 0 NOT NULL, assets INTEGER UNSIGNED DEFAULT 0 NOT NULL, image INTEGER UNSIGNED DEFAULT 0 NOT NULL, imagewidth INTEGER UNSIGNED DEFAULT 0 NOT NULL, imageorient SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imagecols SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageborder SMALLINT UNSIGNED DEFAULT 0 NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, frame_class VARCHAR(60) DEFAULT 'default' NOT NULL COLLATE BINARY, cols INTEGER UNSIGNED DEFAULT 0 NOT NULL, spaceBefore SMALLINT UNSIGNED DEFAULT 0 NOT NULL, spaceAfter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, space_before_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, space_after_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, records CLOB DEFAULT NULL COLLATE BINARY, pages CLOB DEFAULT NULL COLLATE BINARY, colPos INTEGER UNSIGNED DEFAULT 0 NOT NULL, subheader VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, header_link VARCHAR(1024) DEFAULT '' NOT NULL COLLATE BINARY, image_zoom SMALLINT UNSIGNED DEFAULT 0 NOT NULL, header_layout VARCHAR(30) DEFAULT '0' NOT NULL COLLATE BINARY, list_type VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, sectionIndex SMALLINT UNSIGNED DEFAULT 0 NOT NULL, linkToTop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, file_collections CLOB DEFAULT NULL COLLATE BINARY, filelink_size SMALLINT UNSIGNED DEFAULT 0 NOT NULL, filelink_sorting VARCHAR(17) DEFAULT '' NOT NULL COLLATE BINARY, filelink_sorting_direction VARCHAR(4) DEFAULT '' NOT NULL COLLATE BINARY, target VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, date INTEGER UNSIGNED DEFAULT 0 NOT NULL, recursive SMALLINT UNSIGNED DEFAULT 0 NOT NULL, imageheight INTEGER UNSIGNED DEFAULT 0 NOT NULL, pi_flexform CLOB DEFAULT NULL COLLATE BINARY, accessibility_title VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, accessibility_bypass SMALLINT UNSIGNED DEFAULT 0 NOT NULL, accessibility_bypass_text VARCHAR(30) DEFAULT '' NOT NULL COLLATE BINARY, selected_categories CLOB DEFAULT NULL COLLATE BINARY, category_field VARCHAR(64) DEFAULT '' NOT NULL COLLATE BINARY, table_class VARCHAR(60) DEFAULT '' NOT NULL COLLATE BINARY, table_caption VARCHAR(255) DEFAULT NULL COLLATE BINARY, table_delimiter SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_enclosure SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_header_position SMALLINT UNSIGNED DEFAULT 0 NOT NULL, table_tfoot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER DEFAULT 0 NOT NULL, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
265
    INSERT INTO "tt_content" (uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id) SELECT uid, rowDescription, pid, tstamp, crdate, cruser_id, deleted, hidden, starttime, endtime, fe_group, sorting, editlock, sys_language_uid, l18n_parent, l10n_source, l10n_state, t3_origuid, l18n_diffsource, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, CType, header, header_position, bodytext, bullets_type, uploads_description, uploads_type, assets, image, imagewidth, imageorient, imagecols, imageborder, media, layout, frame_class, cols, spaceBefore, spaceAfter, space_before_class, space_after_class, records, pages, colPos, subheader, header_link, image_zoom, header_layout, list_type, sectionIndex, linkToTop, file_collections, filelink_size, filelink_sorting, filelink_sorting_direction, target, date, recursive, imageheight, pi_flexform, accessibility_title, accessibility_bypass, accessibility_bypass_text, selected_categories, category_field, table_class, table_caption, table_delimiter, table_enclosure, table_header_position, table_tfoot, categories, zzz_deleted_t3ver_id FROM __temp__tt_content
266
    DROP TABLE __temp__tt_content
267
    CREATE INDEX translation_source_fcef6e2f ON "tt_content" (l10n_source)
268
    CREATE INDEX language_6f2c39a6 ON "tt_content" (l18n_parent, sys_language_uid)
269
    CREATE INDEX t3ver_oid_be974a6e ON "tt_content" (t3ver_oid, t3ver_wsid)
270
    CREATE INDEX parent_8b16a914 ON "tt_content" (pid, sorting)
271
    DROP INDEX t3ver_oid_8dc31fea
272
    DROP INDEX parent_30db6e61
273
    CREATE TEMPORARY TABLE __temp__backend_layout AS SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM "backend_layout"
274
    DROP TABLE "backend_layout"
275
    CREATE TABLE "backend_layout" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, cruser_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, description CLOB DEFAULT NULL COLLATE BINARY, t3_origuid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_label VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, t3ver_count INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_move_id INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL COLLATE BINARY, config CLOB NOT NULL COLLATE BINARY, icon CLOB DEFAULT NULL COLLATE BINARY, zzz_deleted_t3ver_id INTEGER UNSIGNED DEFAULT 0 NOT NULL)
276
    INSERT INTO "backend_layout" (uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id) SELECT uid, pid, tstamp, crdate, cruser_id, deleted, hidden, sorting, description, t3_origuid, t3ver_oid, t3ver_id, t3ver_label, t3ver_wsid, t3ver_state, t3ver_stage, t3ver_count, t3ver_tstamp, t3ver_move_id, title, config, icon, zzz_deleted_t3ver_id FROM __temp__backend_layout
277
    DROP TABLE __temp__backend_layout
278
    CREATE INDEX t3ver_oid_8dc31fea ON "backend_layout" (t3ver_oid, t3ver_wsid)
279
    CREATE INDEX parent_30db6e61 ON "backend_layout" (pid, deleted, hidden)
(2-2/2)