Potřebné altery
alter table tkategorie modify velikostporce int(3);
alter table tcipy modify cipstav int(3);
alter table tstravnicistat add column locale varchar(5) default 'cs';
alter table rtr_statistics add column message varchar(255);
alter table tstravnicistat modify StravnikPassword VARCHAR(255) ;
alter table tstravnicistat add column homePage VARCHAR(25) ;

CREATE TABLE rtr_audit_type (
audit_type_id int(10) unsigned NOT NULL auto_increment,
auditTxt varchar(100) character set utf8 NOT NULL default '',
 auditType tinyint(4) unsigned default '0',
PRIMARY KEY (`audit_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
 insert into rtr_audit_type (auditType, auditTxt) values (1, 'Vytvořena objednávka');
insert into rtr_audit_type (auditType, auditTxt) values (2, 'Zrušena objednávka');
insert into rtr_audit_type (auditType, auditTxt) values (3, 'Odebrán další chod');
 insert into rtr_audit_type (auditType, auditTxt) values (4, 'Odebrán další chod');
insert into rtr_audit_type (auditType, auditTxt) values (5, 'Objednávka dána do burzy');
insert into rtr_audit_type (auditType, auditTxt) values (7, 'Uživatel přihlášen přes iCanteen');


create table persistent_logins (
    username varchar(64) not null,
    series varchar(64) primary key,
    token varchar(64) not null,
    last_used timestamp not null
) engine = InnoDb;



CREATE TABLE `tzakvyd` (
  `ZakVyd_Id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `U_id` int(10) unsigned DEFAULT NULL,
  `Stravnik_id` int(11) unsigned DEFAULT NULL,
  `Vydejna_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`ZakVyd_Id`),
  UNIQUE KEY `uvyd_u` (`U_id`,`Vydejna_id`),
  UNIQUE KEY `strvyd_u` (`Stravnik_id`,`Vydejna_id`),
  KEY `vydejna_i` (`Vydejna_id`),
  KEY `stravnik_i` (`Stravnik_id`)
) ENGINE=innoDB;

CREATE TABLE `tskupiny` (
  `Skupina_Id` tinyint(11) unsigned NOT NULL AUTO_INCREMENT,
  `SkupinaTxt` varchar(30) NOT NULL DEFAULT '',
  `SkupDo` varchar(11) DEFAULT '',
  `PovysSkup_Id` tinyint(11) unsigned NOT NULL DEFAULT '0',
  `ZkrS` varchar(4) DEFAULT '',
  PRIMARY KEY (`Skupina_Id`)
) ENGINE=innoDB;

CREATE TABLE `tzasji` (
  `ZasJi_id` int(10) unsigned NOT NULL auto_increment,
  `Stravnik_id` int(11) unsigned default NULL,
  `Chod_id` int(11) unsigned default NULL,
  `DruhPotr_id` int(11) unsigned default null,
  `zbozi_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`ZasJi_Id`),
  UNIQUE KEY `Zasji_ui` (`Stravnik_id`,`zbozi_id`),
  UNIQUE KEY `Zasch_ui` (`Stravnik_id`,`Chod_id`),
  UNIQUE KEY `Zasdr_ui` (`Stravnik_id`,`DruhPotr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `pavpoctyobj` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `oscis` int(11) unsigned NOT NULL default '0',
  `obdobi` varchar(4) NOT NULL default '0000',
  `aktualizace` timestamp default '0000-00-00 00:00:00',
  `O` int(11) NOT NULL default '0',
  `S` int(11) NOT NULL default '0',
  `V` int(11) NOT NULL default '0',
  `DS` int(11) NOT NULL default '0',
  `SV` int(11) NOT NULL default '0',
  `DTO` date default '0000-00-00',
  `DTS` date default '0000-00-00',
  `DTV` date default '0000-00-00',
  `DTDS` date default '0000-00-00',
  `DTSV` date default '0000-00-00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `prim_klic` (`oscis`,`obdobi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='PoctyObj';

CREATE TABLE IF NOT EXISTS `pavzust` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `oscis` int(11) unsigned NOT NULL default '0',
  `obdobi` varchar(4) NOT NULL default '0000',
  `aktualizace` timestamp default '0000-00-00 00:00:00',
  `zustatek` double NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `prim_klic` (`oscis`,`obdobi`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Zustatky';

alter table rtr_sablony add column vydejoddisplay datetime;
alter table rtr_sablony add column vydejdodisplay datetime;

update rtr_sablony set vydejoddisplay=vydejod;

update rtr_sablony set vydejdodisplay=vydejdo;