[ewiki] Postgresql support.

From: "Daniel P. Stasinski" <mooooooo@xxxxxxxxxxx>
To: ewiki@xxxxxxxxxxxxx
Date: Fri, 02 Jan 2004 20:30:55 -0700

The init code was not able to create the table in Postgresql.  Below is
the how I did it manually.

Thank you so much for ewiki :)

 CREATE TABLE ewiki (
    pagename character varying(160) NOT NULL,
    "version" bigint DEFAULT 0 NOT NULL,
    flags bigint DEFAULT 0,
    content text,
    author character varying(100),
    created bigint DEFAULT 0,
    lastmodified bigint DEFAULT 0,
    refs text,
    meta text,
    hits bigint DEFAULT 0
 );

 ALTER TABLE ONLY ewiki
    ADD CONSTRAINT id PRIMARY KEY (pagename, "version");

-- 
Daniel P. Stasinski
http://www.disabilities-r-us.com
mooooooo@xxxxxxxxxxxxxxxxxxxxx

Follow-Ups:

[ewiki] Re: Postgresql support, protected mode
From: Mario Salzer

[ewiki] Postgresql support.

Other related posts: