use moma;

drop table if exists artists;

create table artists (
  cid int primary key,
  displayname varchar(255),
  bio varchar(255),
  nationality varchar(255),
  gender varchar(8),
  begindate int,
  enddate int,	
  qid varchar(12),
  ulan varchar(12) )
  character set utf8;	

create index name_idx
on artists(displayname);