text: # $Id: upgrade.my.sql 798 2008-04-13 19:59:24Z jberanek $
  
  drop table mrbs_entry_tmp;
  
  CREATE TABLE mrbs_entry_tmp (
    id int(11) NOT NULL auto_increment,
    room_id int(11) DEFAULT '1' NOT NULL,
    create_by varchar(25) DEFAULT '' NOT NULL,
    start_time int(11) NOT NULL,
    end_time int(11) NOT NULL,
    timestamp timestamp(14),
    type char(1) DEFAULT 'E' NOT NULL,
    name varchar(80) DEFAULT '' NOT NULL,
    description text,
    PRIMARY KEY (id)
  );
  
  insert into mrbs_entry_tmp (room_id, create_by, start_time,
              end_time, timestamp, type, name, description)
  
  select room_id, create_by, unix_timestamp(start_time),
         unix_timestamp(end_time), timestamp, type,
         name, description
  from mrbs_entry;
  
  drop table mrbs_entry;
  
  CREATE TABLE mrbs_entry (
    id int(11) NOT NULL auto_increment,
    room_id int(11) DEFAULT '1' NOT NULL,
    create_by varchar(25) DEFAULT '' NOT NULL,
    start_time int(11) NOT NULL,
    end_time int(11) NOT NULL,
    timestamp timestamp(14),
    type char(1) DEFAULT 'E' NOT NULL,
    name varchar(80) DEFAULT '' NOT NULL,
    description text,
    PRIMARY KEY (id),
    key idxStartTime (start_time),
    key idxEndTime (end_time)
  );
  
  insert into mrbs_entry select * from mrbs_entry_tmp;
  
  drop table mrbs_entry_tmp;
  