We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Modx xPDO XML Schema boolean help

    • 42082
    • 72 Posts
    modxnooby Reply #11, 12 years, 9 months ago
    One more thing, just as a side question ^-^. Can I have special characters like _ in my field keys? Like is key="show_author" ok? Also I have seen a setup like this quite often and I'm not quite sure what it is for? I mean I have read the new documentation on version="1.1" models and I thought index was depreciated. Am i mixing stuff up? 
    <index alias="name" name="name" primary="false" unique="false" type="BTREE">
        <column key="name" length="" collation="A" null="false" />
    </index>

    I'm just starting out in all this xml schema/mysql stuff so all your help is amazing. I almost feel badly for taking up all your time.But thank you all so much!

    Modxnooby [ed. note: modxnooby last edited this post 12 years, 9 months ago.]
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      sottwell Reply #12, 12 years, 9 months ago
      Take a look at a similar table in the database, and you'll see the correlation between its indexes and lines like this.

      http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html

      Here's a phpMyAdmin view of the indexes for the chunks table (site_htmlsnippets)
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 3749
        • 24,544 Posts
        BobRay Reply #13, 12 years, 9 months ago
        Yes, underscores are OK. A number of MODX fields have underscores in their field names.
          Did I help you? Buy me a beer
          Get my Book: MODX:The Official Guide
          MODX info for everyone: http://bobsguides.com/modx.html
          My MODX Extras
          Bob's Guides is now hosted at A2 MODX Hosting