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+unsubscr...@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 > <https://groups.google.com/d/msgid/weewx-user/5c4a39f8-5517-4c26-9a79-98ac3df11b6fn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEDn_A0BBk3Jhd1i9jLzrt3Abu3R0rQdjQ_iH1_-_nSt7Q%40mail.gmail.com.
