"Fossies" - the Fresh Open Source Software Archive

Member "administrator/components/com_admin/sql/updates/postgresql/4.0.0-2018-07-29.sql" (13 Sep 2021, 10758 Bytes) of package /linux/www/Joomla_4.0.3-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 INSERT INTO "#__extensions" ("package_id", "name", "type", "element", "folder", "client_id", "enabled", "access", "protected", "manifest_cache", "params", "custom_data", "checked_out", "checked_out_time", "ordering", "state") VALUES
    2 (0, 'plg_extension_finder', 'plugin', 'finder', 'extension', 0, 1, 1, 0, '', '', '', 0, '1970-01-01 00:00:00', 0, 0);
    3 
    4 TRUNCATE TABLE "#__finder_filters";
    5 ALTER TABLE "#__finder_filters" ALTER COLUMN "created_by" SET DEFAULT 0;
    6 ALTER TABLE "#__finder_filters" ALTER COLUMN "created_by_alias" SET DEFAULT '';
    7 ALTER TABLE "#__finder_filters" ALTER COLUMN "created" DROP DEFAULT;
    8 ALTER TABLE "#__finder_filters" ALTER COLUMN "modified" DROP DEFAULT;
    9 ALTER TABLE "#__finder_filters" ALTER COLUMN "checked_out_time" DROP NOT NULL;
   10 ALTER TABLE "#__finder_filters" ALTER COLUMN "checked_out_time" DROP DEFAULT;
   11 
   12 TRUNCATE TABLE "#__finder_links";
   13 ALTER TABLE "#__finder_links" ALTER COLUMN "route" TYPE character varying(400);
   14 ALTER TABLE "#__finder_links" ALTER COLUMN "state" SET NOT NULL;
   15 ALTER TABLE "#__finder_links" ALTER COLUMN "access" SET NOT NULL;
   16 ALTER TABLE "#__finder_links" ALTER COLUMN "language" TYPE character varying(7);
   17 ALTER TABLE "#__finder_links" ALTER COLUMN "language" SET DEFAULT '';
   18 ALTER TABLE "#__finder_links" ALTER COLUMN "indexdate" DROP DEFAULT;
   19 ALTER TABLE "#__finder_links" ALTER COLUMN "publish_start_date" DROP NOT NULL;
   20 ALTER TABLE "#__finder_links" ALTER COLUMN "publish_start_date" DROP DEFAULT;
   21 ALTER TABLE "#__finder_links" ALTER COLUMN "publish_end_date" DROP NOT NULL;
   22 ALTER TABLE "#__finder_links" ALTER COLUMN "publish_end_date" DROP DEFAULT;
   23 ALTER TABLE "#__finder_links" ALTER COLUMN "start_date" DROP NOT NULL;
   24 ALTER TABLE "#__finder_links" ALTER COLUMN "start_date" DROP DEFAULT;
   25 ALTER TABLE "#__finder_links" ALTER COLUMN "end_date" DROP NOT NULL;
   26 ALTER TABLE "#__finder_links" ALTER COLUMN "end_date" DROP DEFAULT;
   27 CREATE INDEX "#__finder_links_idx_language" on "#__finder_links" ("language");
   28 
   29 CREATE TABLE "#__finder_links_terms" (
   30     "link_id" bigint NOT NULL,
   31     "term_id" bigint NOT NULL,
   32     "weight" REAL NOT NULL DEFAULT 0,
   33     PRIMARY KEY ("link_id", "term_id")
   34 );
   35 CREATE INDEX "#__finder_links_terms_idx_term_weight" on "#__finder_links_terms" ("term_id", "weight");
   36 CREATE INDEX "#__finder_links_terms_idx_link_term_weight" on "#__finder_links_terms" ("link_id", "term_id", "weight");
   37 
   38 DROP TABLE "#__finder_links_terms0" CASCADE;
   39 DROP TABLE "#__finder_links_terms1" CASCADE;
   40 DROP TABLE "#__finder_links_terms2" CASCADE;
   41 DROP TABLE "#__finder_links_terms3" CASCADE;
   42 DROP TABLE "#__finder_links_terms4" CASCADE;
   43 DROP TABLE "#__finder_links_terms5" CASCADE;
   44 DROP TABLE "#__finder_links_terms6" CASCADE;
   45 DROP TABLE "#__finder_links_terms7" CASCADE;
   46 DROP TABLE "#__finder_links_terms8" CASCADE;
   47 DROP TABLE "#__finder_links_terms9" CASCADE;
   48 DROP TABLE "#__finder_links_termsa" CASCADE;
   49 DROP TABLE "#__finder_links_termsb" CASCADE;
   50 DROP TABLE "#__finder_links_termsc" CASCADE;
   51 DROP TABLE "#__finder_links_termsd" CASCADE;
   52 DROP TABLE "#__finder_links_termse" CASCADE;
   53 DROP TABLE "#__finder_links_termsf" CASCADE;
   54 
   55 CREATE TABLE IF NOT EXISTS "#__finder_logging" (
   56   "searchterm" character varying(255) NOT NULL DEFAULT '',
   57   "md5sum" character varying(32) NOT NULL DEFAULT '',
   58   "query" bytea NOT NULL,
   59   "hits" integer NOT NULL DEFAULT 1,
   60   "results" integer NOT NULL DEFAULT 0,
   61   PRIMARY KEY ("md5sum")
   62 );
   63 CREATE INDEX "#__finder_logging_idx_md5sum" on "#__finder_logging" ("md5sum");
   64 CREATE INDEX "#__finder_logging_idx_searchterm" on "#__finder_logging" ("searchterm");
   65 
   66 DROP TABLE "#__finder_taxonomy";
   67 CREATE TABLE IF NOT EXISTS "#__finder_taxonomy" (
   68   "id" serial NOT NULL,
   69   "parent_id" integer DEFAULT 0 NOT NULL,
   70   "lft" integer DEFAULT 0 NOT NULL,
   71   "rgt" integer DEFAULT 0 NOT NULL,
   72   "level" integer DEFAULT 0 NOT NULL,
   73   "path" VARCHAR(400) NOT NULL DEFAULT '',
   74   "title" VARCHAR(255) NOT NULL DEFAULT '',
   75   "alias" VARCHAR(400) NOT NULL DEFAULT '',
   76   "state" smallint DEFAULT 1 NOT NULL,
   77   "access" smallint DEFAULT 1 NOT NULL,
   78   "language" varchar(7) DEFAULT '' NOT NULL,
   79   PRIMARY KEY ("id")
   80 );
   81 CREATE INDEX "#__finder_taxonomy_state" on "#__finder_taxonomy" ("state");
   82 CREATE INDEX "#__finder_taxonomy_access" on "#__finder_taxonomy" ("access");
   83 CREATE INDEX "#__finder_taxonomy_path" on "#__finder_taxonomy" ("path");
   84 CREATE INDEX "#__finder_taxonomy_lft_rgt" on "#__finder_taxonomy" ("lft", "rgt");
   85 CREATE INDEX "#__finder_taxonomy_alias" on "#__finder_taxonomy" ("alias");
   86 CREATE INDEX "#__finder_taxonomy_language" on "#__finder_taxonomy" ("language");
   87 CREATE INDEX "#__finder_taxonomy_idx_parent_published" on "#__finder_taxonomy" ("parent_id", "state", "access");
   88 INSERT INTO "#__finder_taxonomy" ("id", "parent_id", "lft", "rgt", "level", "path", "title", "alias", "state", "access", "language") VALUES
   89 (1, 0, 0, 1, 0, '', 'ROOT', 'root', 1, 1, '*');
   90 SELECT setval('#__finder_taxonomy_id_seq', 2, false);
   91 
   92 TRUNCATE TABLE "#__finder_taxonomy_map";
   93 
   94 TRUNCATE TABLE "#__finder_terms";
   95 ALTER TABLE "#__finder_terms" ALTER COLUMN "language" TYPE character varying(7);
   96 ALTER TABLE "#__finder_terms" ALTER COLUMN "language" SET DEFAULT '';
   97 ALTER TABLE "#__finder_terms" ALTER COLUMN "stem" SET DEFAULT '';
   98 ALTER TABLE "#__finder_terms" ALTER COLUMN "soundex" SET DEFAULT '';
   99 CREATE INDEX "#__finder_terms_idx_stem" on "#__finder_terms" ("stem");
  100 CREATE INDEX "#__finder_terms_idx_language" on "#__finder_terms" ("language");
  101 ALTER TABLE "#__finder_terms" DROP CONSTRAINT "#__finder_terms_idx_term";
  102 ALTER TABLE "#__finder_terms" ADD CONSTRAINT "#__finder_terms_idx_term_language" UNIQUE ("term", "language");
  103 
  104 DROP TABLE IF EXISTS "#__finder_terms_common";
  105 CREATE TABLE "#__finder_terms_common" (
  106   "term" varchar(75) NOT NULL,
  107   "language" varchar(7) DEFAULT '' NOT NULL,
  108   "custom" integer DEFAULT 0 NOT NULL,
  109   CONSTRAINT "#__finder_terms_common_idx_term_language" UNIQUE ("term", "language")
  110 );
  111 CREATE INDEX "#__finder_terms_common_idx_lang" on "#__finder_terms_common" ("language");
  112 INSERT INTO "#__finder_terms_common" ("term", "language", "custom") VALUES
  113     ('i', 'en', 0),
  114     ('me', 'en', 0),
  115     ('my', 'en', 0),
  116     ('myself', 'en', 0),
  117     ('we', 'en', 0),
  118     ('our', 'en', 0),
  119     ('ours', 'en', 0),
  120     ('ourselves', 'en', 0),
  121     ('you', 'en', 0),
  122     ('your', 'en', 0),
  123     ('yours', 'en', 0),
  124     ('yourself', 'en', 0),
  125     ('yourselves', 'en', 0),
  126     ('he', 'en', 0),
  127     ('him', 'en', 0),
  128     ('his', 'en', 0),
  129     ('himself', 'en', 0),
  130     ('she', 'en', 0),
  131     ('her', 'en', 0),
  132     ('hers', 'en', 0),
  133     ('herself', 'en', 0),
  134     ('it', 'en', 0),
  135     ('its', 'en', 0),
  136     ('itself', 'en', 0),
  137     ('they', 'en', 0),
  138     ('them', 'en', 0),
  139     ('their', 'en', 0),
  140     ('theirs', 'en', 0),
  141     ('themselves', 'en', 0),
  142     ('what', 'en', 0),
  143     ('which', 'en', 0),
  144     ('who', 'en', 0),
  145     ('whom', 'en', 0),
  146     ('this', 'en', 0),
  147     ('that', 'en', 0),
  148     ('these', 'en', 0),
  149     ('those', 'en', 0),
  150     ('am', 'en', 0),
  151     ('is', 'en', 0),
  152     ('are', 'en', 0),
  153     ('was', 'en', 0),
  154     ('were', 'en', 0),
  155     ('be', 'en', 0),
  156     ('been', 'en', 0),
  157     ('being', 'en', 0),
  158     ('have', 'en', 0),
  159     ('has', 'en', 0),
  160     ('had', 'en', 0),
  161     ('having', 'en', 0),
  162     ('do', 'en', 0),
  163     ('does', 'en', 0),
  164     ('did', 'en', 0),
  165     ('doing', 'en', 0),
  166     ('would', 'en', 0),
  167     ('should', 'en', 0),
  168     ('could', 'en', 0),
  169     ('ought', 'en', 0),
  170     ('i''m', 'en', 0),
  171     ('you''re', 'en', 0),
  172     ('he''s', 'en', 0),
  173     ('she''s', 'en', 0),
  174     ('it''s', 'en', 0),
  175     ('we''re', 'en', 0),
  176     ('they''re', 'en', 0),
  177     ('i''ve', 'en', 0),
  178     ('you''ve', 'en', 0),
  179     ('we''ve', 'en', 0),
  180     ('they''ve', 'en', 0),
  181     ('i''d', 'en', 0),
  182     ('you''d', 'en', 0),
  183     ('he''d', 'en', 0),
  184     ('she''d', 'en', 0),
  185     ('we''d', 'en', 0),
  186     ('they''d', 'en', 0),
  187     ('i''ll', 'en', 0),
  188     ('you''ll', 'en', 0),
  189     ('he''ll', 'en', 0),
  190     ('she''ll', 'en', 0),
  191     ('we''ll', 'en', 0),
  192     ('they''ll', 'en', 0),
  193     ('isn''t', 'en', 0),
  194     ('aren''t', 'en', 0),
  195     ('wasn''t', 'en', 0),
  196     ('weren''t', 'en', 0),
  197     ('hasn''t', 'en', 0),
  198     ('haven''t', 'en', 0),
  199     ('hadn''t', 'en', 0),
  200     ('doesn''t', 'en', 0),
  201     ('don''t', 'en', 0),
  202     ('didn''t', 'en', 0),
  203     ('won''t', 'en', 0),
  204     ('wouldn''t', 'en', 0),
  205     ('shan''t', 'en', 0),
  206     ('shouldn''t', 'en', 0),
  207     ('can''t', 'en', 0),
  208     ('cannot', 'en', 0),
  209     ('couldn''t', 'en', 0),
  210     ('mustn''t', 'en', 0),
  211     ('let''s', 'en', 0),
  212     ('that''s', 'en', 0),
  213     ('who''s', 'en', 0),
  214     ('what''s', 'en', 0),
  215     ('here''s', 'en', 0),
  216     ('there''s', 'en', 0),
  217     ('when''s', 'en', 0),
  218     ('where''s', 'en', 0),
  219     ('why''s', 'en', 0),
  220     ('how''s', 'en', 0),
  221     ('a', 'en', 0),
  222     ('an', 'en', 0),
  223     ('the', 'en', 0),
  224     ('and', 'en', 0),
  225     ('but', 'en', 0),
  226     ('if', 'en', 0),
  227     ('or', 'en', 0),
  228     ('because', 'en', 0),
  229     ('as', 'en', 0),
  230     ('until', 'en', 0),
  231     ('while', 'en', 0),
  232     ('of', 'en', 0),
  233     ('at', 'en', 0),
  234     ('by', 'en', 0),
  235     ('for', 'en', 0),
  236     ('with', 'en', 0),
  237     ('about', 'en', 0),
  238     ('against', 'en', 0),
  239     ('between', 'en', 0),
  240     ('into', 'en', 0),
  241     ('through', 'en', 0),
  242     ('during', 'en', 0),
  243     ('before', 'en', 0),
  244     ('after', 'en', 0),
  245     ('above', 'en', 0),
  246     ('below', 'en', 0),
  247     ('to', 'en', 0),
  248     ('from', 'en', 0),
  249     ('up', 'en', 0),
  250     ('down', 'en', 0),
  251     ('in', 'en', 0),
  252     ('out', 'en', 0),
  253     ('on', 'en', 0),
  254     ('off', 'en', 0),
  255     ('over', 'en', 0),
  256     ('under', 'en', 0),
  257     ('again', 'en', 0),
  258     ('further', 'en', 0),
  259     ('then', 'en', 0),
  260     ('once', 'en', 0),
  261     ('here', 'en', 0),
  262     ('there', 'en', 0),
  263     ('when', 'en', 0),
  264     ('where', 'en', 0),
  265     ('why', 'en', 0),
  266     ('how', 'en', 0),
  267     ('all', 'en', 0),
  268     ('any', 'en', 0),
  269     ('both', 'en', 0),
  270     ('each', 'en', 0),
  271     ('few', 'en', 0),
  272     ('more', 'en', 0),
  273     ('most', 'en', 0),
  274     ('other', 'en', 0),
  275     ('some', 'en', 0),
  276     ('such', 'en', 0),
  277     ('no', 'en', 0),
  278     ('nor', 'en', 0),
  279     ('not', 'en', 0),
  280     ('only', 'en', 0),
  281     ('own', 'en', 0),
  282     ('same', 'en', 0),
  283     ('so', 'en', 0),
  284     ('than', 'en', 0),
  285     ('too', 'en', 0),
  286     ('very', 'en', 0);
  287 
  288 TRUNCATE TABLE "#__finder_tokens";
  289 ALTER TABLE "#__finder_tokens" ALTER COLUMN "language" TYPE character varying(7);
  290 ALTER TABLE "#__finder_tokens" ALTER COLUMN "language" SET DEFAULT '';
  291 ALTER TABLE "#__finder_tokens" ALTER COLUMN "stem" SET DEFAULT '';
  292 CREATE INDEX "#__finder_tokens_idx_stem" on "#__finder_tokens" ("stem");
  293 CREATE INDEX "#__finder_tokens_idx_language" on "#__finder_tokens" ("language");
  294 
  295 TRUNCATE TABLE "#__finder_tokens_aggregate";
  296 ALTER TABLE "#__finder_tokens_aggregate" ALTER COLUMN "language" TYPE character varying(7);
  297 ALTER TABLE "#__finder_tokens_aggregate" ALTER COLUMN "language" SET DEFAULT '';
  298 ALTER TABLE "#__finder_tokens_aggregate" DROP COLUMN "map_suffix";
  299 ALTER TABLE "#__finder_tokens_aggregate" ALTER COLUMN "stem" SET DEFAULT '';
  300 ALTER TABLE "#__finder_tokens_aggregate" ALTER COLUMN "term_weight" SET DEFAULT 0;
  301 ALTER TABLE "#__finder_tokens_aggregate" ALTER COLUMN "context_weight" SET DEFAULT 0;
  302 ALTER TABLE "#__finder_tokens_aggregate" ALTER COLUMN "total_weight" SET DEFAULT 0;
  303 
  304 ALTER TABLE "#__finder_types" ALTER COLUMN "mime" SET DEFAULT '';