-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- : localhost
--  :  30 2007 ., 22:07
--  : 4.1.16
--  PHP: 4.4.4
-- 
-- : `board`
-- 

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

-- 
--   `admin`
-- 

CREATE TABLE `admin` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

-- 
--    `admin`
-- 

INSERT INTO `admin` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3');

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

-- 
--   `board`
-- 

CREATE TABLE `board` (
  `id` int(11) NOT NULL auto_increment,
  `id_category` int(11) NOT NULL default '0',
  `autor` varchar(32) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `email` varchar(32) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `hits` int(11) NOT NULL default '0',
  `type` enum('S','P') NOT NULL default 'P',
  `old_mess` enum('new','old') NOT NULL default 'new',
  `checkbox_top` int(1) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `time_delete` enum('7','14','30','60','90','180','365') NOT NULL default '30',
  `last_edit` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 CHECKSUM=1 AUTO_INCREMENT=2 ;

-- 
--    `board`
-- 

INSERT INTO `board` VALUES (1, 12, 'Joker', ' Php ', 'proekt@rbcmail.ru', '', '', ' Php :   ;<br />\r\n  ', 12, 'P', 'old', 1, 1188496721, '365', '2007-08-30 22:06:13');

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

-- 
--   `board_cat`
-- 

CREATE TABLE `board_cat` (
  `id` int(11) NOT NULL auto_increment,
  `root_category` int(11) NOT NULL default '0',
  `name_cat` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `img` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13 ;

-- 
--    `board_cat`
-- 

INSERT INTO `board_cat` VALUES (1, 0, '-, -, -', ', , , . , , ...', 'avto.gif');
INSERT INTO `board_cat` VALUES (2, 0, '', ', , , . , , ...', 'interer.gif');
INSERT INTO `board_cat` VALUES (3, 0, '', ', , , . , ,  ...', 'nedvijimost.gif');
INSERT INTO `board_cat` VALUES (4, 0, '  ', '  .   .    ...', 'tehnika.gif');
INSERT INTO `board_cat` VALUES (5, 0, '  ', ', . .    ...', 'krasota.gif');
INSERT INTO `board_cat` VALUES (6, 0, '  ', ' , , .   ...', 'biznes.gif');
INSERT INTO `board_cat` VALUES (7, 0, '  ', '. . , , , . , , . ...', 'dosug.gif');
INSERT INTO `board_cat` VALUES (8, 0, '  ', '   , , ,   ...', 'pets.gif');
INSERT INTO `board_cat` VALUES (9, 0, '', ' . .   ...', 'rabota.gif');
INSERT INTO `board_cat` VALUES (10, 0, '  ', ', , .   ...', 'nauka.gif');
INSERT INTO `board_cat` VALUES (11, 0, '  ', '  . , , ...', 'stroitelstvo.gif');
INSERT INTO `board_cat` VALUES (12, 0, '   ', '. .   . . ,     ...', 'other.gif');
