- md5
- a7483af80415b822a99abaa67e2c80d7
- sha1
- 0b0d0bc92bb1af47693cf6eba8edfd34126dcb23
- sha256
- 4ef66e458173e05afd33e7e965d5b6d23472e7ba3b4205f3478bf18c9b52bfad
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387
--
-- Table structure for table `#__finder_filters`
--
CREATE TABLE IF NOT EXISTS "#__finder_filters" (
"filter_id" serial NOT NULL,
"title" varchar(255) DEFAULT,
"alias" varchar(255) DEFAULT,
"state" smallint DEFAULT 1 NOT NULL,
"created" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"created_by" integer DEFAULT 0 NOT NULL,
"created_by_alias" varchar(255) DEFAULT '' NOT NULL,
"modified" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"modified_by" integer DEFAULT 0 NOT NULL,
"checked_out" integer DEFAULT 0 NOT NULL,
"checked_out_time" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"map_count" integer DEFAULT 0 NOT NULL,
"data" text,
"params" text,
PRIMARY KEY ("filter_id")
);
--
-- Table structure for table `#__finder_links`
--
CREATE TABLE IF NOT EXISTS "#__finder_links" (
"link_id" serial NOT NULL,
"url" varchar(255) NOT NULL,
"route" varchar(255) NOT NULL,
"title" varchar(400) DEFAULT NULL,
"description" text,
"indexdate" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"md5sum" varchar(32) DEFAULT NULL,
"published" smallint DEFAULT 1 NOT NULL,
"state" integer DEFAULT 1 NOT NULL,
"access" integer DEFAULT 0 NOT NULL,
"language" varchar(7) DEFAULT '' NOT NULL,
"publish_start_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"publish_end_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"start_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"end_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL,
"list_price" numeric(8,2) DEFAULT 0 NOT NULL,
"sale_price" numeric(8,2) DEFAULT 0 NOT NULL,
"type_id" bigint NOT NULL,
"object" bytea,
PRIMARY KEY ("link_id")
);
CREATE INDEX "#__finder_links_idx_type" on "#__finder_links" ("type_id");
CREATE INDEX "#__finder_links_idx_title" on "#__finder_links" ("title");
CREATE INDEX "#__finder_links_idx_md5" on "#__finder_links" ("md5sum");
CREATE INDEX "#__finder_links_idx_language" on "#__finder_links" ("language");
CREATE INDEX "#__finder_links_idx_url" on "#__finder_links" (substr(url,0,76));
CREATE INDEX "#__finder_links_idx_published_list" on "#__finder_links" ("published", "state", "access", "publish_start_date", "publish_end_date", "list_price");
CREATE INDEX "#__finder_links_idx_published_sale" on "#__finder_links" ("published", "state", "access", "publish_start_date", "publish_end_date", "sale_price");
--
-- Table: #__finder_links_terms
--
CREATE TABLE IF NOT EXISTS "#__finder_links_terms" (
"link_id" integer NOT NULL,
"term_id" integer NOT NULL,
"weight" numeric(8,2) DEFAULT 0 NOT NULL,
PRIMARY KEY ("link_id", "term_id")
);
CREATE INDEX "#__finder_links_terms0_idx_term_weight" on "#__finder_links_terms0" ("term_id", "weight");
CREATE INDEX "#__finder_links_terms0_idx_link_term_weight" on "#__finder_links_terms0" ("link_id", "term_id", "weight");
--
-- Table structure for table `#__finder_logging`
--
CREATE TABLE IF NOT EXISTS "#__finder_logging" (
"searchterm" character varying(255) NOT NULL DEFAULT '',
"md5sum" character varying(32) NOT NULL DEFAULT '',
"query" bytes NOT NULL,
"hits" integer NOT NULL DEFAULT 1,
"results" integer NOT NULL DEFAULT 0,
CONSTRAINT "#__finder_logging_idx_md5sum" UNIQUE ("md5sum")
);
CREATE INDEX "#__finder_logging_idx_md5sum" on "#__finder_logging" ("md5sum");
CREATE INDEX "#__finder_logging_idx_searchterm" on "#__finder_logging" ("searchterm");
--
-- Table: #__finder_taxonomy
--
CREATE TABLE IF NOT EXISTS "#__finder_taxonomy" (
"id" serial NOT NULL,
"parent_id" integer DEFAULT 0 NOT NULL,
"lft" integer DEFAULT 0 NOT NULL,
"rgt" integer DEFAULT 0 NOT NULL,
"level" integer DEFAULT 0 NOT NULL,
"path" VARCHAR(400) NOT NULL DEFAULT '',
"title" VARCHAR(255) NOT NULL DEFAULT '',
"alias" VARCHAR(400) NOT NULL DEFAULT '',
"state" smallint DEFAULT 1 NOT NULL,
"access" smallint DEFAULT 1 NOT NULL,
"language" varchar(7) DEFAULT '' NOT NULL,
PRIMARY KEY ("id")
);
CREATE INDEX "#__finder_taxonomy_state" on "#__finder_taxonomy" ("state");
CREATE INDEX "#__finder_taxonomy_access" on "#__finder_taxonomy" ("access");
CREATE INDEX "#__finder_taxonomy_path" on "#__finder_taxonomy" ("path");
CREATE INDEX "#__finder_taxonomy_lft_rgt" on "#__finder_taxonomy" ("lft", "rgt");
CREATE INDEX "#__finder_taxonomy_alias" on "#__finder_taxonomy" ("alias");
CREATE INDEX "#__finder_taxonomy_language" on "#__finder_taxonomy" ("language");
CREATE INDEX "#__finder_taxonomy_idx_parent_published" on "#__finder_taxonomy" ("parent_id", "state", "access");
--
-- Dumping data for table `#__finder_taxonomy`
--
INSERT INTO "#__finder_taxonomy" ("id", "parent_id", "lft", "rgt", "level", "path", "title", "alias", "state", "access", "language") VALUES
(1, 0, 0, 1, 0, '', 'ROOT', 'root', 1, 1, '*');
SELECT setval('#__finder_taxonomy_id_seq', 2, false);
--
-- Table structure for table `#__finder_taxonomy_map`
--
CREATE TABLE IF NOT EXISTS "#__finder_taxonomy_map" (
"link_id" integer NOT NULL,
"node_id" integer NOT NULL,
PRIMARY KEY ("link_id", "node_id")
);
CREATE INDEX "#__finder_taxonomy_map_link_id" on "#__finder_taxonomy_map" ("link_id");
CREATE INDEX "#__finder_taxonomy_map_node_id" on "#__finder_taxonomy_map" ("node_id");
--
-- Table structure for table `#__finder_terms`
--
CREATE TABLE IF NOT EXISTS "#__finder_terms" (
"term_id" serial NOT NULL,
"term" varchar(75) NOT NULL,
"stem" varchar(75) DEFAULT '' NOT NULL,
"common" smallint DEFAULT 0 NOT NULL,
"phrase" smallint DEFAULT 0 NOT NULL,
"weight" numeric(8,2) DEFAULT 0 NOT NULL,
"soundex" varchar(75) DEFAULT '' NOT NULL,
"links" integer DEFAULT 0 NOT NULL,
"language" varchar(7) DEFAULT '' NOT NULL,
PRIMARY KEY ("term_id"),
CONSTRAINT "#__finder_terms_idx_term" UNIQUE ("term")
);
CREATE INDEX "#__finder_terms_idx_term_phrase" on "#__finder_terms" ("term", "phrase");
CREATE INDEX "#__finder_terms_idx_stem_phrase" on "#__finder_terms" ("stem", "phrase");
CREATE INDEX "#__finder_terms_idx_soundex_phrase" on "#__finder_terms" ("soundex", "phrase");
--
-- Table structure for table `#__finder_terms_common`
--
CREATE TABLE IF NOT EXISTS "#__finder_terms_common" (
"term" varchar(75) NOT NULL,
"language" varchar(7) DEFAULT '' NOT NULL
);
CREATE INDEX "#__finder_terms_common_idx_word_lang" on "#__finder_terms_common" ("term", "language");
CREATE INDEX "#__finder_terms_common_idx_lang" on "#__finder_terms_common" ("language");
--
-- Dumping data for table `#__finder_terms_common`
--
INSERT INTO "#__finder_terms_common" ("term", "language") VALUES
('a', 'en'),
('about', 'en'),
('after', 'en'),
('ago', 'en'),
('all', 'en'),
('am', 'en'),
('an', 'en'),
('and', 'en'),
('any', 'en'),
('are', 'en'),
('aren''t', 'en'),
('as', 'en'),
('at', 'en'),
('be', 'en'),
('but', 'en'),
('by', 'en'),
('for', 'en'),
('from', 'en'),
('get', 'en'),
('go', 'en'),
('how', 'en'),
('if', 'en'),
('in', 'en'),
('into', 'en'),
('is', 'en'),
('isn''t', 'en'),
('it', 'en'),
('its', 'en'),
('me', 'en'),
('more', 'en'),
('most', 'en'),
('must', 'en'),
('my', 'en'),
('new', 'en'),
('no', 'en'),
('none', 'en'),
('not', 'en'),
('nothing', 'en'),
('of', 'en'),
('off', 'en'),
('often', 'en'),
('old', 'en'),
('on', 'en'),
('onc', 'en'),
('once', 'en'),
('only', 'en'),
('or', 'en'),
('other', 'en'),
('our', 'en'),
('ours', 'en'),
('out', 'en'),
('over', 'en'),
('page', 'en'),
('she', 'en'),
('should', 'en'),
('small', 'en'),
('so', 'en'),
('some', 'en'),
('than', 'en'),
('thank', 'en'),
('that', 'en'),
('the', 'en'),
('their', 'en'),
('theirs', 'en'),
('them', 'en'),
('then', 'en'),
('there', 'en'),
('these', 'en'),
('they', 'en'),
('this', 'en'),
('those', 'en'),
('thus', 'en'),
('time', 'en'),
('times', 'en'),
('to', 'en'),
('too', 'en'),
('true', 'en'),
('under', 'en'),
('until', 'en'),
('up', 'en'),
('upon', 'en'),
('use', 'en'),
('user', 'en'),
('users', 'en'),
('version', 'en'),
('very', 'en'),
('via', 'en'),
('want', 'en'),
('was', 'en'),
('way', 'en'),
('were', 'en'),
('what', 'en'),
('when', 'en'),
('where', 'en'),
('which', 'en'),
('who', 'en'),
('whom', 'en'),
('whose', 'en'),
('why', 'en'),
('wide', 'en'),
('will', 'en'),
('with', 'en'),
('within', 'en'),
('without', 'en'),
('would', 'en'),
('yes', 'en'),
('yet', 'en'),
('you', 'en'),
('your', 'en'),
('yours', 'en');
--
-- Table structure for table `#__finder_tokens`
--
CREATE TABLE IF NOT EXISTS "#__finder_tokens" (
"term" varchar(75) NOT NULL,
"stem" varchar(75) DEFAULT '' NOT NULL,
"common" smallint DEFAULT 0 NOT NULL,
"phrase" smallint DEFAULT 0 NOT NULL,
"weight" numeric(8,2) DEFAULT 1 NOT NULL,
"context" smallint DEFAULT 2 NOT NULL,
"language" varchar(7) DEFAULT '' NOT NULL
);
CREATE INDEX "#__finder_tokens_idx_word" on "#__finder_tokens" ("term");
CREATE INDEX "#__finder_tokens_idx_stem" on "#__finder_tokens" ("stem");
CREATE INDEX "#__finder_tokens_idx_context" on "#__finder_tokens" ("context");
CREATE INDEX "#__finder_tokens_idx_language" on "#__finder_tokens" ("language");
--
-- Table structure for table `#__finder_tokens_aggregate`
--
CREATE TABLE IF NOT EXISTS "#__finder_tokens_aggregate" (
"term_id" integer NOT NULL,
"term" varchar(75) NOT NULL,
"stem" varchar(75) DEFAULT '' NOT NULL,
"common" smallint DEFAULT 0 NOT NULL,
"phrase" smallint DEFAULT 0 NOT NULL,
"term_weight" numeric(8,2) NOT NULL DEFAULT 0,
"context" smallint DEFAULT 2 NOT NULL,
"context_weight" numeric(8,2) NOT NULL DEFAULT 0,
"total_weight" numeric(8,2) NOT NULL DEFAULT 0,
"language" varchar(7) DEFAULT '' NOT NULL
);
CREATE INDEX "#__finder_tokens_aggregate_token" on "#__finder_tokens_aggregate" ("term");
CREATE INDEX "_#__finder_tokens_aggregate_keyword_id" on "#__finder_tokens_aggregate" ("term_id");
--
-- Table structure for table `#__finder_types`
--
CREATE TABLE IF NOT EXISTS "#__finder_types" (
"id" serial NOT NULL,
"title" varchar(100) NOT NULL,
"mime" varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY ("id"),
CONSTRAINT "#__finder_types_title" UNIQUE ("title")
);
--
-- Here is SOUNDEX replacement for those who can't enable fuzzystrmatch module
-- from contrib folder.
-- This function comes from https://wiki.postgresql.org/wiki/Soundex
-- and is distributed with GPL license.
-- Thanks to its author, Marti Raudsepp, that published this piece of code.
--
CREATE OR REPLACE FUNCTION soundex(input text) RETURNS text
IMMUTABLE STRICT COST 500 LANGUAGE plpgsql
AS $$
DECLARE
soundex text = '';
char text;
symbol text;
last_symbol text = '';
pos int = 1;
BEGIN
WHILE length(soundex) < 4 LOOP
char = upper(substr(input, pos, 1));
pos = pos + 1;
CASE char
WHEN '' THEN
-- End of input string
IF soundex = '' THEN
RETURN '';
ELSE
RETURN rpad(soundex, 4, '0');
END IF;
WHEN 'B', 'F', 'P', 'V' THEN
symbol = '1';
WHEN 'C', 'G', 'J', 'K', 'Q', 'S', 'X', 'Z' THEN
symbol = '2';
WHEN 'D', 'T' THEN
symbol = '3';
WHEN 'L' THEN
symbol = '4';
WHEN 'M', 'N' THEN
symbol = '5';
WHEN 'R' THEN
symbol = '6';
ELSE
-- Not a consonant; no output, but next similar consonant will be re-recorded
symbol = '';
END CASE;
IF soundex = '' THEN
-- First character; only accept strictly English ASCII characters
IF char ~>=~ 'A' AND char ~<=~ 'Z' THEN
soundex = char;
last_symbol = symbol;
END IF;
ELSIF last_symbol != symbol THEN
soundex = soundex || symbol;
last_symbol = symbol;
END IF;
END LOOP;
RETURN soundex;
END;
$$;
The same content is in 3 releases, Joomla 4.0.0-alpha9 to 4.0.0-alpha11. See them all, or every version of this file.