No primary key on archive

[Clay Jackson]

I'm importing weewx data from a mariadb  database to a percona xtradb  and it has strict primary key enforcement turned on.  Is there a reason there's a key but not a primary key defined for the archive table?

[Tom Keffer]

But, there is a primary key: field dateTime. It should be defined as "INTEGER NOT NULL UNIQUE PRIMARY KEY".

You're not seeing that?

On Tue, Apr 30, 2024 at 9:39 PM Clay Jackson <cl...@n7qnm.net> wrote:

I'm importing weewx data from a mariadb  database to a percona xtradb  and it has strict primary key enforcement turned on.  Is there a reason there's a key but not a primary key defined for the archive table?

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5c4a39f8-5517-4c26-9a79-98ac3df11b6fn%40googlegroups.com.

[Cameron D]

Some of the  utilities for exporting data structure only declare the primary key in an ALTER TABLE at  the end of the file.  I never understood why.

Not sure if it was phpmyadmin or mysql workbench.

Mysqdump declares it differently again