o h)@s6ddlmZmZmZddlmZGdddejZdS)) connection migrationsmodels) IndexEntryc @seZdZdgZejdkriddlZddlZe 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 gZdSejdkr ddlmZe j ddejddde j dd ejddde j ddedgZer ee je jddejdddejddfdefd ejddfdejddfgddejjidge jdejjdejjde jdejjejjfd de jd!ejjejjfd"de jd#ejjejjfd$dgd%dSdSejd&krpe j ddejddde j dd ejddde j ddejd'd(dd)gZee jd*d+dee jd,d-dee jd.d/dej rdee jd0d1ddSee jd2d1ddSdS)3 Migration) wagtailsearch0005_create_indexentry postgresqlrN indexentry autocomplete) model_namenamefieldtitlebodywagtailsear_autocom_476c89_gin)fieldsr )r indexwagtailsear_title_9caae0_ginwagtailsear_body_90c85d_ginsqlite)fts5_availableT)nullsqliteftsindexentry index_entryFzwagtailsearch.indexentryrowid) primary_key serializeto on_delete db_columndb_tablez%s_fts)r roptionszACREATE VIRTUAL TABLE %s_fts USING fts5(autocomplete, body, title)zDROP TABLE IF EXISTS %s_fts)sql 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)state_operationsdatabase_operationsmysql)default)r r rpreserve_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__ dependenciesrvendordjango.contrib.postgres.indexesdjangodjango.contrib.postgres.searchrAddFieldcontribpostgressearchSearchVectorFieldAddIndexindexesGinIndex operations-wagtail.search.backends.database.sqlite.utilsrr TextFieldappendSeparateDatabaseAndState CreateModel OneToOneFieldCASCADEr_metar!RunSQLmysql_is_mariadbrFrFs/var/www/html/ndineBlogger/venv/lib/python3.10/site-packages/wagtail/search/migrations/0006_customise_indexentry.pyr s>        $        B    rN) django.dbrrrwagtail.search.modelsrrrFrFrFrGs