CREATE TABLE navrh 
    ( 
     id_navrhu INT (6)  NOT NULL AUTO_INCREMENT PRIMARY KEY, 
     kod TEXT  NOT NULL , 
     nahled VARCHAR (30) , 
     heslo VARCHAR (30) ,  
     id_pozadi INT (5)  NOT NULL 
    ) 
;

insert into navrh(kod, nahled, heslo, id_pozadi) values (' 
                <div id="pozadiBarva" style="background-color: rgb(196, 255, 232);"></div>
                <div id="pozadi" style="width: 100%; height: 100%; position: absolute; top: 0px; left: 0px; z-index: 1; opacity: 0.75; background-image: url(&quot;pozadi/01_Sackton.png&quot;); background-size: 100% auto;"></div>

            <divtext id="text" style="position: absolute; left: 28px; top: 49px; z-index: 2; font-family: Impact, Charcoal, sans-serif; color: rgb(15, 15, 133); text-shadow: rgb(130, 197, 255) 2px 2px 5px; font-size: 49px; border: 0px solid rgb(255, 51, 51);" class="objText">COMPANY s.r.o.</divtext><img src="pics/logo.png" id="picture" style="position: absolute; left: 301px; top: -22px; z-index: 2; border: 0px solid rgb(255, 51, 51);" class="dragme" width="250"><divtext id="text" style="position: absolute; left: 26px; top: 162px; z-index: 2; font-family: Georgia, Georgia, serif; color: rgb(184, 255, 253); font-size: 31px; text-shadow: rgb(48, 51, 138) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Petr Novk</divtext><divtext id="text" style="position: absolute; left: 26px; top: 208px; z-index: 2; font-size: 25px; color: rgb(184, 255, 253); text-shadow: rgb(45, 52, 138) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Tel: 723 555 222</divtext><divtext id="text" style="position: absolute; left: 28px; top: 246px; z-index: 2; font-size: 25px; color: rgb(184, 255, 253); text-shadow: rgb(47, 53, 138) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Email: mail@comp.cz</divtext>
', 
'images/53538f10d41ff.png', 'heslo',1);

insert into navrh(kod, nahled, heslo, id_pozadi) values (' 
                <div id="pozadiBarva" style="background-color: rgb(250, 255, 201);"></div>
                <div id="pozadi" style="width: 100%; height: 100%; position: absolute; top: 0px; left: 0px; z-index: 1; background-image: url(http://localhost/bc/produkty/pozadi/02_Duncan.png); background-size: 100%; opacity: 0.5;"></div>

            <divtext id="text" style="position: absolute; left: 34px; top: 63px; z-index: 2; color: rgb(97, 90, 26); text-shadow: rgb(235, 255, 135) 2px 2px 5px; font-size: 56px; font-family: Candal, Chiller, sans-serif; border: 0px solid rgb(255, 51, 51);" class="objText">Company s.r.o.</divtext><img src="pics/logo.png" id="picture" style="position: absolute; left: 405px; top: -19px; z-index: 2; width: 158px; border: 0px solid rgb(255, 51, 51);" class="dragme" width="250"><divtext id="text" style="position: absolute; left: 209px; top: 161px; z-index: 2; font-family: Georgia, Georgia, serif; color: rgb(49, 51, 24); font-size: 53px; text-shadow: rgb(255, 248, 153) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Pavel Novk</divtext><divtext id="text" style="position: absolute; left: 19px; top: 251px; z-index: 2; color: rgb(49, 51, 24); text-shadow: rgb(255, 252, 153) 2px 2px 5px; font-size: 32px; font-family: Trebuchet MS, Georgia, serif; border: 0px solid rgb(255, 51, 51);" class="objText">Tel: 723 600 100</divtext><divtext id="text" style="position: absolute; left: 319px; top: 248px; z-index: 2; color: rgb(49, 51, 24); text-shadow: rgb(255, 255, 156) 2px 2px 5px; font-size: 32px; font-family: Trebuchet MS, Georgia, serif; border: 0px solid rgb(255, 51, 51);" class="objText">mail2@comp.cz</divtext>

', 
'images/535a089c8fe00.png', 'heslo',2);

CREATE TABLE objednavka 
    ( 
     id_objednavky INT (6)  NOT NULL AUTO_INCREMENT PRIMARY KEY, 
     jmeno VARCHAR (50) , 
     osoba VARCHAR (50)  NOT NULL , 
     ulice VARCHAR (50)  NOT NULL , 
     mesto VARCHAR (50)  NOT NULL , 
     psc VARCHAR (15)  NOT NULL , 
     ico VARCHAR (20) , 
     dic VARCHAR (20) , 
     telefon VARCHAR (20) , 
     email VARCHAR (50)  NOT NULL , 
     poznamky TEXT , 
     nahled VARCHAR (30)  NOT NULL , 
     kusy INT (5)  NOT NULL , 
     cena INT (6)  NOT NULL , 
     vyrizeno tinyint(1) 
    ) 
;

insert into objednavka(jmeno, osoba, ulice, mesto, psc, ico, dic, telefon, email, poznamky, nahled, kusy, cena, vyrizeno) 
values ('Company s.r.o', 'Petr Novk', 'Pardubick 315','Nchod', '549 40', '405 24 485', 'CZ405 24 485', '723555222', 'mail@comp.cz', 'Lamino', 'images/53538f10d41ff.png',2000, 1600, 0);

insert into objednavka(jmeno, osoba, ulice, mesto, psc, ico, dic, telefon, email, poznamky, nahled, kusy, cena, vyrizeno) 
values ('Company s.r.o', 'Pavel Novk', 'Pardubick 315','Nchod', '549 40', '405 24 485', 'CZ405 24 485', '723600100', 'mail2@comp.cz', 'Bez lamina', 'images/535a089c8fe00.png',800, 1040, 0);





CREATE TABLE pozadi 
    ( 
     id_pozadi INT (5)  NOT NULL AUTO_INCREMENT PRIMARY KEY, 
     cesta VARCHAR (30)  NOT NULL , 
     odkaz VARCHAR (200)  NOT NULL , 
     autor VARCHAR (40)  NOT NULL 
    ) 
;

insert into pozadi(cesta, odkaz, autor) values ('01_Sackton.png', 'http://www.flickr.com/photos/sackton/7941527304/', 'Tim Sackton');
insert into pozadi(cesta, odkaz, autor) values ('02_Duncan.png', 'https://www.flickr.com/photos/duncanh1/4023982016/in/set-72157622628464500/', 'Duncan');


CREATE TABLE sablona 
    ( 
     id_sablony INT (5)  NOT NULL AUTO_INCREMENT PRIMARY KEY, 
     kod TEXT  NOT NULL , 
     nahled VARCHAR (30) , 
     id_pozadi INT (5)  NOT NULL 
    ) 
;

insert into sablona(kod, nahled, id_pozadi) values (' 
                <div id="pozadiBarva" style="background-color: rgb(196, 255, 232);"></div>
                <div id="pozadi" style="width: 100%; height: 100%; position: absolute; top: 0px; left: 0px; z-index: 1; opacity: 0.75; background-image: url(&quot;pozadi/01_Sackton.png&quot;); background-size: 100% auto;"></div>

            <divtext id="text" style="position: absolute; left: 28px; top: 49px; z-index: 2; font-family: Impact, Charcoal, sans-serif; color: rgb(15, 15, 133); text-shadow: rgb(130, 197, 255) 2px 2px 5px; font-size: 49px; border: 0px solid rgb(255, 51, 51);" class="objText">NZEV FIRMY</divtext><img src="pics/logo.png" id="picture" style="position: absolute; left: 301px; top: -22px; z-index: 2; border: 0px solid rgb(255, 51, 51);" class="dragme" width="250"><divtext id="text" style="position: absolute; left: 26px; top: 162px; z-index: 2; font-family: Georgia, Georgia, serif; color: rgb(135, 227, 255); font-size: 31px; text-shadow: rgb(48, 51, 138) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Jmno</divtext><divtext id="text" style="position: absolute; left: 26px; top: 208px; z-index: 2; font-size: 25px; color: rgb(128, 225, 255); text-shadow: rgb(45, 52, 138) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Telefon</divtext><divtext id="text" style="position: absolute; left: 28px; top: 246px; z-index: 2; font-size: 25px; color: rgb(135, 227, 255); text-shadow: rgb(47, 53, 138) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Email</divtext>
', 
'images/535383826f7cc.png',1);

insert into sablona(kod, nahled, id_pozadi) values (' 
                <div id="pozadiBarva" style="background-color: rgb(250, 255, 201);"></div>
                <div id="pozadi" style="width: 100%; height: 100%; position: absolute; top: 0px; left: 0px; z-index: 1; background-image: url(&quot;pozadi/02_Duncan.png&quot;); background-size: 100%; opacity: 0.5;"></div>

            <divtext id="text" style="position: absolute; left: 48px; top: 72px; z-index: 2; color: rgb(97, 90, 26); text-shadow: rgb(235, 255, 135) 2px 2px 5px; font-family: Candal, Chiller, sans-serif; font-size: 56px; border: 0px solid rgb(255, 51, 51);" class="objText">NZEV FIRMY</divtext><img src="pics/logo.png" id="picture" style="position: absolute; left: 405px; top: -19px; z-index: 2; width: 158px; border: 0px solid rgb(255, 51, 51);" class="dragme" width="250"><divtext id="text" style="position: absolute; left: 253px; top: 166px; z-index: 2; font-family: Georgia, Georgia, serif; color: rgb(49, 51, 24); font-size: 53px; text-shadow: rgb(255, 248, 153) 2px 2px 5px; border: 0px solid rgb(255, 51, 51);" class="objText">Jmno</divtext><divtext id="text" style="position: absolute; left: 19px; top: 251px; z-index: 2; color: rgb(49, 51, 24); text-shadow: rgb(255, 252, 153) 2px 2px 5px; font-size: 32px; border: 0px solid rgb(255, 51, 51);" class="objText">Telefon</divtext><divtext id="text" style="position: absolute; left: 440px; top: 247px; z-index: 2; color: rgb(49, 51, 24); text-shadow: rgb(255, 255, 156) 2px 2px 5px; font-size: 32px; border: 0px solid rgb(255, 51, 51);" class="objText">Email</divtext>

', 
'images/535384dd610b9.png',2);


