Dump Islander
Table of Contents
Download
https://the-eye.eu/public/Piracy/PreDBs/Islander/
Database.rar
7,71 GiB (8.283.389.137 bytes)
Scripts.rar
539 KiB (552.135 bytes)
README.txt
BIGGEST PRE-SCENE-DATABASE & SCRIPTS DUMP
Date: 10th October 2014
By: Islander
Hello,
If you have downloaded this release scripts and database and reading this README then you dont have anything better to do in your life.
Dont waste your precious time in torrent sites, drama forums, scene or IRC.
Quit this addictive usless drama e-penies time wasting money spending scene/p2p world.I quit this world around 2011 and started a real life and im soo much happier.
I wanted to release this dump from a long time but didnt get the time to do so. I have tried to share all my scripts and my whole predb wasting a whole day filtering it out and cleaning stuff out.
My windows PC and the HardDisk where this data is stored is almost dead :P. So before i wipe and sell off this windows junk i wanted to share the whole shit.I spent thousands of hours programming and lots of sleepless nights to build these scripts and the fucking huge database which comes to around 16 GB after extracted. So leave credits where its due.
Enjoy the fucking biggest database and scripts dump!!
So the Database And Scripts
1. Database
I collected the DB from 2005 till 2011. It was the biggest database of releases with nfo sfv m3u mp3info videoinfo url fromdata etc at that time (2011).
2. Scripts
I did not get the time to filter all the scene and groups related scripts cause it had too much sensitive data. So i destroyed them. There are lots of repeated stuff. All scripts are bullshit for 2014 but back then it was the top and almost everyone still works completely fine. I was a total n00b to programming back then :P No bots had these kinds of scripts or db back then :)
And before you ask
YOU WONT SEE ME AROUND ANYMORE.
NO YOU CANNOT TALK TO ME ABOUT THIS RELEASE.
NO YOU CANNOT TALK TO ME ABOUT ANYTHING.
NO FOR EVERYTHING.
NO.
Peace and Goodbye forever,
Islander
Summary
Format 1
Split up
473252256 May 26 2013 allpres.sql
254521414 May 25 2013 m3u.sql
5597196125 May 26 2013 nfo.sql
677598656 May 26 2013 sfv.sql
125089285 May 25 2013 url.sql+------------+------------+
| table_name | table_rows |
+------------+------------+
| allpres | 4521495 |
| m3u | 835415 |
| nfo | 2896099 |
| sfv | 1682511 |
| url | 1233797 |
+------------+------------+Other data dump
1338145558 May 27 2013 predb-20thDec2011.sql+------------+------------+
| table_name | table_rows |
+------------+------------+
| allpres | 8079642 |
| delpre | 49 |
| m3u | 4087 |
| nfo | 86180 |
| nicks | 79100 |
| nukes | 1147 |
| sfv | 80731 |
| tracks | 0 |
| unnukes | 150 |
| url | 57 |
+------------+------------+Format 2 (with !from data)
6769636018 Jun 1 2013 scenestuff-01-june-2013-SHUTDOWN.sql+--------------+------------+
| table_name | table_rows |
+--------------+------------+
| allpres | 5259612 |
| dizdb | 12521 |
| frominfodata | 89162 |
| frompredata | 0 |
| fromspamdata | 2178424 |
| ftprls | 236429 |
| ftpsubs | 6752 |
| m3usdb | 341609 |
| mp3info | 301925 |
| newpre | 5311136 |
| newprecrap | 49372 |
| nfosdb | 1055739 |
| predb | 2664128 |
| predbbig | 4147389 |
| prerls | 360160 |
| prerlsdb | 1625013 |
| sfvsdb | 768545 |
| tracers | 36943 |
| tracersnew | 348102 |
| videoinfo | 321291 |
+--------------+------------+Format 3 (external)
Files:
478511245 Jul 9 2013 supertorrents-shutdown.predb.sql
10032051 May 26 2013 tempnuke.sqlThe first one is the SuperTorrents data dump. (size matches)
+------------+------------+
| table_name | table_rows |
+------------+------------+
| predb | 4825245 |
| tempnuke | 83662 |
+------------+------------+Analysis
Schema
Format 1 - Split up
allpres
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| rel_id | int(32) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | | |
| rel_group | varchar(64) | NO | MUL | | |
| rel_section | varchar(64) | NO | MUL | | |
| nuked | tinyint(4) | NO | MUL | 0 | |
| deleted | int(1) unsigned | NO | MUL | 0 | |
| rel_time | int(10) unsigned | NO | MUL | 0 | |
| rel_files | int(20) | NO | MUL | 0 | |
| rel_size | decimal(10,1) | NO | | 0.0 | |
| rel_genre | varchar(48) | NO | | | |
+-------------+------------------+------+-----+---------+----------------+m3u
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_m3u | longblob | NO | | NULL | |
| rel_filename | varchar(100) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+nfo
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_nfo | longblob | NO | | NULL | |
| rel_filename | varchar(100) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+sfv
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_sfv | longblob | NO | | NULL | |
| rel_filename | varchar(100) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+url
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_url | varchar(150) | NO | | NULL | |
+----------+------------------+------+-----+---------+----------------+Format 1 - Other
allpres
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| rel_id | int(32) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | MUL | | |
| rel_group | varchar(64) | NO | MUL | | |
| rel_section | varchar(64) | NO | MUL | | |
| nuked | tinyint(4) | NO | MUL | 0 | |
| deleted | int(1) unsigned | NO | MUL | 0 | |
| rel_time | int(10) unsigned | NO | MUL | 0 | |
| rel_files | int(20) | NO | MUL | 0 | |
| rel_size | decimal(10,1) | NO | | 0.0 | |
| rel_genre | varchar(48) | NO | | | |
+-------------+------------------+------+-----+---------+----------------+delpre
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| d_id | int(20) unsigned | NO | PRI | NULL | auto_increment |
| rel_id | int(32) unsigned | NO | MUL | 0 | |
| d_reason | char(255) | NO | | NULL | |
| d_time | int(10) unsigned | NO | | 0 | |
| readded | char(1) | NO | | N | |
+----------+------------------+------+-----+---------+----------------+m3u
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_m3u | longblob | NO | | NULL | |
| rel_filename | varchar(100) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+nfo
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_nfo | longblob | NO | | NULL | |
| rel_filename | varchar(100) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+nicks
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| nk_id | int(20) unsigned | NO | PRI | NULL | auto_increment |
| rel_id | int(32) unsigned | NO | MUL | NULL | |
| a_type | char(6) | NO | MUL | NULL | |
| a_nick | varchar(32) | NO | MUL | NULL | |
| a_chan | varchar(32) | NO | MUL | NULL | |
| a_network | varchar(32) | NO | MUL | NULL | |
| a_source | text | NO | | NULL | |
| a_searchterm | text | NO | | NULL | |
| a_fields | text | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+nukes
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| n_id | int(20) unsigned | NO | PRI | NULL | auto_increment |
| rel_id | int(32) unsigned | NO | MUL | 0 | |
| n_reason | char(255) | NO | | | |
| n_time | int(10) unsigned | NO | | 0 | |
| unnuked | char(1) | NO | MUL | N | |
+----------+------------------+------+-----+---------+----------------+sfv
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | NULL | |
| rel_sfv | longblob | NO | | NULL | |
| rel_filename | varchar(100) | NO | | NULL | |
+--------------+------------------+------+-----+---------+----------------+tracks
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | | NULL | |
| rel_file | varchar(255) | NO | | NULL | |
| rel_size | int(10) unsigned | NO | | NULL | |
+----------+------------------+------+-----+---------+----------------+unnukes
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| un_id | int(20) | NO | PRI | NULL | auto_increment |
| n_id | int(20) | NO | MUL | 0 | |
| rel_id | int(32) unsigned | NO | MUL | 0 | |
| un_reason | char(255) | NO | | | |
| un_time | int(10) unsigned | NO | | 0 | |
+-----------+------------------+------+-----+---------+----------------+url
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | | NULL | |
| rel_url | varchar(255) | NO | | NULL | |
+----------+------------------+------+-----+---------+----------------+Format 2
allpres
+-------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------------+------+-----+---------+----------------+
| rel_id | int(32) unsigned | NO | PRI | NULL | auto_increment |
| rel_name | varchar(255) | NO | UNI | | |
| rel_group | varchar(64) | NO | MUL | | |
| rel_section | varchar(64) | NO | MUL | | |
| nuked | tinyint(4) | NO | MUL | 0 | |
| deleted | int(1) unsigned | NO | MUL | 0 | |
| rel_time | int(10) unsigned | NO | MUL | 0 | |
| rel_files | int(20) | NO | MUL | 0 | |
| rel_size | decimal(10,1) | NO | | 0.0 | |
| rel_genre | varchar(48) | NO | | | |
+-------------+------------------+------+-----+---------+----------------+dizdb
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| grp | varchar(100) | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| data | text | NO | | NULL | |
| filename | varchar(100) | NO | | NULL | |
| size | int(8) | YES | | 0 | |
+----------+------------------+------+-----+---------+----------------+frominfodata
+---------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| infoid | int(11) unsigned | NO | MUL | NULL | |
| type | varchar(50) | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| nick | varchar(32) | NO | MUL | NULL | |
| chan | varchar(30) | NO | | NULL | |
| network | varchar(30) | NO | MUL | NULL | |
+---------+------------------+------+-----+---------+----------------+frompredata
+---------+-------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| preid | int(11) unsigned | NO | MUL | NULL | |
| type | enum('addpre','info','genre') | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| nick | varchar(32) | NO | MUL | NULL | |
| chan | varchar(30) | NO | | NULL | |
| network | varchar(30) | NO | MUL | NULL | |
+---------+-------------------------------+------+-----+---------+----------------+fromspamdata
+---------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| spamid | int(11) unsigned | NO | MUL | NULL | |
| type | varchar(25) | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| nick | varchar(32) | NO | MUL | NULL | |
| chan | varchar(30) | NO | | NULL | |
| network | varchar(30) | NO | MUL | NULL | |
+---------+------------------+------+-----+---------+----------------+ftprls
+-------------+-------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(200) | NO | UNI | NULL | |
| category | varchar(25) | NO | MUL | NULL | |
| grp | varchar(50) | NO | MUL | NULL | |
| unixtime | int(11) | NO | | 0 | |
| nfofilename | varchar(200) | YES | | NULL | |
| subs | enum('yes','no','done') | NO | MUL | no | |
| sample | enum('yes','no') | NO | MUL | no | |
| complete | enum('yes','no') | NO | MUL | no | |
| genre | varchar(200) | YES | MUL | NULL | |
+-------------+-------------------------+------+-----+---------+----------------+ftpsubs
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(200) | NO | MUL | NULL | |
| subdir | varchar(100) | NO | MUL | NULL | |
| unixtime | int(11) unsigned | NO | | 0 | |
| preid | int(11) unsigned | NO | | 0 | |
| complete | enum('yes','no') | NO | MUL | no | |
+----------+------------------+------+-----+---------+----------------+m3usdb
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| grp | varchar(100) | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| data | text | NO | | NULL | |
| filename | varchar(100) | NO | | NULL | |
| size | int(8) | YES | | 0 | |
+----------+------------------+------+-----+---------+----------------+mp3info
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| genre | varchar(255) | NO | | NULL | |
| year | varchar(255) | NO | | NULL | |
| hertz | varchar(255) | NO | | NULL | |
| type | varchar(255) | NO | | NULL | |
| bitrate | varchar(255) | NO | | NULL | |
| bittype | varchar(255) | NO | | NULL | |
| unixtime | decimal(10,0) | NO | | NULL | |
| addedon | datetime | NO | | NULL | |
| fromnet | varchar(100) | NO | | NULL | |
+----------+------------------+------+-----+---------+----------------+newpre
+------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| section | varchar(25) | NO | MUL | NULL | |
| unixtime | decimal(11,0) | NO | | NULL | |
| files | decimal(10,2) | NO | | 0.00 | |
| size | decimal(10,2) | NO | | 0.00 | |
| genre | varchar(255) | YES | | NULL | |
| grp | varchar(35) | NO | MUL | NULL | |
| imdb | varchar(100) | YES | | NULL | |
| url | varchar(255) | YES | | NULL | |
| nukestatus | varchar(10) | YES | | NULL | |
| nukereason | varchar(150) | YES | | NULL | |
| nukenet | varchar(50) | YES | | NULL | |
| delstatus | varchar(10) | YES | | NULL | |
| delreason | varchar(150) | YES | | NULL | |
| delnet | varchar(50) | YES | | NULL | |
| frompre | varchar(100) | NO | | NULL | |
| frominfo | varchar(100) | YES | | NULL | |
| fromgenre | varchar(100) | YES | | NULL | |
| fromimdb | varchar(100) | YES | | NULL | |
| fromurl | varchar(100) | YES | | NULL | |
| fromnuke | varchar(100) | YES | | NULL | |
| fromdel | varchar(100) | YES | | NULL | |
+------------+---------------+------+-----+---------+----------------+newprecrap
+------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| section | varchar(25) | NO | MUL | NULL | |
| unixtime | decimal(11,0) | NO | | NULL | |
| files | decimal(10,2) | NO | | 0.00 | |
| size | decimal(10,2) | NO | | 0.00 | |
| genre | varchar(255) | YES | | NULL | |
| grp | varchar(35) | NO | MUL | NULL | |
| imdb | varchar(100) | YES | | NULL | |
| url | varchar(255) | YES | | NULL | |
| nukestatus | varchar(10) | YES | | NULL | |
| nukereason | varchar(150) | YES | | NULL | |
| nukenet | varchar(50) | YES | | NULL | |
| delstatus | varchar(10) | YES | | NULL | |
| delreason | varchar(150) | YES | | NULL | |
| delnet | varchar(50) | YES | | NULL | |
| frompre | varchar(100) | NO | | NULL | |
| frominfo | varchar(100) | YES | | NULL | |
| fromgenre | varchar(100) | YES | | NULL | |
| fromimdb | varchar(100) | YES | | NULL | |
| fromurl | varchar(100) | YES | | NULL | |
| fromnuke | varchar(100) | YES | | NULL | |
| fromdel | varchar(100) | YES | | NULL | |
+------------+---------------+------+-----+---------+----------------+nfosdb
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| grp | varchar(100) | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| data | text | NO | | NULL | |
| filename | varchar(100) | NO | | NULL | |
| size | int(8) | YES | | 0 | |
+----------+------------------+------+-----+---------+----------------+predb
+------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| section | varchar(20) | NO | | | |
| rlsname | varchar(255) | NO | UNI | | |
| grp | varchar(50) | NO | MUL | | |
| status | decimal(1,0) | NO | | 0 | |
| nukereason | varchar(255) | YES | | NULL | |
| ctime | decimal(10,0) | NO | | 0 | |
| size | int(8) | YES | | NULL | |
| files | int(6) | YES | | NULL | |
+------------+---------------+------+-----+---------+----------------+predbbig
+------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| section | varchar(20) | NO | MUL | | |
| rlsname | varchar(255) | NO | UNI | | |
| grp | varchar(50) | NO | MUL | | |
| status | decimal(1,0) | NO | | 0 | |
| nukereason | varchar(255) | YES | | NULL | |
| ctime | decimal(10,0) | NO | | 0 | |
| size | int(8) | YES | | NULL | |
| files | int(6) | YES | | NULL | |
| genre | varchar(50) | YES | | NULL | |
+------------+---------------+------+-----+---------+----------------+prerls
+-------------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| section | varchar(25) | NO | MUL | NULL | |
| rlstime | decimal(10,0) | NO | | NULL | |
| pretime | datetime | NO | | NULL | |
| nukestatus | varchar(6) | YES | | NULL | |
| nukereason | varchar(255) | YES | | NULL | |
| nukenet | varchar(255) | YES | | NULL | |
| files | int(6) | YES | | NULL | |
| size | int(8) | YES | | NULL | |
| genre | varchar(255) | YES | | NULL | |
| group | varchar(255) | YES | | NULL | |
| delstatus | varchar(255) | YES | | NULL | |
| nfofilename | varchar(255) | YES | | NULL | |
| sfvfilename | varchar(255) | NO | | NULL | |
| m3ufilename | varchar(255) | NO | | NULL | |
+-------------+---------------+------+-----+---------+----------------+prerlsdb
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| section | varchar(25) | NO | MUL | NULL | |
| filtersec | varchar(25) | NO | | NULL | |
| unixtime | decimal(11,0) | NO | | NULL | |
| addedon | decimal(11,0) | NO | | NULL | |
| files | decimal(10,2) | NO | | 0.00 | |
| size | decimal(10,2) | NO | | 0.00 | |
| genre | varchar(255) | YES | | NULL | |
| grp | varchar(35) | NO | | NULL | |
| imdb | varchar(100) | YES | | NULL | |
| url | varchar(255) | YES | | NULL | |
| nukestatus | varchar(10) | YES | | NULL | |
| nukereason | varchar(150) | YES | | NULL | |
| nukenet | varchar(50) | YES | | NULL | |
| delstatus | varchar(10) | YES | | NULL | |
| delreason | varchar(150) | YES | | NULL | |
| delnet | varchar(50) | YES | | NULL | |
| frompre | varchar(100) | NO | | NULL | |
| frominfo | varchar(100) | YES | | NULL | |
| fromgenre | varchar(100) | YES | | NULL | |
| fromimdb | varchar(100) | YES | | NULL | |
| fromurl | varchar(100) | YES | | NULL | |
| fromnuke | varchar(100) | YES | | NULL | |
| fromdel | varchar(100) | YES | | NULL | |
| addold | enum('yes','no') | NO | | no | |
+------------+------------------+------+-----+---------+----------------+sfvsdb
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| grp | varchar(100) | NO | MUL | NULL | |
| time | int(11) | NO | | NULL | |
| data | text | NO | | NULL | |
| filename | varchar(100) | NO | | NULL | |
| size | int(8) | YES | | 0 | |
+----------+------------------+------+-----+---------+----------------+tracers
+---------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| site | longtext | NO | | NULL | |
| rlsname | varchar(255) | NO | MUL | NULL | |
| rlstime | decimal(10,0) | NO | | NULL | |
| pretime | datetime | NO | | NULL | |
+---------+---------------+------+-----+---------+----------------+tracersnew
+----------+---------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | MUL | NULL | |
| site | varchar(255) | NO | | NULL | |
| place | varchar(255) | NO | | NULL | |
| unixtime | decimal(10,0) | NO | | NULL | |
| addedon | datetime | NO | | NULL | |
| category | varchar(255) | NO | | NULL | |
| link | varchar(255) | NO | | NULL | |
| type | varchar(255) | NO | | NULL | |
+----------+---------------+------+-----+---------+----------------+videoinfo
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| rlsname | varchar(255) | NO | UNI | NULL | |
| videocodec | varchar(80) | NO | | NULL | |
| frames | varchar(80) | NO | | NULL | |
| resolution | varchar(80) | NO | | NULL | |
| resnframe | varchar(80) | NO | | NULL | |
| audiocodec | varchar(80) | NO | | NULL | |
| bitrate | varchar(80) | NO | | NULL | |
| hertz | varchar(80) | NO | | NULL | |
| channel | varchar(80) | NO | | NULL | |
| unixtime | decimal(10,0) | NO | | NULL | |
| addedon | datetime | NO | | NULL | |
| fromnet | varchar(100) | NO | | NULL | |
+------------+------------------+------+-----+---------+----------------+Format 3 - SuperTorrents
predb
+-----------+------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------------------+------+-----+---------+-------+
| name | varchar(150) | NO | PRI | NULL | |
| timestamp | int(10) | NO | | NULL | |
| section | varchar(12) | NO | | NULL | |
| files | int(5) | YES | | 0 | |
| size | decimal(10,2) | NO | | 0.00 | |
| genre | varchar(20) | YES | | NULL | |
| nuked | enum('no','nuked','unnuked') | NO | | no | |
| reason | varchar(100) | YES | | NULL | |
| nuketime | int(10) | YES | | 0 | |
+-----------+------------------------------+------+-----+---------+-------+tempnuke
+-----------+------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------------+------+-----+---------+----------------+
| id | int(10) | NO | PRI | NULL | auto_increment |
| timestamp | int(10) | NO | | NULL | |
| name | varchar(255) | NO | | NULL | |
| type | enum('add','mod','un') | NO | | NULL | |
| reason | varchar(255) | NO | | NULL | |
| src | varchar(255) | NO | | - | |
+-----------+------------------------+------+-----+---------+----------------+page revision: 5, last edited: 06 Mar 2024 21:47