1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
Accouns_deleted
hits
dte
all_info_hash

Artists
image
streamable
last_update
visible

artists_albums
  id
  a_md5
  reach
  last_update
  album_name
  image_large
  image_medium
  image_small

artist_events
  id
  a_md5
  last_update
  title
  description
  link
  pubDate

artists_genres
  a_md5
  genre_md5

artists_similar
  a_md5
  s_md5

artists_torrents
  a_md5
  torrent

bainip
  id
  ip
  whobanned
  bandate
  comment
  host

banned_infohash
  info_hash_base64
  comment
  info_hash_hex

bannedtracker
  hostname
  comment

blog
  id
  blog_data
  blog_title
  added
  username
  updated
  comments
  commentable
  data_md5
  html

blog_comments
  id
  comment
  blog_id
  added
  username
  owner
  ip
  comment_md5
  deleted

calendar
  id
  cal_data
  cal_title
  happening_start
  happening_stop

captcha
  id
  filename
  pass

categories
  category
  catname
  number

cmt_update
  id

comments
  owner
  torrent
  comment
  username
  added
  status
  ip
  comment_md5

dellim
  owner
  cnt
  dte

faketorrents
  info_hash
  name

files_to_remove
  id
  userid
  checked
  ip6
  id
  ip6

 missing
  url_md5
  url
  referer_md5
  referer
  hits

 music_genres
  id
  genre
  genre_md5
  visible

pageviews
  datum
  section
  pageviews

pageviews_cc
  datum
  section
  pageviews

  passwd_tor
  id

private_torrents
  info_hash

reg_bans
  ip
  hits

IP logs

reg_hits
  ip
  dte
  hits

reports
  id
  torrent_id
  torrent_title
  torrent_owner
  torrent_username
  torrent_email
  torrent_ip
  reported_by
  reason
  priority
  checked
  date

rss_user
  user_id
  torrent 
  added

searchTerms
  term
  day
  hits
  added
  search_word

search_stats
  added
  last_active  
  hits
  isporn
  isporn_rateing

searches2
  dte
  hits

series
  id
  s_name
  visable

series_episodes
  id
  season
  series
  s_name
  ep_name
  torrentid
  ep_num

series_seasons
  series
  season
  visable

spamurl
  id
  url
  addedby

tags
  tag
  torrent
  category

top_tracker_peers
  total
  seed
  leech
  dtetme

torrents
  id
  info_hash
  name
  descr
  category
  size
  added
  num_files
  num_comments
  leechers
  seeders
  owner
  username
  status
  last_active
  language
  text_language
  imdb
  flags
  vote_num
  vote_sum
  trackerurl
  been_checked_by
  vote_up
  vote_dn
  tags
  imagetag
  anon
  tfsize
  private

unknown
  url_md5
  url
  referer_md5
  referer
  remote_ip
  hits
  ua

users
  id
  username
  show_porn
  status
  last_login
  language
  authtoken
  num_comments
  num_torrents
  num_logins
  vip_until
  email_enc
  last_pwchange
  password_enc
  ip_enc
  sortorder
  regdate
  allowspam