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');