"Fossies" - the Fresh Open Source Software Archive 
Member "administrator/components/com_admin/sql/updates/mysql/2.5.0-2011-12-23.sql" (18 Jun 2022, 2032 Bytes) of package /linux/www/Joomla_3.10.10-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 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