Skip to content

Instantly share code, notes, and snippets.

@wcargen

wcargen/gist:7000761

Created October 16, 2013 00:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wcargen/7000761 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wcargen/7000761 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. wcargen created this gist Oct 16, 2013.
    116 changes: 116 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,116 @@
    <?xml version="1.0" encoding="utf-8" ?>
    <!-- SQL XML created by WWW SQL Designer, http://code.google.com/p/wwwsqldesigner/ -->
    <!-- Active URL: http://ondras.zarovi.cz/sql/demo/ -->
    <sql>
    <datatypes db="mysql">
    <group label="Numeric" color="rgb(238,238,170)">
    <type label="TINYINT" length="0" sql="TINYINT" quote=""/>
    <type label="SMALLINT" length="0" sql="SMALLINT" quote=""/>
    <type label="MEDIUMINT" length="0" sql="MEDIUMINT" quote=""/>
    <type label="INT" length="0" sql="INT" quote=""/>
    <type label="Integer" length="0" sql="INTEGER" quote=""/>
    <type label="BIGINT" length="0" sql="BIGINT" quote=""/>
    <type label="Decimal" length="1" sql="DECIMAL" re="DEC" quote=""/>
    <type label="Single precision" length="0" sql="FLOAT" quote=""/>
    <type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote=""/>
    </group>

    <group label="Character" color="rgb(255,200,200)">
    <type label="Char" length="1" sql="CHAR" quote="'"/>
    <type label="Varchar" length="1" sql="VARCHAR" quote="'"/>
    <type label="Text" length="0" sql="MEDIUMTEXT" re="TEXT" quote="'"/>
    <type label="Binary" length="1" sql="BINARY" quote="'"/>
    <type label="Varbinary" length="1" sql="VARBINARY" quote="'"/>
    <type label="BLOB" length="0" sql="BLOB" re="BLOB" quote="'"/>
    </group>

    <group label="Date &amp; Time" color="rgb(200,255,200)">
    <type label="Date" length="0" sql="DATE" quote="'"/>
    <type label="Time" length="0" sql="TIME" quote="'"/>
    <type label="Datetime" length="0" sql="DATETIME" quote="'"/>
    <type label="Year" length="0" sql="YEAR" quote=""/>
    <type label="Timestamp" length="0" sql="TIMESTAMP" quote="'"/>
    </group>

    <group label="Miscellaneous" color="rgb(200,200,255)">
    <type label="ENUM" length="1" sql="ENUM" quote=""/>
    <type label="SET" length="1" sql="SET" quote=""/>
    <type label="Bit" length="0" sql="bit" quote=""/>
    </group>
    </datatypes><table x="700" y="299" name="User">
    <row name="id" null="1" autoincrement="1">
    <datatype>TINYINT</datatype>
    <default>NULL</default></row>
    <row name="name" null="1" autoincrement="0">
    <datatype>MEDIUMTEXT</datatype>
    <default>NULL</default></row>
    <key type="PRIMARY" name="">
    <part>id</part>
    </key>
    </table>
    <table x="460" y="348" name="Post">
    <row name="id" null="1" autoincrement="1">
    <datatype>TINYINT</datatype>
    <default>NULL</default><relation table="Comment" row="id" />
    <relation table="Tag" row="id" />
    </row>
    <row name="user_id" null="1" autoincrement="0">
    <datatype>TINYINT</datatype>
    <default>NULL</default><relation table="User" row="id" />
    </row>
    <row name="post" null="1" autoincrement="0">
    <datatype>TINYINT</datatype>
    <default>NULL</default></row>
    <row name="date/time" null="1" autoincrement="0">
    <datatype>DATETIME</datatype>
    <default>NULL</default></row>
    <key type="PRIMARY" name="">
    <part>id</part>
    </key>
    </table>
    <table x="452" y="657" name="Comment">
    <row name="id" null="1" autoincrement="1">
    <datatype>TINYINT</datatype>
    <default>NULL</default><relation table="Tag" row="id" />
    </row>
    <row name="user_id" null="1" autoincrement="0">
    <datatype>INT</datatype>
    <default>NULL</default></row>
    <row name="comment" null="1" autoincrement="0">
    <datatype>TINYINT</datatype>
    <default>NULL</default></row>
    <row name="date/time" null="1" autoincrement="0">
    <datatype>DATETIME</datatype>
    <default>NULL</default></row>
    <key type="PRIMARY" name="">
    <part>id</part>
    </key>
    </table>
    <table x="205" y="625" name="Vote">
    <row name="user_id" null="1" autoincrement="1">
    <datatype>MEDIUMTEXT</datatype>
    <default>NULL</default></row>
    <row name="vote" null="1" autoincrement="0">
    <datatype>INT</datatype>
    <default>NULL</default><relation table="Comment" row="id" />
    <relation table="Post" row="id" />
    </row>
    <key type="PRIMARY" name="">
    <part>user_id</part>
    </key>
    </table>
    <table x="772" y="647" name="Tag">
    <row name="id" null="1" autoincrement="1">
    <datatype>TINYINT</datatype>
    <default>NULL</default></row>
    <row name="user_id" null="1" autoincrement="0">
    <datatype>TINYINT</datatype>
    <default>NULL</default></row>
    <row name="tag" null="1" autoincrement="0">
    <datatype>TINYINT</datatype>
    <default>NULL</default></row>
    <key type="PRIMARY" name="">
    <part>id</part>
    </key>
    </table>
    </sql>