Database questions

  • maybe42

    (@maybe42)


    4 years, 3 months ago

    First of all I would like to thank you very much for this software. This is a great product that I am completely enthusiastic about, well thought out and with obviously great support and documentation.
    It is a pleasure to work with. I have already bought some extensions and will of course also donate.

    Now I have a database question:
    I see a number of columns in the members table that I have deleted, for example first_name or last_name.
    Can I just remove these fields with ALTER TABLE DROP COLUMN or is that dangerous? They exist no longer in the participants_database_fields table either.
    This would be only for clarity.

    And a second question:
    I will maintain a database of yacht owners.
    Before owners register themselves with their hull number, we will import a lot of data from an archive.
    The hull number should be unique, which means that as soon as a user registers with an email and a hull number, I would like to be notified if this number already exists in the database so that I can delete the ‘old’ record (or, after consultation, merge the data).
    Technically really unique is just the email address.
    Do I have to write SQL myself or can the email expansion add-on help me?

    Thanks & regards, Peter

Viewing 1 replies (of 1 total)
  • Plugin Author Roland Barker

    (@xnau)

    4 years, 3 months ago

    Those unused columns can be deleted.

    There is a utility function in the plugin that will do this for you. When you’re on a plugin admin page, add “&pdb-remove-orphan-columns” to the end of the URL in the location bar, hit enter, and it will invoke the code to delete the orphan database columns.

    Or you can do it manually.

    Second: this is not something you will be able to do without some custom code. The Email Expansion Kit does provide a way to check new or updated records and send a notification if certain conditions are met, but it’s not possible to set a condition that the value match a value already in the db. You can implement a check like that with some custom code.

Viewing 1 replies (of 1 total)

The topic ‘Database questions’ is closed to new replies.