-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- : localhost
--  :  30 2007 ., 21:54
--  : 4.1.16
--  PHP: 4.4.4
-- 
-- : `site`
-- 

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

-- 
--   `admin`
-- 

CREATE TABLE `admin` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `fio` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `default_show_count` int(11) NOT NULL default '100000',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

-- 
--    `admin`
-- 

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

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

-- 
--   `count_view`
-- 

CREATE TABLE `count_view` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;

-- 
--    `count_view`
-- 

INSERT INTO `count_view` VALUES (1, 'all', 10);
INSERT INTO `count_view` VALUES (2, 'stat', 1);

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

-- 
--   `session`
-- 

CREATE TABLE `session` (
  `id_session` tinytext NOT NULL,
  `putdate` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
--    `session`
-- 


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

-- 
--   `sites`
-- 

CREATE TABLE `sites` (
  `id` smallint(6) NOT NULL auto_increment,
  `id_category` smallint(6) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `text` varchar(255) NOT NULL default '',
  `email` varchar(32) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `hits` int(6) NOT NULL default '0',
  `click` int(6) default '0',
  `checkbox_top` int(1) NOT NULL default '0',
  `city` varchar(32) NOT NULL default '',
  `old_mess` enum('new','old') NOT NULL default 'new',
  `time` time NOT NULL default '00:00:00',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=2 ;

-- 
--    `sites`
-- 

INSERT INTO `sites` VALUES (1, 3, 'PHP .    .', 'PHP .   .  .  ...', 'proekt@rbcmail.ru', 'allpublication.ru', 89, 10, 1, '', 'old', '21:01:37', '2007-08-26');

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

-- 
--   `sites_cat`
-- 

CREATE TABLE `sites_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 '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=17 ;

-- 
--    `sites_cat`
-- 

INSERT INTO `sites_cat` VALUES (1, 0, '', ', , , ...');
INSERT INTO `sites_cat` VALUES (2, 0, ', ...', ', ,  , , ...');
INSERT INTO `sites_cat` VALUES (3, 0, '', ', ,  ');
INSERT INTO `sites_cat` VALUES (4, 0, 'Hi-Tech', ', ,  ');
INSERT INTO `sites_cat` VALUES (5, 0, '  ', ', , , , ');
INSERT INTO `sites_cat` VALUES (6, 0, '  ', ' ');
INSERT INTO `sites_cat` VALUES (7, 0, '', ' , ');
INSERT INTO `sites_cat` VALUES (8, 0, '', '  ');
INSERT INTO `sites_cat` VALUES (9, 0, '', '  ');
INSERT INTO `sites_cat` VALUES (10, 0, '', ', , ');
INSERT INTO `sites_cat` VALUES (11, 0, '', ', ...');
INSERT INTO `sites_cat` VALUES (12, 0, '', ', ');
INSERT INTO `sites_cat` VALUES (13, 0, '', ', ');
INSERT INTO `sites_cat` VALUES (14, 0, '  ', '');
INSERT INTO `sites_cat` VALUES (15, 0, '', '  ');
INSERT INTO `sites_cat` VALUES (16, 0, '', '  ');
