1-- 2-- Table: #__finder_filters 3-- 4CREATE TABLE "#__finder_filters" ( 5 "filter_id" serial NOT NULL, 6 "title" character varying(255) NOT NULL, 7 "alias" character varying(255) NOT NULL, 8 "state" smallint DEFAULT 1 NOT NULL, 9 "created" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 10 "created_by" integer NOT NULL, 11 "created_by_alias" character varying(255) NOT NULL, 12 "modified" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 13 "modified_by" integer DEFAULT 0 NOT NULL, 14 "checked_out" integer DEFAULT 0 NOT NULL, 15 "checked_out_time" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 16 "map_count" integer DEFAULT 0 NOT NULL, 17 "data" text NOT NULL, 18 "params" text, 19 PRIMARY KEY ("filter_id") 20); 21 22-- 23-- Table: #__finder_links 24-- 25CREATE TABLE "#__finder_links" ( 26 "link_id" serial NOT NULL, 27 "url" character varying(255) NOT NULL, 28 "route" character varying(255) NOT NULL, 29 "title" character varying(255) DEFAULT NULL, 30 "description" character varying(255) DEFAULT NULL, 31 "indexdate" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 32 "md5sum" character varying(32) DEFAULT NULL, 33 "published" smallint DEFAULT 1 NOT NULL, 34 "state" integer DEFAULT 1, 35 "access" integer DEFAULT 0, 36 "language" character varying(8) NOT NULL, 37 "publish_start_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 38 "publish_end_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 39 "start_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 40 "end_date" timestamp without time zone DEFAULT '1970-01-01 00:00:00' NOT NULL, 41 "list_price" numeric(8,2) DEFAULT 0 NOT NULL, 42 "sale_price" numeric(8,2) DEFAULT 0 NOT NULL, 43 "type_id" bigint NOT NULL, 44 "object" bytea NOT NULL, 45 PRIMARY KEY ("link_id") 46); 47CREATE INDEX "#__finder_links_idx_type" on "#__finder_links" ("type_id"); 48CREATE INDEX "#__finder_links_idx_title" on "#__finder_links" ("title"); 49CREATE INDEX "#__finder_links_idx_md5" on "#__finder_links" ("md5sum"); 50CREATE INDEX "#__finder_links_idx_url" on "#__finder_links" (url(75)); 51CREATE INDEX "#__finder_links_idx_published_list" on "#__finder_links" ("published", "state", "access", "publish_start_date", "publish_end_date", "list_price"); 52CREATE INDEX "#__finder_links_idx_published_sale" on "#__finder_links" ("published", "state", "access", "publish_start_date", "publish_end_date", "sale_price"); 53 54-- 55-- Table: #__finder_links_terms0 56-- 57CREATE TABLE "#__finder_links_terms0" ( 58 "link_id" integer NOT NULL, 59 "term_id" integer NOT NULL, 60 "weight" numeric(8,2) NOT NULL, 61 PRIMARY KEY ("link_id", "term_id") 62); 63CREATE INDEX "#__finder_links_terms0_idx_term_weight" on "#__finder_links_terms0" ("term_id", "weight"); 64CREATE INDEX "#__finder_links_terms0_idx_link_term_weight" on "#__finder_links_terms0" ("link_id", "term_id", "weight"); 65 66-- 67-- Table: #__finder_links_terms1 68-- 69CREATE TABLE "#__finder_links_terms1" ( 70 "link_id" integer NOT NULL, 71 "term_id" integer NOT NULL, 72 "weight" numeric(8,2) NOT NULL, 73 PRIMARY KEY ("link_id", "term_id") 74); 75CREATE INDEX "#__finder_links_terms1_idx_term_weight" on "#__finder_links_terms1" ("term_id", "weight"); 76CREATE INDEX "#__finder_links_terms1_idx_link_term_weight" on "#__finder_links_terms1" ("link_id", "term_id", "weight"); 77 78-- 79-- Table: #__finder_links_terms2 80-- 81CREATE TABLE "#__finder_links_terms2" ( 82 "link_id" integer NOT NULL, 83 "term_id" integer NOT NULL, 84 "weight" numeric(8,2) NOT NULL, 85 PRIMARY KEY ("link_id", "term_id") 86); 87CREATE INDEX "#__finder_links_terms2_idx_term_weight" on "#__finder_links_terms2" ("term_id", "weight"); 88CREATE INDEX "#__finder_links_terms2_idx_link_term_weight" on "#__finder_links_terms2" ("link_id", "term_id", "weight"); 89 90-- 91-- Table: #__finder_links_terms3 92-- 93CREATE TABLE "#__finder_links_terms3" ( 94 "link_id" integer NOT NULL, 95 "term_id" integer NOT NULL, 96 "weight" numeric(8,2) NOT NULL, 97 PRIMARY KEY ("link_id", "term_id") 98); 99CREATE INDEX "#__finder_links_terms3_idx_term_weight" on "#__finder_links_terms3" ("term_id", "weight"); 100CREATE INDEX "#__finder_links_terms3_idx_link_term_weight" on "#__finder_links_terms3" ("link_id", "term_id", "weight"); 101 102-- 103-- Table: #__finder_links_terms4 104-- 105CREATE TABLE "#__finder_links_terms4" ( 106 "link_id" integer NOT NULL, 107 "term_id" integer NOT NULL, 108 "weight" numeric(8,2) NOT NULL, 109 PRIMARY KEY ("link_id", "term_id") 110); 111CREATE INDEX "#__finder_links_terms4_idx_term_weight" on "#__finder_links_terms4" ("term_id", "weight"); 112CREATE INDEX "#__finder_links_terms4_idx_link_term_weight" on "#__finder_links_terms4" ("link_id", "term_id", "weight"); 113 114-- 115-- Table: #__finder_links_terms5 116-- 117CREATE TABLE "#__finder_links_terms5" ( 118 "link_id" integer NOT NULL, 119 "term_id" integer NOT NULL, 120 "weight" numeric(8,2) NOT NULL, 121 PRIMARY KEY ("link_id", "term_id") 122); 123CREATE INDEX "#__finder_links_terms5_idx_term_weight" on "#__finder_links_terms5" ("term_id", "weight"); 124CREATE INDEX "#__finder_links_terms5_idx_link_term_weight" on "#__finder_links_terms5" ("link_id", "term_id", "weight"); 125 126-- 127-- Table: #__finder_links_terms6 128-- 129CREATE TABLE "#__finder_links_terms6" ( 130 "link_id" integer NOT NULL, 131 "term_id" integer NOT NULL, 132 "weight" numeric(8,2) NOT NULL, 133 PRIMARY KEY ("link_id", "term_id") 134); 135CREATE INDEX "#__finder_links_terms6_idx_term_weight" on "#__finder_links_terms6" ("term_id", "weight"); 136CREATE INDEX "#__finder_links_terms6_idx_link_term_weight" on "#__finder_links_terms6" ("link_id", "term_id", "weight"); 137 138-- 139-- Table: #__finder_links_terms7 140-- 141CREATE TABLE "#__finder_links_terms7" ( 142 "link_id" integer NOT NULL, 143 "term_id" integer NOT NULL, 144 "weight" numeric(8,2) NOT NULL, 145 PRIMARY KEY ("link_id", "term_id") 146); 147CREATE INDEX "#__finder_links_terms7_idx_term_weight" on "#__finder_links_terms7" ("term_id", "weight"); 148CREATE INDEX "#__finder_links_terms7_idx_link_term_weight" on "#__finder_links_terms7" ("link_id", "term_id", "weight"); 149 150-- 151-- Table: #__finder_links_terms8 152-- 153CREATE TABLE "#__finder_links_terms8" ( 154 "link_id" integer NOT NULL, 155 "term_id" integer NOT NULL, 156 "weight" numeric(8,2) NOT NULL, 157 PRIMARY KEY ("link_id", "term_id") 158); 159CREATE INDEX "#__finder_links_terms8_idx_term_weight" on "#__finder_links_terms8" ("term_id", "weight"); 160CREATE INDEX "#__finder_links_terms8_idx_link_term_weight" on "#__finder_links_terms8" ("link_id", "term_id", "weight"); 161 162-- 163-- Table: #__finder_links_terms9 164-- 165CREATE TABLE "#__finder_links_terms9" ( 166 "link_id" integer NOT NULL, 167 "term_id" integer NOT NULL, 168 "weight" numeric(8,2) NOT NULL, 169 PRIMARY KEY ("link_id", "term_id") 170); 171CREATE INDEX "#__finder_links_terms9_idx_term_weight" on "#__finder_links_terms9" ("term_id", "weight"); 172CREATE INDEX "#__finder_links_terms9_idx_link_term_weight" on "#__finder_links_terms9" ("link_id", "term_id", "weight"); 173 174-- 175-- Table: #__finder_links_termsa 176-- 177CREATE TABLE "#__finder_links_termsa" ( 178 "link_id" integer NOT NULL, 179 "term_id" integer NOT NULL, 180 "weight" numeric(8,2) NOT NULL, 181 PRIMARY KEY ("link_id", "term_id") 182); 183CREATE INDEX "#__finder_links_termsa_idx_term_weight" on "#__finder_links_termsa" ("term_id", "weight"); 184CREATE INDEX "#__finder_links_termsa_idx_link_term_weight" on "#__finder_links_termsa" ("link_id", "term_id", "weight"); 185 186-- 187-- Table: #__finder_links_termsb 188-- 189CREATE TABLE "#__finder_links_termsb" ( 190 "link_id" integer NOT NULL, 191 "term_id" integer NOT NULL, 192 "weight" numeric(8,2) NOT NULL, 193 PRIMARY KEY ("link_id", "term_id") 194); 195CREATE INDEX "#__finder_links_termsb_idx_term_weight" on "#__finder_links_termsb" ("term_id", "weight"); 196CREATE INDEX "#__finder_links_termsb_idx_link_term_weight" on "#__finder_links_termsb" ("link_id", "term_id", "weight"); 197 198-- 199-- Table: #__finder_links_termsc 200-- 201CREATE TABLE "#__finder_links_termsc" ( 202 "link_id" integer NOT NULL, 203 "term_id" integer NOT NULL, 204 "weight" numeric(8,2) NOT NULL, 205 PRIMARY KEY ("link_id", "term_id") 206); 207CREATE INDEX "#__finder_links_termsc_idx_term_weight" on "#__finder_links_termsc" ("term_id", "weight"); 208CREATE INDEX "#__finder_links_termsc_idx_link_term_weight" on "#__finder_links_termsc" ("link_id", "term_id", "weight"); 209 210-- 211-- Table: #__finder_links_termsd 212-- 213CREATE TABLE "#__finder_links_termsd" ( 214 "link_id" integer NOT NULL, 215 "term_id" integer NOT NULL, 216 "weight" numeric(8,2) NOT NULL, 217 PRIMARY KEY ("link_id", "term_id") 218); 219CREATE INDEX "#__finder_links_termsd_idx_term_weight" on "#__finder_links_termsd" ("term_id", "weight"); 220CREATE INDEX "#__finder_links_termsd_idx_link_term_weight" on "#__finder_links_termsd" ("link_id", "term_id", "weight"); 221 222-- 223-- Table: #__finder_links_termse 224-- 225CREATE TABLE "#__finder_links_termse" ( 226 "link_id" integer NOT NULL, 227 "term_id" integer NOT NULL, 228 "weight" numeric(8,2) NOT NULL, 229 PRIMARY KEY ("link_id", "term_id") 230); 231CREATE INDEX "#__finder_links_termse_idx_term_weight" on "#__finder_links_termse" ("term_id", "weight"); 232CREATE INDEX "#__finder_links_termse_idx_link_term_weight" on "#__finder_links_termse" ("link_id", "term_id", "weight"); 233 234-- 235-- Table: #__finder_links_termsf 236-- 237CREATE TABLE "#__finder_links_termsf" ( 238 "link_id" integer NOT NULL, 239 "term_id" integer NOT NULL, 240 "weight" numeric(8,2) NOT NULL, 241 PRIMARY KEY ("link_id", "term_id") 242); 243CREATE INDEX "#__finder_links_termsf_idx_term_weight" on "#__finder_links_termsf" ("term_id", "weight"); 244CREATE INDEX "#__finder_links_termsf_idx_link_term_weight" on "#__finder_links_termsf" ("link_id", "term_id", "weight"); 245 246-- 247-- Table: #__finder_taxonomy 248-- 249CREATE TABLE "#__finder_taxonomy" ( 250 "id" serial NOT NULL, 251 "parent_id" integer DEFAULT 0 NOT NULL, 252 "title" character varying(255) NOT NULL, 253 "state" smallint DEFAULT 1 NOT NULL, 254 "access" smallint DEFAULT 0 NOT NULL, 255 "ordering" smallint DEFAULT 0 NOT NULL, 256 PRIMARY KEY ("id") 257); 258CREATE INDEX "#__finder_taxonomy_parent_id" on "#__finder_taxonomy" ("parent_id"); 259CREATE INDEX "#__finder_taxonomy_state" on "#__finder_taxonomy" ("state"); 260CREATE INDEX "#__finder_taxonomy_ordering" on "#__finder_taxonomy" ("ordering"); 261CREATE INDEX "#__finder_taxonomy_access" on "#__finder_taxonomy" ("access"); 262CREATE INDEX "#__finder_taxonomy_idx_parent_published" on "#__finder_taxonomy" ("parent_id", "state", "access"); 263 264-- 265-- Dumping data for table #__finder_taxonomy 266-- 267UPDATE "#__finder_taxonomy" SET ("id", "parent_id", "title", "state", "access", "ordering") = (1, 0, 'ROOT', 0, 0, 0) 268WHERE "id"=1; 269 270INSERT INTO "#__finder_taxonomy" ("id", "parent_id", "title", "state", "access", "ordering") 271SELECT 1, 0, 'ROOT', 0, 0, 0 WHERE 1 NOT IN 272(SELECT 1 FROM "#__finder_taxonomy" WHERE "id"=1); 273 274 275 276-- 277-- Table: #__finder_taxonomy_map 278-- 279CREATE TABLE "#__finder_taxonomy_map" ( 280 "link_id" integer NOT NULL, 281 "node_id" integer NOT NULL, 282 PRIMARY KEY ("link_id", "node_id") 283); 284CREATE INDEX "#__finder_taxonomy_map_link_id" on "#__finder_taxonomy_map" ("link_id"); 285CREATE INDEX "#__finder_taxonomy_map_node_id" on "#__finder_taxonomy_map" ("node_id"); 286 287-- 288-- Table: #__finder_terms 289-- 290CREATE TABLE "#__finder_terms" ( 291 "term_id" serial NOT NULL, 292 "term" character varying(75) NOT NULL, 293 "stem" character varying(75) NOT NULL, 294 "common" smallint DEFAULT 0 NOT NULL, 295 "phrase" smallint DEFAULT 0 NOT NULL, 296 "weight" numeric(8,2) DEFAULT 0 NOT NULL, 297 "soundex" character varying(75) NOT NULL, 298 "links" integer DEFAULT 0 NOT NULL, 299 PRIMARY KEY ("term_id"), 300 CONSTRAINT "#__finder_terms_idx_term" UNIQUE ("term") 301); 302CREATE INDEX "#__finder_terms_idx_term_phrase" on "#__finder_terms" ("term", "phrase"); 303CREATE INDEX "#__finder_terms_idx_stem_phrase" on "#__finder_terms" ("stem", "phrase"); 304CREATE INDEX "#__finder_terms_idx_soundex_phrase" on "#__finder_terms" ("soundex", "phrase"); 305 306-- 307-- Table: #__finder_terms_common 308-- 309CREATE TABLE "#__finder_terms_common" ( 310 "term" character varying(75) NOT NULL, 311 "language" character varying(3) NOT NULL 312); 313CREATE INDEX "#__finder_terms_common_idx_word_lang" on "#__finder_terms_common" ("term", "language"); 314CREATE INDEX "#__finder_terms_common_idx_lang" on "#__finder_terms_common" ("language"); 315 316 317-- 318-- Dumping data for table `#__finder_terms_common` 319-- 320 321-- 322UPDATE "#__finder_terms_common" SET ("term", "language") = ('a', 'en') WHERE "term"='a'; 323 324INSERT INTO "#__finder_terms_common" ("term", "language") 325SELECT 'a', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='a'); 326 327-- 328UPDATE "#__finder_terms_common" SET ("term", "language") = ('about', 'en') WHERE "term"='about'; 329 330INSERT INTO "#__finder_terms_common" ("term", "language") 331SELECT 'about', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='about'); 332 333-- 334UPDATE "#__finder_terms_common" SET ("term", "language") = ('after', 'en') WHERE "term"='after'; 335 336INSERT INTO "#__finder_terms_common" ("term", "language") 337SELECT 'after', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='after'); 338 339-- 340UPDATE "#__finder_terms_common" SET ("term", "language") = ('ago', 'en') WHERE "term"='ago'; 341 342INSERT INTO "#__finder_terms_common" ("term", "language") 343SELECT 'ago', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='ago'); 344 345-- 346UPDATE "#__finder_terms_common" SET ("term", "language") = ('all', 'en') WHERE "term"='all'; 347 348INSERT INTO "#__finder_terms_common" ("term", "language") 349SELECT 'all', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='all'); 350 351-- 352UPDATE "#__finder_terms_common" SET ("term", "language") = ('am', 'en') WHERE "term"='am'; 353 354INSERT INTO "#__finder_terms_common" ("term", "language") 355SELECT 'am', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='am'); 356 357-- 358UPDATE "#__finder_terms_common" SET ("term", "language") = ('an', 'en') WHERE "term"='an'; 359 360INSERT INTO "#__finder_terms_common" ("term", "language") 361SELECT 'an', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='an'); 362 363-- 364UPDATE "#__finder_terms_common" SET ("term", "language") = ('and', 'en') WHERE "term"='and'; 365 366INSERT INTO "#__finder_terms_common" ("term", "language") 367SELECT 'and', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='and'); 368 369-- 370UPDATE "#__finder_terms_common" SET ("term", "language") = ('any', 'en') WHERE "term"='any'; 371 372INSERT INTO "#__finder_terms_common" ("term", "language") 373SELECT 'any', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='any'); 374 375-- 376UPDATE "#__finder_terms_common" SET ("term", "language") = ('are', 'en') WHERE "term"='are'; 377 378INSERT INTO "#__finder_terms_common" ("term", "language") 379SELECT 'are', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='are'); 380 381-- 382UPDATE "#__finder_terms_common" SET ("term", "language") = ('aren''t', 'en') WHERE "term"='aren''t'; 383 384INSERT INTO "#__finder_terms_common" ("term", "language") 385SELECT 'aren''t', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='aren''t'); 386 387-- 388UPDATE "#__finder_terms_common" SET ("term", "language") = ('as', 'en') WHERE "term"='as'; 389 390INSERT INTO "#__finder_terms_common" ("term", "language") 391SELECT 'as', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='as'); 392 393-- 394UPDATE "#__finder_terms_common" SET ("term", "language") = ('at', 'en') WHERE "term"='at'; 395 396INSERT INTO "#__finder_terms_common" ("term", "language") 397SELECT 'at', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='at'); 398 399-- 400UPDATE "#__finder_terms_common" SET ("term", "language") = ('be', 'en') WHERE "term"='be'; 401 402INSERT INTO "#__finder_terms_common" ("term", "language") 403SELECT 'be', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='be'); 404 405-- 406UPDATE "#__finder_terms_common" SET ("term", "language") = ('but', 'en') WHERE "term"='but'; 407 408INSERT INTO "#__finder_terms_common" ("term", "language") 409SELECT 'but', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='but'); 410 411-- 412UPDATE "#__finder_terms_common" SET ("term", "language") = ('by', 'en') WHERE "term"='by'; 413 414INSERT INTO "#__finder_terms_common" ("term", "language") 415SELECT 'by', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='by'); 416 417-- 418UPDATE "#__finder_terms_common" SET ("term", "language") = ('for', 'en') WHERE "term"='for'; 419 420INSERT INTO "#__finder_terms_common" ("term", "language") SELECT 'for', 'en' WHERE 1 NOT IN 421(SELECT 1 FROM "#__finder_terms_common" WHERE "term"='for'); 422 423-- 424UPDATE "#__finder_terms_common" SET ("term", "language") = ('from', 'en') WHERE "term"='from'; 425 426INSERT INTO "#__finder_terms_common" ("term", "language") 427SELECT 'from', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='from'); 428 429-- 430UPDATE "#__finder_terms_common" SET ("term", "language") = ('get', 'en') WHERE "term"='get'; 431 432INSERT INTO "#__finder_terms_common" ("term", "language") 433SELECT 'get', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='get'); 434 435-- 436UPDATE "#__finder_terms_common" SET ("term", "language") = ('go', 'en') WHERE "term"='go'; 437 438INSERT INTO "#__finder_terms_common" ("term", "language") 439SELECT 'go', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='go'); 440 441-- 442UPDATE "#__finder_terms_common" SET ("term", "language") = ('how', 'en') WHERE "term"='how'; 443 444INSERT INTO "#__finder_terms_common" ("term", "language") 445SELECT 'how', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='how'); 446 447-- 448UPDATE "#__finder_terms_common" SET ("term", "language") = ('if', 'en') WHERE "term"='if'; 449 450INSERT INTO "#__finder_terms_common" ("term", "language") 451SELECT 'if', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='if'); 452 453-- 454UPDATE "#__finder_terms_common" SET ("term", "language") = ('in', 'en') WHERE "term"='in'; 455 456INSERT INTO "#__finder_terms_common" ("term", "language") 457SELECT 'in', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='in'); 458 459-- 460UPDATE "#__finder_terms_common" SET ("term", "language") = ('into', 'en') WHERE "term"='into'; 461 462INSERT INTO "#__finder_terms_common" ("term", "language") 463SELECT 'into', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='into'); 464 465-- 466UPDATE "#__finder_terms_common" SET ("term", "language") = ('is', 'en') WHERE "term"='is'; 467 468INSERT INTO "#__finder_terms_common" ("term", "language") 469SELECT 'is', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='is'); 470 471-- 472UPDATE "#__finder_terms_common" SET ("term", "language") = ('isn''t', 'en') WHERE "term"='isn''t'; 473 474INSERT INTO "#__finder_terms_common" ("term", "language") 475SELECT 'isn''t', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='isn''t'); 476 477-- 478UPDATE "#__finder_terms_common" SET ("term", "language") = ('it', 'en') WHERE "term"='it'; 479 480INSERT INTO "#__finder_terms_common" ("term", "language") 481SELECT 'it', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='it'); 482 483-- 484UPDATE "#__finder_terms_common" SET ("term", "language") = ('its', 'en') WHERE "term"='its'; 485 486INSERT INTO "#__finder_terms_common" ("term", "language") 487SELECT 'its', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='its'); 488 489-- 490UPDATE "#__finder_terms_common" SET ("term", "language") = ('me', 'en') WHERE "term"='me'; 491 492INSERT INTO "#__finder_terms_common" ("term", "language") 493SELECT 'me', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='me'); 494 495-- 496UPDATE "#__finder_terms_common" SET ("term", "language") = ('more', 'en') WHERE "term"='more'; 497 498INSERT INTO "#__finder_terms_common" ("term", "language") 499SELECT 'more', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='more'); 500 501-- 502UPDATE "#__finder_terms_common" SET ("term", "language") = ('most', 'en') WHERE "term"='most'; 503 504INSERT INTO "#__finder_terms_common" ("term", "language") 505SELECT 'most', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='most'); 506 507-- 508UPDATE "#__finder_terms_common" SET ("term", "language") = ('must', 'en') WHERE "term"='must'; 509 510INSERT INTO "#__finder_terms_common" ("term", "language") 511SELECT 'must', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='must'); 512 513-- 514UPDATE "#__finder_terms_common" SET ("term", "language") = ('my', 'en') WHERE "term"='my'; 515 516INSERT INTO "#__finder_terms_common" ("term", "language") 517SELECT 'my', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='my'); 518 519-- 520UPDATE "#__finder_terms_common" SET ("term", "language") = ('new', 'en') WHERE "term"='new'; 521 522INSERT INTO "#__finder_terms_common" ("term", "language") 523SELECT 'new', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='new'); 524 525-- 526UPDATE "#__finder_terms_common" SET ("term", "language") = ('no', 'en') WHERE "term"='no'; 527 528INSERT INTO "#__finder_terms_common" ("term", "language") 529SELECT 'no', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='no'); 530 531-- 532UPDATE "#__finder_terms_common" SET ("term", "language") = ('none', 'en') WHERE "term"='none'; 533 534INSERT INTO "#__finder_terms_common" ("term", "language") 535SELECT 'none', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='none'); 536 537-- 538UPDATE "#__finder_terms_common" SET ("term", "language") = ('not', 'en') WHERE "term"='not'; 539 540INSERT INTO "#__finder_terms_common" ("term", "language") 541SELECT 'not', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='not'); 542 543-- 544UPDATE "#__finder_terms_common" SET ("term", "language") = ('nothing', 'en') WHERE "term"='nothing'; 545 546INSERT INTO "#__finder_terms_common" ("term", "language") 547SELECT 'nothing', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='nothing'); 548 549-- 550UPDATE "#__finder_terms_common" SET ("term", "language") = ('of', 'en') WHERE "term"='of'; 551 552INSERT INTO "#__finder_terms_common" ("term", "language") 553SELECT 'of', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='of'); 554 555-- 556UPDATE "#__finder_terms_common" SET ("term", "language") = ('off', 'en') WHERE "term"='off'; 557 558INSERT INTO "#__finder_terms_common" ("term", "language") 559SELECT 'off', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='off'); 560 561-- 562UPDATE "#__finder_terms_common" SET ("term", "language") = ('often', 'en') WHERE "term"='often'; 563 564INSERT INTO "#__finder_terms_common" ("term", "language") 565SELECT 'often', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='often'); 566 567-- 568UPDATE "#__finder_terms_common" SET ("term", "language") = ('old', 'en') WHERE "term"='old'; 569 570INSERT INTO "#__finder_terms_common" ("term", "language") 571SELECT 'old', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='old'); 572 573-- 574UPDATE "#__finder_terms_common" SET ("term", "language") = ('on', 'en') WHERE "term"='on'; 575 576INSERT INTO "#__finder_terms_common" ("term", "language") 577SELECT 'on', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='on'); 578 579-- 580UPDATE "#__finder_terms_common" SET ("term", "language") = ('onc', 'en') WHERE "term"='onc'; 581 582INSERT INTO "#__finder_terms_common" ("term", "language") 583SELECT 'onc', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='onc'); 584 585-- 586UPDATE "#__finder_terms_common" SET ("term", "language") = ('once', 'en') WHERE "term"='once'; 587 588INSERT INTO "#__finder_terms_common" ("term", "language") 589SELECT 'once', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='once'); 590 591-- 592UPDATE "#__finder_terms_common" SET ("term", "language") = ('only', 'en') WHERE "term"='only'; 593 594INSERT INTO "#__finder_terms_common" ("term", "language") 595SELECT 'only', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='only'); 596 597-- 598UPDATE "#__finder_terms_common" SET ("term", "language") = ('or', 'en') WHERE "term"='or'; 599 600INSERT INTO "#__finder_terms_common" ("term", "language") 601SELECT 'or', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='or'); 602 603-- 604UPDATE "#__finder_terms_common" SET ("term", "language") = ('other', 'en') WHERE "term"='other'; 605 606INSERT INTO "#__finder_terms_common" ("term", "language") 607SELECT 'other', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='other'); 608 609-- 610UPDATE "#__finder_terms_common" SET ("term", "language") = ('our', 'en') WHERE "term"='our'; 611 612INSERT INTO "#__finder_terms_common" ("term", "language") 613SELECT 'our', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='our'); 614 615-- 616UPDATE "#__finder_terms_common" SET ("term", "language") = ('ours', 'en') WHERE "term"='ours'; 617 618INSERT INTO "#__finder_terms_common" ("term", "language") 619SELECT 'ours', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='ours'); 620 621-- 622UPDATE "#__finder_terms_common" SET ("term", "language") = ('out', 'en') WHERE "term"='out'; 623 624INSERT INTO "#__finder_terms_common" ("term", "language") 625SELECT 'out', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='out'); 626 627-- 628UPDATE "#__finder_terms_common" SET ("term", "language") = ('over', 'en') WHERE "term"='over'; 629 630INSERT INTO "#__finder_terms_common" ("term", "language") 631SELECT 'over', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='over'); 632 633-- 634UPDATE "#__finder_terms_common" SET ("term", "language") = ('page', 'en') WHERE "term"='page'; 635 636INSERT INTO "#__finder_terms_common" ("term", "language") 637SELECT 'page', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='page'); 638 639-- 640UPDATE "#__finder_terms_common" SET ("term", "language") = ('she', 'en') WHERE "term"='she'; 641 642INSERT INTO "#__finder_terms_common" ("term", "language") 643SELECT 'she', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='she'); 644 645-- 646UPDATE "#__finder_terms_common" SET ("term", "language") = ('should', 'en') WHERE "term"='should'; 647 648INSERT INTO "#__finder_terms_common" ("term", "language") 649SELECT 'should', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='should'); 650 651-- 652UPDATE "#__finder_terms_common" SET ("term", "language") = ('small', 'en') WHERE "term"='small'; 653 654INSERT INTO "#__finder_terms_common" ("term", "language") 655SELECT 'small', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='small'); 656 657-- 658UPDATE "#__finder_terms_common" SET ("term", "language") = ('so', 'en') WHERE "term"='so'; 659 660INSERT INTO "#__finder_terms_common" ("term", "language") 661SELECT 'so', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='so'); 662 663-- 664UPDATE "#__finder_terms_common" SET ("term", "language") = ('some', 'en') WHERE "term"='some'; 665 666INSERT INTO "#__finder_terms_common" ("term", "language") 667SELECT 'some', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='some'); 668 669-- 670UPDATE "#__finder_terms_common" SET ("term", "language") = ('than', 'en') WHERE "term"='than'; 671 672INSERT INTO "#__finder_terms_common" ("term", "language") 673SELECT 'than', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='than'); 674 675-- 676UPDATE "#__finder_terms_common" SET ("term", "language") = ('thank', 'en') WHERE "term"='thank'; 677 678INSERT INTO "#__finder_terms_common" ("term", "language") 679SELECT 'thank', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='thank'); 680 681-- 682UPDATE "#__finder_terms_common" SET ("term", "language") = ('that', 'en') WHERE "term"='that'; 683 684INSERT INTO "#__finder_terms_common" ("term", "language") 685SELECT 'that', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='that'); 686 687-- 688UPDATE "#__finder_terms_common" SET ("term", "language") = ('the', 'en') WHERE "term"='the'; 689 690INSERT INTO "#__finder_terms_common" ("term", "language") 691SELECT 'the', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='the'); 692 693-- 694UPDATE "#__finder_terms_common" SET ("term", "language") = ('their', 'en') WHERE "term"='their'; 695 696INSERT INTO "#__finder_terms_common" ("term", "language") 697SELECT 'their', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='their'); 698 699-- 700UPDATE "#__finder_terms_common" SET ("term", "language") = ('theirs', 'en') WHERE "term"='theirs'; 701 702INSERT INTO "#__finder_terms_common" ("term", "language") 703SELECT 'theirs', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='theirs'); 704 705-- 706UPDATE "#__finder_terms_common" SET ("term", "language") = ('them', 'en') WHERE "term"='them'; 707 708INSERT INTO "#__finder_terms_common" ("term", "language") 709SELECT 'them', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='them'); 710 711-- 712UPDATE "#__finder_terms_common" SET ("term", "language") = ('then', 'en') WHERE "term"='then'; 713 714INSERT INTO "#__finder_terms_common" ("term", "language") 715SELECT 'then', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='then'); 716 717-- 718UPDATE "#__finder_terms_common" SET ("term", "language") = ('there', 'en') WHERE "term"='there'; 719 720INSERT INTO "#__finder_terms_common" ("term", "language") 721SELECT 'there', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='there'); 722 723-- 724UPDATE "#__finder_terms_common" SET ("term", "language") = ('these', 'en') WHERE "term"='these'; 725 726INSERT INTO "#__finder_terms_common" ("term", "language") 727SELECT 'these', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='these'); 728 729-- 730UPDATE "#__finder_terms_common" SET ("term", "language") = ('they', 'en') WHERE "term"='they'; 731 732INSERT INTO "#__finder_terms_common" ("term", "language") 733SELECT 'they', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='they'); 734 735-- 736UPDATE "#__finder_terms_common" SET ("term", "language") = ('this', 'en') WHERE "term"='this'; 737 738INSERT INTO "#__finder_terms_common" ("term", "language") 739SELECT 'this', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='this'); 740 741-- 742UPDATE "#__finder_terms_common" SET ("term", "language") = ('those', 'en') WHERE "term"='those'; 743 744INSERT INTO "#__finder_terms_common" ("term", "language") 745SELECT 'those', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='those'); 746 747-- 748UPDATE "#__finder_terms_common" SET ("term", "language") = ('thus', 'en') WHERE "term"='thus'; 749 750INSERT INTO "#__finder_terms_common" ("term", "language") 751SELECT 'thus', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='thus'); 752 753-- 754UPDATE "#__finder_terms_common" SET ("term", "language") = ('time', 'en') WHERE "term"='time'; 755 756INSERT INTO "#__finder_terms_common" ("term", "language") 757SELECT 'time', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='time'); 758 759-- 760UPDATE "#__finder_terms_common" SET ("term", "language") = ('times', 'en') WHERE "term"='times'; 761 762INSERT INTO "#__finder_terms_common" ("term", "language") 763SELECT 'times', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='times'); 764 765-- 766UPDATE "#__finder_terms_common" SET ("term", "language") = ('to', 'en') WHERE "term"='to'; 767 768INSERT INTO "#__finder_terms_common" ("term", "language") 769SELECT 'to', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='to'); 770 771-- 772UPDATE "#__finder_terms_common" SET ("term", "language") = ('too', 'en') WHERE "term"='too'; 773 774INSERT INTO "#__finder_terms_common" ("term", "language") 775SELECT 'too', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='too'); 776 777-- 778UPDATE "#__finder_terms_common" SET ("term", "language") = ('true', 'en') WHERE "term"='true'; 779 780INSERT INTO "#__finder_terms_common" ("term", "language") 781SELECT 'true', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='true'); 782 783-- 784UPDATE "#__finder_terms_common" SET ("term", "language") = ('under', 'en')WHERE "term"='under'; 785 786INSERT INTO "#__finder_terms_common" ("term", "language") 787SELECT 'under', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='under'); 788 789-- 790UPDATE "#__finder_terms_common" SET ("term", "language") = ('until', 'en') WHERE "term"='until'; 791 792INSERT INTO "#__finder_terms_common" ("term", "language") 793SELECT 'until', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='until'); 794 795-- 796UPDATE "#__finder_terms_common" SET ("term", "language") = ('up', 'en') WHERE "term"='up'; 797 798INSERT INTO "#__finder_terms_common" ("term", "language") 799SELECT 'up', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='up'); 800 801-- 802UPDATE "#__finder_terms_common" SET ("term", "language") = ('upon', 'en') WHERE "term"='upon'; 803 804INSERT INTO "#__finder_terms_common" ("term", "language") 805SELECT 'upon', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='upon'); 806 807-- 808UPDATE "#__finder_terms_common" SET ("term", "language") = ('use', 'en') WHERE "term"='use'; 809 810INSERT INTO "#__finder_terms_common" ("term", "language") 811SELECT 'use', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='use'); 812 813-- 814UPDATE "#__finder_terms_common" SET ("term", "language") = ('user', 'en') WHERE "term"='user'; 815 816INSERT INTO "#__finder_terms_common" ("term", "language") 817SELECT 'user', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='user'); 818 819-- 820UPDATE "#__finder_terms_common" SET ("term", "language") = ('users', 'en') WHERE "term"='users'; 821 822INSERT INTO "#__finder_terms_common" ("term", "language") 823SELECT 'users', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='users'); 824 825-- 826UPDATE "#__finder_terms_common" SET ("term", "language") = ('version', 'en') WHERE "term"='version'; 827 828INSERT INTO "#__finder_terms_common" ("term", "language") 829SELECT 'version', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='version'); 830 831-- 832UPDATE "#__finder_terms_common" SET ("term", "language") = ('very', 'en') WHERE "term"='very'; 833 834INSERT INTO "#__finder_terms_common" ("term", "language") 835SELECT 'very', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='very'); 836 837-- 838UPDATE "#__finder_terms_common" SET ("term", "language") = ('via', 'en') WHERE "term"='via'; 839 840INSERT INTO "#__finder_terms_common" ("term", "language") 841SELECT 'via', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='via'); 842 843-- 844UPDATE "#__finder_terms_common" SET ("term", "language") = ('want', 'en') WHERE "term"='want'; 845 846INSERT INTO "#__finder_terms_common" ("term", "language") 847SELECT 'want', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='want'); 848 849-- 850UPDATE "#__finder_terms_common" SET ("term", "language") = ('was', 'en') WHERE "term"='was'; 851 852INSERT INTO "#__finder_terms_common" ("term", "language") 853SELECT 'was', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='was'); 854 855-- 856UPDATE "#__finder_terms_common" SET ("term", "language") = ('way', 'en') WHERE "term"='way'; 857 858INSERT INTO "#__finder_terms_common" ("term", "language") 859SELECT 'way', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='way'); 860 861-- 862UPDATE "#__finder_terms_common" SET ("term", "language") = ('were', 'en') WHERE "term"='were'; 863 864INSERT INTO "#__finder_terms_common" ("term", "language") 865SELECT 'were', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='were'); 866 867-- 868UPDATE "#__finder_terms_common" SET ("term", "language") = ('what', 'en') WHERE "term"='what'; 869 870INSERT INTO "#__finder_terms_common" ("term", "language") 871SELECT 'what', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='what'); 872 873-- 874UPDATE "#__finder_terms_common" SET ("term", "language") = ('when', 'en') WHERE "term"='when'; 875 876INSERT INTO "#__finder_terms_common" ("term", "language") 877SELECT 'when', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='when'); 878 879-- 880UPDATE "#__finder_terms_common" SET ("term", "language") = ('where', 'en') WHERE "term"='where'; 881 882INSERT INTO "#__finder_terms_common" ("term", "language") 883SELECT 'where', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='where'); 884 885-- 886UPDATE "#__finder_terms_common" SET ("term", "language") = ('which', 'en') WHERE "term"='which'; 887 888INSERT INTO "#__finder_terms_common" ("term", "language") 889SELECT 'which', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='which'); 890 891-- 892UPDATE "#__finder_terms_common" SET ("term", "language") = ('who', 'en') WHERE "term"='who'; 893 894INSERT INTO "#__finder_terms_common" ("term", "language") 895SELECT 'who', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='who'); 896 897-- 898UPDATE "#__finder_terms_common" SET ("term", "language") = ('whom', 'en') WHERE "term"='whom'; 899 900INSERT INTO "#__finder_terms_common" ("term", "language") 901SELECT 'whom', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='whom'); 902 903-- 904UPDATE "#__finder_terms_common" SET ("term", "language") = ('whose', 'en') WHERE "term"='whose'; 905 906INSERT INTO "#__finder_terms_common" ("term", "language") 907SELECT 'whose', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='whose'); 908 909-- 910UPDATE "#__finder_terms_common" SET ("term", "language") = ('why', 'en') WHERE "term"='why'; 911 912INSERT INTO "#__finder_terms_common" ("term", "language") 913SELECT 'why', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='why'); 914 915-- 916UPDATE "#__finder_terms_common" SET ("term", "language") = ('wide', 'en') WHERE "term"='wide'; 917 918INSERT INTO "#__finder_terms_common" ("term", "language") 919SELECT 'wide', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='wide'); 920 921-- 922UPDATE "#__finder_terms_common" SET ("term", "language") = ('will', 'en') WHERE "term"='will'; 923 924INSERT INTO "#__finder_terms_common" ("term", "language") 925SELECT 'will', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='will'); 926 927-- 928UPDATE "#__finder_terms_common" SET ("term", "language") = ('with', 'en') WHERE "term"='with'; 929 930INSERT INTO "#__finder_terms_common" ("term", "language") 931SELECT 'with', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='with'); 932 933-- 934UPDATE "#__finder_terms_common" SET ("term", "language") = ('within', 'en') WHERE "term"='within'; 935 936INSERT INTO "#__finder_terms_common" ("term", "language") 937SELECT 'within', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='within'); 938 939-- 940UPDATE "#__finder_terms_common" SET ("term", "language") = ('without', 'en') WHERE "term"='without'; 941 942INSERT INTO "#__finder_terms_common" ("term", "language") 943SELECT 'without', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='without'); 944 945-- 946UPDATE "#__finder_terms_common" SET ("term", "language") = ('would', 'en') WHERE "term"='would'; 947 948INSERT INTO "#__finder_terms_common" ("term", "language") 949SELECT 'would', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='would'); 950 951-- 952UPDATE "#__finder_terms_common" SET ("term", "language") = ('yes', 'en') WHERE "term"='yes'; 953 954INSERT INTO "#__finder_terms_common" ("term", "language") 955SELECT 'yes', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='yes'); 956 957-- 958UPDATE "#__finder_terms_common" SET ("term", "language") = ('yet', 'en') WHERE "term"='yet'; 959 960INSERT INTO "#__finder_terms_common" ("term", "language") 961SELECT 'yet', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='yet'); 962 963-- 964UPDATE "#__finder_terms_common" SET ("term", "language") = ('you', 'en') WHERE "term"='you'; 965 966INSERT INTO "#__finder_terms_common" ("term", "language") 967SELECT 'you', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='you'); 968 969-- 970UPDATE "#__finder_terms_common" SET ("term", "language") = ('your', 'en') WHERE "term"='your'; 971 972INSERT INTO "#__finder_terms_common" ("term", "language") 973SELECT 'your', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='your'); 974 975-- 976UPDATE "#__finder_terms_common" SET ("term", "language") = ('yours', 'en') WHERE "term"='yours'; 977 978INSERT INTO "#__finder_terms_common" ("term", "language") 979SELECT 'yours', 'en' WHERE 1 NOT IN (SELECT 1 FROM "#__finder_terms_common" WHERE "term"='yours'); 980 981 982 983-- 984-- Table: #__finder_tokens 985-- 986CREATE TABLE "#__finder_tokens" ( 987 "term" character varying(75) NOT NULL, 988 "stem" character varying(75) NOT NULL, 989 "common" smallint DEFAULT 0 NOT NULL, 990 "phrase" smallint DEFAULT 0 NOT NULL, 991 "weight" numeric(8,2) DEFAULT 1 NOT NULL, 992 "context" smallint DEFAULT 2 NOT NULL 993); 994CREATE INDEX "#__finder_tokens_idx_word" on "#__finder_tokens" ("term"); 995CREATE INDEX "#__finder_tokens_idx_context" on "#__finder_tokens" ("context"); 996 997-- 998-- Table: #__finder_tokens_aggregate 999-- 1000CREATE TABLE "#__finder_tokens_aggregate" ( 1001 "term_id" integer NOT NULL, 1002 "map_suffix" character(1) NOT NULL, 1003 "term" character varying(75) NOT NULL, 1004 "stem" character varying(75) NOT NULL, 1005 "common" smallint DEFAULT 0 NOT NULL, 1006 "phrase" smallint DEFAULT 0 NOT NULL, 1007 "term_weight" numeric(8,2) NOT NULL, 1008 "context" smallint DEFAULT 2 NOT NULL, 1009 "context_weight" numeric(8,2) NOT NULL, 1010 "total_weight" numeric(8,2) NOT NULL 1011); 1012CREATE INDEX "#__finder_tokens_aggregate_token" on "#__finder_tokens_aggregate" ("term"); 1013CREATE INDEX "_#__finder_tokens_aggregate_keyword_id" on "#__finder_tokens_aggregate" ("term_id"); 1014 1015-- 1016-- Table: #__finder_types 1017-- 1018CREATE TABLE "#__finder_types" ( 1019 "id" serial NOT NULL, 1020 "title" character varying(100) NOT NULL, 1021 "mime" character varying(100) NOT NULL, 1022 PRIMARY KEY ("id"), 1023 CONSTRAINT "#__finder_types_title" UNIQUE ("title") 1024); 1025 1026