# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : sny

# --------------------------------------------------------
#
# Table structure for table 'anketa_hlavicka'
#

CREATE TABLE anketa_hlavicka (
   id_anketa int(11) NOT NULL auto_increment,
   otazka varchar(255) NOT NULL,
   active char(2) DEFAULT 'A' NOT NULL,
   sirka int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id_anketa)
);


# --------------------------------------------------------
#
# Table structure for table 'anketa_odpoved'
#

CREATE TABLE anketa_odpoved (
   id_odpoved int(11) NOT NULL auto_increment,
   id_anketa int(11) DEFAULT '0' NOT NULL,
   odpoved varchar(255) NOT NULL,
   pocet int(11) DEFAULT '0' NOT NULL,
   barva varchar(255) NOT NULL,
   PRIMARY KEY (id_odpoved),
   KEY id_anketa (id_anketa)
);