Re: Database schema upgrade in Maia-dev releases
"Dave Overton" <[email protected]>
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Organization | SYIX.COM |
| Message-ID | <00c801d15ec1$34314bc0$9c93e340$@com> |
What you see is exactly what the tool (Mysql Workbench) spit out. I was digging around, found the Mysql tool that will do what is proper and create the .sql file to modify the scheme. Will post its results later. > -----Original Message----- > From: Brian McCullough [mailto:[email protected]] > Sent: Wednesday, February 03, 2016 6:04 AM > To: Dave Overton > Cc: [email protected] > Subject: Re: [Maia-users] Database schema upgrade in Maia-dev releases > > On Wed, Feb 03, 2016 at 01:38:15AM -0800, Dave Overton wrote: > > Here are scheme changes from 1.0.2c to 1.0.4. I am sure someone > could script this to update the old DB, thats past my skillset, but hey > at least we know what the changes are. I think probably the other > ideas are better, dump and restore to the new scheme, but here are the > actual changes. > > > Dave, > > In your listing, you show the following sequence several times: "added > index," followed by "removed index." > > Were the changes actually in that order, or were they perhaps more > like: > "removed index," following by "add ( new, replacement ) index?" > > > > Thanks, > Brian _______________________________________________ Maia-users mailing list [email protected] http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users