rem "C:\Program Files\Java\jdk1.6.0_31\bin\"

rem "c:\Program Files\Java\jdk1.7.0\bin\java"
set PATH=G:\bin\GraphViz2.35\bin\;%PATH%
rem dot -?

"C:\Program Files\Java\jdk1.6.0_31\bin\java" -jar schemaSpy_5.0.0.jar  -t sqlite -dp ./sqlite.jar -db ./foods.db   -o ./q   -u main 

rem "C:\Program Files\Java\jdk1.6.0_31\bin\java" -jar schemaSpy_5.0.0.jar  -t dbType -db foods.db   -o .
exit

set X=G:\bin\Jar2Exe
rem %X%/j2ewiz.exe /m Srv /type console  /embed G:\agp\128\_work\JAVA-HTTP\bld\log4j-1.2.16.jar /embed G:\agp\128\_work\JAVA-HTTP\bld\org.apache.commons.io.jar /embed G:\agp\128\_work\JAVA-HTTP\bld\xmlrpc.jar  /embed G:\agp\128\_work\JAVA-HTTP\bld\Srv.jar Srv.jar /target 1.2
%X%/j2ewiz.exe 

-rw-rw-rw-   1 user     group    14279680 Apr  4  2012 trace.db
-rw-rw-rw-   1 user     group      516096 Aug 27  2011 sqlite_jni.dll
-rw-rw-rw-   1 user     group       65216 Aug 27  2011 sqlite.jar
-rw-rw-rw-   1 user     group      248945 Jan  8 19:06 schemaSpy_5.0.0.jar
drwxrwxrwx   1 user     group           0 Feb 26 23:37 q
-rwxrwxrwx   1 user     group         719 Feb 26 23:48 jar2exe.cmd
-rw-rw-rw-   1 user     group       34816 Apr  3  2006 foods.db
-rwxrwxrwx   1 user     group         116 Feb 26 23:07 dot.cmd
drwxrwxrwx   1 user     group           0 Feb 26 23:01 diagrams
-rw-rw-rw-   1 user     group        1831 Feb 26 23:27 db.db.xml
-rw-rw-rw-   1 user     group        5120 Oct 10 09:30 db.db
drwxrwxrwx   1 user     group           0 Feb 26 22:48 bin
-rw-rw-rw-   1 user     group     3663559 Feb 26 22:57 SqliteJdbcDriver.zip

set PATH=G:\bin\GraphViz2008\bin\;%PATH%
rem dot -?
rem "G:\agp\128\prj\testSchemaSpy\bin\java" -jar schemaSpy_5.0.0.jar  -s main  -t sqlite  -dp ./sqlite-jdbc4-3.8.2-SNAPSHOT.jar   -db ./b.db   -o ./q  -u main
 
"C:\Program Files\Java\jdk1.7.0\bin\java" -jar schemaSpy_5.0.0.jar -hq  -t sqlite  -dp ./sqlite-jdbc4-3.8.2-SNAPSHOT.jar   -db ./db.db   -o ./db  -u main >.log.log 2>.errors.log

total 7040
drwxrwxrwx   1 user     group           0 Mar  7 20:23 db
-rw-rw-rw-   1 user     group        8192 Mar  7 20:23 db.db
-rwxrwxrwx   1 user     group        1249 Mar  7 20:20 mkSchemaSpy.cmd
-rw-rw-rw-   1 user     group      248945 Feb 27 11:30 schemaSpy_5.0.0.jar
-rw-rw-rw-   1 user     group     3201128 Feb 27 11:30 sqlite-jdbc-3.7.2.jar
-rw-rw-rw-   1 user     group     3745548 Feb 27 12:04 sqlite-jdbc4-3.8.2-SNAPSHOT.jar
-rw-rw-rw-   1 user     group         140 Mar  7 20:11 sqlite.properties

description=SQLite-Xerial
driver=org.sqlite.JDBC
driverPath=sqlite-jdbc4-3.8.2-SNAPSHOT.jar 
connectionSpec=jdbc:sqlite:./db.db
db=db.db

// dot 2.34.0 on Windows XP 5.1
// SchemaSpy rev 590
digraph "largeRelationshipsDiagram" {
  graph [
    rankdir="RL"
    bgcolor="#f7f7f7"
    label="\nGenerated by SchemaSpy"
    labeljust="l"
    nodesep="0.18"
    ranksep="0.46"
    fontname="Helvetica"
    fontsize="11"
  ];
  node [
    fontname="Helvetica"
    fontsize="11"
    shape="plaintext"
  ];
  edge [
    arrowsize="0.8"
  ];
  "cities" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">cities</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="Cname" COLSPAN="3" ALIGN="LEFT">Cname</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">16 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">2 ></TD></TR>
    </TABLE>>
    URL="tables/cities.html"
    tooltip="cities"
  ];
  "jets" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">jets</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="pName" COLSPAN="3" ALIGN="LEFT">pName</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">  </TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 ></TD></TR>
    </TABLE>>
    URL="tables/jets.html"
    tooltip="jets"
  ];
  "jumpss" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">jumpss</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="ffrom" COLSPAN="3" ALIGN="LEFT">ffrom</TD></TR>
      <TR><TD PORT="tto" COLSPAN="3" ALIGN="LEFT">tto</TD></TR>
      <TR><TD PORT="llength" COLSPAN="3" ALIGN="LEFT">llength</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">3 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">1 ></TD></TR>
    </TABLE>>
    URL="tables/jumpss.html"
    tooltip="jumpss"
  ];
  "movement" [
    label=<
    <TABLE BORDER="0" CELLBORDER="1" CELLSPACING="0" BGCOLOR="#ffffff">
      <TR><TD COLSPAN="3" BGCOLOR="#9bab96" ALIGN="CENTER">movement</TD></TR>
      <TR><TD PORT="id" COLSPAN="3" ALIGN="LEFT">id</TD></TR>
      <TR><TD PORT="jets" COLSPAN="3" ALIGN="LEFT">jets</TD></TR>
      <TR><TD PORT="jumps" COLSPAN="3" ALIGN="LEFT">jumps</TD></TR>
      <TR><TD PORT="flight" COLSPAN="3" ALIGN="LEFT">flight</TD></TR>
      <TR><TD PORT="ordNumb" COLSPAN="3" ALIGN="LEFT">ordNumb</TD></TR>
      <TR><TD PORT="takeoff" COLSPAN="3" ALIGN="LEFT">takeoff</TD></TR>
      <TR><TD PORT="landed" COLSPAN="3" ALIGN="LEFT">landed</TD></TR>
      <TR><TD ALIGN="LEFT" BGCOLOR="#f7f7f7">< 2</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">7 rows</TD><TD ALIGN="RIGHT" BGCOLOR="#f7f7f7">  </TD></TR>
    </TABLE>>
    URL="tables/movement.html"
    tooltip="movement"
  ];
  "jumpss":"ffrom":w -> "cities":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "jumpss":"tto":w -> "cities":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "movement":"jets":w -> "jets":"id":e [arrowhead=none dir=back arrowtail=crowodot];
  "movement":"jumps":w -> "jumpss":"id":e [arrowhead=none dir=back arrowtail=crowodot];
}