# *** zalozeni nove tabulky rs_klik_kampan

create table rs_klik_kampan
(
idk int unsigned auto_increment not null,
alias char(20) not null,
info char(100) not null,
email char(80),
primary key(idk)
);

# *** zalozeni nove tabulky rs_klik_ban

create table rs_klik_ban
(
idb int unsigned auto_increment not null,
id_kampan int unsigned not null,
datum date,
alias char(20),
text char(80),
banner text,
cil char(100),
width int unsigned not null default 0,
height int unsigned not null default 0,
druh tinyint unsigned not null default 0,
pocitadlo int unsigned not null default 0,
primary key(idb)
);

# *** zalozeni nove tabulky rs_klik_rekl

create table rs_klik_rekl
(
idr tinyint unsigned auto_increment not null,
pozice tinyint unsigned not null,
kod text,
primary key(idr)
);

# Vlozeni default dat do tabulky rs_klik_rekl

insert into rs_klik_rekl values
(null,'1','<a href="http://www.supersvet.cz" target="_blank"><img src="image/reklama7.gif" alt="GNU redakční systém phpRS" width="468" height="60"><br><font size=1 face="Arial CE,Arial">GNU redakční systém phpRS</font></a>');
insert into rs_klik_rekl values
(null,'2','<a href="http://www.supersvet.cz" target="_blank"><img src="image/reklama7.gif" alt="GNU redakční systém phpRS" width="468" height="60"><br><font size=1 face="Arial CE,Arial">GNU redakční systém phpRS</font></a>');