Re: [jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-20 Thread Stephane LAPIE
Craig Small wrote: > On Tue, Oct 20, 2009 at 12:52:09PM +0900, Stephane LAPIE wrote: >> I just tried your file on my test setup, it doesn't work because of the >> AUTO_INCREMENTs (MySQL-isms), which are not declared the same way at all >> in PostgreSQL. > It seems that the mysql "postgresql compati

Re: [jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-20 Thread Stephane LAPIE
Craig Small wrote: > On Tue, Oct 20, 2009 at 12:52:09PM +0900, Stephane LAPIE wrote: >> I just tried your file on my test setup, it doesn't work because of the >> AUTO_INCREMENTs (MySQL-isms), which are not declared the same way at all >> in PostgreSQL. > It seems that the mysql "postgresql compati

Re: [jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-20 Thread Craig Small
On Tue, Oct 20, 2009 at 12:52:09PM +0900, Stephane LAPIE wrote: > I just tried your file on my test setup, it doesn't work because of the > AUTO_INCREMENTs (MySQL-isms), which are not declared the same way at all > in PostgreSQL. It seems that the mysql "postgresql compatible" mode is not compatibl

Re: [jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-19 Thread Stephane LAPIE
Craig Small wrote: > On Mon, Oct 19, 2009 at 09:26:24PM +1100, Craig Small wrote: >> Attached is the jffnms 0.8.5 database schema. The bad news is mysqldump > I tried sending it and then the email was too big. Here it is gziped up. I just tried your file on my test setup, it doesn't work because

Re: [jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-19 Thread Craig Small
On Mon, Oct 19, 2009 at 09:26:24PM +1100, Craig Small wrote: > Attached is the jffnms 0.8.5 database schema. The bad news is mysqldump I tried sending it and then the email was too big. Here it is gziped up. - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 ht

Re: [jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-19 Thread Craig Small
On Mon, Oct 19, 2009 at 01:54:31PM +0900, Stephane LAPIE wrote: > Could any of the maintainers provide a proper 0.8.4 postgres file ? This > is really annoying, and I am currently creating my "own" file by using > the 0.8.3 one and checking the differences with the mysql file for any > missing data

[jffnms-users] Problems with the 0.8.4 pgsql database schema

2009-10-18 Thread Stephane LAPIE
Hello, I am using JFFNMS 0.8.4 on FreeBSD with PostgreSQL and now, I am stuck in a bind with the postgres schema provided being virtually only table alterations and no actual data. Could any of the maintainers provide a proper 0.8.4 postgres file ? This is really annoying, and I am currently crea