From darcs: * Teach expressions how to deal with identity columns

diff --git a/sql/expressions.lisp b/sql/expressions.lisp
index 6aaededd7c6b32aa1c58337c9257fc6e400d29a8..63885153259d9fad208f1a9bc3636372936e340e 100644 (file)
--- a/sql/expressions.lisp
+++ b/sql/expressions.lisp
@@ -967,7 +967,9 @@ uninclusive, and the args from that keyword to the end."
    (cons (symbol-name-default-case "UNSIGNED") "UNSIGNED")
    (cons (symbol-name-default-case "ZEROFILL") "ZEROFILL")
    (cons (symbol-name-default-case "AUTO-INCREMENT") "AUTO_INCREMENT")
-   (cons (symbol-name-default-case "UNIQUE") "UNIQUE")))
+   (cons (symbol-name-default-case "UNIQUE") "UNIQUE")
+   (cons (symbol-name-default-case "IDENTITY") "IDENTITY (1,1)") ;Added Identity for MS-SQLServer support
+   ))
 
 (defmethod database-constraint-statement (constraint-list database)
   (declare (ignore database))