View file portfolio/db_tables.sql

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(32) NOT NULL,
  `password` varchar(64) NOT NULL,
  `date_reg` int(11) NOT NULL,
  `date_last_entry` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
CREATE TABLE  `news` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL,
  `text` text NOT NULL,
  `date` int(32) NOT NULL,
  `look` int(100) unsigned default '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
CREATE TABLE  `category` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(32) NOT NULL,
  `text` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
CREATE TABLE  `works` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `id_category` int(30) NOT NULL,
  `title` varchar(32) NOT NULL,
  `text` varchar(800) NOT NULL,
  `scr` text NOT NULL,
  `file` text NOT NULL,
  `look` int(100) unsigned default '0',
  `cost` text NOT NULL,
  `pre` text NOT NULL,
  `status` varchar(1) NOT NULL,
  `date` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
CREATE TABLE  `reviews` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `text` varchar(300) NOT NULL,
  `status` text NOT NULL,
  `browser` text NOT NULL,
  `ip` text NOT NULL,
  `date` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
CREATE TABLE IF NOT EXISTS `online` (
`ip` varchar(32) NOT NULL,
`browser`varchar(32) NOT NULL,
`date` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
CREATE TABLE  `system` (
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `title` text NOT NULL,
  `status`varchar(1) NOT NULL,
  `theme` text NOT NULL,
  `objects` varchar(2) NOT NULL,
  `name` varchar(32) NOT NULL,
  `surename` varchar(32) NOT NULL,
  `country` varchar(32) NOT NULL,
  `birthday` varchar(32) NOT NULL,
  `work` varchar(500) NOT NULL,
  `interests` varchar(500) NOT NULL,
  `contacts` varchar(500) NOT NULL,
  `icq` varchar(9) NOT NULL,
  `aboute` varchar(500) NOT NULL,
  `email` varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
INSERT INTO `system` (`objects`) VALUES('2');