Воть эти запросы мне надо выполнить:
1) Выполнить sql запрос
1.1)
ALTER TABLE `12__files_categories` ADD `cimg` VARCHAR( 100 ) NOT NULL AFTER `cdescription`;
1.2)
ALTER TABLE `12__files` CHANGE `email` `license` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `12__files` ADD `os` VARCHAR( 100 ) NOT NULL AFTER `license`;
ALTER TABLE `12__files` ADD `lang` INT ( 1 ) NOT NULL AFTER `os`;
1.3)
CREATE TABLE `12__media` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`url` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`size` varchar(50) NOT NULL default '0',
`roles` varchar(255) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`album` varchar(100) NOT NULL default '',
`year` int(11) NOT NULL default '0',
`lang` varchar(100) NOT NULL default '',
`format` varchar(100) NOT NULL default '',
`quality` varchar(100) NOT NULL default '',
`links` text NOT NULL,
`time` varchar(100) NOT NULL default '',
`director` varchar(100) NOT NULL default '',
`ip_sender` varchar(60) default NULL,
`votes` int(11) NOT NULL default '0',
`totalvotes` int(11) NOT NULL default '0',
`totalcomments` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__media_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`cimg` varchar(100) NOT NULL default '',
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__media_poolchec` (
`lid` int(11) NOT NULL default '0',
`time` varchar(14) NOT NULL default '',
`host_addr` varchar(48) NOT NULL default '',
PRIMARY KEY (`time`)
) TYPE=MyISAM;
1.4)
CREATE TABLE `12__games` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`url` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`size` varchar(50) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`year` int(11) NOT NULL default '0',
`lang` varchar(100) NOT NULL default '',
`format` varchar(100) NOT NULL default '',
`links` text NOT NULL,
`director` varchar(100) NOT NULL default '',
`ip_sender` varchar(60) default NULL,
`votes` int(11) NOT NULL default '0',
`totalvotes` int(11) NOT NULL default '0',
`totalcomments` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__games_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`cimg` varchar(100) NOT NULL default '',
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__games_poolchec` (
`lid` int(11) NOT NULL default '0',
`time` varchar(14) NOT NULL default '',
`host_addr` varchar(48) NOT NULL default '',
PRIMARY KEY (`time`)
) TYPE=MyISAM;
1.5)
CREATE TABLE `12__links` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`url` varchar(100) NOT NULL default '',
`img` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`name` varchar(100) NOT NULL default '',
`ip_sender` varchar(60) default NULL,
`votes` int(11) NOT NULL default '0',
`totalvotes` int(11) NOT NULL default '0',
`totalcomments` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__links_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__links_poolchec` (
`lid` int(11) NOT NULL default '0',
`time` varchar(14) NOT NULL default '',
`host_addr` varchar(48) NOT NULL default '',
KEY `time` (`time`)
) TYPE=MyISAM;
1.6)
Выполнить sql запрос из папки SQL/Album.sql
1.7)
ALTER TABLE `12__faqanswer` ADD `name` VARCHAR( 100 ) NOT NULL AFTER `answer`;
ALTER TABLE `12__faqanswer` ADD `urg` VARCHAR( 100 ) NOT NULL AFTER `name`;
ALTER TABLE `12__faqanswer` ADD `totalcomments` int(11) NOT NULL AFTER `urg`;
ALTER TABLE `12__faqanswer` ADD `hits` int(11) NOT NULL AFTER `totalcomments`;
ALTER TABLE `12__faqanswer` ADD `votes` int(11) NOT NULL AFTER `hits`;
ALTER TABLE `12__faqanswer` ADD `totalvotes` int(11) NOT NULL AFTER `votes`;
ALTER TABLE `12__faqanswer` ADD `date` datetime default NULL AFTER `totalvotes`;
CREATE TABLE `12__faq_poolchec` (
`lid` int(11) NOT NULL default '0',
`time` varchar(14) NOT NULL default '',
`host_addr` varchar(48) NOT NULL default '',
KEY `time` (`time`)
) TYPE=MyISAM;
1.

ALTER TABLE `12__files` ADD `crack` VARCHAR( 100 ) NOT NULL AFTER `url`;
ALTER TABLE `12__files` ADD `rus` VARCHAR( 100 ) NOT NULL AFTER `crack`;
ALTER TABLE `12__files` ADD `newsid` int(11) NOT NULL AFTER `status`;
1.9)
ALTER TABLE `12__media` ADD `newsid` int(11) NOT NULL AFTER `status`;
2.0)
ALTER TABLE `12__games` ADD `newsid` int(11) NOT NULL AFTER `status`;
2.1)
CREATE TABLE `12__book` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`description` text NOT NULL,
`url` varchar(100) NOT NULL default '',
`img` varchar(100) NOT NULL default '',
`date` datetime default NULL,
`filesize` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`izdatel` varchar(100) NOT NULL default '',
`year` varchar(100) NOT NULL default '',
`avtor` varchar(200) NOT NULL default '',
`ip_sender` varchar(60) default NULL,
`votes` int(11) NOT NULL default '0',
`totalvotes` int(11) NOT NULL default '0',
`totalcomments` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
`newsid` int(11) NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
CREATE TABLE `12__book_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`cimg` varchar(100) NOT NULL default '',
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `title` (`title`)
) TYPE=MyISAM;
2.2)
ALTER TABLE `12__pages` CHANGE `pid` `lid` INT( 11 ) NOT NULL AUTO_INCREMENT
ALTER TABLE `12__pages` ADD `name` VARCHAR( 100 ) NOT NULL AFTER `date`;
ALTER TABLE `12__pages` ADD `totalcomments` int(11) NOT NULL AFTER `name`;
ALTER TABLE `12__pages` CHANGE `counter` `hits` int(11) NOT NULL;
ALTER TABLE `12__pages` ADD `votes` int(11) NOT NULL AFTER `totalcomments`;
ALTER TABLE `12__pages` ADD `totalvotes` int(11) NOT NULL AFTER `votes`;
2.3)
ALTER TABLE `12__stories` CHANGE `sid` `lid` INT( 11 ) NOT NULL AUTO_INCREMENT
ALTER TABLE `12__faqanswer` CHANGE `id` `lid` INT( 11 ) NOT NULL AUTO_INCREMENT
ALTER TABLE `12__stories` CHANGE `score` `totalvotes` int(10) NOT NULL;
ALTER TABLE `12__stories` CHANGE `ratings` `votes` int(10) NOT NULL;
2.4)
DROP TABLE IF EXISTS `12__media_poolchec`;
DROP TABLE IF EXISTS `12__links_poolchec`;
DROP TABLE IF EXISTS `12__games_poolchec`;
DROP TABLE IF EXISTS `12__files_poolchec`;
DROP TABLE IF EXISTS `12__faq_poolchec`;