Support » Plugin: WP Data Access » Unique index

  • Resolved terreel2018

    (@terreel2018)


    Hi Peter,

    When creating my index on a table, in design I say index is unique, but in the created table the index is not unique.

    And can I delete a created index? I saw the primary key index is already created automatically! So now I have that one twice.

    kind regards
    Mieke

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Peter Schulz

    (@peterschulznl)

    Hi Mieke,

    I tested the “create unique index” functionality. It works fine for me. I guess you meant the column ‘Unique?’ on the ‘Indexes’ tab of Data Explorer is showing the wrong value? I changed it. It should be fine now. Can you please confirm?

    Delete indexes is not yet implemented. I didn’t plan it as I always drop and recreate my tables. But I understand that different people have different habits! 🙂 I’ll leave this thread open see what I can do…

    Best reards,
    Peter

    Plugin Author Peter Schulz

    (@peterschulznl)

    Hi Mieke,

    I just uploaded a new version. You can now drop indexes from the Data Explorer:
    – Go to the Data Explorer
    – Find the table of which you want to drop an index
    – Click on the admin menu of that table
    – Click on the link Drop Index
    – Click on the trash icon of the index you want to drop and confirm

    Hope this helps!

    Best regards,
    Peter

    It all works fine now! Thank you.

    Problem solved

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Unique index’ is closed to new replies.