[mbackup-devel] MySQL table format

[James O'K. <jo...@mi...>]

Someone reminded me that I forgot to include the table layout in the tar
ball. Try this:

#
# Table structure for table 'filelocation'
#

CREATE TABLE filelocation (
  filelocation_id int(32) NOT NULL auto_increment,
  filename varchar(255),
  checksum varchar(32),
  location varchar(255),
  PRIMARY KEY (filelocation_id)
);

#
# Table structure for table 'metadata'
#

CREATE TABLE metadata (
  metadata_id int(32) NOT NULL auto_increment,
  checksum varchar(32),
  filename varchar(255),
  filtered_name varchar(255),
  partnum int(16),
  lastpart int(16),
  current_size int(16),
  filelocation_id int(32),
  hostname varchar(255),
  st_dev int(64),
  st_ino int(32),
  st_mode int(32),
  st_nlink int(32),
  st_uid int(16),
  st_gid int(16),
  st_rdev int(64),
  st_size int(32),
  st_blksize int(32),
  st_blocks int(32),
  st_atime int(32),
  st_mtime int(32),
  st_ctime int(32),
  PRIMARY KEY (metadata_id),
  KEY metadata_index (checksum,filename)
);