"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/2.5.0-2011-12-21-2.sql" (12 Sep 2021, 8118 Bytes) of package /linux/www/Joomla_3.10.2-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. See also the last Fossies "Diffs" side-by-side code changes report for "2.5.0-2011-12-21-2.sql": 3.9.25_vs_3.9.27.

    1 CREATE TABLE IF NOT EXISTS `#__finder_links_terms0` (
    2   `link_id` int unsigned NOT NULL,
    3   `term_id` int unsigned NOT NULL,
    4   `weight` float unsigned NOT NULL,
    5   PRIMARY KEY  (`link_id`,`term_id`),
    6   KEY `idx_term_weight` (`term_id`,`weight`),
    7   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
    8 ) DEFAULT CHARSET=utf8;
    9 
   10 CREATE TABLE IF NOT EXISTS `#__finder_links_terms1` (
   11   `link_id` int unsigned NOT NULL,
   12   `term_id` int unsigned NOT NULL,
   13   `weight` float unsigned NOT NULL,
   14   PRIMARY KEY  (`link_id`,`term_id`),
   15   KEY `idx_term_weight` (`term_id`,`weight`),
   16   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   17 ) DEFAULT CHARSET=utf8;
   18 
   19 CREATE TABLE IF NOT EXISTS `#__finder_links_terms2` (
   20   `link_id` int unsigned NOT NULL,
   21   `term_id` int unsigned NOT NULL,
   22   `weight` float unsigned NOT NULL,
   23   PRIMARY KEY  (`link_id`,`term_id`),
   24   KEY `idx_term_weight` (`term_id`,`weight`),
   25   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   26 ) DEFAULT CHARSET=utf8;
   27 
   28 CREATE TABLE IF NOT EXISTS `#__finder_links_terms3` (
   29   `link_id` int unsigned NOT NULL,
   30   `term_id` int unsigned NOT NULL,
   31   `weight` float unsigned NOT NULL,
   32   PRIMARY KEY  (`link_id`,`term_id`),
   33   KEY `idx_term_weight` (`term_id`,`weight`),
   34   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   35 )  DEFAULT CHARSET=utf8;
   36 
   37 
   38 CREATE TABLE IF NOT EXISTS `#__finder_links_terms4` (
   39   `link_id` int unsigned NOT NULL,
   40   `term_id` int unsigned NOT NULL,
   41   `weight` float unsigned NOT NULL,
   42   PRIMARY KEY  (`link_id`,`term_id`),
   43   KEY `idx_term_weight` (`term_id`,`weight`),
   44   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   45 )  DEFAULT CHARSET=utf8;
   46 
   47 
   48 CREATE TABLE IF NOT EXISTS `#__finder_links_terms5` (
   49   `link_id` int unsigned NOT NULL,
   50   `term_id` int unsigned NOT NULL,
   51   `weight` float unsigned NOT NULL,
   52   PRIMARY KEY  (`link_id`,`term_id`),
   53   KEY `idx_term_weight` (`term_id`,`weight`),
   54   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   55 )  DEFAULT CHARSET=utf8;
   56 
   57 
   58 CREATE TABLE IF NOT EXISTS `#__finder_links_terms6` (
   59   `link_id` int unsigned NOT NULL,
   60   `term_id` int unsigned NOT NULL,
   61   `weight` float unsigned NOT NULL,
   62   PRIMARY KEY  (`link_id`,`term_id`),
   63   KEY `idx_term_weight` (`term_id`,`weight`),
   64   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   65 )  DEFAULT CHARSET=utf8;
   66 
   67 
   68 CREATE TABLE IF NOT EXISTS `#__finder_links_terms7` (
   69   `link_id` int unsigned NOT NULL,
   70   `term_id` int unsigned NOT NULL,
   71   `weight` float unsigned NOT NULL,
   72   PRIMARY KEY  (`link_id`,`term_id`),
   73   KEY `idx_term_weight` (`term_id`,`weight`),
   74   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   75 )  DEFAULT CHARSET=utf8;
   76 
   77 
   78 CREATE TABLE IF NOT EXISTS `#__finder_links_terms8` (
   79   `link_id` int unsigned NOT NULL,
   80   `term_id` int unsigned NOT NULL,
   81   `weight` float unsigned NOT NULL,
   82   PRIMARY KEY  (`link_id`,`term_id`),
   83   KEY `idx_term_weight` (`term_id`,`weight`),
   84   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   85 )  DEFAULT CHARSET=utf8;
   86 
   87 
   88 CREATE TABLE IF NOT EXISTS `#__finder_links_terms9` (
   89   `link_id` int unsigned NOT NULL,
   90   `term_id` int unsigned NOT NULL,
   91   `weight` float unsigned NOT NULL,
   92   PRIMARY KEY  (`link_id`,`term_id`),
   93   KEY `idx_term_weight` (`term_id`,`weight`),
   94   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
   95 )  DEFAULT CHARSET=utf8;
   96 
   97 
   98 CREATE TABLE IF NOT EXISTS `#__finder_links_termsa` (
   99   `link_id` int unsigned NOT NULL,
  100   `term_id` int unsigned NOT NULL,
  101   `weight` float unsigned NOT NULL,
  102   PRIMARY KEY  (`link_id`,`term_id`),
  103   KEY `idx_term_weight` (`term_id`,`weight`),
  104   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
  105 )  DEFAULT CHARSET=utf8;
  106 
  107 
  108 CREATE TABLE IF NOT EXISTS `#__finder_links_termsb` (
  109   `link_id` int unsigned NOT NULL,
  110   `term_id` int unsigned NOT NULL,
  111   `weight` float unsigned NOT NULL,
  112   PRIMARY KEY  (`link_id`,`term_id`),
  113   KEY `idx_term_weight` (`term_id`,`weight`),
  114   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
  115 )  DEFAULT CHARSET=utf8;
  116 
  117 
  118 CREATE TABLE IF NOT EXISTS `#__finder_links_termsc` (
  119   `link_id` int unsigned NOT NULL,
  120   `term_id` int unsigned NOT NULL,
  121   `weight` float unsigned NOT NULL,
  122   PRIMARY KEY  (`link_id`,`term_id`),
  123   KEY `idx_term_weight` (`term_id`,`weight`),
  124   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
  125 )  DEFAULT CHARSET=utf8;
  126 
  127 
  128 CREATE TABLE IF NOT EXISTS `#__finder_links_termsd` (
  129   `link_id` int unsigned NOT NULL,
  130   `term_id` int unsigned NOT NULL,
  131   `weight` float unsigned NOT NULL,
  132   PRIMARY KEY  (`link_id`,`term_id`),
  133   KEY `idx_term_weight` (`term_id`,`weight`),
  134   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
  135 )  DEFAULT CHARSET=utf8;
  136 
  137 
  138 CREATE TABLE IF NOT EXISTS `#__finder_links_termse` (
  139   `link_id` int unsigned NOT NULL,
  140   `term_id` int unsigned NOT NULL,
  141   `weight` float unsigned NOT NULL,
  142   PRIMARY KEY  (`link_id`,`term_id`),
  143   KEY `idx_term_weight` (`term_id`,`weight`),
  144   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
  145 )  DEFAULT CHARSET=utf8;
  146 
  147 
  148 CREATE TABLE IF NOT EXISTS `#__finder_links_termsf` (
  149   `link_id` int unsigned NOT NULL,
  150   `term_id` int unsigned NOT NULL,
  151   `weight` float unsigned NOT NULL,
  152   PRIMARY KEY  (`link_id`,`term_id`),
  153   KEY `idx_term_weight` (`term_id`,`weight`),
  154   KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
  155 )  DEFAULT CHARSET=utf8;
  156 
  157 
  158 CREATE TABLE IF NOT EXISTS `#__finder_taxonomy` (
  159   `id` int unsigned NOT NULL auto_increment,
  160   `parent_id` int unsigned NOT NULL default '0',
  161   `title` varchar(255) NOT NULL,
  162   `state` tinyint unsigned NOT NULL default '1',
  163   `access` tinyint unsigned NOT NULL default '0',
  164   `ordering` tinyint unsigned NOT NULL default '0',
  165   PRIMARY KEY  (`id`),
  166   KEY `parent_id` (`parent_id`),
  167   KEY `state` (`state`),
  168   KEY `ordering` (`ordering`),
  169   KEY `access` (`access`),
  170   KEY `idx_parent_published` (`parent_id`,`state`,`access`)
  171 )   DEFAULT CHARSET=utf8;
  172 
  173 
  174 CREATE TABLE IF NOT EXISTS `#__finder_taxonomy_map` (
  175   `link_id` int unsigned NOT NULL,
  176   `node_id` int unsigned NOT NULL,
  177   PRIMARY KEY  (`link_id`,`node_id`),
  178   KEY `link_id` (`link_id`),
  179   KEY `node_id` (`node_id`)
  180 )  DEFAULT CHARSET=utf8;
  181 
  182 
  183 CREATE TABLE IF NOT EXISTS `#__finder_terms` (
  184   `term_id` int unsigned NOT NULL auto_increment,
  185   `term` varchar(75) NOT NULL,
  186   `stem` varchar(75) NOT NULL,
  187   `common` tinyint unsigned NOT NULL default '0',
  188   `phrase` tinyint unsigned NOT NULL default '0',
  189   `weight` float unsigned NOT NULL default '0',
  190   `soundex` varchar(75) NOT NULL,
  191   `links` int NOT NULL default '0',
  192   PRIMARY KEY  (`term_id`),
  193   UNIQUE KEY `idx_term` (`term`),
  194   KEY `idx_term_phrase` (`term`,`phrase`),
  195   KEY `idx_stem_phrase` (`stem`,`phrase`),
  196   KEY `idx_soundex_phrase` (`soundex`,`phrase`)
  197 )  DEFAULT CHARSET=utf8;
  198 
  199 
  200 CREATE TABLE IF NOT EXISTS `#__finder_terms_common` (
  201   `term` varchar(75) NOT NULL,
  202   `language` varchar(3) NOT NULL,
  203   KEY `idx_word_lang` (`term`,`language`),
  204   KEY `idx_lang` (`language`)
  205 )  DEFAULT CHARSET=utf8;
  206 
  207 
  208 CREATE TABLE IF NOT EXISTS `#__finder_tokens` (
  209   `term` varchar(75) NOT NULL,
  210   `stem` varchar(75) NOT NULL,
  211   `common` tinyint unsigned NOT NULL default '0',
  212   `phrase` tinyint unsigned NOT NULL default '0',
  213   `weight` float unsigned NOT NULL default '1',
  214   `context` tinyint unsigned NOT NULL default '2',
  215   KEY `idx_word` (`term`),
  216   KEY `idx_context` (`context`)
  217 ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
  218 
  219 
  220 CREATE TABLE IF NOT EXISTS `#__finder_tokens_aggregate` (
  221   `term_id` int unsigned NOT NULL,
  222   `map_suffix` char(1) NOT NULL,
  223   `term` varchar(75) NOT NULL,
  224   `stem` varchar(75) NOT NULL,
  225   `common` tinyint unsigned NOT NULL default '0',
  226   `phrase` tinyint unsigned NOT NULL default '0',
  227   `term_weight` float unsigned NOT NULL,
  228   `context` tinyint unsigned NOT NULL default '2',
  229   `context_weight` float unsigned NOT NULL,
  230   `total_weight` float unsigned NOT NULL,
  231   KEY `token` (`term`),
  232   KEY `keyword_id` (`term_id`)
  233 ) ENGINE=MEMORY DEFAULT CHARSET=utf8;
  234 
  235 
  236 CREATE TABLE IF NOT EXISTS `#__finder_types` (
  237   `id` int unsigned NOT NULL auto_increment,
  238   `title` varchar(100) NOT NULL,
  239   `mime` varchar(100) NOT NULL,
  240   PRIMARY KEY  (`id`),
  241   UNIQUE KEY `title` (`title`)
  242 )   DEFAULT CHARSET=utf8;
  243 
  244