use moma;

drop table if exists artworks;

create table artworks (
  title varchar(1000),
  workdate varchar(255),
  medium varchar(1400),
  dimensions varchar(3200),
  creditline varchar(800),
  accessionnumber varchar(32),
  classification varchar(32),
  department varchar(40),
  dateacquired varchar(20),
  cataloged char(1),
  objectid int primary key,
  url varchar(255),
  thumbnailurl varchar(255),
  circumference numeric(12,4),
  depth numeric(12,5),
  diameter numeric(12,5),
  height numeric(12,5),
  length numeric(12,5),
  weight numeric(12,5),
  width numeric(12,5),
  seatheight numeric(12,5),
  duration numeric(12,5)
)
character set utf8
;