[Summary view] [Print] [Text view]

   1  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
   2  SET time_zone = "+00:00";
   3  
   4  --
   5  -- Table structure for table `#__banners`
   6  --
   7  
   8  CREATE TABLE IF NOT EXISTS `#__banners` (
   9    `id` int NOT NULL AUTO_INCREMENT,
  10    `cid` int NOT NULL DEFAULT 0,
  11    `type` int NOT NULL DEFAULT 0,
  12    `name` varchar(255) NOT NULL DEFAULT '',
  13    `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  14    `imptotal` int NOT NULL DEFAULT 0,
  15    `impmade` int NOT NULL DEFAULT 0,
  16    `clicks` int NOT NULL DEFAULT 0,
  17    `clickurl` varchar(200) NOT NULL DEFAULT '',
  18    `state` tinyint NOT NULL DEFAULT 0,
  19    `catid` int unsigned NOT NULL DEFAULT 0,
  20    `description` text NOT NULL,
  21    `custombannercode` varchar(2048) NOT NULL,
  22    `sticky` tinyint unsigned NOT NULL DEFAULT 0,
  23    `ordering` int NOT NULL DEFAULT 0,
  24    `metakey` text,
  25    `params` text NOT NULL,
  26    `own_prefix` tinyint NOT NULL DEFAULT 0,
  27    `metakey_prefix` varchar(400) NOT NULL DEFAULT '',
  28    `purchase_type` tinyint NOT NULL DEFAULT -1,
  29    `track_clicks` tinyint NOT NULL DEFAULT -1,
  30    `track_impressions` tinyint NOT NULL DEFAULT -1,
  31    `checked_out` int unsigned,
  32    `checked_out_time` datetime,
  33    `publish_up` datetime,
  34    `publish_down` datetime,
  35    `reset` datetime,
  36    `created` datetime NOT NULL,
  37    `language` char(7) NOT NULL DEFAULT '',
  38    `created_by` int unsigned NOT NULL DEFAULT 0,
  39    `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  40    `modified` datetime NOT NULL,
  41    `modified_by` int unsigned NOT NULL DEFAULT 0,
  42    `version` int unsigned NOT NULL DEFAULT 1,
  43    PRIMARY KEY (`id`),
  44    KEY `idx_state` (`state`),
  45    KEY `idx_own_prefix` (`own_prefix`),
  46    KEY `idx_metakey_prefix` (`metakey_prefix`(100)),
  47    KEY `idx_banner_catid` (`catid`),
  48    KEY `idx_language` (`language`)
  49  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
  50  
  51  -- --------------------------------------------------------
  52  
  53  --
  54  -- Table structure for table `#__banner_clients`
  55  --
  56  
  57  CREATE TABLE IF NOT EXISTS `#__banner_clients` (
  58    `id` int NOT NULL AUTO_INCREMENT,
  59    `name` varchar(255) NOT NULL DEFAULT '',
  60    `contact` varchar(255) NOT NULL DEFAULT '',
  61    `email` varchar(255) NOT NULL DEFAULT '',
  62    `extrainfo` text NOT NULL,
  63    `state` tinyint NOT NULL DEFAULT 0,
  64    `checked_out` int unsigned,
  65    `checked_out_time` datetime,
  66    `metakey` text,
  67    `own_prefix` tinyint NOT NULL DEFAULT 0,
  68    `metakey_prefix` varchar(400) NOT NULL DEFAULT '',
  69    `purchase_type` tinyint NOT NULL DEFAULT -1,
  70    `track_clicks` tinyint NOT NULL DEFAULT -1,
  71    `track_impressions` tinyint NOT NULL DEFAULT -1,
  72    PRIMARY KEY (`id`),
  73    KEY `idx_own_prefix` (`own_prefix`),
  74    KEY `idx_metakey_prefix` (`metakey_prefix`(100))
  75  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
  76  
  77  -- --------------------------------------------------------
  78  
  79  --
  80  -- Table structure for table `#__banner_tracks`
  81  --
  82  
  83  CREATE TABLE IF NOT EXISTS `#__banner_tracks` (
  84    `track_date` datetime NOT NULL,
  85    `track_type` int unsigned NOT NULL,
  86    `banner_id` int unsigned NOT NULL,
  87    `count` int unsigned NOT NULL DEFAULT 0,
  88    PRIMARY KEY (`track_date`,`track_type`,`banner_id`),
  89    KEY `idx_track_date` (`track_date`),
  90    KEY `idx_track_type` (`track_type`),
  91    KEY `idx_banner_id` (`banner_id`)
  92  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
  93  
  94  -- --------------------------------------------------------
  95  
  96  --
  97  -- Table structure for table `#__contact_details`
  98  --
  99  
 100  CREATE TABLE IF NOT EXISTS `#__contact_details` (
 101    `id` int NOT NULL AUTO_INCREMENT,
 102    `name` varchar(255) NOT NULL,
 103    `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 104    `con_position` varchar(255),
 105    `address` text,
 106    `suburb` varchar(100),
 107    `state` varchar(100),
 108    `country` varchar(100),
 109    `postcode` varchar(100),
 110    `telephone` varchar(255),
 111    `fax` varchar(255),
 112    `misc` mediumtext,
 113    `image` varchar(255),
 114    `email_to` varchar(255),
 115    `default_con` tinyint unsigned NOT NULL DEFAULT 0,
 116    `published` tinyint NOT NULL DEFAULT 0,
 117    `checked_out` int unsigned,
 118    `checked_out_time` datetime,
 119    `ordering` int NOT NULL DEFAULT 0,
 120    `params` text NOT NULL,
 121    `user_id` int NOT NULL DEFAULT 0,
 122    `catid` int NOT NULL DEFAULT 0,
 123    `access` int unsigned NOT NULL DEFAULT 0,
 124    `mobile` varchar(255) NOT NULL DEFAULT '',
 125    `webpage` varchar(255) NOT NULL DEFAULT '',
 126    `sortname1` varchar(255) NOT NULL DEFAULT '',
 127    `sortname2` varchar(255) NOT NULL DEFAULT '',
 128    `sortname3` varchar(255) NOT NULL DEFAULT '',
 129    `language` varchar(7) NOT NULL,
 130    `created` datetime NOT NULL,
 131    `created_by` int unsigned NOT NULL DEFAULT 0,
 132    `created_by_alias` varchar(255) NOT NULL DEFAULT '',
 133    `modified` datetime NOT NULL,
 134    `modified_by` int unsigned NOT NULL DEFAULT 0,
 135    `metakey` text,
 136    `metadesc` text NOT NULL,
 137    `metadata` text NOT NULL,
 138    `featured` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Set if contact is featured.',
 139    `publish_up` datetime,
 140    `publish_down` datetime,
 141    `version` int unsigned NOT NULL DEFAULT 1,
 142    `hits` int unsigned NOT NULL DEFAULT 0,
 143    PRIMARY KEY (`id`),
 144    KEY `idx_access` (`access`),
 145    KEY `idx_checkout` (`checked_out`),
 146    KEY `idx_state` (`published`),
 147    KEY `idx_catid` (`catid`),
 148    KEY `idx_createdby` (`created_by`),
 149    KEY `idx_featured_catid` (`featured`,`catid`),
 150    KEY `idx_language` (`language`)
 151  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 152  
 153  -- --------------------------------------------------------
 154  
 155  --
 156  -- Table structure for table `#__content`
 157  --
 158  
 159  CREATE TABLE IF NOT EXISTS `#__content` (
 160    `id` int unsigned NOT NULL AUTO_INCREMENT,
 161    `asset_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
 162    `title` varchar(255) NOT NULL DEFAULT '',
 163    `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 164    `introtext` mediumtext NOT NULL,
 165    `fulltext` mediumtext NOT NULL,
 166    `state` tinyint NOT NULL DEFAULT 0,
 167    `catid` int unsigned NOT NULL DEFAULT 0,
 168    `created` datetime NOT NULL,
 169    `created_by` int unsigned NOT NULL DEFAULT 0,
 170    `created_by_alias` varchar(255) NOT NULL DEFAULT '',
 171    `modified` datetime NOT NULL,
 172    `modified_by` int unsigned NOT NULL DEFAULT 0,
 173    `checked_out` int unsigned,
 174    `checked_out_time` datetime NULL DEFAULT NULL,
 175    `publish_up` datetime NULL DEFAULT NULL,
 176    `publish_down` datetime NULL DEFAULT NULL,
 177    `images` text NOT NULL,
 178    `urls` text NOT NULL,
 179    `attribs` varchar(5120) NOT NULL,
 180    `version` int unsigned NOT NULL DEFAULT 1,
 181    `ordering` int NOT NULL DEFAULT 0,
 182    `metakey` text,
 183    `metadesc` text NOT NULL,
 184    `access` int unsigned NOT NULL DEFAULT 0,
 185    `hits` int unsigned NOT NULL DEFAULT 0,
 186    `metadata` text NOT NULL,
 187    `featured` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
 188    `language` char(7) NOT NULL COMMENT 'The language code for the article.',
 189    `note` varchar(255) NOT NULL DEFAULT '',
 190    PRIMARY KEY (`id`),
 191    KEY `idx_access` (`access`),
 192    KEY `idx_checkout` (`checked_out`),
 193    KEY `idx_state` (`state`),
 194    KEY `idx_catid` (`catid`),
 195    KEY `idx_createdby` (`created_by`),
 196    KEY `idx_featured_catid` (`featured`,`catid`),
 197    KEY `idx_language` (`language`),
 198    KEY `idx_alias` (`alias`(191))
 199  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 200  
 201  -- --------------------------------------------------------
 202  
 203  --
 204  -- Table structure for table `#__content_frontpage`
 205  --
 206  
 207  CREATE TABLE IF NOT EXISTS `#__content_frontpage` (
 208    `content_id` int NOT NULL DEFAULT 0,
 209    `ordering` int NOT NULL DEFAULT 0,
 210    `featured_up` datetime,
 211    `featured_down` datetime,
 212    PRIMARY KEY (`content_id`)
 213  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 214  
 215  -- --------------------------------------------------------
 216  
 217  --
 218  -- Table structure for table `#__content_rating`
 219  --
 220  
 221  CREATE TABLE IF NOT EXISTS `#__content_rating` (
 222    `content_id` int NOT NULL DEFAULT 0,
 223    `rating_sum` int unsigned NOT NULL DEFAULT 0,
 224    `rating_count` int unsigned NOT NULL DEFAULT 0,
 225    `lastip` varchar(50) NOT NULL DEFAULT '',
 226    PRIMARY KEY (`content_id`)
 227  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 228  
 229  -- --------------------------------------------------------
 230  
 231  --
 232  -- Table structure for table `#__finder_filters`
 233  --
 234  
 235  CREATE TABLE IF NOT EXISTS `#__finder_filters` (
 236    `filter_id` int unsigned NOT NULL AUTO_INCREMENT,
 237    `title` varchar(255) NOT NULL,
 238    `alias` varchar(255) NOT NULL,
 239    `state` tinyint NOT NULL DEFAULT 1,
 240    `created` datetime NOT NULL,
 241    `created_by` int unsigned NOT NULL DEFAULT 0,
 242    `created_by_alias` varchar(255) NOT NULL DEFAULT '',
 243    `modified` datetime NOT NULL,
 244    `modified_by` int unsigned NOT NULL DEFAULT 0,
 245    `checked_out` int unsigned,
 246    `checked_out_time` datetime,
 247    `map_count` int unsigned NOT NULL DEFAULT 0,
 248    `data` text,
 249    `params` mediumtext,
 250    PRIMARY KEY (`filter_id`)
 251  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 252  
 253  -- --------------------------------------------------------
 254  
 255  --
 256  -- Table structure for table `#__finder_links`
 257  --
 258  
 259  CREATE TABLE IF NOT EXISTS `#__finder_links` (
 260    `link_id` int unsigned NOT NULL AUTO_INCREMENT,
 261    `url` varchar(255) NOT NULL,
 262    `route` varchar(400) NOT NULL,
 263    `title` varchar(400) DEFAULT NULL,
 264    `description` text,
 265    `indexdate` datetime NOT NULL,
 266    `md5sum` varchar(32) DEFAULT NULL,
 267    `published` tinyint NOT NULL DEFAULT 1,
 268    `state` int NOT NULL DEFAULT 1,
 269    `access` int NOT NULL DEFAULT 0,
 270    `language` char(7) NOT NULL DEFAULT '',
 271    `publish_start_date` datetime,
 272    `publish_end_date` datetime,
 273    `start_date` datetime,
 274    `end_date` datetime,
 275    `list_price` double unsigned NOT NULL DEFAULT 0,
 276    `sale_price` double unsigned NOT NULL DEFAULT 0,
 277    `type_id` int NOT NULL,
 278    `object` mediumblob,
 279    PRIMARY KEY (`link_id`),
 280    KEY `idx_type` (`type_id`),
 281    KEY `idx_title` (`title`(100)),
 282    KEY `idx_md5` (`md5sum`),
 283    KEY `idx_url` (`url`(75)),
 284    KEY `idx_language` (`language`),
 285    KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
 286    KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
 287  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 288  
 289  -- --------------------------------------------------------
 290  
 291  --
 292  -- Table structure for table `#__finder_links_terms`
 293  --
 294  
 295  CREATE TABLE IF NOT EXISTS `#__finder_links_terms` (
 296    `link_id` int unsigned NOT NULL,
 297    `term_id` int unsigned NOT NULL,
 298    `weight` float unsigned NOT NULL DEFAULT 0,
 299    PRIMARY KEY (`link_id`,`term_id`),
 300    KEY `idx_term_weight` (`term_id`,`weight`),
 301    KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
 302  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 303  
 304  -- --------------------------------------------------------
 305  
 306  --
 307  -- Table structure for table `#__finder_logging`
 308  --
 309  
 310  CREATE TABLE IF NOT EXISTS `#__finder_logging` (
 311    `searchterm` VARCHAR(255) NOT NULL DEFAULT '',
 312    `md5sum` VARCHAR(32) NOT NULL DEFAULT '',
 313    `query` BLOB NOT NULL,
 314    `hits` int NOT NULL DEFAULT 1,
 315    `results` int NOT NULL DEFAULT 0,
 316    PRIMARY KEY (`md5sum`),
 317    INDEX `searchterm` (`searchterm`(191))
 318  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 319  
 320  -- --------------------------------------------------------
 321  
 322  --
 323  -- Table structure for table `#__finder_taxonomy`
 324  --
 325  
 326  CREATE TABLE IF NOT EXISTS `#__finder_taxonomy` (
 327    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
 328    `parent_id` int UNSIGNED NOT NULL DEFAULT '0',
 329    `lft` int NOT NULL DEFAULT '0',
 330    `rgt` int NOT NULL DEFAULT '0',
 331    `level` int UNSIGNED NOT NULL DEFAULT '0',
 332    `path` VARCHAR(400) NOT NULL DEFAULT '',
 333    `title` VARCHAR(255) NOT NULL DEFAULT '',
 334    `alias` VARCHAR(400) NOT NULL DEFAULT '',
 335    `state` tinyint UNSIGNED NOT NULL DEFAULT '1',
 336    `access` tinyint UNSIGNED NOT NULL DEFAULT '1',
 337    `language` CHAR(7) NOT NULL DEFAULT '',
 338    PRIMARY KEY (`id`),
 339    INDEX `idx_state` (`state`),
 340    INDEX `idx_access` (`access`),
 341    INDEX `idx_path` (`path`(100)),
 342    INDEX `idx_level` (`level`),
 343    INDEX `idx_left_right` (`lft`, `rgt`),
 344    INDEX `idx_alias` (`alias`(100)),
 345    INDEX `idx_language` (`language`),
 346    INDEX `idx_parent_published` (`parent_id`, `state`, `access`)
 347  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 348  
 349  --
 350  -- Dumping data for table `#__finder_taxonomy`
 351  --
 352  
 353  INSERT INTO `#__finder_taxonomy` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `state`, `access`, `language`) VALUES
 354  (1, 0, 0, 1, 0, '', 'ROOT', 'root', 1, 1, '*');
 355  
 356  -- --------------------------------------------------------
 357  
 358  --
 359  -- Table structure for table `#__finder_taxonomy_map`
 360  --
 361  
 362  CREATE TABLE IF NOT EXISTS `#__finder_taxonomy_map` (
 363    `link_id` int unsigned NOT NULL,
 364    `node_id` int unsigned NOT NULL,
 365    PRIMARY KEY (`link_id`,`node_id`),
 366    KEY `link_id` (`link_id`),
 367    KEY `node_id` (`node_id`)
 368  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 369  
 370  -- --------------------------------------------------------
 371  
 372  --
 373  -- Table structure for table `#__finder_terms`
 374  --
 375  
 376  CREATE TABLE IF NOT EXISTS `#__finder_terms` (
 377    `term_id` int unsigned NOT NULL AUTO_INCREMENT,
 378    `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 379    `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 380    `common` tinyint unsigned NOT NULL DEFAULT 0,
 381    `phrase` tinyint unsigned NOT NULL DEFAULT 0,
 382    `weight` float unsigned NOT NULL DEFAULT 0,
 383    `soundex` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 384    `links` int NOT NULL DEFAULT 0,
 385    `language` char(7) NOT NULL DEFAULT '',
 386    PRIMARY KEY (`term_id`),
 387    UNIQUE KEY `idx_term_language` (`term`,`language`),
 388    KEY `idx_stem` (`stem`),
 389    KEY `idx_term_phrase` (`term`,`phrase`),
 390    KEY `idx_stem_phrase` (`stem`,`phrase`),
 391    KEY `idx_soundex_phrase` (`soundex`,`phrase`),
 392    KEY `idx_language` (`language`)
 393  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 394  
 395  -- --------------------------------------------------------
 396  
 397  --
 398  -- Table structure for table `#__finder_terms_common`
 399  --
 400  
 401  CREATE TABLE IF NOT EXISTS `#__finder_terms_common` (
 402    `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 403    `language` char(7) NOT NULL DEFAULT '',
 404    `custom` int NOT NULL DEFAULT '0',
 405    UNIQUE KEY `idx_term_language` (`term`,`language`),
 406    KEY `idx_lang` (`language`)
 407  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 408  
 409  --
 410  -- Dumping data for table `#__finder_terms_common`
 411  --
 412  
 413  INSERT INTO `#__finder_terms_common` (`term`, `language`, `custom`) VALUES
 414  ('i', 'en', 0),
 415  ('me', 'en', 0),
 416  ('my', 'en', 0),
 417  ('myself', 'en', 0),
 418  ('we', 'en', 0),
 419  ('our', 'en', 0),
 420  ('ours', 'en', 0),
 421  ('ourselves', 'en', 0),
 422  ('you', 'en', 0),
 423  ('your', 'en', 0),
 424  ('yours', 'en', 0),
 425  ('yourself', 'en', 0),
 426  ('yourselves', 'en', 0),
 427  ('he', 'en', 0),
 428  ('him', 'en', 0),
 429  ('his', 'en', 0),
 430  ('himself', 'en', 0),
 431  ('she', 'en', 0),
 432  ('her', 'en', 0),
 433  ('hers', 'en', 0),
 434  ('herself', 'en', 0),
 435  ('it', 'en', 0),
 436  ('its', 'en', 0),
 437  ('itself', 'en', 0),
 438  ('they', 'en', 0),
 439  ('them', 'en', 0),
 440  ('their', 'en', 0),
 441  ('theirs', 'en', 0),
 442  ('themselves', 'en', 0),
 443  ('what', 'en', 0),
 444  ('which', 'en', 0),
 445  ('who', 'en', 0),
 446  ('whom', 'en', 0),
 447  ('this', 'en', 0),
 448  ('that', 'en', 0),
 449  ('these', 'en', 0),
 450  ('those', 'en', 0),
 451  ('am', 'en', 0),
 452  ('is', 'en', 0),
 453  ('are', 'en', 0),
 454  ('was', 'en', 0),
 455  ('were', 'en', 0),
 456  ('be', 'en', 0),
 457  ('been', 'en', 0),
 458  ('being', 'en', 0),
 459  ('have', 'en', 0),
 460  ('has', 'en', 0),
 461  ('had', 'en', 0),
 462  ('having', 'en', 0),
 463  ('do', 'en', 0),
 464  ('does', 'en', 0),
 465  ('did', 'en', 0),
 466  ('doing', 'en', 0),
 467  ('would', 'en', 0),
 468  ('should', 'en', 0),
 469  ('could', 'en', 0),
 470  ('ought', 'en', 0),
 471  ('i\'m', 'en', 0),
 472  ('you\'re', 'en', 0),
 473  ('he\'s', 'en', 0),
 474  ('she\'s', 'en', 0),
 475  ('it\'s', 'en', 0),
 476  ('we\'re', 'en', 0),
 477  ('they\'re', 'en', 0),
 478  ('i\'ve', 'en', 0),
 479  ('you\'ve', 'en', 0),
 480  ('we\'ve', 'en', 0),
 481  ('they\'ve', 'en', 0),
 482  ('i\'d', 'en', 0),
 483  ('you\'d', 'en', 0),
 484  ('he\'d', 'en', 0),
 485  ('she\'d', 'en', 0),
 486  ('we\'d', 'en', 0),
 487  ('they\'d', 'en', 0),
 488  ('i\'ll', 'en', 0),
 489  ('you\'ll', 'en', 0),
 490  ('he\'ll', 'en', 0),
 491  ('she\'ll', 'en', 0),
 492  ('we\'ll', 'en', 0),
 493  ('they\'ll', 'en', 0),
 494  ('isn\'t', 'en', 0),
 495  ('aren\'t', 'en', 0),
 496  ('wasn\'t', 'en', 0),
 497  ('weren\'t', 'en', 0),
 498  ('hasn\'t', 'en', 0),
 499  ('haven\'t', 'en', 0),
 500  ('hadn\'t', 'en', 0),
 501  ('doesn\'t', 'en', 0),
 502  ('don\'t', 'en', 0),
 503  ('didn\'t', 'en', 0),
 504  ('won\'t', 'en', 0),
 505  ('wouldn\'t', 'en', 0),
 506  ('shan\'t', 'en', 0),
 507  ('shouldn\'t', 'en', 0),
 508  ('can\'t', 'en', 0),
 509  ('cannot', 'en', 0),
 510  ('couldn\'t', 'en', 0),
 511  ('mustn\'t', 'en', 0),
 512  ('let\'s', 'en', 0),
 513  ('that\'s', 'en', 0),
 514  ('who\'s', 'en', 0),
 515  ('what\'s', 'en', 0),
 516  ('here\'s', 'en', 0),
 517  ('there\'s', 'en', 0),
 518  ('when\'s', 'en', 0),
 519  ('where\'s', 'en', 0),
 520  ('why\'s', 'en', 0),
 521  ('how\'s', 'en', 0),
 522  ('a', 'en', 0),
 523  ('an', 'en', 0),
 524  ('the', 'en', 0),
 525  ('and', 'en', 0),
 526  ('but', 'en', 0),
 527  ('if', 'en', 0),
 528  ('or', 'en', 0),
 529  ('because', 'en', 0),
 530  ('as', 'en', 0),
 531  ('until', 'en', 0),
 532  ('while', 'en', 0),
 533  ('of', 'en', 0),
 534  ('at', 'en', 0),
 535  ('by', 'en', 0),
 536  ('for', 'en', 0),
 537  ('with', 'en', 0),
 538  ('about', 'en', 0),
 539  ('against', 'en', 0),
 540  ('between', 'en', 0),
 541  ('into', 'en', 0),
 542  ('through', 'en', 0),
 543  ('during', 'en', 0),
 544  ('before', 'en', 0),
 545  ('after', 'en', 0),
 546  ('above', 'en', 0),
 547  ('below', 'en', 0),
 548  ('to', 'en', 0),
 549  ('from', 'en', 0),
 550  ('up', 'en', 0),
 551  ('down', 'en', 0),
 552  ('in', 'en', 0),
 553  ('out', 'en', 0),
 554  ('on', 'en', 0),
 555  ('off', 'en', 0),
 556  ('over', 'en', 0),
 557  ('under', 'en', 0),
 558  ('again', 'en', 0),
 559  ('further', 'en', 0),
 560  ('then', 'en', 0),
 561  ('once', 'en', 0),
 562  ('here', 'en', 0),
 563  ('there', 'en', 0),
 564  ('when', 'en', 0),
 565  ('where', 'en', 0),
 566  ('why', 'en', 0),
 567  ('how', 'en', 0),
 568  ('all', 'en', 0),
 569  ('any', 'en', 0),
 570  ('both', 'en', 0),
 571  ('each', 'en', 0),
 572  ('few', 'en', 0),
 573  ('more', 'en', 0),
 574  ('most', 'en', 0),
 575  ('other', 'en', 0),
 576  ('some', 'en', 0),
 577  ('such', 'en', 0),
 578  ('no', 'en', 0),
 579  ('nor', 'en', 0),
 580  ('not', 'en', 0),
 581  ('only', 'en', 0),
 582  ('own', 'en', 0),
 583  ('same', 'en', 0),
 584  ('so', 'en', 0),
 585  ('than', 'en', 0),
 586  ('too', 'en', 0),
 587  ('very', 'en', 0);
 588  
 589  -- --------------------------------------------------------
 590  
 591  --
 592  -- Table structure for table `#__finder_tokens`
 593  --
 594  
 595  CREATE TABLE IF NOT EXISTS `#__finder_tokens` (
 596    `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 597    `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 598    `common` tinyint unsigned NOT NULL DEFAULT 0,
 599    `phrase` tinyint unsigned NOT NULL DEFAULT 0,
 600    `weight` float unsigned NOT NULL DEFAULT 1,
 601    `context` tinyint unsigned NOT NULL DEFAULT 2,
 602    `language` char(7) NOT NULL DEFAULT '',
 603    KEY `idx_word` (`term`),
 604    KEY `idx_stem` (`stem`),
 605    KEY `idx_context` (`context`),
 606    KEY `idx_language` (`language`)
 607  ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 608  
 609  -- --------------------------------------------------------
 610  
 611  --
 612  -- Table structure for table `#__finder_tokens_aggregate`
 613  --
 614  
 615  CREATE TABLE IF NOT EXISTS `#__finder_tokens_aggregate` (
 616    `term_id` int unsigned NOT NULL,
 617    `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 618    `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 619    `common` tinyint unsigned NOT NULL DEFAULT 0,
 620    `phrase` tinyint unsigned NOT NULL DEFAULT 0,
 621    `term_weight` float unsigned NOT NULL DEFAULT 0,
 622    `context` tinyint unsigned NOT NULL DEFAULT 2,
 623    `context_weight` float unsigned NOT NULL DEFAULT 0,
 624    `total_weight` float unsigned NOT NULL DEFAULT 0,
 625    `language` char(7) NOT NULL DEFAULT '',
 626    KEY `token` (`term`),
 627    KEY `keyword_id` (`term_id`)
 628  ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 629  
 630  -- --------------------------------------------------------
 631  
 632  --
 633  -- Table structure for table `#__finder_types`
 634  --
 635  
 636  CREATE TABLE IF NOT EXISTS `#__finder_types` (
 637    `id` int unsigned NOT NULL AUTO_INCREMENT,
 638    `title` varchar(100) NOT NULL,
 639    `mime` varchar(100) NOT NULL DEFAULT '',
 640    PRIMARY KEY (`id`),
 641    UNIQUE KEY `title` (`title`)
 642  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 643  
 644  -- --------------------------------------------------------
 645  
 646  --
 647  -- Table structure for table `#__messages`
 648  --
 649  
 650  CREATE TABLE IF NOT EXISTS `#__messages` (
 651    `message_id` int unsigned NOT NULL AUTO_INCREMENT,
 652    `user_id_from` int unsigned NOT NULL DEFAULT 0,
 653    `user_id_to` int unsigned NOT NULL DEFAULT 0,
 654    `folder_id` tinyint unsigned NOT NULL DEFAULT 0,
 655    `date_time` datetime NOT NULL,
 656    `state` tinyint NOT NULL DEFAULT 0,
 657    `priority` tinyint unsigned NOT NULL DEFAULT 0,
 658    `subject` varchar(255) NOT NULL DEFAULT '',
 659    `message` text NOT NULL,
 660    PRIMARY KEY (`message_id`),
 661    KEY `useridto_state` (`user_id_to`,`state`)
 662  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 663  
 664  -- --------------------------------------------------------
 665  
 666  --
 667  -- Table structure for table `#__messages_cfg`
 668  --
 669  
 670  CREATE TABLE IF NOT EXISTS `#__messages_cfg` (
 671    `user_id` int unsigned NOT NULL DEFAULT 0,
 672    `cfg_name` varchar(100) NOT NULL DEFAULT '',
 673    `cfg_value` varchar(255) NOT NULL DEFAULT '',
 674    UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
 675  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 676  
 677  -- --------------------------------------------------------
 678  
 679  --
 680  -- Table structure for table `#__newsfeeds`
 681  --
 682  
 683  CREATE TABLE IF NOT EXISTS `#__newsfeeds` (
 684    `catid` int NOT NULL DEFAULT 0,
 685    `id` int unsigned NOT NULL AUTO_INCREMENT,
 686    `name` varchar(100) NOT NULL DEFAULT '',
 687    `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
 688    `link` varchar(2048) NOT NULL DEFAULT '',
 689    `published` tinyint NOT NULL DEFAULT 0,
 690    `numarticles` int unsigned NOT NULL DEFAULT 1,
 691    `cache_time` int unsigned NOT NULL DEFAULT 3600,
 692    `checked_out` int unsigned,
 693    `checked_out_time` datetime,
 694    `ordering` int NOT NULL DEFAULT 0,
 695    `rtl` tinyint NOT NULL DEFAULT 0,
 696    `access` int unsigned NOT NULL DEFAULT 0,
 697    `language` char(7) NOT NULL DEFAULT '',
 698    `params` text NOT NULL,
 699    `created` datetime NOT NULL,
 700    `created_by` int unsigned NOT NULL DEFAULT 0,
 701    `created_by_alias` varchar(255) NOT NULL DEFAULT '',
 702    `modified` datetime NOT NULL,
 703    `modified_by` int unsigned NOT NULL DEFAULT 0,
 704    `metakey` text,
 705    `metadesc` text NOT NULL,
 706    `metadata` text NOT NULL,
 707    `publish_up` datetime,
 708    `publish_down` datetime,
 709    `description` text NOT NULL,
 710    `version` int unsigned NOT NULL DEFAULT 1,
 711    `hits` int unsigned NOT NULL DEFAULT 0,
 712    `images` text NOT NULL,
 713    PRIMARY KEY (`id`),
 714    KEY `idx_access` (`access`),
 715    KEY `idx_checkout` (`checked_out`),
 716    KEY `idx_state` (`published`),
 717    KEY `idx_catid` (`catid`),
 718    KEY `idx_createdby` (`created_by`),
 719    KEY `idx_language` (`language`)
 720  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 721  
 722  -- --------------------------------------------------------
 723  
 724  --
 725  -- Table structure for table `#__privacy_requests`
 726  --
 727  
 728  CREATE TABLE IF NOT EXISTS `#__privacy_requests` (
 729    `id` int unsigned NOT NULL AUTO_INCREMENT,
 730    `email` varchar(100) NOT NULL DEFAULT '',
 731    `requested_at` datetime NOT NULL,
 732    `status` tinyint NOT NULL DEFAULT 0,
 733    `request_type` varchar(25) NOT NULL DEFAULT '',
 734    `confirm_token` varchar(100) NOT NULL DEFAULT '',
 735    `confirm_token_created_at` datetime,
 736    PRIMARY KEY (`id`)
 737  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 738  
 739  -- --------------------------------------------------------
 740  
 741  --
 742  -- Table structure for table `#__privacy_consents`
 743  --
 744  
 745  CREATE TABLE IF NOT EXISTS `#__privacy_consents` (
 746    `id` int unsigned NOT NULL AUTO_INCREMENT,
 747    `user_id` int unsigned NOT NULL DEFAULT 0,
 748    `state` int NOT NULL DEFAULT 1,
 749    `created` datetime NOT NULL,
 750    `subject` varchar(255) NOT NULL DEFAULT '',
 751    `body` text NOT NULL,
 752    `remind` tinyint NOT NULL DEFAULT 0,
 753    `token` varchar(100) NOT NULL DEFAULT '',
 754    PRIMARY KEY (`id`),
 755    KEY `idx_user_id` (`user_id`)
 756  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 757  
 758  -- --------------------------------------------------------
 759  
 760  --
 761  -- Table structure for table `#__redirect_links`
 762  --
 763  
 764  CREATE TABLE IF NOT EXISTS `#__redirect_links` (
 765    `id` int unsigned NOT NULL AUTO_INCREMENT,
 766    `old_url` varchar(2048) NOT NULL,
 767    `new_url` varchar(2048),
 768    `referer` varchar(2048) NOT NULL,
 769    `comment` varchar(255) NOT NULL DEFAULT '',
 770    `hits` int unsigned NOT NULL DEFAULT 0,
 771    `published` tinyint NOT NULL,
 772    `created_date` datetime NOT NULL,
 773    `modified_date` datetime NOT NULL,
 774    `header` smallint NOT NULL DEFAULT 301,
 775    PRIMARY KEY (`id`),
 776    KEY `idx_old_url` (`old_url`(100)),
 777    KEY `idx_link_modified` (`modified_date`)
 778  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 779  
 780  -- --------------------------------------------------------
 781  
 782  --
 783  -- Table structure for table `#__action_logs`
 784  --
 785  
 786  CREATE TABLE IF NOT EXISTS `#__action_logs` (
 787    `id` int unsigned NOT NULL AUTO_INCREMENT,
 788    `message_language_key` varchar(255) NOT NULL DEFAULT '',
 789    `message` text NOT NULL,
 790    `log_date` datetime NOT NULL,
 791    `extension` varchar(50) NOT NULL DEFAULT '',
 792    `user_id` int NOT NULL DEFAULT 0,
 793    `item_id` int NOT NULL DEFAULT 0,
 794    `ip_address` VARCHAR(40) NOT NULL DEFAULT '0.0.0.0',
 795    PRIMARY KEY (`id`),
 796    KEY `idx_user_id` (`user_id`),
 797    KEY `idx_user_id_logdate` (`user_id`, `log_date`),
 798    KEY `idx_user_id_extension` (`user_id`, `extension`),
 799    KEY `idx_extension_item_id` (`extension`, `item_id`)
 800  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 801  
 802  -- --------------------------------------------------------
 803  
 804  --
 805  -- Table structure for table `#__action_logs_extensions`
 806  --
 807  
 808  CREATE TABLE IF NOT EXISTS `#__action_logs_extensions` (
 809    `id` int unsigned NOT NULL AUTO_INCREMENT,
 810    `extension` varchar(255) NOT NULL DEFAULT '',
 811    PRIMARY KEY (`id`)
 812  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 813  
 814  INSERT INTO `#__action_logs_extensions` (`id`, `extension`) VALUES
 815  (1, 'com_banners'),
 816  (2, 'com_cache'),
 817  (3, 'com_categories'),
 818  (4, 'com_config'),
 819  (5, 'com_contact'),
 820  (6, 'com_content'),
 821  (7, 'com_installer'),
 822  (8, 'com_media'),
 823  (9, 'com_menus'),
 824  (10, 'com_messages'),
 825  (11, 'com_modules'),
 826  (12, 'com_newsfeeds'),
 827  (13, 'com_plugins'),
 828  (14, 'com_redirect'),
 829  (15, 'com_tags'),
 830  (16, 'com_templates'),
 831  (17, 'com_users'),
 832  (18, 'com_checkin'),
 833  (19, 'com_scheduler');
 834  
 835  -- --------------------------------------------------------
 836  
 837  --
 838  -- Table structure for table `#__action_log_config`
 839  --
 840  
 841  CREATE TABLE IF NOT EXISTS `#__action_log_config` (
 842    `id` int unsigned NOT NULL AUTO_INCREMENT,
 843    `type_title` varchar(255) NOT NULL DEFAULT '',
 844    `type_alias` varchar(255) NOT NULL DEFAULT '',
 845    `id_holder` varchar(255),
 846    `title_holder` varchar(255),
 847    `table_name` varchar(255),
 848    `text_prefix` varchar(255),
 849    PRIMARY KEY (`id`)
 850  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 851  
 852  INSERT INTO `#__action_log_config` (`id`, `type_title`, `type_alias`, `id_holder`, `title_holder`, `table_name`, `text_prefix`) VALUES
 853  (1, 'article', 'com_content.article', 'id' ,'title' , '#__content', 'PLG_ACTIONLOG_JOOMLA'),
 854  (2, 'article', 'com_content.form', 'id', 'title' , '#__content', 'PLG_ACTIONLOG_JOOMLA'),
 855  (3, 'banner', 'com_banners.banner', 'id' ,'name' , '#__banners', 'PLG_ACTIONLOG_JOOMLA'),
 856  (4, 'user_note', 'com_users.note', 'id', 'subject' ,'#__user_notes', 'PLG_ACTIONLOG_JOOMLA'),
 857  (5, 'media', 'com_media.file', '' , 'name' , '',  'PLG_ACTIONLOG_JOOMLA'),
 858  (6, 'category', 'com_categories.category', 'id' , 'title' , '#__categories', 'PLG_ACTIONLOG_JOOMLA'),
 859  (7, 'menu', 'com_menus.menu', 'id' ,'title' , '#__menu_types', 'PLG_ACTIONLOG_JOOMLA'),
 860  (8, 'menu_item', 'com_menus.item', 'id' , 'title' , '#__menu', 'PLG_ACTIONLOG_JOOMLA'),
 861  (9, 'newsfeed', 'com_newsfeeds.newsfeed', 'id' ,'name' , '#__newsfeeds', 'PLG_ACTIONLOG_JOOMLA'),
 862  (10, 'link', 'com_redirect.link', 'id', 'old_url' , '#__redirect_links', 'PLG_ACTIONLOG_JOOMLA'),
 863  (11, 'tag', 'com_tags.tag', 'id', 'title' , '#__tags', 'PLG_ACTIONLOG_JOOMLA'),
 864  (12, 'style', 'com_templates.style', 'id' , 'title' , '#__template_styles', 'PLG_ACTIONLOG_JOOMLA'),
 865  (13, 'plugin', 'com_plugins.plugin', 'extension_id' , 'name' , '#__extensions', 'PLG_ACTIONLOG_JOOMLA'),
 866  (14, 'component_config', 'com_config.component', 'extension_id' , 'name', '', 'PLG_ACTIONLOG_JOOMLA'),
 867  (15, 'contact', 'com_contact.contact', 'id', 'name', '#__contact_details', 'PLG_ACTIONLOG_JOOMLA'),
 868  (16, 'module', 'com_modules.module', 'id' ,'title', '#__modules', 'PLG_ACTIONLOG_JOOMLA'),
 869  (17, 'access_level', 'com_users.level', 'id' , 'title', '#__viewlevels', 'PLG_ACTIONLOG_JOOMLA'),
 870  (18, 'banner_client', 'com_banners.client', 'id', 'name', '#__banner_clients', 'PLG_ACTIONLOG_JOOMLA'),
 871  (19, 'application_config', 'com_config.application', '', 'name', '', 'PLG_ACTIONLOG_JOOMLA'),
 872  (20, 'task', 'com_scheduler.task', 'id', 'title', '#__scheduler_tasks', 'PLG_ACTIONLOG_JOOMLA');
 873  
 874  -- --------------------------------------------------------
 875  
 876  --
 877  -- Table structure for table `#__action_logs_users`
 878  --
 879  
 880  CREATE TABLE IF NOT EXISTS `#__action_logs_users` (
 881    `user_id` int UNSIGNED NOT NULL,
 882    `notify` tinyint UNSIGNED NOT NULL,
 883    `extensions` text NOT NULL,
 884    PRIMARY KEY (`user_id`),
 885    KEY `idx_notify` (`notify`)
 886  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
 887  
 888  -- --------------------------------------------------------
 889  
 890  --
 891  -- Table structure for table `#__scheduler_tasks`
 892  --
 893  
 894  CREATE TABLE IF NOT EXISTS `#__scheduler_tasks` (
 895    `id` int unsigned NOT NULL AUTO_INCREMENT,
 896    `asset_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
 897    `title` varchar(255) NOT NULL DEFAULT '',
 898    `type` varchar(128) NOT NULL COMMENT 'unique identifier for job defined by plugin',
 899    `execution_rules` text COMMENT 'Execution Rules, Unprocessed',
 900    `cron_rules` text COMMENT 'Processed execution rules, crontab-like JSON form',
 901    `state` tinyint NOT NULL DEFAULT FALSE,
 902    `last_exit_code` int NOT NULL DEFAULT 0 COMMENT 'Exit code when job was last run',
 903    `last_execution` datetime COMMENT 'Timestamp of last run',
 904    `next_execution` datetime COMMENT 'Timestamp of next (planned) run, referred for execution on trigger',
 905    `times_executed` int DEFAULT 0 COMMENT 'Count of successful triggers',
 906    `times_failed` int DEFAULT 0 COMMENT 'Count of failures',
 907    `locked` datetime,
 908    `priority` smallint NOT NULL DEFAULT 0,
 909    `ordering` int NOT NULL DEFAULT 0 COMMENT 'Configurable list ordering',
 910    `cli_exclusive` smallint NOT NULL DEFAULT 0 COMMENT 'If 1, the task is only accessible via CLI',
 911    `params` text NOT NULL,
 912    `note` text,
 913    `created` datetime NOT NULL,
 914    `created_by` int UNSIGNED NOT NULL DEFAULT 0,
 915    `checked_out` int unsigned,
 916    `checked_out_time` datetime,
 917    PRIMARY KEY (id),
 918    KEY `idx_type` (`type`),
 919    KEY `idx_state` (`state`),
 920    KEY `idx_last_exit` (`last_exit_code`),
 921    KEY `idx_next_exec` (`next_execution`),
 922    KEY `idx_locked` (`locked`),
 923    KEY `idx_priority` (`priority`),
 924    KEY `idx_cli_exclusive` (`cli_exclusive`),
 925    KEY `idx_checked_out` (`checked_out`)
 926  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci;
 927  
 928  -- --------------------------------------------------------