[Summary view] [Print] [Text view]

   1  create table {$NAMESPACE}_repository.repository_commit (
   2    id int unsigned not null auto_increment primary key,
   3    repositoryPHID varchar(64) binary not null,
   4    phid varchar(64) binary not null,
   5    commitIdentifier varchar(40) binary not null,
   6    epoch int unsigned not null,
   7    unique key (phid),
   8    unique key (repositoryPHID, commitIdentifier)
   9  );
  10  
  11  
  12  create table {$NAMESPACE}_timeline.timeline_event (
  13    id int unsigned not null auto_increment primary key,
  14    type char(4) binary not null,
  15    key (type, id)
  16  );
  17  
  18  create table {$NAMESPACE}_timeline.timeline_eventdata (
  19    id int unsigned not null auto_increment primary key,
  20    eventID int unsigned not null,
  21    eventData longblob not null,
  22    unique key (eventID)
  23  );
  24  
  25  create table {$NAMESPACE}_timeline.timeline_cursor (
  26    name varchar(255) COLLATE `binary` not null primary key,
  27    position int unsigned not null
  28  );