snipt

Ctrl+h for KB shortcuts

XML

propel xml example schema

<?xml version="1.0" encoding="UTF-8"?>
 <database name="propel" defaultIdMethod="native" noXsd="true" package="lib.model">
    <table name="blog_article" phpName="Article">
      <column name="id" type="integer" required="true" primaryKey="true"autoIncrement="true" />
      <column name="title" type="varchar" size="255" />
      <column name="content" type="longvarchar" />
      <column name="created_at" type="timestamp" />
    </table>
    <table name="blog_comment" phpName="Comment">
      <column name="id" type="integer" required="true" primaryKey="true"autoIncrement="true" />
      <column name="article_id" type="integer" />
      <foreign-key foreignTable="blog_article">
        <reference local="article_id" foreign="id"/>
      </foreign-key>
      <column name="author" type="varchar" size="255" />
      <column name="content" type="longvarchar" />
      <column name="created_at" type="timestamp" />
    </table>
 </database>
https://snipt.net/embed/2610c4fc7330fd5e4733f9afc1e0d6ff/
/raw/2610c4fc7330fd5e4733f9afc1e0d6ff/
2610c4fc7330fd5e4733f9afc1e0d6ff
xml
XML
19
2019-05-21T16:30:27
True
False
False
/api/public/snipt/2547/
propel-xml-samle-schema
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a> <a href="#L-12">12</a> <a href="#L-13">13</a> <a href="#L-14">14</a> <a href="#L-15">15</a> <a href="#L-16">16</a> <a href="#L-17">17</a> <a href="#L-18">18</a> <a href="#L-19">19</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cp">&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;</span> </span><span id="L-2"><a name="L-2"></a> <span class="nt">&lt;database</span> <span class="na">name=</span><span class="s">&quot;propel&quot;</span> <span class="na">defaultIdMethod=</span><span class="s">&quot;native&quot;</span> <span class="na">noXsd=</span><span class="s">&quot;true&quot;</span> <span class="na">package=</span><span class="s">&quot;lib.model&quot;</span><span class="nt">&gt;</span> </span><span id="L-3"><a name="L-3"></a> <span class="nt">&lt;table</span> <span class="na">name=</span><span class="s">&quot;blog_article&quot;</span> <span class="na">phpName=</span><span class="s">&quot;Article&quot;</span><span class="nt">&gt;</span> </span><span id="L-4"><a name="L-4"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;id&quot;</span> <span class="na">type=</span><span class="s">&quot;integer&quot;</span> <span class="na">required=</span><span class="s">&quot;true&quot;</span> <span class="na">primaryKey=</span><span class="s">&quot;true&quot;</span><span class="na">autoIncrement=</span><span class="s">&quot;true&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-5"><a name="L-5"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;title&quot;</span> <span class="na">type=</span><span class="s">&quot;varchar&quot;</span> <span class="na">size=</span><span class="s">&quot;255&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-6"><a name="L-6"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;content&quot;</span> <span class="na">type=</span><span class="s">&quot;longvarchar&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-7"><a name="L-7"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;created_at&quot;</span> <span class="na">type=</span><span class="s">&quot;timestamp&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-8"><a name="L-8"></a> <span class="nt">&lt;/table&gt;</span> </span><span id="L-9"><a name="L-9"></a> <span class="nt">&lt;table</span> <span class="na">name=</span><span class="s">&quot;blog_comment&quot;</span> <span class="na">phpName=</span><span class="s">&quot;Comment&quot;</span><span class="nt">&gt;</span> </span><span id="L-10"><a name="L-10"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;id&quot;</span> <span class="na">type=</span><span class="s">&quot;integer&quot;</span> <span class="na">required=</span><span class="s">&quot;true&quot;</span> <span class="na">primaryKey=</span><span class="s">&quot;true&quot;</span><span class="na">autoIncrement=</span><span class="s">&quot;true&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-11"><a name="L-11"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;article_id&quot;</span> <span class="na">type=</span><span class="s">&quot;integer&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-12"><a name="L-12"></a> <span class="nt">&lt;foreign-key</span> <span class="na">foreignTable=</span><span class="s">&quot;blog_article&quot;</span><span class="nt">&gt;</span> </span><span id="L-13"><a name="L-13"></a> <span class="nt">&lt;reference</span> <span class="na">local=</span><span class="s">&quot;article_id&quot;</span> <span class="na">foreign=</span><span class="s">&quot;id&quot;</span><span class="nt">/&gt;</span> </span><span id="L-14"><a name="L-14"></a> <span class="nt">&lt;/foreign-key&gt;</span> </span><span id="L-15"><a name="L-15"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;author&quot;</span> <span class="na">type=</span><span class="s">&quot;varchar&quot;</span> <span class="na">size=</span><span class="s">&quot;255&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-16"><a name="L-16"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;content&quot;</span> <span class="na">type=</span><span class="s">&quot;longvarchar&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-17"><a name="L-17"></a> <span class="nt">&lt;column</span> <span class="na">name=</span><span class="s">&quot;created_at&quot;</span> <span class="na">type=</span><span class="s">&quot;timestamp&quot;</span> <span class="nt">/&gt;</span> </span><span id="L-18"><a name="L-18"></a> <span class="nt">&lt;/table&gt;</span> </span><span id="L-19"><a name="L-19"></a> <span class="nt">&lt;/database&gt;</span> </span></pre></div> </td></tr></table>
mysql, propel, symfony, xml