Показать сообщение отдельно
Старый 22.03.2010, 18:34   #15
Аватар для NetS
NetS NetS вне форума
Member
Обновились

Цитата:
CREATE TABLE `peers_leechers` (
`uid` int(10) unsigned NOT NULL default '0',
`fid` int(10) unsigned NOT NULL default '0',
`mtime` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `uid_fid` (`uid`,`fid`),
KEY `mtime` (`mtime`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

CREATE TABLE `peers_port` (
`ipa` int(11) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`connectable` tinyint(3) unsigned default NULL,
`mtime` int(11) unsigned NOT NULL default '0',
UNIQUE KEY `ipa_port` (`ipa`,`port`),
KEY `mtime` (`mtime`),
KEY `connectable` (`connectable`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS peers_cache;

CREATE TABLE `peers_cache` (
`n` int(11) unsigned NOT NULL auto_increment,
`pid` binary(4) NOT NULL default '\0\0\0\0',
`uid` int(11) unsigned NOT NULL default '0',
`fid` int(11) unsigned NOT NULL default '0',
`event` enum('','started','stopped','completed') NOT NULL default '',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`left` bigint(20) unsigned NOT NULL default '0',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`bonus` smallint(5) unsigned NOT NULL default '0',
`peer_id` binary(20) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipa` int(11) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`mtime` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`n`)
) ENGINE=MEMORY AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

ALTER TABLE `peers`
DROP COLUMN active,
DROP COLUMN announced,
DROP COLUMN pclass,
DROP COLUMN uploaded,
DROP COLUMN downloaded,
DROP COLUMN upspeed,
DROP COLUMN downspeed,
DROP COLUMN ipa,
DROP COLUMN port,
DROP INDEX fid_uid,
DROP INDEX connectable,
DROP INDEX completed,
DROP INDEX uid;

ALTER TABLE `peers`
ADD UNIQUE KEY `uid_fid` (`uid`,`fid`),
ADD INDEX `fid` (`fid`),
ADD COLUMN `download_user` bigint(20) unsigned NOT NULL default '0',
ADD COLUMN `upload_user` bigint(20) unsigned NOT NULL default '0';
MODIFY `peer_id` binary(8) NOT NULL default '\0\0\0\0\0\0\0\0',
MODIFY `completed` tinyint(4) unsigned NOT NULL default '0',
RENAME peers_archive;

UPDATE `peers_archive` SET `upload_user`=`upload_sum`, `download_user`=`download_sum`;

CREATE TABLE `peers` (
`pid` binary(4) NOT NULL,
`uid` int(11) unsigned NOT NULL,
`fid` int(11) unsigned NOT NULL,
`lastevent` enum('','started','stopped','completed') NOT NULL default '',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`left` bigint(20) unsigned NOT NULL,
`uploaded` bigint(20) unsigned NOT NULL default '0',
`upspeed` bigint(20) unsigned NOT NULL default '0',
`downspeed` bigint(20) unsigned NOT NULL default '0',
`download_sum` bigint(20) unsigned NOT NULL default '0',
`download_user` bigint(20) unsigned NOT NULL default '0',
`upload_sum` bigint(20) unsigned NOT NULL default '0',
`upload_user` bigint(20) unsigned NOT NULL default '0',
`timespent` bigint(20) unsigned NOT NULL,
`peer_id` binary(20) NOT NULL default '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
`ipa` int(11) unsigned NOT NULL,
`port` smallint(5) unsigned NOT NULL default '0',
`mtime` int(11) unsigned NOT NULL,
`flag` tinyint(3) unsigned NOT NULL default '0',
UNIQUE KEY `uid` (`uid`,`pid`),
KEY `mtime` (`mtime`),
KEY `fid` (`fid`),
KEY `flag` (`flag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `attachment`
DROP COLUMN ctime,
DROP COLUMN announce_list,
DROP INDEX ctime,
MODIFY `flags` int(11) unsigned NOT NULL default '0',
MODIFY `mtime` int(11) unsigned NOT NULL default '0',
MODIFY `size` bigint(20) unsigned NOT NULL default '0';

ALTER TABLE `user`
DROP COLUMN leechers,
DROP COLUMN seeders,
DROP COLUMN ctime,
DROP INDEX ctime;

Последний раз редактировалось NetS; 26.03.2010 в 17:31.
Ответить с цитированием