CREATE TABLE "entries" (
  "id" int(11) NOT NULL auto_increment,
  "ent_seq" int(11) default NULL,
  "english_search" text,
  "japanese_search" text,
  "entry" text,
  PRIMARY KEY  ("id")
);

CREATE TABLE "glosses" (
  "id" int(11) NOT NULL auto_increment,
  "sense_id" int(11) default NULL,
  "language" varchar(255) default NULL,
  "gender" varchar(255) default NULL,
  "gloss" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "kanjis" (
  "id" int(11) NOT NULL auto_increment,
  "type" varchar(255) default NULL,
  "entry_id" int(11) default NULL,
  "kanji" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "notes" (
  "id" int(11) NOT NULL auto_increment,
  "entry_id" int(11) default NULL,
  "sense_id" int(11) default NULL,
  "note" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "priorities" (
  "id" int(11) NOT NULL auto_increment,
  "kanji_id" int(11) default NULL,
  "reading_id" int(11) default NULL,
  "priority" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "readings" (
  "id" int(11) NOT NULL auto_increment,
  "type" varchar(255) default NULL,
  "entry_id" int(11) default NULL,
  "reading" varchar(255) default NULL,
  "no_kanji" tinyint(1) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "refs" (
  "id" int(11) NOT NULL auto_increment,
  "sense_id" int(11) default NULL,
  "ref" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "restrictions" (
  "id" int(11) NOT NULL auto_increment,
  "reading_id" int(11) default NULL,
  "sense_id" int(11) default NULL,
  "restriction" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "senses" (
  "id" int(11) NOT NULL auto_increment,
  "entry_id" int(11) default NULL,
  PRIMARY KEY  ("id")
);

CREATE TABLE "tags" (
  "id" int(11) NOT NULL auto_increment,
  "kanji_id" int(11) default NULL,
  "reading_id" int(11) default NULL,
  "sense_id" int(11) default NULL,
  "entry_id" int(11) default NULL,
  "tag" varchar(255) default NULL,
  PRIMARY KEY  ("id")
);