Re: Instalace galerie
Zaslán uživatelem/kou:
kadehak (IP adresa zaznamenána)
Datum: 2008-06-04, 09:00
Ďakujem za návod - pomohlo to. Tu je obsah galerie.sql :
#
# galerie ( 4 tabulky)
#
# kodovani: Windows-1250
#
# zalozeni database
# create database galerie;
# pripojeni na galerie db
# connect galerie;
# *** zalozeni tabulky
# *** vlozeni default dat do tabulky
CREATE TABLE rs_gallery (
gallery_id int(11) NOT NULL auto_increment,
gallery_title varchar(255) NOT NULL default '',
gallery_user_id int(11) NOT NULL default '0',
gallery_description text NOT NULL,
gallery_admin int(1) NOT NULL default '0',
gallery_zalozeni datetime NOT NULL default '0000-00-00 00:00:00',
gallery_uprava datetime NOT NULL default '0000-00-00 00:00:00',
gallery_zobrazit int(1) NOT NULL default '3',
gallery_delete int(1) NOT NULL default '0',
gallery_zobrazeni int(5) NOT NULL default '0',
gallery_verejna int(3) NOT NULL default '0',
PRIMARY KEY (gallery_id)
) ;
CREATE TABLE rs_gallery_konfigurace (
idk smallint(5) unsigned NOT NULL auto_increment,
nazev varchar(50) NOT NULL default '',
hodnota varchar(50) NOT NULL default '',
PRIMARY KEY (idk)
) ;
INSERT INTO rs_gallery_konfigurace VALUES (1, 'pocet_gal_admin', '50');
INSERT INTO rs_gallery_konfigurace VALUES (2, 'pocet_gal_redaktor', '25');
INSERT INTO rs_gallery_konfigurace VALUES (3, 'pocet_gal_autor', '10');
INSERT INTO rs_gallery_konfigurace VALUES (4, 'pocet_gal_ctenar', '3');
INSERT INTO rs_gallery_konfigurace VALUES (5, 'nahled_sirka', '120');
INSERT INTO rs_gallery_konfigurace VALUES (6, 'nahled_vyska', '120');
INSERT INTO rs_gallery_konfigurace VALUES (7, 'galerie_interni', '1');
INSERT INTO rs_gallery_konfigurace VALUES (8, 'ftp_admin', '1');
INSERT INTO rs_gallery_konfigurace VALUES (9, 'ftp_redaktor', '0');
INSERT INTO rs_gallery_konfigurace VALUES (10, 'ftp_autor', '0');
INSERT INTO rs_gallery_konfigurace VALUES (11, 'ftp_ctenar', '1');
INSERT INTO rs_gallery_konfigurace VALUES (12, 'top_prehled', '9');
INSERT INTO rs_gallery_konfigurace VALUES (24, 'hromadne_pridani', '10');
INSERT INTO rs_gallery_konfigurace VALUES (23, 'celkove_vyrazeni_externi', '1');
INSERT INTO rs_gallery_konfigurace VALUES (15, 'strankovani', '20');
INSERT INTO rs_gallery_konfigurace VALUES (17, 'gallery_dir', 'gallery/');
INSERT INTO rs_gallery_konfigurace VALUES (18, 'phprs_verze', '265');
INSERT INTO rs_gallery_konfigurace VALUES (19, 'gd_verze', 'gd2');
INSERT INTO rs_gallery_konfigurace VALUES (20, 'pocet_znaku', '15');
INSERT INTO rs_gallery_konfigurace VALUES (21, 'pocet_sloupcu', '3');
INSERT INTO rs_gallery_konfigurace VALUES (22, 'velikost_obrazek', '200');
INSERT INTO rs_gallery_konfigurace VALUES (25, 'copyright_text', '(c) phpRS');
CREATE TABLE rs_media (
media_id int(11) NOT NULL auto_increment,
media_gallery_id int(11) NOT NULL default '0',
media_file varchar(255) NOT NULL default '',
media_thumbnail varchar(255) NOT NULL default '',
media_thumbnail_width int(11) NOT NULL default '0',
media_thumbnail_height int(11) NOT NULL default '0',
media_caption varchar(255) NOT NULL default '',
media_description text,
media_size int(11) NOT NULL default '0',
media_width int(11) NOT NULL default '0',
media_height int(11) NOT NULL default '0',
media_view int(11) NOT NULL default '0',
media_znamka int(10) NOT NULL default '0',
media_hodnotilo int(10) NOT NULL default '0',
media_smazano int(3) NOT NULL default '0',
PRIMARY KEY (media_id)
) ;
CREATE TABLE rs_media_komentare (
idk int(10) unsigned NOT NULL auto_increment,
datum datetime NOT NULL default '0000-00-00 00:00:00',
obsah text,
obrazek int(10) unsigned NOT NULL default '0',
od varchar(60) default '',
od_mail varchar(80) default '',
od_ip varchar(50) default '',
titulek varchar(80) NOT NULL default '',
reakce_na int(10) unsigned default '0',
PRIMARY KEY (idk)
) ;