U |h)@s6ddlmZmZmZddlmZGdddejZdS)) connection migrationsmodels) IndexEntryc @seZdZdgZejdkrddlZddlZe j ddej j j de j ddej j j de j dd ej j j de jdej j jjdgd d d e jdej j jjdgd d d e jdej j jjd gdd d gZnejdkrddlmZe j ddejddde j dd ejddde j ddedgZeree je jddejdddejddfdefd ejddfdejddfgddejjidge jdejjdejjde jdejjejjfd de jd!ejjejjfd"de jd#ejjejjfd$dgd%nejd&kre j ddejddde j dd ejddde j ddejd'd(dd)gZee jd*d+dee jd,d-dee jd.d/dej ree jd0d1dnee jd2d1ddS)3 Migration)Z wagtailsearchZ0005_create_indexentry postgresqlrNZ indexentry autocomplete) model_namenamefieldtitlebodyZwagtailsear_autocom_476c89_gin)fieldsr )r indexZwagtailsear_title_9caae0_ginZwagtailsear_body_90c85d_ginZsqlite)fts5_availableT)nullZsqliteftsindexentryZ index_entryFzwagtailsearch.indexentryZrowid)Z primary_key serializetoZ on_deleteZ db_columndb_tablez%s_fts)r roptionszACREATE VIRTUAL TABLE %s_fts USING fts5(autocomplete, body, title)zDROP TABLE IF EXISTS %s_fts)sqlZ reverse_sqlzCREATE TRIGGER insert_wagtailsearch_indexentry_fts AFTER INSERT ON %s BEGIN INSERT INTO %s_fts(title, body, autocomplete, rowid) VALUES (NEW.title, NEW.body, NEW.autocomplete, NEW.id); ENDz:DROP TRIGGER IF EXISTS insert_wagtailsearch_indexentry_ftszCREATE TRIGGER update_wagtailsearch_indexentry_fts AFTER UPDATE ON %s BEGIN UPDATE %s_fts SET title=NEW.title, body=NEW.body, autocomplete=NEW.autocomplete WHERE rowid=NEW.id; ENDz:DROP TRIGGER IF EXISTS update_wagtailsearch_indexentry_ftszvCREATE TRIGGER delete_wagtailsearch_indexentry_fts AFTER DELETE ON %s BEGIN DELETE FROM %s_fts WHERE rowid=OLD.id; ENDz:DROP TRIGGER IF EXISTS delete_wagtailsearch_indexentry_fts)Zstate_operationsZdatabase_operationsmysql)default)r r r Zpreserve_defaultz ALTER TABLE wagtailsearch_indexentry ADD FULLTEXT INDEX `fulltext_body` (`body`) zu ALTER TABLE wagtailsearch_indexentry DROP INDEX `fulltext_body` z ALTER TABLE wagtailsearch_indexentry ADD FULLTEXT INDEX `fulltext_title` (`title`) zv ALTER TABLE wagtailsearch_indexentry DROP INDEX `fulltext_title` z ALTER TABLE wagtailsearch_indexentry ADD FULLTEXT INDEX `fulltext_title_body` (`title`, `body`) z{ ALTER TABLE wagtailsearch_indexentry DROP INDEX `fulltext_title_body` z ALTER TABLE wagtailsearch_indexentry ADD FULLTEXT INDEX `fulltext_autocomplete` (`autocomplete`) z ALTER TABLE wagtailsearch_indexentry DROP INDEX `fulltext_autocomplete` z ALTER TABLE wagtailsearch_indexentry ADD FULLTEXT INDEX `fulltext_autocomplete` (`autocomplete`) WITH PARSER ngram )!__name__ __module__ __qualname__ dependenciesrvendorZdjango.contrib.postgres.indexesdjangoZdjango.contrib.postgres.searchrZAddFieldcontribpostgressearchZSearchVectorFieldZAddIndexZindexesZGinIndex operationsZ-wagtail.search.backends.database.sqlite.utilsrrZ TextFieldappendZSeparateDatabaseAndStateZ CreateModelZ OneToOneFieldZCASCADEr_metarZRunSQLZmysql_is_mariadbr&r&{/var/www/dating/data/www/fatepal.com/env/lib/python3.8/site-packages/wagtail/search/migrations/0006_customise_indexentry.pyr s>       $        A     rN)Z django.dbrrrZwagtail.search.modelsrrr&r&r&r's