X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Ftable.lisp;h=d51960e3e06f617536bd167693d4ea9b3c5e4707;hb=f2a0eb003af406415567c9f8545455ede786db87;hp=52b5c1a155143c3b96a51228b9bfe4d504f2bc31;hpb=db9892632e6eb7869aea7a94c16b523a82de1501;p=clsql.git

diff --git a/sql/table.lisp b/sql/table.lisp
index 52b5c1a..d51960e 100644
--- a/sql/table.lisp
+++ b/sql/table.lisp
@@ -33,7 +33,7 @@
 ;; Tables 
 
 (defun create-table (name description &key (database *default-database*)
-                          (constraints nil))
+                          (constraints nil) (transactions t))
   "Create a table called NAME, in DATABASE which defaults to
 *DEFAULT-DATABASE*, containing the attributes in DESCRIPTION which is
 a list containing lists of attribute-name and type information pairs."
@@ -44,7 +44,8 @@ a list containing lists of attribute-name and type information pairs."
          (stmt (make-instance 'sql-create-table
                               :name table-name
                               :columns description
-                              :modifiers constraints)))
+                              :modifiers constraints
+			      :transactions transactions)))
     (execute-command stmt :database database)))
 
 (defun drop-table (name &key (if-does-not-exist :error)
@@ -173,6 +174,8 @@ specification of a table to drop the index from."
        (unless (index-exists-p index-name :database database)
          (return-from drop-index)))
       (:error t))
+    (unless (db-type-use-column-on-drop-index? (database-underlying-type database))
+      (setq on nil))
     (execute-command (format nil "DROP INDEX ~A~A" index-name
                              (if (null on) ""
                                  (concatenate 'string " ON "