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

# --------------------------------------------------------
#
# Table structure for table 'admin'
#

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
   login text NOT NULL,
   pass text NOT NULL
);


# --------------------------------------------------------
#
# Table structure for table 'country'
#

DROP TABLE IF EXISTS country;
CREATE TABLE country (
   code char(3) NOT NULL,
   cname varchar(25) NOT NULL,
   PRIMARY KEY (code)
);


# --------------------------------------------------------
#
# Table structure for table 'email'
#

DROP TABLE IF EXISTS email;
CREATE TABLE email (
   id int(11) NOT NULL auto_increment,
   data text,
   name text,
   email text,
   subject text,
   message blob,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'incoming'
#

DROP TABLE IF EXISTS incoming;
CREATE TABLE incoming (
   id int(11) NOT NULL auto_increment,
   data text,
   name text,
   surname text,
   address text,
   country text NOT NULL,
   city text,
   city_cod text,
   phone int(11),
   fax int(11),
   email text,
   data_from int(11),
   month_from text,
   year_from int(11),
   data_to int(11),
   month_to text,
   year_to int(11),
   month text,
   year text,
   nights int(11),
   weeks int(11),
   number_person int(11),
   child_12 int(11),
   child_5 int(11),
   price text,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'period'
#

DROP TABLE IF EXISTS period;
CREATE TABLE period (
   ID int(11) DEFAULT '0' NOT NULL,
   jan1 int(11) DEFAULT '0' NOT NULL,
   jan2 int(11) DEFAULT '0' NOT NULL,
   jan3 int(11) DEFAULT '0' NOT NULL,
   jan4 int(11) DEFAULT '0' NOT NULL,
   feb1 int(11) DEFAULT '0' NOT NULL,
   feb2 int(11) DEFAULT '0' NOT NULL,
   feb3 int(11) DEFAULT '0' NOT NULL,
   feb4 int(11) DEFAULT '0' NOT NULL,
   mar1 int(11) DEFAULT '0' NOT NULL,
   mar2 int(11) DEFAULT '0' NOT NULL,
   mar3 int(11) DEFAULT '0' NOT NULL,
   mar4 int(11) DEFAULT '0' NOT NULL,
   apr1 int(4) DEFAULT '0' NOT NULL,
   apr2 int(4) DEFAULT '0' NOT NULL,
   apr3 int(4) DEFAULT '0' NOT NULL,
   apr4 int(4) DEFAULT '0' NOT NULL,
   may1 int(4) DEFAULT '0' NOT NULL,
   may2 int(4) DEFAULT '0' NOT NULL,
   may3 int(4) DEFAULT '0' NOT NULL,
   may4 int(4) DEFAULT '0' NOT NULL,
   june1 int(4) DEFAULT '0' NOT NULL,
   june2 int(4) DEFAULT '0' NOT NULL,
   june3 int(4) DEFAULT '0' NOT NULL,
   june4 int(4) DEFAULT '0' NOT NULL,
   july1 int(11) DEFAULT '0' NOT NULL,
   july2 int(11) DEFAULT '0' NOT NULL,
   july3 int(11) DEFAULT '0' NOT NULL,
   july4 int(11) DEFAULT '0' NOT NULL,
   aug1 int(4) DEFAULT '0' NOT NULL,
   aug2 int(4) DEFAULT '0' NOT NULL,
   aug3 int(4) DEFAULT '0' NOT NULL,
   aug4 int(4) DEFAULT '0' NOT NULL,
   sept1 int(4) DEFAULT '0' NOT NULL,
   sept2 int(4) DEFAULT '0' NOT NULL,
   sept3 int(4) DEFAULT '0' NOT NULL,
   sept4 int(4) DEFAULT '0' NOT NULL,
   okt1 int(4) DEFAULT '0' NOT NULL,
   okt2 int(4) DEFAULT '0' NOT NULL,
   okt3 int(4) DEFAULT '0' NOT NULL,
   okt4 int(4) DEFAULT '0' NOT NULL,
   nov1 int(11) DEFAULT '0' NOT NULL,
   nov2 int(11) DEFAULT '0' NOT NULL,
   nov3 int(11) DEFAULT '0' NOT NULL,
   nov4 int(11) DEFAULT '0' NOT NULL,
   dec1 int(11) DEFAULT '0' NOT NULL,
   dec2 int(11) DEFAULT '0' NOT NULL,
   dec3 int(11) DEFAULT '0' NOT NULL,
   dec4 int(11) DEFAULT '0' NOT NULL
);


# --------------------------------------------------------
#
# Table structure for table 'price'
#

DROP TABLE IF EXISTS price;
CREATE TABLE price (
   currency text,
   person1 int(11),
   person2 int(11),
   person3 int(11),
   person4 int(11),
   add1 int(11),
   add2 int(11),
   add3 int(11),
   add4 int(11)
);