DROP TABLE IF EXISTS predb;
CREATE TABLE predb (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
title VARCHAR(255) NOT NULL DEFAULT '',
nfo VARCHAR(255) NULL,
size VARCHAR(50) NULL,
category VARCHAR(255) NULL,
created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Unix time of when the
pre was created, or first noted by the system',
updated TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Unix time of when the
entry was last updated',
source VARCHAR(50) NOT NULL DEFAULT '',
requestid INT(10) UNSIGNED NOT NULL DEFAULT '0',
groups_id INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to groups',
nuked TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'Is this pre nuked? 0 no 2 yes 1 un nuked 3 mod nuked',
nukereason VARCHAR(255) NULL COMMENT 'If this pre is nuked, what is the reason?',
files VARCHAR(50) NULL COMMENT 'How many files does this pre have ?',
filename VARCHAR(255) NOT NULL DEFAULT '',
searched TINYINT(1) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
UNIQUE INDEX ix_predb_title (title),
INDEX ix_predb_nfo (nfo),
INDEX ix_predb_created (created),
INDEX ix_predb_source (source),
INDEX ix_predb_requestid (requestid, groups_id),
INDEX ix_predb_filename (filename),
INDEX ix_predb_searched (searched),
FULLTEXT INDEX ix_predb_filename_ft (filename)
)
ENGINE = MYISAM
DEFAULT CHARSET = utf8
COLLATE = utf8_unicode_ci
AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS predb_hashes;
CREATE TABLE predb_hashes (
predb_id INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'id, of the predb entry, this hash belongs to',
hash VARBINARY(20) NOT NULL DEFAULT '',
PRIMARY KEY (hash)
)
ENGINE = MYISAM
DEFAULT CHARSET = utf8mb4
COLLATE = utf8mb4_unicode_ci;
DROP TABLE IF EXISTS predb_imports;
CREATE TABLE predb_imports (
title VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
nfo VARCHAR(255)
COLLATE utf8_unicode_ci DEFAULT NULL,
size VARCHAR(50)
COLLATE utf8_unicode_ci DEFAULT NULL,
category VARCHAR(255)
COLLATE utf8_unicode_ci DEFAULT NULL,
created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated DATETIME NOT NULL DEFAULT 0,
source VARCHAR(50)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
requestid INT(10) UNSIGNED NOT NULL DEFAULT '0',
groups_id INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to groups',
nuked TINYINT(1) NOT NULL DEFAULT '0' COMMENT 'Is this pre nuked? 0 no 2 yes 1 un nuked 3 mod nuked',
nukereason VARCHAR(255)
COLLATE utf8_unicode_ci DEFAULT NULL
COMMENT 'If this pre is nuked, what is the reason?',
files VARCHAR(50)
COLLATE utf8_unicode_ci DEFAULT NULL
COMMENT 'How many files does this pre have ?',
filename VARCHAR(255)
COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
searched TINYINT(1) NOT NULL DEFAULT '0',
groupname VARCHAR(255)
COLLATE utf8_unicode_ci DEFAULT NULL
)
ENGINE =MYISAM
DEFAULT CHARSET =utf8
COLLATE =utf8_unicode_ci;