search

TsubakiBotPad / pad-data-pipeline

Original repo: https://github.com/nachoapps/dadguide-data
9 stars 2 forks source link

Move files and write PADDMSGParser #441

Closed chasehult closed 1 year ago

chasehult commented 1 year ago 
CREATE TABLE bgms (
  bgm_id int(11) PRIMARY KEY,
  name_ja text,
  name_en text,
  name_ko text,
  tstamp int(11) NOT NULL,

  KEY tstamp_idx (tstamp)
);

CREATE TABLE bgm_sets (
  bgm_set_id int(11) PRIMARY KEY,
  name_ja text,
  name_en text,
  name_ko text,
  route_bgm_id int(11) REFERENCES bgms (bgm_id),
  boss_bgm_id int(11) REFERENCES bgms (bgm_id),
  unused tinyint(1),
  tstamp int(11) NOT NULL,

  KEY tstamp_idx (tstamp)
);