CREATE TABLE `lessons` (
`id` int(4) NOT NULL auto_increment,
`name` text NOT NULL,
`author` varchar(255) NOT NULL,
`lesson` text NOT NULL,
`views` text NOT NULL,
`date` varchar(255) NOT NULL,
`cat` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `cats` (
`id` int(4) NOT NULL auto_increment,
`value` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
INSERT INTO `cats` VALUES (1, 'PHP & MySQL');
INSERT INTO `cats` VALUES (2, ' MySQL');
INSERT INTO `cats` VALUES (3, 'HTML');
INSERT INTO `cats` VALUES (4, 'CSS');
INSERT INTO `cats` VALUES (5, 'JavaScript');
INSERT INTO `cats` VALUES (6, 'phpBB Tricks');
INSERT INTO `cats` VALUES (7, 'IPB Tricks');
INSERT INTO `cats` VALUES (8, 'Codes');
INSERT INTO `cats` VALUES (9, 'FLASH & AS');
INSERT INTO `cats` VALUES (10, 'Photoshop');
INSERT INTO `cats` VALUES (11, 'Windows');
INSERT INTO `cats` VALUES (12, 'Linux');
INSERT INTO `cats` VALUES (13, 'Outher');
CREATE TABLE `users` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`skype` varchar(255) NOT NULL,
`rank` varchar(255) NOT NULL default 'member',
`avatar` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `banners` (
`id` int(4) NOT NULL auto_increment,
`img` text NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `pm` (
`id` int(4) NOT NULL auto_increment,
`user` varchar(255) NOT NULL,
`author` varchar(255) NOT NULL,
`title` text NOT NULL,
`post` text NOT NULL,
`date` varchar(255) NOT NULL,
`procheteno` varchar(255) NOT NULL default 'ne',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE TABLE `comments` (
`id` int(4) NOT NULL auto_increment,
`uid` text NOT NULL,
`author` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
`comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
