Changeset 333

Timestamp:

01/28/11 13:15:35 (1 year ago)

Author:

Nafania

Message:

--

Files:

• pic/blank.gif (added)
• sql.sql (modified) (17 diffs)

sql.sql

@@ -1 +1 @@
--- phpMyAdmin SQL Dump
-2.3
+3.7
--- http://www.phpmyadmin.net
---
--- Хост: localhost
-Июн 22 2010 г., 17:41
+Янв 28 2011 г., 14:47
--- Версия сервера: 5.1.40
-2.12
+3.3
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
@@ -17 +17 @@
-
---
-svn
+test
---
-
@@ -101 +101 @@
-  `chat_user_ip` varchar(16) NOT NULL DEFAULT '',
-  PRIMARY KEY (`chat_msg_id`),
-
-
+
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-
@@ -210 +209 @@
-INSERT INTO `config` (`name`, `value`, `is_dynamic`) VALUES
-('siteonline', '1', 0),
-'1268666465'
+UNIX_TIMESTAMP(NOW())
-('sitename', '', 0),
-77214019
+96214237
-('sitemail', '', 0),
-
+00
-('announce_interval', '1800', 0),
-('min_announce_interval', '1740', 0),
@@ -275 +274 @@
-('server_port', '', 0),
-('script_path', '', 0),
-16
+24
-('default_lang', 'english', 0),
-('max_login_attempts', '5', 0),
@@ -283 +282 @@
-('merge_flood_interval', '5', 0),
-('search_flood_interval', '0', 0),
-7454c7512ffc7cfd8eb3d5c2fd56efb2
+8fa36961e6c15829e3cbda4392c9a836
-('search_min_chars', '3', 0),
-('inactive_users_del_days', '0', 0),
@@ -358 +357 @@
-('autoclean_interval_tidy_cache', '10', 0),
-('autoclean_last_run_sync_torrents_info', '1277214019', 1),
-77214019
-77214019
-77214019
-77214019
-77214019
-77214019
+96214237
+96214237
+96214237
+96214237
+96214237
+96214237
-('autoclean_last_run_receive_invites', '0', 1),
-77214019
-77214019
+96214237
+96214237
-('autoclean_interval_promote_demote_users', '1440', 0),
-77214019
+96214237
-('user_limit_ary_allow_download', 'a:10:{s:1:"W";i:1;s:1:"D";i:1;i:0;i:0;i:1;i:1;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:1;i:7;i:1;}', 0),
-('min_seeders_for_sos_button', '3', 0),
@@ -375 +374 @@
-('site_keywords', '', 0),
-('autoclean_interval_delete_old_sessions', '10', 0),
-77214019
+96214237
-('cleanup_lock', '0', 1),
-('offline_text', '', 0),
@@ -388 +387 @@
-('load_anon_lastread', '1', 0),
-('load_db_track', '0', 0),
+('anonymous_announce', '1', 0),
-('smtp_auth_method', '', 0);
-
@@ -1287 +1287 @@
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Дамп данных таблицы `sessions`
---
-
-
--- --------------------------------------------------------
-
@@ -1306 +1301 @@
-  PRIMARY KEY (`key_id`,`user_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
---
--- Дамп данных таблицы `sessions_keys`
---
-
-
--- --------------------------------------------------------
@@ -1613 +1603 @@
-  `tag_for_id` int(10) NOT NULL,
-  `tag_count` int(10) NOT NULL DEFAULT '0',
+  `tag_cat_id` int(10) NOT NULL DEFAULT '0',
-  KEY `tag_type` (`tag_type`),
-  KEY `tag_for_id` (`tag_for_id`)
@@ -1765 +1756 @@
-  `visible` tinyint(1) DEFAULT '0',
-  `disable_comments` tinyint(1) DEFAULT '0',
-  `ballance` bigint(20) DEFAULT '0',
-  `flags` tinyint(1) DEFAULT '0',
-  `moderated` tinyint(1) DEFAULT '0',
@@ -1885 +1875 @@
-  `user_posts` mediumint(8) unsigned DEFAULT '0',
-  `user_lastvisit` int(11) DEFAULT '0',
-  `notify_forum` tinyint(1) DEFAULT '1',
-  `user_sig` text,
-  `user_style` tinyint(3) DEFAULT '0',
@@ -1893 +1882 @@
-  `user_rank_id` int(10) DEFAULT '0',
-  `user_lastmark` int(11) DEFAULT '0',
+  `user_bans` varchar(29) NOT NULL DEFAULT '0:0:0:0:0:0:0:0:0:0:0:0:0:0:0',
+  `user_torrents_uploaded` int(10) NOT NULL DEFAULT '0',
+  `user_requests_created` int(10) NOT NULL DEFAULT '0',
+  `user_offers_created` int(10) NOT NULL DEFAULT '0',
+  `user_requests_filled` int(10) NOT NULL DEFAULT '0',
+  `user_offers_filled` int(10) NOT NULL DEFAULT '0',
-  PRIMARY KEY (`uid`),
-  UNIQUE KEY `torrent_pass` (`torrent_pass`),
@@ -1910 +1905 @@
---
-
-notify_forum`, `user_sig`, `user_style`, `can_leech`, `torrents_limit`, `user_unread_pms`, `user_rank_id`, `user_lastmark
-0.00, 0, 0, 0, 0, 0, 65536, 65536, '', '', '', '', '', 1, 0, '0000-00-00', 1, 'russian', 3600000, 0, 0, 943909200, '0', 0, 0, 0, 1, '', 1
-1268666466, '', 3, 1, '127.0.0.1', 7, '', 0, 0, '', 3, '[forum]', '', 1, 1, 0, 0, 0, 60, 1, 1, '57154e78ba0de787487576ae87207371', 3.00, 1, 0, 0, 0, 0, 10485760, 10485760, '', '', '', '', '', 1, 0, '0000-00-00', 1, 'english', 0, 0, 0, 1277214025, 'login.php', 1, 0, 1268666598, 1, '', 1
+user_sig`, `user_style`, `can_leech`, `torrents_limit`, `user_unread_pms`, `user_rank_id`, `user_lastmark`, `user_bans`, `user_torrents_uploaded`, `user_requests_created`, `user_offers_created`, `user_requests_filled`, `user_offers_filled
+'0.00', 0, 0, 0, 0, 0, 65536, 65536, '', '', '', '', '', 1, 0, '0000-00-00', 1, 'russian', 3600000, 0, 0, 943909200, '0', 0, 0, 0, '', 1, 0, 0, 0, 0, 0, '0:0:0:0:0:0:0:0:0:0:0:0:0:0:0'
+UNIX_TIMESTAMP(NOW()), '', 3, 1, '127.0.0.1', 7, '', 0, 0, '', 3, '[forum]', '', 1, 1, 0, 0, 0, 60, 1, 1, '57154e78ba0de787487576ae87207371', '3.00', 1, 0, 0, 0, 0, 10485760, 10485760, '', '', '', '', '', 1, 0, '0000-00-00', 1, 'english', 0, 0, 0, 1296214242, 'login.php', 1, 0, 1277214025, '', 1, 0, 0, 0, 0, 0, '0:0:0:0:0:0:0:0:0:0:0:0:0:0:0'
-
--- --------------------------------------------------------
@@ -1997 +1992 @@
---
-
+
+-- --------------------------------------------------------
+
+--
+-- Структура таблицы `xbt_deleted_hashes`
+--
+
+DROP TABLE IF EXISTS `xbt_deleted_hashes`;
+CREATE TABLE IF NOT EXISTS `xbt_deleted_hashes` (
+  `fid` int(10) NOT NULL DEFAULT '0',
+  `info_hash` blob NOT NULL,
+  KEY `fid` (`fid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Дамп данных таблицы `xbt_deleted_hashes`
+--
+