RT-SETU...XT-INDEX(1)

✨ NAME ✨

rt-setup-fulltext-index — bestie, this is the little script that creates indexes for full text search 💅 and it lives in the User Contributed Perl Documentation, section 1 (the header line up top reads RT-SETU...XT-INDEX(1) because it got squished, we love a truncated title moment ✨).

---

🦋 DESCRIPTION 🦋

okay so real talk: this script creates all the appropriate tables, columns, functions, and / or views that you need for full-text searching, specifically for your database type 🌈. It's basically tailoring the whole fit to your DB. Slay.

⚠️ but heads up bestie, it will drop any existing indexes in the process — like, gone gone. no take-backs. 😭 so know what you're doing before you run it.

Please please please read docs/full_text_indexing.pod for the complete documentation on full-text indexing for your database type 📖 — that's the real lore, iykyk.

---

If your database administrator user or password is non-standard (we love a quirky setup 💖), you can set them explicitly with the --dba and --dba-password parameters:

rt-setup-fulltext-index --dba sysdba --dba-password 'secret'

and if you just wanna peek at what would happen without actually running any DDL — like a vibe check but for your database 🫶 — pass the --dry-run flag. no cap, it's the safe way to test.

---

🍓 the Oracle situation

okay so the Oracle index is a lil different: it decides which content-types it will index at creation time ⭐. By default, what's getting indexed is:

• textual message bodies 💌
• textual uploaded attachments (aka attachments with filenames) 🎀

and if you want to ignore textual attachments, just pass the --no-attachments flag when the index is created. periodt. 💅

---

👑 AUTHOR 👑

• Ruslan Zakirov <ruz@bestpractical.com>
• Alex Vandiver <alexmv@bestpractical.com>

---

and that's the whole page bestie, we ate that 🍽️✨ — this was perl v5.42.3, dated 2026-07-20, brought to you by the RT-SETU...XT-INDEX(1) girlies. go forth and index responsibly 💖🦋🌸