X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql-create.lisp;h=2c35d9a96df5166380bf7821899f6141341766eb;hb=1b5b2e75a888e011706359e341b622a22f2023ea;hp=73605a9f285c7db454aece139825fb72272bf0d2;hpb=c1293bd68aa6ab9ef67bb486b2edda24aea98fee;p=umlisp.git diff --git a/sql-create.lisp b/sql-create.lisp index 73605a9..2c35d9a 100644 --- a/sql-create.lisp +++ b/sql-create.lisp @@ -1,3 +1,4 @@ + ;;;; -*- Mode: Lisp; Syntax: ANSI-Common-Lisp; Base: 10; Package: umlisp -*- ;;;; ************************************************************************* ;;;; FILE IDENTIFICATION @@ -7,7 +8,7 @@ ;;;; Programmer: Kevin M. Rosenberg ;;;; Date Started: Apr 2000 ;;;; -;;;; $Id: sql-create.lisp,v 1.1 2002/10/18 03:57:39 kevin Exp $ +;;;; $Id: sql-create.lisp,v 1.3 2002/10/21 08:23:52 kevin Exp $ ;;;; ;;;; This file, part of UMLisp, is ;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D. @@ -171,13 +172,13 @@ (init-umls) (init-hash-table) (with-sql-connection (conn) -;; (sql-drop-tables conn) -;; (sql-create-tables conn) -;; (sql-insert-all-values conn) + (sql-drop-tables conn) + (sql-create-tables conn) + (sql-insert-all-values conn) (sql-create-indexes conn) (sql-create-custom-tables conn) (sql-create-indexes conn +custom-index-cols+) - (sql-create-special-tables))) + (sql-create-special-tables conn))) (defun create-umls-db (&optional (extension ".trans") (copy-cmd #'mysql-copy-cmd)) @@ -259,6 +260,9 @@ This is much faster that using create-umls-db-insert." (custom-col-values (custom-colstructs-for-file file) line "|" nil)))) +;;; Routines for analyzing cost of fixed size storage + + (defun umls-fixed-size-waste () "Display storage waste if using all fixed size storage" (let ((totalwaste 0)