"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/4.0.0-2018-07-29.sql" (13 Sep 2021, 11785 Bytes) of package /linux/www/Joomla_4.0.3-Stable-Full_Package.tar.bz2:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `manifest_cache`, `params`, `custom_data`, `checked_out`, `checked_out_time`, `ordering`, `state`) VALUES
    2 (0, 'plg_extension_finder', 'plugin', 'finder', 'extension', 0, 1, 1, 0, '', '', '', 0, '0000-00-00 00:00:00', 0, 0);
    3 
    4 TRUNCATE TABLE `#__finder_filters`;
    5 ALTER TABLE `#__finder_filters` MODIFY `created_by` int unsigned NOT NULL DEFAULT 0;
    6 ALTER TABLE `#__finder_filters` MODIFY `created_by_alias` varchar(255) NOT NULL DEFAULT '';
    7 ALTER TABLE `#__finder_filters` MODIFY `created` datetime NOT NULL;
    8 ALTER TABLE `#__finder_filters` MODIFY `modified` datetime NOT NULL;
    9 ALTER TABLE `#__finder_filters` MODIFY `checked_out_time` datetime NULL DEFAULT NULL;
   10 ALTER TABLE `#__finder_filters` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   11 ALTER TABLE `#__finder_filters` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   12 
   13 TRUNCATE TABLE `#__finder_links`;
   14 ALTER TABLE `#__finder_links` CHANGE `route` `route` varchar(400);
   15 ALTER TABLE `#__finder_links` CHANGE `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `access`;
   16 ALTER TABLE `#__finder_links` MODIFY `state` int NOT NULL DEFAULT 1;
   17 ALTER TABLE `#__finder_links` MODIFY `access` int NOT NULL DEFAULT 0;
   18 ALTER TABLE `#__finder_links` MODIFY `indexdate` datetime NOT NULL;
   19 ALTER TABLE `#__finder_links` MODIFY `publish_start_date` datetime NULL DEFAULT NULL;
   20 ALTER TABLE `#__finder_links` MODIFY `publish_end_date` datetime NULL DEFAULT NULL;
   21 ALTER TABLE `#__finder_links` MODIFY `start_date` datetime NULL DEFAULT NULL;
   22 ALTER TABLE `#__finder_links` MODIFY `end_date` datetime NULL DEFAULT NULL;
   23 ALTER TABLE `#__finder_links` ADD INDEX `idx_language` (`language`);
   24 ALTER TABLE `#__finder_links` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   25 ALTER TABLE `#__finder_links` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   26 
   27 CREATE TABLE `#__finder_links_terms` (
   28     `link_id` INT UNSIGNED NOT NULL,
   29     `term_id` INT UNSIGNED NOT NULL,
   30     `weight` FLOAT UNSIGNED NOT NULL DEFAULT 0,
   31     PRIMARY KEY (`link_id`, `term_id`),
   32     INDEX `idx_term_weight` (`term_id`, `weight`),
   33     INDEX `idx_link_term_weight` (`link_id`, `term_id`, `weight`)
   34 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
   35 
   36 DROP TABLE `#__finder_links_terms0`;
   37 DROP TABLE `#__finder_links_terms1`;
   38 DROP TABLE `#__finder_links_terms2`;
   39 DROP TABLE `#__finder_links_terms3`;
   40 DROP TABLE `#__finder_links_terms4`;
   41 DROP TABLE `#__finder_links_terms5`;
   42 DROP TABLE `#__finder_links_terms6`;
   43 DROP TABLE `#__finder_links_terms7`;
   44 DROP TABLE `#__finder_links_terms8`;
   45 DROP TABLE `#__finder_links_terms9`;
   46 DROP TABLE `#__finder_links_termsa`;
   47 DROP TABLE `#__finder_links_termsb`;
   48 DROP TABLE `#__finder_links_termsc`;
   49 DROP TABLE `#__finder_links_termsd`;
   50 DROP TABLE `#__finder_links_termse`;
   51 DROP TABLE `#__finder_links_termsf`;
   52 
   53 CREATE TABLE IF NOT EXISTS `#__finder_logging` (
   54   `searchterm` VARCHAR(255) NOT NULL DEFAULT '',
   55   `md5sum` VARCHAR(32) NOT NULL DEFAULT '',
   56   `query` BLOB NOT NULL,
   57   `hits` INT NOT NULL DEFAULT 1,
   58   `results` INT NOT NULL DEFAULT 0,
   59   PRIMARY KEY (`md5sum`),
   60   INDEX `searchterm` (`searchterm`(191))
   61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
   62 ALTER TABLE `#__finder_logging` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   63 ALTER TABLE `#__finder_logging` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   64 
   65 DROP TABLE `#__finder_taxonomy`;
   66 CREATE TABLE IF NOT EXISTS `#__finder_taxonomy` (
   67     `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
   68     `parent_id` INT UNSIGNED NOT NULL DEFAULT '0',
   69     `lft` INT NOT NULL DEFAULT '0',
   70     `rgt` INT NOT NULL DEFAULT '0',
   71     `level` INT UNSIGNED NOT NULL DEFAULT '0',
   72     `path` VARCHAR(400) NOT NULL DEFAULT '',
   73     `title` VARCHAR(255) NOT NULL DEFAULT '',
   74     `alias` VARCHAR(400) NOT NULL DEFAULT '',
   75     `state` TINYINT UNSIGNED NOT NULL DEFAULT '1',
   76     `access` TINYINT UNSIGNED NOT NULL DEFAULT '1',
   77     `language` CHAR(7) NOT NULL DEFAULT '',
   78     PRIMARY KEY (`id`),
   79     INDEX `idx_state` (`state`),
   80     INDEX `idx_access` (`access`),
   81     INDEX `idx_path` (`path`(100)),
   82     INDEX `idx_left_right` (`lft`, `rgt`),
   83     INDEX `idx_alias` (`alias`(100)),
   84     INDEX `idx_language` (`language`),
   85     INDEX `idx_parent_published` (`parent_id`, `state`, `access`)
   86 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
   87 INSERT INTO `#__finder_taxonomy` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `state`, `access`, `language`) VALUES
   88 (1, 0, 0, 1, 0, '', 'ROOT', 'root', 1, 1, '*');
   89 
   90 TRUNCATE TABLE `#__finder_taxonomy_map`;
   91 ALTER TABLE `#__finder_taxonomy_map` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   92 ALTER TABLE `#__finder_taxonomy_map` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   93 
   94 TRUNCATE TABLE `#__finder_terms`;
   95 ALTER TABLE `#__finder_terms` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   96 ALTER TABLE `#__finder_terms` CHANGE `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `links`;
   97 ALTER TABLE `#__finder_terms` MODIFY `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
   98 ALTER TABLE `#__finder_terms` MODIFY `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '';
   99 ALTER TABLE `#__finder_terms` MODIFY `soundex` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '';
  100 ALTER TABLE `#__finder_terms` DROP INDEX `idx_term`;
  101 ALTER TABLE `#__finder_terms` ADD INDEX `idx_stem` (`stem`);
  102 ALTER TABLE `#__finder_terms` ADD INDEX `idx_language` (`language`);
  103 ALTER TABLE `#__finder_terms` ADD UNIQUE INDEX `idx_term_language` (`term`, `language`);
  104 ALTER TABLE `#__finder_terms` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  105 
  106 DROP TABLE IF EXISTS `#__finder_terms_common`;
  107 CREATE TABLE `#__finder_terms_common` (
  108   `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  109   `language` char(7) NOT NULL DEFAULT '',
  110   `custom` int NOT NULL DEFAULT '0',
  111   UNIQUE KEY `idx_term_language` (`term`,`language`),
  112   KEY `idx_lang` (`language`)
  113 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
  114 INSERT INTO `#__finder_terms_common` (`term`, `language`, `custom`) VALUES
  115     ('i', 'en', 0),
  116     ('me', 'en', 0),
  117     ('my', 'en', 0),
  118     ('myself', 'en', 0),
  119     ('we', 'en', 0),
  120     ('our', 'en', 0),
  121     ('ours', 'en', 0),
  122     ('ourselves', 'en', 0),
  123     ('you', 'en', 0),
  124     ('your', 'en', 0),
  125     ('yours', 'en', 0),
  126     ('yourself', 'en', 0),
  127     ('yourselves', 'en', 0),
  128     ('he', 'en', 0),
  129     ('him', 'en', 0),
  130     ('his', 'en', 0),
  131     ('himself', 'en', 0),
  132     ('she', 'en', 0),
  133     ('her', 'en', 0),
  134     ('hers', 'en', 0),
  135     ('herself', 'en', 0),
  136     ('it', 'en', 0),
  137     ('its', 'en', 0),
  138     ('itself', 'en', 0),
  139     ('they', 'en', 0),
  140     ('them', 'en', 0),
  141     ('their', 'en', 0),
  142     ('theirs', 'en', 0),
  143     ('themselves', 'en', 0),
  144     ('what', 'en', 0),
  145     ('which', 'en', 0),
  146     ('who', 'en', 0),
  147     ('whom', 'en', 0),
  148     ('this', 'en', 0),
  149     ('that', 'en', 0),
  150     ('these', 'en', 0),
  151     ('those', 'en', 0),
  152     ('am', 'en', 0),
  153     ('is', 'en', 0),
  154     ('are', 'en', 0),
  155     ('was', 'en', 0),
  156     ('were', 'en', 0),
  157     ('be', 'en', 0),
  158     ('been', 'en', 0),
  159     ('being', 'en', 0),
  160     ('have', 'en', 0),
  161     ('has', 'en', 0),
  162     ('had', 'en', 0),
  163     ('having', 'en', 0),
  164     ('do', 'en', 0),
  165     ('does', 'en', 0),
  166     ('did', 'en', 0),
  167     ('doing', 'en', 0),
  168     ('would', 'en', 0),
  169     ('should', 'en', 0),
  170     ('could', 'en', 0),
  171     ('ought', 'en', 0),
  172     ('i\'m', 'en', 0),
  173     ('you\'re', 'en', 0),
  174     ('he\'s', 'en', 0),
  175     ('she\'s', 'en', 0),
  176     ('it\'s', 'en', 0),
  177     ('we\'re', 'en', 0),
  178     ('they\'re', 'en', 0),
  179     ('i\'ve', 'en', 0),
  180     ('you\'ve', 'en', 0),
  181     ('we\'ve', 'en', 0),
  182     ('they\'ve', 'en', 0),
  183     ('i\'d', 'en', 0),
  184     ('you\'d', 'en', 0),
  185     ('he\'d', 'en', 0),
  186     ('she\'d', 'en', 0),
  187     ('we\'d', 'en', 0),
  188     ('they\'d', 'en', 0),
  189     ('i\'ll', 'en', 0),
  190     ('you\'ll', 'en', 0),
  191     ('he\'ll', 'en', 0),
  192     ('she\'ll', 'en', 0),
  193     ('we\'ll', 'en', 0),
  194     ('they\'ll', 'en', 0),
  195     ('isn\'t', 'en', 0),
  196     ('aren\'t', 'en', 0),
  197     ('wasn\'t', 'en', 0),
  198     ('weren\'t', 'en', 0),
  199     ('hasn\'t', 'en', 0),
  200     ('haven\'t', 'en', 0),
  201     ('hadn\'t', 'en', 0),
  202     ('doesn\'t', 'en', 0),
  203     ('don\'t', 'en', 0),
  204     ('didn\'t', 'en', 0),
  205     ('won\'t', 'en', 0),
  206     ('wouldn\'t', 'en', 0),
  207     ('shan\'t', 'en', 0),
  208     ('shouldn\'t', 'en', 0),
  209     ('can\'t', 'en', 0),
  210     ('cannot', 'en', 0),
  211     ('couldn\'t', 'en', 0),
  212     ('mustn\'t', 'en', 0),
  213     ('let\'s', 'en', 0),
  214     ('that\'s', 'en', 0),
  215     ('who\'s', 'en', 0),
  216     ('what\'s', 'en', 0),
  217     ('here\'s', 'en', 0),
  218     ('there\'s', 'en', 0),
  219     ('when\'s', 'en', 0),
  220     ('where\'s', 'en', 0),
  221     ('why\'s', 'en', 0),
  222     ('how\'s', 'en', 0),
  223     ('a', 'en', 0),
  224     ('an', 'en', 0),
  225     ('the', 'en', 0),
  226     ('and', 'en', 0),
  227     ('but', 'en', 0),
  228     ('if', 'en', 0),
  229     ('or', 'en', 0),
  230     ('because', 'en', 0),
  231     ('as', 'en', 0),
  232     ('until', 'en', 0),
  233     ('while', 'en', 0),
  234     ('of', 'en', 0),
  235     ('at', 'en', 0),
  236     ('by', 'en', 0),
  237     ('for', 'en', 0),
  238     ('with', 'en', 0),
  239     ('about', 'en', 0),
  240     ('against', 'en', 0),
  241     ('between', 'en', 0),
  242     ('into', 'en', 0),
  243     ('through', 'en', 0),
  244     ('during', 'en', 0),
  245     ('before', 'en', 0),
  246     ('after', 'en', 0),
  247     ('above', 'en', 0),
  248     ('below', 'en', 0),
  249     ('to', 'en', 0),
  250     ('from', 'en', 0),
  251     ('up', 'en', 0),
  252     ('down', 'en', 0),
  253     ('in', 'en', 0),
  254     ('out', 'en', 0),
  255     ('on', 'en', 0),
  256     ('off', 'en', 0),
  257     ('over', 'en', 0),
  258     ('under', 'en', 0),
  259     ('again', 'en', 0),
  260     ('further', 'en', 0),
  261     ('then', 'en', 0),
  262     ('once', 'en', 0),
  263     ('here', 'en', 0),
  264     ('there', 'en', 0),
  265     ('when', 'en', 0),
  266     ('where', 'en', 0),
  267     ('why', 'en', 0),
  268     ('how', 'en', 0),
  269     ('all', 'en', 0),
  270     ('any', 'en', 0),
  271     ('both', 'en', 0),
  272     ('each', 'en', 0),
  273     ('few', 'en', 0),
  274     ('more', 'en', 0),
  275     ('most', 'en', 0),
  276     ('other', 'en', 0),
  277     ('some', 'en', 0),
  278     ('such', 'en', 0),
  279     ('no', 'en', 0),
  280     ('nor', 'en', 0),
  281     ('not', 'en', 0),
  282     ('only', 'en', 0),
  283     ('own', 'en', 0),
  284     ('same', 'en', 0),
  285     ('so', 'en', 0),
  286     ('than', 'en', 0),
  287     ('too', 'en', 0),
  288     ('very', 'en', 0);
  289 
  290 TRUNCATE TABLE `#__finder_tokens`;
  291 ALTER TABLE `#__finder_tokens` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  292 ALTER TABLE `#__finder_tokens` CHANGE `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `context`;
  293 ALTER TABLE `#__finder_tokens` MODIFY `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
  294 ALTER TABLE `#__finder_tokens` MODIFY `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '';
  295 ALTER TABLE `#__finder_tokens` ADD INDEX `idx_stem` (`stem`);
  296 ALTER TABLE `#__finder_tokens` ADD INDEX `idx_language` (`language`);
  297 ALTER TABLE `#__finder_tokens` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  298 
  299 TRUNCATE TABLE `#__finder_tokens_aggregate`;
  300 ALTER TABLE `#__finder_tokens_aggregate` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  301 ALTER TABLE `#__finder_tokens_aggregate` DROP COLUMN `map_suffix`;
  302 ALTER TABLE `#__finder_tokens_aggregate` CHANGE `language` `language` CHAR(7) NOT NULL DEFAULT '' AFTER `total_weight`;
  303 ALTER TABLE `#__finder_tokens_aggregate` MODIFY `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
  304 ALTER TABLE `#__finder_tokens_aggregate` MODIFY `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '';
  305 ALTER TABLE `#__finder_tokens_aggregate` MODIFY `term_weight` float unsigned NOT NULL DEFAULT 0;
  306 ALTER TABLE `#__finder_tokens_aggregate` MODIFY `context_weight` float unsigned NOT NULL DEFAULT 0;
  307 ALTER TABLE `#__finder_tokens_aggregate` MODIFY `total_weight` float unsigned NOT NULL DEFAULT 0;
  308 ALTER TABLE `#__finder_tokens_aggregate` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  309 
  310 ALTER TABLE `#__finder_types` MODIFY `mime` varchar(100) NOT NULL DEFAULT '';
  311 ALTER TABLE `#__finder_types` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  312 ALTER TABLE `#__finder_types` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;