[TYPO3-dev] Postgres databse schema

[Michiel Roos [netcreators]]

Dear devs,

Short:

Can anyone provide me with a proper postgres.sql database schema for
a clean TYPO3 install?


Long:

Yesterday I looked ad postgres for the first time. I wanted to know if I
could get TYPO3 running on it with the dbal in place and all.

So I started out with an existing TYPO3 install and dumped the table
structure.

Then I pulled it through some 733t conversion script to generate a
postgres database schema.

Then I imported this schema into a postgres database (which threw me a
bunch of errors but I smacked it around a bit untill it worked).

Then I fiddled around with the localconf.php for a while untill I could
log into the backend. . . . and there was much rejoicing. . . .

Now every once in a while TYPO3 throws me errors which I have to correct
in pgpmyadmin. These errors include:
- incorrect default values for bytea and text fields (which I need to
chage from empty to ''::text or ''::bytea.
- incorrectly defined keys or duplicate keys

If I fix those errors it all works fine. Well . . . . I don't really know
if it is fine that I just drop the Constraints/keys/indexes that postgres
complains about.

But still it would be great to use a 'proper' database schema to import in
the install tool or manually via pgpmyadmin and not having to do all this
strange conversion stuff.

Is such a schema available?

-- 
Met vriendelijke groet,

Michiel Roos