--
-- Table structure for table `kas_anketa_junior`
--

CREATE TABLE IF NOT EXISTS `kas_anketa_junior` (
  `id_anketa_junior` int(11) NOT NULL AUTO_INCREMENT,
  `fio` text NOT NULL,
  `hday` text NOT NULL,
  `class` text NOT NULL,
  `addres` text NOT NULL,
  `h_phone` text NOT NULL,
  `m_phone` varchar(12) NOT NULL,
  `m_phone_rod` varchar(12) NOT NULL,
  `ucheba` text NOT NULL,
  `school` text NOT NULL,
  `email` text NOT NULL,
  `anketa` text NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id_anketa_junior`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;


--
-- Table structure for table `kas_departament`
--

CREATE TABLE IF NOT EXISTS `kas_departament` (
  `id_departament` int(11) NOT NULL AUTO_INCREMENT,
  `departament` text NOT NULL,
  PRIMARY KEY (`id_departament`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `kas_departament`
--

INSERT INTO `kas_departament` (`id_departament`, `departament`) VALUES
(1, 'Юбилейная 40, гостиница ВЕГА'),
(2, 'Татищева 6, 19 квартал'),
(3, 'Комсомольский р-н, Ярославская 9');

-- --------------------------------------------------------

--
-- Table structure for table `kas_reklama`
--

CREATE TABLE IF NOT EXISTS `kas_reklama` (
  `id_reklama` int(11) NOT NULL AUTO_INCREMENT,
  `reklama` text NOT NULL,
  PRIMARY KEY (`id_reklama`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `kas_reklama`
--

INSERT INTO `kas_reklama` (`id_reklama`, `reklama`) VALUES
(1, 'Газеты'),
(2, 'Журналы'),
(3, 'Наружняя реклама'),
(4, 'Радио/телевидение'),
(5, 'Интернет'),
(6, 'Рекомендации знакомых');

-- --------------------------------------------------------

--
-- Table structure for table `kas_reklama_data`
--

CREATE TABLE IF NOT EXISTS `kas_reklama_data` (
  `id_reklama_data` int(11) NOT NULL AUTO_INCREMENT,
  `reklama` int(1) NOT NULL,
  `id_junior` int(11) NOT NULL,
  `id_big` int(11) NOT NULL,
  PRIMARY KEY (`id_reklama_data`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `kas_reklama_data`
--

INSERT INTO `kas_reklama_data` (`id_reklama_data`, `reklama`, `id_junior`, `id_big`) VALUES
(1, 1, 1, 0),
(2, 5, 1, 0),
(3, 3, 2, 0),
(4, 4, 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `kas_week`
--

CREATE TABLE IF NOT EXISTS `kas_week` (
  `id_week` int(11) NOT NULL AUTO_INCREMENT,
  `week_small` text NOT NULL,
  `week_big` text NOT NULL,
  PRIMARY KEY (`id_week`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `kas_week`
--

INSERT INTO `kas_week` (`id_week`, `week_small`, `week_big`) VALUES
(1, 'Пн.', 'Понедельник'),
(2, 'Вт.', 'Вторник'),
(3, 'Ср.', 'Среда'),
(4, 'Чт.', 'Четверг'),
(5, 'Пт.', 'Пятница'),
(6, 'Сб.', 'Суббота'),
(7, 'Вс.', 'Воскресенье');

-- --------------------------------------------------------

--
-- Table structure for table `kas_week_data`
--

CREATE TABLE IF NOT EXISTS `kas_week_data` (
  `id_week_data` int(11) NOT NULL AUTO_INCREMENT,
  `week` int(1) NOT NULL,
  `id_junior` int(11) NOT NULL,
  `id_big` int(11) NOT NULL,
  PRIMARY KEY (`id_week_data`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `kas_week_data`
--

INSERT INTO `kas_week_data` (`id_week_data`, `week`, `id_junior`, `id_big`) VALUES
(1, 1, 1, 0),
(2, 3, 1, 0),
(3, 5, 1, 0),
(4, 2, 2, 0),
(5, 3, 2, 0),
(6, 4, 2, 0);