DROP TABLE IF EXISTS r_logs;
CREATE TABLE IF NOT EXISTS r_logs (
  rlg_id int(10) NOT NULL AUTO_INCREMENT,
  rlg_client char(10) NOT NULL DEFAULT '',
  rlg_creuser char(4) NOT NULL DEFAULT '',
  rlg_created varchar(19) NOT NULL DEFAULT '0000-00-00 00:00:00',
  rlg_upduser char(4) NOT NULL DEFAULT '',
  rlg_updated varchar(19) NOT NULL DEFAULT '0000-00-00 00:00:00',
  rlg_updcount int(3) NOT NULL DEFAULT '0',
  rlg_l char(1) NOT NULL DEFAULT '',
  rlg_sync char(1) NOT NULL DEFAULT '',
  rlg_md5 char(1) NOT NULL DEFAULT '',
  rlg_rxxdb char(3) NOT NULL DEFAULT '',
  rlg_rxxid int(10) NOT NULL DEFAULT '0',
  rlg_text text NOT NULL,
  rlg_context varchar(50) NOT NULL DEFAULT '',
  rlg_link varchar(100) NOT NULL DEFAULT '',
  rlg_state char(2) NOT NULL DEFAULT '00',
  PRIMARY KEY (rlg_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;