diff options
| author | Ondrej Zara <ondrej.zara@gmail.com> | 2014-06-16 09:06:51 +0200 |
|---|---|---|
| committer | Ondrej Zara <ondrej.zara@gmail.com> | 2014-06-16 09:06:51 +0200 |
| commit | 91c06fb963f3ce43ccad3315209703b26f06b031 (patch) | |
| tree | 982b307a49643c3a1460330688c4105aae75cae3 /backend/asp-file/data | |
| parent | 4f5ad99bc245cafc404839313a6a2e4bf6e31880 (diff) | |
| download | wwwsqldesigner-91c06fb963f3ce43ccad3315209703b26f06b031.zip wwwsqldesigner-91c06fb963f3ce43ccad3315209703b26f06b031.tar.gz wwwsqldesigner-91c06fb963f3ce43ccad3315209703b26f06b031.tar.bz2 | |
asp-file backend, thanks to Arie van Halem
Diffstat (limited to 'backend/asp-file/data')
| -rw-r--r-- | backend/asp-file/data/default | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/backend/asp-file/data/default b/backend/asp-file/data/default new file mode 100644 index 0000000..a6de8b9 --- /dev/null +++ b/backend/asp-file/data/default @@ -0,0 +1,30 @@ +<?xml version="1.0" encoding="utf-8" ?><sql><datatypes db="mysql"> + <group label="Numeric" color="rgb(238,238,170)"> + <type label="Integer" length="0" sql="INTEGER" re="INT" 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 & 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=""/> + </group> +</datatypes><table x="50" y="50" name="Producer"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="name" null="1" autoincrement="0"><datatype>VARCHAR(100)</datatype><default>NULL</default></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="574" y="66" name="Consumer"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="name" null="1" autoincrement="0"><datatype>VARCHAR(100)</datatype><default>NULL</default></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="195" y="333" name="Product"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="id_Producer" null="0" autoincrement="1"><datatype>INTEGER</datatype><relation table="Producer" row="id" /></row><row name="name" null="1" autoincrement="0"><datatype>VARCHAR(100)</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table><table x="383" y="227" name="Garbage"><row name="id" null="0" autoincrement="1"><datatype>INTEGER</datatype></row><row name="id_Product" null="0" autoincrement="1"><datatype>INTEGER</datatype><relation table="Product" row="id" /></row><row name="id_Consumer" null="0" autoincrement="1"><datatype>INTEGER</datatype><relation table="Consumer" row="id" /></row><row name="consumed" null="0" autoincrement="0"><datatype>TIMESTAMP</datatype></row><key type="PRIMARY" name=""><part>id</part></key></table></sql>
\ No newline at end of file |