# *** pridani sloupce level do tabulky rs_topic

alter table rs_topic add (level tinyint unsigned default 0);

# *** pridani sloupce rodic do tabulky rs_topic

alter table rs_topic add (rodic tinyint unsigned default 0);

# *** pridani sloupce id_predka do tabulky rs_topic

alter table rs_topic add (id_predka smallint unsigned default 0);

# *** pridani sloupce skupina_cl do tabulky rs_clanky

alter table rs_clanky add (skupina_cl smallint unsigned default 0);

# *** pridani sloupce hodnoceni do tabulky rs_clanky

alter table rs_clanky add (hodnoceni tinyint unsigned default 0);

# *** zalozeni tabulky rs_skup_cl

create table rs_skup_cl
(
ids int unsigned auto_increment not null,
nazev_skup varchar(100),
primary key(ids)
);