"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/mysql/2.5.0-2011-12-23.sql" (12 Sep 2021, 2032 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-23.sql": 3.9.25_vs_3.9.27.

    1 CREATE TABLE IF NOT EXISTS `#__finder_filters` (
    2   `filter_id` int unsigned NOT NULL auto_increment,
    3   `title` varchar(255) NOT NULL,
    4   `alias` varchar(255) NOT NULL,
    5   `state` tinyint NOT NULL default '1',
    6   `created` datetime NOT NULL default '0000-00-00 00:00:00',
    7   `created_by` int unsigned NOT NULL,
    8   `created_by_alias` varchar(255) NOT NULL,
    9   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
   10   `modified_by` int unsigned NOT NULL default '0',
   11   `checked_out` int unsigned NOT NULL default '0',
   12   `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
   13   `map_count` int unsigned NOT NULL default '0',
   14   `data` text NOT NULL,
   15   `params` mediumtext,
   16   PRIMARY KEY  (`filter_id`)
   17 ) DEFAULT CHARSET=utf8;
   18 
   19 CREATE TABLE IF NOT EXISTS `#__finder_links` (
   20   `link_id` int unsigned NOT NULL auto_increment,
   21   `url` varchar(255) NOT NULL,
   22   `route` varchar(255) NOT NULL,
   23   `title` varchar(255) default NULL,
   24   `description` varchar(255) default NULL,
   25   `indexdate` datetime NOT NULL default '0000-00-00 00:00:00',
   26   `md5sum` varchar(32) default NULL,
   27   `published` tinyint NOT NULL default '1',
   28   `state` int default '1',
   29   `access` int default '0',
   30   `language` varchar(8) NOT NULL,
   31   `publish_start_date` datetime NOT NULL default '0000-00-00 00:00:00',
   32   `publish_end_date` datetime NOT NULL default '0000-00-00 00:00:00',
   33   `start_date` datetime NOT NULL default '0000-00-00 00:00:00',
   34   `end_date` datetime NOT NULL default '0000-00-00 00:00:00',
   35   `list_price` double unsigned NOT NULL default '0',
   36   `sale_price` double unsigned NOT NULL default '0',
   37   `type_id` int NOT NULL,
   38   `object` mediumblob NOT NULL,
   39   PRIMARY KEY  (`link_id`),
   40   KEY `idx_type` (`type_id`),
   41   KEY `idx_title` (`title`),
   42   KEY `idx_md5` (`md5sum`),
   43   KEY `idx_url` (`url`(75)),
   44   KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
   45   KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
   46 ) DEFAULT CHARSET=utf8;
   47