rt-setup-fulltext-index(8)

💖 rt-setup-fulltext-index — the Request Tracker Reference glow-up 💖

okay bestie, so you know that one page, rt-setup-fulltext-index(8), from the Request Tracker Reference? yeah. we're doing it. pull up a chair 🪑

---

✨ NAME ✨

rt-setup-fulltext-index — she helps you create indexes for full text search, and she eats 💅

---

🌸 DESCRIPTION 🌸

so basically this script does the absolute most: it creates the tables, columns, functions, and/or views that you need for full-text searching, customised for your database type. that's the whole point of her. iconic. and yeah, heads up, she will drop any existing indexes in the process — no thoughts, just DDL. 😭

⚠️ fr fr, "will drop any existing indexes" is not a cute little detail, that's a real thing she does. know that going in.

for the complete documentation on full-text indexing for your database type, go read docs/full_text_indexing.pod — that's your girl, that's the deep lore, go read her. 📖

now. if your database administrator user or password is ✨non-standard✨ (a rebel, a maverick), you can just tell her about it explicitly with the --dba and --dba-password parameters:

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

and if you're the type of person who wants to see the whole fit before committing (same, honestly 🫶), you can test what's about to happen without running any DDL — just pass the --dryrun flag. no cap, nothing gets touched, she just shows you the vision. 🌈

okay and now the Oracle tea ☕ — the Oracle index decides which content-types it's gonna index at creation time. like, that's locked in, that's the moment. by default she indexes textual message bodies and textual uploaded attachments (the attachments with filenames, iykyk). but if you want her to ignore textual attachments? pass the --no-attachments flag when the index is created. timing matters bestie, it's giving "the window is now". ⏰

---

👑 AUTHOR 👑

the legends behind this masterpiece:

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

---

and that's the whole page, bestie. this came to you courtesy of Request Tracker Reference, built on perl v5.38.2, dated 2023-10-29, and named — of course — rt-setup-fulltext-index(8). periodt. 💜🦋✨