X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Ftable.lisp;h=b9a5ef1bd1534d9215e441123549c63d9d299ef0;hb=a223800f208347e8a07f597648fcdb6c05ec5afe;hp=6491fade2719c1e510fe235eed0189c5f6baea79;hpb=a4097e19c5157e87b9991549bc44f3ef598aeb90;p=clsql.git diff --git a/sql/table.lisp b/sql/table.lisp index 6491fad..b9a5ef1 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,7 +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-use-column-on-drop-index? database) + (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) ""