Support » Plugin: Participants Database » Removing Participants Database Columns Completely from the MYSQL DB?

  • Resolved tinykot

    (@tinykot)


    Thanks for the wonderful Participant Database plugin. 🙂

    All is working perfectly with the Plugin. But when I remove a Entry Column, via the Participant Admin. The MYSQL Table dose not get altered?

    If I’m 100% sure 🙂 I don’t need the default Entries (e.g Country,City,Street) and Backup it up before any Slaughtering!!

    Would it be possible to remove the Entry via the Admin. Then simply alter the Table via PhpMyAdmin?

    By looking at the very clean Design Structure of the Plugin 🙂 I’m 99.9% sure this is all ok. But just asking to be 100% sure.

    Thanks for any help, and see everyone around later.

    http://wordpress.org/plugins/participants-database/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author xnau webdesign

    (@xnau)

    When a field is deleted in the plugin admin, it is only deleted from the fields database, not from the main database. If you want to delete the corresponding fields from the main database too, go ahead. Just make sure that for every field that is defined in the fields database, there is a matching column in the main database.

    There are several columns you should not delete, of course: all the columns in the “internal” group.

    Back up your database, and if things go wrong, just restore it.

    Sorry for not replying in the past.
    Thanks for your detailed reply, I was able to successfully modify the MYSQL database structure and sorting the columns. Without any database Restore 🙂

    See your around, and thanks for the wonderful plugin 🙂

    Sorry to open this thread again. Relevant question on topic, methinks. It may be terribly obvious but I’m still going to ask it.
    So, if one creates a new field through the plugin admin that will in turn create a field in the main database, right? does it do anything else?

    Plugin Author xnau webdesign

    (@xnau)

    The fields database holds the properties of the field, the main database holds the data, so for each fields row, there is a corresponding column in the main database. Creating a new field adds a row to the fields table and a column to the main table, nothing more than that.

    Word. Thanks again.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Removing Participants Database Columns Completely from the MYSQL DB?’ is closed to new replies.