/usr/share/doc/php-mdb2/docs/examples/metapear_test_db.schema is in php-mdb2 2.5.0b5-1build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 | <?xml version="1.0" encoding="ISO-8859-1" ?>
<database>
<name>metapear_test_db</name>
<create>1</create>
<table>
<name>numbers</name>
<declaration>
<field>
<name>number</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>trans_en</name>
<type>text</type>
<length>100</length>
<default></default>
</field>
<field>
<name>trans_fr</name>
<type>text</type>
<length>100</length>
<default></default>
</field>
</declaration>
</table>
<table>
<name>test</name>
<declaration>
<field>
<name>test_id</name>
<type>integer</type>
<notnull>1</notnull>
<default>0</default>
</field>
<field>
<name>test_name</name>
<type>text</type>
<length>30</length>
<notnull>1</notnull>
<default>no name</default>
</field>
<field>
<name>test_date</name>
<type>timestamp</type>
<notnull>1</notnull>
<default>0000-00-00 00:00:00</default>
</field>
</declaration>
<initialization>
<insert>
<field>
<name>test_id</name>
<value>1</value>
</field>
<field>
<name>test_name</name>
<value>test0r</value>
</field>
<field>
<name>test_date</name>
<value>2002-02-12 16:33:53</value>
</field>
</insert>
<insert>
<field>
<name>test_id</name>
<value>2</value>
</field>
<field>
<name>test_name</name>
<value>gummihuhn</value>
</field>
<field>
<name>test_date</name>
<value>2001-02-12 16:34:03</value>
</field>
</insert>
</initialization>
</table>
</database>
|