No unique column in DB

  • I needed to edit some form records manually in my database. However, there is no unique column, which makes it impossible to select, edit, copy, or delete any of the records through phpMyAdmin. May I suggest two things?

    First, a completely unique primary key that auto increments for each record, just for that purpose.

    Second, storing form submission data where the identifier for the form submitted from by its post ID, which is unique to each form, instead of relying on the title of the form. What if someone titled two or more forms the same, even though they were different in content or topic?

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    https://cfdbplugin.com/?page_id=71

    The form plugins, not CFDB creates the forms. CFDB integrates with various form plugins. They don’t all provide a unique id different from the form name. And for some people, having two or more forms that capture data under the same form name is a desirable feature.

    Thread Starter sashafiero

    (@sashafiero)

    Ah, okay. I understand! Besides, it’s not like you have to display the form name where you put the form to be filled out; the admin can just use different names if they need!

    I’d still suggest an auto increment primary key for each of your records, in any case, not really used for anything except manual DB manipulation.

    Sorry about not putting this in a separate topic!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘No unique column in DB’ is closed to new replies.