# Host: localhost Databáze : RS

# --------------------------------------------------------
#
# Struktura tabulky 'AUTORI'
#

DROP TABLE IF EXISTS autori;
CREATE TABLE autori (
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   login varchar(20) NOT NULL,
   pass varchar(32) NOT NULL,
   jmeno varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   oautorovi text NOT NULL,
   prava tinyint(3) unsigned DEFAULT '1' NOT NULL,
   stav char(1) DEFAULT 'n' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Struktura tabulky 'CLANKY'
#

DROP TABLE IF EXISTS clanky;
CREATE TABLE clanky (
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   id_autor int(10) unsigned DEFAULT '0' NOT NULL,
   id_rubrika int(10) unsigned DEFAULT '0' NOT NULL,
   datum int(10) unsigned DEFAULT '0' NOT NULL,
   counter int(10) unsigned DEFAULT '0' NOT NULL,
   priorita smallint(5) unsigned DEFAULT '0' NOT NULL,
   nadpis varchar(255),
   anotace text,
   clanek text,
   poznamka text,
   stav char(1) DEFAULT 'n',
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Struktura tabulky 'FORA'
#

DROP TABLE IF EXISTS fora;
CREATE TABLE fora (
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   id_clanku int(10) unsigned DEFAULT '0' NOT NULL,
   datum int(10) unsigned DEFAULT '0' NOT NULL,
   jmeno varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   predmet varchar(255) NOT NULL,
   text text NOT NULL,
   notify char(1) DEFAULT 'n' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Struktura tabulky 'NOVINKY'
#

DROP TABLE IF EXISTS novinky;
CREATE TABLE novinky (
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   novinka text,
   datum int(10) unsigned DEFAULT '0' NOT NULL,
   stav char(1) DEFAULT 'n' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Struktura tabulky 'RUBRIKY'
#

DROP TABLE IF EXISTS rubriky;
CREATE TABLE rubriky (
   id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
   rubrika varchar(50) NOT NULL,
   PRIMARY KEY (id)
);