CREATE TABLE linpackjava (
  mflops int not null,         # floating point operations (millions)
                               #
                               #      this number is actually Mflops * 1,000
                               #      so we can store it as an int.  we need
                               #      to use integer sorting instead of string
                               #      sorting which is all we could do when we
                               #      stored the number with its decimal in place
                               #        so, technically, the value in this field
                               #        is kflops instead of mflops.
                               #      mcmahan@cs.utk.edu
                               #
  time CHAR(8) not null,       # time to run benchmark
  cpu CHAR(25) not null,       # central processing unit 
  os CHAR(18) not null,        # operating system
  comments CHAR(130),          # specs on computer
  name CHAR(35),               # name of person 
  email CHAR(50) not null,     # email of person submitted by
# currtime INT not null,       # current time (secs since epoch)
#    INT wasn't big enough to hold this number
  currtime char(13) not null,  # current time (secs since epoch)
  residn CHAR(8) not null,     # residual
  epsilon CHAR(16) not null,   # machine epsilon
  version CHAR(17) not null    # applet version
) \g