View file bd.sql

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(32) NOT NULL,
  `password` varchar(32)  NOT NULL,
  `date_reg` int(11) NOT NULL,
  `date_last_entry` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `user` (`id`, `login`, `password`, `date_reg`, `date_last_entry`) VALUES
(1, 'Admin', '9278c2912eb1a3b50c7c72f96f3a8925', 0, 1334681352);

CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `note` (
  `id` int(11) NOT NULL auto_increment,
  `id_cat` int(11) NOT NULL,
  `title` text NOT NULL,
  `note` text NOT NULL,
  `look` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `comment` (
  `id` int(11) NOT NULL auto_increment,
  `id_note` int(11) NOT NULL,
  `name` text NOT NULL,
  `comment` text NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `system` (
  `id` int(11) NOT NULL auto_increment,
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `copy` text NOT NULL,
  `title` text NOT NULL,
  `icq` text NOT NULL,
  `mail` text NOT NULL,
  `ads_head` text NOT NULL,
  `ads_foot` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `system` (`id`, `keywords`, `description`, `copy`, `title`, `icq`, `mail`, `ads_head`, `ads_foot`) VALUES
(1, 'Ключевые слова', 'Описание сайта', 'RonsoN 2012г.', 'Блог)', '7-191-321', '[email protected]', '[url=http://wapexpert.ru/]WapExpert.Ru[/url]', '[url=http://wapexpert.ru/]WapExpert.Ru[/url]');