Question on codex documentation and dbDelta

  • Resolved AliceWonderFull

    (@alicewonderfull)


    9 years, 10 months ago

    http://codex.wordpress.org/Creating_Tables_with_Plugins

    On that page it says You must have two spaces between the words PRIMARY KEY and the definition of your primary key”

    but then the example does not actually specify a primary key, it specifies a unique key – and does not appear to have two spaces.

    What is the right thing to do to work with dbDelta ??

    -=-

    Secondly, can I use the CHECK feature to restrict the values a column can have or is that not supported if using dbDelta?

Viewing 1 replies (of 1 total)
  • Thread Starter AliceWonderFull

    (@alicewonderfull)

    9 years, 10 months ago

    Well I got it to work but it looks like it ignored adding the CHECK stuff, so I guess either that’s not supported, or is supported but I didn’t do it in a way that dbDelta likes.

    It’s not that critical, I’d just like to have inserts fail if the data is outside the intended range of the column.

Viewing 1 replies (of 1 total)
  • The topic ‘Question on codex documentation and dbDelta’ is closed to new replies.