MDB create from schema
| From: | Jeroen Houben | Date: | Wed, 02 Apr 2003 12:09:59 +0000 |
| Subject: | MDB create from schema | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-4591@lists.php.net to get a copy of this message | ||
Hi,
When I try to create my schema I get the following error
php createMDB.php
Error: MDB Error: syntax error
info: [nativecode = ERROR: parser: parse error at or near "START"]
Anyone knows where this is coming from? I'm using postgres 7.2.1
Here's my schema. TIA!
Jeroen
<?xml version="1.0" encoding="ISO-8859-1" ?>
<database>
<name>sixnettest</name>
<create>1</create>
<table>
<name>docblobs</name>
<declaration>
<field>
<name>doc_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>content</name>
<type>blob</type>
</field>
<index>
<name>doc_id</name>
<unique>1</unique>
<field>
<name>doc_id</name></field> </index> </declaration> </table> <table> <name>docsections</name> <declaration> <field> <name>doc_id</name> <type>integer</type> <notnull>1</notnull> <default>0</default> </field> <field> <name>section_id</name> <type>integer</type> <notnull>1</notnull> <default>0</default> </field> <index> <name>doc_id</name> <unique>1</unique> <field>
<name>doc_id</name></field> </index> <index> <name>section_id</name> <unique>1</unique> <field>
<name>section_id</name></field> </index> <index> <name>did</name> <field>
<name>doc_id</name>
<sorting>ascending</sorting>
</field>
</index>
<index>
<name>sid</name>
<field>
<name>section_id</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<table>
<name>documents</name>
<declaration>
<field>
<name>doc_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>filename</name>
<type>text</type>
<length>120</length>
<notnull>1</notnull>
<default></default>
</field>
<field>
<name>filesize</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>mimetype</name>
<type>text</type>
<length>50</length>
<notnull>1</notnull>
<default>application/octet-stream</default>
</field>
<field>
<name>description</name>
<type>text</type>
<length>255</length>
<notnull>1</notnull>
<default></default>
</field>
<field>
<name>uploaddate</name>
<type>timestamp</type>
<notnull>1</notnull>
<default>0001-01-01 00:00:00</default>
</field>
<index>
<name>doc_id</name>
<unique>1</unique>
<field>
<name>doc_id</name></field> </index> <index> <name>uploaddate</name> <field>
<name>uploaddate</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<sequence>
<name>documents_doc_id</name>
<on>
<table>documents</table>
<field>doc_id</field>
</on>
</sequence>
<table>
<name>groups</name>
<declaration>
<field>
<name>group_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>name</name>
<type>text</type>
<length>120</length>
<notnull>1</notnull>
<default></default>
</field>
<index>
<name>group_id</name>
<unique>1</unique>
<field>
<name>group_id</name></field> </index> <index> <name>idx_unicat</name> <field>
<name>name</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<sequence>
<name>groups_id</name>
<on>
<table>groups</table>
<field>group_id</field>
</on>
</sequence>
<table>
<name>permissions</name>
<declaration>
<field>
<name>section_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>group_id</name>
<type>integer</type>
</field>
<field>
<name>perm</name>
<type>text</type>
<length>5</length>
<notnull>1</notnull>
<default>READ</default>
</field>
<index>
<name>sid</name>
<field>
<name>section_id</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<table>
<name>sections</name>
<declaration>
<field>
<name>section_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>parent_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>name</name>
<type>text</type>
<length>150</length>
<notnull>1</notnull>
<default></default>
</field>
<field>
<name>url</name>
<type>text</type>
<length>150</length>
<notnull>1</notnull>
<default>documents.php</default>
</field>
<field>
<name>urltarget</name>
<type>text</type>
<length>6</length>
<notnull>1</notnull>
<default>_self</default>
</field>
<field>
<name>displayorder</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<index>
<name>section_id</name>
<unique>1</unique>
<field>
<name>section_id</name></field> </index> <index> <name>url</name> <field>
<name>url</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<sequence>
<name>sections_section_id</name>
<on>
<table>sections</table>
<field>section_id</field>
</on>
</sequence>
<table>
<name>usergroup</name>
<declaration>
<field>
<name>group_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>user_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<index>
<name>group_id</name>
<unique>1</unique>
<field>
<name>group_id</name></field> </index> <index> <name>user_id</name> <unique>1</unique> <field>
<name>user_id</name></field> </index> <index> <name>gid</name> <field>
<name>group_id</name>
<sorting>ascending</sorting>
</field>
</index>
<index>
<name>uid</name>
<field>
<name>user_id</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<table>
<name>users</name>
<declaration>
<field>
<name>user_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>fullname</name>
<type>text</type>
<length>60</length>
<notnull>1</notnull>
<default></default>
</field>
<field>
<name>username</name>
<type>text</type>
<length>10</length>
<notnull>1</notnull>
<default></default>
</field>
<field>
<name>pw</name>
<type>text</type>
<length>40</length>
<notnull>1</notnull>
<default></default>
</field>
<field>
<name>sessionid</name>
<type>text</type>
<length>32</length>
<notnull>1</notnull>
<default>0</default>
</field>
<index>
<name>user_id</name>
<unique>1</unique>
<field>
<name>user_id</name></field> </index> <index> <name>username</name> <field>
<name>username</name>
<sorting>ascending</sorting>
</field>
</index>
<index>
<name>idx_pwd</name>
<field>
<name>pw</name>
<sorting>ascending</sorting>
</field>
</index>
</declaration>
</table>
<sequence>
<name>users_user_id</name>
<on>
<table>users</table>
<field>user_id</field>
</on>
</sequence>
</database>