home *** CD-ROM | disk | FTP | other *** search
/ Enter 2004 June / ENTER.ISO / files / xampp-win32-1.4.5-installer.exe / xampp / metapear_test_db.schema < prev    next >
Encoding:
Extensible Markup Language  |  2004-03-24  |  1.7 KB  |  115 lines
  1. <?xml version="1.0" encoding="ISO-8859-1" ?>
  2. <database>
  3.  
  4.  <name>metapear_test_db</name>
  5.  <create>1</create>
  6.  
  7.  <table>
  8.  
  9.   <name>numbers</name>
  10.  
  11.   <declaration>
  12.  
  13.    <field>
  14.     <name>number</name>
  15.     <type>integer</type>
  16.     <notnull>1</notnull>
  17.     <default>0</default>
  18.    </field>
  19.  
  20.    <field>
  21.     <name>trans_en</name>
  22.     <type>text</type>
  23.     <length>100</length>
  24.     <notnull>1</notnull>
  25.     <default></default>
  26.    </field>
  27.  
  28.    <field>
  29.     <name>trans_fr</name>
  30.     <type>text</type>
  31.     <length>100</length>
  32.     <notnull>1</notnull>
  33.     <default></default>
  34.    </field>
  35.  
  36.   </declaration>
  37.  
  38.  </table>
  39.  
  40.  <table>
  41.  
  42.   <name>test</name>
  43.  
  44.   <declaration>
  45.  
  46.    <field>
  47.     <name>test_id</name>
  48.     <type>integer</type>
  49.     <notnull>1</notnull>
  50.     <default>0</default>
  51.    </field>
  52.  
  53.    <field>
  54.     <name>test_name</name>
  55.     <type>text</type>
  56.     <length>30</length>
  57.     <notnull>1</notnull>
  58.     <default></default>
  59.    </field>
  60.  
  61.    <field>
  62.     <name>test_date</name>
  63.     <type>timestamp</type>
  64.     <notnull>1</notnull>
  65.     <default>0000-00-00 00:00:00</default>
  66.    </field>
  67.  
  68.   </declaration>
  69.  
  70.   <initialization>
  71.  
  72.    <insert>
  73.  
  74.    <field>
  75.      <name>test_id</name>
  76.      <value>1</value>
  77.    </field>
  78.  
  79.    <field>
  80.      <name>test_name</name>
  81.      <value>test0r</value>
  82.    </field>
  83.  
  84.    <field>
  85.      <name>test_date</name>
  86.      <value>2002-02-12 16:33:53</value>
  87.    </field>
  88.  
  89.    </insert>
  90.  
  91.    <insert>
  92.  
  93.    <field>
  94.      <name>test_id</name>
  95.      <value>2</value>
  96.    </field>
  97.  
  98.    <field>
  99.      <name>test_name</name>
  100.      <value>gummihuhn</value>
  101.    </field>
  102.  
  103.    <field>
  104.      <name>test_date</name>
  105.      <value>2001-02-12 16:34:03</value>
  106.    </field>
  107.  
  108.    </insert>
  109.  
  110.   </initialization>
  111.  
  112.  </table>
  113.  
  114. </database>
  115.