diff options
| author | Ondrej Zara <ondrej.zara@gmail.com> | 2017-01-17 11:33:25 +0100 |
|---|---|---|
| committer | Ondrej Zara <ondrej.zara@gmail.com> | 2017-01-17 11:33:44 +0100 |
| commit | 6ed40fdab764e10f1890c6c7319efefc3b9d4732 (patch) | |
| tree | 0a9df7fe9e95dd67d6f6705f145ac25670d4387f | |
| parent | 3afa2f24763f117b0d2e24e4d1ff717fc8b030e2 (diff) | |
| download | wwwsqldesigner-6ed40fdab764e10f1890c6c7319efefc3b9d4732.zip wwwsqldesigner-6ed40fdab764e10f1890c6c7319efefc3b9d4732.tar.gz wwwsqldesigner-6ed40fdab764e10f1890c6c7319efefc3b9d4732.tar.bz2 | |
unique multi-column keys in sqlite, fixes #97
| -rw-r--r-- | db/sqlite/output.xsl | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/db/sqlite/output.xsl b/db/sqlite/output.xsl index 971419b..9208950 100644 --- a/db/sqlite/output.xsl +++ b/db/sqlite/output.xsl @@ -58,14 +58,10 @@ <!-- keys after table --> <xsl:for-each select="key"> - <xsl:if test="@type = 'UNIQUE' or (@type = 'PRIMARY' and count(child::part) > 1)"> + <xsl:if test="@type = 'UNIQUE' or (@type = 'PRIMARY' and count(child::part) > 1)"> <xsl:text>, </xsl:text> - <xsl:choose> - <xsl:when test="@type = 'PRIMARY'">PRIMARY KEY</xsl:when> - <xsl:when test="@type = 'UNIQUE'">UNIQUE</xsl:when> - </xsl:choose> - <xsl:text> (</xsl:text> + <xsl:text>UNIQUE (</xsl:text> <xsl:for-each select="part"> <xsl:value-of select="." /> |