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 of the
AUTO_INCREMENTs (MySQL-isms), which are not declared the same way at all
in PostgreSQL.
-- At the end of your file :
ALTER TABLE actions AUTO_INCREMENT = 10001;
The equivalent of adding the AUTO_INCREMENT concept to a table's primary
key in PostgreSQL is done in the following manner (this is also how it
was done until 0.8.3), with a separate counter object that has to be
created before the table :
-- This part was properly converted before
CREATE SEQUENCE actions_id_seq;
-- This part was not done in previous conversions, though this is how
you force the sequence value
SELECT pg_catalog.setval('actions_id_seq', 10000, true);
Then declaring the table fields this way :
CREATE TABLE actions (
id integer DEFAULT nextval('actions_id_seq') NOT NULL,
...
);
Thanks for your time,
--
Stephane LAPIE, EPITA SRS, Promo 2005
"Even when they have digital readouts, I can't understand them."
--MegaTokyo
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference
_______________________________________________ jffnms-users mailing list jffnms-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jffnms-users
